JILS-31: Time Recorded/Estimated Bars

Issue Information

Issue Type: New Feature
 
Priority: Major
Status: Closed

Reported By:
Ben Tasker
Assigned To:
Ben Tasker
Project: Jira Issue Listing Script (JILS)
Resolution: Done (2016-04-29 15:02:51)
Affects Version: 0.01b,
Target version: 0.01b,
Labels: TimeManagement,

Created: 2015-09-18 13:58:30
Time Spent Working
Estimated:
 
120 minutes
Remaining:
  
7 minutes
Logged:
  
113 minutes


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 :)


Toggle State Changes

Activity


2015-09-18 14:00:09
btasker changed timespent from '0 minutes' to '55 minutes'

2015-09-18 14:00:56

Repo: Jira-Issue-Listing
Commit: e3c670fed6c9b5a4778bd326c615d651a3cafe21
Author: Ben Tasker <github@<Domain Hidden>>

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




Webhook User-Agent 

GitHub-Hookshot/be3703b


View Commit


2015-09-18 14:05:42
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

Repo: Jira-Issue-Listing
Commit: 5a855b3717ae0a041a66a0d708a4a8682919fa27
Author: Ben Tasker <github@<Domain Hidden>>

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




Webhook User-Agent 

GitHub-Hookshot/be3703b


View Commit


2015-09-18 14:43:14
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 
mysql> select SUMMARY,TIMEORIGINALESTIMATE,TIMEESTIMATE,TIMESPENT from jiraissue WHERE ID=13918;
+------------------------------+----------------------+--------------+-----------+
| SUMMARY                      | TIMEORIGINALESTIMATE | TIMEESTIMATE | TIMESPENT |
+------------------------------+----------------------+--------------+-----------+
| Time Recorded/Estimated Bars |                 7200 |         3900 |      3300 |
+------------------------------+----------------------+--------------+-----------+


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 
mysql> select SUMMARY,TIMEORIGINALESTIMATE,TIMEESTIMATE,TIMESPENT from jiraissue WHERE ID=13918;
+------------------------------+----------------------+--------------+-----------+
| SUMMARY                      | TIMEORIGINALESTIMATE | TIMEESTIMATE | TIMESPENT |
+------------------------------+----------------------+--------------+-----------+
| Time Recorded/Estimated Bars |                 9000 |         3900 |      3300 |
+------------------------------+----------------------+--------------+-----------+


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

Repo: Jira-Issue-Listing
Commit: 4bf32ca541087031b8654b543b48a6dc495bb0b9
Author: Ben Tasker <github@<Domain Hidden>>

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




Webhook User-Agent 

GitHub-Hookshot/be3703b


View Commit


2015-09-18 15:24:49
btasker changed timespent from '98 minutes' to '108 minutes'

2015-09-18 15:24:56

Repo: Jira-Issue-Listing
Commit: 10d42f25c911a11c8f857a0d4bfff182964b298e
Author: Ben Tasker <github@<Domain Hidden>>

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




Webhook User-Agent 

GitHub-Hookshot/be3703b


View Commit


2015-09-18 15:33:13
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

Repo: Jira-Issue-Listing
Commit: 13c75126653015e96ad70d00d6aba32f6d0f15b4
Author: Ben Tasker <github@<Domain Hidden>>

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




Webhook User-Agent 

GitHub-Hookshot/be3703b


View Commit


2016-04-29 14:54:09
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
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
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'

Work log

Ben Tasker
 Permalink
2015-09-18 14:00:09

Time Spent: 55 minutes
Log Entry: Trying a few things and settling on initial basic implementation
Ben Tasker
 Permalink
2015-09-18 14:58:44

Time Spent: 43 minutes
Log Entry: Inserting 'Remaining Bar' and fixing issues with source fields. Testing.
Ben Tasker
 Permalink
2015-09-18 15:24:49

Time Spent: 10 minutes
Log Entry: Added time annotations and did some basic styling
Ben Tasker
 Permalink
2015-09-18 15:33:37

Time Spent: 5 minutes
Log Entry: Testing responsive layout on small screen sizes.