湖北水库项目
parent: c0d555bc | patch | commit | ignore whitespace
zrj
2024-06-14 6a885cb950ef8eb50cda4a1da5ed028ee4150946 
海康事件查询修改
1 files modified
3 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkEventMapper.xml 3 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkEventMapper.xml


@@ -30,6 +30,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="hkEvent.resGuid!=null and hkEvent.resGuid!=''">


            and awb."res_guid" = #{hkEvent.resGuid}


        </if>


        <if test="hkEvent.srcName!=null and hkEvent.srcName!=''">


            and she.src_name like concat('%',#{hkEvent.srcName},'%')


        </if>