Merge "SpecialRunJobs: optional output stats and status."
[lhc/web/wiklou.git] / includes / specials / SpecialUnusedCategories.php
1 <?php
2 /**
3 * Implements Special:Unusedcategories
4 *
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
9 *
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
14 *
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
19 *
20 * @file
21 * @ingroup SpecialPage
22 */
23
24 /**
25 * @ingroup SpecialPage
26 */
27 class SpecialUnusedCategories extends QueryPage {
28 function __construct( $name = 'Unusedcategories' ) {
29 parent::__construct( $name );
30 }
31
32 public function isExpensive() {
33 return true;
34 }
35
36 function getPageHeader() {
37 return $this->msg( 'unusedcategoriestext' )->parseAsBlock();
38 }
39
40 public function getQueryInfo() {
41 return [
42 'tables' => [ 'page', 'categorylinks', 'page_props' ],
43 'fields' => [
44 'namespace' => 'page_namespace',
45 'title' => 'page_title',
46 'value' => 'page_title'
47 ],
48 'conds' => [
49 'cl_from IS NULL',
50 'page_namespace' => NS_CATEGORY,
51 'page_is_redirect' => 0,
52 'pp_page IS NULL'
53 ],
54 'join_conds' => [
55 'categorylinks' => [ 'LEFT JOIN', 'cl_to = page_title' ],
56 'page_props' => [ 'LEFT JOIN', [
57 'page_id = pp_page',
58 'pp_propname' => 'expectunusedcategory'
59 ] ]
60 ]
61 ];
62 }
63
64 /**
65 * A should come before Z (T32907)
66 * @return bool
67 */
68 function sortDescending() {
69 return false;
70 }
71
72 /**
73 * @param Skin $skin
74 * @param object $result Result row
75 * @return string
76 */
77 function formatResult( $skin, $result ) {
78 $title = Title::makeTitle( NS_CATEGORY, $result->title );
79
80 return $this->getLinkRenderer()->makeLink( $title, $title->getText() );
81 }
82
83 protected function getGroupName() {
84 return 'maintenance';
85 }
86
87 public function preprocessResults( $db, $res ) {
88 $this->executeLBFromResultWrapper( $res );
89 }
90 }