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

View 17.0 View 19.0
Inputs Method Outputs
  • analytic_account_id
  • analytic_account_id.ids
  • analytic_account_id.id
  • account_id
  • account_id.ids
  • account_id.id
- 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)
  • purchase_orders_count

Back to entity