Skip to Content
This question has been flagged
pythonpostgresql
2 Respostes
5764 Vistes
Avatar
Ali Abdelmonem Mustafa Amer

Hi Guys

I Got Error (TypeError: 'int' object is not iterable)

My Code : (python :) def on_change_emp(self,cr,uid,ids,emp_id,context=None): vs = cr.execute('SELECT wage FROM hr_contract WHERE (id=%s)',(tuple(emp_id))).fetchone() if vs is not None: raise osv.except_osv((vs[0]),('Employee Wage')) else: pass

(XML :) <field name="emp_id" attrs="{'invisible':[('item_emp','!=',True)]}" on_change="on_change_emp(emp_id)"/>

Avatar
Descartar
Ayyappan

Hello Ali, you also have passed wrong "id" value in query. You are passing employee id in query and matching with contract "id". It will give wrong wage value too.

Avatar
Ayyappan
Best Answer

Use below code to get wage: In PYTHON file:

_columns = {
    'name': fields.many2one('hr.employee', "Employee", required=True),
    'wage_amt': fields.float('Wage', digits=(16,2), required=True, help="Basic Salary of the employee"),
}

def onchange_employee_id(self, cr, uid, ids, employee_id, context=None):
    v = {}
    if employee_id:
        contract_sr = self.pool.get('hr.contract').search(cr, uid, [('employee_id','=',employee_id)], context=context)
        if contract_sr:
                contract_br = self.pool.get('hr.contract').browse(cr, uid, contract_sr, context=context)[0]
                v['wage_amt'] = contract_br.wage

    return {'value': v}

In XML file:

<field name="name" on_change="onchange_employee_id(name)"/>
<field name="wage_amt"/>
Avatar
Descartar
Ali Abdelmonem Mustafa Amer
Autor

Thanks a Lot It's Working My Friend

Avatar
Serpent Consulting Services Pvt. Ltd.
Best Answer

Hello Ali,

I guess problem is in your query.

Try this:

cr.execute('SELECT wage FROM hr_contract WHERE id in %s', (tuple(emp_id),))
cr.fetchone()

Thanks,

Serpent Consulting Services.

Avatar
Descartar
Ali Abdelmonem Mustafa Amer
Autor

thanks for answer my friend but still give me that (TypeError: 'int' object is not iterable )

Serpent Consulting Services Pvt. Ltd.

Did you try it after restart the server?

Related Posts Respostes Vistes Activitat
modulo no crea tabla en postgresql odoo 17
python postgresql
Avatar
Avatar
Avatar
2
de maig 24
1453
Error Report: Odoo 17 Installation Issue
python postgresql odoo17
Avatar
0
d’ag. 24
1598
i want write a script that when i select table name the related column name of the table is show in the drop down in odoo Solved
python postgresql odoo16features
Avatar
Avatar
1
de març 23
2238
Trying to get manufacturer,(partner name) getting TypeError: string indices must be integers
v8 python postgresql
Avatar
0
de març 15
4985
new python env
python
Avatar
0
de març 25
1189