def getSSSContribution(val): res = db.SubList("SSSContributions", "ID", val) for row in res: if row is not None: SSSContribution = SSSContributions.SSSContributions( str(row[0]), str(row[1])) return SSSContributions
def getOfficeEmployeeType(val): res = db.SubList("OfficeEmployeeTypes", "ID", val) for row in res: if row is not None: OfficeEmployeeType = OfficeEmployeeTypes.OfficeEmployeeTypes( str(row[0]), str(row[1])) return OfficeEmployeeType
def getClient(val): res = db.SubList("Clients", "ID", val) for row in res: if row is not None: Client = Clients.Clients(str(row[0]), str(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5])) return Client
def getLog(val): res = db.SubList("Logs", "ID", val) 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])) return Log
def getAllowance(val): res = db.SubList("Allowances", "ID", val) 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])) return Allowance
def getAuthorizedManHour(val): res = db.SubList("AuthorizedManHours", "ID", val) 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])) return Allowance
def getPayrollRecord(val): res = db.SubList("PersonalPayables", "ID", val) 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])) return PersonalPayables
def getDetachmentContactPersons(val): res = db.SubList("DetachmentContactPersons", "DetachID", val) DetachmentContactPersonsList = [] for row in res: if row is not None: DetachmentContactPerson = DetachmentContactPersons.DetachmentContactPersons( 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]) ) DetachmentContactPersonsList.append(DetachmentContactPerson) row = db.cur.fetchone() return DetachmentContactPersonsList
def getAllDetachmentsbyID(val): res = db.SubList("Detachments", "ClientID", val) DetachmentList = [] 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]) ) DetachmentList.append(Detachment) row = db.cur.fetchone() return DetachmentList
def getClientContactPerson(val): res = db.SubList("ClientContactPersons", "ID", val) for row in res: if row is not None: Contact = ClientContactPersons.ClientContactPersons( 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])) return Contact
def getPayrollRecord(val): res = db.SubList("PayrollRecord", "ID", val) 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])) return PayrollRecord
def getAllowances(val): res = db.SubList("Allowances", "DetachID", val) AllowanceList = [] 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])) AllowanceList.append(Allowance) row = db.cur.fetchone() return AllowanceList
def getRate(val): res = db.SubList("Rates", "ID", val) 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])) return Rate
def getPayables(val): res = db.SubList("PersonalPayables", "PeriodCode", val) PayableList = [] for row in res: if row is not None: Payable = PersonalPayables.PersonalPayables( int(row[0]), int(row[1]), str(row[2]), str(row[3]), str(row[4]), str(row[5])) PayableList.append(Payable) row = db.cur.fetchone() return PayableList
def getFieldEmployee(val): res = db.SubList("FieldEmployees", "ID", val) 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])) return FieldEmployee
def getClientContactPersons(val): res = db.SubList("ClientContactPersons", "ClientID", val) ClientContactPersonsList = [] for row in res: if row is not None: ClientContactPerson = ClientContactPersons.ClientContactPersons( 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])) ClientContactPersonsList.append(ClientContactPerson) row = db.cur.fetchone() return ClientContactPersonsList
def getPayrollRate(val): res = db.SubList("Rates", "DetachID", val) RateArray = [] 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])) RateArray.append(Rate) return RateArray
def getFieldEmployeeTypes(val): res = db.SubList("FieldEmployeeTypes", "ID", val) for row in res: if row is not None: FieldEmployeeType = FieldEmployeeTypes.FieldEmployeeTypes( str(row[0]), str(row[1]) ) return Detachment
def getReceivable(val): res = db.SubList("Receivables", "ID", val) for row in res: if row is not None: Receivable = Receivables.Receivables(str(row[0]), str(row[1])) return Receivables
def getRateType(val): res = db.SubList("RateTypes", "ID", val) for row in res: if row is not None: RateType = RateTypes.RateTypes(str(row[0]), str(row[1])) return RateType
def getOfficeEmployeeType(val): res = db.SubList("PagibigCalamityLoan", "ID", val) for row in res: if row is not None: PagibigCalamityLoan = PagibigCalamityLoans.PagibigCalamityLoans( int(row[0]), int(row[1]), int(row[2]), int(row[3]), int(row[4]), str(row[5]) ) return PagibigCalamityLoan
def getDetachment(val): res = db.SubList("Detachments", "ID", val) 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])) return Detachment
def getUniformDeposit(val): res = db.SubList("UniformDeposits", "ID", val) for row in res: if row is not None: UniformDeposit = UniformDeposits.UniformDeposits( str(row[0]), str(row[1]) ) return UniformDeposit
def getPagibigSalaryLoan(val): res = db.SubList("PagibigSalaryLoans", "ID", val) for row in res: if row is not None: PagibigSalaryLoans = PagibigSalaryLoans.PagibigSalaryLoans( int(row[0]), int(row[1]), int(row[2]), int(row[3]), int(row[4]), str(row[5]) ) return PagibigSalaryLoans
def getHolidayMOR(val): res = db.SubList("HolidayMOR", "ID", val) for row in res: if row is not None: HolidayMOR = HolidayMOR.HolidayMOR(str(row[0]), str(row[1])) return HolidayMOR
def getIncentiveMOR(val): res = db.SubList("IncentiveMOR", "ID", val) for row in res: if row is not None: IncentiveMOR = IncentiveMOR.IncentiveMOR(str(row[0]), str(row[1])) return IncentiveMOR
def getOfficeEmployee(val): res = db.SubList("OfficeEmployees", "Username", val) 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]) ) return OfficeEmployee