From 46742d881f0b2fabfbaaf5e823cea113625dbfa3 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Sun, 1 Oct 2023 16:30:39 +0700 Subject: remake again pricelist --- import_brand.ktr | 128 ++++++++++++------------ import_product_product.ktr | 178 ++++++++++++++++----------------- import_purchase_order.ktr | 228 +++++++++++++++++++++--------------------- import_purchase_pricelist.ktr | 168 +++++++++++++++---------------- insert_update_pricelist.ktr | 134 ++++++++++++------------- insert_update_pricelist1.ktr | 176 ++++++++++++++++---------------- insert_update_pricelist2.ktr | 176 ++++++++++++++++---------------- insert_update_pricelist3.ktr | 176 ++++++++++++++++---------------- insert_update_pricelist4.ktr | 176 ++++++++++++++++---------------- insert_update_pricelist5.ktr | 176 ++++++++++++++++---------------- 10 files changed, 858 insertions(+), 858 deletions(-) diff --git a/import_brand.ktr b/import_brand.ktr index 7b0d313..122b864 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -544,69 +544,6 @@ Y - - dw Insert / update brand - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - brand
- - id - id - = - - - - id - id - N - - - name - x_name - Y - - - type - x_manufacture_level - Y - - - parent - parent - Y - - - pricing_group - pricing_group - Y - - - - - - - - - - - - 272 - 96 - Y - - Table input TableInput @@ -622,7 +559,7 @@ select id, x_name, x_manufacture_level, (select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group from x_manufactures xm -where xm.write_date >= (now() - '15 days'::interval) +--where xm.write_date >= (now() - '15 days'::interval) 0 N @@ -760,6 +697,69 @@ where xm.write_date >= (now() - '15 days'::interval) Y + + dw Insert / update brand + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + brand
+ + id + id + = + + + + id + id + N + + + name + x_name + Y + + + type + x_manufacture_level + Y + + + parent + parent + Y + + + pricing_group + pricing_group + Y + + + + + + + + + + + + 272 + 96 + Y + + diff --git a/import_product_product.ktr b/import_product_product.ktr index 8ab3062..c5dbfc6 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -544,94 +544,6 @@ Y - - dw Insert / update product - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - product
- - product_id - product_id - = - - - - product_id - product_id - N - - - template_id - template_id - Y - - - name - name - Y - - - active - active - Y - - - brand_id - brand_id - Y - - - item_code - item_code - Y - - - parent_category - parent_category - Y - - - image - image - Y - - - description - description - Y - - - weight - weight - Y - - - - - - - - - - - - 448 - 128 - Y - - Table input TableInput @@ -654,7 +566,7 @@ pt.website_description as description, pt.weight from product_product pp join product_template pt on pt.id = pp.product_tmpl_id -where pp.write_date >= (now() - '5 days'::interval) +--where pp.write_date >= (now() - '5 days'::interval) 0 N @@ -907,6 +819,94 @@ where pp.write_date >= (now() - '5 days'::interval) Y + + dw Insert / update product + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + product
+ + product_id + product_id + = + + + + product_id + product_id + N + + + template_id + template_id + Y + + + name + name + Y + + + active + active + Y + + + brand_id + brand_id + Y + + + item_code + item_code + Y + + + parent_category + parent_category + Y + + + image + image + Y + + + description + description + Y + + + weight + weight + Y + + + + + + + + + + + + 448 + 128 + Y + + diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index f297a94..e548fbd 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -544,119 +544,6 @@ Y - - dw Insert / update po - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - purchase_order_dw
- - line_id - line_id - = - - - - po_date - po_date - Y - - - line_date - line_date - Y - - - documentno - documentno - Y - - - state - state - Y - - - partner_id - partner_id - Y - - - vendor - vendor - Y - - - product_id - product_id - Y - - - qty - qty - Y - - - price_unit - price_unit - Y - - - price_subtotal - price_subtotal - Y - - - line_id - line_id - N - - - year_month - year_month - Y - - - year_date - year_date - Y - - - month_date - month_date - Y - - - day_date - day_date - Y - - - - - - - - - - - - 432 - 96 - Y - - Table input TableInput @@ -680,7 +567,7 @@ get_quarter(to_char(pol.write_date::timestamp with time zone, 'MM'::text)) from purchase_order po join res_partner rp on rp.id = po.partner_id join purchase_order_line pol on pol.order_id = po.id -where pol.write_date >= (now() - '5 days'::interval) +--where pol.write_date >= (now() - '5 days'::interval) 0 N @@ -1071,6 +958,119 @@ where pol.write_date >= (now() - '5 days'::interval) Y + + dw Insert / update po + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + purchase_order_dw
+ + line_id + line_id + = + + + + po_date + po_date + Y + + + line_date + line_date + Y + + + documentno + documentno + Y + + + state + state + Y + + + partner_id + partner_id + Y + + + vendor + vendor + Y + + + product_id + product_id + Y + + + qty + qty + Y + + + price_unit + price_unit + Y + + + price_subtotal + price_subtotal + Y + + + line_id + line_id + N + + + year_month + year_month + Y + + + year_date + year_date + Y + + + month_date + month_date + Y + + + day_date + day_date + Y + + + + + + + + + + + + 432 + 96 + Y + + diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index 384d7ff..2ab9f29 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -544,89 +544,6 @@ Y - - dw Insert / update purchase pl - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - purchase_pricelist_dw
- - id - id - = - - - - id - id - N - - - product_id - product_id - Y - - - vendor_id - vendor_id - Y - - - vendor - vendor - Y - - - product_price - product_price - Y - - - write_date - write_date - Y - - - system_price - system_price - Y - - - system_last_update - system_last_update - Y - - - human_last_update - human_last_update - Y - - - - - - - - - - - - 512 - 336 - Y - - Table input TableInput @@ -643,7 +560,7 @@ pp.system_price, pp.system_last_update, pp.human_last_update from purchase_pricelist pp join res_partner rp on rp.id = pp.vendor_id -where pp.write_date >= (now() - '10 days'::interval) +--where pp.write_date >= (now() - '10 days'::interval) 0 N @@ -873,6 +790,89 @@ where pp.write_date >= (now() - '10 days'::interval) Y + + dw Insert / update purchase pl + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + purchase_pricelist_dw
+ + id + id + = + + + + id + id + N + + + product_id + product_id + Y + + + vendor_id + vendor_id + Y + + + vendor + vendor + Y + + + product_price + product_price + Y + + + write_date + write_date + Y + + + system_price + system_price + Y + + + system_last_update + system_last_update + Y + + + human_last_update + human_last_update + Y + + + + + + + + + + + + 512 + 336 + Y + + diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 330a5d0..482819a 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -572,12 +572,12 @@ p Insert / update base pl base solr flag pt - Y + N base solr flag pt base solr flag pp - Y + N @@ -787,8 +787,8 @@ - base solr flag pt - InsertUpdate + Merge join + MergeJoin Y @@ -797,24 +797,15 @@ none - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - + LEFT OUTER + price compute + price erp + + product_id + + + product_id + @@ -824,11 +815,43 @@ - 912 + 320 272 Y + + Write to log + WriteToLog + + Y + + 1 + + none + + + log_level_nothing + Y + N + 0 + + + + + + + + + + + + + 464 + 400 + Y + + base solr flag pp InsertUpdate @@ -873,8 +896,8 @@ - Merge join - MergeJoin + base solr flag pt + InsertUpdate Y @@ -883,15 +906,24 @@ none - LEFT OUTER - price compute - price erp - - product_id - - - product_id - + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + @@ -901,43 +933,11 @@ - 320 + 912 272 Y - - Write to log - WriteToLog - - Y - - 1 - - none - - - log_level_nothing - Y - N - 0 - - - - - - - - - - - - - 464 - 400 - Y - - p Insert / update base pl InsertUpdate diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr index d7ab991..660fa8e 100644 --- a/insert_update_pricelist1.ktr +++ b/insert_update_pricelist1.ktr @@ -572,12 +572,12 @@ p Insert / update tier1 pl1 solr flag pt - Y + N pl1 solr flag pt pl1 solr flag pp - Y + N @@ -798,92 +798,6 @@ Y - - pl1 solr flag pt - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 928 - 272 - Y - - - - pl1 solr flag pp - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1120 - 272 - Y - - Merge join MergeJoin @@ -1059,6 +973,92 @@ Y + + pl1 solr flag pp + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 1120 + 272 + Y + + + + pl1 solr flag pt + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 928 + 272 + Y + + price compute TableInput diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index 10bf73c..461b15c 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -572,12 +572,12 @@ p Insert / update tier2 pl2 solr flag pt - Y + N pl2 solr flag pt pl2 solr flag pp - Y + N @@ -798,92 +798,6 @@ Y - - pl2 solr flag pt - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 912 - 272 - Y - - - - pl2 solr flag pp - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1088 - 272 - Y - - Merge join MergeJoin @@ -1059,6 +973,92 @@ Y + + pl2 solr flag pp + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 1088 + 272 + Y + + + + pl2 solr flag pt + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 912 + 272 + Y + + price compute TableInput diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index ec3e954..e1cc183 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -572,12 +572,12 @@ p Insert / update tier3 pl3 solr flag pt - Y + N pl3 solr flag pt pl3 solr flag pp - Y + N @@ -798,92 +798,6 @@ Y - - pl3 solr flag pt - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 912 - 272 - Y - - - - pl3 solr flag pp - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1088 - 272 - Y - - Merge join MergeJoin @@ -1059,6 +973,92 @@ Y + + pl3 solr flag pp + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 1088 + 272 + Y + + + + pl3 solr flag pt + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 912 + 272 + Y + + price compute TableInput diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr index f8d75e6..79f9d0e 100644 --- a/insert_update_pricelist4.ktr +++ b/insert_update_pricelist4.ktr @@ -572,12 +572,12 @@ p Insert / update tier4 pl4 solr flag pt - Y + N pl4 solr flag pt pl4 solr flag pp - Y + N @@ -798,92 +798,6 @@ Y - - pl4 solr flag pt - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 912 - 272 - Y - - - - pl4 solr flag pp - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1088 - 272 - Y - - Merge join MergeJoin @@ -1059,6 +973,92 @@ Y + + pl4 solr flag pp + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 1088 + 272 + Y + + + + pl4 solr flag pt + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 912 + 272 + Y + + price compute TableInput diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr index d06bd59..ae14135 100644 --- a/insert_update_pricelist5.ktr +++ b/insert_update_pricelist5.ktr @@ -572,12 +572,12 @@ p Insert / update tier5 pl5 solr flag pt - Y + N pl5 solr flag pt pl5 solr flag pp - Y + N @@ -798,92 +798,6 @@ Y - - pl5 solr flag pt - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_template
- - template_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 912 - 272 - Y - - - - pl5 solr flag pp - InsertUpdate - - Y - - 1 - - none - - - erp indoteknik production (localhost) - 100 - N - - public - product_product
- - product_id - id - = - - - - solr_flag - solr_flag - Y - - - - - - - - - - - - 1088 - 272 - Y - - Merge join MergeJoin @@ -1059,6 +973,92 @@ Y + + pl5 solr flag pp + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_product
+ + product_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 1088 + 272 + Y + + + + pl5 solr flag pt + InsertUpdate + + Y + + 1 + + none + + + erp indoteknik production (localhost) + 100 + N + + public + product_template
+ + template_id + id + = + + + + solr_flag + solr_flag + Y + + + + + + + + + + + + 912 + 272 + Y + + price compute TableInput -- cgit v1.2.3