From d2fe6196f1991d10b48adf2debf8521b34f4c461 Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期二, 27 四月 2021 10:04:40 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 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 2c0ffde..fdb8c3d 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
@@ -16,12 +16,14 @@
import com.panzhihua.common.model.vos.user.AdministratorsUserVO;
import com.panzhihua.common.model.vos.user.SysUserNoticeVO;
import com.panzhihua.common.model.vos.user.SysUserVO;
+import com.panzhihua.common.model.vos.user.UpdateUserArchivesVO;
import com.panzhihua.service_user.model.dos.SysUserDO;
import com.panzhihua.service_user.model.dtos.DataKanbanDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
+import org.springframework.web.bind.annotation.RequestParam;
import java.util.Date;
import java.util.List;
@@ -333,11 +335,24 @@
void updateServiceTeam(@Param("newphone")String newphone,@Param("oldphone")String oldphone);
@Select("SELECT\n" +
- "\t COUNT(a.id)\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 \n" +
- "\t u.phone = #{phone}")
+ "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);
+
+ @Select("delete from com_shop_store where delete_status = 1 and phone = #{phone}")
+ void deleteStoreByPhoneAndStatus(@RequestParam("phone") String phone);
+
+ @Select("update sys_user set" +
+ " card_photo_front = #{userArchivesVO.cardPhotoFront} \n" +
+ ", card_photo_back = #{userArchivesVO.cardPhotoBack} \n" +
+ ",family_book = #{userArchivesVO.familyBook} \n" +
+ " where user_id = #{userArchivesVO.userId}")
+ void updateUserArchives(@Param("userArchivesVO") UpdateUserArchivesVO userArchivesVO);
+
}
--
Gitblit v1.7.1