summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/Controllers/Metrics/Stats.php5
1 files changed, 3 insertions, 2 deletions
diff --git a/src/Controllers/Metrics/Stats.php b/src/Controllers/Metrics/Stats.php
index 11643e46..c841be10 100644
--- a/src/Controllers/Metrics/Stats.php
+++ b/src/Controllers/Metrics/Stats.php
@@ -37,7 +37,7 @@ class Stats
$query
->leftJoin('UserWorkLog', 'UserWorkLog.user_id', '=', 'users.id')
->leftJoin('ShiftEntry', 'ShiftEntry.UID', '=', 'users.id')
- ->groupBy('users.id');
+ ->distinct();
$query->where(function ($query) use ($working) {
/** @var QueryBuilder $query */
@@ -48,6 +48,7 @@ class Stats
return;
}
+
$query
->whereNull('ShiftEntry.SID')
->whereNull('UserWorkLog.work_hours');
@@ -56,7 +57,7 @@ class Stats
}
return $query
- ->count();
+ ->count('users.id');
}
/**