java/zhihuishenqu.git

New file
			@@ -0,0 +1,393 @@
			package com.panzhihua.service_user.dao;

			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.*;
			import com.panzhihua.common.model.vos.community.acid.ComActAcidCheckRecordVO;
			import com.panzhihua.common.model.vos.community.acid.ComActAcidMemberVO;
			import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO;
			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.*;
			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.springframework.web.bind.annotation.RequestParam;

			import java.util.Date;
			import java.util.List;
			import java.util.Map;

			/**
			* @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);


			IPage<DataKanbanDTO> selectCommunityUserOrder(Page page, @Param("areaCode") String areaCode);

			IPage<DataKanbanDTO> selectCommunityUserOrderMonth(Page page, @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);

			/**
			* 查看是否社工
			*
			* @param phone
			* @param communityId
			* @return
			*/
			int countSocialWorker(@Param("phone") String phone, @Param("communityId") Long communityId);

			/**
			* 查看是否社会组织
			*
			* @param userId
			* @return
			*/
			int countSocialOrg(Long userId);


			/**
			* 查看是否是微团队成员
			*
			* @param phone
			* @param userCommunityId
			* @return
			*/
			int countFmsMember(@Param("phone") String phone, @Param("communityId") Long userCommunityId);

			/**
			* 查询街道信息
			*
			* @param streetId
			* @return
			*/
			ComStreetVO selectStreetById(@Param("streetId") Long streetId);

			/**
			* 查询是否是社会组织成员
			*
			* @param userId
			* @return
			*/
			int countSocialOrgMember(@Param("userId") Long userId);

			/**
			* 查询是否社会组织联系人
			*
			* @param phone
			* @return
			*/
			int countOrgNum(@Param("phone") String phone);

			/**
			* 查询是否人大代表
			*
			* @param phone
			* @param userCommunityId
			* @return
			*/
			int selectCountDpc(@Param("phone") String phone, @Param("userCommunityId") Long userCommunityId);

			/**
			* 查看是否网格员
			*
			* @param phone
			* @param userCommunityId
			* @return
			*/
			int countEasyPhotoMember(@Param("phone") String phone, @Param("communityId") Long userCommunityId);

			/**
			* 查询防疫工作人员信息
			*
			* @param phone
			* @return
			*/
			ComActAcidMemberVO selectAcidMemberByPhone(@Param("phone") String phone);

			/**
			* 查询单位管理员
			*
			* @param phone
			* @return
			*/
			Integer selectOrgAdmin(@Param("phone") String phone);

			/**
			* 查询报道单位id
			*
			* @param phone
			* @return
			*/
			Long selectCheckUnitId(@Param("phone") String phone);

			/**
			* 根据社区名称查询区县社区联动关系
			*
			* @param relationName
			* @return
			*/
			List<ComAreaTownCommunityVO> selectAreaTownCommunity(@Param("relationName") String relationName);

			/**
			* 根据街道id查询区域名称
			*
			* @param streetId
			* @return
			*/
			String selectAreaCodeByStreetId(Long streetId);

			/**
			* 看板用户统计：用户占比统计
			*/
			List<UserProportion> userAnalysis(@Param("type") Integer type, @Param("range") String range, @Param("streetId") Long streetId, @Param("areaCode") Long areaCode, @Param("appId") String appId);

			/**
			* 统计区域实名用户数
			*/
			List<RealUser> realUserCount(@Param("type") Integer type, @Param("range") String range, @Param("streetId") Long streetId, @Param("areaCode") Long areaCode, @Param("appId") String appId);

			/**
			* 统计该街道内的所有用户数
			*/
			Integer streetUserCount(@Param("id") Long id, @Param("areaCode") Long areaCode);

			/**
			* 街道用户统计
			*/
			IndexDataKanbanVO dataKanBanStreet(@Param("streetId") Long streetId, @Param("areaCode") Long areaCode, @Param("range") String range);

			/**
			* 获取当天的新增和日活
			*/
			Map<String, Long> getDailyAddAndActive(@Param("date") Date date, @Param("id") Long streetId, @Param("areaCode") Long areaCode, @Param("appId") String appId);

			Map<String, Long> getDailyAdd(@Param("createAt") String createAt, @Param("id") Long streetId, @Param("areaCode") Long areaCode, @Param("appId") String appId);

			Map<String, Long> getActive(@Param("lastLoginTime") String lastLoginTime, @Param("id") Long streetId, @Param("areaCode") Long areaCode, @Param("appId") String appId);


			List<StreetVOS> selectStreetByAreaCode(Integer code);

			List<StreetVO> selectStreetsByAreaCode(Integer code);

			ComActAcidCheckRecordVO selectComActAcidCheckRecordById(Long id);

			ComActAcidRecordVO selectComActAcidRecord(Long id);

			ComActAcidMemberVO selectComActAcidMember(Long id);

			/**
			* 获取本月的
			*/
			Integer getMonthUsers(@Param("streetId") Long streetId, @Param("areaCode") Long areaCode, @Param("range") String range, @Param("appId") String appId);

			/**
			* 获取街道下属村/社区
			*/
			List<CommunityVO> selectCommunityByStreetId(@Param("id") Long streetId, @Param("type") Integer type);

			/**
			* 获取账户id
			*/
			List<Integer> selectIdsByAccount(@Param("array") String[] streetList);

			List<CommunityVO> selectCommunityByStreetName(String name);

			StreetVOS selectStreetByName(String name);
			}