src/Repository/GuardianRegister/GuardianRegisterRepository.php line 36

Open in your IDE?
  1. <?php
  3. namespace App\Repository\GuardianRegister;
  5. use App\Entity\GuardianRegister\GuardianRegister;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\ORM\QueryBuilder;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11. * @method GuardianRegister|null find($id, $lockMode = null, $lockVersion = null)
  12. * @method GuardianRegister|null findOneBy(array $criteria, array $orderBy = null)
  13. * @method GuardianRegister[] findAll()
  14. * @method GuardianRegister[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15. */
  16. class GuardianRegisterRepository extends ServiceEntityRepository
  17. {
  18. public function __construct(ManagerRegistry $registry)
  19. {
  20. parent::__construct($registry, GuardianRegister::class);
  21. }
  23. /**
  24. * Creates a new QueryBuilder instance that is prepopulated for this entity name.
  25. *
  26. * @param string $alias
  27. * @param string $indexBy The index for the from.
  28. *
  29. * @return QueryBuilder
  30. */
  31. public function createQueryBuilder($alias, $indexBy = null)
  32. {
  33. return $this->_em->createQueryBuilder()
  34. ->select($alias)
  35. ->from($this->_entityName, $alias, $indexBy)
  36. ->andWhere("${alias}.isDeleted = 0");
  37. }
  39. public function countNewRegistrations(): int
  40. {
  41. return (int) $this->createQueryBuilder('gr')
  42. ->select('COUNT(gr.id)')
  43. ->andWhere('gr.status = :status')
  44. ->setParameter('status', GuardianRegister::STATUS_NEW['value'])
  45. ->getQuery()
  46. ->getSingleScalarResult();
  47. }
  49. // /**
  50. // * @return GuardianRegister[] Returns an array of GuardianRegister objects
  51. // */
  52. /*
  53. public function findByExampleField($value)
  54. {
  55. return $this->createQueryBuilder('g')
  56. ->andWhere('g.exampleField = :val')
  57. ->setParameter('val', $value)
  58. ->orderBy('g.id', 'ASC')
  59. ->setMaxResults(10)
  60. ->getQuery()
  61. ->getResult()
  62. ;
  63. }
  64. */
  66. /*
  67. public function findOneBySomeField($value): ?GuardianRegister
  68. {
  69. return $this->createQueryBuilder('g')
  70. ->andWhere('g.exampleField = :val')
  71. ->setParameter('val', $value)
  72. ->getQuery()
  73. ->getOneOrNullResult()
  74. ;
  75. }
  76. */
  77. }