summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2014-12-16 08:52:52 +0100
committerPhilip Häusler <msquare@notrademark.de>2014-12-17 14:59:41 +0100
commit294a21d1632a07ee510adaf18e39a7a5956fac6b (patch)
treebc467329cdc02e4f26c0d4f2af5ba6befb8c7d39
parent25889920cf216e46873da968afe4b2dae5fead64 (diff)
add shift types model
-rw-r--r--includes/model/ShiftTypes_model.php48
1 files changed, 48 insertions, 0 deletions
diff --git a/includes/model/ShiftTypes_model.php b/includes/model/ShiftTypes_model.php
index 4c71a3ed..7b502585 100644
--- a/includes/model/ShiftTypes_model.php
+++ b/includes/model/ShiftTypes_model.php
@@ -1,18 +1,66 @@
<?php
+/**
+ * Delete a shift type.
+ * @param int $shifttype_id
+ */
function ShiftType_delete($shifttype_id) {
+ return sql_query("DELETE FROM `ShiftTypes` WHERE `id`=" . sql_escape($shifttype_id));
}
+/**
+ * Update a shift type.
+ *
+ * @param int $shifttype_id
+ * @param string $name
+ * @param int $angeltype_id
+ * @param string $description
+ */
function ShiftType_update($shifttype_id, $name, $angeltype_id, $description) {
+ return sql_query("UPDATE `ShiftTypes` SET
+ `name`='" . sql_escape($name) . "',
+ `angeltype_id`=" . sql_null($angeltype_id) . ",
+ `description`='" . sql_escape($description) . "'
+ WHERE `id`=" . sql_escape($shifttype_id));
}
+/**
+ * Create a shift type.
+ *
+ * @param string $name
+ * @param int $angeltype_id
+ * @param string $description
+ * @return new shifttype id
+ */
function ShiftType_create($name, $angeltype_id, $description) {
+ $result = sql_query("INSERT INTO `ShiftTypes` SET
+ `name`='" . sql_escape($name) . "',
+ `angeltype_id`=" . sql_null($angeltype_id) . ",
+ `description`='" . sql_escape($description) . "'");
+ if ($result === false)
+ return false;
+ return sql_id();
}
+/**
+ * Get a shift type by id.
+ *
+ * @param int $shifttype_id
+ */
function ShiftType($shifttype_id) {
+ $shifttype = sql_select("SELECT * FROM `ShiftTypes` WHERE `id`=" . sql_escape($shifttype_id));
+ if ($shifttype === false)
+ return false;
+ if ($shifttype == null)
+ return null;
+ return $shifttype[0];
}
+/**
+ * Get all shift types.
+ */
function ShiftTypes() {
+ return sql_select("SELECT * FROM `ShiftTypes` ORDER BY `name`");
}
?> \ No newline at end of file