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.
