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 { default PageResult selectPage(HrmAssetStocktakingPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .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() .eq(HrmAssetStocktakingDO::getAssetId, assetId) .eq(HrmAssetStocktakingDO::getStocktakingDate, stocktakingDate)); } }