From fd30f967bb196ed765ea62a2e825b9d27964899b Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期三, 04 六月 2025 16:29:43 +0800
Subject: [PATCH] xml遍历集合修改
---
src/main/resources/mapper/PwrdevAlarmMapper.xml | 3 +--
src/main/resources/mapper/BattalarmDataMapper.xml | 4 ++--
src/main/resources/mapper/DevalarmDataMapper.xml | 3 +--
src/main/resources/mapper/UserMapper.xml | 3 +--
4 files changed, 5 insertions(+), 8 deletions(-)
diff --git a/src/main/resources/mapper/BattalarmDataMapper.xml b/src/main/resources/mapper/BattalarmDataMapper.xml
index 3bf08da..2b6ab27 100644
--- a/src/main/resources/mapper/BattalarmDataMapper.xml
+++ b/src/main/resources/mapper/BattalarmDataMapper.xml
@@ -24,11 +24,11 @@
and tb_battalarm_data.alm_level=#{almLevel}
</if>
<if test="almIds!=null">
- and tb_battalarm_data.alm_id in(
+ and tb_battalarm_data.alm_id in
<foreach collection="almIds" item="almId" open="(" separator="," close=")">
#{almId}
</foreach>
- )
+
</if>
<if test="uid>100">
and tb_batt_inf.station_id in(
diff --git a/src/main/resources/mapper/DevalarmDataMapper.xml b/src/main/resources/mapper/DevalarmDataMapper.xml
index ef4e3bb..a60191a 100644
--- a/src/main/resources/mapper/DevalarmDataMapper.xml
+++ b/src/main/resources/mapper/DevalarmDataMapper.xml
@@ -23,11 +23,10 @@
and tb_devalarm_data.alm_level=#{almLevel}
</if>
<if test="almIds!=null">
- and tb_devalarm_data.alm_id in(
+ and tb_devalarm_data.alm_id in
<foreach collection="almIds" item="almId" open="(" separator="," close=")">
#{almId}
</foreach>
- )
</if>
<if test="uid>100">
and tb_batt_inf.station_id in(
diff --git a/src/main/resources/mapper/PwrdevAlarmMapper.xml b/src/main/resources/mapper/PwrdevAlarmMapper.xml
index 094f7e4..f853fbe 100644
--- a/src/main/resources/mapper/PwrdevAlarmMapper.xml
+++ b/src/main/resources/mapper/PwrdevAlarmMapper.xml
@@ -23,11 +23,10 @@
and tb_pwrdev_alarm.alm_level=#{almLevel}
</if>
<if test="almIds!=null">
- and tb_pwrdev_alarm.alm_id in(
+ and tb_pwrdev_alarm.alm_id in
<foreach collection="almIds" item="almId" open="(" separator="," close=")">
#{almId}
</foreach>
- )
</if>
<if test="uid>100">
and tb_pwrdev_alarm.power_id in(
diff --git a/src/main/resources/mapper/UserMapper.xml b/src/main/resources/mapper/UserMapper.xml
index 6f164c7..95ddee6 100644
--- a/src/main/resources/mapper/UserMapper.xml
+++ b/src/main/resources/mapper/UserMapper.xml
@@ -55,11 +55,10 @@
id in(
select distinct uid from db_user.tb_baojigroup_usr
<where>
- baoji_group_id in(
+ baoji_group_id in
<foreach collection="baojiIdList" item="baojiId" open="(" separator="," close=")">
#{baojiId}
</foreach>
- )
</where>
)
</where>
--
Gitblit v1.9.1