Replaced more sql queries and old data

1 files changed, 4 insertions, 9 deletions

diff --git a/includes/pages/guest_stats.php b/includes/pages/guest_stats.php
index bb07f4dc..d9012748 100644
--- a/includes/pages/guest_stats.php
+++ b/includes/pages/guest_stats.php
@@ -1,6 +1,8 @@
 <?php
 
 use Engelsystem\Database\DB;
+use Engelsystem\Models\User\State;
+use Engelsystem\Models\User\User;
 
 function guest_stats()
 {
@@ -11,15 +13,8 @@ function guest_stats()
         if (!empty($apiKey) && $request->input('api_key') == $apiKey) {
             $stats = [];
 
-            list($user_count) = DB::select('SELECT count(*) AS `user_count` FROM `User`');
-            $stats['user_count'] = $user_count['user_count'];
-
-            list($arrived_user_count) = DB::select('
-                SELECT count(*) AS `user_count`
-                FROM `User`
-                WHERE `Gekommen`=1
-            ');
-            $stats['arrived_user_count'] = $arrived_user_count['user_count'];
+            $stats['user_count'] = User::all()->count();
+            $stats['arrived_user_count'] = State::whereArrived(true)->count();
 
             $done_shifts_seconds = DB::selectOne('
                 SELECT SUM(`Shifts`.`end` - `Shifts`.`start`)