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 |    2 +-
 ansteel-biz/db/mysql.sql                                                                      |    3 ++-
 doc/鞍钢数据接口文档_master.doc                                                                       |    0 
 3 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql
index 6c7e340..6107218 100644
--- a/ansteel-biz/db/mysql.sql
+++ b/ansteel-biz/db/mysql.sql
@@ -632,13 +632,14 @@
     `max_demand`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '月最大需量',
     `cur_demand`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '实测需量',
     `active_power` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '有功功率',
-    `sort`         varchar(50)                                                  DEFAULT NULL COMMENT '排序',
+    `sort`         int NULL DEFAULT NULL COMMENT '排序'                                                 DEFAULT NULL COMMENT '排序',
     PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='月最大需量,实测需量,有功功率';
 
 ALTER TABLE `t_power_demand`
     ADD COLUMN `code`  varchar(50) NULL DEFAULT NULL COMMENT '编号';
 
+CREATE UNIQUE INDEX  `idx_code` ON t_power_demand(`code`);
 
 -- ----------------------------
 -- 负荷移植-调整后的功率因数与无功倒送量
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 562b70b..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
@@ -486,7 +486,7 @@
         return success(result);
     }
 
-    @GetMapping("/demand/history")
+    @PostMapping("/demand/history")
     @Operation(summary = "负荷移植-实测需量,有功功率 历史")
     public CommonResult<PowerHistoryDTO> getPowerDemandHistory(@RequestBody PowerDemandHisReqDTO dto) {
         log.info("请求参数: {}", JSONObject.toJSONString(dto));
diff --git "a/doc/\351\236\215\351\222\242\346\225\260\346\215\256\346\216\245\345\217\243\346\226\207\346\241\243_master.doc" "b/doc/\351\236\215\351\222\242\346\225\260\346\215\256\346\216\245\345\217\243\346\226\207\346\241\243_master.doc"
index 2c89eeb..77765cf 100644
--- "a/doc/\351\236\215\351\222\242\346\225\260\346\215\256\346\216\245\345\217\243\346\226\207\346\241\243_master.doc"
+++ "b/doc/\351\236\215\351\222\242\346\225\260\346\215\256\346\216\245\345\217\243\346\226\207\346\241\243_master.doc"
Binary files differ

--
Gitblit v1.9.3