/**
*
* @param int $siteId
* @param string $orderBy
* @param int $order
* @param int $page
* @param int $perPage
* @return Application\Component\TableInterface
*/
protected function getVotersTable($siteId, $orderBy, $order, $page, $perPage)
{
$aggregates = array(new Aggregate(DbViewVotes::USERID, Aggregate::NONE, null, true), new Aggregate(DbViewVotes::USERNAME, Aggregate::NONE, null, true), new Aggregate(DbViewVotes::USERDISPLAYNAME, Aggregate::NONE, null, true), new Aggregate(DbViewVotes::USERDELETED, Aggregate::NONE, null, true), new Aggregate('*', Aggregate::COUNT, 'Votes'), new Aggregate(DbViewVotes::VALUE, Aggregate::SUM, 'Sum'));
$voters = $this->services->getVoteService()->getAggregatedForSite($siteId, $aggregates, null, null, array($orderBy => $order), true);
$voters->setCurrentPageNumber($page);
$voters->setItemCountPerPage($perPage);
$table = PaginatedTableFactory::createVotersTable($voters);
$table->getColumns()->setOrder($orderBy, $order === Order::ASCENDING);
return $table;
}
public function votersAction()
{
$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 !== 'Votes' && !DbViewVotes::hasField($orderBy)) {
$orderBy = 'Votes';
$order = Order::DESCENDING;
} else {
if ($this->params()->fromQuery('ascending', true)) {
$order = Order::ASCENDING;
} else {
$order = Order::DESCENDING;
}
}
$voters = $this->getVotersPaginator($siteId, $from, $to, $orderBy, $order, $page, $perPage);
$table = PaginatedTableFactory::createVotersTable($voters);
$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()));
}
}
return new JsonModel($result);
}
