SaleProductQuery

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

Returns a new ChildSaleProductQuery 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 sale_id column

Example usage: $query->filterBySaleId(1234); // WHERE saleid = 1234 $query->filterBySaleId(array(12, 34)); // WHERE saleid IN (12, 34) $query->filterBySaleId(array('min' => 12)); // WHERE sale_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 attributeavid column

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

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

Adds a JOIN clause to the query using the Sale relation

Use the Sale relation Sale object

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\AttributeAv object

Adds a JOIN clause to the query using the AttributeAv relation

Use the AttributeAv relation AttributeAv object

Exclude object from result

Deletes all rows from the sale_product table.

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

Order by the id column

Order by the sale_id column

Order by the product_id column

Order by the attributeavid column

Group by the id column

Group by the sale_id column

Group by the product_id column

Group by the attributeavid 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 Sale relation

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

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

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 AttributeAv relation

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

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

Return the first ChildSaleProduct matching the query

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

Return the first ChildSaleProduct filtered by the id column

Return the first ChildSaleProduct filtered by the sale_id column

Return the first ChildSaleProduct filtered by the product_id column

Return the first ChildSaleProduct filtered by the attributeavid column

Return ChildSaleProduct objects filtered by the id column

Return ChildSaleProduct objects filtered by the sale_id column

Return ChildSaleProduct objects filtered by the product_id column

Return ChildSaleProduct objects filtered by the attributeavid column