| | |
|---|
| | | 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; |
|---|
| | | |
|---|
| | |
|---|
| | | @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)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
