xml遍历集合修改

whyclxw

2025-06-04 fd30f967bb196ed765ea62a2e825b9d27964899b

xml遍历集合修改

 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(

 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(

 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(

 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>