| | |
| | | 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 previousProcess); |
| | | List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process, String previousProcess, String laminating); |
| | | |
| | | List<Map<String,String>> SelectProcessMp(); |
| | | |
| | |
| | | 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); |
| | | |
| | | 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(); |
| | | } |