src/Domain/Repository/TextRepository.php line 19

Open in your IDE?
  1. <?php
  3. declare(strict_types = 1);
  5. namespace App\Domain\Repository;
  7. use App\Domain\Entity\Text;
  8. use App\Domain\Repository\Interfaces\TextRepositoryInterface;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  12. class TextRepository extends ServiceEntityRepository implements TextRepositoryInterface
  13. {
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, Text::class);
  17.     }
  19.     public function getContentByPageAndSection(string $page, string $section)
  20.     {
  21.         return $this->createQueryBuilder('text')
  22.             ->innerJoin('text.page', 'p')
  23.             ->innerJoin('text.section', 's')
  24.             ->where('p.name = :page')
  25.             ->andWhere('s.name = :section')
  26.             ->setParameter('page', $page)
  27.             ->setParameter('section', $section)
  28.             ->setCacheable(true)
  29.             ->getQuery()
  30.             ->getOneOrNullResult();
  31.     }
  33.     public function getContentsByPageAndSection(string $page, string $section)
  34.     {
  35.         return $this->createQueryBuilder('text')
  36.             ->innerJoin('text.page', 'p')
  37.             ->innerJoin('text.section', 's')
  38.             ->orderBy('text.createdAt', 'ASC')
  39.             ->where('p.name = :page')
  40.             ->andWhere('s.name = :section')
  41.             ->setParameter('page', $page)
  42.             ->setParameter('section', $section)
  43.             ->setCacheable(true)
  44.             ->getQuery()
  45.             ->getResult();
  46.     }
  47. }