src/Repository/UserRepository.php line 20

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\User;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use Symfony\Component\Security\Core\Exception\UnsupportedUserException;
  9. use Symfony\Component\Security\Core\User\PasswordUpgraderInterface;
  10. use Symfony\Component\Security\Core\User\UserInterface;
  12. /**
  13.  * @method User|null find($id, $lockMode = null, $lockVersion = null)
  14.  * @method User|null findOneBy(array $criteria, array $orderBy = null)
  15.  * @method User[]    findAll()
  16.  * @method User[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  17.  */
  18. class UserRepository extends ServiceEntityRepository implements PasswordUpgraderInterface
  19. {
  20.     public function __construct(ManagerRegistry $registry)
  21.     {
  22.         parent::__construct($registry, User::class);
  23.     }
  25.     /**
  26.      * Used to upgrade (rehash) the user's password automatically over time.
  27.      */
  28.     public function upgradePassword(UserInterface $user, string $newEncodedPassword): void
  29.     {
  30.         if (!$user instanceof User) {
  31.             throw new UnsupportedUserException(sprintf('Instances of "%s" are not supported.', \get_class($user)));
  32.         }
  34.         $user->setPassword($newEncodedPassword);
  35.         $this->_em->persist($user);
  36.         $this->_em->flush();
  37.     }
  39.     public function loadUserByUsername($username)
  40.     {
  41.         return $this->createQueryBuilder('u')
  42.             ->where('u.username = :username OR u.email = :email')
  43.             ->setParameter('username', $username)
  44.             ->setParameter('email', $username)
  45.             ->getQuery()
  46.             ->getOneOrNullResult();
  47.     }
  50.     public function countRecentLoginAttempts($id)
  51.     {
  53.         return $this->createQueryBuilder('u')
  54.                     ->select('u.authentication_failure','u.locked')
  55.                     ->where('u.locked IS NOT NULL')
  56.                     ->andWhere('u.id = :id')
  57.                     ->setParameter('id', $id)
  58.                     ->getQuery()
  59.                     ->getOneOrNullResult()
  60.         ;
  61.     }
  63.     public function findEmailUser($id)
  64.     {
  65.         return $this->createQueryBuilder('u')
  66.                     ->select('u.email')
  67.                     ->andWhere('u.id =:id')
  68.                     ->setParameter('id', $id)
  69.                     ->getQuery()
  70.                     ->getOneOrNullResult();
  71.     }
  73.     public function findUserIsNotDelete()
  74.     {
  75.         return $this->createQueryBuilder('u')
  76.                     ->andWhere('u.isDelete =:etat')
  77.                     ->setParameter('etat', false)
  78.                     ->orderBy('u.id','DESC')
  79.                     ->getQuery()
  80.                     ->getResult();
  81.     }
  83.     // /**
  84.     //  * @return User[] Returns an array of User objects
  85.     //  */
  86.     /*
  87.     public function findByExampleField($value)
  88.     {
  89.         return $this->createQueryBuilder('u')
  90.             ->andWhere('u.exampleField = :val')
  91.             ->setParameter('val', $value)
  92.             ->orderBy('u.id', 'ASC')
  93.             ->setMaxResults(10)
  94.             ->getQuery()
  95.             ->getResult()
  96.         ;
  97.     }
  98.     */
  100.     /*
  101.     public function findOneBySomeField($value): ?User
  102.     {
  103.         return $this->createQueryBuilder('u')
  104.             ->andWhere('u.exampleField = :val')
  105.             ->setParameter('val', $value)
  106.             ->getQuery()
  107.             ->getOneOrNullResult()
  108.         ;
  109.     }
  110.     */
  111. }