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
;
60 'tables' => [ 'image' ],
62 'namespace' => NS_FILE
,
63 'title' => 'img_name',
64 // Still have a value field just in case,
65 // but it isn't actually used for sorting.
66 'value' => 'img_name',
74 'img_major_mime' => $this->major
,
75 // This is in order to trigger using
76 // the img_media_mime index in "range" mode.
77 // @todo how is order defined? use MimeAnalyzer::getMediaTypes?
97 * The index is on (img_media_type, img_major_mime, img_minor_mime)
98 * which unfortunately doesn't have img_name at the end for sorting.
99 * So tell db to sort it however it wishes (Its not super important
100 * that this report gives results in a logical order). As an aditional
101 * note, mysql seems to by default order things by img_name ASC, which
102 * is what we ideally want, so everything works out fine anyhow.
105 function getOrderFields() {
110 * Generate and output the form
112 function getPageHeader() {
115 'type' => 'combobox',
116 'options' => $this->getSuggestionsForTypes(),
118 'label-message' => 'mimetype',
120 'default' => $this->mime
,
124 HTMLForm
::factory( 'ooui', $formDescriptor, $this->getContext() )
125 ->setSubmitTextMsg( 'ilsubmit' )
126 ->setAction( $this->getPageTitle()->getLocalURL() )
129 ->displayForm( false );
132 protected function getSuggestionsForTypes() {
133 $dbr = wfGetDB( DB_REPLICA
);
136 $result = $dbr->select(
138 // We ignore img_media_type, but using it in the query is needed for MySQL to choose a
139 // sensible execution plan
140 [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ],
143 [ 'GROUP BY' => [ 'img_media_type', 'img_major_mime', 'img_minor_mime' ] ]
145 foreach ( $result as $row ) {
146 $major = $row->img_major_mime
;
147 $minor = $row->img_minor_mime
;
148 $suggestions[ "$major/$minor" ] = "$major/$minor";
149 if ( $lastMajor === $major ) {
150 // If there are at least two with the same major mime type, also include the wildcard
151 $suggestions[ "$major/*" ] = "$major/*";
155 ksort( $suggestions );
159 public function execute( $par ) {
160 $this->mime
= $par ?
$par : $this->getRequest()->getText( 'mime' );
161 $this->mime
= trim( $this->mime
);
162 list( $this->major
, $this->minor
) = File
::splitMime( $this->mime
);
164 if ( $this->major
== '' ||
$this->minor
== '' ||
$this->minor
== 'unknown' ||
165 !self
::isValidType( $this->major
)
168 $this->outputHeader();
169 $this->getPageHeader();
173 parent
::execute( $par );
178 * @param object $result Result row
181 function formatResult( $skin, $result ) {
184 $linkRenderer = $this->getLinkRenderer();
185 $nt = Title
::makeTitle( $result->namespace, $result->title
);
186 $text = $wgContLang->convert( $nt->getText() );
187 $plink = $linkRenderer->makeLink(
188 Title
::newFromText( $nt->getPrefixedText() ),
192 $download = Linker
::makeMediaLinkObj( $nt, $this->msg( 'download' )->escaped() );
193 $download = $this->msg( 'parentheses' )->rawParams( $download )->escaped();
194 $lang = $this->getLanguage();
195 $bytes = htmlspecialchars( $lang->formatSize( $result->img_size
) );
196 $dimensions = $this->msg( 'widthheight' )->numParams( $result->img_width
,
197 $result->img_height
)->escaped();
198 $user = $linkRenderer->makeLink(
199 Title
::makeTitle( NS_USER
, $result->img_user_text
),
200 $result->img_user_text
203 $time = $lang->userTimeAndDate( $result->img_timestamp
, $this->getUser() );
204 $time = htmlspecialchars( $time );
206 return "$download $plink . . $dimensions . . $bytes . . $user . . $time";
210 * @param string $type
213 protected static function isValidType( $type ) {
214 // From maintenance/tables.sql => img_major_mime
228 return in_array( $type, $types );
231 public function preprocessResults( $db, $res ) {
232 $this->executeLBFromResultWrapper( $res );
235 protected function getGroupName() {