From 4fb32b831491aa6c3c053281b95cddd495ff1172 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 7 May 2025 08:16:43 +0700
Subject: bf reserve manufacturing order

---
 update_reserved_status_mo.ktr | 201 ++++++++++++++++++++++--------------------
 1 file changed, 105 insertions(+), 96 deletions(-)

(limited to 'update_reserved_status_mo.ktr')

diff --git a/update_reserved_status_mo.ktr b/update_reserved_status_mo.ktr
index 6687abf..7623c4e 100644
--- a/update_reserved_status_mo.ktr
+++ b/update_reserved_status_mo.ktr
@@ -503,6 +503,107 @@
       <enabled>Y</enabled>
     </hop>
   </order>
+  <step>
+    <name>Update</name>
+    <type>Update</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>erp indoteknik production (localhost)</connection>
+    <skip_lookup>N</skip_lookup>
+    <commit>100</commit>
+    <use_batch>N</use_batch>
+    <error_ignored>N</error_ignored>
+    <ignore_flag_field/>
+    <lookup>
+      <schema>public</schema>
+      <table>mrp_production</table>
+      <key>
+        <name>production_id</name>
+        <field>id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>date_reserved</name>
+        <rename>new_date_reserved</rename>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>640</xloc>
+      <yloc>48</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>javascript reserve state</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>var reserve_state = "waiting"
+if(state == "done" &amp;&amp; qty_done > 0){
+	reserve_state = "done"
+}
+else if(state == "cancel"){
+	reserve_state = "cancel"
+}
+else if(qty_reserved-qty_need==0 &amp;&amp; qty_reserved > 0){
+	reserve_state = "ready"
+}
+else{
+	reserve_state = "waiting"
+}</jsScript_script>
+      </jsScript>
+    </jsScripts>
+    <fields>
+      <field>
+        <name>reserve_state</name>
+        <rename>reserve_state</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>336</xloc>
+      <yloc>48</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>outstanding manufacturing order</name>
     <type>TableInput</type>
@@ -770,61 +871,14 @@ if (reserve_state == "ready" || reserve_state == "done"){
 }
 else{
 	new_date_reserved = null
-}</jsScript_script>
-      </jsScript>
-    </jsScripts>
-    <fields>    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>480</xloc>
-      <yloc>48</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>javascript reserve state</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>var reserve_state = "waiting"
-if(state == "done" &amp;&amp; qty_done > 0){
-	reserve_state = "done"
-}
-else if(state == "cancel"){
-	reserve_state = "cancel"
-}
-else if(qty_reserved-qty_need==0 &amp;&amp; qty_reserved > 0){
-	reserve_state = "ready"
-}
-else{
-	reserve_state = "waiting"
 }</jsScript_script>
       </jsScript>
     </jsScripts>
     <fields>
       <field>
-        <name>reserve_state</name>
-        <rename>reserve_state</rename>
-        <type>String</type>
+        <name>new_date_reserved</name>
+        <rename>new_date_reserved</rename>
+        <type>Timestamp</type>
         <length>-1</length>
         <precision>-1</precision>
         <replace>N</replace>
@@ -839,52 +893,7 @@ else{
       </output>
     </remotesteps>
     <GUI>
-      <xloc>336</xloc>
-      <yloc>48</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
-    <name>Update</name>
-    <type>Update</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <skip_lookup>N</skip_lookup>
-    <commit>100</commit>
-    <use_batch>N</use_batch>
-    <error_ignored>N</error_ignored>
-    <ignore_flag_field/>
-    <lookup>
-      <schema>public</schema>
-      <table>mrp_production</table>
-      <key>
-        <name>production_id</name>
-        <field>id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>date_reserved</name>
-        <rename>new_date_reserved</rename>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>640</xloc>
+      <xloc>480</xloc>
       <yloc>48</yloc>
       <draw>Y</draw>
     </GUI>
-- 
cgit v1.2.3