Default collation of table is not utf8 and because of this cyrillic symbols are not displaying correctly. I had to manually change collation in database.

using the 'next' branch,
Filtering on category creates an empty report.

Hello,

How can we contribute to your project ? We have translated the file strings_french.txt and create strings_breton.txt.

Thanks.

Bruno / Keleier

Apply css on "Add button" to apply the standard mantis 2.0 web interface.

on TimeTracking.php, line 156

who is :

<td><input name="<?php echo plugin_lang_get( 'submit' ) ?>" type="submit" value="<?php echo plugin_lang_get( 'submit' ) ?>" /></td>

change to:

<td><input class="btn btn-primary btn-sm btn-white btn-round" name="<?php echo plugin_lang_get( 'submit' ) ?>" type="submit" value="<?php echo plugin_lang_get( 'submit' ) ?>" /></td>

Hi

I'm in the process of upgrading mantis to the latest version and this plugin does not work on the latest version. (1.3.4)
I'm currently getting a outdated dependency for MantisBT Core 1.2.0.
is there any plan to update the plugin in the future?

Kind Regards

I would like to suggest a couple of adds to the Readme file:

1- Simple installation instructions, like git clone and setup it here and there. Do we need to disable or enable core time tracking?
1- Is it compatible with the core time tracking? Like, will it mess up with it or use its data at all? If no, can I import its data?
2- How it compares to core time tracking?
3- One or two screenshots would be very cool too.

I don't know if this would help anyone else, but would it be possible to have a means of clocking in and out the amount of time taken during a issue's existence? This way, people could use ETAs to measure (if they were more specific) and determine the saved (or lost) time spent on a task.

Hi,

I have installed timetracking on Mantis 1.2.15, and spanish strings file should be in UTF-8 format.

There are some missing tranlations, that I added.

I have updated file and I can send you it, but I don't know how.

I have done tranlation in catalan too, so I can send this file too.

Dear,
How I can see the total hours in view issues?, What variables should I use in View Issues Columns ( Manage Columns)

I also would like to know how can I see the full report by project and category in TimeTracking/show_report

Regards

Hello!
I'm using Mantis with postgresql. timetracking plugin tries to create table but special word user isn't properly escaped ( https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html ):
ERROR: syntax error at or near "user" at character 134
2018-02-27 19:53:30 CET HOST:127.0.0.1 xxx VTID:3/55833 STATEMENT: CREATE TABLE mantis_plugin_TimeTracking_data_table (
id SERIAL,
bug_id INTEGER DEFAULT NULL,
user INTEGER DEFAULT NULL,
expenditure_date TIMESTAMP DEFAULT NULL,
hours FLOAT8 DEFAULT NULL,
timestamp TIMESTAMP DEFAULT NULL,
category VARCHAR(255) DEFAULT NULL,
info VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (id)
)


If an issue has been deleted, but an user has hour tracked on that issue, the application returns "Application error #1100" issue not found

Hello,
I hope it is asked in the right place.
Please keep the time on the server side, so that the time that has been started with the start button is not lost by refreshing the browser screen.
Thanks in Advance

Hello,

When I try install this plugin on Mantis 2.18.0 with MS SQL Server 13.00.4202 I get the following error:
APPLICATION ERROR #2503
The plugin schema update failed in block #0.

The PHP version is 7.2.7.

Thanks.

Currently it impossible to see whole time tracker information about user if there multiple projects.

Could you add a page to show this based on user like it shows now for projects?

Version of plugin: 2.0.5
Mantis Version: 2.13.1

Mantis translate the schema definition to the following:
CREATE TABLE mantis_plugin_TimeTracking_data_table (
id SERIAL,
bug_id INTEGER DEFAULT NULL,
user INTEGER DEFAULT NULL,
expenditure_date TIMESTAMP DEFAULT NULL,
hours FLOAT8 DEFAULT NULL,
timestamp TIMESTAMP DEFAULT NULL,
info VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (id)
)
and because user and timestamp are reserved words in postgres it throws error.

