def getRates(): res = db.List("Rates") RatesList = [] for row in res: if row is not None: Rate = Rates.Rates( int(row[0]), int(row[1]), str(row[2]), str(row[3]), str(row[4]), int(row[5]), int(row[6]), int(row[7]), int(row[8]), int(row[9]), int(row[10]), int(row[11]), int(row[12]), int(row[13]), int(row[14]), str(row[15]), ) RatesList.append(Rate) row = cur.fetchone() return RatesList
def getReceivables(): res = db.List("Receivables") ReceivablesList = [] for row in res: if row is not None: Receivable = Receivables.Receivables(str(row[0]), str(row[1])) ReceivablesList.append(Receivable) row = cur.fetchone() return ReceivablesList
def getAllFieldEmployees(): res = db.List("FieldEmployees") FieldEmployeesList = [] for row in res: if row is not None: FieldEmployee = FieldEmployees.FieldEmployees( str(row[0]), str(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5]), str(row[6]), str(row[7]), str(row[8]), str(row[9]), str(row[10]), str(row[11]), str(row[12]), str(row[13]), int(row[14]), str(row[15]), str(row[16]), str(row[17]), str(row[18]), str(row[19]), str(row[20]) ) FieldEmployeesList.append(FieldEmployee) row = db.cur.fetchone() return FieldEmployeesList
def getAllIncentiveMOR(): res = db.List("IncentiveMOR") IncentiveMORList = [] for row in res: if row is not None: IncentiveMOR = IncentiveMOR.IncentiveMOR(str(row[0]), str(row[1])) IncentiveMOR.append(IncentiveMOR) row = cur.fetchone() return IncentiveMORList
def getOfficeEmployees(): res = db.List("OfficeEmployees") OfficeEmployeesList = [] for row in res: if row is not None: OfficeEmployee = OfficeEmployees.OfficeEmployees( int(row[0]), str(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5]), str(row[6]), str(row[7]), str(row[8]), str(row[9]), str(row[10]), str(row[11]), str(row[12]), str(row[13]), int(row[14]), str(row[15]), str(row[16]), str(row[17]), str(row[18]) ) OfficeEmployeesList.append(OfficeEmployee) row = db.cur.fetchone() return OfficeEmployeesList
def getAllDetachments(): res = db.List("Detachments") DetachmentsList = [] for row in res: if row is not None: Detachment = Detachments.Detachments( int(row[0]), int(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5]), str(row[6]), str(row[7]), str(row[8]) ) DetachmentsList.append(Detachment) row = db.cur.fetchone() return DetachmentsList
def getRateTypes(): res = db.List("RateTypes") RateTypesList = [] for row in res: if row is not None: RateType = RateTypes.RateTypes(str(row[0]), str(row[1])) RateTypesList.append(RateType) row = cur.fetchone() return RateTypesList
def getAllPagibigSalaryLoans(): res = db.List("PagibigSalaryLoans") PagibigSalaryLoansList = [] for row in res: if row is not None: PagibigSalaryLoan = PagibigSalaryLoans.PagibigSalaryLoans( int(row[0]), int(row[1]), int(row[2]), int(row[3]), int(row[4]), str(row[5]) ) PagibigSalaryLoansList.append(PagibigSalaryLoan) row = cur.fetchone() return PagibigCalamityLoansList
def getAllHolidayMOR(): res = db.List("HolidayMOR") HolidayMORList = [] for row in res: if row is not None: HolidayMOR = HolidayMOR.HolidayMOR(str(row[0]), str(row[1])) HolidayMORList.append(HolidayMOR) row = cur.fetchone() return HolidayMORList
def getUniformDeposits(): res = db.List("UniformDeposits") UniformDepositsList = [] for row in res: if row is not None: UniformDeposit = UniformDeposits.UniformDeposits( str(row[0]), str(row[1]) ) UniformDepositsList.append(UniformDeposit) row = cur.fetchone() return UniformDepositsList
def getFieldEmployeeTypes(): res = db.List("FieldEmployeeTypes") FieldEmployeeTypesList = [] for row in res: if row is not None: FieldEmployeeType = FieldEmployeeTypes.FieldEmployeeTypes( str(row[0]), str(row[1]) ) FieldEmployeeTypesList.append(FieldEmployeeType) row = cur.fetchone() return FieldEmployeeTypesList
def getOfficeEmployeeTypes(): res = db.List("OfficeEmployeeTypes") OfficeEmployeeTypesList = [] for row in res: if row is not None: OfficeEmployeeType = OfficeEmployeeTypes.OfficeEmployeeTypes( str(row[0]), str(row[1])) OfficeEmployeeTypes.append(OfficeEmployeeType) row = cur.fetchone() return OfficeEmployeeTypesList
def getAllClients(): res = db.List("Clients") ClientList = [] for row in res: if row is not None: Client = Clients.Clients(int(row[0]), str(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5])) ClientList.append(Client) row = db.cur.fetchone() return ClientList
def getSSSContributions(): res = db.List("SSSContributions") SSSContributionsList = [] for row in res: if row is not None: SSSContribution = SSSContributions.SSSContributions( str(row[0]), str(row[1])) SSSContributionsList.append(SSSContribution) row = cur.fetchone() return SSSContributionsList
def getLogs(): res = db.List("Logs") LogsList = [] for row in res: if row is not None: Log = Logs.Logs(int(row[0]), int(row[1]), str(row[2]), str(row[3]), str(row[4])) Logs.append(Log) row = cur.fetchone() return LogsList
def getAllowances(): res = db.List("Allowances") AllowancesList = [] for row in res: if row is not None: Allowance = Allowances.Allowances(int(row[0]), int(row[1]), int(row[2]), int(row[3]), str(row[4]), str(row[5])) AllowancesList.append(Allowance) row = db.cur.fetchone() return AllowancesList
def getAuthorizedManHours(): res = db.List("AuthorizedManHours") AuthorizedManHoursList = [] for row in res: if row is not None: AuthorizedManHours = AuthorizedManHours.AuthorizedManHours( int(row[0]), int(row[1]), int(row[2]), int(row[3]), int(row[4]), str(row[5])) AuthorizedManHoursList.append(AuthorizedManHours) row = cur.fetchone() return AuthorizedManHoursList
def getPersonalPayables(): res = db.List("PersonalPayables") PersonalPayablesList = [] for row in res: if row is not None: PersonalPayable = PersonalPayables.PersonalPayables( int(row[0]), int(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5])) PersonalPayablesList.append(PersonalPayable) row = cur.fetchone() return PersonalPayables
def getPayrollRecords(): res = db.List("PayrollRecord") PayrollRecordList = [] for row in res: if row is not None: PayrollRecord = PayrollRecord.PayrollRecord( int(row[0]), int(row[1]), int(row[2]), int(row[3]), int(row[4]), int(row[5]), int(row[6]), int(row[7]), int(row[8]), int(row[9]), int(row[10]), int(row[11]), int(row[12]), int(row[13]), int(row[14]), int(row[15])) PayrollRecordList.append(PayrollRecord) row = cur.fetchone() return PayrollRecordList