From 78c7b03e279cad29a6123e83da738edc1f00280c Mon Sep 17 00:00:00 2001
From: liuhaonan <31457034@qq.com>
Date: 星期四, 23 六月 2022 16:55:41 +0800
Subject: [PATCH] bug修复

---
 ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightTaskService.java |  245 ++++++++++++++++++++++++++++++++++--------------
 1 files changed, 171 insertions(+), 74 deletions(-)

diff --git a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightTaskService.java b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightTaskService.java
index 03b04c3..194c366 100644
--- a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightTaskService.java
+++ b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightTaskService.java
@@ -29,13 +29,16 @@
 import com.sandu.ximon.admin.security.SecurityUtils;
 import com.sandu.ximon.admin.utils.StoreOperationRecordsUtils;
 import com.sandu.ximon.admin.utils.TaskOrderUtil;
+import com.sandu.ximon.dao.bo.LightTaskPoleRelationBo;
 import com.sandu.ximon.dao.bo.LightTaskStatusAndPole;
 import com.sandu.ximon.dao.domain.LightEnergyData;
 import com.sandu.ximon.dao.domain.LightTask;
 import com.sandu.ximon.dao.domain.LightTaskPoleRelation;
 import com.sandu.ximon.dao.domain.Pole;
 import com.sandu.ximon.dao.enums.DeviceRespStatusEnums;
+import com.sandu.ximon.dao.enums.OrderByEnums;
 import com.sandu.ximon.dao.mapper.LightTaskMapper;
+import com.sandu.ximon.dao.mapper.LightTaskPoleRelationMapper;
 import lombok.AllArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.BeanUtils;
@@ -137,7 +140,7 @@
     }
 
     @Transactional(rollbackFor = Exception.class)
