/** * control list with applied in no of Project * * @param request * @return */ @RequestMapping( value = "/icga/getJASONforProjectWiseControlList.html", method = RequestMethod.POST) public @ResponseBody JasonBean getProjectWiseControlCountList(HttpServletRequest request) { logger.debug("Project Wise Control List Controller "); String page = request.getParameter("page") != null ? request.getParameter("page") : "1"; String rp = request.getParameter("rp") != null ? request.getParameter("rp") : "10"; String sortname = request.getParameter("sortname") != null ? request.getParameter("sortname") : "projectName"; String sortorder = request.getParameter("sortorder") != null ? request.getParameter("sortorder") : "desc"; String query = request.getParameter("query") != null ? request.getParameter("query") : "false"; String qtype = request.getParameter("qtype") != null ? request.getParameter("qtype") : "false"; String controlIdsListAsString = request.getParameter("controlId") != null ? request.getParameter("controlId") : ""; String tableName = request.getParameter("tableName") != null ? request.getParameter("tableName") : ""; List dbColumnList = TransactionSearchController.getDbColumnHeaderList(request, tableName); sortname = dbColumnList != null ? RealTimeMonitoringController.getDbColumnNameByRef(dbColumnList, sortname) : null; logger.debug("SMN: controlIdsListAsString=" + controlIdsListAsString); List dbColumnHeaderList = new ArrayList(); JasonBean jasonData = new JasonBean(); int totalItems = 0; List<Cell> entry = new ArrayList<Cell>(); List trxSearchList = new ArrayList<Control>(); GlobalTransactionSearch globalTransactionSearch = new GlobalTransactionSearch(); try { totalItems = adminJdbcService.getProjectWiseCountByControlIds( controlIdsListAsString, getStringForComparingControls(controlIdsListAsString), qtype, query, sortname, sortorder); trxSearchList = adminJdbcService.getProjectWiseCountListByControlIds( controlIdsListAsString, getStringForComparingControls(controlIdsListAsString), Utils.parseInteger(page), "max".equals(rp) ? totalItems : Utils.parseInteger(rp), qtype, query, sortname, sortorder); logger.debug("TOTAL count---" + totalItems + " page=" + page + " rp=" + rp); if ("max".equals(rp)) { TransactionSearchController.setTotalListSizeAndListInSession( totalItems, trxSearchList, request); jasonData.setTotal(totalItems); } else { if (trxSearchList != null) { int count = 0; logger.debug("trxSearchList size=" + trxSearchList.size()); jasonData.setPage(Utils.parseInteger(page)); for (Object obj : trxSearchList) { RealTimeProject realTimeProject = new RealTimeProject(); Cell cell = new Cell(); Map map = (Map) obj; realTimeProject.setProjectName( map.get("project") != null ? map.get("project").toString() : ""); realTimeProject.setTransactionIds( map.get("transaction_ids") != null ? map.get("transaction_ids").toString() : ""); realTimeProject.setTotal(map.get("total") != null ? map.get("total").toString() : ""); realTimeProject.setProjectType( map.get("projectType") != null ? map.get("projectType").toString() : ""); realTimeProject.setProjectId( map.get("projectId") != null ? map.get("projectId").toString() : ""); cell.setId(count++); cell.setCell(realTimeProject); entry.add(cell); } Map mapForHeader = new HashMap(); mapForHeader.put( "projectName", "project"); // key=flexigrid parameter name, value = dbField Name mapForHeader.put("transactionIds", "transaction_ids"); mapForHeader.put("total", "total"); mapForHeader.put("projectId", "projectId"); mapForHeader.put("projectType", "projectType"); dbColumnHeaderList.add(mapForHeader); request.getSession().setAttribute(tableName, dbColumnHeaderList); jasonData.setRows(entry); jasonData.setTotal(totalItems); jasonData.setDbColumnHeader(dbColumnHeaderList); } else { logger.debug("No Transaction Search List Found"); } } } catch (Exception ex) { logger.debug("CERROR:Project Wise Control Exception : " + ex); } return jasonData; }