From 6fff6a6c1a5a4ae6c6977c3aeb4ac532ba09a395 Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
Date: Wed, 5 Oct 2016 18:56:50 +0200
Subject: begin room view and shifts filter renderer

---
 includes/model/Shifts_model.php | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'includes/model')

diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php
index 8c251209..6721c30e 100644
--- a/includes/model/Shifts_model.php
+++ b/includes/model/Shifts_model.php
@@ -1,6 +1,14 @@
 <?php
 use Engelsystem\ShiftsFilter;
 
+function Shifts_by_room($room) {
+  $result = sql_select("SELECT * FROM `Shifts` WHERE `RID`=" . sql_escape($room['RID']));
+  if ($result === false) {
+    engelsystem_error("Unable to load shifts.");
+  }
+  return $result;
+}
+
 function Shifts_by_ShiftsFilter(ShiftsFilter $shiftsFilter, $user) {
   $SQL = "SELECT DISTINCT `Shifts`.*, `ShiftTypes`.`name`, `Room`.`Name` as `room_name`, nat2.`special_needs` > 0 AS 'has_special_needs'
   FROM `Shifts`
-- 
cgit v1.2.3-54-g00ecf