opt: 人大金仓数据库改造

linwei

2026-04-07 f7116b40ed99a1a9ee5994353b266a624ec48df5

opt: 人大金仓数据库改造

 drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneFlightRecordMapper.xml

@@ -108,12 +108,12 @@
                </foreach>
            </if>
            <if test="regionCode != null and regionCode != ''">
                and (d.final_outbound_area_code like CONCAT(#{regionCode}, '%')
                and (d.final_outbound_area_code::VARCHAR like CONCAT(#{regionCode}::VARCHAR, '%')
                <!-- 或者设备是共享给当前部门的 -->
                <if test="currentDeptId != null and currentDeptId != '' ">
                    or dfr.device_id in (
                    SELECT device_id FROM ja_fw_device_per_share
                    WHERE loan_to_dept_id = #{currentDeptId}
                    WHERE loan_to_dept_id::VARCHAR = #{currentDeptId}::VARCHAR
                    AND is_deleted = 0
                    )
                </if>