diff options
| author | msquare <msquare@notrademark.de> | 2017-12-13 11:55:59 +0100 |
|---|---|---|
| committer | msquare <msquare@notrademark.de> | 2017-12-13 11:55:59 +0100 |
| commit | af8454598c204d5b32c6a33467086df5fd2dc3dc (patch) | |
| tree | c98cf73dc1a851e4edb92f56f0ebe171d9b2e41e /includes/model | |
| parent | 582b1a739aa10c84454dc7f862bc788a9ed2ded4 (diff) | |
improve public dashboard
Diffstat (limited to 'includes/model')
| -rw-r--r-- | includes/model/Stats.php | 8 |
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 ]); |