32 private ServiceOptions $options;
34 private LanguageNameUtils $langNameUtils;
35 private ILoadBalancer $loadBalancer;
37 private Language $contentLanguage;
40 private LinkBatchFactory $linkBatchFactory;
41 private LanguageFactory $languageFactory;
43 private int $period = 180;
45 public const CONSTRUCTOR_OPTIONS = [
46 'TranslateMessageNamespaces',
49 public function __construct(
52 LanguageNameUtils $langNameUtils,
53 ILoadBalancer $loadBalancer,
55 Language $contentLanguage,
57 LinkBatchFactory $linkBatchFactory,
58 LanguageFactory $languageFactory
60 parent::__construct(
'SupportedLanguages' );
61 $this->options =
new ServiceOptions( self::CONSTRUCTOR_OPTIONS, $config );
62 $this->translatorActivity = $translatorActivity;
63 $this->langNameUtils = $langNameUtils;
64 $this->loadBalancer = $loadBalancer;
65 $this->configHelper = $configHelper;
66 $this->contentLanguage = $contentLanguage;
67 $this->progressStatsTableFactory = $progressStatsTableFactory;
68 $this->linkBatchFactory = $linkBatchFactory;
69 $this->languageFactory = $languageFactory;
72 protected function getGroupName() {
76 public function getDescription() {
77 return $this->msg(
'supportedlanguages' );
80 public function execute( $par ):
void {
81 $out = $this->getOutput();
82 $lang = $this->getLanguage();
83 $this->progressStatsTable = $this->progressStatsTableFactory->newFromContext( $this->getContext() );
86 $out->addModuleStyles(
'ext.translate.specialpages.styles' );
89 'Help:Extension:Translate/Statistics_and_reporting#List_of_languages_and_translators'
92 $this->outputHeader(
'supportedlanguages-summary' );
93 $dbr = $this->loadBalancer->getConnection( DB_REPLICA );
94 $dbType = $dbr->getType();
95 if ( $dbType ===
'sqlite' || $dbType ===
'postgres' ) {
99 $out->msg(
'supportedlanguages-' . $dbType .
'-error' )->parse()
105 $out->addWikiMsg(
'supportedlanguages-localsummary' );
107 $names = $this->langNameUtils->getLanguageNames( LanguageNameUtils::AUTONYMS, LanguageNameUtils::ALL );
108 $languages = $this->languageCloud();
110 $languages = array_intersect_key( $languages, $names );
112 $this->outputLanguageCloud( $languages, $names );
113 $out->addWikiMsg(
'supportedlanguages-count', $lang->formatNum( count( $languages ) ) );
120 $language = strtolower( $par );
122 $data = $this->translatorActivity->inLanguage( $language );
125 $out->addHTML( Html::errorBox( $this->msg(
'generic-pool-error' )->parse() ) );
127 }
catch ( InvalidArgumentException $e ) {
128 $errorMessageHtml = $this->msg(
'translate-activelanguages-invalid-code' )
129 ->params( LanguageCode::bcp47( $language ) )
131 $out->addHTML( Html::errorBox( $errorMessageHtml ) );
135 $users = $data[
'users'];
136 $users = $this->filterUsers( $users, $language );
137 $this->preQueryUsers( $users );
138 $this->showLanguage( $language, $users, (
int)$data[
'asOfTime'] );
141 private function showLanguage(
string $code, array $users,
int $cachedAt ):
void {
142 $out = $this->getOutput();
143 $lang = $this->getLanguage();
147 $linkInfo[
'rc'][
'title'] = SpecialPage::getTitleFor(
'Recentchanges' );
148 $linkInfo[
'rc'][
'msg'] = $this->msg(
'supportedlanguages-recenttranslations' )->text();
149 $linkInfo[
'stats'][
'title'] = SpecialPage::getTitleFor(
'LanguageStats' );
150 $linkInfo[
'stats'][
'msg'] = $this->msg(
'languagestats' )->text();
152 $local = $this->langNameUtils->getLanguageName( $code, $lang->getCode() );
153 $native = $this->langNameUtils->getLanguageName( $code );
154 $statLanguage = $this->languageFactory->getLanguage( $code );
155 $bcp47Code = $statLanguage->getHtmlCode();
157 $span = Html::rawElement(
'span', [
'lang' => $bcp47Code,
'dir' => $statLanguage->getDir() ], $native );
159 if ( $local !== $native ) {
161 $headerText = $this->msg(
'supportedlanguages-portallink' )
162 ->params( $bcp47Code, $local, $span )->parse();
165 $headerText = $this->msg(
'supportedlanguages-portallink-nocldr' )
166 ->params( $bcp47Code, $span )->parse();
169 $out->addHTML( Html::rawElement(
'h2', [
'id' => $code ], $headerText ) );
173 $links[] = $this->getLinkRenderer()->makeKnownLink(
174 $linkInfo[
'stats'][
'title'],
175 $linkInfo[
'stats'][
'msg'],
179 'suppresscomplete' =>
'1'
182 $links[] = $this->getLinkRenderer()->makeKnownLink(
183 $linkInfo[
'rc'][
'title'],
184 $linkInfo[
'rc'][
'msg'],
187 'translations' =>
'only',
188 'trailer' =>
'/' . $code
191 $linkList = $lang->listToText( $links );
193 $out->addHTML(
'<p>' . $linkList .
"</p>\n" );
194 $this->makeUserList( $users );
196 $ageString = $this->getLanguage()->formatTimePeriod(
198 [
'noabbrevs' =>
true,
'avoid' =>
'avoidseconds' ]
200 $out->addWikiMsg(
'supportedlanguages-colorlegend', $this->getColorLegend() );
201 $out->addWikiMsg(
'translate-supportedlanguages-cached', $ageString );
204 private function languageCloud(): array {
206 $cache = ObjectCache::getInstance( CACHE_ANYTHING );
207 $cachekey = $cache->makeKey(
'translate-supportedlanguages-language-cloud',
'v2' );
209 $data = $cache->get( $cachekey );
210 if ( is_array( $data ) ) {
214 $dbr = $this->loadBalancer->getConnection( DB_REPLICA );
215 $timestamp = $dbr->timestamp( (
int)wfTimestamp() - 60 * 60 * 24 * $this->period );
217 $res = $dbr->newSelectQueryBuilder()
218 ->select( [
'lang' =>
'substring_index(rc_title, \'/\', -1)',
'count' =>
'COUNT(*)' ] )
219 ->from(
'recentchanges' )
221 'rc_timestamp > ' . $dbr->addQuotes( $timestamp ),
222 'rc_namespace' => $this->options->get(
'TranslateMessageNamespaces' ),
223 'rc_title' . $dbr->buildLike( $dbr->anyString(),
'/', $dbr->anyString() ),
226 ->having(
'count > 20' )
228 ->caller( __METHOD__ )
232 foreach ( $res as $row ) {
233 $data[$row->lang] = (int)$row->count;
236 $cache->set( $cachekey, $data, 3600 );
241 protected function filterUsers( array $users,
string $code ): array {
242 foreach ( $users as $index => $user ) {
243 $username = $user[TranslatorActivityQuery::USER_NAME];
245 if ( $this->configHelper->isAuthorExcluded(
'#', $code, $username ) ) {
246 unset( $users[$index] );
253 protected function outputLanguageCloud( array $languages, array $names ) {
254 global $wgTranslateDocumentationLanguageCode;
256 $out = $this->getOutput();
258 $out->addHTML(
'<div class="tagcloud autonym">' );
260 foreach ( $languages as $k => $v ) {
263 $size = round( log( $v ) * 20 ) + 10;
265 if ( $langAttribute === $wgTranslateDocumentationLanguageCode ) {
266 $langAttribute = $this->contentLanguage->getHtmlCode();
270 'href' => $this->getPageTitle( $k )->getLocalURL(),
272 'style' =>
"font-size:$size%",
273 'lang' => $langAttribute,
276 $tag = Html::element(
'a', $params, $name );
277 $out->addHTML( $tag .
"\n" );
279 $out->addHTML(
'</div>' );
282 private function makeUserList( array $userStats ):
void {
287 $period = $this->period;
291 usort( $userStats,
static function ( $a, $b ) {
293 $a[TranslatorActivityQuery::USER_TRANSLATIONS]
295 $b[TranslatorActivityQuery::USER_TRANSLATIONS]
299 foreach ( $userStats as $stats ) {
300 $username = $stats[TranslatorActivityQuery::USER_NAME];
301 $title = Title::makeTitleSafe( NS_USER, $username );
303 LoggerFactory::getInstance(
'Translate' )->warning(
304 "T248125: Got Title-invalid username '{username}'",
305 [
'username' => $username ]
310 $count = $stats[TranslatorActivityQuery::USER_TRANSLATIONS];
311 $lastTranslationTimestamp = $stats[TranslatorActivityQuery::USER_LAST_ACTIVITY];
313 $enc = htmlspecialchars( $username );
317 $styles[
'font-size'] = round( log( $count, 10 ) * 30 ) + 70 .
'%';
319 $last = (int)wfTimestamp() - (int)wfTimestamp( TS_UNIX, $lastTranslationTimestamp );
320 $last = round( $last / $day );
322 $this->msg(
'supportedlanguages-activity', $username )
323 ->numParams( $count, $last )
325 $last = max( 1, min( $period, $last ) );
326 $styles[
'border-bottom'] =
327 '3px solid #' . $this->progressStatsTable->getBackgroundColor( ( $period - $last ) / $period );
329 $stylestr = $this->formatStyle( $styles );
331 $attribs[
'style'] = $stylestr;
335 $this->getLinkRenderer()->makeLink( $title,
new HtmlArmor( $enc ), $attribs );
339 $usernameForGender =
'';
340 if ( count( $userStats ) === 1 ) {
341 $usernameForGender = $userStats[0][TranslatorActivityQuery::USER_NAME];
344 $linkList = $this->getLanguage()->listToText( $links );
345 $html =
"<p class='mw-translate-spsl-translators'>";
346 $html .= $this->msg(
'supportedlanguages-translators' )
347 ->rawParams( $linkList )
348 ->numParams( count( $links ) )
349 ->params( $usernameForGender )
352 $this->getOutput()->addHTML( $html );
355 protected function formatStyle( $styles ) {
357 foreach ( $styles as $key => $value ) {
358 $stylestr .=
"$key:$value;";
364 protected function preQueryUsers( array $users ):
void {
365 $lb = $this->linkBatchFactory->newLinkBatch();
366 foreach ( $users as $data ) {
367 $username = $data[TranslatorActivityQuery::USER_NAME];
368 $user = Title::capitalize( $username, NS_USER );
369 $lb->add( NS_USER, $user );
370 $lb->add( NS_USER_TALK, $user );
375 protected function getColorLegend() {
377 $period = $this->period;
379 for ( $i = 0; $i <= $period; $i += 30 ) {
380 $iFormatted = htmlspecialchars( $this->getLanguage()->formatNum( $i ) );
381 $legend .=
'<span style="background-color:#' .
382 $this->progressStatsTable->getBackgroundColor( ( $period - $i ) / $period ) .
383 "\"> $iFormatted</span>";