本文整理汇总了PHP中Doctrine\ORM\Query::setMaxResults方法的典型用法代码示例。如果您正苦于以下问题:PHP Query::setMaxResults方法的具体用法?PHP Query::setMaxResults怎么用?PHP Query::setMaxResults使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Doctrine\ORM\Query
的用法示例。
在下文中一共展示了Query::setMaxResults方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: setPagerParameters
/**
* @param Query $pageQuery
*/
protected function setPagerParameters(Query $pageQuery)
{
$pageQuery->setFirstResult($this->getFirstResult());
$pageQuery->setMaxResults($this->bufferSize);
}
示例2: applyPaging
/**
* @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;
}
示例3: setMaxPerPage
/**
* @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();
}
示例4: getQuery
/**
* @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;
}
示例5: limit
/**
* 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;
}
示例6: findCollectionSet
/**
* {@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 [];
}
}
示例7: newAction
/**
* @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]
));
}
示例8: fetch
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();
}
}
}
}
}
示例9: applyPagingOptionsToQuery
/**
* 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);
}
}