diff options
| -rw-r--r-- | run_calculate_pricelist_odoo.kjb | 76 | ||||
| -rw-r--r-- | update_brand_vendor_purchase_pricelist.ktr | 14 | ||||
| -rw-r--r-- | update_count_trx_odoo.ktr | 8 |
3 files changed, 51 insertions, 47 deletions
diff --git a/run_calculate_pricelist_odoo.kjb b/run_calculate_pricelist_odoo.kjb index a49e48a..3b89f21 100644 --- a/run_calculate_pricelist_odoo.kjb +++ b/run_calculate_pricelist_odoo.kjb @@ -460,7 +460,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>880</xloc> + <xloc>1072</xloc> <yloc>96</yloc> <attributes_kjc/> </entry> @@ -499,7 +499,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>1072</xloc> + <xloc>1248</xloc> <yloc>96</yloc> <attributes_kjc/> </entry> @@ -538,8 +538,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>1248</xloc> - <yloc>96</yloc> + <xloc>1072</xloc> + <yloc>240</yloc> <attributes_kjc/> </entry> <entry> @@ -577,7 +577,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>1248</xloc> + <xloc>928</xloc> <yloc>240</yloc> <attributes_kjc/> </entry> @@ -616,7 +616,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>1072</xloc> + <xloc>768</xloc> <yloc>240</yloc> <attributes_kjc/> </entry> @@ -655,7 +655,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>880</xloc> + <xloc>592</xloc> <yloc>240</yloc> <attributes_kjc/> </entry> @@ -694,7 +694,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>656</xloc> + <xloc>384</xloc> <yloc>240</yloc> <attributes_kjc/> </entry> @@ -733,7 +733,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>464</xloc> + <xloc>192</xloc> <yloc>240</yloc> <attributes_kjc/> </entry> @@ -772,8 +772,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>288</xloc> - <yloc>240</yloc> + <xloc>192</xloc> + <yloc>384</yloc> <attributes_kjc/> </entry> <entry> @@ -811,8 +811,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>112</xloc> - <yloc>240</yloc> + <xloc>384</xloc> + <yloc>384</yloc> <attributes_kjc/> </entry> <entry> @@ -850,7 +850,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>112</xloc> + <xloc>544</xloc> <yloc>384</yloc> <attributes_kjc/> </entry> @@ -928,7 +928,7 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>288</xloc> + <xloc>704</xloc> <yloc>384</yloc> <attributes_kjc/> </entry> @@ -967,8 +967,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>496</xloc> - <yloc>384</yloc> + <xloc>864</xloc> + <yloc>96</yloc> <attributes_kjc/> </entry> <entry> @@ -1006,8 +1006,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>720</xloc> - <yloc>384</yloc> + <xloc>1248</xloc> + <yloc>240</yloc> <attributes_kjc/> </entry> </entries> @@ -1031,15 +1031,6 @@ <unconditional>N</unconditional> </hop> <hop> - <from>import purchase order</from> - <to>import purchase pricelist</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> <from>import purchase pricelist</from> <to>import price group</to> <from_nr>0</from_nr> @@ -1049,15 +1040,6 @@ <unconditional>N</unconditional> </hop> <hop> - <from>import price group</from> - <to>count product</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> <from>count product</from> <to>count vendor</to> <from_nr>0</from_nr> @@ -1157,7 +1139,16 @@ <unconditional>N</unconditional> </hop> <hop> - <from>update count trx odoo</from> + <from>update brand vendor purchase pricelist</from> + <to>count product</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import purchase order</from> <to>update brand purchase pricelist</to> <from_nr>0</from_nr> <to_nr>0</to_nr> @@ -1167,6 +1158,15 @@ </hop> <hop> <from>update brand purchase pricelist</from> + <to>import purchase pricelist</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import price group</from> <to>update brand vendor purchase pricelist</to> <from_nr>0</from_nr> <to_nr>0</to_nr> diff --git a/update_brand_vendor_purchase_pricelist.ktr b/update_brand_vendor_purchase_pricelist.ktr index e46b67e..5575661 100644 --- a/update_brand_vendor_purchase_pricelist.ktr +++ b/update_brand_vendor_purchase_pricelist.ktr @@ -430,17 +430,17 @@ <created_date>2024/03/19 14:40:57.019</created_date> <modified_user>-</modified_user> <modified_date>2024/03/19 14:40:57.019</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>erp indoteknik production (localhost)</name> - <server>10.148.0.3</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>erp_indoteknik</database> + <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> @@ -504,9 +504,9 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production (localhost)</connection> + <connection>dw bi indoteknik (localhost)</connection> <sql>select pp.brand_id, pp.vendor_id, count(*) as count_brand_vendor -from purchase_pricelist pp +from purchase_pricelist_dw pp where pp.brand_id is not null group by pp.brand_id, pp.vendor_id</sql> <limit>0</limit> @@ -611,7 +611,7 @@ group by pp.brand_id, pp.vendor_id</sql> <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production (localhost)</connection> + <connection>dw bi indoteknik (localhost)</connection> <skip_lookup>N</skip_lookup> <commit>100</commit> <use_batch>N</use_batch> diff --git a/update_count_trx_odoo.ktr b/update_count_trx_odoo.ktr index 62f0d97..d212413 100644 --- a/update_count_trx_odoo.ktr +++ b/update_count_trx_odoo.ktr @@ -430,7 +430,7 @@ <created_date>2023/10/21 10:18:07.701</created_date> <modified_user>-</modified_user> <modified_date>2023/10/21 10:18:07.701</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -556,7 +556,7 @@ <schema_name/> </partitioning> <connection>dw bi indoteknik (localhost)</connection> - <sql>select id, count_trx_po, count_trx_po_vendor from purchase_pricelist_dw</sql> + <sql>select id, count_trx_po, count_trx_po_vendor, count_brand_vendor from purchase_pricelist_dw</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -682,6 +682,10 @@ <name>count_trx_po_vendor</name> <rename>count_trx_po_vendor</rename> </value> + <value> + <name>count_brand_vendor</name> + <rename>count_brand_vendor</rename> + </value> </lookup> <attributes/> <cluster_schema/> |