<?php namespace App\Repository; use App\Entity\News; use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository; use Doctrine\Persistence\ManagerRegistry; /** * @method News|null find($id, $lockMode = null, $lockVersion = null) * @method News|null findOneBy(array $criteria, array $orderBy = null) * @method News[] findAll() * @method News[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) */ class NewsRepository extends ServiceEntityRepository { public function __construct(ManagerRegistry $registry) { parent::__construct($registry, News::class); } /** * @return News[] Returns an array of News objects */ public function findLatest($limit = 0) { $qb = $this->createQueryBuilder('n'); $qb ->where('n.enabled = :enabled') ->setParameter('enabled', true) ->orderBy('n.position', 'ASC'); if ($limit > 0) { $qb->setMaxResults($limit); } return $qb->getQuery(); } }