ReviewPerLanguageStats.php

<?php
declare( strict_types = 1 );
 
namespace MediaWiki\Extension\Translate\Statistics;
 
use MediaWiki\Extension\Translate\Utilities\Utilities;
use stdClass;
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\SelectQueryBuilder;
 
class ReviewPerLanguageStats extends TranslatePerLanguageStats {
    public function createQueryBuilder( IReadableDatabase $database, string $caller ): SelectQueryBuilder {
        global $wgTranslateMessageNamespaces;
 
        $fields = [ 'log_timestamp' ];
 
        $conds = [
            'log_namespace' => $wgTranslateMessageNamespaces,
            'log_action' => 'message',
        ];
 
        $this->groups = $this->opts->getGroups();
 
        $namespaces = self::namespacesFromGroups( $this->groups );
        if ( count( $namespaces ) ) {
            $conds['log_namespace'] = $namespaces;
        }
 
        $languages = [];
        foreach ( $this->opts->getLanguages() as $code ) {
            $languages[] = 'log_title ' . $database->buildLike( $database->anyString(), "/$code" );
        }
        if ( count( $languages ) ) {
            $conds[] = $database->makeList( $languages, LIST_OR );
        }
 
        $fields[] = 'log_title';
 
        if ( $this->groups ) {
            $fields[] = 'log_namespace';
        }
 
        if ( $this->opts->getValue( 'count' ) === 'reviewers' ) {
            $fields[] = 'log_actor';
        }
 
        return $database->newSelectQueryBuilder()
            ->table( 'logging' )
            ->fields( $fields )
            ->conds( $conds )
            ->options( [ 'ORDER BY' => 'log_timestamp' ] )
            ->caller( $caller . '-reviews' );
    }
 
    public function indexOf( stdClass $row ): ?array {
        if ( $this->opts->getValue( 'count' ) === 'reviewers' ) {
            $date = $this->formatTimestamp( $row->log_timestamp );
 
            if ( isset( $this->seenUsers[$date][$row->log_actor] ) ) {
                return null;
            }
 
            $this->seenUsers[$date][$row->log_actor] = 1;
        }
 
        // Do not consider language-less pages.
        if ( !str_contains( $row->log_title, '/' ) ) {
            return null;
        }
 
        // No filters, just one key to track.
        if ( !$this->groups && !$this->opts->getLanguages() ) {
            return [ 'all' ];
        }
 
        // The key-building needs to be in sync with ::labels().
        [ $key, $code ] = Utilities::figureMessage( $row->log_title );
 
        $groups = [];
        $codes = [];
 
        if ( $this->groups ) {
            /* Get list of keys that the message belongs to, and filter
             * out those which are not requested. */
            $groups = $this->messageIndex->getGroupIdsForDatabaseTitle( (int)$row->log_namespace, $key );
            $groups = array_intersect( $this->groups, $groups );
        }
 
        if ( $this->opts->getLanguages() ) {
            $codes = [ $code ];
        }
 
        return $this->combineTwoArrays( $groups, $codes );
    }
 
    public function labels(): array {
        return $this->combineTwoArrays( $this->groups, $this->opts->getLanguages() );
    }
 
    public function getTimestampColumn(): string {
        return 'log_timestamp';
    }
}