CurrencyQuery
class CurrencyQuery extends CurrencyQuery
Skeleton subclass for performing query and update operations on the 'currency' table.
You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.
Methods
Initializes internal state of \Thelia\Model\Base\CurrencyQuery object.
Returns a new ChildCurrencyQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the code column
Filter the query on the symbol column
Filter the query on the format column
Filter the query on the rate column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the by_default 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\Order object
Adds a JOIN clause to the query using the Order relation
Use the Order relation Order object
Filter the query by a related \Thelia\Model\Cart object
Adds a JOIN clause to the query using the Cart relation
Use the Cart relation Cart object
Filter the query by a related \Thelia\Model\ProductPrice object
Adds a JOIN clause to the query using the ProductPrice relation
Use the ProductPrice relation ProductPrice object
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\CurrencyI18n object
Adds a JOIN clause to the query using the CurrencyI18n relation
Use the CurrencyI18n relation CurrencyI18n object
Deletes all rows from the currency table.
Performs a DELETE on the database, given a ChildCurrency 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
Order by the symbol column
Order by the format column
Order by the visible column
Order by the position column
Order by the by_default column
Order by the created_at column
Order by the updated_at column
Adds a LEFT JOIN clause to the query using the Order relation
Adds a RIGHT JOIN clause to the query using the Order relation
Adds a INNER JOIN clause to the query using the Order relation
Adds a LEFT JOIN clause to the query using the Cart relation
Adds a RIGHT JOIN clause to the query using the Cart relation
Adds a INNER JOIN clause to the query using the Cart relation
Adds a LEFT JOIN clause to the query using the ProductPrice relation
Adds a RIGHT JOIN clause to the query using the ProductPrice relation
Adds a INNER JOIN clause to the query using the ProductPrice relation
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 CurrencyI18n relation
Adds a RIGHT JOIN clause to the query using the CurrencyI18n relation
Adds a INNER JOIN clause to the query using the CurrencyI18n relation
Return the first ChildCurrency matching the query
Return the first ChildCurrency matching the query, or a new ChildCurrency object populated from the query conditions when no match is found
Return the first ChildCurrency filtered by the id column
Return the first ChildCurrency filtered by the code column
Return the first ChildCurrency filtered by the symbol column
Return the first ChildCurrency filtered by the format column
Return the first ChildCurrency filtered by the rate column
Return the first ChildCurrency filtered by the visible column
Return the first ChildCurrency filtered by the position column
Return the first ChildCurrency filtered by the by_default column
Return the first ChildCurrency filtered by the created_at column
Return the first ChildCurrency filtered by the updated_at column
Return ChildCurrency objects filtered by the code column
Return ChildCurrency objects filtered by the symbol column
Return ChildCurrency objects filtered by the format column
Return ChildCurrency objects filtered by the rate column
Return ChildCurrency objects filtered by the visible column
Return ChildCurrency objects filtered by the position column
Return ChildCurrency objects filtered by the by_default column
Return ChildCurrency objects filtered by the created_at column
Return ChildCurrency objects filtered by the updated_at column
Details
in
CurrencyQuery at line 107
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Currency',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CurrencyQuery object.
in
CurrencyQuery at line 120
static
CurrencyQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCurrencyQuery object.
in
CurrencyQuery at line 150
Currency|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);
in
CurrencyQuery at line 232
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
CurrencyQuery at line 253
CurrencyQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
CurrencyQuery at line 266
CurrencyQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CurrencyQuery at line 290
CurrencyQuery
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
in
CurrencyQuery at line 328
CurrencyQuery
filterByCode(
string $code = null,
string $comparison = null)
Filter the query on the code column
Example usage:
$query->filterByCode('fooValue'); // WHERE code = 'fooValue'
$query->filterByCode('%fooValue%'); // WHERE code LIKE '%fooValue%'
in
CurrencyQuery at line 357
CurrencyQuery
filterBySymbol(
string $symbol = null,
string $comparison = null)
Filter the query on the symbol column
Example usage:
$query->filterBySymbol('fooValue'); // WHERE symbol = 'fooValue'
$query->filterBySymbol('%fooValue%'); // WHERE symbol LIKE '%fooValue%'
in
CurrencyQuery at line 386
CurrencyQuery
filterByFormat(
string $format = null,
string $comparison = null)
Filter the query on the format column
Example usage:
$query->filterByFormat('fooValue'); // WHERE format = 'fooValue'
$query->filterByFormat('%fooValue%'); // WHERE format LIKE '%fooValue%'
in
CurrencyQuery at line 418
CurrencyQuery
filterByRate(
mixed $rate = null,
string $comparison = null)
Filter the query on the rate column
Example usage:
$query->filterByRate(1234); // WHERE rate = 1234
$query->filterByRate(array(12, 34)); // WHERE rate IN (12, 34)
$query->filterByRate(array('min' => 12)); // WHERE rate > 12
in
CurrencyQuery at line 459
CurrencyQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
in
CurrencyQuery at line 500
CurrencyQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition(1234); // WHERE position = 1234
$query->filterByPosition(array(12, 34)); // WHERE position IN (12, 34)
$query->filterByPosition(array('min' => 12)); // WHERE position > 12
in
CurrencyQuery at line 541
CurrencyQuery
filterByByDefault(
mixed $byDefault = null,
string $comparison = null)
Filter the query on the by_default column
Example usage:
$query->filterByByDefault(1234); // WHERE bydefault = 1234
$query->filterByByDefault(array(12, 34)); // WHERE bydefault IN (12, 34)
$query->filterByByDefault(array('min' => 12)); // WHERE by_default > 12
in
CurrencyQuery at line 584
CurrencyQuery
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'
in
CurrencyQuery at line 627
CurrencyQuery
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'
in
CurrencyQuery at line 658
CurrencyQuery
filterByOrder(
Order|ObjectCollection $order,
string $comparison = null)
Filter the query by a related \Thelia\Model\Order object
in
CurrencyQuery at line 681
CurrencyQuery
joinOrder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Order relation
in
CurrencyQuery at line 716
OrderQuery
useOrderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Order relation Order object
in
CurrencyQuery at line 731
CurrencyQuery
filterByCart(
Cart|ObjectCollection $cart,
string $comparison = null)
Filter the query by a related \Thelia\Model\Cart object
in
CurrencyQuery at line 754
CurrencyQuery
joinCart(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Cart relation
in
CurrencyQuery at line 789
CartQuery
useCartQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Cart relation Cart object
in
CurrencyQuery at line 804
CurrencyQuery
filterByProductPrice(
ProductPrice|ObjectCollection $productPrice,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductPrice object
in
CurrencyQuery at line 827
CurrencyQuery
joinProductPrice(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductPrice relation
in
CurrencyQuery at line 862
ProductPriceQuery
useProductPriceQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductPrice relation ProductPrice object
in
CurrencyQuery at line 877
CurrencyQuery
filterBySaleOffsetCurrency(
SaleOffsetCurrency|ObjectCollection $saleOffsetCurrency,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleOffsetCurrency object
in
CurrencyQuery at line 900
CurrencyQuery
joinSaleOffsetCurrency(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the SaleOffsetCurrency relation
in
CurrencyQuery at line 935
SaleOffsetCurrencyQuery
useSaleOffsetCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the SaleOffsetCurrency relation SaleOffsetCurrency object
in
CurrencyQuery at line 950
CurrencyQuery
filterByCurrencyI18n(
CurrencyI18n|ObjectCollection $currencyI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\CurrencyI18n object
in
CurrencyQuery at line 973
CurrencyQuery
joinCurrencyI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the CurrencyI18n relation
in
CurrencyQuery at line 1008
CurrencyI18nQuery
useCurrencyI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the CurrencyI18n relation CurrencyI18n object
in
CurrencyQuery at line 1022
CurrencyQuery
prune(
Currency $currency = null)
Exclude object from result
in
CurrencyQuery at line 1037
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the currency table.
in
CurrencyQuery at line 1074
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCurrency or Criteria object OR a primary key value.
in
CurrencyQuery at line 1115
CurrencyQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
CurrencyQuery at line 1127
CurrencyQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
CurrencyQuery at line 1137
CurrencyQuery
lastUpdatedFirst()
Order by update date desc
in
CurrencyQuery at line 1147
CurrencyQuery
firstUpdatedFirst()
Order by update date asc
in
CurrencyQuery at line 1157
CurrencyQuery
lastCreatedFirst()
Order by create date desc
in
CurrencyQuery at line 1167
CurrencyQuery
firstCreatedFirst()
Order by create date asc
in
CurrencyQuery at line 1183
CurrencyQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
in
CurrencyQuery at line 1201
CurrencyQuery
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()
in
CurrencyQuery at line 1222
CurrencyI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByCode($order = Criteria::ASC)
Order by the code column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderBySymbol($order = Criteria::ASC)
Order by the symbol column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByFormat($order = Criteria::ASC)
Order by the format column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByRate($order = Criteria::ASC)
Order by the rate column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByByDefault($order = Criteria::ASC)
Order by the by_default column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CurrencyQuery at line 97
ChildCurrencyQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupById()
Group by the id column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByCode()
Group by the code column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupBySymbol()
Group by the symbol column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByFormat()
Group by the format column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByRate()
Group by the rate column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByVisible()
Group by the visible column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByPosition()
Group by the position column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByByDefault()
Group by the by_default column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByCreatedAt()
Group by the created_at column
in
CurrencyQuery at line 97
ChildCurrencyQuery
groupByUpdatedAt()
Group by the updated_at column
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoinOrder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Order relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoinOrder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Order relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoinOrder($relationAlias = null)
Adds a INNER JOIN clause to the query using the Order relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoinCart($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Cart relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoinCart($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Cart relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoinCart($relationAlias = null)
Adds a INNER JOIN clause to the query using the Cart relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoinProductPrice($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductPrice relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoinProductPrice($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductPrice relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoinProductPrice($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductPrice relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoinSaleOffsetCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleOffsetCurrency relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoinSaleOffsetCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleOffsetCurrency relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoinSaleOffsetCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleOffsetCurrency relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
leftJoinCurrencyI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CurrencyI18n relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
rightJoinCurrencyI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CurrencyI18n relation
in
CurrencyQuery at line 97
ChildCurrencyQuery
innerJoinCurrencyI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the CurrencyI18n relation
in
CurrencyQuery at line 97
ChildCurrency
findOne(
ConnectionInterface $con = null)
Return the first ChildCurrency matching the query
in
CurrencyQuery at line 97
ChildCurrency
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCurrency matching the query, or a new ChildCurrency object populated from the query conditions when no match is found
in
CurrencyQuery at line 97
ChildCurrency
findOneById(
int $id)
Return the first ChildCurrency filtered by the id column
in
CurrencyQuery at line 97
ChildCurrency
findOneByCode(
string $code)
Return the first ChildCurrency filtered by the code column
in
CurrencyQuery at line 97
ChildCurrency
findOneBySymbol(
string $symbol)
Return the first ChildCurrency filtered by the symbol column
in
CurrencyQuery at line 97
ChildCurrency
findOneByFormat(
string $format)
Return the first ChildCurrency filtered by the format column
in
CurrencyQuery at line 97
ChildCurrency
findOneByRate(
double $rate)
Return the first ChildCurrency filtered by the rate column
in
CurrencyQuery at line 97
ChildCurrency
findOneByVisible(
int $visible)
Return the first ChildCurrency filtered by the visible column
in
CurrencyQuery at line 97
ChildCurrency
findOneByPosition(
int $position)
Return the first ChildCurrency filtered by the position column
in
CurrencyQuery at line 97
ChildCurrency
findOneByByDefault(
int $by_default)
Return the first ChildCurrency filtered by the by_default column
in
CurrencyQuery at line 97
ChildCurrency
findOneByCreatedAt(
string $created_at)
Return the first ChildCurrency filtered by the created_at column
in
CurrencyQuery at line 97
ChildCurrency
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCurrency filtered by the updated_at column
in
CurrencyQuery at line 97
array
findById(
int $id)
Return ChildCurrency objects filtered by the id column
in
CurrencyQuery at line 97
array
findByCode(
string $code)
Return ChildCurrency objects filtered by the code column
in
CurrencyQuery at line 97
array
findBySymbol(
string $symbol)
Return ChildCurrency objects filtered by the symbol column
in
CurrencyQuery at line 97
array
findByFormat(
string $format)
Return ChildCurrency objects filtered by the format column
in
CurrencyQuery at line 97
array
findByRate(
double $rate)
Return ChildCurrency objects filtered by the rate column
in
CurrencyQuery at line 97
array
findByVisible(
int $visible)
Return ChildCurrency objects filtered by the visible column
in
CurrencyQuery at line 97
array
findByPosition(
int $position)
Return ChildCurrency objects filtered by the position column
in
CurrencyQuery at line 97
array
findByByDefault(
int $by_default)
Return ChildCurrency objects filtered by the by_default column
in
CurrencyQuery at line 97
array
findByCreatedAt(
string $created_at)
Return ChildCurrency objects filtered by the created_at column
in
CurrencyQuery at line 97
array
findByUpdatedAt(
string $updated_at)
Return ChildCurrency objects filtered by the updated_at column