diff options
| author | msquare <msquare@notrademark.de> | 2017-12-10 18:56:40 +0100 |
|---|---|---|
| committer | msquare <msquare@notrademark.de> | 2017-12-10 18:56:40 +0100 |
| commit | afb77d22ba35dfbee74bbbee95626d55edef8898 (patch) | |
| tree | d8d35dc5a7848276f83bcab3d1a792e7fb2e1b66 /includes/model/Shifts_model.php | |
| parent | aae8c77ed1a7b0d323f1d32c71b5fd12ff15d4bf (diff) | |
move room db queries to model
Diffstat (limited to 'includes/model/Shifts_model.php')
| -rw-r--r-- | includes/model/Shifts_model.php | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php index 8a1b69f9..1fc7fe89 100644 --- a/includes/model/Shifts_model.php +++ b/includes/model/Shifts_model.php @@ -26,6 +26,12 @@ function Shifts_by_angeltype($angeltype) { ', [$angeltype['id'], $angeltype['id']]); } +/** + * Returns all shifts with a PSID (from frab import) + */ +function Shifts_from_frab() { + return DB::select('SELECT * FROM `Shifts` WHERE `PSID` IS NOT NULL ORDER BY `start`'); +} /** * @param array $room |