package cn.iocoder.yudao.module.srm.dal.mysql;
|
|
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.srm.controller.admin.bond.vo.SrmBidBondPageReqVO;
|
import cn.iocoder.yudao.module.srm.dal.dataobject.SrmBidBondDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
@Mapper
|
public interface SrmBidBondMapper extends BaseMapperX<SrmBidBondDO> {
|
|
default PageResult<SrmBidBondDO> selectPage(SrmBidBondPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<SrmBidBondDO>()
|
.likeIfPresent(SrmBidBondDO::getNo, reqVO.getNo())
|
.eqIfPresent(SrmBidBondDO::getSupplierId, reqVO.getSupplierId())
|
.likeIfPresent(SrmBidBondDO::getProjectName, reqVO.getProjectName())
|
.eqIfPresent(SrmBidBondDO::getWon, reqVO.getWon())
|
.eqIfPresent(SrmBidBondDO::getRefundStatus, reqVO.getRefundStatus())
|
.geIfPresent(SrmBidBondDO::getPayDate, reqVO.getPayDateStart())
|
.leIfPresent(SrmBidBondDO::getPayDate, reqVO.getPayDateEnd())
|
.orderByDesc(SrmBidBondDO::getId));
|
}
|
|
default SrmBidBondDO selectByNo(String no) {
|
return selectOne(SrmBidBondDO::getNo, no);
|
}
|
|
default long selectCountBySupplierId(Long supplierId) {
|
return selectCount(SrmBidBondDO::getSupplierId, supplierId);
|
}
|
|
}
|
