From 4408f77aac1a6f382758c142e9cf59e9685a1daa Mon Sep 17 00:00:00 2001
From: chenlu <1320612696@qq.com>
Date: 星期五, 19 十二月 2025 08:40:44 +0800
Subject: [PATCH] 修改在制品报表终止数量不显示问题，添加报工后续工序减去对应终止数量
---
north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderGlassDetailMapper.java | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderGlassDetailMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderGlassDetailMapper.java
index 3f9542c..bc4d69b 100644
--- a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderGlassDetailMapper.java
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderGlassDetailMapper.java
@@ -7,10 +7,14 @@
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
@Mapper
public interface OrderGlassDetailMapper extends BaseMapper<OrderGlassDetail> {
- boolean insertOrderGlassDetail(@Param("orderId") String orderId);
+ boolean insertOrderGlassDetail(@Param("orderId") String orderId,
+ @Param("outside") String outside,
+ @Param("inside") String inside
+ );
List<OrderGlassDetail> selectOrderGlassDetail(@Param("orderId") String orderId);
@@ -19,4 +23,15 @@
void updateSizeAndProcess(@Param("orderGlassDetails")List<OrderGlassDetail> orderGlassDetails);
Integer getDifferentSizeNumber(String orderId, Integer orderNumber);
+
+ List<Map<String,Object>> getOrderGlassDetailByProductId(String orderId, String glassChild,Long productId);
+
+ List<OrderGlassDetail> getOrderGlassDetailByProductIdGlassChild(String orderId, Integer orderNumber);
+
+ Integer getMinIdByGroup(String orderId, String orderNumber, String group);
+ Integer getMaxIdByGroup(String orderId, String orderNumber, String group);
+
+ Integer getMinTechnologyNumberByGroup(String orderId, String orderNumber, String group);
+
+ Integer getMaxTechnologyNumberByGroup(String orderId, String orderNumber, String group);
}
--
Gitblit v1.8.0