/** * 动态报表数据查询 * * @param configId 配置id-code * @param page 分页页面 * @param rows 分页大小 * @param request * @param response */ @SuppressWarnings("unchecked") @RequestMapping(params = "datagrid") public void datagrid( String configId, String page, String field, String rows, HttpServletRequest request, HttpServletResponse response) { // step.1 根据id获取该动态报表的配置参数 Map<String, Object> cgReportMap = null; try { cgReportMap = graphReportService.queryCgReportConfig(configId); if (cgReportMap.size() <= 0) { throw new CgReportNotFoundException("动态报表配置不存在!"); } } catch (Exception e) { throw new CgReportNotFoundException("查找动态报表配置失败!" + e.getMessage()); } // step.2 获取该配置的查询SQL Map configM = (Map) cgReportMap.get(CgReportConstant.MAIN); String querySql = (String) configM.get(CgReportConstant.CONFIG_SQL); List<Map<String, Object>> items = (List<Map<String, Object>>) cgReportMap.get(CgReportConstant.ITEMS); Map queryparams = new LinkedHashMap<String, Object>(); for (Map<String, Object> item : items) { String isQuery = (String) item.get(CgReportConstant.ITEM_ISQUERY); if (CgReportConstant.BOOL_TRUE.equalsIgnoreCase(isQuery)) { // step.3 装载查询条件 CgReportQueryParamUtil.loadQueryParams(request, item, queryparams); } } // step.4 进行查询返回结果 int p = page == null ? 1 : Integer.parseInt(page); int r = rows == null ? 99999 : Integer.parseInt(rows); List<Map<String, Object>> result = graphReportService.queryByCgReportSql(querySql, queryparams, p, r); long size = graphReportService.countQueryByCgReportSql(querySql, queryparams); dealDic(result, items); dealReplace(result, items); response.setContentType("application/json"); response.setHeader("Cache-Control", "no-store"); PrintWriter writer; try { writer = response.getWriter(); writer.println(CgReportQueryParamUtil.getJson(result, size)); writer.flush(); } catch (IOException e) { e.printStackTrace(); } }
/** * 组装模版参数 * * @param cgReportMap */ @SuppressWarnings("unchecked") private void loadVars(Map<String, Object> cgReportMap) { Map mainM = (Map) cgReportMap.get(CgReportConstant.MAIN); List<Map<String, Object>> fieldList = (List<Map<String, Object>>) cgReportMap.get(CgReportConstant.ITEMS); List<Map<String, Object>> queryList = new ArrayList<Map<String, Object>>(0); // 图表数据 List<Map<String, Object>> graphList = new ArrayList<Map<String, Object>>(0); // tab数据 Set<String> tabSet = new HashSet<String>(); List<String> tabList = new ArrayList<String>(); for (Map<String, Object> fl : fieldList) { fl.put( CgReportConstant.ITEM_FIELDNAME, ((String) fl.get(CgReportConstant.ITEM_FIELDNAME)).toLowerCase()); String isQuery = (String) fl.get(CgReportConstant.ITEM_ISQUERY); if (CgReportConstant.BOOL_TRUE.equalsIgnoreCase(isQuery)) { loadDic(fl, fl); queryList.add(fl); } if ("y".equals(fl.get("is_graph")) || "Y".equals(fl.get("is_graph"))) { graphList.add(fl); String tabName = (fl.get("tab_name") == null ? "" : fl.get("tab_name").toString()); if (!tabSet.contains(tabName)) { tabList.add(tabName); tabSet.add(tabName); } } } cgReportMap.put(CgReportConstant.CONFIG_ID, mainM.get("code")); cgReportMap.put(CgReportConstant.CONFIG_NAME, mainM.get("name")); cgReportMap.put(CgReportConstant.CONFIG_FIELDLIST, fieldList); cgReportMap.put(CgReportConstant.CONFIG_QUERYLIST, queryList); cgReportMap.put("graphList", graphList); cgReportMap.put("tabList", tabList); }
/** * 动态报表数据查询(不分页) * * @param configId 配置id-code * @param request * @param response */ @SuppressWarnings("unchecked") @RequestMapping(params = "datagridGraph") public void datagridGraph( String configId, HttpServletRequest request, HttpServletResponse response) { // step.1 根据id获取该动态报表的配置参数 Map<String, Object> cgReportMap = null; try { cgReportMap = graphReportService.queryCgReportConfig(configId); if (cgReportMap.size() <= 0) { throw new CgReportNotFoundException("动态报表配置不存在!"); } } catch (Exception e) { throw new CgReportNotFoundException("查找动态报表配置失败!" + e.getMessage()); } try { // step.2 获取该配置的查询SQL Map configM = (Map) cgReportMap.get(CgReportConstant.MAIN); String querySql = (String) configM.get("CGR_SQL"); List<Map<String, Object>> items = (List<Map<String, Object>>) cgReportMap.get(CgReportConstant.ITEMS); Map queryparams = new LinkedHashMap<String, Object>(); for (Map<String, Object> item : items) { String isQuery = (String) item.get(CgReportConstant.ITEM_ISQUERY); if (CgReportConstant.BOOL_TRUE.equalsIgnoreCase(isQuery)) { // step.3 装载查询条件 CgReportQueryParamUtil.loadQueryParams(request, item, queryparams); } } // step.4 进行查询返回结果 List<Map<String, Object>> result = graphReportService.queryByCgReportSql(querySql, queryparams, -1, -1); dealDic(result, items); dealReplace(result, items); // 导出execel List<String> fields = new ArrayList<String>(); List<Map<String, Object>> configItems = (List<Map<String, Object>>) cgReportMap.get(CgReportConstant.ITEMS); for (Map<String, Object> map : configItems) { if ("Y".equals(map.get("is_show"))) { fields.add(map.get("field_txt").toString()); fields.add(map.get("field_name").toString()); } } if (exportExecel( request, response, configM.get("content").toString(), configM.get("content").toString(), fields.toArray(new String[fields.size()]), result, null)) { return; } response.setContentType("application/json"); response.setHeader("Cache-Control", "no-store"); PrintWriter writer; writer = response.getWriter(); writer.println(CgReportQueryParamUtil.getJson(result, -1L)); writer.flush(); } catch (IOException e) { e.printStackTrace(); throw new RuntimeException(e); } }