From 495141890f516244d7d0b756f3b37b2f2d999105 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 11 Sep 2023 18:37:05 +0700
Subject: recovery 3

---
 import_brand.ktr           | 2 +-
 import_pricelist.ktr       | 2 +-
 import_product_product.ktr | 2 +-
 import_purchase_order.ktr  | 2 +-
 4 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/import_brand.ktr b/import_brand.ktr
index e24b1a4..cc956af 100644
--- a/import_brand.ktr
+++ b/import_brand.ktr
@@ -622,7 +622,7 @@
     <sql>select id, x_name, x_manufacture_level, 
 (select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group
 from x_manufactures xm
---where xm.write_date >= (now() - '15 days'::interval)</sql>
+where xm.write_date >= (now() - '15 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
diff --git a/import_pricelist.ktr b/import_pricelist.ktr
index 16fa89f..a40884a 100644
--- a/import_pricelist.ktr
+++ b/import_pricelist.ktr
@@ -616,7 +616,7 @@
     <connection>erp indoteknik production</connection>
     <sql>select ppi.id, ppi.product_id, ppi.write_date, ppi.fixed_price as price
 from product_pricelist_item ppi where ppi.pricelist_id = 1 
---and ppi.write_date >= (now() - '5 days'::interval)</sql>
+and ppi.write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
diff --git a/import_product_product.ktr b/import_product_product.ktr
index d133eb3..640a1a5 100644
--- a/import_product_product.ktr
+++ b/import_product_product.ktr
@@ -697,7 +697,7 @@ pt.website_description as description,
 pt.weight
 from product_product pp
 join product_template pt on pt.id = pp.product_tmpl_id
---where pp.write_date >= (now() - '5 days'::interval)</sql>
+where pp.write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr
index 03bdb75..ee85cad 100644
--- a/import_purchase_order.ktr
+++ b/import_purchase_order.ktr
@@ -680,7 +680,7 @@ get_quarter(to_char(pol.write_date::timestamp with time zone, 'MM'::text))
 from purchase_order po
 join res_partner rp on rp.id = po.partner_id
 join purchase_order_line pol on pol.order_id = po.id
---where pol.write_date >= (now() - '5 days'::interval)</sql>
+where pol.write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
-- 
cgit v1.2.3