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

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

            array('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;

    }

    /**

     * @param int $id