From 070d6aca3fd91ae7eb297c36c62a4320f43043a1 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期六, 23 八月 2025 12:11:27 +0800
Subject: [PATCH] 首页搜索bug修复
---
blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/NcNodeMapper.xml | 10 ++++++----
blade-service/blade-mdm/src/main/resources/logback.xml | 20 +++++++++++++++++++-
2 files changed, 25 insertions(+), 5 deletions(-)
diff --git a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/NcNodeMapper.xml b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/NcNodeMapper.xml
index f9e2d29..bb74899 100644
--- a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/NcNodeMapper.xml
+++ b/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>=#{createTimeBegin}
</if>
diff --git a/blade-service/blade-mdm/src/main/resources/logback.xml b/blade-service/blade-mdm/src/main/resources/logback.xml
index 9d5749c..0d455ea 100644
--- a/blade-service/blade-mdm/src/main/resources/logback.xml
+++ b/blade-service/blade-mdm/src/main/resources/logback.xml
@@ -56,8 +56,26 @@
<appender-ref ref="MDM_FILE" />
<appender-ref ref="CONSOLE" />
</logger>
+ <!-- 鍏抽敭閰嶇疆锛歁yBatis 鏍稿績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"/> -->
--
Gitblit v1.9.3