Debian Codegraph @

addons/hr_timesheet/report/timesheets_analysis_report.py

raw
1 # -*- coding: utf-8 -*-
2 # Part of Odoo. See LICENSE file for full copyright and licensing details.
3
4 from odoo import api, fields, models
5 from odoo.tools.sql import drop_view_if_exists, SQL
6
7
8 class TimesheetsAnalysisReport(models.Model):
9 _name = 'timesheets.analysis.report'
10 _inherit = ["hr.manager.department.report"]
11 _description = "Timesheets Analysis Report"
12 _auto = False
13
14 name = fields.Char("Description", readonly=True)
15 user_id = fields.Many2one("res.users", string="User", readonly=True)
16 project_id = fields.Many2one("project.project", string="Project", readonly=True)
17 task_id = fields.Many2one("project.task", string="Task", readonly=True)
18 parent_task_id = fields.Many2one("project.task", string="Parent Task", readonly=True)
19 manager_id = fields.Many2one("hr.employee", "Manager", readonly=True)
20 company_id = fields.Many2one("res.company", string="Company", readonly=True)
21 department_id = fields.Many2one("hr.department", string="Department", readonly=True)
22 currency_id = fields.Many2one('res.currency', string="Currency", readonly=True)
23 date = fields.Date("Date", readonly=True)
24 amount = fields.Monetary("Amount", currency_field="currency_id", readonly=True)
25 unit_amount = fields.Float("Time Spent", readonly=True)
26 partner_id = fields.Many2one('res.partner', string="Partner", readonly=True)
27 milestone_id = fields.Many2one('project.milestone', related='task_id.milestone_id')
28 message_partner_ids = fields.Many2many('res.partner', compute='_compute_message_partner_ids',
29 search='_search_message_partner_ids', readonly=True)
30
31 @api.depends('project_id.message_partner_ids', 'task_id.message_partner_ids')
32 def _compute_message_partner_ids(self):
33 for line in self:
34 line.message_partner_ids = line.task_id.message_partner_ids | line.project_id.message_partner_ids
35
36 def _search_message_partner_ids(self, operator, value):
37 return self.env['account.analytic.line']._search_message_partner_ids(operator, value)
38
39 @property
40 def _table_query(self):
41 return "%s %s %s" % (self._select(), self._from(), self._where())
42
43 @api.model
44 def _select(self):
45 return """
46 SELECT
47 A.id AS id,
48 A.name AS name,
49 A.user_id AS user_id,
50 A.project_id AS project_id,
51 A.task_id AS task_id,
52 A.parent_task_id AS parent_task_id,
53 A.employee_id AS employee_id,
54 A.manager_id AS manager_id,
55 A.company_id AS company_id,
56 A.department_id AS department_id,
57 A.currency_id AS currency_id,
58 A.date AS date,
59 A.amount AS amount,
60 A.unit_amount AS unit_amount,
61 A.partner_id AS partner_id
62 """
63
64 @api.model
65 def _from(self):
66 return "FROM account_analytic_line A"
67
68 @api.model
69 def _where(self):
70 return "WHERE A.project_id IS NOT NULL"
71
72 def init(self):
73 drop_view_if_exists(self.env.cr, self._table)
74 self.env.cr.execute(SQL("""CREATE or REPLACE VIEW %s as (%s)""", SQL.identifier(self._table), SQL(self._table_query)))