chamilo / chamilo-lms

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

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