diff options
| -rw-r--r-- | indoteknik_custom/models/purchasing_job.py | 34 |
1 files changed, 16 insertions, 18 deletions
diff --git a/indoteknik_custom/models/purchasing_job.py b/indoteknik_custom/models/purchasing_job.py index 27bb1f4e..230c171a 100644 --- a/indoteknik_custom/models/purchasing_job.py +++ b/indoteknik_custom/models/purchasing_job.py @@ -41,24 +41,23 @@ class PurchasingJob(models.Model): } def init(self): - tools.drop_view_if_exists(self.env.cr, self._table) self.env.cr.execute(""" CREATE OR REPLACE VIEW %s AS ( - WITH latest_purchase_orders AS ( - SELECT - pol.product_id, - po.user_id, - ROW_NUMBER() OVER (PARTITION BY pol.product_id ORDER BY po.create_date DESC) AS order_rank - FROM purchase_order po - RIGHT JOIN purchase_order_line pol ON pol.order_id = po.id - LEFT JOIN res_partner rp ON rp.id = po.partner_id - ), - random_user_ids AS ( - SELECT DISTINCT - CASE - WHEN vendor_id = 5571 THEN 27 - WHEN vendor_id = 9688 THEN 397 - WHEN vendor_id = 35475 THEN 397 + WITH latest_purchase_orders AS ( + SELECT + pol.product_id, + po.user_id, + ROW_NUMBER() OVER (PARTITION BY pol.product_id ORDER BY po.create_date DESC) AS order_rank + FROM purchase_order po + RIGHT JOIN purchase_order_line pol ON pol.order_id = po.id + LEFT JOIN res_partner rp ON rp.id = po.partner_id + ), + random_user_ids AS ( + SELECT DISTINCT + CASE + WHEN vendor_id = 5571 THEN 27 + WHEN vendor_id = 9688 THEN 397 + WHEN vendor_id = 35475 THEN 397 WHEN vendor_id = 29712 THEN 397 ELSE (CASE WHEN random() < 0.5 THEN 397 ELSE 1036 END) END AS user_id, @@ -151,8 +150,7 @@ class PurchasingJob(models.Model): pmp.item_code, pmp.product, pmp.action - ) - """ % self._table) + )""" % self._table) def open_form_multi_generate_request_po(self): |