ZenMagick 0.9.10


org.zenmagick.core.services.database\ZMQueryPager
core\services\database\ZMQueryPager.php at line 29

Class ZMQueryPager

ZMObject
└─ZMQueryPager

public class ZMQueryPager
extends ZMObject

Paginate a query.

Author:
DerManoMann

Fields inherited from org.zenmagick.core\ZMObject
properties_
Method Summary
void

__construct(ZMQueryDetails queryDetails)

Create new instance for the given query.

void

addFilter(string filter)

Add a filter clause.

protected string

getFilterSQL()

Get the filter conditions.

array

getResults(int page, int pagination)

Get results.

int

getTotalNumberOfResults()

Get total number of results.

void

setOrderBy(string orderBy)

Set order by clause(s).

Methods inherited from org.zenmagick.core\ZMObject
__construct, attachMethod, get, getAttachedMethods, getProperties, getPropertyNames, set, singleton

Method Detail

core\services\database\ZMQueryPager.php at line 41

__construct

public void __construct(ZMQueryDetails queryDetails)

Create new instance for the given query.

Parameters:
queryDetails - The query details.

core\services\database\ZMQueryPager.php at line 62

addFilter

public void addFilter(string filter)

Add a filter clause.

Parameters:
filter - The filter condition.

core\services\database\ZMQueryPager.php at line 71

getFilterSQL

protected string getFilterSQL()

Get the filter conditions.

Returns:
The sql.

core\services\database\ZMQueryPager.php at line 156

getResults

public array getResults(int page, int pagination)

Get results.

Parameters:
page - The page number to retreive.
pagination - The number of results per page.
Returns:
A list of results.

core\services\database\ZMQueryPager.php at line 87

getTotalNumberOfResults

public int getTotalNumberOfResults()

Get total number of results.

Returns:
The total number of results available.

core\services\database\ZMQueryPager.php at line 53

setOrderBy

public void setOrderBy(string orderBy)

Set order by clause(s).

Parameters:
orderBy - The order by condition(s).

ZenMagick 0.9.10