summaryrefslogtreecommitdiff
path: root/includes
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2014-01-07 15:56:31 +0100
committerPhilip Häusler <msquare@notrademark.de>2014-01-07 15:56:31 +0100
commitb35a32ef5287e5746ad724c649fc2cb43d581c17 (patch)
tree9b67e4859c40b649b621418f6110bbe41f2e78d8 /includes
parent239c2b168411c110b1f884f6ef0df172cb913b4b (diff)
completed api comments
Diffstat (limited to 'includes')
-rw-r--r--includes/model/AngelType_model.php30
-rw-r--r--includes/model/UserAngelTypes_model.php39
2 files changed, 63 insertions, 6 deletions
diff --git a/includes/model/AngelType_model.php b/includes/model/AngelType_model.php
index bc07ace7..180712b2 100644
--- a/includes/model/AngelType_model.php
+++ b/includes/model/AngelType_model.php
@@ -1,26 +1,44 @@
<?php
+/**
+ * Delete an Angeltype.
+ * @param Angeltype $angeltype
+ */
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");
+ return sql_query("
+ DELETE FROM `AngelTypes`
+ WHERE `id`=" . sql_escape($angeltype['id']) . "
+ LIMIT 1");
}
+/**
+ * Update Angeltype.
+ *
+ * @param int $angeltype_id
+ * @param string $name
+ * @param boolean $restricted
+ */
function AngelType_update($angeltype_id, $name, $restricted) {
return sql_query("
UPDATE `AngelTypes` SET
`name`='" . sql_escape($name) . "',
- `restricted`=" . sql_escape($restricted) . "
+ `restricted`=" . sql_escape($restricted ? 1 : 0) . "
WHERE `id`=" . sql_escape($angeltype_id) . "
LIMIT 1");
}
+/**
+ * Create an Angeltype.
+ *
+ * @param string $name
+ * @param boolean $restricted
+ * @return New Angeltype id
+ */
function AngelType_create($name, $restricted) {
$result = sql_query("
INSERT INTO `AngelTypes` SET
`name`='" . sql_escape($name) . "',
- `restricted`=" . sql_escape($restricted));
+ `restricted`=" . sql_escape($restricted ? 1 : 0));
if ($result === false)
return false;
return sql_id();
diff --git a/includes/model/UserAngelTypes_model.php b/includes/model/UserAngelTypes_model.php
index e931e04b..4987eddd 100644
--- a/includes/model/UserAngelTypes_model.php
+++ b/includes/model/UserAngelTypes_model.php
@@ -1,5 +1,10 @@
<?php
+/**
+ * Delete all unconfirmed UserAngelTypes for given Angeltype.
+ *
+ * @param int $angeltype_id
+ */
function UserAngelTypes_delete_all($angeltype_id) {
return sql_query("
DELETE FROM `UserAngelTypes`
@@ -7,6 +12,12 @@ function UserAngelTypes_delete_all($angeltype_id) {
AND `confirm_user_id` IS NULL");
}
+/**
+ * Confirm all unconfirmed UserAngelTypes for given Angeltype.
+ *
+ * @param int $angeltype_id
+ * @param User $confirm_user
+ */
function UserAngelTypes_confirm_all($angeltype_id, $confirm_user) {
return sql_query("
UPDATE `UserAngelTypes`
@@ -15,6 +26,12 @@ function UserAngelTypes_confirm_all($angeltype_id, $confirm_user) {
AND `confirm_user_id` IS NULL");
}
+/**
+ * Confirm an UserAngelType with confirming user.
+ *
+ * @param int $user_angeltype_id
+ * @param User $confirm_user
+ */
function UserAngelType_confirm($user_angeltype_id, $confirm_user) {
return sql_query("
UPDATE `UserAngelTypes`
@@ -23,6 +40,11 @@ function UserAngelType_confirm($user_angeltype_id, $confirm_user) {
LIMIT 1");
}
+/**
+ * Delete an UserAngelType.
+ *
+ * @param UserAngelType $user_angeltype
+ */
function UserAngelType_delete($user_angeltype) {
return sql_query("
DELETE FROM `UserAngelTypes`
@@ -30,6 +52,12 @@ function UserAngelType_delete($user_angeltype) {
LIMIT 1");
}
+/**
+ * Create an UserAngelType.
+ *
+ * @param User $user
+ * @param Angeltype $angeltype
+ */
function UserAngelType_create($user, $angeltype) {
$result = sql_query("
INSERT INTO `UserAngelTypes` SET
@@ -40,6 +68,11 @@ function UserAngelType_create($user, $angeltype) {
return sql_id();
}
+/**
+ * Get an UserAngelType by its id.
+ *
+ * @param int $user_angeltype_id
+ */
function UserAngelType($user_angeltype_id) {
$angeltype = sql_select("
SELECT *
@@ -53,6 +86,12 @@ function UserAngelType($user_angeltype_id) {
return $angeltype[0];
}
+/**
+ * Get an UserAngelType by user and angeltype.
+ *
+ * @param User $user
+ * @param Angeltype $angeltype
+ */
function UserAngelType_by_User_and_AngelType($user, $angeltype) {
$angeltype = sql_select("
SELECT *