2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
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 NavLinks
::usersPages();
26 $navigator->set_focus('tab', 'users', null);
28 if (!can_perform('canadmingroups'))
33 // ###################################################################
34 // define permissions as groups
37 $lang->string('General Permissions') => array(
38 'canviewbugs' => $lang->string('Can View Bugs'),
39 'canviewhidden' => $lang->string('Can View Hidden Bugs and Comments'),
40 'cansearch' => $lang->string('Can Search Bugs'),
41 'cansubscribe' => $lang->string('Can Subscribe to Bugs'),
42 'canbeassignedto' => $lang->string('Can Be Assigned Bugs')
45 $lang->string('Posting/Submitting Permissions') => array(
46 'canvote' => $lang->string('Can Vote on Polls'),
47 'cansubmitbugs' => $lang->string('Can Submit Bugs'),
48 'canpostcomments' => $lang->string('Can Post Comments'),
49 'cangetattach' => $lang->string('Can View Attachments'),
50 'canputattach' => $lang->string('Can Upload/Edit Own Attachments'),
51 'caneditattach' => $lang->string('Can Manage All Attachments')
54 $lang->string('Moderation/Managment Permissions') => array(
55 'caneditown' => $lang->string('Can Edit Own Bugs'),
56 'caneditother' => $lang->string('Can Edit Others\' Bugs'),
57 'caneditownreply' => $lang->string('Can Edit Own Comments'),
58 'caneditotherreply' => $lang->string('Can Edit Others\' Comments'),
59 'canassign' => $lang->string('Can Assign Bugs'),
60 'canchangestatus' => $lang->string('Can Change Status')
63 $lang->string('Administrator Permissions') => array(
64 'canadminpanel' => $lang->string('Can Access Control Panel'),
65 'canadminbugs' => $lang->string('Can Administer Bug Reports'),
66 'canadminfields' => $lang->string('Can Administer Additional Bug Fields'),
67 'canadminversions' => $lang->string('Can Administer Products / Components / Versions'),
68 'canadminusers' => $lang->string('Can Administer Users'),
69 'canadmingroups' => $lang->string('Can Administer Usergroups'),
70 'canadmintools' => $lang->string('Can Administer Settings / Maintenance Tools')
74 // ###################################################################
76 if (empty($_REQUEST['do']))
78 $_REQUEST['do'] = 'modify';
81 // ###################################################################
83 if ($_REQUEST['do'] == 'kill')
85 $usergroup = new UsergroupAPI($bugsys);
86 $usergroup->set('usergroupid', $bugsys->in
['usergroupid']);
87 $usergroup->set_condition();
90 $admin->redirect('usergroup.php?do=modify');
93 // ###################################################################
95 if ($_REQUEST['do'] == 'delete')
97 if ($bugsys->in
['usergroupid'] < 7)
99 $admin->error($lang->string('You can\'t delete a default usergroup.'));
102 $admin->page_confirm($lang->string('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?do=kill&usergroupid=' . $bugsys->in
['usergroupid']);
105 // ###################################################################
107 if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
109 $add = (($_REQUEST['do'] == 'add') ? true : false);
110 $edit = (($_REQUEST['do'] == 'edit') ? true : false);
114 NavLinks
::usergroupsEdit($bugsys->in
['usergroupid']);
115 $navigator->set_focus('link', 'users-pages-usergroups', 'users-pages');
119 NavLinks
::usergroupsAdd();
120 $navigator->set_focus('link', 'usergroups-add', 'usergroups');
123 $admin->page_start(($add ? $lang->string('New Usergroup') : $lang->string('Edit Usergroup')));
125 $admin->form_start('usergroup.php', ($add ? 'insert' : 'update'));
129 $usergroup = new UsergroupAPI($bugsys);
130 $usergroup->set('usergroupid', $bugsys->in
['usergroupid']);
131 $usergroup->set_condition();
134 $admin->form_hidden_field('usergroupid', $usergroup->objdata
['usergroupid']);
138 $usergroup['permissions'] = 319;
142 $admin->table_start();
143 $admin->table_head($lang->string('Usergroup Details'));
144 $admin->row_input($lang->string('Usergroup Title'), 'title', $bugsys->sanitize($usergroup->objdata
['title']));
145 $admin->row_input($lang->string('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']));
149 $admin->table_start();
151 $admin->table_head($lang->string('Permission Settings'));
153 foreach ($permissions AS $group => $settings)
155 $admin->row_span($group, 'thead', 'center');
156 foreach ($settings AS $setting => $name)
158 $admin->row_yesno($name, "perm[$setting]", ($usergroup->objdata
['permissions'] & $bugsys->permissions
["$setting"]));
164 // custom field permissions
165 $admin->table_start();
166 $admin->table_head($lang->string('Custom Field Permissions'));
170 $perms = $db->query("SELECT fieldid
, mask FROM
" . TABLE_PREFIX . "bugfieldpermission WHERE usergroupid
= " . $usergroup->objdata['usergroupid']);
171 while ($perm = $db->fetch_array($perms))
173 $permissions["$perm[fieldid
]"] = $perm['mask'];
177 $fields = $db->query("SELECT fieldid
, name FROM
" . TABLE_PREFIX . "bugfield ORDER BY fieldid
");
178 while ($field = $db->fetch_array($fields))
181 $admin->list_item($lang->string('No Permission'), 0, $permissions["$field[fieldid
]"] == 0);
182 $admin->list_item($lang->string('Can View Field'), 1, $permissions["$field[fieldid
]"] == 1);
183 $admin->list_item($lang->string('Can View, Edit Field'), 2, $permissions["$field[fieldid
]"] == 2);
184 $admin->row_list($field['name'], "custom
[$field[fieldid
]]");
190 $admin->table_start();
191 $admin->row_submit();
199 // ###################################################################
201 if ($_POST['do'] == 'insert')
203 $bugsys->input_clean('perm', TYPE_UINT);
204 foreach ($bugsys->in['perm'] AS $permtitle => $binaryswitch)
206 $permissionvalue += $bugsys->permissions["$permtitle"] * $binaryswitch;
209 $usergroup = new UsergroupAPI($bugsys);
210 $usergroup->set('title', $bugsys->in
['title']);
211 $usergroup->set('displaytitle', $bugsys->in
['displaytitle']);
212 $usergroup->set('permissions', $permissionvalue);
213 $usergroup->insert();
215 $bugsys->input_clean('custom', TYPE_UINT
);
216 foreach ($bugsys->in
['custom'] AS $fieldid => $mask)
218 $values[] = $usergroup->insertid
. ", " . $bugsys->clean($fieldid, TYPE_UINT
) . ", " . $mask;
221 if (is_array($values))
224 INSERT INTO " . TABLE_PREFIX
. "bugfieldpermission
225 (usergroupid, fieldid, mask)
227 (" . implode("\n\t\t\t", $values) . "
232 $admin->redirect('usergroup.php?do=modify');
235 // ###################################################################
237 if ($_POST['do'] == 'update')
239 $bugsys->input_clean_array(array(
241 'usergroupid' => TYPE_UINT
,
242 'custom' => TYPE_UINT
244 $bugsys->input_clean('perm', TYPE_UINT
);
245 foreach ($bugsys->in
['perm'] AS $permtitle => $binaryswitch)
247 $permissionvalue +
= $bugsys->permissions
["$permtitle"] * $binaryswitch;
250 $usergroup = new UsergroupAPI($bugsys);
251 $usergroup->set('usergroupid', $bugsys->in['usergroupid']);
252 $usergroup->set_condition();
253 $usergroup->set('title', $bugsys->in['title']);
254 $usergroup->set('displaytitle', $bugsys->in['displaytitle']);
255 $usergroup->set('permissions', $permissionvalue);
256 $usergroup->update();
258 $bugsys->input_clean('custom', TYPE_UINT);
259 foreach ($bugsys->in['custom'] AS $fieldid => $mask)
261 $values[] = $usergroup->values['usergroupid'] . ", " . $bugsys->clean($fieldid, TYPE_UINT) . ", " . $mask;
264 if (is_array($values))
267 REPLACE INTO
" . TABLE_PREFIX . "bugfieldpermission
268 (usergroupid
, fieldid
, mask
)
270 (" . implode("),\n\t\t\t(", $values) . ")"
275 $admin->redirect('usergroup.php?do=modify');
278 // ###################################################################
280 if ($_REQUEST['do'] == 'modify')
282 NavLinks::usergroupsAdd();
283 $navigator->set_focus('link', 'users-pages-usergroups', 'users-pages');
285 $admin->page_start($lang->string('Usergroup Manager'));
287 $admin->form_start('usergroup.php', 'null');
288 $admin->table_start();
289 $admin->table_head($lang->string('Usergroup Manager'), 3, 'usergroups');
291 $groups = $db->query("SELECT
* FROM
" . TABLE_PREFIX . "usergroup ORDER BY usergroupid ASC
");
292 while ($group = $db->fetch_array($groups))
294 $usergroups["$group[usergroupid
]"] = $group;
296 $db->free_result($groups);
298 $groups = $db->query("
299 SELECT
COUNT(user
.userid
) AS total
, user
.usergroupid
300 FROM
" . TABLE_PREFIX . "user
AS user
301 LEFT JOIN
" . TABLE_PREFIX . "usergroup
AS usergroup
USING (usergroupid
)
302 GROUP BY usergroup
.usergroupid
303 ORDER BY usergroup
.usergroupid
"
305 while ($group = $db->fetch_array($groups))
307 $usergroups["$group[usergroupid
]"]['total'] = $group['total'];
310 $admin->table_column_head(array($lang->string('Usergroup'), $lang->string('Number of Users'), $lang->string('Action')));
311 foreach ($usergroups AS $group)
313 $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
]\">[" . $lang->string('Edit') . "]</a
>" . (($group['usergroupid'] > 6) ? "<a href
=\"usergroup
.php
?do=delete
&
;usergroupid
=$group[usergroupid
]\">[" . $lang->string('Delete') . "]</a
>" : '') => 'c'));
322 /*=====================================================================*\
323 || ###################################################################
326 || ###################################################################
327 \*=====================================================================*/