From 3f55daa7a9a9af552e3f665f21933d84421b4d98 Mon Sep 17 00:00:00 2001
From: luodangjia <luodangjia>
Date: 星期二, 10 十二月 2024 16:00:13 +0800
Subject: [PATCH] 11.6
---
ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
index 8ddb578..450257e 100644
--- a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
+++ b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
@@ -526,6 +526,12 @@
<if test="data.endTime != null and data.endTime != ''">
AND STR_TO_DATE(SUBSTRING_INDEX(time, ' - ', -1), '%Y-%m-%d %H:%i') <![CDATA[ <= ]]> #{data.endTime}
</if>
+ <if test="data.completeTimeStart != null and data.completeTimeStart != ''">
+ and DATE(o.complete_time) <![CDATA[ >= ]]> #{data.completeTimeStart}
+ </if>
+ <if test="data.completeTimeEnd != null and data.completeTimeEnd != ''">
+ and DATE(o.complete_time) <![CDATA[ <= ]]> #{data.completeTimeEnd}
+ </if>
</where>
order by o.createTime desc
</select>
--
Gitblit v1.7.1