chamilo / chamilo-lms

     * @param int $userId

     * @return array

     */

    public static function getCourseAccessPerSessionAndUser($sessionId, $userId, $limit = null)

    {

        $table = Database:: get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);

        $sessionId = intval($sessionId);

        $userId = intval($userId);

        $sql = "SELECT * FROM $table

                WHERE session_id = $sessionId AND user_id = $userId";

        if (!empty($limit)) {

            $limit = intval($limit);

            $sql .= " LIMIT $limit";

        }

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

        return Database::store_result($result);

    }

    /**

     * Get information from the track_e_course_access table

     * Get the maximum display order of the thematic item

     * @return int	Maximum display order

     */

    public function get_max_thematic_item($use_session = true)

    {

        // Database table definition

        $tbl_thematic = Database :: get_course_table(TABLE_THEMATIC);

        $session_id   = api_get_session_id();

        if ($use_session) {

            $condition_session = api_get_session_condition($session_id);

        } else {

            $condition_session = '';

        }

        $course_id = api_get_course_int_id();

        $sql = "SELECT MAX(display_order)

                FROM $tbl_thematic

                WHERE c_id = $course_id AND active = 1 $condition_session";

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

        $row = Database::fetch_array($rs);

        return $row[0];

    }

    /**

     * Move a thematic

     * @param int $group_id

     * @return array

     */

    public static function getTutors($group_id)

    {

        $tutor_user_table = Database :: get_course_table(TABLE_GROUP_TUTOR);

        $course_id = api_get_course_int_id();

        $group_id = intval($group_id);

        $sql = "SELECT user_id FROM $tutor_user_table

                WHERE c_id = $course_id AND group_id = $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 $group_id

     * @return array

     */

    public static function getStudents($group_id)

    {

        $group_user_table = Database :: get_course_table(TABLE_GROUP_USER);

        $course_id = api_get_course_int_id();

        $group_id = intval($group_id);

        $sql = "SELECT user_id FROM $group_user_table

                WHERE c_id = $course_id AND group_id = $group_id";

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

        $users = array();

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

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

        }

        return $users;

    }

    /**

     * Returns users belonging to any of the group

     * @param int $group_id

     * @return int Number of students in the given group.

     */

    public static function number_of_students($group_id, $course_id = null)

    {

        $table_group_user = Database :: get_course_table(TABLE_GROUP_USER);

        $group_id = intval($group_id);

        if (empty($course_id)) {

            $course_id = api_get_course_int_id();

        } else {

            $course_id = intval($course_id);

        }

        $sql = "SELECT  COUNT(*) AS number_of_students

                FROM $table_group_user

                WHERE c_id = $course_id AND group_id = $group_id";

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

        $db_object = Database::fetch_object($db_result);

        return $db_object->number_of_students;

    }

    /**

     * Maximum number of students in a group

     * @param int $course_id

     * @return bool

     */

    public static function is_user_filled_survey($user_id, $survey_id, $course_id)

    {

        $table_survey_answer = Database :: get_course_table(TABLE_SURVEY_ANSWER);

        $user_id	= intval($user_id);

        $course_id	= intval($course_id);

        $survey_id	= intval($survey_id);

        $sql = "SELECT DISTINCT user FROM $table_survey_answer

                WHERE

                    c_id		= $course_id AND

                    user		= $user_id AND

                    survey_id	= $survey_id";

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

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

            return true;

        }

        return false;

    }

    /**

     * This function gets all the persons who have filled the survey