class CouponCountryQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildCouponCountryQuery object.

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

filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Coupon relation

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

Use the Coupon relation Coupon object

prune( CouponCountry $couponCountry = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the coupon_country table.

int
delete( ConnectionInterface $con = null)

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

ChildCouponCountryQuery
orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

ChildCouponCountryQuery
orderByCountryId($order = Criteria::ASC)

Order by the country_id column

ChildCouponCountryQuery
groupByCouponId()

Group by the coupon_id column

ChildCouponCountryQuery
groupByCountryId()

Group by the country_id column

ChildCouponCountryQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCouponCountryQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCouponCountryQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCouponCountryQuery
leftJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
rightJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
innerJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
leftJoinCoupon($relationAlias = null)

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

ChildCouponCountryQuery
rightJoinCoupon($relationAlias = null)

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

ChildCouponCountryQuery
innerJoinCoupon($relationAlias = null)

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

ChildCouponCountry
findOne( ConnectionInterface $con = null)

Return the first ChildCouponCountry matching the query

ChildCouponCountry
findOneOrCreate( ConnectionInterface $con = null)

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

ChildCouponCountry
findOneByCouponId( int $coupon_id)

Return the first ChildCouponCountry filtered by the coupon_id column

ChildCouponCountry
findOneByCountryId( int $country_id)

Return the first ChildCouponCountry filtered by the country_id column

array
findByCouponId( int $coupon_id)

Return ChildCouponCountry objects filtered by the coupon_id column

array
findByCountryId( int $country_id)

Return ChildCouponCountry objects filtered by the country_id column

Details

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

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

Returns a new ChildCouponCountryQuery object.

Parameters

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

Return Value

CouponCountryQuery

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

CouponCountry|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
CouponCountryQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CouponCountryQuery The current query, for fluid interface

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

CouponCountryQuery The current query, for fluid interface

at line 259
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

See also

filterByCoupon()

at line 302
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

See also

filterByCountry()

at line 333
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

at line 358
CouponCountryQuery 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

CouponCountryQuery 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
CouponCountryQuery filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

Parameters

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

Return Value

CouponCountryQuery The current query, for fluid interface

at line 433
CouponCountryQuery joinCoupon( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Coupon relation

Parameters

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

Return Value

CouponCountryQuery The current query, for fluid interface

at line 468
CouponQuery useCouponQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 482
CouponCountryQuery prune( CouponCountry $couponCountry = null)

Exclude object from result

Parameters

CouponCountry $couponCountry Object to remove from the list of results

Return Value

CouponCountryQuery The current query, for fluid interface

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

Deletes all rows from the coupon_country 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 ChildCouponCountry 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
ChildCouponCountryQuery orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

Parameters

$order

Return Value

ChildCouponCountryQuery

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

Order by the country_id column

Parameters

$order

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery groupByCouponId()

Group by the coupon_id column

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery groupByCountryId()

Group by the country_id column

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery leftJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery rightJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery innerJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery leftJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery rightJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

at line 52
ChildCouponCountryQuery innerJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

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

Return the first ChildCouponCountry matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCouponCountry

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

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

Parameters

ConnectionInterface $con

Return Value

ChildCouponCountry

at line 52
ChildCouponCountry findOneByCouponId( int $coupon_id)

Return the first ChildCouponCountry filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

ChildCouponCountry

at line 52
ChildCouponCountry findOneByCountryId( int $country_id)

Return the first ChildCouponCountry filtered by the country_id column

Parameters

int $country_id

Return Value

ChildCouponCountry

at line 52
array findByCouponId( int $coupon_id)

Return ChildCouponCountry objects filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

array

at line 52
array findByCountryId( int $country_id)

Return ChildCouponCountry objects filtered by the country_id column

Parameters

int $country_id

Return Value

array