summaryrefslogtreecommitdiff
path: root/includes/model/UserDriverLicenses_model.php
blob: afc44575e7b340d65e05665e5454b8f56ec5904f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<?php

/**
 * Returns a new empty UserDriverLicense
 * FIXME entity object needed
 */
function UserDriverLicense_new() {
  return [
      'user_id' => null,
      '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_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
 */
function UserDriverLicense($user_id) {
  $user_driver_license = sql_select("SELECT * FROM `UserDriverLicenses` WHERE `user_id`='" . sql_escape($user_id) . "'");
  if ($user_driver_license === false) {
    engelsystem_error('Unable to load user driver license.');
    return false;
  }
  if (count($user_driver_license) > 0) {
    return $user_driver_license[0];
  }
  return null;
}

/**
 * Create a user's driver license entry
 *
 * @param UserDriverLicense $user_driver_license
 *          The UserDriverLicense to create
 */
function UserDriverLicenses_create($user_driver_license, $user) {
  $user_driver_license['user_id'] = $user['UID'];
  $result = sql_query("
      INSERT INTO `UserDriverLicenses` SET
      `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');
  }
  return $user_driver_license;
}

/**
 * Update a user's driver license entry
 *
 * @param UserDriverLicense $user_driver_license
 *          The UserDriverLicense to update
 */
function UserDriverLicenses_update($user_driver_license) {
  $result = sql_query("UPDATE `UserDriverLicenses` SET
      `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");
  }
  return $result;
}

/**
 * Delete a user's driver license entry
 *
 * @param int $user_id          
 */
function UserDriverLicenses_delete($user_id) {
  $result = sql_query("DELETE FROM `UserDriverLicenses` WHERE `user_id`=" . sql_escape($user_id));
  if ($result === false) {
    engelsystem_error("Unable to remove user driver license information");
  }
  return $result;
}
?>