diff options
| author | Manuel Schwarz <manschwa@uos.de> | 2022-09-29 15:09:44 +0200 |
|---|---|---|
| committer | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2025-07-01 12:55:05 +0200 |
| commit | b06634ab30ecc95a0c03640c3cd588f04e6a1288 (patch) | |
| tree | 885117d058e4ea456cb226e9467365c490feeaf2 /lib/classes/globalsearch/GlobalSearchCourses.php | |
| parent | b6d92a02e777c40d76c7ca2909c635449f3820d3 (diff) | |
Ändert die Sortierung von Veranstaltungen, ref #1347
Diffstat (limited to 'lib/classes/globalsearch/GlobalSearchCourses.php')
| -rw-r--r-- | lib/classes/globalsearch/GlobalSearchCourses.php | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/lib/classes/globalsearch/GlobalSearchCourses.php b/lib/classes/globalsearch/GlobalSearchCourses.php index 939203c..ce82199 100644 --- a/lib/classes/globalsearch/GlobalSearchCourses.php +++ b/lib/classes/globalsearch/GlobalSearchCourses.php @@ -120,11 +120,12 @@ class GlobalSearchCourses extends GlobalSearchModule implements GlobalSearchFull {$institute_condition} {$seminar_type_condition} {$semester_condition} - GROUP BY courses.Seminar_id - ORDER BY MAX(`semester_data`.`beginn`) DESC"; + GROUP BY courses.Seminar_id"; if (Config::get()->IMPORTANT_SEMNUMBER) { - $sql .= ", courses.`VeranstaltungsNummer`"; + $sql .= " ORDER BY CASE WHEN courses.`VeranstaltungsNummer` THEN courses.`VeranstaltungsNummer` ELSE MAX(`semester_data`.`beginn`) END"; + } else { + $sql .= " ORDER BY MAX(`semester_data`.`beginn`) DESC"; } $sql .= ", `Name`"; |
