From 9f46f8471a3521c03461e04a6e82cff023e9bfdb Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 19 六月 2025 18:38:21 +0800
Subject: [PATCH] 判断优良电源性能
---
src/main/java/com/whyc/service/PwrdevHistorydataIdService.java | 159 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 156 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java b/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java
index 5f78d5f..896a094 100644
--- a/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java
+++ b/src/main/java/com/whyc/service/PwrdevHistorydataIdService.java
@@ -1,18 +1,32 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.whyc.constant.PwrCapperformanceEnum;
+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.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_station.PowerInf;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.lang.reflect.Field;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
import java.util.Date;
+import java.util.HashMap;
import java.util.List;
+import java.util.Map;
@Service
public class PwrdevHistorydataIdService {
@@ -21,27 +35,166 @@
@Resource
private CommonMapper commonMapper;
+ @Autowired
+ private PowerInfService powerInfService;
+
+ @Autowired
+ private AppParamService appParamService;
+
+ @Autowired
+ private ApptimeParamService apptimeParamService;
+
+ @Autowired
+ private PowerPropertyParamService propertyParamService;
+
//绯荤粺姒傝鑾峰彇鍗婂皬鏃朵氦娴佽緭鍏ョ粺璁�
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);
+ List<PwrHisRealAcInDto> datalist=subTablePageInfoService.getHalfHourPwrHisAcinData(tableName,granularity,halfHourAgoTime);
return new Response().setII(1,datalist.size()>0,datalist,"鑾峰彇鍗婂皬鏃跺唴浜ゆ祦杈撳叆缁熻");
}
//绯荤粺姒傝鑾峰彇鍗婂皬鏃剁洿娴佽緭鍑虹粺璁�
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,"褰撳墠鐢垫簮涓嶅瓨鍦ㄥ墠闈㈠皬鏃舵暟鎹�");
}
- List<PwrHisRealDcoutInDto> datalist=subTablePageInfoService.getHalfHourPwrHisDcoutData(tableName,granularity);
- return new Response().setII(1,datalist.size()>0,datalist,"鑾峰彇鍗婂皬鏃跺唴鐩存祦杈撳嚭缁熻");
+ List<PwrHisRealDcoutInDto> datalist=subTablePageInfoService.getHalfHourPwrHisDcoutData(tableName,granularity,halfHourAgoTime);
+ Long modelCfg=0l;
+ PowerInf pinf=powerInfService.getPowerInfById(powerId);
+ if(pinf!=null){
+ modelCfg=pinf.getModelCfg();
+ }
+ return new Response().setIII(1,datalist.size()>0,datalist,modelCfg,"鑾峰彇鍗婂皬鏃跺唴鐩存祦杈撳嚭缁熻");
+ }
+ //1.2.7浼樿壇鐢垫簮缁熻涓婁竴瀛ｅ害鐨勭數婧愭煇涓�灞炴�у拰鍙傛暟闃堝�艰秴杩囩殑娆℃暟
+ 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);
+ /*Map<String,Float> paramValues=new HashMap<>();
+ for (PowerPropertyParam param : paramList) {
+ paramValues.put(param.getPropertyName()+"_upper", param.getBasisVal()*param.getAlarmLimithUpper());
+ paramValues.put(param.getPropertyName()+"_lower", param.getBasisVal()*param.getAlarmLimitlLower());
+ map.put(param.getPropertyName(), 0);
+ }*/
+ 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<QuarterPwr7Res> datalist=subTablePageInfoService.getPwrQuarter7(tableName);
+ // 閬嶅巻 dataList 骞舵瘮杈冨睘鎬у��
+ for (QuarterPwr7Res data : datalist) {
+ /*if(paramValues.get("acin1_vola_upper")!=null){
+ if ((data.getAcin1Vola() > paramValues.get("acin1_vola_upper"))||(data.getAcin1Vola() < paramValues.get("acin1_vola_lower"))) {
+ map.put("acin1_vola", map.get("acin1_vola") + 1);
+ }
+ }
+ if(paramValues.get("acout_curra_upper")!=null) {
+ if ((data.getAcoutCurra() > paramValues.get("acout_curra_upper")) || (data.getAcoutCurra() < paramValues.get("acout_curra_lower"))) {
+ map.put("acout_curra", map.get("acout_curra") + 1);
+ }
+ }
+ if(paramValues.get("dcout_vol_upper")!=null) {
+ if ((data.getDcoutVol() > paramValues.get("dcout_vol_upper")) || (data.getDcoutVol() < paramValues.get("dcout_vo_lower"))) {
+ map.put("dcout_vol", map.get("dcout_vol") + 1);
+ }
+ }
+ if(paramValues.get("dcout_curr_upper")!=null) {
+ if ((data.getDcoutCurr() > paramValues.get("dcout_curr_upper")) || (data.getDcoutCurr() < paramValues.get("dcout_curr_lower"))) {
+ map.put("dcout_curr", map.get("dcout_curr") + 1);
+ }
+ }*/
+ for (int j=0;j<paramList.size();j++) {
+ PowerPropertyParam param = paramList.get(j);
+ String propertyName = ActionUtil.toCamelCase(param.getPropertyName());
+ Field field = QuarterPwr7Res.class.getDeclaredField(propertyName);
+ field.setAccessible(true); // 濡傛灉瀛楁鏄鏈夌殑锛岄渶瑕佽缃负鍙闂�
+ Float value = (Float) field.get(data);
+ if ((value > (param.getBasisVal()*param.getAlarmLimithUpper()))||(value <(param.getBasisVal()*param.getAlarmLimitlLower()))) {
+ map.put(param.getPropertyName(), map.get(param.getPropertyName())==null?0:map.get(param.getPropertyName())+ 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