ProductQuery
class ProductQuery extends ModelCriteria
Base class that represents a query for the 'product' table.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled |
Methods
Initializes internal state of \Thelia\Model\Base\ProductQuery object.
Returns a new ChildProductQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the taxruleid column
Filter the query on the ref column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the template_id column
Filter the query on the brand_id column
Filter the query on the virtual column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query on the version column
Filter the query on the versioncreatedat column
Filter the query on the versioncreatedby column
Filter the query by a related \Thelia\Model\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
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.
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 position 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 position 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 position 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 position 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
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.
at line 179
static
ProductQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProductQuery object.
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);
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);
at line 312
ProductQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 325
ProductQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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
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%'
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
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
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
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
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
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'
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'
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
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'
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%'
at line 860
ProductQuery
filterByTaxRule(
TaxRule|ObjectCollection $taxRule,
string $comparison = null)
Filter the query by a related \Thelia\Model\TaxRule object
at line 885
ProductQuery
joinTaxRule(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the TaxRule relation
at line 920
TaxRuleQuery
useTaxRuleQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the TaxRule relation TaxRule object
at line 935
ProductQuery
filterByTemplate(
Template|ObjectCollection $template,
string $comparison = null)
Filter the query by a related \Thelia\Model\Template object
at line 960
ProductQuery
joinTemplate(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Template relation
at line 995
TemplateQuery
useTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Template relation Template object
at line 1010
ProductQuery
filterByBrand(
Brand|ObjectCollection $brand,
string $comparison = null)
Filter the query by a related \Thelia\Model\Brand object
at line 1035
ProductQuery
joinBrand(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Brand relation
at line 1070
BrandQuery
useBrandQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Brand relation Brand object
at line 1085
ProductQuery
filterByProductCategory(
ProductCategory|ObjectCollection $productCategory,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductCategory object
at line 1108
ProductQuery
joinProductCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductCategory relation
at line 1143
ProductCategoryQuery
useProductCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductCategory relation ProductCategory object
at line 1158
ProductQuery
filterByFeatureProduct(
FeatureProduct|ObjectCollection $featureProduct,
string $comparison = null)
Filter the query by a related \Thelia\Model\FeatureProduct object
at line 1181
ProductQuery
joinFeatureProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FeatureProduct relation
at line 1216
FeatureProductQuery
useFeatureProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FeatureProduct relation FeatureProduct object
at line 1231
ProductQuery
filterByProductSaleElements(
ProductSaleElements|ObjectCollection $productSaleElements,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductSaleElements object
at line 1254
ProductQuery
joinProductSaleElements(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductSaleElements relation
at line 1289
ProductSaleElementsQuery
useProductSaleElementsQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductSaleElements relation ProductSaleElements object
at line 1304
ProductQuery
filterByProductImage(
ProductImage|ObjectCollection $productImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductImage object
at line 1327
ProductQuery
joinProductImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductImage relation
at line 1362
ProductImageQuery
useProductImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductImage relation ProductImage object
at line 1377
ProductQuery
filterByProductDocument(
ProductDocument|ObjectCollection $productDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductDocument object
at line 1400
ProductQuery
joinProductDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductDocument relation
at line 1435
ProductDocumentQuery
useProductDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductDocument relation ProductDocument object
at line 1450
ProductQuery
filterByAccessoryRelatedByProductId(
Accessory|ObjectCollection $accessory,
string $comparison = null)
Filter the query by a related \Thelia\Model\Accessory object
at line 1473
ProductQuery
joinAccessoryRelatedByProductId(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AccessoryRelatedByProductId relation
at line 1508
AccessoryQuery
useAccessoryRelatedByProductIdQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AccessoryRelatedByProductId relation Accessory object
at line 1523
ProductQuery
filterByAccessoryRelatedByAccessory(
Accessory|ObjectCollection $accessory,
string $comparison = null)
Filter the query by a related \Thelia\Model\Accessory object
at line 1546
ProductQuery
joinAccessoryRelatedByAccessory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AccessoryRelatedByAccessory relation
at line 1581
AccessoryQuery
useAccessoryRelatedByAccessoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AccessoryRelatedByAccessory relation Accessory object
at line 1596
ProductQuery
filterByCartItem(
CartItem|ObjectCollection $cartItem,
string $comparison = null)
Filter the query by a related \Thelia\Model\CartItem object
at line 1619
ProductQuery
joinCartItem(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CartItem relation
at line 1654
CartItemQuery
useCartItemQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CartItem relation CartItem object
at line 1669
ProductQuery
filterByProductAssociatedContent(
ProductAssociatedContent|ObjectCollection $productAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductAssociatedContent object
at line 1692
ProductQuery
joinProductAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductAssociatedContent relation
at line 1727
ProductAssociatedContentQuery
useProductAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductAssociatedContent relation ProductAssociatedContent object
at line 1742
ProductQuery
filterBySaleProduct(
SaleProduct|ObjectCollection $saleProduct,
string $comparison = null)
Filter the query by a related \Thelia\Model\SaleProduct object
at line 1765
ProductQuery
joinSaleProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the SaleProduct relation
at line 1800
SaleProductQuery
useSaleProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the SaleProduct relation SaleProduct object
at line 1815
ProductQuery
filterByProductI18n(
ProductI18n|ObjectCollection $productI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductI18n object
at line 1838
ProductQuery
joinProductI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ProductI18n relation
at line 1873
ProductI18nQuery
useProductI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ProductI18n relation ProductI18n object
at line 1888
ProductQuery
filterByProductVersion(
ProductVersion|ObjectCollection $productVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductVersion object
at line 1911
ProductQuery
joinProductVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductVersion relation
at line 1946
ProductVersionQuery
useProductVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductVersion relation ProductVersion object
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
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
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
at line 2011
ProductQuery
prune(
Product $product = null)
Exclude object from result
at line 2026
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the product table.
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.
at line 2104
ProductQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 2116
ProductQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 2126
ProductQuery
lastUpdatedFirst()
Order by update date desc
at line 2136
ProductQuery
firstUpdatedFirst()
Order by update date asc
at line 2146
ProductQuery
lastCreatedFirst()
Order by create date desc
at line 2156
ProductQuery
firstCreatedFirst()
Order by create date asc
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
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()
at line 2211
ProductI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 2225
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
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
at line 149
ChildProductQuery
orderByTaxRuleId($order = Criteria::ASC)
Order by the taxruleid column
at line 149
ChildProductQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
at line 149
ChildProductQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 149
ChildProductQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 149
ChildProductQuery
orderByTemplateId($order = Criteria::ASC)
Order by the template_id column
at line 149
ChildProductQuery
orderByBrandId($order = Criteria::ASC)
Order by the brand_id column
at line 149
ChildProductQuery
orderByVirtual($order = Criteria::ASC)
Order by the virtual column
at line 149
ChildProductQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 149
ChildProductQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 149
ChildProductQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 149
ChildProductQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 149
ChildProductQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 149
ChildProductQuery
groupById()
Group by the id column
at line 149
ChildProductQuery
groupByTaxRuleId()
Group by the taxruleid column
at line 149
ChildProductQuery
groupByRef()
Group by the ref column
at line 149
ChildProductQuery
groupByVisible()
Group by the visible column
at line 149
ChildProductQuery
groupByPosition()
Group by the position column
at line 149
ChildProductQuery
groupByTemplateId()
Group by the template_id column
at line 149
ChildProductQuery
groupByBrandId()
Group by the brand_id column
at line 149
ChildProductQuery
groupByVirtual()
Group by the virtual column
at line 149
ChildProductQuery
groupByCreatedAt()
Group by the created_at column
at line 149
ChildProductQuery
groupByUpdatedAt()
Group by the updated_at column
at line 149
ChildProductQuery
groupByVersion()
Group by the version column
at line 149
ChildProductQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 149
ChildProductQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 149
ChildProductQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 149
ChildProductQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 149
ChildProductQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 149
ChildProductQuery
leftJoinTaxRule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the TaxRule relation
at line 149
ChildProductQuery
rightJoinTaxRule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the TaxRule relation
at line 149
ChildProductQuery
innerJoinTaxRule($relationAlias = null)
Adds a INNER JOIN clause to the query using the TaxRule relation
at line 149
ChildProductQuery
leftJoinTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Template relation
at line 149
ChildProductQuery
rightJoinTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Template relation
at line 149
ChildProductQuery
innerJoinTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the Template relation
at line 149
ChildProductQuery
leftJoinBrand($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Brand relation
at line 149
ChildProductQuery
rightJoinBrand($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Brand relation
at line 149
ChildProductQuery
innerJoinBrand($relationAlias = null)
Adds a INNER JOIN clause to the query using the Brand relation
at line 149
ChildProductQuery
leftJoinProductCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductCategory relation
at line 149
ChildProductQuery
rightJoinProductCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductCategory relation
at line 149
ChildProductQuery
innerJoinProductCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductCategory relation
at line 149
ChildProductQuery
leftJoinFeatureProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FeatureProduct relation
at line 149
ChildProductQuery
rightJoinFeatureProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FeatureProduct relation
at line 149
ChildProductQuery
innerJoinFeatureProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the FeatureProduct relation
at line 149
ChildProductQuery
leftJoinProductSaleElements($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductSaleElements relation
at line 149
ChildProductQuery
rightJoinProductSaleElements($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductSaleElements relation
at line 149
ChildProductQuery
innerJoinProductSaleElements($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductSaleElements relation
at line 149
ChildProductQuery
leftJoinProductImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductImage relation
at line 149
ChildProductQuery
rightJoinProductImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductImage relation
at line 149
ChildProductQuery
innerJoinProductImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductImage relation
at line 149
ChildProductQuery
leftJoinProductDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductDocument relation
at line 149
ChildProductQuery
rightJoinProductDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductDocument relation
at line 149
ChildProductQuery
innerJoinProductDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductDocument relation
at line 149
ChildProductQuery
leftJoinAccessoryRelatedByProductId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AccessoryRelatedByProductId relation
at line 149
ChildProductQuery
rightJoinAccessoryRelatedByProductId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AccessoryRelatedByProductId relation
at line 149
ChildProductQuery
innerJoinAccessoryRelatedByProductId($relationAlias = null)
Adds a INNER JOIN clause to the query using the AccessoryRelatedByProductId relation
at line 149
ChildProductQuery
leftJoinAccessoryRelatedByAccessory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AccessoryRelatedByAccessory relation
at line 149
ChildProductQuery
rightJoinAccessoryRelatedByAccessory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AccessoryRelatedByAccessory relation
at line 149
ChildProductQuery
innerJoinAccessoryRelatedByAccessory($relationAlias = null)
Adds a INNER JOIN clause to the query using the AccessoryRelatedByAccessory relation
at line 149
ChildProductQuery
leftJoinCartItem($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CartItem relation
at line 149
ChildProductQuery
rightJoinCartItem($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CartItem relation
at line 149
ChildProductQuery
innerJoinCartItem($relationAlias = null)
Adds a INNER JOIN clause to the query using the CartItem relation
at line 149
ChildProductQuery
leftJoinProductAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductAssociatedContent relation
at line 149
ChildProductQuery
rightJoinProductAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductAssociatedContent relation
at line 149
ChildProductQuery
innerJoinProductAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductAssociatedContent relation
at line 149
ChildProductQuery
leftJoinSaleProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the SaleProduct relation
at line 149
ChildProductQuery
rightJoinSaleProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the SaleProduct relation
at line 149
ChildProductQuery
innerJoinSaleProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the SaleProduct relation
at line 149
ChildProductQuery
leftJoinProductI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductI18n relation
at line 149
ChildProductQuery
rightJoinProductI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductI18n relation
at line 149
ChildProductQuery
innerJoinProductI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductI18n relation
at line 149
ChildProductQuery
leftJoinProductVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductVersion relation
at line 149
ChildProductQuery
rightJoinProductVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductVersion relation
at line 149
ChildProductQuery
innerJoinProductVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductVersion relation
at line 149
ChildProduct
findOne(
ConnectionInterface $con = null)
Return the first ChildProduct matching the query
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
at line 149
ChildProduct
findOneById(
int $id)
Return the first ChildProduct filtered by the id column
at line 149
ChildProduct
findOneByTaxRuleId(
int $tax_rule_id)
Return the first ChildProduct filtered by the taxruleid column
at line 149
ChildProduct
findOneByRef(
string $ref)
Return the first ChildProduct filtered by the ref column
at line 149
ChildProduct
findOneByVisible(
int $visible)
Return the first ChildProduct filtered by the visible column
at line 149
ChildProduct
findOneByPosition(
int $position)
Return the first ChildProduct filtered by the position column
at line 149
ChildProduct
findOneByTemplateId(
int $template_id)
Return the first ChildProduct filtered by the template_id column
at line 149
ChildProduct
findOneByBrandId(
int $brand_id)
Return the first ChildProduct filtered by the brand_id column
at line 149
ChildProduct
findOneByVirtual(
int $virtual)
Return the first ChildProduct filtered by the virtual column
at line 149
ChildProduct
findOneByCreatedAt(
string $created_at)
Return the first ChildProduct filtered by the created_at column
at line 149
ChildProduct
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProduct filtered by the updated_at column
at line 149
ChildProduct
findOneByVersion(
int $version)
Return the first ChildProduct filtered by the version column
at line 149
ChildProduct
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildProduct filtered by the versioncreatedat column
at line 149
ChildProduct
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildProduct filtered by the versioncreatedby column
at line 149
array
findById(
int $id)
Return ChildProduct objects filtered by the id column
at line 149
array
findByTaxRuleId(
int $tax_rule_id)
Return ChildProduct objects filtered by the taxruleid column
at line 149
array
findByRef(
string $ref)
Return ChildProduct objects filtered by the ref column
at line 149
array
findByVisible(
int $visible)
Return ChildProduct objects filtered by the visible column
at line 149
array
findByPosition(
int $position)
Return ChildProduct objects filtered by the position column
at line 149
array
findByTemplateId(
int $template_id)
Return ChildProduct objects filtered by the template_id column
at line 149
array
findByBrandId(
int $brand_id)
Return ChildProduct objects filtered by the brand_id column
at line 149
array
findByVirtual(
int $virtual)
Return ChildProduct objects filtered by the virtual column
at line 149
array
findByCreatedAt(
string $created_at)
Return ChildProduct objects filtered by the created_at column
at line 149
array
findByUpdatedAt(
string $updated_at)
Return ChildProduct objects filtered by the updated_at column
at line 149
array
findByVersion(
int $version)
Return ChildProduct objects filtered by the version column
at line 149
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildProduct objects filtered by the versioncreatedat column
at line 149
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildProduct objects filtered by the versioncreatedby column