mRequest = $wgRequest; # NB: the offset is quoted, not validated. It is treated as an arbitrary string # to support the widest variety of index types. Be careful outputting it into # HTML! $this->mOffset = $this->mRequest->getText( 'offset' ); $this->mLimit = $this->mRequest->getInt( 'limit', $this->mDefaultLimit ); if ( $this->mLimit <= 0 || $this->mLimit > 50000 ) { $this->mLimit = $this->mDefaultLimit; } $this->mIsBackwards = ( $this->mRequest->getVal( 'dir' ) == 'prev' ); $this->mIndexField = $this->getIndexField(); $this->mDb = wfGetDB( DB_SLAVE ); } /** * Do the query, using information from the object context. This function * has been kept minimal to make it overridable if necessary, to allow for * result sets formed from multiple DB queries. */ function doQuery() { # Use the child class name for profiling $fname = __METHOD__ . ' (' . get_class( $this ) . ')'; wfProfileIn( $fname ); $descending = ( $this->mIsBackwards == $this->mDefaultDirection ); # Plus an extra row so that we can tell the "next" link should be shown $queryLimit = $this->mLimit + 1; $this->mResult = $this->reallyDoQuery( $this->mOffset, $queryLimit, $descending ); $this->extractResultInfo( $this->mOffset, $queryLimit, $this->mResult ); $this->mQueryDone = true; wfProfileOut( $fname ); } /** * Extract some useful data from the result object for use by * the navigation bar, put it into $this */ function extractResultInfo( $offset, $limit, ResultWrapper $res ) { $numRows = $res->numRows(); if ( $numRows ) { $row = $res->fetchRow(); $firstIndex = $row[$this->mIndexField]; # Discard the extra result row if there is one if ( $numRows > $this->mLimit && $numRows > 1 ) { $res->seek( $numRows - 1 ); $this->mPastTheEndRow = $res->fetchObject(); $indexField = $this->mIndexField; $this->mPastTheEndIndex = $this->mPastTheEndRow->$indexField; $res->seek( $numRows - 2 ); $row = $res->fetchRow(); $lastIndex = $row[$this->mIndexField]; } else { $this->mPastTheEndRow = null; # Setting indexes to an empty string means that they will be omitted # if they would otherwise appear in URLs. It just so happens that this # is the right thing to do in the standard UI, in all the relevant cases. $this->mPastTheEndIndex = ''; $res->seek( $numRows - 1 ); $row = $res->fetchRow(); $lastIndex = $row[$this->mIndexField]; } } else { $firstIndex = ''; $lastIndex = ''; $this->mPastTheEndRow = null; $this->mPastTheEndIndex = ''; } if ( $this->mIsBackwards ) { $this->mIsFirst = ( $numRows < $limit ); $this->mIsLast = ( $offset == '' ); $this->mLastShown = $firstIndex; $this->mFirstShown = $lastIndex; } else { $this->mIsFirst = ( $offset == '' ); $this->mIsLast = ( $numRows < $limit ); $this->mLastShown = $lastIndex; $this->mFirstShown = $firstIndex; } } /** * Do a query with specified parameters, rather than using the object context * * @param string $offset Index offset, inclusive * @param integer $limit Exact query limit * @param boolean $descending Query direction, false for ascending, true for descending * @return ResultWrapper */ function reallyDoQuery( $offset, $limit, $ascending ) { $fname = __METHOD__ . ' (' . get_class( $this ) . ')'; $info = $this->getQueryInfo(); $tables = $info['tables']; $fields = $info['fields']; $conds = isset( $info['conds'] ) ? $info['conds'] : array(); $options = isset( $info['options'] ) ? $info['options'] : array(); if ( $ascending ) { $options['ORDER BY'] = $this->mIndexField; $operator = '>'; } else { $options['ORDER BY'] = $this->mIndexField . ' DESC'; $operator = '<'; } if ( $offset != '' ) { $conds[] = $this->mIndexField . $operator . $this->mDb->addQuotes( $offset ); } $options['LIMIT'] = intval( $limit ); $res = $this->mDb->select( $tables, $fields, $conds, $fname, $options ); return new ResultWrapper( $this->mDb, $res ); } /** * Get the formatted result list. Calls getStartBody(), formatRow() and * getEndBody(), concatenates the results and returns them. */ function getBody() { if ( !$this->mQueryDone ) { $this->doQuery(); } # Don't use any extra rows returned by the query $numRows = min( $this->mResult->numRows(), $this->mLimit ); $s = $this->getStartBody(); if ( $numRows ) { if ( $this->mIsBackwards ) { for ( $i = $numRows - 1; $i >= 0; $i-- ) { $this->mResult->seek( $i ); $row = $this->mResult->fetchObject(); $s .= $this->formatRow( $row ); } } else { $this->mResult->seek( 0 ); for ( $i = 0; $i < $numRows; $i++ ) { $row = $this->mResult->fetchObject(); $s .= $this->formatRow( $row ); } } } else { $s .= $this->getEmptyBody(); } $s .= $this->getEndBody(); return $s; } /** * Make a self-link */ function makeLink($text, $query = NULL) { if ( $query === null ) { return $text; } else { return $this->getSkin()->makeKnownLinkObj( $this->getTitle(), $text, wfArrayToCGI( $query, $this->getDefaultQuery() ) ); } } /** * Hook into getBody(), allows text to be inserted at the start. This * will be called even if there are no rows in the result set. */ function getStartBody() { return ''; } /** * Hook into getBody() for the end of the list */ function getEndBody() { return ''; } /** * Hook into getBody(), for the bit between the start and the * end when there are no rows */ function getEmptyBody() { return ''; } /** * Title used for self-links. Override this if you want to be able to * use a title other than $wgTitle */ function getTitle() { return $GLOBALS['wgTitle']; } /** * Get the current skin. This can be overridden if necessary. */ function getSkin() { if ( !isset( $this->mSkin ) ) { global $wgUser; $this->mSkin = $wgUser->getSkin(); } return $this->mSkin; } /** * Get an array of query parameters that should be put into self-links. * By default, all parameters passed in the URL are used, except for a * short blacklist. */ function getDefaultQuery() { if ( !isset( $this->mDefaultQuery ) ) { $this->mDefaultQuery = $_GET; unset( $this->mDefaultQuery['title'] ); unset( $this->mDefaultQuery['dir'] ); unset( $this->mDefaultQuery['offset'] ); unset( $this->mDefaultQuery['limit'] ); } return $this->mDefaultQuery; } /** * Get the number of rows in the result set */ function getNumRows() { if ( !$this->mQueryDone ) { $this->doQuery(); } return $this->mResult->numRows(); } /** * Get a query array for the prev, next, first and last links. */ function getPagingQueries() { if ( !$this->mQueryDone ) { $this->doQuery(); } # Don't announce the limit everywhere if it's the default $urlLimit = $this->mLimit == $this->mDefaultLimit ? '' : $this->mLimit; if ( $this->mIsFirst ) { $prev = false; $first = false; } else { $prev = array( 'dir' => 'prev', 'offset' => $this->mFirstShown, 'limit' => $urlLimit ); $first = array( 'limit' => $urlLimit ); } if ( $this->mIsLast ) { $next = false; $last = false; } else { $next = array( 'offset' => $this->mLastShown, 'limit' => $urlLimit ); $last = array( 'dir' => 'prev', 'limit' => $urlLimit ); } return compact( 'prev', 'next', 'first', 'last' ); } /** * Get paging links. If a link is disabled, the item from $disabledTexts will * be used. If there is no such item, the unlinked text from $linkTexts will * be used. Both $linkTexts and $disabledTexts are arrays of HTML. */ function getPagingLinks( $linkTexts, $disabledTexts = array() ) { $queries = $this->getPagingQueries(); $links = array(); foreach ( $queries as $type => $query ) { if ( $query !== false ) { $links[$type] = $this->makeLink( $linkTexts[$type], $queries[$type] ); } elseif ( isset( $disabledTexts[$type] ) ) { $links[$type] = $disabledTexts[$type]; } else { $links[$type] = $linkTexts[$type]; } } return $links; } function getLimitLinks() { global $wgLang; $links = array(); if ( $this->mIsBackwards ) { $offset = $this->mPastTheEndIndex; } else { $offset = $this->mOffset; } foreach ( $this->mLimitsShown as $limit ) { $links[] = $this->makeLink( $wgLang->formatNum( $limit ), array( 'offset' => $offset, 'limit' => $limit ) ); } return $links; } /** * Abstract formatting function. This should return an HTML string * representing the result row $row. Rows will be concatenated and * returned by getBody() */ abstract function formatRow( $row ); /** * This function should be overridden to provide all parameters * needed for the main paged query. It returns an associative * array with the following elements: * tables => Table(s) for passing to Database::select() * fields => Field(s) for passing to Database::select(), may be * * conds => WHERE conditions * options => option array */ abstract function getQueryInfo(); /** * This function should be overridden to return the name of the * index field. */ abstract function getIndexField(); } /** * IndexPager with a formatted navigation bar */ abstract class ReverseChronologicalPager extends IndexPager { public $mDefaultDirection = true; function __construct() { parent::__construct(); } function getNavigationBar() { global $wgLang; if ( isset( $this->mNavigationBar ) ) { return $this->mNavigationBar; } $linkTexts = array( 'prev' => wfMsgHtml( "prevn", $this->mLimit ), 'next' => wfMsgHtml( 'nextn', $this->mLimit ), 'first' => wfMsgHtml('histlast'), 'last' => wfMsgHtml( 'histfirst' ) ); $pagingLinks = $this->getPagingLinks( $linkTexts ); $limitLinks = $this->getLimitLinks(); $limits = implode( ' | ', $limitLinks ); $this->mNavigationBar = "({$pagingLinks['first']} | {$pagingLinks['last']}) " . wfMsgHtml("viewprevnext", $pagingLinks['prev'], $pagingLinks['next'], $limits); return $this->mNavigationBar; } } /** * Table-based display with a user-selectable sort order */ abstract class TablePager extends IndexPager { var $mSort; var $mCurrentRow; function __construct() { global $wgRequest; $this->mSort = $wgRequest->getText( 'sort' ); if ( !array_key_exists( $this->mSort, $this->getFieldNames() ) ) { $this->mSort = $this->getDefaultSort(); } if ( $wgRequest->getBool( 'asc' ) ) { $this->mDefaultDirection = false; } elseif ( $wgRequest->getBool( 'desc' ) ) { $this->mDefaultDirection = true; } /* Else leave it at whatever the class default is */ parent::__construct(); } function getStartBody() { global $wgStylePath; $tableClass = htmlspecialchars( $this->getTableClass() ); $sortClass = htmlspecialchars( $this->getSortHeaderClass() ); $s = "\n"; $fields = $this->getFieldNames(); # Make table header foreach ( $fields as $field => $name ) { if ( strval( $name ) == '' ) { $s .= "\n"; } elseif ( $this->isFieldSortable( $field ) ) { $query = array( 'sort' => $field, 'limit' => $this->mLimit ); if ( $field == $this->mSort ) { # This is the sorted column # Prepare a link that goes in the other sort order if ( $this->mDefaultDirection ) { # Descending $image = 'Arr_u.png'; $query['asc'] = '1'; $query['desc'] = ''; $alt = htmlspecialchars( wfMsg( 'descending_abbrev' ) ); } else { # Ascending $image = 'Arr_d.png'; $query['asc'] = ''; $query['desc'] = '1'; $alt = htmlspecialchars( wfMsg( 'ascending_abbrev' ) ); } $image = htmlspecialchars( "$wgStylePath/common/images/$image" ); $link = $this->makeLink( "\"$alt\"" . htmlspecialchars( $name ), $query ); $s .= "\n"; } else { $s .= '\n"; } } else { $s .= '\n"; } } $s .= "\n"; return $s; } function getEndBody() { return '
 $link' . $this->makeLink( htmlspecialchars( $name ), $query ) . "' . htmlspecialchars( $name ) . "
