Kdyby\Doctrine\EntityRepository::findBy PHP Method

findBy() public method

public findBy ( array $criteria, array $orderBy = null, $limit = null, $offset = null )
$criteria array
$orderBy array
    public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
    {
        if ($this->criteriaRequiresDql($criteria) === FALSE && $this->criteriaRequiresDql((array) $orderBy) === FALSE) {
            return parent::findBy($criteria, $orderBy, $limit, $offset);
        }
        $qb = $this->createQueryBuilder('e')->whereCriteria($criteria)->autoJoinOrderBy((array) $orderBy);
        return $qb->getQuery()->setMaxResults($limit)->setFirstResult($offset)->getResult();
    }

Usage Example

Example #1
0
 /**
  * Vraci ankety dle kriterii: limit, offset
  * @param array $limits
  * @return Entities\Vote[]
  */
 public function findAllVotes($limits = [])
 {
     if (empty($limits)) {
         return $this->myVoteRepository->findAll();
     }
     return $this->myVoteRepository->findBy([], ['id' => 'DESC'], $limits['limit'], $limits['offset']);
 }
All Usage Examples Of Kdyby\Doctrine\EntityRepository::findBy