From 2bc69b919ef626e6093d598d7eae07c8f9e3e0e4 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期五, 14 一月 2022 10:56:51 +0800
Subject: [PATCH] 仁和东区代码提交

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/BigScreenStatisticsServiceImpl.java |  310 +++++++++++----------------------------------------
 1 files changed, 69 insertions(+), 241 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/BigScreenStatisticsServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/BigScreenStatisticsServiceImpl.java
index fca296c..ddf1531 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/BigScreenStatisticsServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/BigScreenStatisticsServiceImpl.java
@@ -14,12 +14,9 @@
 
 import javax.annotation.Resource;
 
-import com.panzhihua.common.model.vos.community.bigscreen.BigScreenResidentActStatisticsInfo;
-import com.panzhihua.common.model.vos.community.bigscreen.BigScreenVolunteerActStatisticsInfo;
-import com.panzhihua.service_community.dao.ComActActivityDAO;
-import com.panzhihua.service_community.dao.ComActCommitteeDao;
 import org.springframework.stereotype.Service;
 
+import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.panzhihua.common.model.dtos.PageBaseDTO;
 import com.panzhihua.common.model.dtos.community.convenient.PagePopularMerchantDTO;
@@ -33,12 +30,16 @@
 import com.panzhihua.common.model.vos.community.bigscreen.BigScreenMicroWishStatisticsInfo;
 import com.panzhihua.common.model.vos.community.bigscreen.BigScreenNeighborStatisticsInfo;
 import com.panzhihua.common.model.vos.community.bigscreen.BigScreenQuestionnaireStatisticsInfo;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenResidentActStatisticsInfo;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenVolunteerActStatisticsInfo;
 import com.panzhihua.common.model.vos.community.bigscreen.GridsGovernanceStatisticsVO;
 import com.panzhihua.common.model.vos.community.bigscreen.ResidentAutonomyStatisticsVO;
 import com.panzhihua.common.model.vos.community.convenient.ConvenientMerchantVO;
 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.EventGridStatisticsVO;
+import com.panzhihua.service_community.dao.ComActActivityDAO;
+import com.panzhihua.service_community.dao.ComActCommitteeDao;
 import com.panzhihua.service_community.dao.ComActDiscussDAO;
 import com.panzhihua.service_community.dao.ComActDynDAO;
 import com.panzhihua.service_community.dao.ComActEasyPhotoDAO;
@@ -113,20 +114,12 @@
         if (isNull(statisticsVO)) {
             statisticsVO = new ResidentAutonomyStatisticsVO();
         }
-        List<ComActEasyPhotoVO> easyPhotoVOList = comActEasyPhotoDAO.selectStatisticsList(communityId);
+        List<StatisticsCommVO> easyPhotoHistogram = comActEasyPhotoDAO.selectStatisticsList(communityId);
         //随手拍总数
         Integer easyPhotoTotalCount = 0;
         //随手拍柱状统计
-        List<StatisticsCommVO> easyPhotoHistogram = new ArrayList<>();
-        if (Objects.nonNull(easyPhotoVOList) && !easyPhotoVOList.isEmpty()) {
-            Map<String, List<ComActEasyPhotoVO>> easyPhotoVOMap = easyPhotoVOList.stream().collect(Collectors.groupingBy(ComActEasyPhotoVO::getClassifyName));
-            for (Map.Entry<String, List<ComActEasyPhotoVO>> entry : easyPhotoVOMap.entrySet()) {
-                StatisticsCommVO commVO = new StatisticsCommVO();
-                commVO.setFiled(entry.getKey());
-                commVO.setNum(entry.getValue().size());
-                easyPhotoHistogram.add(commVO);
-            }
-            easyPhotoTotalCount = easyPhotoVOList.size();
+        if (Objects.nonNull(easyPhotoHistogram) && !easyPhotoHistogram.isEmpty()) {
+            easyPhotoTotalCount = easyPhotoHistogram.stream().map(StatisticsCommVO::getNum).mapToInt(Integer::intValue).sum();
         }
         statisticsVO.setEasyPhotoTotalCount(easyPhotoTotalCount);
         statisticsVO.setEasyPhotoHistogram(easyPhotoHistogram);
@@ -135,7 +128,7 @@
         List<StatisticsCommVO> microWishRealizePercent = comActMicroWishDAO.selectRealizePercent(communityId);
         statisticsVO.setMicroWishRealizePercent(microWishRealizePercent);
         //微心愿图片
-        List<String> microWishImages = comActMicroWishDAO.getPassedAllImages(communityId, pageSize);
+        List<String> microWishImages = comActMicroWishDAO.getPassedAllImages(communityId, 20);
         statisticsVO.setMicroWishImages(microWishImages);
 
         //议事投票类型占比
@@ -149,40 +142,19 @@
         statisticsVO.setVoteTitles(voteTitles);
 
         //邻里圈图片
-        List<String> neighborImages = comActNeighborCircleDAO.getAllImages(communityId, pageSize);
+        List<String> neighborImages = comActNeighborCircleDAO.getAllImages(communityId, 20);
         statisticsVO.setNeighborImages(neighborImages);
         //邻里圈文本内容
         List<String> neighborContents = comActNeighborCircleDAO.getContents(communityId, pageSize);
         statisticsVO.setNeighborContents(neighborContents);
 
         //报事报修新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> repairAddPolylineData = comPropertyDao.getRepairPolylineDate(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = repairAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                repairAddPolylineData.add(other);
-            }
-        }
-        repairAddPolylineData = repairAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsVO.setRepairAddPolylineData(repairAddPolylineData);
         //报事报修累计折线数据
         List<StatisticsCommVO> repairTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         repairAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comPropertyDao.getRepairTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comPropertyDao.getRepairTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             repairTotalPolylineData.add(temp);
         });
