diff options
author | msquare <msquare@notrademark.de> | 2016-11-17 14:35:04 +0100 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2016-11-17 14:35:04 +0100 |
commit | 9c4636f5c4dd5d3b7ff12effb553172f8235cfe6 (patch) | |
tree | aa1ac8dc1fdbe18120ec667610eab7f64cc8ac34 /includes/model/UserDriverLicenses_model.php | |
parent | b5784e5961c0121f6c4d9f27f75473c56c727a5a (diff) |
reduce complexity of user driver license
Diffstat (limited to 'includes/model/UserDriverLicenses_model.php')
-rw-r--r-- | includes/model/UserDriverLicenses_model.php | 81 |
1 files changed, 50 insertions, 31 deletions
diff --git a/includes/model/UserDriverLicenses_model.php b/includes/model/UserDriverLicenses_model.php index 32785c92..6a3f14ab 100644 --- a/includes/model/UserDriverLicenses_model.php +++ b/includes/model/UserDriverLicenses_model.php @@ -1,8 +1,37 @@ <?php /** + * Returns a new empty UserDriverLicense + * FIXME entity object needed + */ +function UserDriverLicense_new($user) { + return [ + 'user_id' => $user['UID'], + 'has_car' => false, + 'has_license_car' => false, + 'has_license_3_5t_transporter' => false, + 'has_license_7_5t_truck' => false, + 'has_license_12_5t_truck' => false, + 'has_license_forklift' => false + ]; +} + +/** + * Is it valid? + * + * @param UserDriverLicense $user_driver_license + * The UserDriverLicense to check + * @return boolean + */ +function UserDriverLicense_valid($user_driver_license) { + return $user_driver_license['has_car'] || $user_driver_license['has_license_car'] || $user_driver_license['has_license_3_5t_transporter'] || $user_driver_license['has_license_7_5t_truck'] || $user_driver_license['has_license_12_5t_truck'] || $user_driver_license['has_license_forklift']; +} + +/** * Get a users driver license information - * @param int $user_id The users id + * + * @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) . "'"); @@ -19,24 +48,19 @@ function UserDriverLicense($user_id) { /** * 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 + * @param UserDriverLicense $user_driver_license + * The UserDriverLicense to create */ -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) { +function UserDriverLicenses_create($user_driver_license) { $result = 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)); + `user_id`=" . sql_escape($user_driver_license['user_id']) . ", + `has_car`=" . sql_bool($user_driver_license['has_car']) . ", + `has_license_car`=" . sql_bool($user_driver_license['has_license_car']) . ", + `has_license_3_5t_transporter`=" . sql_bool($user_driver_license['has_license_3_5t_transporter']) . ", + `has_license_7_5t_truck`=" . sql_bool($user_driver_license['has_license_7_5t_truck']) . ", + `has_license_12_5t_truck`=" . sql_bool($user_driver_license['has_license_12_5t_truck']) . ", + `has_license_forklift`=" . sql_bool($user_driver_license['has_license_forklift'])); if ($result === false) { engelsystem_error('Unable to create user driver license'); } @@ -46,23 +70,18 @@ function UserDriverLicenses_create($user_id, $has_car, $has_license_car, $has_li /** * 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 + * @param UserDriverLicense $user_driver_license + * The UserDriverLicense to update */ -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) { +function UserDriverLicenses_update($user_driver_license) { $result = 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) . "'"); + `has_car`=" . sql_bool($user_driver_license['has_car']) . ", + `has_license_car`=" . sql_bool($user_driver_license['has_license_car']) . ", + `has_license_3_5t_transporter`=" . sql_bool($user_driver_license['has_license_3_5t_transporter']) . ", + `has_license_7_5t_truck`=" . sql_bool($user_driver_license['has_license_7_5t_truck']) . ", + `has_license_12_5t_truck`=" . sql_bool($user_driver_license['has_license_12_5t_truck']) . ", + `has_license_forklift`=" . sql_bool($user_driver_license['has_license_forklift']) . " + WHERE `user_id`='" . sql_escape($user_driver_license['user_id']) . "'"); if ($result === false) { engelsystem_error("Unable to update user driver license information"); } |