From bc0fdd1f0c20ca4737e8f073050f37b27a658694 Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期四, 22 五月 2025 16:31:12 +0800
Subject: [PATCH] 管路&气柜产能负载优化，实现动态row聚合统计
---
aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java | 43 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 42 insertions(+), 1 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java
index 992ecaf..d2a255c 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java
@@ -1,8 +1,10 @@
package com.aps.core.mapper;
import com.aps.core.domain.ApsGasPipingRouteStat;
+import org.apache.ibatis.annotations.Mapper;
import java.util.List;
+import java.util.Map;
/**
* 姘斾綋绠¤矾浜ц兘璐熻浇缁熻Mapper鎺ュ彛
@@ -10,6 +12,7 @@
* @author hjy
* @date 2025-04-24
*/
+@Mapper
public interface ApsGasPipingRouteStatMapper
{
/**
@@ -67,11 +70,49 @@
*/
public int deleteApsGasPipingRouteStatByBatchNum(String batchNumber);
-
/**
* 鎵归噺鎻掑叆绠¤矾姘旀煖浜ц兘鏁版嵁
* @param apsGasPipingRouteStatList
* @return
*/
public int insertApsGasPipingRouteStatBatch(List<ApsGasPipingRouteStat> apsGasPipingRouteStatList);
+
+ List<ApsGasPipingRouteStat> queryTempStat();
+
+ /**
+ * 鍒犻櫎鎵�鏈夋皵浣撶璺骇鑳借礋杞界粺璁℃暟鎹�
+ *
+ * @return 缁撴灉
+ */
+ public int deleteAll();
+
+ /**
+ * 鑱斿悎鏌ヨ鎵嬪伐姘斾綋棰勬祴鏁版嵁鐩稿叧淇℃伅
+ *
+ * @return 鎵嬪伐姘斾綋棰勬祴鏁版嵁鍙婂叧鑱斾俊鎭�
+ */
+ public List<Map<String, Object>> selectPredictionRouteData();
+
+ /**
+ * 鑱斿悎鏌ヨ鎵嬪伐姘斾綋宸ュ崟鏁版嵁鐩稿叧淇℃伅
+ *
+ * @return 鎵嬪伐姘斾綋宸ュ崟鏁版嵁鍙婂叧鑱斾俊鎭�
+ */
+ public List<Map<String, Object>> selectMoRouteData();
+
+ /**
+ * 鏍规嵁鏃堕棿缁村害鑱氬悎鏌ヨ缁熻鏁版嵁
+ *
+ * @param params 鏌ヨ鍙傛暟锛屽寘鍚椂闂磋寖鍥村拰杩囨护鏉′欢
+ * @return 鎸夊伐搴忓悕绉板拰鏃堕棿缁村害鑱氬悎鐨勬暟鎹�
+ */
+ public List<Map<String, Object>> selectAggregatedStatData(Map<String, Object> params);
+
+ /**
+ * 鏌ヨ鍘熷缁熻鏁版嵁锛堜笉杩涜鑱氬悎锛�
+ *
+ * @param params 鏌ヨ鍙傛暟
+ * @return 鍘熷缁熻鏁版嵁鍒楄〃
+ */
+ public List<Map<String, Object>> selectRawStatData(Map<String, Object> params);
}
--
Gitblit v1.9.3