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. GuardianRegister::STATUS_DUPLICATE['value'],
  87. ])
  88. ->getQuery()
  89. ->getResult();
  90. }
  92. /**
  93. * Finds the most recent registration created before $registration that
  94. * shares one of its emails/phones and is still being worked on.
  95. *
  96. * @param string[] $emails
  97. * @param string[] $phoneSuffixes trailing digits matched against stored phones
  98. */
  99. public function findOpenOriginal(GuardianRegister $registration, array $emails, array $phoneSuffixes): ?GuardianRegister
  100. {
  101. $query = $this->createQueryBuilder('gr');
  102. $contactConditions = $query->expr()->orX();
  104. foreach (array_values($emails) as $index => $email) {
  105. $contactConditions->add("gr.email = :email{$index}");
  106. $contactConditions->add("gr.guardianEmail = :email{$index}");
  107. $query->setParameter("email{$index}", $email);
  108. }
  109. foreach (array_values($phoneSuffixes) as $index => $phoneSuffix) {
  110. $contactConditions->add("gr.phone LIKE :phone{$index}");
  111. $contactConditions->add("gr.guardianPhone LIKE :phone{$index}");
  112. $query->setParameter("phone{$index}", "%{$phoneSuffix}");
  113. }
  114. if (!$contactConditions->count()) {
  115. return null;
  116. }
  118. return $query
  119. ->andWhere($contactConditions)
  120. ->andWhere('gr.id < :currentId')
  121. ->setParameter('currentId', $registration->getId())
  122. ->andWhere('gr.status IN (:openStatuses)')
  123. ->setParameter('openStatuses', GuardianRegister::OPEN_STATUSES_FOR_DUPLICATE_CHECK)
  124. ->orderBy('gr.id', 'DESC')
  125. ->setMaxResults(1)
  126. ->getQuery()
  127. ->getOneOrNullResult();
  128. }
  130. // /**
  131. // * @return GuardianRegister[] Returns an array of GuardianRegister objects
  132. // */
  133. /*
  134. public function findByExampleField($value)
  135. {
  136. return $this->createQueryBuilder('g')
  137. ->andWhere('g.exampleField = :val')
  138. ->setParameter('val', $value)
  139. ->orderBy('g.id', 'ASC')
  140. ->setMaxResults(10)
  141. ->getQuery()
  142. ->getResult()
  143. ;
  144. }
  145. */
  147. /*
  148. public function findOneBySomeField($value): ?GuardianRegister
  149. {
  150. return $this->createQueryBuilder('g')
  151. ->andWhere('g.exampleField = :val')
  152. ->setParameter('val', $value)
  153. ->getQuery()
  154. ->getOneOrNullResult()
  155. ;
  156. }
  157. */
  158. }