Resolve "Studiengruppen erweitern" - Hauptbronch

Closes #3616

Merge request studip/studip!2509

1 files changed, 36 insertions, 0 deletions

diff --git a/lib/models/StudygroupCourseProposal.php b/lib/models/StudygroupCourseProposal.php
new file mode 100644
index 0000000..b746fbc
--- /dev/null
+++ b/lib/models/StudygroupCourseProposal.php
@@ -0,0 +1,36 @@
+<?php
+
+/**
+ * @license GPL2 or any later version
+ *
+ * @property string $id alias column for tag_hash
+ * @property string $studygroup_id database column
+ * @property string $course_id database column
+ * @property string $proposed_from database column 'course' or 'studygroup'
+ * @property string $user_id database column
+ * @property int $mkdate database column
+ *
+ */
+class StudygroupCourseProposal extends SimpleORMap
+{
+    protected static function configure($config = [])
+    {
+        $config['db_table'] = 'studygroup_courses_proposals';
+        $config['belongs_to']['course'] = [
+            'class_name'        => Course::class,
+            'foreign_key'       => 'course_id',
+            'assoc_foreign_key' => 'seminar_id',
+        ];
+        $config['belongs_to']['studygroup'] = [
+            'class_name'        => Course::class,
+            'foreign_key'       => 'studygroup_id',
+            'assoc_foreign_key' => 'seminar_id',
+        ];
+        $config['belongs_to']['user'] = [
+            'class_name'        => User::class,
+            'foreign_key'       => 'user_id'
+        ];
+        parent::configure($config);
+    }
+
+}