filter purchase price below or equal 0

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>&gt;</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>