'; } function getEmptyBody() { $colspan = count( $this->getFieldNames() ); $msgEmpty = wfMsgHtml( 'table_pager_empty' ); return "$msgEmpty\n"; } function formatRow( $row ) { $s = "\n"; $fieldNames = $this->getFieldNames(); $this->mCurrentRow = $row; # In case formatValue needs to know foreach ( $fieldNames as $field => $name ) { $value = isset( $row->$field ) ? $row->$field : null; $formatted = strval( $this->formatValue( $field, $value ) ); if ( $formatted == '' ) { $formatted = ' '; } $class = 'TablePager_col_' . htmlspecialchars( $field ); $s .= "$formatted\n"; } $s .= "\n"; return $s; } function getIndexField() { return $this->mSort; } function getTableClass() { return 'TablePager'; } function getNavClass() { return 'TablePager_nav'; } function getSortHeaderClass() { return 'TablePager_sort'; } /** * A navigation bar with images */ function getNavigationBar() { global $wgStylePath, $wgContLang; $path = "$wgStylePath/common/images"; $labels = array( 'first' => 'table_pager_first', 'prev' => 'table_pager_prev', 'next' => 'table_pager_next', 'last' => 'table_pager_last', ); $images = array( 'first' => $wgContLang->isRTL() ? 'arrow_last_25.png' : 'arrow_first_25.png', 'prev' => $wgContLang->isRTL() ? 'arrow_right_25.png' : 'arrow_left_25.png', 'next' => $wgContLang->isRTL() ? 'arrow_left_25.png' : 'arrow_right_25.png', 'last' => $wgContLang->isRTL() ? 'arrow_first_25.png' : 'arrow_last_25.png', ); $disabledImages = array( 'first' => $wgContLang->isRTL() ? 'arrow_disabled_last_25.png' : 'arrow_disabled_first_25.png', 'prev' => $wgContLang->isRTL() ? 'arrow_disabled_right_25.png' : 'arrow_disabled_left_25.png', 'next' => $wgContLang->isRTL() ? 'arrow_disabled_left_25.png' : 'arrow_disabled_right_25.png', 'last' => $wgContLang->isRTL() ? 'arrow_disabled_first_25.png' : 'arrow_disabled_last_25.png', ); $linkTexts = array(); $disabledTexts = array(); foreach ( $labels as $type => $label ) { $msgLabel = wfMsgHtml( $label ); $linkTexts[$type] = "\"$msgLabel\"/
$msgLabel"; $disabledTexts[$type] = "\"$msgLabel\"/
$msgLabel"; } $links = $this->getPagingLinks( $linkTexts, $disabledTexts ); $navClass = htmlspecialchars( $this->getNavClass() ); $s = ""; $cellAttrs = 'valign="top" align="center" width="' . 100 / count( $links ) . '%"'; foreach ( $labels as $type => $label ) { $s .= "\n"; } $s .= '
{$links[$type]}
'; return $s; } /** * Get a "; foreach ( $this->mLimitsShown as $limit ) { $selected = $limit == $this->mLimit ? 'selected="selected"' : ''; $formattedLimit = $wgLang->formatNum( $limit ); $s .= "\n"; } $s .= ""; return $s; } /** * Get elements for use in a method="get" form. * Resubmits all defined elements of the $_GET array, except for a * blacklist, passed in the $blacklist parameter. */ function getHiddenFields( $blacklist = array() ) { $blacklist = (array)$blacklist; $query = $_GET; foreach ( $blacklist as $name ) { unset( $query[$name] ); } $s = ''; foreach ( $query as $name => $value ) { $encName = htmlspecialchars( $name ); $encValue = htmlspecialchars( $value ); $s .= "\n"; } return $s; } /** * Get a form containing a limit selection dropdown */ function getLimitForm() { # Make the select with some explanatory text $url = $this->getTitle()->escapeLocalURL(); $msgSubmit = wfMsgHtml( 'table_pager_limit_submit' ); return "
" . wfMsgHtml( 'table_pager_limit', $this->getLimitSelect() ) . "\n\n" . $this->getHiddenFields( 'limit' ) . "
\n"; } /** * Return true if the named field should be sortable by the UI, false otherwise * @param string $field */ abstract function isFieldSortable( $field ); /** * Format a table cell. The return value should be HTML, but use an empty string * not   for empty cells. Do not include the and . * * @param string $name The database field name * @param string $value The value retrieved from the database * * The current result row is available as $this->mCurrentRow, in case you need * more context. */ abstract function formatValue( $name, $value ); /** * The database field name used as a default sort order */ abstract function getDefaultSort(); /** * An array mapping database field names to a textual description of the field * name, for use in the table header. The description should be plain text, it * will be HTML-escaped later. */ abstract function getFieldNames(); } ?>