includes/specials/SpecialMIMEsearch.php

   1 <?php
   2 /**
   3  * Implements Special:MIMESearch
   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  * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
  23  */
  24
  25 use MediaWiki\MediaWikiServices;
  26
  27 /**
  28  * Searches the database for files of the requested MIME type, comparing this with the
  29  * 'img_major_mime' and 'img_minor_mime' fields in the image table.
  30  * @ingroup SpecialPage
  31  */
  32 class MIMEsearchPage extends QueryPage {
  33         protected $major, $minor, $mime;
  34
  35         function __construct( $name = 'MIMEsearch' ) {
  36                 parent::__construct( $name );
  37         }
  38
  39         public function isExpensive() {
  40                 return false;
  41         }
  42
  43         function isSyndicated() {
  44                 return false;
  45         }
  46
  47         function isCacheable() {
  48                 return false;
  49         }
  50
  51         function linkParameters() {
  52                 return [ 'mime' => "{$this->major}/{$this->minor}" ];
  53         }
  54
  55         public function getQueryInfo() {
  56                 $minorType = [];
  57                 if ( $this->minor !== '*' ) {
  58                         // Allow wildcard searching
  59                         $minorType['img_minor_mime'] = $this->minor;
  60                 }
  61                 $imgQuery = LocalFile::getQueryInfo();
  62                 $qi = [
  63                         'tables' => $imgQuery['tables'],
  64                         'fields' => [
  65                                 'namespace' => NS_FILE,
  66                                 'title' => 'img_name',
  67                                 // Still have a value field just in case,
  68                                 // but it isn't actually used for sorting.
  69                                 'value' => 'img_name',
  70                                 'img_size',
  71                                 'img_width',
  72                                 'img_height',
  73                                 'img_user_text' => $imgQuery['fields']['img_user_text'],
  74                                 'img_timestamp'
  75                         ],
  76                         'conds' => [
  77                                 'img_major_mime' => $this->major,
  78                                 // This is in order to trigger using
  79                                 // the img_media_mime index in "range" mode.
  80                                 // @todo how is order defined? use MimeAnalyzer::getMediaTypes?
  81                                 'img_media_type' => [
  82                                         MEDIATYPE_BITMAP,
  83                                         MEDIATYPE_DRAWING,
  84                                         MEDIATYPE_AUDIO,
  85                                         MEDIATYPE_VIDEO,
  86                                         MEDIATYPE_MULTIMEDIA,
  87                                         MEDIATYPE_UNKNOWN,
  88                                         MEDIATYPE_OFFICE,
  89                                         MEDIATYPE_TEXT,
  90                                         MEDIATYPE_EXECUTABLE,
  91                                         MEDIATYPE_ARCHIVE,
  92                                         MEDIATYPE_3D,
  93                                 ],
  94                         ] + $minorType,
  95                         'join_conds' => $imgQuery['joins'],
  96                 ];
  97
  98                 return $qi;
  99         }
 100
 101         /**
 102          * The index is on (img_media_type, img_major_mime, img_minor_mime)
 103          * which unfortunately doesn't have img_name at the end for sorting.
 104          * So tell db to sort it however it wishes (Its not super important
 105          * that this report gives results in a logical order). As an aditional
 106          * note, mysql seems to by default order things by img_name ASC, which
 107          * is what we ideally want, so everything works out fine anyhow.
 108          * @return array
 109          */
 110         function getOrderFields() {
 111                 return [];
 112         }
 113
 114         /**
 115          * Generate and output the form
 116          */
 117         function getPageHeader() {
 118                 $formDescriptor = [
 119                         'mime' => [
 120                                 'type' => 'combobox',
 121                                 'options' => $this->getSuggestionsForTypes(),
 122                                 'name' => 'mime',
 123                                 'label-message' => 'mimetype',
 124                                 'required' => true,
 125                                 'default' => $this->mime,
 126                         ],
 127                 ];
 128
 129                 HTMLForm::factory( 'ooui', $formDescriptor, $this->getContext() )
 130                         ->setSubmitTextMsg( 'ilsubmit' )
 131                         ->setAction( $this->getPageTitle()->getLocalURL() )
 132                         ->setMethod( 'get' )
 133                         ->prepareForm()
 134                         ->displayForm( false );
 135         }
 136
 137         protected function getSuggestionsForTypes() {
 138                 $dbr = wfGetDB( DB_REPLICA );
 139                 $lastMajor = null;
 140                 $suggestions = [];
 141                 $result = $dbr->select(
 142                         [ 'image' ],
 143                         // We ignore img_media_type, but using it in the query is needed for MySQL to choose a
 144                         // sensible execution plan
 145                         [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ],
 146                         [],
 147                         __METHOD__,
 148                         [ 'GROUP BY' => [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ] ]
 149                 );
 150                 foreach ( $result as $row ) {
 151                         $major = $row->img_major_mime;
 152                         $minor = $row->img_minor_mime;
 153                         $suggestions[ "$major/$minor" ] = "$major/$minor";
 154                         if ( $lastMajor === $major ) {
 155                                 // If there are at least two with the same major mime type, also include the wildcard
 156                                 $suggestions[ "$major/*" ] = "$major/*";
 157                         }
 158                         $lastMajor = $major;
 159                 }
 160                 ksort( $suggestions );
 161                 return $suggestions;
 162         }
 163
 164         public function execute( $par ) {
 165                 $this->mime = $par ?: $this->getRequest()->getText( 'mime' );
 166                 $this->mime = trim( $this->mime );
 167                 list( $this->major, $this->minor ) = File::splitMime( $this->mime );
 168
 169                 if ( $this->major == '' || $this->minor == '' || $this->minor == 'unknown' ||
 170                         !self::isValidType( $this->major )
 171                 ) {
 172                         $this->setHeaders();
 173                         $this->outputHeader();
 174                         $this->getPageHeader();
 175                         return;
 176                 }
 177
 178                 parent::execute( $par );
 179         }
 180
 181         /**
 182          * @param Skin $skin
 183          * @param object $result Result row
 184          * @return string
 185          */
 186         function formatResult( $skin, $result ) {
 187                 $linkRenderer = $this->getLinkRenderer();
 188                 $nt = Title::makeTitle( $result->namespace, $result->title );
 189                 $text = MediaWikiServices::getInstance()->getContentLanguage()
 190                         ->convert( htmlspecialchars( $nt->getText() ) );
 191                 $plink = $linkRenderer->makeLink(
 192                         Title::newFromText( $nt->getPrefixedText() ),
 193                         new HtmlArmor( $text )
 194                 );
 195
 196                 $download = Linker::makeMediaLinkObj( $nt, $this->msg( 'download' )->escaped() );
 197                 $download = $this->msg( 'parentheses' )->rawParams( $download )->escaped();
 198                 $lang = $this->getLanguage();
 199                 $bytes = htmlspecialchars( $lang->formatSize( $result->img_size ) );
 200                 $dimensions = $this->msg( 'widthheight' )->numParams( $result->img_width,
 201                         $result->img_height )->escaped();
 202                 $user = $linkRenderer->makeLink(
 203                         Title::makeTitle( NS_USER, $result->img_user_text ),
 204                         $result->img_user_text
 205                 );
 206
 207                 $time = $lang->userTimeAndDate( $result->img_timestamp, $this->getUser() );
 208                 $time = htmlspecialchars( $time );
 209
 210                 return "$download $plink . . $dimensions . . $bytes . . $user . . $time";
 211         }
 212
 213         /**
 214          * @param string $type
 215          * @return bool
 216          */
 217         protected static function isValidType( $type ) {
 218                 // From maintenance/tables.sql => img_major_mime
 219                 $types = [
 220                         'unknown',
 221                         'application',
 222                         'audio',
 223                         'image',
 224                         'text',
 225                         'video',
 226                         'message',
 227                         'model',
 228                         'multipart',
 229                         'chemical'
 230                 ];
 231
 232                 return in_array( $type, $types );
 233         }
 234
 235         public function preprocessResults( $db, $res ) {
 236                 $this->executeLBFromResultWrapper( $res );
 237         }
 238
 239         protected function getGroupName() {
 240                 return 'media';
 241         }
 242 }