diff options
author | tike <timflex@gmx.de> | 2016-02-05 22:57:57 +0100 |
---|---|---|
committer | tike <timflex@gmx.de> | 2016-02-07 13:00:28 +0100 |
commit | 661e5595c4f5844cec94f4fb304c16650fa3b211 (patch) | |
tree | a58f8ed4dc700d16d2165e474f51694d8bce4352 /includes/model/ShiftEntry_model.php | |
parent | 1da3cba5a70328780a362af0ec06e9f6a689562a (diff) |
issue #242 - make app caluclate number of vouchers for angels
Diffstat (limited to 'includes/model/ShiftEntry_model.php')
-rw-r--r-- | includes/model/ShiftEntry_model.php | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/includes/model/ShiftEntry_model.php b/includes/model/ShiftEntry_model.php index 008531ff..6324c3bf 100644 --- a/includes/model/ShiftEntry_model.php +++ b/includes/model/ShiftEntry_model.php @@ -85,6 +85,23 @@ function ShiftEntries_upcoming_for_user($user) { } /** + * Returns shifts completed by the given user. + * + * @param User $user + */ +function ShiftEntries_finished_by_user($user){ + return sql_select(" + SELECT * + FROM `ShiftEntry` + JOIN `Shifts` ON (`Shifts`.`SID` = `ShiftEntry`.`SID`) + JOIN `ShiftTypes` ON `ShiftTypes`.`id` = `Shifts`.`shifttype_id` + WHERE `ShiftEntry`.`UID`=" . sql_escape($user['UID']) . " + AND `Shifts`.`end` < " . sql_escape(time()) . " + ORDER BY `Shifts`.`end` + "); +} + +/** * Returns all shift entries in given shift for given angeltype. * * @param int $shift_id |