From 9c2b9c6ef30aa49b9117156e57259a8581cb2660 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Tue, 23 Jan 2024 11:21:53 +0700
Subject: import include price in purchase pricelist

---
 import_purchase_pricelist.ktr | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

(limited to 'import_purchase_pricelist.ktr')

diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr
index 5e869ca..2b9c883 100644
--- a/import_purchase_pricelist.ktr
+++ b/import_purchase_pricelist.ktr
@@ -557,10 +557,10 @@
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
     <sql>select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date,
-pp.system_price, pp.system_last_update, pp.human_last_update
+pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price
 from purchase_pricelist pp
 join res_partner rp on rp.id = pp.vendor_id
-where pp.write_date >= (now() - '10 days'::interval)</sql>
+--where pp.write_date >= (now() - '10 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -858,6 +858,11 @@ where pp.write_date >= (now() - '10 days'::interval)</sql>
         <rename>human_last_update</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>include_price</name>
+        <rename>include_price</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
-- 
cgit v1.2.3