# Part of Odoo. See LICENSE file for full copyright and licensing details. import json from odoo import fields, models, _ from odoo.osv import expression class Project(models.Model): _inherit = "project.project" purchase_orders_count = fields.Integer('# Purchase Orders', compute='_compute_purchase_orders_count', groups='purchase.group_purchase_user', export_string_translation=False) def _compute_purchase_orders_count(self): purchase_orders_per_project = dict( self.env['purchase.order']._read_group( domain=[ ('project_id', 'in', self.ids), ('order_line', '!=', False), ], groupby=['project_id'], aggregates=['id:array_agg'], ) ) purchase_orders_count_per_project_from_lines = dict( self.env['purchase.order.line']._read_group( domain=[ ('order_id', 'not in', [order_id for values in purchase_orders_per_project.values() for order_id in values]), ('analytic_distribution', 'in', self.account_id.ids), ], groupby=['analytic_distribution'], aggregates=['__count'], ) ) projects_no_account = self.filtered(lambda project: not project.account_id) for project in projects_no_account: project.purchase_orders_count = len(purchase_orders_per_project.get(project, [])) purchase_orders_per_project = {project.account_id.id: len(orders) for project, orders in purchase_orders_per_project.items()} for project in (self - projects_no_account): project.purchase_orders_count = purchase_orders_per_project.get(project.account_id.id, 0) + purchase_orders_count_per_project_from_lines.get(project.account_id.id, 0) # ---------------------------- # Actions # ---------------------------- def action_open_project_purchase_orders(self): purchase_orders = self.env['purchase.order.line'].search([ '|', ('analytic_distribution', 'in', self.account_id.ids), ('order_id.project_id', '=', self.id), ]).order_id action_window = { 'name': self.env._('Purchase Orders'), 'type': 'ir.actions.act_window', 'res_model': 'purchase.order', 'views': [ [False, 'list'], [self.env.ref('purchase.purchase_order_view_kanban_without_dashboard').id, 'kanban'], [False, 'form'], [False, 'calendar'], [False, 'pivot'], [False, 'graph'], [False, 'activity'], ], 'domain': [('id', 'in', purchase_orders.ids)], 'context': { 'default_project_id': self.id, }, 'help': "

%s

%s

" % ( _("No purchase order found. Let's create one."), _("Once you ordered your products from your supplier, confirm your request for quotation and it will turn " "into a purchase order."), ), } if len(purchase_orders) == 1 and not self.env.context.get('from_embedded_action'): action_window['views'] = [[False, 'form']] action_window['res_id'] = purchase_orders.id return action_window def action_profitability_items(self, section_name, domain=None, res_id=False): if section_name == 'purchase_order': action = { 'name': self.env._('Purchase Order Items'), 'type': 'ir.actions.act_window', 'res_model': 'purchase.order.line', 'views': [[False, 'list'], [False, 'form']], 'domain': domain, 'context': { 'create': False, 'edit': False, }, } if res_id: action['res_id'] = res_id if 'views' in action: action['views'] = [ (view_id, view_type) for view_id, view_type in action['views'] if view_type == 'form' ] or [False, 'form'] action['view_mode'] = 'form' return action return super().action_profitability_items(section_name, domain, res_id) # ---------------------------- # Project Updates # ---------------------------- def _get_stat_buttons(self): buttons = super(Project, self)._get_stat_buttons() if self.env.user.has_group('purchase.group_purchase_user'): self_sudo = self.sudo() buttons.append({ 'icon': 'credit-card', 'text': self.env._('Purchase Orders'), 'number': self_sudo.purchase_orders_count, 'action_type': 'object', 'action': 'action_open_project_purchase_orders', 'show': self_sudo.purchase_orders_count > 0, 'sequence': 36, }) return buttons def _get_profitability_aal_domain(self): return expression.AND([ super()._get_profitability_aal_domain(), ['|', ('move_line_id', '=', False), ('move_line_id.purchase_line_id', '=', False)], ]) def _add_purchase_items(self, profitability_items, with_action=True): return False def _get_profitability_labels(self): labels = super()._get_profitability_labels() labels['purchase_order'] = self.env._('Purchase Orders') return labels def _get_profitability_sequence_per_invoice_type(self): sequence_per_invoice_type = super()._get_profitability_sequence_per_invoice_type() sequence_per_invoice_type['purchase_order'] = 10 return sequence_per_invoice_type def _get_profitability_items(self, with_action=True): profitability_items = super()._get_profitability_items(with_action) if self.account_id: invoice_lines = self.env['account.move.line'].sudo().search_fetch([ ('parent_state', 'in', ['draft', 'posted']), ('analytic_distribution', 'in', self.account_id.ids), ('purchase_line_id', '!=', False), ], ['parent_state', 'currency_id', 'price_subtotal', 'analytic_distribution']) purchase_order_line_invoice_line_ids = self._get_already_included_profitability_invoice_line_ids() with_action = with_action and ( self.env.user.has_group('purchase.group_purchase_user') or self.env.user.has_group('account.group_account_invoice') or self.env.user.has_group('account.group_account_readonly') ) if invoice_lines: amount_invoiced = amount_to_invoice = 0.0 purchase_order_line_invoice_line_ids.extend(invoice_lines.ids) for line in invoice_lines: price_subtotal = line.currency_id._convert(line.price_subtotal, self.currency_id, self.company_id) # an analytic account can appear several time in an analytic distribution with different repartition percentage analytic_contribution = sum( percentage for ids, percentage in line.analytic_distribution.items() if str(self.account_id.id) in ids.split(',') ) / 100. cost = price_subtotal * analytic_contribution * (-1 if line.is_refund else 1) if line.parent_state == 'posted': amount_invoiced -= cost else: amount_to_invoice -= cost costs = profitability_items['costs'] section_id = 'purchase_order' purchase_order_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: args = [section_id, [('id', 'in', invoice_lines.purchase_line_id.ids)]] if len(invoice_lines.purchase_line_id) == 1: args.append(invoice_lines.purchase_line_id.id) action = {'name': 'action_profitability_items', 'type': 'object', 'args': json.dumps(args)} purchase_order_costs['action'] = action costs['data'].append(purchase_order_costs) costs['total']['billed'] += amount_invoiced costs['total']['to_bill'] += amount_to_invoice domain = [ ('move_id.move_type', 'in', ['in_invoice', 'in_refund']), ('parent_state', 'in', ['draft', 'posted']), ('price_subtotal', '>', 0), ('id', 'not in', purchase_order_line_invoice_line_ids), ] self._get_costs_items_from_purchase(domain, profitability_items, with_action=with_action) return profitability_items