花城-智慧社区
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
huanghongfa
2021-08-05 31eb44e38f79f3011ce19eb5bc657a08ab22cc3b 
 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);




}