ProductPriceQuery
class ProductPriceQuery extends ModelCriteria
Base class that represents a query for the 'product_price' table.
Methods
Initializes internal state of \Thelia\Model\Base\ProductPriceQuery object.
Returns a new ChildProductPriceQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the productsaleelements_id column
Filter the query on the currency_id column
Filter the query on the price column
Filter the query on the promo_price column
Filter the query on the fromdefaultcurrency 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\ProductSaleElements object
Adds a JOIN clause to the query using the ProductSaleElements relation
Use the ProductSaleElements relation ProductSaleElements object
Filter the query by a related \Thelia\Model\Currency object
Adds a JOIN clause to the query using the Currency relation
Use the Currency relation Currency object
Deletes all rows from the product_price table.
Performs a DELETE on the database, given a ChildProductPrice 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 productsaleelements_id column
Order by the currency_id column
Order by the price column
Order by the promo_price column
Order by the fromdefaultcurrency column
Order by the created_at column
Order by the updated_at column
Group by the productsaleelements_id column
Group by the currency_id column
Group by the price column
Group by the promo_price column
Group by the fromdefaultcurrency 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 ProductSaleElements relation
Adds a RIGHT JOIN clause to the query using the ProductSaleElements relation
Adds a INNER JOIN clause to the query using the ProductSaleElements relation
Adds a LEFT JOIN clause to the query using the Currency relation
Adds a RIGHT JOIN clause to the query using the Currency relation
Adds a INNER JOIN clause to the query using the Currency relation
Return the first ChildProductPrice matching the query
Return the first ChildProductPrice matching the query, or a new ChildProductPrice object populated from the query conditions when no match is found
Return the first ChildProductPrice filtered by the productsaleelements_id column
Return the first ChildProductPrice filtered by the currency_id column
Return the first ChildProductPrice filtered by the price column
Return the first ChildProductPrice filtered by the promo_price column
Return the first ChildProductPrice filtered by the fromdefaultcurrency column
Return the first ChildProductPrice filtered by the created_at column
Return the first ChildProductPrice filtered by the updated_at column
Return ChildProductPrice objects filtered by the productsaleelements_id column
Return ChildProductPrice objects filtered by the currency_id column
Return ChildProductPrice objects filtered by the price column
Return ChildProductPrice objects filtered by the promo_price column
Return ChildProductPrice objects filtered by the fromdefaultcurrency column
Return ChildProductPrice objects filtered by the created_at column
Return ChildProductPrice objects filtered by the updated_at column
Details
at line 82
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProductPrice',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProductPriceQuery object.
at line 95
static
ProductPriceQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProductPriceQuery object.
at line 125
ProductPrice|array|mixed
findPk($key, $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(array(12, 34), $con);
at line 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
at line 229
ProductPriceQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 244
ProductPriceQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 279
ProductPriceQuery
filterByProductSaleElementsId(
mixed $productSaleElementsId = null,
string $comparison = null)
Filter the query on the productsaleelements_id column
Example usage:
$query->filterByProductSaleElementsId(1234); // WHERE productsaleelementsid = 1234
$query->filterByProductSaleElementsId(array(12, 34)); // WHERE productsaleelementsid IN (12, 34)
$query->filterByProductSaleElementsId(array('min' => 12)); // WHERE productsaleelements_id > 12
at line 322
ProductPriceQuery
filterByCurrencyId(
mixed $currencyId = null,
string $comparison = null)
Filter the query on the currency_id column
Example usage:
$query->filterByCurrencyId(1234); // WHERE currencyid = 1234
$query->filterByCurrencyId(array(12, 34)); // WHERE currencyid IN (12, 34)
$query->filterByCurrencyId(array('min' => 12)); // WHERE currency_id > 12
at line 363
ProductPriceQuery
filterByPrice(
mixed $price = null,
string $comparison = null)
Filter the query on the price column
Example usage:
$query->filterByPrice(1234); // WHERE price = 1234
$query->filterByPrice(array(12, 34)); // WHERE price IN (12, 34)
$query->filterByPrice(array('min' => 12)); // WHERE price > 12
at line 404
ProductPriceQuery
filterByPromoPrice(
mixed $promoPrice = null,
string $comparison = null)
Filter the query on the promo_price column
Example usage:
$query->filterByPromoPrice(1234); // WHERE promoprice = 1234
$query->filterByPromoPrice(array(12, 34)); // WHERE promoprice IN (12, 34)
$query->filterByPromoPrice(array('min' => 12)); // WHERE promo_price > 12
at line 445
ProductPriceQuery
filterByFromDefaultCurrency(
boolean|string $fromDefaultCurrency = null,
string $comparison = null)
Filter the query on the fromdefaultcurrency column
Example usage:
$query->filterByFromDefaultCurrency(true); // WHERE fromdefaultcurrency = true
$query->filterByFromDefaultCurrency('yes'); // WHERE fromdefaultcurrency = true
at line 474
ProductPriceQuery
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 517
ProductPriceQuery
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 548
ProductPriceQuery
filterByProductSaleElements(
ProductSaleElements|ObjectCollection $productSaleElements,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductSaleElements object
at line 573
ProductPriceQuery
joinProductSaleElements(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductSaleElements relation
at line 608
ProductSaleElementsQuery
useProductSaleElementsQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductSaleElements relation ProductSaleElements object
at line 623
ProductPriceQuery
filterByCurrency(
Currency|ObjectCollection $currency,
string $comparison = null)
Filter the query by a related \Thelia\Model\Currency object
at line 648
ProductPriceQuery
joinCurrency(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Currency relation
at line 683
CurrencyQuery
useCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Currency relation Currency object
at line 697
ProductPriceQuery
prune(
ProductPrice $productPrice = null)
Exclude object from result
at line 714
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the product_price table.
at line 751
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProductPrice or Criteria object OR a primary key value.
at line 792
ProductPriceQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 804
ProductPriceQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 814
ProductPriceQuery
lastUpdatedFirst()
Order by update date desc
at line 824
ProductPriceQuery
firstUpdatedFirst()
Order by update date asc
at line 834
ProductPriceQuery
lastCreatedFirst()
Order by create date desc
at line 844
ProductPriceQuery
firstCreatedFirst()
Order by create date asc
at line 72
ChildProductPriceQuery
orderByProductSaleElementsId($order = Criteria::ASC)
Order by the productsaleelements_id column
at line 72
ChildProductPriceQuery
orderByCurrencyId($order = Criteria::ASC)
Order by the currency_id column
at line 72
ChildProductPriceQuery
orderByPrice($order = Criteria::ASC)
Order by the price column
at line 72
ChildProductPriceQuery
orderByPromoPrice($order = Criteria::ASC)
Order by the promo_price column
at line 72
ChildProductPriceQuery
orderByFromDefaultCurrency($order = Criteria::ASC)
Order by the fromdefaultcurrency column
at line 72
ChildProductPriceQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 72
ChildProductPriceQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 72
ChildProductPriceQuery
groupByProductSaleElementsId()
Group by the productsaleelements_id column
at line 72
ChildProductPriceQuery
groupByCurrencyId()
Group by the currency_id column
at line 72
ChildProductPriceQuery
groupByPrice()
Group by the price column
at line 72
ChildProductPriceQuery
groupByPromoPrice()
Group by the promo_price column
at line 72
ChildProductPriceQuery
groupByFromDefaultCurrency()
Group by the fromdefaultcurrency column
at line 72
ChildProductPriceQuery
groupByCreatedAt()
Group by the created_at column
at line 72
ChildProductPriceQuery
groupByUpdatedAt()
Group by the updated_at column
at line 72
ChildProductPriceQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 72
ChildProductPriceQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 72
ChildProductPriceQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 72
ChildProductPriceQuery
leftJoinProductSaleElements($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductSaleElements relation
at line 72
ChildProductPriceQuery
rightJoinProductSaleElements($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductSaleElements relation
at line 72
ChildProductPriceQuery
innerJoinProductSaleElements($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductSaleElements relation
at line 72
ChildProductPriceQuery
leftJoinCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Currency relation
at line 72
ChildProductPriceQuery
rightJoinCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Currency relation
at line 72
ChildProductPriceQuery
innerJoinCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the Currency relation
at line 72
ChildProductPrice
findOne(
ConnectionInterface $con = null)
Return the first ChildProductPrice matching the query
at line 72
ChildProductPrice
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProductPrice matching the query, or a new ChildProductPrice object populated from the query conditions when no match is found
at line 72
ChildProductPrice
findOneByProductSaleElementsId(
int $product_sale_elements_id)
Return the first ChildProductPrice filtered by the productsaleelements_id column
at line 72
ChildProductPrice
findOneByCurrencyId(
int $currency_id)
Return the first ChildProductPrice filtered by the currency_id column
at line 72
ChildProductPrice
findOneByPrice(
string $price)
Return the first ChildProductPrice filtered by the price column
at line 72
ChildProductPrice
findOneByPromoPrice(
string $promo_price)
Return the first ChildProductPrice filtered by the promo_price column
at line 72
ChildProductPrice
findOneByFromDefaultCurrency(
boolean $from_default_currency)
Return the first ChildProductPrice filtered by the fromdefaultcurrency column
at line 72
ChildProductPrice
findOneByCreatedAt(
string $created_at)
Return the first ChildProductPrice filtered by the created_at column
at line 72
ChildProductPrice
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProductPrice filtered by the updated_at column
at line 72
array
findByProductSaleElementsId(
int $product_sale_elements_id)
Return ChildProductPrice objects filtered by the productsaleelements_id column
at line 72
array
findByCurrencyId(
int $currency_id)
Return ChildProductPrice objects filtered by the currency_id column
at line 72
array
findByPrice(
string $price)
Return ChildProductPrice objects filtered by the price column
at line 72
array
findByPromoPrice(
string $promo_price)
Return ChildProductPrice objects filtered by the promo_price column
at line 72
array
findByFromDefaultCurrency(
boolean $from_default_currency)
Return ChildProductPrice objects filtered by the fromdefaultcurrency column
at line 72
array
findByCreatedAt(
string $created_at)
Return ChildProductPrice objects filtered by the created_at column
at line 72
array
findByUpdatedAt(
string $updated_at)
Return ChildProductPrice objects filtered by the updated_at column