123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822 |
- <?php
- /**
- * SPDX-FileCopyrightText: 2016-2024 Nextcloud GmbH and Nextcloud contributors
- * SPDX-FileCopyrightText: 2016 ownCloud, Inc.
- * SPDX-License-Identifier: AGPL-3.0-only
- */
- namespace OC\User;
- use Doctrine\DBAL\Platforms\OraclePlatform;
- use OC\Hooks\PublicEmitter;
- use OC\Memcache\WithLocalCache;
- use OCP\DB\QueryBuilder\IQueryBuilder;
- use OCP\EventDispatcher\IEventDispatcher;
- use OCP\HintException;
- use OCP\ICache;
- use OCP\ICacheFactory;
- use OCP\IConfig;
- use OCP\IGroup;
- use OCP\IUser;
- use OCP\IUserBackend;
- use OCP\IUserManager;
- use OCP\L10N\IFactory;
- use OCP\Server;
- use OCP\Support\Subscription\IAssertion;
- use OCP\User\Backend\ICheckPasswordBackend;
- use OCP\User\Backend\ICountUsersBackend;
- use OCP\User\Backend\IGetRealUIDBackend;
- use OCP\User\Backend\IProvideEnabledStateBackend;
- use OCP\User\Backend\ISearchKnownUsersBackend;
- use OCP\User\Events\BeforeUserCreatedEvent;
- use OCP\User\Events\UserCreatedEvent;
- use OCP\UserInterface;
- use Psr\Log\LoggerInterface;
- /**
- * Class Manager
- *
- * Hooks available in scope \OC\User:
- * - preSetPassword(\OC\User\User $user, string $password, string $recoverPassword)
- * - postSetPassword(\OC\User\User $user, string $password, string $recoverPassword)
- * - preDelete(\OC\User\User $user)
- * - postDelete(\OC\User\User $user)
- * - preCreateUser(string $uid, string $password)
- * - postCreateUser(\OC\User\User $user, string $password)
- * - change(\OC\User\User $user)
- * - assignedUserId(string $uid)
- * - preUnassignedUserId(string $uid)
- * - postUnassignedUserId(string $uid)
- *
- * @package OC\User
- */
- class Manager extends PublicEmitter implements IUserManager {
- /**
- * @var \OCP\UserInterface[] $backends
- */
- private array $backends = [];
- /**
- * @var array<string,\OC\User\User> $cachedUsers
- */
- private array $cachedUsers = [];
- private ICache $cache;
- private DisplayNameCache $displayNameCache;
- public function __construct(
- private IConfig $config,
- ICacheFactory $cacheFactory,
- private IEventDispatcher $eventDispatcher,
- private LoggerInterface $logger,
- ) {
- $this->cache = new WithLocalCache($cacheFactory->createDistributed('user_backend_map'));
- $this->listen('\OC\User', 'postDelete', function (IUser $user): void {
- unset($this->cachedUsers[$user->getUID()]);
- });
- $this->displayNameCache = new DisplayNameCache($cacheFactory, $this);
- }
- /**
- * Get the active backends
- * @return \OCP\UserInterface[]
- */
- public function getBackends() {
- return $this->backends;
- }
- /**
- * register a user backend
- *
- * @param \OCP\UserInterface $backend
- */
- public function registerBackend($backend) {
- $this->backends[] = $backend;
- }
- /**
- * remove a user backend
- *
- * @param \OCP\UserInterface $backend
- */
- public function removeBackend($backend) {
- $this->cachedUsers = [];
- if (($i = array_search($backend, $this->backends)) !== false) {
- unset($this->backends[$i]);
- }
- }
- /**
- * remove all user backends
- */
- public function clearBackends() {
- $this->cachedUsers = [];
- $this->backends = [];
- }
- /**
- * get a user by user id
- *
- * @param string $uid
- * @return \OC\User\User|null Either the user or null if the specified user does not exist
- */
- public function get($uid) {
- if (is_null($uid) || $uid === '' || $uid === false) {
- return null;
- }
- if (isset($this->cachedUsers[$uid])) { //check the cache first to prevent having to loop over the backends
- return $this->cachedUsers[$uid];
- }
- $cachedBackend = $this->cache->get(sha1($uid));
- if ($cachedBackend !== null && isset($this->backends[$cachedBackend])) {
- // Cache has the info of the user backend already, so ask that one directly
- $backend = $this->backends[$cachedBackend];
- if ($backend->userExists($uid)) {
- return $this->getUserObject($uid, $backend);
- }
- }
- foreach ($this->backends as $i => $backend) {
- if ($i === $cachedBackend) {
- // Tried that one already
- continue;
- }
- if ($backend->userExists($uid)) {
- // Hash $uid to ensure that only valid characters are used for the cache key
- $this->cache->set(sha1($uid), $i, 300);
- return $this->getUserObject($uid, $backend);
- }
- }
- return null;
- }
- public function getDisplayName(string $uid): ?string {
- return $this->displayNameCache->getDisplayName($uid);
- }
- /**
- * get or construct the user object
- *
- * @param string $uid
- * @param \OCP\UserInterface $backend
- * @param bool $cacheUser If false the newly created user object will not be cached
- * @return \OC\User\User
- */
- public function getUserObject($uid, $backend, $cacheUser = true) {
- if ($backend instanceof IGetRealUIDBackend) {
- $uid = $backend->getRealUID($uid);
- }
- if (isset($this->cachedUsers[$uid])) {
- return $this->cachedUsers[$uid];
- }
- $user = new User($uid, $backend, $this->eventDispatcher, $this, $this->config);
- if ($cacheUser) {
- $this->cachedUsers[$uid] = $user;
- }
- return $user;
- }
- /**
- * check if a user exists
- *
- * @param string $uid
- * @return bool
- */
- public function userExists($uid) {
- $user = $this->get($uid);
- return ($user !== null);
- }
- /**
- * Check if the password is valid for the user
- *
- * @param string $loginName
- * @param string $password
- * @return IUser|false the User object on success, false otherwise
- */
- public function checkPassword($loginName, $password) {
- $result = $this->checkPasswordNoLogging($loginName, $password);
- if ($result === false) {
- $this->logger->warning('Login failed: \'' . $loginName . '\' (Remote IP: \'' . \OC::$server->getRequest()->getRemoteAddress() . '\')', ['app' => 'core']);
- }
- return $result;
- }
- /**
- * Check if the password is valid for the user
- *
- * @internal
- * @param string $loginName
- * @param string $password
- * @return IUser|false the User object on success, false otherwise
- */
- public function checkPasswordNoLogging($loginName, $password) {
- $loginName = str_replace("\0", '', $loginName);
- $password = str_replace("\0", '', $password);
- $cachedBackend = $this->cache->get($loginName);
- if ($cachedBackend !== null && isset($this->backends[$cachedBackend])) {
- $backends = [$this->backends[$cachedBackend]];
- } else {
- $backends = $this->backends;
- }
- foreach ($backends as $backend) {
- if ($backend instanceof ICheckPasswordBackend || $backend->implementsActions(Backend::CHECK_PASSWORD)) {
- /** @var ICheckPasswordBackend $backend */
- $uid = $backend->checkPassword($loginName, $password);
- if ($uid !== false) {
- return $this->getUserObject($uid, $backend);
- }
- }
- }
- // since http basic auth doesn't provide a standard way of handling non ascii password we allow password to be urlencoded
- // we only do this decoding after using the plain password fails to maintain compatibility with any password that happens
- // to contain urlencoded patterns by "accident".
- $password = urldecode($password);
- foreach ($backends as $backend) {
- if ($backend instanceof ICheckPasswordBackend || $backend->implementsActions(Backend::CHECK_PASSWORD)) {
- /** @var ICheckPasswordBackend|UserInterface $backend */
- $uid = $backend->checkPassword($loginName, $password);
- if ($uid !== false) {
- return $this->getUserObject($uid, $backend);
- }
- }
- }
- return false;
- }
- /**
- * Search by user id
- *
- * @param string $pattern
- * @param int $limit
- * @param int $offset
- * @return IUser[]
- * @deprecated 27.0.0, use searchDisplayName instead
- */
- public function search($pattern, $limit = null, $offset = null) {
- $users = [];
- foreach ($this->backends as $backend) {
- $backendUsers = $backend->getUsers($pattern, $limit, $offset);
- if (is_array($backendUsers)) {
- foreach ($backendUsers as $uid) {
- $users[$uid] = new LazyUser($uid, $this, null, $backend);
- }
- }
- }
- uasort($users, function (IUser $a, IUser $b) {
- return strcasecmp($a->getUID(), $b->getUID());
- });
- return $users;
- }
- /**
- * Search by displayName
- *
- * @param string $pattern
- * @param int $limit
- * @param int $offset
- * @return IUser[]
- */
- public function searchDisplayName($pattern, $limit = null, $offset = null) {
- $users = [];
- foreach ($this->backends as $backend) {
- $backendUsers = $backend->getDisplayNames($pattern, $limit, $offset);
- if (is_array($backendUsers)) {
- foreach ($backendUsers as $uid => $displayName) {
- $users[] = new LazyUser($uid, $this, $displayName, $backend);
- }
- }
- }
- usort($users, function (IUser $a, IUser $b) {
- return strcasecmp($a->getDisplayName(), $b->getDisplayName());
- });
- return $users;
- }
- /**
- * @return IUser[]
- */
- public function getDisabledUsers(?int $limit = null, int $offset = 0, string $search = ''): array {
- $users = $this->config->getUsersForUserValue('core', 'enabled', 'false');
- $users = array_combine(
- $users,
- array_map(
- fn (string $uid): IUser => new LazyUser($uid, $this),
- $users
- )
- );
- if ($search !== '') {
- $users = array_filter(
- $users,
- function (IUser $user) use ($search): bool {
- try {
- return mb_stripos($user->getUID(), $search) !== false ||
- mb_stripos($user->getDisplayName(), $search) !== false ||
- mb_stripos($user->getEMailAddress() ?? '', $search) !== false;
- } catch (NoUserException $ex) {
- $this->logger->error('Error while filtering disabled users', ['exception' => $ex, 'userUID' => $user->getUID()]);
- return false;
- }
- });
- }
- $tempLimit = ($limit === null ? null : $limit + $offset);
- foreach ($this->backends as $backend) {
- if (($tempLimit !== null) && (count($users) >= $tempLimit)) {
- break;
- }
- if ($backend instanceof IProvideEnabledStateBackend) {
- $backendUsers = $backend->getDisabledUserList(($tempLimit === null ? null : $tempLimit - count($users)), 0, $search);
- foreach ($backendUsers as $uid) {
- $users[$uid] = new LazyUser($uid, $this, null, $backend);
- }
- }
- }
- return array_slice($users, $offset, $limit);
- }
- /**
- * Search known users (from phonebook sync) by displayName
- *
- * @param string $searcher
- * @param string $pattern
- * @param int|null $limit
- * @param int|null $offset
- * @return IUser[]
- */
- public function searchKnownUsersByDisplayName(string $searcher, string $pattern, ?int $limit = null, ?int $offset = null): array {
- $users = [];
- foreach ($this->backends as $backend) {
- if ($backend instanceof ISearchKnownUsersBackend) {
- $backendUsers = $backend->searchKnownUsersByDisplayName($searcher, $pattern, $limit, $offset);
- } else {
- // Better than nothing, but filtering after pagination can remove lots of results.
- $backendUsers = $backend->getDisplayNames($pattern, $limit, $offset);
- }
- if (is_array($backendUsers)) {
- foreach ($backendUsers as $uid => $displayName) {
- $users[] = $this->getUserObject($uid, $backend);
- }
- }
- }
- usort($users, function ($a, $b) {
- /**
- * @var IUser $a
- * @var IUser $b
- */
- return strcasecmp($a->getDisplayName(), $b->getDisplayName());
- });
- return $users;
- }
- /**
- * @param string $uid
- * @param string $password
- * @return false|IUser the created user or false
- * @throws \InvalidArgumentException
- * @throws HintException
- */
- public function createUser($uid, $password) {
- // DI injection is not used here as IRegistry needs the user manager itself for user count and thus it would create a cyclic dependency
- /** @var IAssertion $assertion */
- $assertion = \OC::$server->get(IAssertion::class);
- $assertion->createUserIsLegit();
- $localBackends = [];
- foreach ($this->backends as $backend) {
- if ($backend instanceof Database) {
- // First check if there is another user backend
- $localBackends[] = $backend;
- continue;
- }
- if ($backend->implementsActions(Backend::CREATE_USER)) {
- return $this->createUserFromBackend($uid, $password, $backend);
- }
- }
- foreach ($localBackends as $backend) {
- if ($backend->implementsActions(Backend::CREATE_USER)) {
- return $this->createUserFromBackend($uid, $password, $backend);
- }
- }
- return false;
- }
- /**
- * @param string $uid
- * @param string $password
- * @param UserInterface $backend
- * @return IUser|false
- * @throws \InvalidArgumentException
- */
- public function createUserFromBackend($uid, $password, UserInterface $backend) {
- $l = \OCP\Util::getL10N('lib');
- $this->validateUserId($uid, true);
- // No empty password
- if (trim($password) === '') {
- throw new \InvalidArgumentException($l->t('A valid password must be provided'));
- }
- // Check if user already exists
- if ($this->userExists($uid)) {
- throw new \InvalidArgumentException($l->t('The Login is already being used'));
- }
- /** @deprecated 21.0.0 use BeforeUserCreatedEvent event with the IEventDispatcher instead */
- $this->emit('\OC\User', 'preCreateUser', [$uid, $password]);
- $this->eventDispatcher->dispatchTyped(new BeforeUserCreatedEvent($uid, $password));
- $state = $backend->createUser($uid, $password);
- if ($state === false) {
- throw new \InvalidArgumentException($l->t('Could not create account'));
- }
- $user = $this->getUserObject($uid, $backend);
- if ($user instanceof IUser) {
- /** @deprecated 21.0.0 use UserCreatedEvent event with the IEventDispatcher instead */
- $this->emit('\OC\User', 'postCreateUser', [$user, $password]);
- $this->eventDispatcher->dispatchTyped(new UserCreatedEvent($user, $password));
- return $user;
- }
- return false;
- }
- /**
- * returns how many users per backend exist (if supported by backend)
- *
- * @param boolean $hasLoggedIn when true only users that have a lastLogin
- * entry in the preferences table will be affected
- * @return array<string, int> an array of backend class as key and count number as value
- */
- public function countUsers() {
- $userCountStatistics = [];
- foreach ($this->backends as $backend) {
- if ($backend instanceof ICountUsersBackend || $backend->implementsActions(Backend::COUNT_USERS)) {
- /** @var ICountUsersBackend|IUserBackend $backend */
- $backendUsers = $backend->countUsers();
- if ($backendUsers !== false) {
- if ($backend instanceof IUserBackend) {
- $name = $backend->getBackendName();
- } else {
- $name = get_class($backend);
- }
- if (isset($userCountStatistics[$name])) {
- $userCountStatistics[$name] += $backendUsers;
- } else {
- $userCountStatistics[$name] = $backendUsers;
- }
- }
- }
- }
- return $userCountStatistics;
- }
- /**
- * returns how many users per backend exist in the requested groups (if supported by backend)
- *
- * @param IGroup[] $groups an array of gid to search in
- * @return array|int an array of backend class as key and count number as value
- * if $hasLoggedIn is true only an int is returned
- */
- public function countUsersOfGroups(array $groups) {
- $users = [];
- foreach ($groups as $group) {
- $usersIds = array_map(function ($user) {
- return $user->getUID();
- }, $group->getUsers());
- $users = array_merge($users, $usersIds);
- }
- return count(array_unique($users));
- }
- /**
- * The callback is executed for each user on each backend.
- * If the callback returns false no further users will be retrieved.
- *
- * @psalm-param \Closure(\OCP\IUser):?bool $callback
- * @param string $search
- * @param boolean $onlySeen when true only users that have a lastLogin entry
- * in the preferences table will be affected
- * @since 9.0.0
- */
- public function callForAllUsers(\Closure $callback, $search = '', $onlySeen = false) {
- if ($onlySeen) {
- $this->callForSeenUsers($callback);
- } else {
- foreach ($this->getBackends() as $backend) {
- $limit = 500;
- $offset = 0;
- do {
- $users = $backend->getUsers($search, $limit, $offset);
- foreach ($users as $uid) {
- if (!$backend->userExists($uid)) {
- continue;
- }
- $user = $this->getUserObject($uid, $backend, false);
- $return = $callback($user);
- if ($return === false) {
- break;
- }
- }
- $offset += $limit;
- } while (count($users) >= $limit);
- }
- }
- }
- /**
- * returns how many users are disabled
- *
- * @return int
- * @since 12.0.0
- */
- public function countDisabledUsers(): int {
- $queryBuilder = \OC::$server->getDatabaseConnection()->getQueryBuilder();
- $queryBuilder->select($queryBuilder->func()->count('*'))
- ->from('preferences')
- ->where($queryBuilder->expr()->eq('appid', $queryBuilder->createNamedParameter('core')))
- ->andWhere($queryBuilder->expr()->eq('configkey', $queryBuilder->createNamedParameter('enabled')))
- ->andWhere($queryBuilder->expr()->eq('configvalue', $queryBuilder->createNamedParameter('false'), IQueryBuilder::PARAM_STR));
- $result = $queryBuilder->execute();
- $count = $result->fetchOne();
- $result->closeCursor();
- if ($count !== false) {
- $count = (int)$count;
- } else {
- $count = 0;
- }
- return $count;
- }
- /**
- * returns how many users are disabled in the requested groups
- *
- * @param array $groups groupids to search
- * @return int
- * @since 14.0.0
- */
- public function countDisabledUsersOfGroups(array $groups): int {
- $queryBuilder = \OC::$server->getDatabaseConnection()->getQueryBuilder();
- $queryBuilder->select($queryBuilder->createFunction('COUNT(DISTINCT ' . $queryBuilder->getColumnName('uid') . ')'))
- ->from('preferences', 'p')
- ->innerJoin('p', 'group_user', 'g', $queryBuilder->expr()->eq('p.userid', 'g.uid'))
- ->where($queryBuilder->expr()->eq('appid', $queryBuilder->createNamedParameter('core')))
- ->andWhere($queryBuilder->expr()->eq('configkey', $queryBuilder->createNamedParameter('enabled')))
- ->andWhere($queryBuilder->expr()->eq('configvalue', $queryBuilder->createNamedParameter('false'), IQueryBuilder::PARAM_STR))
- ->andWhere($queryBuilder->expr()->in('gid', $queryBuilder->createNamedParameter($groups, IQueryBuilder::PARAM_STR_ARRAY)));
- $result = $queryBuilder->execute();
- $count = $result->fetchOne();
- $result->closeCursor();
- if ($count !== false) {
- $count = (int)$count;
- } else {
- $count = 0;
- }
- return $count;
- }
- /**
- * returns how many users have logged in once
- *
- * @return int
- * @since 11.0.0
- */
- public function countSeenUsers() {
- $queryBuilder = \OC::$server->getDatabaseConnection()->getQueryBuilder();
- $queryBuilder->select($queryBuilder->func()->count('*'))
- ->from('preferences')
- ->where($queryBuilder->expr()->eq('appid', $queryBuilder->createNamedParameter('login')))
- ->andWhere($queryBuilder->expr()->eq('configkey', $queryBuilder->createNamedParameter('lastLogin')));
- $query = $queryBuilder->execute();
- $result = (int)$query->fetchOne();
- $query->closeCursor();
- return $result;
- }
- /**
- * @param \Closure $callback
- * @psalm-param \Closure(\OCP\IUser):?bool $callback
- * @since 11.0.0
- */
- public function callForSeenUsers(\Closure $callback) {
- $limit = 1000;
- $offset = 0;
- do {
- $userIds = $this->getSeenUserIds($limit, $offset);
- $offset += $limit;
- foreach ($userIds as $userId) {
- foreach ($this->backends as $backend) {
- if ($backend->userExists($userId)) {
- $user = $this->getUserObject($userId, $backend, false);
- $return = $callback($user);
- if ($return === false) {
- return;
- }
- break;
- }
- }
- }
- } while (count($userIds) >= $limit);
- }
- /**
- * Getting all userIds that have a listLogin value requires checking the
- * value in php because on oracle you cannot use a clob in a where clause,
- * preventing us from doing a not null or length(value) > 0 check.
- *
- * @param int $limit
- * @param int $offset
- * @return string[] with user ids
- */
- private function getSeenUserIds($limit = null, $offset = null) {
- $queryBuilder = \OC::$server->getDatabaseConnection()->getQueryBuilder();
- $queryBuilder->select(['userid'])
- ->from('preferences')
- ->where($queryBuilder->expr()->eq(
- 'appid', $queryBuilder->createNamedParameter('login'))
- )
- ->andWhere($queryBuilder->expr()->eq(
- 'configkey', $queryBuilder->createNamedParameter('lastLogin'))
- )
- ->andWhere($queryBuilder->expr()->isNotNull('configvalue')
- );
- if ($limit !== null) {
- $queryBuilder->setMaxResults($limit);
- }
- if ($offset !== null) {
- $queryBuilder->setFirstResult($offset);
- }
- $query = $queryBuilder->execute();
- $result = [];
- while ($row = $query->fetch()) {
- $result[] = $row['userid'];
- }
- $query->closeCursor();
- return $result;
- }
- /**
- * @param string $email
- * @return IUser[]
- * @since 9.1.0
- */
- public function getByEmail($email) {
- // looking for 'email' only (and not primary_mail) is intentional
- $userIds = $this->config->getUsersForUserValueCaseInsensitive('settings', 'email', $email);
- $users = array_map(function ($uid) {
- return $this->get($uid);
- }, $userIds);
- return array_values(array_filter($users, function ($u) {
- return ($u instanceof IUser);
- }));
- }
- /**
- * @param string $uid
- * @param bool $checkDataDirectory
- * @throws \InvalidArgumentException Message is an already translated string with a reason why the id is not valid
- * @since 26.0.0
- */
- public function validateUserId(string $uid, bool $checkDataDirectory = false): void {
- $l = Server::get(IFactory::class)->get('lib');
- // Check the name for bad characters
- // Allowed are: "a-z", "A-Z", "0-9", spaces and "_.@-'"
- if (preg_match('/[^a-zA-Z0-9 _.@\-\']/', $uid)) {
- throw new \InvalidArgumentException($l->t('Only the following characters are allowed in an Login:'
- . ' "a-z", "A-Z", "0-9", spaces and "_.@-\'"'));
- }
- // No empty username
- if (trim($uid) === '') {
- throw new \InvalidArgumentException($l->t('A valid Login must be provided'));
- }
- // No whitespace at the beginning or at the end
- if (trim($uid) !== $uid) {
- throw new \InvalidArgumentException($l->t('Login contains whitespace at the beginning or at the end'));
- }
- // Username only consists of 1 or 2 dots (directory traversal)
- if ($uid === '.' || $uid === '..') {
- throw new \InvalidArgumentException($l->t('Login must not consist of dots only'));
- }
- if (!$this->verifyUid($uid, $checkDataDirectory)) {
- throw new \InvalidArgumentException($l->t('Login is invalid because files already exist for this user'));
- }
- }
- /**
- * Gets the list of user ids sorted by lastLogin, from most recent to least recent
- *
- * @param int|null $limit how many users to fetch (default: 25, max: 100)
- * @param int $offset from which offset to fetch
- * @param string $search search users based on search params
- * @return list<string> list of user IDs
- */
- public function getLastLoggedInUsers(?int $limit = null, int $offset = 0, string $search = ''): array {
- // We can't load all users who already logged in
- $limit = min(100, $limit ?: 25);
- $connection = \OC::$server->getDatabaseConnection();
- $queryBuilder = $connection->getQueryBuilder();
- $queryBuilder->select('pref_login.userid')
- ->from('preferences', 'pref_login')
- ->where($queryBuilder->expr()->eq('pref_login.appid', $queryBuilder->expr()->literal('login')))
- ->andWhere($queryBuilder->expr()->eq('pref_login.configkey', $queryBuilder->expr()->literal('lastLogin')))
- ->setFirstResult($offset)
- ->setMaxResults($limit)
- ;
- // Oracle don't want to run ORDER BY on CLOB column
- $loginOrder = $connection->getDatabasePlatform() instanceof OraclePlatform
- ? $queryBuilder->expr()->castColumn('pref_login.configvalue', IQueryBuilder::PARAM_INT)
- : 'pref_login.configvalue';
- $queryBuilder
- ->orderBy($loginOrder, 'DESC')
- ->addOrderBy($queryBuilder->func()->lower('pref_login.userid'), 'ASC');
- if ($search !== '') {
- $displayNameMatches = $this->searchDisplayName($search);
- $matchedUids = array_map(static fn (IUser $u): string => $u->getUID(), $displayNameMatches);
- $queryBuilder
- ->leftJoin('pref_login', 'preferences', 'pref_email', $queryBuilder->expr()->andX(
- $queryBuilder->expr()->eq('pref_login.userid', 'pref_email.userid'),
- $queryBuilder->expr()->eq('pref_email.appid', $queryBuilder->expr()->literal('settings')),
- $queryBuilder->expr()->eq('pref_email.configkey', $queryBuilder->expr()->literal('email')),
- ))
- ->andWhere($queryBuilder->expr()->orX(
- $queryBuilder->expr()->in('pref_login.userid', $queryBuilder->createNamedParameter($matchedUids, IQueryBuilder::PARAM_STR_ARRAY)),
- ));
- }
- /** @var list<string> */
- $list = $queryBuilder->executeQuery()->fetchAll(\PDO::FETCH_COLUMN);
- return $list;
- }
- private function verifyUid(string $uid, bool $checkDataDirectory = false): bool {
- $appdata = 'appdata_' . $this->config->getSystemValueString('instanceid');
- if (\in_array($uid, [
- '.htaccess',
- 'files_external',
- '__groupfolders',
- '.ncdata',
- 'owncloud.log',
- 'nextcloud.log',
- 'updater.log',
- 'audit.log',
- $appdata], true)) {
- return false;
- }
- if (!$checkDataDirectory) {
- return true;
- }
- $dataDirectory = $this->config->getSystemValueString('datadirectory', \OC::$SERVERROOT . '/data');
- return !file_exists(rtrim($dataDirectory, '/') . '/' . $uid);
- }
- public function getDisplayNameCache(): DisplayNameCache {
- return $this->displayNameCache;
- }
- }
|