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.

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

Returns the special prices of the indicated products.

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

Returns the record number of the filtered special prices.

public getSpecialPricesCount( void ) : integer

Get special prices record count.

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

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

public sortSpecialPrices( StringType $orderBy = null ) : QuickEditProductSpecialPricesReaderInterface

Sets the sorting order of the products.

protected _addSqlWhereCondition( $column, $value )

Specifies the where conditions for the database query

protected _addSqlWhereRoundCondition( $column, $value )

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

protected _addSqlWhereDateCondition( $column, array $value )

Sets the 'where date' condition.

protected _addSqlWhereGroupCondition( $column, array $value )

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

protected _addSqlWhereLikeCondition( $column, $value )

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

protected _addSqlWhereBetweenCondition( $column, array $value )

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

protected _addSqlWhereLessThanCondition( $column, $value )

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

protected _addSqlWhereMoreThanCondition( $column, $value )

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

protected _columns( void ) : array

Provides required columns.

protected _join( void )

Specifies the database relationships.

protected _delegateFilterToColumn( void ) : array

Returns the required columns for the overview of the properties.

protected _addAdditionalColumns( void ) : array

Provides additionally required columns.

Properties summary

protected $db : CI_DB_query_builder 

		

		

			
			
				
				protected  
				

				
					$brutto
				

				: string