From a777cbf23ac54f9e2c24bdbad102d45deb0b06b1 Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期三, 29 九月 2021 17:48:03 +0800
Subject: [PATCH] Merge branch 'test' into 'test_bak'
---
springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java | 96 ++++++++++++++++++++++++++++++++---------------
1 files changed, 65 insertions(+), 31 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 90181a6..0d66ff1 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
@@ -1,23 +1,22 @@
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;
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.*;
+import com.panzhihua.common.model.vos.community.screen.civil.CivilVillageStatisticsVO;
+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.*;
-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.*;
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
@@ -44,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
*/
- String getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId);
+ Map<String, String> getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId);
/**
* 查询事件（管理）列表
+ *
* @param page
* @param pageEventManageDTO
* @return
@@ -69,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);
@@ -86,48 +96,72 @@
/**
* 根据网格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);
+
+ 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);
}
--
Gitblit v1.7.1