1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
<?php
/*
* studip_lecture_tree.php - base class for lecture tree
*
* Copyright (C) 2006 - Marco Diedrich (mdiedric@uos.de)
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation; either version 2 of
* the License, or (at your option) any later version.
*/
class StudipLectureTreeHelper
{
public static function get_seminars_by_sem_tree_id($sem_tree_id, $term_id)
{
$db = DBManager::get();
$semester = Semester::find($term_id);
$stmt = $db->prepare('
SELECT s.Seminar_id AS seminar_id, s.Name AS name
FROM seminar_sem_tree st
LEFT JOIN seminare s ON (st.seminar_id = s.Seminar_id)
LEFT JOIN semester_courses ON (s.Seminar_id = semester_courses.course_id)
WHERE st.sem_tree_id = ?
AND s.start_time <= ?
AND (semester_courses.semester_id IS NULL OR semester_courses.semester_id = ?)
GROUP BY s.Seminar_id
');
$stmt->execute([$sem_tree_id, $semester->beginn, $semester->semester_id]);
return $stmt->fetchAll();
}
public static function get_sem_path($sem_tree_id)
{
$stack = (array) $sem_tree_id;
$info = StudipLectureTreeHelper::get_info_for_sem_tree_id($sem_tree_id);
$name_parts = [];
while(($current = array_pop($stack))) {
$info = StudipLectureTreeHelper::get_info_for_sem_tree_id($current);
array_push($stack, $info['parent_id']);
$name_parts = array_merge((array) $info['name'], $name_parts);
$last = $current;
}
return implode (" > ", $name_parts);
}
public static function get_info_for_sem_tree_id($sem_tree_id)
{
$db = DBManager::get();
$stmt = $db->prepare("SELECT st.sem_tree_id AS id, st.parent_id,
IF (st.name IS NULL OR st.name = '', i.Name, st.name) AS name
FROM sem_tree st
LEFT JOIN Institute i ON (st.studip_object_id = i.Institut_id)
WHERE st.sem_tree_id = ?
GROUP BY st.sem_tree_id");
$stmt->execute([$sem_tree_id]);
return $stmt->fetchAll();
}
public static function get_subtree($sem_tree_id)
{
$stack = $collected = [$sem_tree_id];
while ($current = array_pop($stack)) {
$local_tree = StudipLectureTreeHelper::get_local_tree($current);
$collected = array_merge($collected, $local_tree);
$stack = array_merge($local_tree, $stack); // depth first
}
return $collected;
}
public static function get_subtree_seminar_count($sem_tree_id, $only_visible = true)
{
$db = DBManager::get();
$subtree_entries = StudipLectureTreeHelper::get_subtree($sem_tree_id);
$subtree_entries = array_map([$db, 'quote'], $subtree_entries);
$stmt = $db->prepare('SELECT COUNT(sst.seminar_id) AS seminar_count
FROM seminar_sem_tree sst
JOIN seminare s ON sst.seminar_id = s.Seminar_id
WHERE sst.sem_tree_id IN (' . join(',', $subtree_entries) . ')' .
($only_visible ? ' AND s.visible = 1' : ''));
$stmt->execute();
return $stmt->fetchColumn();
}
public static function get_local_tree($sem_tree_id)
{
$db = DBManager::get();
$stmt = $db->prepare('SELECT sem_tree_id FROM sem_tree WHERE parent_id = ? ORDER BY priority');
$stmt->execute([$sem_tree_id]);
return $stmt->fetchAll(PDO::FETCH_COLUMN);
}
}
|
