src/Repository/AbscenceSheetRepository.php line 36

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\AbscenceSheet;
  6. use App\Entity\SchoolYear;
  7. use App\Entity\Quater;
  8. use App\Entity\Sequence;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  12. /**
  13. * @extends ServiceEntityRepository<AbscenceSheet>
  14. *
  15. * @method AbscenceSheet|null find($id, $lockMode = null, $lockVersion = null)
  16. * @method AbscenceSheet|null findOneBy(array $criteria, array $orderBy = null)
  17. * @method AbscenceSheet[] findAll()
  18. * @method AbscenceSheet[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  19. */
  20. class AbscenceSheetRepository extends ServiceEntityRepository
  21. {
  22. public function __construct(ManagerRegistry $registry)
  23. {
  24. parent::__construct($registry, AbscenceSheet::class);
  25. }
  26. public function findAbsByYear(SchoolYear $year )
  27. {
  28. $qb = $this->createQueryBuilder('a')
  29. ->leftJoin('a.sequence', 's')
  30. ->leftJoin('s.quater', 'q')
  31. ->leftJoin('q.schoolYear', 'sc')
  32. ->andWhere('sc.id=:sc')
  33. ->setParameter('sc', $year->getId());
  36. return $qb ->orderBy('a.id', 'DESC')->getQuery()->getResult();
  37. }
  39. // /**
  40. // * @return AbscenceSheet[] Returns an array of AbscenceSheet objects
  41. // */
  42. // public function findByExampleField($value): array
  43. // {
  44. // return $this->createQueryBuilder('a')
  45. // ->andWhere('a.exampleField = :val')
  46. // ->setParameter('val', $value)
  47. // ->orderBy('a.id', 'ASC')
  48. // ->setMaxResults(10)
  49. // ->getQuery()
  50. // ->getResult()
  51. // ;
  52. // }
  54. /**
  55. * @return AbscenceSheet[] Returns an array of AbscenceSheet objects
  56. */
  57. public function findByQuater(Quater $qt): ?array
  58. {
  59. return $this->createQueryBuilder('a')
  60. ->leftJoin('a.sequence', 's')
  61. ->leftJoin('s.quater', 'q')
  62. ->where('q.id=:q_id')
  63. ->orderBy('a.updatedAt')
  64. ->setParameter('q_id', $qt->getId())
  65. ->getQuery()
  66. ->getResult();
  67. ;
  68. }
  69. }