diff options
author | Philip Häusler <msquare@notrademark.de> | 2014-05-13 15:51:45 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2014-05-13 15:51:45 +0200 |
commit | f1145b8a5e8630e0180d35ff1ced2e934b872f01 (patch) | |
tree | c99e7b7a5f6e1ab3839777dbd8095f83a1c94f20 /includes/model/User_model.php | |
parent | e107dff1ce417df779733667ad81d60755582779 (diff) |
implemented team/angeltype coordinators
Diffstat (limited to 'includes/model/User_model.php')
-rw-r--r-- | includes/model/User_model.php | 26 |
1 files changed, 24 insertions, 2 deletions
diff --git a/includes/model/User_model.php b/includes/model/User_model.php index d369ea3e..c8c48e6c 100644 --- a/includes/model/User_model.php +++ b/includes/model/User_model.php @@ -1,12 +1,34 @@ <?php +/** + * User model + */ + +/** + * Returns all users that are not member of given 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']) . ") + WHERE `UserAngelTypes`.`id` IS NULL + ORDER BY `Nick`"); +} /** * Returns all members of given angeltype. - * @param Angeltype $angeltype + * + * @param Angeltype $angeltype */ function Users_by_angeltype($angeltype) { return sql_select(" - SELECT `User`.*, `UserAngelTypes`.`id` as `user_angeltype_id`, `UserAngelTypes`.`confirm_user_id` + SELECT + `User`.*, + `UserAngelTypes`.`id` as `user_angeltype_id`, + `UserAngelTypes`.`confirm_user_id`, + `UserAngelTypes`.`coordinator` FROM `User` JOIN `UserAngelTypes` ON `User`.`UID`=`UserAngelTypes`.`user_id` WHERE `UserAngelTypes`.`angeltype_id`=" . sql_escape($angeltype['id']) . " |