Interactive media monitoring website for large national NGO

This website for an NGO in Tbilisi, Georgia, will store and display the results of our monitoring of newscasts of 9 Georgian television channels. The site will encourage user engagement and interaction with the data generated by TI’s work. List of pages with functionality - Home --> Editorial summary of last night’s news (and links to past summaries) --> Links to last night’s monitoring results for all 9 channels --> Site navigation --> Website logo --> Latest activity boxes (Twitter, FB, site comments, SMS, highest-rated news segment) - About --> Information about the project and the organizations and donor behind it --> Monitoring methodology --> Contact information - Blog --> Post blogs specifically written for this website --> Re-post media-related blog posts from TI Georgia’s main blog ([login to view URL]) - Channel View --> Display all news segments from a given channel, on a given date --> Allow side-by-side comparison to other channels on the given date --> Easy navigation to view past broadcasts --> Allow up/down voting and user comments on individual news segments (we like the interface used by [login to view URL] for live sports events) --> Automatically generated links to [login to view URL], where possible - Search / Filter --> Filter segments by date, channel, keyword, tag, rating - Popular segments --> Display most/least liked segments in past 24 hours/past week/month/ever --> Display most commented on segments in past 24 hours/past week/month/ever - Administration --> Allow monitors to submit monitoring results --> Allow site admin to moderate monitoring results --> Allow site admin to publish editorial summaries --> Allow site admin to edit content --> Allow site admin to publish blog posts --> Allow site admin to moderate comments --> Allow site admin to moderate SMSes --> Allow site admin to add / delete monitors and site users --> Provide admin with aggregate statistics about monitoring results suitable for analysis in an external program (CSV, XLS, etc.) Further required functionality - Monitoring Database --> News Segments (one segment is an uninterrupted report broadcast on a specific topic, a news broadcasts consists of a number of news segments) //--> TV Channel //--> Date //--> Start time //--> End time //--> Duration (=end time-start time) //--> Title //--> Summary //--> Identity of monitor filing the report //--> Tags (assigned by monitors or site admin) //--> Sequence in news broadcast (1st, 2nd, 3rd segment, etc.) //--> Public comments //--> Public rating (like/dislike, as YouTube) //--> Link to video (optional; default [login to view URL], and should be auto-generated if so). --> Event //--> An event to which a news segment refers //--> Site admin will assign monitor reports to events //--> Date //--> Title //--> Segments referring to this event - Users --> Deter multiple voting by one person (mildly) --> Provide badges for frequent site participants --> Easy integration with social media --> User comments should be immutable in the back-end, because we may want to use a user’s comment in our donor reports, even if that user has deleted their comment. --> Allow for anonymous comments - Editorial Summaries --> These are basically blog posts, written only by site admins - Automatically post SMS messages --> We will handle receiving and parsing SMSes in-house; we just need an easy way to push messages from our SMS server - Unicode --> The entire site (including user names and passwords) must be able to handle Unicode input, as most of the site’s content, including user-generated content, will be in Georgian. - Security --> HTTPS should be used for all connections by authenticated users --> The site, including the back-end for monitors, should not be