From fbaeeeff5704f210bc6347454c0f16d255001822 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 04 十一月 2026 16:32:09 +0800
Subject: [PATCH] refactor(srm): 重构供应商采购域,新增询价比价与保证金管理

---
 yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInvoiceMapper.java |   15 +++++++++++++++
 1 files changed, 15 insertions(+), 0 deletions(-)

diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInvoiceMapper.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInvoiceMapper.java
index 33bbae2..6cd508d 100644
--- a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInvoiceMapper.java
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInvoiceMapper.java
@@ -7,6 +7,7 @@
 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;
 
@@ -45,4 +46,18 @@
                 .in(ErpPurchaseInvoiceDO::getPurchaseOrderId, orderIds));
     }
 
+    /**
+     * 鎸変緵搴斿晢涓庡紑绁ㄦ椂闂磋寖鍥存煡璇㈡潵绁紙渚涘簲鍟嗗線鏉ワ級
+     */
+    default List<ErpPurchaseInvoiceDO> selectListBySupplierIdAndInvoiceTimeBetween(Long supplierId,
+                                                                                  LocalDateTime beginTime,
+                                                                                  LocalDateTime endTime) {
+        return selectList(new LambdaQueryWrapperX<ErpPurchaseInvoiceDO>()
+                .eq(ErpPurchaseInvoiceDO::getSupplierId, supplierId)
+                .geIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, beginTime)
+                .leIfPresent(ErpPurchaseInvoiceDO::getInvoiceTime, endTime)
+                .orderByAsc(ErpPurchaseInvoiceDO::getInvoiceTime)
+                .orderByAsc(ErpPurchaseInvoiceDO::getId));
+    }
+
 }

--
Gitblit v1.9.3