AppBundle\Repository\UserRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	selectUsersByParams()	0	19	4
A	loadUserByUsername()	0	8	1

<?php

namespace AppBundle\Repository;

use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;
use Symfony\Component\HttpFoundation\ParameterBag;

/**
 * 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();
    }

    /**
     * @param ParameterBag $params
     * @return array
     */
    public function selectUsersByParams(ParameterBag $params):array
    {
        $postsQuery = $this->createQueryBuilder('Users')
            ->select('u')
            ->from('AppBundle:User', 'u')
            ->orderBy('u.createdAt', preg_match('/asc/i', $params->get('order')) ? 'ASC' : 'DESC');

        if ($params->has('name') && $params->get('name')) {
            $postsQuery->where(
                $postsQuery->expr()->like('u.firstName', ':name')
            )
                ->orWhere(
                    $postsQuery->expr()->like('u.lastName', ':name')
                )
                ->setParameter('name', '%' . $params->get('name') . '%');
        }

        return $postsQuery->getQuery()->getResult();
    }
}