From 31eb44e38f79f3011ce19eb5bc657a08ab22cc3b Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期四, 05 八月 2021 14:06:42 +0800
Subject: [PATCH] 实名认证接口修改

---
 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java |   29 +++++++++++++++++++++++------
 1 files changed, 23 insertions(+), 6 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 68dd1f6..c5b6c75 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.LoginUserInfoVO;
 import com.panzhihua.common.model.vos.community.ComActVO;
 import com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO;
+import com.panzhihua.common.model.vos.community.screen.event.EventGridMemberVO;
 import com.panzhihua.common.model.vos.grid.GridMemberVO;
 import com.panzhihua.common.model.vos.user.AdministratorsUserVO;
 import com.panzhihua.common.model.vos.user.SysUserNoticeVO;
@@ -23,14 +24,12 @@
 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.apache.ibatis.annotations.*;
 import org.springframework.web.bind.annotation.RequestParam;
 
 import java.util.Date;
 import java.util.List;
+import java.util.Map;
 
 /**
  * @program: springcloud_k8s_panzhihuazhihuishequ
@@ -412,7 +411,25 @@
             "</script>")
     void passResetUser(@Param("gridMemberDTO") EventGridMemberPassResetDTO gridMemberDTO);
 
-//    @Update("update lc_compare_code_member set local_grid_member_id = #{userId},grid_member_name = #{userName} where id = #{lcMemberId}")
-//    void addLcMember(@Param("lcMemberId") Long lcMemberId,@Param("userId") Long userId,@Param("userName") Long userName);
+    @Update("update lc_compare_code_member set local_grid_member_id = #{userId},grid_member_name = #{userName} where id = #{lcMemberId}")
+    void addLcMember(@Param("lcMemberId") Long lcMemberId,@Param("userId") Long userId,@Param("userName") String userName);
+
+    @Delete("delete from lc_compare_code_member where local_grid_member_id = #{gridMemberId}")
+    void delLcMember(@Param("gridMemberId") Long gridMemberId);
+
+    @Select("select id,village_id,act_id from com_mng_building where id = #{buildingId}")
+    Map<String,Long> getBuilding(@Param("buildingId") Long buildingId);
+
+    @Delete("delete from event_grid_member_building_relation where grid_member_id = #{gridMemberId}")
+    void delGridMemberRelation(@Param("gridMemberId") Long gridMemberId);
+
+    @Select("select lc_grid_member_id,lc_grid_member_name,lc_bind_user_id from lc_compare_code_member where local_grid_member_id = #{gridMemberId}")
+    Map<String,String> getLcMemberId(@Param("gridMemberId") Long gridMemberId);
+
+    @Select("select count(id) from event_grid_member_relation where grid_member_id = #{userId}")
+    Integer getGridIsOk(@Param("userId") Long userId);
+
+    @Select("select user_id,nick_name,phone from sys_user where type = 6 and community_id = #{communityId} limit 3")
+    List<EventGridMemberVO> getGridsMemberList(@Param("communityId") Long communityId);
 
 }

--
Gitblit v1.7.1