AreaQuery
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
Initializes internal state of \Thelia\Model\Base\AreaQuery object.
Returns a new ChildAreaQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
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.
Order by the created_at column
Order by the updated_at column
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 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 postage column
Return ChildArea objects filtered by the created_at column
Return ChildArea objects filtered by the updated_at column
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.
in
AreaQuery at line 87
static
AreaQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAreaQuery object.
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);
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);
in
AreaQuery at line 233
AreaQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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%'
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
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'
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'
in
AreaQuery at line 444
AreaQuery
filterByAreaDeliveryModule(
AreaDeliveryModule|ObjectCollection $areaDeliveryModule,
string $comparison = null)
Filter the query by a related \Thelia\Model\AreaDeliveryModule object
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
in
AreaQuery at line 502
AreaDeliveryModuleQuery
useAreaDeliveryModuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AreaDeliveryModule relation AreaDeliveryModule object
in
AreaQuery at line 517
AreaQuery
filterByCountryArea(
CountryArea|ObjectCollection $countryArea,
string $comparison = null)
Filter the query by a related \Thelia\Model\CountryArea object
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
in
AreaQuery at line 575
CountryAreaQuery
useCountryAreaQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CountryArea relation CountryArea object
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
in
AreaQuery at line 621
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the area table.
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.
in
AreaQuery at line 64
ChildAreaQuery
orderById($order = Criteria::ASC)
Order by the id column
in
AreaQuery at line 64
ChildAreaQuery
orderByName($order = Criteria::ASC)
Order by the name column
in
AreaQuery at line 64
ChildAreaQuery
orderByPostage($order = Criteria::ASC)
Order by the postage column
in
AreaQuery at line 64
ChildAreaQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
AreaQuery at line 64
ChildAreaQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
AreaQuery at line 64
ChildAreaQuery
groupById()
Group by the id column
in
AreaQuery at line 64
ChildAreaQuery
groupByName()
Group by the name column
in
AreaQuery at line 64
ChildAreaQuery
groupByPostage()
Group by the postage column
in
AreaQuery at line 64
ChildAreaQuery
groupByCreatedAt()
Group by the created_at column
in
AreaQuery at line 64
ChildAreaQuery
groupByUpdatedAt()
Group by the updated_at column
in
AreaQuery at line 64
ChildAreaQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
AreaQuery at line 64
ChildAreaQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
AreaQuery at line 64
ChildAreaQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
AreaQuery at line 64
ChildAreaQuery
leftJoinAreaDeliveryModule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AreaDeliveryModule relation
in
AreaQuery at line 64
ChildAreaQuery
rightJoinAreaDeliveryModule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AreaDeliveryModule relation
in
AreaQuery at line 64
ChildAreaQuery
innerJoinAreaDeliveryModule($relationAlias = null)
Adds a INNER JOIN clause to the query using the AreaDeliveryModule relation
in
AreaQuery at line 64
ChildAreaQuery
leftJoinCountryArea($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CountryArea relation
in
AreaQuery at line 64
ChildAreaQuery
rightJoinCountryArea($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CountryArea relation
in
AreaQuery at line 64
ChildAreaQuery
innerJoinCountryArea($relationAlias = null)
Adds a INNER JOIN clause to the query using the CountryArea relation
in
AreaQuery at line 64
ChildArea
findOne(
ConnectionInterface $con = null)
Return the first ChildArea matching the query
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
in
AreaQuery at line 64
ChildArea
findOneById(
int $id)
Return the first ChildArea filtered by the id column
in
AreaQuery at line 64
ChildArea
findOneByName(
string $name)
Return the first ChildArea filtered by the name column
in
AreaQuery at line 64
ChildArea
findOneByPostage(
double $postage)
Return the first ChildArea filtered by the postage column
in
AreaQuery at line 64
ChildArea
findOneByCreatedAt(
string $created_at)
Return the first ChildArea filtered by the created_at column
in
AreaQuery at line 64
ChildArea
findOneByUpdatedAt(
string $updated_at)
Return the first ChildArea filtered by the updated_at column
in
AreaQuery at line 64
array
findById(
int $id)
Return ChildArea objects filtered by the id column
in
AreaQuery at line 64
array
findByName(
string $name)
Return ChildArea objects filtered by the name column
in
AreaQuery at line 64
array
findByPostage(
double $postage)
Return ChildArea objects filtered by the postage column
in
AreaQuery at line 64
array
findByCreatedAt(
string $created_at)
Return ChildArea objects filtered by the created_at column
in
AreaQuery at line 64
array
findByUpdatedAt(
string $updated_at)
Return ChildArea objects filtered by the updated_at column