Skip to Content
This question has been flagged
communitypayrollhr_payroll
2 Replies
1326 Views
Avatar
dagi

if you are using odoo community and you want to calculate your employees salary based on their attendance using python code please refer the below code. 


result =(contract.wage/31) * sum(i.worked_hours for i in employee.attendance_ids)



Happy for improvement comment or if there are any other methods.

Avatar
Discard
Avatar
André Canilho
Best Answer

This looks wrong, or incomplete. 

"employee.attendance_ids" contains ALL attendance data, and I'm sure this is NOT what you want.

You must always filter the data for the current month, or in alternative with an interval of your choice.
Eg: You pay every w week 
or 
When you pay on every 21st of the month, and the remaining days are paid in the next month (on the 21st). 

Possible fix:
Add a filter to the attendance_ids, so you only get the ones in the required interval and not ALL of them.

You can use Check IN to validate the time intervals


Avatar
Discard
Avatar
dagi
Author Best Answer

can you please provide the code for those you pay on monthly and weekly base ? it's good to share it

Avatar
Discard
Related Posts Replies Views Activity
Server action hr.work.entry Solved
payroll hr_payroll
Avatar
Avatar
1
Oct 24
1671
V10 module payroll how to create basic rules as i deleted accidentally Solved
payroll hr_payroll
Avatar
Avatar
1
Feb 22
3463
Payslips: change the quantity field with Python
payroll hr_payroll
Avatar
Avatar
1
Jul 24
7214
Change view in contract to display as Basic instead of wage ?
payroll hr_payroll
Avatar
0
Nov 15
3725
Payroll report error
payroll hr_payroll
Avatar
0
Mar 15
4472