跳至内容
此问题已终结
pythonpostgresql
2 回复
5979 查看
形象
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)"/>

形象
丢弃
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.

形象
Ayyappan
最佳答案

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"/>
形象
丢弃
Ali Abdelmonem Mustafa Amer
编写者

Thanks a Lot It's Working My Friend

形象
Serpent Consulting Services Pvt. Ltd.
最佳答案

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.

形象
丢弃
Ali Abdelmonem Mustafa Amer
编写者

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?

相关帖文 回复 查看 活动
modulo no crea tabla en postgresql odoo 17
python postgresql
形象
形象
形象
2
5月 24
1728
Error Report: Odoo 17 Installation Issue
python postgresql odoo17
形象
0
8月 24
2025
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 已解决
python postgresql odoo16features
形象
形象
1
3月 23
2532
Trying to get manufacturer,(partner name) getting TypeError: string indices must be integers
v8 python postgresql
形象
0
3月 15
5354
new python env
python
形象
0
3月 25
1552