* (bug 7405) Make Linker methods static. Patch by Dan Li.
[lhc/web/wiklou.git] / includes / Pager.php
1 <?php
2
3 /**
4 * Basic pager interface.
5 */
6 interface Pager {
7 function getNavigationBar();
8 function getBody();
9 }
10
11 /**
12 * IndexPager is an efficient pager which uses a (roughly unique) index in the
13 * data set to implement paging, rather than a "LIMIT offset,limit" clause.
14 * In MySQL, such a limit/offset clause requires counting through the specified number
15 * of offset rows to find the desired data, which can be expensive for large offsets.
16 *
17 * ReverseChronologicalPager is a child class of the abstract IndexPager, and contains
18 * some formatting and display code which is specific to the use of timestamps as
19 * indexes. Here is a synopsis of its operation:
20 *
21 * * The query is specified by the offset, limit and direction (dir) parameters, in
22 * addition to any subclass-specific parameters.
23 *
24 * * The offset is the non-inclusive start of the DB query. A row with an index value
25 * equal to the offset will never be shown.
26 *
27 * * The query may either be done backwards, where the rows are returned by the database
28 * in the opposite order to which they are displayed to the user, or forwards. This is
29 * specified by the "dir" parameter, dir=prev means backwards, anything else means
30 * forwards. The offset value specifies the start of the database result set, which
31 * may be either the start or end of the displayed data set. This allows "previous"
32 * links to be implemented without knowledge of the index value at the start of the
33 * previous page.
34 *
35 * * An additional row beyond the user-specified limit is always requested. This allows
36 * us to tell whether we should display a "next" link in the case of forwards mode,
37 * or a "previous" link in the case of backwards mode. Determining whether to
38 * display the other link (the one for the page before the start of the database
39 * result set) can be done heuristically by examining the offset.
40 *
41 * * An empty offset indicates that the offset condition should be omitted from the query.
42 * This naturally produces either the first page or the last page depending on the
43 * dir parameter.
44 *
45 * Subclassing the pager to implement concrete functionality should be fairly simple,
46 * please see the examples in PageHistory.php and SpecialIpblocklist.php. You just need
47 * to override formatRow(), getQueryInfo() and getIndexField(). Don't forget to call the
48 * parent constructor if you override it.
49 */
50 abstract class IndexPager implements Pager {
51 public $mRequest;
52 public $mLimitsShown = array( 20, 50, 100, 250, 500 );
53 public $mDefaultLimit = 50;
54 public $mOffset, $mLimit;
55 public $mQueryDone = false;
56 public $mDb;
57 public $mPastTheEndRow;
58
59 protected $mIndexField;
60
61 /**
62 * Default query direction. false for ascending, true for descending
63 */
64 public $mDefaultDirection = false;
65
66 /**
67 * Result object for the query. Warning: seek before use.
68 */
69 public $mResult;
70
71 function __construct() {
72 global $wgRequest;
73 $this->mRequest = $wgRequest;
74
75 # NB: the offset is quoted, not validated. It is treated as an arbitrary string
76 # to support the widest variety of index types. Be careful outputting it into
77 # HTML!
78 $this->mOffset = $this->mRequest->getText( 'offset' );
79 $this->mLimit = $this->mRequest->getInt( 'limit', $this->mDefaultLimit );
80 if ( $this->mLimit <= 0 || $this->mLimit > 50000 ) {
81 $this->mLimit = $this->mDefaultLimit;
82 }
83 $this->mIsBackwards = ( $this->mRequest->getVal( 'dir' ) == 'prev' );
84 $this->mIndexField = $this->getIndexField();
85 $this->mDb = wfGetDB( DB_SLAVE );
86 }
87
88 /**
89 * Do the query, using information from the object context. This function
90 * has been kept minimal to make it overridable if necessary, to allow for
91 * result sets formed from multiple DB queries.
92 */
93 function doQuery() {
94 # Use the child class name for profiling
95 $fname = __METHOD__ . ' (' . get_class( $this ) . ')';
96 wfProfileIn( $fname );
97
98 $descending = ( $this->mIsBackwards == $this->mDefaultDirection );
99 # Plus an extra row so that we can tell the "next" link should be shown
100 $queryLimit = $this->mLimit + 1;
101
102 $this->mResult = $this->reallyDoQuery( $this->mOffset, $queryLimit, $descending );
103 $this->extractResultInfo( $this->mOffset, $queryLimit, $this->mResult );
104 $this->mQueryDone = true;
105
106 wfProfileOut( $fname );
107 }
108
109 /**
110 * Extract some useful data from the result object for use by
111 * the navigation bar, put it into $this
112 */
113 function extractResultInfo( $offset, $limit, ResultWrapper $res ) {
114 $numRows = $res->numRows();
115 if ( $numRows ) {
116 $row = $res->fetchRow();
117 $firstIndex = $row[$this->mIndexField];
118
119 # Discard the extra result row if there is one
120 if ( $numRows > $this->mLimit && $numRows > 1 ) {
121 $res->seek( $numRows - 1 );
122 $this->mPastTheEndRow = $res->fetchObject();
123 $indexField = $this->mIndexField;
124 $this->mPastTheEndIndex = $this->mPastTheEndRow->$indexField;
125 $res->seek( $numRows - 2 );
126 $row = $res->fetchRow();
127 $lastIndex = $row[$this->mIndexField];
128 } else {
129 $this->mPastTheEndRow = null;
130 # Setting indexes to an empty string means that they will be omitted
131 # if they would otherwise appear in URLs. It just so happens that this
132 # is the right thing to do in the standard UI, in all the relevant cases.
133 $this->mPastTheEndIndex = '';
134 $res->seek( $numRows - 1 );
135 $row = $res->fetchRow();
136 $lastIndex = $row[$this->mIndexField];
137 }
138 } else {
139 $firstIndex = '';
140 $lastIndex = '';
141 $this->mPastTheEndRow = null;
142 $this->mPastTheEndIndex = '';
143 }
144
145 if ( $this->mIsBackwards ) {
146 $this->mIsFirst = ( $numRows < $limit );
147 $this->mIsLast = ( $offset == '' );
148 $this->mLastShown = $firstIndex;
149 $this->mFirstShown = $lastIndex;
150 } else {
151 $this->mIsFirst = ( $offset == '' );
152 $this->mIsLast = ( $numRows < $limit );
153 $this->mLastShown = $lastIndex;
154 $this->mFirstShown = $firstIndex;
155 }
156 }
157
158 /**
159 * Do a query with specified parameters, rather than using the object context
160 *
161 * @param string $offset Index offset, inclusive
162 * @param integer $limit Exact query limit
163 * @param boolean $descending Query direction, false for ascending, true for descending
164 * @return ResultWrapper
165 */
166 function reallyDoQuery( $offset, $limit, $ascending ) {
167 $fname = __METHOD__ . ' (' . get_class( $this ) . ')';
168 $info = $this->getQueryInfo();
169 $tables = $info['tables'];
170 $fields = $info['fields'];
171 $conds = isset( $info['conds'] ) ? $info['conds'] : array();
172 $options = isset( $info['options'] ) ? $info['options'] : array();
173 if ( $ascending ) {
174 $options['ORDER BY'] = $this->mIndexField;
175 $operator = '>';
176 } else {
177 $options['ORDER BY'] = $this->mIndexField . ' DESC';
178 $operator = '<';
179 }
180 if ( $offset != '' ) {
181 $conds[] = $this->mIndexField . $operator . $this->mDb->addQuotes( $offset );
182 }
183 $options['LIMIT'] = intval( $limit );
184 $res = $this->mDb->select( $tables, $fields, $conds, $fname, $options );
185 return new ResultWrapper( $this->mDb, $res );
186 }
187
188 /**
189 * Get the formatted result list. Calls getStartBody(), formatRow() and
190 * getEndBody(), concatenates the results and returns them.
191 */
192 function getBody() {
193 if ( !$this->mQueryDone ) {
194 $this->doQuery();
195 }
196 # Don't use any extra rows returned by the query
197 $numRows = min( $this->mResult->numRows(), $this->mLimit );
198
199 $s = $this->getStartBody();
200 if ( $numRows ) {
201 if ( $this->mIsBackwards ) {
202 for ( $i = $numRows - 1; $i >= 0; $i-- ) {
203 $this->mResult->seek( $i );
204 $row = $this->mResult->fetchObject();
205 $s .= $this->formatRow( $row );
206 }
207 } else {
208 $this->mResult->seek( 0 );
209 for ( $i = 0; $i < $numRows; $i++ ) {
210 $row = $this->mResult->fetchObject();
211 $s .= $this->formatRow( $row );
212 }
213 }
214 } else {
215 $s .= $this->getEmptyBody();
216 }
217 $s .= $this->getEndBody();
218 return $s;
219 }
220
221 /**
222 * Make a self-link
223 */
224 function makeLink($text, $query = NULL) {
225 if ( $query === null ) {
226 return $text;
227 } else {
228 return Linker::makeKnownLinkObj( $this->getTitle(), $text,
229 wfArrayToCGI( $query, $this->getDefaultQuery() ) );
230 }
231 }
232
233 /**
234 * Hook into getBody(), allows text to be inserted at the start. This
235 * will be called even if there are no rows in the result set.
236 */
237 function getStartBody() {
238 return '';
239 }
240
241 /**
242 * Hook into getBody() for the end of the list
243 */
244 function getEndBody() {
245 return '';
246 }
247
248 /**
249 * Hook into getBody(), for the bit between the start and the
250 * end when there are no rows
251 */
252 function getEmptyBody() {
253 return '';
254 }
255
256 /**
257 * Title used for self-links. Override this if you want to be able to
258 * use a title other than $wgTitle
259 */
260 function getTitle() {
261 return $GLOBALS['wgTitle'];
262 }
263
264 /**
265 * Get an array of query parameters that should be put into self-links.
266 * By default, all parameters passed in the URL are used, except for a
267 * short blacklist.
268 */
269 function getDefaultQuery() {
270 if ( !isset( $this->mDefaultQuery ) ) {
271 $this->mDefaultQuery = $_GET;
272 unset( $this->mDefaultQuery['title'] );
273 unset( $this->mDefaultQuery['dir'] );
274 unset( $this->mDefaultQuery['offset'] );
275 unset( $this->mDefaultQuery['limit'] );
276 }
277 return $this->mDefaultQuery;
278 }
279
280 /**
281 * Get the number of rows in the result set
282 */
283 function getNumRows() {
284 if ( !$this->mQueryDone ) {
285 $this->doQuery();
286 }
287 return $this->mResult->numRows();
288 }
289
290 /**
291 * Get a query array for the prev, next, first and last links.
292 */
293 function getPagingQueries() {
294 if ( !$this->mQueryDone ) {
295 $this->doQuery();
296 }
297
298 # Don't announce the limit everywhere if it's the default
299 $urlLimit = $this->mLimit == $this->mDefaultLimit ? '' : $this->mLimit;
300
301 if ( $this->mIsFirst ) {
302 $prev = false;
303 $first = false;
304 } else {
305 $prev = array( 'dir' => 'prev', 'offset' => $this->mFirstShown, 'limit' => $urlLimit );
306 $first = array( 'limit' => $urlLimit );
307 }
308 if ( $this->mIsLast ) {
309 $next = false;
310 $last = false;
311 } else {
312 $next = array( 'offset' => $this->mLastShown, 'limit' => $urlLimit );
313 $last = array( 'dir' => 'prev', 'limit' => $urlLimit );
314 }
315 return compact( 'prev', 'next', 'first', 'last' );
316 }
317
318 /**
319 * Get paging links. If a link is disabled, the item from $disabledTexts will
320 * be used. If there is no such item, the unlinked text from $linkTexts will
321 * be used. Both $linkTexts and $disabledTexts are arrays of HTML.
322 */
323 function getPagingLinks( $linkTexts, $disabledTexts = array() ) {
324 $queries = $this->getPagingQueries();
325 $links = array();
326 foreach ( $queries as $type => $query ) {
327 if ( $query !== false ) {
328 $links[$type] = $this->makeLink( $linkTexts[$type], $queries[$type] );
329 } elseif ( isset( $disabledTexts[$type] ) ) {
330 $links[$type] = $disabledTexts[$type];
331 } else {
332 $links[$type] = $linkTexts[$type];
333 }
334 }
335 return $links;
336 }
337
338 function getLimitLinks() {
339 global $wgLang;
340 $links = array();
341 if ( $this->mIsBackwards ) {
342 $offset = $this->mPastTheEndIndex;
343 } else {
344 $offset = $this->mOffset;
345 }
346 foreach ( $this->mLimitsShown as $limit ) {
347 $links[] = $this->makeLink( $wgLang->formatNum( $limit ),
348 array( 'offset' => $offset, 'limit' => $limit ) );
349 }
350 return $links;
351 }
352
353 /**
354 * Abstract formatting function. This should return an HTML string
355 * representing the result row $row. Rows will be concatenated and
356 * returned by getBody()
357 */
358 abstract function formatRow( $row );
359
360 /**
361 * This function should be overridden to provide all parameters
362 * needed for the main paged query. It returns an associative
363 * array with the following elements:
364 * tables => Table(s) for passing to Database::select()
365 * fields => Field(s) for passing to Database::select(), may be *
366 * conds => WHERE conditions
367 * options => option array
368 */
369 abstract function getQueryInfo();
370
371 /**
372 * This function should be overridden to return the name of the
373 * index field.
374 */
375 abstract function getIndexField();
376 }
377
378 /**
379 * IndexPager with a formatted navigation bar
380 */
381 abstract class ReverseChronologicalPager extends IndexPager {
382 public $mDefaultDirection = true;
383
384 function __construct() {
385 parent::__construct();
386 }
387
388 function getNavigationBar() {
389 global $wgLang;
390
391 if ( isset( $this->mNavigationBar ) ) {
392 return $this->mNavigationBar;
393 }
394 $linkTexts = array(
395 'prev' => wfMsgHtml( "prevn", $this->mLimit ),
396 'next' => wfMsgHtml( 'nextn', $this->mLimit ),
397 'first' => wfMsgHtml('histlast'),
398 'last' => wfMsgHtml( 'histfirst' )
399 );
400
401 $pagingLinks = $this->getPagingLinks( $linkTexts );
402 $limitLinks = $this->getLimitLinks();
403 $limits = implode( ' | ', $limitLinks );
404
405 $this->mNavigationBar = "({$pagingLinks['first']} | {$pagingLinks['last']}) " . wfMsgHtml("viewprevnext", $pagingLinks['prev'], $pagingLinks['next'], $limits);
406 return $this->mNavigationBar;
407 }
408 }
409
410 /**
411 * Table-based display with a user-selectable sort order
412 */
413 abstract class TablePager extends IndexPager {
414 var $mSort;
415 var $mCurrentRow;
416
417 function __construct() {
418 global $wgRequest;
419 $this->mSort = $wgRequest->getText( 'sort' );
420 if ( !array_key_exists( $this->mSort, $this->getFieldNames() ) ) {
421 $this->mSort = $this->getDefaultSort();
422 }
423 if ( $wgRequest->getBool( 'asc' ) ) {
424 $this->mDefaultDirection = false;
425 } elseif ( $wgRequest->getBool( 'desc' ) ) {
426 $this->mDefaultDirection = true;
427 } /* Else leave it at whatever the class default is */
428
429 parent::__construct();
430 }
431
432 function getStartBody() {
433 global $wgStylePath;
434 $tableClass = htmlspecialchars( $this->getTableClass() );
435 $sortClass = htmlspecialchars( $this->getSortHeaderClass() );
436
437 $s = "<table border='1' class=\"$tableClass\"><thead><tr>\n";
438 $fields = $this->getFieldNames();
439
440 # Make table header
441 foreach ( $fields as $field => $name ) {
442 if ( strval( $name ) == '' ) {
443 $s .= "<th>&nbsp;</th>\n";
444 } elseif ( $this->isFieldSortable( $field ) ) {
445 $query = array( 'sort' => $field, 'limit' => $this->mLimit );
446 if ( $field == $this->mSort ) {
447 # This is the sorted column
448 # Prepare a link that goes in the other sort order
449 if ( $this->mDefaultDirection ) {
450 # Descending
451 $image = 'Arr_u.png';
452 $query['asc'] = '1';
453 $query['desc'] = '';
454 $alt = htmlspecialchars( wfMsg( 'descending_abbrev' ) );
455 } else {
456 # Ascending
457 $image = 'Arr_d.png';
458 $query['asc'] = '';
459 $query['desc'] = '1';
460 $alt = htmlspecialchars( wfMsg( 'ascending_abbrev' ) );
461 }
462 $image = htmlspecialchars( "$wgStylePath/common/images/$image" );
463 $link = $this->makeLink(
464 "<img width=\"12\" height=\"12\" alt=\"$alt\" src=\"$image\" />" .
465 htmlspecialchars( $name ), $query );
466 $s .= "<th class=\"$sortClass\">$link</th>\n";
467 } else {
468 $s .= '<th>' . $this->makeLink( htmlspecialchars( $name ), $query ) . "</th>\n";
469 }
470 } else {
471 $s .= '<th>' . htmlspecialchars( $name ) . "</th>\n";
472 }
473 }
474 $s .= "</tr></thead><tbody>\n";
475 return $s;
476 }
477
478 function getEndBody() {
479 return '</tbody></table>';
480 }
481
482 function getEmptyBody() {
483 $colspan = count( $this->getFieldNames() );
484 $msgEmpty = wfMsgHtml( 'table_pager_empty' );
485 return "<tr><td colspan=\"$colspan\">$msgEmpty</td></tr>\n";
486 }
487
488 function formatRow( $row ) {
489 $s = "<tr>\n";
490 $fieldNames = $this->getFieldNames();
491 $this->mCurrentRow = $row; # In case formatValue needs to know
492 foreach ( $fieldNames as $field => $name ) {
493 $value = isset( $row->$field ) ? $row->$field : null;
494 $formatted = strval( $this->formatValue( $field, $value ) );
495 if ( $formatted == '' ) {
496 $formatted = '&nbsp;';
497 }
498 $class = 'TablePager_col_' . htmlspecialchars( $field );
499 $s .= "<td class=\"$class\">$formatted</td>\n";
500 }
501 $s .= "</tr>\n";
502 return $s;
503 }
504
505 function getIndexField() {
506 return $this->mSort;
507 }
508
509 function getTableClass() {
510 return 'TablePager';
511 }
512
513 function getNavClass() {
514 return 'TablePager_nav';
515 }
516
517 function getSortHeaderClass() {
518 return 'TablePager_sort';
519 }
520
521 /**
522 * A navigation bar with images
523 */
524 function getNavigationBar() {
525 global $wgStylePath, $wgContLang;
526 $path = "$wgStylePath/common/images";
527 $labels = array(
528 'first' => 'table_pager_first',
529 'prev' => 'table_pager_prev',
530 'next' => 'table_pager_next',
531 'last' => 'table_pager_last',
532 );
533 $images = array(
534 'first' => $wgContLang->isRTL() ? 'arrow_last_25.png' : 'arrow_first_25.png',
535 'prev' => $wgContLang->isRTL() ? 'arrow_right_25.png' : 'arrow_left_25.png',
536 'next' => $wgContLang->isRTL() ? 'arrow_left_25.png' : 'arrow_right_25.png',
537 'last' => $wgContLang->isRTL() ? 'arrow_first_25.png' : 'arrow_last_25.png',
538 );
539 $disabledImages = array(
540 'first' => $wgContLang->isRTL() ? 'arrow_disabled_last_25.png' : 'arrow_disabled_first_25.png',
541 'prev' => $wgContLang->isRTL() ? 'arrow_disabled_right_25.png' : 'arrow_disabled_left_25.png',
542 'next' => $wgContLang->isRTL() ? 'arrow_disabled_left_25.png' : 'arrow_disabled_right_25.png',
543 'last' => $wgContLang->isRTL() ? 'arrow_disabled_first_25.png' : 'arrow_disabled_last_25.png',
544 );
545
546 $linkTexts = array();
547 $disabledTexts = array();
548 foreach ( $labels as $type => $label ) {
549 $msgLabel = wfMsgHtml( $label );
550 $linkTexts[$type] = "<img src=\"$path/{$images[$type]}\" alt=\"$msgLabel\"/><br/>$msgLabel";
551 $disabledTexts[$type] = "<img src=\"$path/{$disabledImages[$type]}\" alt=\"$msgLabel\"/><br/>$msgLabel";
552 }
553 $links = $this->getPagingLinks( $linkTexts, $disabledTexts );
554
555 $navClass = htmlspecialchars( $this->getNavClass() );
556 $s = "<table class=\"$navClass\" align=\"center\" cellpadding=\"3\"><tr>";
557 $cellAttrs = 'valign="top" align="center" width="' . 100 / count( $links ) . '%"';
558 foreach ( $labels as $type => $label ) {
559 $s .= "<td $cellAttrs>{$links[$type]}</td>\n";
560 }
561 $s .= '</tr></table>';
562 return $s;
563 }
564
565 /**
566 * Get a <select> element which has options for each of the allowed limits
567 */
568 function getLimitSelect() {
569 global $wgLang;
570 $s = "<select name=\"limit\">";
571 foreach ( $this->mLimitsShown as $limit ) {
572 $selected = $limit == $this->mLimit ? 'selected="selected"' : '';
573 $formattedLimit = $wgLang->formatNum( $limit );
574 $s .= "<option value=\"$limit\" $selected>$formattedLimit</option>\n";
575 }
576 $s .= "</select>";
577 return $s;
578 }
579
580 /**
581 * Get <input type="hidden"> elements for use in a method="get" form.
582 * Resubmits all defined elements of the $_GET array, except for a
583 * blacklist, passed in the $blacklist parameter.
584 */
585 function getHiddenFields( $blacklist = array() ) {
586 $blacklist = (array)$blacklist;
587 $query = $_GET;
588 foreach ( $blacklist as $name ) {
589 unset( $query[$name] );
590 }
591 $s = '';
592 foreach ( $query as $name => $value ) {
593 $encName = htmlspecialchars( $name );
594 $encValue = htmlspecialchars( $value );
595 $s .= "<input type=\"hidden\" name=\"$encName\" value=\"$encValue\"/>\n";
596 }
597 return $s;
598 }
599
600 /**
601 * Get a form containing a limit selection dropdown
602 */
603 function getLimitForm() {
604 # Make the select with some explanatory text
605 $url = $this->getTitle()->escapeLocalURL();
606 $msgSubmit = wfMsgHtml( 'table_pager_limit_submit' );
607 return
608 "<form method=\"get\" action=\"$url\">" .
609 wfMsgHtml( 'table_pager_limit', $this->getLimitSelect() ) .
610 "\n<input type=\"submit\" value=\"$msgSubmit\"/>\n" .
611 $this->getHiddenFields( 'limit' ) .
612 "</form>\n";
613 }
614
615 /**
616 * Return true if the named field should be sortable by the UI, false otherwise
617 * @param string $field
618 */
619 abstract function isFieldSortable( $field );
620
621 /**
622 * Format a table cell. The return value should be HTML, but use an empty string
623 * not &nbsp; for empty cells. Do not include the <td> and </td>.
624 *
625 * @param string $name The database field name
626 * @param string $value The value retrieved from the database
627 *
628 * The current result row is available as $this->mCurrentRow, in case you need
629 * more context.
630 */
631 abstract function formatValue( $name, $value );
632
633 /**
634 * The database field name used as a default sort order
635 */
636 abstract function getDefaultSort();
637
638 /**
639 * An array mapping database field names to a textual description of the field
640 * name, for use in the table header. The description should be plain text, it
641 * will be HTML-escaped later.
642 */
643 abstract function getFieldNames();
644 }
645 ?>