吉安感知网项目-后端
parent: 099a2436 | patch | commit | ignore whitespace
linwei
2026-04-02 71ac08b70ee4f84ac7832dcf7057f3013a206552 
opt: sql改造其他模块改造10
1 files modified
4 ■■■■■ changed files
drone-service/drone-fw/src/main/java/org/sxkj/fw/device/mapper/FwDeviceMapper.xml 4 ●●●●● patch | view | raw | blame | history 
 drone-service/drone-fw/src/main/java/org/sxkj/fw/device/mapper/FwDeviceMapper.xml


@@ -86,10 +86,10 @@


                and status = #{param2.status}


            </if>


            <if test="param2.isTrack != null and param2.isTrack == 1">


                and (SELECT COUNT(*) FROM ja_fw_device_track tmp WHERE ja_fw_device.id = tmp.device_id) > 0


                and (SELECT COUNT(*) FROM ja_fw_device_track tmp WHERE ja_fw_device.id::VARCHAR = tmp.device_id::VARCHAR) > 0


            </if>


            <if test="param2.isTrack != null and param2.isTrack == 2">


                and (SELECT COUNT(*) FROM ja_fw_device_track tmp WHERE ja_fw_device.id = tmp.device_id) = 0


                and (SELECT COUNT(*) FROM ja_fw_device_track tmp WHERE ja_fw_device.id::VARCHAR = tmp.device_id::VARCHAR) = 0


            </if>


            <if test="param2.deptList != null and param2.deptList.size > 0">


                and ( create_dept in