fix userdomain lookup for selection 'no userdomain', fixes #4353

Closes #4353

Merge request studip/studip!3160

1 files changed, 18 insertions, 2 deletions

diff --git a/lib/classes/UserLookup.php b/lib/classes/UserLookup.php
index 62de8fd..063c324 100644
--- a/lib/classes/UserLookup.php
+++ b/lib/classes/UserLookup.php
@@ -441,10 +441,26 @@ class UserLookup
             return [];
         }
 
-        $query = "SELECT `user_id`
+        $query = "SELECT DISTINCT `user_id`
                  FROM `user_userdomains`
                  WHERE `userdomain_id` IN (?)";
-        return DBManager::get()->fetchFirst($query, [$needles]);
+        $result = DBManager::get()->fetchFirst($query, [$needles]);
+
+        if (in_array('keine', $needles)) {
+            $query = "SELECT `user_id`
+                      FROM `auth_user_md5`
+                      WHERE `user_id` NOT IN (
+                          SELECT `user_id`
+                          FROM `user_userdomains`
+                      )";
+            $result = array_merge(
+                $result,
+                DBManager::get()->fetchFirst($query)
+            );
+            $result = array_unique($result);
+        }
+
+        return $result;
     }
 
     /**