IndexPager is an efficient pager which uses a (roughly unique) index in the data set to implement paging, rather than a "LIMIT offset,limit" clause. More...

Inheritance diagram for IndexPager:

[legend]

Collaboration diagram for IndexPager:

[legend]

Public Member Functions
	__construct (IContextSource $context=null, LinkRenderer $linkRenderer=null)

	doQuery ()
	Do the query, using information from the object context.

	formatRow ( $row)
	Returns an HTML string representing the result row $row.

	getBody ()
	Get the formatted result list.

	getDatabase ()
	Get the Database object in use.

	getDefaultQuery ()
	Get an array of query parameters that should be put into self-links.

	getIndexField ()
	Returns the name of the index field.

	getLimit ()
	Get the current limit.

	getModuleStyles ()
	ResourceLoader modules that must be loaded to provide correct styling for this pager.

	getNavigationBuilder ()

	getNumRows ()
	Get the number of rows in the result set.

	getOffsetQuery ()
	Get the current offset for the URL query parameter.

	getPagingQueries ()
	Get a URL query array for the prev, next, first and last links.

	getQueryInfo ()
	Provides all parameters needed for the main paged query.

	getResult ()

	getResultOffset ()

	reallyDoQuery ( $offset, $limit, $order)
	Do a query with specified parameters, rather than using the object context.

	setIncludeOffset ( $include)
	Set whether a row matching exactly the offset should be also included in the result or not.

	setLimit ( $limit)
	Set the limit from an other source than the request.

	setOffset ( $offset)
	Set the offset from an other source than the request.

Public Member Functions inherited from ContextSource
	canUseWikiPage ()
	Check whether a WikiPage object can be get with getWikiPage().

	exportSession ()
	Export the resolved user IP, HTTP headers, user ID, and session ID.

	getActionName ()
	Get the action name for the current web request.

	getAuthority ()

	getConfig ()

	getContext ()
	Get the base IContextSource object.

	getCsrfTokenSet ()
	Get a repository to obtain and match CSRF tokens.

	getLanguage ()

	getOutput ()

	getRequest ()

	getSkin ()

	getStats ()

	getTiming ()

	getTitle ()

	getUser ()

	getWikiPage ()
	Get the WikiPage object.

	msg ( $key,... $params)
	Get a Message object with context set Parameters are the same as wfMessage()

	setContext (IContextSource $context)

Public Member Functions inherited from Pager
	getNavigationBar ()

Public Attributes
IDatabase	$mDb

bool	$mDefaultDirection
	$mDefaultDirection gives the direction to use when sorting results: DIR_ASCENDING or DIR_DESCENDING.

int	$mDefaultLimit = 50
	The default entry limit choosen for clients.

bool	$mIsBackwards

bool	$mIsFirst
	True if the current result set is the first one.

bool	$mIsLast

int	$mLimit
	The maximum number of entries to show.

int[]	$mLimitsShown = [ 20, 50, 100, 250, 500 ]
	List of default entry limit options to be presented to clients.

mixed	$mOffset
	The starting point to enumerate entries.

stdClass bool null	$mPastTheEndRow
	Extra row fetched at the end to see if the end was reached.

bool	$mQueryDone = false
	Whether the listing query completed.

WebRequest	$mRequest

IResultWrapper	$mResult
	Result object for the query.

const	DIR_ASCENDING = false
	Backwards-compatible constant for $mDefaultDirection field (do not change)

const	DIR_DESCENDING = true
	Backwards-compatible constant for $mDefaultDirection field (do not change)

const	QUERY_ASCENDING = true
	Backwards-compatible constant for reallyDoQuery() (do not change)

const	QUERY_DESCENDING = false
	Backwards-compatible constant for reallyDoQuery() (do not change)

