3 * Implements Special:MIMESearch
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.
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.
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
21 * @ingroup SpecialPage
22 * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
26 * Searches the database for files of the requested MIME type, comparing this with the
27 * 'img_major_mime' and 'img_minor_mime' fields in the image table.
28 * @ingroup SpecialPage
30 class MIMEsearchPage
extends QueryPage
{
31 protected $major, $minor, $mime;
33 function __construct( $name = 'MIMEsearch' ) {
34 parent
::__construct( $name );
37 public function isExpensive() {
41 function isSyndicated() {
45 function isCacheable() {
49 function linkParameters() {
50 return [ 'mime' => "{$this->major}/{$this->minor}" ];
53 public function getQueryInfo() {
55 if ( $this->minor
!== '*' ) {
56 // Allow wildcard searching
57 $minorType['img_minor_mime'] = $this->minor
;
59 $imgQuery = LocalFile
::getQueryInfo();
61 'tables' => $imgQuery['tables'],
63 'namespace' => NS_FILE
,
64 'title' => 'img_name',
65 // Still have a value field just in case,
66 // but it isn't actually used for sorting.
67 'value' => 'img_name',
71 'img_user_text' => $imgQuery['fields']['img_user_text'],
75 'img_major_mime' => $this->major
,
76 // This is in order to trigger using
77 // the img_media_mime index in "range" mode.
78 // @todo how is order defined? use MimeAnalyzer::getMediaTypes?
93 'join_conds' => $imgQuery['joins'],
100 * The index is on (img_media_type, img_major_mime, img_minor_mime)
101 * which unfortunately doesn't have img_name at the end for sorting.
102 * So tell db to sort it however it wishes (Its not super important
103 * that this report gives results in a logical order). As an aditional
104 * note, mysql seems to by default order things by img_name ASC, which
105 * is what we ideally want, so everything works out fine anyhow.
108 function getOrderFields() {
113 * Generate and output the form
115 function getPageHeader() {
118 'type' => 'combobox',
119 'options' => $this->getSuggestionsForTypes(),
121 'label-message' => 'mimetype',
123 'default' => $this->mime
,
127 HTMLForm
::factory( 'ooui', $formDescriptor, $this->getContext() )
128 ->setSubmitTextMsg( 'ilsubmit' )
129 ->setAction( $this->getPageTitle()->getLocalURL() )
132 ->displayForm( false );
135 protected function getSuggestionsForTypes() {
136 $dbr = wfGetDB( DB_REPLICA
);
139 $result = $dbr->select(
141 // We ignore img_media_type, but using it in the query is needed for MySQL to choose a
142 // sensible execution plan
143 [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ],
146 [ 'GROUP BY' => [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ] ]
148 foreach ( $result as $row ) {
149 $major = $row->img_major_mime
;
150 $minor = $row->img_minor_mime
;
151 $suggestions[ "$major/$minor" ] = "$major/$minor";
152 if ( $lastMajor === $major ) {
153 // If there are at least two with the same major mime type, also include the wildcard
154 $suggestions[ "$major/*" ] = "$major/*";
158 ksort( $suggestions );
162 public function execute( $par ) {
163 $this->mime
= $par ?
: $this->getRequest()->getText( 'mime' );
164 $this->mime
= trim( $this->mime
);
165 list( $this->major
, $this->minor
) = File
::splitMime( $this->mime
);
167 if ( $this->major
== '' ||
$this->minor
== '' ||
$this->minor
== 'unknown' ||
168 !self
::isValidType( $this->major
)
171 $this->outputHeader();
172 $this->getPageHeader();
176 parent
::execute( $par );
181 * @param object $result Result row
184 function formatResult( $skin, $result ) {
187 $linkRenderer = $this->getLinkRenderer();
188 $nt = Title
::makeTitle( $result->namespace, $result->title
);
189 $text = $wgContLang->convert( $nt->getText() );
190 $plink = $linkRenderer->makeLink(
191 Title
::newFromText( $nt->getPrefixedText() ),
195 $download = Linker
::makeMediaLinkObj( $nt, $this->msg( 'download' )->escaped() );
196 $download = $this->msg( 'parentheses' )->rawParams( $download )->escaped();
197 $lang = $this->getLanguage();
198 $bytes = htmlspecialchars( $lang->formatSize( $result->img_size
) );
199 $dimensions = $this->msg( 'widthheight' )->numParams( $result->img_width
,
200 $result->img_height
)->escaped();
201 $user = $linkRenderer->makeLink(
202 Title
::makeTitle( NS_USER
, $result->img_user_text
),
203 $result->img_user_text
206 $time = $lang->userTimeAndDate( $result->img_timestamp
, $this->getUser() );
207 $time = htmlspecialchars( $time );
209 return "$download $plink . . $dimensions . . $bytes . . $user . . $time";
213 * @param string $type
216 protected static function isValidType( $type ) {
217 // From maintenance/tables.sql => img_major_mime
231 return in_array( $type, $types );
234 public function preprocessResults( $db, $res ) {
235 $this->executeLBFromResultWrapper( $res );
238 protected function getGroupName() {