chamilo / chamilo-lms

     * @param string Order direction

     * @return array Results

     */

    public static function get_course_data_tracking_overview($from, $number_of_items, $column, $direction)

    {

        $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);

        $from = intval($from);

        $number_of_items = intval($number_of_items);

        $sql = "SELECT code AS col0, title AS col1 FROM $main_course_table";

        $sql .= " ORDER BY col$column $direction ";

        $sql .= " LIMIT $from,$number_of_items";

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

        $return = array ();

        while ($course = Database::fetch_row($result)) {

            $return[] = $course;

        }

        return $return;

    }

    /**

     * Fills in course reporting data

     * @return array An array with all available system announcements (as php

     * objects)

     */

    public static function get_all_announcements()

    {

        $table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);

        $now = api_get_utc_datetime();

        $sql = "SELECT *, IF ( '$now'  >= date_start AND '$now' <= date_end, '1', '0') AS visible

                FROM $table";

        $current_access_url_id = 1;

        if (api_is_multiple_url_enabled()) {

            $current_access_url_id = api_get_current_access_url_id();

        }

        $sql .= " WHERE access_url_id = '$current_access_url_id' ";

        $sql .= " ORDER BY date_start ASC";

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

        $all_announcements = array();

        while ($announcement = Database::fetch_object($announcements)) {

            $all_announcements[] = $announcement;

        }

        return $all_announcements;

    }

    /**

     * Adds an announcement to the database