class ProductSaleElementsQuery extends ProductSaleElementsQuery

Skeleton subclass for performing query and update operations on the 'productsaleelements' table.

You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.

Methods

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\ProductSaleElements', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\ProductSaleElementsQuery object.

create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProductSaleElementsQuery object.

ProductSaleElements|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByProductId( mixed $productId = null, string $comparison = null)

Filter the query on the product_id column

filterByRef( string $ref = null, string $comparison = null)

Filter the query on the ref column

filterByQuantity( mixed $quantity = null, string $comparison = null)

Filter the query on the quantity column

filterByPromo( mixed $promo = null, string $comparison = null)

Filter the query on the promo column

filterByNewness( mixed $newness = null, string $comparison = null)

Filter the query on the newness column

filterByWeight( mixed $weight = null, string $comparison = null)

Filter the query on the weight column

filterByIsDefault( boolean|string $isDefault = null, string $comparison = null)

Filter the query on the is_default column

filterByEanCode( string $eanCode = null, string $comparison = null)

Filter the query on the ean_code column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByProduct( Product|ObjectCollection $product, string $comparison = null)

Filter the query by a related \Thelia\Model\Product object

joinProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Product relation

useProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Product relation Product object

filterByAttributeCombination( AttributeCombination|ObjectCollection $attributeCombination, string $comparison = null)

Filter the query by a related \Thelia\Model\AttributeCombination object

