34 private $translatorActivity;
36 private $langNameUtils;
38 private $loadBalancer;
40 private $configHelper;
42 private $contentLanguage;
44 private $progressStatsTableFactory;
46 private $progressStatsTable;
48 private $linkBatchFactory;
50 private $period = 180;
52 public const CONSTRUCTOR_OPTIONS = [
53 'TranslateMessageNamespaces',
56 public function __construct(
59 LanguageNameUtils $langNameUtils,
60 ILoadBalancer $loadBalancer,
62 Language $contentLanguage,
64 LinkBatchFactory $linkBatchFactory
66 parent::__construct(
'SupportedLanguages' );
67 $this->options =
new ServiceOptions( self::CONSTRUCTOR_OPTIONS, $config );
68 $this->translatorActivity = $translatorActivity;
69 $this->langNameUtils = $langNameUtils;
70 $this->loadBalancer = $loadBalancer;
71 $this->configHelper = $configHelper;
72 $this->contentLanguage = $contentLanguage;
73 $this->progressStatsTableFactory = $progressStatsTableFactory;
74 $this->linkBatchFactory = $linkBatchFactory;
77 protected function getGroupName() {
81 public function getDescription() {
82 return $this->msg(
'supportedlanguages' )->text();
85 public function execute( $par ) {
86 $out = $this->getOutput();
87 $lang = $this->getLanguage();
88 $this->progressStatsTable = $this->progressStatsTableFactory->newFromContext( $this->getContext() );
91 $out->addModuleStyles(
'ext.translate.specialpages.styles' );
94 'Help:Extension:Translate/Statistics_and_reporting#List_of_languages_and_translators'
97 $this->outputHeader(
'supportedlanguages-summary' );
98 $dbr = $this->loadBalancer->getConnectionRef( DB_REPLICA );
99 $dbType = $dbr->getType();
100 if ( $dbType ===
'sqlite' || $dbType ===
'postgres' ) {
104 $out->msg(
'supportedlanguages-' . $dbType .
'-error' )->parse()
110 $out->addWikiMsg(
'supportedlanguages-localsummary' );
112 $names = $this->langNameUtils->getLanguageNames( LanguageNameUtils::AUTONYMS, LanguageNameUtils::ALL );
113 $languages = $this->languageCloud();
115 $languages = array_intersect_key( $languages, $names );
117 $this->outputLanguageCloud( $languages, $names );
118 $out->addWikiMsg(
'supportedlanguages-count', $lang->formatNum( count( $languages ) ) );
125 $language = strtolower( $par );
127 $data = $this->translatorActivity->inLanguage( $language );
130 $out->addHTML( Html::errorBox( $this->msg(
'generic-pool-error' )->parse() ) );
132 }
catch ( InvalidArgumentException $e ) {
133 $errorMessageHtml = $this->msg(
'translate-activelanguages-invalid-code' )
134 ->params( LanguageCode::bcp47( $language ) )
136 $out->addHTML( Html::errorBox( $errorMessageHtml ) );
140 $users = $data[
'users'];
141 $users = $this->filterUsers( $users, $language );
142 $this->preQueryUsers( $users );
143 $this->showLanguage( $language, $users, (
int)$data[
'asOfTime'] );
146 private function showLanguage(
string $code, array $users,
int $cachedAt ):
void {
147 $out = $this->getOutput();
148 $lang = $this->getLanguage();
149 $bcp47Code = LanguageCode::bcp47( $code );
153 $linkInfo[
'rc'][
'title'] = SpecialPage::getTitleFor(
'Recentchanges' );
154 $linkInfo[
'rc'][
'msg'] = $this->msg(
'supportedlanguages-recenttranslations' )->text();
155 $linkInfo[
'stats'][
'title'] = SpecialPage::getTitleFor(
'LanguageStats' );
156 $linkInfo[
'stats'][
'msg'] = $this->msg(
'languagestats' )->text();
158 $local = $this->langNameUtils->getLanguageName( $code, $lang->getCode(), LanguageNameUtils::ALL );
159 $native = $this->langNameUtils->getLanguageName( $code, LanguageNameUtils::AUTONYMS, LanguageNameUtils::ALL );
161 if ( $local !== $native ) {
163 $headerText = $this->msg(
'supportedlanguages-portallink' )
164 ->params( $bcp47Code, $local, $native )->escaped();
167 $headerText = $this->msg(
'supportedlanguages-portallink-nocldr' )
168 ->params( $bcp47Code, $native )->escaped();
171 $out->addHTML( Html::rawElement(
'h2', [
'id' => $code ], $headerText ) );
175 $links[] = $this->getLinkRenderer()->makeKnownLink(
176 $linkInfo[
'stats'][
'title'],
177 $linkInfo[
'stats'][
'msg'],
181 'suppresscomplete' =>
'1'
184 $links[] = $this->getLinkRenderer()->makeKnownLink(
185 $linkInfo[
'rc'][
'title'],
186 $linkInfo[
'rc'][
'msg'],
189 'translations' =>
'only',
190 'trailer' =>
'/' . $code
193 $linkList = $lang->listToText( $links );
195 $out->addHTML(
'<p>' . $linkList .
"</p>\n" );
196 $this->makeUserList( $users );
198 $ageString = $this->getLanguage()->formatTimePeriod(
200 [
'noabbrevs' =>
true,
'avoid' =>
'avoidseconds' ]
202 $out->addWikiMsg(
'supportedlanguages-colorlegend', $this->getColorLegend() );
203 $out->addWikiMsg(
'translate-supportedlanguages-cached', $ageString );
206 private function languageCloud(): array {
208 $cache = ObjectCache::getInstance( CACHE_ANYTHING );
209 $cachekey = $cache->makeKey(
'translate-supportedlanguages-language-cloud',
'v2' );
211 $data = $cache->get( $cachekey );
212 if ( is_array( $data ) ) {
216 $dbr = $this->loadBalancer->getConnectionRef( DB_REPLICA );
217 $tables = [
'recentchanges' ];
218 $fields = [
'substring_index(rc_title, \'/\', -1) as lang',
'count(*) as count' ];
219 $timestamp = $dbr->timestamp( wfTimestamp( TS_UNIX ) - 60 * 60 * 24 * $this->period );
221 'rc_timestamp > ' . $dbr->addQuotes( $timestamp ),
222 'rc_namespace' => $this->options->get(
'TranslateMessageNamespaces' ),
223 'rc_title' . $dbr->buildLike( $dbr->anyString(),
'/', $dbr->anyString() ),
225 $options = [
'GROUP BY' =>
'lang',
'HAVING' =>
'count > 20',
'ORDER BY' =>
'NULL' ];
227 $res = $dbr->select( $tables, $fields, $conds, __METHOD__, $options );
230 foreach ( $res as $row ) {
231 $data[$row->lang] = (int)$row->count;
234 $cache->set( $cachekey, $data, 3600 );
239 protected function filterUsers( array $users,
string $code ): array {
240 foreach ( $users as $index => $user ) {
241 $username = $user[TranslatorActivityQuery::USER_NAME];
243 if ( $this->configHelper->isAuthorExcluded(
'#', $code, $username ) ) {
244 unset( $users[$index] );
251 protected function outputLanguageCloud( array $languages, array $names ) {
252 global $wgTranslateDocumentationLanguageCode;
254 $out = $this->getOutput();
256 $out->addHTML(
'<div class="tagcloud autonym">' );
258 foreach ( $languages as $k => $v ) {
261 $size = round( log( $v ) * 20 ) + 10;
263 if ( $langAttribute === $wgTranslateDocumentationLanguageCode ) {
264 $langAttribute = $this->contentLanguage->getHtmlCode();
268 'href' => $this->getPageTitle( $k )->getLocalURL(),
270 'style' =>
"font-size:$size%",
271 'lang' => $langAttribute,
274 $tag = Html::element(
'a', $params, $name );
275 $out->addHTML( $tag .
"\n" );
277 $out->addHTML(
'</div>' );
280 private function makeUserList( array $userStats ):
void {
285 $period = $this->period;
289 usort( $userStats,
static function ( $a, $b ) {
291 $a[TranslatorActivityQuery::USER_TRANSLATIONS]
293 $b[TranslatorActivityQuery::USER_TRANSLATIONS]
297 foreach ( $userStats as $stats ) {
298 $username = $stats[TranslatorActivityQuery::USER_NAME];
299 $title = Title::makeTitleSafe( NS_USER, $username );
301 LoggerFactory::getInstance(
'Translate' )->warning(
302 "T248125: Got Title-invalid username '{username}'",
303 [
'username' => $username ]
308 $count = $stats[TranslatorActivityQuery::USER_TRANSLATIONS];
309 $lastTranslationTimestamp = $stats[TranslatorActivityQuery::USER_LAST_ACTIVITY];
311 $enc = htmlspecialchars( $username );
315 $styles[
'font-size'] = round( log( $count, 10 ) * 30 ) + 70 .
'%';
317 $last = wfTimestamp( TS_UNIX ) - wfTimestamp( TS_UNIX, $lastTranslationTimestamp );
318 $last = round( $last / $day );
320 $this->msg(
'supportedlanguages-activity', $username )
321 ->numParams( $count, $last )
323 $last = max( 1, min( $period, $last ) );
324 $styles[
'border-bottom'] =
325 '3px solid #' . $this->progressStatsTable->getBackgroundColor( ( $period - $last ) / $period );
327 $stylestr = $this->formatStyle( $styles );
329 $attribs[
'style'] = $stylestr;
333 $this->getLinkRenderer()->makeLink( $title,
new HtmlArmor( $enc ), $attribs );
337 $usernameForGender =
'';
338 if ( count( $userStats ) === 1 ) {
339 $usernameForGender = $userStats[0][TranslatorActivityQuery::USER_NAME];
342 $linkList = $this->getLanguage()->listToText( $links );
343 $html =
"<p class='mw-translate-spsl-translators'>";
344 $html .= $this->msg(
'supportedlanguages-translators' )
345 ->rawParams( $linkList )
346 ->numParams( count( $links ) )
347 ->params( $usernameForGender )
350 $this->getOutput()->addHTML( $html );
353 protected function formatStyle( $styles ) {
355 foreach ( $styles as $key => $value ) {
356 $stylestr .=
"$key:$value;";
362 protected function preQueryUsers( array $users ):
void {
363 $lb = $this->linkBatchFactory->newLinkBatch();
364 foreach ( $users as $data ) {
365 $username = $data[TranslatorActivityQuery::USER_NAME];
366 $user = Title::capitalize( $username, NS_USER );
367 $lb->add( NS_USER, $user );
368 $lb->add( NS_USER_TALK, $user );
373 protected function getColorLegend() {
375 $period = $this->period;
377 for ( $i = 0; $i <= $period; $i += 30 ) {
378 $iFormatted = htmlspecialchars( $this->getLanguage()->formatNum( $i ) );
379 $legend .=
'<span style="background-color:#' .
380 $this->progressStatsTable->getBackgroundColor( ( $period - $i ) / $period ) .
381 "\"> $iFormatted</span>";