| | |
| | | * |
| | | * @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 ("); |
| | |
| | | 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); |