src/Repository/AddressRepository.php line 46

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Address;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. /**
  10.  * @method Address|null find($id, $lockMode = null, $lockVersion = null)
  11.  * @method Address|null findOneBy(array $criteria, array $orderBy = null)
  12.  * @method Address[]    findAll()
  13.  * @method Address[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  14.  */
  15. class AddressRepository extends ServiceEntityRepository
  16. {
  17.     public function __construct(ManagerRegistry $registry)
  18.     {
  19.         parent::__construct($registry, Address::class);
  20.     }
  22.     public function getExistingCountries($type = null)
  23.     {
  24.         $query = $this->createQueryBuilder('a')
  25.             ->select('a.countryCode')
  26.             ->join('a.owner','o')
  27.             ->where('o.isPro = true')
  28.             ->groupBy('a.countryCode')
  29.             ->orderBy('count(a.countryCode)', 'DESC')
  30.         ;
  32.         if ($type != null) {
  33.             if ($type == 'coach') {
  34.                 $query->andWhere('o INSTANCE OF App\Entity\Coach');
  35.             }
  36.             else if ($type == 'club') {
  37.                 $query->andWhere('o INSTANCE OF App\Entity\Club');
  38.             } 
  39.             else 
  40.             {
  41.                 $query->andWhere('o INSTANCE OF App\Entity\Operator');
  42.             }
  43.         }
  44.             
  45.         return $query->getQuery()
  46.             ->getResult();
  47.     }
  49.     public function findCountryName($slug)
  50.     {
  51.         return $this->createQueryBuilder('a')
  52.             ->select('MIN(a.country)')
  53.             ->where('a.slug  = :slug')
  54.             ->setParameter('slug', $slug)
  55.             ->getQuery()
  56.             ->getOneOrNullResult()
  57.         ;
  58.     }
  59. }