Class QuickEditProductSpecialPricesReader

Class QuickEditProductSpecialPricesReader

QuickEditProductSpecialPricesReader implements QuickEditProductSpecialPricesReaderInterface

Package: QuickEdit\Repositories
Category: System
Located at Services/Core/QuickEdit/Repositories/Reader/QuickEditProductSpecialPricesReader.inc.php

Methods summary

`public`	# `__construct( CI_DB_query_builder $db, QuickEditSpecialPricesOverviewColumns $quickEditSpecialPricesOverviewColumns )` QuickEditProductsSpecialPriceReader constructor. QuickEditProductsSpecialPriceReader constructor. Parameters `$db` Database query builder instance. `$quickEditSpecialPricesOverviewColumns` QuickEdit special price overview columns
`public array`	# `getFilteredSpecialPrices( array $productIds, array $filterParameters )` Returns the special prices of the indicated products. Returns the special prices of the indicated products. Parameters `$productIds` Array containing the product IDs to be processed. `$filterParameters` Contains filter parameters. Returns array Returns the query result as a pure array, or an empty array when no result is produced. Implementation of `QuickEditProductSpecialPricesReaderInterface::getFilteredSpecialPrices()`
`public integer`	# `getFilteredSpecialPricesCount( array $productIds, array $filterParameters )` Returns the record number of the filtered special prices. Returns the record number of the filtered special prices. Parameters `$productIds` Array containing the product IDs to be processed. `$filterParameters` Contains filter parameters. Returns integer Returns the number of special prices found. Implementation of `QuickEditProductSpecialPricesReaderInterface::getFilteredSpecialPricesCount()`
`public integer`	# `getSpecialPricesCount( )` Get special prices record count. Get special prices record count. Returns integer Returns the number of all special prices found. Implementation of `QuickEditProductSpecialPricesReaderInterface::getSpecialPricesCount()`
`public QuickEditProductSpecialPricesReaderInterface`	# `paginateSpecialPrices( IntType $start = null, IntType $length = null )` Sets the starting point of the pagination and the number of products. Sets the starting point of the pagination and the number of products. Parameters `$start` Starting point. `$length` Number of products. Returns `QuickEditProductSpecialPricesReaderInterface` Returns same instance for chained method calls. Implementation of `QuickEditProductSpecialPricesReaderInterface::paginateSpecialPrices()`
`public QuickEditProductSpecialPricesReaderInterface`	# `sortSpecialPrices( StringType $orderBy = null )` Sets the sorting order of the products. Sets the sorting order of the products. Parameters `$orderBy` Sorting order (ASC or DESC) Returns `QuickEditProductSpecialPricesReaderInterface` Returns same instance for chained method calls. Implementation of `QuickEditProductSpecialPricesReaderInterface::sortSpecialPrices()`
`protected`	# `_addSqlWhereCondition( $column, $value )` Specifies the where conditions for the database query Specifies the where conditions for the database query Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereRoundCondition( $column, $value )` Starts and ends a group expression with 'where' condition in conjunction with a round function. Starts and ends a group expression with 'where' condition in conjunction with a round function. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereDateCondition( $column, array $value )` Sets the 'where date' condition. Sets the 'where date' condition. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereGroupCondition( $column, array $value )` Starts and ends a group expression with 'where group' condition. Starts and ends a group expression with 'where group' condition. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereLikeCondition( $column, $value )` Starts and ends a group expression with 'like' condition. Starts and ends a group expression with 'like' condition. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereBetweenCondition( $column, array $value )` Starts and ends a group expression with 'where between' condition. Starts and ends a group expression with 'where between' condition. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereLessThanCondition( $column, $value )` Starts and ends a group expression with 'less than' condition. Starts and ends a group expression with 'less than' condition. Parameters `$column` Column. `$value` Value.
`protected`	# `_addSqlWhereMoreThanCondition( $column, $value )` Starts and ends a group expression with 'more than' condition. Starts and ends a group expression with 'more than' condition. Parameters `$column` Column. `$value` Value.
`protected array`	# `_columns( )` Provides required columns. Provides required columns. Returns array Returns an array of the required columns.
`protected`	# `_join( )` Specifies the database relationships. Specifies the database relationships.
`protected array`	# `_delegateFilterToColumn( )` Returns the required columns for the overview of the properties. Returns the required columns for the overview of the properties. Returns array Returns an array of the required columns for the overview of the properties.
`protected array`	# `_addAdditionalColumns( )` Provides additionally required columns. Provides additionally required columns. Returns array Returns an array of the additional columns.

Properties summary

`protected CI_DB_query_builder`	`$db`	#
`protected string`	`$brutto`	#
`protected QuickEditSpecialPricesOverviewColumns`	`$quickEditSpecialPricesOverviewColumns`	#