TemplateQuery
class TemplateQuery extends ModelCriteria
Base class that represents a query for the 'template' table.
Methods
Initializes internal state of \Thelia\Model\Base\TemplateQuery object.
Returns a new ChildTemplateQuery 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 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\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\AttributeTemplate object
Adds a JOIN clause to the query using the AttributeTemplate relation
Use the AttributeTemplate relation AttributeTemplate object
Filter the query by a related \Thelia\Model\TemplateI18n object
Adds a JOIN clause to the query using the TemplateI18n relation
Use the TemplateI18n relation TemplateI18n object
Filter the query by a related Feature object using the feature_template table as cross reference
Filter the query by a related Attribute object using the attribute_template table as cross reference
Deletes all rows from the template table.
Performs a DELETE on the database, given a ChildTemplate 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
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 created_at column
Order by the updated_at column
Group by the id 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 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 AttributeTemplate relation
Adds a RIGHT JOIN clause to the query using the AttributeTemplate relation
Adds a INNER JOIN clause to the query using the AttributeTemplate relation
Adds a LEFT JOIN clause to the query using the TemplateI18n relation
Adds a RIGHT JOIN clause to the query using the TemplateI18n relation
Adds a INNER JOIN clause to the query using the TemplateI18n relation
Return the first ChildTemplate matching the query
Return the first ChildTemplate matching the query, or a new ChildTemplate object populated from the query conditions when no match is found
Return the first ChildTemplate filtered by the id column
Return the first ChildTemplate filtered by the created_at column
Return the first ChildTemplate filtered by the updated_at column
Return ChildTemplate objects filtered by the id column
Return ChildTemplate objects filtered by the created_at column
Return ChildTemplate objects filtered by the updated_at column
Details
at line 75
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Template',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\TemplateQuery object.
at line 88
static
TemplateQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildTemplateQuery object.
at line 118
Template|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 200
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 221
TemplateQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 234
TemplateQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 258
TemplateQuery
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 301
TemplateQuery
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 344
TemplateQuery
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 375
TemplateQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 398
TemplateQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Product relation
at line 433
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Product relation Product object
at line 448
TemplateQuery
filterByFeatureTemplate(
FeatureTemplate|ObjectCollection $featureTemplate,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureTemplate object
at line 471
TemplateQuery
joinFeatureTemplate(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FeatureTemplate relation
at line 506
FeatureTemplateQuery
useFeatureTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FeatureTemplate relation FeatureTemplate object
at line 521
TemplateQuery
filterByAttributeTemplate(
AttributeTemplate|ObjectCollection $attributeTemplate,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeTemplate object
at line 544
TemplateQuery
joinAttributeTemplate(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeTemplate relation
at line 579
AttributeTemplateQuery
useAttributeTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeTemplate relation AttributeTemplate object
at line 594
TemplateQuery
filterByTemplateI18n(
TemplateI18n|ObjectCollection $templateI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\TemplateI18n object
at line 617
TemplateQuery
joinTemplateI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the TemplateI18n relation
at line 652
TemplateI18nQuery
useTemplateI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the TemplateI18n relation TemplateI18n object
at line 668
TemplateQuery
filterByFeature(
Feature $feature,
string $comparison = Criteria::EQUAL)
Filter the query by a related Feature object using the feature_template table as cross reference
at line 685
TemplateQuery
filterByAttribute(
Attribute $attribute,
string $comparison = Criteria::EQUAL)
Filter the query by a related Attribute object using the attribute_template table as cross reference
at line 700
TemplateQuery
prune(
Template $template = null)
Exclude object from result
at line 715
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the template table.
at line 752
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildTemplate or Criteria object OR a primary key value.
at line 795
TemplateQuery
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 813
TemplateQuery
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 834
TemplateI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 850
TemplateQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 862
TemplateQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 872
TemplateQuery
lastUpdatedFirst()
Order by update date desc
at line 882
TemplateQuery
firstUpdatedFirst()
Order by update date asc
at line 892
TemplateQuery
lastCreatedFirst()
Order by create date desc
at line 902
TemplateQuery
firstCreatedFirst()
Order by create date asc
at line 65
ChildTemplateQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 65
ChildTemplateQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 65
ChildTemplateQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 65
ChildTemplateQuery
groupById()
Group by the id column
at line 65
ChildTemplateQuery
groupByCreatedAt()
Group by the created_at column
at line 65
ChildTemplateQuery
groupByUpdatedAt()
Group by the updated_at column
at line 65
ChildTemplateQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 65
ChildTemplateQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 65
ChildTemplateQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 65
ChildTemplateQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
at line 65
ChildTemplateQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
at line 65
ChildTemplateQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
at line 65
ChildTemplateQuery
leftJoinFeatureTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureTemplate relation
at line 65
ChildTemplateQuery
rightJoinFeatureTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureTemplate relation
at line 65
ChildTemplateQuery
innerJoinFeatureTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureTemplate relation
at line 65
ChildTemplateQuery
leftJoinAttributeTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeTemplate relation
at line 65
ChildTemplateQuery
rightJoinAttributeTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeTemplate relation
at line 65
ChildTemplateQuery
innerJoinAttributeTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeTemplate relation
at line 65
ChildTemplateQuery
leftJoinTemplateI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TemplateI18n relation
at line 65
ChildTemplateQuery
rightJoinTemplateI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TemplateI18n relation
at line 65
ChildTemplateQuery
innerJoinTemplateI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the TemplateI18n relation
at line 65
ChildTemplate
findOne(
ConnectionInterface $con = null)
Return the first ChildTemplate matching the query
at line 65
ChildTemplate
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildTemplate matching the query, or a new ChildTemplate object populated from the query conditions when no match is found
at line 65
ChildTemplate
findOneById(
int $id)
Return the first ChildTemplate filtered by the id column
at line 65
ChildTemplate
findOneByCreatedAt(
string $created_at)
Return the first ChildTemplate filtered by the created_at column
at line 65
ChildTemplate
findOneByUpdatedAt(
string $updated_at)
Return the first ChildTemplate filtered by the updated_at column
at line 65
array
findById(
int $id)
Return ChildTemplate objects filtered by the id column
at line 65
array
findByCreatedAt(
string $created_at)
Return ChildTemplate objects filtered by the created_at column
at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildTemplate objects filtered by the updated_at column