AttributeAvQuery
class AttributeAvQuery extends ModelCriteria
Base class that represents a query for the 'attribute_av' table.
Methods
Initializes internal state of \Thelia\Model\Base\AttributeAvQuery object.
Returns a new ChildAttributeAvQuery 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 attribute_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\Attribute object
Adds a JOIN clause to the query using the Attribute relation
Use the Attribute relation Attribute object
Filter the query by a related \Thelia\Model\AttributeCombination object
Adds a JOIN clause to the query using the AttributeCombination relation
Use the AttributeCombination relation AttributeCombination object
Filter the query by a related \Thelia\Model\SaleProduct object
Adds a JOIN clause to the query using the SaleProduct relation
Use the SaleProduct relation SaleProduct object
Filter the query by a related \Thelia\Model\AttributeAvI18n object
Adds a JOIN clause to the query using the AttributeAvI18n relation
Use the AttributeAvI18n relation AttributeAvI18n object
Deletes all rows from the attribute_av table.
Performs a DELETE on the database, given a ChildAttributeAv 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 attribute_id column
Order by the position column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the attribute_id column
Group by the position 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 Attribute relation
Adds a RIGHT JOIN clause to the query using the Attribute relation
Adds a INNER JOIN clause to the query using the Attribute relation
Adds a LEFT JOIN clause to the query using the AttributeCombination relation
Adds a RIGHT JOIN clause to the query using the AttributeCombination relation
Adds a INNER JOIN clause to the query using the AttributeCombination relation
Adds a LEFT JOIN clause to the query using the SaleProduct relation
Adds a RIGHT JOIN clause to the query using the SaleProduct relation
Adds a INNER JOIN clause to the query using the SaleProduct relation
Adds a LEFT JOIN clause to the query using the AttributeAvI18n relation
Adds a RIGHT JOIN clause to the query using the AttributeAvI18n relation
Adds a INNER JOIN clause to the query using the AttributeAvI18n relation
Return the first ChildAttributeAv matching the query
Return the first ChildAttributeAv matching the query, or a new ChildAttributeAv object populated from the query conditions when no match is found
Return the first ChildAttributeAv filtered by the id column
Return the first ChildAttributeAv filtered by the attribute_id column
Return the first ChildAttributeAv filtered by the position column
Return the first ChildAttributeAv filtered by the created_at column
Return the first ChildAttributeAv filtered by the updated_at column
Return ChildAttributeAv objects filtered by the id column
Return ChildAttributeAv objects filtered by the attribute_id column
Return ChildAttributeAv objects filtered by the position column
Return ChildAttributeAv objects filtered by the created_at column
Return ChildAttributeAv objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\AttributeAv',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\AttributeAvQuery object.
at line 96
static
AttributeAvQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAttributeAvQuery object.
at line 126
AttributeAv|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 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 229
AttributeAvQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
AttributeAvQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
AttributeAvQuery
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 309
AttributeAvQuery
filterByAttributeId(
mixed $attributeId = null,
string $comparison = null)
Filter the query on the attribute_id column
Example usage:
$query->filterByAttributeId(1234); // WHERE attributeid = 1234
$query->filterByAttributeId(array(12, 34)); // WHERE attributeid IN (12, 34)
$query->filterByAttributeId(array('min' => 12)); // WHERE attribute_id > 12
at line 350
AttributeAvQuery
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
at line 393
AttributeAvQuery
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 436
AttributeAvQuery
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 467
AttributeAvQuery
filterByAttribute(
Attribute|ObjectCollection $attribute,
string $comparison = null)
Filter the query by a related \Thelia\Model\Attribute object
at line 492
AttributeAvQuery
joinAttribute(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Attribute relation
at line 527
AttributeQuery
useAttributeQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Attribute relation Attribute object
at line 542
AttributeAvQuery
filterByAttributeCombination(
AttributeCombination|ObjectCollection $attributeCombination,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeCombination object
at line 565
AttributeAvQuery
joinAttributeCombination(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeCombination relation
at line 600
AttributeCombinationQuery
useAttributeCombinationQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeCombination relation AttributeCombination object
at line 615
AttributeAvQuery
filterBySaleProduct(
SaleProduct|ObjectCollection $saleProduct,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleProduct object
at line 638
AttributeAvQuery
joinSaleProduct(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the SaleProduct relation
at line 673
SaleProductQuery
useSaleProductQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the SaleProduct relation SaleProduct object
at line 688
AttributeAvQuery
filterByAttributeAvI18n(
AttributeAvI18n|ObjectCollection $attributeAvI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeAvI18n object
at line 711
AttributeAvQuery
joinAttributeAvI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the AttributeAvI18n relation
at line 746
AttributeAvI18nQuery
useAttributeAvI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the AttributeAvI18n relation AttributeAvI18n object
at line 760
AttributeAvQuery
prune(
AttributeAv $attributeAv = null)
Exclude object from result
at line 775
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the attribute_av table.
at line 812
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildAttributeAv or Criteria object OR a primary key value.
at line 853
AttributeAvQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 865
AttributeAvQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 875
AttributeAvQuery
lastUpdatedFirst()
Order by update date desc
at line 885
AttributeAvQuery
firstUpdatedFirst()
Order by update date asc
at line 895
AttributeAvQuery
lastCreatedFirst()
Order by create date desc
at line 905
AttributeAvQuery
firstCreatedFirst()
Order by create date asc
at line 921
AttributeAvQuery
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 939
AttributeAvQuery
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 960
AttributeAvI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildAttributeAvQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildAttributeAvQuery
orderByAttributeId($order = Criteria::ASC)
Order by the attribute_id column
at line 73
ChildAttributeAvQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildAttributeAvQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildAttributeAvQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildAttributeAvQuery
groupById()
Group by the id column
at line 73
ChildAttributeAvQuery
groupByAttributeId()
Group by the attribute_id column
at line 73
ChildAttributeAvQuery
groupByPosition()
Group by the position column
at line 73
ChildAttributeAvQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildAttributeAvQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildAttributeAvQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildAttributeAvQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildAttributeAvQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildAttributeAvQuery
leftJoinAttribute($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Attribute relation
at line 73
ChildAttributeAvQuery
rightJoinAttribute($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Attribute relation
at line 73
ChildAttributeAvQuery
innerJoinAttribute($relationAlias = null)
Adds a INNER JOIN clause to the query using the Attribute relation
at line 73
ChildAttributeAvQuery
leftJoinAttributeCombination($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeCombination relation
at line 73
ChildAttributeAvQuery
rightJoinAttributeCombination($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeCombination relation
at line 73
ChildAttributeAvQuery
innerJoinAttributeCombination($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeCombination relation
at line 73
ChildAttributeAvQuery
leftJoinSaleProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleProduct relation
at line 73
ChildAttributeAvQuery
rightJoinSaleProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleProduct relation
at line 73
ChildAttributeAvQuery
innerJoinSaleProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleProduct relation
at line 73
ChildAttributeAvQuery
leftJoinAttributeAvI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeAvI18n relation
at line 73
ChildAttributeAvQuery
rightJoinAttributeAvI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeAvI18n relation
at line 73
ChildAttributeAvQuery
innerJoinAttributeAvI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeAvI18n relation
at line 73
ChildAttributeAv
findOne(
ConnectionInterface $con = null)
Return the first ChildAttributeAv matching the query
at line 73
ChildAttributeAv
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildAttributeAv matching the query, or a new ChildAttributeAv object populated from the query conditions when no match is found
at line 73
ChildAttributeAv
findOneById(
int $id)
Return the first ChildAttributeAv filtered by the id column
at line 73
ChildAttributeAv
findOneByAttributeId(
int $attribute_id)
Return the first ChildAttributeAv filtered by the attribute_id column
at line 73
ChildAttributeAv
findOneByPosition(
int $position)
Return the first ChildAttributeAv filtered by the position column
at line 73
ChildAttributeAv
findOneByCreatedAt(
string $created_at)
Return the first ChildAttributeAv filtered by the created_at column
at line 73
ChildAttributeAv
findOneByUpdatedAt(
string $updated_at)
Return the first ChildAttributeAv filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildAttributeAv objects filtered by the id column
at line 73
array
findByAttributeId(
int $attribute_id)
Return ChildAttributeAv objects filtered by the attribute_id column
at line 73
array
findByPosition(
int $position)
Return ChildAttributeAv objects filtered by the position column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildAttributeAv objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildAttributeAv objects filtered by the updated_at column