From aa815b5a4d4f915f553f4ff122b06084868f4aa9 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Thu, 14 Sep 2023 17:10:57 +0700 Subject: revise name --- calculate_price_after_disc.ktr | 5436 ++++++++++++++++++++-------------------- insert_update_discount.ktr | 2 +- insert_update_pricelist.ktr | 2 +- insert_update_tier4.ktr | 4 +- insert_update_tier5.ktr | 4 +- 5 files changed, 2724 insertions(+), 2724 deletions(-) diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index d96c01e..7b13e71 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -529,8 +529,8 @@ - calculate price after disc - Calculator + Add constants + Constant Y @@ -539,82 +539,20 @@ none - Y - - price_after_disc_1 - PERCENT_3 - purchase_price - markup_std1 - - Number - -1 - -1 - N - - - - - - - price_after_disc_2 - PERCENT_3 - purchase_price - markup_std2 - - Number - -1 - -1 - N - - - - - - - price_after_disc_3 - PERCENT_3 - purchase_price - markup_std3 - - Number - -1 - -1 - N - - - - - - - price_after_disc_4 - PERCENT_3 - purchase_price - markup_std4 - - Number - -1 - -1 - N - - - - - - - price_after_disc_5 - PERCENT_3 - purchase_price - markup_std5 - - Number - -1 - -1 - N - - - - - + + + zero + Number + + + + + 0 + -1 + -1 + N + + @@ -624,14 +562,58 @@ - 384 + 240 + 192 + Y + + + + Filter rows + FilterRows + + Y + + 1 + + none + + + calculate price after disc + Add constants + + + N + purchase_price + > + + + constant + BigNumber + 0.0 + -1 + -1 + N + ######0.0###################;-######0.0################### + + + + + + + + + + + + + 240 64 Y - calculate price tier - Calculator + Insert / update + InsertUpdate Y @@ -640,2640 +622,469 @@ none - Y - - price_before_disc1 - PERCENT_3 - price_after_disc_1 - markup_group1 - - Number - -1 - -1 - N - - - - - - - price_before_disc2 - PERCENT_3 - price_after_disc_2 - markup_group2 - - Number - -1 - -1 - N - - - - - - - price_before_disc3 - PERCENT_3 - price_after_disc_3 - markup_group3 - - Number - -1 - -1 - N - - - - - - - price_before_disc4 - PERCENT_3 - price_after_disc_4 - markup_group4 - - Number - -1 - -1 - N - - - - - - - price_before_disc5 - PERCENT_3 - price_after_disc_5 - markup_group5 - - Number - -1 - -1 - N - - - - - - - price_tier2_1 - PERCENT_3 - purchase_price - markup_tier2_1 - - Number - -1 - -1 - N - - - - - - - price_tier2_2 - PERCENT_3 - purchase_price - markup_tier2_2 - - Number - -1 - -1 - N - - - - - - - price_tier2_3 - PERCENT_3 - purchase_price - markup_tier2_3 - - Number - -1 - -1 - N - - - - - - - price_tier2_4 - PERCENT_3 - purchase_price - markup_tier2_4 - - Number - -1 - -1 - N - - - - - - - price_tier2_5 - PERCENT_3 - purchase_price - markup_tier2_5 - - Number - -1 - -1 - N - - - - - - - price_tier3_1 - PERCENT_3 - purchase_price - markup_tier3_1 - - Number - -1 - -1 - N - - - - - - - price_tier3_2 - PERCENT_3 - purchase_price - markup_tier3_2 - - Number - -1 - -1 - N - - - - - - - price_tier3_3 - PERCENT_3 - purchase_price - markup_tier3_3 - - Number - -1 - -1 - N - - - - - - - price_tier3_4 - PERCENT_3 - purchase_price - markup_tier3_4 - - Number - -1 - -1 - N - - - - - - - price_tier3_5 - PERCENT_3 - purchase_price - markup_tier3_5 - - Number - -1 - -1 - N - - - - - - - price_tier4_1 - PERCENT_3 - purchase_price - markup_tier4_1 - - Number - -1 - -1 - N - - - - - - - price_tier4_2 - PERCENT_3 - purchase_price - markup_tier4_2 - - Number - -1 - -1 - N - - - - - - - price_tier4_3 - PERCENT_3 - purchase_price - markup_tier4_3 - - Number - -1 - -1 - N - - - - - - - price_tier4_4 - PERCENT_3 - purchase_price - markup_tier4_4 - - Number - -1 - -1 - N - - - - - - - price_tier4_5 - PERCENT_3 - purchase_price - markup_tier4_5 - - Number - -1 - -1 - N - - - - - - - price_tier5_1 - PERCENT_3 - purchase_price - markup_tier5_1 - - Number - -1 - -1 - N - - - - - - - price_tier5_2 - PERCENT_3 - purchase_price - markup_tier5_2 - - Number - -1 - -1 - N - - - - - - - price_tier5_3 - PERCENT_3 - purchase_price - markup_tier5_3 - - Number - -1 - -1 - N - - - - - - - price_tier5_4 - PERCENT_3 - purchase_price - markup_tier5_4 - - Number - -1 - -1 - N - - - - - - - price_tier5_5 - PERCENT_3 - purchase_price - markup_tier5_5 - - Number - -1 - -1 - N - - - - - - - - - - - - - - - 544 - 64 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - pricelist_compute
- - product_id - product_id - = - - - - product_id - product_id - N - - - item_code - item_code - Y - - - name - name - Y - - - pricing_group - pricing_group - Y - - - purchase_price - purchase_price - Y - - - markup_std1 - markup_std1 - Y - - - markup_std2 - markup_std2 - Y - - - markup_std3 - markup_std3 - Y - - - markup_std4 - markup_std4 - Y - - - markup_std5 - markup_std5 - Y - - - markup_group1 - markup_group1 - Y - - - markup_group2 - markup_group2 - Y - - - markup_group3 - markup_group3 - Y - - - markup_group4 - markup_group4 - Y - - - markup_group5 - markup_group5 - Y - - - markup_tier2_1 - markup_tier2_1 - Y - - - markup_tier2_2 - markup_tier2_2 - Y - - - markup_tier2_3 - markup_tier2_3 - Y - - - markup_tier2_4 - markup_tier2_4 - Y - - - markup_tier2_5 - markup_tier2_5 - Y - - - markup_tier3_1 - markup_tier3_1 - Y - - - markup_tier3_2 - markup_tier3_2 - Y - - - markup_tier3_3 - markup_tier3_3 - Y - - - markup_tier3_4 - markup_tier3_4 - Y - - - markup_tier3_5 - markup_tier3_5 - Y - - - markup_tier4_1 - markup_tier4_1 - Y - - - markup_tier4_2 - markup_tier4_2 - Y - - - markup_tier4_3 - markup_tier4_3 - Y - - - markup_tier4_4 - markup_tier4_4 - Y - - - markup_tier4_5 - markup_tier4_5 - Y - - - markup_tier5_1 - markup_tier5_1 - Y - - - markup_tier5_2 - markup_tier5_2 - Y - - - markup_tier5_3 - markup_tier5_3 - Y - - - markup_tier5_4 - markup_tier5_4 - Y - - - markup_tier5_5 - markup_tier5_5 - Y - - - price_after_disc_1 - price_after_disc_1 - Y - - - price_after_disc_2 - price_after_disc_2 - Y - - - price_after_disc_3 - price_after_disc_3 - Y - - - price_after_disc_4 - price_after_disc_4 - Y - - - price_after_disc_5 - price_after_disc_5 - Y - - - price_before_disc1 - price_before_disc1 - Y - - - price_before_disc2 - price_before_disc2 - Y - - - price_before_disc3 - price_before_disc3 - Y - - - price_before_disc4 - price_before_disc4 - Y - - - price_before_disc5 - price_before_disc5 - Y - - - price_tier2_1 - price_tier2_1 - Y - - - price_tier2_2 - price_tier2_2 - Y - - - price_tier2_3 - price_tier2_3 - Y - - - price_tier2_4 - price_tier2_4 - Y - - - price_tier2_5 - price_tier2_5 - Y - - - price_tier3_1 - price_tier3_1 - Y - - - price_tier3_2 - price_tier3_2 - Y - - - price_tier3_3 - price_tier3_3 - Y - - - price_tier3_4 - price_tier3_4 - Y - - - price_tier3_5 - price_tier3_5 - Y - - - price_tier4_1 - price_tier4_1 - Y - - - price_tier4_2 - price_tier4_2 - Y - - - price_tier4_3 - price_tier4_3 - Y - - - price_tier4_4 - price_tier4_4 - Y - - - price_tier4_5 - price_tier4_5 - Y - - - price_tier5_1 - price_tier5_1 - Y - - - price_tier5_2 - price_tier5_2 - Y - - - price_tier5_3 - price_tier5_3 - Y - - - price_tier5_4 - price_tier5_4 - Y - - - price_tier5_5 - price_tier5_5 - Y - - - disc1_1 - disc1_1 - Y - - - disc1_2 - disc1_2 - Y - - - disc1_3 - disc1_3 - Y - - - disc1_4 - disc1_4 - Y - - - disc1_5 - disc1_5 - Y - - - disc2_1 - disc2_1 - Y - - - disc2_2 - disc2_2 - Y - - - disc2_3 - disc2_3 - Y - - - disc2_4 - disc2_4 - Y - - - disc2_5 - disc2_5 - Y - - - disc3_1 - disc3_1 - Y - - - disc3_2 - disc3_2 - Y - - - disc3_3 - disc3_3 - Y - - - disc3_4 - disc3_4 - Y - - - disc3_5 - disc3_5 - Y - - - disc4_1 - disc4_1 - Y - - - disc4_2 - disc4_2 - Y - - - disc4_3 - disc4_3 - Y - - - disc4_4 - disc4_4 - Y - - - disc4_5 - disc4_5 - Y - - - disc5_1 - disc5_1 - Y - - - disc5_2 - disc5_2 - Y - - - disc5_3 - disc5_3 - Y - - - disc5_4 - disc5_4 - Y - - - disc5_5 - disc5_5 - Y - - - - - - - - - - - - 736 - 192 - Y - - - - Table input - TableInput - - Y - - 1 - - none - - - dw bi indoteknik - select p.product_id, p.item_code, p.name, b.pricing_group, -coalesce((select - case - when human_last_update is null then coalesce(system_price, 0) - when system_last_update is null then coalesce(product_price, 0) - when system_last_update >= human_last_update then coalesce(system_price, 0) - --when b.pricing_group is null then 0 - else coalesce(product_price, 0) - end as purchase_price - from purchase_pricelist_dw ppd - where ppd.product_id = p.product_id - order by ppd.count_trx_po desc, ppd.count_trx_po_vendor desc - limit 1 -),0) as purchase_price, -(select group1 from price_group_dw pgd where id = 2) as markup_std1, -(select group2 from price_group_dw pgd where id = 2) as markup_std2, -(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 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 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 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 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 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 -from product p -left join brand b on b.id = p.brand_id - 0 - - N - N - N - N - - - Integer - normal - product_id - 9 - 0 - Table input - product_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - item_code - 2147483647 - -1 - Table input - item_code - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - name - 2147483647 - -1 - Table input - name - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - pricing_group - 2147483647 - -1 - Table input - pricing_group - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - purchase_price - -1 - -1 - Table input - purchase_price - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std1 - -1 - -1 - Table input - markup_std1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std2 - -1 - -1 - Table input - markup_std2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std3 - -1 - -1 - Table input - markup_std3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std4 - -1 - -1 - Table input - markup_std4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_std5 - -1 - -1 - Table input - markup_std5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_group1 - -1 - -1 - Table input - markup_group1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_group2 - -1 - -1 - Table input - markup_group2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_group3 - -1 - -1 - Table input - markup_group3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_group4 - -1 - -1 - Table input - markup_group4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_group5 - -1 - -1 - Table input - markup_group5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier2_1 - -1 - -1 - Table input - markup_tier2_1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier2_2 - -1 - -1 - Table input - markup_tier2_2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier2_3 - -1 - -1 - Table input - markup_tier2_3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier2_4 - -1 - -1 - Table input - markup_tier2_4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier2_5 - -1 - -1 - Table input - markup_tier2_5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier3_1 - -1 - -1 - Table input - markup_tier3_1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier3_2 - -1 - -1 - Table input - markup_tier3_2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier3_3 - -1 - -1 - Table input - markup_tier3_3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier3_4 - -1 - -1 - Table input - markup_tier3_4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier3_5 - -1 - -1 - Table input - markup_tier3_5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier4_1 - -1 - -1 - Table input - markup_tier4_1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier4_2 - -1 - -1 - Table input - markup_tier4_2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier4_3 - -1 - -1 - Table input - markup_tier4_3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier4_4 - -1 - -1 - Table input - markup_tier4_4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier4_5 - -1 - -1 - Table input - markup_tier4_5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier5_1 - -1 - -1 - Table input - markup_tier5_1 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier5_2 - -1 - -1 - Table input - markup_tier5_2 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier5_3 - -1 - -1 - Table input - markup_tier5_3 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier5_4 - -1 - -1 - Table input - markup_tier5_4 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal - markup_tier5_5 - -1 - -1 - Table input - markup_tier5_5 - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - - - - - - - - - - 112 - 64 - Y - - - - calculate diff - Calculator - - Y - - 1 - - none - - - Y - - diff1_1 - SUBTRACT - price_before_disc1 - price_after_disc_1 - - None - -1 - -1 - N - - - - - - - diff1_2 - SUBTRACT - price_before_disc2 - price_after_disc_2 - - None - -1 - -1 - N - - - - - - - diff1_3 - SUBTRACT - price_before_disc3 - price_after_disc_3 - - None - -1 - -1 - N - - - - - - - diff1_4 - SUBTRACT - price_before_disc4 - price_after_disc_4 - - None - -1 - -1 - N - - - - - - - diff1_5 - SUBTRACT - price_before_disc5 - price_after_disc_5 - - None - -1 - -1 - N - - - - - - - diff2_1 - SUBTRACT - price_before_disc1 - price_tier2_1 - - None - -1 - -1 - N - - - - - - - diff2_2 - SUBTRACT - price_before_disc2 - price_tier2_2 - - None - -1 - -1 - N - - - - - - - diff2_3 - SUBTRACT - price_before_disc3 - price_tier2_3 - - None - -1 - -1 - N - - - - - - - diff2_4 - SUBTRACT - price_before_disc4 - price_tier2_4 - - None - -1 - -1 - N - - - - - - - diff2_5 - SUBTRACT - price_before_disc5 - price_tier2_5 - - None - -1 - -1 - N - - - - - - - diff3_1 - SUBTRACT - price_before_disc1 - price_tier3_1 - - None - -1 - -1 - N - - - - - - - diff3_2 - SUBTRACT - price_before_disc2 - price_tier3_2 - - None - -1 - -1 - N - - - - - - - diff3_3 - SUBTRACT - price_before_disc3 - price_tier3_3 - - None - -1 - -1 - N - - - - - - - diff3_4 - SUBTRACT - price_before_disc4 - price_tier3_4 - - None - -1 - -1 - N - - - - - - - diff3_5 - SUBTRACT - price_before_disc5 - price_tier3_5 - - None - -1 - -1 - N - - - - - - - diff4_1 - SUBTRACT - price_before_disc1 - price_tier4_1 - - None - -1 - -1 - N - - - - - - - diff4_2 - SUBTRACT - price_before_disc2 - price_tier4_2 - - None - -1 - -1 - N - - - - - - - diff4_3 - SUBTRACT - price_before_disc3 - price_tier4_3 - - None - -1 - -1 - N - - - - - - - diff4_4 - SUBTRACT - price_before_disc4 - price_tier4_4 - - None - -1 - -1 - N - - - - - - - diff4_5 - SUBTRACT - price_before_disc5 - price_tier4_5 - - None - -1 - -1 - N - - - - - - - diff5_1 - SUBTRACT - price_before_disc1 - price_tier5_1 - - None - -1 - -1 - N - - - - - - - diff5_2 - SUBTRACT - price_before_disc2 - price_tier5_2 - - None - -1 - -1 - N - - - - - - - diff5_3 - SUBTRACT - price_before_disc3 - price_tier5_3 - - None - -1 - -1 - N - - - - - - - diff5_4 - SUBTRACT - price_before_disc4 - price_tier5_4 - - None - -1 - -1 - N - - - - - - - diff5_5 - SUBTRACT - price_before_disc5 - price_tier5_5 - - None - -1 - -1 - N - - - - - - - - - - - - - - - 384 - 192 - Y - - - - calculate discount - Calculator - - Y - - 1 - - none - - - Y - - disc1_1 - PERCENT_1 - diff1_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc1_2 - PERCENT_1 - diff1_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc1_3 - PERCENT_1 - diff1_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc1_4 - PERCENT_1 - diff1_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc1_5 - PERCENT_1 - diff1_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc2_1 - PERCENT_1 - diff2_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc2_2 - PERCENT_1 - diff2_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc2_3 - PERCENT_1 - diff2_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc2_4 - PERCENT_1 - diff2_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc2_5 - PERCENT_1 - diff2_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc3_1 - PERCENT_1 - diff3_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc3_2 - PERCENT_1 - diff3_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc3_3 - PERCENT_1 - diff3_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc3_4 - PERCENT_1 - diff3_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc3_5 - PERCENT_1 - diff3_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc4_1 - PERCENT_1 - diff4_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc4_2 - PERCENT_1 - diff4_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc4_3 - PERCENT_1 - diff4_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc4_4 - PERCENT_1 - diff4_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc4_5 - PERCENT_1 - diff4_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - disc5_1 - PERCENT_1 - diff5_1 - price_before_disc1 - - Number - -1 - -1 - N - - - - - - - disc5_2 - PERCENT_1 - diff5_2 - price_before_disc2 - - Number - -1 - -1 - N - - - - - - - disc5_3 - PERCENT_1 - diff5_3 - price_before_disc3 - - Number - -1 - -1 - N - - - - - - - disc5_4 - PERCENT_1 - diff5_4 - price_before_disc4 - - Number - -1 - -1 - N - - - - - - - disc5_5 - PERCENT_1 - diff5_5 - price_before_disc5 - - Number - -1 - -1 - N - - - - - - - - - - - - - - - 544 - 192 - Y - - - - Filter rows - FilterRows - - Y - - 1 - - none - - - calculate price after disc - Add constants - - - N - purchase_price - > - - - constant - BigNumber - 0.0 - -1 - -1 - N - ######0.0###################;-######0.0################### - - - - - - - - - - - - - 240 - 64 - Y - - - - Add constants - Constant - - Y - - 1 - - none - - - - - zero - Number - - - - - 0 - -1 - -1 - N - - + dw bi indoteknik + 100 + N + + public + pricelist_compute
+ + product_id + product_id + = + + + + product_id + product_id + N + + + item_code + item_code + Y + + + name + name + Y + + + pricing_group + pricing_group + Y + + + purchase_price + purchase_price + Y + + + markup_std1 + markup_std1 + Y + + + markup_std2 + markup_std2 + Y + + + markup_std3 + markup_std3 + Y + + + markup_std4 + markup_std4 + Y + + + markup_std5 + markup_std5 + Y + + + markup_group1 + markup_group1 + Y + + + markup_group2 + markup_group2 + Y + + + markup_group3 + markup_group3 + Y + + + markup_group4 + markup_group4 + Y + + + markup_group5 + markup_group5 + Y + + + markup_tier2_1 + markup_tier2_1 + Y + + + markup_tier2_2 + markup_tier2_2 + Y + + + markup_tier2_3 + markup_tier2_3 + Y + + + markup_tier2_4 + markup_tier2_4 + Y + + + markup_tier2_5 + markup_tier2_5 + Y + + + markup_tier3_1 + markup_tier3_1 + Y + + + markup_tier3_2 + markup_tier3_2 + Y + + + markup_tier3_3 + markup_tier3_3 + Y + + + markup_tier3_4 + markup_tier3_4 + Y + + + markup_tier3_5 + markup_tier3_5 + Y + + + markup_tier4_1 + markup_tier4_1 + Y + + + markup_tier4_2 + markup_tier4_2 + Y + + + markup_tier4_3 + markup_tier4_3 + Y + + + markup_tier4_4 + markup_tier4_4 + Y + + + markup_tier4_5 + markup_tier4_5 + Y + + + markup_tier5_1 + markup_tier5_1 + Y + + + markup_tier5_2 + markup_tier5_2 + Y + + + markup_tier5_3 + markup_tier5_3 + Y + + + markup_tier5_4 + markup_tier5_4 + Y + + + markup_tier5_5 + markup_tier5_5 + Y + + + price_after_disc_1 + price_after_disc_1 + Y + + + price_after_disc_2 + price_after_disc_2 + Y + + + price_after_disc_3 + price_after_disc_3 + Y + + + price_after_disc_4 + price_after_disc_4 + Y + + + price_after_disc_5 + price_after_disc_5 + Y + + + price_before_disc1 + price_before_disc1 + Y + + + price_before_disc2 + price_before_disc2 + Y + + + price_before_disc3 + price_before_disc3 + Y + + + price_before_disc4 + price_before_disc4 + Y + + + price_before_disc5 + price_before_disc5 + Y + + + price_tier2_1 + price_tier2_1 + Y + + + price_tier2_2 + price_tier2_2 + Y + + + price_tier2_3 + price_tier2_3 + Y + + + price_tier2_4 + price_tier2_4 + Y + + + price_tier2_5 + price_tier2_5 + Y + + + price_tier3_1 + price_tier3_1 + Y + + + price_tier3_2 + price_tier3_2 + Y + + + price_tier3_3 + price_tier3_3 + Y + + + price_tier3_4 + price_tier3_4 + Y + + + price_tier3_5 + price_tier3_5 + Y + + + price_tier4_1 + price_tier4_1 + Y + + + price_tier4_2 + price_tier4_2 + Y + + + price_tier4_3 + price_tier4_3 + Y + + + price_tier4_4 + price_tier4_4 + Y + + + price_tier4_5 + price_tier4_5 + Y + + + price_tier5_1 + price_tier5_1 + Y + + + price_tier5_2 + price_tier5_2 + Y + + + price_tier5_3 + price_tier5_3 + Y + + + price_tier5_4 + price_tier5_4 + Y + + + price_tier5_5 + price_tier5_5 + Y + + + disc1_1 + disc1_1 + Y + + + disc1_2 + disc1_2 + Y + + + disc1_3 + disc1_3 + Y + + + disc1_4 + disc1_4 + Y + + + disc1_5 + disc1_5 + Y + + + disc2_1 + disc2_1 + Y + + + disc2_2 + disc2_2 + Y + + + disc2_3 + disc2_3 + Y + + + disc2_4 + disc2_4 + Y + + + disc2_5 + disc2_5 + Y + + + disc3_1 + disc3_1 + Y + + + disc3_2 + disc3_2 + Y + + + disc3_3 + disc3_3 + Y + + + disc3_4 + disc3_4 + Y + + + disc3_5 + disc3_5 + Y + + + disc4_1 + disc4_1 + Y + + + disc4_2 + disc4_2 + Y + + + disc4_3 + disc4_3 + Y + + + disc4_4 + disc4_4 + Y + + + disc4_5 + disc4_5 + Y + + + disc5_1 + disc5_1 + Y + + + disc5_2 + disc5_2 + Y + + + disc5_3 + disc5_3 + Y + + + disc5_4 + disc5_4 + Y + + + disc5_5 + disc5_5 + Y + + @@ -3283,7 +1094,7 @@ left join brand b on b.id = p.brand_id - 240 + 736 192 Y @@ -3771,8 +1582,2197 @@ left join brand b on b.id = p.brand_id - 240 - 304 + 240 + 304 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select p.product_id, p.item_code, p.name, b.pricing_group, +coalesce((select + case + when human_last_update is null then coalesce(system_price, 0) + when system_last_update is null then coalesce(product_price, 0) + when system_last_update >= human_last_update then coalesce(system_price, 0) + --when b.pricing_group is null then 0 + else coalesce(product_price, 0) + end as purchase_price + from purchase_pricelist_dw ppd + where ppd.product_id = p.product_id + order by ppd.count_trx_po desc, ppd.count_trx_po_vendor desc + limit 1 +),0) as purchase_price, +(select group1 from price_group_dw pgd where id = 2) as markup_std1, +(select group2 from price_group_dw pgd where id = 2) as markup_std2, +(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 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 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 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 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 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 +from product p +left join brand b on b.id = p.brand_id + 0 + + N + N + N + N + + + Integer + normal + product_id + 9 + 0 + Table input + product_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + item_code + 2147483647 + -1 + Table input + item_code + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + name + 2147483647 + -1 + Table input + name + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + pricing_group + 2147483647 + -1 + Table input + pricing_group + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + purchase_price + -1 + -1 + Table input + purchase_price + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_std1 + -1 + -1 + Table input + markup_std1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_std2 + -1 + -1 + Table input + markup_std2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_std3 + -1 + -1 + Table input + markup_std3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_std4 + -1 + -1 + Table input + markup_std4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_std5 + -1 + -1 + Table input + markup_std5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_group1 + -1 + -1 + Table input + markup_group1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_group2 + -1 + -1 + Table input + markup_group2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_group3 + -1 + -1 + Table input + markup_group3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_group4 + -1 + -1 + Table input + markup_group4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_group5 + -1 + -1 + Table input + markup_group5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier2_1 + -1 + -1 + Table input + markup_tier2_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier2_2 + -1 + -1 + Table input + markup_tier2_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier2_3 + -1 + -1 + Table input + markup_tier2_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier2_4 + -1 + -1 + Table input + markup_tier2_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier2_5 + -1 + -1 + Table input + markup_tier2_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier3_1 + -1 + -1 + Table input + markup_tier3_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier3_2 + -1 + -1 + Table input + markup_tier3_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier3_3 + -1 + -1 + Table input + markup_tier3_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier3_4 + -1 + -1 + Table input + markup_tier3_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier3_5 + -1 + -1 + Table input + markup_tier3_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier4_1 + -1 + -1 + Table input + markup_tier4_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier4_2 + -1 + -1 + Table input + markup_tier4_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier4_3 + -1 + -1 + Table input + markup_tier4_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier4_4 + -1 + -1 + Table input + markup_tier4_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier4_5 + -1 + -1 + Table input + markup_tier4_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_1 + -1 + -1 + Table input + markup_tier5_1 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_2 + -1 + -1 + Table input + markup_tier5_2 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_3 + -1 + -1 + Table input + markup_tier5_3 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_4 + -1 + -1 + Table input + markup_tier5_4 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + BigNumber + normal + markup_tier5_5 + -1 + -1 + Table input + markup_tier5_5 + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 112 + 64 + Y + + + + calculate diff + Calculator + + Y + + 1 + + none + + + Y + + diff1_1 + SUBTRACT + price_before_disc1 + price_after_disc_1 + + None + -1 + -1 + N + + + + + + + diff1_2 + SUBTRACT + price_before_disc2 + price_after_disc_2 + + None + -1 + -1 + N + + + + + + + diff1_3 + SUBTRACT + price_before_disc3 + price_after_disc_3 + + None + -1 + -1 + N + + + + + + + diff1_4 + SUBTRACT + price_before_disc4 + price_after_disc_4 + + None + -1 + -1 + N + + + + + + + diff1_5 + SUBTRACT + price_before_disc5 + price_after_disc_5 + + None + -1 + -1 + N + + + + + + + diff2_1 + SUBTRACT + price_before_disc1 + price_tier2_1 + + None + -1 + -1 + N + + + + + + + diff2_2 + SUBTRACT + price_before_disc2 + price_tier2_2 + + None + -1 + -1 + N + + + + + + + diff2_3 + SUBTRACT + price_before_disc3 + price_tier2_3 + + None + -1 + -1 + N + + + + + + + diff2_4 + SUBTRACT + price_before_disc4 + price_tier2_4 + + None + -1 + -1 + N + + + + + + + diff2_5 + SUBTRACT + price_before_disc5 + price_tier2_5 + + None + -1 + -1 + N + + + + + + + diff3_1 + SUBTRACT + price_before_disc1 + price_tier3_1 + + None + -1 + -1 + N + + + + + + + diff3_2 + SUBTRACT + price_before_disc2 + price_tier3_2 + + None + -1 + -1 + N + + + + + + + diff3_3 + SUBTRACT + price_before_disc3 + price_tier3_3 + + None + -1 + -1 + N + + + + + + + diff3_4 + SUBTRACT + price_before_disc4 + price_tier3_4 + + None + -1 + -1 + N + + + + + + + diff3_5 + SUBTRACT + price_before_disc5 + price_tier3_5 + + None + -1 + -1 + N + + + + + + + diff4_1 + SUBTRACT + price_before_disc1 + price_tier4_1 + + None + -1 + -1 + N + + + + + + + diff4_2 + SUBTRACT + price_before_disc2 + price_tier4_2 + + None + -1 + -1 + N + + + + + + + diff4_3 + SUBTRACT + price_before_disc3 + price_tier4_3 + + None + -1 + -1 + N + + + + + + + diff4_4 + SUBTRACT + price_before_disc4 + price_tier4_4 + + None + -1 + -1 + N + + + + + + + diff4_5 + SUBTRACT + price_before_disc5 + price_tier4_5 + + None + -1 + -1 + N + + + + + + + diff5_1 + SUBTRACT + price_before_disc1 + price_tier5_1 + + None + -1 + -1 + N + + + + + + + diff5_2 + SUBTRACT + price_before_disc2 + price_tier5_2 + + None + -1 + -1 + N + + + + + + + diff5_3 + SUBTRACT + price_before_disc3 + price_tier5_3 + + None + -1 + -1 + N + + + + + + + diff5_4 + SUBTRACT + price_before_disc4 + price_tier5_4 + + None + -1 + -1 + N + + + + + + + diff5_5 + SUBTRACT + price_before_disc5 + price_tier5_5 + + None + -1 + -1 + N + + + + + + + + + + + + + + + 384 + 192 + Y + + + + calculate discount + Calculator + + Y + + 1 + + none + + + Y + + disc1_1 + PERCENT_1 + diff1_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc1_2 + PERCENT_1 + diff1_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc1_3 + PERCENT_1 + diff1_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc1_4 + PERCENT_1 + diff1_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc1_5 + PERCENT_1 + diff1_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc2_1 + PERCENT_1 + diff2_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc2_2 + PERCENT_1 + diff2_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc2_3 + PERCENT_1 + diff2_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc2_4 + PERCENT_1 + diff2_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc2_5 + PERCENT_1 + diff2_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc3_1 + PERCENT_1 + diff3_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc3_2 + PERCENT_1 + diff3_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc3_3 + PERCENT_1 + diff3_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc3_4 + PERCENT_1 + diff3_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc3_5 + PERCENT_1 + diff3_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc4_1 + PERCENT_1 + diff4_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc4_2 + PERCENT_1 + diff4_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc4_3 + PERCENT_1 + diff4_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc4_4 + PERCENT_1 + diff4_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc4_5 + PERCENT_1 + diff4_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + disc5_1 + PERCENT_1 + diff5_1 + price_before_disc1 + + Number + -1 + -1 + N + + + + + + + disc5_2 + PERCENT_1 + diff5_2 + price_before_disc2 + + Number + -1 + -1 + N + + + + + + + disc5_3 + PERCENT_1 + diff5_3 + price_before_disc3 + + Number + -1 + -1 + N + + + + + + + disc5_4 + PERCENT_1 + diff5_4 + price_before_disc4 + + Number + -1 + -1 + N + + + + + + + disc5_5 + PERCENT_1 + diff5_5 + price_before_disc5 + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 544 + 192 + Y + + + + calculate price after disc + Calculator + + Y + + 1 + + none + + + Y + + price_after_disc_1 + PERCENT_3 + purchase_price + markup_std1 + + Number + -1 + -1 + N + + + + + + + price_after_disc_2 + PERCENT_3 + purchase_price + markup_std2 + + Number + -1 + -1 + N + + + + + + + price_after_disc_3 + PERCENT_3 + purchase_price + markup_std3 + + Number + -1 + -1 + N + + + + + + + price_after_disc_4 + PERCENT_3 + purchase_price + markup_std4 + + Number + -1 + -1 + N + + + + + + + price_after_disc_5 + PERCENT_3 + purchase_price + markup_std5 + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 384 + 64 + Y + + + + calculate price tier + Calculator + + Y + + 1 + + none + + + Y + + price_before_disc1 + PERCENT_3 + price_after_disc_1 + markup_group1 + + Number + -1 + -1 + N + + + + + + + price_before_disc2 + PERCENT_3 + price_after_disc_2 + markup_group2 + + Number + -1 + -1 + N + + + + + + + price_before_disc3 + PERCENT_3 + price_after_disc_3 + markup_group3 + + Number + -1 + -1 + N + + + + + + + price_before_disc4 + PERCENT_3 + price_after_disc_4 + markup_group4 + + Number + -1 + -1 + N + + + + + + + price_before_disc5 + PERCENT_3 + price_after_disc_5 + markup_group5 + + Number + -1 + -1 + N + + + + + + + price_tier2_1 + PERCENT_3 + purchase_price + markup_tier2_1 + + Number + -1 + -1 + N + + + + + + + price_tier2_2 + PERCENT_3 + purchase_price + markup_tier2_2 + + Number + -1 + -1 + N + + + + + + + price_tier2_3 + PERCENT_3 + purchase_price + markup_tier2_3 + + Number + -1 + -1 + N + + + + + + + price_tier2_4 + PERCENT_3 + purchase_price + markup_tier2_4 + + Number + -1 + -1 + N + + + + + + + price_tier2_5 + PERCENT_3 + purchase_price + markup_tier2_5 + + Number + -1 + -1 + N + + + + + + + price_tier3_1 + PERCENT_3 + purchase_price + markup_tier3_1 + + Number + -1 + -1 + N + + + + + + + price_tier3_2 + PERCENT_3 + purchase_price + markup_tier3_2 + + Number + -1 + -1 + N + + + + + + + price_tier3_3 + PERCENT_3 + purchase_price + markup_tier3_3 + + Number + -1 + -1 + N + + + + + + + price_tier3_4 + PERCENT_3 + purchase_price + markup_tier3_4 + + Number + -1 + -1 + N + + + + + + + price_tier3_5 + PERCENT_3 + purchase_price + markup_tier3_5 + + Number + -1 + -1 + N + + + + + + + price_tier4_1 + PERCENT_3 + purchase_price + markup_tier4_1 + + Number + -1 + -1 + N + + + + + + + price_tier4_2 + PERCENT_3 + purchase_price + markup_tier4_2 + + Number + -1 + -1 + N + + + + + + + price_tier4_3 + PERCENT_3 + purchase_price + markup_tier4_3 + + Number + -1 + -1 + N + + + + + + + price_tier4_4 + PERCENT_3 + purchase_price + markup_tier4_4 + + Number + -1 + -1 + N + + + + + + + price_tier4_5 + PERCENT_3 + purchase_price + markup_tier4_5 + + Number + -1 + -1 + N + + + + + + + price_tier5_1 + PERCENT_3 + purchase_price + markup_tier5_1 + + Number + -1 + -1 + N + + + + + + + price_tier5_2 + PERCENT_3 + purchase_price + markup_tier5_2 + + Number + -1 + -1 + N + + + + + + + price_tier5_3 + PERCENT_3 + purchase_price + markup_tier5_3 + + Number + -1 + -1 + N + + + + + + + price_tier5_4 + PERCENT_3 + purchase_price + markup_tier5_4 + + Number + -1 + -1 + N + + + + + + + price_tier5_5 + PERCENT_3 + purchase_price + markup_tier5_5 + + Number + -1 + -1 + N + + + + + + + + + + + + + + + 544 + 64 Y diff --git a/insert_update_discount.ktr b/insert_update_discount.ktr index 5ee13ea..acc84c7 100644 --- a/insert_update_discount.ktr +++ b/insert_update_discount.ktr @@ -491,7 +491,7 @@ localhost POSTGRESQL Native - indoteknik_20230912 + indoteknik_20230913 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 435b4f5..02d665a 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -491,7 +491,7 @@ localhost POSTGRESQL Native - indoteknik_20230912 + indoteknik_20230913 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 diff --git a/insert_update_tier4.ktr b/insert_update_tier4.ktr index 619946e..fb774d8 100644 --- a/insert_update_tier4.ktr +++ b/insert_update_tier4.ktr @@ -1,7 +1,7 @@ - insert_update_tier5 + insert_update_tier4 @@ -492,7 +492,7 @@ localhost POSTGRESQL Native - indoteknik_20230912 + indoteknik_20230913 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 diff --git a/insert_update_tier5.ktr b/insert_update_tier5.ktr index fb4a0b9..d759ef5 100644 --- a/insert_update_tier5.ktr +++ b/insert_update_tier5.ktr @@ -1,7 +1,7 @@ - insert_update_tier4 + insert_update_tier5 @@ -492,7 +492,7 @@ localhost POSTGRESQL Native - indoteknik_20230912 + indoteknik_20230913 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 -- cgit v1.2.3