summaryrefslogtreecommitdiff
path: root/includes
diff options
context:
space:
mode:
authormsquare <msquare@notrademark.de>2017-12-13 11:55:59 +0100
committermsquare <msquare@notrademark.de>2017-12-13 11:55:59 +0100
commitaf8454598c204d5b32c6a33467086df5fd2dc3dc (patch)
treec98cf73dc1a851e4edb92f56f0ebe171d9b2e41e /includes
parent582b1a739aa10c84454dc7f862bc788a9ed2ded4 (diff)
improve public dashboard
Diffstat (limited to 'includes')
-rw-r--r--includes/model/Stats.php8
1 files changed, 2 insertions, 6 deletions
diff --git a/includes/model/Stats.php b/includes/model/Stats.php
index 5618cdc6..c6208dc3 100644
--- a/includes/model/Stats.php
+++ b/includes/model/Stats.php
@@ -54,9 +54,7 @@ function stats_angels_needed_three_hours()
- (SELECT COUNT(*) FROM `ShiftEntry` WHERE `ShiftEntry`.`SID`=`Shifts`.`SID` AND `freeloaded`=0)
) as `count`
FROM `Shifts`
- WHERE ((`end` > ? AND `end` < ?) OR (`start` > ? AND `start` < ?))", [
- $now,
- $in3hours,
+ WHERE `end` > ? AND `start` < ?", [
$now,
$in3hours
]);
@@ -79,9 +77,7 @@ function stats_angels_needed_for_nightshifts()
- (SELECT COUNT(*) FROM `ShiftEntry` WHERE `ShiftEntry`.`SID`=`Shifts`.`SID` AND `freeloaded`=0)
) as `count`
FROM `Shifts`
- WHERE ((`end` > ? AND `end` < ?) OR (`start` > ? AND `start` < ?))", [
- $night_start,
- $night_end,
+ WHERE `end` > ? AND `start` < ?", [
$night_start,
$night_end
]);