src/FMT/Data/Repository/UserSchoolRepository.php line 27

Open in your IDE?
  1. <?php
  3. namespace FMT\Data\Repository;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Doctrine\Common\Collections\ArrayCollection;
  7. use Doctrine\ORM\NonUniqueResultException;
  8. use Doctrine\ORM\Query;
  9. use Doctrine\ORM\QueryBuilder;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use FMT\Data\Entity\User;
  12. use FMT\Data\Entity\UserSchool;
  13. use FMT\Domain\Repository\UserSchoolRepositoryInterface;
  14. use Symfony\Component\Security\Core\User\UserInterface;
  16. /**
  17.  * @method UserSchool|null find($id, $lockMode = null, $lockVersion = null)
  18.  * @method UserSchool|null findOneBy(array $criteria, array $orderBy = null)
  19.  * @method UserSchool[]    findAll()
  20.  * @method UserSchool[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  21.  */
  22. class UserSchoolRepository extends DoctrineRepository implements UserSchoolRepositoryInterface
  23. {
  24.     private EntityManagerInterface $entityManager;
  25.     
  26.     
  27.     public function __construct(ManagerRegistry $registry,EntityManagerInterface $entityManager)
  28.     {
  29.         parent::__construct($registry, UserSchool::class);
  30.         $this->entityManager = $entityManager;
  31.     }
  33.     public function findWithMajors(int $schoolId): ?UserSchool
  34.     {
  35.         return $this->createQueryBuilder('us')
  36.             ->leftJoin('us.userMajors', 'um')
  37.             ->addSelect('um')
  38.             ->where('us.id = :id')
  39.             ->setParameter('id', $schoolId)
  40.             ->getQuery()
  41.             ->getOneOrNullResult();
  42.     }
  44.     /**
  45.      * @param array $criteria
  46.      * @return array|UserSchool[]
  47.      * @deprecated
  48.      */
  49.     public function findAllBy(array $criteria)
  50.     {
  51.         return $this->findBy($criteria);
  52.     }
  54.     /**
  55.      * @param bool $activeOnly
  56.      * @return ArrayCollection
  57.      */
  58.     public function getSchoolsCollection(?UserInterface $user, $activeOnly = false): ArrayCollection
  59.     {
  60.         $userSchool = $user instanceof UserInterface ? $user->getProfile()->getSchool() : null;
  62.         $result = $this->getSchoolsQuery($activeOnly)
  63.             ->orWhere('us.id = :userSchool')
  64.             ->setParameter('userSchool', $userSchool)
  65.             ->getQuery()
  66.             ->execute();
  68.         return is_array($result) ? new ArrayCollection($result) : $result;
  69.     }
  71.     /**
  72.      * @param bool $activeOnly
  73.      * @return QueryBuilder
  74.      */
  75.     private function getSchoolsQuery($activeOnly = false)
  76.     {
  77.         $qb = $this->createQueryBuilder("us");
  79.         if ($activeOnly) {
  80.             $qb->where("us.active = true");
  81.         }
  83.         return $qb;
  84.     }
  86.     /**
  87.      * @param bool $activeOnly
  88.      * @return array|ArrayCollection|int|string
  89.      */
  90.     public function getSchools($activeOnly = false)
  91.     {
  92.         return $this->getSchoolsQuery($activeOnly)->getQuery()->getResult();
  93.     }
  95.     public function getSchoolForTransfer(): ?UserSchool
  96.     {
  97.         $query = $this->createQueryBuilder('userSchool');
  99.         return $query->leftJoin('userSchool.userSchoolTransferAttempts', 'uu')
  100.             ->leftJoin('userSchool.userSchoolSettings', 'us')
  101.             ->orderBy('uu.updatedAt')
  102.             ->where('us.apiId IS NOT NULL')
  103.             ->andWhere('us.accessToken IS NOT NULL')
  104.             ->andWhere('us.stripeCustomerId IS NOT NULL')
  105.             ->andWhere('userSchool.active = true')
  106.             ->setMaxResults(1)
  107.             ->getQuery()
  108.             ->getOneOrNullResult();
  109.     }
  111.     /**
  112.      * @param int $bookstoreId
  113.      * @return UserSchool|null
  114.      * @throws NonUniqueResultException
  115.      */
  116.     public function getActiveSchoolByBookstore(int $bookstoreId): ?UserSchool
  117.     {
  118.         return $this->createQueryBuilder('userSchool')
  119.             ->where('userSchool.active = true')
  120.             ->andWhere('userSchool.bookstoreId = :bookstoreId')
  121.             ->setParameter('bookstoreId', $bookstoreId)
  122.             ->getQuery()
  123.             ->getOneOrNullResult();
  124.     }
  125. }