# Part of Odoo. See LICENSE file for full copyright and licensing details. import json from ast import literal_eval from collections import defaultdict from odoo.osv import expression from odoo import models class Project(models.Model): _inherit = 'project.project' def _add_purchase_items(self, profitability_items, with_action=True): domain = self._get_add_purchase_items_domain() with_action = with_action and ( self.env.user.has_group('account.group_account_invoice') or self.env.user.has_group('account.group_account_readonly') ) self._get_costs_items_from_purchase(domain, profitability_items, with_action=with_action) def _get_add_purchase_items_domain(self): purchase_order_line_invoice_line_ids = self._get_already_included_profitability_invoice_line_ids() return [ ('move_type', 'in', ['in_invoice', 'in_refund']), ('parent_state', 'in', ['draft', 'posted']), ('price_subtotal', '>', 0), ('id', 'not in', purchase_order_line_invoice_line_ids), ] def _get_costs_items_from_purchase(self, domain, profitability_items, with_action=True): """ This method is used in sale_project and project_purchase. Since project_account is the only common module (except project), we create the method here. """ # calculate the cost of bills without a purchase order account_move_lines = self.env['account.move.line'].sudo().search_fetch( domain + [('analytic_distribution', 'in', self.account_id.ids)], ['price_subtotal', 'parent_state', 'currency_id', 'analytic_distribution', 'move_type', 'move_id'], ) if account_move_lines: # Get conversion rate from currencies to currency of the current company amount_invoiced = amount_to_invoice = 0.0 for move_line in account_move_lines: price_subtotal = move_line.currency_id._convert( from_amount=move_line.price_subtotal, to_currency=self.currency_id, ) # an analytic account can appear several time in an analytic distribution with different repartition percentage analytic_contribution = sum( percentage for ids, percentage in move_line.analytic_distribution.items() if str(self.account_id.id) in ids.split(',') ) / 100. if move_line.parent_state == 'draft': if move_line.move_type == 'in_invoice': amount_to_invoice -= price_subtotal * analytic_contribution else: # move_line.move_type == 'in_refund' amount_to_invoice += price_subtotal * analytic_contribution else: # move_line.parent_state == 'posted' if move_line.move_type == 'in_invoice': amount_invoiced -= price_subtotal * analytic_contribution else: # move_line.move_type == 'in_refund' amount_invoiced += price_subtotal * analytic_contribution # don't display the section if the final values are both 0 (bill -> vendor credit) if amount_invoiced != 0 or amount_to_invoice != 0: costs = profitability_items['costs'] section_id = 'other_purchase_costs' bills_costs = { 'id': section_id, 'sequence': self._get_profitability_sequence_per_invoice_type()[section_id], 'billed': amount_invoiced, 'to_bill': amount_to_invoice, } if with_action: bills_costs['action'] = self._get_action_for_profitability_section(account_move_lines.move_id.ids, section_id) costs['data'].append(bills_costs) costs['total']['billed'] += amount_invoiced costs['total']['to_bill'] += amount_to_invoice def _get_action_for_profitability_section(self, record_ids, name): self.ensure_one() args = [name, [('id', 'in', record_ids)]] if len(record_ids) == 1: args.append(record_ids[0]) return {'name': 'action_profitability_items', 'type': 'object', 'args': json.dumps(args)} def _get_profitability_labels(self): return { **super()._get_profitability_labels(), 'other_purchase_costs': self.env._('Vendor Bills'), 'other_revenues_aal': self.env._('Other Revenues'), 'other_costs_aal': self.env._('Other Costs'), } def _get_profitability_sequence_per_invoice_type(self): return { **super()._get_profitability_sequence_per_invoice_type(), 'other_purchase_costs': 11, 'other_revenues_aal': 14, 'other_costs_aal': 15, } def action_profitability_items(self, section_name, domain=None, res_id=False): if section_name in ['other_revenues_aal', 'other_costs_aal', 'other_costs']: action = self.env["ir.actions.actions"]._for_xml_id("analytic.account_analytic_line_action_entries") action['domain'] = domain action['context'] = { 'group_by_date': True, } if res_id: action['views'] = [(False, 'form')] action['view_mode'] = 'form' action['res_id'] = res_id else: pivot_view_id = self.env['ir.model.data']._xmlid_to_res_id('project_account.project_view_account_analytic_line_pivot') graph_view_id = self.env['ir.model.data']._xmlid_to_res_id('project_account.project_view_account_analytic_line_graph') action['views'] = [(pivot_view_id, view_type) if view_type == 'pivot' else (graph_view_id, view_type) if view_type == 'graph' else (view_id, view_type) for (view_id, view_type) in action['views']] return action if section_name == 'other_purchase_costs': action = self.env["ir.actions.actions"]._for_xml_id("account.action_move_in_invoice_type") action['domain'] = domain or [] if res_id: action['views'] = [(False, 'form')] action['view_mode'] = 'form' action['res_id'] = res_id return action return super().action_profitability_items(section_name, domain, res_id) def _get_domain_aal_with_no_move_line(self): """ this method is used in order to overwrite the domain in sale_timesheet module. Since the field 'project_id' is added to the "analytic line" model in the hr_timesheet module, we can't add the condition ('project_id', '=', False) here. """ return [('account_id', '=', self.account_id.id), ('move_line_id', '=', False)] def _get_items_from_aal(self, with_action=True): domain = self._get_domain_aal_with_no_move_line() domain = expression.AND([ domain, [('category', 'not in', ['manufacturing_order', 'picking_entry'])] ]) aal_other_search = self.env['account.analytic.line'].sudo().search_read(domain, ['id', 'amount', 'currency_id']) if not aal_other_search: return { 'revenues': {'data': [], 'total': {'invoiced': 0.0, 'to_invoice': 0.0}}, 'costs': {'data': [], 'total': {'billed': 0.0, 'to_bill': 0.0}}, } # dict of form { company : {costs : float, revenues: float}} dict_amount_per_currency_id = defaultdict(lambda: {'costs': 0.0, 'revenues': 0.0}) set_currency_ids = {self.currency_id.id} cost_ids = [] revenue_ids = [] for aal in aal_other_search: set_currency_ids.add(aal['currency_id'][0]) aal_amount = aal['amount'] if aal_amount < 0.0: dict_amount_per_currency_id[aal['currency_id'][0]]['costs'] += aal_amount cost_ids.append(aal['id']) else: dict_amount_per_currency_id[aal['currency_id'][0]]['revenues'] += aal_amount revenue_ids.append(aal['id']) total_revenues = total_costs = 0.0 for currency_id, dict_amounts in dict_amount_per_currency_id.items(): currency = self.env['res.currency'].browse(currency_id).with_prefetch(dict_amount_per_currency_id) total_revenues += currency._convert(dict_amounts['revenues'], self.currency_id, self.company_id) total_costs += currency._convert(dict_amounts['costs'], self.currency_id, self.company_id) # we dont know what part of the numbers has already been billed or not, so we have no choice but to put everything under the billed/invoiced columns. # The to bill/to invoice ones will simply remain 0 profitability_sequence_per_invoice_type = self._get_profitability_sequence_per_invoice_type() revenues = {'id': 'other_revenues_aal', 'sequence': profitability_sequence_per_invoice_type['other_revenues_aal'], 'invoiced': total_revenues, 'to_invoice': 0.0} costs = {'id': 'other_costs_aal', 'sequence': profitability_sequence_per_invoice_type['other_costs_aal'], 'billed': total_costs, 'to_bill': 0.0} if with_action and self.env.user.has_group('account.group_account_readonly'): costs['action'] = self._get_action_for_profitability_section(cost_ids, 'other_costs_aal') revenues['action'] = self._get_action_for_profitability_section(revenue_ids, 'other_revenues_aal') return { 'revenues': {'data': [revenues], 'total': {'invoiced': total_revenues, 'to_invoice': 0.0}}, 'costs': {'data': [costs], 'total': {'billed': total_costs, 'to_bill': 0.0}}, } def action_open_analytic_items(self): action = self.env['ir.actions.act_window']._for_xml_id('analytic.account_analytic_line_action_entries') action['domain'] = [('account_id', '=', self.account_id.id)] context = literal_eval(action['context']) action['context'] = { **context, 'create': self.env.context.get('from_embedded_action', False), 'default_account_id': self.account_id.id, } return action