Protected Member Functions
	buildPrevNextNavigation (Title $title, $offset, $limit, array $query=[], $atend=false)
	Generate (prev x\| next x) (20\|50\|100...) type links for paging.

	buildQueryInfo ( $offset, $limit, $order)
	Build variables to use by the database wrapper.

	doBatchLookups ()
	Called from getBody(), before getStartBody() is called and after doQuery() was called.

	extractResultInfo ( $isFirst, $limit, IResultWrapper $res)
	Extract some useful data from the result object for use by the navigation bar, put it into $this.

	getDefaultDirections ()
	Return the default sorting direction: DIR_ASCENDING or DIR_DESCENDING.

	getEmptyBody ()
	Hook into getBody(), for the bit between the start and the end when there are no rows.

	getEndBody ()
	Hook into getBody() for the end of the list.

	getExtraSortFields ()
	Returns the names of secondary columns to order by in addition to the column in getIndexField().

	getFooter ()
	Classes can extend to output a footer at the bottom of the pager list.

	getLimitLinks ()

	getLinkRenderer ()

	getPagingLinks ( $linkTexts, $disabledTexts=[])
	Get paging links.

	getRow ( $row)
	Get the HTML of a pager row.

	getSqlComment ()
	Get some text to go in brackets in the "function name" part of the SQL comment.

	getStartBody ()
	Hook into getBody(), allows text to be inserted at the start.

	isNavigationBarShown ()
	Returns whether to show the "navigation bar".

	makeLink ( $text, array $query=null, $type=null)
	Make a self-link.

	preprocessResults ( $result)
	Pre-process results; useful for performing batch existence checks, etc.

Static Protected Member Functions
static	oppositeOrder ( $order)

Protected Attributes
array	$mDefaultQuery

string[]	$mExtraSortFields
	An array of secondary columns to order by.

array	$mFirstShown

bool	$mIncludeOffset = false
	Whether to include the offset in the query.

string string[]	$mIndexField
	The index to actually be used for ordering.

array	$mLastShown

string	$mNavigationBar

string null	$mOrderType
	For pages that support multiple types of ordering, which one to use.

array	$mPastTheEndIndex

Detailed Description

IndexPager is an efficient pager which uses a (roughly unique) index in the data set to implement paging, rather than a "LIMIT offset,limit" clause.

In MySQL, such a limit/offset clause requires counting through the specified number of offset rows to find the desired data, which can be expensive for large offsets.

ReverseChronologicalPager is a child class of the abstract IndexPager, and contains some formatting and display code which is specific to the use of timestamps as indexes. Here is a synopsis of its operation:

The query is specified by the offset, limit and direction (dir) parameters, in addition to any subclass-specific parameters.
The offset is the non-inclusive start of the DB query. A row with an index value equal to the offset will never be shown.
The query may either be done backwards, where the rows are returned by the database in the opposite order to which they are displayed to the user, or forwards. This is specified by the "dir" parameter, dir=prev means backwards, anything else means forwards. The offset value specifies the start of the database result set, which may be either the start or end of the displayed data set. This allows "previous" links to be implemented without knowledge of the index value at the start of the previous page.
An additional row beyond the user-specified limit is always requested. This allows us to tell whether we should display a "next" link in the case of forwards mode, or a "previous" link in the case of backwards mode. Determining whether to display the other link (the one for the page before the start of the database result set) can be done heuristically by examining the offset.
An empty offset indicates that the offset condition should be omitted from the query. This naturally produces either the first page or the last page depending on the dir parameter.

Subclassing the pager to implement concrete functionality should be fairly simple, please see the examples in HistoryAction.php and SpecialBlockList.php. You just need to override formatRow(), getQueryInfo() and getIndexField(). Don't forget to call the parent constructor if you override it.

Stability: stable: to extend

Definition at line 75 of file IndexPager.php.

Constructor & Destructor Documentation

◆ __construct()

IndexPager::__construct	(	IContextSource	$context = null,
		LinkRenderer	$linkRenderer = null )

Stability: stable: to call

Parameters

IContextSource \| null	$context
LinkRenderer \| null	$linkRenderer

Reimplemented in TablePager.

Definition at line 176 of file IndexPager.php.

References $mOrderType, DB_REPLICA, getDefaultDirections(), getExtraSortFields(), getIndexField(), ContextSource\getRequest(), ContextSource\getUser(), ContextSource\setContext(), and wfGetDB().

