Stud.IP  6.0
range_tree.view.php File Reference

Variables

 $sem_start_times = []
 
foreach(Semester::findAllVisible() as $key=> $value$_views = []
 
 $_views ['sem_number_sql'] = "INTERVAL(start_time," . join(",",$sem_start_times) .")"
 
 $_views ['sem_number_end_sql'] = "IF(duration_time=-1,-1,INTERVAL(start_time+duration_time," . join(",",$sem_start_times) ."))"
 
 $_views ["TREE_KIDS"] = ["pk"=>"item_id"
 
 temp_table_type
 
 $_views ["TREE_GET_DATA"] = ["pk"=>"item_id"
 
 $_views ["TREE_GET_SEM_ENTRIES"] = ["pk"=>"item_id"
 
 $_views ["TREE_OBJECT_NAME"] = ["pk"=>""
 
 $_views ["TREE_OBJECT_DETAIL"] = ["pk"=>""
 
 $_views ["TREE_OBJECT_CAT"] = ["pk"=>"kategorie_id"
 
 $_views ["TREE_INST_STATUS"] = ["pk"=>""
 
 $_views ["TREE_FAK_STATUS"] = ["pk"=>""
 
 $_views ["TREE_ITEMS_OBJECT"] = ["pk"=>"item_id"
 
 $_views ["TREE_UPD_PRIO"] = ["query" => "UPDATE range_tree SET priority=§ WHERE item_id=?"]
 
 $_views ["TREE_INS_ITEM"] = ["query" => "INSERT INTO range_tree (item_id,parent_id,name,priority,studip_object,studip_object_id) VALUES (?,?,?,§,?,?)"]
 
 $_views ["TREE_UPD_ITEM"] = ["query" => "UPDATE range_tree SET name=?, studip_object=?, studip_object_id=? WHERE item_id=?"]
 
 $_views ["TREE_MOVE_ITEM"] = ["query" => "UPDATE range_tree SET parent_id=?, priority=§ WHERE item_id=?"]
 
 $_views ["TREE_DEL_ITEM"] = ["query" => "DELETE FROM range_tree WHERE item_id IN (&)"]
 
 $_views ["TREE_SEARCH_INST"] = ["query" => "SELECT Name,Institut_id FROM Institute WHERE fakultaets_id!=Institut_id AND Name LIKE '%§%'"]
 
 $_views ["TREE_SEARCH_FAK"] = ["query" => "SELECT Name,Institut_id AS Fakultaets_id FROM Institute WHERE fakultaets_id=Institut_id AND Name LIKE '%§%'"]
 
 $_views ["TREE_SEARCH_ITEM"] = ["pk"=>"item_id"
 
 $_views ["TREE_SEARCH_USER"] = ["pk"=>"item_id"
 
 $_views ["TREE_SEARCH_SEM"] = ["pk"=>"item_id"
 
 $_views ["CAT_UPD_PRIO"] = ["query" => "UPDATE kategorien SET priority=§,chdate=UNIX_TIMESTAMP() WHERE kategorie_id=?"]
 
 $_views ["CAT_UPD_CONTENT"] = ["query" => "UPDATE kategorien SET name=?, content=?, chdate=UNIX_TIMESTAMP() WHERE kategorie_id=?"]
 
 $_views ["CAT_INS_ALL"] = ["query" => "INSERT INTO kategorien (kategorie_id,range_id,name,content,priority,mkdate,chdate)VALUES (?,?,?,?,§,UNIX_TIMESTAMP(),UNIX_TIMESTAMP())"]
 
 $_views ["CAT_DEL"] = ["query" => "DELETE FROM kategorien WHERE kategorie_id IN (&)"]
 
 $_views ["CAT_DEL_RANGE"] = ["query" => "DELETE FROM kategorien WHERE range_id IN (&)"]
 
 $_views ["STATUS_COUNT"] = ["query"=>"SELECT count(DISTINCT user_id) AS anzahl FROM statusgruppen LEFT JOIN statusgruppe_user USING(statusgruppe_id) WHERE range_id=?"]
 

Variable Documentation

◆ $_views [1/28]

return $_views = []

◆ $_views [2/28]

$_views[ 'sem_number_sql'] = "INTERVAL(start_time," . join(",",$sem_start_times) .")"

◆ $_views [3/28]

$_views[ 'sem_number_end_sql'] = "IF(duration_time=-1,-1,INTERVAL(start_time+duration_time," . join(",",$sem_start_times) ."))"

◆ $_views [4/28]

$_views["TREE_KIDS"] = ["pk"=>"item_id"

◆ $_views [5/28]

$_views["TREE_GET_DATA"] = ["pk"=>"item_id"

◆ $_views [6/28]

$_views["TREE_GET_SEM_ENTRIES"] = ["pk"=>"item_id"

◆ $_views [7/28]

$_views["TREE_OBJECT_NAME"] = ["pk"=>""

◆ $_views [8/28]

$_views["TREE_OBJECT_DETAIL"] = ["pk"=>""

◆ $_views [9/28]

$_views["TREE_OBJECT_CAT"] = ["pk"=>"kategorie_id"

◆ $_views [10/28]

$_views["TREE_INST_STATUS"] = ["pk"=>""

◆ $_views [11/28]

$_views["TREE_FAK_STATUS"] = ["pk"=>""

◆ $_views [12/28]

$_views["TREE_ITEMS_OBJECT"] = ["pk"=>"item_id"

◆ $_views [13/28]

$_views["TREE_UPD_PRIO"] = ["query" => "UPDATE range_tree SET priority=§ WHERE item_id=?"]

◆ $_views [14/28]

$_views["TREE_INS_ITEM"] = ["query" => "INSERT INTO range_tree (item_id,parent_id,name,priority,studip_object,studip_object_id) VALUES (?,?,?,§,?,?)"]

◆ $_views [15/28]

$_views["TREE_UPD_ITEM"] = ["query" => "UPDATE range_tree SET name=?, studip_object=?, studip_object_id=? WHERE item_id=?"]

◆ $_views [16/28]

$_views["TREE_MOVE_ITEM"] = ["query" => "UPDATE range_tree SET parent_id=?, priority=§ WHERE item_id=?"]

◆ $_views [17/28]

$_views["TREE_DEL_ITEM"] = ["query" => "DELETE FROM range_tree WHERE item_id IN (&)"]

◆ $_views [18/28]

$_views["TREE_SEARCH_INST"] = ["query" => "SELECT Name,Institut_id FROM Institute WHERE fakultaets_id!=Institut_id AND Name LIKE '%§%'"]

◆ $_views [19/28]

$_views["TREE_SEARCH_FAK"] = ["query" => "SELECT Name,Institut_id AS Fakultaets_id FROM Institute WHERE fakultaets_id=Institut_id AND Name LIKE '%§%'"]

◆ $_views [20/28]

$_views["TREE_SEARCH_ITEM"] = ["pk"=>"item_id"

◆ $_views [21/28]

$_views["TREE_SEARCH_USER"] = ["pk"=>"item_id"

◆ $_views [22/28]

$_views["TREE_SEARCH_SEM"] = ["pk"=>"item_id"

◆ $_views [23/28]

$_views["CAT_UPD_PRIO"] = ["query" => "UPDATE kategorien SET priority=§,chdate=UNIX_TIMESTAMP() WHERE kategorie_id=?"]

◆ $_views [24/28]

$_views["CAT_UPD_CONTENT"] = ["query" => "UPDATE kategorien SET name=?, content=?, chdate=UNIX_TIMESTAMP() WHERE kategorie_id=?"]

◆ $_views [25/28]

$_views["CAT_INS_ALL"] = ["query" => "INSERT INTO kategorien (kategorie_id,range_id,name,content,priority,mkdate,chdate)VALUES (?,?,?,?,§,UNIX_TIMESTAMP(),UNIX_TIMESTAMP())"]

◆ $_views [26/28]

$_views["CAT_DEL"] = ["query" => "DELETE FROM kategorien WHERE kategorie_id IN (&)"]

◆ $_views [27/28]

$_views["CAT_DEL_RANGE"] = ["query" => "DELETE FROM kategorien WHERE range_id IN (&)"]

◆ $_views [28/28]

$_views["STATUS_COUNT"] = ["query"=>"SELECT count(DISTINCT user_id) AS anzahl FROM statusgruppen LEFT JOIN statusgruppe_user USING(statusgruppe_id) WHERE range_id=?"]

◆ $sem_start_times

$sem_start_times = []

◆ temp_table_type

temp_table_type
Initial value:
=>"HEAP",
"query"=>"SELECT item_id FROM range_tree WHERE parent_id=? ORDER BY priority"]