SpecialWantedCategories.php

Go to the documentation of this file.

<?php
class SpecialWantedCategories extends WantedQueryPage {
    private $currentCategoryCounts;
 
    public function __construct( $name = 'Wantedcategories' ) {
        parent::__construct( $name );
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'categorylinks', 'page' ],
            'fields' => [
                'namespace' => NS_CATEGORY,
                'title' => 'cl_to',
                'value' => 'COUNT(*)'
            ],
            'conds' => [ 'page_title IS NULL' ],
            'options' => [ 'GROUP BY' => 'cl_to' ],
            'join_conds' => [ 'page' => [ 'LEFT JOIN',
                [ 'page_title = cl_to',
                    'page_namespace' => NS_CATEGORY ] ] ]
        ];
    }
 
    public function preprocessResults( $db, $res ) {
        parent::preprocessResults( $db, $res );
 
        $this->currentCategoryCounts = [];
 
        if ( !$res->numRows() || !$this->isCached() ) {
            return;
        }
 
        // Fetch (hopefully) up-to-date numbers of pages in each category.
        // This should be fast enough as we limit the list to a reasonable length.
 
        $allCategories = [];
        foreach ( $res as $row ) {
            $allCategories[] = $row->title;
        }
 
        $categoryRes = $db->select(
            'category',
            [ 'cat_title', 'cat_pages' ],
            [ 'cat_title' => $allCategories ],
            __METHOD__
        );
        foreach ( $categoryRes as $row ) {
            $this->currentCategoryCounts[$row->cat_title] = intval( $row->cat_pages );
        }
 
        // Back to start for display
        $res->seek( 0 );
    }
 
    public function formatResult( $skin, $result ) {
        $nt = Title::makeTitle( $result->namespace, $result->title );
 
        $text = new HtmlArmor( $this->getLanguageConverter()->convertHtml( $nt->getText() ) );
 
        if ( !$this->isCached() ) {
            // We can assume the freshest data
            $plink = $this->getLinkRenderer()->makeBrokenLink(
                $nt,
                $text
            );
            $nlinks = $this->msg( 'nmembers' )->numParams( $result->value )->escaped();
        } else {
            $plink = $this->getLinkRenderer()->makeLink( $nt, $text );
 
            $currentValue = $this->currentCategoryCounts[$result->title] ?? 0;
            $cachedValue = intval( $result->value ); // T76910
 
            // If the category has been created or emptied since the list was refreshed, strike it
            if ( $nt->isKnown() || $currentValue === 0 ) {
                $plink = "<del>$plink</del>";
            }
 
            // Show the current number of category entries if it changed
            if ( $currentValue !== $cachedValue ) {
                $nlinks = $this->msg( 'nmemberschanged' )
                    ->numParams( $cachedValue, $currentValue )->escaped();
            } else {
                $nlinks = $this->msg( 'nmembers' )->numParams( $cachedValue )->escaped();
            }
        }
 
        return $this->getLanguage()->specialList( $plink, $nlinks );
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}