TaxRuleQuery
class TaxRuleQuery extends ModelCriteria
Base class that represents a query for the 'tax_rule' table.
Methods
Initializes internal state of \Thelia\Model\Base\TaxRuleQuery object.
Returns a new ChildTaxRuleQuery 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 is_default 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\Product object
Adds a JOIN clause to the query using the Product relation
Use the Product relation Product 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\TaxRuleI18n object
Adds a JOIN clause to the query using the TaxRuleI18n relation
Use the TaxRuleI18n relation TaxRuleI18n object
Deletes all rows from the tax_rule table.
Performs a DELETE on the database, given a ChildTaxRule 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 is_default column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the is_default 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 Product relation
Adds a RIGHT JOIN clause to the query using the Product relation
Adds a INNER JOIN clause to the query using the Product 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 TaxRuleI18n relation
Adds a RIGHT JOIN clause to the query using the TaxRuleI18n relation
Adds a INNER JOIN clause to the query using the TaxRuleI18n relation
Return the first ChildTaxRule matching the query
Return the first ChildTaxRule matching the query, or a new ChildTaxRule object populated from the query conditions when no match is found
Return the first ChildTaxRule filtered by the id column
Return the first ChildTaxRule filtered by the is_default column
Return the first ChildTaxRule filtered by the created_at column
Return the first ChildTaxRule filtered by the updated_at column
Return ChildTaxRule objects filtered by the id column
Return ChildTaxRule objects filtered by the is_default column
Return ChildTaxRule objects filtered by the created_at column
Return ChildTaxRule objects filtered by the updated_at column
Details
at line 75
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\TaxRule',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\TaxRuleQuery object.
at line 88
static
TaxRuleQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildTaxRuleQuery object.
at line 118
TaxRule|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
TaxRuleQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 234
TaxRuleQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 258
TaxRuleQuery
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 299
TaxRuleQuery
filterByIsDefault(
boolean|string $isDefault = null,
string $comparison = null)
Filter the query on the is_default column
Example usage:
$query->filterByIsDefault(true); // WHERE isdefault = true
$query->filterByIsDefault('yes'); // WHERE isdefault = true
at line 328
TaxRuleQuery
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 371
TaxRuleQuery
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 402
TaxRuleQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 425
TaxRuleQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Product relation
at line 460
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Product relation Product object
at line 475
TaxRuleQuery
filterByTaxRuleCountry(
TaxRuleCountry|ObjectCollection $taxRuleCountry,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRuleCountry object
at line 498
TaxRuleQuery
joinTaxRuleCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the TaxRuleCountry relation
at line 533
TaxRuleCountryQuery
useTaxRuleCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the TaxRuleCountry relation TaxRuleCountry object
at line 548
TaxRuleQuery
filterByTaxRuleI18n(
TaxRuleI18n|ObjectCollection $taxRuleI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRuleI18n object
at line 571
TaxRuleQuery
joinTaxRuleI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the TaxRuleI18n relation
at line 606
TaxRuleI18nQuery
useTaxRuleI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the TaxRuleI18n relation TaxRuleI18n object
at line 620
TaxRuleQuery
prune(
TaxRule $taxRule = null)
Exclude object from result
at line 635
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the tax_rule table.
at line 672
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildTaxRule or Criteria object OR a primary key value.
at line 713
TaxRuleQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 725
TaxRuleQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 735
TaxRuleQuery
lastUpdatedFirst()
Order by update date desc
at line 745
TaxRuleQuery
firstUpdatedFirst()
Order by update date asc
at line 755
TaxRuleQuery
lastCreatedFirst()
Order by create date desc
at line 765
TaxRuleQuery
firstCreatedFirst()
Order by create date asc
at line 781
TaxRuleQuery
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 799
TaxRuleQuery
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 820
TaxRuleI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 65
ChildTaxRuleQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 65
ChildTaxRuleQuery
orderByIsDefault($order = Criteria::ASC)
Order by the is_default column
at line 65
ChildTaxRuleQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 65
ChildTaxRuleQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 65
ChildTaxRuleQuery
groupById()
Group by the id column
at line 65
ChildTaxRuleQuery
groupByIsDefault()
Group by the is_default column
at line 65
ChildTaxRuleQuery
groupByCreatedAt()
Group by the created_at column
at line 65
ChildTaxRuleQuery
groupByUpdatedAt()
Group by the updated_at column
at line 65
ChildTaxRuleQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 65
ChildTaxRuleQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 65
ChildTaxRuleQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 65
ChildTaxRuleQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
at line 65
ChildTaxRuleQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
at line 65
ChildTaxRuleQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
at line 65
ChildTaxRuleQuery
leftJoinTaxRuleCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxRuleQuery
rightJoinTaxRuleCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxRuleQuery
innerJoinTaxRuleCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRuleCountry relation
at line 65
ChildTaxRuleQuery
leftJoinTaxRuleI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRuleI18n relation
at line 65
ChildTaxRuleQuery
rightJoinTaxRuleI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRuleI18n relation
at line 65
ChildTaxRuleQuery
innerJoinTaxRuleI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRuleI18n relation
at line 65
ChildTaxRule
findOne(
ConnectionInterface $con = null)
Return the first ChildTaxRule matching the query
at line 65
ChildTaxRule
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildTaxRule matching the query, or a new ChildTaxRule object populated from the query conditions when no match is found
at line 65
ChildTaxRule
findOneById(
int $id)
Return the first ChildTaxRule filtered by the id column
at line 65
ChildTaxRule
findOneByIsDefault(
boolean $is_default)
Return the first ChildTaxRule filtered by the is_default column
at line 65
ChildTaxRule
findOneByCreatedAt(
string $created_at)
Return the first ChildTaxRule filtered by the created_at column
at line 65
ChildTaxRule
findOneByUpdatedAt(
string $updated_at)
Return the first ChildTaxRule filtered by the updated_at column
at line 65
array
findById(
int $id)
Return ChildTaxRule objects filtered by the id column
at line 65
array
findByIsDefault(
boolean $is_default)
Return ChildTaxRule objects filtered by the is_default column
at line 65
array
findByCreatedAt(
string $created_at)
Return ChildTaxRule objects filtered by the created_at column
at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildTaxRule objects filtered by the updated_at column