User Tools

  • Logged in as: anonymous (anonymous)
  • Log Out

Site Tools


mantisbt:issue:4428

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
mantisbt:issue:4428 [2006/12/19 13:30]
davidnewcomb created
mantisbt:issue:4428 [2014/05/18 01:12] (current)
lakshmipriya
Line 1: Line 1:
 ====== Time Tracking ====== ====== Time Tracking ======
 +
  
 ===== Introduction ===== ===== Introduction =====
 This is currently a work in progress. It will be updated as and when I get time or the checked in code's functionally changes. This is currently a work in progress. It will be updated as and when I get time or the checked in code's functionally changes.
 +
 +  * on the bugtracker: [[http://​www.mantisbt.org/​bugs/​view.php?​id=4428|issue 4428]].
 +
 +
 +
  
 ===== Configuration Options ===== ===== Configuration Options =====
-Currently the configuration options only exists in ''​config_defaults_inc.php''​. 
  
-==== g_time_tracking_enabled ​==== +  * $g_time_tracking_enabled - Turns Time Tracking features ON or OFF  - Default '​OFF'​ 
-Turns Time Tracking features on or off+  * $g_time_tracking_without_note - Allow time tracking to be recorded without writing some text in the associated bugnote - Default '​ON'​ 
 +  * $g_time_tracking_with_billing - Adds calculation links to workout how much time has been spent between a particular time frame. Currently it will allow you to enter a cost/hour and will work out some billing information. This will become more extensive in the future. Currently it is more of a proof of concept. 
 +  * $g_time_tracking_stopwatch - Instead of a text field turning this option on places a stopwatch on the page with "​Start/​Stop"​ and "​Reset"​ buttons next to it.  You must have $g_use_javascript switched on for this to take effect. ​ A bit gimickie, but who cares. 
 +  * $g_time_tracking_view_threshold - Access level required to view time tracking information - Default ''​DEVELOPER''​. 
 +  * $g_time_tracking_edit_threshold - Access level required to add/edit time tracking information - Default ''​DEVELOPER''​. 
 +  * $g_time_tracking_reporting_threshold - Access level required to run reports (not completed yet) - Default ''​MANAGER''​. 
 + 
 +If you give a user ''​g_time_tracking_edit_threshold''​ you must give them ''​g_time_tracking_view_threshold''​ aswell. 
 + 
 +===== Database Changes ===== 
 +The time tracking information is attached to issue notes. Currently it is using an INT column type to hold the number of minutes. ​ ''​admin/​schema.php''​ has an update to add this column to the database. 
 + 
 +<code sql> 
 +  ALTER TABLE mantis_bugnote_table ADD COLUMN time_tracking TIME DEFAULT 0; 
 +</​code>​
  
-==== g_time_tracking_hours ==== +In previous versions ​the time_tracking column was held as a MySQL TIME column type.  If you are using a CVS version and would like to upgrade to using the INT column, then the following SQL will help you convert the information to the new column type.
-When single numbers are entered decide if they are hours or minutes. +
-This option will disappear in the next release ​as all numbers entered ​will be minutes.+
  
-==== g_time_tracking_with_billing ==== +<code sql> 
-Adds calculation links to workout how much time has been spent between a particular time frame. Currently it will allow you to enter a cost/hour and will work out some billing information. This will become more extensive in the future. Currently it is more of a proof of concept.+  ALTER TABLE mantis_bugnote_table ADD COLUMN time_tracking_t int default 0; 
 +  UPDATE bugnote_table SET time_tracking_t ​(HOUR(time_tracking)*60) + (MINUTE(time_tracking)) + IF(SECOND(time_tracking)>​30,​1,​0);​ 
 +  ALTER TABLE mantis_bugnote_table DROP COLUMN time_tracking;​ 
 +  ALTER TABLE mantis_bugnote_table CHANGE time_tracking_t time_tracking INT DEFAULT 0; 
 +</code>
  
-==== g_time_tracking_stopwatch ==== 
-Instead of a text field turning this option on places a stopwatch on the page with "​Start/​Stop"​ and "​Reset"​ buttons next to it. 
-You must have g_use_javascript switched on for this to take effect. 
-A bit gimickie, but who cares. 
  
-===== Database ​===== +===== Feedback ​=====
-The time tracking information is attached to a bugnote. Currently it is using a MySQL TIME column in the database to hold the time component. +
-The current schema does not contain any reference to this as it is still exprimental. To add the column: +
-  +
-  ALTER TABLE bugnote_table ADD COLUMN time_tracking TIME DEFAULT 0;+
  
-This will be changing to an integer ​for better database mirgration.+Thanks for implementing these functions in mantis. 
 +Moreover a field for the estimated time would be very helpful - and of course a field for the remaining time would than make sense. 
 +This picture http://​www.mantisbt.org/​bugs/​file_download.php?​file_id=740&​type=bug shows a nice implementation ​for that.
  
 +Please write your feedback here.
mantisbt/issue/4428.1166553001.txt.gz · Last modified: 2008/10/29 04:36 (external edit)