package com.panzhihua.service_community.dao;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import com.panzhihua.service_community.model.dos.EventDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
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.community.bigscreen.event.ScreenEventListDTO;
|
import com.panzhihua.common.model.dtos.grid.GridEventStatisticsDTO;
|
import com.panzhihua.common.model.dtos.grid.PageEventDTO;
|
import com.panzhihua.common.model.dtos.grid.PageEventManageDTO;
|
import com.panzhihua.common.model.dtos.grid.PageEventSpecialPopulationDTO;
|
import com.panzhihua.common.model.dtos.grid.PagePublicityEventCommunityDTO;
|
import com.panzhihua.common.model.dtos.grid.PagePublicityEventDTO;
|
import com.panzhihua.common.model.vos.community.StatisticsCommVO;
|
import com.panzhihua.common.model.vos.community.screen.civil.CivilVillageStatisticsVO;
|
import com.panzhihua.common.model.vos.community.screen.event.EventComprehensiveGovernanceStatisticsVO;
|
import com.panzhihua.common.model.vos.community.screen.event.EventGridIncidentStatisticsVO;
|
import com.panzhihua.common.model.vos.community.screen.event.EventListVO;
|
import com.panzhihua.common.model.vos.grid.ComMapGridEventVO;
|
import com.panzhihua.common.model.vos.grid.EventSpecialPopulationVO;
|
import com.panzhihua.common.model.vos.grid.EventStatisticsAllAdminVO;
|
import com.panzhihua.common.model.vos.grid.EventVO;
|
import com.panzhihua.common.model.vos.grid.GridEventStatisticsDetailVO;
|
import com.panzhihua.common.model.vos.grid.GridEventStatisticsVO;
|
import com.panzhihua.common.model.vos.screen.DateScreenVO;
|
import com.panzhihua.common.model.vos.screen.EventDetailWorkVO;
|
import com.panzhihua.common.model.vos.screen.EventTypeWorkVO;
|
import com.panzhihua.common.model.vos.screen.EventWorkVO;
|
import com.panzhihua.common.model.vos.screen.ScreenDrawEventPopulationTotalVO;
|
|
/**
|
* DAO
|
*
|
* @author cedoo email:cedoo(a)qq.com
|
* @version 1.0
|
* @date 2021-05-26
|
* @since 1.0
|
*/
|
@Mapper
|
public interface EventMapper extends BaseMapper<EventDO> {
|
|
/**
|
* 分页查询事件
|
*
|
* @param pageEventDTO
|
* @return
|
*/
|
IPage<EventVO> findByPage(Page page, @Param("pageEventDTO") PageEventDTO pageEventDTO);
|
|
/**
|
* 分页查询宣传教育
|
*
|
* @param pagePublicityEventDTO
|
* @return
|
*/
|
IPage<EventVO> findPublicityByPage(Page page,
|
@Param("pagePublicityEventDTO") PagePublicityEventDTO pagePublicityEventDTO);
|
|
/**
|
* 地图模块-根据网格id查询网格办件事件
|
*
|
* @param gridId
|
* 网格id
|
* @return 网格办件事件
|
*/
|
List<ComMapGridEventVO> getEventByGridId(@Param("gridId") Long gridId);
|
|
/**
|
* 根据网格员id查询网格员头像url
|
*
|
* @param gridMemberId
|
* 网格员id
|
* @return 头像url
|
*/
|
Map<String, String> getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId);
|
|
/**
|
* 查询事件（管理）列表
|
*
|
* @param page
|
* @param pageEventManageDTO
|
* @return
|
*/
|
IPage<EventVO> findToManageByPage(Page page, @Param("pageEventManageDTO") PageEventManageDTO pageEventManageDTO);
|
|
/**
|
* 查询事件（管理）列表
|
*
|
* @param page
|
* @param pagePublicityEventCommunityDTO
|
* @return
|
*/
|
IPage<EventVO> findCommunityPublicityByPage(Page page,
|
@Param("pagePublicityEventCommunityDTO") PagePublicityEventCommunityDTO pagePublicityEventCommunityDTO);
|
|
/**
|
* 后台管理-统计模块
|
*
|
* @param communityId
|
* 社区id
|
* @return 统计信息
|
*/
|
EventStatisticsAllAdminVO eventStatistics(@Param("communityId") Long communityId);
|
|
Integer getEventCountByGridIds(@Param("ids") List<Long> ids);
|
|
/**
|
* 根据网格id查询网格统计数据
|
*
|
* @param gridId
|
* 网格id
|
* @return 网格统计数据
|
*/
|
GridEventStatisticsVO getGridEventStatisticsByApp(@Param("gridId") Long gridId);
|
|
/**
|
* 查询网格事件统计数据
|
*
|
* @param statisticsDTO
|
* 请求参数
|
* @return 网格事件统计数据
|
*/
|
GridEventStatisticsDetailVO
|
getGridEventDetailStatisticsByApp(@Param("statisticsDTO") GridEventStatisticsDTO statisticsDTO);
|
|
/**
|
* 查询时间发布者基本信息
|
*
|
* @param gridMemberId
|
* @return
|
*/
|
Map<String, Object> getUserBaseInfo(@Param("gridMemberId") Long gridMemberId);
|
|
/**
|
* 事件大屏查询事件列表
|
*
|
* @param eventListDTO
|
* 请求参数
|
* @return 事件列表
|
*/
|
IPage<EventListVO> getScreenEventList(Page page, @Param("eventListDTO") ScreenEventListDTO eventListDTO);
|
|
/**
|
* 特殊人群上报-社区人口数据列表
|
*
|
* @param specialPopulationDTO
|
* 请求参数
|
* @return 社区人口数据列表
|
*/
|
IPage<EventSpecialPopulationVO> specialPopulationList(Page page,
|
@Param("specialPopulationDTO") PageEventSpecialPopulationDTO specialPopulationDTO);
|
|
Map<String, Long> countByCommunityId(@Param("communityId") Long communityId, @Param("nowDate") String nowDate);
|
|
DateScreenVO countByAvgCommunityId(@Param("communityId") Long communityId);
|
|
List<EventDetailWorkVO> getWorkScreenEventList(@Param("communityId") Long communityId);
|
|
EventWorkVO countByTime(@Param("start") String start, @Param("end") String end,
|
@Param("communityId") Long communityId);
|
|
EventTypeWorkVO getComplete(@Param("communityId") Long communityId);
|
|
EventTypeWorkVO getNoComplete(@Param("communityId") Long communityId);
|
|
Map<String, Long> getSSPEventTotal(@Param("communityId") Long communityId);
|
|
List<EventGridIncidentStatisticsVO> getEventListByCommunityId(@Param("communityId") Long communityId);
|
|
List<CivilVillageStatisticsVO> getCivilScreenVillageList(@Param("communityId") Long communityId);
|
|
ScreenDrawEventPopulationTotalVO getVillagePopulationTotal(@Param("villageId") Long villageId);
|
|
List<Map<String, Object>> getMemberBuildName(@Param("userId") Long userId);
|
|
Integer getPopulationByLabelCount(@Param("floor") String floor, @Param("villageId") Long villageId);
|
|
/**
|
* 西区大数据分析平台-综合治理栏数据
|
* @return
|
*/
|
EventComprehensiveGovernanceStatisticsVO selectComprehensiveGovernanceStatics();
|
|
List<EventGridIncidentStatisticsVO> getGridsGovernanceEventList(@Param("communityId") Long communityId);
|
|
ScreenDrawEventPopulationTotalVO getVillagePopulationTotalNew(@Param("villageId") Long villageId);
|
|
List<StatisticsCommVO> selectStatisticsForAge(@Param("villageIds") List<Long> villageIds);
|
}
|
