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/NeededAngelTypes_model.php | 35 +++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 includes/model/NeededAngelTypes_model.php

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

diff --git a/includes/model/NeededAngelTypes_model.php b/includes/model/NeededAngelTypes_model.php
new file mode 100644
index 00000000..85890f2d
--- /dev/null
+++ b/includes/model/NeededAngelTypes_model.php
@@ -0,0 +1,35 @@
+<?php
+
+/**
+ * Returns all needed angeltypes and already taken needs.
+ *
+ * @param Shift $shift          
+ */
+function NeededAngelTypes_by_shift($shift) {
+  $needed_angeltypes_source = sql_select("
+        SELECT `NeededAngelTypes`.*, `AngelTypes`.`name`, `AngelTypes`.`restricted`
+        FROM `NeededAngelTypes`
+        JOIN `AngelTypes` ON `AngelTypes`.`id` = `NeededAngelTypes`.`angel_type_id`
+        WHERE `shift_id`=" . sql_escape($shift['SID']) . "
+        OR `room_id`=" . sql_escape($shift['RID']) . "
+        ORDER BY `room_id` DESC
+        ");
+  if ($needed_angeltypes === false)
+    return false;
+  
+  $needed_angeltypes = array();
+  foreach ($needed_angeltypes_source as $angeltype)
+    $needed_angeltypes[$angeltype['id']] = $angeltype;
+  
+  foreach ($needed_angeltypes as &$angeltype) {
+    $shift_entries = ShiftEntries_by_shift_and_angeltype($shift['SID'], $angeltype['id']);
+    if ($shift_entries === false)
+      return false;
+    
+    $angeltype['taken'] = count($shift_entries);
+  }
+  
+  return $needed_angeltypes;
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3-54-g00ecf