Member Function Documentation

◆ buildPrevNextNavigation()

IndexPager::buildPrevNextNavigation	(	Title	$title,
			$offset,
			$limit,
		array	$query = [],
			$atend = false )

protected

Generate (prev x| next x) (20|50|100...) type links for paging.

Deprecated: since 1.39 Use PagerNavigationBuilder instead

Parameters

Title	$title
int	$offset
int	$limit
array	$query	Optional URL query parameter string
bool	$atend	Optional param for specified if this is the last page

Returns: string

Definition at line 1073 of file IndexPager.php.

References $title.

◆ buildQueryInfo()

IndexPager::buildQueryInfo	(	$offset,
		$limit,
		$order )

protected

Build variables to use by the database wrapper.

Note: For b/c, query direction is true for ascending and false for descending

Stability: stable: to override

Parameters

int \| string \| null	$offset	Index offset, inclusive
int	$limit	Exact query limit
bool	$order	IndexPager::QUERY_ASCENDING or IndexPager::QUERY_DESCENDING

Returns: array

Reimplemented in RangeChronologicalPager, and ActiveUsersPager.

Definition at line 475 of file IndexPager.php.

References getQueryInfo(), and getSqlComment().

Referenced by reallyDoQuery(), and ImageListPager\reallyDoQuery().

◆ doBatchLookups()

IndexPager::doBatchLookups ( )

protected

Called from getBody(), before getStartBody() is called and after doQuery() was called.

This will be called only if there are rows in the result set.

Stability: stable: to override

Returns: void

Reimplemented in HistoryPager, ActiveUsersPager, ContribsPager, ImageListPager, MergeHistoryPager, NewFilesPager, and UsersPager.

Definition at line 719 of file IndexPager.php.

◆ doQuery()

IndexPager::doQuery ( )

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.

Stability: stable: to override

Reimplemented in LogPager, and ImageHistoryPseudoPager.

Definition at line 260 of file IndexPager.php.

References $mIncludeOffset, DIR_ASCENDING, extractResultInfo(), oppositeOrder(), preprocessResults(), QUERY_DESCENDING, and reallyDoQuery().

◆ extractResultInfo()

IndexPager::extractResultInfo	(		$isFirst,
			$limit,
		IResultWrapper	$res )

protected

Extract some useful data from the result object for use by the navigation bar, put it into $this.

Stability: stable: to override

Parameters

bool	$isFirst	False if there are rows before those fetched (i.e. if a "previous" link would make sense)
int	$limit	Exact query limit
IResultWrapper	$res

Definition at line 378 of file IndexPager.php.

References $res.

Referenced by doQuery().

◆ formatRow()

IndexPager::formatRow ( $row )

abstract

Returns an HTML string representing the result row $row.

Rows will be concatenated and returned by getBody()

Parameters

array | stdClass $row Database row

Returns: string

Reimplemented in CategoryPager, HistoryPager, LogPager, ImageHistoryPseudoPager, TablePager, ActiveUsersPager, AllMessagesTablePager, ContribsPager, DeletedContribsPager, MergeHistoryPager, NewFilesPager, NewPagesPager, ProtectedTitlesPager, and UsersPager.

◆ getBody()

IndexPager::getBody ( )

Get the formatted result list.

Calls getStartBody(), formatRow() and getEndBody(), concatenates the results and returns them.

Stability: stable: to override

Returns: string

Implements Pager.

Reimplemented in ImageHistoryPseudoPager, TablePager, and CategoryPager.

Definition at line 609 of file IndexPager.php.

References $s.

Referenced by SpecialContributions\execute().

◆ getDatabase()

IndexPager::getDatabase ( )

Get the Database object in use.

Since: 1.20

Returns: IDatabase

Definition at line 249 of file IndexPager.php.

References $mDb.

◆ getDefaultDirections()

IndexPager::getDefaultDirections ( )

protected

Return the default sorting direction: DIR_ASCENDING or DIR_DESCENDING.

