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, String laminating);
|
|
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);
|
|
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();
|
}
|