From c8164600f68fe3e4b5fc467cac0d7520a5215409 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 06 Jul 2023 10:21:16 +0800
Subject: [PATCH] 巡检任务增加曾都区试点

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml |    1 +
 1 files changed, 1 insertions(+), 0 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 c26728d..a71254b 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
@@ -31,6 +31,7 @@
         WHERE a."user_phone" = b.PHONE
           and a."res_guid" = c."guid"
           and a."type" = 5
+          and c."interior_ad_guid" like '421303%'
     </select>
 
     <update id="updateResManagePersonByGuid">

--
Gitblit v1.9.3