-    public int updateLightTask(Long taskId, LightTaskParam param) {
+    public String updateLightTask(Long taskId, LightTaskParam param) {
         if (StrUtil.length(param.getControlOrder()) % LightTaskParam.REQUEST_ORDER_LENGTH != 0) {
             throw new BusinessException("鐏帶鍛戒护鏍煎紡涓嶆纭�");
         }
@@ -184,6 +187,7 @@
 
         List<LightTaskPoleRelation> newPoleAll = new ArrayList<>();
         List<LightTaskPoleRelation> newPoleSuccess = new ArrayList<>();
+        List<LightTaskPoleRelation> newPoleFail = new ArrayList<>();
         if (CollectionUtil.isNotEmpty(newPoleIdList)) {
             //鏂扮伅鏉嗕笅鍙戞柊浠诲姟
             Map<String, List<LightTaskPoleRelation>> newPoleMap = sendControllerFrame(newPoleIdList, lightTask.getFramePayload(), param.getLightAddress());
@@ -191,6 +195,7 @@
             //newPoleAll闆嗗悎鍚庨潰鐢ㄤ簬瀛樺偍鍏崇郴琛�
             newPoleAll = newPoleMap.getOrDefault("all", new ArrayList<>());
             newPoleSuccess = newPoleMap.getOrDefault("success", new ArrayList<>());
+            newPoleFail = newPoleMap.getOrDefault("fail", new ArrayList<>());
         }
 
         List<LightTaskPoleRelation> oldPoleFail = new ArrayList<>();
@@ -203,22 +208,26 @@
         }
 
         List<LightTaskPoleRelation> closePoleFail = new ArrayList<>();
-        List<LightTaskPoleRelation> closeSuccess = new ArrayList<>();
+        List<LightTaskPoleRelation> closePoleSuccess = new ArrayList<>();
         if (CollectionUtil.isNotEmpty(closeLight)) {
             //鎵ц鍏崇伅鍐呭抚
             String framePayloadClose = "7f0000007f173b00";
             //瑕嗙洊鎿嶄綔鐏潌
             Map<String, List<LightTaskPoleRelation>> closePoleMap = sendControllerFrame(closeLight, framePayloadClose, param.getLightAddress());
             closePoleFail = closePoleMap.getOrDefault("fail", new ArrayList<>());
-            closeSuccess = closePoleMap.getOrDefault("success", new ArrayList<>());
+            closePoleSuccess = closePoleMap.getOrDefault("success", new ArrayList<>());
         }
 
-        //鏈夊け鏁楃殑闇�瑕佷繚瀛樻棫鐨勪换鍕�
+
         if (closePoleFail.size() == 0 && oldPoleFail.size() == 0) {
+            //鏃т换鍔′腑鍏ㄩ儴鍙戦�佹寚浠ゆ垚鍔燂紝鏇存柊鍘熸湰浠诲姟涓殑鏁版嵁
             newLightTask.setTaskId(lightTask.getTaskId());
             updateById(newLightTask);
         } else {
-            save(newLightTask);
+            if (!newPoleSuccess.isEmpty() || !oldPoleSuccess.isEmpty()) {
+                //鏈夊け鏁楃殑闇�瑕佷繚瀛樻棫鐨勪换鍕欙紝鏂板鏂扮殑浠诲姟鏁版嵁杩涜淇濆瓨
+                save(newLightTask);
+            }
         }
 
         /**
@@ -231,18 +240,13 @@
                 poleCodeList = poleList.stream().map(Pole::getDeviceCode).collect(Collectors.toList());
             }
         }
-        String content = "{浠诲姟ID锛�" + newLightTask.getTaskId()
-                + "锛� 浠诲姟鍚嶏細" + newLightTask.getTaskName()
-                + "}锛寋鍐呭抚鎸囦护" + newLightTask.getFramePayload()
-                + "锛� 鐏潌ID锛�" + param.getPoleIdList().toString()
-                + "锛� 鎺у埗鐨勭伅澶村湴鍧�锛�" + param.getLightAddress()
-                + " }";
+        String content = "{浠诲姟ID锛�" + newLightTask.getTaskId() + "锛� 浠诲姟鍚嶏細" + newLightTask.getTaskName() + "}锛寋鍐呭抚鎸囦护" + newLightTask.getFramePayload() + "锛� 鐏潌ID锛�" + param.getPoleIdList().toString() + "锛� 鎺у埗鐨勭伅澶村湴鍧�锛�" + param.getLightAddress() + " }";
         StoreOperationRecordsUtils.storeOperationData(poleCodeList, null, "缂栬緫璺伅浠诲姟", content);
         /**
          * 缂栬緫璺伅浠诲姟鏃ュ織璁板綍缁撴潫
          */
 
-        for (LightTaskPoleRelation bean : newPoleAll) {
+        for (LightTaskPoleRelation bean : newPoleSuccess) {
             bean.setTaskId(newLightTask.getTaskId());
         }
         //鎴愬姛鐢ㄦ柊鐨勪换鍔D
@@ -260,46 +264,54 @@
         }
 
         List<LightTaskPoleRelation> all = new ArrayList<>();
-        all.addAll(newPoleAll);
+        all.addAll(newPoleSuccess);
         all.addAll(oldPoleSuccess);
         all.addAll(oldPoleFail);
         all.addAll(closePoleFail);
 
 
-
-
-
         List<Long> allPoleId = new ArrayList<>();
-        allPoleId.addAll(poleIdList);
-        allPoleId.addAll(oldList);
-        lightTaskPoleRelationService.remove(Wrappers.lambdaQuery(LightTaskPoleRelation.class).in(LightTaskPoleRelation::getPoleId, allPoleId));
-        lightTaskPoleRelationService.saveBatch(all);
+        for (LightTaskPoleRelation bean : newPoleSuccess) {
+            allPoleId.add(bean.getPoleId());
+        }
+        for (LightTaskPoleRelation bean : oldPoleSuccess) {
+            allPoleId.add(bean.getPoleId());
+        }
+        for (LightTaskPoleRelation bean : oldPoleFail) {
+            allPoleId.add(bean.getPoleId());
+        }
+        for (LightTaskPoleRelation bean : closePoleSuccess) {
+            allPoleId.add(bean.getPoleId());
+        }
+
+        if (!allPoleId.isEmpty()) {
+            lightTaskPoleRelationService.remove(Wrappers.lambdaQuery(LightTaskPoleRelation.class).in(LightTaskPoleRelation::getPoleId, allPoleId));
+
+        }
+        if (!all.isEmpty()) {
+            lightTaskPoleRelationService.saveBatch(all);
+        }
 
 
         /**
          * 涓嬪彂璺伅浠诲姟鏃ュ織璁板綍寮�濮�
          */
-        String content1 = "{浠诲姟ID锛�" + newLightTask.getTaskId()
-                + "锛� 浠诲姟鍚嶏細" + newLightTask.getTaskName()
-                + "}," + " 鐏潌ID锛�" + param.getPoleIdList().toString()
-                + " }";
+        String content1 = "{浠诲姟ID锛�" + newLightTask.getTaskId() + "锛� 浠诲姟鍚嶏細" + newLightTask.getTaskName() + "}," + " 鐏潌ID锛�" + param.getPoleIdList().toString() + " }";
         StoreOperationRecordsUtils.storeOperationData(poleCodeList, null, "涓嬪彂璺伅浠诲姟", content1);
         /**
          * 涓嬪彂璺伅浠诲姟鏃ュ織璁板綍缁撴潫
          */
 
-        if(oldPoleFail.isEmpty()&&closePoleFail.isEmpty()){
-            //鍏ㄩ儴鎴愬姛
-            return 0;
-        }else if(!closeLight.isEmpty()||!oldPoleFail.isEmpty()){
-            //鍏崇伅澶辫触  鎴栬�呰鐩栦换鍔″け璐�
-            return 1;
-        }else if(newPoleSuccess.isEmpty()&&oldPoleSuccess.isEmpty()&&closeSuccess.isEmpty()){
-            //缂栬緫鍏ㄩ儴澶辫触
-            return 2;
-        }else {
-            //鍏朵粬鎯呭喌
-            return -1;
+        if (newPoleFail.isEmpty() && oldPoleFail.isEmpty() && closePoleFail.isEmpty()) {
+            return "缂栬緫鎴愬姛";
+        } else if (newPoleSuccess.isEmpty() && oldPoleSuccess.isEmpty() && closePoleSuccess.isEmpty()) {
+            throw new BusinessException("缂栬緫澶辫触,璇锋鏌ョ紪杈戠殑璁惧鏄惁鍦ㄧ嚎!");
+        } else if (!closePoleFail.isEmpty() || !oldPoleFail.isEmpty()) {
+            return "鍘熶换鍔′腑瀛樺湪涓嬪彂寮傚父锛屽師浠诲姟淇濈暀锛屽垱寤烘柊浠诲姟杩涜淇濆瓨";
+        } else if (!newPoleFail.isEmpty()) {
+            return "鏂颁换鍔′腑瀛樺湪涓嬪彂寮傚父锛屽拷鐣ュ紓甯告搷浣滅殑鐏潌";
+        } else {
+            return "鎿嶄綔寮傚父";
         }
     }
 
@@ -320,22 +332,48 @@
         return Optional.ofNullable(responseCommonFrame).map(WrapResponseCommonFrame::getResponseInnerFrame).orElse(null);
     }
 
