Resolve "Veranstaltungs-Stundenplan: Anzeigefilter für Terminkachel einbauen"

Closes #5585

Merge request studip/studip!4209

1 files changed, 13 insertions, 0 deletions

diff --git a/lib/models/CourseDate.php b/lib/models/CourseDate.php
index 0fb9e08..038a120 100644
--- a/lib/models/CourseDate.php
+++ b/lib/models/CourseDate.php
@@ -740,5 +740,18 @@ class CourseDate extends SimpleORMap implements PrivacyObject, Event
         );
     }
 
+    /**
+     * returns the next single date within a given cycle
+     */
+    public static function getNextDateByMetadate($metadate_id): ?self
+    {
+        return self::findOneBySQL(
+            "`metadate_id` = :metadate_id
+             AND `date` >= UNIX_TIMESTAMP()
+             ORDER BY `date`",
+            ['metadate_id' => $metadate_id]
+        );
+    }
+
     //End of Event interface implementation.
 }