Web Developer - Upgrade database driven site

Scope: Our monitoring website, [login to view URL], is built in Ruby on Rails using Heroku/git deployment and a Mongo database. This is an specification of the upgrades we would like done on our database/monitoring site, www.-----.com. Hourly estimates of each task are listed for reference only. Details will be provided as the selection process warrants. Debugging of items in this prospectus is included for a 45 day period after project completion. Pre-existing bugs are not covered in the scope of this project and will be assessed on an ad-hoc basis. Priorities indicated in [RED]. Major Upgrades: (44hr) ? [1] 16hr: Data retention policy for MongoDB. ? Only hold last 90 days for all units on raw data, hourly data, messages. Daily Summaries hold forever. ? Create .csv per unit, per day on Google Drive. The daily .csv should be all the raw data for that unit, for that day. An example of this is when you ' unitID/graphs -> download CSV' within 1 day, time relative. If you want a unit that is operational now, try 'Paso R' as the meta tag. I have attached an example in the reply email... ? [6] 4hr: Add new dashboard fields: Post-Filter Life, UV Life e.g. ? [5] 20hr: Email notice on low 'Life' values (Module,Pre-Filter, Post-Filter, REM, UV) (all users). If a unit has a low 'life' value (thresholds are already programmed for color on the UI) an email gets sent to any user associated with the unit. This is a different type of notification than the 'Error'. Module Life/Pre-Filter/Post-Filter/REM /UV based on time & volume ('Days' remaining). 30 day/15 day/5 day/today notifications. The nature of these values shouldn't jitter, they count down... and only get reset manually. However, if you could add something that only sends ONE email per day MAX for this sort of notification, that would be good. The trigger should be only when the value crosses the threshold. There should be a separate notification for each field 'crossing'. Also, they will only cross at the same time by coincidence. I will give you text for the emails... html TBD. We might get a little fancier with it... I'll probably want to add an 'Unsubscribe' button with each email that allows that user to opt-out of that particular group of notifications. (+4 hr?) Opt-out options: These 'life' notifications should be grouped together with a separate option for receiving them. 'Error' notifications are the other group. 'Connection' notifications are the last group (next item) See pic: ¿ [7] 4hr: Email notice on 'Offline' status (no data in the last 60 minutes). o Send once only per offline. (on/off flag?) We would like it limited to one email/24hr period. o I will provide text/html. o Opt out described above ('Connection' group). Minor Upgrades: (14hr) ? [9] 1hr: Add (Google) Analytics to site ? [4] 1hr: Add 'Recent Data' button to unit/detail which downloads last 24 hours of data (.csv) ? [8] 2hr: /graphs - auto-maximizing the graphing area to fit browser window. This only happens on page reload, not browser resizing in real time. We want the graphing area to maximize within the browser window... right now, it always starts at the same size (small). ? [8] 2hr: /graphs - color code 'daily summary' and 'hourly summary' items: ¿ [8] 1hr : /graphs - move 'Update Graphs' button to top of page, enable 'Enter' key stroke to 'Update Graphs'. Set the focus to the "Update Graphs" button by default. It will always update the graphs unless you click on something else first. ¿ [8] 3hr: Ability to name saved graphs ? [2] 2hr: 'Inactivity Indicator' - if a unit has not sent a data the last 5 minutes, highlight it gray. UI + data changes. + sorting. Datapoints nor messages. Although, if just datapoints is easier, that's fine too. ? [3] 2hr: 'Error Indicator' - if a unit has errored, highlight in RED. Assuming a unit "has errored" if the last contact is of "Error" type, and is cleared with any new status. + sor