forked from mantisbt/mantisbt
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathexcel_xml_export.php
134 lines (110 loc) · 4.06 KB
/
excel_xml_export.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
# MantisBT - A PHP based bugtracking system
# MantisBT is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 2 of the License, or
# (at your option) any later version.
#
# MantisBT is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with MantisBT. If not, see <http://www.gnu.org/licenses/>.
/**
* Excel (2003 SP2 and above) export page
*
* @package MantisBT
* @copyright Copyright (C) 2000 - 2002 Kenzaburo Ito - [email protected]
* @copyright Copyright (C) 2002 - 2012 MantisBT Team - [email protected]
* @link http://www.mantisbt.org
*
* @uses core.php
* @uses authentication_api.php
* @uses bug_api.php
* @uses columns_api.php
* @uses config_api.php
* @uses excel_api.php
* @uses file_api.php
* @uses filter_api.php
* @uses gpc_api.php
* @uses helper_api.php
* @uses print_api.php
* @uses utility_api.php
*/
/**
* MantisBT Core API's
*/
require_once( 'core.php' );
require_api( 'authentication_api.php' );
require_api( 'bug_api.php' );
require_api( 'columns_api.php' );
require_api( 'config_api.php' );
require_api( 'excel_api.php' );
require_api( 'file_api.php' );
require_api( 'filter_api.php' );
require_api( 'gpc_api.php' );
require_api( 'helper_api.php' );
require_api( 'print_api.php' );
require_api( 'utility_api.php' );
define( 'PRINT_ALL_BUG_OPTIONS_INC_ALLOW', true );
include( dirname( __FILE__ ) . DIRECTORY_SEPARATOR . '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' );
}
# pre-cache custom column data
columns_plugin_cache_issue_data( $result );
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 {
foreach( $result as $t_row ) {
$t_bug = null;
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;
if ( column_is_extended( $t_column ) ) {
if( $t_bug === null ) {
$t_bug = bug_get( $t_row->id, /* extended = */ true );
}
echo $t_function( $t_bug->$t_column );
} else {
echo $t_function( $t_row->$t_column );
}
}
}
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 );
$t_more !== false;
}
} while ( $t_more );
echo excel_get_footer();