Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.
Module: Project Purchase
Entity: project.project
Compute Method: _compute_purchase_orders_count
| Inputs | Method | Outputs |
|---|---|---|
|
- if not self.analytic_account_id: - self.purchase_orders_count = 0 - return - query = self.env['purchase.order.line']._search([]) - query.add_where( - SQL( - "%s && %s", - [str(account_id) for account_id in self.analytic_account_id.ids], - self.env['purchase.order.line']._query_analytic_accounts(), + 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'], ) ) - query_string, query_param = query.select( - r"""DISTINCT order_id, (regexp_matches(jsonb_object_keys(purchase_order_line.analytic_distribution), '\d+', 'g'))[1]::int as account_id""" + 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'], + ) ) - query_string = f""" - SELECT account_id, count(order_id) FROM - ({query_string}) distribution - GROUP BY account_id - """ - self._cr.execute(query_string, query_param) - data = {res['account_id']: res['count'] for res in self._cr.dictfetchall()} - for project in self: - project.purchase_orders_count = data.get(project.analytic_account_id.id, 0) + 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) |
|
