/**
* 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;
}
