summaryrefslogtreecommitdiff
path: root/includes/model/User_model.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/model/User_model.php')
-rw-r--r--includes/model/User_model.php73
1 files changed, 54 insertions, 19 deletions
diff --git a/includes/model/User_model.php b/includes/model/User_model.php
index a6c12f9d..bd3ec31f 100644
--- a/includes/model/User_model.php
+++ b/includes/model/User_model.php
@@ -5,6 +5,37 @@
*/
/**
+ * Update user.
+ *
+ * @param User $user
+ */
+function User_update($user) {
+ return sql_query("UPDATE `User` SET
+ `Nick`='" . sql_escape($user['Nick']) . "',
+ `Name`='" . sql_escape($user['Name']) . "',
+ `Vorname`='" . sql_escape($user['Vorname']) . "',
+ `Alter`='" . sql_escape($user['Alter']) . "',
+ `Telefon`='" . sql_escape($user['Telefon']) . "',
+ `DECT`='" . sql_escape($user['DECT']) . "',
+ `Handy`='" . sql_escape($user['Handy']) . "',
+ `email`='" . sql_escape($user['email']) . "',
+ `email_shiftinfo`=" . sql_bool($user['email_shiftinfo']) . ",
+ `jabber`='" . sql_escape($user['jabber']) . "',
+ `Size`='" . sql_escape($user['Size']) . "',
+ `Gekommen`='" . sql_escape($user['Gekommen']) . "',
+ `Aktiv`='" . sql_escape($user['Aktiv']) . "',
+ `force_active`=" . sql_bool($user['force_active']) . ",
+ `Tshirt`='" . sql_escape($user['Tshirt']) . "',
+ `color`='" . sql_escape($user['color']) . "',
+ `Sprache`='" . sql_escape($user['Sprache']) . "',
+ `Hometown`='" . sql_escape($user['Hometown']) . "',
+ `got_voucher`='" . sql_escape($user['got_voucher']) . "',
+ `arrival_date`='" . sql_escape($user['arrival_date']) . "',
+ `planned_arrival_date`='" . sql_escape($user['planned_arrival_date']) . "'
+ WHERE `UID`='" . sql_escape($user['UID']) . "'");
+}
+
+/**
* Counts all forced active users.
*/
function User_force_active_count() {
@@ -15,6 +46,10 @@ function User_active_count() {
return sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `Aktiv` = 1");
}
+function User_got_voucher_count() {
+ return sql_select_single_cell("SELECT SUM(`got_voucher`) FROM `User`");
+}
+
function User_arrived_count() {
return sql_select_single_cell("SELECT COUNT(*) FROM `User` WHERE `Gekommen` = 1");
}
@@ -39,14 +74,14 @@ function User_sortable_columns() {
'Aktiv',
'force_active',
'Tshirt',
- 'lastLogIn'
+ 'lastLogIn'
);
}
/**
* Get all users, ordered by Nick by default or by given param.
*
- * @param string $order_by
+ * @param string $order_by
*/
function Users($order_by = 'Nick') {
return sql_select("SELECT * FROM `User` ORDER BY `" . sql_escape($order_by) . "` ASC");
@@ -55,24 +90,24 @@ function Users($order_by = 'Nick') {
/**
* Returns true if user is freeloader
*
- * @param User $user
+ * @param User $user
*/
function User_is_freeloader($user) {
global $max_freeloadable_shifts, $user;
-
+
return count(ShiftEntries_freeloaded_by_user($user)) >= $max_freeloadable_shifts;
}
/**
* Returns all users that are not member of given angeltype.
*
- * @param Angeltype $angeltype
+ * @param Angeltype $angeltype
*/
function Users_by_angeltype_inverted($angeltype) {
return sql_select("
SELECT `User`.*
FROM `User`
- LEFT JOIN `UserAngelTypes` ON (`User`.`UID`=`UserAngelTypes`.`user_id` AND `angeltype_id`=" . sql_escape($angeltype['id']) . ")
+ LEFT JOIN `UserAngelTypes` ON (`User`.`UID`=`UserAngelTypes`.`user_id` AND `angeltype_id`='" . sql_escape($angeltype['id']) . "')
WHERE `UserAngelTypes`.`id` IS NULL
ORDER BY `Nick`");
}
@@ -80,7 +115,7 @@ function Users_by_angeltype_inverted($angeltype) {
/**
* Returns all members of given angeltype.
*
- * @param Angeltype $angeltype
+ * @param Angeltype $angeltype
*/
function Users_by_angeltype($angeltype) {
return sql_select("
@@ -91,7 +126,7 @@ function Users_by_angeltype($angeltype) {
`UserAngelTypes`.`coordinator`
FROM `User`
JOIN `UserAngelTypes` ON `User`.`UID`=`UserAngelTypes`.`user_id`
- WHERE `UserAngelTypes`.`angeltype_id`=" . sql_escape($angeltype['id']) . "
+ WHERE `UserAngelTypes`.`angeltype_id`='" . sql_escape($angeltype['id']) . "'
ORDER BY `Nick`");
}
@@ -105,7 +140,7 @@ function User_ids() {
/**
* Strip unwanted characters from a users nick.
*
- * @param string $nick
+ * @param string $nick
*/
function User_validate_Nick($nick) {
return preg_replace("/([^a-z0-9üöäß. _+*-]{1,})/ui", '', $nick);
@@ -114,10 +149,10 @@ function User_validate_Nick($nick) {
/**
* Returns user by id.
*
- * @param $id UID
+ * @param $id UID
*/
function User($id) {
- $user_source = sql_select("SELECT * FROM `User` WHERE `UID`=" . sql_escape($id) . " LIMIT 1");
+ $user_source = sql_select("SELECT * FROM `User` WHERE `UID`='" . sql_escape($id) . "' LIMIT 1");
if ($user_source === false)
return false;
if (count($user_source) > 0)
@@ -129,10 +164,10 @@ function User($id) {
* TODO: Merge into normal user function
* Returns user by id (limit informations.
*
- * @param $id UID
+ * @param $id UID
*/
function mUser_Limit($id) {
- $user_source = sql_select("SELECT `UID`, `Nick`, `Name`, `Vorname`, `Telefon`, `DECT`, `Handy`, `email`, `jabber`, `Avatar` FROM `User` WHERE `UID`=" . sql_escape($id) . " LIMIT 1");
+ $user_source = sql_select("SELECT `UID`, `Nick`, `Name`, `Vorname`, `Telefon`, `DECT`, `Handy`, `email`, `jabber` FROM `User` WHERE `UID`='" . sql_escape($id) . "' LIMIT 1");
if ($user_source === false)
return false;
if (count($user_source) > 0)
@@ -159,7 +194,7 @@ function User_by_api_key($api_key) {
/**
* Returns User by email.
*
- * @param string $email
+ * @param string $email
* @return Matching user, null or false on error
*/
function User_by_email($email) {
@@ -174,7 +209,7 @@ function User_by_email($email) {
/**
* Returns User by password token.
*
- * @param string $token
+ * @param string $token
* @return Matching user, null or false on error
*/
function User_by_password_recovery_token($token) {
@@ -189,7 +224,7 @@ function User_by_password_recovery_token($token) {
/**
* Generates a new api key for given user.
*
- * @param User $user
+ * @param User $user
*/
function User_reset_api_key(&$user, $log = true) {
$user['api_key'] = md5($user['Nick'] . time() . rand());
@@ -197,20 +232,20 @@ function User_reset_api_key(&$user, $log = true) {
if ($result === false)
return false;
if ($log)
- engelsystem_log(sprintf("API key resetted (%s).",User_Nick_render($user)));
+ engelsystem_log(sprintf("API key resetted (%s).", User_Nick_render($user)));
}
/**
* Generates a new password recovery token for given user.
*
- * @param User $user
+ * @param User $user
*/
function User_generate_password_recovery_token(&$user) {
$user['password_recovery_token'] = md5($user['Nick'] . time() . rand());
$result = sql_query("UPDATE `User` SET `password_recovery_token`='" . sql_escape($user['password_recovery_token']) . "' WHERE `UID`='" . sql_escape($user['UID']) . "' LIMIT 1");
if ($result === false)
return false;
- engelsystem_log("Password recovery for " . $user['Nick'] . " started.");
+ engelsystem_log("Password recovery for " . User_Nick_render($user) . " started.");
return $user['password_recovery_token'];
}
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2024-07-06 05:41:51 +0000