Changes between Version 12 and Version 13 of TeamCalendarPlugin
- Timestamp:
- Sep 3, 2015, 2:43:11 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TeamCalendarPlugin
v12 v13 15 15 16 16 If you have any issues, create a 17 [ http://trac-hacks.org/newticket?component=TeamCalendarPlugin&owner=ChrisNelson new ticket].17 [/newticket?component=TeamCalendarPlugin new ticket]. 18 18 19 19 [[TicketQuery(component=TeamCalendarPlugin&group=type,format=progress)]] … … 31 31 === Prerequisites 32 32 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!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 34 35 35 === Installation steps … … 60 60 61 61 For Sqlite3, the database and table can be created as follows: 62 {{{ 62 {{{#!sh 63 63 sqlite3 trac.db 64 64 }}} … … 66 66 {{{#!sql 67 67 CREATE TABLE team_availability ( 68 username text not null default'',69 ondate date not null default (datetime('now')),70 availability float default null,68 username TEXT NOT NULL DEFAULT '', 69 ondate DATE NOT NULL DEFAULT (DATETIME('now')), 70 availability FLOAT DEFAULT NULL, 71 71 PRIMARY KEY (username, ondate) 72 72 ); … … 75 75 == Under the hood 76 76 77 This plugin adds a new tab, Team Calendar, to users with the `TEAMCALENDAR_VIEW` 78 permission. This shows a simple tables with dates running down the rows 79 and team members across the columns. Users with `TEAMCALENDAR_UPDATE_OWN` 80 permissions can change the state of the tick boxes under their own name, 81 and save the results. Users with `TEAMCALENDAR_UPDATE_OTHERS` permission can 82 update everyone's. 77 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. 83 78 84 79 The table is populated form the team_availability table in the database. 85 80 86 81 The 'availability' column will contain 0 or 1 if populated through the GUI. 87 It is left as a float to make it possible to store more granular availability, 88 e.g. half-day, but there is no UI for this at present. 82 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. 89 83 90 The calendar does not do anything else by itself. However, the 91 team_availability table can be used in reports. 84 The calendar does not do anything else by itself. However, the team_availability table can be used in reports. 92 85 93 86 == Recent Changes