From 5917eba6c8d0a75560a92f08fa8d71e86dc0cbec Mon Sep 17 00:00:00 2001
From: zrj <646384940@qq.com>
Date: Wed, 05 Jun 2024 16:03:51 +0800
Subject: [PATCH] 海康设备水尺监测查询修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml
index d8e1763..9c6aacf 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml
+++ b/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>
--
Gitblit v1.9.3