You can also have an associative array of ordertype => dir, if multiple order types are supported. In this case getIndexField() must return an array, and the keys of that must exactly match the keys of this.

For backward compatibility, this method's return value will be ignored if $this->mDefaultDirection is already set when the constructor is called, for instance if it's statically initialized. In that case the value of that variable (which must be a boolean) will be used.

Note that despite its name, this does not return the value of the $this->mDefaultDirection member variable. That's the default for this particular instantiation, which is a single value. This is the set of all defaults for the class.

Stability: stable: to override

Returns: bool

Definition at line 1058 of file IndexPager.php.

Referenced by __construct().

◆ getDefaultQuery()

IndexPager::getDefaultQuery ( )

Get an array of query parameters that should be put into self-links.

By default, all parameters passed in the URL are used, apart from a few exceptions.

Stability: stable: to override

Returns: array Associative array

Reimplemented in HistoryPager, LogPager, CategoryPager, ContribsPager, DeletedContribsPager, ImageListPager, and UsersPager.

Definition at line 764 of file IndexPager.php.

◆ getEmptyBody()

IndexPager::getEmptyBody ( )

protected

Hook into getBody(), for the bit between the start and the end when there are no rows.

Stability: stable: to override

Returns: string

Reimplemented in HistoryPager, and TablePager.

Definition at line 751 of file IndexPager.php.

◆ getEndBody()

IndexPager::getEndBody ( )

protected

Hook into getBody() for the end of the list.

Stability: stable: to override

Returns: string

Reimplemented in HistoryPager, TablePager, AllMessagesTablePager, ContribsPager, DeletedContribsPager, MergeHistoryPager, NewFilesPager, and NewPagesPager.

Definition at line 739 of file IndexPager.php.

◆ getExtraSortFields()

IndexPager::getExtraSortFields ( )

protected

Returns the names of secondary columns to order by in addition to the column in getIndexField().

These fields will not be used in the pager offset or in any links for users.

If getIndexField() returns an array of 'querykey' => 'indexfield' pairs then this must return a corresponding array of 'querykey' => [ fields... ] pairs in order for a request with &order=querykey to use [ fields... ] to sort.

If getIndexField() returns a string with the field to sort by, this must either: 1 - return an associative array like above, but only the elements for the current field will be used. 2 - return a non-associative array, for secondary keys to use always.

This is useful for pagers that GROUP BY a unique column (say page_id) and ORDER BY another (say page_len). Using GROUP BY and ORDER BY both on page_len,page_id avoids temp tables (given a page_len index). This would also work if page_id was non-unique but we had a page_len,page_id index.

Stability: stable: to override

Returns: string[]|array[]

Reimplemented in ContribsPager.

Definition at line 1033 of file IndexPager.php.

Referenced by __construct().

◆ getFooter()

IndexPager::getFooter ( )

protected

Classes can extend to output a footer at the bottom of the pager list.

Since: 1.38

Returns: string

Reimplemented in ReverseChronologicalPager.

Definition at line 663 of file IndexPager.php.

◆ getIndexField()

IndexPager::getIndexField ( )

abstract

Returns the name of the index field.

If the pager supports multiple orders, it may return an array of 'querykey' => 'indexfield' pairs, so that a request with &order=querykey will use indexfield to sort. In this case, the first returned key is the default.

Needless to say, it's really not a good idea to use a non-unique index for this! That won't page right.

The pager may paginate on multiple fields in combination. If paginating on multiple fields, they should be unique in combination (e.g. when paginating on user and timestamp, rows may have the same user, rows may have the same timestamp, but rows should all have a different combination of user and timestamp).

Examples:

Always paginate on the user field: 'user'
Paginate on either the user or the timestamp field (default to user): [ 'name' => 'user', 'time' => 'timestamp', ]
Always paginate on the combination of user and timestamp: [ [ 'user', 'timestamp' ] ]
Paginate on the user then timestamp, or the timestamp then user: [ 'nametime' => [ 'user', 'timestamp' ], 'timename' => [ 'timestamp', 'user' ], ]

Returns: string|string[]|array[]

