huanghongfa
2021-09-02 177249c76aeea0b4bf8d8816d4994e3b445b45ce
springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java
@@ -1,5 +1,10 @@
package com.panzhihua.service_grid.dao;
import java.util.List;
import java.util.Map;
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;
@@ -12,11 +17,6 @@
import com.panzhihua.common.model.vos.grid.*;
import com.panzhihua.common.model.vos.screen.*;
import com.panzhihua.service_grid.model.dos.EventDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
/**
 * DAO
@@ -43,23 +43,30 @@
     * @param pagePublicityEventDTO
     * @return
     */
    IPage<EventVO> findPublicityByPage(Page page, @Param("pagePublicityEventDTO") PagePublicityEventDTO pagePublicityEventDTO);
    IPage<EventVO> findPublicityByPage(Page page,
        @Param("pagePublicityEventDTO") PagePublicityEventDTO pagePublicityEventDTO);
    /**
     * 地图模块-根据网格id查询网格办件事件
     * @param gridId    网格id
     * @return  网格办件事件
     *
     * @param gridId
     *            网格id
     * @return 网格办件事件
     */
    List<ComMapGridEventVO> getEventByGridId(@Param("gridId") Long gridId);
    /**
     * 根据网格员id查询网格员头像url
     * @param gridMemberId  网格员id
     * @return  头像url
     *
     * @param gridMemberId
     *            网格员id
     * @return 头像url
     */
    Map<String,String> getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId);
    Map<String, String> getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId);
    /**
     * 查询事件(管理)列表
     *
     * @param page
     * @param pageEventManageDTO
     * @return
@@ -68,16 +75,20 @@
    /**
     * 查询事件(管理)列表
     *
     * @param page
     * @param pagePublicityEventCommunityDTO
     * @return
     */
    IPage<EventVO> findCommunityPublicityByPage(Page page, @Param("pagePublicityEventCommunityDTO") PagePublicityEventCommunityDTO pagePublicityEventCommunityDTO);
    IPage<EventVO> findCommunityPublicityByPage(Page page,
        @Param("pagePublicityEventCommunityDTO") PagePublicityEventCommunityDTO pagePublicityEventCommunityDTO);
    /**
     * 后台管理-统计模块
     * @param communityId   社区id
     * @return  统计信息
     *
     * @param communityId
     *            社区id
     * @return 统计信息
     */
    EventStatisticsAllAdminVO eventStatistics(@Param("communityId") Long communityId);
@@ -85,52 +96,64 @@
    /**
     * 根据网格id查询网格统计数据
     * @param gridId    网格id
     * @return  网格统计数据
     *
     * @param gridId
     *            网格id
     * @return 网格统计数据
     */
    GridEventStatisticsVO getGridEventStatisticsByApp(@Param("gridId") Long gridId);
    /**
     * 查询网格事件统计数据
     * @param statisticsDTO 请求参数
     * @return  网格事件统计数据
     *
     * @param statisticsDTO
     *            请求参数
     * @return 网格事件统计数据
     */
    GridEventStatisticsDetailVO getGridEventDetailStatisticsByApp(@Param("statisticsDTO") GridEventStatisticsDTO statisticsDTO);
    GridEventStatisticsDetailVO
        getGridEventDetailStatisticsByApp(@Param("statisticsDTO") GridEventStatisticsDTO statisticsDTO);
    /**
     * 查询时间发布者基本信息
     *
     * @param gridMemberId
     * @return
     */
    Map<String, Object> getUserBaseInfo(@Param("gridMemberId")Long gridMemberId);
    Map<String, Object> getUserBaseInfo(@Param("gridMemberId") Long gridMemberId);
    /**
     * 事件大屏查询事件列表
     * @param eventListDTO  请求参数
     * @return  事件列表
     *
     * @param eventListDTO
     *            请求参数
     * @return 事件列表
     */
    IPage<EventListVO> getScreenEventList(Page page, @Param("eventListDTO") ScreenEventListDTO eventListDTO);
    /**
     * 特殊人群上报-社区人口数据列表
     * @param specialPopulationDTO   请求参数
     * @return  社区人口数据列表
     *
     * @param specialPopulationDTO
     *            请求参数
     * @return 社区人口数据列表
     */
    IPage<EventSpecialPopulationVO> specialPopulationList(Page page, @Param("specialPopulationDTO") PageEventSpecialPopulationDTO specialPopulationDTO);
    IPage<EventSpecialPopulationVO> specialPopulationList(Page page,
        @Param("specialPopulationDTO") PageEventSpecialPopulationDTO specialPopulationDTO);
    Map<String,Long> countByCommunityId(@Param("communityId") Long communityId,@Param("nowDate")String nowDate);
    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);
    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);
    Map<String, Long> getSSPEventTotal(@Param("communityId") Long communityId);
    List<EventGridIncidentStatisticsVO> getEventListByCommunityId(@Param("communityId") Long communityId);
@@ -138,7 +161,7 @@
    ScreenDrawEventPopulationTotalVO getVillagePopulationTotal(@Param("villageId") Long villageId);
    List<Map<String,Object>> getMemberBuildName(@Param("userId") Long userId);
    List<Map<String, Object>> getMemberBuildName(@Param("userId") Long userId);
    Integer getPopulationByLabelCount(@Param("floor") String floor,@Param("villageId") Long villageId);
    Integer getPopulationByLabelCount(@Param("floor") String floor, @Param("villageId") Long villageId);
}