From 05bd97aab35b27be282fd45d013e1330edda2cc0 Mon Sep 17 00:00:00 2001 From: xyh <18782104331@139.com> Date: 星期二, 29 六月 2021 16:21:53 +0800 Subject: [PATCH] 修复bug-401-【综治后台管理--事件管理】搜索事件功能未生效 --- springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java | 75 ++++++++++++++++++++++++++++++++++--- 1 files changed, 69 insertions(+), 6 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java index 1e65581..90181a6 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java @@ -4,17 +4,20 @@ 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.grid.PageEventDTO; -import com.panzhihua.common.model.dtos.grid.PageEventManageDTO; -import com.panzhihua.common.model.dtos.grid.PagePublicityEventDTO; -import com.panzhihua.common.model.vos.grid.ComMapGridEventVO; -import com.panzhihua.common.model.vos.grid.EventStatisticsAllAdminVO; +import com.panzhihua.common.model.dtos.community.bigscreen.event.ScreenEventListDTO; +import com.panzhihua.common.model.dtos.grid.*; +import com.panzhihua.common.model.vos.community.screen.event.EventListVO; +import com.panzhihua.common.model.vos.grid.*; +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.service_grid.model.dos.EventDO; -import com.panzhihua.common.model.vos.grid.EventVO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; +import java.util.Map; /** * DAO @@ -64,7 +67,67 @@ */ 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); } -- Gitblit v1.7.1