class SaleQuery extends ModelCriteria

Base class that represents a query for the 'sale' table.

Methods

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

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

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

Returns a new ChildSaleQuery object.

Sale|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

filterByActive( boolean|string $active = null, string $comparison = null)

Filter the query on the active column

filterByDisplayInitialPrice( boolean|string $displayInitialPrice = null, string $comparison = null)

Filter the query on the displayinitialprice column

filterByStartDate( mixed $startDate = null, string $comparison = null)

Filter the query on the start_date column

filterByEndDate( mixed $endDate = null, string $comparison = null)

Filter the query on the end_date column

filterByPriceOffsetType( mixed $priceOffsetType = null, string $comparison = null)

Filter the query on the priceoffsettype 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

filterBySaleOffsetCurrency( SaleOffsetCurrency|ObjectCollection $saleOffsetCurrency, string $comparison = null)

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

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

Adds a JOIN clause to the query using the SaleOffsetCurrency relation

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

Use the SaleOffsetCurrency relation SaleOffsetCurrency object

filterBySaleProduct( SaleProduct|ObjectCollection $saleProduct, string $comparison = null)

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

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

Adds a JOIN clause to the query using the SaleProduct relation

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

Use the SaleProduct relation SaleProduct object

filterBySaleI18n( SaleI18n|ObjectCollection $saleI18n, string $comparison = null)

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

joinSaleI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the SaleI18n relation

useSaleI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the SaleI18n relation SaleI18n object

