代码提交

goupan

2024-04-10 8ecfe3aeb0aaad87cdad97e333d25a9e46f66469

代码提交

 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}, '%')