change import price group

2 files changed, 35 insertions, 2 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 3e205a6..b3ae58c 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -1618,31 +1618,49 @@ coalesce((select
 (select group3 from price_group_dw pgd where id = 2) as markup_std3,
 (select group4 from price_group_dw pgd where id = 2) as markup_std4,
 (select group5 from price_group_dw pgd where id = 2) as markup_std5,
+(select group6 from price_group_dw pgd where id = 2) as markup_std6,
+(select group7 from price_group_dw pgd where id = 2) as markup_std7,
+(select group8 from price_group_dw pgd where id = 2) as markup_std8,
 (select group1 from price_group_dw pgd where id = 1) as markup_group1,
 (select group2 from price_group_dw pgd where id = 1) as markup_group2,
 (select group3 from price_group_dw pgd where id = 1) as markup_group3,
 (select group4 from price_group_dw pgd where id = 1) as markup_group4,
 (select group5 from price_group_dw pgd where id = 1) as markup_group5,
+(select group6 from price_group_dw pgd where id = 1) as markup_group6,
+(select group7 from price_group_dw pgd where id = 1) as markup_group7,
+(select group8 from price_group_dw pgd where id = 1) as markup_group8,
 (select group1 from price_group_dw pgd where id = 3) as markup_tier2_1,
 (select group2 from price_group_dw pgd where id = 3) as markup_tier2_2,
 (select group3 from price_group_dw pgd where id = 3) as markup_tier2_3,
 (select group4 from price_group_dw pgd where id = 3) as markup_tier2_4,
 (select group5 from price_group_dw pgd where id = 3) as markup_tier2_5,
+(select group6 from price_group_dw pgd where id = 3) as markup_tier2_6,
+(select group7 from price_group_dw pgd where id = 3) as markup_tier2_7,
+(select group8 from price_group_dw pgd where id = 3) as markup_tier2_8,
 (select group1 from price_group_dw pgd where id = 4) as markup_tier3_1,
 (select group2 from price_group_dw pgd where id = 4) as markup_tier3_2,
 (select group3 from price_group_dw pgd where id = 4) as markup_tier3_3,
 (select group4 from price_group_dw pgd where id = 4) as markup_tier3_4,
 (select group5 from price_group_dw pgd where id = 4) as markup_tier3_5,
+(select group6 from price_group_dw pgd where id = 4) as markup_tier3_6,
+(select group7 from price_group_dw pgd where id = 4) as markup_tier3_7,
+(select group8 from price_group_dw pgd where id = 4) as markup_tier3_8,
 (select group1 from price_group_dw pgd where id = 5) as markup_tier4_1,
 (select group2 from price_group_dw pgd where id = 5) as markup_tier4_2,
 (select group3 from price_group_dw pgd where id = 5) as markup_tier4_3,
 (select group4 from price_group_dw pgd where id = 5) as markup_tier4_4,
 (select group5 from price_group_dw pgd where id = 5) as markup_tier4_5,
+(select group6 from price_group_dw pgd where id = 5) as markup_tier4_6,
+(select group7 from price_group_dw pgd where id = 5) as markup_tier4_7,
+(select group8 from price_group_dw pgd where id = 5) as markup_tier4_8,
 (select group1 from price_group_dw pgd where id = 6) as markup_tier5_1,
 (select group2 from price_group_dw pgd where id = 6) as markup_tier5_2,
 (select group3 from price_group_dw pgd where id = 6) as markup_tier5_3,
 (select group4 from price_group_dw pgd where id = 6) as markup_tier5_4,
-(select group5 from price_group_dw pgd where id = 6) as markup_tier5_5
+(select group5 from price_group_dw pgd where id = 6) as markup_tier5_5,
+(select group6 from price_group_dw pgd where id = 6) as markup_tier5_6,
+(select group7 from price_group_dw pgd where id = 6) as markup_tier5_7,
+(select group8 from price_group_dw pgd where id = 6) as markup_tier5_8
 from product p
 left join brand b on b.id = p.brand_id</sql>
     <limit>0</limit>
diff --git a/import_price_group.ktr b/import_price_group.ktr
index ab567ae..ff969ce 100644
--- a/import_price_group.ktr
+++ b/import_price_group.ktr
@@ -607,6 +607,21 @@
         <rename>group5</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>group6</name>
+        <rename>group6</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group7</name>
+        <rename>group7</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group8</name>
+        <rename>group8</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -634,7 +649,7 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5 from price_group pg</sql>
+    <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8 from price_group pg</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>