SpecialUnusedCategories.php

Go to the documentation of this file.

<?php
use MediaWiki\Cache\LinkBatchFactory;
use Wikimedia\Rdbms\ILoadBalancer;
 
class SpecialUnusedCategories extends QueryPage {
 
    public function __construct(
        ILoadBalancer $loadBalancer,
        LinkBatchFactory $linkBatchFactory
    ) {
        parent::__construct( 'Unusedcategories' );
        $this->setDBLoadBalancer( $loadBalancer );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    public function isExpensive() {
        return true;
    }
 
    protected function getPageHeader() {
        return $this->msg( 'unusedcategoriestext' )->parseAsBlock();
    }
 
    protected function getOrderFields() {
        return [ 'title' ];
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'page', 'categorylinks', 'page_props' ],
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
            ],
            'conds' => [
                'cl_from IS NULL',
                'page_namespace' => NS_CATEGORY,
                'page_is_redirect' => 0,
                'pp_page IS NULL'
            ],
            'join_conds' => [
                'categorylinks' => [ 'LEFT JOIN', 'cl_to = page_title' ],
                'page_props' => [ 'LEFT JOIN', [
                    'page_id = pp_page',
                    'pp_propname' => 'expectunusedcategory'
                ] ]
            ]
        ];
    }
 
    protected function sortDescending() {
        return false;
    }
 
    public function formatResult( $skin, $result ) {
        $title = Title::makeTitle( NS_CATEGORY, $result->title );
 
        return $this->getLinkRenderer()->makeLink( $title, $title->getText() );
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
 
    public function preprocessResults( $db, $res ) {
        $this->executeLBFromResultWrapper( $res );
    }
}