src/Repository/Configurator/LibraryRepository.php line 9

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace App\Repository\Configurator;
  7. use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
  9. final class LibraryRepository extends EntityRepository
  10. {
  11.     public function findByPhrase(string $phrase): array
  12.     {
  13.         return $this->createQueryBuilder('library')
  14.             ->leftJoin('library.translations', 'translation')
  15.             ->andWhere('translation.name LIKE :phrase')
  16.             ->setParameter('phrase', '%' . $phrase . '%')
  17.             ->getQuery()
  18.             ->getResult()
  19.             ;
  20.     }
  21. }