/** * * @param int $siteId * @param string $orderBy * @param int $order * @param int $page * @param int $perPage * @return Application\Component\TableInterface */ protected function getEditorsTable($siteId, $orderBy, $order, $page, $perPage) { $aggregates = array(new Aggregate(DbViewRevisions::USERID, Aggregate::NONE, null, true), new Aggregate(DbViewRevisions::USERWIKIDOTNAME, Aggregate::NONE, null, true), new Aggregate(DbViewRevisions::USERDISPLAYNAME, Aggregate::NONE, null, true), new Aggregate(DbViewRevisions::USERDELETED, Aggregate::NONE, null, true), new Aggregate('*', Aggregate::COUNT, 'Revisions')); $editors = $this->services->getRevisionService()->getAggregatedValues($siteId, $aggregates, null, null, array($orderBy => $order), true); $editors->setCurrentPageNumber($page); $editors->setItemCountPerPage($perPage); $table = PaginatedTableFactory::createEditorsTable($editors); $table->getColumns()->setOrder($orderBy, $order === Order::ASCENDING); return $table; }
public function editorsAction() { $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'); if (!$orderBy || $orderBy !== 'Revisions' && !DbViewRevisions::hasField($orderBy)) { $orderBy = 'Revisions'; $order = Order::DESCENDING; } else { if ($this->params()->fromQuery('ascending', true)) { $order = Order::ASCENDING; } else { $order = Order::DESCENDING; } } $editors = $this->getEditorsPaginator($siteId, $from, $to, $orderBy, $order, $page, $perPage); $table = PaginatedTableFactory::createEditorsTable($editors); $renderer = $this->getServiceLocator()->get('ViewHelperManager')->get('partial'); $table->getColumns()->setOrder($orderBy, $order === Order::ASCENDING); if ($renderer) { $result['success'] = true; $result['content'] = $renderer('partial/tables/table.phtml', array('table' => $table, 'data' => array('total' => $this->services->getRevisionService()->countSiteRevisions($siteId, $from, $to)))); } } return new JsonModel($result); }