src/Repository/FilmProjectProgressReportRepository.php line 49

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\FilmProjectProgressReport;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. /**
  10.  * @extends ServiceEntityRepository<FilmProjectProgressReport>
  11.  *
  12.  * @method FilmProjectProgressReport|null find($id, $lockMode = null, $lockVersion = null)
  13.  * @method FilmProjectProgressReport|null findOneBy(array $criteria, array $orderBy = null)
  14.  * @method FilmProjectProgressReport[]    findAll()
  15.  * @method FilmProjectProgressReport[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  16.  */
  17. class FilmProjectProgressReportRepository extends ServiceEntityRepository
  18. {
  19.     public function __construct(ManagerRegistry $registry)
  20.     {
  21.         parent::__construct($registry, FilmProjectProgressReport::class);
  22.     }
  24. //    /**
  25. //     * @return FilmProjectProgressReport[] Returns an array of FilmProjectProgressReport objects
  26. //     */
  27. //    public function findByExampleField($value): array
  28. //    {
  29. //        return $this->createQueryBuilder('f')
  30. //            ->andWhere('f.exampleField = :val')
  31. //            ->setParameter('val', $value)
  32. //            ->orderBy('f.id', 'ASC')
  33. //            ->setMaxResults(10)
  34. //            ->getQuery()
  35. //            ->getResult()
  36. //        ;
  37. //    }
  39. //    public function findOneBySomeField($value): ?FilmProjectProgressReport
  40. //    {
  41. //        return $this->createQueryBuilder('f')
  42. //            ->andWhere('f.exampleField = :val')
  43. //            ->setParameter('val', $value)
  44. //            ->getQuery()
  45. //            ->getOneOrNullResult()
  46. //        ;
  47. //    }
  49.     public function findByYear(int $year, int $filmProjectId): ?FilmProjectProgressReport
  50.     {
  51.         $startDate = new \DateTime("$year-01-01 00:00:00");
  52.         $endDate = new \DateTime("$year-12-31 23:59:59");
  54.         return $this->createQueryBuilder('e')
  55.             ->leftJoin('e.filmProject','f')
  56.             ->andWhere('e.createdAt >= :startDate')
  57.             ->andWhere('e.createdAt <= :endDate')
  58.             ->andWhere('f.id = :filmProjectId')
  59.             ->setParameter('startDate', $startDate)
  60.             ->setParameter('endDate', $endDate)
  61.             ->setParameter('filmProjectId', $filmProjectId)
  62.             ->getQuery()
  63.             ->getOneOrNullResult()
  64.         ;
  65.     }
  67.     public function findAllByYear(int $year): array
  68.     {
  69.         $startDate = new \DateTime("$year-01-01 00:00:00");
  70.         $endDate = new \DateTime("$year-12-31 23:59:59");
  72.         return $this->createQueryBuilder('e')
  73.             ->leftJoin('e.filmProject','f')
  74.             ->andWhere('e.createdAt >= :startDate')
  75.             ->andWhere('e.createdAt <= :endDate')
  76.             ->setParameter('startDate', $startDate)
  77.             ->setParameter('endDate', $endDate)
  78.             ->getQuery()
  79.             ->getResult()
  80.         ;
  81.     }
  83.     public function findAllCompleted(): array
  84.     {
  85.         $completed = 'completed';
  86.         
  87.         return $this->createQueryBuilder('e')
  88.             ->andWhere('e.status = :status')
  89.             ->setParameter('status', $completed)
  90.             ->getQuery()
  91.             ->getResult()
  92.         ;
  93.     }
  94. }