Briefly what im trying to do is to create payslips for all contracts in the db through a loop, i just checked sqlform factory but i have a question where do i pass the form(payslip table) to insert in into after if form.process().accepts:
On Monday, September 26, 2016 at 11:09:52 PM UTC+3, Jim S wrote: > > I think that is all that it should do. > > Your check_batch function is being called at the validation stage of > processing your form. All your check_batch function does is reassign > values to the form variables that you've captured. After it is done, the > web2py form processing will insert the current values of the form variables > into the database for you. See Anthony's first reply. I think your > approach to this is somewhat flawed. > > Here is what I see is happening: > > 1. User makes a request to the batch_payslips function. Result is that a > form is displayed. > 2. User enters values into the form and clicks on Submit. > 3. Your onvalidation method (check_batch) is invoked. This method resets > a bunch of the form variables, but since it is in a loop, the variables set > in the last pass through the loop are retained in the form variables. > 4. sqlform.process().accepted takes over and inserts a record into > payslips based on the current values of the form variables. > > From what I think you're trying to do, I'd re-architect a bit. > > 1. Use a SQFORM.factory to gather whatever information it is your asking > of the user. > http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-factory > 2. Instead of loop through the RUNNING contracts in the onvalidation > function (check_batch), put that code after the "if > form.process().accepts:" statement. > 3. Update that code to manually insert the records into payslips instead > of just assigning values to the form variables. > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#insert > > I hope this helps. My apologies if I'm misunderstanding your goals. > > -Jim > > > On Monday, September 26, 2016 at 2:48:32 PM UTC-5, Oasis Agano wrote: >> >> Well its progressing now, using >> >> form.vars.employee=contraa.employee >> form.vars.payslip_name=contraa.employee.fullname >> form.vars.contract=contraa.id >> >> >> Now it is inserting only one payslip(from one contract) but not inserting >> the other one >> >> >> On Monday, September 26, 2016 at 7:54:03 PM UTC+3, Jim S wrote: >>> >>> You're setting form.vars.employee = contraa.employee.fullname >>> >>> It should be set to the employee id, not the name. Results in the same >>> problem as with contract name/id. >>> >>> Should just be contraa.employee I believe... >>> >>> -Jim >>> >>> On Monday, September 26, 2016 at 10:23:15 AM UTC-5, Oasis Agano wrote: >>>> >>>> i changed it to form.vars.contract = contraa.id >>>> but still getting the same error >>>> >>>> On Monday, September 26, 2016 at 5:39:41 PM UTC+3, Anthony wrote: >>>>> >>>>> In your model, db.payslip.contract is a reference field, but in your >>>>> code, you attempt to assign a string value to it (form.vars.contract = >>>>> contraa.contract_name). >>>>> >>>>> Anthony >>>>> >>>>> On Monday, September 26, 2016 at 10:04:30 AM UTC-4, Oasis Agano wrote: >>>>>> >>>>>> Models are here, if this way cant work can you suggest another way of >>>>>> doing it >>>>>> >>>>>> MARITAL_SET = [ >>>>>> T('Single'), >>>>>> T('Married'), >>>>>> T('Divorced'), >>>>>> T('Widower') >>>>>> >>>>>> >>>>>> ] >>>>>> TIME_SET = [ >>>>>> T('Part time'), >>>>>> T('Full time'), >>>>>> >>>>>> >>>>>> ] >>>>>> >>>>>> STATE_SET = [ >>>>>> T('Trial'), >>>>>> T('Employed'), >>>>>> T('Fired'), >>>>>> T('Retired'), >>>>>> >>>>>> >>>>>> ] >>>>>> #@auth.requires_login() >>>>>> >>>>>> db.define_table('employee', >>>>>> Field('emp_photo', 'upload',label='Photo'), >>>>>> Field('first_name','string',label='First Name'), >>>>>> Field('last_name','string',label='Last Name'), >>>>>> >>>>>> Field('fullname','string',readable='False',compute=lambda r: >>>>>> r.first_name+' '+r.last_name), >>>>>> Field('email','string'), >>>>>> Field('phone','string'), >>>>>> Field('marital_status', requires=IS_IN_SET(MARITAL_SET, >>>>>> zero=T('--choose marital status--'))), >>>>>> Field('number_of_children', 'string'), >>>>>> Field('name_of_children','text'), >>>>>> Field('address','text'), >>>>>> Field('Manager', 'reference employee'), >>>>>> #Field('date','datetime'), >>>>>> Field('dob', 'datetime', label='Date of Birth'), >>>>>> Field('doj', 'datetime', label='Hired Date'), >>>>>> Field('ismanager', 'boolean', default=False,label='Is >>>>>> Department Manager'), >>>>>> Field('department', 'reference >>>>>> department',requires=IS_EMPTY_OR(IS_IN_DB(db, "department.id", >>>>>> '%(department_name)s'))), >>>>>> Field('user', 'reference >>>>>> auth_user',requires=IS_EMPTY_OR(IS_IN_DB(db, "auth_user.id", >>>>>> '%(fullname)s'))), >>>>>> Field('job', 'reference job_title'), >>>>>> Field('Other', 'text'), >>>>>> Field('state', requires=IS_IN_SET(STATE_SET, >>>>>> zero=T('--choose employment status--'))), >>>>>> auth.signature, >>>>>> format='%(fullname)s' >>>>>> >>>>>> ) >>>>>> db.define_table('job_title', >>>>>> Field('job_name', 'string', label='Job Title'), >>>>>> auth.signature, >>>>>> format='%(job_name)s' >>>>>> ) >>>>>> #db = DAL(lazy_tables=True) >>>>>> db.define_table('department', >>>>>> Field('department_name', 'string', label='Department >>>>>> Name'), >>>>>> Field('parent_dept', 'reference department'), >>>>>> Field('Other', 'text'), >>>>>> format='%(department_name)s' >>>>>> ) >>>>>> #db.employee.department.requires = IS_IN_DB(db, db.department.id, >>>>>> '%(department_name)s') >>>>>> >>>>>> CONTRACTTYPE_SET = [ >>>>>> T('Employee'), >>>>>> T('Consultant'), >>>>>> T('Freelance'), >>>>>> T('Internship'), >>>>>> >>>>>> ] >>>>>> >>>>>> SALARYSTRUCTURE_SET = [ >>>>>> T('Less than 30000'), >>>>>> T('Between 30000 and 100000'), >>>>>> T('Great than 100000') >>>>>> >>>>>> ] >>>>>> >>>>>> CONTRACTSTATE_SET = [ >>>>>> T('Draft'), >>>>>> T('Running'), >>>>>> T('Expired/To Renew'), >>>>>> T('Closed'), >>>>>> T('Cancelled'), >>>>>> >>>>>> >>>>>> ] >>>>>> >>>>>> >>>>>> db.define_table('contract', >>>>>> Field('employee', 'reference employee', required='true', >>>>>> requires=IS_IN_DB(db, "employee.id", >>>>>> '%(fullname)s')), >>>>>> # Field('date','datetime'), >>>>>> Field('contract_name', 'string', label='Contract Title'), >>>>>> Field('contract_type', >>>>>> requires=IS_IN_SET(CONTRACTTYPE_SET, zero=T('--choose contract >>>>>> type--'))), >>>>>> Field('salary_structure', >>>>>> requires=IS_IN_SET(SALARYSTRUCTURE_SET, zero=T('--choose salary >>>>>> type--'))), >>>>>> Field('job', 'reference job_title'), >>>>>> Field('contract_scan', 'upload',label='Contract Upload'), >>>>>> Field('date_trial_start', 'datetime', label='Starting >>>>>> Trial Date'), >>>>>> Field('date_trial_end', 'datetime', label='End Trial >>>>>> Date'), >>>>>> Field('date_work_start', 'datetime', label='Starting >>>>>> Working Date'), >>>>>> Field('date_work_end', 'datetime', label='End of >>>>>> Contract'), >>>>>> Field('wage', 'float'), >>>>>> Field('rssb', 'boolean', default=True, label='Pay RSSB'), >>>>>> Field('batch', 'boolean', default=True, label='Enable >>>>>> Batch Payslip'), >>>>>> Field('allowances', 'float'), >>>>>> Field('visa_no', 'string', label='Visa No'), >>>>>> Field('work_permit_no', 'string', label='Work Permit >>>>>> No'), >>>>>> Field('visa_exp', 'datetime', label='Visa Expiry Date'), >>>>>> Field('other','text'), >>>>>> Field('state', requires=IS_IN_SET(CONTRACTSTATE_SET, >>>>>> zero=T('--State--'))), >>>>>> auth.signature >>>>>> ) >>>>>> >>>>>> >>>>>> >>>>>> LOANSTATE_SET = [ >>>>>> T('Draft'), >>>>>> T('Confirmed'), >>>>>> T('Refused'), >>>>>> T('Paid'), >>>>>> >>>>>> >>>>>> >>>>>> ] >>>>>> >>>>>> LOANTYPE_SET = [ >>>>>> T('Advance'), >>>>>> T('Long Term'), >>>>>> >>>>>> ] >>>>>> db.define_table('loans', >>>>>> Field('loan_name', 'string', label='Loan Title'), >>>>>> Field('employee', 'reference employee', required='true', >>>>>> requires=IS_IN_DB(db, "employee.id", >>>>>> '%(fullname)s')), >>>>>> Field('contract', 'reference contract', required='true', >>>>>> requires=IS_IN_DB(db, "contract.id", >>>>>> '%(contract_name)s')), >>>>>> Field('loan_type', requires=IS_IN_SET(LOANTYPE_SET, >>>>>> zero=T('--Type--'))), >>>>>> Field('loan_amount', 'float',label='Loan Amount'), >>>>>> Field('paid', 'float', label='Amount >>>>>> Paid',default='0.0'), >>>>>> Field('balance', 'float', label='Loan Amount >>>>>> Remaining',default='0.0',readable=False), >>>>>> Field('date','datetime',label='Date >>>>>> request',default=lambda:datetime.now()), >>>>>> Field('date_start', 'datetime', label='Start of >>>>>> Payment'), >>>>>> Field('no_of_months', 'integer',label='No of Months'), >>>>>> Field('state', requires=IS_IN_SET(LOANSTATE_SET, >>>>>> zero=T('--State--')),default='Draft'), >>>>>> auth.signature >>>>>> ) >>>>>> >>>>>> db.define_table('loanpayment', >>>>>> Field('loanpayment_name', 'string', label='Payment >>>>>> Title'), >>>>>> Field('employee', 'reference employee', required='true', >>>>>> requires=IS_IN_DB(db, "employee.id", >>>>>> '%(fullname)s')), >>>>>> Field('loan', 'reference loans', required='true', >>>>>> requires=IS_IN_DB(db, "loans.id", >>>>>> '%(loan_name)s')), >>>>>> Field('amount_payed', 'float', label='Loan Amount >>>>>> Payed'), >>>>>> Field('date', 'datetime', label='Date of Payment'), >>>>>> auth.signature >>>>>> ) >>>>>> >>>>>> PAYSLIPSTATE_SET = [ >>>>>> T('Draft'), >>>>>> T('Confirmed'), >>>>>> T('Closed'), >>>>>> T('Cancelled'), >>>>>> >>>>>> >>>>>> >>>>>> ] >>>>>> db.define_table('payslip', >>>>>> Field('employee', 'reference employee', required='true', >>>>>> requires=IS_IN_DB(db, "employee.id", >>>>>> '%(fullname)s')), >>>>>> Field('contract', 'reference contract', required='true', >>>>>> requires=IS_EMPTY_OR(IS_IN_DB(db, "contract.id", >>>>>> '%(contract_name)s'))), >>>>>> Field('payslip_name', 'string', label='Payslip Title'), >>>>>> Field('gross', 'float',readable=False, writable=False), >>>>>> Field('net', 'float',readable=False, writable=False), >>>>>> Field('rssb_emp','float',readable=False, writable=False), >>>>>> Field('rssb_comp','float',readable=False, >>>>>> writable=False), >>>>>> Field('rssb_tot','float',readable=False, writable=False), >>>>>> Field('paye','float',readable=False, writable=False), >>>>>> #Field('loan','float',default='0'), >>>>>> Field('loan', 'reference loanpayment',label='Loan >>>>>> ',requires=IS_EMPTY_OR(IS_IN_DB(db, "loanpayment.id", >>>>>> '%(loanpayment_name)s'))), >>>>>> Field('date','datetime',default=lambda:datetime.now()), >>>>>> Field('date_pay_start', 'datetime', label='Start of >>>>>> Payment Period'), >>>>>> Field('date_pay_end', 'datetime', label='End of Payment >>>>>> Period'), >>>>>> #Field('contract_type', >>>>>> requires=IS_IN_SET(CONTRACTTYPE_SET, zero=T('--choose contract >>>>>> type--')),readable=False, writable=False), >>>>>> #Field('salary_structure', >>>>>> requires=IS_IN_SET(SALARYSTRUCTURE_SET, zero=T('--choose salary >>>>>> type--')),readable=False, writable=False), >>>>>> #Field('job', 'reference job_title',readable=False, >>>>>> writable=False), >>>>>> Field('user', 'reference auth_user',label='Link to >>>>>> User',requires=IS_EMPTY_OR(IS_IN_DB(db, "auth_user.id", >>>>>> '%(fullname)s'))), >>>>>> Field('state', requires=IS_IN_SET(PAYSLIPSTATE_SET, >>>>>> zero=T('--State--'))), >>>>>> >>>>>> auth.signature >>>>>> ) >>>>>> >>>>>> >>>>>> On Monday, September 26, 2016 at 5:00:14 PM UTC+3, Anthony wrote: >>>>>>> >>>>>>> Well, you still haven't shown your models. My guess is one of your >>>>>>> fields is a reference field, which stores long int values representing >>>>>>> the >>>>>>> record ID of the referenced record, but you are attempting to insert a >>>>>>> string value. >>>>>>> >>>>>>> Anyway, your approach won't work because SQLFORM only does a single >>>>>>> insert, which happens after the onvalidation callback runs. So, only >>>>>>> the >>>>>>> last set of form.vars values assigned in the onvalidation for loop will >>>>>>> end >>>>>>> up being inserted in the database. >>>>>>> >>>>>>> Anthony >>>>>>> >>>>>>> On Monday, September 26, 2016 at 9:56:34 AM UTC-4, Oasis Agano wrote: >>>>>>>> >>>>>>>> TRACEBACK >>>>>>>> >>>>>>>> Traceback (most recent call last): >>>>>>>> File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\restricted.py", >>>>>>>> line 227, in restricted >>>>>>>> exec ccode in environment >>>>>>>> File >>>>>>>> "D:/lab/PycharmProjects/Smartwork/web2py/applications/smartwork/controllers/default.py" >>>>>>>> >>>>>>>> <http://127.0.0.1:8000/admin/default/edit/smartwork/controllers/default.py>, >>>>>>>> line 708, in <module> >>>>>>>> File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\globals.py", >>>>>>>> line 417, in <lambda> >>>>>>>> self._caller = lambda f: f() >>>>>>>> File >>>>>>>> "D:/lab/PycharmProjects/Smartwork/web2py/applications/smartwork/controllers/default.py" >>>>>>>> >>>>>>>> <http://127.0.0.1:8000/admin/default/edit/smartwork/controllers/default.py>, >>>>>>>> line 300, in batch_payslip >>>>>>>> if form.process(onvalidation=check_batch).accepted: >>>>>>>> File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\html.py", line >>>>>>>> 2298, in process >>>>>>>> self.validate(**kwargs) >>>>>>>> File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\html.py", line >>>>>>>> 2236, in validate >>>>>>>> if self.accepts(**kwargs): >>>>>>>> File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\sqlhtml.py", >>>>>>>> line 1746, in accepts >>>>>>>> self.vars.id = self.table.insert(**fields) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\objects.py", >>>>>>>> line 726, in insert >>>>>>>> ret = self._db._adapter.insert(self, self._listify(fields)) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>>>> line 739, in insert >>>>>>>> query = self._insert(table,fields) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>>>> line 730, in _insert >>>>>>>> values = ','.join(self.expand(v, f.type) for f, v in fields) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>>>> line 730, in <genexpr> >>>>>>>> values = ','.join(self.expand(v, f.type) for f, v in fields) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>>>> line 962, in expand >>>>>>>> rv = self.represent(expression, field_type) >>>>>>>> File >>>>>>>> "D:\lab\PycharmProjects\Smartwork\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>>>> line 1442, in represent >>>>>>>> return str(long(obj)) >>>>>>>> ValueError: invalid literal for long() with base 10: 'Jul Contract' >>>>>>>> >>>>>>>> >>>>>>>> Note that this contract is the second in the database >>>>>>>> >>>>>>>> >>>>>>>> Basically what im trying to do is create a loop(from a form) that will >>>>>>>> create payslips for all running contracts >>>>>>>> >>>>>>>> >>>>>>>> On Monday, September 26, 2016 at 4:21:56 PM UTC+3, Anthony wrote: >>>>>>>>> >>>>>>>>> Hard to say what the problem is without seeing the full traceback >>>>>>>>> as well as your models. >>>>>>>>> >>>>>>>>> Also, what are you trying to do in the check_batch function? You >>>>>>>>> are looping through some records and making assignments to form.vars, >>>>>>>>> but >>>>>>>>> only the final run of the loop will end up taking effect -- so what >>>>>>>>> is the >>>>>>>>> point of the loop? >>>>>>>>> >>>>>>>>> Anthony >>>>>>>>> >>>>>>>>> On Monday, September 26, 2016 at 8:29:35 AM UTC-4, Oasis Agano >>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Greetings >>>>>>>>>> im creating a payroll app and i need a to create a batch of >>>>>>>>>> payslips >>>>>>>>>> >>>>>>>>>> i want to create payslips for all contracts in the database >>>>>>>>>> within the running state >>>>>>>>>> the code >>>>>>>>>> >>>>>>>>>> def check_batch(form): >>>>>>>>>> >>>>>>>>>> contraaa = db(db.contract.state == >>>>>>>>>> 'Running').select(db.contract.ALL) >>>>>>>>>> for contraa in contraaa: >>>>>>>>>> >>>>>>>>>> if contraa.salary_structure == 'Less than 30000': >>>>>>>>>> totgross=contraa.wage+contraa.allowances >>>>>>>>>> >>>>>>>>>> form.vars.employee=contraa.employee.fullname >>>>>>>>>> form.vars.payslip_name=contraa.employee.fullname >>>>>>>>>> form.vars.contract=contraa.contract_name >>>>>>>>>> >>>>>>>>>> form.vars.gross=totgross >>>>>>>>>> form.vars.rssb_emp = totgross*0.03 >>>>>>>>>> form.vars.rssb_comp = totgross*0.05 >>>>>>>>>> form.vars.paye = 0 >>>>>>>>>> totrssb=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> form.vars.rssb_tot=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> if type(form.vars.loan) !=int : >>>>>>>>>> >>>>>>>>>> form.vars.net = totgross-form.vars.rssb_emp >>>>>>>>>> else: >>>>>>>>>> payy=db(db.loanpayment.id == >>>>>>>>>> form.vars.loan).select(db.loanpayment.ALL) >>>>>>>>>> for pay in payy: >>>>>>>>>> loanpay=int(pay.amount_payed) >>>>>>>>>> form.vars.net = >>>>>>>>>> totgross-form.vars.rssb_emp-loanpay >>>>>>>>>> >>>>>>>>>> elif contraa.salary_structure == 'Between 30000 and 100000': >>>>>>>>>> >>>>>>>>>> form.vars.employee=contraa.employee.fullname >>>>>>>>>> form.vars.payslip_name=contraa.employee.fullname >>>>>>>>>> form.vars.contract=contraa.contract_name >>>>>>>>>> >>>>>>>>>> totgross=contraa.wage+contraa.allowances >>>>>>>>>> form.vars.gross=totgross >>>>>>>>>> form.vars.rssb_emp = totgross*0.03 >>>>>>>>>> form.vars.rssb_comp = totgross*0.05 >>>>>>>>>> varia =totgross-30000 >>>>>>>>>> form.vars.paye = varia*0.2 >>>>>>>>>> totrssb=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> form.vars.rssb_tot=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> if type(form.vars.loan) !=int : >>>>>>>>>> form.vars.net = >>>>>>>>>> totgross-form.vars.rssb_emp-form.vars.paye >>>>>>>>>> else: >>>>>>>>>> payy=db(db.loanpayment.id == >>>>>>>>>> form.vars.loan).select(db.loanpayment.ALL) >>>>>>>>>> for pay in payy: >>>>>>>>>> loanpay=int(pay.amount_payed) >>>>>>>>>> form.vars.net = >>>>>>>>>> totgross-form.vars.rssb_emp-form.vars.paye-loanpay >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> #form = SQLFORM(db.payslip) >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> elif contraa.salary_structure=='Great than 100000': >>>>>>>>>> >>>>>>>>>> form.vars.employee=contraa.employee >>>>>>>>>> form.vars.payslip_name=contraa.employee >>>>>>>>>> form.vars.contract=contraa.contract_name >>>>>>>>>> >>>>>>>>>> totgross=contraa.wage+contraa.allowances >>>>>>>>>> form.vars.gross=totgross >>>>>>>>>> form.vars.rssb_emp = totgross*0.03 >>>>>>>>>> form.vars.rssb_comp = totgross*0.05 >>>>>>>>>> varia2 =totgross-100000 >>>>>>>>>> variah = varia2*0.3 >>>>>>>>>> varia3 =70000*0.2 >>>>>>>>>> form.vars.paye = variah+varia3 >>>>>>>>>> totrssb=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> form.vars.rssb_tot=form.vars.rssb_emp+form.vars.rssb_comp >>>>>>>>>> if type(form.vars.loan) !=int : >>>>>>>>>> form.vars.net = >>>>>>>>>> totgross-form.vars.rssb_emp-form.vars.paye >>>>>>>>>> else: >>>>>>>>>> payy=db(db.loanpayment.id == >>>>>>>>>> form.vars.loan).select(db.loanpayment.ALL) >>>>>>>>>> for pay in payy: >>>>>>>>>> loanpay=int(pay.amount_payed) >>>>>>>>>> form.vars.net = >>>>>>>>>> totgross-form.vars.rssb_emp-form.vars.paye-loanpay >>>>>>>>>> >>>>>>>>>> #form = SQLFORM(db.payslip) >>>>>>>>>> >>>>>>>>>> else: >>>>>>>>>> response.flash=T('Select a salary structure and >>>>>>>>>> contract') >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> def batch_payslip(): >>>>>>>>>> db.payslip.gross.readonly =True >>>>>>>>>> db.payslip.net.readable =False >>>>>>>>>> db.payslip.rssb_emp.readable =False >>>>>>>>>> #db.payslip.salary_structure.readable =False >>>>>>>>>> db.payslip.rssb_comp.readable =False >>>>>>>>>> db.payslip.paye.readable =False >>>>>>>>>> db.payslip.employee.readable =False >>>>>>>>>> db.payslip.employee.writable =False >>>>>>>>>> db.payslip.contract.readable =False >>>>>>>>>> db.payslip.contract.writable =False >>>>>>>>>> db.payslip.payslip_name.readable =False >>>>>>>>>> db.payslip.payslip_name.writable =False >>>>>>>>>> db.payslip.loan.readable =False >>>>>>>>>> db.payslip.loan.writable =False >>>>>>>>>> db.payslip.user.readable =False >>>>>>>>>> db.payslip.user.writable =False >>>>>>>>>> form = SQLFORM(db.payslip) >>>>>>>>>> >>>>>>>>>> if form.process(onvalidation=check_batch).accepted: >>>>>>>>>> response.flash=T('Payslip Added') >>>>>>>>>> return dict(form=form) >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> im getting this error >>>>>>>>>> >>>>>>>>>> ValueError: invalid literal for long() with base 10: 'with a >>>>>>>>>> contract name' >>>>>>>>>> >>>>>>>>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
