From 04ee9afc3f33f48327e360be965f882ffd2c16be Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期三, 28 七月 2021 16:00:52 +0800 Subject: [PATCH] 修改bug --- springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 10 +++++++--- 1 files changed, 7 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 8fe36a8..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; @@ -413,7 +414,7 @@ @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); - @Update("update lc_compare_code_member set local_grid_member_id = null,grid_member_name = null where local_grid_member_id = #{gridMemberId}") + @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}") @@ -422,10 +423,13 @@ @Delete("delete from event_grid_member_building_relation where grid_member_id = #{gridMemberId}") void delGridMemberRelation(@Param("gridMemberId") Long gridMemberId); - @Select("select id from lc_compare_code_member where local_grid_member_id = #{gridMemberId}") - Long getLcMemberId(@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