From 0564c4028595d0a6ca66350e6778de454fe5088d Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 18 Sep 2023 15:22:20 +0700
Subject: add base price

---
 insert_update_pricelist1.ktr | 60 ++++++++++++++++++++++++++++++++++++++++++++
 insert_update_pricelist2.ktr | 60 ++++++++++++++++++++++++++++++++++++++++++++
 insert_update_pricelist3.ktr | 60 ++++++++++++++++++++++++++++++++++++++++++++
 insert_update_pricelist4.ktr | 60 ++++++++++++++++++++++++++++++++++++++++++++
 insert_update_pricelist5.ktr | 60 ++++++++++++++++++++++++++++++++++++++++++++
 5 files changed, 300 insertions(+)

diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr
index f84c8fe..cb55534 100644
--- a/insert_update_pricelist1.ktr
+++ b/insert_update_pricelist1.ktr
@@ -547,6 +547,11 @@
       <to>Insert / update 3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Insert / update 3</from>
+      <to>Execute SQL script</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -692,6 +697,18 @@
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
       </field>
+      <field>
+        <name>base_const</name>
+        <type>String</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>list_price</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -826,6 +843,11 @@
         <rename>write_date_1</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1990,6 +2012,44 @@ order by product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Execute SQL script</name>
+    <type>ExecSQL</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <execute_each_row>N</execute_each_row>
+    <single_statement>N</single_statement>
+    <replace_variables>N</replace_variables>
+    <quoteString>N</quoteString>
+    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17023;</sql>
+    <set_params>N</set_params>
+    <insert_field/>
+    <update_field/>
+    <delete_field/>
+    <read_field/>
+    <arguments>
+    </arguments>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1120</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr
index 87064c4..2c8a66c 100644
--- a/insert_update_pricelist2.ktr
+++ b/insert_update_pricelist2.ktr
@@ -547,6 +547,11 @@
       <to>Insert / update 3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Insert / update 3</from>
+      <to>Execute SQL script</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -692,6 +697,18 @@
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
       </field>
+      <field>
+        <name>base</name>
+        <type>String</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>list_price</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -826,6 +843,11 @@
         <rename>write_date_1</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1990,6 +2012,44 @@ order by product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Execute SQL script</name>
+    <type>ExecSQL</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <execute_each_row>N</execute_each_row>
+    <single_statement>N</single_statement>
+    <replace_variables>N</replace_variables>
+    <quoteString>N</quoteString>
+    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17024;</sql>
+    <set_params>N</set_params>
+    <insert_field/>
+    <update_field/>
+    <delete_field/>
+    <read_field/>
+    <arguments>
+    </arguments>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1152</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr
index c2981fb..7de2e7f 100644
--- a/insert_update_pricelist3.ktr
+++ b/insert_update_pricelist3.ktr
@@ -547,6 +547,11 @@
       <to>Insert / update 3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Insert / update 3</from>
+      <to>Execute SQL script</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -692,6 +697,18 @@
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
       </field>
+      <field>
+        <name>base_const</name>
+        <type>String</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>list_price</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -826,6 +843,11 @@
         <rename>write_date_1</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1990,6 +2012,44 @@ order by product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Execute SQL script</name>
+    <type>ExecSQL</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <execute_each_row>N</execute_each_row>
+    <single_statement>N</single_statement>
+    <replace_variables>N</replace_variables>
+    <quoteString>N</quoteString>
+    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17025;</sql>
+    <set_params>N</set_params>
+    <insert_field/>
+    <update_field/>
+    <delete_field/>
+    <read_field/>
+    <arguments>
+    </arguments>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1136</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr
index b5fc7c1..5914e97 100644
--- a/insert_update_pricelist4.ktr
+++ b/insert_update_pricelist4.ktr
@@ -547,6 +547,11 @@
       <to>Insert / update 3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Insert / update 3</from>
+      <to>Execute SQL script</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -692,6 +697,18 @@
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
       </field>
+      <field>
+        <name>base</name>
+        <type>String</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>list_price</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -826,6 +843,11 @@
         <rename>write_date_1</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1990,6 +2012,44 @@ order by product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Execute SQL script</name>
+    <type>ExecSQL</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <execute_each_row>N</execute_each_row>
+    <single_statement>N</single_statement>
+    <replace_variables>N</replace_variables>
+    <quoteString>N</quoteString>
+    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17026;</sql>
+    <set_params>N</set_params>
+    <insert_field/>
+    <update_field/>
+    <delete_field/>
+    <read_field/>
+    <arguments>
+    </arguments>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1152</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr
index be0b9c1..b6c99e3 100644
--- a/insert_update_pricelist5.ktr
+++ b/insert_update_pricelist5.ktr
@@ -547,6 +547,11 @@
       <to>Insert / update 3</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>Insert / update 3</from>
+      <to>Execute SQL script</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -692,6 +697,18 @@
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
       </field>
+      <field>
+        <name>base</name>
+        <type>String</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>list_price</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -826,6 +843,11 @@
         <rename>write_date_1</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>base</name>
+        <rename>base_const</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1990,6 +2012,44 @@ order by product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Execute SQL script</name>
+    <type>ExecSQL</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <execute_each_row>N</execute_each_row>
+    <single_statement>N</single_statement>
+    <replace_variables>N</replace_variables>
+    <quoteString>N</quoteString>
+    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17027;</sql>
+    <set_params>N</set_params>
+    <insert_field/>
+    <update_field/>
+    <delete_field/>
+    <read_field/>
+    <arguments>
+    </arguments>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>1152</xloc>
+      <yloc>272</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
-- 
cgit v1.2.3