From d70d117e530b3c2aae9e6a646f7e1729adb5acac Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 18 Sep 2023 14:05:32 +0700
Subject: revise

---
 import_product_product.ktr | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/import_product_product.ktr b/import_product_product.ktr
index 17c48ef..e668a86 100644
--- a/import_product_product.ktr
+++ b/import_product_product.ktr
@@ -612,7 +612,7 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select pp.id as product_id, pt.id as template_id, pt.name, pp.active, pt.x_manufacture as brand_id,
+    <sql>select pp.id as product_id, pt.id as template_id, pt.name, pp.active::boolean, pt.x_manufacture as brand_id,
 case when pp.default_code is null then pt.default_code else pp.default_code end as item_code,
 (select name from product_public_category ppc where id in((select replace(left(parent_path, 2), '/', '')::int from product_public_category 
 	where id in(select ppcptr.product_public_category_id from product_public_category_product_template_rel ppcptr 
@@ -870,7 +870,7 @@ where pp.write_date >= (now() - '5 days'::interval)</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>304</xloc>
+      <xloc>288</xloc>
       <yloc>128</yloc>
       <draw>Y</draw>
     </GUI>
-- 
cgit v1.2.3