########################################################################################## JILS-31: Time Recorded/Estimated Bars ########################################################################################## Issue Type: New Feature ----------------------------------------------------------------------------------------- Issue Information ==================== Priority: Major Status: Closed Resolution: Done (2016-04-29 15:02:51) Project: Jira Issue Listing Script (JILS) Reported By: btasker Assigned To: btasker Affected Versions: - 0.01b Targeted for fix in version: - 0.01b Labels: TimeManagement, Time Estimate: 7 minutes Time Logged: 113 minutes ----------------------------------------------------------------------------------------- Issue Description ================== JIRA uses coloured bars to denote the time logged against an issue, as well as the original estimate etc. It's quite a good way to display, at a glance, the current status of an issue vs it's budgeted time, so I'd like to reproduce it within the HTML exports. Note: I'd already started when this issue was raised :) ----------------------------------------------------------------------------------------- Activity ========== ----------------------------------------------------------------------------------------- 2015-09-18 14:00:09 ----------------------------------------------------------------------------------------- btasker changed timespent from '0 minutes' to '55 minutes' ----------------------------------------------------------------------------------------- 2015-09-18 14:00:56 git ----------------------------------------------------------------------------------------- -- BEGIN QUOTE -- Repo: Jira-Issue-Listing Commit: e3c670fed6c9b5a4778bd326c615d651a3cafe21 Author: Ben Tasker > Date: Fri Sep 18 13:59:26 2015 +0100 Commit Message: Initial basic timebar functionality implemented for JILS-31 Modified (-)(+) ------- issue_page.php static/core.css utils.class.php -- END QUOTE -- *Webhook User-Agent* -- BEGIN SNIPPET -- GitHub-Hookshot/be3703b -- END SNIPPET -- https://github.com/bentasker/Jira-Issue-Listing/commit/e3c670fed6c9b5a4778bd326c615d651a3cafe21 ----------------------------------------------------------------------------------------- 2015-09-18 14:05:42 btasker ----------------------------------------------------------------------------------------- At the moment, you need to hover over the "Estimate" bar to find out what the original estimate was (and the system doesn't discern between 0 and not set). JIRA also displays a guide to the time remaining within the Estimate, which can also be quite useful. So, remaining tasks so far - Add annotations of the time the bar represents when _showtime_ is true - Add a bar to show the remaining time (again, only when _showtime_ is true) Check how well the implementation works with the responsiveness. ----------------------------------------------------------------------------------------- 2015-09-18 14:14:09 ----------------------------------------------------------------------------------------- btasker changed status from 'Open' to 'In Progress' ----------------------------------------------------------------------------------------- 2015-09-18 14:24:56 git ----------------------------------------------------------------------------------------- -- BEGIN QUOTE -- Repo: Jira-Issue-Listing Commit: 5a855b3717ae0a041a66a0d708a4a8682919fa27 Author: Ben Tasker > Date: Fri Sep 18 14:24:06 2015 +0100 Commit Message: Modified bars to use colour for empty values. See JILS-31 Modified (-)(+) ------- static/core.css utils.class.php -- END QUOTE -- *Webhook User-Agent* -- BEGIN SNIPPET -- GitHub-Hookshot/be3703b -- END SNIPPET -- https://github.com/bentasker/Jira-Issue-Listing/commit/5a855b3717ae0a041a66a0d708a4a8682919fa27 ----------------------------------------------------------------------------------------- 2015-09-18 14:43:14 btasker ----------------------------------------------------------------------------------------- I've got a basic implementation of the 'Remaining' bar created, but it seems the way JIRA records estimates isn't quite as I thought. I estimated this issue at 2h when created, and have made no changes to the estimate. With 55m logged, that should leave 1h5m remaining. Looking in the database though -- BEGIN SNIPPET -- mysql> select SUMMARY,TIMEORIGINALESTIMATE,TIMEESTIMATE,TIMESPENT from jiraissue WHERE ID=13918; +------------------------------+----------------------+--------------+-----------+ | SUMMARY | TIMEORIGINALESTIMATE | TIMEESTIMATE | TIMESPENT | +------------------------------+----------------------+--------------+-----------+ | Time Recorded/Estimated Bars | 7200 | 3900 | 3300 | +------------------------------+----------------------+--------------+-----------+ -- END SNIPPET -- 7200 seconds is 2 hours, so there's my original estimate. It looks like _TIMEESTIMATE_ is automatically adjusted down to represent whatever is left. So, we probably need to use _TIMEORIGINALESTIMATE_, but what happens if we change the estimate on an issue for some reason? Assuming that 'Time Estimate Remaining' isn't changed, we get the following result -- BEGIN SNIPPET -- mysql> select SUMMARY,TIMEORIGINALESTIMATE,TIMEESTIMATE,TIMESPENT from jiraissue WHERE ID=13918; +------------------------------+----------------------+--------------+-----------+ | SUMMARY | TIMEORIGINALESTIMATE | TIMEESTIMATE | TIMESPENT | +------------------------------+----------------------+--------------+-----------+ | Time Recorded/Estimated Bars | 9000 | 3900 | 3300 | +------------------------------+----------------------+--------------+-----------+ -- END SNIPPET -- In JIRA's UI, the 'Remaining' bar is clearly based on _TIMEESTIMATE_, so we just need to use that rather than performing calculations against it, but we'll need to refactor slightly to make the Estimate bar use _TIMEORIGINALESTIMATE_ ----------------------------------------------------------------------------------------- 2015-09-18 14:58:01 ----------------------------------------------------------------------------------------- btasker changed status from 'In Progress' to 'Open' ----------------------------------------------------------------------------------------- 2015-09-18 14:58:44 ----------------------------------------------------------------------------------------- btasker changed timespent from '55 minutes' to '98 minutes' ----------------------------------------------------------------------------------------- 2015-09-18 14:58:56 git ----------------------------------------------------------------------------------------- -- BEGIN QUOTE -- Repo: Jira-Issue-Listing Commit: 4bf32ca541087031b8654b543b48a6dc495bb0b9 Author: Ben Tasker > Date: Fri Sep 18 14:57:47 2015 +0100 Commit Message: Added 'Remaining' bar, and fixed field usage. See JILS-31 Modified (-)(+) ------- issue_page.php static/core.css utils.class.php -- END QUOTE -- *Webhook User-Agent* -- BEGIN SNIPPET -- GitHub-Hookshot/be3703b -- END SNIPPET -- https://github.com/bentasker/Jira-Issue-Listing/commit/4bf32ca541087031b8654b543b48a6dc495bb0b9 ----------------------------------------------------------------------------------------- 2015-09-18 15:24:49 ----------------------------------------------------------------------------------------- btasker changed timespent from '98 minutes' to '108 minutes' ----------------------------------------------------------------------------------------- 2015-09-18 15:24:56 git ----------------------------------------------------------------------------------------- -- BEGIN QUOTE -- Repo: Jira-Issue-Listing Commit: 10d42f25c911a11c8f857a0d4bfff182964b298e Author: Ben Tasker > Date: Fri Sep 18 15:24:12 2015 +0100 Commit Message: Added time annotations and did some styling. See JILS-31 Modified (-)(+) ------- static/core.css utils.class.php -- END QUOTE -- *Webhook User-Agent* -- BEGIN SNIPPET -- GitHub-Hookshot/be3703b -- END SNIPPET -- https://github.com/bentasker/Jira-Issue-Listing/commit/10d42f25c911a11c8f857a0d4bfff182964b298e ----------------------------------------------------------------------------------------- 2015-09-18 15:33:13 btasker ----------------------------------------------------------------------------------------- Have tested at a variety of screensizes, and seems to work well at all but very small (< 550 pixels). Have added a line to the media queries to address this. Otherwise doesn't seem to cause any issues and makes the page much more readable. ----------------------------------------------------------------------------------------- 2015-09-18 15:33:37 ----------------------------------------------------------------------------------------- btasker changed timespent from '108 minutes' to '113 minutes' ----------------------------------------------------------------------------------------- 2015-09-18 15:33:48 ----------------------------------------------------------------------------------------- btasker changed status from 'Open' to 'Resolved' ----------------------------------------------------------------------------------------- 2015-09-18 15:33:48 ----------------------------------------------------------------------------------------- btasker added 'Done' to resolution ----------------------------------------------------------------------------------------- 2015-09-18 15:33:53 ----------------------------------------------------------------------------------------- btasker changed status from 'Resolved' to 'Closed' ----------------------------------------------------------------------------------------- 2015-09-18 15:34:56 git ----------------------------------------------------------------------------------------- -- BEGIN QUOTE -- Repo: Jira-Issue-Listing Commit: 13c75126653015e96ad70d00d6aba32f6d0f15b4 Author: Ben Tasker > Date: Fri Sep 18 15:31:46 2015 +0100 Commit Message: Added some styling for very small screens. See JILS-31 Modified (-)(+) ------- static/core.css -- END QUOTE -- *Webhook User-Agent* -- BEGIN SNIPPET -- GitHub-Hookshot/be3703b -- END SNIPPET -- https://github.com/bentasker/Jira-Issue-Listing/commit/13c75126653015e96ad70d00d6aba32f6d0f15b4 ----------------------------------------------------------------------------------------- 2016-04-29 14:54:09 btasker ----------------------------------------------------------------------------------------- Re-opening to assign to a version ----------------------------------------------------------------------------------------- 2016-04-29 14:54:09 ----------------------------------------------------------------------------------------- btasker removed 'Done' from resolution ----------------------------------------------------------------------------------------- 2016-04-29 14:54:09 ----------------------------------------------------------------------------------------- btasker changed status from 'Closed' to 'Reopened' ----------------------------------------------------------------------------------------- 2016-04-29 14:55:19 btasker ----------------------------------------------------------------------------------------- Assigning to v0.01b ----------------------------------------------------------------------------------------- 2016-04-29 14:55:19 ----------------------------------------------------------------------------------------- btasker added '0.01b' to Version ----------------------------------------------------------------------------------------- 2016-04-29 14:55:19 ----------------------------------------------------------------------------------------- btasker added '0.01b' to Fix Version ----------------------------------------------------------------------------------------- 2016-04-29 15:02:51 btasker ----------------------------------------------------------------------------------------- Re-Closing ----------------------------------------------------------------------------------------- 2016-04-29 15:02:51 ----------------------------------------------------------------------------------------- btasker changed status from 'Reopened' to 'Resolved' ----------------------------------------------------------------------------------------- 2016-04-29 15:02:51 ----------------------------------------------------------------------------------------- btasker added 'Done' to resolution ----------------------------------------------------------------------------------------- 2016-04-29 15:02:56 ----------------------------------------------------------------------------------------- btasker changed status from 'Resolved' to 'Closed' ----------------------------------------------------------------------------------------- Worklog ======== ----------------------------------------------------------------------------------------- 2015-09-18 14:00:09 btasker 55 minutes ----------------------------------------------------------------------------------------- Trying a few things and settling on initial basic implementation ----------------------------------------------------------------------------------------- 2015-09-18 14:58:44 btasker 43 minutes ----------------------------------------------------------------------------------------- Inserting 'Remaining Bar' and fixing issues with source fields. Testing. ----------------------------------------------------------------------------------------- 2015-09-18 15:24:49 btasker 10 minutes ----------------------------------------------------------------------------------------- Added time annotations and did some basic styling ----------------------------------------------------------------------------------------- 2015-09-18 15:33:37 btasker 5 minutes ----------------------------------------------------------------------------------------- Testing responsive layout on small screen sizes.