@Secured({"ROLE_ADMIN"}) @RequestMapping(value = {"/admin"}) public ModelAndView admin( HttpServletResponse response, @RequestParam(value = "page", required = false, defaultValue = "1") int page, @RequestParam(value = "pageSize", required = false, defaultValue = "20") int pageSize) throws Exception { response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1. response.setHeader("Pragma", "no-cache"); // HTTP 1.0. response.setDateHeader("Expires", 0); ModelAndView mav = new ModelAndView("admin/index"); long totalGuests = jpaDaoService.executeNativeQuery("SELECT count(*) from Guest"); // If pageSize is too small, set to default of 20 if (pageSize <= 0) pageSize = 20; // Limit range of page to be >=1 and <= lastPage) int lastPage = ((int) totalGuests) % pageSize == 0 ? ((int) totalGuests) / pageSize : ((int) totalGuests) / pageSize + 1; if (page < 1) page = 1; else if (page > lastPage) page = lastPage; final int offset = (page - 1) * pageSize; final List<Guest> allGuests = jpaDaoService.executeQueryWithLimitAndOffset( "SELECT guest FROM Guest guest", pageSize, offset, Guest.class); // get scheduled updateWorkerTasks for the current subset of users final List<UpdateWorkerTask> tasks = connectorUpdateService.getAllScheduledUpdateWorkerTasks(); mav.addObject("allGuests", allGuests); mav.addObject("release", env.get("release")); final List<ConnectorInfo> connectors = systemService.getConnectors(); mav.addObject("subview", "connectorHealthDashboard"); mav.addObject("connectors", connectors); List<Map.Entry<Guest, List<List<ApiKey>>>> rows = new ArrayList<Map.Entry<Guest, List<List<ApiKey>>>>(); ValueHolder synching = getSynchingUpdateWorkerTasks(); long consumerTriggerRepeatInterval = Long.valueOf(env.get("consumer.trigger.repeatInterval")); ValueHolder due = getDueUpdateWorkerWorkerTasks(tasks, consumerTriggerRepeatInterval); ValueHolder overdue = getOverdueUpdateWorkerWorkerTasks(tasks, consumerTriggerRepeatInterval); for (Guest guest : allGuests) { List<List<ApiKey>> guestApiKeys = new ArrayList<List<ApiKey>>(); for (ConnectorInfo connector : connectors) { final List<ApiKey> apiKeys = guestService.getApiKeys(guest.getId(), Connector.fromValue(connector.api)); guestApiKeys.add(apiKeys); } final Map.Entry<Guest, List<List<ApiKey>>> guestListEntry = new AbstractMap.SimpleEntry<Guest, List<List<ApiKey>>>(guest, guestApiKeys); rows.add(guestListEntry); } mav.addObject("totalGuests", totalGuests); mav.addObject("fromGuest", offset); mav.addObject("toGuest", offset + allGuests.size()); mav.addObject("page", page); mav.addObject("pageSize", pageSize); mav.addObject("synching", synching); mav.addObject("tasksDue", due); mav.addObject("tasksOverdue", overdue); mav.addObject("rows", rows); mav.addObject("serverUUID", connectorUpdateService.getLiveServerUUIDs().toString()); return mav; }