chamilo / chamilo-lms

 * @param int $id Numeric ID of the course

 * @return array The course info as an array formatted by api_format_course_array, including category.name

 */

function api_get_course_info_by_id($id = null)

{

    if (!empty($id)) {

        $id = intval($id);

        $course_table = Database::get_main_table(TABLE_MAIN_COURSE);

        $course_cat_table = Database::get_main_table(TABLE_MAIN_CATEGORY);

        $sql = "SELECT

                    course.*,

                    course_category.code faCode,

                    course_category.name faName

                FROM $course_table

                LEFT JOIN $course_cat_table

                ON course.category_code =  course_category.code

                WHERE course.id = $id";

        $result = Database::query($sql);

        $_course = array();

        if (Database::num_rows($result) > 0) {

            $course_data = Database::fetch_array($result);

            $_course = api_format_course_array($course_data);

        }

        return $_course;

    }

    global $_course;

    if ($_course == '-1') $_course = array();

    return $_course;

}

/**

 * Reformat the course array (output by api_get_course_info()) in order, mostly,

     * current course)

     * @return array The category

     */

    public static function get_category_from_group($group_id, $course_code = null)

    {

        $table_group = Database:: get_course_table(TABLE_GROUP);

        $table_group_cat = Database:: get_course_table(TABLE_GROUP_CATEGORY);

        if (empty($group_id)) {

            return array();

        }

        $course_info = api_get_course_info($course_code);

        $course_id = $course_info['real_id'];

        $group_id = intval($group_id);

        $sql = "SELECT gc.* FROM $table_group_cat gc, $table_group g

                WHERE

                    gc.c_id = $course_id AND

                    g.c_id = $course_id AND

                    gc.id = g.category_id AND g.id= $group_id

                LIMIT 1";

        $res = Database::query($sql);

        $cat = array();

        if (Database::num_rows($res)) {

            $cat = Database::fetch_array($res);

        }

        return $cat;

    }

    /**

     * Delete a group category