Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello
I want to get the amount for a specific employee, here's my function when I print the result I get all the sum of the records.
def get_sum(self, ):
for rec in self:
rec._cr.execute("SELECT sum(loan_amount) from hr_loan GROUP BY employee_id")
results = rec.env.cr.fetchall()
result = float(''.join(map(str, results[0])))
print("summmmmmmmmmmmm",result)
return result
Hi,
To fetch the total loan_amount group by employees, you can use the following query:
SELECT SUM(loan_amount)
FROM hr_loan
GROUP BY employee_id;
This will display the results in the following format:
Sum
4687.50
23963.00
750.00
2145.00
3325.00
If you want to fetch the loan_amount for a specific employee, you can add the employee ID in the WHERE condition like this:
SELECT SUM(loan_amount)
FROM hr_loan
WHERE employee_id = 10;
This will display the result like 2145.00.
Regards
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
3
ต.ค. 23
|
8980 | ||
|
|
1
ก.ย. 23
|
3406 | ||
|
2
เม.ย. 23
|
2917 | ||
|
Inherit Element form kanban View
แก้ไขแล้ว
|
|
1
มี.ค. 23
|
2308 | |
|
|
0
มี.ค. 23
|
1427 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
