Se rendre au contenu
Cette question a été signalée
pythondataexpression
2 Réponses
12371 Vues
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
Ignorer
Avatar
Turkesh Patel (tpa)
Meilleure réponse 
<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
Ignorer
Turkesh Patel (tpa)

use >= for >=

saad
Auteur

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)
Meilleure réponse 
    <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
Ignorer
Publications associées Réponses Vues Activité
Python expression doesnt work
python expression automatic-action
Avatar
0
nov. 22
3249
How to import complex excel data (Contact and Subcontact in one line) into Odoo?
python import data odoo19
Avatar
0
sept. 25
1064
Syntax to inout/write text in a field
python expression studio v14
Avatar
Avatar
2
févr. 23
3629
server action many2one insert self?
action python expression serveraction
Avatar
0
mars 24
2064
Multi line Python expression in xml data file? Résolu
python multiple lines expression
Avatar
Avatar
Avatar
3
déc. 19
7564