跳至內容
此問題已被標幟
pythonpostgresql
2 回覆
5887 瀏覽次數
頭像
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
1612
Error Report: Odoo 17 Installation Issue
python postgresql odoo17
頭像
0
8月 24
1802
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
2435
Trying to get manufacturer,(partner name) getting TypeError: string indices must be integers
v8 python postgresql
頭像
0
3月 15
5177
new python env
python
頭像
0
3月 25
1380