browse.php File Reference

Namespaces
namespace	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'
	$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(mb_strlen( $name) > 2)	if (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

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

$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(count($filter))

(

count( $filter)

)