@@ -195,18 +167,20 @@
         List<String> warehouseLoveTransfer = comActWarehouseDonatesDao.getWarehouseLoveTransfer(communityId, pageSize);
         statisticsVO.setWarehouseLoveTransfer(warehouseLoveTransfer);
         //捐赠图片
-        List<String> warehouseImages = comActWarehouseDonatesDao.getWarehouseImages(communityId, pageSize);
+        List<String> warehouseImages = comActWarehouseDonatesDao.getWarehouseImages(communityId, 20);
         statisticsVO.setWarehouseImages(warehouseImages);
 
         //居民活动柱状统计
         List<StatisticsCommVO> residentActHistogram = comActActivityDAO.selectResidentActHistogramData(communityId, true);
+        //居民活动新增数据
+        List<StatisticsCommVO> actAddPolylineData = comActActivityDAO.getActAddPolylineData(communityId, true);
         //居民活动发布总数
         int residentActTotalCount = 0;
         if (!residentActHistogram.isEmpty()) {
             residentActTotalCount = residentActHistogram.stream().map(StatisticsCommVO::getNum).mapToInt(Integer::intValue).sum();
         }
         statisticsVO.setResidentActTotalCount(residentActTotalCount);
-        statisticsVO.setResidentActHistogram(residentActHistogram);
+        statisticsVO.setResidentActHistogram(actAddPolylineData);
         //业主委员会党员占比
         List<StatisticsCommVO> committeePartyPercent = comActCommitteeDao.selectCommitteePartyPercent(communityId);
         statisticsVO.setCommitteePartyPercent(committeePartyPercent);
@@ -244,37 +218,13 @@
             });
         }
         statisticsVO.setVillageStatisticsList(villageStatisticsList);
-        // 查询社区事件列表
-        List<EventGridIncidentStatisticsVO> gridIncidentList = comMngPopulationDAO.getGridsGovernanceEventList(communityId);
-        statisticsVO.setGridIncidentList(gridIncidentList);
         //事件分析新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> eventAddPolylineData = comPropertyDao.getEventAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = eventAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                eventAddPolylineData.add(other);
-            }
-        }
-        eventAddPolylineData = eventAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsVO.setEventAddPolylineData(eventAddPolylineData);
         //事件分析累计折线数据
         List<StatisticsCommVO> eventTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         eventAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comPropertyDao.getEventTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comPropertyDao.getEventTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             eventTotalPolylineData.add(temp);
         });
@@ -340,31 +290,11 @@
         //微心愿新增折线数据
         Date nowDate = new Date();
         List<StatisticsCommVO> microWishAddPolylineData = comActMicroWishDAO.getMicroWishAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = microWishAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                microWishAddPolylineData.add(other);
-            }
-        }
-        microWishAddPolylineData = microWishAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setMicroWishAddPolylineData(microWishAddPolylineData);
         //微心愿累计折线数据
         List<StatisticsCommVO> microWishTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         microWishAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActMicroWishDAO.getMicroWishTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comActMicroWishDAO.getMicroWishTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             microWishTotalPolylineData.add(temp);
         });
@@ -383,31 +313,11 @@
         //随手拍新增折线数据
         Date nowDate = new Date();
         List<StatisticsCommVO> easyPhotoAddPolylineData = comActEasyPhotoDAO.getEasyPhotoAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = easyPhotoAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                easyPhotoAddPolylineData.add(other);