Reimplemented in HistoryPager, LogPager, ImageHistoryPseudoPager, TablePager, ActiveUsersPager, BlockListPager, CategoryPager, ContribsPager, DeletedContribsPager, ImageListPager, MergeHistoryPager, NewFilesPager, NewPagesPager, ProtectedPagesPager, ProtectedTitlesPager, and UsersPager.

Referenced by __construct().

◆ getLimit()

IndexPager::getLimit ( )

Get the current limit.

Returns: int

Definition at line 352 of file IndexPager.php.

References $mLimit.

◆ getLimitLinks()

IndexPager::getLimitLinks ( )

protected

Deprecated: since 1.39 Use PagerNavigationBuilder instead

Returns: string[] HTML

Definition at line 937 of file IndexPager.php.

◆ getLinkRenderer()

IndexPager::getLinkRenderer ( )

protected

Since: 1.34

Returns: LinkRenderer

Definition at line 1089 of file IndexPager.php.

Referenced by CategoryPager\formatRow(), NewFilesPager\formatRow(), AllMessagesTablePager\formatValue(), ProtectedPagesPager\formatValue(), and BlockListPager\formatValue().

◆ getModuleStyles()

IndexPager::getModuleStyles ( )

ResourceLoader modules that must be loaded to provide correct styling for this pager.

Stability: stable: to override

Since: 1.38

Returns: string[]

Reimplemented in TablePager.

Definition at line 653 of file IndexPager.php.

◆ getNavigationBuilder()

IndexPager::getNavigationBuilder ( )

Stability: stable: to override

Since: 1.39

Returns: PagerNavigationBuilder

Definition at line 852 of file IndexPager.php.

Referenced by AlphabeticPager\getNavigationBar().

◆ getNumRows()

IndexPager::getNumRows ( )

Get the number of rows in the result set.

Returns: int

Definition at line 783 of file IndexPager.php.

Referenced by SpecialContributions\execute(), HistoryPager\getEndBody(), HistoryPager\getStartBody(), LogPager\getStartBody(), HistoryPager\isNavigationBarShown(), SpecialAutoblockList\showList(), and SpecialBlockList\showList().

◆ getOffsetQuery()

IndexPager::getOffsetQuery ( )

Get the current offset for the URL query parameter.

Stability: stable: to override

Since: 1.39

Returns: string

Definition at line 839 of file IndexPager.php.

◆ getPagingLinks()

IndexPager::getPagingLinks	(		$linkTexts,
			$disabledTexts = [] )

protected

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.

Deprecated: since 1.39 Use PagerNavigationBuilder instead

Parameters

array	$linkTexts
array	$disabledTexts

Returns: string[] HTML

Definition at line 914 of file IndexPager.php.

References $type.

◆ getPagingQueries()

IndexPager::getPagingQueries ( )

Get a URL query array for the prev, next, first and last links.

Stability: stable: to override

Returns: array

Reimplemented in ImageListPager.

Definition at line 797 of file IndexPager.php.

Referenced by TablePager\getNavigationBar().

◆ getQueryInfo()

IndexPager::getQueryInfo ( )

abstract

Provides 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 join_conds => JOIN conditions

Returns: array

Reimplemented in HistoryPager, LogPager, ImageHistoryPseudoPager, AllMessagesTablePager, BlockListPager, CategoryPager, ContribsPager, DeletedContribsPager, ImageListPager, MergeHistoryPager, NewFilesPager, NewPagesPager, ProtectedPagesPager, ProtectedTitlesPager, and UsersPager.

Referenced by buildQueryInfo().

◆ getResult()

IndexPager::getResult ( )

Returns: IResultWrapper The result wrapper.

Definition at line 307 of file IndexPager.php.

References $mResult.

◆ getResultOffset()

IndexPager::getResultOffset ( )

Returns: int The current offset into the result. Valid during formatRow().

Definition at line 314 of file IndexPager.php.

Referenced by HistoryPager\formatRow(), ProtectedPagesPager\formatValue(), and BlockListPager\formatValue().

