def save(self):
sql = "insert into Receivables (FieldEmpID, CholFund, EmpFileFund, HolidayPay, ThirteenMonthPay, IncentivesPay, UniAllowance, UniDeposit) values (%s, %s, %s, %s, %s, %s, %s, %s)"
params = (
self.FieldEmpID,
self.CholFund,
self.EmpFileFund,
self.HolidayPay,
self.ThirteenMonthPay,
self.IncentivesPay,
self.UniAllowance,
self.UniDeposit,
)
db.ins(sql, params)
def save(self):
sql = "insert into ClientContactPersons (ClientID, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, Birthdate) values (%s, %s, %s, %s, %s, %s, %s, %s)"
params = (
self.ClientID,
self.Suffix,
self.LastName,
self.FirstName,
self.MiddleName,
self.Landline,
self.MobileNo,
self.BirthDate,
)
db.ins(sql, params)
def save(self):
sql = "insert into ManHourLogs (ID, DetachID, NoOfFullDays, NightHours, RegHours, OTHours, LegHolidayHours, SpeHolidayHours, DateCreated, PeriodCode) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
params = (
self.ID,
self.DetachID,
self.NoOfFullDays,
self.NightHours,
self.RegHours,
self.OTHours,
self.LegHolidayHours,
self.SpeHolidayHours,
self.DateCreated,
self.PeriodCode,
)
return db.ins(sql, params)
def save(self): sql = "insert into DetachmentContactPersons (DetachID, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, BirthDate) values (%s, %s, %s, %s, %s, %s, %s, %s)" params = (self.DetachID, self.Suffix, self.LastName, self.FirstName, self.MiddleName, self.Landline, self.MobileNo, self.BirthDate) return db.ins(sql, params)
def save(self): sql = "insert into PagibigSalaryLoans (FieldEmpID, Amount, MonthlyPay, Balance, Status) values (%s, %s, %s, %s, %s)" params = (self.FieldEmpID, self.Amount, self.MonthlyPay, self.Balance, self.Status) db.ins(sql,params)
def save(self): sql = "insert into FieldEmployees (Type, DisplayCode, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, Address, Birthdate, Gender, CivilStatus, Dependents, Skills, DateHired, DateResigned, EmpStatus, CholesterolStatus, FileStatus) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" params = (self.type, self.DisplayCode, self.Suffix, self.LastName, self.FirstName, self.MiddleName, self.Landline, self.MobileNo, self.Address, self.Birthdate, self.Gender, self.CivilStatus, self.Dependents, self.Skills, self.Datehired, self.DateResigned, self.EmpStatus, self.CholesterolStatus, self.Filestatus) db.ins(sql,params)
def save(self): sql = "insert into OfficeEmployees (Type, Username, Password, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, Address, BirthDate, Gender, CivilStatus, Dependents, Position, DateHired, DateResigned, EmpStatus) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, )" params = (self.Type, self.Username, self.Password, self.Suffix, self.LastName, self.FirstName, self.MiddleName, self.Landline, self.MobileNo, self.Address, self.BirthDate, self.Gender, self.CivilStatus, self.Dependents, self.Position, self.DateHired, self.DateResigned, self.EmpStatus) db.ins(sql,params)
def save(self): sql = "insert into RateTypes (type, description) values (%s, %s)" params = (self.type, self.description) db.ins(sql, params)
def save(self): sql = "insert into ClientContactPersons (ClientID, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, Birthdate) values (%s, %s, %s, %s, %s, %s, %s, %s) params = (self.ClientID, self.Suffix, self.LastName, self.FirstName, self.MiddleName, self.Landline, self.MobileNo, self.BirthDate) db.ins(sql,params)
def save(self): sql = "insert into IncentiveMOR (type, description) values (%s, %s)" params = (self.type, self.description) db.ins(sql, params)
def save(self): sql = "insert into Logs (EmpID, Type, Description, Timestamp) values (%s, %s, %s, %s)" params = (self.EmpID, self.Type, self.Description, self.Timestamp) db.ins(sql,params)
def save(self): sql = "insert into OfficeEmployeeTypes (Type, Description) values (%s, %s)" params = (self.Type, self.Description) db.ins(sql,params)
def save(self):
sql = "insert into Logs (EmpID, Type, Description, Timestamp) values (%s, %s, %s, %s)"
params = (self.EmpID, self.Type, self.Description, self.Timestamp)
db.ins(sql, params)
def save(self): sql = "insert into PersonalPayables (FieldEmpID, Type, Amount, PeriodCode, DateCreated) values (%s, %s, %s, %s, %s)" params = (self.FieldEmpID, self.Type, self.Amount, self.PeriodCode, self.DateCreated) db.ins(sql,params)
def save(self):
sql = "insert into ManHourLogs (ID, DetachID, NoOfFullDays, NightHours, RegHours, OTHours, LegHolidayHours, SpeHolidayHours, DateCreated, PeriodCode) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
params = (self.ID, self.DetachID, self.NoOfFullDays, self.NightHours,
self.RegHours, self.OTHours, self.LegHolidayHours,
self.SpeHolidayHours, self.DateCreated, self.PeriodCode)
return db.ins(sql, params)
def save(self):
sql = "insert into PersonalPayables (FieldEmpID, Type, Amount, PeriodCode, DateCreated) values (%s, %s, %s, %s, %s)"
params = (self.FieldEmpID, self.Type, self.Amount, self.PeriodCode,
self.DateCreated)
db.ins(sql, params)
def save(self): sql = 'insert into FieldEmployeeTypes (type, description) values (%s, %s)' params = (self.type, self.description) db.ins(sql, params)
def save(self):
sql = "insert into IncentiveMOR (type, description) values (%s, %s)"
params = (self.type, self.description)
db.ins(sql, params)
def save(self):
sql = "insert into SSSContributions (PriceFrom, PriceTo, ER, EE, EffectiveYear) values (%s, %s, %s, %s, %s)"
params = (self.PriceFrom, self.PriceTo, self.ER, self.EE,
self.EffectiveYear)
db.ins(sql, params)
def save(self):
sql = "insert into DetachmentContactPersons (DetachID, Suffix, LastName, FirstName, MiddleName, Landline, MobileNo, BirthDate) values (%s, %s, %s, %s, %s, %s, %s, %s)"
params = (self.DetachID, self.Suffix, self.LastName, self.FirstName,
self.MiddleName, self.Landline, self.MobileNo,
self.BirthDate)
return db.ins(sql, params)
def save(self):
sql = 'insert into FieldEmployeeTypes (type, description) values (%s, %s)'
params = (self.type, self.description)
db.ins(sql, params)
def save(self):
sql = "insert into Clients (Code, Name, BillingAddress, Landline) values (%s, %s, %s, %s)"
params = (self.Code, self.Name, self.BillingAddress, self.Landline)
db.ins(sql, params)
def save(self):
sql = "insert into UniformDeposits (FieldEmpID, Amount) values (%s, %s)"
params = (self.FieldEmpID, self.Amount)
db.ins(sql, params)
def save(self):
sql = "insert into SSSLoans (FieldEmpID, Amount, MonthlyPay, Balance, Status) values (%s, %s, %s, %s, %s)"
params = (self.FieldEmpID, self.Amount, self.MonthlyPay, self.Balance,
self.Status)
db.ins(sql, params)
def save(self): #sql = "insert into Rates (RateType, HolidayType, IncentiveType, Regular, Overtime, NDifferential, ECOLA, ThirteenMonth, PhilHealth, PagibigPrem, Incentive, LegalHoliday, EffectiveDate) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" sql = "insert into Rates values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" params = (self.RateType, self.HolidayType, self.Incentive, self.Regular, self.Overtime, self.NDifferential, self.ECOLA, self.ThirteenMonth, self.PhilHealth, self.PagibigPrem, self.Incentive, self.LegalHoliday, self.EffectiveDate) return db.ins(sql, params)
def save(self):
sql = "insert into Detachments (ClientID, RateID, Code, Name, Address, City, StartDate, EndDate, Status) values (%s, %s, %s, %s, %s, %s, %s, %s, %s)"
params = (self.ClientID, self.RateID, self.Code, self.Name,
self.Address, self.City, self.StartDate, self.EndDate,
self.Status)
return db.ins(sql, params)
def save(self):
sql = "insert into OfficeEmployeeTypes (Type, Description) values (%s, %s)"
params = (self.Type, self.Description)
db.ins(sql, params)
def save(self):
sql = "insert into DetachmentContactPersons (ID, DetachID, WorkingDays, Saturdays, Holidays, EffectiveDate) values (%s, %s, %s, %s, %s, %s)"
params = (self.ID, self.DetachID, self.WorkingDays, self.Saturdays,
self.Holidays, self.EffectiveDate)
return db.ins(sql, params)
def save(self): sql = "insert into Receivables (FieldEmpID, CholFund, EmpFileFund, HolidayPay, ThirteenMonthPay, IncentivesPay, UniAllowance, UniDeposit) values (%s, %s, %s, %s, %s, %s, %s, %s)" params = (self.FieldEmpID, self.CholFund, self.EmpFileFund, self.HolidayPay, self.ThirteenMonthPay, self.IncentivesPay, self.UniAllowance, self.UniDeposit) db.ins(sql,params)
def save(self): sql = "insert into SSSContributions (PriceFrom, PriceTo, ER, EE, EffectiveYear) values (%s, %s, %s, %s, %s)" params = (self.PriceFrom, self.PriceTo, self.ER, self.EE, self.EffectiveYear) db.ins(sql,params)
def save(self): sql = "insert into UniformDeposits (FieldEmpID, Amount) values (%s, %s)" params = (self.FieldEmpID, self.Amount) db.ins(sql,params)
def save(self): sql = "insert into Clients (Code, Name, BillingAddress, Landline) values (%s, %s, %s, %s)" params = (self.Code, self.Name, self.BillingAddress, self.Landline) db.ins(sql,params)
def save(self): sql = "insert into DetachmentContactPersons (ID, DetachID, WorkingDays, Saturdays, Holidays, EffectiveDate) values (%s, %s, %s, %s, %s, %s)" params = (self.ID, self.DetachID, self.WorkingDays, self.Saturdays, self.Holidays, self.EffectiveDate) return db.ins(sql, params)
def save(self): sql = "insert into Detachments (ClientID, RateID, Code, Name, Address, City, StartDate, EndDate, Status) values (%s, %s, %s, %s, %s, %s, %s, %s, %s)" params = (self.ClientID, self.Code, self.Name, self.Address, self.City, self.StartDate, self.EndDate, self.Status) return db.ins(sql, params)
def save(self): sql = "insert into PayrollRecord (MHLogID, UniDepoID, SSSLoanID, CalamityLoanID, SalaryLoanID, AllowanceID, Regular, Overtime, NDifferential, ECOLA, LegalHoliday, SpecialHoliday, NetPays) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" params = (self.MHLogID, self.UniDepoID, self.SSSLoanID, self.CalamityLoanID, self.SalaryLoanID, self.AllowanceID, self.Regular, self.Overtime, self.NDifferential, self.ECOLA, self.LegalHoliday, self.SpecialHoliday, self.NetPays) db.ins(sql,params)