joinAttributeCombination( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AttributeCombination relation

useAttributeCombinationQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AttributeCombination relation AttributeCombination object

filterByCartItem( CartItem|ObjectCollection $cartItem, string $comparison = null)

Filter the query by a related \Thelia\Model\CartItem object

joinCartItem( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the CartItem relation

useCartItemQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the CartItem relation CartItem object

filterByProductPrice( ProductPrice|ObjectCollection $productPrice, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductPrice object

joinProductPrice( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductPrice relation

useProductPriceQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductPrice relation ProductPrice object

filterByProductSaleElementsProductImage( ProductSaleElementsProductImage|ObjectCollection $productSaleElementsProductImage, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductSaleElementsProductImage object

joinProductSaleElementsProductImage( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElementsProductImage relation

useProductSaleElementsProductImageQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElementsProductImage relation ProductSaleElementsProductImage object

filterByProductSaleElementsProductDocument( ProductSaleElementsProductDocument|ObjectCollection $productSaleElementsProductDocument, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductSaleElementsProductDocument object

joinProductSaleElementsProductDocument( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElementsProductDocument relation

useProductSaleElementsProductDocumentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElementsProductDocument relation ProductSaleElementsProductDocument object

filterByProductImage( ProductImage $productImage, string $comparison = Criteria::EQUAL)

Filter the query by a related ProductImage object using the productsaleelementsproductimage table as cross reference

filterByProductDocument( ProductDocument $productDocument, string $comparison = Criteria::EQUAL)

Filter the query by a related ProductDocument object using the productsaleelementsproductdocument table as cross reference

prune( ProductSaleElements $productSaleElements = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the productsaleelements table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildProductSaleElements or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

ChildProductSaleElementsQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildProductSaleElementsQuery
orderByProductId($order = Criteria::ASC)

Order by the product_id column

ChildProductSaleElementsQuery
orderByRef($order = Criteria::ASC)

Order by the ref column

ChildProductSaleElementsQuery
orderByQuantity($order = Criteria::ASC)

Order by the quantity column

ChildProductSaleElementsQuery
orderByPromo($order = Criteria::ASC)

Order by the promo column

ChildProductSaleElementsQuery
orderByNewness($order = Criteria::ASC)

Order by the newness column

ChildProductSaleElementsQuery
orderByWeight($order = Criteria::ASC)

Order by the weight column

ChildProductSaleElementsQuery
orderByIsDefault($order = Criteria::ASC)

Order by the is_default column

ChildProductSaleElementsQuery
orderByEanCode($order = Criteria::ASC)

Order by the ean_code column

ChildProductSaleElementsQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildProductSaleElementsQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildProductSaleElementsQuery
groupById()

Group by the id column

ChildProductSaleElementsQuery
groupByProductId()

Group by the product_id column

ChildProductSaleElementsQuery
groupByRef()

Group by the ref column

ChildProductSaleElementsQuery
groupByQuantity()

Group by the quantity column

ChildProductSaleElementsQuery
groupByPromo()

Group by the promo column

ChildProductSaleElementsQuery
groupByNewness()

Group by the newness column

ChildProductSaleElementsQuery
groupByWeight()

Group by the weight column

ChildProductSaleElementsQuery
groupByIsDefault()

Group by the is_default column

ChildProductSaleElementsQuery
groupByEanCode()

Group by the ean_code column

ChildProductSaleElementsQuery
groupByCreatedAt()

Group by the created_at column

ChildProductSaleElementsQuery
groupByUpdatedAt()

Group by the updated_at column

ChildProductSaleElementsQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildProductSaleElementsQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildProductSaleElementsQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildProductSaleElementsQuery
leftJoinProduct($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Product relation

ChildProductSaleElementsQuery
rightJoinProduct($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Product relation

ChildProductSaleElementsQuery
innerJoinProduct($relationAlias = null)

Adds a INNER JOIN clause to the query using the Product relation

ChildProductSaleElementsQuery
leftJoinAttributeCombination($relationAlias = null)

Adds a LEFT JOIN clause to the query using the AttributeCombination relation

ChildProductSaleElementsQuery
rightJoinAttributeCombination($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the AttributeCombination relation

ChildProductSaleElementsQuery
innerJoinAttributeCombination($relationAlias = null)

Adds a INNER JOIN clause to the query using the AttributeCombination relation

ChildProductSaleElementsQuery
leftJoinCartItem($relationAlias = null)

Adds a LEFT JOIN clause to the query using the CartItem relation

ChildProductSaleElementsQuery
rightJoinCartItem($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the CartItem relation

ChildProductSaleElementsQuery
innerJoinCartItem($relationAlias = null)

Adds a INNER JOIN clause to the query using the CartItem relation

ChildProductSaleElementsQuery
leftJoinProductPrice($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductPrice relation

ChildProductSaleElementsQuery
rightJoinProductPrice($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductPrice relation

ChildProductSaleElementsQuery
innerJoinProductPrice($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductPrice relation

ChildProductSaleElementsQuery
leftJoinProductSaleElementsProductImage($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductImage relation

ChildProductSaleElementsQuery
rightJoinProductSaleElementsProductImage($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductImage relation

ChildProductSaleElementsQuery
innerJoinProductSaleElementsProductImage($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductSaleElementsProductImage relation

ChildProductSaleElementsQuery
leftJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductDocument relation

ChildProductSaleElementsQuery
rightJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductDocument relation

ChildProductSaleElementsQuery
innerJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductSaleElementsProductDocument relation

ChildProductSaleElements
findOne( ConnectionInterface $con = null)

Return the first ChildProductSaleElements matching the query

ChildProductSaleElements
findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildProductSaleElements matching the query, or a new ChildProductSaleElements object populated from the query conditions when no match is found

ChildProductSaleElements
findOneById( int $id)

Return the first ChildProductSaleElements filtered by the id column

ChildProductSaleElements
findOneByProductId( int $product_id)

Return the first ChildProductSaleElements filtered by the product_id column

ChildProductSaleElements
findOneByRef( string $ref)

Return the first ChildProductSaleElements filtered by the ref column

ChildProductSaleElements
findOneByQuantity( double $quantity)

Return the first ChildProductSaleElements filtered by the quantity column

ChildProductSaleElements
findOneByPromo( int $promo)

Return the first ChildProductSaleElements filtered by the promo column

ChildProductSaleElements
findOneByNewness( int $newness)

Return the first ChildProductSaleElements filtered by the newness column

ChildProductSaleElements
findOneByWeight( double $weight)

Return the first ChildProductSaleElements filtered by the weight column

ChildProductSaleElements
findOneByIsDefault( boolean $is_default)

Return the first ChildProductSaleElements filtered by the is_default column

ChildProductSaleElements
findOneByEanCode( string $ean_code)

Return the first ChildProductSaleElements filtered by the ean_code column

ChildProductSaleElements
findOneByCreatedAt( string $created_at)

Return the first ChildProductSaleElements filtered by the created_at column

ChildProductSaleElements
findOneByUpdatedAt( string $updated_at)

Return the first ChildProductSaleElements filtered by the updated_at column

array
findById( int $id)

Return ChildProductSaleElements objects filtered by the id column

array
findByProductId( int $product_id)

Return ChildProductSaleElements objects filtered by the product_id column

array
findByRef( string $ref)

Return ChildProductSaleElements objects filtered by the ref column

array
findByQuantity( double $quantity)

Return ChildProductSaleElements objects filtered by the quantity column

array
findByPromo( int $promo)

Return ChildProductSaleElements objects filtered by the promo column

array
findByNewness( int $newness)

Return ChildProductSaleElements objects filtered by the newness column

array
findByWeight( double $weight)

Return ChildProductSaleElements objects filtered by the weight column

array
findByIsDefault( boolean $is_default)

Return ChildProductSaleElements objects filtered by the is_default column

array
findByEanCode( string $ean_code)

Return ChildProductSaleElements objects filtered by the ean_code column

array
findByCreatedAt( string $created_at)

Return ChildProductSaleElements objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildProductSaleElements objects filtered by the updated_at column

Details

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\ProductSaleElements', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\ProductSaleElementsQuery object.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

static ProductSaleElementsQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProductSaleElementsQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

ProductSaleElementsQuery

ProductSaleElements|array|mixed findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

Propel uses the instance pool to skip the database if the object exists. Go fast if the query is untouched.

$obj = $c->findPk(12, $con);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

ProductSaleElements|array|mixed the result, formatted by the current formatter

ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

ProductSaleElementsQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

Example usage: $query->filterById(1234); // WHERE id = 1234 $query->filterById(array(12, 34)); // WHERE id IN (12, 34) $query->filterById(array('min' => 12)); // WHERE id > 12

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByProductId( mixed $productId = null, string $comparison = null)

Filter the query on the product_id column

Example usage: $query->filterByProductId(1234); // WHERE productid = 1234 $query->filterByProductId(array(12, 34)); // WHERE productid IN (12, 34) $query->filterByProductId(array('min' => 12)); // WHERE product_id > 12

Parameters

mixed $productId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

See also

filterByProduct()

ProductSaleElementsQuery filterByRef( string $ref = null, string $comparison = null)

Filter the query on the ref column

Example usage: $query->filterByRef('fooValue'); // WHERE ref = 'fooValue' $query->filterByRef('%fooValue%'); // WHERE ref LIKE '%fooValue%'

Parameters

string $ref The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByQuantity( mixed $quantity = null, string $comparison = null)

Filter the query on the quantity column

Example usage: $query->filterByQuantity(1234); // WHERE quantity = 1234 $query->filterByQuantity(array(12, 34)); // WHERE quantity IN (12, 34) $query->filterByQuantity(array('min' => 12)); // WHERE quantity > 12

Parameters

mixed $quantity The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByPromo( mixed $promo = null, string $comparison = null)

Filter the query on the promo column

Example usage: $query->filterByPromo(1234); // WHERE promo = 1234 $query->filterByPromo(array(12, 34)); // WHERE promo IN (12, 34) $query->filterByPromo(array('min' => 12)); // WHERE promo > 12

Parameters

mixed $promo The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByNewness( mixed $newness = null, string $comparison = null)

Filter the query on the newness column

Example usage: $query->filterByNewness(1234); // WHERE newness = 1234 $query->filterByNewness(array(12, 34)); // WHERE newness IN (12, 34) $query->filterByNewness(array('min' => 12)); // WHERE newness > 12

Parameters

mixed $newness The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByWeight( mixed $weight = null, string $comparison = null)

Filter the query on the weight column

Example usage: $query->filterByWeight(1234); // WHERE weight = 1234 $query->filterByWeight(array(12, 34)); // WHERE weight IN (12, 34) $query->filterByWeight(array('min' => 12)); // WHERE weight > 12

Parameters

mixed $weight The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByIsDefault( boolean|string $isDefault = null, string $comparison = null)

Filter the query on the is_default column

Example usage: $query->filterByIsDefault(true); // WHERE isdefault = true $query->filterByIsDefault('yes'); // WHERE isdefault = true

Parameters

boolean|string $isDefault The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByEanCode( string $eanCode = null, string $comparison = null)

Filter the query on the ean_code column

Example usage: $query->filterByEanCode('fooValue'); // WHERE eancode = 'fooValue' $query->filterByEanCode('%fooValue%'); // WHERE eancode LIKE '%fooValue%'

Parameters

string $eanCode The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

Example usage: $query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

Example usage: $query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery filterByProduct( Product|ObjectCollection $product, string $comparison = null)

Filter the query by a related \Thelia\Model\Product object

Parameters

Product|ObjectCollection $product The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery joinProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Product relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductQuery useProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Product relation Product object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery A secondary query class using the current class as primary query

See also

useQuery()

ProductSaleElementsQuery filterByAttributeCombination( AttributeCombination|ObjectCollection $attributeCombination, string $comparison = null)

Filter the query by a related \Thelia\Model\AttributeCombination object

Parameters

AttributeCombination|ObjectCollection $attributeCombination the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery joinAttributeCombination( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AttributeCombination relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

AttributeCombinationQuery useAttributeCombinationQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AttributeCombination relation AttributeCombination object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AttributeCombinationQuery A secondary query class using the current class as primary query

See also

useQuery()

ProductSaleElementsQuery filterByCartItem( CartItem|ObjectCollection $cartItem, string $comparison = null)

Filter the query by a related \Thelia\Model\CartItem object

Parameters

CartItem|ObjectCollection $cartItem the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery joinCartItem( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the CartItem relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

CartItemQuery useCartItemQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the CartItem relation CartItem object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CartItemQuery A secondary query class using the current class as primary query

See also

useQuery()

ProductSaleElementsQuery filterByProductPrice( ProductPrice|ObjectCollection $productPrice, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductPrice object

Parameters

ProductPrice|ObjectCollection $productPrice the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductSaleElementsQuery joinProductPrice( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductPrice relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ProductPriceQuery useProductPriceQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductPrice relation ProductPrice object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductPriceQuery A secondary query class using the current class as primary query

See also

useQuery()

in ProductSaleElementsQuery at line 1000
ProductSaleElementsQuery filterByProductSaleElementsProductImage( ProductSaleElementsProductImage|ObjectCollection $productSaleElementsProductImage, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductSaleElementsProductImage object

Parameters

ProductSaleElementsProductImage|ObjectCollection $productSaleElementsProductImage the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1023
ProductSaleElementsQuery joinProductSaleElementsProductImage( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElementsProductImage relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1058
ProductSaleElementsProductImageQuery useProductSaleElementsProductImageQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElementsProductImage relation ProductSaleElementsProductImage object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsProductImageQuery A secondary query class using the current class as primary query

See also

useQuery()

in ProductSaleElementsQuery at line 1073
ProductSaleElementsQuery filterByProductSaleElementsProductDocument( ProductSaleElementsProductDocument|ObjectCollection $productSaleElementsProductDocument, string $comparison = null)

Filter the query by a related \Thelia\Model\ProductSaleElementsProductDocument object

Parameters

ProductSaleElementsProductDocument|ObjectCollection $productSaleElementsProductDocument the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1096
ProductSaleElementsQuery joinProductSaleElementsProductDocument( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElementsProductDocument relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1131
ProductSaleElementsProductDocumentQuery useProductSaleElementsProductDocumentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElementsProductDocument relation ProductSaleElementsProductDocument object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsProductDocumentQuery A secondary query class using the current class as primary query

See also

useQuery()

in ProductSaleElementsQuery at line 1147
ProductSaleElementsQuery filterByProductImage( ProductImage $productImage, string $comparison = Criteria::EQUAL)

Filter the query by a related ProductImage object using the productsaleelementsproductimage table as cross reference

Parameters

ProductImage $productImage the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1164
ProductSaleElementsQuery filterByProductDocument( ProductDocument $productDocument, string $comparison = Criteria::EQUAL)

Filter the query by a related ProductDocument object using the productsaleelementsproductdocument table as cross reference

Parameters

ProductDocument $productDocument the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1179
ProductSaleElementsQuery prune( ProductSaleElements $productSaleElements = null)

Exclude object from result

Parameters

ProductSaleElements $productSaleElements Object to remove from the list of results

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1194
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the productsaleelements table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

in ProductSaleElementsQuery at line 1231
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildProductSaleElements or Criteria object OR a primary key value.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

in ProductSaleElementsQuery at line 1272
ProductSaleElementsQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1284
ProductSaleElementsQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1294
ProductSaleElementsQuery lastUpdatedFirst()

Order by update date desc

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1304
ProductSaleElementsQuery firstUpdatedFirst()

Order by update date asc

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1314
ProductSaleElementsQuery lastCreatedFirst()

Order by create date desc

Return Value

ProductSaleElementsQuery The current query, for fluid interface

in ProductSaleElementsQuery at line 1324
ProductSaleElementsQuery firstCreatedFirst()

Order by create date asc

Return Value

ProductSaleElementsQuery The current query, for fluid interface

ChildProductSaleElementsQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByProductId($order = Criteria::ASC)

Order by the product_id column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByRef($order = Criteria::ASC)

Order by the ref column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByQuantity($order = Criteria::ASC)

Order by the quantity column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByPromo($order = Criteria::ASC)

Order by the promo column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByNewness($order = Criteria::ASC)

Order by the newness column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByWeight($order = Criteria::ASC)

Order by the weight column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByIsDefault($order = Criteria::ASC)

Order by the is_default column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByEanCode($order = Criteria::ASC)

Order by the ean_code column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupById()

Group by the id column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByProductId()

Group by the product_id column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByRef()

Group by the ref column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByQuantity()

Group by the quantity column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByPromo()

Group by the promo column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByNewness()

Group by the newness column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByWeight()

Group by the weight column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByIsDefault()

Group by the is_default column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByEanCode()

Group by the ean_code column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinProduct($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinProduct($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinProduct($relationAlias = null)

Adds a INNER JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinAttributeCombination($relationAlias = null)

Adds a LEFT JOIN clause to the query using the AttributeCombination relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinAttributeCombination($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the AttributeCombination relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinAttributeCombination($relationAlias = null)

Adds a INNER JOIN clause to the query using the AttributeCombination relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinCartItem($relationAlias = null)

Adds a LEFT JOIN clause to the query using the CartItem relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinCartItem($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the CartItem relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinCartItem($relationAlias = null)

Adds a INNER JOIN clause to the query using the CartItem relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinProductPrice($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductPrice relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinProductPrice($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductPrice relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinProductPrice($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductPrice relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinProductSaleElementsProductImage($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductImage relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinProductSaleElementsProductImage($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductImage relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinProductSaleElementsProductImage($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductSaleElementsProductImage relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery leftJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductDocument relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery rightJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductDocument relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElementsQuery innerJoinProductSaleElementsProductDocument($relationAlias = null)

Adds a INNER JOIN clause to the query using the ProductSaleElementsProductDocument relation

Parameters

$relationAlias

Return Value

ChildProductSaleElementsQuery

ChildProductSaleElements findOne( ConnectionInterface $con = null)

Return the first ChildProductSaleElements matching the query

Parameters

ConnectionInterface $con

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildProductSaleElements matching the query, or a new ChildProductSaleElements object populated from the query conditions when no match is found

Parameters

ConnectionInterface $con

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneById( int $id)

Return the first ChildProductSaleElements filtered by the id column

Parameters

int $id

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByProductId( int $product_id)

Return the first ChildProductSaleElements filtered by the product_id column

Parameters

int $product_id

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByRef( string $ref)

Return the first ChildProductSaleElements filtered by the ref column

Parameters

string $ref

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByQuantity( double $quantity)

Return the first ChildProductSaleElements filtered by the quantity column

Parameters

double $quantity

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByPromo( int $promo)

Return the first ChildProductSaleElements filtered by the promo column

Parameters

int $promo

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByNewness( int $newness)

Return the first ChildProductSaleElements filtered by the newness column

Parameters

int $newness

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByWeight( double $weight)

Return the first ChildProductSaleElements filtered by the weight column

Parameters

double $weight

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByIsDefault( boolean $is_default)

Return the first ChildProductSaleElements filtered by the is_default column

Parameters

boolean $is_default

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByEanCode( string $ean_code)

Return the first ChildProductSaleElements filtered by the ean_code column

Parameters

string $ean_code

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByCreatedAt( string $created_at)

Return the first ChildProductSaleElements filtered by the created_at column

Parameters

string $created_at

Return Value

ChildProductSaleElements

ChildProductSaleElements findOneByUpdatedAt( string $updated_at)

Return the first ChildProductSaleElements filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildProductSaleElements

array findById( int $id)

Return ChildProductSaleElements objects filtered by the id column

Parameters

int $id

Return Value

array

array findByProductId( int $product_id)

Return ChildProductSaleElements objects filtered by the product_id column

Parameters

int $product_id

Return Value

array

array findByRef( string $ref)

Return ChildProductSaleElements objects filtered by the ref column

Parameters

string $ref

Return Value

array

array findByQuantity( double $quantity)

Return ChildProductSaleElements objects filtered by the quantity column

Parameters

double $quantity

Return Value

array

array findByPromo( int $promo)

Return ChildProductSaleElements objects filtered by the promo column

Parameters

int $promo

Return Value

array

array findByNewness( int $newness)

Return ChildProductSaleElements objects filtered by the newness column

Parameters

int $newness

Return Value

array

array findByWeight( double $weight)

Return ChildProductSaleElements objects filtered by the weight column

Parameters

double $weight

Return Value

array

array findByIsDefault( boolean $is_default)

Return ChildProductSaleElements objects filtered by the is_default column

Parameters

boolean $is_default

Return Value

array

array findByEanCode( string $ean_code)

Return ChildProductSaleElements objects filtered by the ean_code column

Parameters

string $ean_code

Return Value

array

array findByCreatedAt( string $created_at)

Return ChildProductSaleElements objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

array findByUpdatedAt( string $updated_at)

Return ChildProductSaleElements objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array