◆ getRow()

IndexPager::getRow ( $row )

protected

Get the HTML of a pager row.

Stability: stable: to override

Since: 1.38

Parameters

stdClass $row

Returns: string

Reimplemented in ReverseChronologicalPager.

Definition at line 597 of file IndexPager.php.

◆ getSqlComment()

IndexPager::getSqlComment ( )

protected

Get some text to go in brackets in the "function name" part of the SQL comment.

Stability: stable: to override

Returns: string

Reimplemented in HistoryPager, and ContribsPager.

Definition at line 440 of file IndexPager.php.

Referenced by buildQueryInfo(), ActiveUsersPager\buildQueryInfo(), and ActiveUsersPager\getQueryInfo().

◆ getStartBody()

IndexPager::getStartBody ( )

protected

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.

Returns: string

Reimplemented in HistoryPager, LogPager, TablePager, AllMessagesTablePager, ContribsPager, DeletedContribsPager, MergeHistoryPager, NewFilesPager, NewPagesPager, and ProtectedTitlesPager.

Definition at line 728 of file IndexPager.php.

◆ isNavigationBarShown()

IndexPager::isNavigationBarShown ( )

protected

Returns whether to show the "navigation bar".

Stability: stable: to override

Returns: bool

Reimplemented in HistoryPager.

Definition at line 895 of file IndexPager.php.

Referenced by AlphabeticPager\getNavigationBar(), and TablePager\getNavigationBar().

◆ makeLink()

IndexPager::makeLink	(		$text,
		array	$query = null,
			$type = null )

protected

Make a self-link.

To support the deprecated overrides, any override of this method is used by the builder (see getNavigationBuilder()) to make the links. This is deprecated and will be removed. You should override getNavigationBuilder() instead to return a customized builder.

Stability: stable: to override (deprecated since 1.39)

Stability: stable: to call (since 1.39)

Parameters

string	$text	Text displayed on the link
array \| null	$query	Associative array of parameter to be in the query string. If null, no link is generated.
string \| null	$type	Link type used to create additional attributes, like "rel", "class" or "title". Valid values (non-exhaustive list): 'first', 'last', 'prev', 'next', 'asc', 'desc'.

Returns: string HTML fragment

Definition at line 684 of file IndexPager.php.

References $type, and getTitle().

Referenced by TablePager\getStartBody().

◆ oppositeOrder()

static IndexPager::oppositeOrder ( $order )

staticfinalprotected

Parameters

bool $order One of the IndexPager::QUERY_* class constants

Returns: bool The opposite query order as an IndexPager::QUERY_ constant

Definition at line 298 of file IndexPager.php.

References QUERY_ASCENDING, and QUERY_DESCENDING.

Referenced by doQuery().

◆ preprocessResults()

IndexPager::preprocessResults ( $result )

protected

Pre-process results; useful for performing batch existence checks, etc.

Stability: stable: to override

Parameters

IResultWrapper $result

Reimplemented in BlockListPager, and ProtectedPagesPager.

Definition at line 586 of file IndexPager.php.

Referenced by doQuery().

◆ reallyDoQuery()

IndexPager::reallyDoQuery	(	$offset,
		$limit,
		$order )

Do a query with specified parameters, rather than using the object context.

Note: For b/c, query direction is true for ascending and false for descending

Stability: stable: to override

Parameters

string	$offset	Index offset, inclusive
int	$limit	Exact query limit
bool	$order	IndexPager::QUERY_ASCENDING or IndexPager::QUERY_DESCENDING

Returns: IResultWrapper

Reimplemented in AllMessagesTablePager, ContribsPager, DeletedContribsPager, and ImageListPager.

Definition at line 456 of file IndexPager.php.

References buildQueryInfo().

Referenced by doQuery().

◆ setIncludeOffset()

IndexPager::setIncludeOffset ( $include )

Set whether a row matching exactly the offset should be also included in the result or not.

By default this is not the case, but when the offset is user-supplied this might be wanted.

Parameters

bool $include

Definition at line 363 of file IndexPager.php.

