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/ApsPlatePlanMapper.java | 35 ++++++++++++++++++++++++++++++++++-
1 files changed, 34 insertions(+), 1 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java
index c52a435..731c0e3 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java
@@ -1,6 +1,7 @@
package com.aps.core.mapper;
-import com.aps.core.domain.ApsPlatePlan;
+import com.alibaba.fastjson2.JSONObject;
+import com.aps.core.domain.ApsPlate.ApsPlatePlan;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@@ -72,4 +73,36 @@
* @return
*/
public List<ApsPlatePlan> selectPlateRedundantOrderList(ApsPlatePlan apsPlatePlan);
+
+ List<ApsPlatePlan> selectPlatePlanByPlantMajor(String plant);
+
+ /**
+ * 鑾峰彇涓�鏉℃湭鍖归厤鐨勫瓙璁″垝
+ * */
+ ApsPlatePlan selectUnMatchPlateSubPlan(String plant,String itemNumber);
+
+ /**
+ * 鏇存柊瀛愯鍒掓湭鍖归厤鏁伴噺
+ * */
+ int updatePlanUnMatchQtyByVersion(ApsPlatePlan plan);
+
+ /**
+ * 鍒濆鍖� 瀛愪欢宸ュ崟鐨� 鏈尮閰嶆暟閲�
+ * */
+ int initUnMatchQty();
+ /**
+ * 鑾峰彇鏈尮閰嶇殑瀛愯鍒�
+ * */
+ List<ApsPlatePlan> selectUnMatchPlateSubPlanList(String plant,String itemNumber);
+
+ /**
+ * 鏇存柊瀛愪欢宸ュ崟鏈尮閰嶆暟閲忓拰鐗堟湰
+ * */
+ int updatePlanUnMatchQtyAndVersion(ApsPlatePlan plan);
+
+ /**
+ * 鏌ヨ閽ｉ噾瀛愬崟鏁版嵁
+ * @return
+ */
+ List<JSONObject> selectApsSubPlatePlan();
}
--
Gitblit v1.9.3