App\Users\Repository\UserRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	loadUserByUsername()	0	10	1
A	isUserExists()	0	11	1

<?php
declare(strict_types=1);

namespace App\Users\Repository;

use App\Users\Entity\User;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Symfony\Bridge\Doctrine\RegistryInterface;
use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * @method User|null find($id, $lockMode = null, $lockVersion = null)
 * @method User|null findOneBy(array $criteria, array $orderBy = null)
 * @method User[]    findAll()
 * @method User[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class UserRepository extends ServiceEntityRepository implements UserLoaderInterface
{
    public function __construct(RegistryInterface $registry)
    {
        parent::__construct($registry, User::class);
    }

    /**
     * @param string $username
     * @return User|null
     * @throws \Doctrine\ORM\NonUniqueResultException
     */
    public function loadUserByUsername($username): ?User
    {
        $username = mb_strtolower($username);
        return $this->createQueryBuilder('u')
            ->where('LOWER(u.username) = :username OR LOWER(u.email) = :email')
            ->setParameter('username', $username)
            ->setParameter('email', $username)
            ->getQuery()
            ->getOneOrNullResult();
    }

    /**
     * @param array $criteria
     * @return mixed
     */
    public function isUserExists(array $criteria)
    {
        $field = key($criteria);
        $value = mb_strtolower(reset($criteria));

        return $this->createQueryBuilder('u')
            ->where("LOWER(u.{$field}) = :value")
            ->setParameter('value', $value)
            ->getQuery()
            ->getResult();
    }
}