chamilo / chamilo-lms

     * @author Isaac Flores <[email protected]>

     * @return array Contain glossary terms

     */

    public static function get_glossary_terms()

    {

        $glossary_data  = array();

        $glossary_table = Database::get_course_table(TABLE_GLOSSARY);

        $session_id = api_get_session_id();

        $sql_filter = api_get_session_condition($session_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT glossary_id as id, name, description

		        FROM $glossary_table

		        WHERE c_id = $course_id $sql_filter";

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

        while ($row = Database::fetch_array($rs)) {

            $glossary_data[] = $row;

        }

        return $glossary_data;

    }

    /**

     * Get glossary term by glossary id

     * @param int $sub_language_id The sub language id

     * @return array All information about sub-language

     */

    public static function get_all_information_of_sub_language($parent_id, $sub_language_id)

    {

        $table = Database::get_main_table(TABLE_MAIN_LANGUAGE);

        $parent_id = intval($parent_id);

        $sub_language_id = intval($sub_language_id);

        $sql = "SELECT * FROM $table 

                WHERE

                    parent_id = $parent_id AND

                    id = $sub_language_id";

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

        $all_information = array();

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $all_information = $row;

        }

        return $all_information;

    }

    /**

     * Get all information of language

     * @param array $groupInfo

     * @return array

     */

    public static function getTutors($groupInfo)

    {

        $groupTable = Database::get_course_table(TABLE_GROUP);

        $tutor_user_table = Database::get_course_table(TABLE_GROUP_TUTOR);

        $course_id = api_get_course_int_id();

        $group_id = intval($groupInfo['iid']);

        $sql = "SELECT user_id 

                FROM $tutor_user_table gu

                INNER JOIN $groupTable g

                ON (gu.group_id = g.id and g.c_id = gu.c_id)

                WHERE gu.c_id = $course_id AND g.iid = $group_id";

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

        $users = array();

        while ($obj = Database::fetch_object($res)) {

            $users[] = api_get_user_info($obj->user_id);

        }

        return $users;

    }

    /**

     * Get only students from a group (not tutors)

     * @param int $user_id

     * @return array

     */

    public static function get_user_group_name($user_id)

    {

        $table_group_user = Database::get_course_table(TABLE_GROUP_USER);

        $table_group = Database::get_course_table(TABLE_GROUP);

        $user_id = intval($user_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT name

                FROM $table_group g 

                INNER JOIN $table_group_user gu

                ON (gu.group_id = g.iid)

                WHERE

                  gu.c_id= $course_id AND

                  g.c_id= $course_id AND

                  gu.user_id = $user_id";

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

        $groups = array();

        while ($group = Database::fetch_array($res)) {

            $groups[] .= $group['name'];

        }

        return $groups;

    }

    /**

     * @param int $sessionId

     * @return array exercises

     */

    public function getExercisesByCourseSession($courseId, $sessionId)

    {

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $tbl_quiz = Database::get_course_table(TABLE_QUIZ_TEST);

        $sql = "SELECT * FROM $tbl_quiz cq

                WHERE

                    cq.c_id = %s AND

                    (cq.session_id = %s OR cq.session_id = 0) AND

                    cq.active = 0

                ORDER BY cq.id";

        $sql = sprintf($sql, $courseId, $sessionId);

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

        $rows = array();

        while ($row = Database::fetch_array($result, 'ASSOC')) {

            $rows[] = $row;

        }

        return $rows;

    }

    /**

     *