public static string
users
(mixed $name, mixed $active, mixed $nouser = 0, mixed $javascript = null, mixed $order = 'name')
/**
* Select list of active users
*
* @param string $name The name of the field
* @param string $active The active user
* @param integer $nouser If set include an option to select no user
* @param string $javascript Custom javascript
* @param string $order Specify a field to order by
*
* @return string The HTML for a list of users list of users
*
* @since 1.5
*/
public static function users($name, $active, $nouser = 0, $javascript = null, $order = 'name')
{
$db = Factory::getDbo();
$query = $db->getQuery(true)->select([$db->quoteName('u.id', 'value'), $db->quoteName('u.name', 'text')])->from($db->quoteName('#__users', 'u'))->join('LEFT', $db->quoteName('#__user_usergroup_map', 'm'), $db->quoteName('m.user_id') . ' = ' . $db->quoteName('u.id'))->where($db->quoteName('u.block') . ' = 0')->order($order)->group($db->quoteName('u.id'));
$db->setQuery($query);
if ($nouser) {
$users[] = HTMLHelper::_('select.option', '0', Text::_('JOPTION_NO_USER'));
$users = array_merge($users, $db->loadObjectList());
} else {
$users = $db->loadObjectList();
}
$users = HTMLHelper::_('select.genericlist', $users, $name, array('list.attr' => 'size="1" ' . $javascript, 'list.select' => $active));
return $users;
}