def getDISortedHouseholdIDs(self):
""" Returns list of household IDs ordered according to DI/AE, from poorest to richest"""
householdIDs = self.getReportHouseholdIDs()
pid = self.getProjectID()
reporttype = 'DI/AE'
connector = DisposableHouseholdIncome()
disposableincome = connector.householdDisposableIncome(reporttype,pid,householdIDs)
houseids = []
for row in disposableincome:
houseids.append(row[0])
return houseids
def getNormalDIReportTable (self):
'''Get report table'''
pid = self.getProjectID()
householdIDs = self.getReportHouseholdIDs()
reporttype = 'Simulation'
connector = DisposableHouseholdIncome()
simconnector = SimulationDisposableHouseholdIncome()
writeconnector = HouseholdsIncomeWrite()
normalDIreportTable = connector.householdDisposableIncome(reporttype,pid,householdIDs)
simulationDIreportTable = simconnector.householdDisposableIncome(reporttype,pid,householdIDs)
writeconnector.writeSpreadsheetReport(normalDIreportTable,simulationDIreportTable)
return simulationDIreportTable