-            }
-        }
-        easyPhotoAddPolylineData = easyPhotoAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setEasyPhotoAddPolylineData(easyPhotoAddPolylineData);
         //随手拍累计折线数据
         List<StatisticsCommVO> easyPhotoTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         easyPhotoAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActEasyPhotoDAO.getEasyPhotoTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comActEasyPhotoDAO.getEasyPhotoTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             easyPhotoTotalPolylineData.add(temp);
         });
@@ -434,33 +344,12 @@
     public R indexQuestionnaire(Long communityId) {
         BigScreenQuestionnaireStatisticsInfo statisticsInfo = comActQuestnaireDAO.getIndexQuestionnaireBaseData(communityId);
         //社区问卷新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> questionnaireAddPolylineData = comActQuestnaireDAO.getQuestionnaireAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = questionnaireAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                questionnaireAddPolylineData.add(other);
-            }
-        }
-        questionnaireAddPolylineData = questionnaireAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setQuestionnaireAddPolylineData(questionnaireAddPolylineData);
         //社区问卷累计折线数据
         List<StatisticsCommVO> questionnaireTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         questionnaireAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActQuestnaireDAO.getQuestionnaireTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comActQuestnaireDAO.getQuestionnaireTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             questionnaireTotalPolylineData.add(temp);
         });
@@ -482,33 +371,12 @@
             statisticsInfo.setDynNum(dynCircleData.stream().map(StatisticsCommVO::getNum).mapToInt(Integer::intValue).sum());
         }
         //社区动态新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> dynAddPolylineData = comActDynDAO.getDynAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = dynAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                dynAddPolylineData.add(other);
-            }
-        }
-        dynAddPolylineData = dynAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setDynAddPolylineData(dynAddPolylineData);
         //社区动态累计折线数据
         List<StatisticsCommVO> dynTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         dynAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActDynDAO.getDynTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comActDynDAO.getDynTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             dynTotalPolylineData.add(temp);
         });
@@ -539,36 +407,15 @@
         statisticsInfo.setNeighborCircleData(neighborCircleData);
         if (!neighborCircleData.isEmpty()) {
             statisticsInfo.setPublishContentNum(neighborCircleData.stream().map(StatisticsCommVO::getNum).mapToInt(Integer::intValue).sum());
-            statisticsInfo.setPublishTopicNum(neighborCircleData.size());
+            statisticsInfo.setPublishTopicNum(neighborCircleData.stream().filter(e -> !"无话题".equals(e.getFiled())).collect(Collectors.toList()).size());
         }
         //邻里圈新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> neighborAddPolylineData = comActNeighborCircleDAO.getNeighborAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = neighborAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                neighborAddPolylineData.add(other);
-            }
-        }
-        neighborAddPolylineData = neighborAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setNeighborAddPolylineData(neighborAddPolylineData);
         //邻里圈累计折线数据
         List<StatisticsCommVO> neighborTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         neighborAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActNeighborCircleDAO.getNeighborTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = comActNeighborCircleDAO.getNeighborTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             neighborTotalPolylineData.add(temp);
         });
@@ -605,33 +452,12 @@
             statisticsInfo.setServiceTypeNum(serviceTypeCircleData.size());
         }
         //服务次数(目前暂时使用浏览量)新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> serviceTimesAddPolylineData = convenientMerchantDAO.getServiceTimesAddPolylineData(communityId);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = serviceTimesAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                serviceTimesAddPolylineData.add(other);
-            }
-        }
-        serviceTimesAddPolylineData = serviceTimesAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setServiceTimesAddPolylineData(serviceTimesAddPolylineData);
         //服务次数(目前暂时使用浏览量)累计折线数据
         List<StatisticsCommVO> serviceTimesTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         serviceTimesAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = convenientMerchantDAO.getServiceTimesTotalPolylineDate(communityId, year + e.getFiled());
+            StatisticsCommVO temp = convenientMerchantDAO.getServiceTimesTotalPolylineDate(communityId, e.getFiled());
             temp.setFiled(e.getFiled());
             serviceTimesTotalPolylineData.add(temp);
         });
@@ -693,33 +519,12 @@
         }
         statisticsInfo.setPublishNum(publishNum);
         //居民活动新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> actAddPolylineData = comActActivityDAO.getActAddPolylineData(communityId, true);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = actAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                actAddPolylineData.add(other);
