actorStore = $actorStore; $this->table( 'actor' ); } /** * Find by provided user ids. * * @param int|int[] $userIds * @return UserSelectQueryBuilder */ public function userIds( $userIds ): self { Assert::parameterType( 'integer|array', $userIds, '$userIds' ); $this->conds( [ 'actor_user' => $userIds ] ); return $this; } /** * Find by provided user names. * * @param string|string[] $userNames * @return UserSelectQueryBuilder */ public function userNames( $userNames ): self { Assert::parameterType( 'string|array', $userNames, '$userIds' ); $userNames = array_map( function ( $name ) { return $this->actorStore->normalizeUserName( (string)$name ); }, (array)$userNames ); $this->conds( [ 'actor_name' => $userNames ] ); return $this; } /** * Find users with names starting from the provided prefix. * * @note this could produce a huge number of results, like User00000 ... User99999, * so you must set a limit when using this condition. * * @param string $prefix * @return UserSelectQueryBuilder */ public function userNamePrefix( string $prefix ): self { if ( !isset( $this->options['LIMIT'] ) ) { throw new PreconditionException( 'Must set a limit when using a user name prefix' ); } $like = $this->db->buildLike( $prefix, $this->db->anyString() ); $this->conds( "actor_name{$like}" ); return $this; } /** * Order results by name in $direction * * @param string $dir one of self::SORT_ACS or self::SORT_DESC * @return UserSelectQueryBuilder */ public function orderByName( string $dir = self::SORT_ASC ): self { $this->orderBy( 'actor_name', $dir ); return $this; } /** * Order results by user id. * * @param string $dir one of self::SORT_ACS or self::SORT_DESC * @return UserSelectQueryBuilder */ public function orderByUserId( string $dir = self::SORT_ASC ): self { $this->orderBy( 'actor_user', $dir ); return $this; } /** * Only return registered users. * * @return UserSelectQueryBuilder */ public function registered(): self { $this->conds( [ 'actor_user != 0' ] ); return $this; } /** * Only return anonymous users. * * @return UserSelectQueryBuilder */ public function anon(): self { $this->conds( [ 'actor_user' => null ] ); return $this; } /** * Fetch a single UserIdentity that matches specified criteria. * * @return UserIdentity|null */ public function fetchUserIdentity(): ?UserIdentity { $this->fields( [ 'actor_id', 'actor_name', 'actor_user' ] ); $row = $this->fetchRow(); if ( !$row ) { return null; } return $this->actorStore->newActorFromRow( $row ); } /** * Fetch UserIdentities for the specified query. * * @return Iterator */ public function fetchUserIdentities(): Iterator { $this->fields( [ 'actor_id', 'actor_name', 'actor_user' ] ); return call_user_func( function () { $result = $this->fetchResultSet(); foreach ( $result as $row ) { yield $this->actorStore->newActorFromRow( $row ); } $result->free(); } ); } /** * Returns an array of user names matching the query. * * @return string[] */ public function fetchUserNames(): array { $this->field( 'actor_name' ); return $this->fetchFieldValues(); } }