From 6ca5c72bd4e9825480282baac88de85205db4f66 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期四, 22 四月 2021 13:29:10 +0800
Subject: [PATCH] 新增商家和修改商家bug修复
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 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 14b1d17..fc303e1 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
@@ -331,4 +331,15 @@
void updateMemberRole(@Param("newphone")String newphone,@Param("oldphone")String oldphone);
@Update("update com_pb_service_team u set u.phone=#{newphone},is_reg=1 where u.phone=#{oldphone}")
void updateServiceTeam(@Param("newphone")String newphone,@Param("oldphone")String oldphone);
+
+ @Select("SELECT\n" +
+ "\t COUNT(ur.role_id) \n" +
+ "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);
+
+ @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