ProductSaleElementsQuery

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

Returns a new ChildProductSaleElementsQuery object.

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);

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

Filter the query by primary key

Filter the query by a list of primary keys

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

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

Filter the query on the ref column

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

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

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

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

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

Filter the query on the is_default column

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

Filter the query on the ean_code column

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

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'

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'

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

Adds a JOIN clause to the query using the Product relation

Use the Product relation Product object

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

Adds a JOIN clause to the query using the AttributeCombination relation

Use the AttributeCombination relation AttributeCombination object

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

Adds a JOIN clause to the query using the CartItem relation

Use the CartItem relation CartItem object

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

Adds a JOIN clause to the query using the ProductPrice relation

Use the ProductPrice relation ProductPrice object

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

Adds a JOIN clause to the query using the ProductSaleElementsProductImage relation

Use the ProductSaleElementsProductImage relation ProductSaleElementsProductImage object

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

Adds a JOIN clause to the query using the ProductSaleElementsProductDocument relation

Use the ProductSaleElementsProductDocument relation ProductSaleElementsProductDocument object

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

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

Exclude object from result

Deletes all rows from the productsaleelements table.

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

Filter by the latest updated

Filter by the latest created

Order by update date desc

Order by update date asc

Order by create date desc

Order by create date asc

Order by the id column

Order by the product_id column

Order by the ref column

Order by the quantity column

Order by the promo column

Order by the newness column

Order by the weight column

Order by the is_default column

Order by the ean_code column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the product_id column

Group by the ref column

Group by the quantity column

Group by the promo column

Group by the newness column

Group by the weight column

Group by the is_default column

Group by the ean_code column

Group by the created_at column

Group by the updated_at column

Adds a LEFT JOIN clause to the query

Adds a RIGHT JOIN clause to the query

Adds a INNER JOIN clause to the query

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Return the first ChildProductSaleElements matching the query

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

Return the first ChildProductSaleElements filtered by the id column

Return the first ChildProductSaleElements filtered by the product_id column

Return the first ChildProductSaleElements filtered by the ref column

Return the first ChildProductSaleElements filtered by the quantity column

Return the first ChildProductSaleElements filtered by the promo column

Return the first ChildProductSaleElements filtered by the newness column

Return the first ChildProductSaleElements filtered by the weight column

Return the first ChildProductSaleElements filtered by the is_default column

Return the first ChildProductSaleElements filtered by the ean_code column

Return the first ChildProductSaleElements filtered by the created_at column

Return the first ChildProductSaleElements filtered by the updated_at column

Return ChildProductSaleElements objects filtered by the id column

Return ChildProductSaleElements objects filtered by the product_id column

Return ChildProductSaleElements objects filtered by the ref column

Return ChildProductSaleElements objects filtered by the quantity column

Return ChildProductSaleElements objects filtered by the promo column

Return ChildProductSaleElements objects filtered by the newness column

Return ChildProductSaleElements objects filtered by the weight column

Return ChildProductSaleElements objects filtered by the is_default column

Return ChildProductSaleElements objects filtered by the ean_code column

Return ChildProductSaleElements objects filtered by the created_at column

Return ChildProductSaleElements objects filtered by the updated_at column