. /** * Excel (2003 SP2 and above) export page * * @package MantisBT * @copyright Copyright (C) 2000 - 2002 Kenzaburo Ito - kenito@300baud.org * @copyright Copyright (C) 2002 - 2014 MantisBT Team - mantisbt-dev@lists.sourceforge.net * @link http://www.mantisbt.org */ /** * MantisBT Core API's */ require_once( 'core.php' ); require_once( 'current_user_api.php' ); require_once( 'bug_api.php' ); require_once( 'string_api.php' ); require_once( 'columns_api.php' ); require_once( 'excel_api.php' ); require( 'print_all_bug_options_inc.php' ); auth_ensure_user_authenticated(); $f_export = gpc_get_string( 'export', '' ); helper_begin_long_process(); $t_export_title = excel_get_default_filename(); $t_short_date_format = config_get( 'short_date_format' ); # This is where we used to do the entire actual filter ourselves $t_page_number = gpc_get_int( 'page_number', 1 ); $t_per_page = 100; $result = filter_get_bug_rows( $t_page_number, $t_per_page, $t_page_count, $t_bug_count ); if ( $result === false ) { print_header_redirect( 'view_all_set.php?type=0&print=1' ); } header( 'Content-Type: application/vnd.ms-excel; charset=UTF-8' ); header( 'Pragma: public' ); header( 'Content-Disposition: attachment; filename="' . urlencode( file_clean_name( $t_export_title ) ) . '.xml"' ) ; echo excel_get_header( $t_export_title ); echo excel_get_titles_row(); $f_bug_arr = explode( ',', $f_export ); $t_columns = excel_get_columns(); do { # pre-cache custom column data columns_plugin_cache_issue_data( $result ); foreach( $result as $t_row ) { if ( is_blank( $f_export ) || in_array( $t_row->id, $f_bug_arr ) ) { echo excel_get_start_row(); foreach ( $t_columns as $t_column ) { $t_custom_field = column_get_custom_field_name( $t_column ); if ( $t_custom_field !== null ) { echo excel_format_custom_field( $t_row->id, $t_row->project_id, $t_custom_field ); } else if ( column_is_plugin_column( $t_column ) ) { echo excel_format_plugin_column_value( $t_column, $t_row ); } else { $t_function = 'excel_format_' . $t_column; echo $t_function( $t_row ); } } echo excel_get_end_row(); } #in_array } #for loop // Get the next page if we are not processing the last one // @@@ Note that since we are not using a transaction, there is a risk that we get a duplicate record or we miss // one due to a submit or update that happens in parallel. $t_more = ( $t_page_number < $t_page_count ); if ( $t_more ) { $t_page_number++; $result = filter_get_bug_rows( $t_page_number, $t_per_page, $t_page_count, $t_bug_count ); } } while ( $t_more ); echo excel_get_footer();