视频设备列表增加查询条件

xieb

2024-05-06 9a5fbc0c9584fd09d79adbeb65832bc3dddf963d

视频设备列表增加查询条件

 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>

 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;
}