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