browse.php File Reference

Namespaces
namespace	studip_core

Variables
	$template = $GLOBALS['template_factory']->open('browse')
if(!Request::submitted('reset')) if(isset($name))	$sortby_fields = array('perms', 'status')
	$sortby = Request::option('sortby')
	$db = DBManager::get()
	$vis_query = get_vis_query('auth_user_md5', 'search') . ' AS visible'
	$search_object
	$fields = array($_fullname_sql['full_rev'].' AS fullname', 'username', 'perms', 'auth_user_md5.user_id', $vis_query)
	$tables = array('auth_user_md5', 'LEFT JOIN user_info USING (user_id)', 'LEFT JOIN user_visibility USING (user_id)')
if($inst_id) if($sem_id) if(strlen($name) > 2)	if (count($filter))

Variable Documentation

$db = DBManager::get()

$fields = array($_fullname_sql['full_rev'].' AS fullname', 'username', 'perms', 'auth_user_md5.user_id', $vis_query)

$search_object

Initial value:

 new SQLSearch("SELECT username, CONCAT(Vorname, ' ', Nachname, ' (', username, ')'), CONCAT(Vorname, ' ', Nachname), $vis_query" .
                               " FROM auth_user_md5 LEFT JOIN user_visibility USING (user_id)" .
                               " WHERE CONCAT(Vorname, ' ', Nachname) LIKE :input HAVING visible = 1".
                               " ORDER BY Nachname, Vorname", _('Nutzer suchen'), 'username')

$sortby = Request::option('sortby')

if (!Request::submitted('reset')) if (isset($name)) $sortby_fields = array('perms', 'status')

$tables = array('auth_user_md5', 'LEFT JOIN user_info USING (user_id)', 'LEFT JOIN user_visibility USING (user_id)')

$template = $GLOBALS['template_factory']->open('browse')

$vis_query = get_vis_query('auth_user_md5', 'search') . ' AS visible'

if ($inst_id) if ($sem_id) if (strlen($name) > 2) if(count($filter))