From ef5a518c3e2c1fe41aa60f56ca31ddafa0cb1561 Mon Sep 17 00:00:00 2001
From: guoyuji <guoyujie@ng.com>
Date: 星期四, 23 五月 2024 08:32:36 +0800
Subject: [PATCH] 添加产品汇总报表
---
north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java
new file mode 100644
index 0000000..344c925
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java
@@ -0,0 +1,42 @@
+package com.example.erp.mapper.pp;
+
+import com.example.erp.entity.sd.Product;
+import com.example.erp.entity.sd.OrderGlassDetail;
+import com.example.erp.entity.sd.OrderDetail;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.sql.Date;
+import java.util.List;
+
+@Mapper
+public interface WorkOrderMapper {
+ //宸ュ崟绠＄悊鏌ヨ鏈浆宸ュ崟鏁版嵁
+ List<OrderGlassDetail> selectWordOrder(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail);
+
+ //鏌ヨ宸茶浆宸ュ崟鏁版嵁
+ List<OrderGlassDetail> selectWordOrderNo(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail);
+
+ //鏌ヨ闇�瑕佽浆宸ュ崟鏄庣粏
+ List<OrderDetail> addWordOrder(String orderId, OrderDetail orderDetail);
+
+ //杞伐鍗�
+ Boolean addOrderWorkMp(String productIdVl,
+ @Param("orderId") String orderId,
+ @Param("productId") Integer productId,
+ @Param("productName") String productName,
+ String userName);
+ //鏌ヨ瀵瑰簲璁㈠崟鍙疯搴�
+ Integer selectOrderNumber(String productIdVl);
+
+ //鍒犻櫎宸ュ崟,灏嗗搴斾骇鍝佺敓浜ц鍗曞彿鏀逛负null
+ Boolean deleteOrderWorkMp(String orderId, String productionId);
+
+ Integer selectWorkCount(String orderId);
+
+ Boolean updateWorkType(String orderId, Integer state);
+
+ Integer selectYesWorkCount(String orderId);
+
+ Integer selectProcessCard(String orderId);
+}
--
Gitblit v1.8.0