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. * Finds other GuardianRegister rows for the same phone/email as $current
  51. * that never got their own Guardian linked and are still in an "open"
  52. * status. These are stale duplicate registration attempts left behind
  53. * once $current (or another sibling) converted into a Guardian.
  54. *
  55. * @return GuardianRegister[]
  56. */
  57. public function findOpenDuplicates(GuardianRegister $current, ?string $phone, ?string $email): array
  58. {
  59. $query = $this->createQueryBuilder('gr');
  60. $contactConditions = $query->expr()->orX();
  62. if ($phone) {
  63. $contactConditions->add('gr.phone = :phone');
  64. $contactConditions->add('gr.guardianPhone = :phone');
  65. $query->setParameter('phone', $phone);
  66. }
  67. if ($email) {
  68. $contactConditions->add('gr.email = :email');
  69. $contactConditions->add('gr.guardianEmail = :email');
  70. $query->setParameter('email', $email);
  71. }
  72. if (!$contactConditions->count()) {
  73. return [];
  74. }
  76. return $query
  77. ->andWhere($contactConditions)
  78. ->andWhere('gr.id <> :currentId')
  79. ->setParameter('currentId', $current->getId())
  80. ->andWhere('gr.guardian IS NULL')
  81. ->andWhere('gr.status NOT IN (:closedStatuses)')
  82. ->setParameter('closedStatuses', [
  83. GuardianRegister::STATUS_CONFIRMED['value'],
  84. GuardianRegister::STATUS_LOST['value'],
  85. GuardianRegister::STATUS_UNTARGETED['value'],
  86. ])
  87. ->getQuery()
  88. ->getResult();
  89. }
  91. // /**
  92. // * @return GuardianRegister[] Returns an array of GuardianRegister objects
  93. // */
  94. /*
  95. public function findByExampleField($value)
  96. {
  97. return $this->createQueryBuilder('g')
  98. ->andWhere('g.exampleField = :val')
  99. ->setParameter('val', $value)
  100. ->orderBy('g.id', 'ASC')
  101. ->setMaxResults(10)
  102. ->getQuery()
  103. ->getResult()
  104. ;
  105. }
  106. */
  108. /*
  109. public function findOneBySomeField($value): ?GuardianRegister
  110. {
  111. return $this->createQueryBuilder('g')
  112. ->andWhere('g.exampleField = :val')
  113. ->setParameter('val', $value)
  114. ->getQuery()
  115. ->getOneOrNullResult()
  116. ;
  117. }
  118. */
  119. }