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/sd/OrderProcessDetailMapper.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderProcessDetailMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderProcessDetailMapper.java
new file mode 100644
index 0000000..c33a6c5
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderProcessDetailMapper.java
@@ -0,0 +1,32 @@
+package com.example.erp.mapper.sd;
+
+import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.example.erp.entity.pp.ReportingWorkDetail;
+import com.example.erp.entity.sd.OrderProcessDetail;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.sql.Date;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+@DS("sd")
+public interface OrderProcessDetailMapper extends BaseMapper<OrderProcessDetail> {
+ boolean insertOrderProcessDetail(@Param("processDetailList") List<OrderProcessDetail> processDetailList);
+
+ void updateQuantity(String reportingWorkId,String process,String type);
+
+ List<Map<String,String>> filterOrderProcess(String orderId);
+
+ List<Map<String,Integer>> getGlassLRow(String orderId);
+
+ List<Map<String, String>> filterLastProcess(String orderId, String orderNumber, String technologyNumber,String id);
+
+ void insertByReportingWorkDetail(ReportingWorkDetail reportingWorkDetail, String processId, String thisProcess);
+
+ List<Map<String,String>> filterOrderProcessCollect(Date selectTime1, Date selectTime2);
+
+ List<Map<String, Integer>> getGlassLRowCollect(Date selectTime1, Date selectTime2);
+}
--
Gitblit v1.8.0