From db31c68b10e3a58bce17e3bbf880db05b6f341fe Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期五, 16 七月 2021 16:39:56 +0800
Subject: [PATCH] 修改bug

---
 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java |  126 ++++++++++++++++++++++++++----------------
 1 files changed, 78 insertions(+), 48 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 f034a98..8f0aefd 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
@@ -121,9 +121,10 @@
                 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);
@@ -263,7 +264,7 @@
             }
 
             //当事件为特殊人群上报时,需要查询事件与人口关联关系
-            if(eventDetailsVO.getEventType().equals(6)){
+            if(eventDetailsVO.getEventType() != null && eventDetailsVO.getEventType().equals(6)){
                 List<EventSpecialPopulationDetailsVO> specialPopulationList = eventSpecialCrowdRecordMapper.getSpecialPopulationIds(eventDetailsVO.getId());
                 if(!specialPopulationList.isEmpty()){
                     specialPopulationList.forEach(special -> {
@@ -292,13 +293,15 @@
         if (eventGridDataDO == null) {
             return R.fail("网格不存在");
         }
+        eventDO.setGridMemberCommunity(eventGridDataDO.getGridCommunityId());
+        eventDO.setGridMemberStreet(eventGridDataDO.getGridStreetId());
 
         //检查特殊人群上报时参数
-        if(commonEventAddDTO.getEventType().equals(6)){
-            if(commonEventAddDTO.getPopulationIds() == null || commonEventAddDTO.getPopulationIds().size() <= 0){
-                return R.fail("上报人员为空");
-            }
-        }
+//        if(commonEventAddDTO.getEventType().equals(6)){
+//            if(commonEventAddDTO.getPopulationIds() == null || commonEventAddDTO.getPopulationIds().size() <= 0){
+//                return R.fail("上报人员为空");
+//            }
+//        }
 
         eventDO.setEventCategory(1l);//办件事件
         eventDO.setEventStatus(2);//事件状态 2发布
@@ -310,20 +313,22 @@
         eventDO.setCreateBy(commonEventAddDTO.getUserId());
         eventDO.setSubmitDate(new Date());
         eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType()));
-        if (eventMapper.insert(eventDO) == 1) {
 
+        if (eventMapper.insert(eventDO) == 1) {
             //如果是特殊人群,则新增特殊人群与事件关系
             if(commonEventAddDTO.getEventType().equals(6)){
-                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(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);
+                }
             }
 
             //添加音频
@@ -734,15 +739,20 @@
     public R republishEvent(CommonEventRepublishDTO commonEventRepublishDTO) {
         EventDO eventDO = this.getBaseMapper().selectById(commonEventRepublishDTO.getId());
         //boolean canRepublishByUser = eventDO.getEventStatus() == 4 || eventDO.getEventStatus() == 1;
-        boolean canRepublishByUser = eventDO.getEventDealStatus() == 7|eventDO.getEventDealStatus() == 5; //已失效状态
+        boolean canRepublishByUser = eventDO.getEventDealStatus() == 6|eventDO.getEventDealStatus() == 5; //已失效状态
         if (!canRepublishByUser) {
             return R.fail("当前不是撤销/草稿状态");
         }
 
+        if(eventDO.getEventCategory().equals(2L)){//宣传教育
+            eventDO.setEventDealStatus(8);
+        }else{
+            eventDO.setEventProcessStatus(1); //待解决
+            eventDO.setProcessType(1);   //网格员处理
+        }
         eventDO.setEventStatus(2);//2 发布
-        eventDO.setEventProcessStatus(1); //待解决
-        eventDO.setProcessType(1);   //网格员处理
         eventDO.setUpdateBy(commonEventRepublishDTO.getUserId());
+
         int updated = this.getBaseMapper().updateById(eventDO);
         if (updated != 1) {
             return R.fail("更新事件状态失败");
@@ -1020,10 +1030,13 @@
         }
         EventDO eventDO = new EventDO();
         BeanUtils.copyProperties(publicityEventAddDTO, eventDO);
+        eventDO.setHappenTime(publicityEventAddDTO.getPropagandaTime());
         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{
@@ -1264,9 +1277,10 @@
                 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);
@@ -1325,9 +1339,10 @@
                 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);
@@ -1738,9 +1753,10 @@
 //        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("经纬度参数错误");
-        }
+        //经纬度匹配规则:(短(纬度)在前长(经度)在后,不要擅自修改此规则,否则出现问题后果自负)
+//        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]);
@@ -1907,7 +1923,12 @@
      */
     @Override
     public R getGridEventStatisticsByApp(Long gridId){
-        return R.ok(this.baseMapper.getGridEventStatisticsByApp(gridId));
+        GridEventStatisticsVO result = this.baseMapper.getGridEventStatisticsByApp(gridId);
+        if(result != null){
+            result.setTodayNum(result.getTodayNum() + result.getZfTodayNum());
+            result.setMonthNum(result.getMonthNum() + result.getZfMonthNum());
+        }
+        return R.ok(result);
     }
 
     /**
@@ -1933,6 +1954,16 @@
         }
         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);
+            }
         }
 
         //统计数据
@@ -2196,7 +2227,12 @@
         IPage<EventSpecialPopulationVO> specialPopulationVOIPage = this.baseMapper.specialPopulationList(new Page(specialPopulationDTO.getPageNum(), specialPopulationDTO.getPageSize()), specialPopulationDTO);
         if(!specialPopulationVOIPage.getRecords().isEmpty()){
             specialPopulationVOIPage.getRecords().forEach(specialPopulation -> {
-                specialPopulation.setAge(IdcardUtil.getAgeByIdCard(specialPopulation.getIdCard()));
+                try {
+                    Integer age = IdcardUtil.getAgeByIdCard(specialPopulation.getIdCard());
+                    specialPopulation.setAge(age);
+                }catch (Exception e){
+                    log.error("身份证号码转换年龄失败,人员id:" + specialPopulation.getId());
+                }
             });
         }
         return R.ok(specialPopulationVOIPage);
@@ -2240,7 +2276,7 @@
             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("currentNum")== null ? 0L : Long.valueOf(countMap.get("currentNum").toString()));
+            workScreenVO.setCurrentNum(countMap.get("sspCurrentNum") + countMap.get("currentNum"));
         }
 
         //计算处理时间消耗的时间
@@ -2262,6 +2298,9 @@
         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);
         }
@@ -2284,11 +2323,11 @@
         List<EventWorkVO> dateList = new ArrayList<>();
         Date now  = new Date();
         for(int i= 6;i>=1;i--){
-            Date date = DateUtils.getDateM(now,-i);
+            Date date = DateUtils.getDateM(now,-(i-1));
             DateTime endDay = DateUtil.endOfMonth(date);
 
             int m = DateUtil.month(endDay);
-            m++;
+//            m++;
             if(m == 12){
                 m = 0;
             }
@@ -2298,23 +2337,14 @@
             EventWorkVO eventWorkVO = new EventWorkVO();
             eventWorkVO.setMonth(monthStr[m]+"月上旬");
             eventWorkVO.setStart(month+ "-01 00:00:00");
-            eventWorkVO.setEnd(month+ "-"+half+" 23:59:58");
+            eventWorkVO.setEnd(month+ "-"+half+" 23:59:59");
             dateList.add(eventWorkVO);
             EventWorkVO eventWorkVO1 = new EventWorkVO();
             eventWorkVO1.setMonth(monthStr[m]+"月下旬");
-            eventWorkVO1.setStart(month+ "-"+half+" 23:59:58");
+            eventWorkVO1.setStart(month+ "-"+half+" 23:59:59");
             eventWorkVO1.setEnd(DateUtils.getDateFormatString(endDay,"yyyy-MM-dd HH:mm:ss"));
             dateList.add(eventWorkVO1);
         }
         return dateList;
-
     }
-
-    public static void main(String[] args) {
-        String content = "30,104";
-        String re = "[1-9][0-9](\\.[0-9]{1,6})?,[1-9][0-9]{2}(\\.[0-9]{1,6})?";
-
-        System.out.println(content.matches(re));
-    }
-
 }

--
Gitblit v1.7.1