package cn.iocoder.yudao.module.asset.dal.mysql.requisition;
|
|
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.asset.controller.admin.requisition.vo.AssetRequisitionPageReqVO;
|
import cn.iocoder.yudao.module.asset.dal.dataobject.requisition.AssetRequisitionDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
@Mapper
|
public interface AssetRequisitionMapper extends BaseMapperX<AssetRequisitionDO> {
|
|
default PageResult<AssetRequisitionDO> selectPage(AssetRequisitionPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<AssetRequisitionDO>()
|
.likeIfPresent(AssetRequisitionDO::getNo, reqVO.getNo())
|
.likeIfPresent(AssetRequisitionDO::getAssetName, reqVO.getAssetName())
|
.likeIfPresent(AssetRequisitionDO::getRecipientName, reqVO.getRecipientName())
|
.eqIfPresent(AssetRequisitionDO::getCategory, reqVO.getCategory())
|
.eqIfPresent(AssetRequisitionDO::getReturnStatus, reqVO.getReturnStatus())
|
.orderByDesc(AssetRequisitionDO::getId));
|
}
|
|
default Long selectCountByAssetIdAndNotReturned(Long assetId) {
|
return selectCount(new LambdaQueryWrapperX<AssetRequisitionDO>()
|
.eq(AssetRequisitionDO::getAssetId, assetId)
|
.ne(AssetRequisitionDO::getReturnStatus, 3));
|
}
|
|
}
|
