Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.

Module: Point of Sale - Coupons & Loyalty

Entity: loyalty.program

Compute Method: _compute_pos_order_count

View 17.0 View 19.0
Inputs Method Outputs
  • id
query = """
-                 WITH reward_to_orders_count AS (
-                  SELECT reward.id                    AS lr_id,
-                         COUNT(DISTINCT pos_order.id) AS orders_count
-                    FROM pos_order_line line
-                    JOIN pos_order ON line.order_id = pos_order.id
-                    JOIN loyalty_reward reward ON line.reward_id = reward.id
-                GROUP BY lr_id
-               ),
-               program_to_reward AS (
-                  SELECT reward.id  AS reward_id,
-                         program.id AS program_id
-                    FROM loyalty_program program
-                    JOIN loyalty_reward reward ON reward.program_id = program.id
-                   WHERE program.id = ANY (%s)
-               )
-        SELECT program_to_reward.program_id,
-               SUM(reward_to_orders_count.orders_count)
-          FROM program_to_reward
-     LEFT JOIN reward_to_orders_count ON reward_to_orders_count.lr_id = program_to_reward.reward_id
-      GROUP BY program_to_reward.program_id
+             SELECT program.id, SUM(orders_count)
+             FROM loyalty_program program
+                 JOIN loyalty_reward reward ON reward.program_id = program.id
+                 JOIN LATERAL (
+                     SELECT COUNT(DISTINCT orders.id) AS orders_count
+                     FROM pos_order orders
+                         JOIN pos_order_line order_lines ON order_lines.order_id = orders.id
+                         WHERE order_lines.reward_id = reward.id
+                 ) agg ON TRUE
+                 WHERE program.id = ANY(%s)
+                     GROUP BY program.id
                """
- self._cr.execute(query, (self.ids,))
- res = self._cr.dictfetchall()
- res = {k['program_id']: k['sum'] for k in res}
+ self.env.cr.execute(query, (self.ids,))
+ res = self.env.cr.dictfetchall()
+ res = {k['id']: k['sum'] for k in res}
for rec in self:
            rec.pos_order_count = res.get(rec.id) or 0
  • pos_order_count

Back to entity