Version 18 (modified by Bhaavan Merchant, 12 years ago) ( diff )


Google Summer of Code 2012 Project



This project aims to create a roster tool for the CERT service. This would involve a web interface where one could view time scheduling of volunteers. Volunteers could be reassigned using drag and drop features on the timetable as per need and requirement. The interface will highlight empty slots which require filling to the user. The client may then choose to fill these slots manually or take advantage of the autofill functionality of the application which will fill the slots for you.


Student Details

Bhaavan Merchant
bhaavanmerchant [at] gmail [dot[ com

Mentor Details

Dominic König
dominic [at] nursix [dot[ org
Forked repo:

Meeting Dates

5 June 2012 - Google Hangout
13 June 2012 - Google Hangout
20 June 2012 - Google Hangout (1900 UTC)
27 June 2012 - Google Hangout (1900 UTC)
6 July 2012 - #sahana-meeting (1900 UTC)
11 July 2012 - Google Hangout (1700 UTC)


Finalizing idea
Establishing contact with CERT members for review
Setting up a controller and view for the rostering tool
Building a UI similar to the one in blueprint
Creating a prototype of the rostering tool.
CSS to match the blueprint
Database structure finalized
Database definition done
CERT Review meeting for feedback
s3db for joining tables

Project Goals and Timeline

24th AprilGaining a better understanding of the eden codeFixing Bugs
27th AprilGaining a better understanding of the CERT code. Creating a skeletal module for implementing the full code. This will be accessible through a REST UriCode commit, accessible from
1st MayModified Proposal in conformation with the feedback receivedInteraction with the community to finalize the project Goals, and feedback; Modification of timeline if needed; Finalizing the details; Prioritizing the tasks
17th MayImplementing their demo examples and ensure proper functioningComparing all the required jQuery plugins, weighing their individual pros and cons, and choosing the right plugin
4th JuneAdmin can login and view admin panelLogin system, and creation of the views for users, and admin including the admin panel
10th JuneVolunteers' list populated from databasePopulate the volunteers list with volunteers which can be dragged and dropped to main grid
13th JuneOnly eligible volunteers are displayedShortening the list of volunteers based of filter criteria, distance parameter
17th JuneThe grid will show light blue color for slots which require fillingFilling the grid with blue color based on db query where timeslot is a part of an event requiring volunteer
29th JuneError message for conflicting allotmentChecking the new allotments for clashes with previous job role allotment
2nd JulySuccess message on submission of new rosterStoring new data into database
9th JulyAbility to view job allotment based on volunteer filterClicking on a volunteer should display his / her job allotment
15th JulyA volunteer can declare that he will be unavailable from time A to B, and thus, he cannot be assigned a job in that timeImplementing features like suggest a volunteer, and declaring unavailability by volunteer
22nd JulyThe software can autofill the timeslot roster on clicking auto fillAutofilling functionality
28th JulyImproved look and feel of the applicationWrite CSS
2nd AugustBuffer periodComplete any pending work
5th AugustImproved code structureCode cleanup and commenting
8th AugustSolved bugsFix typos, improve the flash messages and other metadata text.
10th AugustSolved BugsTesting
13th AugustProject completionComplete documentation, and submit report
Note: See TracWiki for help on using the wiki.