/**
* Generates the paginated resultset
*
* @param ItemsEvent $event
*/
public function items(ItemsEvent $event)
{
$query = $event->getQuery();
$distinct = $event->isDistinct();
$result = null;
if ($distinct) {
$limitSubQuery = QueryHelper::cloneQuery($query);
$limitSubQuery->setParameters($query->getParameters());
QueryHelper::addCustomTreeWalker($limitSubQuery, self::TREE_WALKER_LIMIT_SUBQUERY);
$limitSubQuery->setFirstResult($event->getOffset())->setMaxResults($event->getRowCountPerPage());
$ids = array_map('current', $limitSubQuery->getScalarResult());
// create where-in query
$whereInQuery = QueryHelper::cloneQuery($query);
QueryHelper::addCustomTreeWalker($whereInQuery, self::TREE_WALKER_WHERE_IN);
$whereInQuery->setHint(WhereInWalker::HINT_PAGINATOR_ID_COUNT, count($ids))->setFirstResult(null)->setMaxResults(null);
foreach ($ids as $i => $id) {
$whereInQuery->setParameter(WhereInWalker::PAGINATOR_ID_ALIAS . '_' . ++$i, $id);
}
$result = $whereInQuery->getResult();
} else {
$query->setFirstResult($event->getOffset())->setMaxResults($event->getRowCountPerPage());
$result = $query->getResult();
}
$event->stopPropagation();
$event->setItems($result);
}
