From 8ecfe3aeb0aaad87cdad97e333d25a9e46f66469 Mon Sep 17 00:00:00 2001
From: goupan <goupan@chinapopin.com>
Date: 星期三, 10 四月 2024 16:26:26 +0800
Subject: [PATCH] 代码提交
---
common-buiness/src/main/java/cn/stylefeng/guns/modular/business/mapper/mapping/MentalTestTopicMapper.xml | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/common-buiness/src/main/java/cn/stylefeng/guns/modular/business/mapper/mapping/MentalTestTopicMapper.xml b/common-buiness/src/main/java/cn/stylefeng/guns/modular/business/mapper/mapping/MentalTestTopicMapper.xml
index 376e40c..4410d51 100644
--- a/common-buiness/src/main/java/cn/stylefeng/guns/modular/business/mapper/mapping/MentalTestTopicMapper.xml
+++ b/common-buiness/src/main/java/cn/stylefeng/guns/modular/business/mapper/mapping/MentalTestTopicMapper.xml
@@ -8,11 +8,10 @@
AND status_flag = 1
AND is_delete = 0
<if test="classIdList != null and classIdList.size != 0">
- AND ( 1 = 2
- <foreach collection="classIdList" item="item" index="index" separator=",">
- OR FIND_IN_SET( #{item}, class_id ) > 0
+ AND
+ <foreach collection="classIdList" item="item" index="index" open="(" separator=" OR " close=")">
+ FIND_IN_SET(#{item}, class_id) > 0
</foreach>
- )
</if>
<if test="title != null and title != ''">
AND o.title LIKE CONCAT('%', #{title}, '%')
--
Gitblit v1.7.1