| 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))) |