src/Repository/SignedFormRepository.php line 68

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\SignedForm;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. use App\Classes\StudentFilter;
  11. /**
  12.  * @extends ServiceEntityRepository<SignedForm>
  13.  *
  14.  * @method SignedForm|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method SignedForm|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method SignedForm[]    findAll()
  17.  * @method SignedForm[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class SignedFormRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, SignedForm::class);
  24.     }
  26.     public function save(SignedForm $entity, bool $flush = false): void
  27.     {
  28.         $this->getEntityManager()->persist($entity);
  30.         if ($flush) {
  31.             $this->getEntityManager()->flush();
  32.         }
  33.     }
  35.     public function remove(SignedForm $entity, bool $flush = false): void
  36.     {
  37.         $this->getEntityManager()->remove($entity);
  39.         if ($flush) {
  40.             $this->getEntityManager()->flush();
  41.         }
  42.     }
  43.     
  44.     public function getDocuments(StudentFilter $filter = null, int $page = 1, int $limit = 20)
  45.     {
  46.         $page = max(1, $page);
  47.         $limit = max(1, $limit);
  48.         
  49.         $qb = $this->createQueryBuilder('c')
  50.                 ->addOrderBy('c.signeddate', 'desc');
  51.         
  52.         if ($filter && $filter->getStudent()) {
  53.             $qb->andWhere('c.student = :filterStudent')
  54.                     ->setParameter('filterStudent', $filter->getStudent());
  55.         }
  56.         
  57.         if ($filter && $filter->getClubform()) {
  58.             $qb->andWhere('c.clubform = :filterClubform')
  59.                     ->setParameter('filterClubform', $filter->getClubform());
  60.         }
  61.         
  62.         $qb->setFirstResult(($page - 1) * $limit)
  63.                 ->setMaxResults($limit);
  65.         return $qb->getQuery()->getResult();
  66.     }
  67.     
  68.     public function countDocuments(StudentFilter $filter = null): int
  69.     {
  70.         $qb = $this->createQueryBuilder('c')
  71.                 ->select('COUNT(c.id)');
  72.         
  73.         if ($filter && $filter->getStudent()) {
  74.             $qb->andWhere('c.student = :filterStudent')
  75.                     ->setParameter('filterStudent', $filter->getStudent());
  76.         }
  77.         
  78.         if ($filter && $filter->getClubform()) {
  79.             $qb->andWhere('c.clubform = :filterClubform')
  80.                     ->setParameter('filterClubform', $filter->getClubform());
  81.         }
  82.         
  83.         return (int) $qb->getQuery()->getSingleScalarResult();
  84.     }
  86. //    /**
  87. //     * @return SignedForm[] Returns an array of SignedForm objects
  88. //     */
  89. //    public function findByExampleField($value): array
  90. //    {
  91. //        return $this->createQueryBuilder('s')
  92. //            ->andWhere('s.exampleField = :val')
  93. //            ->setParameter('val', $value)
  94. //            ->orderBy('s.id', 'ASC')
  95. //            ->setMaxResults(10)
  96. //            ->getQuery()
  97. //            ->getResult()
  98. //        ;
  99. //    }
  101. //    public function findOneBySomeField($value): ?SignedForm
  102. //    {
  103. //        return $this->createQueryBuilder('s')
  104. //            ->andWhere('s.exampleField = :val')
  105. //            ->setParameter('val', $value)
  106. //            ->getQuery()
  107. //            ->getOneOrNullResult()
  108. //        ;
  109. //    }
  110. }