CategoryQuery
class CategoryQuery extends ModelCriteria
Base class that represents a query for the 'category' table.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled |
Methods
Initializes internal state of \Thelia\Model\Base\CategoryQuery object.
Returns a new ChildCategoryQuery 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 parent column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the defaulttemplateid column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query on the version column
Filter the query on the versioncreatedat column
Filter the query on the versioncreatedby column
Filter the query by a related \Thelia\Model\ProductCategory object
Adds a JOIN clause to the query using the ProductCategory relation
Use the ProductCategory relation ProductCategory object
Filter the query by a related \Thelia\Model\CategoryImage object
Adds a JOIN clause to the query using the CategoryImage relation
Use the CategoryImage relation CategoryImage object
Filter the query by a related \Thelia\Model\CategoryDocument object
Adds a JOIN clause to the query using the CategoryDocument relation
Use the CategoryDocument relation CategoryDocument object
Filter the query by a related \Thelia\Model\CategoryAssociatedContent object
Adds a JOIN clause to the query using the CategoryAssociatedContent relation
Use the CategoryAssociatedContent relation CategoryAssociatedContent object
Filter the query by a related \Thelia\Model\CategoryI18n object
Adds a JOIN clause to the query using the CategoryI18n relation
Use the CategoryI18n relation CategoryI18n object
Filter the query by a related \Thelia\Model\CategoryVersion object
Adds a JOIN clause to the query using the CategoryVersion relation
Use the CategoryVersion relation CategoryVersion object
Filter the query by a related Product object using the product_category table as cross reference
Deletes all rows from the category table.
Performs a DELETE on the database, given a ChildCategory 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
Checks whether versioning is enabled
Enables versioning
Disables versioning
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 parent column
Order by the visible column
Order by the position column
Order by the defaulttemplateid column
Order by the created_at column
Order by the updated_at column
Order by the version column
Order by the versioncreatedat column
Order by the versioncreatedby column
Group by the id column
Group by the parent column
Group by the visible column
Group by the position column
Group by the defaulttemplateid column
Group by the created_at column
Group by the updated_at column
Group by the version column
Group by the versioncreatedat column
Group by the versioncreatedby 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 ProductCategory relation
Adds a RIGHT JOIN clause to the query using the ProductCategory relation
Adds a INNER JOIN clause to the query using the ProductCategory relation
Adds a LEFT JOIN clause to the query using the CategoryImage relation
Adds a RIGHT JOIN clause to the query using the CategoryImage relation
Adds a INNER JOIN clause to the query using the CategoryImage relation
Adds a LEFT JOIN clause to the query using the CategoryDocument relation
Adds a RIGHT JOIN clause to the query using the CategoryDocument relation
Adds a INNER JOIN clause to the query using the CategoryDocument relation
Adds a LEFT JOIN clause to the query using the CategoryAssociatedContent relation
Adds a RIGHT JOIN clause to the query using the CategoryAssociatedContent relation
Adds a INNER JOIN clause to the query using the CategoryAssociatedContent relation
Adds a LEFT JOIN clause to the query using the CategoryI18n relation
Adds a RIGHT JOIN clause to the query using the CategoryI18n relation
Adds a INNER JOIN clause to the query using the CategoryI18n relation
Adds a LEFT JOIN clause to the query using the CategoryVersion relation
Adds a RIGHT JOIN clause to the query using the CategoryVersion relation
Adds a INNER JOIN clause to the query using the CategoryVersion relation
Return the first ChildCategory matching the query
Return the first ChildCategory matching the query, or a new ChildCategory object populated from the query conditions when no match is found
Return the first ChildCategory filtered by the id column
Return the first ChildCategory filtered by the parent column
Return the first ChildCategory filtered by the visible column
Return the first ChildCategory filtered by the position column
Return the first ChildCategory filtered by the defaulttemplateid column
Return the first ChildCategory filtered by the created_at column
Return the first ChildCategory filtered by the updated_at column
Return the first ChildCategory filtered by the version column
Return the first ChildCategory filtered by the versioncreatedat column
Return the first ChildCategory filtered by the versioncreatedby column
Return ChildCategory objects filtered by the id column
Return ChildCategory objects filtered by the parent column
Return ChildCategory objects filtered by the visible column
Return ChildCategory objects filtered by the position column
Return ChildCategory objects filtered by the defaulttemplateid column
Return ChildCategory objects filtered by the created_at column
Return ChildCategory objects filtered by the updated_at column
Return ChildCategory objects filtered by the version column
Return ChildCategory objects filtered by the versioncreatedat column
Return ChildCategory objects filtered by the versioncreatedby column
Details
at line 118
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Category',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CategoryQuery object.
at line 131
static
CategoryQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCategoryQuery object.
at line 161
Category|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 243
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 264
CategoryQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 277
CategoryQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 301
CategoryQuery
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 342
CategoryQuery
filterByParent(
mixed $parent = null,
string $comparison = null)
Filter the query on the parent column
Example usage:
$query->filterByParent(1234); // WHERE parent = 1234
$query->filterByParent(array(12, 34)); // WHERE parent IN (12, 34)
$query->filterByParent(array('min' => 12)); // WHERE parent > 12
at line 383
CategoryQuery
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 424
CategoryQuery
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 465
CategoryQuery
filterByDefaultTemplateId(
mixed $defaultTemplateId = null,
string $comparison = null)
Filter the query on the defaulttemplateid column
Example usage:
$query->filterByDefaultTemplateId(1234); // WHERE defaulttemplateid = 1234
$query->filterByDefaultTemplateId(array(12, 34)); // WHERE defaulttemplateid IN (12, 34)
$query->filterByDefaultTemplateId(array('min' => 12)); // WHERE defaulttemplateid > 12
at line 508
CategoryQuery
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 551
CategoryQuery
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 592
CategoryQuery
filterByVersion(
mixed $version = null,
string $comparison = null)
Filter the query on the version column
Example usage:
$query->filterByVersion(1234); // WHERE version = 1234
$query->filterByVersion(array(12, 34)); // WHERE version IN (12, 34)
$query->filterByVersion(array('min' => 12)); // WHERE version > 12
at line 635
CategoryQuery
filterByVersionCreatedAt(
mixed $versionCreatedAt = null,
string $comparison = null)
Filter the query on the versioncreatedat column
Example usage:
$query->filterByVersionCreatedAt('2011-03-14'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt('now'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt(array('max' => 'yesterday')); // WHERE versioncreatedat > '2011-03-13'
at line 673
CategoryQuery
filterByVersionCreatedBy(
string $versionCreatedBy = null,
string $comparison = null)
Filter the query on the versioncreatedby column
Example usage:
$query->filterByVersionCreatedBy('fooValue'); // WHERE versioncreatedby = 'fooValue'
$query->filterByVersionCreatedBy('%fooValue%'); // WHERE versioncreatedby LIKE '%fooValue%'
at line 695
CategoryQuery
filterByProductCategory(
ProductCategory|ObjectCollection $productCategory,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductCategory object
at line 718
CategoryQuery
joinProductCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductCategory relation
at line 753
ProductCategoryQuery
useProductCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductCategory relation ProductCategory object
at line 768
CategoryQuery
filterByCategoryImage(
CategoryImage|ObjectCollection $categoryImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryImage object
at line 791
CategoryQuery
joinCategoryImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryImage relation
at line 826
CategoryImageQuery
useCategoryImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryImage relation CategoryImage object
at line 841
CategoryQuery
filterByCategoryDocument(
CategoryDocument|ObjectCollection $categoryDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryDocument object
at line 864
CategoryQuery
joinCategoryDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryDocument relation
at line 899
CategoryDocumentQuery
useCategoryDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryDocument relation CategoryDocument object
at line 914
CategoryQuery
filterByCategoryAssociatedContent(
CategoryAssociatedContent|ObjectCollection $categoryAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryAssociatedContent object
at line 937
CategoryQuery
joinCategoryAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryAssociatedContent relation
at line 972
CategoryAssociatedContentQuery
useCategoryAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryAssociatedContent relation CategoryAssociatedContent object
at line 987
CategoryQuery
filterByCategoryI18n(
CategoryI18n|ObjectCollection $categoryI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryI18n object
at line 1010
CategoryQuery
joinCategoryI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the CategoryI18n relation
at line 1045
CategoryI18nQuery
useCategoryI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the CategoryI18n relation CategoryI18n object
at line 1060
CategoryQuery
filterByCategoryVersion(
CategoryVersion|ObjectCollection $categoryVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryVersion object
at line 1083
CategoryQuery
joinCategoryVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryVersion relation
at line 1118
CategoryVersionQuery
useCategoryVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryVersion relation CategoryVersion object
at line 1134
CategoryQuery
filterByProduct(
Product $product,
string $comparison = Criteria::EQUAL)
Filter the query by a related Product object using the product_category table as cross reference
at line 1149
CategoryQuery
prune(
Category $category = null)
Exclude object from result
at line 1164
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the category table.
at line 1201
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCategory or Criteria object OR a primary key value.
at line 1244
CategoryQuery
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 1262
CategoryQuery
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 1283
CategoryI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 1297
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
at line 1305
static
enableVersioning()
Enables versioning
at line 1313
static
disableVersioning()
Disables versioning
at line 1327
CategoryQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1339
CategoryQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1349
CategoryQuery
lastUpdatedFirst()
Order by update date desc
at line 1359
CategoryQuery
firstUpdatedFirst()
Order by update date asc
at line 1369
CategoryQuery
lastCreatedFirst()
Order by create date desc
at line 1379
CategoryQuery
firstCreatedFirst()
Order by create date asc
at line 101
ChildCategoryQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 101
ChildCategoryQuery
orderByParent($order = Criteria::ASC)
Order by the parent column
at line 101
ChildCategoryQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 101
ChildCategoryQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 101
ChildCategoryQuery
orderByDefaultTemplateId($order = Criteria::ASC)
Order by the defaulttemplateid column
at line 101
ChildCategoryQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 101
ChildCategoryQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 101
ChildCategoryQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 101
ChildCategoryQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 101
ChildCategoryQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 101
ChildCategoryQuery
groupById()
Group by the id column
at line 101
ChildCategoryQuery
groupByParent()
Group by the parent column
at line 101
ChildCategoryQuery
groupByVisible()
Group by the visible column
at line 101
ChildCategoryQuery
groupByPosition()
Group by the position column
at line 101
ChildCategoryQuery
groupByDefaultTemplateId()
Group by the defaulttemplateid column
at line 101
ChildCategoryQuery
groupByCreatedAt()
Group by the created_at column
at line 101
ChildCategoryQuery
groupByUpdatedAt()
Group by the updated_at column
at line 101
ChildCategoryQuery
groupByVersion()
Group by the version column
at line 101
ChildCategoryQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 101
ChildCategoryQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 101
ChildCategoryQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 101
ChildCategoryQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 101
ChildCategoryQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 101
ChildCategoryQuery
leftJoinProductCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductCategory relation
at line 101
ChildCategoryQuery
rightJoinProductCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductCategory relation
at line 101
ChildCategoryQuery
innerJoinProductCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductCategory relation
at line 101
ChildCategoryQuery
leftJoinCategoryImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryImage relation
at line 101
ChildCategoryQuery
rightJoinCategoryImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryImage relation
at line 101
ChildCategoryQuery
innerJoinCategoryImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryImage relation
at line 101
ChildCategoryQuery
leftJoinCategoryDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryDocument relation
at line 101
ChildCategoryQuery
rightJoinCategoryDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryDocument relation
at line 101
ChildCategoryQuery
innerJoinCategoryDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryDocument relation
at line 101
ChildCategoryQuery
leftJoinCategoryAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryAssociatedContent relation
at line 101
ChildCategoryQuery
rightJoinCategoryAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryAssociatedContent relation
at line 101
ChildCategoryQuery
innerJoinCategoryAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryAssociatedContent relation
at line 101
ChildCategoryQuery
leftJoinCategoryI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryI18n relation
at line 101
ChildCategoryQuery
rightJoinCategoryI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryI18n relation
at line 101
ChildCategoryQuery
innerJoinCategoryI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryI18n relation
at line 101
ChildCategoryQuery
leftJoinCategoryVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryVersion relation
at line 101
ChildCategoryQuery
rightJoinCategoryVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryVersion relation
at line 101
ChildCategoryQuery
innerJoinCategoryVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryVersion relation
at line 101
ChildCategory
findOne(
ConnectionInterface $con = null)
Return the first ChildCategory matching the query
at line 101
ChildCategory
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCategory matching the query, or a new ChildCategory object populated from the query conditions when no match is found
at line 101
ChildCategory
findOneById(
int $id)
Return the first ChildCategory filtered by the id column
at line 101
ChildCategory
findOneByParent(
int $parent)
Return the first ChildCategory filtered by the parent column
at line 101
ChildCategory
findOneByVisible(
int $visible)
Return the first ChildCategory filtered by the visible column
at line 101
ChildCategory
findOneByPosition(
int $position)
Return the first ChildCategory filtered by the position column
at line 101
ChildCategory
findOneByDefaultTemplateId(
int $default_template_id)
Return the first ChildCategory filtered by the defaulttemplateid column
at line 101
ChildCategory
findOneByCreatedAt(
string $created_at)
Return the first ChildCategory filtered by the created_at column
at line 101
ChildCategory
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCategory filtered by the updated_at column
at line 101
ChildCategory
findOneByVersion(
int $version)
Return the first ChildCategory filtered by the version column
at line 101
ChildCategory
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildCategory filtered by the versioncreatedat column
at line 101
ChildCategory
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildCategory filtered by the versioncreatedby column
at line 101
array
findById(
int $id)
Return ChildCategory objects filtered by the id column
at line 101
array
findByParent(
int $parent)
Return ChildCategory objects filtered by the parent column
at line 101
array
findByVisible(
int $visible)
Return ChildCategory objects filtered by the visible column
at line 101
array
findByPosition(
int $position)
Return ChildCategory objects filtered by the position column
at line 101
array
findByDefaultTemplateId(
int $default_template_id)
Return ChildCategory objects filtered by the defaulttemplateid column
at line 101
array
findByCreatedAt(
string $created_at)
Return ChildCategory objects filtered by the created_at column
at line 101
array
findByUpdatedAt(
string $updated_at)
Return ChildCategory objects filtered by the updated_at column
at line 101
array
findByVersion(
int $version)
Return ChildCategory objects filtered by the version column
at line 101
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildCategory objects filtered by the versioncreatedat column
at line 101
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildCategory objects filtered by the versioncreatedby column