guoyujie
1 天以前 91b61fe723df498d62c596372521d426299f0f8b
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 previousProcess);
    List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process, String previousProcess, String laminating);
    List<Map<String,String>> SelectProcessMp();
@@ -41,4 +39,71 @@
    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();
}