From 7880be96b110b68c0c88fd7363f16a2764cd2c31 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Sun, 1 Oct 2023 18:18:19 +0700 Subject: back to original --- import_brand.ktr | 2 +- import_product_product.ktr | 2 +- import_purchase_order.ktr | 2 +- import_purchase_pricelist.ktr | 2 +- insert_update_pricelist.ktr | 4 ++-- insert_update_pricelist1.ktr | 4 ++-- insert_update_pricelist2.ktr | 4 ++-- insert_update_pricelist3.ktr | 4 ++-- insert_update_pricelist4.ktr | 4 ++-- insert_update_pricelist5.ktr | 4 ++-- 10 files changed, 16 insertions(+), 16 deletions(-) diff --git a/import_brand.ktr b/import_brand.ktr index 122b864..1a16fb7 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -559,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 diff --git a/import_product_product.ktr b/import_product_product.ktr index c5dbfc6..0942694 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -566,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 diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index e548fbd..7262513 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -567,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 diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index 2ab9f29..5e869ca 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -560,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 diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 482819a..6ce28c7 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -572,12 +572,12 @@ p Insert / update base pl base solr flag pt - N + Y base solr flag pt base solr flag pp - N + Y diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr index 660fa8e..1cd5c8f 100644 --- a/insert_update_pricelist1.ktr +++ b/insert_update_pricelist1.ktr @@ -572,12 +572,12 @@ p Insert / update tier1 pl1 solr flag pt - N + Y pl1 solr flag pt pl1 solr flag pp - N + Y diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index 461b15c..ad2aedb 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -572,12 +572,12 @@ p Insert / update tier2 pl2 solr flag pt - N + Y pl2 solr flag pt pl2 solr flag pp - N + Y diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr index e1cc183..a726d11 100644 --- a/insert_update_pricelist3.ktr +++ b/insert_update_pricelist3.ktr @@ -572,12 +572,12 @@ p Insert / update tier3 pl3 solr flag pt - N + Y pl3 solr flag pt pl3 solr flag pp - N + Y diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr index 79f9d0e..2b6b468 100644 --- a/insert_update_pricelist4.ktr +++ b/insert_update_pricelist4.ktr @@ -572,12 +572,12 @@ p Insert / update tier4 pl4 solr flag pt - N + Y pl4 solr flag pt pl4 solr flag pp - N + Y diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr index ae14135..6465f04 100644 --- a/insert_update_pricelist5.ktr +++ b/insert_update_pricelist5.ktr @@ -572,12 +572,12 @@ p Insert / update tier5 pl5 solr flag pt - N + Y pl5 solr flag pt pl5 solr flag pp - N + Y -- cgit v1.2.3