fix error purchasing job

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):