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 ?>