From 25cc1b887f5421353d94c5e6be0fca56b3f2e668 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期三, 21 五月 2025 16:29:24 +0800
Subject: [PATCH] 优化Job
---
aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlatePlanMapper.java | 47 +++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 45 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 501ce3d..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鎺ュ彛
@@ -62,4 +64,45 @@
public int deleteApsPlatePlanByIds(String[] ids);
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