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