initial commit 2

1 files changed, 32 insertions, 0 deletions

diff --git a/addons/hr_recruitment/models/hr_department.py b/addons/hr_recruitment/models/hr_department.py
new file mode 100644
index 00000000..66db1ca3
--- /dev/null
+++ b/addons/hr_recruitment/models/hr_department.py
@@ -0,0 +1,32 @@
+# -*- coding: utf-8 -*-
+
+from odoo import api, fields, models
+
+
+class HrDepartment(models.Model):
+    _inherit = 'hr.department'
+
+    new_applicant_count = fields.Integer(
+        compute='_compute_new_applicant_count', string='New Applicant')
+    new_hired_employee = fields.Integer(
+        compute='_compute_recruitment_stats', string='New Hired Employee')
+    expected_employee = fields.Integer(
+        compute='_compute_recruitment_stats', string='Expected Employee')
+
+    def _compute_new_applicant_count(self):
+        applicant_data = self.env['hr.applicant'].read_group(
+            [('department_id', 'in', self.ids), ('stage_id.sequence', '<=', '1')],
+            ['department_id'], ['department_id'])
+        result = dict((data['department_id'][0], data['department_id_count']) for data in applicant_data)
+        for department in self:
+            department.new_applicant_count = result.get(department.id, 0)
+
+    def _compute_recruitment_stats(self):
+        job_data = self.env['hr.job'].read_group(
+            [('department_id', 'in', self.ids)],
+            ['no_of_hired_employee', 'no_of_recruitment', 'department_id'], ['department_id'])
+        new_emp = dict((data['department_id'][0], data['no_of_hired_employee']) for data in job_data)
+        expected_emp = dict((data['department_id'][0], data['no_of_recruitment']) for data in job_data)
+        for department in self:
+            department.new_hired_employee = new_emp.get(department.id, 0)
+            department.expected_employee = expected_emp.get(department.id, 0)