Moo\FlashCardBundle\Repository\Category

Complexity

Total Complexity

1

Size/Duplication

Total Lines	21
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	3
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	fetchCategories()	0	13	1

<?php

/*
 * This file is part of the Moo\FlashCardBundle package.
 *
 * (c) Mohamed Alsharaf <mohamed.alsharaf@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Moo\FlashCardBundle\Repository;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\Expr;

/**
 * Category is a repository class for the card category entity.
 *
 * @author Mohamed Alsharaf <mohamed.alsharaf@gmail.com>
 */
class Category extends EntityRepository
{
    /**
     * Fetch active categories
     *
     * @return array
     */
    public function fetchCategories()
    {
        $builder = $this->getEntityManager()->createQueryBuilder();

        $builder
            ->select('p', 'c')
            ->from('MooFlashCardBundle:Category', 'p')
            ->join('p.cards', 'c', Expr\Join::WITH, 'c.active = 1')
            ->where('p.active = 1')
            ->orderBy('p.title', 'ASC');

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