diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-11-20 09:33:48 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-11-20 09:33:48 +0700 |
| commit | 88911da7b24709cc7764b2910cb30d52cb4ea4c5 (patch) | |
| tree | 35d9d369f81612aac2ff8a86230ab6884f3241c0 /calculate_status_so.ktr | |
| parent | 53cf22e7d348dc0e8fa58d0ad2ca43dfa3ce99f4 (diff) | |
update reserve status
Diffstat (limited to 'calculate_status_so.ktr')
| -rw-r--r-- | calculate_status_so.ktr | 112 |
1 files changed, 56 insertions, 56 deletions
diff --git a/calculate_status_so.ktr b/calculate_status_so.ktr index 3367b29..6bc84e3 100644 --- a/calculate_status_so.ktr +++ b/calculate_status_so.ktr @@ -430,7 +430,7 @@ <created_date>2024/11/15 11:18:44.951</created_date> <modified_user>-</modified_user> <modified_date>2024/11/15 11:18:44.951</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -499,6 +499,61 @@ </hop> </order> <step> + <name>Modified JavaScript value</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 so_status = "menunggu" +if(qty_so > qty_delivered && qty_delivered > 0){ + so_status = "sebagian" + +} +else if(qty_delivered == 0){ + so_status = "menunggu" +} +else{ + so_status = "terproses" +}</jsScript_script> + </jsScript> + </jsScripts> + <fields> + <field> + <name>so_status</name> + <rename>so_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>352</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -609,61 +664,6 @@ group by so.id</sql> </GUI> </step> <step> - <name>Modified JavaScript value</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 so_status = "menunggu" -if(qty_so > qty_delivered && qty_delivered > 0){ - so_status = "sebagian" - -} -else if(qty_delivered == 0){ - so_status = "menunggu" -} -else{ - so_status = "terproses" -}</jsScript_script> - </jsScript> - </jsScripts> - <fields> - <field> - <name>so_status</name> - <rename>so_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>352</xloc> - <yloc>128</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Update</name> <type>Update</type> <description/> |