summaryrefslogtreecommitdiff
path: root/includes/model/UserDriverLicenses_model.php
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2015-12-19 23:31:08 +0100
committerPhilip Häusler <msquare@notrademark.de>2015-12-19 23:31:08 +0100
commitfacc32f13331498999ee07d467ea4ef420ebf190 (patch)
tree340fcacdcb4993200dbbc83bfa1b7380aaef12c9 /includes/model/UserDriverLicenses_model.php
parentdc4eb98cafccbba7b2877691d8c3322cac87828b (diff)
#198 add basic driver license information
Diffstat (limited to 'includes/model/UserDriverLicenses_model.php')
-rw-r--r--includes/model/UserDriverLicenses_model.php69
1 files changed, 69 insertions, 0 deletions
diff --git a/includes/model/UserDriverLicenses_model.php b/includes/model/UserDriverLicenses_model.php
new file mode 100644
index 00000000..b99c8b1b
--- /dev/null
+++ b/includes/model/UserDriverLicenses_model.php
@@ -0,0 +1,69 @@
+<?php
+
+/**
+ * Get a users driver license information
+ * @param int $user_id The users id
+ */
+function UserDriverLicense($user_id) {
+ $user_driver_license = sql_select("SELECT * FROM `UserDriverLicenses` WHERE `user_id`='" . sql_escape($user_id) . "'");
+ if ($user_driver_license === false)
+ return false;
+ if (count($user_driver_license) > 0)
+ return $user_driver_license[0];
+ return null;
+}
+
+/**
+ * Create a user's driver license entry
+ *
+ * @param bool $user_id
+ * @param bool $has_car
+ * @param bool $has_license_car
+ * @param bool $has_license_3_5t_transporter
+ * @param bool $has_license_7_5t_truck
+ * @param bool $has_license_12_5t_truck
+ * @param bool $has_license_forklift
+ */
+function UserDriverLicenses_create($user_id, $has_car, $has_license_car, $has_license_3_5t_transporter, $has_license_7_5t_truck, $has_license_12_5t_truck, $has_license_forklift) {
+ return sql_query("
+ INSERT INTO `UserDriverLicenses` SET
+ `user_id`=" . sql_escape($user_id) . ",
+ `has_car`=" . sql_bool($has_car) . ",
+ `has_license_car`=" . sql_bool($has_license_car) . ",
+ `has_license_3_5t_transporter`=" . sql_bool($has_license_3_5t_transporter) . ",
+ `has_license_7_5t_truck`=" . sql_bool($has_license_7_5t_truck) . ",
+ `has_license_12_5t_truck`=" . sql_bool($has_license_12_5t_truck) . ",
+ `has_license_forklift`=" . sql_bool($has_license_forklift));
+}
+
+/**
+ * Update a user's driver license entry
+ *
+ * @param bool $user_id
+ * @param bool $has_car
+ * @param bool $has_license_car
+ * @param bool $has_license_3_5t_transporter
+ * @param bool $has_license_7_5t_truck
+ * @param bool $has_license_12_5t_truck
+ * @param bool $has_license_forklift
+ */
+function UserDriverLicenses_update($user_id, $has_car, $has_license_car, $has_license_3_5t_transporter, $has_license_7_5t_truck, $has_license_12_5t_truck, $has_license_forklift) {
+ return sql_query("UPDATE `UserDriverLicenses` SET
+ `has_car`=" . sql_bool($has_car) . ",
+ `has_license_car`=" . sql_bool($has_license_car) . ",
+ `has_license_3_5t_transporter`=" . sql_bool($has_license_3_5t_transporter) . ",
+ `has_license_7_5t_truck`=" . sql_bool($has_license_7_5t_truck) . ",
+ `has_license_12_5t_truck`=" . sql_bool($has_license_12_5t_truck) . ",
+ `has_license_forklift`=" . sql_bool($has_license_forklift) . "
+ WHERE `user_id`='" . sql_escape($user_id) . "'");
+}
+
+/**
+ * Delete a user's driver license entry
+ *
+ * @param int $user_id
+ */
+function UserDriverLicenses_delete($user_id) {
+ return sql_query("DELETE FROM `UserDriverLicenses` WHERE `user_id`=" . sql_escape($user_id));
+}
+?> \ No newline at end of file