Changes between Version 51 and Version 52 of TracJsGanttPlugin
- Timestamp:
- Sep 13, 2015, 12:20:25 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracJsGanttPlugin
v51 v52 71 71 * When making decisions about which ticket to schedule first, TracPM sorts the candidate tickets with `ITaskSorter.compareTasks()`.[[br]][[br]]`compareTasks()` is passed two hashes, the attributes of the two tickets to compare. Any attributes added or changed by `prepareTasks()` are available to `compareTasks()`. 72 72 73 {{{ 74 #!py 73 {{{#!py 75 74 class ITaskSorter(Interface): 76 75 # Process task list to precompute keys or otherwise make … … 113 112 * When scheduling a task, TracPM calls `IResourceCalendar.hoursAvailable()` to determine how much of a task can be done on a date. 114 113 115 {{{ 116 #!py 114 {{{#!py 117 115 class IResourceCalendar(Interface): 118 116 # Return the number of hours available for the resource on the … … 135 133 An interface for task schedulers exists, but is not yet well documented. 136 134 137 {{{ 138 #!py 135 {{{#!py 139 136 class ITaskScheduler(Interface): 140 137 # Schedule each the ticket in tickets with consideration for … … 193 190 With this data in place, you can show a Gantt chart of scheduled tickets with dates as in the database (`[[TracJSGanttChart(scheduled=1)]]`) or create reports of the scheduled tickets. 194 191 195 {{{ 196 #!sql 192 {{{#!sql 197 193 SELECT 198 194 p.value AS __color__, … … 201 197 priority, 202 198 description as _description, 203 est.value asest,204 act.value asact,199 est.value AS est, 200 act.value AS act, 205 201 -- This bit is specific to PostgreSQL 206 202 (SELECT to_date(to_timestamp((sched.finish/1000000))::text, 'YYYY-MM-DD')) AS due, 207 203 status 208 204 FROM ticket AS t 209 INNER JOIN schedule AS sched ON (t.id =sched.ticket)210 INNER JOIN enum AS p ON (p.name =t.priority AND p.type = 'priority')205 INNER JOIN schedule AS sched ON (t.id = sched.ticket) 206 INNER JOIN enum AS p ON (p.name = t.priority AND p.type = 'priority') 211 207 LEFT OUTER JOIN ticket_custom AS est ON 212 (t.id =est.ticket AND est.name='estimatedhours')208 (t.id = est.ticket AND est.name = 'estimatedhours') 213 209 LEFT OUTER JOIN ticket_custom AS act ON 214 (t.id =act.ticket AND act.name='totalhours')210 (t.id = act.ticket AND act.name = 'totalhours') 215 211 WHERE t.owner = '$USER' AND status <> 'closed' 216 212 ORDER BY due NULLS FIRST, p.value 217 213 }}} 214 215 == Bugs/Feature Requests 216 217 Existing bugs and feature requests for !TracJsGanttPlugin are [report:9?COMPONENT=TracJsGanttPlugin here]. 218 219 If you have any issues, create a [/newticket?component=TracJsGanttPlugin new ticket]. 220 221 [[TicketQuery(component=TracJsGanttPlugin&group=type,format=progress)]] 222 223 === Known issues 224 225 The following is a list of known issues: 226 [[TicketQuery(status=accepted&status=assigned&status=new&status=reopened&type=defect&component=TracJsGanttPlugin&col=id&col=summary&col=component&col=status&col=owner&col=type&col=priority&order=priority)]] 227 228 === Planned enhancements 229 230 1. Display a legend of task colors and their meaning, eg which milestone or owner they represent. 231 1. Allow some tasks to be open or closed by default. 232 1. Display critical path. 233 1. Display slack time. 234 235 == Source & Download 236 237 You can check out !TracJsGanttPlugin from [http://trac-hacks.org/svn/tracjsganttplugin here] using Subversion, or [source:tracjsganttplugin browse the source] with Trac. 238 239 Download the zipped source from [download:tracjsganttplugin here]. 218 240 219 241 == Installation … … 336 358 * The `goal_ticket_type` may be used to have a custom ticket type show up as milestones on the chart. If this field is not specified, only Trac milestones are displayed as milestones. 337 359 338 == Bugs/Feature Requests339 340 Existing bugs and feature requests for !TracJsGanttPlugin are [report:9?COMPONENT=TracJsGanttPlugin here].341 342 If you have any issues, create a [/newticket?component=TracJsGanttPlugin&owner=ChrisNelson new ticket].343 344 [[TicketQuery(component=TracJsGanttPlugin&group=type,format=progress)]]345 346 === Known issues347 348 The following is a list of known issues:349 [[TicketQuery(status=accepted&status=assigned&status=new&status=reopened&type=defect&component=TracJsGanttPlugin&col=id&col=summary&col=component&col=status&col=owner&col=type&col=priority&order=priority)]]350 351 === Planned enhancements352 353 1. Display a legend of task colors and their meaning, eg which milestone or owner they represent.354 1. Allow some tasks to be open or closed by default.355 1. Display critical path.356 1. Display slack time.357 358 == Source & Download359 360 You can check out !TracJsGanttPlugin from [http://trac-hacks.org/svn/tracjsganttplugin here] using Subversion, or [source:tracjsganttplugin browse the source] with Trac.361 362 Download the zipped source from [download:tracjsganttplugin here].363 364 360 === Recent Changes 365 361