class ProductQuery extends ModelCriteria

Base class that represents a query for the 'product' table.

Properties

static $isVersioningEnabled Whether the versioning is enabled

Methods

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\Product', string $modelAlias = null)

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

static  ProductQuery
create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProductQuery object.

Product|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

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

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByTaxRuleId( mixed $taxRuleId = null, string $comparison = null)

Filter the query on the taxruleid column

filterByRef( string $ref = null, string $comparison = null)

Filter the query on the ref column

filterByVisible( mixed $visible = null, string $comparison = null)

Filter the query on the visible column

filterByPosition( mixed $position = null, string $comparison = null)

Filter the query on the position column

filterByTemplateId( mixed $templateId = null, string $comparison = null)

Filter the query on the template_id column

filterByBrandId( mixed $brandId = null, string $comparison = null)

Filter the query on the brand_id column

filterByVirtual( mixed $virtual = null, string $comparison = null)

Filter the query on the virtual column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByVersion( mixed $version = null, string $comparison = null)

Filter the query on the version column

filterByVersionCreatedAt( mixed $versionCreatedAt = null, string $comparison = null)

Filter the query on the versioncreatedat column

filterByVersionCreatedBy( string $versionCreatedBy = null, string $comparison = null)

Filter the query on the versioncreatedby column

filterByTaxRule( TaxRule|ObjectCollection $taxRule, string $comparison = null)

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

