From 8b2c74fb6842e8af60f70e7df6eef8837d74be07 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期四, 05 九月 2024 11:44:17 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/ERP_override

---
 north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java |   83 +++++++++++++++++++++++++++++++++++++++++
 1 files changed, 83 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..cb91a78
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java
@@ -0,0 +1,83 @@
+package com.example.erp.mapper.pp;
+import com.example.erp.entity.pp.BasicDataProduce;
+import com.example.erp.entity.pp.ReportingWork;
+import com.github.yulichang.base.MPJBaseMapper;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.sql.Date;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface ReportingWorkMapper extends MPJBaseMapper<ReportingWork> {
+
+
+    ReportingWork AddSelectLastWorkMp(String processIdStr, String technologyStr, String previousProcess, String nextProcess, String process, String reportType);
+
+    List<BasicDataProduce> SelectWorkBasicDeviceMp(String process);
+
+    List<BasicDataProduce> SelectWorkBasicTeamsMp(String process);
+
+    String SelectTechnologicalProcess(String processIdStr, String technologyStr);
+
+    String SelectWorkTechnologyMp(String processIdStr);
+
+    List<Map<String,String>> SelectTechnologicalNumMp(String processIdStr, String technologyStr, String process, String reportType);
+
+    List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process, String previousProcess);
+
+    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);
+
+    Integer selectLayerByReportingWorkId(String reportingWorkId);
+
+    Boolean ReviewReportingWorkMp(String substring, String process, String result, String userName);
+
+    String getPatchConditionMp(String reportingWorkId);
+}

--
Gitblit v1.8.0