class Scores2012(BatchFileProcessor):
def __init__(self,pattern,audit_file):
super(Scores2012,self).__init__(pattern,SCORES_SUFFIX)
self.dec = XLConverter(None,None,NO_CONFIG)
self.audit_mapper = AuditScoreMapper2012(audit_file,AUDIT_SHEET)
self.audit_mapper.process()
def transform(self,inbook,outbook):
(r,c) = self.dec.decode_single_cell('B1')
facility_id = inbook.sheet_by_name(FACILITY_PROFILE).cell_value(rowx=r,colx=c)
(r,c) = self.dec.decode_single_cell('B5')
audit_date = inbook.sheet_by_name(AUDIT_GENERAL_INFO).cell_value(rowx=r,colx=c)
out_sheet = outbook.add_sheet(SCORES)
preferred_list = self.audit_mapper.get_preferred_cols(facility_id,audit_date)
if( preferred_list):
for r,row in enumerate(preferred_list):
for c,col in enumerate(row):
out_sheet.write(r,c,label=col)
return True
numbered_findings[0] = fhdr + "\n" + numbered_findings[0]
for find in numbered_findings:
ar.write_row(rx+1,id,cat,FINDING_TYPE,fhdr + find,u"".join(exd_observations),cause,"Cond2.1")
elif not numbered_findings:
ar.write_row(rx+1,id,cat,FINDING_TYPE,fhdr,u"".join(exd_observations),cause,"Cond1")
else:
#Cond4 - no such match. Dump findings and finding details and notify
ar.write_row(rx+1,id,cat,FINDING_TYPE,finding,(d1 + "\n" + d2),cause,"Cond4: Neelansha Please look at it!")
if fob and not fdob:
ar.write_row(rx+1,id,cat,OBSERV_TYPE,fob,d1 + "\n" + d2,cause,"Cond5.1 observ")
elif fob and fdob:
ar.write_row(rx+1,id,cat,OBSERV_TYPE,fob,fdob,cause,"Cond5 observ")
try:
converter = XLConverter(book,ar.get_workbook(),config_file)
converter.process()
#get facility profile name from file
(frow,fcol) = converter.decode_single_cell('B5')
facility_name = facility_profile.cell_value(rowx=frow,colx=fcol).strip()
facility_id = facility_mapper.get_facility_id(facility_name,2013)
converter.write_value("Facility Profile","A1","Facility ID From MSS:")
converter.write_value("Facility Profile","B1",facility_id)
ar.save()
logging.info('Written file: ' + ifile + ".xls")
except:
logging.error("Error processing file: " + ifile + ".No output written")
for find in numbered_findings:
ar.write_row(rx + 1, id, cat, FINDING_TYPE, fhdr + find, "".join(exd_observations), cause, "Cond2.1")
elif not numbered_findings:
ar.write_row(rx + 1, id, cat, FINDING_TYPE, fhdr, "".join(exd_observations), cause, "Cond1")
else:
# Cond4 - no such match. Dump findings and finding details and notify
ar.write_row(
rx + 1, id, cat, FINDING_TYPE, finding, (d1 + "\n" + d2), cause, "Cond4: Neelansha Please look at it!"
)
if fob and not fdob:
ar.write_row(rx + 1, id, cat, OBSERV_TYPE, fob, d1 + "\n" + d2, cause, "Cond5.1 observ")
elif fob and fdob:
ar.write_row(rx + 1, id, cat, OBSERV_TYPE, fob, fdob, cause, "Cond5 observ")
try:
converter = XLConverter(book, ar.get_workbook(), "./config")
converter.process()
# get facility profile name from file
(frow, fcol) = converter.decode_single_cell("B5")
facility_name = facility_profile.cell_value(rowx=frow, colx=fcol).strip()
facility_id = facility_mapper.get_facility_id(facility_name, 2013)
converter.write_value("Facility Profile", "A1", "Facility ID From MSS:")
converter.write_value("Facility Profile", "B1", facility_id)
ar.save()
logging.info("Written file: " + ifile + ".xls")
except:
logging.error("Error processing file: " + ifile + ".No output written")
