src/Repository/CitiesRepository.php line 47

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Cities;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. /**
  10.  * @extends ServiceEntityRepository<Cities>
  11.  *
  12.  * @method Cities|null find($id, $lockMode = null, $lockVersion = null)
  13.  * @method Cities|null findOneBy(array $criteria, array $orderBy = null)
  14.  * @method Cities[]    findAll()
  15.  * @method Cities[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  16.  */
  17. class CitiesRepository extends ServiceEntityRepository
  18. {
  19.     public function __construct(ManagerRegistry $registry)
  20.     {
  21.         parent::__construct($registry, Cities::class);
  22.     }
  24.     public function save(Cities $entity, bool $flush = false): void
  25.     {
  26.         $this->getEntityManager()->persist($entity);
  28.         if ($flush) {
  29.             $this->getEntityManager()->flush();
  30.         }
  31.     }
  33.     public function remove(Cities $entity, bool $flush = false): void
  34.     {
  35.         $this->getEntityManager()->remove($entity);
  37.         if ($flush) {
  38.             $this->getEntityManager()->flush();
  39.         }
  40.     }
  42.     public function getCitiesWithMedics()
  43.     {
  44.         return $this->createQueryBuilder('c')
  45.             ->innerJoin('c.users', 'u')
  46.             ->getQuery()
  47.             ->getResult();
  48.     }
  49. }