Debian Codegraph @

addons/hr_skills/report/hr_employee_skill_report.py

raw
1 # Part of Odoo. See LICENSE file for full copyright and licensing details.
2
3 from odoo import api, fields, models, tools
4
5
6 class HrEmployeeSkillReport(models.BaseModel):
7 _name = 'hr.employee.skill.report'
8 _auto = False
9 _inherit = ["hr.manager.department.report"]
10 _description = 'Employee Skills Report'
11 _order = 'employee_id, level_progress desc'
12
13 company_id = fields.Many2one('res.company', readonly=True)
14 department_id = fields.Many2one('hr.department', readonly=True)
15 job_id = fields.Many2one('hr.job', readonly=True)
16
17 skill_id = fields.Many2one('hr.skill', readonly=True)
18 skill_type_id = fields.Many2one('hr.skill.type', readonly=True)
19 skill_level = fields.Char(readonly=True)
20 level_progress = fields.Float(readonly=True, aggregator='avg')
21 active = fields.Boolean(related='employee_id.active')
22
23 def init(self):
24 tools.drop_view_if_exists(self.env.cr, self._table)
25
26 self.env.cr.execute("""
27 CREATE OR REPLACE VIEW %s AS (
28 SELECT
29 row_number() OVER () AS id,
30 e.id AS employee_id,
31 e.company_id AS company_id,
32 v.department_id AS department_id,
33 v.job_id AS job_id,
34 s.skill_id AS skill_id,
35 s.skill_type_id AS skill_type_id,
36 sl.level_progress / 100.0 AS level_progress,
37 sl.name AS skill_level
38 FROM hr_employee e
39 LEFT JOIN hr_version v ON e.current_version_id = v.id
40 LEFT OUTER JOIN hr_employee_skill s ON e.id = s.employee_id
41 LEFT OUTER JOIN hr_skill_level sl ON sl.id = s.skill_level_id
42 LEFT OUTER JOIN hr_skill_type st ON st.id = sl.skill_type_id
43 WHERE st.active IS True AND st.is_certification IS NOT TRUE AND s.valid_to IS NULL
44 )
45 """ % (self._table, ))
46
47 @api.model
48 def formatted_read_grouping_sets(self, domain, grouping_sets, aggregates=(), *, order=None):
49 # In the pivot view, we don't want the hierarchical naming of department_id (hr.department)
50 self_contexted = self.with_context(hierarchical_naming=False)
51 return super(HrEmployeeSkillReport, self_contexted).formatted_read_grouping_sets(
52 domain, grouping_sets, aggregates, order=order,
53 )