From ddcbb5d3e4153700dfe88bf6e0c58fb0074eefbb Mon Sep 17 00:00:00 2001
From: FIN-IT_AndriFP <andrifebriyadiputra@gmail.com>
Date: Wed, 17 Dec 2025 13:55:04 +0700
Subject: fix connection db

---
 calculate_leadtime_po_to_mr.ktr | 174 +++++++++++++---------------------------
 1 file changed, 55 insertions(+), 119 deletions(-)

(limited to 'calculate_leadtime_po_to_mr.ktr')

diff --git a/calculate_leadtime_po_to_mr.ktr b/calculate_leadtime_po_to_mr.ktr
index d5c0904..95e6361 100644
--- a/calculate_leadtime_po_to_mr.ktr
+++ b/calculate_leadtime_po_to_mr.ktr
@@ -442,59 +442,8 @@
     <access>Native</access>
     <database>dw_bi_indoteknik</database>
     <port>5432</port>
-    <username>odoo</username>
-    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
-    <servername/>
-    <data_tablespace/>
-    <index_tablespace/>
-    <attributes>
-      <attribute>
-        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
-        <attribute>N</attribute>
-      </attribute>
-      <attribute>
-        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
-        <attribute>N</attribute>
-      </attribute>
-      <attribute>
-        <code>IS_CLUSTERED</code>
-        <attribute>N</attribute>
-      </attribute>
-      <attribute>
-        <code>PORT_NUMBER</code>
-        <attribute>5432</attribute>
-      </attribute>
-      <attribute>
-        <code>PRESERVE_RESERVED_WORD_CASE</code>
-        <attribute>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>QUOTE_ALL_FIELDS</code>
-        <attribute>N</attribute>
-      </attribute>
-      <attribute>
-        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>N</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
-    </attributes>
-  </connection>
-  <connection>
-    <name>dw bi indoteknik (localhost)</name>
-    <server>localhost</server>
-    <type>POSTGRESQL</type>
-    <access>Native</access>
-    <database>dw_bi_indoteknik</database>
-    <port>5432</port>
-    <username>postgres</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10bec3fd89</password>
+    <username>pdi</username>
+    <password>Encrypted 2be989bb20084ca95810197629d9ea18e</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -822,6 +771,59 @@ if (new_po_to_arrival != null) {
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Modified JavaScript value 2</name>
+    <type>ScriptValueMod</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <compatible>N</compatible>
+    <optimizationLevel>9</optimizationLevel>
+    <jsScripts>
+      <jsScript>
+        <jsScript_type>0</jsScript_type>
+        <jsScript_name>Script 1</jsScript_name>
+        <jsScript_script>//Script here
+var po_to_arrival_status = 'not achieve';
+if (new_po_to_arrival &lt;= 48)
+{
+	po_to_arrival_status = 'achieve'
+}
+else{
+	po_to_arrival_status = 'not achieve'
+}
+</jsScript_script>
+      </jsScript>
+    </jsScripts>
+    <fields>
+      <field>
+        <name>po_to_arrival_status</name>
+        <rename>po_to_arrival_status</rename>
+        <type>String</type>
+        <length>-1</length>
+        <precision>-1</precision>
+        <replace>N</replace>
+      </field>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>960</xloc>
+      <yloc>80</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>Select values</name>
     <type>SelectValues</type>
@@ -879,27 +881,21 @@ if (new_po_to_arrival != null) {
     <fields>
       <field>
         <name>po_confirm_date</name>
-        <rename/>
       </field>
       <field>
         <name>received_good_date</name>
-        <rename/>
       </field>
       <field>
         <name>purchase_line_id</name>
-        <rename/>
       </field>
       <field>
         <name>purchase_id</name>
-        <rename/>
       </field>
       <field>
         <name>received_id</name>
-        <rename/>
       </field>
       <field>
         <name>parent_category</name>
-        <rename/>
       </field>
       <select_unspecified>N</select_unspecified>
     </fields>
@@ -931,31 +927,24 @@ if (new_po_to_arrival != null) {
     <fields>
       <field>
         <name>po_confirm_date</name>
-        <rename/>
       </field>
       <field>
         <name>received_good_date</name>
-        <rename/>
       </field>
       <field>
         <name>purchase_line_id</name>
-        <rename/>
       </field>
       <field>
         <name>purchase_id</name>
-        <rename/>
       </field>
       <field>
         <name>new_po_to_arrival</name>
-        <rename/>
       </field>
       <field>
         <name>received_id</name>
-        <rename/>
       </field>
       <field>
         <name>parent_category</name>
-        <rename/>
       </field>
       <select_unspecified>N</select_unspecified>
     </fields>
@@ -1565,59 +1554,6 @@ FROM filtered_hours;</sql>
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Modified JavaScript value 2</name>
-    <type>ScriptValueMod</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <compatible>N</compatible>
-    <optimizationLevel>9</optimizationLevel>
-    <jsScripts>
-      <jsScript>
-        <jsScript_type>0</jsScript_type>
-        <jsScript_name>Script 1</jsScript_name>
-        <jsScript_script>//Script here
-var po_to_arrival_status = 'not achieve';
-if (new_po_to_arrival &lt;= 48)
-{
-	po_to_arrival_status = 'achieve'
-}
-else{
-	po_to_arrival_status = 'not achieve'
-}
-</jsScript_script>
-      </jsScript>
-    </jsScripts>
-    <fields>
-      <field>
-        <name>po_to_arrival_status</name>
-        <rename>po_to_arrival_status</rename>
-        <type>String</type>
-        <length>-1</length>
-        <precision>-1</precision>
-        <replace>N</replace>
-      </field>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>960</xloc>
-      <yloc>80</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
-- 
cgit v1.2.3