From 32cafd54c82586c749734505359d25f696ee158f Mon Sep 17 00:00:00 2001 From: chenlu <1320612696@qq.com> Date: 星期四, 14 三月 2024 16:55:29 +0800 Subject: [PATCH] 报工查询删除 --- north-glass-erp/src/main/java/com/example/erp/mapper/pp/ReportingWorkMapper.java | 26 +++++++++++++++++++++++--- 1 files changed, 23 insertions(+), 3 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 89418ed..0f20e75 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 @@ -2,11 +2,9 @@ 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 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; @@ -45,4 +43,26 @@ int selectGlassProcessNum(String orderNumber, String technologyNumber, String processId, String thisProcess); int selectFlowCardNum(String orderNumber, String technologyNumber, String processId, String thisProcess); + + List<ReportingWork> selectReportingWorkMp(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, String orderId, ReportingWork reportingWork); + + 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); } -- Gitblit v1.8.0