Smart\ContentBundle\Entity\Repository\CategoryRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	getAllWithPublishedPosts()	0	11	1

<?php

namespace Smart\ContentBundle\Entity\Repository;

use Doctrine\ORM\EntityRepository;
use Smart\ContentBundle\Entity\Category;

/**
 * Nicolas Bastien <nicolas.bastien@smartbooster.io>
 */
class CategoryRepository extends EntityRepository
{
    /**
     * @param int|null $limit
     * @return Category[]
     */
    public function getAllWithPublishedPosts($limit = null)
    {
        return $this->createQueryBuilder('c')
            ->leftJoin('c.posts', 'p')
            ->andWhere('p.publishedAt IS NOT NULL')
            ->andWhere('p.enabled = 1')
            ->orderBy('c.title', 'ASC')
            ->setMaxResults($limit)
            ->getQuery()
            ->getResult();
    }
}