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

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

     *

     * @return bool

     */

    public static function hasVersion($language, $version)

    {

        $table = Database::get_main_table(TABLE_MAIN_LEGAL);

        $language = intval($language);

        $version = intval($version);

        if (empty($language)) {

            return false;

        }

        $sql = "SELECT version FROM $table

                WHERE 

                    language_id = '$language' AND 

                    version = '$version'                

                LIMIT 1 ";

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

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

            return true;

        } else {

            return false;

        }

    }

    /**

     * @param string $content

     * @param int $annoucement_id

     * @return array

     */

    public static function get_by_id($course_id, $annoucement_id)

    {

        $annoucement_id = intval($annoucement_id);

        $course_id = $course_id ? intval($course_id) : api_get_course_int_id();

        $tbl_announcement = Database::get_course_table(TABLE_ANNOUNCEMENT);

        $tbl_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);

        $sql = "SELECT DISTINCT 

                    announcement.id, 

                    announcement.title, 

                    announcement.content

               FROM $tbl_announcement announcement

               INNER JOIN $tbl_item_property ip

               ON

                    announcement.id = ip.ref AND

                    announcement.c_id = ip.c_id

               WHERE

                    announcement.c_id = $course_id AND

                    ip.tool='announcement' AND

                    announcement.id = $annoucement_id

                ";

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

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

            return Database::fetch_array($result);

        }

        return [];

    }

    /**

     * this function gets all the groups of the course,

     * @param int $group_id 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";

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

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

        return $db_object->number_of_students;

    }

    /**

     * @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, $groupInfo)

    {

        if (empty($groupInfo)) {

            return false;

        }

        $table_group_tutor = Database::get_course_table(TABLE_GROUP_TUTOR);

        $user_id = intval($user_id);

        $group_id = intval($groupInfo['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

     *

     * @return bool

     */

    public static function deleteCategory($id)

    {

        $id = intval($id);

        if (empty($id)) {

            return false;

        }

        $table = Database::get_main_table(TABLE_TICKET_TICKET);

        $sql = "UPDATE $table SET category_id = NULL WHERE category_id = $id";

        Database::query($sql);

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY);

        $sql = "DELETE FROM $table WHERE id = $id";

        Database::query($sql);

        return true;

    }

    /**

     * @param int $categoryId

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