diff options
Diffstat (limited to 'calculate_price_after_disc.ktr')
| -rw-r--r-- | calculate_price_after_disc.ktr | 148 |
1 files changed, 117 insertions, 31 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 06228fc..4a60dab 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -488,11 +488,6 @@ </connection> <order> <hop> - <from>Table input</from> - <to>calculate price after disc</to> - <enabled>Y</enabled> - </hop> - <hop> <from>calculate price after disc</from> <to>calculate price tier</to> <enabled>Y</enabled> @@ -512,6 +507,21 @@ <to>Insert / update</to> <enabled>Y</enabled> </hop> + <hop> + <from>Table input</from> + <to>Filter rows</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>calculate price after disc</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Write to log</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>calculate price after disc</name> @@ -2383,7 +2393,7 @@ left join brand b on b.id = p.brand_id</sql> </output> </remotesteps> <GUI> - <xloc>240</xloc> + <xloc>112</xloc> <yloc>64</yloc> <draw>Y</draw> </GUI> @@ -2807,7 +2817,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff1_1</field_a> <field_b>price_before_disc1</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2822,7 +2832,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff1_2</field_a> <field_b>price_before_disc2</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2837,7 +2847,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff1_3</field_a> <field_b>price_before_disc3</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2852,7 +2862,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff1_4</field_a> <field_b>price_before_disc4</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2867,7 +2877,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff1_5</field_a> <field_b>price_before_disc5</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2882,7 +2892,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff2_1</field_a> <field_b>price_before_disc1</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2897,7 +2907,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff2_2</field_a> <field_b>price_before_disc2</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2912,7 +2922,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff2_3</field_a> <field_b>price_before_disc3</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2927,7 +2937,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff2_4</field_a> <field_b>price_before_disc4</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2942,7 +2952,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff2_5</field_a> <field_b>price_before_disc5</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2957,7 +2967,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff3_1</field_a> <field_b>price_before_disc1</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2972,7 +2982,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff3_2</field_a> <field_b>price_before_disc2</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -2987,7 +2997,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff3_3</field_a> <field_b>price_before_disc3</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3002,7 +3012,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff3_4</field_a> <field_b>price_before_disc4</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3017,7 +3027,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff3_5</field_a> <field_b>price_before_disc5</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3032,7 +3042,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff4_1</field_a> <field_b>price_before_disc1</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3047,7 +3057,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff4_2</field_a> <field_b>price_before_disc2</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3062,7 +3072,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff4_3</field_a> <field_b>price_before_disc3</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3077,7 +3087,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff4_4</field_a> <field_b>price_before_disc4</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3092,7 +3102,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff4_5</field_a> <field_b>price_before_disc5</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3107,7 +3117,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff5_1</field_a> <field_b>price_before_disc1</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3122,7 +3132,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff5_2</field_a> <field_b>price_before_disc2</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3137,7 +3147,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff5_3</field_a> <field_b>price_before_disc3</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3152,7 +3162,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff5_4</field_a> <field_b>price_before_disc4</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3167,7 +3177,7 @@ left join brand b on b.id = p.brand_id</sql> <field_a>diff5_5</field_a> <field_b>price_before_disc5</field_b> <field_c/> - <value_type>None</value_type> + <value_type>Number</value_type> <value_length>-1</value_length> <value_precision>-1</value_precision> <remove>N</remove> @@ -3190,6 +3200,82 @@ left join brand b on b.id = p.brand_id</sql> <draw>Y</draw> </GUI> </step> + <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>calculate price after disc</send_true_to> + <send_false_to>Write to log</send_false_to> + <compare> + <condition> + <negated>N</negated> + <leftvalue>purchase_price</leftvalue> + <function>></function> + <rightvalue/> + <value> + <name>constant</name> + <type>BigNumber</type> + <text>0.0</text> + <length>-1</length> + <precision>-1</precision> + <isnull>N</isnull> + <mask>######0.0###################;-######0.0###################</mask> + </value> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>240</xloc> + <yloc>64</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Write to log</name> + <type>WriteToLog</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <loglevel>log_level_basic</loglevel> + <displayHeader>Y</displayHeader> + <limitRows>N</limitRows> + <limitRowsNumber>0</limitRowsNumber> + <logmessage/> + <fields> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>176</xloc> + <yloc>192</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |