From 2d25e6b0185514c95552c41af1da371cc1cc17cd Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 15 十一月 2022 17:52:42 +0800
Subject: [PATCH] 修改办事指南所属部门集合
---
flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java | 2 +-
flower_city/src/main/resources/mapper/TransactionEventMapper.xml | 6 ++++++
2 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java b/flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java
index 759c30e..9c9a5b3 100644
--- a/flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java
+++ b/flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java
@@ -201,7 +201,7 @@
@ApiModelProperty("操作指引附件url")
private String operationalGuidelineUrl;
- /**
+ /**
* 操作指引视频url
*/
@ApiModelProperty("操作指引视频url")
diff --git a/flower_city/src/main/resources/mapper/TransactionEventMapper.xml b/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
index d52b835..f4cfb84 100644
--- a/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
+++ b/flower_city/src/main/resources/mapper/TransactionEventMapper.xml
@@ -104,6 +104,12 @@
transaction_area_name,
classify_ids,
department_ids,
+ (SELECT GROUP_CONCAT(organization_name) FROM automessage_organization_chart WHERE id in (SELECT
+ substring_index(substring_index(department_ids,',', b.help_topic_id + 1), ',', -1) result
+ FROM
+ mysql.help_topic b
+ where
+ b.help_topic_id < (LENGTH(department_ids) - LENGTH(REPLACE(department_ids, ',', '')) + 1))) as departmentNames,
(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
automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)),
--
Gitblit v1.7.1