def getReportTable (self): pid = self.getProjectID() reporttype = self.setReportType() reportQuery =self.getFinalReportTableQuery() connector = HouseholdIncome() reportTable = connector.getReportTable(reportQuery,pid,reporttype) return reportTable
def getHouseholdIDsQuery(self): '''Get query for generating a list of households that match a users selection criteria''' projectid = self.getProjectID() selectedHChars = self.getSelectedHouseholdCharacteristics() selectedPChars = self.getSelectedPersonalCharacteristics() selectedhouseholds = self.getHouseholdsSelection() connector = HouseholdIncome() householdIDsQuery = connector.buildReportHouseholdIDsQuery(projectid,selectedhouseholds,selectedPChars,selectedHChars) return householdIDsQuery
def getReportHouseholdIDs (self): '''Get a list of households that match a users selection criteria -i.e Household names + Personal Characteristics and Household Characteristics''' selectedids = [] householdIDsQuery =self.getHouseholdIDsQuery() connector = HouseholdIncome() householdIDs = connector.getReportHouseholdIDs(householdIDsQuery) for hid in householdIDs: selectedids.append(str(hid[0])) return selectedids
def getFinalReportTableQuery(self): projectid = self.getProjectID() householdIDs = self.getDISortedHouseholdIDs() cropdetails = self.getCropReportDetails() employmentdetails = self.getEmploymentReportDetails() livestockdetails = self.getLivestockReportDetails() loandetails = self.getLoansReportDetails() transferdetails = self.getTransfersDetails() wildfoodsdetails = self.getWildFoodDetails() reporttype = self.setReportType() connector = HouseholdIncome() householdIDsQuery = connector.getFinalIncomeReportTableQuery(reporttype,projectid,householdIDs,cropdetails,employmentdetails, livestockdetails,loandetails,transferdetails,wildfoodsdetails ) return householdIDsQuery