Chamilo\CourseBundle\Entity\Repository\CWikiCategoryRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	countByCourse()	0	3	1
A	findByCourse()	0	3	1
A	buildCourseTree()	0	17	3

<?php

/* For licensing terms, see /license.txt */

namespace Chamilo\CourseBundle\Entity\Repository;

use Chamilo\CoreBundle\Entity\Course;
use Chamilo\CoreBundle\Entity\Session;
use Gedmo\Tree\Entity\Repository\NestedTreeRepository;

class CWikiCategoryRepository extends NestedTreeRepository
{
    public function findByCourse(Course $course, ?Session $session): array
    {
        return $this->findBy(['course' => $course, 'session' => $session], ['lft' => 'ASC']);
    }

    public function countByCourse(Course $course, ?Session $session): int
    {
        return $this->count(['couse' => $course, 'session' => $session]);
    }

    /**
     * @return array|string
     */
    public function buildCourseTree(Course $course, ?Session $session, array $options = [])
    {
        $whereParams = ['course' => $course];

        if ($session) {
            $whereParams['session'] = $session;
        }

        $qb = $this->createQueryBuilder('c')
            ->where('c.course = :course')
            ->andWhere($session ? 'c.session = :session' : 'c.session IS NULL')
            ->orderBy('c.lft', 'ASC')
            ->setParameters($whereParams)
            ->getQuery()
        ;

        return $this->buildTree($qb->getArrayResult(), $options);
    }
}