|
| $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 ["SEM_TREE_GET_DATA_NO_ENTRIES"] = ["pk"=>"sem_tree_id" |
|
| temp_table_type |
|
| $_views ["SEM_TREE_GET_ENTRIES"] = ["pk"=>"sem_tree_id" |
|
| $_views ["SEM_TREE_GET_SEMIDS"] = ["pk"=>"seminar_id" |
|
| $_views ["SEM_TREE_GET_SEMIDS_ROOT"] = ["pk"=>"seminar_id" |
|
| $_views ["SEM_TREE_GET_SEMDATA"] |
|
| $_views ["SEM_TREE_GET_SEMDATA_ROOT"] |
|
| $_views ["SEM_TREE_GET_NUM_SEM"] |
|
| $_views ["SEM_TREE_GET_LONELY_SEM_DATA"] |
|
| $_views ["SEM_TREE_GET_NUM_LONELY_SEM"] |
|
| $_views ["SEM_TREE_GET_LONELY_FAK"] = ["query" => "SELECT Institut_id,a.Name FROM Institute a LEFT JOIN sem_tree b ON(studip_object_id=Institut_id) WHERE Institut_id = fakultaets_id AND ISNULL(studip_object_id) ORDER BY a.Name"] |
|
| $_views ["SEM_TREE_UPD_PRIO"] = ["query" => "UPDATE sem_tree SET priority=§ WHERE sem_tree_id=?"] |
|
| $_views ["SEM_TREE_INS_ITEM"] = ["query" => "INSERT INTO sem_tree (sem_tree_id,parent_id,name,priority,info,studip_object_id,type) VALUES (?,?,?,?,?,?,?)"] |
|
| $_views ["SEM_TREE_UPD_ITEM"] = ["query" => "UPDATE sem_tree SET name=?, info=?, type=? WHERE sem_tree_id=?"] |
|
| $_views ["SEM_TREE_DEL_ITEM"] = ["query" => "DELETE FROM sem_tree WHERE sem_tree_id IN (&)"] |
|
| $_views ["SEM_TREE_MOVE_ITEM"] = ["query" => "UPDATE sem_tree SET parent_id=?, priority=§ WHERE sem_tree_id=?"] |
|
| $_views ["SEM_TREE_SEARCH_SEM"] |
|
| $_views ["SEM_TREE_CHECK_PERM"] = ["query" => "SELECT inst_perms FROM user_inst WHERE inst_perms='admin' AND user_id=? AND Institut_id=?"] |
|
| $_views ["SEM_TREE_SEARCH_ITEM"] = ["query" => "SELECT a.sem_tree_id,a.parent_id FROM sem_tree a LEFT JOIN sem_tree b ON(a.sem_tree_id=b.parent_id) WHERE a.name LIKE ? AND ISNULL(b.sem_tree_id) AND a.sem_tree_id NOT IN(&)"] |
|
| $_views ["SEMINAR_SEM_TREE_DEL_RANGE"] = ["query" => "DELETE FROM seminar_sem_tree WHERE sem_tree_id IN (&)"] |
|
| $_views ["SEMINAR_SEM_TREE_DEL_SEM_RANGE"] = ["query" => "DELETE FROM seminar_sem_tree WHERE sem_tree_id IN (&) AND seminar_id IN (&)"] |
|
| $_views ["SEMINAR_SEM_TREE_DEL_SEMID_RANGE"] = ["query" => "DELETE FROM seminar_sem_tree WHERE seminar_id IN (&)"] |
|
| $_views ["SEMINAR_SEM_TREE_INS_ITEM"] = ["query" => "INSERT IGNORE INTO seminar_sem_tree (seminar_id,sem_tree_id) VALUES (?,?)"] |
|
| $_views ["SEMINAR_SEM_TREE_GET_IDS"] = ["query" => "SELECT DISTINCT a.sem_tree_id,b.parent_id FROM seminar_sem_tree a INNER JOIN sem_tree b USING(sem_tree_id) WHERE seminar_id=? ORDER BY parent_id,priority"] |
|
| $_views ["SEMINAR_SEM_TREE_GET_EXP_IDS"] = ["query" => "SELECT DISTINCT b.sem_tree_id,c.parent_id FROM seminare a LEFT JOIN seminar_sem_tree b USING(seminar_id) LEFT JOIN sem_tree c USING(sem_tree_id) WHERE a.Institut_id=? AND b.sem_tree_id NOT IN(&)"] |
|
| $_views ["SEMINAR_GET_SEMDATA"] |
|
| $_views ["SEM_SEARCH_LECTURER"] = ["query" => "SELECT user_id FROM auth_user_md5 WHERE perms = 'dozent' AND (username LIKE ? OR Vorname LIKE ? OR Nachname LIKE ? OR CONCAT(Vorname, ' ', Nachname) LIKE ? OR CONCAT(Nachname, ', ', Vorname) LIKE ?)"] |
|
| $_views ["SEM_SEARCH_LECTURER_ID"] |
|
| $_views ["SEM_SEARCH_SEM"] = ["query" =>"SELECT c.seminar_id, " . $_views['sem_number_sql'] . " AS sem_number , " . $_views['sem_number_end_sql'] . " AS sem_number_end FROM seminare c WHERE § §"] |
|
| $_views ["SEM_GET_FAKS"] = ["query" => "SELECT DISTINCT b.fakultaets_id,d.sem_tree_id FROM seminar_inst a LEFT JOIN Institute b USING(Institut_id) LEFT JOIN sem_tree d ON (b.fakultaets_id=d.studip_object_id) WHERE a.seminar_id=?"] |
|
| $_views ["SEM_GET_INST"] = ["query" => "SELECT institut_id FROM seminar_inst WHERE seminar_id=?"] |
|
| $_views ["SEM_TREE_GET_FAK"] = ["query" => "SELECT DISTINCT sem_tree_id FROM Institute LEFT JOIN sem_tree ON (fakultaets_id=studip_object_id) WHERE Institut_id IN (&) AND NOT ISNULL(sem_tree_id)"] |
|
| $_views ["SEM_INST_GET_SEM"] |
|
| $_views ["SEM_USER_GET_SEM"] |
|