From 5e8453992810181facf168d6aaede9d2dcd61dba Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Sun, 5 Jan 2014 19:30:06 +0100
Subject: rewritten angeltypes and user angeltypes

---
 includes/model/AngelType_model.php | 134 +++++++++++++++++++++++++++++--------
 1 file changed, 106 insertions(+), 28 deletions(-)

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

diff --git a/includes/model/AngelType_model.php b/includes/model/AngelType_model.php
index 49d1c702..22baa4a4 100644
--- a/includes/model/AngelType_model.php
+++ b/includes/model/AngelType_model.php
@@ -1,29 +1,107 @@
-<?php
-
-/**
- * Returns AngelType id array
- */
-function mAngelTypeList() {
-	$angelType_source = sql_select("SELECT `id` FROM `AngelTypes`");
-	if ($angelType_source === false)
-		return false;
-	if (count($angelType_source) > 0)
-		return $angelType_source;
-	return null;
-}
-
-/**
- * Returns angelType by id.
- *
- * @param $id angelType ID
- */
-function mAngelType($id) {
-	$angelType_source = sql_select("SELECT * FROM `AngelTypes` WHERE `id`=" . sql_escape($id) . " LIMIT 1");
-	if ($angelType_source === false)
-		return false;
-	if (count($angelType_source) > 0)
-		return $angelType_source[0];
-	return null;
-}
-
+<?php
+
+function AngelType_delete($angeltype) {
+  sql_query("DELETE FROM `NeededAngelTypes` WHERE `angel_type_id`=" . sql_escape($angeltype['id']) . " LIMIT 1");
+  sql_query("DELETE FROM `ShiftEntry` WHERE `TID`=" . sql_escape($angeltype['id']) . " LIMIT 1");
+  sql_query("DELETE FROM `UserAngelTypes` WHERE `angeltype_id`=" . sql_escape($angeltype['id']) . " LIMIT 1");
+  return sql_query("DELETE FROM `AngelTypes` WHERE `id`=" . sql_escape($angeltype['id']) . " LIMIT 1");
+}
+
+function AngelType_update($angeltype_id, $name, $restricted) {
+  return sql_query("
+      UPDATE `AngelTypes` SET 
+      `name`='" . sql_escape($name) . "', 
+      `restricted`=" . sql_escape($restricted) . " 
+      WHERE `id`=" . sql_escape($angeltype_id) . " 
+      LIMIT 1");
+}
+
+function AngelType_create($name, $restricted) {
+  $result = sql_query("
+      INSERT INTO `AngelTypes` SET 
+      `name`='" . sql_escape($name) . "', 
+      `restricted`=" . sql_escape($restricted));
+  if ($result === false)
+    return false;
+  return sql_id();
+}
+
+/**
+ * Validates a name for angeltypes.
+ * Returns array containing validation success and validated name.
+ *
+ * @param string $name          
+ * @param AngelType $angeltype          
+ */
+function AngelType_validate_name($name, $angeltype) {
+  $name = strip_item($name);
+  if ($name == "")
+    return array(
+        false,
+        $name 
+    );
+  if (isset($angeltype) && isset($angeltype['id']))
+    return array(
+        sql_num_query("
+        SELECT * 
+        FROM `AngelTypes` 
+        WHERE `name`='" . sql_escape($name) . "' 
+        AND NOT `id`=" . sql_escape($angeltype['id']) . "
+        LIMIT 1") == 0,
+        $name 
+    );
+  else
+    return array(
+        sql_num_query("
+        SELECT `id` 
+        FROM `AngelTypes` 
+        WHERE `name`='" . sql_escape($name) . "' 
+        LIMIT 1") == 0,
+        $name 
+    );
+}
+
+/**
+ * Returns all angeltypes and subscription state to each of them for given user.
+ *
+ * @param User $user          
+ */
+function AngelTypes_with_user($user) {
+  return sql_select("
+      SELECT `AngelTypes`.*, 
+      `UserAngelTypes`.`id` as `user_angeltype_id`,
+      `UserAngelTypes`.`confirm_user_id` 
+      FROM `AngelTypes` 
+      LEFT JOIN `UserAngelTypes` ON `AngelTypes`.`id`=`UserAngelTypes`.`angeltype_id` 
+      AND `UserAngelTypes`.`user_id`=" . $user['UID'] . "
+      ORDER BY `name`");
+}
+
+/**
+ * Returns AngelType id array
+ */
+function mAngelTypeList() {
+  $angelType_source = sql_select("SELECT `id` FROM `AngelTypes`");
+  if ($angelType_source === false)
+    return false;
+  if (count($angelType_source) > 0)
+    return $angelType_source;
+  return null;
+}
+
+/**
+ * Returns angelType by id.
+ *
+ * @param $id angelType
+ *          ID
+ */
+function mAngelType($id) {
+  $angelType_source = sql_select("SELECT * FROM `AngelTypes` WHERE `id`=" . sql_escape($id) . " LIMIT 1");
+  if ($angelType_source === false)
+    return false;
+  if (count($angelType_source) > 0)
+    return $angelType_source[0];
+  return null;
+}
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-54-g00ecf