UserRepository::selectUsersByParams() - Code Metrics - Inspection of "[WIP] Alpha1" - geekhub-php/serve-seattle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#30)

by nonanerz

created 2017-03-27 06:01 UTC

UserRepository::selectUsersByParams() A

↳ Parent: UserRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	3.0309

Importance

Changes

Metric	Value
c	0
b	0
f	0
dl	0
loc	18
ccs	4
cts	11
cp	0.3636
rs	9.4285
cc	2
eloc	11
nc	2
nop	1
crap	3.0309

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

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


1		<?php
2
3		namespace AppBundle\Repository;
4
5		use Doctrine\ORM\Query;
6		use AppBundle\Entity\DTO\Filter;
7		use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;
8
9		/**
10		* UserRepository.
11		*
12		* This class was generated by the Doctrine ORM. Add your own custom
13		* repository methods below.
14		*/
15		class UserRepository extends \Doctrine\ORM\EntityRepository implements UserLoaderInterface
16		{
17	4	public function loadUserByUsername($username)
18		{
19	4	return $this->createQueryBuilder('user')
20	4	->andWhere('user.apiToken = :username')
21	4	->setParameter('username', $username)
22	4	->getQuery()
23	4	->getOneOrNullResult();
24		}
25
26		/**
27		* @param Filter $filter
28		*
29		* @return Query
30		*/
31	3	public function selectUsersByParams(Filter $filter):Query
32		{
33	3	$postsQuery = $this->createQueryBuilder('u');
34	3	if ($filter->name) {
35		$postsQuery->where(
36		$postsQuery->expr()->like('u.firstName', ':name')
37		)
38		->orWhere(
39		$postsQuery->expr()->like('u.lastName', ':name')
40		)
41		->orWhere(
42		$postsQuery->expr()->like('u.email', ':name')
43		)
44		->setParameter('name', '%'.$filter->name.'%');
45		}
46
47	3	return $postsQuery->getQuery();
48		}
49
50		public function selectNotBlocked()
51		{
52		return $this->createQueryBuilder('u')
53		->andWhere('u.enabled = TRUE')
54		->orderBy('u.lastName')
55		->getQuery()
56		->getResult();
57		}
58		}
59

geekhub-php / serve-seattle

Pull Request — master (#30)

UserRepository::selectUsersByParams() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like