SaleQuery

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

Returns a new ChildSaleQuery 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 active column

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

Filter the query on the displayinitialprice column

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

Filter the query on the start_date column

Example usage: $query->filterByStartDate('2011-03-14'); // WHERE startdate = '2011-03-14' $query->filterByStartDate('now'); // WHERE startdate = '2011-03-14' $query->filterByStartDate(array('max' => 'yesterday')); // WHERE start_date > '2011-03-13'

Filter the query on the end_date column

Example usage: $query->filterByEndDate('2011-03-14'); // WHERE enddate = '2011-03-14' $query->filterByEndDate('now'); // WHERE enddate = '2011-03-14' $query->filterByEndDate(array('max' => 'yesterday')); // WHERE end_date > '2011-03-13'

Filter the query on the priceoffsettype column

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

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

Adds a JOIN clause to the query using the SaleOffsetCurrency relation

Use the SaleOffsetCurrency relation SaleOffsetCurrency object

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

Adds a JOIN clause to the query using the SaleProduct relation

Use the SaleProduct relation SaleProduct object

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

Adds a JOIN clause to the query using the SaleI18n relation

Use the SaleI18n relation SaleI18n object

Exclude object from result

Deletes all rows from the sale table.

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

Adds a JOIN clause to the query using the i18n relation

Adds a JOIN clause to the query and hydrates the related I18n object.

Shortcut for $c->joinI18n($locale)->with()

Use the I18n relation query object

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 active column

Order by the displayinitialprice column

Order by the start_date column

Order by the end_date column

Order by the priceoffsettype column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the active column

Group by the displayinitialprice column

Group by the start_date column

Group by the end_date column

Group by the priceoffsettype 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 SaleOffsetCurrency relation

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

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

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

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

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

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

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

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

Return the first ChildSale matching the query

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

Return the first ChildSale filtered by the id column

Return the first ChildSale filtered by the active column

Return the first ChildSale filtered by the displayinitialprice column

Return the first ChildSale filtered by the start_date column

Return the first ChildSale filtered by the end_date column

Return the first ChildSale filtered by the priceoffsettype column

Return the first ChildSale filtered by the created_at column

Return the first ChildSale filtered by the updated_at column

Return ChildSale objects filtered by the id column

Return ChildSale objects filtered by the active column

Return ChildSale objects filtered by the displayinitialprice column

Return ChildSale objects filtered by the start_date column

Return ChildSale objects filtered by the end_date column

Return ChildSale objects filtered by the priceoffsettype column

Return ChildSale objects filtered by the created_at column

Return ChildSale objects filtered by the updated_at column