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

return $_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"

$_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=?"]

$sem_start_times = []

temp_table_type

Initial value:

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