From 04318fc87516d28d05aeb2d4dd77f32e6114e776 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 11 Sep 2024 13:57:58 +0700 Subject: update calculate lob x category --- calculate_lob_category_v2_local.ktr | 5221 +++++++++++++++++++++++++++++++++++ 1 file changed, 5221 insertions(+) create mode 100644 calculate_lob_category_v2_local.ktr (limited to 'calculate_lob_category_v2_local.ktr') diff --git a/calculate_lob_category_v2_local.ktr b/calculate_lob_category_v2_local.ktr new file mode 100644 index 0000000..c58f4fe --- /dev/null +++ b/calculate_lob_category_v2_local.ktr @@ -0,0 +1,5221 @@ + + + + calculate_lob_category_v2_local + + + + Normal + / + + + + + + + + + + + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + TRANSNAME + Y + TRANSNAME + + + STATUS + Y + STATUS + + + LINES_READ + Y + LINES_READ + + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + + LINES_UPDATED + Y + LINES_UPDATED + + + + LINES_INPUT + Y + LINES_INPUT + + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + + LINES_REJECTED + Y + LINES_REJECTED + + + + ERRORS + Y + ERRORS + + + STARTDATE + Y + STARTDATE + + + ENDDATE + Y + ENDDATE + + + LOGDATE + Y + LOGDATE + + + DEPDATE + Y + DEPDATE + + + REPLAYDATE + Y + REPLAYDATE + + + LOG_FIELD + Y + LOG_FIELD + + + EXECUTING_SERVER + N + EXECUTING_SERVER + + + EXECUTING_USER + N + EXECUTING_USER + + + CLIENT + N + CLIENT + + + + + +
+ + + + ID_BATCH + Y + ID_BATCH + + + SEQ_NR + Y + SEQ_NR + + + LOGDATE + Y + LOGDATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + INPUT_BUFFER_ROWS + Y + INPUT_BUFFER_ROWS + + + OUTPUT_BUFFER_ROWS + Y + OUTPUT_BUFFER_ROWS + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + LOGGING_OBJECT_TYPE + Y + LOGGING_OBJECT_TYPE + + + OBJECT_NAME + Y + OBJECT_NAME + + + OBJECT_COPY + Y + OBJECT_COPY + + + REPOSITORY_DIRECTORY + Y + REPOSITORY_DIRECTORY + + + FILENAME + Y + FILENAME + + + OBJECT_ID + Y + OBJECT_ID + + + OBJECT_REVISION + Y + OBJECT_REVISION + + + PARENT_CHANNEL_ID + Y + PARENT_CHANNEL_ID + + + ROOT_CHANNEL_ID + Y + ROOT_CHANNEL_ID + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + LOG_FIELD + N + LOG_FIELD + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + METRICS_DATE + Y + METRICS_DATE + + + METRICS_CODE + Y + METRICS_CODE + + + METRICS_DESCRIPTION + Y + METRICS_DESCRIPTION + + + METRICS_SUBJECT + Y + METRICS_SUBJECT + + + METRICS_TYPE + Y + METRICS_TYPE + + + METRICS_VALUE + Y + METRICS_VALUE + + + + + +
+ + 0.0 + 0.0 + + 10000 + 50 + 50 + N + Y + 50000 + Y + + N + 1000 + 100 + + + + + + + + + - + 2024/09/10 16:33:08.253 + - + 2024/09/10 16:33:08.253 + H4sIAAAAAAAAAAMAAAAAAAAAAAA= + N + + + + + dw bi indoteknik + localhost + POSTGRESQL + Native + dw_bi_indoteknik + 5703 + metabase + Encrypted 2be98dfba28d7bf86853c9f58cfc4f889 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5703 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + Y + + + USE_POOLING + N + + + + + + Calculator + Select values 2 + Y + + + Select values + Calculator + Y + + + acc + acc_hore + Y + + + acc_fy + acc + Y + + + acc_hore + hore + Y + + + acc_ly + office_acc + Y + + + agri + agri_clean + Y + + + agri_clean + clean + Y + + + agri_fy + agri + Y + + + agri_ly + machine_agri + Y + + + chemic + chemic_meas + Y + + + chemic_fy + chemic + Y + + + chemic_ly + clean_chemic + Y + + + chemic_meas + meas + Y + + + clean + clean_chemic + Y + + + clean_chemic + chemic + Y + + + clean_fy + clean + Y + + + clean_ly + agri_clean + Y + + + elec + elec_log + Y + + + elec_fy + elec + Y + + + elec_log + log + Y + + + elec_ly + meas_elec + Y + + + hore + Select values + Y + + + hore_fy + hore + Y + + + hore_ly + acc_hore + Y + + + log + log_office + Y + + + log_fy + log + Y + + + log_ly + elec_log + Y + + + log_office + office + Y + + + machine + machine_agri + Y + + + machine_agri + agri + Y + + + machine_fy + machine + Y + + + machine_ly + tools_machine + Y + + + meas + meas_elec + Y + + + meas_elec + elec + Y + + + meas_fy + meas + Y + + + meas_ly + chemic_meas + Y + + + office + office_acc + Y + + + office_acc + acc + Y + + + office_fy + office + Y + + + office_ly + log_office + Y + + + safety + safety_tools + Y + + + safety_fy + safety + Y + + + safety_ly + safety + Y + + + safety_tools + tools + Y + + + tools + tools_machine + Y + + + tools_fy + tools + Y + + + tools_ly + safety_tools + Y + + + tools_machine + machine + Y + + + Select values 2 + Insert / update + Y + + + Block this step until steps finish + Execute SQL script + Y + + + Insert / update + Delay row + Y + + + Delay row + marker + Y + + + Dummy (do nothing) + Block this step until steps finish + Y + + + + Block this step until steps finish + BlockUntilStepsFinish + + Y + + 1 + + none + + + + + marker + 0 + + + + + + + + + + + + 1104 + 432 + Y + + + + Calculator + Calculator + + Y + + 1 + + none + + + Y + + safety_g + PERCENT_1 + safety_fy + safety_ly + + None + -1 + -1 + N + + + + + + + tools_g + PERCENT_1 + tools_fy + tools_ly + + None + -1 + -1 + N + + + + + + + machine_g + PERCENT_1 + machine_fy + machine_ly + + None + -1 + -1 + N + + + + + + + agri_g + PERCENT_1 + agri_fy + agri_ly + + None + -1 + -1 + N + + + + + + + clean_g + PERCENT_1 + clean_fy + clean_ly + + None + -1 + -1 + N + + + + + + + chemic_g + PERCENT_1 + chemic_fy + chemic_ly + + None + -1 + -1 + N + + + + + + + meas_g + PERCENT_1 + meas_fy + meas_ly + + None + -1 + -1 + N + + + + + + + elec_g + PERCENT_1 + elec_fy + elec_ly + + None + -1 + -1 + N + + + + + + + log_g + PERCENT_1 + log_fy + log_ly + + None + -1 + -1 + N + + + + + + + office_g + PERCENT_1 + office_fy + office_ly + + None + -1 + -1 + N + + + + + + + acc_g + PERCENT_1 + acc_fy + acc_ly + + None + -1 + -1 + N + + + + + + + hore_g + PERCENT_1 + hore_fy + hore_ly + + None + -1 + -1 + N + + + + + + + + + + + + + + + 224 + 432 + Y + + + + Execute SQL script + ExecSQL + + Y + + 1 + + none + + + dw bi indoteknik + Y + N + N + N + update t_lob_category_value_v2 set safety_ly = 0 where safety_ly is null; +update t_lob_category_value_v2 set safety_fy = 0 where safety_fy is null; +update t_lob_category_value_v2 set safety_g = 0 where safety_g is null; +update t_lob_category_value_v2 set tools_ly = 0 where tools_ly is null; +update t_lob_category_value_v2 set tools_fy = 0 where tools_fy is null; +update t_lob_category_value_v2 set tools_g = 0 where tools_g is null; +update t_lob_category_value_v2 set machine_ly = 0 where machine_ly is null; +update t_lob_category_value_v2 set machine_fy = 0 where machine_fy is null; +update t_lob_category_value_v2 set machine_g = 0 where machine_g is null; +update t_lob_category_value_v2 set agri_ly = 0 where agri_ly is null; +update t_lob_category_value_v2 set agri_fy = 0 where agri_fy is null; +update t_lob_category_value_v2 set agri_g = 0 where agri_g is null; +update t_lob_category_value_v2 set clean_ly = 0 where clean_ly is null; +update t_lob_category_value_v2 set clean_fy = 0 where clean_fy is null; +update t_lob_category_value_v2 set clean_g = 0 where clean_g is null; +update t_lob_category_value_v2 set chemic_ly = 0 where chemic_ly is null; +update t_lob_category_value_v2 set chemic_fy = 0 where chemic_fy is null; +update t_lob_category_value_v2 set chemic_g = 0 where chemic_g is null; +update t_lob_category_value_v2 set meas_ly = 0 where meas_ly is null; +update t_lob_category_value_v2 set meas_fy = 0 where meas_fy is null; +update t_lob_category_value_v2 set meas_g = 0 where meas_g is null; +update t_lob_category_value_v2 set elec_ly = 0 where elec_ly is null; +update t_lob_category_value_v2 set elec_fy = 0 where elec_fy is null; +update t_lob_category_value_v2 set elec_g = 0 where elec_g is null; +update t_lob_category_value_v2 set log_ly = 0 where log_ly is null; +update t_lob_category_value_v2 set log_fy = 0 where log_fy is null; +update t_lob_category_value_v2 set log_g = 0 where log_g is null; +update t_lob_category_value_v2 set office_ly = 0 where office_ly is null; +update t_lob_category_value_v2 set office_fy = 0 where office_fy is null; +update t_lob_category_value_v2 set office_g = 0 where office_g is null; +update t_lob_category_value_v2 set acc_ly = 0 where acc_ly is null; +update t_lob_category_value_v2 set acc_fy = 0 where acc_fy is null; +update t_lob_category_value_v2 set acc_g = 0 where acc_g is null; +update t_lob_category_value_v2 set hore_ly = 0 where hore_ly is null; +update t_lob_category_value_v2 set hore_fy = 0 where hore_fy is null; +update t_lob_category_value_v2 set hore_g = 0 where hore_g is null; + + N + + + + + + + + + + + + + + + + 912 + 432 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public +
t_lob_category_value_v2
+ + id + id + = + + + + id + id + N + + + industry + industry + Y + + + safety_ly + safety_ly + Y + + + safety_fy + safety_fy + Y + + + tools_ly + tools_ly + Y + + + tools_fy + tools_fy + Y + + + machine_ly + machine_ly + Y + + + machine_fy + machine_fy + Y + + + agri_ly + agri_ly + Y + + + agri_fy + agri_fy + Y + + + clean_ly + clean_ly + Y + + + clean_fy + clean_fy + Y + + + chemic_ly + chemic_ly + Y + + + chemic_fy + chemic_fy + Y + + + meas_ly + meas_ly + Y + + + meas_fy + meas_fy + Y + + + elec_ly + elec_ly + Y + + + elec_fy + elec_fy + Y + + + log_ly + log_ly + Y + + + log_fy + log_fy + Y + + + office_ly + office_ly + Y + + + office_fy + office_fy + Y + + + acc_ly + acc_ly + Y + + + acc_fy + acc_fy + Y + + + hore_ly + hore_ly + Y + + + hore_fy + hore_fy + Y + + + safety_g + safety_g + Y + + + tools_g + tools_g + Y + + + machine_g + machine_g + Y + + + agri_g + agri_g + Y + + + clean_g + clean_g + Y + + + chemic_g + chemic_g + Y + + + meas_g + meas_g + Y + + + elec_g + elec_g + Y + + + log_g + log_g + Y + + + office_g + office_g + Y + + + acc_g + acc_g + Y + + + hore_g + hore_g + Y + + + + + + + + + + + + 496 + 432 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + id + + + industry + + + safety_ly + + + safety_fy + + + tools_ly + + + tools_fy + + + machine_ly + + + machine_fy + + + agri_ly + + + agri_fy + + + clean_ly + + + clean_fy + + + chemic_ly + + + chemic_fy + + + meas_ly + + + meas_fy + + + elec_ly + + + elec_fy + + + log_ly + + + log_fy + + + office_ly + + + office_fy + + + acc_ly + + + acc_fy + + + hore_ly + + + hore_fy + + N + + + + + + + + + + + 112 + 432 + Y + + + + Select values 2 + SelectValues + + Y + + 1 + + none + + + + + id + + + industry + + + safety_ly + + + safety_fy + + + tools_ly + + + tools_fy + + + machine_ly + + + machine_fy + + + agri_ly + + + agri_fy + + + clean_ly + + + clean_fy + + + chemic_ly + + + chemic_fy + + + meas_ly + + + meas_fy + + + elec_ly + + + elec_fy + + + log_ly + + + log_fy + + + office_ly + + + office_fy + + + acc_ly + + + acc_fy + + + hore_ly + + + hore_fy + + + safety_g + + + tools_g + + + machine_g + + + agri_g + + + clean_g + + + chemic_g + + + meas_g + + + elec_g + + + log_g + + + office_g + + + acc_g + + + hore_g + + N + + + + + + + + + + + 336 + 432 + Y + + + + acc + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + office_acc + acc_fy + + id + + + id + + + + + + + + + + + 320 + 240 + Y + + + + acc_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2445 and rpi2.id = rpi.id) as acc_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + acc_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + acc_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + acc_fy + -1 + -1 + acc_fy + acc_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 320 + 336 + Y + + + + acc_hore + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + acc + hore_ly + + id + + + id + + + + + + + + + + + 224 + 240 + Y + + + + acc_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2445 and rpi2.id = rpi.id) as acc_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + acc_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + acc_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + acc_ly + -1 + -1 + acc_ly + acc_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 416 + 336 + Y + + + + agri + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + machine_agri + agri_fy + + id + + + id + + + + + + + + + + + 816 + 160 + Y + + + + agri_clean + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + agri + clean_ly + + id + + + id + + + + + + + + + + + 912 + 160 + Y + + + + agri_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2222 and rpi2.id = rpi.id) as agri_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + agri_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + agri_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + agri_fy + -1 + -1 + agri_fy + agri_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 912 + 64 + Y + + + + agri_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2222 and rpi2.id = rpi.id) as agri_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + agri_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + agri_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + agri_ly + -1 + -1 + agri_ly + agri_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 816 + 64 + Y + + + + chemic + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + clean_chemic + chemic_fy + + id + + + id + + + + + + + + + + + 1200 + 160 + Y + + + + chemic_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2273 and rpi2.id = rpi.id) as chemic_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + chemic_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + chemic_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + chemic_fy + -1 + -1 + chemic_fy + chemic_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1296 + 64 + Y + + + + chemic_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2273 and rpi2.id = rpi.id) as chemic_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + chemic_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + chemic_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + chemic_ly + -1 + -1 + chemic_ly + chemic_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1200 + 64 + Y + + + + chemic_meas + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + chemic + meas_ly + + id + + + id + + + + + + + + + + + 1200 + 240 + Y + + + + clean + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + agri_clean + clean_fy + + id + + + id + + + + + + + + + + + 1008 + 160 + Y + + + + clean_chemic + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + clean + chemic_ly + + id + + + id + + + + + + + + + + + 1104 + 160 + Y + + + + clean_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2246 and rpi2.id = rpi.id) as clean_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + clean_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + clean_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + clean_fy + -1 + -1 + clean_fy + clean_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1104 + 64 + Y + + + + clean_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2246 and rpi2.id = rpi.id) as clean_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + clean_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + clean_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + clean_ly + -1 + -1 + clean_ly + clean_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1008 + 64 + Y + + + + elec + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + meas_elec + elec_fy + + id + + + id + + + + + + + + + + + 896 + 240 + Y + + + + elec_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2354 and rpi2.id = rpi.id) as elec_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + elec_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + elec_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + elec_fy + -1 + -1 + elec_fy + elec_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 896 + 336 + Y + + + + elec_log + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + elec + log_ly + + id + + + id + + + + + + + + + + + 800 + 240 + Y + + + + elec_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2354 and rpi2.id = rpi.id) as elec_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + elec_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + elec_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + elec_ly + -1 + -1 + elec_ly + elec_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 992 + 336 + Y + + + + hore + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + acc_hore + hore_fy + + id + + + id + + + + + + + + + + + 112 + 336 + Y + + + + hore_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2477 and rpi2.id = rpi.id) as hore_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + hore_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + hore_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + hore_fy + -1 + -1 + hore_fy + hore_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 112 + 240 + Y + + + + hore_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2477 and rpi2.id = rpi.id) as hore_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + hore_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + hore_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + hore_ly + -1 + -1 + hore_ly + hore_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 224 + 336 + Y + + + + log + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + elec_log + log_fy + + id + + + id + + + + + + + + + + + 704 + 240 + Y + + + + log_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2394 and rpi2.id = rpi.id) as log_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + log_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + log_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + log_fy + -1 + -1 + log_fy + log_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 704 + 336 + Y + + + + log_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2394 and rpi2.id = rpi.id) as log_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + log_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + log_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + log_ly + -1 + -1 + log_ly + log_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 800 + 336 + Y + + + + log_office + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + log + office_ly + + id + + + id + + + + + + + + + + + 608 + 240 + Y + + + + machine + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + tools_machine + machine_fy + + id + + + id + + + + + + + + + + + 576 + 160 + Y + + + + machine_agri + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + machine + agri_ly + + id + + + id + + + + + + + + + + + 704 + 160 + Y + + + + machine_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2161 and rpi2.id = rpi.id) as machine_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + machine_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + machine_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + machine_fy + -1 + -1 + machine_fy + machine_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 704 + 64 + Y + + + + machine_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2161 and rpi2.id = rpi.id) as machine_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + machine_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + machine_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + machine_ly + -1 + -1 + machine_ly + machine_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 576 + 64 + Y + + + + meas + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + chemic_meas + meas_fy + + id + + + id + + + + + + + + + + + 1104 + 240 + Y + + + + meas_elec + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + meas + elec_ly + + id + + + id + + + + + + + + + + + 992 + 240 + Y + + + + meas_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2315 and rpi2.id = rpi.id) as meas_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + meas_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + meas_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + meas_fy + -1 + -1 + meas_fy + meas_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1104 + 336 + Y + + + + meas_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2315 and rpi2.id = rpi.id) as meas_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + meas_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + meas_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + meas_ly + -1 + -1 + meas_ly + meas_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 1200 + 336 + Y + + + + office + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + log_office + office_fy + + id + + + id + + + + + + + + + + + 512 + 240 + Y + + + + office_acc + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + office + acc_ly + + id + + + id + + + + + + + + + + + 416 + 240 + Y + + + + office_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2420 and rpi2.id = rpi.id) as office_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + office_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + office_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + office_fy + -1 + -1 + office_fy + office_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 512 + 336 + Y + + + + office_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2420 and rpi2.id = rpi.id) as office_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + office_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + office_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + office_ly + -1 + -1 + office_ly + office_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 608 + 336 + Y + + + + safety + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + safety_ly + safety_fy + + id + + + id + + + + + + + + + + + 96 + 160 + Y + + + + safety_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2040 and rpi2.id = rpi.id) as safety_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + safety_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + safety_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + safety_fy + -1 + -1 + safety_fy + safety_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 224 + 64 + Y + + + + safety_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2040 and rpi2.id = rpi.id) as safety_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + safety_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + safety_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + safety_ly + -1 + -1 + safety_ly + safety_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 96 + 64 + Y + + + + safety_tools + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + safety + tools_ly + + id + + + id + + + + + + + + + + + 224 + 160 + Y + + + + tools + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + safety_tools + tools_fy + + id + + + id + + + + + + + + + + + 352 + 160 + Y + + + + tools_fy + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_current_year()::date and get_now()::date +and ppc.id = 2097 and rpi2.id = rpi.id) as tools_fy +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + tools_fy + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + tools_fy + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + tools_fy + -1 + -1 + tools_fy + tools_fy + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 464 + 64 + Y + + + + tools_ly + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select rpi.id, coalesce(rpi.name, 'Unknown') as industry, +(select sum(aml.price_subtotal) +from account_move am +join res_partner rp on rp.id = am.partner_id +join account_move_line aml on aml.move_id = am.id +join product p on p.product_id = aml.product_id +left join res_partner_industry rpi2 on rpi2.id = rp.industry_id +left join product_public_category ppc on ppc.id = p.parent_category_id +where am.move_type = 'out_invoice' +and am.state = 'posted' +and am."date" between get_first_day_last_year()::date and get_now_last_year()::date +and ppc.id = 2097 and rpi2.id = rpi.id) as tools_ly +from res_partner_industry rpi +order by rpi.id + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + tools_ly + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + industry + 2147483647 + -1 + tools_ly + industry + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + tools_ly + -1 + -1 + tools_ly + tools_ly + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 352 + 64 + Y + + + + tools_machine + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + tools + machine_ly + + id + + + id + + + + + + + + + + + 464 + 160 + Y + + + + marker + Dummy + + Y + + 1 + + none + + + + + + + + + + + + 784 + 432 + Y + + + + Delay row + Delay + + Y + + 1 + + none + + + 10 + milliseconds + + + + + + + + + + 640 + 432 + Y + + + + Dummy (do nothing) + Dummy + + Y + + 1 + + none + + + + + + + + + + + + 1280 + 432 + Y + + + + + + + N + + -- cgit v1.2.3