AreaQuery
class AreaQuery extends ModelCriteria
Base class that represents a query for the 'area' table.
Methods
Initializes internal state of \Thelia\Model\Base\AreaQuery object.
Returns a new ChildAreaQuery object.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the name column
Filter the query on the postage column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query by a related \Thelia\Model\AreaDeliveryModule object
Adds a JOIN clause to the query using the AreaDeliveryModule relation
Use the AreaDeliveryModule relation AreaDeliveryModule object
Filter the query by a related \Thelia\Model\CountryArea object
Adds a JOIN clause to the query using the CountryArea relation
Use the CountryArea relation CountryArea object
Filter the query by a related Country object using the country_area table as cross reference
Deletes all rows from the area table.
Performs a DELETE on the database, given a ChildArea or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by update date desc
Order by update date asc
Order by create date desc
Order by create date asc
Order by the id column
Order by the name column
Order by the postage column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the name column
Group by the postage column
Group by the created_at column
Group by the updated_at 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 AreaDeliveryModule relation
Adds a RIGHT JOIN clause to the query using the AreaDeliveryModule relation
Adds a INNER JOIN clause to the query using the AreaDeliveryModule relation
Adds a LEFT JOIN clause to the query using the CountryArea relation
Adds a RIGHT JOIN clause to the query using the CountryArea relation
Adds a INNER JOIN clause to the query using the CountryArea relation
Return the first ChildArea matching the query
Return the first ChildArea matching the query, or a new ChildArea object populated from the query conditions when no match is found
Return the first ChildArea filtered by the id column
Return the first ChildArea filtered by the name column
Return the first ChildArea filtered by the postage column
Return the first ChildArea filtered by the created_at column
Return the first ChildArea filtered by the updated_at column
Return ChildArea objects filtered by the id column
Return ChildArea objects filtered by the name column
Return ChildArea objects filtered by the postage column
Return ChildArea objects filtered by the created_at column
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.
at line 87
static
AreaQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAreaQuery object.
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);
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);
at line 220
AreaQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 233
AreaQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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%'
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
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'
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'
at line 444
AreaQuery
filterByAreaDeliveryModule(
AreaDeliveryModule|ObjectCollection $areaDeliveryModule,
string $comparison = null)
Filter the query by a related \Thelia\Model\AreaDeliveryModule object
at line 467
AreaQuery
joinAreaDeliveryModule(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AreaDeliveryModule relation
at line 502
AreaDeliveryModuleQuery
useAreaDeliveryModuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AreaDeliveryModule relation AreaDeliveryModule object
at line 517
AreaQuery
filterByCountryArea(
CountryArea|ObjectCollection $countryArea,
string $comparison = null)
Filter the query by a related \Thelia\Model\CountryArea object
at line 540
AreaQuery
joinCountryArea(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CountryArea relation
at line 575
CountryAreaQuery
useCountryAreaQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CountryArea relation CountryArea object
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
at line 621
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the area table.
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.
at line 699
AreaQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 711
AreaQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 721
AreaQuery
lastUpdatedFirst()
Order by update date desc
at line 731
AreaQuery
firstUpdatedFirst()
Order by update date asc
at line 741
AreaQuery
lastCreatedFirst()
Order by create date desc
at line 751
AreaQuery
firstCreatedFirst()
Order by create date asc
at line 64
ChildAreaQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 64
ChildAreaQuery
orderByName($order = Criteria::ASC)
Order by the name column
at line 64
ChildAreaQuery
orderByPostage($order = Criteria::ASC)
Order by the postage column
at line 64
ChildAreaQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 64
ChildAreaQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 64
ChildAreaQuery
groupById()
Group by the id column
at line 64
ChildAreaQuery
groupByName()
Group by the name column
at line 64
ChildAreaQuery
groupByPostage()
Group by the postage column
at line 64
ChildAreaQuery
groupByCreatedAt()
Group by the created_at column
at line 64
ChildAreaQuery
groupByUpdatedAt()
Group by the updated_at column
at line 64
ChildAreaQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 64
ChildAreaQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 64
ChildAreaQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 64
ChildAreaQuery
leftJoinAreaDeliveryModule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AreaDeliveryModule relation
at line 64
ChildAreaQuery
rightJoinAreaDeliveryModule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AreaDeliveryModule relation
at line 64
ChildAreaQuery
innerJoinAreaDeliveryModule($relationAlias = null)
Adds a INNER JOIN clause to the query using the AreaDeliveryModule relation
at line 64
ChildAreaQuery
leftJoinCountryArea($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CountryArea relation
at line 64
ChildAreaQuery
rightJoinCountryArea($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CountryArea relation
at line 64
ChildAreaQuery
innerJoinCountryArea($relationAlias = null)
Adds a INNER JOIN clause to the query using the CountryArea relation
at line 64
ChildArea
findOne(
ConnectionInterface $con = null)
Return the first ChildArea matching the query
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
at line 64
ChildArea
findOneById(
int $id)
Return the first ChildArea filtered by the id column
at line 64
ChildArea
findOneByName(
string $name)
Return the first ChildArea filtered by the name column
at line 64
ChildArea
findOneByPostage(
double $postage)
Return the first ChildArea filtered by the postage column
at line 64
ChildArea
findOneByCreatedAt(
string $created_at)
Return the first ChildArea filtered by the created_at column
at line 64
ChildArea
findOneByUpdatedAt(
string $updated_at)
Return the first ChildArea filtered by the updated_at column
at line 64
array
findById(
int $id)
Return ChildArea objects filtered by the id column
at line 64
array
findByName(
string $name)
Return ChildArea objects filtered by the name column
at line 64
array
findByPostage(
double $postage)
Return ChildArea objects filtered by the postage column
at line 64
array
findByCreatedAt(
string $created_at)
Return ChildArea objects filtered by the created_at column
at line 64
array
findByUpdatedAt(
string $updated_at)
Return ChildArea objects filtered by the updated_at column