-            }
-        }
-        actAddPolylineData = actAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setActAddPolylineData(actAddPolylineData);
         //居民活动累计折线数据
         List<StatisticsCommVO> actTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         actAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActActivityDAO.getActTotalPolylineData(communityId, true, year + e.getFiled());
+            StatisticsCommVO temp = comActActivityDAO.getActTotalPolylineData(communityId, true, e.getFiled());
             temp.setFiled(e.getFiled());
             actTotalPolylineData.add(temp);
         });
@@ -759,33 +564,12 @@
         }
         statisticsInfo.setPublishNum(publishNum);
         //志愿者活动新增折线数据
-        Date nowDate = new Date();
         List<StatisticsCommVO> actAddPolylineData = comActActivityDAO.getActAddPolylineData(communityId, false);
-        int currentMon = Integer.parseInt(new SimpleDateFormat("MM").format(nowDate));
-        for (int i = 1; i <= currentMon; i++) {
-            String temp;
-            if (i > 9) {
-                temp = "" + i;
-            } else {
-                temp = "0" + i;
-            }
-            boolean isExist = actAddPolylineData.stream().anyMatch(e -> nonNull(e.getFiled()) &&
-                    e.getFiled().endsWith(temp));
-            if (!isExist) {
-                StatisticsCommVO other = new StatisticsCommVO();
-                other.setFiled(temp);
-                other.setNum(0);
-                actAddPolylineData.add(other);
-            }
-        }
-        actAddPolylineData = actAddPolylineData.stream().filter(e -> nonNull(e.getFiled()))
-                .sorted(Comparator.comparing(e -> e.getFiled())).collect(Collectors.toList());
         statisticsInfo.setActAddPolylineData(actAddPolylineData);
         //志愿者活动累计折线数据
         List<StatisticsCommVO> actTotalPolylineData = new ArrayList<>();
-        String year = new SimpleDateFormat("yyyy").format(nowDate);
         actAddPolylineData.forEach(e -> {
-            StatisticsCommVO temp = comActActivityDAO.getActTotalPolylineData(communityId, false, year + e.getFiled());
+            StatisticsCommVO temp = comActActivityDAO.getActTotalPolylineData(communityId, false, e.getFiled());
             temp.setFiled(e.getFiled());
             actTotalPolylineData.add(temp);
         });
@@ -804,6 +588,50 @@
         return R.ok(comActActivityDAO.indexActList(page, pageBaseDTO, false));
     }
 
+    /**
+     * 清网治格-根据事件分类获取近1月的社区事件数据
+     * @param type
+     * @param communityId
+     * @return
+     */
+    @Override
+    public R getEventList(Integer type, Long communityId) {
+        // 查询社区事件列表
+        List<EventGridIncidentStatisticsVO> gridIncidentList = comMngPopulationDAO.getGridsGovernanceEventList(communityId);
+        List<EventGridIncidentStatisticsVO> returnGridIncidentList = new ArrayList<>();
+        if (!gridIncidentList.isEmpty()) {
+            gridIncidentList.forEach(e -> {
+                if (e.getEventType().equals(2)) {
+                    String[] lngLatString = e.getLatLng().split(",");
+                    e.setLatLng(lngLatString[1] + "," + lngLatString[0]);
+                }
+            });
+            returnGridIncidentList = gridIncidentList.stream().filter(e -> type.equals(e.getType())).collect(Collectors.toList());
+        }
+        return R.ok(returnGridIncidentList);
+    }
+
+    /**
+     * 清网治格-社区事件数据分页
+     * @param pageBaseDTO
+     * @return
+     */
+    @Override
+    public R pageEventList(PageBaseDTO pageBaseDTO) {
+        Page page = retrievePage(pageBaseDTO);
+        IPage<EventGridIncidentStatisticsVO> iPage = comMngPopulationDAO.pageEventList(page, pageBaseDTO);
+        List<EventGridIncidentStatisticsVO> gridIncidentList = iPage.getRecords();
+        if (!gridIncidentList.isEmpty()) {
+            gridIncidentList.forEach(e -> {
+                if (e.getEventType().equals(2)) {
+                    String[] lngLatString = e.getLatLng().split(",");
+                    e.setLatLng(lngLatString[1] + "," + lngLatString[0]);
+                }
+            });
+        }
+        return R.ok(iPage);
+    }
+
     private Page retrievePage(PageBaseDTO pageBaseDTO) {
         Long pageNum = pageBaseDTO.getPageNum();
         Long size = pageBaseDTO.getPageSize();

--
Gitblit v1.7.1