Completed
Push — master ( 858bee...ca95b0 )
by Pavel
10s
created

UserRepository::findCountUsers()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 9
Code Lines 7

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 7
CRAP Score 1

Importance

Changes 1
Bugs 0 Features 0
Metric Value
c 1
b 0
f 0
dl 0
loc 9
ccs 7
cts 7
cp 1
rs 9.6666
cc 1
eloc 7
nc 1
nop 0
crap 1
1
<?php
2
3
namespace AppBundle\Repository;
4
use AppBundle\Entity\User;
5
6
/**
7
 * UserRepository
8
 *
9
 * This class was generated by the Doctrine ORM. Add your own custom
10
 * repository methods below.
11
 */
12
class UserRepository extends \Doctrine\ORM\EntityRepository
13
{
14 1
    public function findUsersWithoutRole($role)
15
    {
16 1
        return $this->createQueryBuilder('user')
17 1
            ->andWhere('user.role <> :role')
18 1
            ->setParameter('role', $role)
19 1
            ->getQuery()
20
         //   ->getResult()
21 1
            ;
22
    }
23
24 1
    public function findChoiceModules($module)
25
    {
26 1
        return $this->createQueryBuilder('u')
27 1
            ->where('u.chosenModule LIKE :module')
28 1
            ->setParameter('module', '%"'.$module.'"%')
29 1
            ->getQuery()
30 1
            ->getResult();
31
    }
32
33 1
    public function findCountUsers()
34
    {
35 1
        return $this->createQueryBuilder('u')
36 1
            ->select('COUNT(u.id) as count_u')
37 1
            ->andWhere('u.role = :role')
38 1
            ->setParameter('role', User::ROLE_USER)
39 1
            ->getQuery()
40 1
            ->getOneOrNullResult();
41
    }
42
}
43