FeatureProductQuery
class FeatureProductQuery extends ModelCriteria
Base class that represents a query for the 'feature_product' table.
Methods
Initializes internal state of \Thelia\Model\Base\FeatureProductQuery object.
Returns a new ChildFeatureProductQuery 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 product_id column
Filter the query on the feature_id column
Filter the query on the featureavid column
Filter the query on the freetextvalue 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\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\Feature object
Adds a JOIN clause to the query using the Feature relation
Use the Feature relation Feature object
Filter the query by a related \Thelia\Model\FeatureAv object
Adds a JOIN clause to the query using the FeatureAv relation
Use the FeatureAv relation FeatureAv object
Deletes all rows from the feature_product table.
Performs a DELETE on the database, given a ChildFeatureProduct 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
Order by the id column
Order by the product_id column
Order by the feature_id column
Order by the featureavid column
Order by the freetextvalue 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 product_id column
Group by the feature_id column
Group by the featureavid column
Group by the freetextvalue 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 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 Feature relation
Adds a RIGHT JOIN clause to the query using the Feature relation
Adds a INNER JOIN clause to the query using the Feature relation
Adds a LEFT JOIN clause to the query using the FeatureAv relation
Adds a RIGHT JOIN clause to the query using the FeatureAv relation
Adds a INNER JOIN clause to the query using the FeatureAv relation
Return the first ChildFeatureProduct matching the query
Return the first ChildFeatureProduct matching the query, or a new ChildFeatureProduct object populated from the query conditions when no match is found
Return the first ChildFeatureProduct filtered by the id column
Return the first ChildFeatureProduct filtered by the product_id column
Return the first ChildFeatureProduct filtered by the feature_id column
Return the first ChildFeatureProduct filtered by the featureavid column
Return the first ChildFeatureProduct filtered by the freetextvalue column
Return the first ChildFeatureProduct filtered by the position column
Return the first ChildFeatureProduct filtered by the created_at column
Return the first ChildFeatureProduct filtered by the updated_at column
Return ChildFeatureProduct objects filtered by the id column
Return ChildFeatureProduct objects filtered by the product_id column
Return ChildFeatureProduct objects filtered by the feature_id column
Return ChildFeatureProduct objects filtered by the featureavid column
Return ChildFeatureProduct objects filtered by the freetextvalue column
Return ChildFeatureProduct objects filtered by the position column
Return ChildFeatureProduct objects filtered by the created_at column
Return ChildFeatureProduct objects filtered by the updated_at column
Details
at line 90
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\FeatureProduct',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\FeatureProductQuery object.
at line 103
static
FeatureProductQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildFeatureProductQuery object.
at line 133
FeatureProduct|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 215
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 236
FeatureProductQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 249
FeatureProductQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 273
FeatureProductQuery
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 316
FeatureProductQuery
filterByProductId(
mixed $productId = null,
string $comparison = null)
Filter the query on the product_id column
Example usage:
$query->filterByProductId(1234); // WHERE productid = 1234
$query->filterByProductId(array(12, 34)); // WHERE productid IN (12, 34)
$query->filterByProductId(array('min' => 12)); // WHERE product_id > 12
at line 359
FeatureProductQuery
filterByFeatureId(
mixed $featureId = null,
string $comparison = null)
Filter the query on the feature_id column
Example usage:
$query->filterByFeatureId(1234); // WHERE featureid = 1234
$query->filterByFeatureId(array(12, 34)); // WHERE featureid IN (12, 34)
$query->filterByFeatureId(array('min' => 12)); // WHERE feature_id > 12
at line 402
FeatureProductQuery
filterByFeatureAvId(
mixed $featureAvId = null,
string $comparison = null)
Filter the query on the featureavid column
Example usage:
$query->filterByFeatureAvId(1234); // WHERE featureavid = 1234
$query->filterByFeatureAvId(array(12, 34)); // WHERE featureavid IN (12, 34)
$query->filterByFeatureAvId(array('min' => 12)); // WHERE featureavid > 12
at line 440
FeatureProductQuery
filterByFreeTextValue(
string $freeTextValue = null,
string $comparison = null)
Filter the query on the freetextvalue column
Example usage:
$query->filterByFreeTextValue('fooValue'); // WHERE freetextvalue = 'fooValue'
$query->filterByFreeTextValue('%fooValue%'); // WHERE freetextvalue LIKE '%fooValue%'
at line 472
FeatureProductQuery
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 515
FeatureProductQuery
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 558
FeatureProductQuery
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 589
FeatureProductQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 614
FeatureProductQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Product relation
at line 649
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
at line 664
FeatureProductQuery
filterByFeature(
Feature|ObjectCollection $feature,
string $comparison = null)
Filter the query by a related \Thelia\Model\Feature object
at line 689
FeatureProductQuery
joinFeature(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Feature relation
at line 724
FeatureQuery
useFeatureQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Feature relation Feature object
at line 739
FeatureProductQuery
filterByFeatureAv(
FeatureAv|ObjectCollection $featureAv,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureAv object
at line 764
FeatureProductQuery
joinFeatureAv(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the FeatureAv relation
at line 799
FeatureAvQuery
useFeatureAvQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the FeatureAv relation FeatureAv object
at line 813
FeatureProductQuery
prune(
FeatureProduct $featureProduct = null)
Exclude object from result
at line 828
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the feature_product table.
at line 865
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildFeatureProduct or Criteria object OR a primary key value.
at line 906
FeatureProductQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 918
FeatureProductQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 928
FeatureProductQuery
lastUpdatedFirst()
Order by update date desc
at line 938
FeatureProductQuery
firstUpdatedFirst()
Order by update date asc
at line 948
FeatureProductQuery
lastCreatedFirst()
Order by create date desc
at line 958
FeatureProductQuery
firstCreatedFirst()
Order by create date asc
at line 80
ChildFeatureProductQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 80
ChildFeatureProductQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
at line 80
ChildFeatureProductQuery
orderByFeatureId($order = Criteria::ASC)
Order by the feature_id column
at line 80
ChildFeatureProductQuery
orderByFeatureAvId($order = Criteria::ASC)
Order by the featureavid column
at line 80
ChildFeatureProductQuery
orderByFreeTextValue($order = Criteria::ASC)
Order by the freetextvalue column
at line 80
ChildFeatureProductQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 80
ChildFeatureProductQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 80
ChildFeatureProductQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 80
ChildFeatureProductQuery
groupById()
Group by the id column
at line 80
ChildFeatureProductQuery
groupByProductId()
Group by the product_id column
at line 80
ChildFeatureProductQuery
groupByFeatureId()
Group by the feature_id column
at line 80
ChildFeatureProductQuery
groupByFeatureAvId()
Group by the featureavid column
at line 80
ChildFeatureProductQuery
groupByFreeTextValue()
Group by the freetextvalue column
at line 80
ChildFeatureProductQuery
groupByPosition()
Group by the position column
at line 80
ChildFeatureProductQuery
groupByCreatedAt()
Group by the created_at column
at line 80
ChildFeatureProductQuery
groupByUpdatedAt()
Group by the updated_at column
at line 80
ChildFeatureProductQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 80
ChildFeatureProductQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 80
ChildFeatureProductQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 80
ChildFeatureProductQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
at line 80
ChildFeatureProductQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
at line 80
ChildFeatureProductQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
at line 80
ChildFeatureProductQuery
leftJoinFeature($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Feature relation
at line 80
ChildFeatureProductQuery
rightJoinFeature($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Feature relation
at line 80
ChildFeatureProductQuery
innerJoinFeature($relationAlias = null)
Adds a INNER JOIN clause to the query using the Feature relation
at line 80
ChildFeatureProductQuery
leftJoinFeatureAv($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureAv relation
at line 80
ChildFeatureProductQuery
rightJoinFeatureAv($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureAv relation
at line 80
ChildFeatureProductQuery
innerJoinFeatureAv($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureAv relation
at line 80
ChildFeatureProduct
findOne(
ConnectionInterface $con = null)
Return the first ChildFeatureProduct matching the query
at line 80
ChildFeatureProduct
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildFeatureProduct matching the query, or a new ChildFeatureProduct object populated from the query conditions when no match is found
at line 80
ChildFeatureProduct
findOneById(
int $id)
Return the first ChildFeatureProduct filtered by the id column
at line 80
ChildFeatureProduct
findOneByProductId(
int $product_id)
Return the first ChildFeatureProduct filtered by the product_id column
at line 80
ChildFeatureProduct
findOneByFeatureId(
int $feature_id)
Return the first ChildFeatureProduct filtered by the feature_id column
at line 80
ChildFeatureProduct
findOneByFeatureAvId(
int $feature_av_id)
Return the first ChildFeatureProduct filtered by the featureavid column
at line 80
ChildFeatureProduct
findOneByFreeTextValue(
string $free_text_value)
Return the first ChildFeatureProduct filtered by the freetextvalue column
at line 80
ChildFeatureProduct
findOneByPosition(
int $position)
Return the first ChildFeatureProduct filtered by the position column
at line 80
ChildFeatureProduct
findOneByCreatedAt(
string $created_at)
Return the first ChildFeatureProduct filtered by the created_at column
at line 80
ChildFeatureProduct
findOneByUpdatedAt(
string $updated_at)
Return the first ChildFeatureProduct filtered by the updated_at column
at line 80
array
findById(
int $id)
Return ChildFeatureProduct objects filtered by the id column
at line 80
array
findByProductId(
int $product_id)
Return ChildFeatureProduct objects filtered by the product_id column
at line 80
array
findByFeatureId(
int $feature_id)
Return ChildFeatureProduct objects filtered by the feature_id column
at line 80
array
findByFeatureAvId(
int $feature_av_id)
Return ChildFeatureProduct objects filtered by the featureavid column
at line 80
array
findByFreeTextValue(
string $free_text_value)
Return ChildFeatureProduct objects filtered by the freetextvalue column
at line 80
array
findByPosition(
int $position)
Return ChildFeatureProduct objects filtered by the position column
at line 80
array
findByCreatedAt(
string $created_at)
Return ChildFeatureProduct objects filtered by the created_at column
at line 80
array
findByUpdatedAt(
string $updated_at)
Return ChildFeatureProduct objects filtered by the updated_at column