AppBundle\Repository\UserRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

100%

Importance

Changes	5
Bugs	0	Features	4

3 Methods

Rating	Name	Duplication	Size	Complexity
A	findUsersWithoutRole()	0	9	1
A	findChoiceModules()	0	8	1
A	findCountUsers()	0	9	1

<?php

namespace AppBundle\Repository;
use AppBundle\Entity\User;

/**
 * UserRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class UserRepository extends \Doctrine\ORM\EntityRepository
{
    public function findUsersWithoutRole($role)
    {
        return $this->createQueryBuilder('user')
            ->andWhere('user.role <> :role')
            ->setParameter('role', $role)
            ->getQuery()
         //   ->getResult()
            ;
    }

    public function findChoiceModules($module)
    {
        return $this->createQueryBuilder('u')
            ->where('u.chosenModule LIKE :module')
            ->setParameter('module', '%"'.$module.'"%')
            ->getQuery()
            ->getResult();
    }

    public function findCountUsers()
    {
        return $this->createQueryBuilder('u')
            ->select('COUNT(u.id) as count_u')
            ->andWhere('u.role = :role')
            ->setParameter('role', User::ROLE_USER)
            ->getQuery()
            ->getOneOrNullResult();
    }
}