refactor(mes): 优化MES生产扫码入库功能支持多类型扫码

云

2 天以前 1ba0dbfde5634c8bf2ec20891d6b226b996f6b59

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
79
80
81
82
package cn.iocoder.yudao.module.mes.dal.mysql.wm.materialstockbag;
 
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockBagPageReqVO;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.materialstockbag.MesWmMaterialStockBagDO;
import org.apache.ibatis.annotations.Mapper;
 
import java.util.Collection;
import java.util.List;
 
@Mapper
public interface MesWmMaterialStockBagMapper extends BaseMapperX<MesWmMaterialStockBagDO> {
 
    default PageResult<MesWmMaterialStockBagDO> selectPage(MesWmMaterialStockBagPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getMaterialStockId, reqVO.getMaterialStockId())
                .likeIfPresent(MesWmMaterialStockBagDO::getBagCode, reqVO.getBagCode())
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
    }
 
    default MesWmMaterialStockBagDO selectByBagCode(String bagCode) {
        return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getBagCode, bagCode)
                .orderByDesc(MesWmMaterialStockBagDO::getId)
                .last("LIMIT 1"));
    }
 
    default MesWmMaterialStockBagDO selectByBagCodeId(Long bagCodeId) {
        return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getBagCodeId, bagCodeId)
                .orderByDesc(MesWmMaterialStockBagDO::getId)
                .last("LIMIT 1"));
    }
 
    default MesWmMaterialStockBagDO selectOneActiveByMaterialStockId(Long materialStockId) {
        return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getMaterialStockId, materialStockId)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .last("LIMIT 1"));
    }
 
    default MesWmMaterialStockBagDO selectActiveByBagCode(String bagCode) {
        return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getBagCode, bagCode)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .last("LIMIT 1"));
    }
 
    default MesWmMaterialStockBagDO selectActiveByBagCodeId(Long bagCodeId) {
        return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getBagCodeId, bagCodeId)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .last("LIMIT 1"));
    }
 
    default List<MesWmMaterialStockBagDO> selectActiveListByItemAndBatch(Long itemId, Long batchId, Integer stockState) {
        return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getItemId, itemId)
                .eqIfPresent(MesWmMaterialStockBagDO::getBatchId, batchId)
                .eqIfPresent(MesWmMaterialStockBagDO::getStockState, stockState)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .eq(MesWmMaterialStockBagDO::getFrozen, false)
                .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
    }
 
    default List<MesWmMaterialStockBagDO> selectListByMaterialStockIds(Collection<Long> materialStockIds) {
        return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .in(MesWmMaterialStockBagDO::getMaterialStockId, materialStockIds)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
    }
 
    default List<MesWmMaterialStockBagDO> selectListByMaterialStockId(Long materialStockId) {
        return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
                .eq(MesWmMaterialStockBagDO::getMaterialStockId, materialStockId)
                .eq(MesWmMaterialStockBagDO::getStatus, 1)
                .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
    }
}