src/Repository/Articles/ArticlesRepository.php line 34

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Articles;
  5. use App\Entity\Articles\Articles;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use Doctrine\ORM\NonUniqueResultException;
  10. /**
  11.  * @method Articles|null find($id, $lockMode = null, $lockVersion = null)
  12.  * @method Articles|null findOneBy(array $criteria, array $orderBy = null)
  13.  * @method Articles[]    findAll()
  14.  * @method Articles[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15.  */
  16. class ArticlesRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, Articles::class);
  21.     }
  23.     public function getArticleRandom(Articles $article, $categorie, $limit)
  24.     {
  25.         return $this->createQueryBuilder('a')
  26.             ->select('a', 'c')
  27.             ->leftJoin('a.categories', 'c')
  28.             ->andWhere('a.id != :article')
  29.             ->andWhere('c.id = :categorie')
  30.             ->setParameters(['article' => $article, 'categorie' => $categorie])
  31.             ->orderBy('RAND()')
  32.             ->setMaxResults($limit)
  33.             ->getQuery()
  34.             ->getResult()
  35.             ;
  36.     }
  38.     /**
  39.      * @param int $limit
  40.      * @return int|mixed|string
  41.      */
  42.     public function getIncontournable(int $limit)
  43.     {
  44.         return $this->createQueryBuilder('a')
  45.             ->andWhere('a.online = 1')
  46.             ->andWhere('a.incontournable = 1')
  47.             ->orderBy('a.id', 'DESC')
  48.             ->setMaxResults($limit)
  49.             ->getQuery()
  50.             ->getResult()
  51.             ;
  52.     }
  54.     /**
  55.      * @return int|mixed|string|null
  56.      * @throws NonUniqueResultException
  57.      */
  58.     public function featured()
  59.     {
  60.         return $this->createQueryBuilder('a')
  61.             ->andWhere('a.online = 1')
  62.             ->andWhere('a.featured = 1')
  63.             ->orderBy('a.updatedAt', 'DESC')
  64.             ->setMaxResults(1)
  65.             ->getQuery()
  66.             ->getOneOrNullResult()
  67.             ;
  68.     }
  69. }