chamilo / chamilo-lms

     * @param string $courseCode

     * @return array

     */

    public static function getGroupByName($name, $courseCode = null)

    {

        $name = trim($name);

        if (empty($name)) {

            return array();

        }

        $course_info = api_get_course_info($courseCode);

        $course_id = $course_info['real_id'];

        $name = Database::escape_string($name);

        $table_group = Database::get_course_table(TABLE_GROUP);

        $sql = "SELECT * FROM $table_group

                WHERE c_id = $course_id AND name = '$name'

                LIMIT 1";

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

        $group = array();

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

            $group = Database::fetch_array($res, 'ASSOC');

        }

        return $group;

    }

    /**

     * @param int $courseId

     * @param string $course_code The course (default = current course)

     * @return array

     */

    public static function getCategoryByTitle($title, $course_code = null)

    {

        $title = trim($title);

        if (empty($title)) {

            return array();

        }

        $course_info = api_get_course_info($course_code);

        $course_id = $course_info['real_id'];

        $title = Database::escape_string($title);

        $table_group_cat = Database::get_course_table(TABLE_GROUP_CATEGORY);

        $sql = "SELECT * FROM $table_group_cat

                WHERE c_id = $course_id AND title = '$title'

                LIMIT 1";

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

        $category = array();

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

            $category = Database::fetch_array($res, 'ASSOC');

        }

        return $category;

    }

    /**

     * Get the unique category of a given group

     * current course)

     * @return array The category

     */

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

    {

        $table_group = Database::get_course_table(TABLE_GROUP);

        $table_group_cat = Database::get_course_table(TABLE_GROUP_CATEGORY);

        $group_id = intval($group_id);

        if (empty($group_id)) {

            return array();

        }

        $course_info = api_get_course_info($course_code);

        if (empty($course_info)) {

            return false;

        }

        $course_id = $course_info['real_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.iid = $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

 * @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,