Page MenuHomeWickedGov Phorge
Files F5981108

ReviewPerLanguageStats.php
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

ReviewPerLanguageStats.php
View Options

<?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;
/**
* Graph which provides statistics on number of reviews and reviewers.
* @ingroup Stats
* @license GPL-2.0-or-later
* @since 2012.03
*/
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';
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, Oct 3, 21:43 (1 w, 2 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
22/1c/cdb8c60c6d6ba7209a492241ba92
Default Alt Text
ReviewPerLanguageStats.php (2 KB)

Event Timeline