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