class OrderCouponCountryQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildOrderCouponCountryQuery object.

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

filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

filterByCountryId( mixed $countryId = null, string $comparison = null)

Filter the query on the country_id column

filterByCountry( Country|ObjectCollection $country, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Country relation

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

Use the Country relation Country object

filterByOrderCoupon( OrderCoupon|ObjectCollection $orderCoupon, string $comparison = null)

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

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

Adds a JOIN clause to the query using the OrderCoupon relation

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

Use the OrderCoupon relation OrderCoupon object

prune( OrderCouponCountry $orderCouponCountry = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the ordercouponcountry table.

int
delete( ConnectionInterface $con = null)

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

ChildOrderCouponCountryQuery
orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

ChildOrderCouponCountryQuery
orderByCountryId($order = Criteria::ASC)

Order by the country_id column

ChildOrderCouponCountryQuery
groupByCouponId()

Group by the coupon_id column

ChildOrderCouponCountryQuery
groupByCountryId()

Group by the country_id column

ChildOrderCouponCountryQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildOrderCouponCountryQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildOrderCouponCountryQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildOrderCouponCountryQuery
leftJoinCountry($relationAlias = null)

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

ChildOrderCouponCountryQuery
rightJoinCountry($relationAlias = null)

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

ChildOrderCouponCountryQuery
innerJoinCountry($relationAlias = null)

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

ChildOrderCouponCountryQuery
leftJoinOrderCoupon($relationAlias = null)

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

ChildOrderCouponCountryQuery
rightJoinOrderCoupon($relationAlias = null)

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

ChildOrderCouponCountryQuery
innerJoinOrderCoupon($relationAlias = null)

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

ChildOrderCouponCountry
findOne( ConnectionInterface $con = null)

Return the first ChildOrderCouponCountry matching the query

ChildOrderCouponCountry
findOneOrCreate( ConnectionInterface $con = null)

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

ChildOrderCouponCountry
findOneByCouponId( int $coupon_id)

Return the first ChildOrderCouponCountry filtered by the coupon_id column

ChildOrderCouponCountry
findOneByCountryId( int $country_id)

Return the first ChildOrderCouponCountry filtered by the country_id column

array
findByCouponId( int $coupon_id)

Return ChildOrderCouponCountry objects filtered by the coupon_id column

array
findByCountryId( int $country_id)

Return ChildOrderCouponCountry objects filtered by the country_id column

Details

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

Initializes internal state of \Thelia\Model\Base\OrderCouponCountryQuery 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 75
static OrderCouponCountryQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildOrderCouponCountryQuery object.

Parameters

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

Return Value

OrderCouponCountryQuery

at line 105
OrderCouponCountry|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

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

at line 188
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 209
OrderCouponCountryQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

OrderCouponCountryQuery The current query, for fluid interface

at line 224
OrderCouponCountryQuery 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

OrderCouponCountryQuery The current query, for fluid interface

at line 259
OrderCouponCountryQuery filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

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

Parameters

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

OrderCouponCountryQuery The current query, for fluid interface

See also

filterByOrderCoupon()

at line 302
OrderCouponCountryQuery filterByCountryId( mixed $countryId = null, string $comparison = null)

Filter the query on the country_id column

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

Parameters

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

OrderCouponCountryQuery The current query, for fluid interface

See also

filterByCountry()

at line 333
OrderCouponCountryQuery filterByCountry( Country|ObjectCollection $country, string $comparison = null)

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

Parameters

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

Return Value

OrderCouponCountryQuery The current query, for fluid interface

at line 358
OrderCouponCountryQuery joinCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Country relation

Parameters

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

Return Value

OrderCouponCountryQuery The current query, for fluid interface

at line 393
CountryQuery useCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 408
OrderCouponCountryQuery filterByOrderCoupon( OrderCoupon|ObjectCollection $orderCoupon, string $comparison = null)

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

Parameters

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

Return Value

OrderCouponCountryQuery The current query, for fluid interface

at line 433
OrderCouponCountryQuery joinOrderCoupon( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the OrderCoupon relation

Parameters

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

Return Value

OrderCouponCountryQuery The current query, for fluid interface

at line 468
OrderCouponQuery useOrderCouponQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 482
OrderCouponCountryQuery prune( OrderCouponCountry $orderCouponCountry = null)

Exclude object from result

Parameters

OrderCouponCountry $orderCouponCountry Object to remove from the list of results

Return Value

OrderCouponCountryQuery The current query, for fluid interface

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

Deletes all rows from the ordercouponcountry table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

Performs a DELETE on the database, given a ChildOrderCouponCountry 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 52
ChildOrderCouponCountryQuery orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

Parameters

$order

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery orderByCountryId($order = Criteria::ASC)

Order by the country_id column

Parameters

$order

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery groupByCouponId()

Group by the coupon_id column

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery groupByCountryId()

Group by the country_id column

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery leftJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery rightJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery innerJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery leftJoinOrderCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery rightJoinOrderCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountryQuery innerJoinOrderCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderCouponCountryQuery

at line 52
ChildOrderCouponCountry findOne( ConnectionInterface $con = null)

Return the first ChildOrderCouponCountry matching the query

Parameters

ConnectionInterface $con

Return Value

ChildOrderCouponCountry

at line 52
ChildOrderCouponCountry findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildOrderCouponCountry

at line 52
ChildOrderCouponCountry findOneByCouponId( int $coupon_id)

Return the first ChildOrderCouponCountry filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

ChildOrderCouponCountry

at line 52
ChildOrderCouponCountry findOneByCountryId( int $country_id)

Return the first ChildOrderCouponCountry filtered by the country_id column

Parameters

int $country_id

Return Value

ChildOrderCouponCountry

at line 52
array findByCouponId( int $coupon_id)

Return ChildOrderCouponCountry objects filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

array

at line 52
array findByCountryId( int $country_id)

Return ChildOrderCouponCountry objects filtered by the country_id column

Parameters

int $country_id

Return Value

array