From c3811d01d1929a98a0f34f70ca187d82ee312dbb Mon Sep 17 00:00:00 2001
From: manailin <261030956@qq.com>
Date: 星期三, 03 十一月 2021 17:26:50 +0800
Subject: [PATCH] Merge branch 'test' of http://gitlab.nhys.cdnhxx.com/root/zhihuishequ into test

---
 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java | 1860 +++++++++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 1,476 insertions(+), 384 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
index c1edcd6..a1038a9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
@@ -1,47 +1,58 @@
 package com.panzhihua.service_grid.service.impl;
 
+import java.text.SimpleDateFormat;
+import java.util.*;
+
+import javax.annotation.Resource;
+
+import org.springframework.beans.BeanUtils;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.CollectionUtils;
+
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.panzhihua.common.enums.EventType;
 import com.panzhihua.common.exceptions.ServiceException;
 import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO;
+import com.panzhihua.common.model.dtos.community.bigscreen.event.ScreenDrawEventListDTO;
+import com.panzhihua.common.model.dtos.community.bigscreen.event.ScreenEventListDTO;
 import com.panzhihua.common.model.dtos.grid.*;
 import com.panzhihua.common.model.vos.R;
 import com.panzhihua.common.model.vos.community.ComActVO;
-import com.panzhihua.common.model.vos.grid.EventDetailsVO;
-import com.panzhihua.common.model.vos.grid.EventResourceVO;
-import com.panzhihua.common.model.vos.grid.EventTransferRecordVO;
-import com.panzhihua.common.model.vos.grid.EventVO;
+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.EventLeftDownStatisticsVO;
+import com.panzhihua.common.model.vos.community.screen.event.EventListVO;
+import com.panzhihua.common.model.vos.grid.*;
+import com.panzhihua.common.model.vos.screen.*;
 import com.panzhihua.common.service.community.CommunityService;
+import com.panzhihua.common.utlis.DateUtils;
+import com.panzhihua.common.utlis.GisPointUtil;
+import com.panzhihua.common.utlis.LngLatUtils;
 import com.panzhihua.common.utlis.StringUtils;
 import com.panzhihua.service_grid.dao.*;
 import com.panzhihua.service_grid.model.dos.*;
-import com.panzhihua.service_grid.service.EventResourceService;
-import com.panzhihua.service_grid.service.EventService;
-import com.panzhihua.service_grid.service.EventTransferRecordService;
-import lombok.extern.slf4j.Slf4j;
-import org.springframework.stereotype.Service;
-import org.springframework.beans.BeanUtils;
-import org.springframework.transaction.annotation.Transactional;
+import com.panzhihua.service_grid.service.*;
 
