送审组织机构打不开

2369059705@qq.com

2023-05-17 e1819d439bb79d6fc124e111f0f3abeb4d11a927

送审组织机构打不开

 product-server-admin/src/main/java/com/product/admin/service/OrganizationCacheService.java

@@ -246,8 +246,8 @@
        sql.append("\n a.org_level_type  ");
        sql.append("\n FROM  ");
        sql.append("\n product_sys_org_levels a ");
        sql.append("\n join product_sys_org_levels b on  b.org_level_status=0  ");
        sql.append("\n and (a.org_level_code_parent=b.org_level_code  OR (a.org_level_code_parent is null or a.org_level_code_parent=''))");
        sql.append("\n LEFT JOIN product_sys_org_levels b on  b.org_level_status=0  ");
        sql.append("\n and (a.org_level_code_parent=b.org_level_code  )");
        sql.append("\n where a.org_level_status=0  ");

        Object[] params = null;