SaleOffsetCurrencyQuery
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
Initializes internal state of \Thelia\Model\Base\SaleOffsetCurrencyQuery object.
Returns a new ChildSaleOffsetCurrencyQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the sale_id column
Filter the query on the currency_id column
Filter the query on the priceoffsetvalue column
Filter the query by a related \Thelia\Model\Sale object
Adds a JOIN clause to the query using the Sale relation
Use the Sale relation Sale object
Filter the query by a related \Thelia\Model\Currency object
Adds a JOIN clause to the query using the Currency relation
Use the Currency relation Currency object
Deletes all rows from the saleoffsetcurrency table.
Performs a DELETE on the database, given a ChildSaleOffsetCurrency or Criteria object OR a primary key value.
Order by the sale_id column
Order by the currency_id column
Order by the priceoffsetvalue column
Group by the sale_id column
Group by the currency_id column
Group by the priceoffsetvalue column
Adds a LEFT JOIN clause to the query
Adds a RIGHT JOIN clause to the query
Adds a INNER JOIN clause to the query
Adds a LEFT JOIN clause to the query using the Sale relation
Adds a RIGHT JOIN clause to the query using the Sale relation
Adds a INNER JOIN clause to the query using the Sale relation
Adds a LEFT JOIN clause to the query using the Currency relation
Adds a RIGHT JOIN clause to the query using the Currency relation
Adds a INNER JOIN clause to the query using the Currency relation
Return the first ChildSaleOffsetCurrency matching the query
Return the first ChildSaleOffsetCurrency matching the query, or a new ChildSaleOffsetCurrency object populated from the query conditions when no match is found
Return the first ChildSaleOffsetCurrency filtered by the sale_id column
Return the first ChildSaleOffsetCurrency filtered by the currency_id column
Return the first ChildSaleOffsetCurrency filtered by the priceoffsetvalue column
Return ChildSaleOffsetCurrency objects filtered by the sale_id column
Return ChildSaleOffsetCurrency objects filtered by the currency_id column
Return ChildSaleOffsetCurrency objects filtered by the priceoffsetvalue column
Details
in
SaleOffsetCurrencyQuery at line 66
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\SaleOffsetCurrency',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\SaleOffsetCurrencyQuery object.
in
SaleOffsetCurrencyQuery at line 79
static
SaleOffsetCurrencyQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildSaleOffsetCurrencyQuery object.
in
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);
in
SaleOffsetCurrencyQuery 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);
in
SaleOffsetCurrencyQuery at line 213
SaleOffsetCurrencyQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
SaleOffsetCurrencyQuery at line 228
SaleOffsetCurrencyQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
SaleOffsetCurrencyQuery 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
in
SaleOffsetCurrencyQuery 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
in
SaleOffsetCurrencyQuery 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
in
SaleOffsetCurrencyQuery at line 378
SaleOffsetCurrencyQuery
filterBySale(
Sale|ObjectCollection $sale,
string $comparison = null)
Filter the query by a related \Thelia\Model\Sale object
in
SaleOffsetCurrencyQuery at line 403
SaleOffsetCurrencyQuery
joinSale(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Sale relation
in
SaleOffsetCurrencyQuery at line 438
SaleQuery
useSaleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Sale relation Sale object
in
SaleOffsetCurrencyQuery at line 453
SaleOffsetCurrencyQuery
filterByCurrency(
Currency|ObjectCollection $currency,
string $comparison = null)
Filter the query by a related \Thelia\Model\Currency object
in
SaleOffsetCurrencyQuery at line 478
SaleOffsetCurrencyQuery
joinCurrency(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Currency relation
in
SaleOffsetCurrencyQuery at line 513
CurrencyQuery
useCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Currency relation Currency object
in
SaleOffsetCurrencyQuery at line 527
SaleOffsetCurrencyQuery
prune(
SaleOffsetCurrency $saleOffsetCurrency = null)
Exclude object from result
in
SaleOffsetCurrencyQuery at line 544
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the saleoffsetcurrency table.
in
SaleOffsetCurrencyQuery 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.
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
orderBySaleId($order = Criteria::ASC)
Order by the sale_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
orderByCurrencyId($order = Criteria::ASC)
Order by the currency_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
orderByPriceOffsetValue($order = Criteria::ASC)
Order by the priceoffsetvalue column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
groupBySaleId()
Group by the sale_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
groupByCurrencyId()
Group by the currency_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
groupByPriceOffsetValue()
Group by the priceoffsetvalue column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
leftJoinSale($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Sale relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
rightJoinSale($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Sale relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
innerJoinSale($relationAlias = null)
Adds a INNER JOIN clause to the query using the Sale relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
leftJoinCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Currency relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
rightJoinCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Currency relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrencyQuery
innerJoinCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the Currency relation
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrency
findOne(
ConnectionInterface $con = null)
Return the first ChildSaleOffsetCurrency matching the query
in
SaleOffsetCurrencyQuery 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
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrency
findOneBySaleId(
int $sale_id)
Return the first ChildSaleOffsetCurrency filtered by the sale_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrency
findOneByCurrencyId(
int $currency_id)
Return the first ChildSaleOffsetCurrency filtered by the currency_id column
in
SaleOffsetCurrencyQuery at line 56
ChildSaleOffsetCurrency
findOneByPriceOffsetValue(
double $price_offset_value)
Return the first ChildSaleOffsetCurrency filtered by the priceoffsetvalue column
in
SaleOffsetCurrencyQuery at line 56
array
findBySaleId(
int $sale_id)
Return ChildSaleOffsetCurrency objects filtered by the sale_id column
in
SaleOffsetCurrencyQuery at line 56
array
findByCurrencyId(
int $currency_id)
Return ChildSaleOffsetCurrency objects filtered by the currency_id column
in
SaleOffsetCurrencyQuery at line 56
array
findByPriceOffsetValue(
double $price_offset_value)
Return ChildSaleOffsetCurrency objects filtered by the priceoffsetvalue column