- md5
- 8a3651daf330d40ccf16d2a745144add
- sha1
- ad6570238d93c31a41c988d2e2c25b2976282a66
- sha256
- 28681cfbe682edad059d7fe407d9d3539f6ea16af95d5f686f7c864136fe4fae
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
<?php
/**
* Joomla! Content Management System
*
* @copyright Copyright (C) 2005 - 2020 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
namespace Joomla\CMS\Console;
\defined('JPATH_PLATFORM') or die;
use Joomla\CMS\Factory;
use Joomla\Console\Command\AbstractCommand;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Style\SymfonyStyle;
/**
* Console command to list existing users
*
* @since 4.0.0
*/
class ListUserCommand extends AbstractCommand
{
/**
* The default command name
*
* @var string
* @since 4.0.0
*/
protected static $defaultName = 'user:list';
/**
* SymfonyStyle Object
* @var object
* @since 4.0.0
*/
private $ioStyle;
/**
* Internal function to execute the command.
*
* @param InputInterface $input The input to inject into the command.
* @param OutputInterface $output The output to inject into the command.
*
* @return integer The command exit code
*
* @since 4.0.0
*/
protected function doExecute(InputInterface $input, OutputInterface $output): int
{
$db = Factory::getDbo();
$this->configureIO($input, $output);
$this->ioStyle->title('List users');
$groupsQuery = $db->getQuery(true)
->select($db->quoteName(['title', 'id']))
->from($db->quoteName('#__usergroups'));
$groups = $db->setQuery($groupsQuery)->loadAssocList('id', 'title');
$query = $db->getQuery(true);
$query->select($db->quoteName(['u.id', 'u.username', 'u.name', 'u.email', 'u.block']))
->select($query->groupConcat($query->castAs('CHAR', $db->quoteName('g.group_id'))) . ' AS ' . $db->quoteName('groups'))
->innerJoin($db->quoteName('#__user_usergroup_map', 'g'), $db->quoteName('g.user_id') . ' = ' . $db->quoteName('u.id'))
->from($db->quoteName('#__users', 'u'))
->group($db->quoteName('u.id'));
$db->setQuery($query);
$users = [];
foreach ($db->loadAssocList() as $user)
{
$user["groups"] = array_map(
function ($groupId) use ($groups) {
return $groups[$groupId];
},
explode(",", $user["groups"])
);
$user["groups"] = implode(", ", $user["groups"]);
$users[] = $user;
}
$this->ioStyle->table(['id', 'username', 'name', 'email', 'blocked', 'groups'], $users);
return 0;
}
/**
* Configure the IO.
*
* @param InputInterface $input The input to inject into the command.
* @param OutputInterface $output The output to inject into the command.
*
* @return void
*
* @since 4.0.0
*/
private function configureIO(InputInterface $input, OutputInterface $output)
{
$this->ioStyle = new SymfonyStyle($input, $output);
}
/**
* Configure the command.
*
* @return void
*
* @since 4.0.0
*/
protected function configure(): void
{
$help = "<info>%command.name%</info> will list all users
\nUsage: <info>php %command.full_name%</info>";
$this->setDescription('List all users');
$this->setHelp($help);
}
}
The same content is in 3 releases, Joomla 4.0.0-beta3 to 4.0.0-beta5. See them all, or every version of this file.