package cn.iocoder.yudao.module.mes.dal.mysql.wm.transaction;
|
|
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.wm.transaction.vo.MesWmTransactionPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.transaction.MesWmTransactionDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* MES 库存事务流水 Mapper
|
*/
|
@Mapper
|
public interface MesWmTransactionMapper extends BaseMapperX<MesWmTransactionDO> {
|
|
default PageResult<MesWmTransactionDO> selectPage(MesWmTransactionPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesWmTransactionDO>()
|
.eqIfPresent(MesWmTransactionDO::getItemId, reqVO.getItemId())
|
.likeIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCode())
|
.eqIfPresent(MesWmTransactionDO::getWarehouseId, reqVO.getWarehouseId())
|
.eqIfPresent(MesWmTransactionDO::getLocationId, reqVO.getLocationId())
|
.eqIfPresent(MesWmTransactionDO::getAreaId, reqVO.getAreaId())
|
.eqIfPresent(MesWmTransactionDO::getType, reqVO.getType())
|
.eqIfPresent(MesWmTransactionDO::getBizType, reqVO.getBizType())
|
.likeIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCode())
|
.eqIfPresent(MesWmTransactionDO::getMaterialStockId, reqVO.getMaterialStockId())
|
.geIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getStartTime())
|
.leIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getEndTime())
|
.orderByDesc(MesWmTransactionDO::getTransactionTime));
|
}
|
|
}
|
