From a041e0efbb9825a9c8d77cba989dcea27d0f825d Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Sun, 29 Dec 2013 15:08:21 +0100
Subject: first api

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

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

diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php
index 5e8a2b54..224bfc0b 100644
--- a/includes/model/Shifts_model.php
+++ b/includes/model/Shifts_model.php
@@ -1,5 +1,63 @@
 <?php
 
+/**
+ * Returns Shift id array
+ */
+function mShiftList() {
+	global $_REQUEST;
+	$filter = "";
+	
+	// filterRoom (Array of integer) - Array of Room IDs (optional, for list request)
+	if (isset($_REQUEST['filterRoom']) && is_array($_REQUEST['filterRoom']) ) {
+		foreach ( $_REQUEST['filterRoom'] as $key => $value ) {
+			$filter .= ", `RID`=" . sql_escape($value) . " ";
+		}
+	}
+	
+	//filterTask (Array of integer) - Array if Task (optional, for list request)
+	if (isset($_REQUEST['filterTask']) && is_array($_REQUEST['filterTask']) ) {
+		foreach ( $_REQUEST['filterTask'] as $key => $value ) {
+// TODO			$filter .= ", `RID`=" . sql_escape($value) . " ";
+		}
+	}
+	
+	// filterOccupancy (integer) - Occupancy state: (optional, for list request)
+	//   1 occupied, 	2 free, 3 occupied and free
+	if (isset($_REQUEST['filterOccupancy']) && is_array($_REQUEST['filterOccupancy']) ) {
+		foreach ( $_REQUEST['filterOccupancy'] as $key => $value ) {
+// TODO			$filter .= ", `RID`=" . sql_escape($value) . " ";
+		}
+	}
+
+	// format filter
+	if( $filter != "" ) {
+		$filter = ' WHERE '. substr($filter, 1); 
+	}
+
+	// real request
+	$shifts_source = sql_select("SELECT `SID` FROM `Shifts`". $filter);
+	if ($shifts_source === false)
+		return false;
+	if (count($shifts_source) > 0) {
+		return $shifts_source;
+	}
+return null;
+}
+
+/**
+ * Returns Shift by id.
+ *
+ * @param $id Shift ID
+ */
+function mShift($id) {
+	$shifts_source = sql_select("SELECT * FROM `Shifts` WHERE `SID`=" . sql_escape($id) . " LIMIT 1");
+	if ($shifts_source === false)
+		return false;
+	if (count($shifts_source) > 0)
+		return $shifts_source[0];
+	return null;
+}
+
 /**
  * Returns all shifts with needed angeltypes and count of subscribed jobs.
  */
-- 
cgit v1.3.1