Ticket #303 (Closed: fixed)

Implement popup loader functionality into campsite. Allow files to be attached to articles. Ability to delete files that are attached to articles. Add syntax to template language to allow these files to be displayed on the frontend.

Administration interface

• the editor will be able to add/delete attachments to/from an article
• the administration interface will detect the mime type automatically; if it can't it will allow the editor to set it
• the attachment will have the following metadata editable by the journalist: file name, mime type, short description
• the attachment can be inserted into the article body fields

Template engine

The web designer will be able to:

• list article attachments: will list all the attachments for the current language + attachments that do not have a language associated
• print attachment file name, mime type, description, URL, size
• implement 'if attachment type', 'if attachment fileName'

Technical specs

The attachments directory structure is: HTML_DIR/attachments/[year]/[month]/[day]/[attachment_id].[extension]

Where :

• year/month/day are the time the attachment was created
• attachment_id is padded to 9 digits and cooresponds to the ID in the database
• extension is the original extension of the file name

Tables:

• Attachments: id, fk_language_id, file_name, extension, is_attachment, charset, mime_type, size_in_bytes, fk_description_id, last_modified, time_created
• ArticleAttachments: fk_article_number, fk_attachment_id
• Translations: id, phrase_id, fk_language_id, translation_text

Attachments: id is autoincrement, fk_language_id may be null and tells the language of the attachment (if any), file_name, mime_type, size_in_bytes, last_modified, and time_created are self explanatory. fk_description_id identifies the phrase_id in translations table.

ArticleAttachments links articles to attachments.

Translations table holds text that can be translated: phrase_id is the phrase identifier, fk_language_id tells the language in which the text was translated and translation_text contains the value.