-    public List<LightTaskDto> listLightTask(BaseConditionVO conditionVO, String keyword) {
-        LambdaQueryWrapper<LightTask> wrapper = Wrappers.lambdaQuery(LightTask.class);
-        if (StrUtil.isNotBlank(keyword)) {
-            wrapper.like(LightTask::getTaskName, keyword);
-        }
-        //涓嶆槸瓒呯闇�瑕佺瓫閫�
-        if (SecurityUtils.getClientId() != null) {
-            wrapper.eq(LightTask::getClientId, SecurityUtils.getUserId()).or(w -> {
-                w.eq(LightTask::getUserId, SecurityUtils.getUserId());
-            });
-        }
+    public List<LightTaskDto> listLightTask(BaseConditionVO conditionVO, String keyword, Integer order, Integer seq) {
+//        LambdaQueryWrapper<LightTask> wrapper = Wrappers.lambdaQuery(LightTask.class);
+//        if (StrUtil.isNotBlank(keyword)) {
+//            wrapper.like(LightTask::getTaskName, keyword);
+//        }
+//        //涓嶆槸瓒呯闇�瑕佺瓫閫�
+//        if (SecurityUtils.getClientId() != null) {
+//            wrapper.eq(LightTask::getClientId, SecurityUtils.getUserId()).or(w -> {
+//                w.eq(LightTask::getUserId, SecurityUtils.getUserId());
+//            });
+//        }
 
-        if (conditionVO != null) {
-            PageHelper.startPage(conditionVO.getPageNo(), conditionVO.getPageSize());
+        //鎺掑簭瀛楁
+        String orderByResult = "task_id";
+        //姝e簭銆佸�掑彊
+        String orderBySeq = OrderByEnums.ASC.getCode();
+        if (order != null) {
+            switch (order) {
+                case 1:
+                    orderByResult = OrderByEnums.LIGHT_TASK_UPDATE_TIME.getCode();
+                    break;
+                default:
+            }
         }
-        List<LightTask> list = list(wrapper);
+        if (seq != null) {
+            switch (seq) {
+                case 1:
+                    orderBySeq = OrderByEnums.ASC.getCode();
+                    break;
+                case 2:
+                    orderBySeq = OrderByEnums.DESC.getCode();
+                    break;
+                default:
+                    break;
+            }
+        }
+        //鎺掑簭鏂瑰紡
+        String orderBy = orderByResult + " " + orderBySeq;
+
+        PageHelper.startPage(conditionVO.getPageNo(), conditionVO.getPageSize(), orderBy);
+        List<LightTask> list = baseMapper.listTask(SecurityUtils.getClientId(),keyword,orderBy);
+
 
         Page<LightTaskDto> page = new Page<>();
         BeanUtils.copyProperties(list, page);
@@ -343,6 +381,35 @@
             LightTaskDto lightTaskDto = new LightTaskDto();
             BeanUtils.copyProperties(lightTask, lightTaskDto);
             lightTaskDto.setWeekList(TaskOrderUtil.parseLightWeek2List(lightTask.getWeek()));
+            //涓嬪彂鎴愬姛鐨勭伅鏉嗘暟閲�
+            Integer successCount = baseMapper.successCount(lightTaskDto.getTaskId());
+            ///浠诲姟涓�荤殑鐏潌鏁伴噺
+            Integer toTalCount = baseMapper.toTalCount(lightTaskDto.getTaskId());
+            if (successCount == null) {
+                successCount = 0;
+            }
+            if (toTalCount == null) {
+                toTalCount = 0;
+            }
+            if (toTalCount == 0) {
+                //浠诲姟涓病鏈夌伅鏉�
+                lightTaskDto.setSyncStatus("鏈悓姝�");
+            } else {
+                //浠诲姟涓湁鐏潌
+                if (successCount == 0) {
+                    //涓嬪彂鎴愬姛鏈�0
+                    lightTaskDto.setSyncStatus("鏈悓姝�");
+                } else if (successCount != 0 && successCount < toTalCount) {
+                    //瀛樺湪涓嬪彂鎴愬姛    浣嗗苟鏈叏閮ㄦ垚鍔�
+                    lightTaskDto.setSyncStatus("閮ㄥ垎鍚屾");
+                } else if (toTalCount.equals(successCount) && toTalCount != 0 && successCount != 0) {
+                    //鍏ㄩ儴鎴愬姛
+                    lightTaskDto.setSyncStatus("宸插悓姝�");
+                } else {
+                    //鏈煡绫诲瀷
+                    lightTaskDto.setSyncStatus("鍚屾鐘舵�佸嚭閿�");
+                }
+            }
             page.add(lightTaskDto);
         }
         return page;
@@ -599,35 +666,65 @@
      */
     public void energy() {
         List<LightTask> lightTasks = list(Wrappers.lambdaQuery(LightTask.class));
-        for (LightTask lightTask : lightTasks) {
-            List<LightTaskPoleRelation> list = SpringContextHolder.getBean(LightTaskPoleRelationService.class).list(Wrappers.lambdaQuery(LightTaskPoleRelation.class).eq(LightTaskPoleRelation::getTaskId, lightTask.getTaskId()));
 
-            LightTaskDto lightTaskDto = new LightTaskDto();
-            BeanUtils.copyProperties(lightTask, lightTaskDto);
-            lightTaskDto.setWeekList(TaskOrderUtil.parseLightWeek2List(lightTask.getWeek()));
+        List<Long> taskIdList = new ArrayList<>();
+        for (LightTask bean : lightTasks) {
+            taskIdList.add(bean.getTaskId());
+        }
+        if (taskIdList.size() != 0) {
+            List<LightTaskPoleRelationBo> list = SpringContextHolder.getBean(LightTaskPoleRelationMapper.class).test(taskIdList);
+            for (LightTaskPoleRelationBo bean : list) {
 
-            BigDecimal energySaving = SpringContextHolder.getBean(LightService.class).jisuan(lightTaskDto);
-            BigDecimal energy = SpringContextHolder.getBean(LightService.class).jisuanEnergy(lightTaskDto);
+                LightTaskDto lightTaskDto = new LightTaskDto();
+                BeanUtils.copyProperties(bean, lightTaskDto);
+                lightTaskDto.setWeekList(TaskOrderUtil.parseLightWeek2List(bean.getWeek()));
+                BigDecimal energySaving;
+                BigDecimal energy;
+                //鑾峰彇鏄ㄥぉ鐨勬槦鏈熸暟
+                LocalDateTime now = LocalDateTime.now();
+                LocalDateTime yesterday = now.minusDays(1);
+                int week = yesterday.getDayOfWeek().getValue();
+                if (!list.isEmpty()) {
+                    //鏈夌粦瀹氱伅鏉�  杩涜璁$畻
+                    if (lightTaskDto.getWeekList().contains(week)) {
+                        //浠诲姟鏈夎鏄熸湡鏁�  璁$畻
+                        energySaving = SpringContextHolder.getBean(LightService.class).jisuan(lightTaskDto);
+                        energy = SpringContextHolder.getBean(LightService.class).jisuanEnergy(lightTaskDto);
+                    } else {
+                        //浠诲姟鏃犺鏄熸湡鏁�  杩斿洖
+                        energySaving = new BigDecimal(1);
+                        energy = BigDecimal.ZERO;
+                    }
+                    for (int i = 0; i < list.size(); i++) {
+                        LightTaskPoleRelation relation = list.get(i);
+                        if (relation.getIssueStatus() != 0) {
+                            //浠诲姟涓嬪彂澶辫触  杩斿洖
+                            energySaving = new BigDecimal(1);
+                            energy = BigDecimal.ZERO;
+                        }
+                    }
+                } else {
+                    //鏈粦瀹氱伅鏉�  鐩存帴杩斿洖
+                    energySaving = new BigDecimal(1);
+                    energy = BigDecimal.ZERO;
+                }
 
-            //鑾峰彇鏄ㄥぉ鐨勬槦鏈熸暟
-            LocalDateTime now = LocalDateTime.now();
-            LocalDateTime yesterday = now.minusDays(1);
+                /**
+                 * 瀛樺偍鏁版嵁
+                 */
 
+                LightEnergyData lightEnergyData = new LightEnergyData();
+                lightEnergyData.setTaskId(bean.getTaskId());
+                lightEnergyData.setYtdTime(yesterday.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
+                lightEnergyData.setEnergySaving(energySaving);
+                lightEnergyData.setEnergy(energy);
+                lightEnergyData.setUserId(bean.getUserId());
+                lightEnergyData.setClientId(bean.getClientId());
+                lightEnergyData.setPoleId(bean.getPoleId());
+                //淇濆瓨鑳借�楁暟鎹埌鏁版嵁搴�
+                lightEnergyDataService.save(lightEnergyData);
+            }
 
-            LightEnergyData lightEnergyData = new LightEnergyData();
-            lightEnergyData.setTaskId(lightTask.getTaskId());
-            lightEnergyData.setYtdTime(yesterday.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
-            lightEnergyData.setEnergySaving(energySaving);
-            lightEnergyData.setEnergy(energy);
-            lightEnergyData.setUserId(lightTask.getUserId());
-            lightEnergyData.setClientId(lightTask.getClientId());
-
-            //淇濆瓨鑳借�楁暟鎹埌鏁版嵁搴�
-            lightEnergyDataService.save(lightEnergyData);
-
-            System.out.println(lightEnergyData + "---------------");
-            //ID   浠诲姟id
         }
     }
-
 }

--
Gitblit v1.9.3