ProductQuery

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

Returns a new ChildProductQuery 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 taxruleid column

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

Filter the query on the ref column

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

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 template_id column

Example usage: $query->filterByTemplateId(1234); // WHERE templateid = 1234 $query->filterByTemplateId(array(12, 34)); // WHERE templateid IN (12, 34) $query->filterByTemplateId(array('min' => 12)); // WHERE template_id > 12

Filter the query on the brand_id column

Example usage: $query->filterByBrandId(1234); // WHERE brandid = 1234 $query->filterByBrandId(array(12, 34)); // WHERE brandid IN (12, 34) $query->filterByBrandId(array('min' => 12)); // WHERE brand_id > 12

Filter the query on the virtual column

Example usage: $query->filterByVirtual(1234); // WHERE virtual = 1234 $query->filterByVirtual(array(12, 34)); // WHERE virtual IN (12, 34) $query->filterByVirtual(array('min' => 12)); // WHERE virtual > 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\TaxRule object

Adds a JOIN clause to the query using the TaxRule relation

Use the TaxRule relation TaxRule object

Filter the query by a related \Thelia\Model\Template object

Adds a JOIN clause to the query using the Template relation

Use the Template relation Template object

Filter the query by a related \Thelia\Model\Brand object

Adds a JOIN clause to the query using the Brand relation

Use the Brand relation Brand object

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

Adds a JOIN clause to the query using the ProductSaleElements relation

Use the ProductSaleElements relation ProductSaleElements object

Filter the query by a related \Thelia\Model\ProductImage object

Adds a JOIN clause to the query using the ProductImage relation

Use the ProductImage relation ProductImage object

Filter the query by a related \Thelia\Model\ProductDocument object

Adds a JOIN clause to the query using the ProductDocument relation

Use the ProductDocument relation ProductDocument object

Filter the query by a related \Thelia\Model\Accessory object

Adds a JOIN clause to the query using the AccessoryRelatedByProductId relation

Use the AccessoryRelatedByProductId relation Accessory object

Filter the query by a related \Thelia\Model\Accessory object

Adds a JOIN clause to the query using the AccessoryRelatedByAccessory relation

Use the AccessoryRelatedByAccessory relation Accessory object

Filter the query by a related \Thelia\Model\CartItem object

Adds a JOIN clause to the query using the CartItem relation

Use the CartItem relation CartItem object

Filter the query by a related \Thelia\Model\ProductAssociatedContent object

Adds a JOIN clause to the query using the ProductAssociatedContent relation

Use the ProductAssociatedContent relation ProductAssociatedContent object

Filter the query by a related \Thelia\Model\SaleProduct object

Adds a JOIN clause to the query using the SaleProduct relation

Use the SaleProduct relation SaleProduct object

Filter the query by a related \Thelia\Model\ProductI18n object

Adds a JOIN clause to the query using the ProductI18n relation

Use the ProductI18n relation ProductI18n object

Filter the query by a related \Thelia\Model\ProductVersion object

Adds a JOIN clause to the query using the ProductVersion relation

Use the ProductVersion relation ProductVersion object

Filter the query by a related Category object using the product_category table as cross reference

Filter the query by a related Product object using the accessory table as cross reference

Filter the query by a related Product object using the accessory table as cross reference

Exclude object from result

Deletes all rows from the product table.

Performs a DELETE on the database, given a ChildProduct 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.

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

Use the I18n relation query object

Checks whether versioning is enabled

Enables versioning

Disables versioning

Order by the id column

Order by the taxruleid column

Order by the ref column

Order by the visible column

Order by the template_id column

Order by the brand_id column

Order by the virtual 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 taxruleid column

Group by the ref column

Group by the visible column

Group by the template_id column

Group by the brand_id column

Group by the virtual 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 TaxRule relation

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

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

Adds a LEFT JOIN clause to the query using the Template relation

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

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

Adds a LEFT JOIN clause to the query using the Brand relation

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

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

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 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 ProductSaleElements relation

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

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

Adds a LEFT JOIN clause to the query using the ProductImage relation

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

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

Adds a LEFT JOIN clause to the query using the ProductDocument relation

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

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

Adds a LEFT JOIN clause to the query using the AccessoryRelatedByProductId relation

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

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

Adds a LEFT JOIN clause to the query using the AccessoryRelatedByAccessory relation

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

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

Adds a LEFT JOIN clause to the query using the CartItem relation

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

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

Adds a LEFT JOIN clause to the query using the ProductAssociatedContent relation

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

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

Adds a LEFT JOIN clause to the query using the SaleProduct relation

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

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

Adds a LEFT JOIN clause to the query using the ProductI18n relation

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

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

Adds a LEFT JOIN clause to the query using the ProductVersion relation

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

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

Return the first ChildProduct matching the query

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

Return the first ChildProduct filtered by the id column

Return the first ChildProduct filtered by the taxruleid column

Return the first ChildProduct filtered by the ref column

Return the first ChildProduct filtered by the visible column

Return the first ChildProduct filtered by the template_id column

Return the first ChildProduct filtered by the brand_id column

Return the first ChildProduct filtered by the virtual column

Return the first ChildProduct filtered by the created_at column

Return the first ChildProduct filtered by the updated_at column

Return the first ChildProduct filtered by the version column

Return the first ChildProduct filtered by the versioncreatedat column

Return the first ChildProduct filtered by the versioncreatedby column

Return ChildProduct objects filtered by the id column

Return ChildProduct objects filtered by the taxruleid column

Return ChildProduct objects filtered by the ref column

Return ChildProduct objects filtered by the visible column

Return ChildProduct objects filtered by the template_id column

Return ChildProduct objects filtered by the brand_id column

Return ChildProduct objects filtered by the virtual column

Return ChildProduct objects filtered by the created_at column

Return ChildProduct objects filtered by the updated_at column

Return ChildProduct objects filtered by the version column

Return ChildProduct objects filtered by the versioncreatedat column

Return ChildProduct objects filtered by the versioncreatedby column