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