class AreaQuery extends AreaQuery

Skeleton subclass for performing query and update operations on the 'area' 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

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

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

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

Returns a new ChildAreaQuery object.

from  AreaQuery
Area|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

from  AreaQuery
ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

from  AreaQuery
filterByPrimaryKey( mixed $key)

Filter the query by primary key

from  AreaQuery
filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

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

Filter the query on the id column

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

Filter the query on the name column

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

Filter the query on the postage column

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

Filter the query on the created_at column

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

Filter the query on the updated_at column

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

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

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

Adds a JOIN clause to the query using the AreaDeliveryModule relation

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

Use the AreaDeliveryModule relation AreaDeliveryModule object

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

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

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

Adds a JOIN clause to the query using the CountryArea relation

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

Use the CountryArea relation CountryArea object

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

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

from  AreaQuery
prune( Area $area = null)

Exclude object from result

from  AreaQuery
int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the area table.

from  AreaQuery
int
delete( ConnectionInterface $con = null)

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

from  AreaQuery
recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

from  AreaQuery
recentlyCreated( int $nbDays = 7)

Filter by the latest created

from  AreaQuery
lastUpdatedFirst()

Order by update date desc

from  AreaQuery
firstUpdatedFirst()

Order by update date asc

from  AreaQuery
lastCreatedFirst()

Order by create date desc

from  AreaQuery
firstCreatedFirst()

Order by create date asc

from  AreaQuery
ChildAreaQuery
orderById($order = Criteria::ASC)

Order by the id column

from  AreaQuery
ChildAreaQuery
orderByName($order = Criteria::ASC)

Order by the name column

from  AreaQuery
ChildAreaQuery
orderByPostage($order = Criteria::ASC)

Order by the postage column

from  AreaQuery
ChildAreaQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

from  AreaQuery
ChildAreaQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

from  AreaQuery
ChildAreaQuery
groupById()

Group by the id column

from  AreaQuery
ChildAreaQuery
groupByName()

Group by the name column

from  AreaQuery
ChildAreaQuery
groupByPostage()

Group by the postage column

from  AreaQuery
ChildAreaQuery
groupByCreatedAt()

Group by the created_at column

from  AreaQuery
ChildAreaQuery
groupByUpdatedAt()

Group by the updated_at column

from  AreaQuery
ChildAreaQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

from  AreaQuery
ChildAreaQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

from  AreaQuery
ChildAreaQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

from  AreaQuery
ChildAreaQuery
leftJoinAreaDeliveryModule($relationAlias = null)

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

from  AreaQuery
ChildAreaQuery
rightJoinAreaDeliveryModule($relationAlias = null)

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

from  AreaQuery
ChildAreaQuery
innerJoinAreaDeliveryModule($relationAlias = null)

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

from  AreaQuery
ChildAreaQuery
leftJoinCountryArea($relationAlias = null)

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

from  AreaQuery
ChildAreaQuery
rightJoinCountryArea($relationAlias = null)

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

from  AreaQuery
ChildAreaQuery
innerJoinCountryArea($relationAlias = null)

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

from  AreaQuery
ChildArea
findOne( ConnectionInterface $con = null)

Return the first ChildArea matching the query

from  AreaQuery
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

from  AreaQuery
ChildArea
findOneById( int $id)

Return the first ChildArea filtered by the id column

from  AreaQuery
ChildArea
findOneByName( string $name)

Return the first ChildArea filtered by the name column

from  AreaQuery
ChildArea
findOneByPostage( double $postage)

Return the first ChildArea filtered by the postage column

from  AreaQuery
ChildArea
findOneByCreatedAt( string $created_at)

Return the first ChildArea filtered by the created_at column

from  AreaQuery
ChildArea
findOneByUpdatedAt( string $updated_at)

Return the first ChildArea filtered by the updated_at column

from  AreaQuery
array
findById( int $id)

Return ChildArea objects filtered by the id column

from  AreaQuery
array
findByName( string $name)

Return ChildArea objects filtered by the name column

from  AreaQuery
array
findByPostage( double $postage)

Return ChildArea objects filtered by the postage column

from  AreaQuery
array
findByCreatedAt( string $created_at)

Return ChildArea objects filtered by the created_at column

from  AreaQuery
array
findByUpdatedAt( string $updated_at)

Return ChildArea objects filtered by the updated_at column

from  AreaQuery

Details

in AreaQuery 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'

in AreaQuery 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

in 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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()

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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()

in AreaQuery 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

in AreaQuery 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

in AreaQuery 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).

in AreaQuery 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.

in AreaQuery 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

in AreaQuery 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

in AreaQuery at line 721
AreaQuery lastUpdatedFirst()

Order by update date desc

Return Value

AreaQuery The current query, for fluid interface

in AreaQuery at line 731
AreaQuery firstUpdatedFirst()

Order by update date asc

Return Value

AreaQuery The current query, for fluid interface

in AreaQuery at line 741
AreaQuery lastCreatedFirst()

Order by create date desc

Return Value

AreaQuery The current query, for fluid interface

in AreaQuery at line 751
AreaQuery firstCreatedFirst()

Order by create date asc

Return Value

AreaQuery The current query, for fluid interface

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

Order by the id column

Parameters

$order

Return Value

ChildAreaQuery

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

Order by the name column

Parameters

$order

Return Value

ChildAreaQuery

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

Order by the postage column

Parameters

$order

Return Value

ChildAreaQuery

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

Order by the created_at column

Parameters

$order

Return Value

ChildAreaQuery

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

Order by the updated_at column

Parameters

$order

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery groupById()

Group by the id column

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery groupByName()

Group by the name column

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery groupByPostage()

Group by the postage column

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery leftJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery rightJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery innerJoinAreaDeliveryModule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery leftJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery rightJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

in AreaQuery at line 64
ChildAreaQuery innerJoinCountryArea($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAreaQuery

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

Return the first ChildArea matching the query

Parameters

ConnectionInterface $con

Return Value

ChildArea

in AreaQuery 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

in AreaQuery at line 64
ChildArea findOneById( int $id)

Return the first ChildArea filtered by the id column

Parameters

int $id

Return Value

ChildArea

in AreaQuery at line 64
ChildArea findOneByName( string $name)

Return the first ChildArea filtered by the name column

Parameters

string $name

Return Value

ChildArea

in AreaQuery at line 64
ChildArea findOneByPostage( double $postage)

Return the first ChildArea filtered by the postage column

Parameters

double $postage

Return Value

ChildArea

in AreaQuery 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

in AreaQuery 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

in AreaQuery at line 64
array findById( int $id)

Return ChildArea objects filtered by the id column

Parameters

int $id

Return Value

array

in AreaQuery at line 64
array findByName( string $name)

Return ChildArea objects filtered by the name column

Parameters

string $name

Return Value

array

in AreaQuery at line 64
array findByPostage( double $postage)

Return ChildArea objects filtered by the postage column

Parameters

double $postage

Return Value

array

in AreaQuery at line 64
array findByCreatedAt( string $created_at)

Return ChildArea objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

in AreaQuery at line 64
array findByUpdatedAt( string $updated_at)

Return ChildArea objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array