首页搜索bug修复

yangys

2025-08-23 070d6aca3fd91ae7eb297c36c62a4320f43043a1

首页搜索bug修复

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/NcNodeMapper.xml

@@ -120,18 +120,20 @@
            <if test="status != null and status != ''">
               and
                (
                1=1
                <if test='status.contains("1")'>
                1=2
                <if test='status.contains("1".toString())'>
                   or n.parent_ids LIKE '0,1,%'
                </if>
                <if test='status.contains("2")'>
                <if test='status.contains("2".toString())'>
                    or n.parent_ids LIKE '0,2,%'
                </if>
                <if test='status.contains("3")'>
                <if test='status.contains("3".toString())'>
                    or n.parent_ids LIKE '0,3,%'
                </if>

                )
            </if>

            <if test="createTimeBegin != null">
                and n.create_time&gt;=#{createTimeBegin}
            </if>

 blade-service/blade-mdm/src/main/resources/logback.xml

@@ -56,8 +56,26 @@
        <appender-ref ref="MDM_FILE" />
        <appender-ref ref="CONSOLE" />
    </logger>
    <!-- 关键配置：MyBatis 核心SQL日志 -->
    <logger name="org.apache.ibatis" level="TRACE">
        <appender-ref ref="CONSOLE" />
    </logger>

    <!-- JDBC 连接相关日志 -->
    <logger name="java.sql.Connection" level="DEBUG">
        <appender-ref ref="CONSOLE" />
    </logger>
    <logger name="java.sql.Statement" level="DEBUG">
        <appender-ref ref="CONSOLE" />
    </logger>
    <logger name="java.sql.PreparedStatement" level="DEBUG">
        <appender-ref ref="CONSOLE" />
    </logger>
    <logger name="java.sql.ResultSet" level="TRACE">
        <appender-ref ref="CONSOLE" />
    </logger>
    <!-- 配置 MyBatis Mapper 包日志 -->
    <logger name="com.yourcompany.yourproject.mapper" level="DEBUG" additivity="false">
    <logger name="org.springblade.mdm.*.mapper" level="DEBUG" additivity="false">
        <appender-ref ref="FILE"/> <!-- MyBatis 日志输出到文件 -->
        <appender-ref ref="MDM_FILE"/>
        <!-- 如果也希望在控制台看到，可以加上 <appender-ref ref="CONSOLE"/> -->