李林
2023-10-07 658d4927d468c47208fd012d9128b09249c07eff
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
/*
 *    Copyright (c) 2018-2025, ztt All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice,
 * this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the following disclaimer in the
 * documentation and/or other materials provided with the distribution.
 * Neither the name of the pig4cloud.com developer nor the names of its
 * contributors may be used to endorse or promote products derived from
 * this software without specific prior written permission.
 * Author: ztt
 */
 
package com.chinaztt.mes.plan.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.chinaztt.mes.plan.dto.ManufacturingOrderSnGenerateDTO;
import com.chinaztt.mes.plan.entity.ManufacturingOrderSnGenerate;
import com.chinaztt.mes.technology.entity.Operation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
/**
 * 生产SN号生成
 *
 * @author shz
 * @date 2022-08-16 18:21:39
 */
@Mapper
public interface ManufacturingOrderSnGenerateMapper extends BaseMapper<ManufacturingOrderSnGenerate> {
 
    List<ManufacturingOrderSnGenerateDTO> selectListByProductSN(String join);
 
    List<ManufacturingOrderSnGenerateDTO> selectListByMoId(Long moId);
 
    List<String> getProductSnsByCustomerOrderNo(String customerOrderNo);
 
    List<String> getProductSnByCustomerNoAndPartName(@Param("customerOrderNo") String customerOrderNo,
                                                     @Param("partName") String partName);
 
    IPage<ManufacturingOrderSnGenerateDTO> getTaskDetailPage(Page page,
                                                             @Param("customerName") String customerName,
                                                             @Param("customerOrderNo") String customerOrderNo,
                                                             @Param("operationId") Long operationId);
 
    IPage<ManufacturingOrderSnGenerateDTO> getTaskDetailPageByWorkstation(Page page,
                                                                          @Param("mpsId") Long mpsId,
                                                                          @Param("operationIds") List<Long> operationIds,
                                                                          @Param("moId") Long moId,
                                                                          @Param("produceStatus") Boolean produceStatus);
 
    List<Operation> getOperationInfo(Long mpsId);
 
    ManufacturingOrderSnGenerateDTO getJoinDocBomRoutingIdByOperationTaskId(Long operationTaskId);
}