From dec8951aae400e54f6ee83a8f95867dba9da8af1 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期五, 23 五月 2025 17:17:33 +0800
Subject: [PATCH] [钣金计划大表] 优化：焊缝统计导出Excel样式
---
aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsGasPipingRouteStatMapper.java | 58 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 57 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..f1fcb23 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,64 @@
*/
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);
+
+ /**
+ * 鏌ヨ鎵�鏈夋墜宸ユ皵浣撳伐鍗曟暟鎹�
+ *
+ * @return 鎵�鏈夋墜宸ユ皵浣撳伐鍗曟暟鎹�
+ */
+ public List<Map<String, Object>> selectAllMoData();
+
+ /**
+ * 鏌ヨ鍩虹缁熻鏁版嵁锛堜笉鍖呭惈鏃堕棿闄愬埗锛�
+ *
+ * @param params 鏌ヨ鍙傛暟锛堜笉鍖呭惈鏃堕棿鑼冨洿鍙傛暟锛�
+ * @return 鍩虹缁熻鏁版嵁鍒楄〃
+ */
+ public List<Map<String, Object>> selectBaseStatData(Map<String, Object> params);
}
--
Gitblit v1.9.3