From 777684cd8c82576b0cbb9c445ecc029e340c732c Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 20 Mar 2024 13:19:14 +0700
Subject: update pricelist

---
 run_calculate_pricelist_odoo.kjb           | 76 +++++++++++++++---------------
 update_brand_vendor_purchase_pricelist.ktr | 14 +++---
 update_count_trx_odoo.ktr                  |  8 +++-
 3 files changed, 51 insertions(+), 47 deletions(-)

diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb
index a49e48a..3b89f21 100644
--- a/run_calculate_pricelist_odoo.kjb
+++ b/run_calculate_pricelist_odoo.kjb
@@ -460,7 +460,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>880</xloc>
+      <xloc>1072</xloc>
       <yloc>96</yloc>
       <attributes_kjc/>
     </entry>
@@ -499,7 +499,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>1072</xloc>
+      <xloc>1248</xloc>
       <yloc>96</yloc>
       <attributes_kjc/>
     </entry>
@@ -538,8 +538,8 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>1248</xloc>
-      <yloc>96</yloc>
+      <xloc>1072</xloc>
+      <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
     <entry>
@@ -577,7 +577,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>1248</xloc>
+      <xloc>928</xloc>
       <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
@@ -616,7 +616,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>1072</xloc>
+      <xloc>768</xloc>
       <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
@@ -655,7 +655,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>880</xloc>
+      <xloc>592</xloc>
       <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
@@ -694,7 +694,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>656</xloc>
+      <xloc>384</xloc>
       <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
@@ -733,7 +733,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>464</xloc>
+      <xloc>192</xloc>
       <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
@@ -772,8 +772,8 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>288</xloc>
-      <yloc>240</yloc>
+      <xloc>192</xloc>
+      <yloc>384</yloc>
       <attributes_kjc/>
     </entry>
     <entry>
@@ -811,8 +811,8 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>112</xloc>
-      <yloc>240</yloc>
+      <xloc>384</xloc>
+      <yloc>384</yloc>
       <attributes_kjc/>
     </entry>
     <entry>
@@ -850,7 +850,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>112</xloc>
+      <xloc>544</xloc>
       <yloc>384</yloc>
       <attributes_kjc/>
     </entry>
@@ -928,7 +928,7 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>288</xloc>
+      <xloc>704</xloc>
       <yloc>384</yloc>
       <attributes_kjc/>
     </entry>
@@ -967,8 +967,8 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>496</xloc>
-      <yloc>384</yloc>
+      <xloc>864</xloc>
+      <yloc>96</yloc>
       <attributes_kjc/>
     </entry>
     <entry>
@@ -1006,8 +1006,8 @@
       <parallel>N</parallel>
       <draw>Y</draw>
       <nr>0</nr>
-      <xloc>720</xloc>
-      <yloc>384</yloc>
+      <xloc>1248</xloc>
+      <yloc>240</yloc>
       <attributes_kjc/>
     </entry>
   </entries>
@@ -1030,15 +1030,6 @@
       <evaluation>Y</evaluation>
       <unconditional>N</unconditional>
     </hop>
-    <hop>
-      <from>import purchase order</from>
-      <to>import purchase pricelist</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
     <hop>
       <from>import purchase pricelist</from>
       <to>import price group</to>
@@ -1048,15 +1039,6 @@
       <evaluation>Y</evaluation>
       <unconditional>N</unconditional>
     </hop>
-    <hop>
-      <from>import price group</from>
-      <to>count product</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
     <hop>
       <from>count product</from>
       <to>count vendor</to>
@@ -1157,7 +1139,16 @@
       <unconditional>N</unconditional>
     </hop>
     <hop>
-      <from>update count trx odoo</from>
+      <from>update brand vendor purchase pricelist</from>
+      <to>count product</to>
+      <from_nr>0</from_nr>
+      <to_nr>0</to_nr>
+      <enabled>Y</enabled>
+      <evaluation>Y</evaluation>
+      <unconditional>N</unconditional>
+    </hop>
+    <hop>
+      <from>import purchase order</from>
       <to>update brand purchase pricelist</to>
       <from_nr>0</from_nr>
       <to_nr>0</to_nr>
@@ -1167,6 +1158,15 @@
     </hop>
     <hop>
       <from>update brand purchase pricelist</from>
+      <to>import purchase pricelist</to>
+      <from_nr>0</from_nr>
+      <to_nr>0</to_nr>
+      <enabled>Y</enabled>
+      <evaluation>Y</evaluation>
+      <unconditional>N</unconditional>
+    </hop>
+    <hop>
+      <from>import price group</from>
       <to>update brand vendor purchase pricelist</to>
       <from_nr>0</from_nr>
       <to_nr>0</to_nr>
diff --git a/update_brand_vendor_purchase_pricelist.ktr b/update_brand_vendor_purchase_pricelist.ktr
index e46b67e..5575661 100644
--- a/update_brand_vendor_purchase_pricelist.ktr
+++ b/update_brand_vendor_purchase_pricelist.ktr
@@ -430,17 +430,17 @@
     <created_date>2024/03/19 14:40:57.019</created_date>
     <modified_user>-</modified_user>
     <modified_date>2024/03/19 14:40:57.019</modified_date>
-    <key_for_session_key/>
+    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
     <is_key_private>N</is_key_private>
   </info>
   <notepads>
   </notepads>
   <connection>
-    <name>erp indoteknik production (localhost)</name>
-    <server>10.148.0.3</server>
+    <name>dw bi indoteknik (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>erp_indoteknik</database>
+    <database>dw_bi_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
     <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
@@ -504,9 +504,9 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pp.brand_id, pp.vendor_id, count(*) as count_brand_vendor
-from purchase_pricelist pp
+from purchase_pricelist_dw pp
 where pp.brand_id is not null
 group by pp.brand_id, pp.vendor_id</sql>
     <limit>0</limit>
@@ -611,7 +611,7 @@ group by pp.brand_id, pp.vendor_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <skip_lookup>N</skip_lookup>
     <commit>100</commit>
     <use_batch>N</use_batch>
diff --git a/update_count_trx_odoo.ktr b/update_count_trx_odoo.ktr
index 62f0d97..d212413 100644
--- a/update_count_trx_odoo.ktr
+++ b/update_count_trx_odoo.ktr
@@ -430,7 +430,7 @@
     <created_date>2023/10/21 10:18:07.701</created_date>
     <modified_user>-</modified_user>
     <modified_date>2023/10/21 10:18:07.701</modified_date>
-    <key_for_session_key/>
+    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
     <is_key_private>N</is_key_private>
   </info>
   <notepads>
@@ -556,7 +556,7 @@
       <schema_name/>
     </partitioning>
     <connection>dw bi indoteknik (localhost)</connection>
-    <sql>select id, count_trx_po, count_trx_po_vendor from purchase_pricelist_dw</sql>
+    <sql>select id, count_trx_po, count_trx_po_vendor, count_brand_vendor from purchase_pricelist_dw</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -682,6 +682,10 @@
         <name>count_trx_po_vendor</name>
         <rename>count_trx_po_vendor</rename>
       </value>
+      <value>
+        <name>count_brand_vendor</name>
+        <rename>count_brand_vendor</rename>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
-- 
cgit v1.2.3