Package DE_EPAGES::Search::API::Object::PagerSearch
object interface for Search.
Base |
DE_EPAGES::Presentation::API::Object::Pager |
@EXPORT_OK |
Functions
- ReplaceWildcards
- allItems
- countItems
- items
- new
- sortObjects
- sqlFrom
- sqlSelect
- sqlSelectCount
- sqlSort
- sqlWhere
ReplaceWildcards
replaces * with % and adds on begin and end a %.
Syntax |
my $SQLString = ReplaceWildcards($SearchString); |
Input |
|
Return |
|
allItems
Returns all objects of all pages.
Syntax |
$aItems = $Pager->allItems; |
Return |
|
countItems
returns how many items should be paged.
Syntax |
$Object->countItems; |
Return |
|
items
load all objects of a page.
Syntax |
my $aItems = $Object->items($PageNumber); |
Input |
|
Return |
|
new
Creates a new search pager object.
Syntax |
$Object = $Package->new($hInfo); |
Input |
|
Return |
|
sortObjects
this function overwrites the standard sort, because the results are already sorted by SQL server to show the right objects at the right page. This function does nothing else.
Syntax |
my $aObjects = $Object->sortObjects($aObjects); |
Input |
|
Return |
|
sqlFrom
returns the from part of sql statement
Syntax |
my $From = $Object->sqlFrom; |
Return |
|
sqlSelect
returns the select part of the sql statement for result columns
Syntax |
my $Select = $Object->sqlSelect; |
Return |
|
sqlSelectCount
returns the select part of the sql statement for count of results
Syntax |
my $SelectCount = $Object->sqlSelectCount; |
Return |
|
sqlSort
returns the OrderBy part of sql statement
Syntax |
my $OrderBy = $Object->sqlSort; |
Return |
|
sqlWhere
returns the where part of sql statement
Syntax |
my $Where = $Object->sqlWhere; |
Return |
|