FeatureQuery
class FeatureQuery extends ModelCriteria
Base class that represents a query for the 'feature' table.
Methods
Initializes internal state of \Thelia\Model\Base\FeatureQuery object.
Returns a new ChildFeatureQuery 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 visible 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\FeatureAv object
Adds a JOIN clause to the query using the FeatureAv relation
Use the FeatureAv relation FeatureAv object
Filter the query by a related \Thelia\Model\FeatureProduct object
Adds a JOIN clause to the query using the FeatureProduct relation
Use the FeatureProduct relation FeatureProduct object
Filter the query by a related \Thelia\Model\FeatureTemplate object
Adds a JOIN clause to the query using the FeatureTemplate relation
Use the FeatureTemplate relation FeatureTemplate object
Filter the query by a related \Thelia\Model\FeatureI18n object
Adds a JOIN clause to the query using the FeatureI18n relation
Use the FeatureI18n relation FeatureI18n object
Filter the query by a related Template object using the feature_template table as cross reference
Deletes all rows from the feature table.
Performs a DELETE on the database, given a ChildFeature 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 visible 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 visible 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 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
Adds a LEFT JOIN clause to the query using the FeatureProduct relation
Adds a RIGHT JOIN clause to the query using the FeatureProduct relation
Adds a INNER JOIN clause to the query using the FeatureProduct relation
Adds a LEFT JOIN clause to the query using the FeatureTemplate relation
Adds a RIGHT JOIN clause to the query using the FeatureTemplate relation
Adds a INNER JOIN clause to the query using the FeatureTemplate relation
Adds a LEFT JOIN clause to the query using the FeatureI18n relation
Adds a RIGHT JOIN clause to the query using the FeatureI18n relation
Adds a INNER JOIN clause to the query using the FeatureI18n relation
Return the first ChildFeature matching the query
Return the first ChildFeature matching the query, or a new ChildFeature object populated from the query conditions when no match is found
Return the first ChildFeature filtered by the id column
Return the first ChildFeature filtered by the visible column
Return the first ChildFeature filtered by the position column
Return the first ChildFeature filtered by the created_at column
Return the first ChildFeature filtered by the updated_at column
Return ChildFeature objects filtered by the id column
Return ChildFeature objects filtered by the visible column
Return ChildFeature objects filtered by the position column
Return ChildFeature objects filtered by the created_at column
Return ChildFeature objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Feature',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\FeatureQuery object.
at line 96
static
FeatureQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildFeatureQuery object.
at line 126
Feature|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
FeatureQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
FeatureQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
FeatureQuery
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 307
FeatureQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
at line 348
FeatureQuery
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 391
FeatureQuery
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 434
FeatureQuery
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 465
FeatureQuery
filterByFeatureAv(
FeatureAv|ObjectCollection $featureAv,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureAv object
at line 488
FeatureQuery
joinFeatureAv(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FeatureAv relation
at line 523
FeatureAvQuery
useFeatureAvQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FeatureAv relation FeatureAv object
at line 538
FeatureQuery
filterByFeatureProduct(
FeatureProduct|ObjectCollection $featureProduct,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureProduct object
at line 561
FeatureQuery
joinFeatureProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FeatureProduct relation
at line 596
FeatureProductQuery
useFeatureProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FeatureProduct relation FeatureProduct object
at line 611
FeatureQuery
filterByFeatureTemplate(
FeatureTemplate|ObjectCollection $featureTemplate,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureTemplate object
at line 634
FeatureQuery
joinFeatureTemplate(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FeatureTemplate relation
at line 669
FeatureTemplateQuery
useFeatureTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FeatureTemplate relation FeatureTemplate object
at line 684
FeatureQuery
filterByFeatureI18n(
FeatureI18n|ObjectCollection $featureI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureI18n object
at line 707
FeatureQuery
joinFeatureI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the FeatureI18n relation
at line 742
FeatureI18nQuery
useFeatureI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the FeatureI18n relation FeatureI18n object
at line 758
FeatureQuery
filterByTemplate(
Template $template,
string $comparison = Criteria::EQUAL)
Filter the query by a related Template object using the feature_template table as cross reference
at line 773
FeatureQuery
prune(
Feature $feature = null)
Exclude object from result
at line 788
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the feature table.
at line 825
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildFeature or Criteria object OR a primary key value.
at line 866
FeatureQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 878
FeatureQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 888
FeatureQuery
lastUpdatedFirst()
Order by update date desc
at line 898
FeatureQuery
firstUpdatedFirst()
Order by update date asc
at line 908
FeatureQuery
lastCreatedFirst()
Order by create date desc
at line 918
FeatureQuery
firstCreatedFirst()
Order by create date asc
at line 934
FeatureQuery
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 952
FeatureQuery
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 973
FeatureI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildFeatureQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildFeatureQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 73
ChildFeatureQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildFeatureQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildFeatureQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildFeatureQuery
groupById()
Group by the id column
at line 73
ChildFeatureQuery
groupByVisible()
Group by the visible column
at line 73
ChildFeatureQuery
groupByPosition()
Group by the position column
at line 73
ChildFeatureQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildFeatureQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildFeatureQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildFeatureQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildFeatureQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildFeatureQuery
leftJoinFeatureAv($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureAv relation
at line 73
ChildFeatureQuery
rightJoinFeatureAv($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureAv relation
at line 73
ChildFeatureQuery
innerJoinFeatureAv($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureAv relation
at line 73
ChildFeatureQuery
leftJoinFeatureProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureProduct relation
at line 73
ChildFeatureQuery
rightJoinFeatureProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureProduct relation
at line 73
ChildFeatureQuery
innerJoinFeatureProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureProduct relation
at line 73
ChildFeatureQuery
leftJoinFeatureTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureTemplate relation
at line 73
ChildFeatureQuery
rightJoinFeatureTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureTemplate relation
at line 73
ChildFeatureQuery
innerJoinFeatureTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureTemplate relation
at line 73
ChildFeatureQuery
leftJoinFeatureI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureI18n relation
at line 73
ChildFeatureQuery
rightJoinFeatureI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureI18n relation
at line 73
ChildFeatureQuery
innerJoinFeatureI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureI18n relation
at line 73
ChildFeature
findOne(
ConnectionInterface $con = null)
Return the first ChildFeature matching the query
at line 73
ChildFeature
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildFeature matching the query, or a new ChildFeature object populated from the query conditions when no match is found
at line 73
ChildFeature
findOneById(
int $id)
Return the first ChildFeature filtered by the id column
at line 73
ChildFeature
findOneByVisible(
int $visible)
Return the first ChildFeature filtered by the visible column
at line 73
ChildFeature
findOneByPosition(
int $position)
Return the first ChildFeature filtered by the position column
at line 73
ChildFeature
findOneByCreatedAt(
string $created_at)
Return the first ChildFeature filtered by the created_at column
at line 73
ChildFeature
findOneByUpdatedAt(
string $updated_at)
Return the first ChildFeature filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildFeature objects filtered by the id column
at line 73
array
findByVisible(
int $visible)
Return ChildFeature objects filtered by the visible column
at line 73
array
findByPosition(
int $position)
Return ChildFeature objects filtered by the position column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildFeature objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildFeature objects filtered by the updated_at column