Smart\ContentBundle\Entity\Repository\CategoryRepository::getAllWithPublishedPosts()

Complexity

Conditions	1
Paths	1

Size

Total Lines

11

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

<?php
    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();
    }
}