From dcf387e233a47ffb81d36bd02c4bb7ee966af5a1 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 13 十一月 2024 16:15:48 +0800
Subject: [PATCH] 调整语法不兼容
---
src/main/resources/mapper/WorkflowPropertyMapper.xml | 8 ++++----
src/main/resources/mapper/BattInfMapper.xml | 2 +-
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/main/resources/mapper/BattInfMapper.xml b/src/main/resources/mapper/BattInfMapper.xml
index 54b48ac..8bef112 100644
--- a/src/main/resources/mapper/BattInfMapper.xml
+++ b/src/main/resources/mapper/BattInfMapper.xml
@@ -751,7 +751,7 @@
where BattGroupId=#{battGroupId}
</select>
<select id="selectAlarmNumIn3D" resultType="java.lang.String">
- select IFNULL(GROUP_CONCAT(DISTINCT MonNum),"") from db_alarm.tb_battalarm_data where BattGroupId=#{battGroupId} and MonNum>0
+ select IFNULL(wm_CONCAT(DISTINCT MonNum),'') from db_alarm.tb_battalarm_data where BattGroupId=#{battGroupId} and MonNum>0
</select>
<select id="hasBattBinf" resultType="java.lang.Integer">
select count(*) from db_battinf.tb_battinf where StationId=#{stationId}
diff --git a/src/main/resources/mapper/WorkflowPropertyMapper.xml b/src/main/resources/mapper/WorkflowPropertyMapper.xml
index 3ec26c8..b7682f8 100644
--- a/src/main/resources/mapper/WorkflowPropertyMapper.xml
+++ b/src/main/resources/mapper/WorkflowPropertyMapper.xml
@@ -6,10 +6,10 @@
<select id="getPropertyList" resultType="com.whyc.dto.WorkflowPropertyDTO2">
SELECT
<!-- GROUP_CONCAT(id) id,-->
- GROUP_CONCAT(link_type) link_type,
- GROUP_CONCAT(link_name) link_name,
- GROUP_CONCAT(role_type) role_type,
- GROUP_CONCAT(role_name) role_name,
+ WM_concat(link_type) link_type,
+ WM_concat(link_name) link_name,
+ WM_concat(role_type) role_type,
+ WM_concat(role_name) role_name,
type
FROM
web_site.tb_workflow_property
--
Gitblit v1.9.1