Just installed the plugin and the select box for category does not contain any options. Is there something else I have to do to setup categories?

screenshot

to add a link to the issue on report page

on file "pages/show_report.php" line ~157

change from:

<?php echo bug_format_summary( $t_item['bug_id'] , SUMMARY_FIELD ) ?>

to:

<?php echo print_bug_link( $t_item['bug_id'] ) . ' ' . bug_format_summary( $t_item['bug_id'] , SUMMARY_FIELD ) ?>

In MantisBT 1.3, the db_query() function will be removed from the API (see mantisbt/mantisbt#128).
The following occurences have been found in this plugin; they should be replaced
by db_query_bound() calls

TimeTracking/core/timetracking_api.php:52:$result = db_query( $query );
TimeTracking/pages/delete_record.php:29:   $result_pull_timerecords = db_query($query_pull_timerecords);
TimeTracking/pages/delete_record.php:39:   db_query($query_delete);
TimeTracking/pages/add_record.php:54:   if(!db_query($query)){
TimeTracking/TimeTracking.php:79:       $result_pull_timerecords = db_query( $query_pull_timerecords );
TimeTracking/TimeTracking.php:84:       $result_pull_hours = db_query( $query_pull_hours );

add translation to portuguese_brazil

in folder lang, add file "strings_portuguese_brazil.txt" with content:

<?php
   $s_plugin_TimeTracking_title = 'Tempo';
   $s_plugin_TimeTracking_subtitle = 'Você trabalhou neste caso? Documente seu trabalho aqui.';
   $s_plugin_TimeTracking_user = 'Usuário';

   $s_plugin_TimeTracking_admin_own_threshold = 'Perfil do usuário propietário';
   $s_plugin_TimeTracking_view_others_threshold = 'Perfil do usuário visualizador';
   $s_plugin_TimeTracking_admin_threshold = 'Perfil do usuário administrador';
   $s_plugin_TimeTracking_categories = 'Categoria';

   $s_plugin_TimeTracking_expenditure_date = 'Data execução';
   $s_plugin_TimeTracking_hours = 'Horas';
   $s_plugin_TimeTracking_category = 'Categoria';
   $s_plugin_TimeTracking_information = 'Descrição';
   $s_plugin_TimeTracking_configuration = 'Configuração';
   $s_plugin_TimeTracking_update = 'Atualizar';
   $s_plugin_TimeTracking_entry_date = 'Data inclusão (auto)';
   $s_plugin_TimeTracking_submit = 'Adicionar';
   $s_plugin_TimeTracking_sum = 'Total';
   $s_plugin_TimeTracking_delete = 'Remover';
   $s_plugin_TimeTracking_value_error = 'Informe um número válido no campo de Horas!';
   $s_plugin_TimeTracking_history = 'Tempo alocado';
   $s_plugin_TimeTracking_deleted = 'Removido';
   $s_plugin_TimeTracking_timerecord_menu = 'Ir para acompanhamento de tempo';

   $s_plugin_TimeTracking_get_info = 'Ver informações de acompanhamento de tempo';

?>

Hi,
The CodevTT plugin aims to do some advanced timetracking on Mantis.
I'd be interested in knowing the goal of this new timetracking plugin. Maybe we could join our efforts ?

https://github.com/mantisbt-plugins/codev

Best regards

strings_russian.txt
Hi All.
There is a problem with the information entered in the fields: category and information . Entered information in Russian. In attachment the screen with the final display information. Help please correct the situation. Additionally attached a file with translation into Russian.

Deprecated functionality: "helper_alternate_class", use "CSS" instead. (in C:\MantisBT2256\plugins\TimeTracking\TimeTracking.php line 143)

Apparently in 2021 Mantis updated code and will soon remove that helper function. This plugin willneed to be updated to use CSS directly.

When viewing the result of the time summation in the page "view.php" is shown different from the result of the page "page = TimeTracking / show_report".

Hi,
It would be great to have a option to download CSV/Excel reports from the timetracking overview.

As reported by @atrol there are language files in wrong locations following merge of pull requests #8, #9 and #10.