From 57fc660acff85425c2b4f8dfdb7801068188dcf3 Mon Sep 17 00:00:00 2001
From: guoyujie <guoyujie@ng.com>
Date: 星期四, 25 十二月 2025 11:45:52 +0800
Subject: [PATCH] 提交报工上传mysql做数量限制
---
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