Referenced by CategoryPager\__construct().

◆ setLimit()

IndexPager::setLimit ( $limit )

Set the limit from an other source than the request.

Verifies limit is between 1 and 5000

Stability: stable: to override

Parameters

int | string $limit

Definition at line 336 of file IndexPager.php.

Referenced by NewFilesPager\__construct().

◆ setOffset()

IndexPager::setOffset ( $offset )

Set the offset from an other source than the request.

Parameters

int | string $offset

Definition at line 323 of file IndexPager.php.

Referenced by CategoryPager\__construct().

Member Data Documentation

◆ $mDb

IDatabase IndexPager::$mDb

Definition at line 101 of file IndexPager.php.

Referenced by getDatabase().

◆ $mDefaultDirection

bool IndexPager::$mDefaultDirection

$mDefaultDirection gives the direction to use when sorting results: DIR_ASCENDING or DIR_DESCENDING.

If $mIsBackwards is set, we start from the opposite end, but we still sort the page itself according to $mDefaultDirection. For example, if $mDefaultDirection is DIR_ASCENDING but we're going backwards, we'll display the last page of results, but the last result will be at the bottom, not the top.

Like $mIndexField, $mDefaultDirection will be a single value even if the class supports multiple default directions for different order types.

Definition at line 134 of file IndexPager.php.

◆ $mDefaultLimit

int IndexPager::$mDefaultLimit = 50

The default entry limit choosen for clients.

Definition at line 93 of file IndexPager.php.

◆ $mDefaultQuery

array IndexPager::$mDefaultQuery

protected

Definition at line 150 of file IndexPager.php.

Referenced by CategoryPager\getDefaultQuery().

◆ $mExtraSortFields

string [] IndexPager::$mExtraSortFields

protected

An array of secondary columns to order by.

These fields are not part of the offset. This is a column list for one ordering, even if multiple orderings are supported.

Definition at line 117 of file IndexPager.php.

◆ $mFirstShown

array IndexPager::$mFirstShown

protected

Definition at line 146 of file IndexPager.php.

◆ $mIncludeOffset

bool IndexPager::$mIncludeOffset = false

protected

Whether to include the offset in the query.

Definition at line 158 of file IndexPager.php.

Referenced by doQuery().

◆ $mIndexField

string string [] IndexPager::$mIndexField

protected

The index to actually be used for ordering.

This can be a single column, an array of single columns, or an array of arrays of columns. See getIndexField for more details.

Definition at line 111 of file IndexPager.php.

Referenced by ImageListPager\reallyDoQuery().

◆ $mIsBackwards

bool IndexPager::$mIsBackwards

Definition at line 136 of file IndexPager.php.

◆ $mIsFirst

bool IndexPager::$mIsFirst

True if the current result set is the first one.

Definition at line 139 of file IndexPager.php.

◆ $mIsLast

bool IndexPager::$mIsLast

Definition at line 141 of file IndexPager.php.

◆ $mLastShown

array IndexPager::$mLastShown

protected

Definition at line 144 of file IndexPager.php.

◆ $mLimit

int IndexPager::$mLimit

The maximum number of entries to show.

Definition at line 97 of file IndexPager.php.

Referenced by getLimit(), TablePager\getLimitSelectList(), and TablePager\getStartBody().

◆ $mLimitsShown

int [] IndexPager::$mLimitsShown = [ 20, 50, 100, 250, 500 ]

List of default entry limit options to be presented to clients.

Definition at line 91 of file IndexPager.php.

◆ $mNavigationBar

string IndexPager::$mNavigationBar

protected

Definition at line 152 of file IndexPager.php.

Referenced by AlphabeticPager\getNavigationBar().

◆ $mOffset

mixed IndexPager::$mOffset

The starting point to enumerate entries.

Definition at line 95 of file IndexPager.php.

Referenced by RangeChronologicalPager\getDateCond().

◆ $mOrderType

string null IndexPager::$mOrderType

protected

For pages that support multiple types of ordering, which one to use.

Definition at line 121 of file IndexPager.php.

Referenced by __construct().

