class TaxQuery extends ModelCriteria

Base class that represents a query for the 'tax' table.

Methods

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\Tax', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\TaxQuery object.

static  TaxQuery
create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildTaxQuery object.

Tax|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByType( string $type = null, string $comparison = null)

Filter the query on the type column

filterBySerializedRequirements( string $serializedRequirements = null, string $comparison = null)

Filter the query on the serialized_requirements column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByTaxRuleCountry( TaxRuleCountry|ObjectCollection $taxRuleCountry, string $comparison = null)

Filter the query by a related \Thelia\Model\TaxRuleCountry object

joinTaxRuleCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the TaxRuleCountry relation

useTaxRuleCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the TaxRuleCountry relation TaxRuleCountry object

filterByTaxI18n( TaxI18n|ObjectCollection $taxI18n, string $comparison = null)

Filter the query by a related \Thelia\Model\TaxI18n object

joinTaxI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the TaxI18n relation

useTaxI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the TaxI18n relation TaxI18n object

prune( Tax $tax = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the tax table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildTax or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query and hydrates the related I18n object.

useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

ChildTaxQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildTaxQuery
orderByType($order = Criteria::ASC)

Order by the type column

ChildTaxQuery
orderBySerializedRequirements($order = Criteria::ASC)

Order by the serialized_requirements column

ChildTaxQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildTaxQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildTaxQuery
groupById()

Group by the id column

ChildTaxQuery
groupByType()

Group by the type column

ChildTaxQuery
groupBySerializedRequirements()

Group by the serialized_requirements column

ChildTaxQuery
groupByCreatedAt()

Group by the created_at column

ChildTaxQuery
groupByUpdatedAt()

Group by the updated_at column

ChildTaxQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildTaxQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildTaxQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildTaxQuery
leftJoinTaxRuleCountry($relationAlias = null)

Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation

ChildTaxQuery
rightJoinTaxRuleCountry($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation

ChildTaxQuery
innerJoinTaxRuleCountry($relationAlias = null)

Adds a INNER JOIN clause to the query using the TaxRuleCountry relation

ChildTaxQuery
leftJoinTaxI18n($relationAlias = null)

Adds a LEFT JOIN clause to the query using the TaxI18n relation

ChildTaxQuery
rightJoinTaxI18n($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the TaxI18n relation

ChildTaxQuery
innerJoinTaxI18n($relationAlias = null)

Adds a INNER JOIN clause to the query using the TaxI18n relation

ChildTax
findOne( ConnectionInterface $con = null)

Return the first ChildTax matching the query

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

ChildTax
findOneById( int $id)

Return the first ChildTax filtered by the id column

ChildTax
findOneByType( string $type)

Return the first ChildTax filtered by the type column

ChildTax
findOneBySerializedRequirements( string $serialized_requirements)

Return the first ChildTax filtered by the serialized_requirements column

ChildTax
findOneByCreatedAt( string $created_at)

Return the first ChildTax filtered by the created_at column

ChildTax
findOneByUpdatedAt( string $updated_at)

Return the first ChildTax filtered by the updated_at column

array
findById( int $id)

Return ChildTax objects filtered by the id column

array
findByType( string $type)

Return ChildTax objects filtered by the type column

array
findBySerializedRequirements( string $serialized_requirements)

Return ChildTax objects filtered by the serialized_requirements column

array
findByCreatedAt( string $created_at)

Return ChildTax objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

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.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

at line 88
static TaxQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildTaxQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

TaxQuery

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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

Tax|array|mixed the result, formatted by the current formatter

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);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

at line 221
TaxQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

TaxQuery The current query, for fluid interface

at line 234
TaxQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

TaxQuery The current query, for fluid interface

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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

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%'

Parameters

string $type The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

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%'

Parameters

string $serializedRequirements The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

at line 433
TaxQuery filterByTaxRuleCountry( TaxRuleCountry|ObjectCollection $taxRuleCountry, string $comparison = null)

Filter the query by a related \Thelia\Model\TaxRuleCountry object

Parameters

TaxRuleCountry|ObjectCollection $taxRuleCountry the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

at line 456
TaxQuery joinTaxRuleCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the TaxRuleCountry relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TaxQuery The current query, for fluid interface

at line 491
TaxRuleCountryQuery useTaxRuleCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the TaxRuleCountry relation TaxRuleCountry object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TaxRuleCountryQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 506
TaxQuery filterByTaxI18n( TaxI18n|ObjectCollection $taxI18n, string $comparison = null)

Filter the query by a related \Thelia\Model\TaxI18n object

Parameters

TaxI18n|ObjectCollection $taxI18n the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

TaxQuery The current query, for fluid interface

at line 529
TaxQuery joinTaxI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the TaxI18n relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TaxQuery The current query, for fluid interface

at line 564
TaxI18nQuery useTaxI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the TaxI18n relation TaxI18n object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TaxI18nQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 578
TaxQuery prune( Tax $tax = null)

Exclude object from result

Parameters

Tax $tax Object to remove from the list of results

Return Value

TaxQuery The current query, for fluid interface

at line 593
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the tax table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

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.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

at line 671
TaxQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

TaxQuery The current query, for fluid interface

at line 683
TaxQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

TaxQuery The current query, for fluid interface

at line 693
TaxQuery lastUpdatedFirst()

Order by update date desc

Return Value

TaxQuery The current query, for fluid interface

at line 703
TaxQuery firstUpdatedFirst()

Order by update date asc

Return Value

TaxQuery The current query, for fluid interface

at line 713
TaxQuery lastCreatedFirst()

Order by create date desc

Return Value

TaxQuery The current query, for fluid interface

at line 723
TaxQuery firstCreatedFirst()

Order by create date asc

Return Value

TaxQuery The current query, for fluid interface

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

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

TaxQuery The current query, for fluid interface

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()

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

TaxQuery The current query, for fluid interface

at line 778
TaxI18nQuery useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

TaxI18nQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 65
ChildTaxQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery orderByType($order = Criteria::ASC)

Order by the type column

Parameters

$order

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery orderBySerializedRequirements($order = Criteria::ASC)

Order by the serialized_requirements column

Parameters

$order

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery groupById()

Group by the id column

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery groupByType()

Group by the type column

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery groupBySerializedRequirements()

Group by the serialized_requirements column

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery leftJoinTaxRuleCountry($relationAlias = null)

Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery rightJoinTaxRuleCountry($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery innerJoinTaxRuleCountry($relationAlias = null)

Adds a INNER JOIN clause to the query using the TaxRuleCountry relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery leftJoinTaxI18n($relationAlias = null)

Adds a LEFT JOIN clause to the query using the TaxI18n relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery rightJoinTaxI18n($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the TaxI18n relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTaxQuery innerJoinTaxI18n($relationAlias = null)

Adds a INNER JOIN clause to the query using the TaxI18n relation

Parameters

$relationAlias

Return Value

ChildTaxQuery

at line 65
ChildTax findOne( ConnectionInterface $con = null)

Return the first ChildTax matching the query

Parameters

ConnectionInterface $con

Return Value

ChildTax

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

Parameters

ConnectionInterface $con

Return Value

ChildTax

at line 65
ChildTax findOneById( int $id)

Return the first ChildTax filtered by the id column

Parameters

int $id

Return Value

ChildTax

at line 65
ChildTax findOneByType( string $type)

Return the first ChildTax filtered by the type column

Parameters

string $type

Return Value

ChildTax

at line 65
ChildTax findOneBySerializedRequirements( string $serialized_requirements)

Return the first ChildTax filtered by the serialized_requirements column

Parameters

string $serialized_requirements

Return Value

ChildTax

at line 65
ChildTax findOneByCreatedAt( string $created_at)

Return the first ChildTax filtered by the created_at column

Parameters

string $created_at

Return Value

ChildTax

at line 65
ChildTax findOneByUpdatedAt( string $updated_at)

Return the first ChildTax filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildTax

at line 65
array findById( int $id)

Return ChildTax objects filtered by the id column

Parameters

int $id

Return Value

array

at line 65
array findByType( string $type)

Return ChildTax objects filtered by the type column

Parameters

string $type

Return Value

array

at line 65
array findBySerializedRequirements( string $serialized_requirements)

Return ChildTax objects filtered by the serialized_requirements column

Parameters

string $serialized_requirements

Return Value

array

at line 65
array findByCreatedAt( string $created_at)

Return ChildTax objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 65
array findByUpdatedAt( string $updated_at)

Return ChildTax objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array