CountryAreaQuery
class CountryAreaQuery extends ModelCriteria
Base class that represents a query for the 'country_area' table.
Methods
Initializes internal state of \Thelia\Model\Base\CountryAreaQuery object.
Returns a new ChildCountryAreaQuery object.
Find object by primary key.
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 country_id column
Filter the query on the state_id column
Filter the query on the area_id 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\Area object
Adds a JOIN clause to the query using the Area relation
Use the Area relation Area object
Filter the query by a related \Thelia\Model\Country object
Adds a JOIN clause to the query using the Country relation
Use the Country relation Country object
Deletes all rows from the country_area table.
Performs a DELETE on the database, given a ChildCountryArea 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 country_id column
Order by the state_id column
Order by the area_id column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the country_id column
Group by the state_id column
Group by the area_id 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 Area relation
Adds a RIGHT JOIN clause to the query using the Area relation
Adds a INNER JOIN clause to the query using the Area relation
Adds a LEFT JOIN clause to the query using the Country relation
Adds a RIGHT JOIN clause to the query using the Country relation
Adds a INNER JOIN clause to the query using the Country relation
Return the first ChildCountryArea matching the query
Return the first ChildCountryArea matching the query, or a new ChildCountryArea object populated from the query conditions when no match is found
Return the first ChildCountryArea filtered by the id column
Return the first ChildCountryArea filtered by the country_id column
Return the first ChildCountryArea filtered by the state_id column
Return the first ChildCountryArea filtered by the area_id column
Return the first ChildCountryArea filtered by the created_at column
Return the first ChildCountryArea filtered by the updated_at column
Return ChildCountryArea objects filtered by the id column
Return ChildCountryArea objects filtered by the country_id column
Return ChildCountryArea objects filtered by the state_id column
Return ChildCountryArea objects filtered by the area_id column
Return ChildCountryArea objects filtered by the created_at column
Return ChildCountryArea objects filtered by the updated_at column
Details
at line 78
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CountryArea',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CountryAreaQuery object.
at line 91
static
CountryAreaQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCountryAreaQuery object.
at line 121
CountryArea|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 203
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 224
CountryAreaQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 237
CountryAreaQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 261
CountryAreaQuery
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 304
CountryAreaQuery
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
at line 345
CountryAreaQuery
filterByStateId(
mixed $stateId = null,
string $comparison = null)
Filter the query on the state_id column
Example usage:
$query->filterByStateId(1234); // WHERE stateid = 1234
$query->filterByStateId(array(12, 34)); // WHERE stateid IN (12, 34)
$query->filterByStateId(array('min' => 12)); // WHERE state_id > 12
at line 388
CountryAreaQuery
filterByAreaId(
mixed $areaId = null,
string $comparison = null)
Filter the query on the area_id column
Example usage:
$query->filterByAreaId(1234); // WHERE areaid = 1234
$query->filterByAreaId(array(12, 34)); // WHERE areaid IN (12, 34)
$query->filterByAreaId(array('min' => 12)); // WHERE area_id > 12
at line 431
CountryAreaQuery
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 474
CountryAreaQuery
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 505
CountryAreaQuery
filterByArea(
Area|ObjectCollection $area,
string $comparison = null)
Filter the query by a related \Thelia\Model\Area object
at line 530
CountryAreaQuery
joinArea(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Area relation
at line 565
AreaQuery
useAreaQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Area relation Area object
at line 580
CountryAreaQuery
filterByCountry(
Country|ObjectCollection $country,
string $comparison = null)
Filter the query by a related \Thelia\Model\Country object
at line 605
CountryAreaQuery
joinCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Country relation
at line 640
CountryQuery
useCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Country relation Country object
at line 654
CountryAreaQuery
prune(
CountryArea $countryArea = null)
Exclude object from result
at line 669
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the country_area table.
at line 706
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCountryArea or Criteria object OR a primary key value.
at line 747
CountryAreaQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 759
CountryAreaQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 769
CountryAreaQuery
lastUpdatedFirst()
Order by update date desc
at line 779
CountryAreaQuery
firstUpdatedFirst()
Order by update date asc
at line 789
CountryAreaQuery
lastCreatedFirst()
Order by create date desc
at line 799
CountryAreaQuery
firstCreatedFirst()
Order by create date asc
at line 68
ChildCountryAreaQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 68
ChildCountryAreaQuery
orderByCountryId($order = Criteria::ASC)
Order by the country_id column
at line 68
ChildCountryAreaQuery
orderByStateId($order = Criteria::ASC)
Order by the state_id column
at line 68
ChildCountryAreaQuery
orderByAreaId($order = Criteria::ASC)
Order by the area_id column
at line 68
ChildCountryAreaQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 68
ChildCountryAreaQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 68
ChildCountryAreaQuery
groupById()
Group by the id column
at line 68
ChildCountryAreaQuery
groupByCountryId()
Group by the country_id column
at line 68
ChildCountryAreaQuery
groupByStateId()
Group by the state_id column
at line 68
ChildCountryAreaQuery
groupByAreaId()
Group by the area_id column
at line 68
ChildCountryAreaQuery
groupByCreatedAt()
Group by the created_at column
at line 68
ChildCountryAreaQuery
groupByUpdatedAt()
Group by the updated_at column
at line 68
ChildCountryAreaQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 68
ChildCountryAreaQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 68
ChildCountryAreaQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 68
ChildCountryAreaQuery
leftJoinArea($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Area relation
at line 68
ChildCountryAreaQuery
rightJoinArea($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Area relation
at line 68
ChildCountryAreaQuery
innerJoinArea($relationAlias = null)
Adds a INNER JOIN clause to the query using the Area relation
at line 68
ChildCountryAreaQuery
leftJoinCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Country relation
at line 68
ChildCountryAreaQuery
rightJoinCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Country relation
at line 68
ChildCountryAreaQuery
innerJoinCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the Country relation
at line 68
ChildCountryArea
findOne(
ConnectionInterface $con = null)
Return the first ChildCountryArea matching the query
at line 68
ChildCountryArea
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCountryArea matching the query, or a new ChildCountryArea object populated from the query conditions when no match is found
at line 68
ChildCountryArea
findOneById(
int $id)
Return the first ChildCountryArea filtered by the id column
at line 68
ChildCountryArea
findOneByCountryId(
int $country_id)
Return the first ChildCountryArea filtered by the country_id column
at line 68
ChildCountryArea
findOneByStateId(
int $state_id)
Return the first ChildCountryArea filtered by the state_id column
at line 68
ChildCountryArea
findOneByAreaId(
int $area_id)
Return the first ChildCountryArea filtered by the area_id column
at line 68
ChildCountryArea
findOneByCreatedAt(
string $created_at)
Return the first ChildCountryArea filtered by the created_at column
at line 68
ChildCountryArea
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCountryArea filtered by the updated_at column
at line 68
array
findById(
int $id)
Return ChildCountryArea objects filtered by the id column
at line 68
array
findByCountryId(
int $country_id)
Return ChildCountryArea objects filtered by the country_id column
at line 68
array
findByStateId(
int $state_id)
Return ChildCountryArea objects filtered by the state_id column
at line 68
array
findByAreaId(
int $area_id)
Return ChildCountryArea objects filtered by the area_id column
at line 68
array
findByCreatedAt(
string $created_at)
Return ChildCountryArea objects filtered by the created_at column
at line 68
array
findByUpdatedAt(
string $updated_at)
Return ChildCountryArea objects filtered by the updated_at column