chamilo / chamilo-lms

     *

     * @return int

     */

    public static function get_last_announcement_order($courseInfo)

    {

        if (empty($courseInfo)) {

            return 0;

        }

        $tbl_announcement = Database::get_course_table(TABLE_ANNOUNCEMENT);

        $course_id = $courseInfo['real_id'];

        $sql = "SELECT MAX(display_order)

                FROM $tbl_announcement

                WHERE c_id = $course_id ";

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

        $order = 0;

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

            $row_max = Database::fetch_array($res_max);

            $order = intval($row_max[0]) + 1;

        }

        return $order;

    }

    /**

     * Store an announcement in the database (including its attached file if any)

 * @param array $courseInfo

 * @return int

 */

function agendaExistsForWork($workId, $courseInfo)

{

    $workTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT);

    $courseId = $courseInfo['real_id'];

    $workId = intval($workId);

    $sql = "SELECT add_to_calendar FROM $workTable

            WHERE c_id = $courseId AND publication_id = ".$workId;

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

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

        $row = Database::fetch_array($res, 'ASSOC');

        if (!empty($row['add_to_calendar'])) {

            return $row['add_to_calendar'];

        }

    }

    return 0;

}

/**

 * Update work description, qualification, weight, allow_text_assignment