feat: 完善质检、生产、销售、财务与人事模块并接入审批流程

gaoluyang

昨天 8c65f898ed6e5b0c7a94c792c4562f6ec831dccd

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
package cn.iocoder.yudao.module.mes.dal.mysql.pro.worktime;
 
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.mes.controller.admin.pro.worktime.vo.MesProWorktimeAuxPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.pro.worktime.MesProWorktimeAuxDO;
import org.apache.ibatis.annotations.Mapper;
 
import java.util.List;
 
/**
 * MES 辅助工时配置 Mapper
 *
 * @author 超级管理员
 */
@Mapper
public interface MesProWorktimeAuxMapper extends BaseMapperX<MesProWorktimeAuxDO> {
 
    default PageResult<MesProWorktimeAuxDO> selectPage(MesProWorktimeAuxPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesProWorktimeAuxDO>()
                .eqIfPresent(MesProWorktimeAuxDO::getProcessId, reqVO.getProcessId())
                .eqIfPresent(MesProWorktimeAuxDO::getWorkstationId, reqVO.getWorkstationId())
                .likeIfPresent(MesProWorktimeAuxDO::getItemName, reqVO.getItemName())
                .eqIfPresent(MesProWorktimeAuxDO::getStatus, reqVO.getStatus())
                .orderByAsc(MesProWorktimeAuxDO::getSort)
                .orderByAsc(MesProWorktimeAuxDO::getId));
    }
 
    default List<MesProWorktimeAuxDO> selectListByProcessId(Long processId) {
        return selectList(new LambdaQueryWrapperX<MesProWorktimeAuxDO>()
                .eq(MesProWorktimeAuxDO::getProcessId, processId)
                .orderByAsc(MesProWorktimeAuxDO::getSort)
                .orderByAsc(MesProWorktimeAuxDO::getId));
    }
 
    default MesProWorktimeAuxDO selectOneByProcessIdAndWorkstationIdAndCode(Long processId, Long workstationId, String itemCode) {
        return selectOne(new LambdaQueryWrapperX<MesProWorktimeAuxDO>()
                .eq(MesProWorktimeAuxDO::getProcessId, processId)
                .eq(MesProWorktimeAuxDO::getItemCode, itemCode)
                .and(w -> {
                    if (workstationId == null) {
                        w.isNull(MesProWorktimeAuxDO::getWorkstationId);
                    } else {
                        w.eq(MesProWorktimeAuxDO::getWorkstationId, workstationId);
                    }
                })
                .last("LIMIT 1"));
    }
 
    default List<MesProWorktimeAuxDO> selectListByProcessIdAndWorkstationId(Long processId, Long workstationId) {
        return selectList(new LambdaQueryWrapperX<MesProWorktimeAuxDO>()
                .eq(MesProWorktimeAuxDO::getProcessId, processId)
                .and(w -> {
                    if (workstationId != null) {
                        w.isNull(MesProWorktimeAuxDO::getWorkstationId)
                                .or(x -> x.eq(MesProWorktimeAuxDO::getWorkstationId, workstationId));
                    } else {
                        w.isNull(MesProWorktimeAuxDO::getWorkstationId);
                    }
                })
                .orderByAsc(MesProWorktimeAuxDO::getSort)
                .orderByAsc(MesProWorktimeAuxDO::getId));
    }
 
}