From 60d295c68e038b9e107e29630466045310a56daa Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 22 四月 2026 18:18:33 +0800
Subject: [PATCH] fix: 付款登记筛选有误
---
src/main/java/com/ruoyi/sales/dto/SalesLedgerProductDto.java | 2 ++
src/main/resources/mapper/sales/SalesLedgerProductMapper.xml | 3 +++
2 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/dto/SalesLedgerProductDto.java b/src/main/java/com/ruoyi/sales/dto/SalesLedgerProductDto.java
index 3831d47..d11a603 100644
--- a/src/main/java/com/ruoyi/sales/dto/SalesLedgerProductDto.java
+++ b/src/main/java/com/ruoyi/sales/dto/SalesLedgerProductDto.java
@@ -70,4 +70,6 @@
@ApiModelProperty("閿�鍞骇鍝侀澶栧姞宸�")
private List<SalesLedgerProductProcess> salesProductProcessList;
+ private String supplierNameOrContractNo;
+
}
diff --git a/src/main/resources/mapper/sales/SalesLedgerProductMapper.xml b/src/main/resources/mapper/sales/SalesLedgerProductMapper.xml
index e7791c9..e0abaa7 100644
--- a/src/main/resources/mapper/sales/SalesLedgerProductMapper.xml
+++ b/src/main/resources/mapper/sales/SalesLedgerProductMapper.xml
@@ -101,6 +101,9 @@
<if test="req.status != null and req.status ">
AND slp.pending_tickets_total > 0
</if>
+ <if test="req.supplierNameOrContractNo != null and req.supplierNameOrContractNo != ''">
+ AND (sl.supplier_name like concat('%',#{req.supplierNameOrContractNo},'%') or sl.purchase_contract_number like concat('%',#{req.supplierNameOrContractNo},'%'))
+ </if>
</where>
order by slp.register_date desc
</select>
--
Gitblit v1.9.3