From 9a5fbc0c9584fd09d79adbeb65832bc3dddf963d Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Mon, 06 May 2024 16:11:47 +0800
Subject: [PATCH] 视频设备列表增加查询条件
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java | 5 +++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml | 10 ++++++++--
2 files changed, 13 insertions(+), 2 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 ef836be..435df5c 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
@@ -9,7 +9,13 @@
where "guid" = #{attWmstBase.guid}
</update>
<select id="getPage" resultType="cn.gistack.sm.sjztmd.vo.AttWmstBaseVO">
- select awb.*,arb."name" as resName from sjzt_md."att_wmst_base" awb
- left join sjzt_md."att_res_base" arb on arb.."guid" = awb."res_guid"
+ select awb.*,arb."name" as resName,ad."ad_name" as towns_name,ad2."ad_name" as county_name,ad3."ad_name" as city_name from sjzt_md."att_wmst_base" awb
+ left join sjzt_md."att_res_base" arb on arb."guid" = awb."res_guid"
+ 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>
</select>
</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
index 0d63cb9..dbcfdef 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
@@ -6,4 +6,9 @@
@Data
public class AttWmstBaseVO extends AttWmstBase {
private String resName;
+
+ private String adCode;
+ private String townsName;
+ private String countyName;
+ private String cityName;
}
--
Gitblit v1.9.3