-import javax.annotation.Resource;
-import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
+import cn.hutool.core.date.DateTime;
+import cn.hutool.core.date.DateUtil;
+import cn.hutool.core.util.IdcardUtil;
+import lombok.extern.slf4j.Slf4j;
 
 /**
- * @author cedoo
- * 2021-04-14 15:03:01
- * 订单表服务实现类
+ * @author cedoo 2021-04-14 15:03:01 订单表服务实现类
  */
 @Slf4j
 @Service
 public class EventServiceImpl extends ServiceImpl<EventMapper, EventDO> implements EventService {
 
+    private final String moth_format_str = "yyyy-MM";
+    private final String[] monthStr = new String[] {"一", "二", "三", "四", "五", "六", "七", "八", "九", "十", "十一", "十二"};
     @Resource
     private EventMapper eventMapper;
     @Resource
@@ -52,35 +63,44 @@
     private CommunityService communityService;
     @Resource
     private EventGridDataMapper eventGridDataMapper;
+    @Resource
+    private EventGridMemberRelationMapper eventGridMemberRelationMapper;
+    @Resource
+    private EventSpecialCrowdRecordService eventSpecialCrowdRecordService;
+    @Resource
+    private EventSpecialCrowdRecordMapper eventSpecialCrowdRecordMapper;
+    @Resource
+    private EventGridDataService eventGridDataService;
+    @Resource
+    private EventResourceMapper eventResourceMapper;
 
     /**
      * 分页查找事件
+     *
      * @param pageEventDTO
      * @return 维护结果
      */
     @Override
-    public R<IPage<EventVO>> query(PageEventDTO pageEventDTO){
-        Page page = new Page(1,10);
-        if(pageEventDTO.getPageNum()!=null) {
+    public R<IPage<EventVO>> query(PageEventDTO pageEventDTO) {
+        Page page = new Page(1, 10);
+        if (pageEventDTO.getPageNum() != null) {
             page.setCurrent(pageEventDTO.getPageNum());
         }
-        if(pageEventDTO.getPageSize()!=null) {
+        if (pageEventDTO.getPageSize() != null) {
             page.setSize(pageEventDTO.getPageSize());
         }
         IPage<EventVO> ipage = eventMapper.findByPage(page, pageEventDTO);
-        if(ipage!=null){
+        if (ipage != null) {
             List<EventVO> eventVOList = ipage.getRecords();
             eventVOList.forEach(eventVO -> {
                 List<EventResourceDO> eventResourceDOList =
-                        eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification, 1)
-                                .eq(EventResourceDO::getRefId, eventVO.getId())
-                        );
+                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                        .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId()));
                 List<EventResourceVO> picList = new ArrayList<>();
                 List<EventResourceVO> audioList = new ArrayList<>();
                 List<EventResourceVO> videoList = new ArrayList<>();
                 eventResourceDOList.forEach(eventResourceDO -> {
-                    switch (eventResourceDO.getType()){
+                    switch (eventResourceDO.getType()) {
                         case 1:
                             EventResourceVO picEventResourceVO = new EventResourceVO();
                             BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -102,10 +122,11 @@
                 eventVO.setPics(picList);
                 eventVO.setVideos(videoList);
 
-                //查询网格员头像
-                String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId());
-                if(StringUtils.isNotEmpty(imageUrl)){
-                    eventVO.setGridMemberImageUrl(imageUrl);
+                // 查询网格员头像
+                Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId());
+                if (StringUtils.isNotEmpty(userMap)) {
+                    eventVO.setGridMemberName(userMap.get("nick_name"));
+                    eventVO.setGridMemberImageUrl(userMap.get("image_url"));
                 }
             });
             return R.ok(ipage);
@@ -115,52 +136,55 @@
 
     /**
      * 删除事件
+     *
      * @param commonEventDeleteDTO
      * @return 平台用户信息
      */
     @Override
-    public R delete(CommonEventDeleteDTO commonEventDeleteDTO){
+    public R delete(CommonEventDeleteDTO commonEventDeleteDTO) {
         EventDO eventDO = eventMapper.selectById(commonEventDeleteDTO.getId());
-        if(eventDO==null){
+        if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        if(eventDO.getEventStatus()!=null &&
-                (eventDO.getEventStatus().intValue()==1||eventDO.getEventStatus().intValue()==4)){//草稿 或者 已撤销 的事件可以删除
-            eventDO.setEventStatus(3);//逻辑删除
+        if (eventDO.getEventStatus() != null
+            && (eventDO.getEventStatus().intValue() == 1 || eventDO.getEventStatus().intValue() == 4)) {// 草稿 或者 已撤销
+                                                                                                        // 的事件可以删除
+            eventDO.setEventStatus(3);// 逻辑删除
             eventDO.setUpdateBy(commonEventDeleteDTO.getUserId());
             int updated = this.getBaseMapper().updateById(eventDO);
-            return updated==1?R.ok():R.fail();
+            return updated == 1 ? R.ok() : R.fail();
         }
         return R.fail("事件不是草稿/已撤销/无效状态, 不允许删除");
     }
 
     /**
      * 查询事件详细信息
-     * @param id 事件 id
+     *
+     * @param id
+     *            事件 id
      * @return 查找结果
      */
     @Override
-    public R<EventDetailsVO> eventDetails(Long id){
+    public R<EventDetailsVO> eventDetails(Long id) {
         EventDO eventDO = eventMapper.selectById(id);
-        if(eventDO!=null) {
+        if (eventDO != null) {
             EventDetailsVO eventDetailsVO = new EventDetailsVO();
             BeanUtils.copyProperties(eventDO, eventDetailsVO);
             EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(eventDO.getGridId());
-            if(eventGridDataDO!=null) {
+            if (eventGridDataDO != null) {
                 eventDetailsVO.setGridName(eventGridDataDO.getGridName());
+                eventDetailsVO.setCommunityId(eventGridDataDO.getGridCommunityId());
             }
 
-            //查询事件关联附件
+            // 查询事件关联附件
             List<EventResourceDO> eventResourceDOList =
-                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                            .eq(EventResourceDO::getClassification, 1)
-                            .eq(EventResourceDO::getRefId, id)
-                    );
+                eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                    .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, id));
             List<EventResourceVO> picList = new ArrayList<>();
             List<EventResourceVO> audioList = new ArrayList<>();
             List<EventResourceVO> videoList = new ArrayList<>();
             eventResourceDOList.forEach(eventResourceDO -> {
-                switch (eventResourceDO.getType()){
+                switch (eventResourceDO.getType()) {
                     case 1:
                         EventResourceVO picEventResourceVO = new EventResourceVO();
                         BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -182,29 +206,23 @@
             eventDetailsVO.setPics(picList);
             eventDetailsVO.setVideos(videoList);
 
-
-
-            //查询事件流转记录
-            List<EventTransferRecordDO> eventTransferRecordDOList = eventTransferRecordService.getBaseMapper()
-                    .selectList(new LambdaQueryWrapper<EventTransferRecordDO>()
-                            .eq(EventTransferRecordDO::getEventId, id)
-                            .orderByAsc(EventTransferRecordDO::getCreateAt)
-                    );
+            // 查询事件流转记录
+            List<EventTransferRecordDO> eventTransferRecordDOList =
+                eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>()
+                    .eq(EventTransferRecordDO::getEventId, id).orderByAsc(EventTransferRecordDO::getCreateAt));
 
             List<EventTransferRecordVO> eventTransferRecordVOS = new ArrayList<>();
             for (EventTransferRecordDO eventTransferRecordDO : eventTransferRecordDOList) {
                 EventTransferRecordVO eventTransferRecordVO = new EventTransferRecordVO();
                 BeanUtils.copyProperties(eventTransferRecordDO, eventTransferRecordVO);
-                List<EventResourceDO> eventTransferResourceDOList =
-                        eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification, 3)
-                                .eq(EventResourceDO::getRefId, eventTransferRecordDO.getId())
-                        );
+                List<EventResourceDO> eventTransferResourceDOList = eventResourceService.getBaseMapper()
+                    .selectList(new LambdaQueryWrapper<EventResourceDO>().eq(EventResourceDO::getClassification, 3)
+                        .eq(EventResourceDO::getRefId, eventTransferRecordDO.getId()));
                 List<EventResourceVO> transferPicList = new ArrayList<>();
                 List<EventResourceVO> transferAudioList = new ArrayList<>();
                 List<EventResourceVO> transferVideoList = new ArrayList<>();
                 eventTransferResourceDOList.forEach(eventResourceDO -> {
-                    switch (eventResourceDO.getType()){
+                    switch (eventResourceDO.getType()) {
                         case 1:
                             EventResourceVO picEventResourceVO = new EventResourceVO();
                             BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -229,12 +247,33 @@
             }
             eventDetailsVO.setTrans(eventTransferRecordVOS);
 
-            //查询事件发布人头像
-            String imageUrl = eventMapper.getGridMemberImageUrl(eventDO.getGridMemberId());
-            if(StringUtils.isNotEmpty(imageUrl)){
-                eventDetailsVO.setGridMemberImageUrl(imageUrl);
+            // 查询网格员头像,姓名
+            Map<String, Object> gridMember = eventMapper.getUserBaseInfo(eventDO.getGridMemberId());
+            if (!CollectionUtils.isEmpty(gridMember)) {
+                eventDetailsVO.setGridMemberName(
+                    gridMember.get("nick_name") == null ? "" : gridMember.get("nick_name").toString());
+                eventDetailsVO.setGridMemberImageUrl(
+                    gridMember.get("image_url") == null ? "" : gridMember.get("image_url").toString());
+            }
+            if (Objects.equals(eventDO.getGridMemberId(), eventDO.getCreateBy())) {
+                eventDetailsVO.setCreator(eventDetailsVO.getGridMemberName());
+            } else {
+                Map<String, Object> createUser = eventMapper.getUserBaseInfo(eventDO.getCreateBy());
+                eventDetailsVO
+                    .setCreator(createUser.get("nick_name") == null ? "" : createUser.get("nick_name").toString());
             }
 
+            // 当事件为特殊人群上报时,需要查询事件与人口关联关系
+            if (eventDetailsVO.getEventType() != null && eventDetailsVO.getEventType().equals(6)) {
+                List<EventSpecialPopulationDetailsVO> specialPopulationList =
+                    eventSpecialCrowdRecordMapper.getSpecialPopulationIds(eventDetailsVO.getId());
+                if (!specialPopulationList.isEmpty()) {
+                    specialPopulationList.forEach(special -> {
+                        special.setAge(IdcardUtil.getAgeByIdCard(special.getIdCard()));
+                    });
+                }
+                eventDetailsVO.setPopulationList(specialPopulationList);
+            }
             return R.ok(eventDetailsVO);
         }
         return R.fail("事件不存在");
@@ -245,29 +284,58 @@
     public R addCommon(CommonEventAddDTO commonEventAddDTO) {
         EventDO eventDO = new EventDO();
         BeanUtils.copyProperties(commonEventAddDTO, eventDO);
-        if(commonEventAddDTO instanceof  CommonEventCommunityAddDTO) {
+        if (commonEventAddDTO instanceof CommonEventCommunityAddDTO) {
             CommonEventCommunityAddDTO commonEventCommunityAddDTO = (CommonEventCommunityAddDTO)commonEventAddDTO;
             eventDO.setGridMemberId(commonEventCommunityAddDTO.getGridMemberId());
-        }else{
+        } else {
             eventDO.setGridMemberId(commonEventAddDTO.getUserId());
         }
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventAddDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
-        eventDO.setEventCategory(1l);//办件事件
-        eventDO.setEventStatus(2);//事件状态 2发布
-        eventDO.setProcessType(1);//网格员处理
-        eventDO.setCommunityProcess(0);//非 社区处理
+        eventDO.setGridMemberCommunity(eventGridDataDO.getGridCommunityId());
+        eventDO.setGridMemberStreet(eventGridDataDO.getGridStreetId());
+
+        // 检查特殊人群上报时参数
+        // if(commonEventAddDTO.getEventType().equals(6)){
+        // if(commonEventAddDTO.getPopulationIds() == null || commonEventAddDTO.getPopulationIds().size() <= 0){
+        // return R.fail("上报人员为空");
+        // }
+        // }
+
+        eventDO.setEventCategory(1l);// 办件事件
+        eventDO.setEventStatus(2);// 事件状态 2发布
+        eventDO.setProcessType(1);// 网格员处理
+        eventDO.setCommunityProcess(0);// 非 社区处理
         eventDO.setEventProcessStatus(1);
         eventDO.setGridMemberName(commonEventAddDTO.getUserName());
         eventDO.setGridMemberTelephone(commonEventAddDTO.getPhone());
         eventDO.setCreateBy(commonEventAddDTO.getUserId());
         eventDO.setSubmitDate(new Date());
         eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
-        if(eventMapper.insert(eventDO)==1){
-            //添加音频
-            if(StringUtils.isNotEmpty(commonEventAddDTO.getAudio())){
+
+        if (eventMapper.insert(eventDO) == 1) {
+            // 如果是特殊人群,则新增特殊人群与事件关系
+            if (commonEventAddDTO.getEventType().equals(6)
+                    && commonEventAddDTO.getPopulationIds() != null
+                    && commonEventAddDTO.getPopulationIds().size() > 0) {
+                if (commonEventAddDTO.getPopulationIds() != null && commonEventAddDTO.getPopulationIds().size() > 0) {
+                    List<EventSpecialCrowdRecordDO> crowdRecordList = new ArrayList<>();
+                    commonEventAddDTO.getPopulationIds().forEach(populationId -> {
+                        EventSpecialCrowdRecordDO specialCrowdRecordDO = new EventSpecialCrowdRecordDO();
+                        specialCrowdRecordDO.setEventId(eventDO.getId());
+                        specialCrowdRecordDO.setPopulationId(populationId);
+                        specialCrowdRecordDO.setCreateAt(new Date());
+                        crowdRecordList.add(specialCrowdRecordDO);
+                    });
+                    // 添加特殊人群上报事件与人口关系
+                    eventSpecialCrowdRecordService.saveBatch(crowdRecordList);
+                }
+            }
+
+            // 添加音频
+            if (StringUtils.isNotEmpty(commonEventAddDTO.getAudio())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
                 eventResourceDO.setType(2);
@@ -275,13 +343,15 @@
                 eventResourceDO.setRefId(eventDO.getId());
                 eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventAddDTO.getAudioTime());
+                eventResourceDO.setResourceName(
+                    commonEventAddDTO.getAudio().substring(commonEventAddDTO.getAudio().lastIndexOf("/") + 1));
                 int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(audioAdd!=1){
+                if (audioAdd != 1) {
                     throw new ServiceException("添加音频失败");
                 }
             }
-            //添加视频
-            if(StringUtils.isNotEmpty(commonEventAddDTO.getVideo())){
+            // 添加视频
+            if (StringUtils.isNotEmpty(commonEventAddDTO.getVideo())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
                 eventResourceDO.setType(3);
@@ -289,13 +359,15 @@
                 eventResourceDO.setRefId(eventDO.getId());
                 eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventAddDTO.getVideoTime());
+                eventResourceDO.setResourceName(
+                    commonEventAddDTO.getVideo().substring(commonEventAddDTO.getVideo().lastIndexOf("/") + 1));
                 int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(videoAdd!=1){
+                if (videoAdd != 1) {
                     throw new ServiceException("添加视频失败");
                 }
             }
-            //添加图片
-            if(StringUtils.isNotEmpty(commonEventAddDTO.getPics())){
+            // 添加图片
+            if (StringUtils.isNotEmpty(commonEventAddDTO.getPics())) {
                 String[] pica = commonEventAddDTO.getPics().split(",");
                 for (int i = 0; i < pica.length; i++) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
@@ -304,8 +376,9 @@
                     eventResourceDO.setUrl(pica[i]);
                     eventResourceDO.setRefId(eventDO.getId());
                     eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
+                    eventResourceDO.setResourceName(pica[i].substring(pica[i].lastIndexOf("/") + 1));
                     int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                    if(picAdd!=1){
+                    if (picAdd != 1) {
                         throw new ServiceException("添加图片失败");
                     }
                 }
@@ -320,24 +393,48 @@
     @Transactional(rollbackFor = Exception.class)
     public R saveDraft(CommonEventEditDTO commonEventEditDTO) {
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventEditDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
-        if(commonEventEditDTO.getId()==null) {
+
+        if (commonEventEditDTO.getId() == null) {
+            // 检查特殊人群上报时参数
+//            if (commonEventEditDTO.getEventType().equals(6)) {
+//                if (commonEventEditDTO.getPopulationIds().isEmpty()) {
+//                    return R.fail("上报人员为空");
+//                }
+//            }
+
             EventDO eventDO = new EventDO();
             BeanUtils.copyProperties(commonEventEditDTO, eventDO);
             eventDO.setGridMemberId(commonEventEditDTO.getUserId());
-            eventDO.setEventCategory(1l);//办件事件
-            eventDO.setEventStatus(1);//事件状态 1草稿
-            eventDO.setProcessType(1);//网格员处理
-            eventDO.setCommunityProcess(0);//非 社区处理
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventStatus(1);// 事件状态 1草稿
+            eventDO.setProcessType(1);// 网格员处理
+            eventDO.setCommunityProcess(0);// 非 社区处理
             eventDO.setCreateBy(commonEventEditDTO.getUserId());
             eventDO.setGridMemberId(commonEventEditDTO.getUserId());
             eventDO.setGridMemberName(commonEventEditDTO.getUserName());
             eventDO.setGridMemberTelephone(commonEventEditDTO.getPhone());
             eventDO.setEventDealStatus(5);
             if (eventMapper.insert(eventDO) > 0) {
-                //添加音频
+
+                // 如果是特殊人群,则新增特殊人群与事件关系
+                if (commonEventEditDTO.getEventType().equals(6) && commonEventEditDTO.getPopulationIds() != null
+                        && commonEventEditDTO.getPopulationIds().size() > 0) {
+                    List<EventSpecialCrowdRecordDO> crowdRecordList = new ArrayList<>();
+                    commonEventEditDTO.getPopulationIds().forEach(populationId -> {
+                        EventSpecialCrowdRecordDO specialCrowdRecordDO = new EventSpecialCrowdRecordDO();
+                        specialCrowdRecordDO.setEventId(eventDO.getId());
+                        specialCrowdRecordDO.setPopulationId(populationId);
+                        specialCrowdRecordDO.setCreateAt(new Date());
+                        crowdRecordList.add(specialCrowdRecordDO);
+                    });
+                    // 添加特殊人群上报事件与人口关系
+                    eventSpecialCrowdRecordService.saveBatch(crowdRecordList);
+                }
+
+                // 添加音频
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -351,7 +448,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -365,7 +462,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getPics())) {
                     String[] pica = commonEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -384,26 +481,25 @@
                 return R.ok();
             }
             return R.fail();
-        }else{
-            //编辑原来的
+        } else {
+            // 编辑原来的
             EventDO eventDO = eventMapper.selectById(commonEventEditDTO.getId());
-            if(eventDO.getEventStatus()!=null && eventDO.getEventStatus()!=1){
-                return R.fail("保存草稿失败,事件不是草稿状态");
+            if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1
+                && eventDO.getEventDealStatus() != 6) {
+                return R.fail("保存草稿失败,事件不是草稿/已撤销状态");
             }
             BeanUtils.copyProperties(commonEventEditDTO, eventDO);
             eventDO.setGridMemberId(commonEventEditDTO.getUserId());
-            eventDO.setEventCategory(1l);//办件事件
-            eventDO.setEventStatus(1);//事件状态 2发布
-            eventDO.setProcessType(1);//网格员处理
-            eventDO.setCommunityProcess(0);//非 社区处理
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventStatus(1);// 事件状态 2发布
+            eventDO.setProcessType(1);// 网格员处理
+            eventDO.setCommunityProcess(0);// 非 社区处理
             eventDO.setUpdateBy(commonEventEditDTO.getUserId());
             eventDO.setEventDealStatus(5);
             if (eventMapper.updateById(eventDO) > 0) {
-                int deleted = eventResourceService.getBaseMapper()
-                        .delete(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification,1)
-                                .eq(EventResourceDO::getRefId, eventDO.getId()));
-                //添加音频
+                int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>()
+                    .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId()));
+                // 添加音频
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -417,7 +513,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -431,7 +527,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(commonEventEditDTO.getPics())) {
                     String[] pica = commonEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -457,35 +553,37 @@
     @Transactional(rollbackFor = Exception.class)
     public R report(CommonEventReportDTO commonEventReportDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventReportDTO.getEventId());
-        if(eventDO==null){
+        if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        if(eventDO.getEventStatus()!=2){
+        if (eventDO.getEventStatus() != 2) {
             return R.fail("当前事件不能上报社区");
         }
-        if(eventDO.getProcessType()==2){
+        if (eventDO.getProcessType() == 2) {
             return R.fail("当前事件已交由社区处理");
         }
 
-        R r  = communityService.detailCommunity(commonEventReportDTO.getToId());
-        if(!R.isOk(r)){
+        R r = communityService.detailCommunity(commonEventReportDTO.getToId());
+        if (!R.isOk(r)) {
             return R.fail("社区不存在");
         }
-        ComActVO comActVO= JSONObject.parseObject(JSONObject.toJSONString(r.getData()),ComActVO.class);
-        if(comActVO==null){
+        ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class);
+        if (comActVO == null) {
             return R.fail("社区不存在");
         }
-        eventDO.setCommunityProcess(1);    //社区处理
-        eventDO.setProcessType(2);    //当前处理对象: 社区处理
+        eventDO.setCommunityProcess(1); // 社区处理
+        eventDO.setProcessType(2); // 当前处理对象: 社区处理
         eventDO.setCommunityProcess(1);
-        eventDO.setEventProcessStatus(1);    //待处理
+        eventDO.setEventProcessStatus(1); // 待处理
         eventDO.setUpdateBy(commonEventReportDTO.getUserId());
         eventDO.setSubmitDate(new Date());
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             throw new ServiceException("更新突发事件状态更新失败");
         }
-        addTransferRecord(eventDO.getId(), commonEventReportDTO.getToId(), comActVO.getName(), 2, commonEventReportDTO.getProcessResult());
+        addTransferRecord(eventDO.getId(), commonEventReportDTO.getToId(), comActVO.getName(), 2,
+            commonEventReportDTO.getProcessResult(), commonEventReportDTO.getUserId(),
+            commonEventReportDTO.getUserName(), 2);
         return R.ok();
 
     }
@@ -494,25 +592,27 @@
     @Transactional(rollbackFor = Exception.class)
     public R emergenciesRevoke(EventRevokeDTO eventRevokeDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(eventRevokeDTO.getId());
-        if(eventDO==null){
+        if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        boolean canRevoke = eventDO.getEventStatus()==2; //发布状态
-        if(!canRevoke){
-            return R.fail("当前事件不允许撤销");
+        boolean canRevoke = eventDO.getEventStatus() == 2; // 发布状态
+        if (!canRevoke) {
+            return R.fail("当前事件不允许·");
         }
-        if(eventDO.getEventCategory()!=null && eventDO.getEventCategory().intValue()==2){//宣传教育事件
-            //不做验证
-        }else if(eventDO.getEventProcessStatus()==2 ||eventDO.getEventProcessStatus()==3) {   //已解决 或者 待验证 不允许撤销
+        Integer eventProcessStatus = eventDO.getEventProcessStatus() != null ? eventDO.getEventProcessStatus() : -1;
+        if (eventProcessStatus == 2 || eventProcessStatus == 3) { // 已解决 或者 待验证 不允许撤销
             return R.fail("当前事件不允许撤销");
         }
         eventDO.setEventStatus(4);
         eventDO.setUpdateBy(eventRevokeDTO.getUserId());
-        eventDO.setProcessType(1);//网格员处理
-        eventDO.setCommunityProcess(0);//非 社区处理
+        eventDO.setProcessType(1);// 网格员处理
+        eventDO.setCommunityProcess(0);// 非 社区处理
+        eventDO.setRevokeType(eventRevokeDTO.getRevokeType());
+        eventDO.setRevokeId(eventRevokeDTO.getRevokeId());
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated == 1){
-            addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1,"撤销成功");
+        if (updated == 1) {
+            addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1, "撤销成功",
+                eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 7);
             return R.ok();
         }
         return R.fail();
@@ -525,35 +625,43 @@
         if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        boolean canDealByUser = eventDO.getEventStatus()==2 && eventDO.getEventProcessStatus()==1;
-        if(!canDealByUser){
-            if(eventDO.getEventStatus()!=2){
-                return R.fail("事件不是发布状态");
+        boolean canDealByUser =
+            (eventDO.getEventStatus() == 2 || eventDO.getEventStatus() == 4) && eventDO.getEventProcessStatus() == 1;
+        if (!canDealByUser) {
+            if (eventDO.getEventStatus() != 2) {
+                return R.fail("事件不是发布/待处理状态");
             }
-            if(eventDO.getEventProcessStatus()!=1){
+            if (eventDO.getEventProcessStatus() != 1) {
                 return R.fail("事件不是待处理状态");
             }
             return R.fail("事件当前不可自处理");
         }
 
-        eventDO.setEventProcessStatus(2);//2已解决
+        eventDO.setEventProcessStatus(2);// 2已解决
         eventDO.setUpdateBy(commonEventDealDTO.getUserId());
 
-        //更新处理信息
+        // 更新处理信息
         eventDO.setProcessUserId(commonEventDealDTO.getUserId());
         eventDO.setProcessUserName(commonEventDealDTO.getUserName());
         eventDO.setProcessDate(new Date());
         eventDO.setProcessDesc(commonEventDealDTO.getProcessResult());
 
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             return R.fail("更新事件状态失败");
         }
+        Integer processType = -1;
+        if (eventDO.getInvalid() != null) {
+            processType = 5;
+        } else {
+            processType = 1;
+        }
         EventTransferRecordDO transferRecordDO =
-                addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(),1, "网格员自处理完成");
-        if(transferRecordDO!=null && transferRecordDO.getId()!=null){
-            //添加音频
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){
+            addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1,
+                "网格员自处理完成", commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), processType);
+        if (transferRecordDO != null && transferRecordDO.getId() != null) {
+            // 添加音频
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(3);
                 eventResourceDO.setType(2);
@@ -562,12 +670,12 @@
                 eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventDealDTO.getAudioTime());
                 int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(audioAdd!=1){
+                if (audioAdd != 1) {
                     throw new ServiceException("添加音频失败");
                 }
             }
-            //添加视频
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getVideo())){
+            // 添加视频
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getVideo())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(3);
                 eventResourceDO.setType(3);
@@ -576,12 +684,12 @@
                 eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventDealDTO.getVideoTime());
                 int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(videoAdd!=1){
+                if (videoAdd != 1) {
                     throw new ServiceException("添加视频失败");
                 }
             }
-            //添加图片
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getPics())){
+            // 添加图片
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getPics())) {
                 String[] pica = commonEventDealDTO.getPics().split(",");
                 for (int i = 0; i < pica.length; i++) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
@@ -591,7 +699,7 @@
                     eventResourceDO.setRefId(transferRecordDO.getId());
                     eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                     int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                    if(picAdd!=1){
+                    if (picAdd != 1) {
                         throw new ServiceException("添加图片失败");
                     }
                 }
@@ -601,56 +709,64 @@
             EventDO eventDOToUpdate = this.getBaseMapper().selectById(commonEventDealDTO.getId());
             eventDOToUpdate.setProcessRecordId(transferRecordId);
             int transferRecordUpdated = this.getBaseMapper().updateById(eventDOToUpdate);
-            if(transferRecordUpdated!=1){
+            if (transferRecordUpdated != 1) {
                 throw new ServiceException("更新事件处理流程失败");
             }
 
             return R.ok();
-        }else{
+        } else {
             throw new ServiceException("处理事件记录出错");
         }
     }
 
-
     @Override
     public R verifyEvent(CommonEventVerifyDTO commonEventVerifyDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventVerifyDTO.getId());
-        boolean canVerifyByUser = eventDO.getEventProcessStatus()==3;
-        if(!canVerifyByUser){
+        boolean canVerifyByUser = eventDO.getEventProcessStatus() == 3;
+        if (!canVerifyByUser) {
             return R.fail("当前不是待验证状态");
         }
-        boolean processTypeRight = eventDO.getProcessType()==1;
-        if(!processTypeRight){
+        boolean processTypeRight = eventDO.getProcessType() == 1;
+        if (!processTypeRight) {
             return R.fail("当前处理对象不是网格员");
         }
 
-        eventDO.setEventProcessStatus(2);//2已解决
+        eventDO.setEventProcessStatus(2);// 2已解决
         eventDO.setUpdateBy(commonEventVerifyDTO.getUserId());
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             return R.fail("更新事件状态失败");
         }
-        addTransferRecord(eventDO.getId(), commonEventVerifyDTO.getUserId(), commonEventVerifyDTO.getUserName(), 1, commonEventVerifyDTO.getProcessResult());
+        addTransferRecord(eventDO.getId(), commonEventVerifyDTO.getUserId(), commonEventVerifyDTO.getUserName(), 1,
+            commonEventVerifyDTO.getProcessResult(), commonEventVerifyDTO.getUserId(),
+            commonEventVerifyDTO.getUserName(), 6);
         return R.ok();
     }
 
     @Override
     public R republishEvent(CommonEventRepublishDTO commonEventRepublishDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventRepublishDTO.getId());
-        boolean canRepublishByUser = eventDO.getEventStatus()==4;
-        if(!canRepublishByUser){
-            return R.fail("当前不是撤销状态");
+        // boolean canRepublishByUser = eventDO.getEventStatus() == 4 || eventDO.getEventStatus() == 1;
+        boolean canRepublishByUser = eventDO.getEventDealStatus() == 6 | eventDO.getEventDealStatus() == 5; // 已失效状态
+        if (!canRepublishByUser) {
+            return R.fail("当前不是撤销/草稿状态");
         }
 
-        eventDO.setEventStatus(2);//2 发布
-        eventDO.setEventProcessStatus(1); //待解决
-        eventDO.setProcessType(1);   //网格员处理
+        if (eventDO.getEventCategory().equals(2L)) {// 宣传教育
+            eventDO.setEventDealStatus(8);
+        } else {
+            eventDO.setEventProcessStatus(1); // 待解决
+            eventDO.setProcessType(1); // 网格员处理
+        }
+        eventDO.setEventStatus(2);// 2 发布
         eventDO.setUpdateBy(commonEventRepublishDTO.getUserId());
+
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             return R.fail("更新事件状态失败");
         }
-        addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 1, "重新发布已撤销事件");
+        addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(),
+            1, "重新发布已撤销事件", commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 8);
         return R.ok();
     }
 
@@ -658,18 +774,18 @@
     @Transactional(rollbackFor = Exception.class)
     public R draftRelease(CommonEventPublicDTO commonEventPublicDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventPublicDTO.getId());
-        boolean draftCanRelease = eventDO.getEventStatus()==1;
-        if(!draftCanRelease){
+        boolean draftCanRelease = eventDO.getEventStatus() == 1;
+        if (!draftCanRelease) {
             return R.fail("当前不是草稿状态");
         }
         eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
-        eventDO.setEventStatus(2);//事件状态 2发布
-        eventDO.setProcessType(1);//当前处理对象类型:网格员处理
-        eventDO.setCommunityProcess(0);//非 社区处理
-        eventDO.setEventProcessStatus(1);//待处理
+        eventDO.setEventStatus(2);// 事件状态 2发布
+        eventDO.setProcessType(1);// 当前处理对象类型:网格员处理
+        eventDO.setCommunityProcess(0);// 非 社区处理
+        eventDO.setEventProcessStatus(1);// 待处理
         eventDO.setUpdateBy(commonEventPublicDTO.getUserId());
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             return R.fail("更新事件状态失败");
         }
         addReleaseRecord(eventDO.getId(), commonEventPublicDTO.getUserId(), commonEventPublicDTO.getUserName());
@@ -678,40 +794,43 @@
 
     /**
      * 生成服务单号
-     * @param eventType 事件类型,宣传事件默认为20
+     *
+     * @param eventType
+     *            事件类型,宣传事件默认为20
      * @return
      */
     private String getEventOrderSn(Integer eventType) {
         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd");
-        if(eventType==null){
-            eventType =  20;
+        if (eventType == null) {
+            eventType = 20;
         }
         String pre = String.format(simpleDateFormat.format(new Date()) + "%02d", eventType);
-        Integer todayCount = this.getBaseMapper().selectCount(new LambdaQueryWrapper<EventDO>().likeRight(EventDO::getOrderSn, pre));
-        String orderSn =  String.format(pre + "%04d", todayCount+1);
+        Integer todayCount =
+            this.getBaseMapper().selectCount(new LambdaQueryWrapper<EventDO>().likeRight(EventDO::getOrderSn, pre));
+        String orderSn = String.format(pre + "%04d", todayCount + 1);
         return orderSn;
     }
 
     @Override
     public R saveSpecialDraft(SpecialEventEditDTO specialEventEditDTO) {
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventEditDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
         R rtVal = R.fail();
-        if(specialEventEditDTO.getId()==null) {
+        if (specialEventEditDTO.getId() == null) {
             EventDO eventDO = new EventDO();
             BeanUtils.copyProperties(specialEventEditDTO, eventDO);
             eventDO.setGridMemberId(specialEventEditDTO.getUserId());
-            eventDO.setEventCategory(1l);//办件事件
-            eventDO.setEventType(EventType.SPECIAL);//特殊人群信息上报-事件分类
-            eventDO.setEventStatus(1);//事件状态 1草稿
-            eventDO.setProcessType(1);//网格员处理
-            eventDO.setCommunityProcess(0);//非 社区处理
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventType(EventType.SPECIAL);// 特殊人群信息上报-事件分类
+            eventDO.setEventStatus(1);// 事件状态 1草稿
+            eventDO.setProcessType(1);// 网格员处理
+            eventDO.setCommunityProcess(0);// 非 社区处理
             eventDO.setCreateBy(specialEventEditDTO.getUserId());
-            eventDO.setEventDealStatus(5);//草稿状态
+            eventDO.setEventDealStatus(5);// 草稿状态
             if (eventMapper.insert(eventDO) > 0) {
-                //添加音频
+                // 添加音频
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -725,7 +844,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -739,7 +858,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getPics())) {
                     String[] pica = specialEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -758,23 +877,21 @@
                 rtVal = R.ok();
             }
             rtVal = R.fail();
-        }else{
-            //编辑原来的
+        } else {
+            // 编辑原来的
             EventDO eventDO = eventMapper.selectById(specialEventEditDTO.getId());
             BeanUtils.copyProperties(specialEventEditDTO, eventDO);
             eventDO.setGridMemberId(specialEventEditDTO.getUserId());
-            eventDO.setEventCategory(1l);//办件事件
-            eventDO.setEventStatus(1);//事件状态 1草稿
-            eventDO.setProcessType(1);//网格员处理
-            eventDO.setCommunityProcess(0);//非 社区处理
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventStatus(1);// 事件状态 1草稿
+            eventDO.setProcessType(1);// 网格员处理
+            eventDO.setCommunityProcess(0);// 非 社区处理
             eventDO.setUpdateBy(specialEventEditDTO.getUserId());
-            eventDO.setEventDealStatus(5);//草稿状态
+            eventDO.setEventDealStatus(5);// 草稿状态
             if (eventMapper.updateById(eventDO) > 0) {
-                int deleted = eventResourceService.getBaseMapper()
-                        .delete(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification,1)
-                                .eq(EventResourceDO::getRefId, eventDO.getId()));
-                //添加音频
+                int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>()
+                    .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId()));
+                // 添加音频
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -788,7 +905,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -802,7 +919,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(specialEventEditDTO.getPics())) {
                     String[] pica = specialEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -822,8 +939,8 @@
             }
             rtVal = R.fail();
         }
-        if(R.isOk(rtVal)){
-            //TODO 处理特殊人群实有人口数据
+        if (R.isOk(rtVal)) {
+            // TODO 处理特殊人群实有人口数据
 
         }
         return rtVal;
@@ -832,22 +949,22 @@
     @Override
     public R addSpecial(SpecialEventAddDTO specialEventAddDTO) {
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventAddDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
         R rtVal = R.fail();
         EventDO eventDO = new EventDO();
         BeanUtils.copyProperties(specialEventAddDTO, eventDO);
         eventDO.setGridMemberId(specialEventAddDTO.getUserId());
-        eventDO.setEventCategory(1l);//办件事件
-        eventDO.setEventType(EventType.SPECIAL);//特殊人群信息上报-事件分类
-        eventDO.setEventStatus(2);//事件状态 2发布
-        eventDO.setProcessType(1);//网格员处理
-        eventDO.setCommunityProcess(0);//非 社区处理
+        eventDO.setEventCategory(1l);// 办件事件
+        eventDO.setEventType(EventType.SPECIAL);// 特殊人群信息上报-事件分类
+        eventDO.setEventStatus(2);// 事件状态 2发布
+        eventDO.setProcessType(1);// 网格员处理
+        eventDO.setCommunityProcess(0);// 非 社区处理
         eventDO.setCreateBy(specialEventAddDTO.getUserId());
         eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
         if (eventMapper.insert(eventDO) > 0) {
-            //添加音频
+            // 添加音频
             if (StringUtils.isNotEmpty(specialEventAddDTO.getAudio())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
@@ -861,7 +978,7 @@
                     throw new ServiceException("添加音频失败");
                 }
             }
-            //添加视频
+            // 添加视频
             if (StringUtils.isNotEmpty(specialEventAddDTO.getVideo())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
@@ -875,7 +992,7 @@
                     throw new ServiceException("添加视频失败");
                 }
             }
-            //添加图片
+            // 添加图片
             if (StringUtils.isNotEmpty(specialEventAddDTO.getPics())) {
                 String[] pica = specialEventAddDTO.getPics().split(",");
                 for (int i = 0; i < pica.length; i++) {
@@ -895,8 +1012,8 @@
         }
         rtVal = R.fail();
 
-        if(R.isOk(rtVal)){
-            //TODO 处理特殊人群实有人口数据
+        if (R.isOk(rtVal)) {
+            // TODO 处理特殊人群实有人口数据
 
             addReleaseRecord(eventDO.getId(), specialEventAddDTO.getUserId(), specialEventAddDTO.getUserName());
             return R.ok();
@@ -916,22 +1033,30 @@
     @Override
     public R addPublicity(PublicityEventAddDTO publicityEventAddDTO) {
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventAddDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
         EventDO eventDO = new EventDO();
         BeanUtils.copyProperties(publicityEventAddDTO, eventDO);
+        eventDO.setHappenTime(publicityEventAddDTO.getPropagandaTime());
         eventDO.setGridMemberId(publicityEventAddDTO.getUserId());
-        eventDO.setEventCategory(2l);//宣传事件
-        eventDO.setEventStatus(2);//事件状态 2发布
-        eventDO.setGridMemberId(publicityEventAddDTO.getUserId());
+        eventDO.setEventCategory(2l);// 宣传事件
+        eventDO.setEventStatus(2);// 事件状态 2发布
+        eventDO.setEventType(8);
+        eventDO.setGridMemberCommunity(eventGridDataDO.getGridCommunityId());
+        eventDO.setGridMemberStreet(eventGridDataDO.getGridStreetId());
+        if (publicityEventAddDTO.getGridMemberId() != null) {
+            eventDO.setGridMemberId(publicityEventAddDTO.getGridMemberId());
+        } else {
+            eventDO.setGridMemberId(publicityEventAddDTO.getUserId());
+        }
         eventDO.setGridMemberName(publicityEventAddDTO.getUserName());
         eventDO.setGridMemberTelephone(publicityEventAddDTO.getPhone());
         eventDO.setCreateBy(publicityEventAddDTO.getUserId());
         eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
-        if(eventMapper.insert(eventDO)==1){
-            //添加音频
-            if(StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())){
+        if (eventMapper.insert(eventDO) == 1) {
+            // 添加音频
+            if (StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
                 eventResourceDO.setType(2);
@@ -940,12 +1065,12 @@
                 eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(publicityEventAddDTO.getAudioTime());
                 int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(audioAdd!=1){
+                if (audioAdd != 1) {
                     throw new ServiceException("添加音频失败");
                 }
             }
-            //添加视频
-            if(StringUtils.isNotEmpty(publicityEventAddDTO.getVideo())){
+            // 添加视频
+            if (StringUtils.isNotEmpty(publicityEventAddDTO.getVideo())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(1);
                 eventResourceDO.setType(3);
@@ -954,12 +1079,12 @@
                 eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(publicityEventAddDTO.getVideoTime());
                 int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(videoAdd!=1){
+                if (videoAdd != 1) {
                     throw new ServiceException("添加视频失败");
                 }
             }
-            //添加图片
-            if(StringUtils.isNotEmpty(publicityEventAddDTO.getPics())){
+            // 添加图片
+            if (StringUtils.isNotEmpty(publicityEventAddDTO.getPics())) {
                 String[] pica = publicityEventAddDTO.getPics().split(",");
                 for (int i = 0; i < pica.length; i++) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
@@ -969,7 +1094,7 @@
                     eventResourceDO.setRefId(eventDO.getId());
                     eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId());
                     int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                    if(picAdd!=1){
+                    if (picAdd != 1) {
                         throw new ServiceException("添加图片失败");
                     }
                 }
@@ -984,22 +1109,23 @@
     @Override
     public R savePublicityDraft(PublicityEventEditDTO publicityEventEditDTO) {
         EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventEditDTO.getGridId());
-        if(eventGridDataDO==null){
+        if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
-        if(publicityEventEditDTO.getId()==null) {
+        if (publicityEventEditDTO.getId() == null) {
             EventDO eventDO = new EventDO();
             BeanUtils.copyProperties(publicityEventEditDTO, eventDO);
             eventDO.setGridMemberId(publicityEventEditDTO.getUserId());
-            eventDO.setEventCategory(2l);//宣传事件
-            eventDO.setEventStatus(1);//事件状态 1草稿
+            eventDO.setEventCategory(2l);// 宣传事件
+            eventDO.setEventStatus(1);// 事件状态 1草稿
             eventDO.setCreateBy(publicityEventEditDTO.getUserId());
             eventDO.setGridMemberId(publicityEventEditDTO.getUserId());
             eventDO.setGridMemberName(publicityEventEditDTO.getUserName());
             eventDO.setGridMemberTelephone(publicityEventEditDTO.getPhone());
-            eventDO.setEventDealStatus(5);//草稿状态
+            eventDO.setEventDealStatus(5);// 草稿状态
+            eventDO.setEventType(8);
             if (eventMapper.insert(eventDO) > 0) {
-                //添加音频
+                // 添加音频
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -1013,7 +1139,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -1027,7 +1153,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getPics())) {
                     String[] pica = publicityEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -1046,26 +1172,25 @@
                 return R.ok();
             }
             return R.fail();
-        }else{
-            //编辑原来的
+        } else {
+            // 编辑原来的
             EventDO eventDO = eventMapper.selectById(publicityEventEditDTO.getId());
-            if(eventDO.getEventStatus()!=null && eventDO.getEventStatus()!=1){
-                return R.fail("保存草稿失败,事件不是草稿状态");
+            if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1
+                && eventDO.getEventDealStatus() != 6) {
+                return R.fail("保存草稿失败,事件不是草稿/撤销状态");
             }
             BeanUtils.copyProperties(publicityEventEditDTO, eventDO);
             eventDO.setGridMemberId(publicityEventEditDTO.getUserId());
-            eventDO.setEventCategory(2L);//宣传事件
-            eventDO.setEventStatus(1);//事件状态 1草稿
-            eventDO.setProcessType(1);//网格员处理
-            eventDO.setCommunityProcess(0);//非 社区处理
+            eventDO.setEventCategory(2L);// 宣传事件
+            eventDO.setEventStatus(1);// 事件状态 1草稿
+            eventDO.setProcessType(1);// 网格员处理
+            eventDO.setCommunityProcess(0);// 非 社区处理
             eventDO.setUpdateBy(publicityEventEditDTO.getUserId());
-            eventDO.setEventDealStatus(5);//草稿状态
+            eventDO.setEventDealStatus(5);// 草稿状态
             if (eventMapper.updateById(eventDO) > 0) {
-                int deleted = eventResourceService.getBaseMapper()
-                        .delete(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification,1)
-                                .eq(EventResourceDO::getRefId, eventDO.getId()));
-                //添加音频
+                int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>()
+                    .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId()));
+                // 添加音频
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -1079,7 +1204,7 @@
                         throw new ServiceException("添加音频失败");
                     }
                 }
-                //添加视频
+                // 添加视频
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getVideo())) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
                     eventResourceDO.setClassification(1);
@@ -1093,7 +1218,7 @@
                         throw new ServiceException("添加视频失败");
                     }
                 }
-                //添加图片
+                // 添加图片
                 if (StringUtils.isNotEmpty(publicityEventEditDTO.getPics())) {
                     String[] pica = publicityEventEditDTO.getPics().split(",");
                     for (int i = 0; i < pica.length; i++) {
@@ -1117,27 +1242,25 @@
 
     @Override
     public R selectPublicity(PagePublicityEventDTO pagePublicityEventDTO) {
-        Page page = new Page(1,10);
-        if(pagePublicityEventDTO.getPageNum()!=null) {
+        Page page = new Page(1, 10);
+        if (pagePublicityEventDTO.getPageNum() != null) {
             page.setCurrent(pagePublicityEventDTO.getPageNum());
         }
-        if(pagePublicityEventDTO.getPageSize()!=null) {
+        if (pagePublicityEventDTO.getPageSize() != null) {
             page.setSize(pagePublicityEventDTO.getPageSize());
         }
         IPage<EventVO> ipage = eventMapper.findPublicityByPage(page, pagePublicityEventDTO);
-        if(ipage!=null){
+        if (ipage != null) {
             List<EventVO> eventVOList = ipage.getRecords();
             eventVOList.forEach(eventVO -> {
                 List<EventResourceDO> eventResourceDOList =
-                        eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification, 1)
-                                .eq(EventResourceDO::getRefId, eventVO.getId())
-                        );
+                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                        .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId()));
                 List<EventResourceVO> picList = new ArrayList<>();
                 List<EventResourceVO> audioList = new ArrayList<>();
                 List<EventResourceVO> videoList = new ArrayList<>();
                 eventResourceDOList.forEach(eventResourceDO -> {
-                    switch (eventResourceDO.getType()){
+                    switch (eventResourceDO.getType()) {
                         case 1:
                             EventResourceVO picEventResourceVO = new EventResourceVO();
                             BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -1158,6 +1281,12 @@
                 eventVO.setAudios(audioList);
                 eventVO.setPics(picList);
                 eventVO.setVideos(videoList);
+                // 查询网格员头像
+                Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId());
+                if (StringUtils.isNotEmpty(userMap)) {
+                    eventVO.setGridMemberName(userMap.get("nick_name"));
+                    eventVO.setGridMemberImageUrl(userMap.get("image_url"));
+                }
             });
             return R.ok(ipage);
         }
@@ -1171,28 +1300,26 @@
 
     @Override
     public R eventToManage(PageEventManageDTO pageEventManageDTO) {
-        //查询管理事件
-        Page page = new Page(1,10);
-        if(pageEventManageDTO.getPageNum()!=null) {
+        // 查询管理事件
+        Page page = new Page(1, 10);
+        if (pageEventManageDTO.getPageNum() != null) {
             page.setCurrent(pageEventManageDTO.getPageNum());
         }
-        if(pageEventManageDTO.getPageSize()!=null) {
+        if (pageEventManageDTO.getPageSize() != null) {
             page.setSize(pageEventManageDTO.getPageSize());
         }
         IPage<EventVO> ipage = eventMapper.findToManageByPage(page, pageEventManageDTO);
-        if(ipage!=null){
+        if (ipage != null) {
             List<EventVO> eventVOList = ipage.getRecords();
             eventVOList.forEach(eventVO -> {
                 List<EventResourceDO> eventResourceDOList =
-                        eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification, 1)
-                                .eq(EventResourceDO::getRefId, eventVO.getId())
-                        );
+                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                        .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId()));
                 List<EventResourceVO> picList = new ArrayList<>();
                 List<EventResourceVO> audioList = new ArrayList<>();
                 List<EventResourceVO> videoList = new ArrayList<>();
                 eventResourceDOList.forEach(eventResourceDO -> {
-                    switch (eventResourceDO.getType()){
+                    switch (eventResourceDO.getType()) {
                         case 1:
                             EventResourceVO picEventResourceVO = new EventResourceVO();
                             BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -1214,10 +1341,11 @@
                 eventVO.setPics(picList);
                 eventVO.setVideos(videoList);
 
-                //查询网格员头像
-                String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId());
-                if(StringUtils.isNotEmpty(imageUrl)){
-                    eventVO.setGridMemberImageUrl(imageUrl);
+                // 查询网格员头像
+                Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId());
+                if (StringUtils.isNotEmpty(userMap)) {
+                    eventVO.setGridMemberName(userMap.get("nick_name"));
+                    eventVO.setGridMemberImageUrl(userMap.get("image_url"));
                 }
             });
             return R.ok(ipage);
@@ -1228,34 +1356,39 @@
     @Override
     public R markEventInvalid(EventRevokeDTO eventRevokeDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(eventRevokeDTO.getId());
-        if(eventDO==null){
+        if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        if(eventDO.getEventCategory()!=null) {
+        if (eventDO.getEventCategory() != null) {
             if (eventDO.getEventCategory() == 1) {
-                boolean canRevoke = eventDO.getEventDealStatus() == 3; //上报状态
+                boolean canRevoke = eventDO.getEventDealStatus() == 3; // 上报状态
                 if (!canRevoke) {
-                    return R.fail("当前事件不是上报状态,不允许标为无效");
+                    return R.fail("当前事件不是上报状态,不允许撤销");
                 }
-            }else if (eventDO.getEventCategory() == 2) {
-                boolean canRevoke = eventDO.getEventDealStatus() == 8; //发布状态
+            } else if (eventDO.getEventCategory() == 2) {
+                boolean canRevoke = eventDO.getEventDealStatus() == 8; // 发布状态
                 if (!canRevoke) {
-                    return R.fail("当前事件不是发布状态,不允许标为无效");
+                    return R.fail("当前事件不是发布状态,不允许撤销");
                 }
-            }else{
+            } else {
                 return R.fail("");
             }
-        }else{
+        } else {
             return R.fail("事件所属错误");
         }
-        eventDO.setInvalid(false);
+//        eventDO.setInvalid(false);
+        // 标为无效后, 交给网格员处理
         eventDO.setUpdateBy(eventRevokeDTO.getUserId());
-        eventDO.setEventStatus(4);//4、撤销
-        eventDO.setProcessType(1);//网格员处理
-        eventDO.setCommunityProcess(0);//非 社区处理
+        eventDO.setEventStatus(4);// 4、撤销
+        eventDO.setEventDealStatus(6);// 4、撤销
+        eventDO.setProcessType(1);// 网格员处理
+        eventDO.setCommunityProcess(0);// 非 社区处理
+        eventDO.setRevokeId(eventRevokeDTO.getRevokeId());
+        eventDO.setRevokeType(eventRevokeDTO.getRevokeType());
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated == 1){
-            addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1,"撤销成功");
+        if (updated == 1) {
+            addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1, "标为无效",
+                eventRevokeDTO.getCommunityId(), eventRevokeDTO.getCommunityName(), 4);
             return R.ok();
         }
         return R.fail();
@@ -1264,17 +1397,21 @@
     @Override
     public R republishInvalidEvent(CommonEventRepublishDTO commonEventRepublishDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventRepublishDTO.getId());
-        if(eventDO==null){
+        if (eventDO == null) {
             return R.fail("事件不存在");
         }
-        boolean canRepulish = eventDO.getEventDealStatus()==7; //已失效状态
-        if(!canRepulish){
-            return R.fail("当前事件不是已失效状态,不能重新发布");
+        boolean canRepulish = eventDO.getEventDealStatus() == 7 || eventDO.getEventDealStatus() == 5 || eventDO.getEventDealStatus() == 6; // 已失效状态
+        if (!canRepulish) {
+            return R.fail("当前事件不是已失效状态/草稿状态/撤销状态,不能重新发布");
         }
         eventDO.setInvalid(true);
+        eventDO.setEventStatus(2);
+        eventDO.setEventDealStatus(1);
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated == 1){
-            addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 1,"重新发布事件成功");
+        if (updated == 1) {
+            addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(),
+                commonEventRepublishDTO.getUserName(), 1, "重新发布事件成功", commonEventRepublishDTO.getUserId(),
+                commonEventRepublishDTO.getUserName(), 9);
             return R.ok();
         }
         return R.fail();
@@ -1287,33 +1424,51 @@
             return R.fail("事件不存在");
         }
         boolean canDealByCommunity = eventDO.getEventDealStatus() == 3;
-        if(!canDealByCommunity){
+        if (!canDealByCommunity) {
             return R.fail("事件当前不是上报状态");
         }
 
-        if(commonEventDealDTO.getNeedVerify()){
-            eventDO.setEventProcessStatus(3);//待验证状态
-            eventDO.setProcessType(1);//交给网格员处理-验证
-        }else {
-            eventDO.setEventProcessStatus(2);//2已解决
+        List<EventTransferRecordDO> list = eventTransferRecordService.getBaseMapper().selectList(
+            new LambdaQueryWrapper<EventTransferRecordDO>().eq(EventTransferRecordDO::getEventId, eventDO.getId())
+                .orderByDesc(EventTransferRecordDO::getCreateAt));
+
+        Long reportToInDB = -1L;
+        for (int i = 0; i < list.size(); i++) {
+            EventTransferRecordDO eventTransferRecordDO = list.get(i);
+            if (eventTransferRecordDO.getProcessType() != null && eventTransferRecordDO.getProcessType() == 2) {
+                reportToInDB = eventTransferRecordDO.getToId();
+            }
+        }
+        if (commonEventDealDTO.getCommunityId() == null) {
+            return R.fail("当前用户社区获取失败");
+        }
+        if (reportToInDB.longValue() != commonEventDealDTO.getCommunityId().longValue()) {
+            return R.fail("用户上报的社区不是当前社区");
+        }
+        if (commonEventDealDTO.getNeedVerify()) {
+            eventDO.setEventProcessStatus(3);// 待验证状态
+            eventDO.setProcessType(1);// 交给网格员处理-验证
+        } else {
+            eventDO.setEventProcessStatus(2);// 2已解决
         }
         eventDO.setUpdateBy(commonEventDealDTO.getUserId());
 
-        //更新处理信息
+        // 更新处理信息
         eventDO.setProcessUserId(commonEventDealDTO.getUserId());
         eventDO.setProcessUserName(commonEventDealDTO.getUserName());
         eventDO.setProcessDate(new Date());
         eventDO.setProcessDesc(commonEventDealDTO.getProcessResult());
 
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated!=1){
+        if (updated != 1) {
             return R.fail("更新事件状态失败");
         }
         EventTransferRecordDO transferRecordDO =
-                addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(),1, "社区处理完成");
-        if(transferRecordDO!=null && transferRecordDO.getId()!=null){
-            //添加音频
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){
+            addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1,
+                "社区处理完成", commonEventDealDTO.getCommunityId(), commonEventDealDTO.getCommunityName(), 3);
+        if (transferRecordDO != null && transferRecordDO.getId() != null) {
+            // 添加音频
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(3);
                 eventResourceDO.setType(2);
@@ -1322,12 +1477,12 @@
                 eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventDealDTO.getAudioTime());
                 int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(audioAdd!=1){
+                if (audioAdd != 1) {
                     throw new ServiceException("添加音频失败");
                 }
             }
-            //添加视频
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getVideo())){
+            // 添加视频
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getVideo())) {
                 EventResourceDO eventResourceDO = new EventResourceDO();
                 eventResourceDO.setClassification(3);
                 eventResourceDO.setType(3);
@@ -1336,12 +1491,12 @@
                 eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventDealDTO.getVideoTime());
                 int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                if(videoAdd!=1){
+                if (videoAdd != 1) {
                     throw new ServiceException("添加视频失败");
                 }
             }
-            //添加图片
-            if(StringUtils.isNotEmpty(commonEventDealDTO.getPics())){
+            // 添加图片
+            if (StringUtils.isNotEmpty(commonEventDealDTO.getPics())) {
                 String[] pica = commonEventDealDTO.getPics().split(",");
                 for (int i = 0; i < pica.length; i++) {
                     EventResourceDO eventResourceDO = new EventResourceDO();
@@ -1351,7 +1506,7 @@
                     eventResourceDO.setRefId(transferRecordDO.getId());
                     eventResourceDO.setCreateBy(commonEventDealDTO.getUserId());
                     int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
-                    if(picAdd!=1){
+                    if (picAdd != 1) {
                         throw new ServiceException("添加图片失败");
                     }
                 }
@@ -1360,38 +1515,36 @@
             EventDO eventDOToUpdate = this.getBaseMapper().selectById(commonEventDealDTO.getId());
             eventDOToUpdate.setProcessRecordId(transferRecordId);
             int transferRecordUpdated = this.getBaseMapper().updateById(eventDOToUpdate);
-            if(transferRecordUpdated!=1){
+            if (transferRecordUpdated != 1) {
                 throw new ServiceException("更新事件处理流程失败");
             }
             return R.ok();
-        }else{
+        } else {
             throw new ServiceException("处理事件记录出错");
         }
     }
 
     @Override
     public R selectCommunityPublicity(PagePublicityEventCommunityDTO pagePublicityEventDTO) {
-        Page page = new Page(1,10);
-        if(pagePublicityEventDTO.getPageNum()!=null) {
+        Page page = new Page(1, 10);
+        if (pagePublicityEventDTO.getPageNum() != null) {
             page.setCurrent(pagePublicityEventDTO.getPageNum());
         }
-        if(pagePublicityEventDTO.getPageSize()!=null) {
+        if (pagePublicityEventDTO.getPageSize() != null) {
             page.setSize(pagePublicityEventDTO.getPageSize());
         }
         IPage<EventVO> ipage = eventMapper.findCommunityPublicityByPage(page, pagePublicityEventDTO);
-        if(ipage!=null){
+        if (ipage != null) {
             List<EventVO> eventVOList = ipage.getRecords();
             eventVOList.forEach(eventVO -> {
                 List<EventResourceDO> eventResourceDOList =
-                        eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
-                                .eq(EventResourceDO::getClassification, 1)
-                                .eq(EventResourceDO::getRefId, eventVO.getId())
-                        );
+                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                        .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId()));
                 List<EventResourceVO> picList = new ArrayList<>();
                 List<EventResourceVO> audioList = new ArrayList<>();
                 List<EventResourceVO> videoList = new ArrayList<>();
                 eventResourceDOList.forEach(eventResourceDO -> {
-                    switch (eventResourceDO.getType()){
+                    switch (eventResourceDO.getType()) {
                         case 1:
                             EventResourceVO picEventResourceVO = new EventResourceVO();
                             BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
@@ -1420,12 +1573,16 @@
 
     /**
      * 添加发布事件流转记录
-     * @param eventId 事件ID
-     * @param userId 操作用户ID
-     * @param userName 操作用户姓名
+     *
+     * @param eventId
+     *            事件ID
+     * @param userId
+     *            操作用户ID
+     * @param userName
+     *            操作用户姓名
      * @return 添加成功返回true, 否则返回false
      */
-    private EventTransferRecordDO addReleaseRecord(Long eventId, Long userId, String userName){
+    private EventTransferRecordDO addReleaseRecord(Long eventId, Long userId, String userName) {
         EventTransferRecordDO eventTransferRecordDO = new EventTransferRecordDO();
         eventTransferRecordDO.setFromType(1);
         eventTransferRecordDO.setFromId(userId);
@@ -1436,8 +1593,9 @@
         eventTransferRecordDO.setProcessDate(new Date());
         eventTransferRecordDO.setEventId(eventId);
         eventTransferRecordDO.setProcessResult("发布成功");
+        eventTransferRecordDO.setProcessType(0);// 初始状态
         int inserted = eventTransferRecordService.getBaseMapper().insert(eventTransferRecordDO);
-        if(inserted!=1){
+        if (inserted != 1) {
             throw new ServiceException("事件流转记录添加失败");
         }
         this.updateEventDealStatus(eventId);
@@ -1446,110 +1604,1044 @@
 
     /**
      * 查询最后的流转记录,并添加事件流转记录
-     * @param eventId 事件ID
-     * @param toId 流转到 ID
-     * @param toName 流转到 名称
-     * @param toType 发送类型
-     * @param msg 流转消息
+     *
+     * @param eventId
+     *            事件ID
+     * @param toId
+     *            流转到 ID
+     * @param toName
+     *            流转到 名称
+     * @param toType
+     *            发送类型
+     * @param msg
+     *            流转消息
      * @return
      */
-    private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg){
-        List<EventTransferRecordDO> list = eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>()
-                .eq(EventTransferRecordDO::getEventId, eventId)
-                .orderByDesc(EventTransferRecordDO::getCreateAt)
-        );
-        if(list==null ||list.size()==0){
-            throw new ServiceException("事件流转记录异常");
-        }
-        EventTransferRecordDO lastRecord = list.get(0);
+    private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg,
+        Long processBy, String processByName, Integer processType) {
+        List<EventTransferRecordDO> list =
+            eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>()
+                .eq(EventTransferRecordDO::getEventId, eventId).orderByDesc(EventTransferRecordDO::getCreateAt));
         EventTransferRecordDO eventTransferRecordDO = new EventTransferRecordDO();
-        eventTransferRecordDO.setFromType(lastRecord.getToType());
-        eventTransferRecordDO.setFromId(lastRecord.getToId());
-        eventTransferRecordDO.setFromName(lastRecord.getToName());
+        if (list != null && list.size() > 0) {
+            EventTransferRecordDO lastRecord = list.get(0);
+            eventTransferRecordDO.setFromType(lastRecord.getToType());
+            eventTransferRecordDO.setFromId(lastRecord.getToId());
+            eventTransferRecordDO.setFromName(lastRecord.getToName());
+        }
         eventTransferRecordDO.setToType(toType);
         eventTransferRecordDO.setToId(toId);
         eventTransferRecordDO.setProcessDate(new Date());
         eventTransferRecordDO.setToName(toName);
         eventTransferRecordDO.setEventId(eventId);
         eventTransferRecordDO.setProcessResult(msg);
+        eventTransferRecordDO.setProcessBy(processBy);
+        eventTransferRecordDO.setProcessByName(processByName);
+        eventTransferRecordDO.setProcessType(processType);
         int inserted = eventTransferRecordService.getBaseMapper().insert(eventTransferRecordDO);
-        if(inserted==1) {
+        if (inserted == 1) {
             this.updateEventDealStatus(eventId);
             return eventTransferRecordDO;
-        }else{
+        } else {
             throw new ServiceException("事件流转记录添加失败");
         }
     }
 
     /**
-     * 根据子状态 查询用户事件处理状态
-     * @param eventId 事件ID
+     * 查询最后的流转记录,并添加事件流转记录
+     * 
+     * @param eventId
+     *            事件ID
+     * @param toId
+     *            流转到 ID
+     * @param toName
+     *            流转到 名称
+     * @param toType
+     *            发送类型
+     * @param msg
+     *            流转消息
+     * @return
      */
-    private EventDO  updateEventDealStatus(Long eventId){
+    /* private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg,Integer processType){
+        return addTransferRecord(eventId, toId, toName, toType, msg, null, null, processType);
+    }*/
+
+    /**
+     * 根据子状态 查询用户事件处理状态
+     *
+     * @param eventId
+     *            事件ID
+     */
+    private EventDO updateEventDealStatus(Long eventId) {
         EventDO eventDO = this.getBaseMapper().selectById(eventId);
         Integer eventDealStatus = getEventDealStatus(eventDO);
         eventDO.setEventDealStatus(eventDealStatus);
         int updated = this.getBaseMapper().updateById(eventDO);
-        if(updated == 1){
+        if (updated == 1) {
             return eventDO;
-        }else{
+        } else {
             throw new ServiceException("更新事件处理状态错误");
         }
     }
 
     /**
      * 根据子状态 查询用户事件处理状态
-     * @param eventDO 事件
+     *
+     * @param eventDO
+     *            事件
      */
-    private Integer  getEventDealStatus(EventDO eventDO){
-        //1 待处理、2 待验证、3 已上报、4 已解决、5 草稿箱、6已撤销、7已失效、8已发布
-        if(eventDO.getEventCategory()!=null) {
+    private Integer getEventDealStatus(EventDO eventDO) {
+        // 1 待处理、2 待验证、3 已上报、4 已解决、5 草稿箱、6已撤销、7已失效、8已发布
+        if (eventDO.getEventCategory() != null) {
             if (eventDO.getEventCategory() == 1) {
-                Integer event_status = eventDO.getEventStatus()!=null?eventDO.getEventStatus():-1;
-                Integer event_process_status = eventDO.getEventProcessStatus()!=null?eventDO.getEventProcessStatus():-1;
-                Integer process_type = eventDO.getProcessType()!=null?eventDO.getProcessType():-1;
-                Integer community_process = eventDO.getCommunityProcess()!=null?eventDO.getCommunityProcess():-1;
+                Integer event_status = eventDO.getEventStatus() != null ? eventDO.getEventStatus() : -1;
+                Integer event_process_status =
+                    eventDO.getEventProcessStatus() != null ? eventDO.getEventProcessStatus() : -1;
+                Integer process_type = eventDO.getProcessType() != null ? eventDO.getProcessType() : -1;
+                Integer community_process = eventDO.getCommunityProcess() != null ? eventDO.getCommunityProcess() : -1;
 
                 Integer eventDealStatus = -1;
-                if (eventDO.getInvalid() != null && eventDO.getInvalid() == false) {
+                /*if (eventDO.getInvalid() != null && eventDO.getInvalid() == false) {
                     eventDealStatus = 7;
                     //7已失效
-                } else if (event_status == 1) {
+                }*/
+                if (event_status == 1) {
                     eventDealStatus = 5;
-                    //"草稿箱"
-                } else if ( event_status == 4) {
+                    // "草稿箱"
+                } else if (event_status == 4) {
                     eventDealStatus = 6;
-                    //"已撤销"
-                } else if (event_status ==2){
+                    // "已撤销"
+                } else if (event_status == 2) {
                     if (event_process_status == 3) {
                         eventDealStatus = 2;
-                        //"待验证"
-                    }else if (event_process_status == 2) {
+                        // "待验证"
+                    } else if (event_process_status == 2) {
                         eventDealStatus = 4;
-                        //"已解决"
-                    }else if ( community_process == 1 &&  process_type == 2) {
+                        // "已解决"
+                    } else if (community_process == 1 && process_type == 2) {
                         eventDealStatus = 3;
-                        //"已上报"
-                    }else if ( event_process_status == 1 && process_type == 1) {
+                        // "已上报"
+                    } else if (event_process_status == 1 && process_type == 1) {
                         eventDealStatus = 1;
-                        //"待处理"
-                    } 
+                        // "待处理"
+                    }
                 }
                 return eventDealStatus;
             } else if (eventDO.getEventCategory() == 2) {
                 Integer event_status = eventDO.getEventStatus();
                 if (event_status != null && event_status == 1) {
                     return 5;
-                    //"草稿箱"
+                    // "草稿箱"
                 } else if (event_status != null && event_status == 2) {
                     return 8;
-                    //已发布
+                    // 已发布
                 } else if (event_status != null && event_status == 4) {
                     return 6;
-                    //"已撤销"
+                    // "已撤销"
                 }
             }
         }
         return -1;
     }
+
+    /**
+     * 后台管理-统计模块
+     *
+     * @param communityId
+     *            社区id
+     * @return 统计信息
+     */
+    @Override
+    public R eventStatistics(Long communityId) {
+        return R.ok(this.baseMapper.eventStatistics(communityId));
+    }
+
+    /**
+     * 后台管理-网格员统计
+     *
+     * @param statisticsAdminDTO
+     *            请求参数
+     * @return 网格员统计信息
+     */
+    @Override
+    public R gridMemberStatistics(MemberStatisticsAdminDTO statisticsAdminDTO) {
+        return R.ok(eventGridMemberRelationMapper.gridMemberStatistics(
+            new Page(statisticsAdminDTO.getPageNum(), statisticsAdminDTO.getPageSize()), statisticsAdminDTO));
+    }
+
+    @Override
+    public R getNearByGrid(PageEventGridNearbyDTO pageEventGridNearbyDTO) {
+        Page page = new Page(pageEventGridNearbyDTO.getPageNum(), pageEventGridNearbyDTO.getPageSize());
+        String latLng = pageEventGridNearbyDTO.getHappentLatLng();
+        // if(!latLng.matches("^[\\-\\+]?(0(\\.\\d{1,10})?|([1-9](\\d)?)(\\.\\d{1,10})?|1[0-7]\\d{1}(\\.\\d{1,10})?|180\\.0{1,10}),[\\-\\+]?((0|([1-8]\\d?))(\\.\\d{1,10})?|90(\\.0{1,10})?)$")){
+        // return R.fail("经纬度参数错误");
+        // }
+        // 经纬度匹配规则:(短(纬度)在前长(经度)在后,不要擅自修改此规则,否则出现问题后果自负)
+        // if(!latLng.matches("[1-9][0-9](\\.[0-9]{1,6})?,[1-9][0-9]{2}(\\.[0-9]{1,6})?")){
+        // return R.fail("经纬度参数错误");
+        // }
+        String[] latLngArr = latLng.split(",");
+        try {
+            Double lat = Double.valueOf(latLngArr[1]);
+            Double lng = Double.valueOf(latLngArr[0]);
+            List<EventGridDataAreaVO> gridList = eventGridDataMapper.selectGridWithArea(page, pageEventGridNearbyDTO);
+            if (gridList != null && gridList.size() > 0) {
+                List<EventGridDataVO> rtEventGridList = new ArrayList<>();
+                for (EventGridDataAreaVO eventGridDataDO : gridList) {
+                    String data = eventGridDataDO.getData();
+                    if (data != null) {
+                        List<LatLngVO> latLngList = LngLatUtils.getLatLngFromText(data);
+                        boolean inGrid = LngLatUtils.isInPolygon(latLngList, lng, lat);
+                        if (inGrid) {
+                            EventGridDataVO eventGridDataVO = new EventGridDataVO();
+                            BeanUtils.copyProperties(eventGridDataDO, eventGridDataVO);
+                            rtEventGridList.add(eventGridDataVO);
+                        }
+                    }
+                }
+                return R.ok(rtEventGridList);
+            } else {
+                return R.ok("未找到社区");
+            }
+        } catch (Exception e) {
+            return R.fail(e.getMessage());
+        }
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public R deleteEventBatch(EventDeleteDTO eventDeleteDTO) {
+        List<String> eventIds = eventDeleteDTO.getId();
+        if (eventIds != null && eventIds.size() > 0) {
+            R rt = null;
+            Long userId = eventDeleteDTO.getUserId();
+            for (String id : eventIds) {
+                try {
+                    Long eventId = Long.parseLong(id);
+                    EventDO eventDO = eventMapper.selectById(eventId);
+                    if (eventDO == null) {
+                        throw new ServiceException("id为" + id + "的事件不存在");
+                    }
+                    if (eventDO.getEventStatus() != null) {
+                        eventDO.setEventStatus(3);// 逻辑删除
+                        eventDO.setUpdateBy(userId);
+                        int updated = this.getBaseMapper().updateById(eventDO);
+                        if (updated != 1) {
+                            throw new ServiceException("删除事件失败");
+                        }
+                    }
+                } catch (Exception e) {
+                    throw new ServiceException("事件ID错误,删除失败");
+                }
+            }
+            return R.ok();
+        } else {
+            return R.fail("参数错误");
+        }
+
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public R batchRepublishEvent(CommonEventBatchRepublishDTO commonEventBatchRepublishDTO) {
+        List<String> ids = commonEventBatchRepublishDTO.getId();
+        if (ids != null && ids.size() > 0) {
+            Long userId = commonEventBatchRepublishDTO.getUserId();
+            String userName = commonEventBatchRepublishDTO.getUserName();
+            for (String id : ids) {
+                Long eventId = -1L;
+                try {
+                    eventId = Long.parseLong(id);
+                } catch (Exception e) {
+                    throw new ServiceException("事件ID错误,发布失败");
+                }
+                EventDO eventDO = this.getBaseMapper().selectById(eventId);
+                if (eventDO == null) {
+                    throw new ServiceException("id为" + id + "的事件不存在");
+                }
+                boolean canRepublishByUser = eventDO.getEventDealStatus() != null
+                    && (eventDO.getEventDealStatus() == 5 || eventDO.getEventDealStatus() == 6);
+                if (!canRepublishByUser) {
+                    throw new ServiceException("当前不是撤销/草稿状态");
+                }
+                eventDO.setEventStatus(2);// 2 发布
+                eventDO.setEventProcessStatus(1); // 待解决
+                eventDO.setProcessType(1); // 网格员处理
+                eventDO.setUpdateBy(userId);
+                int updated = this.getBaseMapper().updateById(eventDO);
+                if (updated != 1) {
+                    throw new ServiceException("更新事件状态失败");
+                }
+                addTransferRecord(eventDO.getId(), userId, userName, 1, "重新发布已撤销事件", userId, userName, 8);
+            }
+            return R.ok();
+        } else {
+            return R.fail("参数错误");
+        }
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public R batchMarkEventInvalid(EventBatchRevokeDTO eventBatchRevokeDTO) {
+        List<String> ids = eventBatchRevokeDTO.getId();
+        if (ids != null && ids.size() > 0) {
+            Long userId = eventBatchRevokeDTO.getUserId();
+            String userName = eventBatchRevokeDTO.getUserName();
+            Long communityId = eventBatchRevokeDTO.getCommunityId();
+            String communityName = eventBatchRevokeDTO.getCommunityName();
+            for (String id : ids) {
+                Long eventId = -1L;
+                try {
+                    eventId = Long.parseLong(id);
+                } catch (Exception e) {
+                    throw new ServiceException("事件ID错误,不能标记失效");
+                }
+                EventDO eventDO = this.getBaseMapper().selectById(eventId);
+                if (eventDO == null) {
+                    throw new ServiceException("id为" + id + "的事件不存在");
+                }
+                if (eventDO.getEventCategory() != null) {
+                    if (eventDO.getEventCategory() == 1) {//
+                        boolean canRevoke = eventDO.getEventDealStatus() == 3; // 上报状态
+                        if (!canRevoke) {
+                            throw new ServiceException("当前事件不是上报状态,不允许撤销");
+                        }
+                    } else if (eventDO.getEventCategory() == 2) {// 宣传教育
+                        boolean canRevoke = eventDO.getEventDealStatus() == 8; // 发布状态
+                        if (!canRevoke) {
+                            throw new ServiceException("当前事件不是发布状态,不允许撤销");
+                        }
+                    } else {
+                        throw new ServiceException("事件分类错误");
+                    }
+                } else {
+                    throw new ServiceException("事件所属错误");
+                }
+                eventDO.setInvalid(false);
+                // 标为无效后, 交给网格员处理
+                eventDO.setUpdateBy(userId);
+                eventDO.setEventStatus(4);// 4、撤销
+                eventDO.setProcessType(1);// 网格员处理
+                eventDO.setCommunityProcess(0);// 非 社区处理
+                int updated = this.getBaseMapper().updateById(eventDO);
+                if (updated == 1) {
+                    addTransferRecord(eventDO.getId(), userId, userName, 1, "标为无效", communityId, communityName, 4);
+                } else {
+                    throw new ServiceException("事件流转信息添加错误");
+                }
+            }
+            return R.ok();
+        } else {
+            return R.fail("参数错误");
+        }
+    }
+
+    /**
+     * 根据网格id查询网格统计数据
+     * 
+     * @param gridId
+     *            网格id
+     * @return 网格统计数据
+     */
+    @Override
+    public R getGridEventStatisticsByApp(Long gridId, Long userId) {
+        GridEventStatisticsVO result = this.baseMapper.getGridEventStatisticsByApp(gridId);
+        if (result != null) {
+            result.setTodayNum(result.getTodayNum() + result.getZfTodayNum() + result.getSspTodayNum());
+            result.setMonthNum(result.getMonthNum() + result.getZfMonthNum() + result.getSspMonthNum());
+
+            // 查询当前网格员下管理的楼栋名称
+            List<Map<String, Object>> buildNameList = this.baseMapper.getMemberBuildName(userId);
+            Integer specialTotal = 0;
+            if (!buildNameList.isEmpty()) {
+                for (Map<String, Object> buildMap : buildNameList) {
+                    String buildName = buildMap.get("name").toString();
+                    Long villageId = Long.parseLong(buildMap.get("village_id").toString());
+                    Integer num = this.baseMapper.getPopulationByLabelCount(buildName, villageId);
+                    specialTotal += num;
+                }
+            }
+            result.setSpecialTotal(specialTotal);
+        }
+        return R.ok(result);
+    }
+
+    /**
+     * 查询网格事件统计数据
+     * 
+     * @param statisticsDTO
+     *            请求参数
+     * @return 网格事件统计数据
+     */
+    @Override
+    public R getGridEventDetailStatisticsByApp(GridEventStatisticsDTO statisticsDTO) {
+        GridEventStatisticsDetailVO statisticsDetailVO =
+            this.baseMapper.getGridEventDetailStatisticsByApp(statisticsDTO);
+        if (statisticsDetailVO == null) {
+            statisticsDetailVO = new GridEventStatisticsDetailVO();
+        }
+
+        if (statisticsDetailVO.getEventSSPTotal() == null) {
+            statisticsDetailVO.setEventSSPTotal(0);
+        }
+        if (statisticsDetailVO.getNoEventSSPTotal() == null) {
+            statisticsDetailVO.setNoEventSSPTotal(0);
+        }
+        if (statisticsDetailVO.getEventZFTotal() == null) {
+            statisticsDetailVO.setEventZFTotal(0);
+        }
+        if (statisticsDetailVO.getNoEventZFTotal() == null) {
+            statisticsDetailVO.setNoEventZFTotal(0);
+        }
+
+        // 查询网格
+        EventGridDataDO gridDataDO = eventGridDataMapper.selectById(statisticsDTO.getGridId());
+        if (gridDataDO != null) {
+            Map<String, Long> sspCountMap = this.baseMapper.getSSPEventTotal(gridDataDO.getGridCommunityId());
+            if (!sspCountMap.isEmpty()) {
+                statisticsDetailVO.setEventSSPTotal(
+                    sspCountMap.get("eventSSPTotal") != null ? sspCountMap.get("eventSSPTotal").intValue() : 0);
+                statisticsDetailVO.setNoEventSSPTotal(
+                    sspCountMap.get("noEventSSPTotal") != null ? sspCountMap.get("noEventSSPTotal").intValue() : 0);
+            }
+        }
+
+        // 统计数据
+        Integer sum = statisticsDetailVO.getEventTFTotal() + statisticsDetailVO.getEventMDTotal()
+            + statisticsDetailVO.getEventZATotal() + statisticsDetailVO.getEventBWDTotal()
+            + statisticsDetailVO.getEventTSTotal() + statisticsDetailVO.getEventGGTotal()
+            + statisticsDetailVO.getEventXCTotal() + statisticsDetailVO.getEventSSPTotal()
+            + statisticsDetailVO.getEventZFTotal();
+        statisticsDetailVO.setSum(sum);
+
+        Integer noSum = statisticsDetailVO.getNoEventTFTotal() + statisticsDetailVO.getNoEventMDTotal()
+            + statisticsDetailVO.getNoEventZATotal() + statisticsDetailVO.getNoEventBWDTotal()
+            + statisticsDetailVO.getNoEventTSTotal() + statisticsDetailVO.getNoEventGGTotal()
+            + statisticsDetailVO.getNoEventSSPTotal() + statisticsDetailVO.getNoEventZFTotal();
+        statisticsDetailVO.setNoSum(noSum);
+        return R.ok(statisticsDetailVO);
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public R reportDirect(CommonEventDirectReportDTO commonEventDirectReportDTO) {
+
+        if (commonEventDirectReportDTO.getEventId() != null) {
+            // 编辑原来的
+            EventDO eventDO = eventMapper.selectById(commonEventDirectReportDTO.getEventId());
+            if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1
+                && eventDO.getEventDealStatus() != 6) {
+                return R.fail("保存草稿失败,事件不是草稿/已撤销状态");
+            }
+            BeanUtils.copyProperties(commonEventDirectReportDTO, eventDO);
+            eventDO.setGridMemberId(commonEventDirectReportDTO.getUserId());
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventStatus(1);// 事件状态 2发布
+            eventDO.setProcessType(2);// 社区处理
+            eventDO.setCommunityProcess(1);// 社区处理
+            eventDO.setUpdateBy(commonEventDirectReportDTO.getUserId());
+            if (eventMapper.updateById(eventDO) > 0) {
+                int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>()
+                    .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId()));
+                // 添加音频
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getAudio())) {
+                    EventResourceDO eventResourceDO = new EventResourceDO();
+                    eventResourceDO.setClassification(1);
+                    eventResourceDO.setType(2);
+                    eventResourceDO.setRefId(eventDO.getId());
+                    eventResourceDO.setUrl(commonEventDirectReportDTO.getAudio());
+                    eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                    eventResourceDO.setResourceTime(commonEventDirectReportDTO.getAudioTime());
+                    int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                    if (audioAdd != 1) {
+                        throw new ServiceException("添加音频失败");
+                    }
+                }
+                // 添加视频
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getVideo())) {
+                    EventResourceDO eventResourceDO = new EventResourceDO();
+                    eventResourceDO.setClassification(1);
+                    eventResourceDO.setType(3);
+                    eventResourceDO.setRefId(eventDO.getId());
+                    eventResourceDO.setUrl(commonEventDirectReportDTO.getVideo());
+                    eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                    eventResourceDO.setResourceTime(commonEventDirectReportDTO.getVideoTime());
+                    int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                    if (videoAdd != 1) {
+                        throw new ServiceException("添加视频失败");
+                    }
+                }
+                // 添加图片
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getPics())) {
+                    String[] pica = commonEventDirectReportDTO.getPics().split(",");
+                    for (int i = 0; i < pica.length; i++) {
+                        EventResourceDO eventResourceDO = new EventResourceDO();
+                        eventResourceDO.setClassification(1);
+                        eventResourceDO.setType(1);
+                        eventResourceDO.setRefId(eventDO.getId());
+                        eventResourceDO.setUrl(pica[i]);
+                        eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                        int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                        if (picAdd != 1) {
+                            throw new ServiceException("添加图片失败");
+                        }
+                    }
+                }
+
+                R r = communityService.detailCommunity(commonEventDirectReportDTO.getToId());
+                if (!R.isOk(r)) {
+                    return R.fail("社区不存在");
+                }
+                ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class);
+                if (comActVO == null) {
+                    return R.fail("社区不存在");
+                }
+                EventDO eventDOInDB = this.getBaseMapper().selectById(commonEventDirectReportDTO.getEventId());
+                eventDOInDB.setCommunityProcess(1); // 社区处理
+                eventDOInDB.setProcessType(2); // 当前处理对象: 社区处理
+                eventDOInDB.setCommunityProcess(1);
+                eventDOInDB.setEventProcessStatus(1); // 待处理
+                eventDOInDB.setUpdateBy(commonEventDirectReportDTO.getUserId());
+                eventDOInDB.setSubmitDate(new Date());
+                int updated = this.getBaseMapper().updateById(eventDO);
+                if (updated != 1) {
+                    throw new ServiceException("事件状态更新失败");
+                }
+                addTransferRecord(eventDO.getId(), commonEventDirectReportDTO.getToId(), comActVO.getName(), 2,
+                    commonEventDirectReportDTO.getProcessResult(), commonEventDirectReportDTO.getUserId(),
+                    commonEventDirectReportDTO.getUserName(), 2);
+                return R.ok();
+            }
+
+        } else {
+            EventDO eventDO = new EventDO();
+            BeanUtils.copyProperties(commonEventDirectReportDTO, eventDO);
+            eventDO.setGridMemberId(commonEventDirectReportDTO.getUserId());
+            EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventDirectReportDTO.getGridId());
+            if (eventGridDataDO == null) {
+                return R.fail("网格不存在");
+            }
+            eventDO.setEventCategory(1l);// 办件事件
+            eventDO.setEventStatus(2);// 事件状态 2发布
+            eventDO.setProcessType(2);// 社区处理
+            eventDO.setCommunityProcess(1);// 社区处理
+            eventDO.setEventProcessStatus(1);
+            eventDO.setGridMemberName(commonEventDirectReportDTO.getUserName());
+            eventDO.setGridMemberTelephone(commonEventDirectReportDTO.getPhone());
+            eventDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+            eventDO.setSubmitDate(new Date());
+            eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
+            if (eventMapper.insert(eventDO) == 1) {
+                // 添加音频
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getAudio())) {
+                    EventResourceDO eventResourceDO = new EventResourceDO();
+                    eventResourceDO.setClassification(1);
+                    eventResourceDO.setType(2);
+                    eventResourceDO.setUrl(commonEventDirectReportDTO.getAudio());
+                    eventResourceDO.setRefId(eventDO.getId());
+                    eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                    eventResourceDO.setResourceTime(commonEventDirectReportDTO.getAudioTime());
+                    int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                    if (audioAdd != 1) {
+                        throw new ServiceException("添加音频失败");
+                    }
+                }
+                // 添加视频
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getVideo())) {
+                    EventResourceDO eventResourceDO = new EventResourceDO();
+                    eventResourceDO.setClassification(1);
+                    eventResourceDO.setType(3);
+                    eventResourceDO.setUrl(commonEventDirectReportDTO.getVideo());
+                    eventResourceDO.setRefId(eventDO.getId());
+                    eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                    eventResourceDO.setResourceTime(commonEventDirectReportDTO.getVideoTime());
+                    int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                    if (videoAdd != 1) {
+                        throw new ServiceException("添加视频失败");
+                    }
+                }
+                // 添加图片
+                if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getPics())) {
+                    String[] pica = commonEventDirectReportDTO.getPics().split(",");
+                    for (int i = 0; i < pica.length; i++) {
+                        EventResourceDO eventResourceDO = new EventResourceDO();
+                        eventResourceDO.setClassification(1);
+                        eventResourceDO.setType(1);
+                        eventResourceDO.setUrl(pica[i]);
+                        eventResourceDO.setRefId(eventDO.getId());
+                        eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId());
+                        int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
+                        if (picAdd != 1) {
+                            throw new ServiceException("添加图片失败");
+                        }
+                    }
+                }
+                addReleaseRecord(eventDO.getId(), commonEventDirectReportDTO.getUserId(),
+                    commonEventDirectReportDTO.getUserName());
+
+                R r = communityService.detailCommunity(commonEventDirectReportDTO.getToId());
+                if (!R.isOk(r)) {
+                    return R.fail("社区不存在");
+                }
+                ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class);
+                if (comActVO == null) {
+                    return R.fail("社区不存在");
+                }
+                EventDO eventDOInDB = this.getBaseMapper().selectById(eventDO.getId());
+                eventDOInDB.setCommunityProcess(1); // 社区处理
+                eventDOInDB.setProcessType(2); // 当前处理对象: 社区处理
+                eventDOInDB.setCommunityProcess(1);
+                eventDOInDB.setEventProcessStatus(1); // 待处理
+                eventDOInDB.setUpdateBy(commonEventDirectReportDTO.getUserId());
+                eventDOInDB.setSubmitDate(new Date());
+                int updated = this.getBaseMapper().updateById(eventDO);
+                if (updated != 1) {
+                    throw new ServiceException("更新突发事件状态更新失败");
+                }
+                addTransferRecord(eventDO.getId(), commonEventDirectReportDTO.getToId(), comActVO.getName(), 2,
+                    commonEventDirectReportDTO.getProcessResult(), commonEventDirectReportDTO.getUserId(),
+                    commonEventDirectReportDTO.getUserName(), 2);
+                return R.ok(eventDO.getId());
+            }
+        }
+
+        return R.fail();
+    }
+
+    /**
+     * 事件大屏查询事件列表
+     * 
+     * @param eventListDTO
+     *            请求参数
+     * @return 事件列表
+     */
+    @Override
+    public R getScreenEventList(ScreenEventListDTO eventListDTO) {
+        if (eventListDTO.getEventTypes() != null && !eventListDTO.getEventTypes().isEmpty()) {
+            eventListDTO.getEventTypes().forEach(eventType -> {
+                if (eventType.equals(ScreenEventListDTO.eventType.xc)) {
+                    eventListDTO.setEventCategory(null);
+                }
+            });
+
+        }
+        IPage<EventListVO> eventPageList = this.baseMapper
+            .getScreenEventList(new Page(eventListDTO.getPageNum(), eventListDTO.getPageSize()), eventListDTO);
+        if (!eventPageList.getRecords().isEmpty()) {
+            eventPageList.getRecords().forEach(event -> {
+                // 查询事件关联附件
+                List<EventResourceDO> eventResourceDOList =
+                    eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>()
+                        .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, event.getId()));
+                List<EventResourceVO> picList = new ArrayList<>();
+                List<EventResourceVO> audioList = new ArrayList<>();
+                List<EventResourceVO> videoList = new ArrayList<>();
+                eventResourceDOList.forEach(eventResourceDO -> {
+                    switch (eventResourceDO.getType()) {
+                        case 1:
+                            EventResourceVO picEventResourceVO = new EventResourceVO();
+                            BeanUtils.copyProperties(eventResourceDO, picEventResourceVO);
+                            picList.add(picEventResourceVO);
+                            break;
+                        case 2:
+                            EventResourceVO audioResourceVO = new EventResourceVO();
+                            BeanUtils.copyProperties(eventResourceDO, audioResourceVO);
+                            audioList.add(audioResourceVO);
+                            break;
+                        case 3:
+                            EventResourceVO videoResourceVO = new EventResourceVO();
+                            BeanUtils.copyProperties(eventResourceDO, videoResourceVO);
+                            videoList.add(videoResourceVO);
+                            break;
+                    }
+                });
+                event.setAudios(audioList);
+                event.setPics(picList);
+                event.setVideos(videoList);
+            });
+        }
+        return R.ok(eventPageList);
+    }
+
+    /**
+     * 特殊人群上报-社区人口数据列表
+     * 
+     * @param specialPopulationDTO
+     *            请求参数
+     * @return 社区人口数据列表
+     */
+    @Override
+    public R specialPopulationList(PageEventSpecialPopulationDTO specialPopulationDTO) {
+        IPage<EventSpecialPopulationVO> specialPopulationVOIPage = this.baseMapper.specialPopulationList(
+            new Page(specialPopulationDTO.getPageNum(), specialPopulationDTO.getPageSize()), specialPopulationDTO);
+        if (!specialPopulationVOIPage.getRecords().isEmpty()) {
+            specialPopulationVOIPage.getRecords().forEach(specialPopulation -> {
+                try {
+                    Integer age = IdcardUtil.getAgeByIdCard(specialPopulation.getIdCard());
+                    specialPopulation.setAge(age);
+                } catch (Exception e) {
+                    log.error("身份证号码转换年龄失败,人员id:" + specialPopulation.getId());
+                }
+            });
+        }
+        return R.ok(specialPopulationVOIPage);
+    }
+
+    @Override
+    public List<EventDetailsVO> getUnUploadEvent() {
+        List<EventDetailsVO> eventDetailsVOList = new ArrayList<>();
+        List<EventDO> unEventList =
+            baseMapper.selectList(new QueryWrapper<EventDO>().eq("upload", false).eq("event_process_status", 2));
+        unEventList.forEach(eventDO -> {
+            eventDetailsVOList.add(eventDetails(eventDO.getId()).getData());
+        });
+        return eventDetailsVOList;
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public Boolean updateLcUploadFlag(Long id) {
+        EventDO event = baseMapper.selectById(id);
+        event.setUpload(true);
+        baseMapper.updateById(event);
+        EventResourceDO eventResourceDO = new EventResourceDO();
+        eventResourceDO.setUpload(true);
+        int flag = eventResourceMapper.update(eventResourceDO, new QueryWrapper<EventResourceDO>().eq("ref_id", id));
+        return flag > 0;
+    }
+
+    @Override
+    public R eventWork(Long communityId) {
+        EventWorkScreenVO workScreenVO = new EventWorkScreenVO();
+        String date = DateUtils.getDateFormatString(new Date(), moth_format_str);
+        Map<String, Long> countMap = this.eventMapper.countByCommunityId(communityId, date);
+        if (!countMap.isEmpty()) {
+            workScreenVO.setResolvedNum(
+                countMap.get("resolvedNum") == null ? 0L : Long.valueOf(countMap.get("resolvedNum").toString()));
+            workScreenVO.setPendingNum(
+                countMap.get("pendingNum") == null ? 0L : Long.valueOf(countMap.get("pendingNum").toString()));
+            workScreenVO.setPropagandaNum(
+                countMap.get("propagandaNum") == null ? 13L : Long.valueOf(countMap.get("propagandaNum").toString()));
+            workScreenVO.setCurrentNum(countMap.get("sspCurrentNum") + countMap.get("currentNum"));
+        }
+
+        // 计算处理时间消耗的时间
+        DateScreenVO countAvg = this.eventMapper.countByAvgCommunityId(communityId);
+        if (countAvg != null) {
+            int second = (int)(countAvg.getEndTime().getTime() - countAvg.getStartTime().getTime()) / 1000;
+            if (second > 0) {
+                second = second / workScreenVO.getResolvedNum().intValue();
+                workScreenVO.setAvgCost(second);
+            }
+        }
+        // 查询最新事件轮播列表
+        List<EventDetailWorkVO> eventList = this.eventMapper.getWorkScreenEventList(communityId);
+        if (!eventList.isEmpty()) {
+            workScreenVO.setEventList(eventList);
+        }
+
+        // 统计近半年数据
+        List<EventWorkVO> list = new ArrayList<>();
+        for (EventWorkVO eventWorkVO : listHalfYearByDyn()) {
+            EventWorkVO result =
+                this.eventMapper.countByTime(eventWorkVO.getStart(), eventWorkVO.getEnd(), communityId);
+            result.setEventTotal(result.getEventTotal() + result.getSspTotal());
+            result.setEventAdd(result.getEventAdd() + result.getSspAdd());
+            result.setEventSolve(result.getEventSolve() + result.getSspSolve());
+            result.setMonth(eventWorkVO.getMonth());
+            list.add(result);
+        }
+        workScreenVO.setList(list);
+
+        // 查询完成事件统计
+        EventTypeWorkVO complete = this.eventMapper.getComplete(communityId);
+        if (complete != null) {
+            workScreenVO.setComplete(complete);
+        }
+        // 查询未完成事件统计
+        EventTypeWorkVO noComplete = this.eventMapper.getNoComplete(communityId);
+        if (complete != null) {
+            workScreenVO.setNoComplete(noComplete);
+        }
+        return R.ok(workScreenVO);
+    }
+
+    private List<EventWorkVO> listHalfYearByDyn() {
+        List<EventWorkVO> dateList = new ArrayList<>();
+        Date now = new Date();
+        for (int i = 6; i >= 1; i--) {
+            Date date = DateUtils.getDateM(now, -(i - 1));
+            DateTime endDay = DateUtil.endOfMonth(date);
+
+            int m = DateUtil.month(endDay);
+            // m++;
+            if (m == 12) {
+                m = 0;
+            }
+            int day = DateUtil.dayOfMonth(endDay);
+            int half = day / 2;
+            String month = DateUtil.format(date, moth_format_str);
+            EventWorkVO eventWorkVO = new EventWorkVO();
+            eventWorkVO.setMonth(monthStr[m] + "月上旬");
+            eventWorkVO.setStart(month + "-01 00:00:00");
+            eventWorkVO.setEnd(month + "-" + half + " 23:59:59");
+            dateList.add(eventWorkVO);
+            EventWorkVO eventWorkVO1 = new EventWorkVO();
+            eventWorkVO1.setMonth(monthStr[m] + "月下旬");
+            eventWorkVO1.setStart(month + "-" + half + " 23:59:59");
+            eventWorkVO1.setEnd(DateUtils.getDateFormatString(endDay, "yyyy-MM-dd HH:mm:ss"));
+            dateList.add(eventWorkVO1);
+        }
+        return dateList;
+    }
+
+    /**
+     * 绘制多边形统计数据
+     * 
+     * @param eventListDTO
+     *            请求参数
+     * @return 统计数据
+     */
+    @Override
+    public R getCivilDrawList(ScreenDrawEventListDTO eventListDTO) {
+
+        ScreenDrawEventVO drawEventVO = new ScreenDrawEventVO();
+        // 返回事件列表结果集
+        List<EventGridIncidentStatisticsVO> eventResultList = new ArrayList<>();
+        // 返回小区列表结果集
+        List<CivilVillageStatisticsVO> villageResultList = new ArrayList<>();
+        // 返回事件统计
+        EventLeftDownStatisticsVO leftDownStatisticsVO = new EventLeftDownStatisticsVO();
+        // 返回人口统计
+        ScreenDrawEventPopulationTotalVO drawEventPopulationTotalVO = new ScreenDrawEventPopulationTotalVO();
+        // 查询所有事件
+        List<EventGridIncidentStatisticsVO> gridIncidentList =
+            this.baseMapper.getEventListByCommunityId(eventListDTO.getCommunityId());
+        if (!gridIncidentList.isEmpty()) {
+            gridIncidentList.forEach(gridIncident -> {
+                // 拆分事件经纬度
+                Double lng = 0.0;// 经度
+                Double lat = 0.0;// 纬度
+                String[] lngLatString = gridIncident.getLatLng().split(",");
+                if (!gridIncident.getType().equals(7)) {
+                    lat = Double.parseDouble(lngLatString[0]);
+                    lng = Double.parseDouble(lngLatString[1]);
+                } else {
+                    lat = Double.parseDouble(lngLatString[1]);
+                    lng = Double.parseDouble(lngLatString[0]);
+                }
+
+                // 判断绘制的图形类型
+                if (eventListDTO.getType().equals(ScreenDrawEventListDTO.type.yx)) {
+                    // 判断这个点是否在圆形范围内
+                    if (GisPointUtil.isInCircle(eventListDTO.getCenterLng(), eventListDTO.getCenterLat(), lng, lat,
+                        eventListDTO.getRadius())) {
+                        if (eventResultList.size() <= eventListDTO.getCount()) {
+                            eventResultList.add(gridIncident);
+                        }
+                        switch (gridIncident.getType()) {
+                            case 1:
+                                leftDownStatisticsVO.setEventZATotal(leftDownStatisticsVO.getEventZATotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventZATotal(leftDownStatisticsVO.getYesEventZATotal() + 1);
+                                }
+                                break;
+                            case 2:
+                                leftDownStatisticsVO.setEventGGTotal(leftDownStatisticsVO.getEventGGTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventGGTotal(leftDownStatisticsVO.getYesEventGGTotal() + 1);
+                                }
+                                break;
+                            case 3:
+                                leftDownStatisticsVO.setEventMDTotal(leftDownStatisticsVO.getEventMDTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventMDTotal(leftDownStatisticsVO.getYesEventMDTotal() + 1);
+                                }
+                                break;
+                            case 4:
+                                leftDownStatisticsVO.setEventBWDTotal(leftDownStatisticsVO.getEventBWDTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventBWDTotal(leftDownStatisticsVO.getYesEventBWDTotal() + 1);
+                                }
+                                break;
+                            case 5:
+                                leftDownStatisticsVO.setEventTFTotal(leftDownStatisticsVO.getEventTFTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventTFTotal(leftDownStatisticsVO.getYesEventTFTotal() + 1);
+                                }
+                                break;
+                            case 6:
+                                leftDownStatisticsVO.setEventTSTotal(leftDownStatisticsVO.getEventTSTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventTSTotal(leftDownStatisticsVO.getYesEventTSTotal() + 1);
+                                }
+                                break;
+                            case 7:
+                                leftDownStatisticsVO.setEventSSPTotal(leftDownStatisticsVO.getEventSSPTotal() + 1);
+                                if (gridIncident.getStatus().equals(2)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventSSPTotal(leftDownStatisticsVO.getYesEventSSPTotal() + 1);
+                                }
+                                break;
+                            default:
+                                break;
+                        }
+                    }
+                } else {// 多边形类型
+                    if (GisPointUtil.isInPolygon(lng, lat, eventListDTO.getLngLatList())) {
+                        if (eventResultList.size() <= eventListDTO.getCount()) {
+                            eventResultList.add(gridIncident);
+                        }
+                        switch (gridIncident.getType()) {
+                            case 1:
+                                leftDownStatisticsVO.setEventZATotal(leftDownStatisticsVO.getEventZATotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventZATotal(leftDownStatisticsVO.getYesEventZATotal() + 1);
+                                }
+                                break;
+                            case 2:
+                                leftDownStatisticsVO.setEventGGTotal(leftDownStatisticsVO.getEventGGTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventGGTotal(leftDownStatisticsVO.getYesEventGGTotal() + 1);
+                                }
+                                break;
+                            case 3:
+                                leftDownStatisticsVO.setEventMDTotal(leftDownStatisticsVO.getEventMDTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventMDTotal(leftDownStatisticsVO.getYesEventMDTotal() + 1);
+                                }
+                                break;
+                            case 4:
+                                leftDownStatisticsVO.setEventBWDTotal(leftDownStatisticsVO.getEventBWDTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventBWDTotal(leftDownStatisticsVO.getYesEventBWDTotal() + 1);
+                                }
+                                break;
+                            case 5:
+                                leftDownStatisticsVO.setEventTFTotal(leftDownStatisticsVO.getEventTFTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventTFTotal(leftDownStatisticsVO.getYesEventTFTotal() + 1);
+                                }
+                                break;
+                            case 6:
+                                leftDownStatisticsVO.setEventTSTotal(leftDownStatisticsVO.getEventTSTotal() + 1);
+                                if (gridIncident.getStatus().equals(4)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventTSTotal(leftDownStatisticsVO.getYesEventTSTotal() + 1);
+                                }
+                                break;
+                            case 7:
+                                leftDownStatisticsVO.setEventSSPTotal(leftDownStatisticsVO.getEventSSPTotal() + 1);
+                                if (gridIncident.getStatus().equals(2)) {
+                                    leftDownStatisticsVO
+                                        .setYesEventSSPTotal(leftDownStatisticsVO.getYesEventSSPTotal() + 1);
+                                }
+                                break;
+                            default:
+                                break;
+                        }
+                    }
+                }
+            });
+        }
+        drawEventVO.setGridIncidentList(eventResultList);
+        drawEventVO.setLeftDownStatisticsVO(leftDownStatisticsVO);
+
+        // 查询所有小区
+        List<CivilVillageStatisticsVO> villageStatisticsList =
+            this.baseMapper.getCivilScreenVillageList(eventListDTO.getCommunityId());
+        if (!villageStatisticsList.isEmpty()) {
+            villageStatisticsList.forEach(village -> {
+                // 判断绘制的图形类型
+                if (eventListDTO.getType().equals(ScreenDrawEventListDTO.type.yx)) {
+                    // 判断这个点是否在圆形范围内
+                    if (GisPointUtil.isInCircle(eventListDTO.getCenterLng(), eventListDTO.getCenterLat(),
+                        Double.parseDouble(village.getLng()), Double.parseDouble(village.getLat()),
+                        eventListDTO.getRadius())) {
+                        villageResultList.add(village);
+                        ScreenDrawEventPopulationTotalVO populationTotalVO =
+                            this.baseMapper.getVillagePopulationTotal(village.getVillageId());
+                        if (populationTotalVO != null) {
+                            drawEventPopulationTotalVO
+                                .setVillageTotal(drawEventPopulationTotalVO.getVillageTotal() + 1);
+                            drawEventPopulationTotalVO
+                                .setPopulationTotal(drawEventPopulationTotalVO.getPopulationTotal()
+                                    + populationTotalVO.getPopulationTotal());
+                            drawEventPopulationTotalVO.setLocalTotal(
+                                drawEventPopulationTotalVO.getLocalTotal() + populationTotalVO.getLocalTotal());
+                            drawEventPopulationTotalVO.setOutTotal(
+                                drawEventPopulationTotalVO.getOutTotal() + populationTotalVO.getOutTotal());
+                            drawEventPopulationTotalVO.setSpecialTotal(
+                                drawEventPopulationTotalVO.getSpecialTotal() + populationTotalVO.getSpecialTotal());
+                            drawEventPopulationTotalVO.setBuildTotal(
+                                drawEventPopulationTotalVO.getBuildTotal() + populationTotalVO.getBuildTotal());
+                        }
+                    }
+                } else {// 多边形类型
+                    if (GisPointUtil.isInPolygon(Double.parseDouble(village.getLng()),
+                        Double.parseDouble(village.getLat()), eventListDTO.getLngLatList())) {
+                        villageResultList.add(village);
+                        ScreenDrawEventPopulationTotalVO populationTotalVO =
+                            this.baseMapper.getVillagePopulationTotal(village.getVillageId());
+                        if (populationTotalVO != null) {
+                            drawEventPopulationTotalVO
+                                .setVillageTotal(drawEventPopulationTotalVO.getVillageTotal() + 1);
+                            drawEventPopulationTotalVO
+                                .setPopulationTotal(drawEventPopulationTotalVO.getPopulationTotal()
+                                    + populationTotalVO.getPopulationTotal());
+                            drawEventPopulationTotalVO.setLocalTotal(
+                                drawEventPopulationTotalVO.getLocalTotal() + populationTotalVO.getLocalTotal());
+                            drawEventPopulationTotalVO.setOutTotal(
+                                drawEventPopulationTotalVO.getOutTotal() + populationTotalVO.getOutTotal());
+                            drawEventPopulationTotalVO.setSpecialTotal(
+                                drawEventPopulationTotalVO.getSpecialTotal() + populationTotalVO.getSpecialTotal());
+                            drawEventPopulationTotalVO.setBuildTotal(
+                                drawEventPopulationTotalVO.getBuildTotal() + populationTotalVO.getBuildTotal());
+                        }
+                    }
+                }
+            });
+        }
+
+        drawEventVO.setVillageStatisticsList(villageResultList);
+        drawEventVO.setDrawEventPopulationTotalVO(drawEventPopulationTotalVO);
+        return R.ok(drawEventVO);
+    }
+
+    /**
+     * 大屏-根据小区id查询小区统计人数
+     * 
+     * @param villageId
+     *            小区id
+     * @return 小区统计数据
+     */
+    @Override
+    public R civilVillageStatistics(Long villageId) {
+        ScreenDrawEventPopulationTotalVO result = this.baseMapper.getVillagePopulationTotal(villageId);
+        result.setVillageTotal(1);
+        return R.ok(result);
+    }
+
+    /**
+     * 查询所有网格员工作汇总数据
+     * 
+     * @param statisticsAdminDTO
+     *            请求参数
+     * @return 网格员工作汇总数据
+     */
+    @Override
+    public R gridMemberStatisticsAll(MemberStatisticsAdminDTO statisticsAdminDTO) {
+        return R.ok(eventGridMemberRelationMapper.gridMemberStatisticsAll(statisticsAdminDTO));
+    }
 }

--
Gitblit v1.7.1