User:Niharika (usurped)/IEG Review tool

Using this page to document progress and ideas about the IEG Review app.

See this link for more information about the complete expected workflow of the app.

I'm going to break down the expected features into (kind of) independent chunks and work on them one by one.

Assumptions

 * Only one campaign can run at a given time
 * App admin == Campaign admin
 * App reviewers == Campaign reviewers

Part 1

 * Add a campaigns table. Table holds data about all previous and current campaigns.
 * ID: INT(11)
 * Name: VARCHAR
 * Created by: User ID
 * Status(Status of campaign): ENUM ('active', 'archive')
 * Start date: TIMESTAMP
 * End date: TIMESTAMP
 * Created at: TIMESTAMP


 * Add a campaign ID field to proposals table. Every proposal belongs to a certain campaign.


 * Add a "View campaigns" report view.
 * Shows all past and current campaigns
 * Clicking on a campaign lists the proposals received for that campaign
 * Clicking on a proposal shows the proposal text and review text
 * In the report view, none of the proposals are editable


 * Add a Settings panel for Admin
 * Edit Start date for campaign (Originally set when starting new campaign)
 * Edit End date for campaign (Originally set when starting new campaign)
 * Start a new campaign: > Further work on this in next part of project.


 * Review queue should only show proposals from the current campaign