src/Repository/DoctorRepository.php line 56

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Appointment;
  6. use App\Entity\Doctor;
  7. use Boab\CmsBundle\Service\Pagination;
  8. use Boab\CmsBundle\Service\PaginationInterface;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use Iterator;
  13. /**
  14.  * @extends ServiceEntityRepository<Doctor>
  15.  *
  16.  * @method Doctor|null find($id, $lockMode = null, $lockVersion = null)
  17.  * @method Doctor|null findOneBy(array $criteria, array $orderBy = null)
  18.  * @method Doctor[]    findAll()
  19.  * @method Doctor[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  20.  */
  21. class DoctorRepository extends ServiceEntityRepository
  22. {
  23.     public function __construct(ManagerRegistry $registry, private PaginationInterface $pagination)
  24.     {
  25.         parent::__construct($registry, Doctor::class);
  26.     }
  28.     public function save(Doctor $entity, bool $flush = false): void
  29.     {
  30.         $this->getEntityManager()->persist($entity);
  32.         if ($flush) {
  33.             $this->getEntityManager()->flush();
  34.         }
  35.     }
  37.     public function remove(Doctor $entity, bool $flush = false): void
  38.     {
  39.         $this->getEntityManager()->remove($entity);
  41.         if ($flush) {
  42.             $this->getEntityManager()->flush();
  43.         }
  44.     }
  46.     public function findAllDoctors()
  47.     {
  48.         $qb = $this->createQueryBuilder('d')
  49.             ->orderBy('d.id', 'ASC')
  50.             ->setMaxResults(10)
  51.             ->getQuery();
  53.         return $this->pagination->paginate($qb);
  54.     }
  56.     public function findAllByLocation(string $lat, string $lng, int $distance=0, $name) 
  57.     {
  58.         $qb = $this->createQueryBuilder('d');
  59.         $qb->select('d', 'SUM(r.rating) as totalRating', 'COUNT(r) as numberOfRatings')
  60.             ->leftJoin('d.reviews', 'r');
  62.             if ($lat && $lng) {
  63.                 $qb->addSelect('
  64.                     (6371 * 
  65.                     ACOS(
  66.                         COS(RADIANS(:lat)) * 
  67.                         COS(RADIANS(d.latitude)) * 
  68.                         COS(RADIANS(d.longitude) - RADIANS(:lng)) + 
  69.                         SIN(RADIANS(:lat)) * 
  70.                         SIN(RADIANS(d.latitude))
  71.                     ))
  72.                     AS HIDDEN distance'
  73.                 );
  74.                 $qb->setParameter('lat', $lat);
  75.                 $qb->setParameter('lng', $lng);                
  76.                 $qb->orderBy('distance');
  78.                 if ($distance > 0) {
  79.                     $qb->having('distance <= :distance');
  80.                     $qb->setParameter('distance', $distance);
  81.                 }                
  82.             }
  83.         /*
  84.         $qb->addSelect('
  85.             (6371 * 
  86.             ACOS(
  87.                 COS(RADIANS(:lat)) * 
  88.                 COS(RADIANS(d.latitude)) * 
  89.                 COS(RADIANS(d.longitude) - RADIANS(:lng)) + 
  90.                 SIN(RADIANS(:lat)) * 
  91.                 SIN(RADIANS(d.latitude))
  92.             ))
  93.             AS HIDDEN distance'
  94.         );
  95.         */
  96.         
  97.         if($name){
  98.             $qb->andWhere("CONCAT(d.firstname, ' ', d.lastname) LIKE :name");
  99.             $qb->setParameter('name', '%' . $name . '%');
  100.         }
  101.         
  102.         $qb->groupBy('d');
  103.         
  104.         return $this->pagination->paginate($qb->getQuery());
  105.     } 
  106. }