海康设备水尺监测查询修改

zrj

2024-06-05 5917eba6c8d0a75560a92f08fa8d71e86dc0cbec

海康设备水尺监测查询修改

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml

@@ -28,6 +28,9 @@
        LEFT JOIN SJZT_MD."att_ad_base" c ON b."p_ad_code" = c."guid"
        LEFT JOIN SJZT_MD."att_ad_base" d ON c."p_ad_code" = d."guid"
        where 1 =1
        <if test="hkStaffGaugeMon.resGuid!=null and hkStaffGaugeMon.resGuid!=''">
            and awb."res_guid" = #{hkStaffGaugeMon.resGuid}
        </if>
        <if test="hkStaffGaugeMon.cameraName!=null and hkStaffGaugeMon.cameraName!=''">
            and shsgm.camera_name like concat('%',#{hkStaffGaugeMon.cameraName},'%')
        </if>