package cn.iocoder.yudao.module.erp.dal.mysql.purchase; 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.erp.controller.admin.purchase.vo.invoice.ErpPurchaseInvoicePageReqVO; import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseInvoiceDO; import org.apache.ibatis.annotations.Mapper; import java.time.LocalDateTime; import java.util.Collection; import java.util.List; /** * ERP 采购来票 Mapper * * @author 超级管理员 */ @Mapper public interface ErpPurchaseInvoiceMapper extends BaseMapperX { default ErpPurchaseInvoiceDO selectByNo(String no) { return selectOne(ErpPurchaseInvoiceDO::getNo, no); } default PageResult selectPage(ErpPurchaseInvoicePageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(ErpPurchaseInvoiceDO::getNo, reqVO.getNo()) .eqIfPresent(ErpPurchaseInvoiceDO::getSupplierId, reqVO.getSupplierId()) .eqIfPresent(ErpPurchaseInvoiceDO::getPurchaseOrderId, reqVO.getPurchaseOrderId()) .orderByDesc(ErpPurchaseInvoiceDO::getId)); } default List selectListByOrderId(Long orderId) { return selectList(new LambdaQueryWrapperX() .eq(ErpPurchaseInvoiceDO::getPurchaseOrderId, orderId)); } default List selectListBySupplierId(Long supplierId) { return selectList(new LambdaQueryWrapperX() .eq(ErpPurchaseInvoiceDO::getSupplierId, supplierId)); } default List selectListByOrderIds(Collection orderIds) { return selectList(new LambdaQueryWrapperX() .in(ErpPurchaseInvoiceDO::getPurchaseOrderId, orderIds)); } default List selectListByItemReceiptId(Long itemReceiptId) { return selectList(new LambdaQueryWrapperX() .eq(ErpPurchaseInvoiceDO::getItemReceiptId, itemReceiptId)); } /** * 按供应商与开票时间范围查询来票(供应商往来) */ default List selectListBySupplierIdAndInvoiceTimeBetween(Long supplierId, LocalDateTime beginTime, LocalDateTime endTime) { return selectList(new LambdaQueryWrapperX() .eq(ErpPurchaseInvoiceDO::getSupplierId, supplierId) .geIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, beginTime) .leIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, endTime) .orderByAsc(ErpPurchaseInvoiceDO::getInvoiceTime) .orderByAsc(ErpPurchaseInvoiceDO::getId)); } /** * 按开票时间范围查询全部供应商的来票(供应商往来汇总) */ default List selectListByInvoiceTimeBetween(LocalDateTime beginTime, LocalDateTime endTime) { return selectList(new LambdaQueryWrapperX() .geIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, beginTime) .leIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, endTime)); } }