TranslatorActivityQuery.php

<?php
declare( strict_types = 1 );
 
namespace MediaWiki\Extension\Translate\Statistics;
 
use Config;
use MediaWiki\User\ActorMigration;
use Wikimedia\Rdbms\ILoadBalancer;
 
class TranslatorActivityQuery {
    public const USER_NAME = 0;
    public const USER_TRANSLATIONS = 1;
    public const USER_LAST_ACTIVITY = 2;
    private Config $options;
    private ILoadBalancer $loadBalancer;
 
    public function __construct( Config $options, ILoadBalancer $loadBalancer ) {
        $this->options = $options;
        $this->loadBalancer = $loadBalancer;
    }
 
    public function inLanguage( string $code ): array {
        $dbr = $this->loadBalancer->getConnection( DB_REPLICA, 'vslow' );
 
        $actorQuery = ActorMigration::newMigration()->getJoin( 'rev_user' );
 
        $res = $dbr->newSelectQueryBuilder()
            ->select( [
                'rev_user_text' => $actorQuery['fields']['rev_user_text'],
                'lastedit' => 'MAX(rev_timestamp)',
                'count' => 'COUNT(page_id)',
            ] )
            ->from( 'page' )
            ->join( 'revision', null, 'page_id=rev_page' )
            ->tables( $actorQuery['tables'] )
            ->where( [
                'page_title' . $dbr->buildLike( $dbr->anyString(), '/', $code ),
                'page_namespace' => $this->options->get( 'TranslateMessageNamespaces' ),
            ] )
            ->groupBy( $actorQuery['fields']['rev_user_text'] )
            ->orderBy( 'NULL' )
            ->joinConds( $actorQuery['joins'] )
            ->caller( __METHOD__ )
            ->fetchResultSet();
 
        $data = [];
        foreach ( $res as $row ) {
            // Warning: user names may be numbers that get cast to ints in array keys
            $data[] = [
                self::USER_NAME => $row->rev_user_text,
                self::USER_TRANSLATIONS => (int)$row->count,
                self::USER_LAST_ACTIVITY => $row->lastedit,
            ];
        }
 
        return $data;
    }
 
    public function inAllLanguages(): array {
        $dbr = $this->loadBalancer->getConnection( DB_REPLICA, 'vslow' );
 
        $actorQuery = ActorMigration::newMigration()->getJoin( 'rev_user' );
 
        $res = $dbr->newSelectQueryBuilder()
            ->select( [
                'rev_user_text' => $actorQuery['fields']['rev_user_text'],
                'lang' => 'substring_index(page_title, \'/\', -1)',
                'lastedit' => 'MAX(rev_timestamp)',
                'count' => 'COUNT(page_id)',
            ] )
            ->from( 'page' )
            ->join( 'revision', null, 'page_id=rev_page' )
            ->tables( $actorQuery['tables'] )
            ->where( [
                'page_title' . $dbr->buildLike( $dbr->anyString(), '/', $dbr->anyString() ),
                'page_namespace' => $this->options->get( 'TranslateMessageNamespaces' ),
            ] )
            ->groupBy( [ 'lang', $actorQuery['fields']['rev_user_text'] ] )
            ->orderBy( 'NULL' )
            ->joinConds( $actorQuery['joins'] )
            ->caller( __METHOD__ )
            ->fetchResultSet();
 
        $data = [];
        foreach ( $res as $row ) {
            // Warning: user names may be numbers that get cast to ints in array keys
            $data[$row->lang][] = [
                self::USER_NAME => $row->rev_user_text,
                self::USER_TRANSLATIONS => (int)$row->count,
                self::USER_LAST_ACTIVITY => $row->lastedit,
            ];
        }
 
        return $data;
    }
}