diff options
author | Igor Scheller <igor.scheller@igorshp.de> | 2018-10-14 18:24:42 +0200 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2018-10-31 13:43:23 +0100 |
commit | d7aea575ff77cd37c326511e7ac5fe49067c63ad (patch) | |
tree | 7a9699346ac737e6791b81562f82eae205829e36 /includes/pages/guest_stats.php | |
parent | 57932be4287d0ea6235137f1a86f07cbb06dd35b (diff) |
Replaced more sql queries and old data
Diffstat (limited to 'includes/pages/guest_stats.php')
-rw-r--r-- | includes/pages/guest_stats.php | 13 |
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`) |