User Tools

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

Site Tools


This is an old revision of the document!

Time Tracking


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

  • $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 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.

  ALTER TABLE mantis_bugnote_table ADD COLUMN time_tracking TIME DEFAULT 0;

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.

  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;


Please write your feedback here.

mantisbt/issue/4428.1166776291.txt.gz · Last modified: 2008/10/29 04:36 (external edit)