isError()) { exit_error($u->getErrorMessage(),'home'); } if($newStatus=="D") { if(!$u->setStatus($newStatus)) { exit_error($u->getErrorMessage(),'home'); } if(!$u->delete(true)) { exit_error($u->getErrorMessage(),'home'); } } else { if(!$u->setStatus($newStatus)) { exit_error($u->getErrorMessage(),'home'); } if(!$u->setUnixStatus($newStatus)) { exit_error($u->getErrorMessage(),'home'); } } $feedback = sprintf(_('User updated to %1$s status'), $statusString); } function show_users_list ($users, $filter='', $sortorder='realname') { echo '
' ._('Status') .': '. util_make_link('/admin/userlist.php', _('All')). ' '.util_make_link('/admin/userlist.php?status=A'.'&sortorder='.$sortorder,_('Active')). ' '.util_make_link('/admin/userlist.php?status=D'.'&sortorder='.$sortorder,_('Deleted')).' '.util_make_link('/admin/userlist.php?status=S'.'&sortorder='.$sortorder,_('Suspended')).' '.util_make_link('/admin/userlist.php?status=P'.'&sortorder='.$sortorder,_('(*)Pending')).''.'
'; if (!count($users)) { return; } $headers = array( _('Login'), _('Add date'), ' ', ' ', ' ', ' ', ' ' ); $headerLinks = array( '/admin/userlist.php?sortorder=user_name'.$filter, '/admin/userlist.php?sortorder=add_date'.$filter, '', '', '', '', '' ); echo $GLOBALS['HTML']->listTableTop($headers, $headerLinks); $res = db_query_params('SELECT * FROM users WHERE user_id = ANY ($1) ORDER BY '.$sortorder, array(db_int_array_to_any_clause($users))); $count = 0; while ($arr = db_fetch_array($res)) { $u = new GFUser($arr['user_id'], $arr); print '"._('Users that use plugin'). " ".$usingplugin."
\n"; $res = db_query_params ('SELECT u.user_id FROM plugins p, user_plugin up, users u WHERE p.plugin_name = $1 and up.user_id = u.user_id and p.plugin_id = up.plugin_id', array($usingplugin)); show_users_list(user_get_objects(util_result_column_to_array($res,0))); } else if (!$group_id) { $user_name_search = getStringFromRequest('user_name_search'); print "" ._('User list for ') . "" ._('All Projects'). "
"; if ($user_name_search) { $res = db_query_params ('SELECT user_id FROM users WHERE lower(user_name) LIKE $1 OR lower(lastname) LIKE $1', array (strtolower("$user_name_search%"))); $list_id = util_result_column_to_array($res,0); } if ($status) { $res = db_query_params ('SELECT user_id FROM users WHERE status = $1', array ($status)); if (isset($list_id)) { $list_id = array_merge($list_id, util_result_column_to_array($res,0)); } else { $list_id = util_result_column_to_array($res,0); } } if (! isset($list_id)) { $res = db_query_params('SELECT user_id FROM users', array ()); $list_id = util_result_column_to_array($res,0); } $filter=''; if (in_array($status,array('D','A','S','P'))) { $filter = '&status='.$status; } $sortorder = getStringFromRequest('sortorder', 'realname'); util_ensure_value_in_set ($sortorder, array('realname','user_name','lastname','firstname','user_id','status','add_date')) ; show_users_list ($list_id, $filter, $sortorder); } else { /* Show list for one project */ $project = group_get_object($group_id) ; print "" ._('User list for project: ') . "" . $project->getPublicName() . "
"; $users = $project->getUsers(); if ($users) { foreach ($project->getUsers() as $user) { $users_id[] = $user->getID(); } $filter = '&group_id='.$group_id; $sortorder = getStringFromRequest('sortorder', 'realname'); util_ensure_value_in_set ($sortorder, array('realname','user_name','lastname','firstname','user_id','status','add_date')) ; show_users_list ($users_id, $filter, $sortorder); } else { echo ''._('No user in this project').'
'; } } $HTML->footer(array()); // Local Variables: // mode: php // c-file-style: "bsd" // End: ?>