[Gemstracker-svn] SF.net SVN: gemstracker:[129] trunk/library/classes/Gems/Util/DbLookup.php

[<gem...@li...>]

Revision: 129
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=129&view=rev
Author:   mennodekker
Date:     2011-10-24 11:30:45 +0000 (Mon, 24 Oct 2011)
Log Message:
-----------
getStaff now returns only active staff

Modified Paths:
--------------
    trunk/library/classes/Gems/Util/DbLookup.php

Modified: trunk/library/classes/Gems/Util/DbLookup.php
===================================================================
--- trunk/library/classes/Gems/Util/DbLookup.php	2011-10-24 11:18:29 UTC (rev 128)
+++ trunk/library/classes/Gems/Util/DbLookup.php	2011-10-24 11:30:45 UTC (rev 129)
@@ -213,13 +213,19 @@
         return $roles;
     }
 
+    /**
+     * Return key/value pairs of all active staff members
+     *
+     * @staticvar array $data
+     * @return array
+     */
     public function getStaff()
     {
         static $data;
 
         if (! $data) {
             $data = $this->db->fetchPairs("SELECT gsf_id_user, CONCAT(COALESCE(gsf_last_name, '-'), ', ', COALESCE(gsf_first_name, ''), COALESCE(CONCAT(' ', gsf_surname_prefix), ''))
-                    FROM gems__staff ORDER BY gsf_last_name, gsf_first_name, gsf_surname_prefix");
+                    FROM gems__staff WHERE gsf_active = 1 ORDER BY gsf_last_name, gsf_first_name, gsf_surname_prefix");
         }
 
         return $data;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.