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 +++++++++++++++++++++++++++++++++++++++++
 includes/model/User_model.php   | 28 +++++++++++++++++++-
 2 files changed, 85 insertions(+), 1 deletion(-)

(limited to 'includes')

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.
  */
diff --git a/includes/model/User_model.php b/includes/model/User_model.php
index a69c288c..6b23f74b 100644
--- a/includes/model/User_model.php
+++ b/includes/model/User_model.php
@@ -1,5 +1,17 @@
 <?php
 
+/**
+ * Returns User id array
+ */
+function mUserList() {
+  $user_source = sql_select("SELECT `UID` FROM `User`");
+  if ($user_source === false)
+    return false;
+  if (count($user_source) > 0)
+    return $user_source;
+  return null;
+}
+
 /**
  * Strip unwanted characters from a users nick.
  * @param string $nick
@@ -22,6 +34,20 @@ function User($id) {
   return null;
 }
 
+/**
+ * Returns user by id (limit informations.
+ *
+ * @param $id UID
+ */
+function mUser_Limit($id) {
+  $user_source = sql_select("SELECT `UID`, `Nick`, `Name`, `Vorname`, `Telefon`, `DECT`, `Handy`, `email`, `ICQ`, `jabber`, `Avatar` FROM `User` WHERE `UID`=" . sql_escape($id) . " LIMIT 1");
+  if ($user_source === false)
+    return false;
+  if (count($user_source) > 0)
+    return $user_source[0];
+  return null;
+}
+
 /**
  * Returns User by api_key.
  *
@@ -95,4 +121,4 @@ function User_generate_password_recovery_token(&$user) {
   return $user['password_recovery_token'];
 }
 
-?>
\ No newline at end of file
+?>
-- 
cgit v1.2.3-54-g00ecf