package cn.iocoder.yudao.module.hrm.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.hrm.controller.admin.asset.vo.HrmAssetStocktakingPageReqVO;
|
import cn.iocoder.yudao.module.hrm.dal.dataobject.asset.HrmAssetStocktakingDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.time.LocalDate;
|
|
/**
|
* 资产盘点 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface HrmAssetStocktakingMapper extends BaseMapperX<HrmAssetStocktakingDO> {
|
|
default PageResult<HrmAssetStocktakingDO> selectPage(HrmAssetStocktakingPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<HrmAssetStocktakingDO>()
|
.eqIfPresent(HrmAssetStocktakingDO::getAssetId, reqVO.getAssetId())
|
.betweenIfPresent(HrmAssetStocktakingDO::getStocktakingDate, reqVO.getStocktakingDate())
|
.eqIfPresent(HrmAssetStocktakingDO::getResult, reqVO.getResult())
|
.orderByDesc(HrmAssetStocktakingDO::getStocktakingDate)
|
.orderByDesc(HrmAssetStocktakingDO::getId));
|
}
|
|
default Long selectCountByAssetId(Long assetId) {
|
return selectCount(HrmAssetStocktakingDO::getAssetId, assetId);
|
}
|
|
default HrmAssetStocktakingDO selectByAssetIdAndDate(Long assetId, LocalDate stocktakingDate) {
|
return selectOne(new LambdaQueryWrapperX<HrmAssetStocktakingDO>()
|
.eq(HrmAssetStocktakingDO::getAssetId, assetId)
|
.eq(HrmAssetStocktakingDO::getStocktakingDate, stocktakingDate));
|
}
|
|
}
|
