Touren application

[infodrom.org/touren.infodrom.org] / core / sys_user.class.php

diff --git a/core/sys_user.class.php b/core/sys_user.class.php
index c03b23a..5611726 100644 (file)
--- a/core/sys_user.class.php
+++ b/core/sys_user.class.php
@@ -21,4 +21,20 @@ class Sys_User extends DatabaseTable
                              'pwkey' => NULL,
                              'pwkey_valid' => NULL]);
     }
+
+    public function getUserlist($tour_id=false)
+    {
+       $tour_id = intval($tour_id);
+       $sql =<<<EOS
+           SELECT DISTINCT
+             sys_user.id,sys_user.name,sys_user.email,tour_id IS NOT NULL AS active
+           FROM sys_user
+           LEFT JOIN tour_member ON sys_user.id = member_id
+                                AND ({$tour_id} = 0 OR tour_id = {$tour_id})
+           WHERE sys_user.id > 1 AND active = true
+           ORDER by sys_user.name
+EOS;
+
+       return $this->db->fetchObjectList($sql);
+    }
 }