预警人员（除责任人外的）查询调整

zrj

2024-06-28 4093ca7ac7e095f36c65ba564773caa4765d92c4

预警人员（除责任人外的）查询调整

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml

@@ -144,7 +144,10 @@
            start with "ad_code" = (select "interior_ad_guid" from SJZT_MD."att_res_base" where "guid" = #{res_cd} )
            CONNECT BY PRIOR "p_ad_code"  =  "ad_code"
        )
        and locate(br.role_name,concat('%',#{roleName},'%'))>0
        and br.role_name in
        <foreach collection="roleName.split(',')" item="item" index="index" open="(" separator="," close=")">
            #{item}
        </foreach>
        and bu.phone is not null and bu.phone!=''
    </select>