package com.panzhihua.service_user.dao;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.panzhihua.common.model.vos.community.*;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.*;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.web.bind.annotation.RequestParam;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.dtos.PageDTO;
|
import com.panzhihua.common.model.dtos.community.ExportUserDTO;
|
import com.panzhihua.common.model.dtos.grid.EventGridMemberEditStatusDTO;
|
import com.panzhihua.common.model.dtos.grid.EventGridMemberPassResetDTO;
|
import com.panzhihua.common.model.dtos.grid.PageEventGridMemberRelationDTO;
|
import com.panzhihua.common.model.dtos.user.EexcelUserDTO;
|
import com.panzhihua.common.model.dtos.user.PageUserAppletsBackstageDTO;
|
import com.panzhihua.common.model.vos.AppletUserInfoVO;
|
import com.panzhihua.common.model.vos.IndexDataKanbanVO;
|
import com.panzhihua.common.model.vos.IndexDataVO;
|
import com.panzhihua.common.model.vos.LoginUserInfoVO;
|
import com.panzhihua.common.model.vos.community.screen.event.EventGridMemberVO;
|
import com.panzhihua.common.model.vos.grid.GridMemberVO;
|
import com.panzhihua.common.model.vos.partybuilding.ComPbServiceTeamWishVO;
|
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;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 用户
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-11-20 15:55
|
**/
|
@Mapper
|
public interface UserDao extends BaseMapper<SysUserDO> {
|
|
|
IPage<LoginUserInfoVO> pageUserFace(Page page, @Param("loginUserInfoVO") LoginUserInfoVO loginUserInfoVO);
|
|
|
IPage<AppletUserInfoVO> pageUser(Page page, @Param("loginUserInfoVO") AppletUserInfoVO userInfoVO);
|
|
|
IPage<AdministratorsUserVO> pageUserBackstage(Page page,
|
@Param("administratorsUserVO") AdministratorsUserVO administratorsUserVO);
|
|
|
IPage<SysUserVO> pageUserAppletsBackstage(Page page,
|
@Param("pageUserAppletsBackstageDTO") PageUserAppletsBackstageDTO pageUserAppletsBackstageDTO);
|
|
|
int deleteUserTest(Long userId);
|
|
|
IPage<SysUserNoticeVO> pageNotice(Page page, @Param("pageDTO") PageDTO pageDTO);
|
|
|
IndexDataKanbanVO selectIndexDataKanban(@Param("areaCode") String areaCode);
|
|
|
List<DataKanbanDTO> selectCommunityUserOrder(@Param("areaCode")String areaCode);
|
|
List<DataKanbanDTO> selectCommunityUserOrderMonth(@Param("areaCode")String areaCode);
|
|
|
DataKanbanDTO selectCommunityActiveUserOrder(Date date1);
|
|
DataKanbanDTO selectCommunityAddUserOrder(@Param("areaCode")String areaCode,@Param("date1")Date date1);
|
|
|
IndexDataVO indexDataCommunityBackstage(Long communityId);
|
|
|
int timedTaskContinuousLandingDays();
|
|
|
ComMngVolunteerMngVO selectVolunteerMngByPhone(String phone);
|
|
|
int updateFaceState(Long userId);
|
|
|
ComActVO selectCommunity(Long communityId);
|
|
|
Integer selectCountArea(String areaName);
|
|
|
Integer selectCountHouse(String areaName);
|
|
|
List<EexcelUserDTO> selectExport(@Param("exportUserDTO") ExportUserDTO exportUserDTO);
|
|
|
Integer selectCountMemberRole(@Param("phone") String phone, @Param("userCommunityId") Long userCommunityId);
|
|
|
Integer selectCountTeam(@Param("phone") String phone, @Param("userCommunityId") Long userCommunityId);
|
|
|
void updateMemberRole(@Param("newphone") String newphone, @Param("oldphone") String oldphone);
|
|
|
void updateServiceTeam(@Param("newphone") String newphone, @Param("oldphone") String oldphone);
|
|
|
Integer selectCountSysUser(@Param("phone") String phone, @Param("userCommunityId") Long userCommunityId);
|
|
|
void updateStoreByPhone(@Param("phone") String phone, @Param("sysUserId") Long sysUserId);
|
|
|
void deleteStoreByPhoneAndStatus(@RequestParam("phone") String phone);
|
|
|
void updateUserArchives(@Param("userArchivesVO") UpdateUserArchivesVO userArchivesVO);
|
|
|
void updateComPbMemberUserId(@Param("idCard") String idCard, @Param("userId") Long userId);
|
|
|
Long getPartyBuildingByIdCard(@Param("idCard") String idCard);
|
|
|
IPage<GridMemberVO> getGridMemberList(Page page,
|
@Param("memberRelationDTO") PageEventGridMemberRelationDTO memberRelationDTO);
|
|
|
void gridMemberEditStatus(@Param("gridMemberEditDTO") EventGridMemberEditStatusDTO gridMemberEditDTO);
|
|
|
void passResetUser(@Param("gridMemberDTO") EventGridMemberPassResetDTO gridMemberDTO);
|
|
|
void addLcMember(@Param("lcMemberId") Long lcMemberId, @Param("userId") Long userId,
|
@Param("userName") String userName);
|
|
|
void delLcMember(@Param("gridMemberId") Long gridMemberId);
|
|
|
Map<String, Long> getBuilding(@Param("buildingId") Long buildingId);
|
|
|
void delGridMemberRelation(@Param("gridMemberId") Long gridMemberId);
|
|
|
Map<String, String> getLcMemberId(@Param("gridMemberId") Long gridMemberId);
|
|
|
Integer getGridIsOk(@Param("userId") Long userId);
|
|
List<EventGridMemberVO> getGridsMemberList(@Param("communityId") Long communityId);
|
|
|
List<ComPbServiceTeamWishVO> getServiceTeamList(@Param("param") String param,
|
@Param("communityId") Long communityId);
|
|
|
List<SysUserVO> getUserListByCommunityId(@Param("communityId") Long communityId);
|
|
int putUserTag(@Param("sysUserDO") SysUserDO sysUserDO);
|
|
/**
|
* 禁用/启用便民服务商家账号
|
* @param status
|
* @param userIds
|
* @return
|
*/
|
int disableOrEnableMerchantUsers(@Param("status") Integer status, @Param("userIds") List<Long> userIds);
|
|
/**
|
* 根据手机号维护社区团队表是否注册
|
* @param phone 手机号
|
*/
|
void judgeCommunityTeam(@Param("phone") String phone);
|
|
/**
|
* 根据手机号查询社区团队表中用户数量
|
* @param phone 手机号
|
* @return 用户数量
|
*/
|
Integer getCommunityTeamCount(@Param("phone") String phone);
|
|
/**
|
* 查询西区所有街道列表以及统计人数
|
* @return 西区所有街道列表以及统计人数
|
*/
|
List<IndexUserStreetVo> getUserStreetList(@Param("areaCode") String areaCode);
|
|
/**
|
* 查询街道下社区列表以及统计人数
|
* @param streetId 街道id
|
* @return 社区列表以及统计人数
|
*/
|
List<IndexUserCommunityVo> getUserCommunityList(@Param("streetId") Long streetId);
|
|
/**
|
* 查询街道下社区注册人数统计数据导出
|
* @return 社区注册人数统计数据导出
|
*/
|
List<IndexUserStreetExcelExportVo> getUserCommunityExcelExport(String areaCode);
|
|
/**
|
* 查看是否是社区物业人员
|
* @param userId
|
* @param userCommunityId
|
* @return
|
*/
|
int countPropertyWorker(@Param("userId") Long userId, @Param("communityId") Long userCommunityId);
|
}
|
