From 86246d52fd3def3bd4e915558a3ce2bfcb066a09 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Mon, 13 May 2024 14:04:41 +0800
Subject: [PATCH] 同步责任人使用水库管辖行政区划
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml
index f660ee6..dc8b2c3 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml
@@ -102,7 +102,7 @@
from "SJZT_MD"."att_res_manage_person" tmp
where tmp."user_phone" = a."user_phone")) as role_id
from (select *
- from (select distinct a."user_name", a."user_phone", concat(b."ad_guid", '000000') as "ad_code"
+ from (select distinct a."user_name", a."user_phone", b."interior_ad_guid" as "ad_code"
from "SJZT_MD"."att_res_manage_person" a
left join "SJZT_MD"."att_res_base" b on a."res_guid" = b."guid"
where "user_phone" is not null
--
Gitblit v1.9.3