ProductCategoryQuery

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

Returns a new ChildProductCategoryQuery 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(array(12, 34), $con);

Find objects by primary key $objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);

Filter the query by primary key

Filter the query by a list of primary keys

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

Filter the query on the category_id column

Example usage: $query->filterByCategoryId(1234); // WHERE categoryid = 1234 $query->filterByCategoryId(array(12, 34)); // WHERE categoryid IN (12, 34) $query->filterByCategoryId(array('min' => 12)); // WHERE category_id > 12

Filter the query on the default_category column

Example usage: $query->filterByDefaultCategory(true); // WHERE defaultcategory = true $query->filterByDefaultCategory('yes'); // WHERE defaultcategory = true

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 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 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\Category object

Adds a JOIN clause to the query using the Category relation

Use the Category relation Category object

Exclude object from result

Deletes all rows from the product_category table.

Performs a DELETE on the database, given a ChildProductCategory 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 product_id column

Order by the category_id column

Order by the default_category column

Order by the position column

Order by the created_at column

Order by the updated_at column

Group by the product_id column

Group by the category_id column

Group by the default_category 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 Category relation

Adds a RIGHT JOIN clause to the query using the Category relation

Adds a INNER JOIN clause to the query using the Category relation

Return the first ChildProductCategory matching the query

Return the first ChildProductCategory matching the query, or a new ChildProductCategory object populated from the query conditions when no match is found

Return the first ChildProductCategory filtered by the product_id column

Return the first ChildProductCategory filtered by the category_id column

Return the first ChildProductCategory filtered by the default_category column

Return the first ChildProductCategory filtered by the position column

Return the first ChildProductCategory filtered by the created_at column

Return the first ChildProductCategory filtered by the updated_at column

Return ChildProductCategory objects filtered by the product_id column

Return ChildProductCategory objects filtered by the category_id column

Return ChildProductCategory objects filtered by the default_category column

Return ChildProductCategory objects filtered by the position column

Return ChildProductCategory objects filtered by the created_at column

Return ChildProductCategory objects filtered by the updated_at column