class AreaQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildAreaQuery object.

Area|array|mixed
findPk( mixed $key, ConnectionInterface $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(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByName( string $name = null, string $comparison = null)

Filter the query on the name column

filterByPostage( mixed $postage = null, string $comparison = null)

Filter the query on the postage column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByAreaDeliveryModule( AreaDeliveryModule|ObjectCollection $areaDeliveryModule, string $comparison = null)

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

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

Adds a JOIN clause to the query using the AreaDeliveryModule relation

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

Use the AreaDeliveryModule relation AreaDeliveryModule object

filterByCountryArea( CountryArea|ObjectCollection $countryArea, string $comparison = null)

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

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

Adds a JOIN clause to the query using the CountryArea relation

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

Use the CountryArea relation CountryArea object

filterByCountry( Country $country, string $comparison = Criteria::EQUAL)

Filter the query by a related Country object using the country_area table as cross reference

prune( Area $area = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the area table.

int
delete( ConnectionInterface $con = null)

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

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildAreaQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildAreaQuery
orderByName($order = Criteria::ASC)

Order by the name column

ChildAreaQuery
orderByPostage($order = Criteria::ASC)

Order by the postage column

ChildAreaQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildAreaQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildAreaQuery
groupById()

Group by the id column

ChildAreaQuery
groupByName()

Group by the name column

ChildAreaQuery
groupByPostage()

Group by the postage column

ChildAreaQuery
groupByCreatedAt()

Group by the created_at column

ChildAreaQuery
groupByUpdatedAt()

Group by the updated_at column

ChildAreaQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildAreaQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildAreaQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildAreaQuery
leftJoinAreaDeliveryModule($relationAlias = null)

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

ChildAreaQuery
rightJoinAreaDeliveryModule($relationAlias = null)

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

ChildAreaQuery
innerJoinAreaDeliveryModule($relationAlias = null)

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

ChildAreaQuery
leftJoinCountryArea($relationAlias = null)

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

ChildAreaQuery
rightJoinCountryArea($relationAlias = null)

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

ChildAreaQuery
innerJoinCountryArea($relationAlias = null)

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

ChildArea
findOne( ConnectionInterface $con = null)

Return the first ChildArea matching the query

ChildArea
findOneOrCreate( ConnectionInterface $con = null)

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

ChildArea
findOneById( int $id)

Return the first ChildArea filtered by the id column

ChildArea
findOneByName( string $name)

Return the first ChildArea filtered by the name column

ChildArea
findOneByPostage( double $postage)

Return the first ChildArea filtered by the postage column

ChildArea
findOneByCreatedAt( string $created_at)

Return the first ChildArea filtered by the created_at column

ChildArea
findOneByUpdatedAt( string $updated_at)

Return the first ChildArea filtered by the updated_at column

array
findById( int $id)

Return ChildArea objects filtered by the id column

array
findByName( string $name)

Return ChildArea objects filtered by the name column

array
findByPostage( double $postage)

Return ChildArea objects filtered by the postage column

array
findByCreatedAt( string $created_at)

Return ChildArea objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildArea objects filtered by the updated_at column

Details

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

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

Returns a new ChildAreaQuery object.

Parameters

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

Return Value

AreaQuery

at line 117
Area|array|mixed findPk( mixed $key, ConnectionInterface $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(12, $con);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

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

at line 199
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $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 220
AreaQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

AreaQuery The current query, for fluid interface

at line 233
AreaQuery 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

AreaQuery The current query, for fluid interface

at line 257
AreaQuery filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

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

Parameters

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

AreaQuery The current query, for fluid interface

at line 295
AreaQuery filterByName( string $name = null, string $comparison = null)

Filter the query on the name column

Example usage: $query->filterByName('fooValue'); // WHERE name = 'fooValue' $query->filterByName('%fooValue%'); // WHERE name LIKE '%fooValue%'

Parameters

string $name The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AreaQuery The current query, for fluid interface

at line 327
AreaQuery filterByPostage( mixed $postage = null, string $comparison = null)

Filter the query on the postage column

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

Parameters

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

AreaQuery The current query, for fluid interface

at line 370
AreaQuery filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

Example usage: $query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. 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

AreaQuery The current query, for fluid interface

at line 413
AreaQuery filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

Example usage: $query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. 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

AreaQuery The current query, for fluid interface

at line 444
AreaQuery filterByAreaDeliveryModule( AreaDeliveryModule|ObjectCollection $areaDeliveryModule, string $comparison = null)

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

Parameters

AreaDeliveryModule|ObjectCollection $areaDeliveryModule the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AreaQuery The current query, for fluid interface

at line 467
AreaQuery joinAreaDeliveryModule( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AreaDeliveryModule relation

Parameters

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

Return Value

AreaQuery The current query, for fluid interface

at line 502
AreaDeliveryModuleQuery useAreaDeliveryModuleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 517
AreaQuery filterByCountryArea( CountryArea|ObjectCollection $countryArea, string $comparison = null)

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

Parameters

CountryArea|ObjectCollection $countryArea the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AreaQuery The current query, for fluid interface

at line 540
AreaQuery joinCountryArea( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the CountryArea relation

Parameters

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

Return Value

AreaQuery The current query, for fluid interface

at line 575
CountryAreaQuery useCountryAreaQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 591
AreaQuery filterByCountry( Country $country, string $comparison = Criteria::EQUAL)

Filter the query by a related Country object using the country_area table as cross reference

Parameters

Country $country the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AreaQuery The current query, for fluid interface

at line 606
AreaQuery prune( Area $area = null)

Exclude object from result

Parameters

Area $area Object to remove from the list of results

Return Value

AreaQuery The current query, for fluid interface

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

Deletes all rows from the area table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

Performs a DELETE on the database, given a ChildArea 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 699
AreaQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

AreaQuery The current query, for fluid interface

at line 711
AreaQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

AreaQuery The current query, for fluid interface

at line 721
AreaQuery lastUpdatedFirst()

Order by update date desc

Return Value

AreaQuery The current query, for fluid interface

at line 731
AreaQuery firstUpdatedFirst()

Order by update date asc

Return Value

AreaQuery The current query, for fluid interface

at line 741
AreaQuery lastCreatedFirst()

Order by create date desc

Return Value

AreaQuery The current query, for fluid interface

at line 751
AreaQuery firstCreatedFirst()

Order by create date asc

Return Value

AreaQuery The current query, for fluid interface

at line 64
ChildAreaQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery orderByName($order = Criteria::ASC)

Order by the name column

Parameters

$order

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery orderByPostage($order = Criteria::ASC)

Order by the postage column

Parameters

$order

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery groupById()

Group by the id column

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery groupByName()

Group by the name column

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery groupByPostage()

Group by the postage column

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery leftJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery rightJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery innerJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery leftJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery rightJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildAreaQuery innerJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

at line 64
ChildArea findOne( ConnectionInterface $con = null)

Return the first ChildArea matching the query

Parameters

ConnectionInterface $con

Return Value

ChildArea

at line 64
ChildArea findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildArea

at line 64
ChildArea findOneById( int $id)

Return the first ChildArea filtered by the id column

Parameters

int $id

Return Value

ChildArea

at line 64
ChildArea findOneByName( string $name)

Return the first ChildArea filtered by the name column

Parameters

string $name

Return Value

ChildArea

at line 64
ChildArea findOneByPostage( double $postage)

Return the first ChildArea filtered by the postage column

Parameters

double $postage

Return Value

ChildArea

at line 64
ChildArea findOneByCreatedAt( string $created_at)

Return the first ChildArea filtered by the created_at column

Parameters

string $created_at

Return Value

ChildArea

at line 64
ChildArea findOneByUpdatedAt( string $updated_at)

Return the first ChildArea filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildArea

at line 64
array findById( int $id)

Return ChildArea objects filtered by the id column

Parameters

int $id

Return Value

array

at line 64
array findByName( string $name)

Return ChildArea objects filtered by the name column

Parameters

string $name

Return Value

array

at line 64
array findByPostage( double $postage)

Return ChildArea objects filtered by the postage column

Parameters

double $postage

Return Value

array

at line 64
array findByCreatedAt( string $created_at)

Return ChildArea objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 64
array findByUpdatedAt( string $updated_at)

Return ChildArea objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array