◆ $mPastTheEndIndex

array IndexPager::$mPastTheEndIndex

protected

Definition at line 148 of file IndexPager.php.

◆ $mPastTheEndRow

stdClass bool null IndexPager::$mPastTheEndRow

Extra row fetched at the end to see if the end was reached.

Definition at line 103 of file IndexPager.php.

◆ $mQueryDone

bool IndexPager::$mQueryDone = false

Whether the listing query completed.

Definition at line 99 of file IndexPager.php.

◆ $mRequest

WebRequest IndexPager::$mRequest

Definition at line 89 of file IndexPager.php.

◆ $mResult

IResultWrapper IndexPager::$mResult

Result object for the query.

Warning: seek before use.

Definition at line 165 of file IndexPager.php.

Referenced by getResult().

◆ DIR_ASCENDING

const IndexPager::DIR_ASCENDING = false

Backwards-compatible constant for $mDefaultDirection field (do not change)

Definition at line 79 of file IndexPager.php.

Referenced by ImageListPager\__construct(), UsersPager\__construct(), TablePager\__construct(), and doQuery().

◆ DIR_DESCENDING

const IndexPager::DIR_DESCENDING = true

Backwards-compatible constant for $mDefaultDirection field (do not change)

Definition at line 81 of file IndexPager.php.

Referenced by BlockListPager\__construct(), ImageListPager\__construct(), UsersPager\__construct(), AllMessagesTablePager\__construct(), TablePager\__construct(), and TablePager\getStartBody().

◆ QUERY_ASCENDING

const IndexPager::QUERY_ASCENDING = true

Backwards-compatible constant for reallyDoQuery() (do not change)

Definition at line 84 of file IndexPager.php.

Referenced by oppositeOrder(), and AllMessagesTablePager\reallyDoQuery().

◆ QUERY_DESCENDING

const IndexPager::QUERY_DESCENDING = false

Backwards-compatible constant for reallyDoQuery() (do not change)

Definition at line 86 of file IndexPager.php.

Referenced by doQuery(), and oppositeOrder().

The documentation for this class was generated from the following file:

includes/pager/IndexPager.php

Public Member Functions

Public Attributes

Protected Member Functions

Static Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ buildPrevNextNavigation()

◆ buildQueryInfo()

◆ doBatchLookups()

◆ doQuery()

◆ extractResultInfo()

◆ formatRow()

◆ getBody()

◆ getDatabase()

◆ getDefaultDirections()

◆ getDefaultQuery()

◆ getEmptyBody()

◆ getEndBody()

◆ getExtraSortFields()

◆ getFooter()

◆ getIndexField()

◆ getLimit()

◆ getLimitLinks()

◆ getLinkRenderer()

◆ getModuleStyles()

◆ getNavigationBuilder()

◆ getNumRows()

◆ getOffsetQuery()

◆ getPagingLinks()

◆ getPagingQueries()

◆ getQueryInfo()

◆ getResult()

◆ getResultOffset()

◆ getRow()

◆ getSqlComment()

◆ getStartBody()

◆ isNavigationBarShown()

◆ makeLink()

◆ oppositeOrder()

◆ preprocessResults()

◆ reallyDoQuery()

◆ setIncludeOffset()

◆ setLimit()

◆ setOffset()

Member Data Documentation

◆ $mDb

◆ $mDefaultDirection

◆ $mDefaultLimit

◆ $mDefaultQuery

◆ $mExtraSortFields

◆ $mFirstShown

◆ $mIncludeOffset

◆ $mIndexField

◆ $mIsBackwards

◆ $mIsFirst

◆ $mIsLast

◆ $mLastShown

◆ $mLimit

◆ $mLimitsShown

◆ $mNavigationBar

◆ $mOffset

◆ $mOrderType

◆ $mPastTheEndIndex

◆ $mPastTheEndRow

◆ $mQueryDone

◆ $mRequest

◆ $mResult

◆ DIR_ASCENDING

◆ DIR_DESCENDING

◆ QUERY_ASCENDING

◆ QUERY_DESCENDING