1 files changed, 61 insertions, 0 deletions
diff --git a/lib/models/ContactGroupItem.php b/lib/models/ContactGroupItem.php
new file mode 100644
index 0000000..0204d0a
--- /dev/null
+++ b/lib/models/ContactGroupItem.php
@@ -0,0 +1,61 @@
+<?php
+/**
+ * The ContactGroupItem class represents an item in a contact group.
+ * 
+ * This file is part of Stud.IP
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License as
+ * published by the Free Software Foundation; either version 2 of
+ * the License, or (at your option) any later version.
+ *
+ * @author      Moritz Strohm <strohm@data-quest.de>
+ * @copyright   2023
+ * @license     http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
+ * @category    Stud.IP
+ * @package     resources
+ * @since       5.5
+ *
+ * @property string $group_id The ID of the group.
+ * @property string $user_id The ID of the user that is inside the group.
+ * @property string $mkdate The creation date of the group.
+ * @property string $chdate The modification date of the group.
+ * @property ContactGroup $contact_group The group instance for the item.
+ * @property User $user The user instance for the item.
+ */
+class ContactGroupItem extends SimpleORMap
+{
+    protected static function configure($config = [])
+    {
+        $config['db_table'] = 'contact_group_items';
+        $config['belongs_to']['contact_group'] = [
+            'class_name'  => ContactGroup::class,
+            'foreign_key' => 'group_id'
+        ];
+        $config['belongs_to']['user'] = [
+            'class_name'  => User::class,
+            'foreign_key' => 'user_id'
+        ];
+        parent::configure($config);
+    }
+
+    /**
+     * Finds and returns all group items for a contact.
+     *
+     * @param Contact $contact The contact for which to find all contact group items.
+     * @return ContactGroupItem[] All memberships of the contact.
+     */
+    public static function findByContact(Contact $contact): array
+    {
+        return self::findBySQL(
+            'JOIN `contact_groups`
+              ON (`contact_group_items`.`group_id` = `contact_groups`.`id`)
+             WHERE `contact_groups`.`owner_id` = :owner_id
+               AND `contact_group_items`.`user_id` = :user_id',
+            [
+                'owner_id' => $contact->owner_id,
+                'user_id' => $contact->user_id
+            ]
+        );
+    }
+}