src/Repository/UserRepository.php line 26

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\OrderWarehouse;
  6. use App\Entity\Service;
  7. use App\Entity\User;
  8. use App\Entity\Warehouse;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\ORM\QueryBuilder;
  11. use Doctrine\Persistence\ManagerRegistry;
  12. use Symfony\Component\Security\Core\Exception\UnsupportedUserException;
  13. use Symfony\Component\Security\Core\User\PasswordUpgraderInterface;
  14. use Symfony\Component\Security\Core\User\UserInterface;
  16. /**
  17.  * @method User|null find($id, $lockMode = null, $lockVersion = null)
  18.  * @method User|null findOneBy(array $criteria, array $orderBy = null)
  19.  * @method User[]    findAll()
  20.  * @method User[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  21.  */
  22. class UserRepository extends ServiceEntityRepository implements PasswordUpgraderInterface
  23. {
  24.     public function __construct(ManagerRegistry $registry)
  25.     {
  26.         parent::__construct($registry, User::class);
  27.     }
  29.     /**
  30.      * Used to upgrade (rehash) the user's password automatically over time.
  31.      */
  32.     public function upgradePassword(UserInterface $user, string $newEncodedPassword): void
  33.     {
  34.         if (!$user instanceof User) {
  35.             throw new UnsupportedUserException(sprintf('Instances of "%s" are not supported.', \get_class($user)));
  36.         }
  38.         $user->setPassword($newEncodedPassword);
  39.         $this->_em->persist($user);
  40.         $this->_em->flush();
  41.     }
  43.     public function getQueryBuilderUserByOrderWarehouse(OrderWarehouse $orderWarehouse): QueryBuilder
  44.     {
  45.         return $this->createQueryBuilder('user')
  46.             ->innerJoin('user.create_orders', 'ordersWarehouse')
  47.             ->andWhere('ordersWarehouse = :orderWarehouse')
  48.             ->setParameter('orderWarehouse', $orderWarehouse);
  49.     }
  51.     public function findUsersEmailByWarehouse(Warehouse $orderWarehouse): array
  52.     {
  53.         $qb = $this->createQueryBuilder('user')
  54.             ->innerJoin('user.warehouses', 'ordersWarehouse')
  55.             ->andWhere('ordersWarehouse = :orderWarehouse')
  56.             ->setParameter('orderWarehouse', $orderWarehouse);
  58.         return $qb->getQuery()->execute();
  59.     }
  61.     public function findUsersByRole(string $role): array
  62.     {
  63.         $qb = $this->createQueryBuilder('user')
  64.             ->where('user.roles LIKE :role')
  65.             ->setParameter('role', '%'.$role.'%');
  67.         return $qb->getQuery()->execute();
  68.     }
  70.     public function findUsersEmailByService(?Service $service): array
  71.     {
  72.         $qb = $this->createQueryBuilder('user')
  73.             ->innerJoin('user.services', 'services')
  74.             ->andWhere('services IN (:service)')
  75.             ->setParameter('service', $service);
  77.         return $qb->getQuery()->execute();
  78.     }
  80.     public function findUserByEmail(string $email): ?User
  81.     {
  82.         return $this->createQueryBuilder('user')
  83.             ->where('user.email = :email')
  84.             ->setParameter('email', $email)
  85.             ->getQuery()
  86.             ->getOneOrNullResult();
  87.     }
  89.     public function persist(User $user): void
  90.     {
  91.         $this->getEntityManager()->persist($user);
  92.         $this->getEntityManager()->flush();
  93.     }
  94. }