Translate extension for MediaWiki
Loading...
Searching...
No Matches
TranslatorActivityQuery.php
1<?php
2declare( strict_types = 1 );
3
4namespace MediaWiki\Extension\Translate\Statistics;
5
6use MediaWiki\Config\Config;
7use Wikimedia\Rdbms\IConnectionProvider;
8
17 public const USER_NAME = 0;
18 public const USER_TRANSLATIONS = 1;
19 public const USER_LAST_ACTIVITY = 2;
20
21 public function __construct(
22 private readonly Config $options,
23 private readonly IConnectionProvider $dbProvider,
24 ) {
25 }
26
33 public function inLanguage( string $code ): array {
34 $dbr = $this->dbProvider->getReplicaDatabase( false, 'vslow' );
35
36 $res = $dbr->newSelectQueryBuilder()
37 ->select( [
38 'rev_user_text' => 'actor_rev_user.actor_name',
39 'lastedit' => 'MAX(rev_timestamp)',
40 'count' => 'COUNT(page_id)',
41 ] )
42 ->from( 'page' )
43 ->join( 'revision', null, 'page_id=rev_page' )
44 ->join( 'actor', 'actor_rev_user', 'actor_rev_user.actor_id = rev_actor' )
45 ->where( [
46 'page_title' . $dbr->buildLike( $dbr->anyString(), '/', $code ),
47 'page_namespace' => $this->options->get( 'TranslateMessageNamespaces' ),
48 ] )
49 ->groupBy( 'actor_rev_user.actor_name' )
50 ->orderBy( 'NULL' )
51 ->caller( __METHOD__ )
52 ->fetchResultSet();
53
54 $data = [];
55 foreach ( $res as $row ) {
56 // Warning: user names may be numbers that get cast to ints in array keys
57 $data[] = [
58 self::USER_NAME => $row->rev_user_text,
59 self::USER_TRANSLATIONS => (int)$row->count,
60 self::USER_LAST_ACTIVITY => $row->lastedit,
61 ];
62 }
63
64 return $data;
65 }
66
75 public function inAllLanguages(): array {
76 $dbr = $this->dbProvider->getReplicaDatabase( false, 'vslow' );
77
78 $res = $dbr->newSelectQueryBuilder()
79 ->select( [
80 'rev_user_text' => 'actor_rev_user.actor_name',
81 'lang' => 'substring_index(page_title, \'/\', -1)',
82 'lastedit' => 'MAX(rev_timestamp)',
83 'count' => 'COUNT(page_id)',
84 ] )
85 ->from( 'page' )
86 ->join( 'revision', null, 'page_id=rev_page' )
87 ->join( 'actor', 'actor_rev_user', 'actor_rev_user.actor_id = rev_actor' )
88 ->where( [
89 'page_title' . $dbr->buildLike( $dbr->anyString(), '/', $dbr->anyString() ),
90 'page_namespace' => $this->options->get( 'TranslateMessageNamespaces' ),
91 ] )
92 ->groupBy( [ 'lang', 'actor_rev_user.actor_name' ] )
93 ->orderBy( 'NULL' )
94 ->caller( __METHOD__ )
95 ->fetchResultSet();
96
97 $data = [];
98 foreach ( $res as $row ) {
99 // Warning: user names may be numbers that get cast to ints in array keys
100 $data[$row->lang][] = [
101 self::USER_NAME => $row->rev_user_text,
102 self::USER_TRANSLATIONS => (int)$row->count,
103 self::USER_LAST_ACTIVITY => $row->lastedit,
104 ];
105 }
106
107 return $data;
108 }
109}
inLanguage(string $code)
Fetch the translators for a language.