From ad5899f02876e9c2e81804d6d3a58988fae8c3db Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Mon, 9 Dec 2013 17:10:07 +0100
Subject: api export for all shifts

---
 includes/model/Shifts_model.php | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 includes/model/Shifts_model.php

(limited to 'includes/model/Shifts_model.php')

diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php
new file mode 100644
index 00000000..84d14c7a
--- /dev/null
+++ b/includes/model/Shifts_model.php
@@ -0,0 +1,24 @@
+<?php
+
+/**
+ * Returns all shifts with needed angeltypes and count of subscribed jobs.
+ */
+function Shifts() {
+  $shifts_source = sql_select("
+    SELECT `Shifts`.*, `Room`.`RID`, `Room`.`Name` as `room_name` 
+    FROM `Shifts`
+    JOIN `Room` ON `Room`.`RID` = `Shifts`.`RID`
+    ");
+  if ($shifts_source === false)
+    return false;
+  
+  foreach ($shifts_source as &$shift) {
+    $needed_angeltypes = NeededAngelTypes_by_shift($shift);
+    if ($needed_angeltypes === false)
+      return false;
+    
+    $shift['angeltypes'] = $needed_angeltypes;
+  }
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3-54-g00ecf