From 0bfae53ba63bfc58632053b7b5363d0fe0c5892f Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 9 Aug 2023 11:55:11 +0700
Subject: add industry

---
 import_adempiere_to_data_warehouse.ktr | 76 +++++++++++++++++++++++++++++++++-
 1 file changed, 75 insertions(+), 1 deletion(-)

(limited to 'import_adempiere_to_data_warehouse.ktr')

diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr
index 624192f..46f7ec7 100644
--- a/import_adempiere_to_data_warehouse.ktr
+++ b/import_adempiere_to_data_warehouse.ktr
@@ -1160,36 +1160,51 @@
     <fields>
       <field>
         <name>customer</name>
+        <rename/>
       </field>
       <field>
         <name>invoice_date</name>
+        <rename/>
       </field>
       <field>
         <name>price_subtotal</name>
+        <rename/>
       </field>
       <field>
         <name>invoice</name>
+        <rename/>
       </field>
       <field>
         <name>quantity</name>
+        <rename/>
       </field>
       <field>
         <name>product</name>
+        <rename/>
       </field>
       <field>
         <name>brand</name>
+        <rename/>
       </field>
       <field>
         <name>salesperson</name>
+        <rename/>
       </field>
       <field>
         <name>name</name>
+        <rename/>
       </field>
       <field>
         <name>value</name>
+        <rename/>
       </field>
       <field>
         <name>odoo_partner_name</name>
+        <rename/>
+      </field>
+      <field>
+        <name>industry</name>
+        <rename/>
       </field>
       <select_unspecified>N</select_unspecified>
       <meta>
@@ -1379,6 +1394,23 @@
         <currency_symbol/>
         <storage_type/>
       </meta>
+      <meta>
+        <name>industry</name>
+        <rename>industry</rename>
+        <type>String</type>
+        <length>-2</length>
+        <precision>-2</precision>
+        <conversion_mask/>
+        <date_format_lenient>false</date_format_lenient>
+        <date_format_locale/>
+        <date_format_timezone/>
+        <lenient_string_to_number>false</lenient_string_to_number>
+        <encoding/>
+        <decimal_symbol/>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <storage_type/>
+      </meta>
     </fields>
     <attributes/>
     <cluster_schema/>
@@ -1406,7 +1438,9 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production</connection>
-    <sql>select id, name, reference_number from res_partner where reference_number is not null</sql>
+    <sql>select rp.id, rp.name, reference_number, rpi.name as industry from res_partner rp
+left join res_partner_industry rpi on rpi.id = rp.industry_id
+where reference_number is not null</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -1483,6 +1517,29 @@
         <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>industry</name>
+        <length>2147483647</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>industry</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/>
@@ -1844,6 +1901,11 @@
         <rename>odoo_partner_name</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>industry</name>
+        <rename>industry</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1871,6 +1933,18 @@
       <schema_name/>
     </partitioning>
     <fields>
+      <field>
+        <name>name</name>
+        <rename/>
+      </field>
+      <field>
+        <name>reference_number</name>
+        <rename/>
+      </field>
+      <field>
+        <name>industry</name>
+        <rename/>
+      </field>
       <select_unspecified>N</select_unspecified>
       <meta>
         <name>name</name>
-- 
cgit v1.2.3