From c4d2818a546bcc15f0324b8682fa7d21abef5ccc Mon Sep 17 00:00:00 2001
From: huliguo <2023611923@qq.com>
Date: 星期二, 29 七月 2025 13:07:01 +0800
Subject: [PATCH] bug修改

---
 ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml |   11 ++++-------
 1 files changed, 4 insertions(+), 7 deletions(-)

diff --git a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
index 956a8d4..1246efe 100644
--- a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
+++ b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
@@ -1218,9 +1218,6 @@
                 #{item}
             </foreach>
         </if>
-        <if test="param.">
-            and order_from = #{param.}
-        </if>
         <if test="param.startDate!=null and param.startDate!=''">
             AND Date(create_time) &gt;= #{param.startDate}
         </if>
@@ -2246,16 +2243,16 @@
             AND (toc.order_no LIKE CONCAT('%',#{param.keyword},'%') OR toc.activity_name LIKE CONCAT('%',#{param.keyword},'%') OR FIND_IN_SET(toc.user_id, #{param.userIds}) &gt; 0)
         </if>
         <if test="param.createTimeBegin != null and param.createTimeBegin != ''">
-            AND Date(toc.create_time) &gt;= #{param.createTimeBegin}
+            AND toc.create_time &gt;= #{param.createTimeBegin}
         </if>
         <if test="param.createTimeEnd != null and param.createTimeEnd != ''">
-            AND Date(toc.create_time) &lt;= #{param.createTimeEnd}
+            AND toc.create_time &lt;= #{param.createTimeEnd}
         </if>
         <if test="param.useTimeBegin != null and param.useTimeBegin != ''">
-            AND Date(toc.use_time) &gt;= #{param.useTimeBegin}
+            AND toc.use_time &gt;= #{param.useTimeBegin}
         </if>
         <if test="param.useTimeEnd != null and param.useTimeEnd != ''">
-            AND Date(toc.use_time) &lt;= #{param.useTimeEnd}
+            AND toc.use_time &lt;= #{param.useTimeEnd}
         </if>
         ORDER BY toc.create_time DESC
     </select>

--
Gitblit v1.7.1