includes/specials/SpecialWantedcategories.php

   1 <?php
   2 /**
   3  * Implements Special:Wantedcategories
   4  *
   5  * Copyright © 2005 Ævar Arnfjörð Bjarmason
   6  *
   7  * This program is free software; you can redistribute it and/or modify
   8  * it under the terms of the GNU General Public License as published by
   9  * the Free Software Foundation; either version 2 of the License, or
  10  * (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15  * GNU General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU General Public License along
  18  * with this program; if not, write to the Free Software Foundation, Inc.,
  19  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  20  * http://www.gnu.org/copyleft/gpl.html
  21  *
  22  * @file
  23  * @ingroup SpecialPage
  24  */
  25
  26 /**
  27  * A querypage to list the most wanted categories - implements Special:Wantedcategories
  28  *
  29  * @ingroup SpecialPage
  30  */
  31 class WantedCategoriesPage extends WantedQueryPage {
  32         private $currentCategoryCounts;
  33
  34         function __construct( $name = 'Wantedcategories' ) {
  35                 parent::__construct( $name );
  36         }
  37
  38         function getQueryInfo() {
  39                 return [
  40                         'tables' => [ 'categorylinks', 'page' ],
  41                         'fields' => [
  42                                 'namespace' => NS_CATEGORY,
  43                                 'title' => 'cl_to',
  44                                 'value' => 'COUNT(*)'
  45                         ],
  46                         'conds' => [ 'page_title IS NULL' ],
  47                         'options' => [ 'GROUP BY' => 'cl_to' ],
  48                         'join_conds' => [ 'page' => [ 'LEFT JOIN',
  49                                 [ 'page_title = cl_to',
  50                                         'page_namespace' => NS_CATEGORY ] ] ]
  51                 ];
  52         }
  53
  54         function preprocessResults( $db, $res ) {
  55                 parent::preprocessResults( $db, $res );
  56
  57                 $this->currentCategoryCounts = [];
  58
  59                 if ( !$res->numRows() || !$this->isCached() ) {
  60                         return;
  61                 }
  62
  63                 // Fetch (hopefully) up-to-date numbers of pages in each category.
  64                 // This should be fast enough as we limit the list to a reasonable length.
  65
  66                 $allCategories = [];
  67                 foreach ( $res as $row ) {
  68                         $allCategories[] = $row->title;
  69                 }
  70
  71                 $categoryRes = $db->select(
  72                         'category',
  73                         [ 'cat_title', 'cat_pages' ],
  74                         [ 'cat_title' => $allCategories ],
  75                         __METHOD__
  76                 );
  77                 foreach ( $categoryRes as $row ) {
  78                         $this->currentCategoryCounts[$row->cat_title] = intval( $row->cat_pages );
  79                 }
  80
  81                 // Back to start for display
  82                 $res->seek( 0 );
  83         }
  84
  85         /**
  86          * @param Skin $skin
  87          * @param object $result Result row
  88          * @return string
  89          */
  90         function formatResult( $skin, $result ) {
  91                 global $wgContLang;
  92
  93                 $nt = Title::makeTitle( $result->namespace, $result->title );
  94                 $text = htmlspecialchars( $wgContLang->convert( $nt->getText() ) );
  95
  96                 if ( !$this->isCached() ) {
  97                         // We can assume the freshest data
  98                         $plink = Linker::link(
  99                                 $nt,
 100                                 $text,
 101                                 [],
 102                                 [],
 103                                 [ 'broken' ]
 104                         );
 105                         $nlinks = $this->msg( 'nmembers' )->numParams( $result->value )->escaped();
 106                 } else {
 107                         $plink = Linker::link( $nt, $text );
 108
 109                         $currentValue = isset( $this->currentCategoryCounts[$result->title] )
 110                                 ? $this->currentCategoryCounts[$result->title]
 111                                 : 0;
 112                         $cachedValue = intval( $result->value ); // T76910
 113
 114                         // If the category has been created or emptied since the list was refreshed, strike it
 115                         if ( $nt->isKnown() || $currentValue === 0 ) {
 116                                 $plink = "<del>$plink</del>";
 117                         }
 118
 119                         // Show the current number of category entries if it changed
 120                         if ( $currentValue !== $cachedValue ) {
 121                                 $nlinks = $this->msg( 'nmemberschanged' )
 122                                         ->numParams( $cachedValue, $currentValue )->escaped();
 123                         } else {
 124                                 $nlinks = $this->msg( 'nmembers' )->numParams( $cachedValue )->escaped();
 125                         }
 126                 }
 127
 128                 return $this->getLanguage()->specialList( $plink, $nlinks );
 129         }
 130
 131         protected function getGroupName() {
 132                 return 'maintenance';
 133         }
 134 }