chamilo / chamilo-lms

     * @author Patrick Cool <[email protected]>, Ghent University

     * @version September 2007

     */

    public static function get_invitations($survey_code)

    {

        $course_id = api_get_course_int_id();

        // Database table definition

        $table_survey_invitation = Database::get_course_table(TABLE_SURVEY_INVITATION);

        $sql = "SELECT * FROM $table_survey_invitation

		        WHERE

		            c_id = $course_id AND

		            survey_code = '".Database::escape_string($survey_code)."'";

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

        $return = array();

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

            $return[$row['user']] = $row;

        }

        return $return;

    }

    /**

     * This function displays the form for searching a survey

     *

     * @return array

     */

    public static function getAllExerciseEventByExeId($exe_id)

    {

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $exe_id = intval($exe_id);

        $list = array();

        $sql = "SELECT * FROM $table_track_attempt

                WHERE exe_id = $exe_id

                ORDER BY position";

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

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

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

                $list[$row['question_id']][] = $row;

            }

        }

        return $list;

    }

    /**

     *

     *

     * @return array

     */

    public static function get_all_exercises_from_lp($lp_id, $course_id)

    {

        $lp_item_table = Database::get_course_table(TABLE_LP_ITEM);

        $course_id = intval($course_id);

        $lp_id = intval($lp_id);

        $sql = "SELECT * FROM $lp_item_table

                WHERE

                    c_id = $course_id AND

                    lp_id = '".$lp_id."' AND

                    item_type = 'quiz'

                ORDER BY parent_item_id, display_order";

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

        $my_exercise_list = array();

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

            $my_exercise_list[] = $row;

        }

        return $my_exercise_list;

    }

    /**

     * This function gets the comments of an exercise

 * @author Julio Montoya <[email protected]>

 * @return int user id

 */

function api_get_access_url_from_user($user_id) {

    $user_id = intval($user_id);

    $table_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $table_url          = Database::get_main_table(TABLE_MAIN_ACCESS_URL);

    $sql = "SELECT access_url_id

            FROM $table_url_rel_user url_rel_user

            INNER JOIN $table_url u

            ON (url_rel_user.access_url_id = u.id)

            WHERE user_id = ".intval($user_id);

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

    $list = array();

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

        $list[] = $row['access_url_id'];

    }

    return $list;

}

/**

 * Gets the status of a user in a course

 * @param int       $user_id

     * @param int $userId

     * @return array

     */

    public static function get_user_course_categories($userId = 0)

    {

        $userId = empty($userId) ? api_get_user_id() : (int) $userId;

        $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $sql = "SELECT * FROM $table_category 

                WHERE user_id = $userId

                ORDER BY sort ASC

                ";

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

        $output = array();

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

            $output[$row['id']] = $row;

        }

        return $output;

    }

    /**

     * Return an array the user_category id and title for the course $courseId for user $userId

     *

     * @return array

     */

    public static function getDeletedDocuments($courseInfo, $sessionId = 0)

    {

        $table = Database::get_course_table(TABLE_DOCUMENT);

        $courseId = $courseInfo['real_id'];

        $sessionCondition = api_get_session_condition($sessionId);

        $sql = "SELECT * FROM $table

                WHERE

                  path LIKE '%DELETED%' AND

                  c_id = $courseId

                  $sessionCondition

                ORDER BY path

        ";

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

        $files = array();

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

            $files[] = $document;

        }

        return $files;

    }

    /**

     * @param int $id

     * @param int $limit

     * @return array

     */

    public function searchByField($tag, $field_id, $limit = 10)

    {

        $field_id = intval($field_id);

        $limit = intval($limit);

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

        $sql = "SELECT DISTINCT id, option_display_text

                FROM {$this->table}

                WHERE

                    field_id = '".$field_id."' AND

                    option_value LIKE '%$tag%'

                ORDER BY option_value

                LIMIT 0, $limit

                ";

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

        $values = array();

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

            $values = Database::store_result($result, 'ASSOC');

        }

        return $values;

    }

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

     * @return array

     */

    public static function get_categories($course_code = null)

    {

        $course_info = api_get_course_info($course_code);

        $course_id = $course_info['real_id'];

        $table_group_cat = Database::get_course_table(TABLE_GROUP_CATEGORY);

        $sql = "SELECT * FROM $table_group_cat

                WHERE c_id = $course_id

                ORDER BY display_order";

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

        $cats = array();

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

            $cats[] = $cat;

        }

        return $cats;

    }

    /**

     * Get a group category

     * @param int $sessionId The session id

     * @return array

     */

    public static function getTotalUserCoursesInSession($sessionId)

    {

        $tableUser = Database::get_main_table(TABLE_MAIN_USER);

        $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        if (empty($sessionId)) {

            return [];

        }

        $sql = "SELECT 

                    COUNT(u.id) as count, 

                    u.id, 

                    scu.status status_in_session, 

                    u.status user_status

                FROM $table scu

                INNER JOIN $tableUser u 

                ON scu.user_id = u.id

                WHERE scu.session_id = ".intval($sessionId)."

                GROUP BY u.id";

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

        $list = array();

        while ($data = Database::fetch_assoc($result)) {

            $list[] = $data;

        }

        return $list;

    }

    /**

     * Returns list of a few data from session (name, short description, start

     *

     * @return array

     */

    public static function getCoursesInSession($sessionId)

    {

        if (empty($sessionId)) {

            return [];

        }

        $tblSessionRelCourse = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);

        $tblCourse = Database::get_main_table(TABLE_MAIN_COURSE);

        // list of course in this session

        $sql = "SELECT session_id, c.id

                FROM $tblSessionRelCourse src

                LEFT JOIN $tblCourse c

                ON c.id = src.c_id

                WHERE session_id = ".intval($sessionId);

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

        $listResultsCourseId = array();

        while ($data = Database::fetch_assoc($res)) {

            $listResultsCourseId[] = $data['id'];

        }

        return $listResultsCourseId;

    }

    /**

     * Return an array of courses in session for user