[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   * @package MantisBT
  19   * @copyright Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
  20   * @copyright Copyright (C) 2002 - 2011  MantisBT Team - mantisbt-dev@lists.sourceforge.net
  21   * @link http://www.mantisbt.org
  22   *
  23   * @uses core.php
  24   * @uses authentication_api.php
  25   * @uses columns_api.php
  26   * @uses constant_inc.php
  27   * @uses csv_api.php
  28   * @uses file_api.php
  29   * @uses filter_api.php
  30   * @uses helper_api.php
  31   * @uses print_api.php
  32   */
  33  
  34  /**
  35   * MantisBT Core API's
  36   */
  37  require_once ( 'core.php' );
  38  require_api( 'authentication_api.php' );
  39  require_api( 'columns_api.php' );
  40  require_api( 'constant_inc.php' );
  41  require_api( 'csv_api.php' );
  42  require_api( 'file_api.php' );
  43  require_api( 'filter_api.php' );
  44  require_api( 'helper_api.php' );
  45  require_api( 'print_api.php' );
  46  
  47  auth_ensure_user_authenticated();
  48  
  49  helper_begin_long_process();
  50  
  51  $t_page_number = 1;
  52  $t_per_page = -1;
  53  $t_bug_count = null;
  54  $t_page_count = null;
  55  
  56  $t_nl = csv_get_newline();
  57  $t_sep = csv_get_separator();
  58  
  59  # Get bug rows according to the current filter
  60  $t_rows = filter_get_bug_rows( $t_page_number, $t_per_page, $t_page_count, $t_bug_count );
  61  if ( $t_rows === false ) {
  62      print_header_redirect( 'view_all_set.php?type=0' );
  63  }
  64  
  65  $t_filename = csv_get_default_filename();
  66  
  67  # Send headers to browser to activate mime loading
  68  
  69  # Make sure that IE can download the attachments under https.
  70  header( 'Pragma: public' );
  71  
  72  header( 'Content-Type: text/plain; name=' . urlencode( file_clean_name( $t_filename ) ) );
  73  header( 'Content-Transfer-Encoding: BASE64;' );
  74  
  75  # Added Quotes (") around file name.
  76  header( 'Content-Disposition: attachment; filename="' . urlencode( file_clean_name( $t_filename ) ) . '"' );
  77  
  78  # Get columns to be exported
  79  $t_columns = csv_get_columns();
  80  
  81  # export the titles
  82  $t_first_column = true;
  83  ob_start();
  84  $t_titles = array();
  85  foreach ( $t_columns as $t_column ) {
  86      if ( !$t_first_column ) {
  87          echo $t_sep;
  88      } else {
  89          $t_first_column = false;
  90      }
  91  
  92      echo column_get_title( $t_column );
  93  }
  94  
  95  echo $t_nl;
  96  
  97  $t_header = ob_get_clean();
  98  
  99  # Fixed for a problem in Excel where it prompts error message "SYLK: File Format Is Not Valid"
 100  # See Microsoft Knowledge Base Article - 323626
 101  # http://support.microsoft.com/default.aspx?scid=kb;en-us;323626&Product=xlw
 102  $t_first_three_chars = utf8_substr( $t_header, 0, 3 );
 103  if ( strcmp( $t_first_three_chars, 'ID' . $t_sep ) == 0 ) {
 104      $t_header = str_replace( 'ID' . $t_sep, 'Id' . $t_sep, $t_header );
 105  }
 106  # end of fix
 107  
 108  echo $t_header;
 109  
 110  # export the rows
 111  foreach ( $t_rows as $t_row ) {
 112      $t_first_column = true;
 113  
 114      foreach ( $t_columns as $t_column ) {
 115          if ( !$t_first_column ) {
 116              echo $t_sep;
 117          } else {
 118              $t_first_column = false;
 119          }
 120  
 121          $t_custom_field = column_get_custom_field_name( $t_column );
 122          if ( $t_custom_field !== null ) {
 123              ob_start();
 124              $t_column_value_function = 'print_column_value';
 125              helper_call_custom_function( $t_column_value_function, array( $t_column, $t_row, COLUMNS_TARGET_CSV_PAGE ) );
 126              $t_value = ob_get_clean();
 127  
 128              echo csv_escape_string($t_value);
 129          } else {
 130              $t_function = 'csv_format_' . $t_column;
 131              echo $t_function( $t_row->$t_column );
 132          }
 133      }
 134  
 135      echo $t_nl;
 136  }