API Documentation » \QuickEditProductSpecialPricesReader

category	System
package	QuickEdit
subpackage	Repositories

QuickEditProductsSpecialPriceReader constructor.

__construct(\CI_DB_query_builder $db, \QuickEditSpecialPricesOverviewColumns $quickEditSpecialPricesOverviewColumns)

Arguments

$db

\CI_DB_query_builder

Database query builder instance.

$quickEditSpecialPricesOverviewColumns

\QuickEditSpecialPricesOverviewColumns

QuickEdit special price overview columns

Provides additionally required columns.

_addAdditionalColumns() : array

Response

array

Returns an array of the additional columns.

Starts and ends a group expression with 'where between' condition.

_addSqlWhereBetweenCondition( $column, array $value)

Arguments

$column

Column.

$value

array

Value.

Specifies the where conditions for the database query

_addSqlWhereCondition( $column,  $value)

Arguments

$column

Column.

$value

Value.

Sets the 'where date' condition.

_addSqlWhereDateCondition( $column, array $value)

Arguments

$column

Column.

$value

array

Value.

Starts and ends a group expression with 'where group' condition.

_addSqlWhereGroupCondition( $column, array $value)

Arguments

$column

Column.

$value

array

Value.

Starts and ends a group expression with 'less than' condition.

_addSqlWhereLessThanCondition( $column,  $value)

Arguments

$column

Column.

$value

Value.

Starts and ends a group expression with 'like' condition.

_addSqlWhereLikeCondition( $column,  $value)

Arguments

$column

Column.

$value

Value.

Starts and ends a group expression with 'more than' condition.

_addSqlWhereMoreThanCondition( $column,  $value)

Arguments

$column

Column.

$value

Value.

Starts and ends a group expression with 'where' condition in conjunction with a round function.

_addSqlWhereRoundCondition( $column,  $value)

Arguments

$column

Column.

$value

Value.

Provides required columns.

_columns() : array

Response

array

Returns an array of the required columns.

Returns the required columns for the overview of the properties.

_delegateFilterToColumn() : array

Response

array

Returns an array of the required columns for the overview of the properties.

Specifies the database relationships.

_join()

Returns the special prices of the indicated products.

getFilteredSpecialPrices(array $productIds, array $filterParameters) : array

Arguments

$productIds

array

Array containing the product IDs to be processed.

$filterParameters

array

Contains filter parameters.

Response

array

Returns the query result as a pure array, or an empty array when no result is produced.

Returns the record number of the filtered special prices.

getFilteredSpecialPricesCount(array $productIds, array $filterParameters) : integer

Arguments

$productIds

array

Array containing the product IDs to be processed.

$filterParameters

array

Contains filter parameters.

Response

integer

Returns the number of special prices found.

Get special prices record count.

getSpecialPricesCount() : integer

Response

integer

Returns the number of all special prices found.

Sets the starting point of the pagination and the number of products.

paginateSpecialPrices(\IntType|null $start = null, \IntType|null $length = null) : \QuickEditProductSpecialPricesReaderInterface

Arguments

$start

\IntType|null

Starting point.

$length

\IntType|null

Number of products.

Response

\QuickEditProductSpecialPricesReaderInterface

Returns same instance for chained method calls.

Sets the sorting order of the products.

sortSpecialPrices(\StringType|null $orderBy = null) : \QuickEditProductSpecialPricesReaderInterface

Arguments

$orderBy

\StringType|null

Sorting order (ASC or DESC)

Response

\QuickEditProductSpecialPricesReaderInterface

Returns same instance for chained method calls.

db

db : \CI_DB_query_builder

var

Type(s)

\CI_DB_query_builder

brutto

brutto : string

var

Type(s)

string

quickEditSpecialPricesOverviewColumns

quickEditSpecialPricesOverviewColumns : \QuickEditSpecialPricesOverviewColumns

var

Type(s)

\QuickEditSpecialPricesOverviewColumns

QuickEditProductSpecialPricesReader

Methods

QuickEditProductsSpecialPriceReader constructor.

Arguments

$db

$quickEditSpecialPricesOverviewColumns

Provides additionally required columns.

Response

Starts and ends a group expression with 'where between' condition.

Arguments

$column

$value

Specifies the where conditions for the database query

Arguments

$column

$value

Sets the 'where date' condition.

Arguments

$column

$value

Starts and ends a group expression with 'where group' condition.

Arguments

$column

$value

Starts and ends a group expression with 'less than' condition.

Arguments

$column

$value

Starts and ends a group expression with 'like' condition.

Arguments

$column

$value

Starts and ends a group expression with 'more than' condition.

Arguments

$column

$value

Starts and ends a group expression with 'where' condition in conjunction with a round function.

Arguments

$column

$value

Provides required columns.

Response

Returns the required columns for the overview of the properties.

Response

Specifies the database relationships.

Returns the special prices of the indicated products.

Arguments

$productIds

$filterParameters

Response

Returns the record number of the filtered special prices.

Arguments

$productIds

$filterParameters

Response

Get special prices record count.

Response

Sets the starting point of the pagination and the number of products.

Arguments

$start

$length

Response

Sets the sorting order of the products.

Arguments

$orderBy

Response

Properties

db

Type(s)

brutto

Type(s)

quickEditSpecialPricesOverviewColumns

Type(s)