[Summary view] [Print] [Text view]

   1  <?php
   2  # MantisBT - A PHP based bugtracking system
   3  
   4  # MantisBT is free software: you can redistribute it and/or modify
   5  # it under the terms of the GNU General Public License as published by
   6  # the Free Software Foundation, either version 2 of the License, or
   7  # (at your option) any later version.
   8  #
   9  # MantisBT is distributed in the hope that it will be useful,
  10  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  # GNU General Public License for more details.
  13  #
  14  # You should have received a copy of the GNU General Public License
  15  # along with MantisBT.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * This include file prints out the bug bugnote_stats
  19   * $f_bug_id must already be defined
  20   *
  21   * @package MantisBT
  22   * @copyright Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
  23   * @copyright Copyright (C) 2002 - 2011  MantisBT Team - mantisbt-dev@lists.sourceforge.net
  24   * @link http://www.mantisbt.org
  25   *
  26   * @uses bugnote_api.php
  27   * @uses collapse_api.php
  28   * @uses config_api.php
  29   * @uses constant_inc.php
  30   * @uses filter_api.php
  31   * @uses gpc_api.php
  32   * @uses helper_api.php
  33   * @uses lang_api.php
  34   * @uses utility_api.php
  35   */
  36  
  37  if ( !defined( 'BUGNOTE_STATS_INC_ALLOW' ) ) {
  38      return;
  39  }
  40  
  41  require_api( 'bugnote_api.php' );
  42  require_api( 'collapse_api.php' );
  43  require_api( 'config_api.php' );
  44  require_api( 'constant_inc.php' );
  45  require_api( 'filter_api.php' );
  46  require_api( 'gpc_api.php' );
  47  require_api( 'helper_api.php' );
  48  require_api( 'lang_api.php' );
  49  require_api( 'utility_api.php' );
  50  
  51  if ( OFF == config_get('time_tracking_enabled') ) {
  52      return;
  53  }
  54  ?>
  55  
  56  <a id="bugnotestats"></a><br />
  57  
  58  <?php
  59  collapse_open( 'bugnotestats' );
  60  
  61  $t_bugnote_stats_from_def = date( "d:m:Y", $tpl_bug->date_submitted );
  62  $t_bugnote_stats_from_def_ar = explode ( ":", $t_bugnote_stats_from_def );
  63  $t_bugnote_stats_from_def_d = $t_bugnote_stats_from_def_ar[0];
  64  $t_bugnote_stats_from_def_m = $t_bugnote_stats_from_def_ar[1];
  65  $t_bugnote_stats_from_def_y = $t_bugnote_stats_from_def_ar[2];
  66  
  67  $t_bugnote_stats_from_d = gpc_get_string( 'start_day', $t_bugnote_stats_from_def_d );
  68  $t_bugnote_stats_from_m = gpc_get_string( 'start_month', $t_bugnote_stats_from_def_m );
  69  $t_bugnote_stats_from_y = gpc_get_string( 'start_year', $t_bugnote_stats_from_def_y );
  70  
  71  $t_bugnote_stats_to_def = date( "d:m:Y" );
  72  $t_bugnote_stats_to_def_ar = explode ( ":", $t_bugnote_stats_to_def );
  73  $t_bugnote_stats_to_def_d = $t_bugnote_stats_to_def_ar[0];
  74  $t_bugnote_stats_to_def_m = $t_bugnote_stats_to_def_ar[1];
  75  $t_bugnote_stats_to_def_y = $t_bugnote_stats_to_def_ar[2];
  76  
  77  $t_bugnote_stats_to_d = gpc_get_string( 'end_day', $t_bugnote_stats_to_def_d );
  78  $t_bugnote_stats_to_m = gpc_get_string( 'end_month', $t_bugnote_stats_to_def_m );
  79  $t_bugnote_stats_to_y = gpc_get_string( 'end_year', $t_bugnote_stats_to_def_y );
  80  
  81  $f_get_bugnote_stats_button = gpc_get_string( 'get_bugnote_stats_button', '' );
  82  ?>
  83  <form method="post" action="">
  84  <?php # CSRF protection not required here - form does not result in modifications ?>
  85  <input type="hidden" name="id" value="<?php echo $f_bug_id ?>" />
  86  <table class="width100" cellspacing="0">
  87  <tr>
  88      <td class="form-title" colspan="4">
  89  <?php
  90      collapse_icon( 'bugnotestats' );
  91      echo lang_get( 'time_tracking' ) ?>
  92      </td>
  93  </tr>
  94  <tr class="row-2">
  95          <td class="category" width="25%">
  96                  <?php
  97          $t_filter = array();
  98          $t_filter[FILTER_PROPERTY_FILTER_BY_DATE] = 'on';
  99          $t_filter[FILTER_PROPERTY_START_DAY] = $t_bugnote_stats_from_d;
 100          $t_filter[FILTER_PROPERTY_START_MONTH] = $t_bugnote_stats_from_m;
 101          $t_filter[FILTER_PROPERTY_START_YEAR] = $t_bugnote_stats_from_y;
 102          $t_filter[FILTER_PROPERTY_END_DAY] = $t_bugnote_stats_to_d;
 103          $t_filter[FILTER_PROPERTY_END_MONTH] = $t_bugnote_stats_to_m;
 104          $t_filter[FILTER_PROPERTY_END_YEAR] = $t_bugnote_stats_to_y;
 105          print_filter_do_filter_by_date(true);
 106          ?>
 107          </td>
 108  </tr>
 109  <tr>
 110          <td class="center" colspan="2">
 111                  <input type="submit" class="button" name="get_bugnote_stats_button" value="<?php echo lang_get( 'time_tracking_get_info_button' ) ?>" />
 112          </td>
 113  </tr>
 114  
 115  </table>
 116  </form>
 117  <?php
 118  if ( !is_blank( $f_get_bugnote_stats_button ) ) {
 119      $t_from = "$t_bugnote_stats_from_y-$t_bugnote_stats_from_m-$t_bugnote_stats_from_d";
 120      $t_to = "$t_bugnote_stats_to_y-$t_bugnote_stats_to_m-$t_bugnote_stats_to_d";
 121      $t_bugnote_stats = bugnote_stats_get_events_array( $f_bug_id, $t_from, $t_to );
 122  ?>
 123  <br />
 124  <table class="width100" cellspacing="0">
 125  <tr class="row-category-history">
 126      <td class="small-caption">
 127          <?php echo lang_get( 'username' ) ?>
 128      </td>
 129      <td class="small-caption">
 130          <?php echo lang_get( 'time_tracking' ) ?>
 131      </td>
 132  </tr>
 133  <?php
 134      $t_sum_in_minutes = 0;
 135      foreach ( $t_bugnote_stats as $t_item ) {
 136          $t_sum_in_minutes += $t_item['sum_time_tracking'];
 137          $t_item['sum_time_tracking'] = db_minutes_to_hhmm ( $t_item['sum_time_tracking'] );
 138  ?>
 139  
 140  <tr <?php echo helper_alternate_class() ?>>
 141      <td class="small-caption">
 142          <?php echo string_display_line( $t_item['username'] ) ?>
 143      </td>
 144      <td class="small-caption">
 145          <?php echo $t_item['sum_time_tracking'] ?>
 146      </td>
 147  </tr>
 148  <?php } # end for loop ?>
 149  <tr <?php echo helper_alternate_class() ?>>
 150      <td class="small-caption">
 151          <?php echo lang_get( 'total_time' ) ?>
 152      </td>
 153      <td class="small-caption">
 154          <?php echo db_minutes_to_hhmm ( $t_sum_in_minutes ) ?>
 155      </td>
 156  </tr>
 157  </table>
 158  <?php
 159  } # end if
 160  
 161      collapse_closed( 'bugnotestats' );
 162  ?>
 163  <table class="width100" cellspacing="0">
 164  <tr>
 165      <td class="form-title" colspan="4">
 166          <?php
 167              collapse_icon( 'bugnotestats' );
 168              echo lang_get( 'time_tracking' ) ?>
 169      </td>
 170  </tr>
 171  </table>
 172  <?php
 173  collapse_end( 'bugnotestats' );