From cce74d57aa0a4757e0238cc9dd322562eb2b03cd Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期四, 24 四月 2025 13:42:11 +0800
Subject: [PATCH] 电网拓扑下拉列表

---
 ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java |  103 ++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 88 insertions(+), 15 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 15e77c9..fd6e9a2 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
@@ -158,10 +158,9 @@
 
     @GetMapping("/net-factor-dropdown/list")
     @Operation(summary = "功率因数-电网拓扑下拉列表")
-    public CommonResult<List<PowerNetFactorDropdownDTO>> getPowerNetFactorDropdownList(@RequestParam String nodeName) {
-        List<PowerNetFactorEntity> list = powerNetFactorService.listDropdown(nodeName);
-        List<PowerNetFactorDropdownDTO> result = ConvertUtils.sourceToTarget(list, PowerNetFactorDropdownDTO.class);
-        return success(result);
+    public CommonResult<List<PowerNetFactorDropdownDTO>> getPowerNetFactorDropdownList(@RequestParam String nodeCode) {
+        List<PowerNetFactorEntity> list = powerNetFactorService.listDropdown(nodeCode);
+        return success(ConvertUtils.sourceToTarget(list, PowerNetFactorDropdownDTO.class));
     }
 
     /**
@@ -366,15 +365,16 @@
     @PostMapping("/net-factor/history")
     @Operation(summary = "功率因数-根据nodeName获取最近1440min历史数据,月最大,最小值")
     public CommonResult<PowerHistoryDTO> getPowerHistoryData(@RequestBody PowerNetFactorHisReqDTO dto) {
-        String nodeName = dto.getNodeName();
-        if (StringUtils.isBlank(nodeName)) {
+        log.info("PowerNetFactorHisReqDTO=" + JSONObject.toJSONString(dto));
+        String nodeCode = dto.getNodeCode();
+        if (StringUtils.isBlank(nodeCode)) {
             return CommonResult.error(GlobalErrorCodeConstants.BAD_REQUEST);
         }
         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");
@@ -432,10 +432,7 @@
         List<ApiPointValueDTO> monthChartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO);
         List<Double> monthValues = new ArrayList<>();
         if (CollectionUtils.isEmpty(monthChartData)) {
-            monthValues =  monthChartData.stream().map(item -> {
-                return item.getV();
-            }).collect(Collectors.toList());
-
+            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());
         }
@@ -463,23 +460,99 @@
     }
 
     @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);
         Map<String, Double> result = new HashMap<>();
         if (CollectionUtils.isEmpty(list)) {
+            log.info("PowerAdjustedFactor List is empty");
             return success(result);
         }
         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