chamilo / chamilo-lms

     * 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

     * @return type

     * @assert ('') === false

     */

    public static function get_surveys($course_code, $session_id = 0)

    {

        $table_survey = Database :: get_course_table(TABLE_SURVEY);

        if (empty($course_code)) {

            return false;

        }

        $course_info = api_get_course_info($course_code);

        $session_condition = api_get_session_condition($session_id, true, true);

        $sql = "SELECT * FROM $table_survey

                WHERE c_id = {$course_info['real_id']} $session_condition ";

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

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

        return $result;

    }

    /**

     * Retrieves all the survey information

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

     * @todo use the function user_has_access that includes this function

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

     */

    public static function is_tutor_of_group($user_id, $group_id)

    {

        $table_group_tutor = Database :: get_course_table(TABLE_GROUP_TUTOR);

        $user_id = intval($user_id);

        $group_id = intval($group_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT * FROM $table_group_tutor

                WHERE 

                    c_id = $course_id AND 

                    user_id = $user_id AND 

                    group_id = $group_id";

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

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

            return true;

        } else {

            return false;

        }

    }

    /**

     * Is the user part of this group? This can be a tutor or a normal member

 * @param int $readonly

 * @return boolean true /false

 */

function update_existing_document($_course, $documentId, $filesize, $readonly = 0)

{

    $document_table = Database::get_course_table(TABLE_DOCUMENT);

    $documentId = intval($documentId);

    $filesize = intval($filesize);

    $readonly = intval($readonly);

    $course_id = $_course['real_id'];

    $sql = "UPDATE $document_table SET

            size = '$filesize',

            readonly = '$readonly'

			WHERE c_id = $course_id AND id = $documentId";

    if (Database::query($sql)) {

        return true;

    } else {

        return false;

    }

}

/**

 * This function updates the last_edit_date, last edit user id on all folders in a given path

     * @param bool $getAllSessions

     * @return mixed

     */

    public static function getCountForum(

        $courseId,

        $sessionId = 0,

        $getAllSessions = false

    ) {

        $forum = Database::get_course_table(TABLE_FORUM);

        if ($getAllSessions) {

            $sql = "SELECT count(*) as count

                    FROM $forum f

                    WHERE f.c_id = %s";

        } else {

            $sql = "SELECT count(*) as count

                    FROM $forum f

                    WHERE f.c_id = %s and f.session_id = %s";

        }

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

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

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

        return $row['count'];

    }

    /**

     * @param int $userId