Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pythondataexpression
2 Odgovori
12345 Prikazi
Avatar
saad

I have created a specific salary rule which the amount computation is based on a complex python expression
My python expression is similar to: 

result = (-200 if contract.wage >= 12000 
else -150 if ((contract.wage >= 9000) and (contract.wage <= 11999))
else -80 if ((contract.wage >= 6000) and (contract.wage <= 8999)) 
else -20 if  ((contract.wage >= 3000) and (contract.wage <= 5999))
else -0)

How can I put this salary rule in a xml data file knowing that '&gt;' and '&lt;' didn't work?

Avatar
Opusti
Avatar
Turkesh Patel (tpa)
Best Answer 
<record id="hr_rule_xyz" model="hr.salary.rule">
    <field name="name">xyz</field>
    <field name="sequence" eval="1"/>
    <field name="code">xyz</field>
    <field name="category_id" ref="hr_payroll.xyz"/>
    <field name="condition_select">none</field>
    <field name="amount_select">code</field>
    <field name="amount_python_compute">result = (-200 if contract.wage &gt;= 12000 else -150 if ((contract.wage &gt;= 9000) and (contract.wage &lt;= 11999)) else -80 if ((contract.wage &gt;= 6000) and (contract.wage &lt;= 8999)) else -20 if  ((contract.wage &gt;= 3000) and (contract.wage &lt;= 5999)) else -0)</field>
</record>
Avatar
Opusti
Turkesh Patel (tpa)

use >= for >=

saad
Avtor

Thank you friends. I used the '<' sign and it get a syntax error as it' interpreted as a tag start. I didn't think to reverse conditional expressions to use '>'.

Turkesh Patel (tpa)

oh yes lt and gt u can use it works..i have been used lt and gt in my answe but it shows < and >

Avatar
Turkesh Patel (tpa)
Best Answer 
    <record id="hr_rule_xyz" model="hr.salary.rule">
        <field name="name">xyz</field>
        <field name="sequence" eval="1"/>
        <field name="code">xyz</field>
        <field name="category_id" ref="hr_payroll.xyz"/>
        <field name="condition_select">none</field>
        <field name="amount_select">code</field>
        <field name="amount_python_compute">result = (-200 if contract.wage >= 12000 else -150 if ((contract.wage >= 9000) and (contract.wage <= 11999)) else -80 if ((contract.wage >= 6000) and (contract.wage <= 8999)) else -20 if  ((contract.wage >= 3000) and (contract.wage <= 5999)) else -0)</field>
    </record>
Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Python expression doesnt work
python expression automatic-action
Avatar
0
nov. 22
3234
How to import complex excel data (Contact and Subcontact in one line) into Odoo?
python import data odoo19
Avatar
0
sep. 25
1057
Syntax to inout/write text in a field
python expression studio v14
Avatar
Avatar
2
feb. 23
3618
server action many2one insert self?
action python expression serveraction
Avatar
0
mar. 24
2064
Multi line Python expression in xml data file? Solved
python multiple lines expression
Avatar
Avatar
Avatar
3
dec. 19
7535