From d5bb894f9be2e0a3b62d475b60b44f2ab138528c Mon Sep 17 00:00:00 2001 From: guoyujie <guoyujie@ng.com> Date: 星期四, 12 六月 2025 16:48:35 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override --- north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java | 77 ++++++++++++++++++++++++++++++++++---- 1 files changed, 68 insertions(+), 9 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 index 05224c5..45f14aa 100644 --- 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 @@ -1,32 +1,30 @@ 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.pp.ReportingWorkDetail; +import com.github.yulichang.base.MPJBaseMapper; import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Param; -import java.time.LocalDate; +import java.sql.Date; import java.util.List; import java.util.Map; @Mapper -public interface ReportingWorkMapper extends BaseMapper<ReportingWork> { +public interface ReportingWorkMapper extends MPJBaseMapper<ReportingWork> { - ReportingWork AddSelectLastWorkMp(String processIdStr, String technologyStr,String previousProcess,String nextProcess,String process); + 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 SelectTechnologicalProcess(String processIdStr, String technologyStr); String SelectWorkTechnologyMp(String processIdStr); - List<Map<String,String>> SelectTechnologicalNumMp(String processIdStr, String technologyStr,String process); + List<Map<String,String>> SelectTechnologicalNumMp(String processIdStr, String technologyStr, String process, String reportType); - List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process); + List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process, String previousProcess, String laminating); List<Map<String,String>> SelectProcessMp(); @@ -47,4 +45,65 @@ 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); + + String selectLayerByReportingWorkId(String reportingWorkId); + + Boolean ReviewReportingWorkMp(String substring, String process, String result, String userName); + + String getPatchConditionMp(String reportingWorkId); + + Integer getFirstStep(String processId, String orderSort, Integer technologyNumber, String interceptProcess); + + Boolean updateReplenishWorkProcess(String processId, String orderSort, Integer technologyNumber, Integer patchNum, String patchProcesses); + + Boolean updateRWPatchNum(String reportingWorkId, Integer patchNum); + + Boolean updateRWDPatchNum(String reportingWorkId, String orderSort, Integer technologyNumber, Integer patchNum); + + String selectUserProcess(String userId); + + List<Map<String,String>> getSelectProcessJiajiao(); + + List<Map<String,String>> getSelectProcessDuoqu(); + + List<Map<String, String>> SelectReworlDetailMpReview(String processIdStr, String technologyStr, String process, String previousProcess, String laminating); + + String getProcessLaminating(String process); + + String selectOrderid(String processIdStr); + + Map<String,Float> getFootSum(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, String orderId, ReportingWork reportingWork); + + Integer selectReviewedState(String reportingWorkId); + + List<ReportingWork> qualityReviewSearchMp(); } -- Gitblit v1.8.0