QuickEditProductPropertiesReader
in package
implements
QuickEditProductPropertiesReaderInterface
Class QuickEditProductPropertiesReader
Tags
Interfaces, Classes and Traits
- QuickEditProductPropertiesReaderInterface
- Interface QuickEditProductsPropertiesReaderInterface
Table of Contents
- $brutto : string
- $db : CI_DB_query_builder
- $quickEditPropertiesOverviewColumns : QuickEditPropertiesOverviewColumns
- __construct() : mixed
- QuickEditProductPropertiesReader constructor.
- getFilteredProductProperties() : array<string|int, mixed>
- Returns filtered product properties based on the provided filter criteria.
- getFilteredProductPropertiesCount() : int
- Returns products that are subject to the specified filter criteria.
- getProductPropertiesCount() : int
- Returns the number of all product properties found.
- paginateProperties() : QuickEditProductPropertiesReaderInterface
- Sets the starting point of the pagination and the number of products.
- sortProperties() : QuickEditProductPropertiesReaderInterface
- 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
- _addSqlWhereGroupCondition() : mixed
- Starts and ends a group expression with 'where' 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
$quickEditPropertiesOverviewColumns
protected
QuickEditPropertiesOverviewColumns
$quickEditPropertiesOverviewColumns
Methods
__construct()
QuickEditProductPropertiesReader constructor.
public
__construct(CI_DB_query_builder $db, QuickEditPropertiesOverviewColumns $quickEditPropertiesOverviewColumns) : mixed
Parameters
- $db : CI_DB_query_builder
-
Database query builder instance.
- $quickEditPropertiesOverviewColumns : QuickEditPropertiesOverviewColumns
-
QuickEdit properties overview columns
Return values
mixed —getFilteredProductProperties()
Returns filtered product properties based on the provided filter criteria.
public
getFilteredProductProperties(array<string|int, mixed> $productIds, array<string|int, mixed> $filterParameters) : array<string|int, mixed>
Parameters
- $productIds : array<string|int, mixed>
-
Array containing the selected product IDs to be processed.
- $filterParameters : array<string|int, mixed>
-
Contains the 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.
getFilteredProductPropertiesCount()
Returns products that are subject to the specified filter criteria.
public
getFilteredProductPropertiesCount(array<string|int, mixed> $productIds, array<string|int, mixed> $filterParameters) : int
Parameters
- $productIds : array<string|int, mixed>
-
Array containing the selected product IDs to be processed.
- $filterParameters : array<string|int, mixed>
-
Contains the filter parameters.
Return values
int —Returns the number of product properties found.
getProductPropertiesCount()
Returns the number of all product properties found.
public
getProductPropertiesCount() : int
Return values
int —Returns the record number.
paginateProperties()
Sets the starting point of the pagination and the number of products.
public
paginateProperties([IntType|null $start = null ][, IntType|null $length = null ]) : QuickEditProductPropertiesReaderInterface
Parameters
Return values
QuickEditProductPropertiesReaderInterface —Returns same instance for chained method calls.
sortProperties()
Sets the sorting order of the products
public
sortProperties([StringType|null $orderBy = null ]) : QuickEditProductPropertiesReaderInterface
Parameters
- $orderBy : StringType|null = null
-
Sorting order (ASC or DESC)
Return values
QuickEditProductPropertiesReaderInterface —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(string $column, array<string|int, mixed> $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : array<string|int, mixed>
-
Condition values.
Return values
mixed —_addSqlWhereCondition()
Specifies the where conditions for the database query
protected
_addSqlWhereCondition(string $column, string $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : string
-
Condition value.
Return values
mixed —_addSqlWhereGroupCondition()
Starts and ends a group expression with 'where' condition.
protected
_addSqlWhereGroupCondition(string $column, array<string|int, mixed> $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : array<string|int, mixed>
-
Condition value.
Return values
mixed —_addSqlWhereLessThanCondition()
Starts and ends a group expression with 'less than' condition.
protected
_addSqlWhereLessThanCondition(string $column, string $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : string
-
Condition value.
Return values
mixed —_addSqlWhereLikeCondition()
Starts and ends a group expression with 'like' condition.
protected
_addSqlWhereLikeCondition(string $column, string $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : string
-
Condition value.
Return values
mixed —_addSqlWhereMoreThanCondition()
Starts and ends a group expression with 'more than' condition.
protected
_addSqlWhereMoreThanCondition(string $column, string $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : string
-
Condition value.
Return values
mixed —_addSqlWhereRoundCondition()
Starts and ends a group expression with 'where' condition in conjunction with a round function.
protected
_addSqlWhereRoundCondition(string $column, string $value) : mixed
Parameters
- $column : string
-
Column name.
- $value : string
-
Condition value.
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