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

UserRepository   A

Complexity

Total Complexity 3

Size/Duplication

Total Lines 34
Duplicated Lines 0 %

Coupling/Cohesion

Components 0
Dependencies 3

Test Coverage

Coverage 0%

Importance

Changes 2
Bugs 0 Features 0
Metric Value
wmc 3
c 2
b 0
f 0
lcom 0
cbo 3
dl 0
loc 34
rs 10
ccs 0
cts 25
cp 0

2 Methods

Rating   Name   Duplication   Size   Complexity  
A loadUserByUsername() 0 8 1
A selectUsersByParams() 0 18 2
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