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
|
<?php
/**
* Copyright 2005 (c) GForge Group, LLC
*
* @version $Id: downloadcsv.php 4986 2005-11-22 19:44:12Z danper $
*
* This file is part of GForge.
*
* GForge 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.
*
* GForge 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 GForge; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 US
*/
require_once('common/tracker/ArtifactFactory.class');
header('Content-type: text/comma-separated-values');
list($year, $month) = explode('-', date('Y-m'));
header('Content-disposition: filename="tracker_report-'.$year.'-'.$month.'.csv"');
if (!$ath->userCanView()) {
exit_permission_denied();
}
$af = new ArtifactFactory($ath);
if (!$af || !is_object($af)) {
exit_error('Error','Could Not Get Factory');
} elseif ($af->isError()) {
exit_error('Error',$af->getErrorMessage());
}
$af->setup($offset,$_sort_col,$_sort_ord,$max_rows,$set,$_assigned_to,$_status,$_changed_from);
$at_arr =& $af->getArtifacts();
echo 'artifact_id,status_id,status_name,priority,submitter_id,submitter_name,assigned_to_id,assigned_to_name,open_date,close_date,last_modified_date,summary';
//
// Show the extra fields
//
$ef =& $ath->getExtraFields(ARTIFACT_EXTRAFIELD_FILTER_INT);
$keys=array_keys($ef);
for ($i=0; $i<count($keys); $i++) {
echo ',"'.$ef[$keys[$i]]['field_name'].'"';
}
$arrRemove = array("\r\n", "\n", ',');
for ($i=0; $i<count($at_arr); $i++) {
echo "\n".$at_arr[$i]->getID().','.
$at_arr[$i]->getStatusID().',"'.
$at_arr[$i]->getStatusName().'",'.
$at_arr[$i]->getPriority().','.
$at_arr[$i]->getSubmittedBy().',"'.
$at_arr[$i]->getSubmittedRealName().'",'.
$at_arr[$i]->getAssignedTo().',"'.
$at_arr[$i]->getAssignedRealName().'","'.
date($sys_datefmt,$at_arr[$i]->getOpenDate()).'","'.
date($sys_datefmt,$at_arr[$i]->getCloseDate()).'","'.
date($sys_datefmt,$at_arr[$i]->getLastModifiedDate()).'","'.
$at_arr[$i]->getSummary().'"';
//
// Show the extra fields
//
$efd =& $at_arr[$i]->getExtraFieldData();
for ($j=0; $j<count($keys); $j++) {
$v=$efd[$keys[$j]];
echo ',"'.$ath->getElementName($v).'"';
}
}
?>
|
