From fdb9d5f53ee72e765408324ea1a3587a2aff4ca1 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Wed, 12 Jul 2023 09:26:49 +0800
Subject: [PATCH] 水库对应角色人员查询修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml
index 1190e55..49f9062 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml
@@ -101,11 +101,11 @@
left join YWXT.blade_role br on locate(br.id,bu.role_id)>0 and br.is_deleted = 0
where bu.is_deleted = 0
and bd.ad_code in (
- select "ad_code" from SJZT_MD."att_ad_base"
- 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"
+ select "ad_code" from SJZT_MD."att_ad_base"
+ 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 br.role_name like concat('%',#{roleName},'%')
+ and locate(br.role_name,concat('%',#{roleName},'%'))>0
and bu.phone is not null and bu.phone!=''
</select>
--
Gitblit v1.9.3