<td valign=top> <label> <strong>' . $Language->getText("admin_userlist", "status") . '</strong> </label> <select multiple name="status_values[]" size=8> <option value="ANY" ' . $anySelect . '>Any</option> <option value="' . PFUser::STATUS_ACTIVE . '" ' . getSelectedFromStatus(PFUser::STATUS_ACTIVE, $status_values) . '>' . $Language->getText("admin_userlist", "active") . '</option> <option value="' . PFUser::STATUS_RESTRICTED . '" ' . getSelectedFromStatus(PFUser::STATUS_RESTRICTED, $status_values) . '>' . $Language->getText("admin_userlist", "restricted") . '</option> <option value="' . PFUser::STATUS_DELETED . '" ' . getSelectedFromStatus(PFUser::STATUS_DELETED, $status_values) . '>' . $Language->getText("admin_userlist", "deleted") . '</option> <option value="' . PFUser::STATUS_SUSPENDED . '" ' . getSelectedFromStatus(PFUser::STATUS_SUSPENDED, $status_values) . '>' . $Language->getText("admin_userlist", "suspended") . '</option> <option value="' . PFUser::STATUS_PENDING . '" ' . getSelectedFromStatus(PFUser::STATUS_PENDING, $status_values) . '>' . $Language->getText("admin_userlist", "pending") . '</option> <option value="' . PFUser::STATUS_VALIDATED . '" ' . getSelectedFromStatus(PFUser::STATUS_VALIDATED, $status_values) . '>' . $Language->getText("admin_userlist", "validated") . '</option> <option value="' . PFUser::STATUS_VALIDATED_RESTRICTED . '" ' . getSelectedFromStatus(PFUser::STATUS_VALIDATED_RESTRICTED, $status_values) . '>' . $Language->getText("admin_userlist", "validated_restricted") . '</option> </select> </td> <td valign=top> <p> <label> <strong>' . $Language->getText('admin_main', 'search_user') . '</strong> </label> </p> <input type="text" name="user_name_search" class="user_name_search" placeholder="' . $search_purify . '" value="' . $user_name_search_purify . '" /> </td> </tr> </table> <div align="center"> <button type="submit" class="btn btn-primary">' . $search_purify . ' <i class="icon-search"></i> </button> </div> </form>'; echo "</p>"; show_users_list($result, $offset, $limit, $user_name_search, $sort_params, $status_values, $group_id); echo '<script type="text/javascript" src="/scripts/tuleap/userlist.js"></script>'; $HTML->footer(array());
$sql .= ' \'' . $user_name_search . '%\' OR lastname '; $sql .= $sys_database_type == 'mysql' ? 'LIKE' : 'ILIKE'; $sql .= ' \'' . $user_name_search . '%\' ORDER BY lastname'; $result = db_query($sql); } else { $sortorder = getStringFromRequest('sortorder', 'user_name'); $result = db_query("SELECT user_name,lastname,firstname,user_id,status,add_date FROM users ORDER BY " . $sortorder); } show_users_list($result); } else { /* Show list for one group */ print "<strong>" . group_getname($group_id) . "</strong></p>"; $result = db_query("SELECT users.user_id AS user_id,users.user_name AS user_name,users.status AS status, users.add_date AS add_date " . "FROM users,user_group " . "WHERE users.user_id=user_group.user_id AND " . "user_group.group_id='{$group_id}' ORDER BY users.user_name"); show_users_list($result); /* Show a form so a user can be added to this group */ ?> <hr /> <p> <form action="<?php echo getStringFromServer('PHP_SELF'); ?> " method="post"> <input type="hidden" name="action" value="add_to_group" /> <input name="user_id" type="TEXT" value="" /> <br /> Add User to Group (<?php print group_getname($group_id);
} } show_users_list($result, $status, $user_name_search); } else { /* Show list for one group */ print "<b>" . group_getname($group_id) . "</b>"; print "\n"; if ($status) { $where_status = "AND status='{$status}'"; } else { $where_status = ""; } $result = db_query("SELECT users.user_id AS user_id,users.user_name AS user_name,users.realname AS realname,users.email AS email,users.status AS status " . "FROM users,user_group " . "WHERE users.user_id=user_group.user_id AND " . "user_group.group_id={$group_id} {$where_status} ORDER BY users.user_name"); show_users_list($result, $status, $user_name_search); /* Show a form so a user can be added to this group */ ?> <hr> <P> <form action="<?php echo $PHP_SELF; ?> " method="post"> <input type="HIDDEN" name="action" VALUE="add_to_group"> <input name="user_id" type="TEXT" value=""> <p> Add User to Group (<?php print group_getname($group_id);
} } else { $user_name_search = ""; $result = $dao->listAllUsers(0, $offset, $limit); } } else { $result = $dao->listAllUsersForGroup($group_id, $offset, $limit); } /* * Show list of users */ $HTML->header(array('title' => $Language->getText('admin_userlist', 'title'))); echo "<p>"; echo $Language->getText('admin_userlist', 'user_list') . ": "; if (!$group_id) { echo "<strong>" . $Language->getText('admin_userlist', 'all_groups') . "</strong>"; echo '</p>'; $session_dao = new SessionDao(); echo '<p>'; echo '<form action="/admin/sessions.php" method="post">'; $csrf = new CSRFSynchronizerToken('/admin/sessions.php'); echo $csrf->fetchHTMLInput(); echo $Language->getText('admin_userlist', 'active_sessions', $session_dao->count()); echo '</form>'; } else { $pm = ProjectManager::instance(); echo "<strong>" . $Language->getText('admin_userlist', 'group', array($pm->getProject($group_id)->getPublicName())) . "</strong>"; } echo "</p>"; show_users_list($result, $offset, $limit, $user_name_search); $HTML->footer(array());