aboutsummaryrefslogtreecommitdiff
path: root/lib/classes/globalsearch/GlobalSearchCourses.php
diff options
context:
space:
mode:
authorManuel Schwarz <manschwa@uos.de>2022-09-29 15:09:44 +0200
committerJan-Hendrik Willms <tleilax+studip@gmail.com>2025-07-01 12:55:05 +0200
commitb06634ab30ecc95a0c03640c3cd588f04e6a1288 (patch)
tree885117d058e4ea456cb226e9467365c490feeaf2 /lib/classes/globalsearch/GlobalSearchCourses.php
parentb6d92a02e777c40d76c7ca2909c635449f3820d3 (diff)
Ändert die Sortierung von Veranstaltungen, ref #1347
Diffstat (limited to 'lib/classes/globalsearch/GlobalSearchCourses.php')
-rw-r--r--lib/classes/globalsearch/GlobalSearchCourses.php7
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`";