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 | 45 +++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 43 insertions(+), 2 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 a79024b..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,8 +1,10 @@
package com.aps.core.mapper;
-import java.util.List;
-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;
/**
* 閽ｉ噾璁″垝绠＄悊Mapper鎺ュ彛
@@ -64,4 +66,43 @@
public int insertPlatePlanFromTempByBatchNumber(String batchNumber);
int removeAllPlatePlans();
+
+ /**
+ * 閽ｉ噾鍐椾綑宸ュ崟鎶ヨ〃
+ * @param apsPlatePlan
+ * @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