QuickEditProductSpecialPricesReader
in package
implements
QuickEditProductSpecialPricesReaderInterface
Class QuickEditProductSpecialPricesReader
Tags
Interfaces, Classes and Traits
- QuickEditProductSpecialPricesReaderInterface
- Interface QuickEditProductSpecialPricesReaderInterface
Table of Contents
- $brutto : string
- $db : CI_DB_query_builder
- $quickEditSpecialPricesOverviewColumns : QuickEditSpecialPricesOverviewColumns
- __construct() : mixed
- QuickEditProductsSpecialPriceReader constructor.
- getFilteredSpecialPrices() : array<string|int, mixed>
- Returns the special prices of the indicated products.
- getFilteredSpecialPricesCount() : int
- Returns the record number of the filtered special prices.
- getSpecialPricesCount() : int
- Get special prices record count.
- paginateSpecialPrices() : QuickEditProductSpecialPricesReaderInterface
- Sets the starting point of the pagination and the number of products.
- sortSpecialPrices() : QuickEditProductSpecialPricesReaderInterface
- Sets the sorting order of the products.
- _addAdditionalColumns() : array<string|int, mixed>
- Provides additionally required columns.
- _addSqlWhereBetweenCondition() : mixed
- Starts and ends a group expression with 'where between' condition.
- _addSqlWhereCondition() : mixed
- Specifies the where conditions for the database query
- _addSqlWhereDateCondition() : mixed
- Sets the 'where date' condition.
- _addSqlWhereGroupCondition() : mixed
- Starts and ends a group expression with 'where group' condition.
- _addSqlWhereLessThanCondition() : mixed
- Starts and ends a group expression with 'less than' condition.
- _addSqlWhereLikeCondition() : mixed
- Starts and ends a group expression with 'like' condition.
- _addSqlWhereMoreThanCondition() : mixed
- Starts and ends a group expression with 'more than' condition.
- _addSqlWhereRoundCondition() : mixed
- Starts and ends a group expression with 'where' condition in conjunction with a round function.
- _columns() : array<string|int, mixed>
- Provides required columns.
- _delegateFilterToColumn() : array<string|int, mixed>
- Returns the required columns for the overview of the properties.
- _join() : mixed
- Specifies the database relationships.
Properties
$brutto
protected
string
$brutto
$db
protected
CI_DB_query_builder
$db
$quickEditSpecialPricesOverviewColumns
protected
QuickEditSpecialPricesOverviewColumns
$quickEditSpecialPricesOverviewColumns
Methods
__construct()
QuickEditProductsSpecialPriceReader constructor.
public
__construct(CI_DB_query_builder $db, QuickEditSpecialPricesOverviewColumns $quickEditSpecialPricesOverviewColumns) : mixed
Parameters
- $db : CI_DB_query_builder
-
Database query builder instance.
- $quickEditSpecialPricesOverviewColumns : QuickEditSpecialPricesOverviewColumns
-
QuickEdit special price overview columns
Return values
mixed —getFilteredSpecialPrices()
Returns the special prices of the indicated products.
public
getFilteredSpecialPrices(array<string|int, mixed> $productIds, array<string|int, mixed> $filterParameters) : array<string|int, mixed>
Parameters
- $productIds : array<string|int, mixed>
-
Array containing the product IDs to be processed.
- $filterParameters : array<string|int, mixed>
-
Contains filter parameters.
Return values
array<string|int, mixed> —Returns the query result as a pure array, or an empty array when no result is produced.
getFilteredSpecialPricesCount()
Returns the record number of the filtered special prices.
public
getFilteredSpecialPricesCount(array<string|int, mixed> $productIds, array<string|int, mixed> $filterParameters) : int
Parameters
- $productIds : array<string|int, mixed>
-
Array containing the product IDs to be processed.
- $filterParameters : array<string|int, mixed>
-
Contains filter parameters.
Return values
int —Returns the number of special prices found.
getSpecialPricesCount()
Get special prices record count.
public
getSpecialPricesCount() : int
Return values
int —Returns the number of all special prices found.
paginateSpecialPrices()
Sets the starting point of the pagination and the number of products.
public
paginateSpecialPrices([IntType|null $start = null ][, IntType|null $length = null ]) : QuickEditProductSpecialPricesReaderInterface
Parameters
Return values
QuickEditProductSpecialPricesReaderInterface —Returns same instance for chained method calls.
sortSpecialPrices()
Sets the sorting order of the products.
public
sortSpecialPrices([StringType|null $orderBy = null ]) : QuickEditProductSpecialPricesReaderInterface
Parameters
- $orderBy : StringType|null = null
-
Sorting order (ASC or DESC)
Return values
QuickEditProductSpecialPricesReaderInterface —Returns same instance for chained method calls.
_addAdditionalColumns()
Provides additionally required columns.
protected
_addAdditionalColumns() : array<string|int, mixed>
Return values
array<string|int, mixed> —Returns an array of the additional columns.
_addSqlWhereBetweenCondition()
Starts and ends a group expression with 'where between' condition.
protected
_addSqlWhereBetweenCondition( $column, array<string|int, mixed> $value) : mixed
Parameters
Return values
mixed —_addSqlWhereCondition()
Specifies the where conditions for the database query
protected
_addSqlWhereCondition( $column, $value) : mixed
Parameters
Return values
mixed —_addSqlWhereDateCondition()
Sets the 'where date' condition.
protected
_addSqlWhereDateCondition( $column, array<string|int, mixed> $value) : mixed
Parameters
Return values
mixed —_addSqlWhereGroupCondition()
Starts and ends a group expression with 'where group' condition.
protected
_addSqlWhereGroupCondition( $column, array<string|int, mixed> $value) : mixed
Parameters
Return values
mixed —_addSqlWhereLessThanCondition()
Starts and ends a group expression with 'less than' condition.
protected
_addSqlWhereLessThanCondition( $column, $value) : mixed
Parameters
Return values
mixed —_addSqlWhereLikeCondition()
Starts and ends a group expression with 'like' condition.
protected
_addSqlWhereLikeCondition( $column, $value) : mixed
Parameters
Return values
mixed —_addSqlWhereMoreThanCondition()
Starts and ends a group expression with 'more than' condition.
protected
_addSqlWhereMoreThanCondition( $column, $value) : mixed
Parameters
Return values
mixed —_addSqlWhereRoundCondition()
Starts and ends a group expression with 'where' condition in conjunction with a round function.
protected
_addSqlWhereRoundCondition( $column, $value) : mixed
Parameters
Return values
mixed —_columns()
Provides required columns.
protected
_columns() : array<string|int, mixed>
Return values
array<string|int, mixed> —Returns an array of the required columns.
_delegateFilterToColumn()
Returns the required columns for the overview of the properties.
protected
_delegateFilterToColumn() : array<string|int, mixed>
Return values
array<string|int, mixed> —Returns an array of the required columns for the overview of the properties.
_join()
Specifies the database relationships.
protected
_join() : mixed