class SaleOffsetCurrencyQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildSaleOffsetCurrencyQuery object.

SaleOffsetCurrency|array|mixed
findPk($key, $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(array(12, 56), array(832, 123), array(123, 456)), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterBySaleId( mixed $saleId = null, string $comparison = null)

Filter the query on the sale_id column

filterByCurrencyId( mixed $currencyId = null, string $comparison = null)

Filter the query on the currency_id column

filterByPriceOffsetValue( mixed $priceOffsetValue = null, string $comparison = null)

Filter the query on the priceoffsetvalue column

filterBySale( Sale|ObjectCollection $sale, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Sale relation

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

Use the Sale relation Sale object

filterByCurrency( Currency|ObjectCollection $currency, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Currency relation

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

Use the Currency relation Currency object

prune( SaleOffsetCurrency $saleOffsetCurrency = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the saleoffsetcurrency table.

int
delete( ConnectionInterface $con = null)

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

ChildSaleOffsetCurrencyQuery
orderBySaleId($order = Criteria::ASC)

Order by the sale_id column

ChildSaleOffsetCurrencyQuery
orderByCurrencyId($order = Criteria::ASC)

Order by the currency_id column

ChildSaleOffsetCurrencyQuery
orderByPriceOffsetValue($order = Criteria::ASC)

Order by the priceoffsetvalue column

ChildSaleOffsetCurrencyQuery
groupBySaleId()

Group by the sale_id column

ChildSaleOffsetCurrencyQuery
groupByCurrencyId()

Group by the currency_id column

ChildSaleOffsetCurrencyQuery
groupByPriceOffsetValue()

Group by the priceoffsetvalue column

ChildSaleOffsetCurrencyQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildSaleOffsetCurrencyQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildSaleOffsetCurrencyQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildSaleOffsetCurrencyQuery
leftJoinSale($relationAlias = null)

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

ChildSaleOffsetCurrencyQuery
rightJoinSale($relationAlias = null)

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

ChildSaleOffsetCurrencyQuery
innerJoinSale($relationAlias = null)

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

ChildSaleOffsetCurrencyQuery
leftJoinCurrency($relationAlias = null)

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

ChildSaleOffsetCurrencyQuery
rightJoinCurrency($relationAlias = null)

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

ChildSaleOffsetCurrencyQuery
innerJoinCurrency($relationAlias = null)

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

ChildSaleOffsetCurrency
findOne( ConnectionInterface $con = null)

Return the first ChildSaleOffsetCurrency matching the query

ChildSaleOffsetCurrency
findOneOrCreate( ConnectionInterface $con = null)

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

ChildSaleOffsetCurrency
findOneBySaleId( int $sale_id)

Return the first ChildSaleOffsetCurrency filtered by the sale_id column

ChildSaleOffsetCurrency
findOneByCurrencyId( int $currency_id)

Return the first ChildSaleOffsetCurrency filtered by the currency_id column

ChildSaleOffsetCurrency
findOneByPriceOffsetValue( double $price_offset_value)

Return the first ChildSaleOffsetCurrency filtered by the priceoffsetvalue column

array
findBySaleId( int $sale_id)

Return ChildSaleOffsetCurrency objects filtered by the sale_id column

array
findByCurrencyId( int $currency_id)

Return ChildSaleOffsetCurrency objects filtered by the currency_id column

array
findByPriceOffsetValue( double $price_offset_value)

Return ChildSaleOffsetCurrency objects filtered by the priceoffsetvalue column

Details

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

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

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

at line 79
static SaleOffsetCurrencyQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildSaleOffsetCurrencyQuery object.

Parameters

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

Return Value

SaleOffsetCurrencyQuery

at line 109
SaleOffsetCurrency|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);

Parameters

$key
$con

Return Value

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

at line 192
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);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

at line 213
SaleOffsetCurrencyQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 228
SaleOffsetCurrencyQuery 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

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 263
SaleOffsetCurrencyQuery filterBySaleId( mixed $saleId = null, string $comparison = null)

Filter the query on the sale_id column

Example usage: $query->filterBySaleId(1234); // WHERE saleid = 1234 $query->filterBySaleId(array(12, 34)); // WHERE saleid IN (12, 34) $query->filterBySaleId(array('min' => 12)); // WHERE sale_id > 12

Parameters

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

SaleOffsetCurrencyQuery The current query, for fluid interface

See also

filterBySale()

at line 306
SaleOffsetCurrencyQuery 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

Parameters

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

SaleOffsetCurrencyQuery The current query, for fluid interface

See also

filterByCurrency()

at line 347
SaleOffsetCurrencyQuery filterByPriceOffsetValue( mixed $priceOffsetValue = null, string $comparison = null)

Filter the query on the priceoffsetvalue column

Example usage: $query->filterByPriceOffsetValue(1234); // WHERE priceoffsetvalue = 1234 $query->filterByPriceOffsetValue(array(12, 34)); // WHERE priceoffsetvalue IN (12, 34) $query->filterByPriceOffsetValue(array('min' => 12)); // WHERE priceoffsetvalue > 12

Parameters

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

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 378
SaleOffsetCurrencyQuery filterBySale( Sale|ObjectCollection $sale, string $comparison = null)

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

Parameters

Sale|ObjectCollection $sale The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 403
SaleOffsetCurrencyQuery joinSale( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Sale relation

Parameters

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

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 438
SaleQuery useSaleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 453
SaleOffsetCurrencyQuery filterByCurrency( Currency|ObjectCollection $currency, string $comparison = null)

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

Parameters

Currency|ObjectCollection $currency The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 478
SaleOffsetCurrencyQuery joinCurrency( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Currency relation

Parameters

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

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

at line 513
CurrencyQuery useCurrencyQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 527
SaleOffsetCurrencyQuery prune( SaleOffsetCurrency $saleOffsetCurrency = null)

Exclude object from result

Parameters

SaleOffsetCurrency $saleOffsetCurrency Object to remove from the list of results

Return Value

SaleOffsetCurrencyQuery The current query, for fluid interface

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

Deletes all rows from the saleoffsetcurrency table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

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

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

at line 56
ChildSaleOffsetCurrencyQuery orderBySaleId($order = Criteria::ASC)

Order by the sale_id column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery orderByCurrencyId($order = Criteria::ASC)

Order by the currency_id column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery orderByPriceOffsetValue($order = Criteria::ASC)

Order by the priceoffsetvalue column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery groupBySaleId()

Group by the sale_id column

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery groupByCurrencyId()

Group by the currency_id column

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery groupByPriceOffsetValue()

Group by the priceoffsetvalue column

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery leftJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery rightJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery innerJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery leftJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery rightJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrencyQuery innerJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

at line 56
ChildSaleOffsetCurrency findOne( ConnectionInterface $con = null)

Return the first ChildSaleOffsetCurrency matching the query

Parameters

ConnectionInterface $con

Return Value

ChildSaleOffsetCurrency

at line 56
ChildSaleOffsetCurrency findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildSaleOffsetCurrency

at line 56
ChildSaleOffsetCurrency findOneBySaleId( int $sale_id)

Return the first ChildSaleOffsetCurrency filtered by the sale_id column

Parameters

int $sale_id

Return Value

ChildSaleOffsetCurrency

at line 56
ChildSaleOffsetCurrency findOneByCurrencyId( int $currency_id)

Return the first ChildSaleOffsetCurrency filtered by the currency_id column

Parameters

int $currency_id

Return Value

ChildSaleOffsetCurrency

at line 56
ChildSaleOffsetCurrency findOneByPriceOffsetValue( double $price_offset_value)

Return the first ChildSaleOffsetCurrency filtered by the priceoffsetvalue column

Parameters

double $price_offset_value

Return Value

ChildSaleOffsetCurrency

at line 56
array findBySaleId( int $sale_id)

Return ChildSaleOffsetCurrency objects filtered by the sale_id column

Parameters

int $sale_id

Return Value

array

at line 56
array findByCurrencyId( int $currency_id)

Return ChildSaleOffsetCurrency objects filtered by the currency_id column

Parameters

int $currency_id

Return Value

array

at line 56
array findByPriceOffsetValue( double $price_offset_value)

Return ChildSaleOffsetCurrency objects filtered by the priceoffsetvalue column

Parameters

double $price_offset_value

Return Value

array