[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * @package        Joomla.Site
   4   * @subpackage    mod_users_latest
   5   * @copyright    Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.
   6   * @license        GNU General Public License version 2 or later; see LICENSE.txt
   7   */
   8  
   9  // no direct access
  10  defined('_JEXEC') or die;
  11  
  12  class modUsersLatestHelper
  13  {
  14      // get users sorted by activation date
  15  	static function getUsers($params)
  16      {
  17          $db        = JFactory::getDbo();
  18          $query    = $db->getQuery(true);
  19          $query->select('a.id, a.name, a.username, a.registerDate');
  20          $query->order('a.registerDate DESC');
  21          $query->from('#__users AS a');
  22          $user = JFactory::getUser();
  23          if (!$user->authorise('core.admin') && $params->get('filter_groups', 0) == 1)
  24          {
  25              $groups = $user->getAuthorisedGroups();
  26              if (empty($groups))
  27              {
  28                  return array();
  29              }
  30              $query->leftJoin('#__user_usergroup_map AS m ON m.user_id = a.id');
  31              $query->leftJoin('#__usergroups AS ug ON ug.id = m.group_id');
  32              $query->where('ug.id in (' . implode(',', $groups) . ')');
  33              $query->where('ug.id <> 1');
  34          }
  35          $db->setQuery($query, 0, $params->get('shownumber'));
  36          $result = $db->loadObjectList();
  37          return (array) $result;
  38      }
  39  }