class SaleOffsetCurrencyQuery extends SaleOffsetCurrencyQuery

Skeleton subclass for performing query and update operations on the 'saleoffsetcurrency' 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\\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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

ChildSaleOffsetCurrencyQuery orderBySaleId($order = Criteria::ASC)

Order by the sale_id column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery orderByCurrencyId($order = Criteria::ASC)

Order by the currency_id column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery orderByPriceOffsetValue($order = Criteria::ASC)

Order by the priceoffsetvalue column

Parameters

$order

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery groupBySaleId()

Group by the sale_id column

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery groupByCurrencyId()

Group by the currency_id column

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery groupByPriceOffsetValue()

Group by the priceoffsetvalue column

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery leftJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery rightJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery innerJoinSale($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery leftJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery rightJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrencyQuery innerJoinCurrency($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildSaleOffsetCurrencyQuery

ChildSaleOffsetCurrency findOne( ConnectionInterface $con = null)

Return the first ChildSaleOffsetCurrency matching the query

Parameters

ConnectionInterface $con

Return Value

ChildSaleOffsetCurrency

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

ChildSaleOffsetCurrency findOneBySaleId( int $sale_id)

Return the first ChildSaleOffsetCurrency filtered by the sale_id column

Parameters

int $sale_id

Return Value

ChildSaleOffsetCurrency

ChildSaleOffsetCurrency findOneByCurrencyId( int $currency_id)

Return the first ChildSaleOffsetCurrency filtered by the currency_id column

Parameters

int $currency_id

Return Value

ChildSaleOffsetCurrency

ChildSaleOffsetCurrency findOneByPriceOffsetValue( double $price_offset_value)

Return the first ChildSaleOffsetCurrency filtered by the priceoffsetvalue column

Parameters

double $price_offset_value

Return Value

ChildSaleOffsetCurrency

array findBySaleId( int $sale_id)

Return ChildSaleOffsetCurrency objects filtered by the sale_id column

Parameters

int $sale_id

Return Value

array

array findByCurrencyId( int $currency_id)

Return ChildSaleOffsetCurrency objects filtered by the currency_id column

Parameters

int $currency_id

Return Value

array

array findByPriceOffsetValue( double $price_offset_value)

Return ChildSaleOffsetCurrency objects filtered by the priceoffsetvalue column

Parameters

double $price_offset_value

Return Value

array