From cba0aa733b2324144b1b8f2835ba585dae42b630 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期日, 08 九月 2024 16:28:25 +0800
Subject: [PATCH] add:结算管理-增加结算人筛选条件

---
 src/main/resources/mapper/payment/OrderSettlementMapper.xml                   |    4 +++-
 src/main/java/com/mzl/flower/dto/request/payment/OrderSettlementQueryDTO.java |    3 +++
 2 files changed, 6 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/mzl/flower/dto/request/payment/OrderSettlementQueryDTO.java b/src/main/java/com/mzl/flower/dto/request/payment/OrderSettlementQueryDTO.java
index 726c83a..49f0dd0 100644
--- a/src/main/java/com/mzl/flower/dto/request/payment/OrderSettlementQueryDTO.java
+++ b/src/main/java/com/mzl/flower/dto/request/payment/OrderSettlementQueryDTO.java
@@ -29,4 +29,7 @@
     @ApiModelProperty(hidden = true)
     private String userId;
 
+    @ApiModelProperty(value = "结算对象名称")
+    private String userName;
+
 }
diff --git a/src/main/resources/mapper/payment/OrderSettlementMapper.xml b/src/main/resources/mapper/payment/OrderSettlementMapper.xml
index a318b4b..5a75e50 100644
--- a/src/main/resources/mapper/payment/OrderSettlementMapper.xml
+++ b/src/main/resources/mapper/payment/OrderSettlementMapper.xml
@@ -23,7 +23,9 @@
         <if test="condition.endDate != null">
             AND s.create_time &lt;= #{condition.endDate}
         </if>
-
+        <if test="condition.userName != null and condition.userName != ''">
+            AND (si.name LIKE CONCAT('%', #{condition.userName}, '%') OR pi.name LIKE CONCAT('%', #{condition.userName}, '%'))
+        </if>
         ORDER BY s.create_time desc
     </select>
 

--
Gitblit v1.9.3