]> src.bluestatic.org Git - bugdar.git/blob - admin/user.php
r1398: Removing the print_r() from BugAPI
[bugdar.git] / admin / user.php
1 <?php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
6 || #
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.
10 || #
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
14 || # more details.
15 || #
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 \*=====================================================================*/
21
22 require_once('./global.php');
23 require_once('./includes/api_user.php');
24 require_once('./includes/class_sort.php');
25
26 require_once('./includes/class_api_error.php');
27 APIError(array(new API_Error_Handler($admin), 'admin_error'));
28
29 NavLinks::usersPages();
30 $navigator->set_focus('tab', 'users', null);
31
32 if (!can_perform('canadminusers'))
33 {
34 admin_login();
35 }
36
37 // ###################################################################
38 /**
39 * Generate an inline checkbox
40 *
41 * @access public
42 *
43 * @param string Name
44 * @param bool Checked?
45 *
46 * @return string HTML checkbxo
47 */
48 function draw_checkbox($name, $checked)
49 {
50 return "<input type=\"checkbox\" class=\"button\" name=\"{$name}\" value=\"1\"" . ($checked == true ? ' checked="checked"' : '') . " />";
51 }
52
53 // ###################################################################
54
55 if (empty($_REQUEST['do']))
56 {
57 $_REQUEST['do'] = 'modify';
58 }
59
60 // ###################################################################
61
62 if ($_REQUEST['do'] == 'kill')
63 {
64 $user = new UserAPI($bugsys);
65 $user->set('userid', $bugsys->in['userid']);
66 $user->set_condition();
67 $user->delete();
68
69 $admin->redirect('user.php');
70 }
71
72 // ###################################################################
73
74 if ($_REQUEST['do'] == 'delete')
75 {
76 $admin->page_confirm(_('Are you sure you want to delete this user?'), 'user.php', 'kill', array('userid' => $bugsys->input_clean('userid', TYPE_UINT)));
77 }
78
79 // ###################################################################
80
81 if ($_POST['do'] == 'insert')
82 {
83 $user = new UserAPI($bugsys);
84 $user->set('displayname', $bugsys->in['displayname']);
85 $user->set('email', $bugsys->in['email']);
86 $user->set('showemail', $bugsys->in['showemail']);
87 $user->set('showcolors', $bugsys->in['showcolors']);
88 $user->set('usergroupid', $bugsys->in['usergroupid']);
89 $user->set('languageid', $bugsys->in['languageid']);
90 $user->set('timezone', $bugsys->in['timezone']);
91 $user->set('usedst', $bugsys->in['usedst']);
92 $user->set('password', $bugsys->in['password']);
93 $user->set('hidestatuses', $bugsys->in['hidestatuses']);
94 $user->set('defaultsortkey', $bugsys->in['defaultsortkey']);
95 $user->set('defaultsortas', $bugsys->in['defaultsortas']);
96 $user->insert();
97
98 // post_insert will set the email options... so we now have to dump them
99 $db->query("DELETE FROM " . TABLE_PREFIX . "useremail WHERE userid = " . $user->insertid);
100
101 $bugsys->input_clean('emailopts', TYPE_INT);
102 if (is_array($bugsys->in['emailopts']))
103 {
104 foreach ($bugsys->in['emailopts'] AS $relation => $bitarr)
105 {
106 $bitmask = 0;
107 foreach ($bitarr AS $option => $yes)
108 {
109 $bitmask += $option * $yes;
110 }
111 $db->query("INSERT INTO " . TABLE_PREFIX . "useremail (userid, relation, mask) VALUES (" . $user->insertid . ", $relation, $bitmask)");
112 }
113 }
114
115 $admin->redirect('user.php?do=edit&userid=' . $user->insertid);
116 }
117
118 // ###################################################################
119
120 if ($_POST['do'] == 'update')
121 {
122 $user = new UserAPI($bugsys);
123 $user->set('userid', $bugsys->in['userid']);
124 $user->set_condition();
125 $user->set('displayname', $bugsys->in['displayname']);
126 $user->set('email', $bugsys->in['email']);
127 $user->set('showemail', $bugsys->in['showemail']);
128 $user->set('showcolors', $bugsys->in['showcolors']);
129 $user->set('usergroupid', $bugsys->in['usergroupid']);
130 $user->set('languageid', $bugsys->in['languageid']);
131 $user->set('timezone', $bugsys->in['timezone']);
132 $user->set('usedst', $bugsys->in['usedst']);
133 $user->set('password', $bugsys->in['password']);
134 $user->set('hidestatuses', $bugsys->in['hidestatuses']);
135 $user->set('defaultsortkey', $bugsys->in['defaultsortkey']);
136 $user->set('defaultsortas', $bugsys->in['defaultsortas']);
137 $user->update();
138
139 $db->query("DELETE FROM " . TABLE_PREFIX . "useremail WHERE userid = " . $user->values['userid']);
140 $bugsys->input_clean('emailopts', TYPE_INT);
141 if (is_array($bugsys->in['emailopts']))
142 {
143 foreach ($bugsys->in['emailopts'] AS $relation => $bitarr)
144 {
145 $bitmask = 0;
146 foreach ($bitarr AS $option => $yes)
147 {
148 $bitmask += $option * $yes;
149 }
150 $db->query("INSERT INTO " . TABLE_PREFIX . "useremail (userid, relation, mask) VALUES (" . $user->values['userid'] . ", $relation, $bitmask)");
151 }
152 }
153
154 $admin->redirect('user.php?do=edit&userid=' . $user->objdata['userid']);
155 }
156
157 // ###################################################################
158
159 if ($_REQUEST['do'] == 'edit' OR $_REQUEST['do'] == 'add')
160 {
161 $add = ($_REQUEST['do'] == 'add');
162 $edit = (!$add);
163
164 if ($edit)
165 {
166 NavLinks::usersEdit($bugsys->in['userid']);
167 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
168
169 $user = new UserAPI($bugsys);
170 $user->set('userid', $bugsys->in['userid']);
171 $user->set_condition();
172 $user->fetch();
173 }
174 else
175 {
176 NavLinks::usersAdd();
177 $navigator->set_focus('link', 'users-add', 'users');
178 }
179
180 $admin->page_start(($add ? _('Add User') : _('Edit User')));
181
182 $admin->form_start('user.php', ($add ? 'insert' : 'update'));
183
184 if ($edit)
185 {
186 $admin->form_hidden_field('userid', $user->objdata['userid']);
187 }
188
189 $admin->table_start();
190
191 $admin->table_head(($add ? _('Add User') : sprintf(_('Edit User (userid: %1$s)'), $user->objdata['userid'])));
192
193 $admin->row_input(_('Display Name'), 'displayname', $user->objdata['displayname']);
194 $admin->row_input(_('Email'), 'email', $user->objdata['email']);
195 $admin->row_input(($add ? _('Password') : _('Password (Leave blank for no change)')), 'password');
196
197 foreach ($bugsys->datastore['usergroup'] AS $group)
198 {
199 $admin->list_item($group['title'], $group['usergroupid'], ($user->objdata['usergroupid'] == $group['usergroupid']));
200 }
201 $admin->row_list(_('Usergroup'), 'usergroupid');
202
203 $admin->row_yesno(_('Show Email Publicly'), 'showemail', $user->objdata['showemail']);
204 $admin->row_yesno(_('Show Status Colors on Bug Listings'), 'showcolors', $user->objdata['showcolors']);
205
206 foreach ($bugsys->datastore['language'] AS $language)
207 {
208 $admin->list_item($language['title'], $language['languageid'], ($user->objdata['languageid'] == $language['languageid']));
209 }
210 $admin->row_list(_('Language'), 'languageid');
211
212 foreach ($datef->fetch_timezone_list() AS $value => $string)
213 {
214 $admin->list_item($string, $value, ($user->objdata['timezone'] == $value));
215 }
216 $admin->row_list(_('Timezone'), 'timezone');
217
218 $admin->row_yesno(_('Observe Daylight Savings Time (DST)'), 'usedst', $user->objdata['usedst']);
219 $admin->row_text(_('Hidden Statuses on Bug Listing'), construct_option_select('hidestatuses', $bugsys->datastore['status'], $user->objdata['hidestatuses'], 'statusid', 'status', 0, true));
220 $admin->row_text(_('Default Sort Order Column'), construct_option_select('defaultsortkey', ListSorter::fetch_by_text(false), $user->objdata['defaultsortkey']));
221 $admin->row_text(_('Default Sort Order Direction'), construct_option_select('defaultsortas', ListSorter::fetch_as_text(false), $user->objdata['defaultsortas']));
222
223 $admin->table_end();
224
225 // -------------------------------------------------------------------
226 $admin->table_start(false);
227 $admin->table_head(_('Email Options'), 6);
228
229 if ($user->objdata['userid'])
230 {
231 $options = $db->query("SELECT * FROM " . TABLE_PREFIX . "useremail WHERE userid = " . $user->objdata['userid']);
232 while ($opt = $db->fetch_array($options))
233 {
234 foreach ($bugsys->emailoptions['notifications'] AS $name => $notif)
235 {
236 foreach ($bugsys->emailoptions['relations'] AS $name => $relation)
237 {
238 if ($opt['mask'] & $notif AND $opt['relation'] == $relation)
239 {
240 $checked["$relation"]["$notif"] = HTML_CHECKED;
241 }
242 }
243 }
244 }
245 }
246
247 $admin->table_column_head(array('', _('Reporter'), _('Assignee'), _('Favorite'), _('Voter'), _('Commenter')));
248
249 // -------------------------------------------------------------------
250
251 $admin->row_text(_('New bug is added'), '<div style="text-align: center">' . draw_checkbox('emailopts[0][2048]', $checked[0][2048]) . '</div>', 'top', 6);
252
253 $admin->row_text(_('I am made the assignee'), '<div style="text-align: center">' . draw_checkbox('emailopts[0][32]', $checked[0][32]) . '</div>', 'top', 6);
254
255 $admin->row_multi_item(array(
256 _('Status or resolution changes') => 'l',
257 draw_checkbox('emailopts[1][64]', $checked[1][64]) => 'c',
258 draw_checkbox('emailopts[2][64]', $checked[2][64]) => 'c',
259 draw_checkbox('emailopts[4][64]', $checked[4][64]) => 'c',
260 draw_checkbox('emailopts[8][64]', $checked[8][64]) => 'c',
261 draw_checkbox('emailopts[16][64]', $checked[16][64]) => 'c',
262 ));
263
264 $admin->row_multi_item(array(
265 _("'Duplicates' field is changed") => 'l',
266 draw_checkbox('emailopts[1][128]', $checked[1][128]) => 'c',
267 draw_checkbox('emailopts[2][128]', $checked[2][128]) => 'c',
268 draw_checkbox('emailopts[4][128]', $checked[4][128]) => 'c',
269 draw_checkbox('emailopts[8][128]', $checked[8][128]) => 'c',
270 draw_checkbox('emailopts[16][128]', $checked[16][128]) => 'c',
271 ));
272
273 $admin->row_multi_item(array(
274 _('A new comment is added') => 'l',
275 draw_checkbox('emailopts[1][256]', $checked[1][256]) => 'c',
276 draw_checkbox('emailopts[2][256]', $checked[2][256]) => 'c',
277 draw_checkbox('emailopts[4][256]', $checked[4][256]) => 'c',
278 draw_checkbox('emailopts[8][256]', $checked[8][256]) => 'c',
279 draw_checkbox('emailopts[16][256]', $checked[16][256]) => 'c',
280 ));
281
282 $admin->row_multi_item(array(
283 _('A new attachment is added') => 'l',
284 draw_checkbox('emailopts[1][512]', $checked[1][512]) => 'c',
285 draw_checkbox('emailopts[2][512]', $checked[2][512]) => 'c',
286 draw_checkbox('emailopts[4][512]', $checked[4][512]) => 'c',
287 draw_checkbox('emailopts[8][512]', $checked[8][512]) => 'c',
288 draw_checkbox('emailopts[16][512]', $checked[16][512]) => 'c',
289 ));
290
291 $admin->row_multi_item(array(
292 _('Any other field changes') => 'l',
293 draw_checkbox('emailopts[1][1024]', $checked[1][1024]) => 'c',
294 draw_checkbox('emailopts[2][1024]', $checked[2][1024]) => 'c',
295 draw_checkbox('emailopts[4][1024]', $checked[4][1024]) => 'c',
296 draw_checkbox('emailopts[8][1024]', $checked[8][1024]) => 'c',
297 draw_checkbox('emailopts[16][1024]', $checked[16][1024]) => 'c',
298 ));
299
300 // -------------------------------------------------------------------
301 $admin->row_submit(null, ':save:', ':reset:', 6);
302
303 $admin->table_end();
304 $admin->form_end();
305
306 $admin->page_end();
307 }
308
309 // ###################################################################
310
311 if ($_REQUEST['do'] == 'search')
312 {
313 $fail = false;
314
315 NavLinks::usersAdd();
316 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
317
318 if (is_numeric($bugsys->in['userdata']))
319 {
320 $bugsys->input_clean('userdata', TYPE_UINT);
321 if ($db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = " . $bugsys->in['userdata']))
322 {
323 header('Location: user.php?do=edit&userid=' . $bugsys->in['userdata']);
324 }
325 else
326 {
327 $fail = true;
328 }
329 }
330 else
331 {
332 $bugsys->in['userdata'] = str_replace('%', '\%', $bugsys->in['userdata']);
333 $results = $db->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE email LIKE '%" . $bugsys->input_escape('userdata') . "%' OR displayname LIKE '%" . $bugsys->input_escape('userdata') . "%'");
334
335 if ($db->num_rows($results) < 1)
336 {
337 $fail = true;
338 }
339 else
340 {
341 $admin->page_start(_('Search Results'));
342
343 $admin->table_start();
344 $admin->table_head(_('Search Results'), 4);
345 $admin->table_column_head(array(_('Display Name'), _('Email'), _('User ID'), _('Actions')));
346
347 while ($row = $db->fetch_array($results))
348 {
349 $admin->row_multi_item(array(
350 $row['displayname'] => 'l',
351 $row['email'] => 'c',
352 $row['userid'] => 'c',
353 '<a href="user.php?do=edit&amp;userid=' . $row['userid'] . '">[' . _('Edit') . ']</a>' => 'c'
354 ));
355 }
356
357 $admin->table_end();
358
359 $admin->page_end();
360 }
361 }
362
363 if ($fail)
364 {
365 $admin->error(_('Sorry, we could not find any users that matched your criteria.'));
366 }
367 }
368
369 // ###################################################################
370
371 if ($_REQUEST['do'] == 'showall')
372 {
373 NavLinks::usersAdd();
374 $navigator->set_focus('link', 'users-showall', 'users');
375
376 LoadPaginationFramework();
377 $pagination->setBitProcessor('AdminPageNavigatorBitCallback');
378 $pagination->setNavigatorProcessor('AdminPageNavigatorCallback');
379
380 $admin->page_start(_('Show All Users'));
381 $admin->table_start();
382 $admin->table_head(_('Show All Users'), 4);
383 $admin->table_column_head(array(_('Display Name'), _('Email'), _('User ID'), _('Actions')));
384
385 $count = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user");
386 $pagination->setTotal($count['count']);
387 $pagination->splitPages();
388
389 $users = $db->query("SELECT * FROM " . TABLE_PREFIX . "user ORDER BY userid ASC LIMIT " . $pagination->fetchLimit($pagination->getPage() - 1) . ", " . $pagination->getPerPage());
390 while ($user = $db->fetch_array($users))
391 {
392 $admin->row_multi_item(array(
393 $user['displayname'] => 'l',
394 $user['email'] => 'c',
395 $user['userid'] => 'c',
396 '<a href="user.php?do=edit&amp;userid=' . $user['userid'] . '">[' . _('Edit') . ']</a>' => 'c'
397 ));
398 }
399
400 $admin->table_end();
401
402 $admin->page_code($pagination->constructPageNav('user.php?do=showall'));
403
404 $admin->page_end();
405 }
406
407 // ###################################################################
408
409 if ($_REQUEST['do'] == 'modify')
410 {
411 NavLinks::usersAdd();
412 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
413
414 $admin->page_start(_('User Search'));
415
416 $admin->form_start('user.php', 'search');
417 $admin->table_start(true, '45%');
418
419 $admin->table_head(_('User Search'));
420 $admin->row_input(_('Name/Email/ID'), 'userdata');
421
422 $admin->row_submit('', ':save:', '');
423
424 $admin->table_end();
425 $admin->form_end();
426
427 $admin->page_end();
428 }
429
430 /*=====================================================================*\
431 || ###################################################################
432 || # $HeadURL$
433 || # $Id$
434 || ###################################################################
435 \*=====================================================================*/
436 ?>