UsersPager.php

Go to the documentation of this file.

<?php
class UsersPager extends AlphabeticPager {
 
    protected $userGroupCache;
 
    function __construct( IContextSource $context = null, $par = null, $including = null ) {
        if ( $context ) {
            $this->setContext( $context );
        }
 
        $request = $this->getRequest();
        $par = ( $par !== null ) ? $par : '';
        $parms = explode( '/', $par );
        $symsForAll = [ '*', 'user' ];
 
        if ( $parms[0] != '' &&
            ( in_array( $par, User::getAllGroups() ) || in_array( $par, $symsForAll ) )
        ) {
            $this->requestedGroup = $par;
            $un = $request->getText( 'username' );
        } elseif ( count( $parms ) == 2 ) {
            $this->requestedGroup = $parms[0];
            $un = $parms[1];
        } else {
            $this->requestedGroup = $request->getVal( 'group' );
            $un = ( $par != '' ) ? $par : $request->getText( 'username' );
        }
 
        if ( in_array( $this->requestedGroup, $symsForAll ) ) {
            $this->requestedGroup = '';
        }
        $this->editsOnly = $request->getBool( 'editsOnly' );
        $this->creationSort = $request->getBool( 'creationSort' );
        $this->including = $including;
        $this->mDefaultDirection = $request->getBool( 'desc' )
            ? IndexPager::DIR_DESCENDING
            : IndexPager::DIR_ASCENDING;
 
        $this->requestedUser = '';
 
        if ( $un != '' ) {
            $username = Title::makeTitleSafe( NS_USER, $un );
 
            if ( !is_null( $username ) ) {
                $this->requestedUser = $username->getText();
            }
        }
 
        parent::__construct();
    }
 
    function getIndexField() {
        return $this->creationSort ? 'user_id' : 'user_name';
    }
 
    function getQueryInfo() {
        $dbr = wfGetDB( DB_REPLICA );
        $conds = [];
 
        // Don't show hidden names
        if ( !$this->getUser()->isAllowed( 'hideuser' ) ) {
            $conds[] = 'ipb_deleted IS NULL OR ipb_deleted = 0';
        }
 
        $options = [];
 
        if ( $this->requestedGroup != '' ) {
            $conds['ug_group'] = $this->requestedGroup;
            $conds[] = 'ug_expiry IS NULL OR ug_expiry >= ' . $dbr->addQuotes( $dbr->timestamp() );
        }
 
        if ( $this->requestedUser != '' ) {
            # Sorted either by account creation or name
            if ( $this->creationSort ) {
                $conds[] = 'user_id >= ' . intval( User::idFromName( $this->requestedUser ) );
            } else {
                $conds[] = 'user_name >= ' . $dbr->addQuotes( $this->requestedUser );
            }
        }
 
        if ( $this->editsOnly ) {
            $conds[] = 'user_editcount > 0';
        }
 
        $options['GROUP BY'] = $this->creationSort ? 'user_id' : 'user_name';
 
        $query = [
            'tables' => [ 'user', 'user_groups', 'ipblocks' ],
            'fields' => [
                'user_name' => $this->creationSort ? 'MAX(user_name)' : 'user_name',
                'user_id' => $this->creationSort ? 'user_id' : 'MAX(user_id)',
                'edits' => 'MAX(user_editcount)',
                'creation' => 'MIN(user_registration)',
                'ipb_deleted' => 'MAX(ipb_deleted)' // block/hide status
            ],
            'options' => $options,
            'join_conds' => [
                'user_groups' => [ 'LEFT JOIN', 'user_id=ug_user' ],
                'ipblocks' => [
                    'LEFT JOIN', [
                        'user_id=ipb_user',
                        'ipb_auto' => 0
                    ]
                ],
            ],
            'conds' => $conds
        ];
 
        Hooks::run( 'SpecialListusersQueryInfo', [ $this, &$query ] );
 
        return $query;
    }
 
    function formatRow( $row ) {
        if ( $row->user_id == 0 ) { # T18487
            return '';
        }
 
        $userName = $row->user_name;
 
        $ulinks = Linker::userLink( $row->user_id, $userName );
        $ulinks .= Linker::userToolLinksRedContribs(
            $row->user_id,
            $userName,
            (int)$row->edits
        );
 
        $lang = $this->getLanguage();
 
        $groups = '';
        $ugms = self::getGroupMemberships( intval( $row->user_id ), $this->userGroupCache );
 
        if ( !$this->including && count( $ugms ) > 0 ) {
            $list = [];
            foreach ( $ugms as $ugm ) {
                $list[] = $this->buildGroupLink( $ugm, $userName );
            }
            $groups = $lang->commaList( $list );
        }
 
        $item = $lang->specialList( $ulinks, $groups );
 
        if ( $row->ipb_deleted ) {
            $item = "<span class=\"deleted\">$item</span>";
        }
 
        $edits = '';
        if ( !$this->including && $this->getConfig()->get( 'Edititis' ) ) {
            $count = $this->msg( 'usereditcount' )->numParams( $row->edits )->escaped();
            $edits = $this->msg( 'word-separator' )->escaped() . $this->msg( 'brackets', $count )->escaped();
        }
 
        $created = '';
        # Some rows may be null
        if ( !$this->including && $row->creation ) {
            $user = $this->getUser();
            $d = $lang->userDate( $row->creation, $user );
            $t = $lang->userTime( $row->creation, $user );
            $created = $this->msg( 'usercreated', $d, $t, $row->user_name )->escaped();
            $created = ' ' . $this->msg( 'parentheses' )->rawParams( $created )->escaped();
        }
        $blocked = !is_null( $row->ipb_deleted ) ?
            ' ' . $this->msg( 'listusers-blocked', $userName )->escaped() :
            '';
 
        Hooks::run( 'SpecialListusersFormatRow', [ &$item, $row ] );
 
        return Html::rawElement( 'li', [], "{$item}{$edits}{$created}{$blocked}" );
    }
 
