API Documentation
Back to top  

QuickEditProductPropertiesReader

Implements \QuickEditProductPropertiesReaderInterface

Class QuickEditProductPropertiesReader

todo

Improve values_price filtering.
category

System
package

QuickEdit
subpackage

Repositories

Methods

QuickEditProductPropertiesReader constructor.

__construct(\CI_DB_query_builder $db, \QuickEditPropertiesOverviewColumns $quickEditPropertiesOverviewColumns)

Arguments

$db

\CI_DB_query_builder

Database query builder instance.

$quickEditPropertiesOverviewColumns

\QuickEditPropertiesOverviewColumns

QuickEdit properties 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(string $column, array $value)

Arguments

$column

string

Column name.

$value

array

Condition values.

Specifies the where conditions for the database query

_addSqlWhereCondition(string $column, string $value)

Arguments

$column

string

Column name.

$value

string

Condition value.

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

_addSqlWhereGroupCondition(string $column, array $value)

Arguments

$column

string

Column name.

$value

array

Condition value.

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

_addSqlWhereLessThanCondition(string $column, string $value)

Arguments

$column

string

Column name.

$value

string

Condition value.

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

_addSqlWhereLikeCondition(string $column, string $value)

Arguments

$column

string

Column name.

$value

string

Condition value.

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

_addSqlWhereMoreThanCondition(string $column, string $value)

Arguments

$column

string

Column name.

$value

string

Condition value.

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

_addSqlWhereRoundCondition(string $column, string $value)

Arguments

$column

string

Column name.

$value

string

Condition 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 filtered product properties based on the provided filter criteria.

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

Arguments

$productIds

array

Array containing the selected product IDs to be processed.

$filterParameters

array

Contains the filter parameters.

Response

array

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

Returns products that are subject to the specified filter criteria.

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

Arguments

$productIds

array

Array containing the selected product IDs to be processed.

$filterParameters

array

Contains the filter parameters.

Response

integer

Returns the number of product properties found.

Returns the number of all product properties found.

getProductPropertiesCount() : integer

Response

integer

Returns the record number.

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

paginateProperties(\IntType|null $start = null, \IntType|null $length = null) : \QuickEditProductPropertiesReaderInterface

Arguments

$start

\IntType|null

Starting point.

$length

\IntType|null

Number of products.

Response

\QuickEditProductPropertiesReaderInterface

Returns same instance for chained method calls.

Sets the sorting order of the products

sortProperties(\StringType|null $orderBy = null) : \QuickEditProductPropertiesReaderInterface

Arguments

$orderBy

\StringType|null

Sorting order (ASC or DESC)

Response

\QuickEditProductPropertiesReaderInterface

Returns same instance for chained method calls.

Properties

db

db : \CI_DB_query_builder
var

Type(s)

\CI_DB_query_builder

brutto

brutto : string
var

Type(s)

string

quickEditPropertiesOverviewColumns

quickEditPropertiesOverviewColumns : \QuickEditPropertiesOverviewColumns
var

Type(s)

\QuickEditPropertiesOverviewColumns