SQL处理

liusheng

2 天以前 8fbd14764be455c53d3722e4d174e87fadf41a51

SQL处理

 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();
            }
        }