joinTaxRule( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the TaxRule relation

useTaxRuleQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the TaxRule relation TaxRule object

filterByTemplate( Template|ObjectCollection $template, string $comparison = null)

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

joinTemplate( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the Template relation

useTemplateQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the Template relation Template object

filterByBrand( Brand|ObjectCollection $brand, string $comparison = null)

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

joinBrand( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the Brand relation

useBrandQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the Brand relation Brand object

filterByProductCategory( ProductCategory|ObjectCollection $productCategory, string $comparison = null)

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

joinProductCategory( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductCategory relation

useProductCategoryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductCategory relation ProductCategory object

filterByFeatureProduct( FeatureProduct|ObjectCollection $featureProduct, string $comparison = null)

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

joinFeatureProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the FeatureProduct relation

useFeatureProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the FeatureProduct relation FeatureProduct object

filterByProductSaleElements( ProductSaleElements|ObjectCollection $productSaleElements, string $comparison = null)

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

joinProductSaleElements( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElements relation

useProductSaleElementsQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElements relation ProductSaleElements object

filterByProductImage( ProductImage|ObjectCollection $productImage, string $comparison = null)

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

joinProductImage( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductImage relation

useProductImageQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductImage relation ProductImage object

filterByProductDocument( ProductDocument|ObjectCollection $productDocument, string $comparison = null)

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

joinProductDocument( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductDocument relation

useProductDocumentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductDocument relation ProductDocument object

filterByAccessoryRelatedByProductId( Accessory|ObjectCollection $accessory, string $comparison = null)

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

joinAccessoryRelatedByProductId( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AccessoryRelatedByProductId relation

useAccessoryRelatedByProductIdQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AccessoryRelatedByProductId relation Accessory object

filterByAccessoryRelatedByAccessory( Accessory|ObjectCollection $accessory, string $comparison = null)

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

joinAccessoryRelatedByAccessory( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AccessoryRelatedByAccessory relation

useAccessoryRelatedByAccessoryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AccessoryRelatedByAccessory relation Accessory object

filterByCartItem( CartItem|ObjectCollection $cartItem, string $comparison = null)

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

joinCartItem( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the CartItem relation

useCartItemQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the CartItem relation CartItem object

filterByProductAssociatedContent( ProductAssociatedContent|ObjectCollection $productAssociatedContent, string $comparison = null)

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

joinProductAssociatedContent( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductAssociatedContent relation

useProductAssociatedContentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductAssociatedContent relation ProductAssociatedContent object

filterBySaleProduct( SaleProduct|ObjectCollection $saleProduct, string $comparison = null)

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

joinSaleProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the SaleProduct relation

useSaleProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the SaleProduct relation SaleProduct object

filterByProductI18n( ProductI18n|ObjectCollection $productI18n, string $comparison = null)

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

joinProductI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the ProductI18n relation

useProductI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the ProductI18n relation ProductI18n object

filterByProductVersion( ProductVersion|ObjectCollection $productVersion, string $comparison = null)

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

joinProductVersion( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductVersion relation

useProductVersionQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductVersion relation ProductVersion object

filterByCategory( Category $category, string $comparison = Criteria::EQUAL)

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

filterByProductRelatedByAccessory( Product $product, string $comparison = Criteria::EQUAL)

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

filterByProductRelatedByProductId( Product $product, string $comparison = Criteria::EQUAL)

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

prune( Product $product = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the product table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildProduct or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query and hydrates the related I18n object.

useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

static  boolean
isVersioningEnabled()

Checks whether versioning is enabled

static 
enableVersioning()

Enables versioning

static 
disableVersioning()

Disables versioning

ChildProductQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildProductQuery
orderByTaxRuleId($order = Criteria::ASC)

Order by the taxruleid column

ChildProductQuery
orderByRef($order = Criteria::ASC)

Order by the ref column

ChildProductQuery
orderByVisible($order = Criteria::ASC)

Order by the visible column

ChildProductQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildProductQuery
orderByTemplateId($order = Criteria::ASC)

Order by the template_id column

ChildProductQuery
orderByBrandId($order = Criteria::ASC)

Order by the brand_id column

ChildProductQuery
orderByVirtual($order = Criteria::ASC)

Order by the virtual column

ChildProductQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildProductQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildProductQuery
orderByVersion($order = Criteria::ASC)

Order by the version column

ChildProductQuery
orderByVersionCreatedAt($order = Criteria::ASC)

Order by the versioncreatedat column

ChildProductQuery
orderByVersionCreatedBy($order = Criteria::ASC)

Order by the versioncreatedby column

ChildProductQuery
groupById()

Group by the id column

ChildProductQuery
groupByTaxRuleId()

Group by the taxruleid column

ChildProductQuery
groupByRef()

Group by the ref column

ChildProductQuery
groupByVisible()

Group by the visible column

ChildProductQuery
groupByPosition()

Group by the position column

ChildProductQuery
groupByTemplateId()

Group by the template_id column

ChildProductQuery
groupByBrandId()

Group by the brand_id column

ChildProductQuery
groupByVirtual()

Group by the virtual column

ChildProductQuery
groupByCreatedAt()

Group by the created_at column

ChildProductQuery
groupByUpdatedAt()

Group by the updated_at column

ChildProductQuery
groupByVersion()

Group by the version column

ChildProductQuery
groupByVersionCreatedAt()

Group by the versioncreatedat column

ChildProductQuery
groupByVersionCreatedBy()

Group by the versioncreatedby column

ChildProductQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildProductQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildProductQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildProductQuery
leftJoinTaxRule($relationAlias = null)

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

ChildProductQuery
rightJoinTaxRule($relationAlias = null)

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

ChildProductQuery
innerJoinTaxRule($relationAlias = null)

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

ChildProductQuery
leftJoinTemplate($relationAlias = null)

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

ChildProductQuery
rightJoinTemplate($relationAlias = null)

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

ChildProductQuery
innerJoinTemplate($relationAlias = null)

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

ChildProductQuery
leftJoinBrand($relationAlias = null)

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

ChildProductQuery
rightJoinBrand($relationAlias = null)

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

ChildProductQuery
innerJoinBrand($relationAlias = null)

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

ChildProductQuery
leftJoinProductCategory($relationAlias = null)

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

ChildProductQuery
rightJoinProductCategory($relationAlias = null)

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

ChildProductQuery
innerJoinProductCategory($relationAlias = null)

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

ChildProductQuery
leftJoinFeatureProduct($relationAlias = null)

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

ChildProductQuery
rightJoinFeatureProduct($relationAlias = null)

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

ChildProductQuery
innerJoinFeatureProduct($relationAlias = null)

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

ChildProductQuery
leftJoinProductSaleElements($relationAlias = null)

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

ChildProductQuery
rightJoinProductSaleElements($relationAlias = null)

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

ChildProductQuery
innerJoinProductSaleElements($relationAlias = null)

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

ChildProductQuery
leftJoinProductImage($relationAlias = null)

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

ChildProductQuery
rightJoinProductImage($relationAlias = null)

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

ChildProductQuery
innerJoinProductImage($relationAlias = null)

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

ChildProductQuery
leftJoinProductDocument($relationAlias = null)

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

ChildProductQuery
rightJoinProductDocument($relationAlias = null)

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

ChildProductQuery
innerJoinProductDocument($relationAlias = null)

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

ChildProductQuery
leftJoinAccessoryRelatedByProductId($relationAlias = null)

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

ChildProductQuery
rightJoinAccessoryRelatedByProductId($relationAlias = null)

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

ChildProductQuery
innerJoinAccessoryRelatedByProductId($relationAlias = null)

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

ChildProductQuery
leftJoinAccessoryRelatedByAccessory($relationAlias = null)

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

ChildProductQuery
rightJoinAccessoryRelatedByAccessory($relationAlias = null)

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

ChildProductQuery
innerJoinAccessoryRelatedByAccessory($relationAlias = null)

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

ChildProductQuery
leftJoinCartItem($relationAlias = null)

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

ChildProductQuery
rightJoinCartItem($relationAlias = null)

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

ChildProductQuery
innerJoinCartItem($relationAlias = null)

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

ChildProductQuery
leftJoinProductAssociatedContent($relationAlias = null)

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

ChildProductQuery
rightJoinProductAssociatedContent($relationAlias = null)

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

ChildProductQuery
innerJoinProductAssociatedContent($relationAlias = null)

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

ChildProductQuery
leftJoinSaleProduct($relationAlias = null)

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

ChildProductQuery
rightJoinSaleProduct($relationAlias = null)

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

ChildProductQuery
innerJoinSaleProduct($relationAlias = null)

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

ChildProductQuery
leftJoinProductI18n($relationAlias = null)

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

ChildProductQuery
rightJoinProductI18n($relationAlias = null)

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

ChildProductQuery
innerJoinProductI18n($relationAlias = null)

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

ChildProductQuery
leftJoinProductVersion($relationAlias = null)

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

ChildProductQuery
rightJoinProductVersion($relationAlias = null)

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

ChildProductQuery
innerJoinProductVersion($relationAlias = null)

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

ChildProduct
findOne( ConnectionInterface $con = null)

Return the first ChildProduct matching the query

ChildProduct
findOneOrCreate( ConnectionInterface $con = null)

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

ChildProduct
findOneById( int $id)

Return the first ChildProduct filtered by the id column

ChildProduct
findOneByTaxRuleId( int $tax_rule_id)

Return the first ChildProduct filtered by the taxruleid column

ChildProduct
findOneByRef( string $ref)

Return the first ChildProduct filtered by the ref column

ChildProduct
findOneByVisible( int $visible)

Return the first ChildProduct filtered by the visible column

ChildProduct
findOneByPosition( int $position)

Return the first ChildProduct filtered by the position column

ChildProduct
findOneByTemplateId( int $template_id)

Return the first ChildProduct filtered by the template_id column

ChildProduct
findOneByBrandId( int $brand_id)

Return the first ChildProduct filtered by the brand_id column

ChildProduct
findOneByVirtual( int $virtual)

Return the first ChildProduct filtered by the virtual column

ChildProduct
findOneByCreatedAt( string $created_at)

Return the first ChildProduct filtered by the created_at column

ChildProduct
findOneByUpdatedAt( string $updated_at)

Return the first ChildProduct filtered by the updated_at column

ChildProduct
findOneByVersion( int $version)

Return the first ChildProduct filtered by the version column

ChildProduct
findOneByVersionCreatedAt( string $version_created_at)

Return the first ChildProduct filtered by the versioncreatedat column

ChildProduct
findOneByVersionCreatedBy( string $version_created_by)

Return the first ChildProduct filtered by the versioncreatedby column

array
findById( int $id)

Return ChildProduct objects filtered by the id column

array
findByTaxRuleId( int $tax_rule_id)

Return ChildProduct objects filtered by the taxruleid column

array
findByRef( string $ref)

Return ChildProduct objects filtered by the ref column

array
findByVisible( int $visible)

Return ChildProduct objects filtered by the visible column

array
findByPosition( int $position)

Return ChildProduct objects filtered by the position column

array
findByTemplateId( int $template_id)

Return ChildProduct objects filtered by the template_id column

array
findByBrandId( int $brand_id)

Return ChildProduct objects filtered by the brand_id column

array
findByVirtual( int $virtual)

Return ChildProduct objects filtered by the virtual column

array
findByCreatedAt( string $created_at)

Return ChildProduct objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildProduct objects filtered by the updated_at column

array
findByVersion( int $version)

Return ChildProduct objects filtered by the version column

array
findByVersionCreatedAt( string $version_created_at)

Return ChildProduct objects filtered by the versioncreatedat column

array
findByVersionCreatedBy( string $version_created_by)

Return ChildProduct objects filtered by the versioncreatedby column

Details

at line 166
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\Product', string $modelAlias = null)

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

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

at line 179
static ProductQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProductQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

ProductQuery

at line 209
Product|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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

Product|array|mixed the result, formatted by the current formatter

at line 291
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

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

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

at line 312
ProductQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ProductQuery The current query, for fluid interface

at line 325
ProductQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

ProductQuery The current query, for fluid interface

at line 349
ProductQuery 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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 392
ProductQuery filterByTaxRuleId( mixed $taxRuleId = null, string $comparison = null)

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

Parameters

mixed $taxRuleId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

See also

filterByTaxRule()

at line 430
ProductQuery filterByRef( string $ref = null, string $comparison = null)

Filter the query on the ref column

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

Parameters

string $ref The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 462
ProductQuery 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

Parameters

mixed $visible The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 503
ProductQuery 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

Parameters

mixed $position The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 546
ProductQuery filterByTemplateId( mixed $templateId = null, string $comparison = null)

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

Parameters

mixed $templateId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

See also

filterByTemplate()

at line 589
ProductQuery filterByBrandId( mixed $brandId = null, string $comparison = null)

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

Parameters

mixed $brandId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

See also

filterByBrand()

at line 630
ProductQuery filterByVirtual( mixed $virtual = null, string $comparison = null)

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

Parameters

mixed $virtual The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 673
ProductQuery 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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 716
ProductQuery 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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 757
ProductQuery 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

Parameters

mixed $version The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 800
ProductQuery 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'

Parameters

mixed $versionCreatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 838
ProductQuery 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%'

Parameters

string $versionCreatedBy The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 860
ProductQuery filterByTaxRule( TaxRule|ObjectCollection $taxRule, string $comparison = null)

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

Parameters

TaxRule|ObjectCollection $taxRule The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 885
ProductQuery joinTaxRule( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the TaxRule relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 920
TaxRuleQuery useTaxRuleQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the TaxRule relation TaxRule object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TaxRuleQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 935
ProductQuery filterByTemplate( Template|ObjectCollection $template, string $comparison = null)

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

Parameters

Template|ObjectCollection $template The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 960
ProductQuery joinTemplate( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the Template relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 995
TemplateQuery useTemplateQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the Template relation Template object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TemplateQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1010
ProductQuery filterByBrand( Brand|ObjectCollection $brand, string $comparison = null)

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

Parameters

Brand|ObjectCollection $brand The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1035
ProductQuery joinBrand( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the Brand relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1070
BrandQuery useBrandQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the Brand relation Brand object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

BrandQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1085
ProductQuery filterByProductCategory( ProductCategory|ObjectCollection $productCategory, string $comparison = null)

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

Parameters

ProductCategory|ObjectCollection $productCategory the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1108
ProductQuery joinProductCategory( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductCategory relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1143
ProductCategoryQuery useProductCategoryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductCategory relation ProductCategory object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductCategoryQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1158
ProductQuery filterByFeatureProduct( FeatureProduct|ObjectCollection $featureProduct, string $comparison = null)

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

Parameters

FeatureProduct|ObjectCollection $featureProduct the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1181
ProductQuery joinFeatureProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the FeatureProduct relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1216
FeatureProductQuery useFeatureProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the FeatureProduct relation FeatureProduct object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

FeatureProductQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1231
ProductQuery filterByProductSaleElements( ProductSaleElements|ObjectCollection $productSaleElements, string $comparison = null)

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

Parameters

ProductSaleElements|ObjectCollection $productSaleElements the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1254
ProductQuery joinProductSaleElements( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductSaleElements relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1289
ProductSaleElementsQuery useProductSaleElementsQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductSaleElements relation ProductSaleElements object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductSaleElementsQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1304
ProductQuery filterByProductImage( ProductImage|ObjectCollection $productImage, string $comparison = null)

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

Parameters

ProductImage|ObjectCollection $productImage the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1327
ProductQuery joinProductImage( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductImage relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1362
ProductImageQuery useProductImageQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductImage relation ProductImage object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductImageQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1377
ProductQuery filterByProductDocument( ProductDocument|ObjectCollection $productDocument, string $comparison = null)

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

Parameters

ProductDocument|ObjectCollection $productDocument the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1400
ProductQuery joinProductDocument( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductDocument relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1435
ProductDocumentQuery useProductDocumentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductDocument relation ProductDocument object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductDocumentQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1450
ProductQuery filterByAccessoryRelatedByProductId( Accessory|ObjectCollection $accessory, string $comparison = null)

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

Parameters

Accessory|ObjectCollection $accessory the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1473
ProductQuery joinAccessoryRelatedByProductId( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AccessoryRelatedByProductId relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1508
AccessoryQuery useAccessoryRelatedByProductIdQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AccessoryRelatedByProductId relation Accessory object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AccessoryQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1523
ProductQuery filterByAccessoryRelatedByAccessory( Accessory|ObjectCollection $accessory, string $comparison = null)

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

Parameters

Accessory|ObjectCollection $accessory the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1546
ProductQuery joinAccessoryRelatedByAccessory( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the AccessoryRelatedByAccessory relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1581
AccessoryQuery useAccessoryRelatedByAccessoryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the AccessoryRelatedByAccessory relation Accessory object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AccessoryQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1596
ProductQuery filterByCartItem( CartItem|ObjectCollection $cartItem, string $comparison = null)

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

Parameters

CartItem|ObjectCollection $cartItem the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1619
ProductQuery joinCartItem( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the CartItem relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1654
CartItemQuery useCartItemQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the CartItem relation CartItem object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CartItemQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1669
ProductQuery filterByProductAssociatedContent( ProductAssociatedContent|ObjectCollection $productAssociatedContent, string $comparison = null)

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

Parameters

ProductAssociatedContent|ObjectCollection $productAssociatedContent the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1692
ProductQuery joinProductAssociatedContent( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductAssociatedContent relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1727
ProductAssociatedContentQuery useProductAssociatedContentQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductAssociatedContent relation ProductAssociatedContent object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductAssociatedContentQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1742
ProductQuery filterBySaleProduct( SaleProduct|ObjectCollection $saleProduct, string $comparison = null)

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

Parameters

SaleProduct|ObjectCollection $saleProduct the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1765
ProductQuery joinSaleProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the SaleProduct relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1800
SaleProductQuery useSaleProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the SaleProduct relation SaleProduct object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

SaleProductQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1815
ProductQuery filterByProductI18n( ProductI18n|ObjectCollection $productI18n, string $comparison = null)

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

Parameters

ProductI18n|ObjectCollection $productI18n the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1838
ProductQuery joinProductI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the ProductI18n relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1873
ProductI18nQuery useProductI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the ProductI18n relation ProductI18n object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductI18nQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1888
ProductQuery filterByProductVersion( ProductVersion|ObjectCollection $productVersion, string $comparison = null)

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

Parameters

ProductVersion|ObjectCollection $productVersion the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1911
ProductQuery joinProductVersion( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductVersion relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery The current query, for fluid interface

at line 1946
ProductVersionQuery useProductVersionQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductVersion relation ProductVersion object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductVersionQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 1962
ProductQuery filterByCategory( Category $category, string $comparison = Criteria::EQUAL)

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

Parameters

Category $category the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1979
ProductQuery filterByProductRelatedByAccessory( Product $product, string $comparison = Criteria::EQUAL)

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

Parameters

Product $product the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 1996
ProductQuery filterByProductRelatedByProductId( Product $product, string $comparison = Criteria::EQUAL)

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

Parameters

Product $product the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProductQuery The current query, for fluid interface

at line 2011
ProductQuery prune( Product $product = null)

Exclude object from result

Parameters

Product $product Object to remove from the list of results

Return Value

ProductQuery The current query, for fluid interface

at line 2026
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the product table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

at line 2063
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildProduct or Criteria object OR a primary key value.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

at line 2104
ProductQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

ProductQuery The current query, for fluid interface

at line 2116
ProductQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

ProductQuery The current query, for fluid interface

at line 2126
ProductQuery lastUpdatedFirst()

Order by update date desc

Return Value

ProductQuery The current query, for fluid interface

at line 2136
ProductQuery firstUpdatedFirst()

Order by update date asc

Return Value

ProductQuery The current query, for fluid interface

at line 2146
ProductQuery lastCreatedFirst()

Order by create date desc

Return Value

ProductQuery The current query, for fluid interface

at line 2156
ProductQuery firstCreatedFirst()

Order by create date asc

Return Value

ProductQuery The current query, for fluid interface

at line 2172
ProductQuery joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ProductQuery The current query, for fluid interface

at line 2190
ProductQuery 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()

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ProductQuery The current query, for fluid interface

at line 2211
ProductI18nQuery useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ProductI18nQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 2225
static boolean isVersioningEnabled()

Checks whether versioning is enabled

Return Value

boolean

at line 2233
static enableVersioning()

Enables versioning

at line 2241
static disableVersioning()

Disables versioning

at line 149
ChildProductQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByTaxRuleId($order = Criteria::ASC)

Order by the taxruleid column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByRef($order = Criteria::ASC)

Order by the ref column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByVisible($order = Criteria::ASC)

Order by the visible column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByTemplateId($order = Criteria::ASC)

Order by the template_id column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByBrandId($order = Criteria::ASC)

Order by the brand_id column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByVirtual($order = Criteria::ASC)

Order by the virtual column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByVersion($order = Criteria::ASC)

Order by the version column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByVersionCreatedAt($order = Criteria::ASC)

Order by the versioncreatedat column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery orderByVersionCreatedBy($order = Criteria::ASC)

Order by the versioncreatedby column

Parameters

$order

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupById()

Group by the id column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByTaxRuleId()

Group by the taxruleid column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByRef()

Group by the ref column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByVisible()

Group by the visible column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByPosition()

Group by the position column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByTemplateId()

Group by the template_id column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByBrandId()

Group by the brand_id column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByVirtual()

Group by the virtual column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByVersion()

Group by the version column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByVersionCreatedAt()

Group by the versioncreatedat column

Return Value

ChildProductQuery

at line 149
ChildProductQuery groupByVersionCreatedBy()

Group by the versioncreatedby column

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinTaxRule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinTaxRule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinTaxRule($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinTemplate($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinTemplate($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinTemplate($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinBrand($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinBrand($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinBrand($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinFeatureProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinFeatureProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinFeatureProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductSaleElements($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductSaleElements($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductSaleElements($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductImage($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductImage($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductImage($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductDocument($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductDocument($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductDocument($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinAccessoryRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinAccessoryRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinAccessoryRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinAccessoryRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinAccessoryRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinAccessoryRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinCartItem($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinCartItem($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinCartItem($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductAssociatedContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductAssociatedContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductAssociatedContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinSaleProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery leftJoinProductVersion($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery rightJoinProductVersion($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProductQuery innerJoinProductVersion($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductQuery

at line 149
ChildProduct findOne( ConnectionInterface $con = null)

Return the first ChildProduct matching the query

Parameters

ConnectionInterface $con

Return Value

ChildProduct

at line 149
ChildProduct findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildProduct

at line 149
ChildProduct findOneById( int $id)

Return the first ChildProduct filtered by the id column

Parameters

int $id

Return Value

ChildProduct

at line 149
ChildProduct findOneByTaxRuleId( int $tax_rule_id)

Return the first ChildProduct filtered by the taxruleid column

Parameters

int $tax_rule_id

Return Value

ChildProduct

at line 149
ChildProduct findOneByRef( string $ref)

Return the first ChildProduct filtered by the ref column

Parameters

string $ref

Return Value

ChildProduct

at line 149
ChildProduct findOneByVisible( int $visible)

Return the first ChildProduct filtered by the visible column

Parameters

int $visible

Return Value

ChildProduct

at line 149
ChildProduct findOneByPosition( int $position)

Return the first ChildProduct filtered by the position column

Parameters

int $position

Return Value

ChildProduct

at line 149
ChildProduct findOneByTemplateId( int $template_id)

Return the first ChildProduct filtered by the template_id column

Parameters

int $template_id

Return Value

ChildProduct

at line 149
ChildProduct findOneByBrandId( int $brand_id)

Return the first ChildProduct filtered by the brand_id column

Parameters

int $brand_id

Return Value

ChildProduct

at line 149
ChildProduct findOneByVirtual( int $virtual)

Return the first ChildProduct filtered by the virtual column

Parameters

int $virtual

Return Value

ChildProduct

at line 149
ChildProduct findOneByCreatedAt( string $created_at)

Return the first ChildProduct filtered by the created_at column

Parameters

string $created_at

Return Value

ChildProduct

at line 149
ChildProduct findOneByUpdatedAt( string $updated_at)

Return the first ChildProduct filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildProduct

at line 149
ChildProduct findOneByVersion( int $version)

Return the first ChildProduct filtered by the version column

Parameters

int $version

Return Value

ChildProduct

at line 149
ChildProduct findOneByVersionCreatedAt( string $version_created_at)

Return the first ChildProduct filtered by the versioncreatedat column

Parameters

string $version_created_at

Return Value

ChildProduct

at line 149
ChildProduct findOneByVersionCreatedBy( string $version_created_by)

Return the first ChildProduct filtered by the versioncreatedby column

Parameters

string $version_created_by

Return Value

ChildProduct

at line 149
array findById( int $id)

Return ChildProduct objects filtered by the id column

Parameters

int $id

Return Value

array

at line 149
array findByTaxRuleId( int $tax_rule_id)

Return ChildProduct objects filtered by the taxruleid column

Parameters

int $tax_rule_id

Return Value

array

at line 149
array findByRef( string $ref)

Return ChildProduct objects filtered by the ref column

Parameters

string $ref

Return Value

array

at line 149
array findByVisible( int $visible)

Return ChildProduct objects filtered by the visible column

Parameters

int $visible

Return Value

array

at line 149
array findByPosition( int $position)

Return ChildProduct objects filtered by the position column

Parameters

int $position

Return Value

array

at line 149
array findByTemplateId( int $template_id)

Return ChildProduct objects filtered by the template_id column

Parameters

int $template_id

Return Value

array

at line 149
array findByBrandId( int $brand_id)

Return ChildProduct objects filtered by the brand_id column

Parameters

int $brand_id

Return Value

array

at line 149
array findByVirtual( int $virtual)

Return ChildProduct objects filtered by the virtual column

Parameters

int $virtual

Return Value

array

at line 149
array findByCreatedAt( string $created_at)

Return ChildProduct objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 149
array findByUpdatedAt( string $updated_at)

Return ChildProduct objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array

at line 149
array findByVersion( int $version)

Return ChildProduct objects filtered by the version column

Parameters

int $version

Return Value

array

at line 149
array findByVersionCreatedAt( string $version_created_at)

Return ChildProduct objects filtered by the versioncreatedat column

Parameters

string $version_created_at

Return Value

array

at line 149
array findByVersionCreatedBy( string $version_created_by)

Return ChildProduct objects filtered by the versioncreatedby column

Parameters

string $version_created_by

Return Value

array