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
|
<?php
/**
* FusionForge reporting system
*
* Copyright 2003-2004, Tim Perdue/GForge, LLC
* Copyright 2009, Roland Mas
*
* This file is part of FusionForge. FusionForge 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 Licence, or (at your option)
* any later version.
*
* FusionForge 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 FusionForge; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
require_once $gfcommon.'reporting/Report.class.php';
class ReportProjectTime extends Report {
function ReportProjectTime($group_id,$type,$start=0,$end=0) {
$this->Report();
if (!$start) {
$start=mktime(0,0,0,date('m'),1,date('Y'));;
}
if (!$end) {
$end=time();
} else {
$end--;
}
if (!$group_id) {
$this->setError('No User_id');
return false;
}
//
// Task report
//
if (!$type || $type=='tasks') {
$res = db_query_params ('SELECT pt.summary,sum(rtt.hours) AS hours
FROM rep_time_tracking rtt, project_task pt, project_group_list pgl
WHERE pgl.group_project_id=pt.group_project_id
AND pgl.group_id=$1
AND rtt.report_date BETWEEN $2 AND $3
AND rtt.project_task_id=pt.project_task_id
GROUP BY pt.summary
ORDER BY hours DESC',
array ($group_id,
$start,
$end)) ;
//
// Category report
//
} elseif ($type=='category') {
$res = db_query_params ('SELECT rtc.category_name, sum(rtt.hours) AS hours
FROM rep_time_tracking rtt, rep_time_category rtc, project_task pt, project_group_list pgl
WHERE pgl.group_id=$1
AND pgl.group_project_id=pt.group_project_id
AND rtt.project_task_id=pt.project_task_id
AND rtt.report_date BETWEEN $2 AND $3
AND rtt.time_code=rtc.time_code
GROUP BY rtc.category_name
ORDER BY hours DESC',
array ($group_id,
$start,
$end)) ;
//
// Percentage this user spent on a specific subproject
//
} elseif ($type=='subproject') {
$res = db_query_params ('SELECT pgl.project_name, sum(rtt.hours) AS hours
FROM rep_time_tracking rtt, project_task pt, project_group_list pgl
WHERE pgl.group_id=$1
AND rtt.report_date BETWEEN $2 AND $3
AND rtt.project_task_id=pt.project_task_id
AND pt.group_project_id=pgl.group_project_id
GROUP BY pgl.project_name
ORDER BY hours DESC',
array ($group_id,
$start,
$end)) ;
} else {
//
// Biggest Users
//
$res = db_query_params ('SELECT u.realname, sum(rtt.hours) AS hours
FROM users u, rep_time_tracking rtt, project_task pt, project_group_list pgl
WHERE pgl.group_id=$1
AND rtt.report_date BETWEEN $2 AND $3
AND rtt.project_task_id=pt.project_task_id
AND pt.group_project_id=pgl.group_project_id
AND u.user_id=rtt.user_id
GROUP BY u.realname
ORDER BY hours DESC',
array ($group_id,
$start,
$end)) ;
}
$this->start_date=$start;
$this->end_date=$end;
if (!$res || db_error()) {
$this->setError('ReportUserAct:: '.db_error());
return false;
}
$this->labels = util_result_column_to_array($res,0);
$this->setData($res,1);
return true;
}
}
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End:
|
