From 20f4d44cbf159f25f78312290be52fcfafef02de Mon Sep 17 00:00:00 2001 From: msquare Date: Thu, 14 Dec 2017 19:39:47 +0100 Subject: fix union queries for dashboard stats --- includes/model/Stats.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'includes/model/Stats.php') diff --git a/includes/model/Stats.php b/includes/model/Stats.php index 5bca0aff..0c581fa9 100644 --- a/includes/model/Stats.php +++ b/includes/model/Stats.php @@ -35,7 +35,7 @@ function stats_hours_to_work() WHERE `end` >= ? AND `Shifts`.`PSID` IS NULL - UNION + UNION ALL SELECT (SELECT SUM(`count`) FROM `NeededAngelTypes` WHERE `NeededAngelTypes`.`room_id`=`Shifts`.`RID`) @@ -71,7 +71,7 @@ function stats_angels_needed_three_hours() WHERE `end` > ? AND `start` < ? AND `Shifts`.`PSID` IS NULL - UNION + UNION ALL SELECT (SELECT SUM(`count`) FROM `NeededAngelTypes` WHERE `NeededAngelTypes`.`room_id`=`Shifts`.`RID`) @@ -109,7 +109,7 @@ function stats_angels_needed_for_nightshifts() WHERE `end` > ? AND `start` < ? AND `Shifts`.`PSID` IS NULL - UNION + UNION ALL SELECT (SELECT SUM(`count`) FROM `NeededAngelTypes` WHERE `NeededAngelTypes`.`room_id`=`Shifts`.`RID`) -- cgit v1.2.3-54-g00ecf