package cn.iocoder.yudao.module.finance.dal.mysql.asset;
|
|
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.finance.controller.admin.asset.vo.FinFixedAssetPageReqVO;
|
import cn.iocoder.yudao.module.finance.dal.dataobject.asset.FinFixedAssetDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.Collection;
|
import java.util.List;
|
|
/**
|
* 固定资产 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface FinFixedAssetMapper extends BaseMapperX<FinFixedAssetDO> {
|
|
default PageResult<FinFixedAssetDO> selectPage(FinFixedAssetPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<FinFixedAssetDO>()
|
.likeIfPresent(FinFixedAssetDO::getAssetCode, reqVO.getAssetCode())
|
.likeIfPresent(FinFixedAssetDO::getAssetName, reqVO.getAssetName())
|
.eqIfPresent(FinFixedAssetDO::getCategory, reqVO.getCategory())
|
.eqIfPresent(FinFixedAssetDO::getDepartmentId, reqVO.getDepartmentId())
|
.eqIfPresent(FinFixedAssetDO::getKeeperId, reqVO.getKeeperId())
|
.eqIfPresent(FinFixedAssetDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(FinFixedAssetDO::getPurchaseDate, reqVO.getPurchaseDate())
|
.orderByDesc(FinFixedAssetDO::getId));
|
}
|
|
default FinFixedAssetDO selectByAssetCode(String assetCode) {
|
return selectOne(FinFixedAssetDO::getAssetCode, assetCode);
|
}
|
|
default List<FinFixedAssetDO> selectListByIds(Collection<Long> ids) {
|
return selectList(new LambdaQueryWrapperX<FinFixedAssetDO>()
|
.in(FinFixedAssetDO::getId, ids));
|
}
|
|
}
|
