web2project: web-based project management

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000143 [v1.2 Release (Closed)] Projects feature always 2009-04-28 00:06 2009-12-08 21:04
Reporter caseydk View Status public  
Assigned To caseydk
Priority high Resolution fixed  
Status closed   Product Version
Summary 0000143: Project % Complete Calculations
Description One of the single most important values that is calculated constantly is a Project's percent complete. While it's trivial for small projects, for larger projects - or on project list screens - it gets to be a non-trivial and often horribly painful calculation.

Since we already have "project_percent_complete" on the Projects table, we should be able to calculate and cache it.
Additional Information To ensure accurate information, this should value should be recalculated when
- we update any of that Project's Tasks have their duration or percent complete updated;
- we update any child Project of the current Project;
Tags No tags attached.
Attached Files

- Relationships
related to 0000086closedcaseydk v2.0 Release (Current) Percent Calculation with Subprojects 
related to 0000170closedcaseydk v1.2 Release (Closed) Cache Worked/Scheduled/Project Hours 
child of 0000142new Pending Requests System Performance Improvements 

-  Notes
(0000606)
caseydk (administrator)
2009-11-25 22:30

Updated to pre-calculate the project_percent_complete value instead of calculating it on the fly for every page load in r805;
Also added a migration to backfill all old project_percent_complete values;

- Issue History
Date Modified Username Field Change
2009-04-28 00:06 caseydk New Issue
2009-04-28 00:06 caseydk Relationship added child of 0000142
2009-04-28 00:08 caseydk Relationship added related to 0000086
2009-05-31 23:28 caseydk Relationship added related to 0000170
2009-06-08 20:43 caseydk Project Pending Requests => v1.1 Release (Closed)
2009-07-07 23:19 caseydk Priority high => low
2009-08-30 23:27 caseydk Status new => assigned
2009-08-30 23:27 caseydk Assigned To => caseydk
2009-09-09 00:54 caseydk Project v1.1 Release (Closed) => Pending Requests
2009-09-11 16:44 caseydk Project Pending Requests => v1.2 Release (Closed)
2009-11-17 22:42 caseydk Priority low => high
2009-11-25 22:30 caseydk Status assigned => resolved
2009-11-25 22:30 caseydk Resolution open => fixed
2009-11-25 22:30 caseydk Note Added: 0000606
2009-12-08 21:04 caseydk Status resolved => closed
2009-12-08 21:04 caseydk Fixed in Version => 1.2


Mantis 1.1.8[^]
Copyright © 2000 - 2009 Mantis Group
Powered by Mantis Bugtracker