src/Repository/AlertesRepository.php line 23

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Alertes;
  6. use DateTime;
  7. use Doctrine\ORM\ORMException;
  8. use Doctrine\ORM\QueryBuilder;
  9. use Doctrine\ORM\OptimisticLockException;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  13. /**
  14.  * @method Alertes|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method Alertes|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method Alertes[]    findAll()
  17.  * @method Alertes[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class AlertesRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, Alertes::class);
  24.     }
  26.     /**
  27.      * @throws ORMException
  28.      * @throws OptimisticLockException
  29.      */
  30.     public function add(Alertes $entity, bool $flush = true): void
  31.     {
  32.         $this->_em->persist($entity);
  33.         if ($flush) {
  34.             $this->_em->flush();
  35.         }
  36.     }
  38.     /**
  39.      * @throws ORMException
  40.      * @throws OptimisticLockException
  41.      */
  42.     public function remove(Alertes $entity, bool $flush = true): void
  43.     {
  44.         $this->_em->remove($entity);
  45.         if ($flush) {
  46.             $this->_em->flush();
  47.         }
  48.     }
  51.     protected function genericRequestOrder(QueryBuilder $queryBuilder)
  52.     {
  53.         $response = $queryBuilder->select('a')
  54.             ->getQuery()
  55.             ->getResult();
  57.         return $response;
  58.     }
  61.     public function findNotifications($id, $user): array
  62.     {
  63.         $today = new DateTime();
  64.         $alertes =  $this->genericRequestOrder(
  65.             ($this->createQueryBuilder('a')
  66.                 ->addSelect('t')
  67.                 ->leftJoin('a.idTypeAlerte', 't')
  68.                 ->where('a.idContact = :id')
  69.                 ->andWhere('a.dateAlerte <= :today')
  70.                 ->andWhere("t.alerte != 'Groupe'")
  71.                 ->andWhere('a.traite = false')
  72.                 ->setParameter('id', $id)
  73.                 ->setParameter('today', $today->format('Y-m-d'))
  74.             )
  75.         );
  77.         foreach (($user->getRoles()) as $role) {
  78.             $alertersGroup =  $this->genericRequestOrder(
  79.                 ($this->createQueryBuilder('a')
  80.                     ->addSelect('t')
  81.                     ->leftJoin('a.idTypeAlerte', 't')
  82.                     ->where('a.dateAlerte <= :today')
  83.                     ->andWhere("t.alerte = 'Groupe'")
  84.                     ->andWhere('a.traite = false')
  85.                     ->andWhere('a.roleGroup = :role')
  86.                     ->setParameter('role', $role)
  87.                     ->setParameter('today', $today->format('Y-m-d'))
  88.                 )
  89.             );
  91.             $alertes =  array_merge($alertes, $alertersGroup);
  92.         }
  94.         return $alertes;
  95.     }
  96. }