Stud.IP  trunk Revision
admin_literatur_overview.php File Reference

Functions

 get_lit_admin_ids ($user_id=false)
 

Variables

foreach($GLOBALS['SEM_CLASS'] as $key=> $value$_sem_status_sql = ((is_array($allowed_sem_status)) ? " s.status IN('" . join("','",$allowed_sem_status) . "') AND " : "")
 
 $_check_list = Request::optionArray('_check_list')
 
 $element = new StudipLitCatElement()
 
if(Request::option('cmd')=='check' &&!isset($_check_list)) if(Request::quoted('send')) if(Request::get('open_element')) if(Request::get('close_element')) if(Request::option('_catalog_id')) if(Request::option('cmd')=='markall' &&is_array($_SESSION['_lit_data'])) if(Request::option('cmd')=='open_all' &&is_array($_SESSION['_lit_data'])) if(Request::option('cmd')=='close_all') if(Request::option('cmd')=='check' &&is_array($_SESSION['_check_list']) &&is_array($_SESSION['_lit_data'])) if(Request::option('_semester_id') &&Request::option('_semester_id') !='all') else
 
 $_sem_sql2 = ""
 
 $_is_fak = false
 
 $_lit_admin_ids = get_lit_admin_ids()
 
 $_is_lit_admin = (is_array($_lit_admin_ids) && count($_lit_admin_ids))
 
 $_search_plugins = array_keys(StudipLitSearch::GetAvailablePlugins())
 
if(in_array('Studip', $_search_plugins)) $preferred_plugin = StudipLitSearch::getPreferredPlugin()
 
if($preferred_plugin &&in_array($preferred_plugin, $_search_plugins)) $query
 
 $institute_statement = DBManager::get()->prepare($query)
 
 $parameters = []
 
 $parameters [] = $_lit_admin_ids
 
 $statement = DBManager::get()->prepare($query)
 
 $institutes = $statement->fetchAll(PDO::FETCH_ASSOC)
 
 $sql2
 
 $sidebar = Sidebar::Get()
 
 $links = new ActionsWidget()
 
 $layout = $GLOBALS['template_factory']->open('layouts/base')
 
$layout content_for_layout = ob_get_clean()
 

Function Documentation

◆ get_lit_admin_ids()

get_lit_admin_ids (   $user_id = false)
Here is the call graph for this function:

Variable Documentation

◆ $_check_list

$_check_list = Request::optionArray('_check_list')

◆ $_is_fak

$_is_fak = false

◆ $_is_lit_admin

$_is_lit_admin = (is_array($_lit_admin_ids) && count($_lit_admin_ids))

◆ $_lit_admin_ids

$_lit_admin_ids = get_lit_admin_ids()

◆ $_search_plugins

$_search_plugins = array_keys(StudipLitSearch::GetAvailablePlugins())

◆ $_sem_sql2

$_sem_sql2 = ""

◆ $_sem_status_sql

foreach ( $GLOBALS[ 'SEM_CLASS'] as $key=> $value) $_sem_status_sql = ((is_array($allowed_sem_status)) ? " s.status IN('" . join("','",$allowed_sem_status) . "') AND " : "")

◆ $element

$element = new StudipLitCatElement()

◆ $institute_statement

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

◆ $institutes

$institutes = $statement->fetchAll(PDO::FETCH_ASSOC)

◆ $layout

$layout = $GLOBALS['template_factory']->open('layouts/base')

◆ $links

$links = new ActionsWidget()

◆ $parameters [1/2]

$parameters = []

◆ $parameters [2/2]

$parameters[] = $_lit_admin_ids

◆ $preferred_plugin

if (in_array( 'Studip', $_search_plugins)) $preferred_plugin = StudipLitSearch::getPreferredPlugin()

◆ $query

if ( $preferred_plugin &&in_array( $preferred_plugin, $_search_plugins)) $query
Initial value:
= "SELECT a.Institut_id, a.Name, COUNT(DISTINCT catalog_id) AS anzahl
FROM Institute AS a
LEFT JOIN seminar_inst AS c USING (Institut_id)
{$_sem_sql}
LEFT JOIN lit_list_content AS e USING (list_id)
WHERE fakultaets_id = ? AND a.institut_id != fakultaets_id
GROUP BY a.Institut_id
ORDER BY Name"

◆ $sidebar

$sidebar = Sidebar::Get()

◆ $sql2

$sql2
Initial value:
= "SELECT s.Name, s.Seminar_id, admission_turnout, COUNT(DISTINCT su.user_id) AS participants
FROM seminar_inst AS c
INNER JOIN seminare AS s ON ({$_sem_status_sql} c.seminar_id = s.Seminar_id)
{$_sem_sql2}
INNER JOIN lit_list AS d ON (c.seminar_id = d.range_id)
INNER JOIN lit_list_content AS e USING(list_id)
LEFT JOIN seminar_user AS su ON (c.seminar_id = su.seminar_id)
WHERE c.institut_id = ? AND catalog_id = ?
GROUP BY s.Seminar_id
ORDER BY s.Name"

◆ $statement

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

◆ content_for_layout

$layout content_for_layout = ob_get_clean()

◆ else

foreach ( $institutes as $institute) foreach (SemesterData::getAllSemesterData() as $sem) foreach ( $_search_plugins as $sp) if ( $_is_fak) else
Initial value:
{
$_sem_sql = " LEFT JOIN seminare s ON ($_sem_status_sql c.seminar_id=s.Seminar_id)
LEFT JOIN lit_list d ON (s.Seminar_id = d.range_id) "