1 files changed, 115 insertions, 0 deletions
diff --git a/MLEB/Translate/src/Statistics/ReviewPerLanguageStats.php b/MLEB/Translate/src/Statistics/ReviewPerLanguageStats.php
new file mode 100644
index 00000000..7b3a2862
--- /dev/null
+++ b/MLEB/Translate/src/Statistics/ReviewPerLanguageStats.php
@@ -0,0 +1,115 @@
+<?php
+declare( strict_types = 1 );
+
+namespace MediaWiki\Extension\Translate\Statistics;
+
+use TranslateUtils;
+
+/**
+ * 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 preQuery( &$tables, &$fields, &$conds, &$type, &$options, &$joins, $start, $end ) {
+		global $wgTranslateMessageNamespaces;
+
+		$db = wfGetDB( DB_REPLICA );
+
+		$tables = [ 'logging' ];
+		$fields = [ 'log_timestamp' ];
+		$joins = [];
+
+		$conds = [
+			'log_namespace' => $wgTranslateMessageNamespaces,
+			'log_action' => 'message',
+		];
+
+		$timeConds = self::makeTimeCondition( 'log_timestamp', $start, $end );
+		$conds = array_merge( $conds, $timeConds );
+
+		$options = [ 'ORDER BY' => 'log_timestamp' ];
+
+		$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 ' . $db->buildLike( $db->anyString(), "/$code" );
+		}
+		if ( count( $languages ) ) {
+			$conds[] = $db->makeList( $languages, LIST_OR );
+		}
+
+		$fields[] = 'log_title';
+
+		if ( $this->groups ) {
+			$fields[] = 'log_namespace';
+		}
+
+		if ( $this->opts->getValue( 'count' ) === 'reviewers' ) {
+			$tables[] = 'actor';
+			$joins['actor'] = [ 'JOIN', 'actor_id=log_actor' ];
+			$fields['log_user_text'] = 'actor_name';
+		}
+
+		$type .= '-reviews';
+	}
+
+	public function indexOf( $row ) {
+		// We need to check that there is only one user per day.
+		if ( $this->opts->getValue( 'count' ) === 'reviewers' ) {
+			$date = $this->formatTimestamp( $row->log_timestamp );
+
+			if ( isset( $this->usercache[$date][$row->log_user_text] ) ) {
+				return false;
+			} else {
+				$this->usercache[$date][$row->log_user_text] = 1;
+			}
+		}
+
+		// Do not consider language-less pages.
+		if ( strpos( $row->log_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().
+		list( $key, $code ) = TranslateUtils::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 = TranslateUtils::messageKeyToGroups( $row->log_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->log_timestamp;
+	}
+}
+
+class_alias( ReviewPerLanguageStats::class, '\MediaWiki\Extensions\Translate\ReviewPerLanguageStats' );