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