大坝安全监测接口流域接口修改

guoshilong

2023-09-07 089e66645c001334467f159bacc401ef2bfdf272

大坝安全监测接口流域接口修改

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/damSecurity/mapper/DamSecurityMapper.xml

@@ -461,14 +461,16 @@
            AND  (province."ad_code" =#{dam.adCode} or city."ad_code" = #{dam.adCode} or county."ad_code" = #{dam.adCode})
        </if>
        <if test="basCodes != null and basCodes !='' ">
            AND(abb."code" in
            AND(
                abb."code" in
            <foreach collection="basCodes.split(',')" item="item" index="index" open="(" separator="," close=")">
                #{item}
            </foreach>
              or pabb."code" in
                    or pabb."code" in
            <foreach collection="basCodes.split(',')" item="item" index="index" open="(" separator="," close=")">
                 #{item})
                 #{item}
            </foreach>
            )
        </if>
    </select>