chamilo / chamilo-lms

     *

     * @return mixed

     */

    public static function getCategories($courseId)

    {

        $em = Database::getManager();

        //Default behaviour

        /*$items = $em->getRepository('ChamiloCourseBundle:CLpCategory')->findBy(

            array('cId' => $course_id),

            array('name' => 'ASC')

        );*/

        // Using doctrine extensions

        /** @var SortableRepository $repo */

        $repo = $em->getRepository('ChamiloCourseBundle:CLpCategory');

        $items = $repo

            ->getBySortableGroupsQuery(['cId' => $courseId])

            ->getResult();

        return $items;

    }

    /**

     * @param int $id

     * @param int $courseId

     * @return array

     */

    public static function getCategoryByCourse($courseId)

    {

        $em = Database::getManager();

        $items = $em->getRepository('ChamiloCourseBundle:CLpCategory')->findBy(

            array('cId' => $courseId)

        );

        return $items;

    }