1 files changed, 16 insertions, 0 deletions
diff --git a/addons/hr_expense/models/hr_department.py b/addons/hr_expense/models/hr_department.py
new file mode 100644
index 00000000..9bf09b2b
--- /dev/null
+++ b/addons/hr_expense/models/hr_department.py
@@ -0,0 +1,16 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+
+from odoo import fields, models
+
+
+class HrDepartment(models.Model):
+    _inherit = 'hr.department'
+
+    def _compute_expense_sheets_to_approve(self):
+        expense_sheet_data = self.env['hr.expense.sheet'].read_group([('department_id', 'in', self.ids), ('state', '=', 'submit')], ['department_id'], ['department_id'])
+        result = dict((data['department_id'][0], data['department_id_count']) for data in expense_sheet_data)
+        for department in self:
+            department.expense_sheets_to_approve_count = result.get(department.id, 0)
+
+    expense_sheets_to_approve_count = fields.Integer(compute='_compute_expense_sheets_to_approve', string='Expenses Reports to Approve')