diff options
Diffstat (limited to 'includes/model/Shifts_model.php')
| -rw-r--r-- | includes/model/Shifts_model.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php index 756d9284..feecdf60 100644 --- a/includes/model/Shifts_model.php +++ b/includes/model/Shifts_model.php @@ -636,8 +636,9 @@ function Shift($shift_id) } $shiftsEntry_source = DB::select(' - SELECT `id`, `TID` , `UID` , `freeloaded` + SELECT `ShiftEntry`.`id`, `ShiftEntry`.`TID` , `ShiftEntry`.`UID` , `ShiftEntry`.`freeloaded`, `users`.`name` AS `username` FROM `ShiftEntry` + LEFT JOIN `users` ON (`users`.`id` = `ShiftEntry`.`UID`) WHERE `SID`=?', [$shift_id]); $result['ShiftEntry'] = $shiftsEntry_source; |