src/Repository/CityPostRepository.php line 20

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\CityPost;
  6. use App\Form\Model\FilterCityModel;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11.  * @method CityPost|null find($id, $lockMode = null, $lockVersion = null)
  12.  * @method CityPost|null findOneBy(array $criteria, array $orderBy = null)
  13.  * @method CityPost[]    findAll()
  14.  * @method CityPost[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15.  */
  16. class CityPostRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, CityPost::class);
  21.     }
  23.     public function getFilteredCity(FilterCityModel $filterCityModel)
  24.     {
  25.         $queryBuilder = $this->createQueryBuilder('p');
  27.         if($filterCityModel->getName() !== null) {
  28.             $queryBuilder
  29.                 ->where('p.name LIKE :name')
  30.                 ->setParameter('name', '%'.$filterCityModel->getName().'%')
  31.             ;
  32.         }
  34.         $queryBuilder
  35.             ->orderBy('p.name', 'ASC');
  37.         return $queryBuilder->getQuery()->getResult();
  38.     }
  39. }