/**
* @param Query $pageQuery
*/
protected function setPagerParameters(Query $pageQuery)
{
$pageQuery->setFirstResult($this->getFirstResult());
$pageQuery->setMaxResults($this->bufferSize);
}
/**
* @param int
* @param int
* @return ResultSet
*/
public function applyPaging($offset, $limit)
{
if ($this->query->getFirstResult() != $offset || $this->query->getMaxResults() != $limit) {
$this->query->setFirstResult($offset);
$this->query->setMaxResults($limit);
$this->iterator = NULL;
}
return $this;
}
/**
* @param int $maxPerPage
*/
public function setMaxPerPage($maxPerPage)
{
if ($maxPerPage > 0) {
$this->maxPerPage = $maxPerPage;
$this->query->setMaxResults($maxPerPage);
} else {
$this->maxPerPage = 0;
$this->query->setMaxResults(Query::INFINITY);
}
$this->calculateFirstResult();
}
/**
* @return Query
* @throws \LogicException If source of a query is not valid
*/
protected function getQuery()
{
if (null === $this->query) {
if ($this->source instanceof Query) {
$this->query = $this->cloneQuery($this->source);
} elseif ($this->source instanceof QueryBuilder) {
$this->query = $this->source->getQuery();
} else {
throw new \LogicException('Unexpected source');
}
unset($this->source);
// initialize cloned query
$this->maxResults = $this->query->getMaxResults();
if (!$this->maxResults || $this->requestedBufferSize < $this->maxResults) {
$this->query->setMaxResults($this->requestedBufferSize);
}
if (null !== $this->requestedHydrationMode) {
$this->query->setHydrationMode($this->requestedHydrationMode);
}
$this->firstResult = (int) $this->query->getFirstResult();
}
return $this->query;
}
/**
* Creates LIMIT clause.
*
* @access public
* @param integer $iVal
* @return $this
* @since 1.0.0-alpha
* @version 1.0.0-alpha
*/
public function limit($iVal)
{
$this->oQuery->setMaxResults($iVal);
return $this;
}
/**
* {@inheritdoc}
*/
public function findCollectionSet($depth = 0, $filter = [], CollectionInterface $collection = null, $sortBy = [])
{
try {
$dql = sprintf('SELECT n, collectionMeta, defaultMeta, collectionType, collectionParent, parentMeta, collectionChildren
FROM %s AS n
LEFT OUTER JOIN n.meta AS collectionMeta
LEFT JOIN n.defaultMeta AS defaultMeta
LEFT JOIN n.type AS collectionType
LEFT JOIN n.parent AS collectionParent
LEFT JOIN n.children AS collectionChildren
LEFT JOIN collectionParent.meta AS parentMeta
WHERE (n.depth <= :depth + :maxDepth OR collectionChildren.depth <= :maxDepthPlusOne)', $this->_entityName);
if ($collection !== null) {
$dql .= ' AND n.lft BETWEEN :lft AND :rgt AND n.id != :id';
}
if (array_key_exists('search', $filter) && $filter['search'] !== null) {
$dql .= ' AND collectionMeta.title LIKE :search';
}
if (array_key_exists('locale', $filter)) {
$dql .= ' AND (collectionMeta.locale = :locale OR defaultMeta != :locale)';
}
if ($sortBy !== null && is_array($sortBy) && sizeof($sortBy) > 0) {
$orderBy = [];
foreach ($sortBy as $column => $order) {
$orderBy[] = 'collectionMeta.' . $column . ' ' . (strtolower($order) === 'asc' ? 'ASC' : 'DESC');
}
$dql .= ' ORDER BY ' . implode(', ', $orderBy);
}
$query = new Query($this->_em);
$query->setDQL($dql);
$query->setParameter('maxDepth', intval($depth));
$query->setParameter('maxDepthPlusOne', intval($depth) + 1);
$query->setParameter('depth', $collection !== null ? $collection->getDepth() : 0);
if ($collection !== null) {
$query->setParameter('lft', $collection->getLft());
$query->setParameter('rgt', $collection->getRgt());
$query->setParameter('id', $collection->getId());
}
if (array_key_exists('search', $filter) && $filter['search'] !== null) {
$query->setParameter('search', '%' . $filter['search'] . '%');
}
if (array_key_exists('limit', $filter)) {
$query->setMaxResults($filter['limit']);
}
if (array_key_exists('offset', $filter)) {
$query->setFirstResult($filter['offset']);
}
if (array_key_exists('locale', $filter)) {
$query->setParameter('locale', $filter['locale']);
}
return new Paginator($query);
} catch (NoResultException $ex) {
return [];
}
}
/**
* @route: blog_new
* Tag Controller
*/
public function newAction()
{
// entity manager and query builder objects
$em = $this->getEm();
$query = new Query($em);
$query->setDQL(
'SELECT p,comments
FROM Bundle\BlogBundle\Entity\Post p
JOIN p.comments comments
ORDER BY p.date DESC'
);
$query->setMaxResults(1);
//$query->setParameter(1, $slug);
$posts = $query->getResult();
return $this->render('BlogBundle:Blog:post.html.twig', array(
'post' => $posts[0]
));
}
public function fetch(Query $query, $mode = self::FETCH_ALL)
{
if ($mode == self::FETCH_ALL) {
if ($query->getMaxResults() !== null && $query->getHydrationMode() != self::HYDRATE_SINGLE_SCALAR) {
return (new Paginator($query))->getIterator()->getArrayCopy();
} else {
return $query->execute();
}
} else {
if ($mode == self::FETCH_ALL_PAGED) {
return new Paginator($query);
} else {
if ($mode == self::FETCH_ONE) {
$query->setMaxResults(1);
if ($query->getHydrationMode() != self::HYDRATE_SINGLE_SCALAR) {
return (new Paginator($query))->getIterator()->current();
} else {
return $query->getOneOrNullResult();
}
} else {
if ($mode == self::FETCH_ONE_UNIQUE) {
return $query->getOneOrNullResult();
}
}
}
}
}
/**
* Applies the paging configuration to the query object.
*
* @param Query $query Query object
* @param QueryOptions $options Paging options
*/
protected function applyPagingOptionsToQuery(Query $query, QueryOptions $options = null)
{
if ($options == null) {
return;
}
if ($options->hasPagination()) {
$query->setFirstResult(($options->page - 1) * $options->itemsPerPage);
$query->setMaxResults($options->itemsPerPage);
}
}
