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/ReportingWorkMapper.java |   78 +++++++++++++++++++++++++++++++++++++++
 1 files changed, 78 insertions(+), 0 deletions(-)

diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java
new file mode 100644
index 0000000..783f769
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java
@@ -0,0 +1,78 @@
+package com.example.erp.mapper.pp;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.example.erp.entity.pp.BasicDataProduce;
+import com.example.erp.entity.pp.ReportingWork;
+import com.example.erp.entity.sd.OrderGlassDetail;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.sql.Date;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface ReportingWorkMapper extends BaseMapper<ReportingWork> {
+
+
+    ReportingWork AddSelectLastWorkMp(String processIdStr, String technologyStr,String previousProcess,String nextProcess,String process);
+
+    List<BasicDataProduce> SelectWorkBasicDeviceMp(String process);
+
+    List<BasicDataProduce> SelectWorkBasicTeamsMp(String process);
+
+    String SelectTechnologicalProcess(String processIdStr);
+
+    String SelectWorkTechnologyMp(String processIdStr);
+
+    List<Map<String,String>> SelectTechnologicalNumMp(String processIdStr, String technologyStr,String process);
+
+    List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process);
+
+    List<Map<String,String>> SelectProcessMp();
+
+    String historyProcessMp(String processIdStr);
+
+    List<Map<String,String>> historyDeviceMp(String historyProcess, String process);
+
+    List<Map<String,String>> historyTeamsMp(String processIdStr, String process);
+
+    List<Map<String,String>> SelectHistoryProcessMp(String historyProcess, String process);
+
+    List<Map<String,BasicDataProduce>>  selectBasicNameByType(String type);
+
+    Integer selectMaxReportingWorkId();
+
+    int selectGlassProcessNum(String orderNumber, String technologyNumber, String processId, String thisProcess);
+
+    int selectFlowCardNum(String orderNumber, String technologyNumber, String processId, String thisProcess);
+
+    List<Map<String,Object>> selectByReportingWorkId(String reportingWorkId,String nextProcess);
+    Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, String orderId, ReportingWork reportingWork);
+
+    String selectNextProcess(String reportingWorkId);
+
+    Integer selectCountByProcessId(String processId, String nextProcess);
+
+    List<Map<String, Object>> reportingWorkDate(String reportingWorkId);
+
+    Boolean updateWorkProcess(String processId, Object orderNumber, Object technologyNumber, Object completedQuantity, Object breakageQuantity, String thisProcess);
+
+    Boolean deleteWork(String reportingWorkId);
+
+    String selectLastProcess(String processId);
+
+    Map<String, Object> selectReceiptQuantity(String processId);
+
+    Integer selectCompletedQuantity(String reportingWorkId);
+
+    Boolean updateInventoryQuantity(String processId, Object orderNumber, Object technologyNumber, Object completedQuantity);
+
+    List<ReportingWork> selectReportingWorkMp(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, String orderId, ReportingWork reportingWork);
+
+    List<ReportingWork> selectQualityTestingMp(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, Integer state, String processId, ReportingWork reportingWork);
+
+    Map<String, Integer> getQualityPageTotal(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, Integer state, String processId, ReportingWork reportingWork);
+
+    Boolean updateQualityStatusMp(String reportingWorkId,String username);
+
+    List<Map<String,String>> detailsQualityMp(String reportingWorkId, ReportingWork reportingWork);
+}

--
Gitblit v1.8.0