src/Repository/BatchFeedbackEmailRepository.php line 79

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: grego
  5.  * Date: 04/02/2025
  6.  * Time: 14:29
  7.  */
  9. namespace App\Repository;
  12. use App\Entity\BatchFeedbackEmail;
  13. use DateTime;
  14. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  15. use Doctrine\Persistence\ManagerRegistry;
  17. /**
  18.  * @extends ServiceEntityRepository<Badge>
  19.  *
  20.  * @method BatchFeedbackEmail|null find($id, $lockMode = null, $lockVersion = null)
  21.  * @method BatchFeedbackEmail|null findOneBy(array $criteria, array $orderBy = null)
  22.  * @method BatchFeedbackEmail[]    findAll()
  23.  * @method BatchFeedbackEmail[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  24.  */
  25. class BatchFeedbackEmailRepository extends ServiceEntityRepository
  26. {
  28.     public function __construct(ManagerRegistry $registry)
  29.     {
  30.         parent::__construct($registry, BatchFeedbackEmail::class);
  31.     }
  33.     public function add(BatchFeedbackEmail $entity, bool $flush = false): void
  34.     {
  35.         $this->getEntityManager()->persist($entity);
  37.         if ($flush) {
  38.             $this->getEntityManager()->flush();
  39.         }
  40.     }
  42.     public function remove(BatchFeedbackEmail $entity, bool $flush = false): void
  43.     {
  44.         $this->getEntityManager()->remove($entity);
  46.         if ($flush) {
  47.             $this->getEntityManager()->flush();
  48.         }
  49.     }
  51. //    /**
  52. //     * @return Badge[] Returns an array of Badge objects
  53. //     */
  54. //    public function findByExampleField($value): array
  55. //    {
  56. //        return $this->createQueryBuilder('b')
  57. //            ->andWhere('b.exampleField = :val')
  58. //            ->setParameter('val', $value)
  59. //            ->orderBy('b.id', 'ASC')
  60. //            ->setMaxResults(10)
  61. //            ->getQuery()
  62. //            ->getResult()
  63. //        ;
  64. //    }
  66. //    public function findOneBySomeField($value): ?Badge
  67. //    {
  68. //        return $this->createQueryBuilder('b')
  69. //            ->andWhere('b.exampleField = :val')
  70. //            ->setParameter('val', $value)
  71. //            ->getQuery()
  72. //            ->getOneOrNullResult()
  73. //        ;
  74. //    }
  76.     const STATUS_PENDING = 0;
  77.     const STATUS_TREATED = 1;
  79.     public function getPendingBatchFeedbacksPastFiveMinuts(){
  80.         $now = new Datetime();
  81.         $past5Minuts = new Datetime();
  82.         $past5Minuts = $past5Minuts->modify('-5 minutes');
  84.         $em = $this->_em;
  85.         $request = $em->createQueryBuilder();
  86.         $request->select('bfe');
  87.         $request->from('App\Entity\BatchFeedbackEmail', 'bfe');
  88.         $request->andWhere('bfe.status = :pending');
  89.         $request->andWhere('bfe.createdAt >= :pastFiveMinuts AND bfe.createdAt <= :now');
  90.         $request->setParameter('pending', self::STATUS_PENDING);
  91.         $request->setParameter('pastFiveMinuts', $past5Minuts);
  92.         $request->setParameter('now', $now);
  93.         $batchFeedbackEmails = $request->getQuery()->getResult();
  95.         return $batchFeedbackEmails;
  96.     }
  97. }