/
excel_xml_export.php
125 lines (97 loc) · 3.87 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
<?php
# Mantis - a php based bugtracking system
# Copyright (C) 2000 - 2002 Kenzaburo Ito - kenito@300baud.org
# Copyright (C) 2002 - 2008 Mantis Team - mantisbt-dev@lists.sourceforge.net
# Mantis 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.
#
# Mantis 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 Mantis. If not, see <http://www.gnu.org/licenses/>.
# --------------------------------------------------------
# $Id$
# --------------------------------------------------------
# Excel (2003 SP2 and above) export page
require_once( 'core.php' );
$t_core_path = config_get( 'core_path' );
require_once( $t_core_path . 'current_user_api.php' );
require_once( $t_core_path . 'bug_api.php' );
require_once( $t_core_path . 'string_api.php' );
require_once( $t_core_path . 'columns_api.php' );
require_once( $t_core_path . '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_export_title = ereg_replace( '[\/:*?"<>|]', '', $t_export_title );
$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;
$t_bug_count = null;
$t_page_count = null;
$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-Type: application/vnd.ms-excel' );
header( 'Content-Disposition: attachment; filename="' . urlencode( $t_export_title ) . '.xml"' ) ;
echo excel_get_header( $t_export_title );
echo excel_get_titles_row();
$f_bug_arr = explode_enum_string( $f_export );
$t_columns = excel_get_columns();
do
{
$t_more = true;
$t_row_count = sizeof( $result );
for( $i = 0; $i < $t_row_count; $i++ ) {
$t_row = $result[$i];
$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 ) {
if ( column_is_extended( $t_column ) ) {
if ( $t_bug === null ) {
$t_bug = bug_get( $t_row['id'], /* extended = */ true );
}
$t_function = 'excel_format_' . $t_column;
echo $t_function( $t_bug->$t_column );
} else {
$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 {
$t_function = 'excel_format_' . $t_column;
echo $t_function( $t_row[$t_column] );
}
}
}
echo excel_get_end_row();
} #in_array
} #for loop
// If got a full page, then attempt for the next 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.
if ( $t_row_count == $t_per_page ) {
$t_page_number++;
$t_bug_count = null;
$t_page_count = null;
$result = filter_get_bug_rows( $t_page_number, $t_per_page, $t_page_count, $t_bug_count );
if ( $result === false ) {
$t_more = false;
}
} else {
$t_more = false;
}
} while ( $t_more );
echo excel_get_footer();
?>