From af4e9a1dedc6b7fad61eb5f402728d2425af944e Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期三, 19 十月 2022 09:57:02 +0800
Subject: [PATCH] 修改办事指南区域未显示，未显示
---
flower_city/src/main/resources/mapper/TransactionEventMapper.xml | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/flower_city/src/main/resources/mapper/TransactionEventMapper.xml b/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
index 82adc08..0c3352f 100644
--- a/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
+++ b/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
@@ -119,7 +119,14 @@
SELECT
id,
department_id,
- department_area,
+ concat(
+ IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select city from automessage_organization_chart
+ where automessage_organization_chart.id=department_id)),''),
+ IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select district from automessage_organization_chart
+ where automessage_organization_chart.id=department_id)),''),
+ IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select village from automessage_organization_chart
+ where automessage_organization_chart.id=department_id)),'')
+ ) AS department_area,
classify_id,
(IF((select classify_grade from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)='2',
(select classify_name from automessage_classify_administration where automessage_classify_administration.id=(select parent_id from
--
Gitblit v1.7.1