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

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

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

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

Returns a new ChildCurrencyQuery object.

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

filterByCode( string $code = null, string $comparison = null)

Filter the query on the code column

filterBySymbol( string $symbol = null, string $comparison = null)

Filter the query on the symbol column

filterByFormat( string $format = null, string $comparison = null)

Filter the query on the format column

filterByRate( mixed $rate = null, string $comparison = null)

Filter the query on the rate column

filterByVisible( mixed $visible = null, string $comparison = null)

Filter the query on the visible column

filterByPosition( mixed $position = null, string $comparison = null)

Filter the query on the position column

filterByByDefault( mixed $byDefault = null, string $comparison = null)

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

filterByOrder( Order|ObjectCollection $order, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Order relation

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

Use the Order relation Order object

filterByCart( Cart|ObjectCollection $cart, string $comparison = null)

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

joinCart( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the Cart relation

useCartQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the Cart relation Cart object

filterByProductPrice( ProductPrice|ObjectCollection $productPrice, string $comparison = null)

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

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

Adds a JOIN clause to the query using the ProductPrice relation

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

Use the ProductPrice relation ProductPrice object

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

filterByCurrencyI18n( CurrencyI18n|ObjectCollection $currencyI18n, string $comparison = null)

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

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

Adds a JOIN clause to the query using the CurrencyI18n relation

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

Use the CurrencyI18n relation CurrencyI18n object

prune( Currency $currency = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the currency table.

int
delete( ConnectionInterface $con = null)

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

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

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

ChildCurrencyQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildCurrencyQuery
orderByCode($order = Criteria::ASC)

Order by the code column

ChildCurrencyQuery
orderBySymbol($order = Criteria::ASC)

Order by the symbol column

ChildCurrencyQuery
orderByFormat($order = Criteria::ASC)

Order by the format column

ChildCurrencyQuery
orderByRate($order = Criteria::ASC)

Order by the rate column

ChildCurrencyQuery
orderByVisible($order = Criteria::ASC)

Order by the visible column

ChildCurrencyQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildCurrencyQuery
orderByByDefault($order = Criteria::ASC)

Order by the by_default column

ChildCurrencyQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildCurrencyQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildCurrencyQuery
groupById()

Group by the id column

ChildCurrencyQuery
groupByCode()

Group by the code column

ChildCurrencyQuery
groupBySymbol()

Group by the symbol column

ChildCurrencyQuery
groupByFormat()

Group by the format column

ChildCurrencyQuery
groupByRate()

Group by the rate column

ChildCurrencyQuery
groupByVisible()

Group by the visible column

ChildCurrencyQuery
groupByPosition()

Group by the position column

ChildCurrencyQuery
groupByByDefault()

Group by the by_default column

ChildCurrencyQuery
groupByCreatedAt()

Group by the created_at column

ChildCurrencyQuery
groupByUpdatedAt()

Group by the updated_at column

ChildCurrencyQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCurrencyQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCurrencyQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCurrencyQuery
leftJoinOrder($relationAlias = null)

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

ChildCurrencyQuery
rightJoinOrder($relationAlias = null)

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

ChildCurrencyQuery
innerJoinOrder($relationAlias = null)

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

ChildCurrencyQuery
leftJoinCart($relationAlias = null)

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

ChildCurrencyQuery
rightJoinCart($relationAlias = null)

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

ChildCurrencyQuery
innerJoinCart($relationAlias = null)

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

ChildCurrencyQuery
leftJoinProductPrice($relationAlias = null)

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

ChildCurrencyQuery
rightJoinProductPrice($relationAlias = null)

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

ChildCurrencyQuery
innerJoinProductPrice($relationAlias = null)

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

ChildCurrencyQuery
leftJoinSaleOffsetCurrency($relationAlias = null)

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

ChildCurrencyQuery
rightJoinSaleOffsetCurrency($relationAlias = null)

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

ChildCurrencyQuery
innerJoinSaleOffsetCurrency($relationAlias = null)

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

ChildCurrencyQuery
leftJoinCurrencyI18n($relationAlias = null)

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

ChildCurrencyQuery
rightJoinCurrencyI18n($relationAlias = null)

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

ChildCurrencyQuery
innerJoinCurrencyI18n($relationAlias = null)

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

ChildCurrency
findOne( ConnectionInterface $con = null)

Return the first ChildCurrency matching the query

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

ChildCurrency
findOneById( int $id)

Return the first ChildCurrency filtered by the id column

ChildCurrency
findOneByCode( string $code)

Return the first ChildCurrency filtered by the code column

ChildCurrency
findOneBySymbol( string $symbol)

Return the first ChildCurrency filtered by the symbol column

ChildCurrency
findOneByFormat( string $format)

Return the first ChildCurrency filtered by the format column

ChildCurrency
findOneByRate( double $rate)

Return the first ChildCurrency filtered by the rate column

ChildCurrency
findOneByVisible( int $visible)

Return the first ChildCurrency filtered by the visible column

ChildCurrency
findOneByPosition( int $position)

Return the first ChildCurrency filtered by the position column

ChildCurrency
findOneByByDefault( int $by_default)

Return the first ChildCurrency filtered by the by_default column

ChildCurrency
findOneByCreatedAt( string $created_at)

Return the first ChildCurrency filtered by the created_at column

ChildCurrency
findOneByUpdatedAt( string $updated_at)

Return the first ChildCurrency filtered by the updated_at column

array
findById( int $id)

Return ChildCurrency objects filtered by the id column

array
findByCode( string $code)

Return ChildCurrency objects filtered by the code column

array
findBySymbol( string $symbol)

Return ChildCurrency objects filtered by the symbol column

array
findByFormat( string $format)

Return ChildCurrency objects filtered by the format column

array
findByRate( double $rate)

Return ChildCurrency objects filtered by the rate column

array
findByVisible( int $visible)

Return ChildCurrency objects filtered by the visible column

array
findByPosition( int $position)

Return ChildCurrency objects filtered by the position column

array
findByByDefault( int $by_default)

Return ChildCurrency objects filtered by the by_default column

array
findByCreatedAt( string $created_at)

Return ChildCurrency objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

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.

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'

in CurrencyQuery at line 120
static CurrencyQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCurrencyQuery object.

Parameters

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

Return Value

CurrencyQuery

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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

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

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);

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

in CurrencyQuery at line 253
CurrencyQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 266
CurrencyQuery 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

CurrencyQuery The current query, for fluid interface

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

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

CurrencyQuery The current query, for fluid interface

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%'

Parameters

string $code The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CurrencyQuery The current query, for fluid interface

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%'

Parameters

string $symbol The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CurrencyQuery The current query, for fluid interface

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%'

Parameters

string $format The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CurrencyQuery The current query, for fluid interface

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

Parameters

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

CurrencyQuery The current query, for fluid interface

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

Parameters

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

CurrencyQuery The current query, for fluid interface

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

Parameters

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

CurrencyQuery The current query, for fluid interface

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

Parameters

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

CurrencyQuery The current query, for fluid interface

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'

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

CurrencyQuery The current query, for fluid interface

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'

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

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 658
CurrencyQuery filterByOrder( Order|ObjectCollection $order, string $comparison = null)

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 716
OrderQuery useOrderQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

in CurrencyQuery at line 731
CurrencyQuery filterByCart( Cart|ObjectCollection $cart, string $comparison = null)

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 789
CartQuery useCartQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

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

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

See also

useQuery()

in CurrencyQuery at line 804
CurrencyQuery filterByProductPrice( ProductPrice|ObjectCollection $productPrice, string $comparison = null)

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 862
ProductPriceQuery useProductPriceQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

in CurrencyQuery at line 877
CurrencyQuery 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

CurrencyQuery The current query, for fluid interface

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 935
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()

in CurrencyQuery at line 950
CurrencyQuery filterByCurrencyI18n( CurrencyI18n|ObjectCollection $currencyI18n, string $comparison = null)

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

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

Parameters

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

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1008
CurrencyI18nQuery useCurrencyI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

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

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

See also

useQuery()

in CurrencyQuery at line 1022
CurrencyQuery prune( Currency $currency = null)

Exclude object from result

Parameters

Currency $currency Object to remove from the list of results

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1037
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the currency table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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.

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.

in CurrencyQuery at line 1115
CurrencyQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1127
CurrencyQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1137
CurrencyQuery lastUpdatedFirst()

Order by update date desc

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1147
CurrencyQuery firstUpdatedFirst()

Order by update date asc

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1157
CurrencyQuery lastCreatedFirst()

Order by create date desc

Return Value

CurrencyQuery The current query, for fluid interface

in CurrencyQuery at line 1167
CurrencyQuery firstCreatedFirst()

Order by create date asc

Return Value

CurrencyQuery The current query, for fluid interface

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

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

CurrencyQuery The current query, for fluid interface

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()

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

CurrencyQuery The current query, for fluid interface

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

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

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

See also

useQuery()

in CurrencyQuery at line 97
ChildCurrencyQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByCode($order = Criteria::ASC)

Order by the code column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderBySymbol($order = Criteria::ASC)

Order by the symbol column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByFormat($order = Criteria::ASC)

Order by the format column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByRate($order = Criteria::ASC)

Order by the rate column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByVisible($order = Criteria::ASC)

Order by the visible column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByByDefault($order = Criteria::ASC)

Order by the by_default column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupById()

Group by the id column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByCode()

Group by the code column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupBySymbol()

Group by the symbol column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByFormat()

Group by the format column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByRate()

Group by the rate column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByVisible()

Group by the visible column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByPosition()

Group by the position column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByByDefault()

Group by the by_default column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoinCart($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoinCart($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoinCart($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoinProductPrice($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoinProductPrice($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoinProductPrice($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoinSaleOffsetCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery leftJoinCurrencyI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery rightJoinCurrencyI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrencyQuery innerJoinCurrencyI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCurrencyQuery

in CurrencyQuery at line 97
ChildCurrency findOne( ConnectionInterface $con = null)

Return the first ChildCurrency matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCurrency

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

Parameters

ConnectionInterface $con

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneById( int $id)

Return the first ChildCurrency filtered by the id column

Parameters

int $id

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByCode( string $code)

Return the first ChildCurrency filtered by the code column

Parameters

string $code

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneBySymbol( string $symbol)

Return the first ChildCurrency filtered by the symbol column

Parameters

string $symbol

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByFormat( string $format)

Return the first ChildCurrency filtered by the format column

Parameters

string $format

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByRate( double $rate)

Return the first ChildCurrency filtered by the rate column

Parameters

double $rate

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByVisible( int $visible)

Return the first ChildCurrency filtered by the visible column

Parameters

int $visible

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByPosition( int $position)

Return the first ChildCurrency filtered by the position column

Parameters

int $position

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByByDefault( int $by_default)

Return the first ChildCurrency filtered by the by_default column

Parameters

int $by_default

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByCreatedAt( string $created_at)

Return the first ChildCurrency filtered by the created_at column

Parameters

string $created_at

Return Value

ChildCurrency

in CurrencyQuery at line 97
ChildCurrency findOneByUpdatedAt( string $updated_at)

Return the first ChildCurrency filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildCurrency

in CurrencyQuery at line 97
array findById( int $id)

Return ChildCurrency objects filtered by the id column

Parameters

int $id

Return Value

array

in CurrencyQuery at line 97
array findByCode( string $code)

Return ChildCurrency objects filtered by the code column

Parameters

string $code

Return Value

array

in CurrencyQuery at line 97
array findBySymbol( string $symbol)

Return ChildCurrency objects filtered by the symbol column

Parameters

string $symbol

Return Value

array

in CurrencyQuery at line 97
array findByFormat( string $format)

Return ChildCurrency objects filtered by the format column

Parameters

string $format

Return Value

array

in CurrencyQuery at line 97
array findByRate( double $rate)

Return ChildCurrency objects filtered by the rate column

Parameters

double $rate

Return Value

array

in CurrencyQuery at line 97
array findByVisible( int $visible)

Return ChildCurrency objects filtered by the visible column

Parameters

int $visible

Return Value

array

in CurrencyQuery at line 97
array findByPosition( int $position)

Return ChildCurrency objects filtered by the position column

Parameters

int $position

Return Value

array

in CurrencyQuery at line 97
array findByByDefault( int $by_default)

Return ChildCurrency objects filtered by the by_default column

Parameters

int $by_default

Return Value

array

in CurrencyQuery at line 97
array findByCreatedAt( string $created_at)

Return ChildCurrency objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

in CurrencyQuery at line 97
array findByUpdatedAt( string $updated_at)

Return ChildCurrency objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array