App\Users\Repository\UserRepository

Complexity

Total Complexity

7

Size/Duplication

Total Lines	86
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

97.37%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	loadUserByUsername()	0	11	1
A	loadUserByEmail()	0	8	1
A	getUsersByCriteria()	0	11	1
A	isUserExists()	0	19	3

<?php

declare(strict_types=1);

namespace App\Users\Repository;

use App\Users\Entity\User;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;
use Symfony\Bridge\Doctrine\RegistryInterface;
use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;

/**
 * @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
     *
     * @throws \Doctrine\ORM\NonUniqueResultException
     *
     * @return User|null
     */
    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 string $email
     *
     * @throws NonUniqueResultException
     *
     * @return User|null
     */
    public function loadUserByEmail(string $email): ?User
    {
        return $this->createQueryBuilder('u')
            ->where('u.email = :email')
            ->setParameter('email', $email)
            ->getQuery()
            ->getOneOrNullResult();
    }

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

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

    /**
     * I do not understand why getSingleScalarResult throws NoResultException but it does.
     *
     * @param array $criteria
     *
     * @return bool
     */
    public function isUserExists(array $criteria): bool
    {
        $field = key($criteria);
        $value = mb_strtolower($criteria[$field]);

        try {
            $user = $this->createQueryBuilder('u')
                ->where("LOWER(u.{$field}) = :value")
                ->setParameter('value', $value)
                ->getQuery()
                ->getSingleScalarResult();
        } catch (NonUniqueResultException $nonUniqueResultException) {
            return true;
        } catch (NoResultException $noResultException) {
            return false;
        }

        return $user !== null;
    }
}