From 76a5f56f324986a18ced12d01214670fdc18663e Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 18 Sep 2023 13:32:00 +0700 Subject: refactor again --- calculate_price_after_disc.ktr | 16 +- import_all_data_bi_indoteknik.kjb | 432 -------------------------------------- import_brand.ktr | 50 +---- import_price_group.ktr | 206 ++++++++---------- import_product_product.ktr | 93 +------- import_purchase_order.ktr | 50 +---- import_purchase_pricelist.ktr | 50 +---- insert_update_pricelist.ktr | 60 ++---- insert_update_pricelist1.ktr | 58 ++--- insert_update_pricelist2.ktr | 58 ++--- insert_update_pricelist3.ktr | 58 ++--- insert_update_pricelist4.ktr | 58 ++--- insert_update_pricelist5.ktr | 58 ++--- update_count_trx_po_product.ktr | 16 +- update_count_trx_po_vendor.ktr | 16 +- 15 files changed, 226 insertions(+), 1053 deletions(-) diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr index 7b13e71..77feab1 100644 --- a/calculate_price_after_disc.ktr +++ b/calculate_price_after_disc.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -622,7 +622,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -1110,7 +1110,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -1598,7 +1598,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select p.product_id, p.item_code, p.name, b.pricing_group, coalesce((select case diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index 0e4bbd0..25c7ce6 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -800,357 +800,6 @@ 416 - - import brand - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_brand.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 928 - 416 - - - - import pricelist - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_pricelist.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 1152 - 416 - - - - import product - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_product_product.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 1152 - 560 - - - - import purchase order - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_purchase_order.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 928 - 560 - - - - import purchase pricelist - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_purchase_pricelist.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 704 - 560 - - - - import price group - - TRANS - - filename - - /home/stephan/transformation-job-bi/import_price_group.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 480 - 560 - - - - count product - - TRANS - - filename - - /home/stephan/transformation-job-bi/update_count_trx_po_product.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 320 - 560 - - - - count vendor - - TRANS - - filename - - /home/stephan/transformation-job-bi/update_count_trx_po_vendor.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 160 - 560 - - - - calculate pricelist - - TRANS - - filename - - /home/stephan/transformation-job-bi/calculate_price_after_disc.ktr - - N - N - N - N - N - N - - - N - N - Basic - N - - N - Y - N - N - N - Pentaho local - N - - Y - - N - Y - 0 - 160 - 688 - - @@ -1270,87 +919,6 @@ Y N - - import sale order - import brand - 0 - 0 - Y - Y - N - - - import brand - import pricelist - 0 - 0 - Y - Y - N - - - import pricelist - import product - 0 - 0 - Y - Y - N - - - import product - import purchase order - 0 - 0 - Y - Y - N - - - import purchase order - import purchase pricelist - 0 - 0 - Y - Y - N - - - import purchase pricelist - import price group - 0 - 0 - Y - Y - N - - - import price group - count product - 0 - 0 - Y - Y - N - - - count product - count vendor - 0 - 0 - Y - Y - N - - - count vendor - calculate pricelist - 0 - 0 - Y - Y - N - diff --git a/import_brand.ktr b/import_brand.ktr index cc956af..4bbf1a2 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + localhost POSTGRESQL Native erp_indoteknik @@ -499,42 +499,10 @@ - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -555,7 +523,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -618,7 +586,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) 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 diff --git a/import_price_group.ktr b/import_price_group.ktr index 05f5414..8a2460d 100644 --- a/import_price_group.ktr +++ b/import_price_group.ktr @@ -430,20 +430,20 @@ 2023/08/22 09:00:32.267 - 2023/08/22 09:00:32.267 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + localhost POSTGRESQL Native erp_indoteknik @@ -499,42 +499,10 @@ - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -544,6 +512,84 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + price_group_dw
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + pricelist_id + pricelist_id + Y + + + group1 + group1 + Y + + + group2 + group2 + Y + + + group3 + group3 + Y + + + group4 + group4 + Y + + + group5 + group5 + Y + + + + + + + + + + + + 480 + 112 + Y + + Table input TableInput @@ -555,7 +601,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select id, name, pricelist_id, group1, group2, group3, group4, group5 from price_group pg 0 @@ -763,84 +809,6 @@ Y - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik - 100 - N - - public - price_group_dw
- - id - id - = - - - - id - id - N - - - name - name - Y - - - pricelist_id - pricelist_id - Y - - - group1 - group1 - Y - - - group2 - group2 - Y - - - group3 - group3 - Y - - - group4 - group4 - Y - - - group5 - group5 - Y - - - - - - - - - - - - 480 - 112 - Y - - diff --git a/import_product_product.ktr b/import_product_product.ktr index 640a1a5..17c48ef 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + localhost POSTGRESQL Native erp_indoteknik @@ -499,42 +499,10 @@ - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -543,50 +511,7 @@ Insert / update Y - - Insert / update - Execute SQL script - N - - - Execute SQL script - ExecSQL - - Y - - 1 - - none - - - dw bi indoteknik - N - N - N - N - refresh materialized view mv_growth_existing_customer; - N - - - - - - - - - - - - - - - - 576 - 128 - Y - - Insert / update InsertUpdate @@ -598,7 +523,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -686,7 +611,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select pp.id as product_id, pt.id as template_id, pt.name, pp.active, pt.x_manufacture as brand_id, case when pp.default_code is null then pt.default_code else pp.default_code end as item_code, (select name from product_public_category ppc where id in((select replace(left(parent_path, 2), '/', '')::int from product_public_category diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index ee85cad..3d798b4 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + localhost POSTGRESQL Native erp_indoteknik @@ -499,42 +499,10 @@ - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -555,7 +523,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -668,7 +636,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select po.write_date as po_date, pol.write_date as line_date, po.name as documentno, po.state, po.partner_id, rp.name as vendor, pol.product_id, pol.product_uom_qty as qty, pol.price_unit, pol.price_subtotal, pol.id as line_id, diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index e64fd60..1de88f4 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -487,8 +487,8 @@ - erp indoteknik production - 34.101.171.249 + erp indoteknik production (localhost) + localhost POSTGRESQL Native erp_indoteknik @@ -499,42 +499,10 @@ - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -555,7 +523,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) 100 N @@ -638,7 +606,7 @@ none - erp indoteknik production + erp indoteknik production (localhost) select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date, pp.system_price, pp.system_last_update, pp.human_last_update from purchase_pricelist pp diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index f14e7f6..335cd76 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17022 order by product_id 0 @@ -2017,7 +1985,7 @@ order by product_id - 416 + 400 128 Y diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr index 77dc10f..f84c8fe 100644 --- a/insert_update_pricelist1.ktr +++ b/insert_update_pricelist1.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17023 order by product_id 0 diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index dd0f6ea..87064c4 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17024 order by product_id 0 diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index 357db0b..c2981fb 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17025 order by product_id 0 diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr index c8feb72..b5fc7c1 100644 --- a/insert_update_pricelist4.ktr +++ b/insert_update_pricelist4.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17026 order by product_id 0 diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr index e747546..be0b9c1 100644 --- a/insert_update_pricelist5.ktr +++ b/insert_update_pricelist5.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -475,11 +475,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -488,54 +488,22 @@ - erp indoteknik local + erp indoteknik production (localhost) localhost POSTGRESQL Native - indoteknik_20230914 + erp_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 - - FORCE_IDENTIFIERS_TO_LOWERCASE - N - - - FORCE_IDENTIFIERS_TO_UPPERCASE - N - - - IS_CLUSTERED - N - PORT_NUMBER 5432 - - PRESERVE_RESERVED_WORD_CASE - Y - - - QUOTE_ALL_FIELDS - N - - - SUPPORTS_BOOLEAN_DATA_TYPE - Y - - - SUPPORTS_TIMESTAMP_DATA_TYPE - Y - - - USE_POOLING - N - @@ -785,7 +753,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -884,7 +852,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -927,7 +895,7 @@ none - erp indoteknik local + erp indoteknik production (localhost) 100 N @@ -1036,7 +1004,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id none - erp indoteknik local + erp indoteknik production (localhost) select * from product_pricelist_item where pricelist_id = 17027 order by product_id 0 diff --git a/update_count_trx_po_product.ktr b/update_count_trx_po_product.ktr index c9839aa..515f468 100644 --- a/update_count_trx_po_product.ktr +++ b/update_count_trx_po_product.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -509,7 +509,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) N N N @@ -547,7 +547,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pod.product_id, pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod where pod.state = 'done' group by pod.product_id, pod.partner_id @@ -653,7 +653,7 @@ group by pod.product_id, pod.partner_id none - dw bi indoteknik + dw bi indoteknik (localhost) N 100 N diff --git a/update_count_trx_po_vendor.ktr b/update_count_trx_po_vendor.ktr index ab116d9..2dc4f32 100644 --- a/update_count_trx_po_vendor.ktr +++ b/update_count_trx_po_vendor.ktr @@ -436,14 +436,14 @@ - dw bi indoteknik - 192.168.23.5 + dw bi indoteknik (localhost) + localhost POSTGRESQL Native dw_bi_indoteknik 5432 odoo - Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -474,11 +474,11 @@ SUPPORTS_BOOLEAN_DATA_TYPE - Y + N SUPPORTS_TIMESTAMP_DATA_TYPE - Y + N USE_POOLING @@ -509,7 +509,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) N N N @@ -547,7 +547,7 @@ none - dw bi indoteknik + dw bi indoteknik (localhost) select pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod where pod.state = 'done' group by pod.partner_id @@ -630,7 +630,7 @@ group by pod.partner_id none - dw bi indoteknik + dw bi indoteknik (localhost) N 100 N -- cgit v1.2.3