    function doBatchLookups() {
        $batch = new LinkBatch();
        $userIds = [];
        # Give some pointers to make user links
        foreach ( $this->mResult as $row ) {
            $batch->add( NS_USER, $row->user_name );
            $batch->add( NS_USER_TALK, $row->user_name );
            $userIds[] = $row->user_id;
        }
 
        // Lookup groups for all the users
        $dbr = wfGetDB( DB_REPLICA );
        $groupRes = $dbr->select(
            'user_groups',
            UserGroupMembership::selectFields(),
            [ 'ug_user' => $userIds ],
            __METHOD__
        );
        $cache = [];
        $groups = [];
        foreach ( $groupRes as $row ) {
            $ugm = UserGroupMembership::newFromRow( $row );
            if ( !$ugm->isExpired() ) {
                $cache[$row->ug_user][$row->ug_group] = $ugm;
                $groups[$row->ug_group] = true;
            }
        }
 
        // Give extensions a chance to add things like global user group data
        // into the cache array to ensure proper output later on
        Hooks::run( 'UsersPagerDoBatchLookups', [ $dbr, $userIds, &$cache, &$groups ] );
 
        $this->userGroupCache = $cache;
 
        // Add page of groups to link batch
        foreach ( $groups as $group => $unused ) {
            $groupPage = UserGroupMembership::getGroupPage( $group );
            if ( $groupPage ) {
                $batch->addObj( $groupPage );
            }
        }
 
        $batch->execute();
        $this->mResult->rewind();
    }
 
    function getPageHeader() {
        list( $self ) = explode( '/', $this->getTitle()->getPrefixedDBkey() );
 
        $this->getOutput()->addModules( 'mediawiki.userSuggest' );
 
        # Form tag
        $out = Xml::openElement(
                'form',
                [ 'method' => 'get', 'action' => wfScript(), 'id' => 'mw-listusers-form' ]
            ) .
            Xml::fieldset( $this->msg( 'listusers' )->text() ) .
            Html::hidden( 'title', $self );
 
        # Username field (with autocompletion support)
        $out .= Xml::label( $this->msg( 'listusersfrom' )->text(), 'offset' ) . ' ' .
            Html::input(
                'username',
                $this->requestedUser,
                'text',
                [
                    'class' => 'mw-autocomplete-user',
                    'id' => 'offset',
                    'size' => 20,
                    'autofocus' => $this->requestedUser === ''
                ]
            ) . ' ';
 
        # Group drop-down list
        $sel = new XmlSelect( 'group', 'group', $this->requestedGroup );
        $sel->addOption( $this->msg( 'group-all' )->text(), '' );
        foreach ( $this->getAllGroups() as $group => $groupText ) {
            $sel->addOption( $groupText, $group );
        }
 
        $out .= Xml::label( $this->msg( 'group' )->text(), 'group' ) . ' ';
        $out .= $sel->getHTML() . '<br />';
        $out .= Xml::checkLabel(
            $this->msg( 'listusers-editsonly' )->text(),
            'editsOnly',
            'editsOnly',
            $this->editsOnly
        );
        $out .= '&#160;';
        $out .= Xml::checkLabel(
            $this->msg( 'listusers-creationsort' )->text(),
            'creationSort',
            'creationSort',
            $this->creationSort
        );
        $out .= '&#160;';
        $out .= Xml::checkLabel(
            $this->msg( 'listusers-desc' )->text(),
            'desc',
            'desc',
            $this->mDefaultDirection
        );
        $out .= '<br />';
 
        Hooks::run( 'SpecialListusersHeaderForm', [ $this, &$out ] );
 
        # Submit button and form bottom
        $out .= Html::hidden( 'limit', $this->mLimit );
        $out .= Xml::submitButton( $this->msg( 'listusers-submit' )->text() );
        Hooks::run( 'SpecialListusersHeader', [ $this, &$out ] );
        $out .= Xml::closeElement( 'fieldset' ) .
            Xml::closeElement( 'form' );
 
        return $out;
    }
 
    function getAllGroups() {
        $result = [];
        foreach ( User::getAllGroups() as $group ) {
            $result[$group] = UserGroupMembership::getGroupName( $group );
        }
        asort( $result );
 
        return $result;
    }
 
    function getDefaultQuery() {
        $query = parent::getDefaultQuery();
        if ( $this->requestedGroup != '' ) {
            $query['group'] = $this->requestedGroup;
        }
        if ( $this->requestedUser != '' ) {
            $query['username'] = $this->requestedUser;
        }
        Hooks::run( 'SpecialListusersDefaultQuery', [ $this, &$query ] );
 
        return $query;
    }
 
    protected static function getGroupMemberships( $uid, $cache = null ) {
        if ( $cache === null ) {
            $user = User::newFromId( $uid );
            return $user->getGroupMemberships();
        } else {
            return isset( $cache[$uid] ) ? $cache[$uid] : [];
        }
    }
 
    protected function buildGroupLink( $group, $username ) {
        return UserGroupMembership::getLink( $group, $this->getContext(), 'html', $username );
    }
}