From 2753ad7aee272a5a5a8a0124b1feea5a1e4cc83e Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期五, 20 六月 2025 22:40:52 +0800
Subject: [PATCH] 电源告警参数返回

---
 src/main/java/com/whyc/service/AlmAnalysisParamService.java |  240 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 240 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/whyc/service/AlmAnalysisParamService.java b/src/main/java/com/whyc/service/AlmAnalysisParamService.java
index afa5076..9c76ae8 100644
--- a/src/main/java/com/whyc/service/AlmAnalysisParamService.java
+++ b/src/main/java/com/whyc/service/AlmAnalysisParamService.java
@@ -1,15 +1,46 @@
 package com.whyc.service;
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.whyc.dto.AnalysisAlm.AnalysisChangeRes;
+import com.whyc.dto.AnalysisAlm.ResAnalysis;
+import com.whyc.dto.Real.RealDateDTO;
+import com.whyc.dto.Response;
+import com.whyc.factory.ThreadPoolExecutorFactory;
 import com.whyc.mapper.AlmAnalysisParamMapper;
+import com.whyc.pojo.db_data_history.BattRealdataId;
+import com.whyc.pojo.db_data_history.PwrdevHistorydataId;
 import com.whyc.pojo.db_param.AlmAnalysisParam;
+import com.whyc.pojo.db_param.AlmSummaryParam;
+import com.whyc.pojo.db_param.AppParam;
+import com.whyc.util.ActionUtil;
+import com.whyc.util.DateUtil;
+import com.whyc.util.ThreadLocalUtil;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+
+import java.text.ParseException;
+import java.util.*;
+import java.util.concurrent.CountDownLatch;
+import java.util.concurrent.ThreadPoolExecutor;
+import java.util.concurrent.TimeUnit;
+import java.util.stream.Collectors;
+
+import static java.lang.Thread.sleep;
 
 @Service
 public class AlmAnalysisParamService {
     @Autowired(required = false)
     private AlmAnalysisParamMapper mapper;
+
+    @Autowired
+    private AppParamService appParamService;
+
+    @Autowired
+    private SubTablePageInfoService subTablePageInfoService;
+
+    @Autowired
+    private AlmSummaryParamService summaryParamService;
+
     //鑾峰彇鍛婅almId瀵瑰簲鐨勫垎鏋愰厤缃睘鎬у��
     public AlmAnalysisParam getAnalysisParam(Integer almId) {
         QueryWrapper wrapper=new QueryWrapper();
@@ -18,4 +49,213 @@
         AlmAnalysisParam param= mapper.selectOne(wrapper);
         return param;
     }
+
+    //棰勮鍒嗘瀽绠$悊-鐢垫簮涓诲睘鎬у拰鍒嗘瀽灞炴��
+    public Response getHisRealInAlm(Integer battgroupId,Integer powerId, String startTime, Integer almId) throws ParseException, InterruptedException {
+        Map<String,Object> map=new HashMap<>();
+        map.put("batt",null);
+        map.put("pwr",null);
+        //鑾峰彇棰勮鍒嗘瀽鍛ㄦ湡闃堝��
+        AppParam appParam = appParamService.getAlarmAnalysisCycle();
+        Integer cycleTime=appParam.getParamValue().intValue();
+        Date cyscleDate=ActionUtil.getDateAdd(ThreadLocalUtil.parse(startTime,1),cycleTime*(-1));
+        //鑾峰彇cyscleDate鍒扮幇鍦ㄦ墍鏈夌殑鍘嗗彶瀹炴椂鏁版嵁
+        List<List<Date>> monthTimeList = DateUtil.getMonthTime(cyscleDate,new Date());
+        //鑾峰彇鍛婅almId瀵瑰簲鐨勫垎鏋愰厤缃睘鎬у��
+        AlmAnalysisParam almAnalysisParam=getAnalysisParam(almId);
+        if(almAnalysisParam==null||almAnalysisParam.getMainFieldType()==null){
+            return new Response().set(1,false,"鏃犲搴斿垎鏋愬睘鎬�");
+        }else{
+            //鍒嗙粍鏌ョ湅闇�瑕佹煡璇㈢數婧�/鐢垫睜瀹炴椂琛ㄧ殑鍝簺鏁版嵁
+            Map<String,  Map<String,Integer>> groupmap=groupPwrAndBatt(almAnalysisParam);
+            Map<String,Integer> battMap=groupmap.get("batt");
+            Map<String,Integer> pwrMap=groupmap.get("pwr");
+            if(battgroupId!=null){
+                if(battMap!=null&&battMap.size()>0){
+                    List battHislist=getBattRealData(battgroupId,monthTimeList,battMap);
+                    map.put("batt",battHislist);
+                }
+            }
+            if(powerId!=null){
+                if(pwrMap!=null&&pwrMap.size()>0){
+                    List pwrHislist=getPwrRealData(powerId,monthTimeList,pwrMap);
+                    map.put("pwr",pwrHislist);
+                }
+            }
+            return new Response().setII(1,true, map,"棰勮鍒嗘瀽绠$悊-鐢垫簮涓诲睘鎬у拰鍒嗘瀽灞炴��");
+        }
+    }
+    //鍒嗙粍鏌ョ湅闇�瑕佹煡璇㈢數婧�/鐢垫睜瀹炴椂琛ㄧ殑鍝簺鏁版嵁
+    private  Map<String,  Map<String,Integer>> groupPwrAndBatt(AlmAnalysisParam almAnalysisParam) {
+        Map<String,  Map<String,Integer>> map = new HashMap<>();
+        Map<String,Integer> battMap=new HashMap<>();
+        Map<String,Integer> pwrMap=new HashMap<>();
+        if(almAnalysisParam.getMainFieldType()==1||almAnalysisParam.getMainFieldType()==2||almAnalysisParam.getMainFieldType()==3){
+            if(almAnalysisParam.getMainField()!=null||almAnalysisParam.getMainField().length()>0){
+                pwrMap.put(almAnalysisParam.getMainField(),almAnalysisParam.getMainFieldType());
+            }
+        }else{
+            if(almAnalysisParam.getMainField()!=null||almAnalysisParam.getMainField().length()>0){
+                battMap.put(almAnalysisParam.getMainField(),almAnalysisParam.getMainFieldType());
+            }
+        }
+        if(almAnalysisParam.getMinorField1Type()==1||almAnalysisParam.getMinorField1Type()==2||almAnalysisParam.getMinorField1Type()==3){
+            if(almAnalysisParam.getMinorField1()!=null&&almAnalysisParam.getMinorField1().length()>0){
+                pwrMap.put(almAnalysisParam.getMinorField1(),almAnalysisParam.getMinorField1Type());
+            }
+        }else{
+             if(almAnalysisParam.getMinorField1()!=null&&almAnalysisParam.getMinorField1().length()>0){
+                 battMap.put(almAnalysisParam.getMinorField1(),almAnalysisParam.getMinorField1Type());
+             }
+        }
+        if(almAnalysisParam.getMinorField2Type()==1||almAnalysisParam.getMinorField2Type()==2||almAnalysisParam.getMinorField2Type()==3){
+            if(almAnalysisParam.getMinorField2()!=null&&almAnalysisParam.getMinorField2().length()>0){
+                pwrMap.put(almAnalysisParam.getMinorField2(),almAnalysisParam.getMinorField2Type());
+            }
+        }else{
+            if(almAnalysisParam.getMinorField2()!=null&&almAnalysisParam.getMinorField2().length()>0){
+                battMap.put(almAnalysisParam.getMinorField2(),almAnalysisParam.getMinorField2Type());
+            }
+        }
+        if(almAnalysisParam.getMinorField3Type()==1||almAnalysisParam.getMinorField3Type()==2||almAnalysisParam.getMinorField3Type()==3){
+            if(almAnalysisParam.getMinorField3()!=null&&almAnalysisParam.getMinorField3().length()>0){
+                pwrMap.put(almAnalysisParam.getMinorField3(),almAnalysisParam.getMinorField3Type());
+            }
+        }else{
+            if(almAnalysisParam.getMinorField3()!=null&&almAnalysisParam.getMinorField3().length()>0){
+                battMap.put(almAnalysisParam.getMinorField3(),almAnalysisParam.getMinorField3Type());
+            }
+        }
+        if(almAnalysisParam.getMinorField4Type()==1||almAnalysisParam.getMinorField4Type()==2||almAnalysisParam.getMinorField4Type()==3){
+            if(almAnalysisParam.getMinorField4()!=null&&almAnalysisParam.getMinorField4().length()>0){
+                pwrMap.put(almAnalysisParam.getMinorField4(),almAnalysisParam.getMinorField4Type());
+            }
+        }else{
+            if(almAnalysisParam.getMinorField4()!=null&&almAnalysisParam.getMinorField4().length()>0){
+                battMap.put(almAnalysisParam.getMinorField4(),almAnalysisParam.getMinorField4Type());
+            }
+        }
+        map.put("pwr",pwrMap);
+        map.put("batt",battMap);
+        return map;
+    }
+    //杩炴帴姹犺幏鍙栫數婧愬巻鍙插疄鏃舵暟鎹�
+    public List getPwrRealData(Integer powerId,List<List<Date>> monthTimeList,Map<String,Integer> pwrMap) throws InterruptedException {
+        List<ResAnalysis> dataList = new LinkedList<>();
+        ThreadPoolExecutor pool = ThreadPoolExecutorFactory.getPoolExecutor();
+        CountDownLatch latch = new CountDownLatch(monthTimeList.size());
+        for (int i = 0; i < monthTimeList.size(); i++) {
+            int finalI = i;
+            pool.execute(() -> {
+                int finalII = finalI;
+                PwrdevHistorydataId pwrHis = new PwrdevHistorydataId();
+                pwrHis.setRecordDatetime(monthTimeList.get(finalII).get(0));
+                pwrHis.setRecordDatetime1(monthTimeList.get(finalII).get(1));
+                String table = powerId + "_" + ThreadLocalUtil.format(pwrHis.getRecordDatetime(),2);
+                pwrHis.setTableName(table);//琛ㄥ悕鏃堕棿鏍煎紡閮ㄥ垎
+                //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦�
+                int tableNum = subTablePageInfoService.judgeTable_pwrhis(table);
+                List<ResAnalysis> list = new ArrayList();
+                if (tableNum > 0) {
+                    list = subTablePageInfoService.getPwrHisRealInAlm(pwrHis,pwrMap);
+                }
+                dataList.addAll(list);
+                latch.countDown();
+            });
+            sleep(200);
+        }
+        latch.await(10, TimeUnit.MINUTES);
+        List dataListSorted = dataList.stream().sorted(Comparator.comparing(ResAnalysis::getRecordTime)).collect(Collectors.toList());
+        return  dataListSorted;
+    }
+
+    //鐢垫睜鍛婅鐐瑰嚮鍏蜂綋鍛婅淇℃伅鏌ョ湅浠庡憡璀﹀紑濮嬫椂闂村埌鐜板湪鐨勫巻鍙插疄鏃舵暟鎹�
+    public List getBattRealData(Integer battgroupId, List<List<Date>> monthTimeList,Map<String,Integer> battMap) throws ParseException, InterruptedException {
+        List<ResAnalysis> dataList = new LinkedList<>();
+        ThreadPoolExecutor pool = ThreadPoolExecutorFactory.getPoolExecutor();
+        CountDownLatch latch = new CountDownLatch(monthTimeList.size());
+        for (int i = 0; i < monthTimeList.size(); i++) {
+            int finalI = i;
+            pool.execute(() -> {
+                int finalII = finalI;
+                BattRealdataId realdata = new BattRealdataId();
+                realdata.setRecordTime(monthTimeList.get(finalII).get(0));
+                realdata.setRecordTime1(monthTimeList.get(finalII).get(1));
+                String table = battgroupId + "_" + ThreadLocalUtil.format(realdata.getRecordTime(),2);
+                realdata.setTableName(table);//琛ㄥ悕鏃堕棿鏍煎紡閮ㄥ垎
+                //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦�
+                int tableNum = subTablePageInfoService.judgeTable_realdata(table);
+                List<ResAnalysis> list = new ArrayList();
+                if (tableNum > 0) {
+                    list = subTablePageInfoService.getBattHisRealInAlm(realdata,battMap);
+                }
+                dataList.addAll(list);
+                latch.countDown();
+            });
+            sleep(200);
+        }
+        latch.await(10, TimeUnit.MINUTES);
+        List dataListSorted = dataList.stream().sorted(Comparator.comparing(ResAnalysis::getRecordTime)).collect(Collectors.toList());
+        return dataListSorted;
+    }
+    //棰勮鍒嗘瀽绠$悊-鍒囨崲鏃堕棿闂撮殧鍜屽壇灞炴��
+    public Response getHisRealWithChage(AnalysisChangeRes res) throws ParseException, InterruptedException {
+        Map<String,Object> map=new HashMap<>();
+        map.put("batt",null);
+        map.put("pwr",null);
+        Integer cycleTime=0;
+        //鑾峰彇棰勮鍒嗘瀽鍛ㄦ湡闃堝��
+        AppParam appParam = appParamService.getAlarmAnalysisCycle();
+        if(res.getIntervalTime()==null){
+            cycleTime=appParam.getParamValue().intValue();
+        }else{
+            //灏嗘暟鎹簱涓椂闂撮棿闅斾慨鏀�
+            appParamService.updateAlarmAnalysisCycle(res.getIntervalTime());
+            cycleTime=res.getIntervalTime();
+        }
+        Date cyscleDate=ActionUtil.getDateAdd(ThreadLocalUtil.parse(res.getStartTime(),1),cycleTime*(-1));
+        //鑾峰彇cyscleDate鍒扮幇鍦ㄦ墍鏈夌殑鍘嗗彶瀹炴椂鏁版嵁
+        List<List<Date>> monthTimeList = DateUtil.getMonthTime(cyscleDate,new Date());
+
+        //鑾峰彇鍛婅almId瀵瑰簲鐨勫垎鏋愰厤缃睘鎬у��
+        AlmAnalysisParam almAnalysisParam=new AlmAnalysisParam();
+        //灏嗗睘鎬ф嫹璐濊嚦almAnalysisParam涓�
+        copyProperties(almAnalysisParam,res);
+        //鍒嗙粍鏌ョ湅闇�瑕佹煡璇㈢數婧�/鐢垫睜瀹炴椂琛ㄧ殑鍝簺鏁版嵁
+        Map<String,  Map<String,Integer>> groupmap=groupPwrAndBatt(almAnalysisParam);
+        Map<String,Integer> battMap=groupmap.get("batt");
+        Map<String,Integer> pwrMap=groupmap.get("pwr");
+        if(res.getBattgroupId()!=null){
+            if(battMap!=null&&battMap.size()>0){
+                List battHislist=getBattRealData(res.getBattgroupId(),monthTimeList,battMap);
+                map.put("batt",battHislist);
+            }
+        }
+        if(res.getPowerId()!=null){
+            if(pwrMap!=null&&pwrMap.size()>0){
+                List pwrHislist=getPwrRealData(res.getPowerId(),monthTimeList,pwrMap);
+                map.put("pwr",pwrHislist);
+            }
+        }
+        return new Response().setII(1,true, map,"棰勮鍒嗘瀽绠$悊-鍒囨崲鏃堕棿闂撮殧鍜屽壇灞炴��");
+    }
+    //灏嗗睘鎬ф嫹璐濊嚦almAnalysisParam涓�
+    private void copyProperties(AlmAnalysisParam almAnalysisParam, AnalysisChangeRes res) {
+        almAnalysisParam.setMainField(res.getDataName1());
+        almAnalysisParam.setMainFieldType(res.getDataType1());
+        almAnalysisParam.setMinorField1(res.getDataName2());
+        almAnalysisParam.setMinorField1Type(res.getDataType2());
+        almAnalysisParam.setMinorField2(res.getDataName3());
+        almAnalysisParam.setMinorField2Type(res.getDataType3());
+        almAnalysisParam.setMinorField3(res.getDataName4());
+        almAnalysisParam.setMinorField3Type(res.getDataType4());
+        almAnalysisParam.setMinorField4(res.getDataName5());
+        almAnalysisParam.setMinorField4Type(res.getDataType5());
+    }
+    //棰勮鍒嗘瀽绠$悊-鏌ヨ鎵�鏈夌殑灞炴�у搴斿叧绯�
+    public Response getAlmSummaryParam() {
+        //鎬荤殑灞炴�ч厤缃�
+        List<AlmSummaryParam> summaryList=summaryParamService.getInfo();
+        return new Response().setII(1,true,summaryList,"棰勮鍒嗘瀽绠$悊-鏌ヨ鎵�鏈夌殑灞炴�у搴斿叧绯�");
+    }
 }
\ No newline at end of file

--
Gitblit v1.9.1