Badger\Bundle\GameBundle\Doctrine\Repository\AdventureStepCompletionRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	57
Duplicated Lines	75.44 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	userAdventureCompletedSteps()	14	14	1
A	userAdventureClaimedSteps()	14	14	1
A	userCompletedSteps()	15	15	1

<?php

namespace Badger\Bundle\GameBundle\Doctrine\Repository;

use Badger\Component\Game\Model\AdventureInterface;
use Badger\Component\Game\Repository\AdventureStepCompletionRepositoryInterface;
use Badger\Component\User\Model\UserInterface;
use Doctrine\ORM\EntityRepository;

/**
 * @author  Adrien Pétremann <hello@grena.fr>
 * @license http://opensource.org/licenses/MIT The MIT License (MIT)
 */
class AdventureStepCompletionRepository extends EntityRepository implements AdventureStepCompletionRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function userAdventureCompletedSteps(UserInterface $user, AdventureInterface $adventure)

This method seems to be duplicated in your project.

    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('s')
            ->from('GameBundle:AdventureStep', 's')
            ->leftJoin('s.completions', 'sc')
            ->where('sc.user = :user')->setParameter(':user', $user)
            ->andWhere('s.adventure = :adventure')->setParameter(':adventure', $adventure)
            ->andWhere('sc.pending = 0');

        $queryResult = $qb->getQuery()->getResult();

        return $queryResult;
    }

    /**
     * {@inheritdoc}
     */
    public function userAdventureClaimedSteps(UserInterface $user, AdventureInterface $adventure)

This method seems to be duplicated in your project.

    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('s')
            ->from('GameBundle:AdventureStep', 's')
            ->leftJoin('s.completions', 'sc')
            ->where('sc.user = :user')->setParameter(':user', $user)
            ->andWhere('s.adventure = :adventure')->setParameter(':adventure', $adventure)
            ->andWhere('sc.pending = 1');

        $queryResult = $qb->getQuery()->getResult();

        return $queryResult;
    }

    /**
     * {@inheritdoc}
     */
    public function userCompletedSteps(UserInterface $user)

This method seems to be duplicated in your project.

    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('a as adventure, COUNT(sc) as completions')
            ->from('GameBundle:Adventure', 'a')
            ->leftJoin('a.steps', 's')
            ->leftJoin('s.completions', 'sc')
            ->where('sc.user = :user')->setParameter(':user', $user)
            ->andWhere('sc.pending = 0')
            ->groupBy('s.adventure');

        $queryResult = $qb->getQuery()->getResult();

        return $queryResult;
    }
}