From a7d2d03fe177a58c22e960e9c87b32f7b05be74f Mon Sep 17 00:00:00 2001
From: CeDo <cedoo@qq.com>
Date: 星期六, 01 五月 2021 22:57:48 +0800
Subject: [PATCH] add:添加小程序实名认证接口过滤（部分）
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
index b919532..c9d59c6 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
@@ -339,8 +339,8 @@
"FROM\n" +
"\t sys_user u LEFT JOIN sys_user_role ur ON u.user_id = ur.user_id \n" +
"\t LEFT JOIN sys_role r ON ur.role_id = r.role_id \n" +
- "WHERE ur.role_id IS NOT NULL AND u.phone = #{phone} ")
- Integer selectCountSysUser(@Param("phone")String phone);
+ "WHERE ur.role_id IS NOT NULL AND u.phone = #{phone} and r.community_id=#{userCommunityId} ")
+ Integer selectCountSysUser(@Param("phone")String phone, @Param("userCommunityId")Long userCommunityId);
@Select("update com_shop_store set sys_user_id = #{sysUserId} where phone = #{phone}")
void updateStoreByPhone(@Param("phone")String phone, @Param("sysUserId")Long sysUserId);
@@ -355,4 +355,10 @@
" where user_id = #{userArchivesVO.userId}")
void updateUserArchives(@Param("userArchivesVO") UpdateUserArchivesVO userArchivesVO);
+ @Select("update com_pb_member set user_id = #{userId} where audit_result = 1 and id_card = #{idCard}")
+ void updateComPbMemberUserId(@Param("idCard")String idCard, @Param("userId")Long userId);
+
+ @Select("select id from com_pb_member where audit_result = 1 and id_card = #{idCard}")
+ Long getPartyBuildingByIdCard(@Param("idCard")String idCard);
+
}
--
Gitblit v1.7.1