diff options
| author | msquare <msquare@notrademark.de> | 2016-12-28 00:26:54 +0100 |
|---|---|---|
| committer | msquare <msquare@notrademark.de> | 2016-12-28 00:26:54 +0100 |
| commit | eccbf32f68d5cc2c7d25f4d369b70d2904239212 (patch) | |
| tree | 4ee8a3e635d3848a41486b4203f004224548f441 | |
| parent | 84527c22526b97ba1e84b200056a0c4f8e8ac0bc (diff) | |
redo
| -rw-r--r-- | includes/model/Shifts_model.php | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php index 5da15733..61f82255 100644 --- a/includes/model/Shifts_model.php +++ b/includes/model/Shifts_model.php @@ -74,7 +74,6 @@ function NeededAngeltypes_by_ShiftsFilter(ShiftsFilter $shiftsFilter, $user) { FROM `Shifts` JOIN `NeededAngelTypes` ON `NeededAngelTypes`.`shift_id`=`Shifts`.`SID` JOIN `AngelTypes` ON `AngelTypes`.`id`= `NeededAngelTypes`.`angel_type_id` - JOIN `NeededAngelTypes` AS nat_room ON `NeededAngelTypes`.`room_id`=`Shifts`.`RID` WHERE `Shifts`.`RID` IN (" . implode(',', $shiftsFilter->getRooms()) . ") AND `start` BETWEEN " . $shiftsFilter->getStartTime() . " AND " . $shiftsFilter->getEndTime() . " ORDER BY `Shifts`.`start`"; |