From e317f9a2aed027551fae194c4ee55573ecdcccc8 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期一, 11 三月 2024 14:42:30 +0800
Subject: [PATCH] 订单搜索Bug修复

---
 ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml |    2 +-
 1 files changed, 1 insertions(+), 1 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 97c5723..f6656e0 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
@@ -542,7 +542,7 @@
             AND toc.shop_id = #{param.shopId} AND (toc.unbinding_flag = 0 OR (toc.unbinding_flag = 1 AND toc.order_from = 1) OR (toc.unbinding_flag = 1 AND toc.order_from = 2 AND toc.order_status = 3))
         </if>
         <if test="param.shopIds != null and param.shopIds != ''">
-            AND FIND_IN_SET(toc.shop_id, #{param.shopIds}) &gt; 0
+            AND FIND_IN_SET(toc.shop_id, #{param.shopIds})
         </if>
         <if test="param.keyword != null and param.keyword != ''">
             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)

--
Gitblit v1.7.1