mantisbt:issue:4428
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mantisbt:issue:4428 [2006/12/20 15:04] – Convert time_tracking from TIME to INT (minutes) davidnewcomb | 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:// |
- | Currently | + | |
- | ==== 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 " | ||
- | 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. | + | |
- | '' | + | |
- | | + | |
+ | * $g_time_tracking_without_note - Allow time tracking to be recorded without writing some text in the associated bugnote - Default ' | ||
+ | * $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 " | ||
+ | * $g_time_tracking_view_threshold - Access level required to view time tracking information - Default '' | ||
+ | * $g_time_tracking_edit_threshold - Access level required to add/edit time tracking information - Default '' | ||
+ | * $g_time_tracking_reporting_threshold - Access level required to run reports (not completed yet) - Default '' | ||
- | 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. | + | If you give a user '' |
- | | + | ===== 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. | ||
+ | |||
+ | <code sql> | ||
+ | | ||
+ | </ | ||
+ | |||
+ | 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 | ||
UPDATE bugnote_table SET time_tracking_t = (HOUR(time_tracking)*60) + (MINUTE(time_tracking)) + IF(SECOND(time_tracking)> | UPDATE bugnote_table SET time_tracking_t = (HOUR(time_tracking)*60) + (MINUTE(time_tracking)) + IF(SECOND(time_tracking)> | ||
- | ALTER TABLE bugnote_table | + | ALTER TABLE mantis_bugnote_table |
- | ALTER TABLE bugnote_table | + | ALTER TABLE mantis_bugnote_table |
+ | </ | ||
+ | |||
+ | |||
+ | ===== Feedback ===== | ||
- | **Don' | + | 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:// | ||
+ | Please write your feedback here. |
mantisbt/issue/4428.txt · Last modified: 2014/05/18 01:12 by lakshmipriya