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
package cn.iocoder.yudao.module.mes.dal.mysql.collect;
 
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.collect.vo.MesCollectCyclePageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.collect.MesCollectCycleDO;
import org.apache.ibatis.annotations.Mapper;
 
/**
 * MES 数采-周期过程数据 Mapper
 *
 * @author 超级管理员
 */
@Mapper
public interface MesCollectCycleMapper extends BaseMapperX<MesCollectCycleDO> {
 
    default PageResult<MesCollectCycleDO> selectPage(MesCollectCyclePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesCollectCycleDO>()
                .eqIfPresent(MesCollectCycleDO::getDeviceCode, reqVO.getDeviceCode())
                .eqIfPresent(MesCollectCycleDO::getMachineryId, reqVO.getMachineryId())
                .eqIfPresent(MesCollectCycleDO::getTaskId, reqVO.getTaskId())
                .eqIfPresent(MesCollectCycleDO::getWorkOrderId, reqVO.getWorkOrderId())
                .betweenIfPresent(MesCollectCycleDO::getCollectTime, reqVO.getCollectTime())
                .orderByDesc(MesCollectCycleDO::getCollectTime));
    }
 
}