SpecialUnusedCategories.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Cache\LinkBatchFactory;
use MediaWiki\Skin\Skin;
use MediaWiki\SpecialPage\QueryPage;
use MediaWiki\Title\Title;
use stdClass;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialUnusedCategories extends QueryPage {
 
    public function __construct(
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory
    ) {
        parent::__construct( 'Unusedcategories' );
        $this->setDatabaseProvider( $dbProvider );
        $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', 'linktarget', 'categorylinks', 'page_props' ],
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
            ],
            'conds' => [
                'cl_from' => null,
                'page_namespace' => NS_CATEGORY,
                'page_is_redirect' => 0,
                'pp_page' => null,
            ],
            'join_conds' => [
                'linktarget' => [ 'LEFT JOIN', [
                    'lt_title = page_title',
                    'lt_namespace = page_namespace',
                ] ],
                'categorylinks' => [ 'LEFT JOIN', 'cl_target_id = lt_id' ],
                '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 );
    }
}
 
class_alias( SpecialUnusedCategories::class, 'SpecialUnusedCategories' );