diff options
| author | Rasmus Fuhse <fuhse@data-quest.de> | 2022-03-31 14:17:41 +0000 |
|---|---|---|
| committer | André Noack <noack@data-quest.de> | 2022-03-31 14:17:41 +0000 |
| commit | b7802baa589843f44f5cbed5a04dd522bd54daa0 (patch) | |
| tree | 5129c94b428c3b1dbf9aaccc12b64e38b3d6bff7 /app/controllers/shared/modul.php | |
| parent | 8073d9c7cb2e8e187cbfb776b865ec9ba2623c25 (diff) | |
Resolve "Unbegrenzte Veranstaltungen haben Startzeitpunkt!"
Diffstat (limited to 'app/controllers/shared/modul.php')
| -rw-r--r-- | app/controllers/shared/modul.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/controllers/shared/modul.php b/app/controllers/shared/modul.php index cd2e96b..55644db 100644 --- a/app/controllers/shared/modul.php +++ b/app/controllers/shared/modul.php @@ -156,13 +156,13 @@ class Shared_ModulController extends AuthenticatedController $stm = DBManager::get()->prepare('SELECT DISTINCT auth_user_md5.username FROM auth_user_md5 JOIN seminar_user ON (auth_user_md5.user_id = seminar_user.user_id) JOIN seminare ON (seminare.seminar_id = seminar_user.seminar_id) - JOIN semester_data ON (seminare.start_time = semester_data.beginn) + LEFT JOIN semester_courses ON (seminare.seminar_id = semester_courses.course_id) JOIN mvv_lvgruppe_seminar ON (mvv_lvgruppe_seminar.seminar_id = seminare.seminar_id) JOIN mvv_lvgruppe_modulteil ON (mvv_lvgruppe_modulteil.lvgruppe_id = mvv_lvgruppe_seminar.lvgruppe_id) JOIN mvv_modulteil ON (mvv_modulteil.modulteil_id = mvv_lvgruppe_modulteil.modulteil_id) WHERE mvv_modulteil.modul_id = :modul_id AND seminar_user.status = :status - AND semester_data.semester_id = :semester_id'); + AND (semester_courses.semester_id = :semester_id OR semester_courses.semester_id IS NULL)'); $stm->execute(['modul_id' => $modul_id, 'status' => 'autor', ':semester_id' => $semester_id]); $_SESSION['sms_data']['p_rec'] = $stm->fetchFirst(); |
