TranslatePerLanguageStats.php

<?php
declare( strict_types = 1 );
 
namespace MediaWiki\Extension\Translate\Statistics;
 
use MediaWiki\MediaWikiServices;
use TranslateUtils;
 
class TranslatePerLanguageStats extends TranslationStatsBase {
    protected $seenUsers;
    protected $groups;
 
    public function __construct( TranslationStatsGraphOptions $opts ) {
        parent::__construct( $opts );
        // This query is slow. Set a lower limit, but allow seeing one year at once.
        $opts->boundValue( 'days', 1, 400 );
    }
 
    public function preQuery( &$tables, &$fields, &$conds, &$type, &$options, &$joins, $start, $end ) {
        global $wgTranslateMessageNamespaces;
 
        $db = wfGetDB( DB_REPLICA );
 
        $tables = [ 'recentchanges' ];
        $fields = [ 'rc_timestamp' ];
        $joins = [];
 
        $conds = [
            'rc_namespace' => $wgTranslateMessageNamespaces,
            'rc_bot' => 0,
            'rc_type != ' . RC_LOG,
        ];
 
        $timeConds = self::makeTimeCondition( 'rc_timestamp', $start, $end );
        $conds = array_merge( $conds, $timeConds );
 
        $options = [ 'ORDER BY' => 'rc_timestamp' ];
 
        $this->groups = array_map( 'MessageGroups::normalizeId', $this->opts->getGroups() );
 
        $namespaces = self::namespacesFromGroups( $this->groups );
        if ( count( $namespaces ) ) {
            $conds['rc_namespace'] = $namespaces;
        }
 
        $languages = [];
        foreach ( $this->opts->getLanguages() as $code ) {
            $languages[] = 'rc_title ' . $db->buildLike( $db->anyString(), "/$code" );
        }
        if ( count( $languages ) ) {
            $conds[] = $db->makeList( $languages, LIST_OR );
        }
 
        $fields[] = 'rc_title';
 
        if ( $this->groups ) {
            $fields[] = 'rc_namespace';
        }
 
        if ( $this->opts->getValue( 'count' ) === 'users' ) {
            $fields[] = 'rc_actor';
        }
 
        $type .= '-perlang';
    }
 
    public function indexOf( $row ) {
        if ( $this->opts->getValue( 'count' ) === 'users' ) {
            $date = $this->formatTimestamp( $row->rc_timestamp );
 
            if ( isset( $this->seenUsers[$date][$row->rc_actor] ) ) {
                return false;
            }
 
            $this->seenUsers[$date][$row->rc_actor] = true;
        }
 
        // Do not consider language-less pages.
        if ( strpos( $row->rc_title, '/' ) === false ) {
            return false;
        }
 
        // 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 ] = TranslateUtils::figureMessage( $row->rc_title );
 
        $groups = [];
        $codes = [];
 
        if ( $this->groups ) {
            /*
             * Get list of keys that the message belongs to, and filter
             * out those which are not requested.
             */
            $groups = TranslateUtils::messageKeyToGroups( $row->rc_namespace, $key );
            $groups = array_intersect( $this->groups, $groups );
        }
 
        if ( $this->opts->getLanguages() ) {
            $codes = [ $code ];
        }
 
        return $this->combineTwoArrays( $groups, $codes );
    }
 
    public function labels() {
        return $this->combineTwoArrays( $this->groups, $this->opts->getLanguages() );
    }
 
    public function getTimestamp( $row ) {
        return $row->rc_timestamp;
    }
 
    protected function makeLabel( $group, $code ) {
        if ( $group || $code ) {
            return "$group@$code";
        } else {
            return 'all';
        }
    }
 
    protected function combineTwoArrays( $groups, $codes ) {
        if ( !count( $groups ) ) {
            $groups[] = false;
        }
 
        if ( !count( $codes ) ) {
            $codes[] = false;
        }
 
        $items = [];
        foreach ( $groups as $group ) {
            foreach ( $codes as $code ) {
                $items[] = $this->makeLabel( $group, $code );
            }
        }
 
        return $items;
    }
 
    protected function formatTimestamp( $timestamp ) {
        switch ( $this->opts->getValue( 'scale' ) ) {
            case 'hours':
                $cut = 4;
                break;
            case 'days':
                $cut = 6;
                break;
            case 'months':
                $cut = 8;
                break;
            case 'years':
                $cut = 10;
                break;
            default:
                return MediaWikiServices::getInstance()->getContentLanguage()
                    ->sprintfDate( $this->getDateFormat(), $timestamp );
        }
 
        return substr( $timestamp, 0, -$cut );
    }
}