From 34d15381438d5afafb1b42b0a61be9e2720211dc Mon Sep 17 00:00:00 2001 From: 杜洪波 <1074825718@qq.com> Date: 星期三, 24 九月 2025 17:55:21 +0800 Subject: [PATCH] 代码提交 --- src/main/java/com/product/server/report/service/ReportConfigService.java | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/product/server/report/service/ReportConfigService.java b/src/main/java/com/product/server/report/service/ReportConfigService.java index 0f07290..99fe3c4 100644 --- a/src/main/java/com/product/server/report/service/ReportConfigService.java +++ b/src/main/java/com/product/server/report/service/ReportConfigService.java @@ -474,12 +474,12 @@ * * @return */ - StringBuilder sql = new StringBuilder(256); - public JSONArray getReportReleaseInfo() { + public JSONArray getReportReleaseInfo() { DataTableEntity aimDte = new DataTableEntity(); DataTableEntity dte; Object[] arr; String filter; + StringBuilder sql = new StringBuilder(256); sql.append("\nSELECT distinct null pid,uuid sid,client_name name "); sql.append("\nFROM product_sys_clients c"); sql.append("\nINNER JOIN ("); @@ -597,9 +597,9 @@ sql.append("\n ) t "); sql.append("\n GROUP BY function_uuid "); sql.append("\n) t1 ON rc.function_uuid = t1.function_uuid "); - sql.append("\nINNER INNER product_sys_menus m on rc.function_uuid=m.function_uuid "); - sql.append("\nINNER INNER product_sys_report_type_config rtc on rc.type_uuid=rtc.uuid "); - sql.append("\nINNER INNER product_sys_menus mp on m.tricode_parent=mp.tricode "); + sql.append("\nINNER JOIN product_sys_menus m on rc.function_uuid=m.function_uuid "); + sql.append("\nINNER JOIN product_sys_report_type_config rtc on rc.type_uuid=rtc.uuid "); + sql.append("\nINNER JOIN product_sys_menus mp on m.tricode_parent=mp.tricode "); // sql.append("\n) t2 "); if (!StringUtils.isEmpty(filter)) { sql.append(" WHERE " + filter); -- Gitblit v1.9.2