CategoryQuery

Initializes internal state of \Thelia\Model\Base\CategoryQuery object.

Returns a new ChildCategoryQuery object.

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);

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

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

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

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

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

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

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'

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'

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

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'

Filter the query on the versioncreatedby column

Example usage: $query->filterByVersionCreatedBy('fooValue'); // WHERE versioncreatedby = 'fooValue' $query->filterByVersionCreatedBy('%fooValue%'); // WHERE versioncreatedby LIKE '%fooValue%'

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

Exclude object from result

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.

Shortcut for $c->joinI18n($locale)->with()

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

count how many direct children have a category

find all category children for a given category. an array of \Thelia\Model\Category is return

Return all category IDs of a category tree, starting at $categoryId, up to a depth of $depth

Get categories from root to child