= Team calendar = == Description == This plugin adds a new navigation tab, "Team calendar", that can be used to keep track of team availability in a project. The data is stored in the database, which means it can be used in reports and queries. == Bugs/Feature Requests == Existing bugs and feature requests for TeamCalendarPlugin are [report:9?COMPONENT=TeamCalendarPlugin here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=TeamCalendarPlugin&owner=optilude new ticket]. == Download == Download the zipped source from [download:teamcalendarplugin here]. == Source == You can check out TeamCalendarPlugin from [http://trac-hacks.org/svn/teamcalendarplugin here] using Subversion, or [source:teamcalendarplugin browse the source] with Trac. == Example == This plugin adds a new tab, Team Calendar, to users with the TEAMCALENDAR_VIEW permission. This shows a simple tables with dates running down the rows and team members across the columns. Users with TEAMCALENDAR_UPDATE_OWN permissions can change the state of the tick boxes under their own name, and save the results. Users with TEAMCALENDAR_UPDATE_OTHERS permission can update everyone's. The table is populated form the database, where the following table must be created: {{{ CREATE TABLE `team_availability` ( `username` varchar(255) NOT NULL DEFAULT '', `ondate` date NOT NULL DEFAULT '0000-00-00', `availability` float unsigned DEFAULT NULL, PRIMARY KEY (`username`,`ondate`) ); }}} Note that the plugin is currently tied to MySQL. Updates to make it more database agnostic would be welcome. The 'availability' column will contain 0 or 1 if populated through the GUI. It is left as a float to make it possible to store more granular availability, e.g. half-day, but there is no UI for this at present. The calendar does not do anything more by itself. However, the team_availability table can be used in reports. == Recent Changes == [[ChangeLog(teamcalendarplugin, 3)]] == Author/Contributors == '''Author:''' [wiki:optilude] [[BR]] '''Contributors:'''