browse.php File Reference

Namespaces
	studip_core

Variables
	$template = $GLOBALS['template_factory']->open('browse')
if(!Request::submitted('reset')) if(Request::get('name') &&!Request::submitted('send')) if(isset($name))	$sortby_fields = array('perms', 'status')
	$sortby = Request::option('sortby')
	$exclude_sem = "AND Seminar_id NOT IN (SELECT seminar_id FROM auto_insert_sem)"
	$parameters = array()
if($perm->have_perm('admin'))	else
	$parameters [] = $user->id
	$statement = DBManager::get()->prepare($query)
	$vis_query = get_vis_query('auth_user_md5', 'search') . ' AS visible'
	$sql
	$search_object = new SQLSearch($sql, _('Vorname, Nachname oder Nutzername'), 'username')
	$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(mb_strlen($name) > 2)	if ( $filter &&count( $filter))

Variable Documentation

$exclude_sem

$exclude_sem = "AND Seminar_id NOT IN (SELECT seminar_id FROM auto_insert_sem)"

$fields

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

$parameters [1/2]

$parameters = array()

$parameters [2/2]

$parameters[] = $user->id

$search_object

$search_object = new SQLSearch($sql, _('Vorname, Nachname oder Nutzername'), 'username')

$sortby

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

$sortby_fields

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

$sql

$sql

Initial value:

= "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
          OR CONCAT(Nachname, ' ', Vorname) LIKE :input
          OR CONCAT(Nachname, ', ', Vorname) LIKE :input
          OR username LIKE :input
        HAVING visible = 1
        ORDER BY Nachname, Vorname"

$statement

$statement = DBManager::get()->prepare($query)

$tables

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

$template

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

$vis_query

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

else

if ( $perm->have_perm( 'admin')) else

Initial value:

{
    $query = "SELECT Institut_id, Name
              FROM user_inst
              LEFT JOIN Institute USING (institut_id)
              WHERE user_id = ? AND (Institute.modules & 16)
              ORDER BY name"

if

if ( $inst_id) if ( $sem_id) if (mb_strlen( $name) > 2) if($filter &&count($filter))