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
