From 8fbd14764be455c53d3722e4d174e87fadf41a51 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期四, 04 九月 2025 09:28:06 +0800
Subject: [PATCH] SQL处理
---
ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java | 22 +++-------------------
1 files changed, 3 insertions(+), 19 deletions(-)
diff --git a/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java b/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java
index a80f3bd..a1aa7d4 100644
--- a/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java
+++ b/ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java
@@ -71,25 +71,7 @@
* @return 淇敼鍚庣殑 SQL
*/
private String modifySqlWithOrgId(String originalSql, String orgid) {
- if (originalSql.contains("insert into")
- || originalSql.contains("INSERT INTO")
- || originalSql.contains("from sys_menu")
- || originalSql.contains("sys_job")
- || originalSql.contains("update sys_menu")
- || originalSql.contains("information_schema.tables")
- || originalSql.contains("information_schema.columns")
- || originalSql.contains("gen_table")
- || originalSql.toUpperCase().contains("ORGID IS NULL")
- || originalSql.toUpperCase().contains("FROM CRYXX")
- || originalSql.toUpperCase().contains("FROM MZXX")
- || originalSql.toUpperCase().contains("FROM JBXX")
- || originalSql.toUpperCase().contains("FROM BMXX")
- || originalSql.toUpperCase().contains("FROM HZJBXX")
- || originalSql.toUpperCase().contains("RENAME TABLE")
- || originalSql.toUpperCase().contains("FROM YHYKSXX")
- || originalSql.toUpperCase().contains("FROM YHYJSXX")
- || originalSql.toUpperCase().contains("ALTER TABLE")
- || originalSql.toUpperCase().contains("CREATE TABLE")) {
+ if (originalSql.contains("insert into") || originalSql.contains("INSERT INTO") || originalSql.contains("from sys_menu") || originalSql.contains("sys_job") || originalSql.contains("update sys_menu") || originalSql.contains("information_schema.tables") || originalSql.contains("information_schema.columns") || originalSql.contains("gen_table") || originalSql.toUpperCase().contains("ORGID IS NULL") || originalSql.toUpperCase().contains("FROM CRYXX") || originalSql.toUpperCase().contains("FROM MZXX") || originalSql.toUpperCase().contains("FROM JBXX") || originalSql.toUpperCase().contains("FROM BMXX") || originalSql.toUpperCase().contains("FROM HZJBXX") || originalSql.toUpperCase().contains("RENAME TABLE") || originalSql.toUpperCase().contains("FROM YHYKSXX") || originalSql.toUpperCase().contains("FROM YHYJSXX") || originalSql.toUpperCase().contains("ALTER TABLE") || originalSql.toUpperCase().contains("CREATE TABLE")) {
return originalSql;
}
// 鎻愬彇 orgid 鐨� WHERE 瀛愬彞
@@ -111,6 +93,8 @@
whereClause = tableOrAlias.toUpperCase() + "." + whereClause;
if (whereClause.contains("WHERE. orgid")) {
whereClause = whereClause.replaceAll("WHERE. orgid", "orgid");
+ } else {
+ whereClause = whereClause.toLowerCase();
}
}
--
Gitblit v1.9.3