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

Both sides previous revision Previous revision
Next revision
Previous revision
mantisbt:issue:4428 [2006/12/20 15:04]
davidnewcomb Convert time_tracking from TIME to INT (minutes)
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.
  
-===== Configuration Options ===== +  * on the bugtracker: [[http://​www.mantisbt.org/​bugs/​view.php?​id=4428|issue 4428]].
-Currently ​the configuration options only exists in ''​config_defaults_inc.php''​.+
  
-==== g_time_tracking_enabled ==== 
-Turns Time Tracking features on or off 
  
-==== 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. 
  
-===== Database ​===== +===== Configuration Options ​=====
-The time tracking information is attached to a bugnote. 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.+
  
-  ​ALTER TABLE bugnote_table ADD COLUMN time_tracking TIME DEFAULT 0;+  ​* $g_time_tracking_enabled - Turns Time Tracking features ON or OFF  - Default '​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''​.
  
-In previous versions the time_tracking column was held as a MySQL TIME column type. If you are using 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.+If you give user ''​g_time_tracking_edit_threshold'' ​you must give them ''​g_time_tracking_view_threshold''​ aswell.
  
-  ​ALTER TABLE bugnote_table ​ADD COLUMN time_tracking_t int default 0;+===== 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>​ 
 + 
 +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. 
 + 
 +<code sql> 
 +  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);​   UPDATE bugnote_table SET time_tracking_t = (HOUR(time_tracking)*60) + (MINUTE(time_tracking)) + IF(SECOND(time_tracking)>​30,​1,​0);​
-  ALTER TABLE bugnote_table ​DROP COLUMN time_tracking;​ +  ALTER TABLE mantis_bugnote_table ​DROP COLUMN time_tracking;​ 
-  ALTER TABLE bugnote_table ​CHANGE time_tracking_t time_tracking INT DEFAULT 0;+  ALTER TABLE mantis_bugnote_table ​CHANGE time_tracking_t time_tracking INT DEFAULT 0; 
 +</​code>​ 
 + 
 + 
 +===== Feedback =====
  
-**Don'​t forget to backup your database before applying any updates**+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.1166645094.txt.gz · Last modified: 2008/10/29 04:36 (external edit)