package cn.iocoder.yudao.module.mes.dal.mysql.trace.consumer;
|
|
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.trace.consumer.vo.MesTraceLocationVisitPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.trace.consumer.MesTraceLocationVisitDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
@Mapper
|
public interface MesTraceLocationVisitMapper extends BaseMapperX<MesTraceLocationVisitDO> {
|
default List<MesTraceLocationVisitDO> selectListByFilter(MesTraceLocationVisitPageReqVO reqVO) {
|
return selectList(new LambdaQueryWrapperX<MesTraceLocationVisitDO>()
|
.likeIfPresent(MesTraceLocationVisitDO::getTraceCode, reqVO.getTraceCode())
|
.geIfPresent(MesTraceLocationVisitDO::getVisitTime, reqVO.getStartTime())
|
.ltIfPresent(MesTraceLocationVisitDO::getVisitTime, reqVO.getEndTime()));
|
}
|
|
default PageResult<MesTraceLocationVisitDO> selectPage(MesTraceLocationVisitPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesTraceLocationVisitDO>()
|
.likeIfPresent(MesTraceLocationVisitDO::getTraceCode, reqVO.getTraceCode())
|
.geIfPresent(MesTraceLocationVisitDO::getVisitTime, reqVO.getStartTime())
|
.ltIfPresent(MesTraceLocationVisitDO::getVisitTime, reqVO.getEndTime())
|
.orderByDesc(MesTraceLocationVisitDO::getVisitTime));
|
}
|
}
|