StateQuery
class StateQuery extends StateQuery
Skeleton subclass for performing query and update operations on the 'state' 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\StateQuery object.
Returns a new ChildStateQuery 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 visible column
Filter the query on the isocode column
Filter the query on the country_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\Country object
Adds a JOIN clause to the query using the Country relation
Use the Country relation Country object
Filter the query by a related \Thelia\Model\TaxRuleCountry object
Adds a JOIN clause to the query using the TaxRuleCountry relation
Use the TaxRuleCountry relation TaxRuleCountry object
Filter the query by a related \Thelia\Model\Address object
Adds a JOIN clause to the query using the Address relation
Use the Address relation Address object
Filter the query by a related \Thelia\Model\OrderAddress object
Adds a JOIN clause to the query using the OrderAddress relation
Use the OrderAddress relation OrderAddress object
Filter the query by a related \Thelia\Model\StateI18n object
Adds a JOIN clause to the query using the StateI18n relation
Use the StateI18n relation StateI18n object
Deletes all rows from the state table.
Performs a DELETE on the database, given a ChildState or Criteria object OR a primary key value.
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Order by the country_id column
Order by the created_at column
Order by the updated_at column
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
Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation
Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation
Adds a INNER JOIN clause to the query using the TaxRuleCountry relation
Adds a LEFT JOIN clause to the query using the Address relation
Adds a RIGHT JOIN clause to the query using the Address relation
Adds a INNER JOIN clause to the query using the Address relation
Adds a LEFT JOIN clause to the query using the OrderAddress relation
Adds a RIGHT JOIN clause to the query using the OrderAddress relation
Adds a INNER JOIN clause to the query using the OrderAddress relation
Adds a LEFT JOIN clause to the query using the StateI18n relation
Adds a RIGHT JOIN clause to the query using the StateI18n relation
Adds a INNER JOIN clause to the query using the StateI18n relation
Return the first ChildState matching the query
Return the first ChildState matching the query, or a new ChildState object populated from the query conditions when no match is found
Return the first ChildState filtered by the id column
Return the first ChildState filtered by the visible column
Return the first ChildState filtered by the isocode column
Return the first ChildState filtered by the country_id column
Return the first ChildState filtered by the created_at column
Return the first ChildState filtered by the updated_at column
Return ChildState objects filtered by the visible column
Return ChildState objects filtered by the isocode column
Return ChildState objects filtered by the country_id column
Return ChildState objects filtered by the created_at column
Return ChildState objects filtered by the updated_at column
Details
in
StateQuery at line 91
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\State',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\StateQuery object.
in
StateQuery at line 104
static
StateQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildStateQuery object.
in
StateQuery at line 134
State|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
StateQuery at line 216
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
StateQuery at line 237
StateQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
StateQuery at line 250
StateQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
StateQuery at line 274
StateQuery
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
StateQuery at line 315
StateQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
in
StateQuery at line 353
StateQuery
filterByIsocode(
string $isocode = null,
string $comparison = null)
Filter the query on the isocode column
Example usage:
$query->filterByIsocode('fooValue'); // WHERE isocode = 'fooValue'
$query->filterByIsocode('%fooValue%'); // WHERE isocode LIKE '%fooValue%'
in
StateQuery at line 387
StateQuery
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
in
StateQuery at line 430
StateQuery
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
StateQuery at line 473
StateQuery
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
StateQuery at line 504
StateQuery
filterByCountry(
Country|ObjectCollection $country,
string $comparison = null)
Filter the query by a related \Thelia\Model\Country object
in
StateQuery at line 529
StateQuery
joinCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Country relation
in
StateQuery at line 564
CountryQuery
useCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Country relation Country object
in
StateQuery at line 579
StateQuery
filterByTaxRuleCountry(
TaxRuleCountry|ObjectCollection $taxRuleCountry,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRuleCountry object
in
StateQuery at line 602
StateQuery
joinTaxRuleCountry(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the TaxRuleCountry relation
in
StateQuery at line 637
TaxRuleCountryQuery
useTaxRuleCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the TaxRuleCountry relation TaxRuleCountry object
in
StateQuery at line 652
StateQuery
filterByAddress(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
in
StateQuery at line 675
StateQuery
joinAddress(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Address relation
in
StateQuery at line 710
AddressQuery
useAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Address relation Address object
in
StateQuery at line 725
StateQuery
filterByOrderAddress(
OrderAddress|ObjectCollection $orderAddress,
string $comparison = null)
Filter the query by a related \Thelia\Model\OrderAddress object
in
StateQuery at line 748
StateQuery
joinOrderAddress(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the OrderAddress relation
in
StateQuery at line 783
OrderAddressQuery
useOrderAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the OrderAddress relation OrderAddress object
in
StateQuery at line 798
StateQuery
filterByStateI18n(
StateI18n|ObjectCollection $stateI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\StateI18n object
in
StateQuery at line 821
StateQuery
joinStateI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the StateI18n relation
in
StateQuery at line 856
StateI18nQuery
useStateI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the StateI18n relation StateI18n object
in
StateQuery at line 870
StateQuery
prune(
State $state = null)
Exclude object from result
in
StateQuery at line 885
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the state table.
in
StateQuery at line 922
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildState or Criteria object OR a primary key value.
in
StateQuery at line 963
StateQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
StateQuery at line 975
StateQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
StateQuery at line 985
StateQuery
lastUpdatedFirst()
Order by update date desc
in
StateQuery at line 995
StateQuery
firstUpdatedFirst()
Order by update date asc
in
StateQuery at line 1005
StateQuery
lastCreatedFirst()
Order by create date desc
in
StateQuery at line 1015
StateQuery
firstCreatedFirst()
Order by create date asc
in
StateQuery at line 1031
StateQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
in
StateQuery at line 1049
StateQuery
joinWithI18n(
string $locale = 'en_US',
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query and hydrates the related I18n object.
Shortcut for $c->joinI18n($locale)->with()
in
StateQuery at line 1070
StateI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
StateQuery at line 81
ChildStateQuery
orderById($order = Criteria::ASC)
Order by the id column
in
StateQuery at line 81
ChildStateQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
StateQuery at line 81
ChildStateQuery
orderByIsocode($order = Criteria::ASC)
Order by the isocode column
in
StateQuery at line 81
ChildStateQuery
orderByCountryId($order = Criteria::ASC)
Order by the country_id column
in
StateQuery at line 81
ChildStateQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
StateQuery at line 81
ChildStateQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
StateQuery at line 81
ChildStateQuery
groupById()
Group by the id column
in
StateQuery at line 81
ChildStateQuery
groupByVisible()
Group by the visible column
in
StateQuery at line 81
ChildStateQuery
groupByIsocode()
Group by the isocode column
in
StateQuery at line 81
ChildStateQuery
groupByCountryId()
Group by the country_id column
in
StateQuery at line 81
ChildStateQuery
groupByCreatedAt()
Group by the created_at column
in
StateQuery at line 81
ChildStateQuery
groupByUpdatedAt()
Group by the updated_at column
in
StateQuery at line 81
ChildStateQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
StateQuery at line 81
ChildStateQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
StateQuery at line 81
ChildStateQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
StateQuery at line 81
ChildStateQuery
leftJoinCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Country relation
in
StateQuery at line 81
ChildStateQuery
rightJoinCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Country relation
in
StateQuery at line 81
ChildStateQuery
innerJoinCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the Country relation
in
StateQuery at line 81
ChildStateQuery
leftJoinTaxRuleCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation
in
StateQuery at line 81
ChildStateQuery
rightJoinTaxRuleCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation
in
StateQuery at line 81
ChildStateQuery
innerJoinTaxRuleCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRuleCountry relation
in
StateQuery at line 81
ChildStateQuery
leftJoinAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Address relation
in
StateQuery at line 81
ChildStateQuery
rightJoinAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Address relation
in
StateQuery at line 81
ChildStateQuery
innerJoinAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the Address relation
in
StateQuery at line 81
ChildStateQuery
leftJoinOrderAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the OrderAddress relation
in
StateQuery at line 81
ChildStateQuery
rightJoinOrderAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the OrderAddress relation
in
StateQuery at line 81
ChildStateQuery
innerJoinOrderAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the OrderAddress relation
in
StateQuery at line 81
ChildStateQuery
leftJoinStateI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the StateI18n relation
in
StateQuery at line 81
ChildStateQuery
rightJoinStateI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the StateI18n relation
in
StateQuery at line 81
ChildStateQuery
innerJoinStateI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the StateI18n relation
in
StateQuery at line 81
ChildState
findOne(
ConnectionInterface $con = null)
Return the first ChildState matching the query
in
StateQuery at line 81
ChildState
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildState matching the query, or a new ChildState object populated from the query conditions when no match is found
in
StateQuery at line 81
ChildState
findOneById(
int $id)
Return the first ChildState filtered by the id column
in
StateQuery at line 81
ChildState
findOneByVisible(
int $visible)
Return the first ChildState filtered by the visible column
in
StateQuery at line 81
ChildState
findOneByIsocode(
string $isocode)
Return the first ChildState filtered by the isocode column
in
StateQuery at line 81
ChildState
findOneByCountryId(
int $country_id)
Return the first ChildState filtered by the country_id column
in
StateQuery at line 81
ChildState
findOneByCreatedAt(
string $created_at)
Return the first ChildState filtered by the created_at column
in
StateQuery at line 81
ChildState
findOneByUpdatedAt(
string $updated_at)
Return the first ChildState filtered by the updated_at column
in
StateQuery at line 81
array
findById(
int $id)
Return ChildState objects filtered by the id column
in
StateQuery at line 81
array
findByVisible(
int $visible)
Return ChildState objects filtered by the visible column
in
StateQuery at line 81
array
findByIsocode(
string $isocode)
Return ChildState objects filtered by the isocode column
in
StateQuery at line 81
array
findByCountryId(
int $country_id)
Return ChildState objects filtered by the country_id column
in
StateQuery at line 81
array
findByCreatedAt(
string $created_at)
Return ChildState objects filtered by the created_at column
in
StateQuery at line 81
array
findByUpdatedAt(
string $updated_at)
Return ChildState objects filtered by the updated_at column