Changes between Version 11 and Version 12 of TeamCalendarPlugin
- Timestamp:
- May 1, 2015, 9:01:54 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TeamCalendarPlugin
v11 v12 1 1 [[PageOutline(2-5,Contents,pullout)]] 2 = Team calendar =3 2 4 == Description == 3 = Team calendar 4 5 == Description 5 6 6 7 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. … … 8 9 See also: GoogleCalendarPlugin, GanttCalendarPlugin, CalendarPlugin 9 10 10 == Bugs/Feature Requests ==11 == Bugs/Feature Requests 11 12 12 13 Existing bugs and feature requests for TeamCalendarPlugin are … … 16 17 [http://trac-hacks.org/newticket?component=TeamCalendarPlugin&owner=ChrisNelson new ticket]. 17 18 18 == Download == 19 [[TicketQuery(component=TeamCalendarPlugin&group=type,format=progress)]] 20 21 == Download 19 22 20 23 Download the zipped source from [download:teamcalendarplugin here]. 21 24 22 == Source ==25 == Source 23 26 24 27 You can check out TeamCalendarPlugin from [http://trac-hacks.org/svn/teamcalendarplugin here] using Subversion, or [source:teamcalendarplugin browse the source] with Trac. 25 28 26 == Prerequisites ==29 == Installation 27 30 28 Note that the plugin is currently tied to MySQL. Updates to make it more 29 database agnostic would be welcome. 30 ''See #4243 - MySQL Testers needed!'' 31 === Prerequisites 31 32 32 == Installation == 33 Note that the plugin is currently tied to MySQL. Updates to make it more database agnostic would be welcome. See #4243 - MySQL Testers needed! 34 35 === Installation steps 33 36 34 37 Install [http://trac.edgewall.org/wiki/TracPlugins#InstallingaTracPlugin as usual]. 35 38 36 Create table in database: (this is MySQL, sqlite version appreciated) 39 For MySQL, the table can be created as follows: 37 40 38 {{{ 39 #!sql 41 {{{#!sql 40 42 CREATE TABLE `team_availability` ( 41 `username` varchar(255) NOT NULL DEFAULT '',42 `ondate` dateNOT NULL DEFAULT '0000-00-00',43 `availability` float unsignedDEFAULT NULL,44 PRIMARY KEY (`username`, `ondate`)43 `username` VARCHAR(255) NOT NULL DEFAULT '', 44 `ondate` DATE NOT NULL DEFAULT '0000-00-00', 45 `availability` FLOAT UNSIGNED DEFAULT NULL, 46 PRIMARY KEY (`username`, `ondate`) 45 47 ); 46 48 }}} 47 49 48 For PostgreSQL 8.3, we created the table with:50 For PostgreSQL 8.3, the table can be created as follows: 49 51 50 {{{ 51 #!sql 52 {{{#!sql 52 53 CREATE TABLE team_availability ( 53 username varchar(255) NOT NULL DEFAULT '',54 ondate dateNOT NULL,55 availability floatDEFAULT NULL,56 PRIMARY KEY (username, ondate)54 username VARCHAR(255) NOT NULL DEFAULT '', 55 ondate DATE NOT NULL, 56 availability FLOAT DEFAULT NULL, 57 PRIMARY KEY (username, ondate) 57 58 ); 58 59 }}} 59 60 60 For Sqlite3 :61 For Sqlite3, the database and table can be created as follows: 61 62 {{{ 62 63 sqlite3 trac.db 63 64 }}} 64 65 65 {{{ 66 #!sql 66 {{{#!sql 67 67 CREATE TABLE team_availability ( 68 68 username text not null default '', 69 69 ondate date not null default (datetime('now')), 70 70 availability float default null, 71 PRIMARY KEY (username, ondate)71 PRIMARY KEY (username, ondate) 72 72 ); 73 73 }}} 74 == Under the hood ==75 74 76 This plugin adds a new tab, Team Calendar, to users with the TEAMCALENDAR_VIEW 75 == Under the hood 76 77 This plugin adds a new tab, Team Calendar, to users with the `TEAMCALENDAR_VIEW` 77 78 permission. This shows a simple tables with dates running down the rows 78 and team members across the columns. Users with TEAMCALENDAR_UPDATE_OWN79 and team members across the columns. Users with `TEAMCALENDAR_UPDATE_OWN` 79 80 permissions can change the state of the tick boxes under their own name, 80 and save the results. Users with TEAMCALENDAR_UPDATE_OTHERSpermission can81 and save the results. Users with `TEAMCALENDAR_UPDATE_OTHERS` permission can 81 82 update everyone's. 82 83 … … 87 88 e.g. half-day, but there is no UI for this at present. 88 89 89 The calendar does not do anything more by itself. However, the90 The calendar does not do anything else by itself. However, the 90 91 team_availability table can be used in reports. 91 92 92 == Recent Changes ==93 == Recent Changes 93 94 94 95 [[ChangeLog(teamcalendarplugin, 3)]] 95 96 96 == Author/Contributors ==97 == Author/Contributors 97 98 98 99 '''Author:''' [wiki:optilude] [[BR]] 99 '''Maintainer:''' [ wiki:ChrisNelson] [[BR]]100 '''Maintainer:''' [[Maintainer]] [[BR]] 100 101 '''Contributors:'''
