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
|
<?php
/**
* tool_reports.php
*
* SourceForge: Breaking Down the Barriers to Open Source Development
* Copyright 1999-2001 (c) VA Linux Systems
* http://sourceforge.net
*
* @version $Id: tool_reports.php 2687 2004-02-19 13:38:03Z gsmet $
*/
/**
* reports_quick_graph() - Show a quick graph of data.
*
* @param string Graph title
* @param int First query resource ID
* @param int Second query resource ID
* @param string The bar colors
*/
function reports_quick_graph($title,$sql1,$sql2,$bar_colors) {
global $Language;
$result1=db_query($sql1);
$result2=db_query($sql2);
if ($result1 && $result2 && db_numrows($result2) > 0) {
$assoc_open=util_result_columns_to_assoc($result1);
$assoc_all=util_result_columns_to_assoc($result2);
while (list($key,$val)=each($assoc_all)) {
$titles[]=$key;
$all[]=$val;
if ($assoc_open[$key]) $open[]=$assoc_open[$key];
else $open[]=0;
}
/* for ($i=0; $i<db_numrows($result1); $i++) {
echo "$titles[$i]=>$opened[$i]/$all[$i]<br />";
}
*/
$scale=graph_calculate_scale(array($opened,$all),400);
$props["scale"]=$scale;
$props["cellspacing"]=5;
$props = hv_graph_defaults($props);
start_graph($props, $titles);
horizontal_multisection_graph(
$titles,
array($open,$all),
$bar_colors,
$props
);
end_graph();
print '<p /><br />';
print '<table cellspacing="0" border="0"><tr align="center"><td width="15%">'.$Language->getText('include_toolreport','key').':</td><td width="5%">(</td><td width="35%" style="background-color:'.$bar_colors[0].'">'.$Language->getText('include_toolreport','open').'</td>'.
'<td width="5%">/</td><td width="35%" style="background-color:'.$bar_colors[1].'">'.$Language->getText('include_toolreport','all').' </td><td width="5%">)</td></tr></table>';
print '<p />';
// GraphResult($result,$title);
} else {
echo "<h2>".$Language->getText('include_toolreport','no_data')."</h2>";
}
}
/**
* reports_header() - Show the reports header
*
* @param int The group ID
* @param array Array of select box values
* @param string The select box title
* @param string Any additional HTML
*/
function reports_header($group_id, $vals, $titles, $html='') {
global $what;
global $period;
global $span;
global $Language;
global $PHP_SELF;
print "<form method=\"get\" action=\"$PHP_SELF#b\">";
print $html;
print html_build_select_box_from_arrays ($vals,$titles,
'what',$what,false);
$periods=array('day'=>'Last day','week'=>'Last week');
$vals=array('day','week','month','year','lifespan');
$texts=array(
$Language->getText('include_toolreport','last_days'),
$Language->getText('include_toolreport','last_weeks'),
$Language->getText('include_toolreport','last_months'),
$Language->getText('include_toolreport','last_years'),
$Language->getText('include_toolreport','project_lifespan'));
if (!$period) $period="lifespan";
print $Language->getText('include_toolreport','for');
print html_build_select_box_from_arrays (
array('','1','4','7','12','14','30','52'),
array('','1','4','7','12','14','30','52'),
'span',$span,false);
print html_build_select_box_from_arrays ($vals,$texts,'period',$period,false);
print "<input type=\"hidden\" name=\"group_id\" value=\"$group_id\" />";
print ' <input type="submit" value="'.$Language->getText('include_toolreport','show').'" />';
print "</form>\n";
}
?>
|
