notify coordinators about unconfirmed angeltypes

1 files changed, 15 insertions, 0 deletions

diff --git a/includes/model/UserAngelTypes_model.php b/includes/model/UserAngelTypes_model.php
index b9b44032..a9944ff1 100644
--- a/includes/model/UserAngelTypes_model.php
+++ b/includes/model/UserAngelTypes_model.php
@@ -4,6 +4,21 @@
  */
 
 /**
+ * Gets unconfirmed user angeltypes for angeltypes of which the given user is a coordinator.
+ *
+ * @param User $user          
+ */
+function User_unconfirmed_AngelTypes($user) {
+  return sql_select("
+    SELECT `UnconfirmedMembers`.*, `AngelTypes`.`name` FROM `UserAngelTypes`
+    JOIN `AngelTypes` ON `UserAngelTypes`.`angeltype_id`=`AngelTypes`.`id`
+    JOIN `UserAngelTypes` as `UnconfirmedMembers` ON `UserAngelTypes`.`angeltype_id`=`UnconfirmedMembers`.`angeltype_id`
+    WHERE `UserAngelTypes`.`user_id`=" . sql_escape($user['UID']) . "
+    AND `AngelTypes`.`restricted`=TRUE
+    AND `UnconfirmedMembers`.`confirm_user_id` IS NULL");
+}
+
+/**
  * Returns true if user is angeltype coordinator or has privilege admin_user_angeltypes.
  *
  * @param User $user