Badger\Bundle\GameBundle\Doctrine\Repository\AdventureRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	52
Duplicated Lines	80.77 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getAvailableAdventuresForUser()	21	21	2
A	getCompletedAdventuresForUser()	21	21	2

<?php

namespace Badger\Bundle\GameBundle\Doctrine\Repository;

use Badger\Component\Game\Repository\AdventureRepositoryInterface;
use Badger\Component\Game\Taggable\TaggableInterface;
use Doctrine\DBAL\Connection;
use Doctrine\ORM\EntityRepository;

/**
 * Doctrine implementation of repository for Adventure entities.
 *
 * @author  Marie Bochu <marie.bochu@akeneo.com>
 * @license http://opensource.org/licenses/MIT The MIT License (MIT)
 */
class AdventureRepository extends EntityRepository implements AdventureRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function getAvailableAdventuresForUser(TaggableInterface $user)

This method seems to be duplicated in your project.

    {
        $tagIds = [];
        foreach ($user->getTags() as $tag) {
            $tagIds[] = $tag->getId();
        }

        $qb = $this->createQueryBuilder('adventure');
        $qb->leftJoin('adventure.tags', 'tags')
            ->leftJoin('adventure.steps', 's')
            ->leftJoin('s.completions', 'sc', 'WITH', 'sc.user = :user AND sc.pending = 0')
            ->setParameter('user', $user)
            ->having('COUNT(sc) < COUNT(s)')
            ->andWhere('tags.id IN (:tagIds)')
            ->setMaxResults(15)
            ->groupBy('adventure.id')
            ->setParameter('tagIds', $tagIds, Connection::PARAM_STR_ARRAY)
        ;

        return $qb->getQuery()->getResult();
    }

    /**
     * {@inheritdoc}
     */
    public function getCompletedAdventuresForUser(TaggableInterface $user)

This method seems to be duplicated in your project.

    {
        $tagIds = [];
        foreach ($user->getTags() as $tag) {
            $tagIds[] = $tag->getId();
        }

        $qb = $this->createQueryBuilder('adventure');
        $qb->leftJoin('adventure.tags', 'tags')
            ->leftJoin('adventure.steps', 's')
            ->leftJoin('s.completions', 'sc', 'WITH', 'sc.user = :user AND sc.pending = 0')
            ->setParameter('user', $user)
            ->having('COUNT(sc) = COUNT(s)')
            ->andWhere('tags.id IN (:tagIds)')
            ->setMaxResults(15)
            ->groupBy('adventure.id')
            ->setParameter('tagIds', $tagIds, Connection::PARAM_STR_ARRAY)
        ;

        return $qb->getQuery()->getResult();
    }
}