廖井涛
2024-03-19 ecb3045fb71d05b7ee3bf73fdf413f5091d65f65
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
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.sd.OrderGlassDetail;
import org.apache.ibatis.annotations.Mapper;
 
import java.sql.Date;
import java.util.List;
import java.util.Map;
 
@Mapper
public interface ReportingWorkMapper extends BaseMapper<ReportingWork> {
 
 
    ReportingWork AddSelectLastWorkMp(String processIdStr, String technologyStr,String previousProcess,String nextProcess,String process);
 
    List<BasicDataProduce> SelectWorkBasicDeviceMp(String process);
 
    List<BasicDataProduce> SelectWorkBasicTeamsMp(String process);
 
    String SelectTechnologicalProcess(String processIdStr);
 
    String SelectWorkTechnologyMp(String processIdStr);
 
    List<Map<String,String>> SelectTechnologicalNumMp(String processIdStr, String technologyStr,String process);
 
    List<Map<String,String>> SelectReworlDetailMp(String processIdStr, String technologyStr, String process);
 
    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);
}