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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
<?php
/**
* @author: Patrick Apel, tarent GmbH
*
* 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.
*/
/**
* Retrieve group_project_id and group_id for a specific project_task_id,
* for URI construction and similar things.
*
* in: int project_task_id
* out: false, or an associative array with
* - int project_task_id (copy)
* - int group_project_id
* - int group_id
*/
function getGroupProjectIdGroupId($project_task_id) {
$res = db_query_params('SELECT project_task.group_project_id, project_group_list.group_id FROM project_task ' .
'INNER JOIN project_group_list ON project_task.group_project_id = project_group_list.group_project_id ' .
'WHERE project_task.project_task_id = $1',
array($project_task_id));
if (!$res || db_numrows($res) != 1) {
return false;
}
while ($arr = db_fetch_array($res)) {
$arrResult = array(
'project_task_id' => (int)$project_task_id,
'group_project_id' => (int)$arr[0],
'group_id' => (int)$arr[1]
);
}
return $arrResult;
}
/**
* Check if the task behind project_task_id is considered public.
*
* in: int project_task_id
* out: true, if it is; false otherwise
*/
function isProjectTaskInfoPublic($project_task_id) {
$res = db_query_params('SELECT group_project_id FROM project_task WHERE project_task_id=$1',
array ($project_task_id)) ;
if (!$res || db_numrows($res) < 1) {
return false;
}
return RoleAnonymous::getInstance()->hasPermission('pm',
db_result ($res, 0, 'group_project_id'),
'read') ;
}
/**
* Check whether the user has access to the project task by
* means of common group membership.
*
* in: int project_task_id
* str user_name (Unix user name)
* out: true, if he has; false otherwise
*/
function isUserAndTaskinSameGroup($project_task_id, $user_name) {
$res = db_query_params('SELECT group_project_id FROM project_task WHERE project_task_id=$1',
array ($project_task_id)) ;
if (!$res || db_numrows($res) < 1) {
return false;
}
$arr = db_fetch_array($res) ;
return forge_check_perm_for_user(user_get_object_by_name ($user_name), 'pm', $arr['group_project_id'], 'read') ;
}
/*-
* Query for controlling the result. It gives back all user_names and
* project_task_ids that matches the groups above:
*
* SELECT users.user_name, project_task.project_task_id FROM users
* INNER JOIN user_group ON users.user_id = user_group.user_id
* INNER JOIN project_group_list ON user_group.group_id = project_group_list.group_id
* INNER JOIN project_task ON project_group_list.group_project_id = project_task.group_project_id;
*
* Query for controlling the result. It gives back all user_names that
* does not match a group above:
*
* SELECT users.user_name, project_task.project_task_id FROM users
* LEFT JOIN user_group ON users.user_id = user_group.user_id
* LEFT JOIN project_group_list ON user_group.group_id = project_group_list.group_id
* LEFT JOIN project_task ON project_group_list.group_project_id = project_task.group_project_id
* WHERE project_task_id isNull;
*/
/**
* Retrieve extended information about a project task.
*
* in: int project_task_id
* out: false (if an error occured) or an associative array with
* - int project_task_id (copy)
* - int group_project_id (for URI construction)
* - int group_id (for URI construction)
* - str group_name
* - str summary (of the task)
* - int priority
* - int created_by (user ID)
* - str created_by_name (Unix user name)
* - int status_id
* - str status_name
* - int category_id
* - str category_name (of the per-group category the task is in)
* - str project_name (of the per-group subproject the task is in)
*/
function getAllFromProjectTask($project_task_id) {
$res = db_query_params('SELECT ' .
'project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.priority, ' .
'project_task.created_by, project_task.status_id, project_task.category_id, ' .
'users.user_name, ' .
'project_category.category_name, ' .
'project_group_list.project_name, ' .
'groups.group_name, ' .
'groups.group_id, ' .
'project_status.status_name ' .
'FROM project_status ' .
'INNER JOIN project_task ON ' .
'project_task.status_id = project_status.status_id ' .
'INNER JOIN users ON ' .
'users.user_id = project_task.created_by ' .
'INNER JOIN project_category ON ' .
'project_category.category_id = project_task.category_id ' .
'INNER JOIN project_group_list ON ' .
'project_group_list.group_project_id = project_task.group_project_id ' .
'INNER JOIN groups ON ' .
'groups.group_id = project_group_list.group_id ' .
'WHERE project_task.project_task_id = $1',
array($project_task_id));
if (!$res || db_numrows($res) != 1) {
return false;
}
while ($arr = db_fetch_array($res)) {
$arrResult = array(
'project_task_id' => (int)$arr[0],
'group_project_id' => (int)$arr[1],
'group_id' => (int)$arr[11],
'summary' => $arr[2],
'priority' => (int)$arr[3],
'created_by' => (int)$arr[4],
'status_id' => (int)$arr[5],
'category_id' => (int)$arr[6],
'created_by_name' => $arr[7],
'category_name' => $arr[8],
'project_name' => $arr[9],
'group_name' => $arr[10],
'status_name' => $arr[12]
);
}
return $arrResult;
}
|
