From 90bcff462e9a040dfded38fd9c145eaee9908311 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期四, 24 四月 2025 10:48:52 +0800
Subject: [PATCH] 负荷移植-实测需量有功功率历史
---
ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java | 147 +++++++++++++++++++++++++++++++++---------------
1 files changed, 100 insertions(+), 47 deletions(-)
diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
index 46d43ad..7af6dd3 100644
--- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
+++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
@@ -27,6 +27,7 @@
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
+import java.util.stream.Collectors;
import static com.iailab.framework.common.pojo.CommonResult.success;
@@ -364,20 +365,23 @@
@PostMapping("/net-factor/history")
@Operation(summary = "功率因数-根据nodeName获取最近1440min历史数据，月最大，最小值")
- public CommonResult<PowerHistoryDTO> getPowerHistoryData(@RequestBody Map<String, Object> params) {
- String nodeName = (String) params.get("nodeName");
- if (StringUtils.isBlank(nodeName)) {
+ public CommonResult<PowerHistoryDTO> getPowerHistoryData(@RequestBody PowerNetFactorHisReqDTO dto) {
+ log.info("PowerNetFactorHisReqDTO=" + JSONObject.toJSONString(dto));
+ String nodeCode = dto.getNodeCode();
+ if (StringUtils.isBlank(nodeCode)) {
return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST);
}
- String queryType = (String) params.get("queryType");
+ String queryType = dto.getQueryType();
if (StringUtils.isBlank(queryType)) {
return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST);
}
- PowerNetFactorEntity powerNetFactor = powerNetFactorService.getByNodeName(nodeName);
+ PowerNetFactorEntity powerNetFactor = powerNetFactorService.getByNodeCode(nodeCode);
PowerHistoryDTO result = new PowerHistoryDTO();
if (powerNetFactor == null) {
+ log.info("powerNetFactor is null");
return success(result);
}
+ log.info("开始查询，");
ApiPointValueQueryDTO apiPointValueQueryDTO = new ApiPointValueQueryDTO();
String pointNo = "";
@@ -395,41 +399,21 @@
break;
}
//查询图表
- String startTimeStr =(String) params.get("startTime");
- String endTimeStr =(String) params.get("endTime");
apiPointValueQueryDTO.setPointNo(pointNo);
Calendar calendar0 = Calendar.getInstance();
calendar0.set(Calendar.MILLISECOND, 0);
calendar0.set(Calendar.SECOND, 0);
- Date end = calendar0.getTime();
+ Date end = dto.getEndTime() == null ? calendar0.getTime() : dto.getEndTime();
calendar0.add(Calendar.MINUTE, -1440);
- Date start = calendar0.getTime();
-
- SimpleDateFormat ft = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- if (StringUtils.isNotBlank(startTimeStr)) {
- try {
- start = ft.parse(params.get("startTime").toString());
- } catch (ParseException e) {
- throw new RuntimeException(e);
- }
- }
- apiPointValueQueryDTO.setStart(start);
- if (StringUtils.isNotBlank(endTimeStr)) {
- try {
- end = ft.parse(params.get("endTime").toString());
- } catch (ParseException e) {
- throw new RuntimeException(e);
- }
- }
+ Date start = dto.getStartTime() == null ? calendar0.getTime() : dto.getStartTime();
apiPointValueQueryDTO.setEnd(end);
+ apiPointValueQueryDTO.setStart(start);
List<ApiPointValueDTO> chartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO);
- List<List<Object>> dataList = new ArrayList<>();
- for (ApiPointValueDTO dto : chartData) {
- List<Object> data = new ArrayList<>();
- String time = ft.format(dto.getT());
- double value = dto.getV();
- data.add(time);
- data.add(value);
+ List<Object[]> dataList = new ArrayList<>();
+ for (ApiPointValueDTO pv : chartData) {
+ Object[] data = new Object[2];
+ data[0] = DateUtils.format(pv.getT(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND);
+ data[1] = pv.getV();
dataList.add(data);
}
List<String> categories = DateUtils.getTimeScale(start, end, 60);
@@ -447,17 +431,12 @@
apiPointValueQueryDTO.setStart(start);
apiPointValueQueryDTO.setEnd(new Date());
List<ApiPointValueDTO> monthChartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO);
- List<List<Object>> monthDataList = new ArrayList<>();
- for (ApiPointValueDTO dto : monthChartData) {
- List<Object> data = new ArrayList<>();
- String time = ft.format(dto.getT());
- double value = dto.getV();
- data.add(time);
- data.add(value);
- monthDataList.add(data);
+ List<Double> monthValues = new ArrayList<>();
+ if (CollectionUtils.isEmpty(monthChartData)) {
+ monthValues = monthChartData.stream().map(item -> item.getV()).collect(Collectors.toList());
+ result.setMax(monthValues.stream().max(Double::compareTo).get());
+ result.setMin(monthValues.stream().min(Double::compareTo).get());
}
- result.setMax(getMax(monthDataList));
- result.setMin(getMin(monthDataList));
return success(result);
}
@@ -482,7 +461,7 @@
}
@GetMapping("/adjust-factor")
- @Operation(summary = "负荷移植-调整后的功率因数与无功倒送量")
+ @Operation(summary = "功率因数-调整后的功率因数与无功倒送量")
public CommonResult<Map<String, Double>> getPowerAdjustFactor(@RequestParam Map<String, Object> params) {
List<PowerAdjustedFactorEntity> list = powerAdjustedFactorService.list(params);
List<PowerAdjustedFactorDTO> dtoList = ConvertUtils.sourceToTarget(list, PowerAdjustedFactorDTO.class);
@@ -493,12 +472,86 @@
List<String> points = new ArrayList<>();
Map<String, Object> dataMap = new HashMap<>();
for (PowerAdjustedFactorDTO dto : dtoList) {
- points.add(dto.getPointNo());
+ if (StringUtils.isNotBlank(dto.getPointNo())) {
+ points.add(dto.getPointNo());
+ }
}
- dataMap = dataPointApi.queryPointsRealValue(points);
+ if (!CollectionUtils.isEmpty(points)) {
+ dataMap = dataPointApi.queryPointsRealValue(points);
+ }
for (PowerAdjustedFactorDTO powerAdjustedFactorDTO : dtoList) {
- result.put(powerAdjustedFactorDTO.getName(), Double.parseDouble(dataMap.get(powerAdjustedFactorDTO.getPointNo()).toString()));
+ Double value = dataMap.get(powerAdjustedFactorDTO.getPointNo()) == null ? 0 : Double.parseDouble(dataMap.get(powerAdjustedFactorDTO.getPointNo()).toString());
+ result.put(powerAdjustedFactorDTO.getName(), value);
}
return success(result);
}
+
+ @PostMapping("/demand/history")
+ @Operation(summary = "负荷移植-实测需量，有功功率 历史")
+ public CommonResult<PowerHistoryDTO> getPowerDemandHistory(@RequestBody PowerDemandHisReqDTO dto) {
+ log.info("请求参数: {}", JSONObject.toJSONString(dto));
+
+ // 参数校验
+ if (StringUtils.isBlank(dto.getCode())) {
+ return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST, "code不能为空");
+ }
+ if (StringUtils.isBlank(dto.getQueryType())) {
+ return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST, "queryType不能为空");
+ }
+
+ PowerDemandEntity powerDemand = powerDemandService.getByCode(dto.getCode());
+ if (powerDemand == null) {
+ log.info("未找到code对应的数据: {}", dto.getCode());
+ return success(new PowerHistoryDTO());
+ }
+
+ String queryType = dto.getQueryType().toUpperCase();
+ String pointNo;
+ switch (queryType.toUpperCase()) {
+ case "D":
+ pointNo = powerDemand.getCurDemand();
+ break;
+ case "P":
+ pointNo = powerDemand.getActivePower();
+ break;
+ default:
+ throw new IllegalArgumentException("不支持的queryType: " + queryType);
+ }
+
+ // 默认查最近24小时
+ Date end = Optional.ofNullable(dto.getEndTime()).orElseGet(() -> {
+ Calendar cal = Calendar.getInstance();
+ cal.set(Calendar.MILLISECOND, 0);
+ cal.set(Calendar.SECOND, 0);
+ return cal.getTime();
+ });
+
+ Date start = Optional.ofNullable(dto.getStartTime()).orElseGet(() -> {
+ Calendar cal = Calendar.getInstance();
+ cal.setTime(end);
+ cal.add(Calendar.MINUTE, -1440); // 24小时前
+ return cal.getTime();
+ });
+
+ // 查询历史数据
+ ApiPointValueQueryDTO query = new ApiPointValueQueryDTO();
+ query.setPointNo(pointNo);
+ query.setStart(start);
+ query.setEnd(end);
+
+ log.info("开始查询实测需量/有功功率历史数据，测点: {}", pointNo);
+ List<ApiPointValueDTO> chartData = dataPointApi.queryPointHistoryValue(query);
+
+ // 构建返回结果
+ PowerHistoryDTO result = new PowerHistoryDTO();
+ result.setCategories(DateUtils.getTimeScale(start, end, 60));
+ result.setDataList(chartData.stream()
+ .map(pv -> new Object[]{
+ DateUtils.format(pv.getT(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND),
+ pv.getV()
+ })
+ .collect(Collectors.toList()));
+
+ return success(result);
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3