From 53f8efd5655c310d2c8d2a8f2218f2fcd559cdd6 Mon Sep 17 00:00:00 2001 From: CeDo <cedoogle@gmail.com> Date: 星期三, 28 四月 2021 15:16:57 +0800 Subject: [PATCH] no --- springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 4 ++-- 1 files changed, 2 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..4d57485 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); -- Gitblit v1.7.1