Is that the full traceback? What happens if you remove the "print" statement? Can you print just rows.first()?
Anthony On Thursday, September 29, 2016 at 9:33:59 PM UTC-4, Oasis Agano wrote: > > Greetings im trying to perform a sum query that calculates the total > gross(float) so that i can pass it to the view but im getting the error > described in the traceback; > > i tried this > https://groups.google.com/forum/#!searchin/web2py/sum/web2py/paz06IC3slo/13Lj3tErj8EJ > but no clue > > *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 1210, 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\gluon\tools.py", line 4241, > in f > return action(*a, **b) > File "D:\lab\PycharmProjects\Smartwork\web2py\gluon\tools.py", line 4241, > in f > return action(*a, **b) > 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 41, in dashboard_admin > print rows.first()[db.payslip.gross.sum()] > IOError: [Errno 22] Invalid argument > > > *CONTROLLER* > > @auth.requires_membership('Admin') > def dashboard_admin(): > > rows=db(db.payslip.state == 'Confirmed').select(db.payslip.gross.sum()) > print rows.first()[db.payslip.gross.sum()] > > > return dict(rows=rows) > > > MODELS > > 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 > ) > > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
