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 here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out TeamCalendarPlugin from here using Subversion, or 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

[4674] by optilude on 10/30/08 16:10:02

Make table name configurable

[4670] by optilude on 10/30/08 14:46:08

Good bye world

[4659] by optilude on 10/29/08 20:50:11

Fix wording

[4658] by optilude on 10/29/08 20:48:54

Improve week handling and make display more configurable

Author/Contributors

Author: optilude
Contributors: