1 files changed, 16 insertions, 0 deletions
diff --git a/lib/ilias_interface/IliasUser.php b/lib/ilias_interface/IliasUser.php
index fbd15ce..84e8f26 100644
--- a/lib/ilias_interface/IliasUser.php
+++ b/lib/ilias_interface/IliasUser.php
@@ -177,6 +177,22 @@ class IliasUser
     }
 
     /**
+    * check member request for workgroup
+    *
+    * checks if member request for current user exists
+    */
+    public function hasWorkgroupRequest(int $workgroup_id): bool
+    {
+        $query = "SELECT id, valid_until
+                  FROM ilias_workgroup_request
+                  WHERE user_id = ? AND ilias_index = ? AND workgroup_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$this->studip_id, $this->index, $workgroup_id]);
+        $data = $statement->fetch(PDO::FETCH_ASSOC);
+        return (!empty($data) && (int)$data['valid_until'] > time());
+    }
+
+    /**
     * get array of user account data
     *
     * returns array of user account data