# -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. from odoo.exceptions import UserError, ValidationError from odoo import api, fields, models, _ from odoo.osv import expression class AccountAnalyticLine(models.Model): _inherit = 'account.analytic.line' def _default_sale_line_domain(self): domain = super(AccountAnalyticLine, self)._default_sale_line_domain() return expression.OR([domain, [('qty_delivered_method', '=', 'timesheet')]]) timesheet_invoice_type = fields.Selection([ ('billable_time', 'Billed on Timesheets'), ('billable_fixed', 'Billed at a Fixed price'), ('non_billable', 'Non Billable Tasks'), ('timesheet_revenues', 'Timesheet Revenues'), ('service_revenues', 'Service Revenues'), ('other_revenues', 'Other Revenues'), ('other_costs', 'Other Costs')], string="Billable Type", compute='_compute_timesheet_invoice_type', compute_sudo=True, store=True, readonly=True) commercial_partner_id = fields.Many2one('res.partner', compute="_compute_commercial_partner") timesheet_invoice_id = fields.Many2one('account.move', string="Invoice", readonly=True, copy=False, help="Invoice created from the timesheet") so_line = fields.Many2one(compute="_compute_so_line", store=True, readonly=False, domain="[('is_service', '=', True), ('is_expense', '=', False), ('state', 'in', ['sale', 'done']), ('order_partner_id', 'child_of', commercial_partner_id)]") # we needed to store it only in order to be able to groupby in the portal order_id = fields.Many2one(related='so_line.order_id', store=True, readonly=True) is_so_line_edited = fields.Boolean("Is Sales Order Item Manually Edited") @api.depends('project_id.commercial_partner_id', 'task_id.commercial_partner_id') def _compute_commercial_partner(self): for timesheet in self: timesheet.commercial_partner_id = timesheet.task_id.commercial_partner_id or timesheet.project_id.commercial_partner_id # When user edit Sale Order Item(so_line) for timesheet make is_so_line_edited field true @api.onchange('so_line') def _onchange_so_line(self): # TODO: [XBO] remove me in master return @api.depends('so_line.product_id', 'project_id', 'amount') def _compute_timesheet_invoice_type(self): for timesheet in self: if timesheet.project_id: # AAL will be set to False invoice_type = 'non_billable' if not timesheet.so_line else False if timesheet.so_line and timesheet.so_line.product_id.type == 'service': if timesheet.so_line.product_id.invoice_policy == 'delivery': if timesheet.so_line.product_id.service_type == 'timesheet': invoice_type = 'timesheet_revenues' if timesheet.amount > 0 else 'billable_time' else: invoice_type = 'billable_fixed' elif timesheet.so_line.product_id.invoice_policy == 'order': invoice_type = 'billable_fixed' timesheet.timesheet_invoice_type = invoice_type else: if timesheet.so_line and timesheet.so_line.product_id.type == 'service': timesheet.timesheet_invoice_type = 'service_revenues' else: timesheet.timesheet_invoice_type = 'other_revenues' if timesheet.amount >= 0 else 'other_costs' @api.depends('task_id.sale_line_id', 'project_id.sale_line_id', 'employee_id', 'project_id.allow_billable') def _compute_so_line(self): for timesheet in self.filtered(lambda t: not t.is_so_line_edited and t._is_not_billed()): # Get only the timesheets are not yet invoiced timesheet.so_line = timesheet.project_id.allow_billable and timesheet._timesheet_determine_sale_line() @api.depends('timesheet_invoice_id.state') def _compute_partner_id(self): super(AccountAnalyticLine, self.filtered(lambda t: t._is_not_billed()))._compute_partner_id() @api.depends('timesheet_invoice_id.state') def _compute_project_id(self): super(AccountAnalyticLine, self.filtered(lambda t: t._is_not_billed()))._compute_project_id() def _is_not_billed(self): self.ensure_one() return not self.timesheet_invoice_id or self.timesheet_invoice_id.state == 'cancel' def _check_timesheet_can_be_billed(self): return self.so_line in self.project_id.mapped('sale_line_employee_ids.sale_line_id') | self.task_id.sale_line_id | self.project_id.sale_line_id def write(self, values): # prevent to update invoiced timesheets if one line is of type delivery self._check_can_write(values) result = super(AccountAnalyticLine, self).write(values) return result def _check_can_write(self, values): if self.sudo().filtered(lambda aal: aal.so_line.product_id.invoice_policy == "delivery") and self.filtered(lambda t: t.timesheet_invoice_id and t.timesheet_invoice_id.state != 'cancel'): if any(field_name in values for field_name in ['unit_amount', 'employee_id', 'project_id', 'task_id', 'so_line', 'amount', 'date']): raise UserError(_('You cannot modify timesheets that are already invoiced.')) @api.model def _timesheet_preprocess(self, values): # TODO: remove me in master return super()._timesheet_preprocess(values) def _timesheet_determine_sale_line(self): """ Deduce the SO line associated to the timesheet line: 1/ timesheet on task rate: the so line will be the one from the task 2/ timesheet on employee rate task: find the SO line in the map of the project (even for subtask), or fallback on the SO line of the task, or fallback on the one on the project """ self.ensure_one() if not self.task_id: if self.project_id.pricing_type == 'employee_rate': map_entry = self._get_employee_mapping_entry() if map_entry: return map_entry.sale_line_id if self.project_id.sale_line_id: return self.project_id.sale_line_id if self.task_id.allow_billable and self.task_id.sale_line_id: if self.task_id.pricing_type in ('task_rate', 'fixed_rate'): return self.task_id.sale_line_id else: # then pricing_type = 'employee_rate' map_entry = self.project_id.sale_line_employee_ids.filtered( lambda map_entry: map_entry.employee_id == self.employee_id and map_entry.sale_line_id.order_partner_id.commercial_partner_id == self.task_id.commercial_partner_id ) if map_entry: return map_entry.sale_line_id return self.task_id.sale_line_id return False def _timesheet_get_portal_domain(self): """ Only the timesheets with a product invoiced on delivered quantity are concerned. since in ordered quantity, the timesheet quantity is not invoiced, thus there is no meaning of showing invoice with ordered quantity. """ domain = super(AccountAnalyticLine, self)._timesheet_get_portal_domain() return expression.AND([domain, [('timesheet_invoice_type', 'in', ['billable_time', 'non_billable', 'billable_fixed'])]]) @api.model def _timesheet_get_sale_domain(self, order_lines_ids, invoice_ids): if not invoice_ids: return [('so_line', 'in', order_lines_ids.ids)] return [ '|', '&', ('timesheet_invoice_id', 'in', invoice_ids.ids), # TODO : Master: Check if non_billable should be removed ? ('timesheet_invoice_type', 'in', ['billable_time', 'non_billable']), '&', ('timesheet_invoice_type', '=', 'billable_fixed'), ('so_line', 'in', order_lines_ids.ids) ] def _get_timesheets_to_merge(self): res = super(AccountAnalyticLine, self)._get_timesheets_to_merge() return res.filtered(lambda l: not l.timesheet_invoice_id or l.timesheet_invoice_id.state != 'posted') @api.ondelete(at_uninstall=False) def _unlink_except_invoiced(self): if any(line.timesheet_invoice_id and line.timesheet_invoice_id.state == 'posted' for line in self): raise UserError(_('You cannot remove a timesheet that has already been invoiced.')) def _get_employee_mapping_entry(self): self.ensure_one() return self.env['project.sale.line.employee.map'].search([('project_id', '=', self.project_id.id), ('employee_id', '=', self.employee_id.id)]) def _employee_timesheet_cost(self): if self.project_id.pricing_type == 'employee_rate': mapping_entry = self._get_employee_mapping_entry() if mapping_entry: return mapping_entry.cost return super()._employee_timesheet_cost()