TaxRuleCountryQuery
class TaxRuleCountryQuery extends TaxRuleCountryQuery
Skeleton subclass for performing query and update operations on the 'taxrulecountry' 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\TaxRuleCountryQuery object.
Returns a new ChildTaxRuleCountryQuery 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 taxruleid column
Filter the query on the country_id column
Filter the query on the state_id column
Filter the query on the tax_id column
Filter the query on the position 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\Tax object
Adds a JOIN clause to the query using the Tax relation
Use the Tax relation Tax object
Filter the query by a related \Thelia\Model\TaxRule object
Adds a JOIN clause to the query using the TaxRule relation
Use the TaxRule relation TaxRule object
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\State object
Adds a JOIN clause to the query using the State relation
Use the State relation State object
Deletes all rows from the taxrulecountry table.
Performs a DELETE on the database, given a ChildTaxRuleCountry or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by the id column
Order by the taxruleid column
Order by the country_id column
Order by the state_id column
Order by the tax_id column
Order by the position column
Order by the created_at column
Order 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 Tax relation
Adds a RIGHT JOIN clause to the query using the Tax relation
Adds a INNER JOIN clause to the query using the Tax relation
Adds a LEFT JOIN clause to the query using the TaxRule relation
Adds a RIGHT JOIN clause to the query using the TaxRule relation
Adds a INNER JOIN clause to the query using the TaxRule relation
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 State relation
Adds a RIGHT JOIN clause to the query using the State relation
Adds a INNER JOIN clause to the query using the State relation
Return the first ChildTaxRuleCountry matching the query
Return the first ChildTaxRuleCountry matching the query, or a new ChildTaxRuleCountry object populated from the query conditions when no match is found
Return the first ChildTaxRuleCountry filtered by the id column
Return the first ChildTaxRuleCountry filtered by the taxruleid column
Return the first ChildTaxRuleCountry filtered by the country_id column
Return the first ChildTaxRuleCountry filtered by the state_id column
Return the first ChildTaxRuleCountry filtered by the tax_id column
Return the first ChildTaxRuleCountry filtered by the position column
Return the first ChildTaxRuleCountry filtered by the created_at column
Return the first ChildTaxRuleCountry filtered by the updated_at column
Return ChildTaxRuleCountry objects filtered by the id column
Return ChildTaxRuleCountry objects filtered by the taxruleid column
Return ChildTaxRuleCountry objects filtered by the country_id column
Return ChildTaxRuleCountry objects filtered by the state_id column
Return ChildTaxRuleCountry objects filtered by the tax_id column
Return ChildTaxRuleCountry objects filtered by the position column
Return ChildTaxRuleCountry objects filtered by the created_at column
Return ChildTaxRuleCountry objects filtered by the updated_at column
Details
in
TaxRuleCountryQuery at line 94
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\TaxRuleCountry',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\TaxRuleCountryQuery object.
in
TaxRuleCountryQuery at line 107
static
TaxRuleCountryQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildTaxRuleCountryQuery object.
in
TaxRuleCountryQuery at line 137
TaxRuleCountry|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
TaxRuleCountryQuery at line 219
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
TaxRuleCountryQuery at line 240
TaxRuleCountryQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
TaxRuleCountryQuery at line 253
TaxRuleCountryQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
TaxRuleCountryQuery at line 277
TaxRuleCountryQuery
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
TaxRuleCountryQuery at line 320
TaxRuleCountryQuery
filterByTaxRuleId(
mixed $taxRuleId = null,
string $comparison = null)
Filter the query on the taxruleid column
Example usage:
$query->filterByTaxRuleId(1234); // WHERE taxruleid = 1234
$query->filterByTaxRuleId(array(12, 34)); // WHERE taxruleid IN (12, 34)
$query->filterByTaxRuleId(array('min' => 12)); // WHERE taxruleid > 12
in
TaxRuleCountryQuery at line 363
TaxRuleCountryQuery
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
TaxRuleCountryQuery at line 406
TaxRuleCountryQuery
filterByStateId(
mixed $stateId = null,
string $comparison = null)
Filter the query on the state_id column
Example usage:
$query->filterByStateId(1234); // WHERE stateid = 1234
$query->filterByStateId(array(12, 34)); // WHERE stateid IN (12, 34)
$query->filterByStateId(array('min' => 12)); // WHERE state_id > 12
in
TaxRuleCountryQuery at line 449
TaxRuleCountryQuery
filterByTaxId(
mixed $taxId = null,
string $comparison = null)
Filter the query on the tax_id column
Example usage:
$query->filterByTaxId(1234); // WHERE taxid = 1234
$query->filterByTaxId(array(12, 34)); // WHERE taxid IN (12, 34)
$query->filterByTaxId(array('min' => 12)); // WHERE tax_id > 12
in
TaxRuleCountryQuery at line 490
TaxRuleCountryQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition(1234); // WHERE position = 1234
$query->filterByPosition(array(12, 34)); // WHERE position IN (12, 34)
$query->filterByPosition(array('min' => 12)); // WHERE position > 12
in
TaxRuleCountryQuery at line 533
TaxRuleCountryQuery
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
TaxRuleCountryQuery at line 576
TaxRuleCountryQuery
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
TaxRuleCountryQuery at line 607
TaxRuleCountryQuery
filterByTax(
Tax|ObjectCollection $tax,
string $comparison = null)
Filter the query by a related \Thelia\Model\Tax object
in
TaxRuleCountryQuery at line 632
TaxRuleCountryQuery
joinTax(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Tax relation
in
TaxRuleCountryQuery at line 667
TaxQuery
useTaxQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Tax relation Tax object
in
TaxRuleCountryQuery at line 682
TaxRuleCountryQuery
filterByTaxRule(
TaxRule|ObjectCollection $taxRule,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRule object
in
TaxRuleCountryQuery at line 707
TaxRuleCountryQuery
joinTaxRule(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the TaxRule relation
in
TaxRuleCountryQuery at line 742
TaxRuleQuery
useTaxRuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the TaxRule relation TaxRule object
in
TaxRuleCountryQuery at line 757
TaxRuleCountryQuery
filterByCountry(
Country|ObjectCollection $country,
string $comparison = null)
Filter the query by a related \Thelia\Model\Country object
in
TaxRuleCountryQuery at line 782
TaxRuleCountryQuery
joinCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Country relation
in
TaxRuleCountryQuery at line 817
CountryQuery
useCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Country relation Country object
in
TaxRuleCountryQuery at line 832
TaxRuleCountryQuery
filterByState(
State|ObjectCollection $state,
string $comparison = null)
Filter the query by a related \Thelia\Model\State object
in
TaxRuleCountryQuery at line 857
TaxRuleCountryQuery
joinState(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the State relation
in
TaxRuleCountryQuery at line 892
StateQuery
useStateQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the State relation State object
in
TaxRuleCountryQuery at line 906
TaxRuleCountryQuery
prune(
TaxRuleCountry $taxRuleCountry = null)
Exclude object from result
in
TaxRuleCountryQuery at line 921
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the taxrulecountry table.
in
TaxRuleCountryQuery at line 958
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildTaxRuleCountry or Criteria object OR a primary key value.
in
TaxRuleCountryQuery at line 999
TaxRuleCountryQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
TaxRuleCountryQuery at line 1011
TaxRuleCountryQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
TaxRuleCountryQuery at line 1021
TaxRuleCountryQuery
lastUpdatedFirst()
Order by update date desc
in
TaxRuleCountryQuery at line 1031
TaxRuleCountryQuery
firstUpdatedFirst()
Order by update date asc
in
TaxRuleCountryQuery at line 1041
TaxRuleCountryQuery
lastCreatedFirst()
Order by create date desc
in
TaxRuleCountryQuery at line 1051
TaxRuleCountryQuery
firstCreatedFirst()
Order by create date asc
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderById($order = Criteria::ASC)
Order by the id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByTaxRuleId($order = Criteria::ASC)
Order by the taxruleid column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByCountryId($order = Criteria::ASC)
Order by the country_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByStateId($order = Criteria::ASC)
Order by the state_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByTaxId($order = Criteria::ASC)
Order by the tax_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupById()
Group by the id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByTaxRuleId()
Group by the taxruleid column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByCountryId()
Group by the country_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByStateId()
Group by the state_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByTaxId()
Group by the tax_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByPosition()
Group by the position column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByCreatedAt()
Group by the created_at column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
groupByUpdatedAt()
Group by the updated_at column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
leftJoinTax($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Tax relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
rightJoinTax($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Tax relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
innerJoinTax($relationAlias = null)
Adds a INNER JOIN clause to the query using the Tax relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
leftJoinTaxRule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRule relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
rightJoinTaxRule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRule relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
innerJoinTaxRule($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRule relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
leftJoinCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Country relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
rightJoinCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Country relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
innerJoinCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the Country relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
leftJoinState($relationAlias = null)
Adds a LEFT JOIN clause to the query using the State relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
rightJoinState($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the State relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountryQuery
innerJoinState($relationAlias = null)
Adds a INNER JOIN clause to the query using the State relation
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOne(
ConnectionInterface $con = null)
Return the first ChildTaxRuleCountry matching the query
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildTaxRuleCountry matching the query, or a new ChildTaxRuleCountry object populated from the query conditions when no match is found
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneById(
int $id)
Return the first ChildTaxRuleCountry filtered by the id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByTaxRuleId(
int $tax_rule_id)
Return the first ChildTaxRuleCountry filtered by the taxruleid column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByCountryId(
int $country_id)
Return the first ChildTaxRuleCountry filtered by the country_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByStateId(
int $state_id)
Return the first ChildTaxRuleCountry filtered by the state_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByTaxId(
int $tax_id)
Return the first ChildTaxRuleCountry filtered by the tax_id column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByPosition(
int $position)
Return the first ChildTaxRuleCountry filtered by the position column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByCreatedAt(
string $created_at)
Return the first ChildTaxRuleCountry filtered by the created_at column
in
TaxRuleCountryQuery at line 84
ChildTaxRuleCountry
findOneByUpdatedAt(
string $updated_at)
Return the first ChildTaxRuleCountry filtered by the updated_at column
in
TaxRuleCountryQuery at line 84
array
findById(
int $id)
Return ChildTaxRuleCountry objects filtered by the id column
in
TaxRuleCountryQuery at line 84
array
findByTaxRuleId(
int $tax_rule_id)
Return ChildTaxRuleCountry objects filtered by the taxruleid column
in
TaxRuleCountryQuery at line 84
array
findByCountryId(
int $country_id)
Return ChildTaxRuleCountry objects filtered by the country_id column
in
TaxRuleCountryQuery at line 84
array
findByStateId(
int $state_id)
Return ChildTaxRuleCountry objects filtered by the state_id column
in
TaxRuleCountryQuery at line 84
array
findByTaxId(
int $tax_id)
Return ChildTaxRuleCountry objects filtered by the tax_id column
in
TaxRuleCountryQuery at line 84
array
findByPosition(
int $position)
Return ChildTaxRuleCountry objects filtered by the position column
in
TaxRuleCountryQuery at line 84
array
findByCreatedAt(
string $created_at)
Return ChildTaxRuleCountry objects filtered by the created_at column
in
TaxRuleCountryQuery at line 84
array
findByUpdatedAt(
string $updated_at)
Return ChildTaxRuleCountry objects filtered by the updated_at column