public function membersAction() { $result = array('success' => false); $siteId = -1; $from = null; $to = null; if ($this->getCommonParams($siteId, $from, $to)) { $page = (int) $this->params()->fromQuery("page", 1); $perPage = (int) $this->params()->fromQuery("perPage", 10); $orderBy = $this->params()->fromQuery('orderBy', DbViewMembership::JOINDATE); if (!DbViewMembership::hasField($orderBy)) { $orderBy = DbViewMembership::JOINDATE; } $order = $this->params()->fromQuery('ascending', true); if ($order) { $order = Order::ASCENDING; } else { $order = Order::DESCENDING; } $members = $this->services->getUserService()->findSiteMembers($siteId, UserType::ANY, false, $from, $to, array($orderBy => $order), true); $members->setCurrentPageNumber($page); $members->setItemCountPerPage($perPage); $renderer = $this->getServiceLocator()->get('ViewHelperManager')->get('partial'); $table = PaginatedTableFactory::createMembersTable($members, false); $table->getColumns()->setOrder($orderBy, $order === Order::ASCENDING); if ($renderer) { $result['success'] = true; $result['content'] = $renderer('partial/tables/table.phtml', array('table' => $table, 'data' => array('siteId' => $siteId))); } } return new JsonModel($result); }