From b7e1a379de348fa59bcc6a14d056981603d53765 Mon Sep 17 00:00:00 2001
From: Vincent Vanwaelscappel <vincent@cubedesigners.com>
Date: Tue, 5 Sep 2023 10:44:19 +0200
Subject: [PATCH] wip #6237 @0.5

---
 src/app/Permissions.php | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

diff --git a/src/app/Permissions.php b/src/app/Permissions.php
index 9b398c8..f3fc7c0 100644
--- a/src/app/Permissions.php
+++ b/src/app/Permissions.php
@@ -4,6 +4,7 @@ namespace Cubedesigners\UserDatabase;
 
 use Cubedesigners\UserDatabase\Models\Company;
 use Cubedesigners\UserDatabase\Models\User;
+use Illuminate\Support\Facades\DB;
 
 class Permissions
 {
@@ -33,19 +34,20 @@ class Permissions
                 'companyNames' => [],
             ];
 
-            foreach (User::withoutGlobalScopes()->get() as $user) {
-                /** @var $user User */
+            $users = DB::connection('extranet_users')->select(User::withoutGlobalScopes()->toSql());
+            foreach ($users as $user) {
                 if (!isset($data['companyUsers'][$user->company])) {
                     $data['companyUsers'][$user->company] = [];
                 }
 
                 $data['companyUsers'][$user->company][] = $user->id;
                 $data['usersCompany'][$user->id] = $user->company;
-                $data['userNames'][$user->id] = $user->name;
+                $data['userNames'][$user->id] = trim($user->firstname . ' ' . $user->lastname);
                 $data['enabledUsers'][$user->id] = $user->enabled;
             }
 
-            foreach (Company::withoutGlobalScopes()->get() as $company) {
+            $companies = DB::connection('extranet_users')->select(Company::withoutGlobalScopes()->toSql());
+            foreach ($companies as $company) {
                 if (!$company->admin || !isset($data['usersCompany'][$company->admin])) {
                     continue;
                 }
-- 
2.39.5