Completed
Pull Request — master (#30)
by
unknown
03:43
created

UserRepository::selectUsersByParams()   A

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 0
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
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 1
    public function loadUserByUsername($username)
18
    {
19 1
        return $this->createQueryBuilder('user')
20 1
            ->andWhere('user.apiToken = :username')
21 1
            ->setParameter('username', $username)
22 1
            ->getQuery()
23 1
            ->getOneOrNullResult();
24
    }
25
26
    /**
27
     * @param Filter $filter
28
     * @return Query
29
     */
30 3
    public function selectUsersByParams(Filter $filter):Query
31
    {
32 3
        $postsQuery = $this->createQueryBuilder('u');
33 3
        if ($filter->name) {
34
            $postsQuery->where(
35
                $postsQuery->expr()->like('u.firstName', ':name')
36
            )
37
                ->orWhere(
38
                    $postsQuery->expr()->like('u.lastName', ':name')
39
                )
40
                ->orWhere(
41
                    $postsQuery->expr()->like('u.email', ':name')
42
                )
43
                ->setParameter('name', '%' . $filter->name . '%');
44
        }
45
46 3
        return $postsQuery->getQuery();
47
    }
48
}
49