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
|
<?php
/***********************************\
| Top level project overview |
\***********************************/
if (!defined('IN_FS')) {
die('Do not access this file directly.');
}
if ($proj->id && $user->can_select_project($proj->prefs)) {
$projects = array(
0 => array(
'project_id' => $proj->id,
'project_title' => $proj->prefs['project_title'],
'project_is_active' => $proj->prefs['project_is_active']
)
);
} else {
$projects = $fs->projects;
# anon users should not see details of a restricted project but anon tasks creation allowed
# but in /index.php we filter now by 'can_select_project', not 'can_view_project' anymore.
$projects= array_filter($projects, array($user, 'can_select_project'));
}
if(count($projects)>0){
$most_wanted = array();
$stats = array();
$assigned_to_myself = array();
$projprefs = array();
# Most wanted tasks for each project
foreach ($projects as $project) {
# means 'can view tasks' ..
if($user->can_view_project($project['project_id'])){
$sql = $db->query('SELECT v.task_id, count(*) AS num_votes
FROM {votes} v
LEFT JOIN {tasks} t ON v.task_id = t.task_id AND t.project_id = ?
WHERE t.is_closed = 0
GROUP BY v.task_id
ORDER BY num_votes DESC',
array($project['project_id']), 5
);
if ($db->countRows($sql)) {
$most_wanted[$project['project_id']] = $db->fetchAllArray($sql);
}
}
}
# Project stats
foreach ($projects as $project) {
$sql = $db->query('SELECT count(*) FROM {tasks} WHERE project_id = ?', array($project['project_id']));
$stats[$project['project_id']]['all'] = $db->fetchOne($sql);
$sql = $db->query('SELECT count(*) FROM {tasks} WHERE project_id = ? AND is_closed = 0', array($project['project_id']));
$stats[$project['project_id']]['open'] = $db->fetchOne($sql);
$sql = $db->query('SELECT avg(percent_complete) FROM {tasks} WHERE project_id = ? AND is_closed = 0', array($project['project_id']));
$stats[$project['project_id']]['average_done'] = round($db->fetchOne($sql), 0);
if ($proj->id) {
$prefs = $proj->prefs;
} else {
$currentproj = new Project($project['project_id']);
$prefs = $currentproj->prefs;
}
$projprefs[$project['project_id']] = $prefs;
if($user->perms('view_estimated_effort', $project['project_id']) ){
if ($prefs['use_effort_tracking']) {
$sql = $db->query('
SELECT t.task_id, t.estimated_effort
FROM {tasks} t
WHERE project_id = ? AND is_closed = 0',
array($project['project_id'])
);
$stats[$project['project_id']]['tasks'] = $db->fetchAllArray($sql);
}
}
}
# Assigned to myself
foreach ($projects as $project) {
$sql = $db->query('
SELECT a.task_id
FROM {assigned} a
LEFT JOIN {tasks} t ON a.task_id = t.task_id AND t.project_id = ?
WHERE t.is_closed = 0 and a.user_id = ?',
array($project['project_id'], $user->id), 5
);
if ($db->countRows($sql)) {
$assigned_to_myself[$project['project_id']] = $db->fetchAllArray($sql);
}
}
$page->uses('most_wanted', 'stats', 'projects', 'assigned_to_myself', 'projprefs');
$page->setTitle($fs->prefs['page_title'] . $proj->prefs['project_title'] . ': ' . L('toplevel'));
$page->pushTpl('toplevel.tpl');
} else{
# mmh what we want to show anon users with only the 'create anon task' permission enabled?...
}
?>
|