AppBundle\Repository\ModuleUserRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	73
Duplicated Lines	52.05 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

16.66%

Importance

Changes	7
Bugs	0	Features	6

5 Methods

Rating	Name	Duplication	Size	Complexity
A	findModuleUserFailed()	13	13	1
A	findModuleUserSuccess()	13	13	1
A	findModuleUserActive()	12	12	1
A	findInfoPassModules()	0	15	1
A	findModules()	0	11	1

<?php
/**
 * Created by PhpStorm.
 * User: device
 * Date: 23.02.16
 * Time: 10:06
 */

namespace AppBundle\Repository;


use AppBundle\Entity\ModuleUser;
use Doctrine\ORM\EntityRepository;

class ModuleUserRepository extends EntityRepository
{
    public function findModuleUserFailed($user)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('mu')
            ->select('mu, m, p')
            ->join('mu.passModules', 'p')
            ->join('mu.module', 'm')
            ->where('mu.user = :user')
            ->andWhere('mu.status = :failed')
            ->setParameter('user', $user)
            ->setParameter('failed', ModuleUser::STATUS_FAILED)
            ->getQuery()
            ->getResult();
    }

    public function findModuleUserSuccess($user)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('mu')
            ->select('mu, m, p')
            ->join('mu.passModules', 'p')
            ->join('mu.module', 'm')
            ->where('mu.user = :user')
            ->andWhere('mu.status = :success')
            ->setParameter('user', $user)
            ->setParameter('success', ModuleUser::STATUS_SUCCESS)
            ->getQuery()
            ->getResult();
    }

    public function findModuleUserActive($user)

This method seems to be duplicated in your project.

    {
        return $this->createQueryBuilder('mu')
            ->select('mu, m')
            ->join('mu.module', 'm')
            ->where('mu.user = :user')
            ->andWhere('mu.status = :active')
            ->setParameter('user', $user)
            ->setParameter('active', ModuleUser::STATUS_ACTIVE)
            ->getQuery()
            ->getResult();
    }

    public function findInfoPassModules($module)
    {
        return $this->createQueryBuilder('mu')
            ->select('mu, m, u, p')
            ->join('mu.module', 'm')
            ->join('mu.user', 'u')
            ->join('mu.passModules', 'p')
            ->where('mu.status <> :active')
            ->andWhere('mu.module = :module')
            ->orderBy('mu.rating', 'DESC')
            ->setParameter('active', ModuleUser::STATUS_ACTIVE)
            ->setParameter('module', $module)
            ->getQuery()
            ->getResult();
    }

    public function findModules($user)
    {
        return $this->createQueryBuilder('mu')
            ->select('mu, m, p')
            ->leftJoin('mu.passModules', 'p')
            ->leftJoin('mu.module', 'm')
            ->where('mu.user = :user')
            ->setParameter('user', $user)
            ->getQuery()
            ->getResult();
    }


}