Completed
Pull Request — dev (#22)
by
unknown
03:24
created

UserRepository::selectUsersByParams()   A

Complexity

Conditions 2
Paths 2

Size

Total Lines 18
Code Lines 11

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 6

Importance

Changes 0
Metric Value
c 0
b 0
f 0
dl 0
loc 18
rs 9.4285
ccs 0
cts 17
cp 0
cc 2
eloc 11
nc 2
nop 1
crap 6
1
<?php
2
3
namespace AppBundle\Repository;
4
5
use Doctrine\ORM\Query;
6
use Symfony\Bridge\Doctrine\Security\User\UserLoaderInterface;
7
8
/**
9
 * UserRepository.
10
 *
11
 * This class was generated by the Doctrine ORM. Add your own custom
12
 * repository methods below.
13
 */
14
class UserRepository extends \Doctrine\ORM\EntityRepository implements UserLoaderInterface
15
{
16
    public function loadUserByUsername($username)
17
    {
18
        return $this->createQueryBuilder('user')
19
            ->andWhere('user.apiToken = :username')
20
            ->setParameter('username', $username)
21
            ->getQuery()
22
            ->getOneOrNullResult();
23
    }
24
25
    /**
26
     * @param String $name
27
     * @return Query
28
     */
29
    public function selectUsersByParams(string $name):Query
30
    {
31
        $postsQuery = $this->createQueryBuilder('u');
32
        if ($name) {
33
            $postsQuery->where(
34
                $postsQuery->expr()->like('u.firstName', ':name')
35
            )
36
                ->orWhere(
37
                    $postsQuery->expr()->like('u.lastName', ':name')
38
                )
39
                ->orWhere(
40
                    $postsQuery->expr()->like('u.email', ':name')
41
                )
42
                ->setParameter('name', '%' . $name . '%');
43
        }
44
45
        return $postsQuery->getQuery();
46
    }
47
}
48