chamilo / chamilo-lms

     * @param bool $with_base_content Whether to include content from the course without session or not

     * @param array $id_list If you want to restrict the structure to only the given IDs

     */

    public function build_announcements(

        $session_id = 0,

        $courseId = 0,

        $with_base_content = false,

        $id_list = array()

    ) {

        $table = Database:: get_course_table(TABLE_ANNOUNCEMENT);

        $sessionCondition = api_get_session_condition(

            $session_id,

            true,

            $with_base_content

        );

        $sql = 'SELECT * FROM '.$table.'

                WHERE c_id = '.$courseId.' '.$sessionCondition;

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

        $table_attachment = Database:: get_course_table(

            TABLE_ANNOUNCEMENT_ATTACHMENT

        );

        while ($obj = Database::fetch_object($db_result)) {

            if (empty($obj->id)) {

                continue;

            }

            $sql = 'SELECT path, comment, filename, size

                    FROM '.$table_attachment.'

                    WHERE c_id = '.$courseId.' AND announcement_id = '.$obj->id.'';

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

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

            $att_path = $att_filename = $att_size = $atth_comment = '';

            if (!empty($attachment_obj)) {

                $att_path = $attachment_obj->path;

                $att_filename = $attachment_obj->filename;

                $att_size = $attachment_obj->size;

                $atth_comment = $attachment_obj->comment;

            }

            $announcement = new Announcement(

                $obj->id,

                $obj->title,

                $obj->content,

                $obj->end_date,

                $obj->display_order,

                $obj->email_sent,

                $att_path,

                $att_filename,

                $att_size,

                $atth_comment

            );

            $this->course->add_resource($announcement);

        }

    }

    /**

     * Build the events

     * @param bool $with_base_content Whether to include content from the course without session or not

     * @param array $id_list If you want to restrict the structure to only the given IDs

     */

    public function build_events(

        $session_id = 0,

        $courseId = 0,

        $with_base_content = false,

        $id_list = array()

    ) {

        $table = Database:: get_course_table(TABLE_AGENDA);

        $sessionCondition = api_get_session_condition(

            $session_id,

            true,

            $with_base_content

        );

        $sql = 'SELECT * FROM '.$table.'

                WHERE c_id = '.$courseId.' '.$sessionCondition;

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

        while ($obj = Database::fetch_object($db_result)) {

            $table_attachment = Database:: get_course_table(

                TABLE_AGENDA_ATTACHMENT

            );

            $sql = 'SELECT path, comment, filename, size

                    FROM '.$table_attachment.'

                    WHERE c_id = '.$courseId.' AND agenda_id = '.$obj->id.'';

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

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

            $att_path = $att_filename = $att_size = $atth_comment = '';

            if (!empty($attachment_obj)) {

                $att_path = $attachment_obj->path;

                $att_filename = $attachment_obj->filename;

                $att_size = $attachment_obj->size;

                $atth_comment = $attachment_obj->comment;

            }

            $event = new CalendarEvent(

                $obj->id,

                $obj->title,

                $obj->content,

                $obj->start_date,

                $obj->end_date,

                $att_path,

                $att_filename,

                $att_size,

                $atth_comment,

                $obj->all_day

            );

            $this->course->add_resource($event);

        }

    }

    /**

     * Build the course-descriptions