2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 require_once('./global.php');
23 require_once('./includes/api_usergroup.php');
25 require_once('./includes/class_api_error.php');
26 APIError(array(new API_Error_Handler($admin), 'admin_error'));
28 NavLinks
::usersPages();
29 $navigator->set_focus('tab', 'users', null);
31 if (!can_perform('canadmingroups'))
36 // ###################################################################
37 // define permissions as groups
40 _('General Permissions') => array(
41 'canviewbugs' => _('Can View Bugs'),
42 'canviewhidden' => _('Can View Hidden Bugs and Comments'),
43 'canviewownhidden' => _('Can View Own Hidden Bugs'),
44 'cansearch' => _('Can Search Bugs'),
45 'cansubscribe' => _('Can Subscribe to Bugs'),
46 'canbeassignedto' => _('Can Be Assigned Bugs')
49 _('Posting/Submitting Permissions') => array(
50 'canvote' => _('Can Vote on Polls'),
51 'cansubmitbugs' => _('Can Submit Bugs'),
52 'canpostcomments' => _('Can Post Comments'),
53 'cangetattach' => _('Can View Attachments'),
54 'canputattach' => _('Can Upload/Edit Own Attachments'),
55 'caneditattach' => _('Can Manage All Attachments')
58 _('Moderation/Managment Permissions') => array(
59 'caneditown' => _('Can Edit Own Bugs'),
60 'caneditother' => _('Can Edit Others\' Bugs'),
61 'caneditownreply' => _('Can Edit Own Comments'),
62 'caneditotherreply' => _('Can Edit Others\' Comments'),
63 'canassign' => _('Can Assign Bugs'),
64 'canchangestatus' => _('Can Change Status'),
65 'candeletedata' => _('Can Delete Bugs and Comments')
68 _('Administrator Permissions') => array(
69 'canadminpanel' => _('Can Access Control Panel'),
70 'canadminbugs' => _('Can Administer Bug Reports'),
71 'canadminfields' => _('Can Administer Additional Bug Fields'),
72 'canadminversions' => _('Can Administer Products / Components / Versions'),
73 'canadminusers' => _('Can Administer Users'),
74 'canadmingroups' => _('Can Administer Usergroups'),
75 'canadmintools' => _('Can Administer Settings / Maintenance Tools')
79 // ###################################################################
81 if (empty($_REQUEST['do']))
83 $_REQUEST['do'] = 'modify';
86 // ###################################################################
88 if ($_REQUEST['do'] == 'kill')
90 $usergroup = new UsergroupAPI($bugsys);
91 $usergroup->set('usergroupid', $bugsys->in
['usergroupid']);
92 $usergroup->set_condition();
95 $admin->redirect('usergroup.php?do=modify');
98 // ###################################################################
100 if ($_REQUEST['do'] == 'delete')
102 if ($bugsys->in
['usergroupid'] < 7)
104 $admin->error(_('You can\'t delete a default usergroup.'));
107 $admin->page_confirm(_('Are you sure you want to delete this usergroup? All users in this group will be set back to the default registered usergroup (id: 2).'), 'usergroup.php', 'kill', array('usergroupid' => $bugsys->in
['usergroupid']));
110 // ###################################################################
112 if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
114 $add = (($_REQUEST['do'] == 'add') ? true : false);
115 $edit = (($_REQUEST['do'] == 'edit') ? true : false);
119 NavLinks
::usergroupsEdit($bugsys->in
['usergroupid']);
120 $navigator->set_focus('link', 'users-pages-usergroups', 'users-pages');
124 NavLinks
::usergroupsAdd();
125 $navigator->set_focus('link', 'usergroups-add', 'usergroups');
128 $admin->page_start(($add ? _('New Usergroup') : _('Edit Usergroup')));
130 $admin->form_start('usergroup.php', ($add ? 'insert' : 'update'));
134 $usergroup = new UsergroupAPI($bugsys);
135 $usergroup->set('usergroupid', $bugsys->in
['usergroupid']);
136 $usergroup->set_condition();
139 $admin->form_hidden_field('usergroupid', $usergroup->objdata
['usergroupid']);
143 $usergroup['permissions'] = 319;
147 $admin->table_start();
148 $admin->table_head(_('Usergroup Details'));
149 $admin->row_input(_('Usergroup Title'), 'title', $bugsys->sanitize($usergroup->objdata
['title']));
150 $admin->row_input(_('Display Title<div><dfn>This is the title that others will be able to see when comments are posted.</dfn></div>'), 'displaytitle', $bugsys->sanitize($usergroup->objdata
['displaytitle']));
154 $admin->table_start();
156 $admin->table_head(_('Permission Settings'));
158 foreach ($permissions AS $group => $settings)
160 $admin->row_span($group, 'thead', 'center');
161 foreach ($settings AS $setting => $name)
163 $admin->row_yesno($name, "perm[$setting]", ($usergroup->objdata
['permissions'] & $bugsys->permissions
["$setting"]));
169 // custom field permissions
170 $admin->table_start();
171 $admin->table_head(_('Custom Field Permissions'));
175 $perms = $db->query("SELECT fieldid
, mask FROM
" . TABLE_PREFIX . "bugfieldpermission WHERE usergroupid
= " . $usergroup->objdata['usergroupid']);
176 while ($perm = $db->fetch_array($perms))
178 $permissions["$perm[fieldid
]"] = $perm['mask'];
182 $fields = $db->query("SELECT fieldid
, name FROM
" . TABLE_PREFIX . "bugfield ORDER BY fieldid
");
183 while ($field = $db->fetch_array($fields))
186 $admin->list_item(_('No Permission'), 0, $permissions["$field[fieldid
]"] == 0);
187 $admin->list_item(_('Can View Field'), 1, $permissions["$field[fieldid
]"] == 1);
188 $admin->list_item(_('Can View, Edit Field'), 2, $permissions["$field[fieldid
]"] == 2);
189 $admin->row_list($field['name'], "custom
[$field[fieldid
]]");
195 $admin->table_start();
196 $admin->row_submit();
204 // ###################################################################
206 if ($_POST['do'] == 'insert')
208 $bugsys->input_clean('perm', TYPE_UINT);
209 foreach ($bugsys->in['perm'] AS $permtitle => $binaryswitch)
211 $permissionvalue += $bugsys->permissions["$permtitle"] * $binaryswitch;
214 $usergroup = new UsergroupAPI($bugsys);
215 $usergroup->set('title', $bugsys->in
['title']);
216 $usergroup->set('displaytitle', $bugsys->in
['displaytitle']);
217 $usergroup->set('permissions', $permissionvalue);
218 $usergroup->insert();
220 $bugsys->input_clean('custom', TYPE_UINT
);
221 foreach ($bugsys->in
['custom'] AS $fieldid => $mask)
223 $values[] = $usergroup->insertid
. ", " . $bugsys->clean($fieldid, TYPE_UINT
) . ", " . $mask;
226 if (is_array($values))
229 INSERT INTO " . TABLE_PREFIX
. "bugfieldpermission
230 (usergroupid, fieldid, mask)
232 (" . implode("\n\t\t\t", $values) . "
237 $admin->redirect('usergroup.php?do=modify');
240 // ###################################################################
242 if ($_POST['do'] == 'update')
244 $bugsys->input_clean_array(array(
246 'usergroupid' => TYPE_UINT
,
247 'custom' => TYPE_UINT
249 $bugsys->input_clean('perm', TYPE_UINT
);
250 foreach ($bugsys->in
['perm'] AS $permtitle => $binaryswitch)
252 $permissionvalue +
= $bugsys->permissions
["$permtitle"] * $binaryswitch;
255 $usergroup = new UsergroupAPI($bugsys);
256 $usergroup->set('usergroupid', $bugsys->in['usergroupid']);
257 $usergroup->set_condition();
258 $usergroup->set('title', $bugsys->in['title']);
259 $usergroup->set('displaytitle', $bugsys->in['displaytitle']);
260 $usergroup->set('permissions', $permissionvalue);
261 $usergroup->update();
263 $bugsys->input_clean('custom', TYPE_UINT);
264 foreach ($bugsys->in['custom'] AS $fieldid => $mask)
266 $values[] = $usergroup->values['usergroupid'] . ", " . $bugsys->clean($fieldid, TYPE_UINT) . ", " . $mask;
269 if (is_array($values))
272 REPLACE INTO
" . TABLE_PREFIX . "bugfieldpermission
273 (usergroupid
, fieldid
, mask
)
275 (" . implode("),\n\t\t\t(", $values) . ")"
280 $admin->redirect('usergroup.php?do=modify');
283 // ###################################################################
285 if ($_REQUEST['do'] == 'modify')
287 NavLinks::usergroupsAdd();
288 $navigator->set_focus('link', 'users-pages-usergroups', 'users-pages');
290 $admin->page_start(_('Usergroup Manager'));
292 $admin->form_start('usergroup.php', 'null');
293 $admin->table_start();
294 $admin->table_head(_('Usergroup Manager'), 3, 'usergroups');
296 $groups = $db->query("SELECT
* FROM
" . TABLE_PREFIX . "usergroup ORDER BY usergroupid ASC
");
297 while ($group = $db->fetch_array($groups))
299 $usergroups["$group[usergroupid
]"] = $group;
301 $db->free_result($groups);
303 $groups = $db->query("
304 SELECT
COUNT(user
.userid
) AS total
, user
.usergroupid
305 FROM
" . TABLE_PREFIX . "user
AS user
306 LEFT JOIN
" . TABLE_PREFIX . "usergroup
AS usergroup
USING (usergroupid
)
307 GROUP BY usergroup
.usergroupid
308 ORDER BY usergroup
.usergroupid
"
310 while ($group = $db->fetch_array($groups))
312 $usergroups["$group[usergroupid
]"]['total'] = $group['total'];
315 $admin->table_column_head(array(_('Usergroup'), _('Number of Users'), _('Action')));
316 foreach ($usergroups AS $group)
318 $admin->row_multi_item(array("<a href
=\"usergroup
.php
?do=edit
&
;usergroupid
=$group[usergroupid
]\">$group[title
]</a
>" => 'l', ((!$group['total']) ? '-' : $group['total']) => 'c', "<a href
=\"usergroup
.php
?do=edit
&
;usergroupid
=$group[usergroupid
]\">[" . _('Edit') . "]</a
>" . (($group['usergroupid'] > 6) ? "<a href
=\"usergroup
.php
?do=delete
&
;usergroupid
=$group[usergroupid
]\">[" . _('Delete') . "]</a
>" : '') => 'c'));
327 /*=====================================================================*\
328 || ###################################################################
331 || ###################################################################
332 \*=====================================================================*/