src/Repository/DealRepository.php line 42

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Club;
  6. use App\Entity\Deal;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11.  * @extends ServiceEntityRepository<Deal>
  12.  *
  13.  * @method Deal|null find($id, $lockMode = null, $lockVersion = null)
  14.  * @method Deal|null findOneBy(array $criteria, array $orderBy = null)
  15.  * @method Deal[]    findAll()
  16.  * @method Deal[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  17.  */
  18. class DealRepository extends ServiceEntityRepository
  19. {
  20.     public function __construct(ManagerRegistry $registry)
  21.     {
  22.         parent::__construct($registry, Deal::class);
  23.     }
  25.     public function save(Deal $entity, bool $flush = false): void
  26.     {
  27.         $this->getEntityManager()->persist($entity);
  28.         if ($flush) {
  29.             $this->getEntityManager()->flush();
  30.         }
  31.     }
  33.     public function remove(Deal $entity, bool $flush = false): void
  34.     {
  35.         $this->getEntityManager()->remove($entity);
  37.         if ($flush) {
  38.             $this->getEntityManager()->flush();
  39.         }
  40.     }
  42.     public function findByDistanceAndClub(
  43.         ?float $ownLat,
  44.         ?float $ownLon,
  45.         bool $ifClub,
  46.         array $params = [],
  47.         int $distance = null,
  48.         Club $club = null,
  49.         bool $ifLonOrLat,
  50.     )
  51.     {
  53.         $qb = $this->createQueryBuilder('d');
  55.             $qb->leftJoin('d.company', 'comp')
  56.                 ->leftJoin('comp.address', 'a');
  58.         if ($ifLonOrLat) {
  59.             if ($ownLat !== null && $ownLon !== null) {
  61.                 $qb->addSelect(
  62.                     "CASE WHEN (a.id IS NOT NULL) THEN (111.12 * SQRT(
  63.                         POWER(
  64.                             (a.longi - :lonB)
  65.                             *
  66.                             COS(
  67.                                 (a.lat + :latB)
  68.                                 /
  69.                                 2
  70.                             )
  71.                         , 2)
  72.                         +
  73.                         POWER(
  74.                             (:latB - a.lat)
  75.                         , 2)
  76.                     )) ELSE 100000 END AS distance")
  77.                     ->setParameter('lonB', $ownLon)
  78.                     ->setParameter('latB', $ownLat);
  80.             }
  82.             if ($distance !== null) {
  83.                 $qb->andWhere('
  84.                 CASE WHEN (a.id IS NOT NULL) THEN (111.12 * SQRT(
  85.                     POWER(
  86.                         (a.longi - :lonB) * COS((a.lat + :latB) / 2), 2) +
  87.                     POWER((:latB - a.lat), 2)
  88.                 )) ELSE 100000 END
  89.                 <= :dist')
  90.                     ->setParameter('dist', $distance);
  91.             }
  93.             if ($ifClub) {
  94.                 $qb->andWhere('d.club = :club')
  95.                     ->setParameter('club', $club);
  96.             }
  98.         }
  100.         if (!empty($params) && array_key_exists('query', $params) && !empty($params['query'])) {
  101.             $qb->andWhere('d.title LIKE :query OR d.description LIKE :query OR comp.fti LIKE :query')
  102.                 ->setParameter('query', '%'.$params['query'].'%');
  103.         }
  105.         $page = $params['page'] ?? 1;
  106.         if ($page <= 0) {
  107.             $page = 1;
  108.         }
  110.         $limit = $params['limit'] ?? 10;
  111.         if ($limit <= 0) {
  112.             $limit = 10;
  113.         }
  115.         $qb->setFirstResult(($page - 1) * $limit)->setMaxResults($limit);
  117.         return $qb->getQuery()->getResult();
  119.     }
  121. //    /**
  122. //     * @return Deal[] Returns an array of Deal objects
  123. //     */
  124. //    public function findByExampleField($value): array
  125. //    {
  126. //        return $this->createQueryBuilder('d')
  127. //            ->andWhere('d.exampleField = :val')
  128. //            ->setParameter('val', $value)
  129. //            ->orderBy('d.id', 'ASC')
  130. //            ->setMaxResults(10)
  131. //            ->getQuery()
  132. //            ->getResult()
  133. //        ;
  134. //    }
  136. //    public function findOneBySomeField($value): ?Deal
  137. //    {
  138. //        return $this->createQueryBuilder('d')
  139. //            ->andWhere('d.exampleField = :val')
  140. //            ->setParameter('val', $value)
  141. //            ->getQuery()
  142. //            ->getOneOrNullResult()
  143. //        ;
  144. //    }
  145. }