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
