From dc7d4e053f09f2d73087932161b7ccab19cde23f Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Thu, 1 Aug 2024 14:22:14 +0700 Subject: add --- run_calculate_pricelist_odoo.kjb | 22 +- run_single_ktr.sh | 2 +- update_override_vendor_pricelist.ktr | 1377 +++++++++++++++++----------------- 3 files changed, 703 insertions(+), 698 deletions(-) diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb index 4dc2e2f..7bcfca7 100644 --- a/run_calculate_pricelist_odoo.kjb +++ b/run_calculate_pricelist_odoo.kjb @@ -539,7 +539,7 @@ Y 0 1168 - 240 + 192 @@ -616,8 +616,8 @@ N Y 0 - 768 - 240 + 752 + 288 @@ -655,8 +655,8 @@ N Y 0 - 432 - 240 + 448 + 288 @@ -695,7 +695,7 @@ Y 0 272 - 240 + 192 @@ -1046,7 +1046,7 @@ Y 0 320 - 96 + 48 @@ -1084,8 +1084,8 @@ N Y 0 - 912 - 240 + 896 + 192 @@ -1123,8 +1123,8 @@ N Y 0 - 608 - 240 + 624 + 192 diff --git a/run_single_ktr.sh b/run_single_ktr.sh index 385e637..0ff3957 100644 --- a/run_single_ktr.sh +++ b/run_single_ktr.sh @@ -1 +1 @@ -sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/calculate_price_after_disc.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" +sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/update_override_vendor_id.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" diff --git a/update_override_vendor_pricelist.ktr b/update_override_vendor_pricelist.ktr index f8d9d06..0972162 100644 --- a/update_override_vendor_pricelist.ktr +++ b/update_override_vendor_pricelist.ktr @@ -430,7 +430,7 @@ 2024/03/26 08:32:53.103 - 2024/03/26 08:32:53.103 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -518,6 +518,50 @@ Y + + Filter rows + FilterRows + + Y + + 1 + + none + + + calculate price tier + filter override vendor purchase price = 0 + + + N + purchase_price + > + + + constant + BigNumber + 0.0 + -1 + -1 + N + ######0.0###################;-######0.0################### + + + + + + + + + + + + + 352 + 128 + Y + + Table input TableInput @@ -540,6 +584,7 @@ coalesce(( select coalesce(ppd.include_price,0) limit 1 ),0) as purchase_price, rp.name as vendor, +b.override_vendor_id as vendor_id, (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, @@ -1857,689 +1902,8 @@ where b.purchase_price_exist = 'Y' - update purchase pricelist override vendor - Update - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - N - 100 - N - N - - - public - pricelist_compute
- - product_id - product_id - = - - - - item_code - item_code - - - name - name - - - pricing_group - pricing_group - - - purchase_price - purchase_price - - - vendor - vendor - - - markup_std1 - markup_std1 - - - markup_std2 - markup_std2 - - - markup_std3 - markup_std3 - - - markup_std4 - markup_std4 - - - markup_std5 - markup_std5 - - - markup_std6 - markup_std6 - - - markup_std7 - markup_std7 - - - markup_std8 - markup_std8 - - - markup_group1 - markup_group1 - - - markup_group2 - markup_group2 - - - markup_group3 - markup_group3 - - - markup_group4 - markup_group4 - - - markup_group5 - markup_group5 - - - markup_group6 - markup_group6 - - - markup_group7 - markup_group7 - - - markup_group8 - markup_group8 - - - markup_tier2_1 - markup_tier2_1 - - - markup_tier2_2 - markup_tier2_2 - - - markup_tier2_3 - markup_tier2_3 - - - markup_tier2_4 - markup_tier2_4 - - - markup_tier2_5 - markup_tier2_5 - - - markup_tier2_6 - markup_tier2_6 - - - markup_tier2_7 - markup_tier2_7 - - - markup_tier2_8 - markup_tier2_8 - - - markup_tier3_1 - markup_tier3_1 - - - markup_tier3_2 - markup_tier3_2 - - - markup_tier3_3 - markup_tier3_3 - - - markup_tier3_4 - markup_tier3_4 - - - markup_tier3_5 - markup_tier3_5 - - - markup_tier3_6 - markup_tier3_6 - - - markup_tier3_7 - markup_tier3_7 - - - markup_tier3_8 - markup_tier3_8 - - - markup_tier4_1 - markup_tier4_1 - - - markup_tier4_2 - markup_tier4_2 - - - markup_tier4_3 - markup_tier4_3 - - - markup_tier4_4 - markup_tier4_4 - - - markup_tier4_5 - markup_tier4_5 - - - markup_tier4_6 - markup_tier4_6 - - - markup_tier4_7 - markup_tier4_7 - - - markup_tier4_8 - markup_tier4_8 - - - markup_tier5_1 - markup_tier5_1 - - - markup_tier5_2 - markup_tier5_2 - - - markup_tier5_3 - markup_tier5_3 - - - markup_tier5_4 - markup_tier5_4 - - - markup_tier5_5 - markup_tier5_5 - - - markup_tier5_6 - markup_tier5_6 - - - markup_tier5_7 - markup_tier5_7 - - - markup_tier5_8 - markup_tier5_8 - - - price_before_disc1 - price_before_disc1 - - - price_before_disc2 - price_before_disc2 - - - price_before_disc3 - price_before_disc3 - - - price_before_disc4 - price_before_disc4 - - - price_before_disc5 - price_before_disc5 - - - price_before_disc6 - price_before_disc6 - - - price_before_disc7 - price_before_disc7 - - - price_before_disc8 - price_before_disc8 - - - price_after_disc_1 - price_after_disc_1 - - - price_after_disc_2 - price_after_disc_2 - - - price_after_disc_3 - price_after_disc_3 - - - price_after_disc_4 - price_after_disc_4 - - - price_after_disc_5 - price_after_disc_5 - - - price_after_disc_6 - price_after_disc_6 - - - price_after_disc_7 - price_after_disc_7 - - - price_after_disc_8 - price_after_disc_8 - - - price_tier2_1 - price_tier2_1 - - - price_tier2_2 - price_tier2_2 - - - price_tier2_3 - price_tier2_3 - - - price_tier2_4 - price_tier2_4 - - - price_tier2_5 - price_tier2_5 - - - price_tier2_6 - price_tier2_6 - - - price_tier2_7 - price_tier2_7 - - - price_tier2_8 - price_tier2_8 - - - price_tier3_1 - price_tier3_1 - - - price_tier3_2 - price_tier3_2 - - - price_tier3_3 - price_tier3_3 - - - price_tier3_4 - price_tier3_4 - - - price_tier3_5 - price_tier3_5 - - - price_tier3_6 - price_tier3_6 - - - price_tier3_7 - price_tier3_7 - - - price_tier3_8 - price_tier3_8 - - - price_tier4_1 - price_tier4_1 - - - price_tier4_2 - price_tier4_2 - - - price_tier4_3 - price_tier4_3 - - - price_tier4_4 - price_tier4_4 - - - price_tier4_5 - price_tier4_5 - - - price_tier4_6 - price_tier4_6 - - - price_tier4_7 - price_tier4_7 - - - price_tier4_8 - price_tier4_8 - - - price_tier5_1 - price_tier5_1 - - - price_tier5_2 - price_tier5_2 - - - price_tier5_3 - price_tier5_3 - - - price_tier5_4 - price_tier5_4 - - - price_tier5_5 - price_tier5_5 - - - price_tier5_6 - price_tier5_6 - - - price_tier5_7 - price_tier5_7 - - - price_tier5_8 - price_tier5_8 - - - disc1_1 - disc1_1 - - - disc1_2 - disc1_2 - - - disc1_3 - disc1_3 - - - disc1_4 - disc1_4 - - - disc1_5 - disc1_5 - - - disc1_6 - disc1_6 - - - disc1_7 - disc1_7 - - - disc1_8 - disc1_8 - - - disc2_1 - disc2_1 - - - disc2_2 - disc2_2 - - - disc2_3 - disc2_3 - - - disc2_4 - disc2_4 - - - disc2_5 - disc2_5 - - - disc2_6 - disc2_6 - - - disc2_7 - disc2_7 - - - disc2_8 - disc2_8 - - - disc3_1 - disc3_1 - - - disc3_2 - disc3_2 - - - disc3_3 - disc3_3 - - - disc3_4 - disc3_4 - - - disc3_5 - disc3_5 - - - disc3_6 - disc3_6 - - - disc3_7 - disc3_7 - - - disc3_8 - disc3_8 - - - disc4_1 - disc4_1 - - - disc4_2 - disc4_2 - - - disc4_3 - disc4_3 - - - disc4_4 - disc4_4 - - - disc4_5 - disc4_5 - - - disc4_6 - disc4_6 - - - disc4_7 - disc4_7 - - - disc4_8 - disc4_8 - - - disc5_1 - disc5_1 - - - disc5_2 - disc5_2 - - - disc5_3 - disc5_3 - - - disc5_4 - disc5_4 - - - disc5_5 - disc5_5 - - - disc5_6 - disc5_6 - - - disc5_7 - disc5_7 - - - disc5_8 - disc5_8 - - - - - - - - - - - - 928 - 256 - Y - - - - Filter rows - FilterRows - - Y - - 1 - - none - - - calculate price tier - filter override vendor purchase price = 0 - - - N - purchase_price - > - - - constant - BigNumber - 0.0 - -1 - -1 - N - ######0.0###################;-######0.0################### - - - - - - - - - - - - - 352 - 128 - Y - - - - filter override vendor purchase price = 0 - WriteToLog - - Y - - 1 - - none - - - log_level_basic - Y - N - 0 - - - - - - - - - - - - - 352 - 256 - Y - - - - calculate diff - Calculator + calculate diff + Calculator Y @@ -4530,8 +3894,649 @@ where b.purchase_price_exist = 'Y' - 576 - 128 + 576 + 128 + Y + + + + filter override vendor purchase price = 0 + WriteToLog + + Y + + 1 + + none + + + log_level_basic + Y + N + 0 + + + + + + + + + + + + + 352 + 256 + Y + + + + update purchase pricelist override vendor + Update + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + N + 100 + N + N + + + public + pricelist_compute
+ + product_id + product_id + = + + + + item_code + item_code + + + name + name + + + pricing_group + pricing_group + + + purchase_price + purchase_price + + + vendor + vendor + + + markup_std1 + markup_std1 + + + markup_std2 + markup_std2 + + + markup_std3 + markup_std3 + + + markup_std4 + markup_std4 + + + markup_std5 + markup_std5 + + + markup_std6 + markup_std6 + + + markup_std7 + markup_std7 + + + markup_std8 + markup_std8 + + + markup_group1 + markup_group1 + + + markup_group2 + markup_group2 + + + markup_group3 + markup_group3 + + + markup_group4 + markup_group4 + + + markup_group5 + markup_group5 + + + markup_group6 + markup_group6 + + + markup_group7 + markup_group7 + + + markup_group8 + markup_group8 + + + markup_tier2_1 + markup_tier2_1 + + + markup_tier2_2 + markup_tier2_2 + + + markup_tier2_3 + markup_tier2_3 + + + markup_tier2_4 + markup_tier2_4 + + + markup_tier2_5 + markup_tier2_5 + + + markup_tier2_6 + markup_tier2_6 + + + markup_tier2_7 + markup_tier2_7 + + + markup_tier2_8 + markup_tier2_8 + + + markup_tier3_1 + markup_tier3_1 + + + markup_tier3_2 + markup_tier3_2 + + + markup_tier3_3 + markup_tier3_3 + + + markup_tier3_4 + markup_tier3_4 + + + markup_tier3_5 + markup_tier3_5 + + + markup_tier3_6 + markup_tier3_6 + + + markup_tier3_7 + markup_tier3_7 + + + markup_tier3_8 + markup_tier3_8 + + + markup_tier4_1 + markup_tier4_1 + + + markup_tier4_2 + markup_tier4_2 + + + markup_tier4_3 + markup_tier4_3 + + + markup_tier4_4 + markup_tier4_4 + + + markup_tier4_5 + markup_tier4_5 + + + markup_tier4_6 + markup_tier4_6 + + + markup_tier4_7 + markup_tier4_7 + + + markup_tier4_8 + markup_tier4_8 + + + markup_tier5_1 + markup_tier5_1 + + + markup_tier5_2 + markup_tier5_2 + + + markup_tier5_3 + markup_tier5_3 + + + markup_tier5_4 + markup_tier5_4 + + + markup_tier5_5 + markup_tier5_5 + + + markup_tier5_6 + markup_tier5_6 + + + markup_tier5_7 + markup_tier5_7 + + + markup_tier5_8 + markup_tier5_8 + + + price_before_disc1 + price_before_disc1 + + + price_before_disc2 + price_before_disc2 + + + price_before_disc3 + price_before_disc3 + + + price_before_disc4 + price_before_disc4 + + + price_before_disc5 + price_before_disc5 + + + price_before_disc6 + price_before_disc6 + + + price_before_disc7 + price_before_disc7 + + + price_before_disc8 + price_before_disc8 + + + price_after_disc_1 + price_after_disc_1 + + + price_after_disc_2 + price_after_disc_2 + + + price_after_disc_3 + price_after_disc_3 + + + price_after_disc_4 + price_after_disc_4 + + + price_after_disc_5 + price_after_disc_5 + + + price_after_disc_6 + price_after_disc_6 + + + price_after_disc_7 + price_after_disc_7 + + + price_after_disc_8 + price_after_disc_8 + + + price_tier2_1 + price_tier2_1 + + + price_tier2_2 + price_tier2_2 + + + price_tier2_3 + price_tier2_3 + + + price_tier2_4 + price_tier2_4 + + + price_tier2_5 + price_tier2_5 + + + price_tier2_6 + price_tier2_6 + + + price_tier2_7 + price_tier2_7 + + + price_tier2_8 + price_tier2_8 + + + price_tier3_1 + price_tier3_1 + + + price_tier3_2 + price_tier3_2 + + + price_tier3_3 + price_tier3_3 + + + price_tier3_4 + price_tier3_4 + + + price_tier3_5 + price_tier3_5 + + + price_tier3_6 + price_tier3_6 + + + price_tier3_7 + price_tier3_7 + + + price_tier3_8 + price_tier3_8 + + + price_tier4_1 + price_tier4_1 + + + price_tier4_2 + price_tier4_2 + + + price_tier4_3 + price_tier4_3 + + + price_tier4_4 + price_tier4_4 + + + price_tier4_5 + price_tier4_5 + + + price_tier4_6 + price_tier4_6 + + + price_tier4_7 + price_tier4_7 + + + price_tier4_8 + price_tier4_8 + + + price_tier5_1 + price_tier5_1 + + + price_tier5_2 + price_tier5_2 + + + price_tier5_3 + price_tier5_3 + + + price_tier5_4 + price_tier5_4 + + + price_tier5_5 + price_tier5_5 + + + price_tier5_6 + price_tier5_6 + + + price_tier5_7 + price_tier5_7 + + + price_tier5_8 + price_tier5_8 + + + disc1_1 + disc1_1 + + + disc1_2 + disc1_2 + + + disc1_3 + disc1_3 + + + disc1_4 + disc1_4 + + + disc1_5 + disc1_5 + + + disc1_6 + disc1_6 + + + disc1_7 + disc1_7 + + + disc1_8 + disc1_8 + + + disc2_1 + disc2_1 + + + disc2_2 + disc2_2 + + + disc2_3 + disc2_3 + + + disc2_4 + disc2_4 + + + disc2_5 + disc2_5 + + + disc2_6 + disc2_6 + + + disc2_7 + disc2_7 + + + disc2_8 + disc2_8 + + + disc3_1 + disc3_1 + + + disc3_2 + disc3_2 + + + disc3_3 + disc3_3 + + + disc3_4 + disc3_4 + + + disc3_5 + disc3_5 + + + disc3_6 + disc3_6 + + + disc3_7 + disc3_7 + + + disc3_8 + disc3_8 + + + disc4_1 + disc4_1 + + + disc4_2 + disc4_2 + + + disc4_3 + disc4_3 + + + disc4_4 + disc4_4 + + + disc4_5 + disc4_5 + + + disc4_6 + disc4_6 + + + disc4_7 + disc4_7 + + + disc4_8 + disc4_8 + + + disc5_1 + disc5_1 + + + disc5_2 + disc5_2 + + + disc5_3 + disc5_3 + + + disc5_4 + disc5_4 + + + disc5_5 + disc5_5 + + + disc5_6 + disc5_6 + + + disc5_7 + disc5_7 + + + disc5_8 + disc5_8 + + + vendor_id + vendor_id + + + + + + + + + + + + 1024 + 256 Y -- cgit v1.2.3