prune( Sale $sale = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the sale table.

int
delete( ConnectionInterface $con = null)

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

joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

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

useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildSaleQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildSaleQuery
orderByActive($order = Criteria::ASC)

Order by the active column

ChildSaleQuery
orderByDisplayInitialPrice($order = Criteria::ASC)

Order by the displayinitialprice column

ChildSaleQuery
orderByStartDate($order = Criteria::ASC)

Order by the start_date column

ChildSaleQuery
orderByEndDate($order = Criteria::ASC)

Order by the end_date column

ChildSaleQuery
orderByPriceOffsetType($order = Criteria::ASC)

Order by the priceoffsettype column

ChildSaleQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildSaleQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildSaleQuery
groupById()

Group by the id column

ChildSaleQuery
groupByActive()

Group by the active column

ChildSaleQuery
groupByDisplayInitialPrice()

Group by the displayinitialprice column

ChildSaleQuery
groupByStartDate()

Group by the start_date column

ChildSaleQuery
groupByEndDate()

Group by the end_date column

ChildSaleQuery
groupByPriceOffsetType()

Group by the priceoffsettype column

ChildSaleQuery
groupByCreatedAt()

Group by the created_at column

ChildSaleQuery
groupByUpdatedAt()

Group by the updated_at column

ChildSaleQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildSaleQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildSaleQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildSaleQuery
leftJoinSaleOffsetCurrency($relationAlias = null)

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

ChildSaleQuery
rightJoinSaleOffsetCurrency($relationAlias = null)

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

ChildSaleQuery
innerJoinSaleOffsetCurrency($relationAlias = null)

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

ChildSaleQuery
leftJoinSaleProduct($relationAlias = null)

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

ChildSaleQuery
rightJoinSaleProduct($relationAlias = null)

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

ChildSaleQuery
innerJoinSaleProduct($relationAlias = null)

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

ChildSaleQuery
leftJoinSaleI18n($relationAlias = null)

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

ChildSaleQuery
rightJoinSaleI18n($relationAlias = null)

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

ChildSaleQuery
innerJoinSaleI18n($relationAlias = null)

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

ChildSale
findOne( ConnectionInterface $con = null)

Return the first ChildSale matching the query

ChildSale
findOneOrCreate( ConnectionInterface $con = null)

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

ChildSale
findOneById( int $id)

Return the first ChildSale filtered by the id column

ChildSale
findOneByActive( boolean $active)

Return the first ChildSale filtered by the active column

ChildSale
findOneByDisplayInitialPrice( boolean $display_initial_price)

Return the first ChildSale filtered by the displayinitialprice column

ChildSale
findOneByStartDate( string $start_date)

Return the first ChildSale filtered by the start_date column

ChildSale
findOneByEndDate( string $end_date)

Return the first ChildSale filtered by the end_date column

ChildSale
findOneByPriceOffsetType( int $price_offset_type)

Return the first ChildSale filtered by the priceoffsettype column

ChildSale
findOneByCreatedAt( string $created_at)

Return the first ChildSale filtered by the created_at column

ChildSale
findOneByUpdatedAt( string $updated_at)

Return the first ChildSale filtered by the updated_at column

array
findById( int $id)

Return ChildSale objects filtered by the id column

array
findByActive( boolean $active)

Return ChildSale objects filtered by the active column

array
findByDisplayInitialPrice( boolean $display_initial_price)

Return ChildSale objects filtered by the displayinitialprice column

array
findByStartDate( string $start_date)

Return ChildSale objects filtered by the start_date column

array
findByEndDate( string $end_date)

Return ChildSale objects filtered by the end_date column

array
findByPriceOffsetType( int $price_offset_type)

Return ChildSale objects filtered by the priceoffsettype column

array
findByCreatedAt( string $created_at)

Return ChildSale objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildSale objects filtered by the updated_at column

Details

at line 91
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\Sale', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\SaleQuery 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'

at line 104
static SaleQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildSaleQuery object.

Parameters

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

Return Value

SaleQuery

at line 134
Sale|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

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

at line 216
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

at line 237
SaleQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

SaleQuery The current query, for fluid interface

at line 250
SaleQuery 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

SaleQuery The current query, for fluid interface

at line 274
SaleQuery 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

SaleQuery The current query, for fluid interface

at line 315
SaleQuery filterByActive( boolean|string $active = null, string $comparison = null)

Filter the query on the active column

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

Parameters

boolean|string $active 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

SaleQuery The current query, for fluid interface

at line 342
SaleQuery filterByDisplayInitialPrice( boolean|string $displayInitialPrice = null, string $comparison = null)

Filter the query on the displayinitialprice column

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

Parameters

boolean|string $displayInitialPrice 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

SaleQuery The current query, for fluid interface

at line 371
SaleQuery filterByStartDate( mixed $startDate = null, string $comparison = null)

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'

Parameters

mixed $startDate 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

SaleQuery The current query, for fluid interface

at line 414
SaleQuery filterByEndDate( mixed $endDate = null, string $comparison = null)

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'

Parameters

mixed $endDate 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

SaleQuery The current query, for fluid interface

at line 455
SaleQuery filterByPriceOffsetType( mixed $priceOffsetType = null, string $comparison = null)

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

Parameters

mixed $priceOffsetType 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

SaleQuery The current query, for fluid interface

at line 498
SaleQuery 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

SaleQuery The current query, for fluid interface

at line 541
SaleQuery 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

SaleQuery The current query, for fluid interface

at line 572
SaleQuery filterBySaleOffsetCurrency( SaleOffsetCurrency|ObjectCollection $saleOffsetCurrency, string $comparison = null)

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

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 595
SaleQuery joinSaleOffsetCurrency( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the SaleOffsetCurrency relation

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 630
SaleOffsetCurrencyQuery useSaleOffsetCurrencyQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the SaleOffsetCurrency relation SaleOffsetCurrency 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

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

See also

useQuery()

at line 645
SaleQuery filterBySaleProduct( SaleProduct|ObjectCollection $saleProduct, string $comparison = null)

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

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 668
SaleQuery joinSaleProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the SaleProduct relation

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 703
SaleProductQuery useSaleProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the SaleProduct relation SaleProduct 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

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

See also

useQuery()

at line 718
SaleQuery filterBySaleI18n( SaleI18n|ObjectCollection $saleI18n, string $comparison = null)

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

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 741
SaleQuery joinSaleI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the SaleI18n relation

Parameters

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

Return Value

SaleQuery The current query, for fluid interface

at line 776
SaleI18nQuery useSaleI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the SaleI18n relation SaleI18n 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

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

See also

useQuery()

at line 790
SaleQuery prune( Sale $sale = null)

Exclude object from result

Parameters

Sale $sale Object to remove from the list of results

Return Value

SaleQuery The current query, for fluid interface

at line 805
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the sale table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

at line 842
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildSale 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.

at line 885
SaleQuery joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

SaleQuery The current query, for fluid interface

at line 903
SaleQuery joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

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

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

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

SaleQuery The current query, for fluid interface

at line 924
SaleI18nQuery useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

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

See also

useQuery()

at line 940
SaleQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

SaleQuery The current query, for fluid interface

at line 952
SaleQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

SaleQuery The current query, for fluid interface

at line 962
SaleQuery lastUpdatedFirst()

Order by update date desc

Return Value

SaleQuery The current query, for fluid interface

at line 972
SaleQuery firstUpdatedFirst()

Order by update date asc

Return Value

SaleQuery The current query, for fluid interface

at line 982
SaleQuery lastCreatedFirst()

Order by create date desc

Return Value

SaleQuery The current query, for fluid interface

at line 992
SaleQuery firstCreatedFirst()

Order by create date asc

Return Value

SaleQuery The current query, for fluid interface

at line 81
ChildSaleQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByActive($order = Criteria::ASC)

Order by the active column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByDisplayInitialPrice($order = Criteria::ASC)

Order by the displayinitialprice column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByStartDate($order = Criteria::ASC)

Order by the start_date column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByEndDate($order = Criteria::ASC)

Order by the end_date column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByPriceOffsetType($order = Criteria::ASC)

Order by the priceoffsettype column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupById()

Group by the id column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByActive()

Group by the active column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByDisplayInitialPrice()

Group by the displayinitialprice column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByStartDate()

Group by the start_date column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByEndDate()

Group by the end_date column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByPriceOffsetType()

Group by the priceoffsettype column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery leftJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery rightJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery innerJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery leftJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery rightJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery innerJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery leftJoinSaleI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery rightJoinSaleI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSaleQuery innerJoinSaleI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleQuery

at line 81
ChildSale findOne( ConnectionInterface $con = null)

Return the first ChildSale matching the query

Parameters

ConnectionInterface $con

Return Value

ChildSale

at line 81
ChildSale findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildSale

at line 81
ChildSale findOneById( int $id)

Return the first ChildSale filtered by the id column

Parameters

int $id

Return Value

ChildSale

at line 81
ChildSale findOneByActive( boolean $active)

Return the first ChildSale filtered by the active column

Parameters

boolean $active

Return Value

ChildSale

at line 81
ChildSale findOneByDisplayInitialPrice( boolean $display_initial_price)

Return the first ChildSale filtered by the displayinitialprice column

Parameters

boolean $display_initial_price

Return Value

ChildSale

at line 81
ChildSale findOneByStartDate( string $start_date)

Return the first ChildSale filtered by the start_date column

Parameters

string $start_date

Return Value

ChildSale

at line 81
ChildSale findOneByEndDate( string $end_date)

Return the first ChildSale filtered by the end_date column

Parameters

string $end_date

Return Value

ChildSale

at line 81
ChildSale findOneByPriceOffsetType( int $price_offset_type)

Return the first ChildSale filtered by the priceoffsettype column

Parameters

int $price_offset_type

Return Value

ChildSale

at line 81
ChildSale findOneByCreatedAt( string $created_at)

Return the first ChildSale filtered by the created_at column

Parameters

string $created_at

Return Value

ChildSale

at line 81
ChildSale findOneByUpdatedAt( string $updated_at)

Return the first ChildSale filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildSale

at line 81
array findById( int $id)

Return ChildSale objects filtered by the id column

Parameters

int $id

Return Value

array

at line 81
array findByActive( boolean $active)

Return ChildSale objects filtered by the active column

Parameters

boolean $active

Return Value

array

at line 81
array findByDisplayInitialPrice( boolean $display_initial_price)

Return ChildSale objects filtered by the displayinitialprice column

Parameters

boolean $display_initial_price

Return Value

array

at line 81
array findByStartDate( string $start_date)

Return ChildSale objects filtered by the start_date column

Parameters

string $start_date

Return Value

array

at line 81
array findByEndDate( string $end_date)

Return ChildSale objects filtered by the end_date column

Parameters

string $end_date

Return Value

array

at line 81
array findByPriceOffsetType( int $price_offset_type)

Return ChildSale objects filtered by the priceoffsettype column

Parameters

int $price_offset_type

Return Value

array

at line 81
array findByCreatedAt( string $created_at)

Return ChildSale objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 81
array findByUpdatedAt( string $updated_at)

Return ChildSale objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array