SaleQuery
class SaleQuery extends ModelCriteria
Base class that represents a query for the 'sale' table.
Methods
Initializes internal state of \Thelia\Model\Base\SaleQuery object.
Returns a new ChildSaleQuery object.
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
Filter the query on the active column
Filter the query on the displayinitialprice column
Filter the query on the start_date column
Filter the query on the end_date column
Filter the query on the priceoffsettype column
Filter the query on the created_at column
Filter the query on the updated_at column
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
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.
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
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.
at line 104
static
SaleQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildSaleQuery object.
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);
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);
at line 237
SaleQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 250
SaleQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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
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
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'
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'
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
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'
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'
at line 572
SaleQuery
filterBySaleOffsetCurrency(
SaleOffsetCurrency|ObjectCollection $saleOffsetCurrency,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleOffsetCurrency object
at line 595
SaleQuery
joinSaleOffsetCurrency(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the SaleOffsetCurrency relation
at line 630
SaleOffsetCurrencyQuery
useSaleOffsetCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the SaleOffsetCurrency relation SaleOffsetCurrency object
at line 645
SaleQuery
filterBySaleProduct(
SaleProduct|ObjectCollection $saleProduct,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleProduct object
at line 668
SaleQuery
joinSaleProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the SaleProduct relation
at line 703
SaleProductQuery
useSaleProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the SaleProduct relation SaleProduct object
at line 718
SaleQuery
filterBySaleI18n(
SaleI18n|ObjectCollection $saleI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleI18n object
at line 741
SaleQuery
joinSaleI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the SaleI18n relation
at line 776
SaleI18nQuery
useSaleI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the SaleI18n relation SaleI18n object
at line 805
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the sale table.
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.
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
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()
at line 924
SaleI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 940
SaleQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 952
SaleQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 962
SaleQuery
lastUpdatedFirst()
Order by update date desc
at line 972
SaleQuery
firstUpdatedFirst()
Order by update date asc
at line 982
SaleQuery
lastCreatedFirst()
Order by create date desc
at line 992
SaleQuery
firstCreatedFirst()
Order by create date asc
at line 81
ChildSaleQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 81
ChildSaleQuery
orderByActive($order = Criteria::ASC)
Order by the active column
at line 81
ChildSaleQuery
orderByDisplayInitialPrice($order = Criteria::ASC)
Order by the displayinitialprice column
at line 81
ChildSaleQuery
orderByStartDate($order = Criteria::ASC)
Order by the start_date column
at line 81
ChildSaleQuery
orderByEndDate($order = Criteria::ASC)
Order by the end_date column
at line 81
ChildSaleQuery
orderByPriceOffsetType($order = Criteria::ASC)
Order by the priceoffsettype column
at line 81
ChildSaleQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 81
ChildSaleQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 81
ChildSaleQuery
groupById()
Group by the id column
at line 81
ChildSaleQuery
groupByActive()
Group by the active column
at line 81
ChildSaleQuery
groupByDisplayInitialPrice()
Group by the displayinitialprice column
at line 81
ChildSaleQuery
groupByStartDate()
Group by the start_date column
at line 81
ChildSaleQuery
groupByEndDate()
Group by the end_date column
at line 81
ChildSaleQuery
groupByPriceOffsetType()
Group by the priceoffsettype column
at line 81
ChildSaleQuery
groupByCreatedAt()
Group by the created_at column
at line 81
ChildSaleQuery
groupByUpdatedAt()
Group by the updated_at column
at line 81
ChildSaleQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 81
ChildSaleQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 81
ChildSaleQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 81
ChildSaleQuery
leftJoinSaleOffsetCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleOffsetCurrency relation
at line 81
ChildSaleQuery
rightJoinSaleOffsetCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleOffsetCurrency relation
at line 81
ChildSaleQuery
innerJoinSaleOffsetCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleOffsetCurrency relation
at line 81
ChildSaleQuery
leftJoinSaleProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleProduct relation
at line 81
ChildSaleQuery
rightJoinSaleProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleProduct relation
at line 81
ChildSaleQuery
innerJoinSaleProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleProduct relation
at line 81
ChildSaleQuery
leftJoinSaleI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleI18n relation
at line 81
ChildSaleQuery
rightJoinSaleI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleI18n relation
at line 81
ChildSaleQuery
innerJoinSaleI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleI18n relation
at line 81
ChildSale
findOne(
ConnectionInterface $con = null)
Return the first ChildSale matching the query
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
at line 81
ChildSale
findOneById(
int $id)
Return the first ChildSale filtered by the id column
at line 81
ChildSale
findOneByActive(
boolean $active)
Return the first ChildSale filtered by the active column
at line 81
ChildSale
findOneByDisplayInitialPrice(
boolean $display_initial_price)
Return the first ChildSale filtered by the displayinitialprice column
at line 81
ChildSale
findOneByStartDate(
string $start_date)
Return the first ChildSale filtered by the start_date column
at line 81
ChildSale
findOneByEndDate(
string $end_date)
Return the first ChildSale filtered by the end_date column
at line 81
ChildSale
findOneByPriceOffsetType(
int $price_offset_type)
Return the first ChildSale filtered by the priceoffsettype column
at line 81
ChildSale
findOneByCreatedAt(
string $created_at)
Return the first ChildSale filtered by the created_at column
at line 81
ChildSale
findOneByUpdatedAt(
string $updated_at)
Return the first ChildSale filtered by the updated_at column
at line 81
array
findById(
int $id)
Return ChildSale objects filtered by the id column
at line 81
array
findByActive(
boolean $active)
Return ChildSale objects filtered by the active column
at line 81
array
findByDisplayInitialPrice(
boolean $display_initial_price)
Return ChildSale objects filtered by the displayinitialprice column
at line 81
array
findByStartDate(
string $start_date)
Return ChildSale objects filtered by the start_date column
at line 81
array
findByEndDate(
string $end_date)
Return ChildSale objects filtered by the end_date column
at line 81
array
findByPriceOffsetType(
int $price_offset_type)
Return ChildSale objects filtered by the priceoffsettype column
at line 81
array
findByCreatedAt(
string $created_at)
Return ChildSale objects filtered by the created_at column
at line 81
array
findByUpdatedAt(
string $updated_at)
Return ChildSale objects filtered by the updated_at column