diff options
Diffstat (limited to 'calculate_leadtime_po_to_mr.ktr')
| -rw-r--r-- | calculate_leadtime_po_to_mr.ktr | 174 |
1 files changed, 55 insertions, 119 deletions
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/> @@ -823,6 +772,59 @@ if (new_po_to_arrival != null) { </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 <= 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> <description/> @@ -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 <= 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> |