From a9df6151d30ea1e2053d168496763dd8f0b27a45 Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期一, 23 六月 2025 09:57:00 +0800 Subject: [PATCH] 实时页面系统概论推送指定时间到当前的数据 --- src/main/java/com/whyc/service/PwrdevHistorydataIdService.java | 263 +++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 227 insertions(+), 36 deletions(-) diff --git a/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java b/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java index f5646de..7c00d39 100644 --- a/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java +++ b/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java @@ -1,21 +1,41 @@ package com.whyc.service; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.whyc.constant.PwrCapperformanceEnum; +import com.whyc.dto.AnalysisAlm.ResAnalysis; +import com.whyc.dto.Real.CompareDto; import com.whyc.dto.Real.PwrHisRealAcInDto; import com.whyc.dto.Real.PwrHisRealDcoutInDto; +import com.whyc.dto.Real.QuarterDto; import com.whyc.dto.Response; +import com.whyc.dto.Statistic.QuarterPwr7Res; +import com.whyc.factory.ThreadPoolExecutorFactory; import com.whyc.mapper.CommonMapper; import com.whyc.pojo.db_data_history.BattRealdataId; import com.whyc.pojo.db_data_history.PwrdevHistorydataId; +import com.whyc.pojo.db_param.AppParam; +import com.whyc.pojo.db_param.ApptimeParam; +import com.whyc.pojo.db_param.PowerPropertyParam; +import com.whyc.pojo.db_param.PowerheartParam; import com.whyc.pojo.db_station.PowerInf; 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 javax.annotation.Resource; +import java.lang.reflect.Field; +import java.text.ParseException; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; -import java.util.Date; -import java.util.List; +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 PwrdevHistorydataIdService { @@ -27,47 +47,218 @@ @Autowired private PowerInfService powerInfService; - //绯荤粺姒傝鑾峰彇鍗婂皬鏃朵氦娴佽緭鍏ョ粺璁� - public Response getHalfHourPwrHisAcinData(Integer powerId,Integer granularity) { - String dateTime = ActionUtil.sdfwithOutday.format(new Date()); - //鑾峰彇鍓嶅崐涓皬鏃舵暟鎹� - LocalDateTime now = LocalDateTime.now(); - // 璁$畻鍗婂皬鏃跺墠鐨勬椂闂寸偣 - LocalDateTime halfHourAgo = now.minusMinutes(30); - // 鏍煎紡鍖栬緭鍑� - DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); - String halfHourAgoTime=halfHourAgo.format(formatter); - String tableName ="db_data_history.tb_pwrdev_historydata_"+powerId+"_"+dateTime; - String existTableName = commonMapper.existTable("db_data_history", "tb_pwrdev_historydata_"+powerId+"_"+dateTime); - if(existTableName == null){ - return new Response().set(1,false,"褰撳墠鐢垫睜缁勪笉瀛樺湪鍓嶉潰灏忔椂鏁版嵁"); - } - List<PwrHisRealAcInDto> datalist=subTablePageInfoService.getHalfHourPwrHisAcinData(tableName,granularity,halfHourAgoTime); - return new Response().setII(1,datalist.size()>0,datalist,"鑾峰彇鍗婂皬鏃跺唴浜ゆ祦杈撳叆缁熻"); + @Autowired + private AppParamService appParamService; + @Autowired + private ApptimeParamService apptimeParamService; + + @Autowired + private PowerPropertyParamService propertyParamService; + + @Autowired + private PowerheartParamService heartService; + + //绯荤粺姒傝鍓峃绗斾氦娴佽緭鍏ョ粺璁� + public Response getPwrHisAcinData100(Integer powerId) throws ParseException, InterruptedException { + //鑾峰彇鍓嶇瑪鏁�*鏃堕棿闂撮殧 + PowerheartParam heartParam=heartService.getHeartParamByPowerId(powerId); + Integer interverCount=100*5;//榛樿鍊� + Integer granularity=5;//榛樿鍊� + if(heartParam!=null){ + interverCount=heartParam.getAcinInterverCfg()*heartParam.getAcinCountCfg(); + granularity=heartParam.getAcinInterverCfg(); + } + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + LocalDateTime now = LocalDateTime.now(); + String dateTime = now.format(formatter); + Date endTime=ActionUtil.sdf.parse(dateTime); + // 璁$畻绗旀暟*鏃堕棿闂撮殧鐨勬椂闂寸偣 + LocalDateTime halfHourAgo = now.minusMinutes(interverCount); + // 鏍煎紡鍖栬緭鍑� + String halfHourAgoTime=halfHourAgo.format(formatter); + Date startTime=ActionUtil.sdf.parse(halfHourAgoTime); + //鑾峰彇涓や釜鏃堕棿鍒嗗壊澶氬皯寮犺〃 + List<List<Date>> monthTimeList = DateUtil.getMonthTime(startTime,endTime); + List<PwrHisRealAcInDto> dataList = new LinkedList<>(); + ThreadPoolExecutor pool = ThreadPoolExecutorFactory.getPoolExecutor(); + CountDownLatch latch = new CountDownLatch(monthTimeList.size()); + for (int i = 0; i < monthTimeList.size(); i++) { + int finalI = i; + Integer finalGranularity = granularity; + pool.execute(() -> { + int finalII = finalI; + Date recordDatetime=monthTimeList.get(finalII).get(0); + Date recordDatetime1=monthTimeList.get(finalII).get(1); + String table = powerId + "_" + ThreadLocalUtil.format(recordDatetime,2); + String tableName="db_data_history.tb_pwrdev_historydata_"+table; + //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦� + int tableNum = subTablePageInfoService.judgeTable_pwrhis(table); + List<PwrHisRealAcInDto> list = new ArrayList(); + if (tableNum > 0) { + //鑾峰彇鎸囧畾鏃堕棿娈靛唴鏈�澶ф渶灏弐ecordNum纭繚鏁版嵁鐨勫畬鏁� + List recordNums= subTablePageInfoService.getPwrMaxAndMinRecordNum(tableName,recordDatetime,recordDatetime1); + Integer maxRecordNum= 0; + Integer minRecordNum= 0; + if(recordNums.size()>0){ + maxRecordNum=(Integer)recordNums.get(0); + minRecordNum=(Integer)recordNums.get(1); + } + list=subTablePageInfoService.getHalfHourPwrHisAcinData(tableName, finalGranularity,recordDatetime,recordDatetime1,maxRecordNum,minRecordNum); + } + dataList.addAll(list); + latch.countDown(); + }); + sleep(200); + } + latch.await(10, TimeUnit.MINUTES); + List dataListSorted = dataList.stream().sorted(Comparator.comparing(PwrHisRealAcInDto::getRecordDatetime)).collect(Collectors.toList()); + return new Response().setII(1,dataList.size()>0,dataListSorted,"鑾峰彇鍗婂皬鏃跺唴浜ゆ祦杈撳叆缁熻"); } - //绯荤粺姒傝鑾峰彇鍗婂皬鏃剁洿娴佽緭鍑虹粺璁� - public Response getHalfHourPwrHisDcoutData(Integer powerId,Integer granularity) { - String dateTime = ActionUtil.sdfwithOutday.format(new Date()); - //鑾峰彇鍓嶅崐涓皬鏃舵暟鎹� - LocalDateTime now = LocalDateTime.now(); - // 璁$畻鍗婂皬鏃跺墠鐨勬椂闂寸偣 - LocalDateTime halfHourAgo = now.minusMinutes(30); - // 鏍煎紡鍖栬緭鍑� - DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); - String halfHourAgoTime=halfHourAgo.format(formatter); - - String tableName ="db_data_history.tb_pwrdev_historydata_"+powerId+"_"+dateTime; - String existTableName = commonMapper.existTable("db_data_history", "tb_pwrdev_historydata_"+powerId+"_"+dateTime); - if(existTableName == null){ - return new Response().set(1,false,"褰撳墠鐢垫簮涓嶅瓨鍦ㄥ墠闈㈠皬鏃舵暟鎹�"); + //绯荤粺姒傝鑾峰彇鍓峃绗旂洿娴佽緭鍑虹粺璁� + public Response getHalfHourPwrHisDcoutData(Integer powerId) throws InterruptedException, ParseException { + //鑾峰彇鍓嶇瑪鏁�*鏃堕棿闂撮殧 + PowerheartParam heartParam=heartService.getHeartParamByPowerId(powerId); + Integer interverCount=100*5;//榛樿鍊� + Integer granularity=5;//榛樿鍊� + if(heartParam!=null){ + interverCount=heartParam.getAcoutInterverCfg()*heartParam.getAcoutCountCfg(); + granularity=heartParam.getAcoutInterverCfg();//榛樿鏃堕棿闂撮殧涓�鍒嗛挓涓�绗旓紝鎵�浠ユ椂闂撮棿闅斿氨鏄嚑绗斿彇涓�绗� } - List<PwrHisRealDcoutInDto> datalist=subTablePageInfoService.getHalfHourPwrHisDcoutData(tableName,granularity,halfHourAgoTime); + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + LocalDateTime now = LocalDateTime.now(); + String dateTime = now.format(formatter); + Date endTime=ActionUtil.sdf.parse(dateTime); + // 璁$畻绗旀暟*鏃堕棿闂撮殧鐨勬椂闂寸偣 + LocalDateTime halfHourAgo = now.minusMinutes(interverCount); + // 鏍煎紡鍖栬緭鍑� + String halfHourAgoTime=halfHourAgo.format(formatter); + Date startTime=ActionUtil.sdf.parse(halfHourAgoTime); + //鑾峰彇涓や釜鏃堕棿鍒嗗壊澶氬皯寮犺〃 + List<List<Date>> monthTimeList = DateUtil.getMonthTime(startTime,endTime); + List<PwrHisRealDcoutInDto> dataList = new LinkedList<>(); + ThreadPoolExecutor pool = ThreadPoolExecutorFactory.getPoolExecutor(); + CountDownLatch latch = new CountDownLatch(monthTimeList.size()); + for (int i = 0; i < monthTimeList.size(); i++) { + int finalI = i; + Integer finalGranularity = granularity; + pool.execute(() -> { + int finalII = finalI; + Date recordDatetime=monthTimeList.get(finalII).get(0); + Date recordDatetime1=monthTimeList.get(finalII).get(1); + String table = powerId + "_" + ThreadLocalUtil.format(recordDatetime,2); + String tableName="db_data_history.tb_pwrdev_historydata_"+table; + //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦� + int tableNum = subTablePageInfoService.judgeTable_pwrhis(table); + List<PwrHisRealDcoutInDto> list = new ArrayList(); + if (tableNum > 0) { + //鑾峰彇鎸囧畾鏃堕棿娈靛唴鏈�澶ф渶灏弐ecordNum纭繚鏁版嵁鐨勫畬鏁� + List recordNums= subTablePageInfoService.getPwrMaxAndMinRecordNum(tableName,recordDatetime,recordDatetime1); + Integer maxRecordNum= 0; + Integer minRecordNum= 0; + if(recordNums.size()>0){ + maxRecordNum=(Integer)recordNums.get(0); + minRecordNum=(Integer)recordNums.get(1); + } + list=subTablePageInfoService.getHalfHourPwrHisDcoutData(tableName, finalGranularity,recordDatetime,recordDatetime1,maxRecordNum,minRecordNum); + } + dataList.addAll(list); + latch.countDown(); + }); + sleep(200); + } + latch.await(10, TimeUnit.MINUTES); + List dataListSorted = dataList.stream().sorted(Comparator.comparing(PwrHisRealDcoutInDto::getRecordDatetime)).collect(Collectors.toList()); Long modelCfg=0l; PowerInf pinf=powerInfService.getPowerInfById(powerId); if(pinf!=null){ modelCfg=pinf.getModelCfg(); } - return new Response().setIII(1,datalist.size()>0,datalist,modelCfg,"鑾峰彇鍗婂皬鏃跺唴鐩存祦杈撳嚭缁熻"); + return new Response().setIII(1,dataList.size()>0,dataListSorted,modelCfg,"鑾峰彇鍗婂皬鏃跺唴鐩存祦杈撳嚭缁熻"); + } + //1.2.7浼樿壇鐢垫簮缁熻涓婁竴瀛e害鐨勭數婧愭煇涓�灞炴�у拰鍙傛暟闃堝�艰秴杩囩殑娆℃暟 + public Integer getPwrQuarter7(Integer powerId,Integer powerType) throws NoSuchFieldException, IllegalAccessException { + Map<String,Integer> map=new HashMap<>(); + //鑾峰彇浼樿壇鐢垫簮鎬ц兘缁熻鍦ㄥ钩鍙颁笂鐨勬椂闂村弬鏁拌缃〃 + ApptimeParam apptimeParam=apptimeParamService.getPwrPerformanceStrartTime(powerId); + //鑾峰彇鎸囧畾鏃堕棿鍒板綋鍓嶆椂闂翠竴鍏卞灏戞湀鐨勯泦鍚� + List<String> datelist=ActionUtil.getDateListBetweenDates(apptimeParam.getParamValue(), new Date()); + //鑾峰彇鐢垫簮浼樿壇鍒ゆ柇鐨勬爣鍑嗗弬鏁板�� + List<PowerPropertyParam> paramList=propertyParamService.getPwrStandardParam(powerType); + List<String> propertyNameList = paramList.stream() + .map(param -> param.getPropertyName()) + .collect(Collectors.toList()); + for (int i=0;i<datelist.size();i++) { + String date=datelist.get(i); + String tableName ="db_data_history.tb_pwrdev_historydata_"+powerId+"_"+date; + String existTableName = commonMapper.existTable("db_data_history", "tb_pwrdev_historydata_"+powerId+"_"+date); + //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦� + if(existTableName == null){ + continue; + } + List<PwrdevHistorydataId> datalist=subTablePageInfoService.getPwrQuarter7(tableName,propertyNameList); + // 閬嶅巻 dataList 骞舵瘮杈冨睘鎬у�� + for (PwrdevHistorydataId data : datalist) { + for (int j=0;j<paramList.size();j++) { + PowerPropertyParam param = paramList.get(j); + String propertyName = ActionUtil.toCamelCase(param.getPropertyName()); + Field field = PwrdevHistorydataId.class.getDeclaredField(propertyName); + field.setAccessible(true); // 濡傛灉瀛楁鏄鏈夌殑锛岄渶瑕佽缃负鍙闂� + Float value = (Float) field.get(data); + if ((value > (param.getBasisVal()*param.getAlarmLimithUpper()))||(value <(param.getBasisVal()*param.getAlarmLimitlLower()))) { + int limitNum=map.get(param.getPropertyName())==null?0:map.get(param.getPropertyName()); + map.put(param.getPropertyName(), limitNum+1); + } + } + } + } + //鍒ゆ柇浼樿壇鐢垫簮鎬ц兘 + int pwrPerformence=judgePwrPerformence(map); + return pwrPerformence; + } + //鍒ゆ柇浼樿壇鐢垫簮鎬ц兘 + private Integer judgePwrPerformence(Map<String,Integer> map){ + //鑾峰彇apps涓紭鑹數婧愬垽鏂弬鏁� + List<AppParam> appParamList=appParamService.getPwrPerformenceParam(); + Float excellentVal=0f; + Float commonlyVal=0f; + Float warningVal=0f; + for (AppParam appParam : appParamList) { + if(appParam.getParamNamePsx().equals("power_excellent_val")){ + excellentVal=appParam.getParamValue(); + } + if(appParam.getParamNamePsx().equals("power_commonly_val")){ + commonlyVal=appParam.getParamValue(); + } + if(appParam.getParamNamePsx().equals("power_warning_val")){ + warningVal=appParam.getParamValue(); + } + } + Integer performance = PwrCapperformanceEnum.PWRSTATE_1.getStateId(); // 鍒濆鍖栦负鏈�浼樼瓑绾� + for (Map.Entry<String, Integer> entry : map.entrySet()) { + Integer level = evaluateValue(entry.getValue(), excellentVal, commonlyVal, warningVal); + // 鏍规嵁绛夌骇鎺掑簭纭畾褰撳墠鏄惁鏄渶宸瓑绾� + if (PwrCapperformanceEnum.PWRSTATE_4.getStateId()==level) { + performance = PwrCapperformanceEnum.PWRSTATE_4.getStateId(); + return performance; // 涓�鏃﹀嚭鐜板樊锛岀洿鎺ヨ繑鍥� + } else if (PwrCapperformanceEnum.PWRSTATE_3.getStateId()==level && PwrCapperformanceEnum.PWRSTATE_4.getStateId()!=performance) { + performance = PwrCapperformanceEnum.PWRSTATE_3.getStateId(); + } else if (PwrCapperformanceEnum.PWRSTATE_2.getStateId()==level &&(PwrCapperformanceEnum.PWRSTATE_3.getStateId()!=performance||PwrCapperformanceEnum.PWRSTATE_4.getStateId()!=performance)) { + performance = PwrCapperformanceEnum.PWRSTATE_2.getStateId(); + } + } + return performance; + } + // 鍒ゆ柇鍗曚釜鍊肩殑绛夌骇 + public Integer evaluateValue(Integer value, Float excellentVal, Float commonlyVal, Float warningVal) { + if (value <= excellentVal) { + return PwrCapperformanceEnum.PWRSTATE_1.getStateId(); + } else if (value <= commonlyVal&&value > excellentVal) { + return PwrCapperformanceEnum.PWRSTATE_2.getStateId(); + } else if (value <= warningVal&&value > commonlyVal) { + return PwrCapperformanceEnum.PWRSTATE_3.getStateId(); + } else { + return PwrCapperformanceEnum.PWRSTATE_4.getStateId(); + } } } \ No newline at end of file -- Gitblit v1.9.1