diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-03-19 15:11:36 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-03-19 15:11:36 +0700 |
| commit | 06a0d0c69bcb0cb0f212d44afd5757b8a4270ecb (patch) | |
| tree | 0000a50fcda2dee21f476c921f1db82e27e253ec /import_brand.ktr | |
| parent | 69d576598339a025521143f2f70e97ad73469ee4 (diff) | |
update brand vendor purchase pricelist
Diffstat (limited to 'import_brand.ktr')
| -rw-r--r-- | import_brand.ktr | 39 |
1 files changed, 34 insertions, 5 deletions
diff --git a/import_brand.ktr b/import_brand.ktr index 1a16fb7..fa669ce 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -557,7 +557,8 @@ </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select id, x_name, x_manufacture_level, -(select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group +(select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group, +(select name from product_public_category ppc where ppc.id in(select product_public_category_id from product_public_category_x_manufactures_rel where x_manufactures_id = xm.id limit 1)) as category from x_manufactures xm where xm.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> @@ -682,6 +683,29 @@ where xm.write_date >= (now() - '15 days'::interval)</sql> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>category</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>category</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> </row-meta> <attributes/> <cluster_schema/> @@ -692,8 +716,8 @@ where xm.write_date >= (now() - '15 days'::interval)</sql> </output> </remotesteps> <GUI> - <xloc>112</xloc> - <yloc>96</yloc> + <xloc>176</xloc> + <yloc>208</yloc> <draw>Y</draw> </GUI> </step> @@ -745,6 +769,11 @@ where xm.write_date >= (now() - '15 days'::interval)</sql> <rename>pricing_group</rename> <update>Y</update> </value> + <value> + <name>category</name> + <rename>category</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -755,8 +784,8 @@ where xm.write_date >= (now() - '15 days'::interval)</sql> </output> </remotesteps> <GUI> - <xloc>272</xloc> - <yloc>96</yloc> + <xloc>336</xloc> + <yloc>208</yloc> <draw>Y</draw> </GUI> </step> |