AppBundle\Repository\UserRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

62.86%

Importance

Changes	2
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	loadUserByUsername()	0	8	1
A	loadUserByEmail()	0	8	1
A	loadUserByToken()	0	8	1
A	selectUsersByParams()	0	18	2
A	selectNotBlocked()	0	8	1

<?php

namespace AppBundle\Repository;

use Doctrine\ORM\Query;
use AppBundle\Entity\DTO\Filter;
use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;

/**
 * UserRepository.
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class UserRepository extends \Doctrine\ORM\EntityRepository implements UserLoaderInterface
{
    public function loadUserByUsername($username)
    {
        return $this->createQueryBuilder('user')
            ->andWhere('user.apiToken = :username')
            ->setParameter('username', $username)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function loadUserByEmail($email)
    {
        return $this->createQueryBuilder('user')
            ->andWhere('user.email = :email')
            ->setParameter('email', $email)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function loadUserByToken($token)
    {
        return $this->createQueryBuilder('user')
            ->andWhere('user.apiToken = :token')
            ->setParameter('token', $token)
            ->getQuery()
            ->getOneOrNullResult();
    }

    /**
     * @param Filter $filter
     *
     * @return Query
     */
    public function selectUsersByParams(Filter $filter):Query
    {
        $postsQuery = $this->createQueryBuilder('u');
        if ($filter->name) {
            $postsQuery->where(
                $postsQuery->expr()->like('u.firstName', ':name')
            )
                ->orWhere(
                    $postsQuery->expr()->like('u.lastName', ':name')
                )
                ->orWhere(
                    $postsQuery->expr()->like('u.email', ':name')
                )
                ->setParameter('name', '%'.$filter->name.'%');
        }

        return $postsQuery->getQuery();
    }

    public function selectNotBlocked()
    {
        return $this->createQueryBuilder('u')
            ->andWhere('u.enabled = TRUE')
            ->orderBy('u.lastName')
            ->getQuery()
            ->getResult();
    }
}