SpecialOfferReader
extends AbstractDataPaginator
in package
implements
SpecialOfferReaderInterface
Interfaces, Classes and Traits
- SpecialOfferReaderInterface
- Interface SpecialOfferReaderInterface
Table of Contents
- $db : mixed
- $table : string
- __construct() : mixed
- ManufacturerReader constructor.
- _translateOrderByStringIntoArrayOfSorter() : array<string|int, mixed>
- Translate an order by sql instruction into a array of Sorter
- fetchAll() : array<string|int, mixed>|null
- Returns all special offers.
- fetchBy() : array<string|int, mixed>|null
- Fetches special offer data by the given condition.
- fetchById() : array<string|int, mixed>|null
- Fetches special offer data by the given id.
- _applyDefaultSorting() : mixed
- Applies the class default sorting
- _applyPagination() : $this|ProductListProvider
- Applies a pagination (Limit and Offset) clause to the currently building query.
- _applySorting() : $this|ProductListProvider
- Applies a sorting based on sorter param (if sorting is supplied) or apply default sorting.
- _getFieldMap() : mixed
- return the child class Field Map array.
- _parseOrderByString() : array<string|int, mixed>
- Parse an order by sql query into a array with fieldname and direction.
- _translateToDatabaseField() : mixed
- Return the related database field of a given object(Entity) field.
- _translateToJsonFieldName() : string|false
- Parse an order by sql query into a array with fieldname and direction.
Properties
$db
protected
mixed
$db
$table
protected
string
$table
= 'specials'
Methods
__construct()
ManufacturerReader constructor.
public
__construct(CI_DB_query_builder $query_builder) : mixed
Parameters
- $query_builder : CI_DB_query_builder
Return values
mixed —_translateOrderByStringIntoArrayOfSorter()
Translate an order by sql instruction into a array of Sorter
public
_translateOrderByStringIntoArrayOfSorter([StringType|null $orderBy = null ]) : array<string|int, mixed>
Parameters
- $orderBy : StringType|null = null
-
SQL instruction with fields to sort.
Return values
array<string|int, mixed> —of Sorter objects.
fetchAll()
Returns all special offers.
public
fetchAll([Pager|null $pager = null ][, array<string|int, mixed> $sorters = [] ]) : array<string|int, mixed>|null
Parameters
- $pager : Pager|null = null
-
(Optional) Pager object with pagination information
- $sorters : array<string|int, mixed> = []
-
(Optional) array of Sorter objects with data sorting information
Return values
array<string|int, mixed>|null —Raw data of special offers.
fetchBy()
Fetches special offer data by the given condition.
public
fetchBy(StringType $searchCondition[, Pager|null $pager = null ][, array<string|int, mixed> $sorters = [] ]) : array<string|int, mixed>|null
Parameters
- $searchCondition : StringType
-
Search condition for special offer data.
- $pager : Pager|null = null
-
(Optional) Pager object with pagination information
- $sorters : array<string|int, mixed> = []
-
(Optional) array of Sorter objects with data sorting information
Return values
array<string|int, mixed>|null —Raw data of special offers.
fetchById()
Fetches special offer data by the given id.
public
fetchById(IdType $specialOfferId) : array<string|int, mixed>|null
Parameters
- $specialOfferId : IdType
-
Id of expected special offer data.
Return values
array<string|int, mixed>|null —Raw data of a special offer.
_applyDefaultSorting()
Applies the class default sorting
protected
_applyDefaultSorting() : mixed
Return values
mixed —_applyPagination()
Applies a pagination (Limit and Offset) clause to the currently building query.
protected
_applyPagination([Pager|null $pager = null ]) : $this|ProductListProvider
Parameters
- $pager : Pager|null = null
-
(Optional) Pager object with pagination information
Return values
$this|ProductListProvider —Same instance for chained method calls.
_applySorting()
Applies a sorting based on sorter param (if sorting is supplied) or apply default sorting.
protected
_applySorting([array<string|int, mixed> $sorters = [] ]) : $this|ProductListProvider
Parameters
- $sorters : array<string|int, mixed> = []
-
Array of Sorter objects.
Tags
Return values
$this|ProductListProvider —Same instance for chained method calls.
_getFieldMap()
return the child class Field Map array.
protected
_getFieldMap() : mixed
Return values
mixed —_parseOrderByString()
Parse an order by sql query into a array with fieldname and direction.
protected
_parseOrderByString([StringType|null $orderBy = null ]) : array<string|int, mixed>
Parameters
- $orderBy : StringType|null = null
-
SQL order by String
Return values
array<string|int, mixed> —with sort information structured as ['field'=>'', 'direction'=>''].
_translateToDatabaseField()
Return the related database field of a given object(Entity) field.
protected
_translateToDatabaseField(string $fieldName) : mixed
Parameters
- $fieldName : string
-
Object Field name.
Tags
Return values
mixed —_translateToJsonFieldName()
Parse an order by sql query into a array with fieldname and direction.
protected
_translateToJsonFieldName(StringType $databaseFieldName) : string|false
Parameters
- $databaseFieldName : StringType
-
the database field name. It can be supplied as table.fieldName or fieldName.
Return values
string|false —will return the field name or FALSE if the field doesn't exist.