From d2e9373d08edad3ebccbcf1831c2e809a693ae6a Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期三, 27 十一月 2024 13:49:31 +0800
Subject: [PATCH] 565-订单列表:增加用户账号搜索框
---
src/main/java/com/mzl/flower/dto/request/payment/OrderQueryDTO.java | 3 +++
src/main/resources/mapper/payment/OrderMapper.xml | 3 +++
2 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/request/payment/OrderQueryDTO.java b/src/main/java/com/mzl/flower/dto/request/payment/OrderQueryDTO.java
index 4086af8..a9d3af8 100644
--- a/src/main/java/com/mzl/flower/dto/request/payment/OrderQueryDTO.java
+++ b/src/main/java/com/mzl/flower/dto/request/payment/OrderQueryDTO.java
@@ -79,4 +79,7 @@
@ApiModelProperty(value = "库位")
private String warehouseLocationCode;
+
+ @ApiModelProperty(value = "用户账号")
+ private String createName;
}
diff --git a/src/main/resources/mapper/payment/OrderMapper.xml b/src/main/resources/mapper/payment/OrderMapper.xml
index cd4419f..ebaac79 100644
--- a/src/main/resources/mapper/payment/OrderMapper.xml
+++ b/src/main/resources/mapper/payment/OrderMapper.xml
@@ -162,6 +162,9 @@
<if test="condition.warehouseLocationCode != null and condition.warehouseLocationCode != ''">
AND q.warehouse_location_code LIKE concat('%', #{condition.warehouseLocationCode},'%')
</if>
+ <if test="condition.createName != null and condition.createName != ''">
+ AND u.nick_name LIKE concat('%', #{condition.createName},'%')
+ </if>
ORDER BY q.create_time desc, q.payment_time desc
</select>
--
Gitblit v1.9.3