TaxQuery
class TaxQuery extends ModelCriteria
Base class that represents a query for the 'tax' table.
Methods
Initializes internal state of \Thelia\Model\Base\TaxQuery object.
Returns a new ChildTaxQuery 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 type column
Filter the query on the serialized_requirements 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\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\TaxI18n object
Adds a JOIN clause to the query using the TaxI18n relation
Use the TaxI18n relation TaxI18n object
Deletes all rows from the tax table.
Performs a DELETE on the database, given a ChildTax 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
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 id column
Order by the type column
Order by the serialized_requirements column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the type column
Group by the serialized_requirements 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 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 TaxI18n relation
Adds a RIGHT JOIN clause to the query using the TaxI18n relation
Adds a INNER JOIN clause to the query using the TaxI18n relation
Return the first ChildTax matching the query
Return the first ChildTax matching the query, or a new ChildTax object populated from the query conditions when no match is found
Return the first ChildTax filtered by the id column
Return the first ChildTax filtered by the type column
Return the first ChildTax filtered by the serialized_requirements column
Return the first ChildTax filtered by the created_at column
Return the first ChildTax filtered by the updated_at column
Return ChildTax objects filtered by the id column
Return ChildTax objects filtered by the type column
Return ChildTax objects filtered by the serialized_requirements column
Return ChildTax objects filtered by the created_at column
Return ChildTax objects filtered by the updated_at column
Details
at line 75
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Tax',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\TaxQuery object.
at line 88
static
TaxQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildTaxQuery object.
at line 118
Tax|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 200
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 221
TaxQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 234
TaxQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 258
TaxQuery
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 296
TaxQuery
filterByType(
string $type = null,
string $comparison = null)
Filter the query on the type column
Example usage:
$query->filterByType('fooValue'); // WHERE type = 'fooValue'
$query->filterByType('%fooValue%'); // WHERE type LIKE '%fooValue%'
at line 325
TaxQuery
filterBySerializedRequirements(
string $serializedRequirements = null,
string $comparison = null)
Filter the query on the serialized_requirements column
Example usage:
$query->filterBySerializedRequirements('fooValue'); // WHERE serializedrequirements = 'fooValue'
$query->filterBySerializedRequirements('%fooValue%'); // WHERE serializedrequirements LIKE '%fooValue%'
at line 359
TaxQuery
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 402
TaxQuery
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 433
TaxQuery
filterByTaxRuleCountry(
TaxRuleCountry|ObjectCollection $taxRuleCountry,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRuleCountry object
at line 456
TaxQuery
joinTaxRuleCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the TaxRuleCountry relation
at line 491
TaxRuleCountryQuery
useTaxRuleCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the TaxRuleCountry relation TaxRuleCountry object
at line 506
TaxQuery
filterByTaxI18n(
TaxI18n|ObjectCollection $taxI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxI18n object
at line 529
TaxQuery
joinTaxI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the TaxI18n relation
at line 564
TaxI18nQuery
useTaxI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the TaxI18n relation TaxI18n object
at line 593
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the tax table.
at line 630
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildTax or Criteria object OR a primary key value.
at line 671
TaxQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 683
TaxQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 693
TaxQuery
lastUpdatedFirst()
Order by update date desc
at line 703
TaxQuery
firstUpdatedFirst()
Order by update date asc
at line 713
TaxQuery
lastCreatedFirst()
Order by create date desc
at line 723
TaxQuery
firstCreatedFirst()
Order by create date asc
at line 739
TaxQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
at line 757
TaxQuery
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()
at line 778
TaxI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 65
ChildTaxQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 65
ChildTaxQuery
orderByType($order = Criteria::ASC)
Order by the type column
at line 65
ChildTaxQuery
orderBySerializedRequirements($order = Criteria::ASC)
Order by the serialized_requirements column
at line 65
ChildTaxQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 65
ChildTaxQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 65
ChildTaxQuery
groupById()
Group by the id column
at line 65
ChildTaxQuery
groupByType()
Group by the type column
at line 65
ChildTaxQuery
groupBySerializedRequirements()
Group by the serialized_requirements column
at line 65
ChildTaxQuery
groupByCreatedAt()
Group by the created_at column
at line 65
ChildTaxQuery
groupByUpdatedAt()
Group by the updated_at column
at line 65
ChildTaxQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 65
ChildTaxQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 65
ChildTaxQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 65
ChildTaxQuery
leftJoinTaxRuleCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxQuery
rightJoinTaxRuleCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxQuery
innerJoinTaxRuleCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxQuery
leftJoinTaxI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxI18n relation
at line 65
ChildTaxQuery
rightJoinTaxI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxI18n relation
at line 65
ChildTaxQuery
innerJoinTaxI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxI18n relation
at line 65
ChildTax
findOne(
ConnectionInterface $con = null)
Return the first ChildTax matching the query
at line 65
ChildTax
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildTax matching the query, or a new ChildTax object populated from the query conditions when no match is found
at line 65
ChildTax
findOneById(
int $id)
Return the first ChildTax filtered by the id column
at line 65
ChildTax
findOneByType(
string $type)
Return the first ChildTax filtered by the type column
at line 65
ChildTax
findOneBySerializedRequirements(
string $serialized_requirements)
Return the first ChildTax filtered by the serialized_requirements column
at line 65
ChildTax
findOneByCreatedAt(
string $created_at)
Return the first ChildTax filtered by the created_at column
at line 65
ChildTax
findOneByUpdatedAt(
string $updated_at)
Return the first ChildTax filtered by the updated_at column
at line 65
array
findById(
int $id)
Return ChildTax objects filtered by the id column
at line 65
array
findByType(
string $type)
Return ChildTax objects filtered by the type column
at line 65
array
findBySerializedRequirements(
string $serialized_requirements)
Return ChildTax objects filtered by the serialized_requirements column
at line 65
array
findByCreatedAt(
string $created_at)
Return ChildTax objects filtered by the created_at column
at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildTax objects filtered by the updated_at column