From b343958745aa7a93064530eb7e880e1dbe69fb6f Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Mon, 06 May 2024 17:15:31 +0800
Subject: [PATCH] 视频设备列表增加筛选条件
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml | 15 ++++++++++++---
1 files changed, 12 insertions(+), 3 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
index 435df5c..d909575 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
@@ -14,8 +14,17 @@
left join sjzt_md."att_ad_base" ad on ad."ad_code" = arb."interior_ad_guid"
left join sjzt_md."att_ad_base" ad2 on ad2."ad_code" = ad."p_ad_code"
left join sjzt_md."att_ad_base" ad3 on ad3."ad_code" = ad2."p_ad_code"
- <if test="attWmstBaseVO.adCode != null and attWmstBaseVO.adCode !=''">
- where concat(ad."ad_code",ad2."ad_code",ad3."ad_code") like concat(#{attWmstBaseVO.adCode},'%')
- </if>
+ <where>
+ <if test="attWmstBaseVO.adCode != null and attWmstBaseVO.adCode !=''">
+ and concat(ad."ad_code",ad2."ad_code",ad3."ad_code") like concat('%',#{attWmstBaseVO.adCode},'%')
+ </if>
+ <if test="attWmstBaseVO.online != null and attWmstBaseVO.online !=''">
+ and awb."online" = #{attWmstBaseVO.online}
+ </if>
+ <if test="attWmstBaseVO.sysResource != null and attWmstBaseVO.sysResource !=''">
+ and awb."sys_resource" = #{attWmstBaseVO.sysResource}
+ </if>
+ </where>
+
</select>
</mapper>
--
Gitblit v1.9.3