From cf3b4b7fc95fd5b83cae6842e8c24b99e70068e0 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期二, 27 四月 2021 16:55:07 +0800
Subject: [PATCH] 修复bug

---
 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java |   11 ++++++++++-
 1 files changed, 10 insertions(+), 1 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 d7f8f47..ad1b6d6 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,6 +16,7 @@
 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;
@@ -160,7 +161,7 @@
             "from sys_user u\n" +
             "left join com_act a on u.community_id=a.community_id\n" +
             " where\n" +
-            "u.type=1\n" +
+            "u.type=1 and community_id is not null \n" +
             "<if test='pageUserAppletsBackstageDTO.phone != null and pageUserAppletsBackstageDTO.phone.trim() != &quot;&quot;'>" +
             "and u.phone=#{pageUserAppletsBackstageDTO.phone}\n" +
             " </if> " +
@@ -346,4 +347,12 @@
 
     @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