class OrderProductQuery extends OrderProductQuery

Skeleton subclass for performing query and update operations on the 'order_product' table.

You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.

Methods

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

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

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

Returns a new ChildOrderProductQuery object.

OrderProduct|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

filterByOrderId( mixed $orderId = null, string $comparison = null)

Filter the query on the order_id column

filterByProductRef( string $productRef = null, string $comparison = null)

Filter the query on the product_ref column

filterByProductSaleElementsRef( string $productSaleElementsRef = null, string $comparison = null)

Filter the query on the productsaleelements_ref column

filterByProductSaleElementsId( mixed $productSaleElementsId = null, string $comparison = null)

Filter the query on the productsaleelements_id column

filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

filterByChapo( string $chapo = null, string $comparison = null)

Filter the query on the chapo column

filterByDescription( string $description = null, string $comparison = null)

Filter the query on the description column

filterByPostscriptum( string $postscriptum = null, string $comparison = null)

Filter the query on the postscriptum column

filterByQuantity( mixed $quantity = null, string $comparison = null)

Filter the query on the quantity column

filterByPrice( mixed $price = null, string $comparison = null)

Filter the query on the price column

filterByPromoPrice( mixed $promoPrice = null, string $comparison = null)

Filter the query on the promo_price column

filterByWasNew( mixed $wasNew = null, string $comparison = null)

Filter the query on the was_new column

filterByWasInPromo( mixed $wasInPromo = null, string $comparison = null)

Filter the query on the wasinpromo column

filterByWeight( string $weight = null, string $comparison = null)

Filter the query on the weight column

filterByEanCode( string $eanCode = null, string $comparison = null)

Filter the query on the ean_code column

filterByTaxRuleTitle( string $taxRuleTitle = null, string $comparison = null)

Filter the query on the taxruletitle column

filterByTaxRuleDescription( string $taxRuleDescription = null, string $comparison = null)

Filter the query on the taxruledescription column

filterByParent( mixed $parent = null, string $comparison = null)

Filter the query on the parent column

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

Filter the query on the virtual column

filterByVirtualDocument( string $virtualDocument = null, string $comparison = null)

Filter the query on the virtual_document 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

filterByOrder( Order|ObjectCollection $order, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Order relation

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

Use the Order relation Order object

filterByOrderProductAttributeCombination( OrderProductAttributeCombination|ObjectCollection $orderProductAttributeCombination, string $comparison = null)

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

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

Adds a JOIN clause to the query using the OrderProductAttributeCombination relation

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

Use the OrderProductAttributeCombination relation OrderProductAttributeCombination object

filterByOrderProductTax( OrderProductTax|ObjectCollection $orderProductTax, string $comparison = null)

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

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

Adds a JOIN clause to the query using the OrderProductTax relation

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

Use the OrderProductTax relation OrderProductTax object

prune( OrderProduct $orderProduct = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the order_product table.

int
delete( ConnectionInterface $con = null)

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

ChildOrderProductQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildOrderProductQuery
orderByOrderId($order = Criteria::ASC)

Order by the order_id column

ChildOrderProductQuery
orderByProductRef($order = Criteria::ASC)

Order by the product_ref column

ChildOrderProductQuery
orderByProductSaleElementsRef($order = Criteria::ASC)

Order by the productsaleelements_ref column

ChildOrderProductQuery
orderByProductSaleElementsId($order = Criteria::ASC)

Order by the productsaleelements_id column

ChildOrderProductQuery
orderByTitle($order = Criteria::ASC)

Order by the title column

ChildOrderProductQuery
orderByChapo($order = Criteria::ASC)

Order by the chapo column

ChildOrderProductQuery
orderByDescription($order = Criteria::ASC)

Order by the description column

ChildOrderProductQuery
orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

ChildOrderProductQuery
orderByQuantity($order = Criteria::ASC)

Order by the quantity column

ChildOrderProductQuery
orderByPrice($order = Criteria::ASC)

Order by the price column

ChildOrderProductQuery
orderByPromoPrice($order = Criteria::ASC)

Order by the promo_price column

ChildOrderProductQuery
orderByWasNew($order = Criteria::ASC)

Order by the was_new column

ChildOrderProductQuery
orderByWasInPromo($order = Criteria::ASC)

Order by the wasinpromo column

ChildOrderProductQuery
orderByWeight($order = Criteria::ASC)

Order by the weight column

ChildOrderProductQuery
orderByEanCode($order = Criteria::ASC)

Order by the ean_code column

ChildOrderProductQuery
orderByTaxRuleTitle($order = Criteria::ASC)

Order by the taxruletitle column

ChildOrderProductQuery
orderByTaxRuleDescription($order = Criteria::ASC)

Order by the taxruledescription column

ChildOrderProductQuery
orderByParent($order = Criteria::ASC)

Order by the parent column

ChildOrderProductQuery
orderByVirtual($order = Criteria::ASC)

Order by the virtual column

ChildOrderProductQuery
orderByVirtualDocument($order = Criteria::ASC)

Order by the virtual_document column

ChildOrderProductQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildOrderProductQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildOrderProductQuery
groupById()

Group by the id column

ChildOrderProductQuery
groupByOrderId()

Group by the order_id column

ChildOrderProductQuery
groupByProductRef()

Group by the product_ref column

ChildOrderProductQuery
groupByProductSaleElementsRef()

Group by the productsaleelements_ref column

ChildOrderProductQuery
groupByProductSaleElementsId()

Group by the productsaleelements_id column

ChildOrderProductQuery
groupByTitle()

Group by the title column

ChildOrderProductQuery
groupByChapo()

Group by the chapo column

ChildOrderProductQuery
groupByDescription()

Group by the description column

ChildOrderProductQuery
groupByPostscriptum()

Group by the postscriptum column

ChildOrderProductQuery
groupByQuantity()

Group by the quantity column

ChildOrderProductQuery
groupByPrice()

Group by the price column

ChildOrderProductQuery
groupByPromoPrice()

Group by the promo_price column

ChildOrderProductQuery
groupByWasNew()

Group by the was_new column

ChildOrderProductQuery
groupByWasInPromo()

Group by the wasinpromo column

ChildOrderProductQuery
groupByWeight()

Group by the weight column

ChildOrderProductQuery
groupByEanCode()

Group by the ean_code column

ChildOrderProductQuery
groupByTaxRuleTitle()

Group by the taxruletitle column

ChildOrderProductQuery
groupByTaxRuleDescription()

Group by the taxruledescription column

ChildOrderProductQuery
groupByParent()

Group by the parent column

ChildOrderProductQuery
groupByVirtual()

Group by the virtual column

ChildOrderProductQuery
groupByVirtualDocument()

Group by the virtual_document column

ChildOrderProductQuery
groupByCreatedAt()

Group by the created_at column

ChildOrderProductQuery
groupByUpdatedAt()

Group by the updated_at column

ChildOrderProductQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildOrderProductQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildOrderProductQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildOrderProductQuery
leftJoinOrder($relationAlias = null)

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

ChildOrderProductQuery
rightJoinOrder($relationAlias = null)

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

ChildOrderProductQuery
innerJoinOrder($relationAlias = null)

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

ChildOrderProductQuery
leftJoinOrderProductAttributeCombination($relationAlias = null)

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

ChildOrderProductQuery
rightJoinOrderProductAttributeCombination($relationAlias = null)

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

ChildOrderProductQuery
innerJoinOrderProductAttributeCombination($relationAlias = null)

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

ChildOrderProductQuery
leftJoinOrderProductTax($relationAlias = null)

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

ChildOrderProductQuery
rightJoinOrderProductTax($relationAlias = null)

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

ChildOrderProductQuery
innerJoinOrderProductTax($relationAlias = null)

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

ChildOrderProduct
findOne( ConnectionInterface $con = null)

Return the first ChildOrderProduct matching the query

ChildOrderProduct
findOneOrCreate( ConnectionInterface $con = null)

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

ChildOrderProduct
findOneById( int $id)

Return the first ChildOrderProduct filtered by the id column

ChildOrderProduct
findOneByOrderId( int $order_id)

Return the first ChildOrderProduct filtered by the order_id column

ChildOrderProduct
findOneByProductRef( string $product_ref)

Return the first ChildOrderProduct filtered by the product_ref column

ChildOrderProduct
findOneByProductSaleElementsRef( string $product_sale_elements_ref)

Return the first ChildOrderProduct filtered by the productsaleelements_ref column

ChildOrderProduct
findOneByProductSaleElementsId( int $product_sale_elements_id)

Return the first ChildOrderProduct filtered by the productsaleelements_id column

ChildOrderProduct
findOneByTitle( string $title)

Return the first ChildOrderProduct filtered by the title column

ChildOrderProduct
findOneByChapo( string $chapo)

Return the first ChildOrderProduct filtered by the chapo column

ChildOrderProduct
findOneByDescription( string $description)

Return the first ChildOrderProduct filtered by the description column

ChildOrderProduct
findOneByPostscriptum( string $postscriptum)

Return the first ChildOrderProduct filtered by the postscriptum column

ChildOrderProduct
findOneByQuantity( double $quantity)

Return the first ChildOrderProduct filtered by the quantity column

ChildOrderProduct
findOneByPrice( string $price)

Return the first ChildOrderProduct filtered by the price column

ChildOrderProduct
findOneByPromoPrice( string $promo_price)

Return the first ChildOrderProduct filtered by the promo_price column

ChildOrderProduct
findOneByWasNew( int $was_new)

Return the first ChildOrderProduct filtered by the was_new column

ChildOrderProduct
findOneByWasInPromo( int $was_in_promo)

Return the first ChildOrderProduct filtered by the wasinpromo column

ChildOrderProduct
findOneByWeight( string $weight)

Return the first ChildOrderProduct filtered by the weight column

ChildOrderProduct
findOneByEanCode( string $ean_code)

Return the first ChildOrderProduct filtered by the ean_code column

ChildOrderProduct
findOneByTaxRuleTitle( string $tax_rule_title)

Return the first ChildOrderProduct filtered by the taxruletitle column

ChildOrderProduct
findOneByTaxRuleDescription( string $tax_rule_description)

Return the first ChildOrderProduct filtered by the taxruledescription column

ChildOrderProduct
findOneByParent( int $parent)

Return the first ChildOrderProduct filtered by the parent column

ChildOrderProduct
findOneByVirtual( int $virtual)

Return the first ChildOrderProduct filtered by the virtual column

ChildOrderProduct
findOneByVirtualDocument( string $virtual_document)

Return the first ChildOrderProduct filtered by the virtual_document column

ChildOrderProduct
findOneByCreatedAt( string $created_at)

Return the first ChildOrderProduct filtered by the created_at column

ChildOrderProduct
findOneByUpdatedAt( string $updated_at)

Return the first ChildOrderProduct filtered by the updated_at column

array
findById( int $id)

Return ChildOrderProduct objects filtered by the id column

array
findByOrderId( int $order_id)

Return ChildOrderProduct objects filtered by the order_id column

array
findByProductRef( string $product_ref)

Return ChildOrderProduct objects filtered by the product_ref column

array
findByProductSaleElementsRef( string $product_sale_elements_ref)

Return ChildOrderProduct objects filtered by the productsaleelements_ref column

array
findByProductSaleElementsId( int $product_sale_elements_id)

Return ChildOrderProduct objects filtered by the productsaleelements_id column

array
findByTitle( string $title)

Return ChildOrderProduct objects filtered by the title column

array
findByChapo( string $chapo)

Return ChildOrderProduct objects filtered by the chapo column

array
findByDescription( string $description)

Return ChildOrderProduct objects filtered by the description column

array
findByPostscriptum( string $postscriptum)

Return ChildOrderProduct objects filtered by the postscriptum column

array
findByQuantity( double $quantity)

Return ChildOrderProduct objects filtered by the quantity column

array
findByPrice( string $price)

Return ChildOrderProduct objects filtered by the price column

array
findByPromoPrice( string $promo_price)

Return ChildOrderProduct objects filtered by the promo_price column

array
findByWasNew( int $was_new)

Return ChildOrderProduct objects filtered by the was_new column

array
findByWasInPromo( int $was_in_promo)

Return ChildOrderProduct objects filtered by the wasinpromo column

array
findByWeight( string $weight)

Return ChildOrderProduct objects filtered by the weight column

array
findByEanCode( string $ean_code)

Return ChildOrderProduct objects filtered by the ean_code column

array
findByTaxRuleTitle( string $tax_rule_title)

Return ChildOrderProduct objects filtered by the taxruletitle column

array
findByTaxRuleDescription( string $tax_rule_description)

Return ChildOrderProduct objects filtered by the taxruledescription column

array
findByParent( int $parent)

Return ChildOrderProduct objects filtered by the parent column

array
findByVirtual( int $virtual)

Return ChildOrderProduct objects filtered by the virtual column

array
findByVirtualDocument( string $virtual_document)

Return ChildOrderProduct objects filtered by the virtual_document column

array
findByCreatedAt( string $created_at)

Return ChildOrderProduct objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildOrderProduct objects filtered by the updated_at column

static 
getSaleStats($productRef, DateTime $startDate = null, DateTime $endDate = null, $orderStatus = array(2, 3, 4), $customerId = null)

No description

Details

in OrderProductQuery at line 150
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\OrderProduct', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\OrderProductQuery 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'

in OrderProductQuery at line 163
static OrderProductQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildOrderProductQuery object.

Parameters

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

Return Value

OrderProductQuery

in OrderProductQuery at line 193
OrderProduct|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

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

in OrderProductQuery at line 275
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

in OrderProductQuery at line 296
OrderProductQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 309
OrderProductQuery 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 333
OrderProductQuery 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 376
OrderProductQuery filterByOrderId( mixed $orderId = null, string $comparison = null)

Filter the query on the order_id column

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

Parameters

mixed $orderId 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

OrderProductQuery The current query, for fluid interface

See also

filterByOrder()

in OrderProductQuery at line 414
OrderProductQuery filterByProductRef( string $productRef = null, string $comparison = null)

Filter the query on the product_ref column

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

Parameters

string $productRef 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 443
OrderProductQuery filterByProductSaleElementsRef( string $productSaleElementsRef = null, string $comparison = null)

Filter the query on the productsaleelements_ref column

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

Parameters

string $productSaleElementsRef 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 475
OrderProductQuery filterByProductSaleElementsId( mixed $productSaleElementsId = null, string $comparison = null)

Filter the query on the productsaleelements_id column

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

Parameters

mixed $productSaleElementsId 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 513
OrderProductQuery filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

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

Parameters

string $title 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 542
OrderProductQuery filterByChapo( string $chapo = null, string $comparison = null)

Filter the query on the chapo column

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

Parameters

string $chapo 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 571
OrderProductQuery filterByDescription( string $description = null, string $comparison = null)

Filter the query on the description column

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

Parameters

string $description 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 600
OrderProductQuery filterByPostscriptum( string $postscriptum = null, string $comparison = null)

Filter the query on the postscriptum column

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

Parameters

string $postscriptum 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 632
OrderProductQuery filterByQuantity( mixed $quantity = null, string $comparison = null)

Filter the query on the quantity column

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

Parameters

mixed $quantity 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 673
OrderProductQuery filterByPrice( mixed $price = null, string $comparison = null)

Filter the query on the price column

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

Parameters

mixed $price 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 714
OrderProductQuery filterByPromoPrice( mixed $promoPrice = null, string $comparison = null)

Filter the query on the promo_price column

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

Parameters

mixed $promoPrice 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 755
OrderProductQuery filterByWasNew( mixed $wasNew = null, string $comparison = null)

Filter the query on the was_new column

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

Parameters

mixed $wasNew 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 796
OrderProductQuery filterByWasInPromo( mixed $wasInPromo = null, string $comparison = null)

Filter the query on the wasinpromo column

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

Parameters

mixed $wasInPromo 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 834
OrderProductQuery filterByWeight( string $weight = null, string $comparison = null)

Filter the query on the weight column

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

Parameters

string $weight 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 863
OrderProductQuery filterByEanCode( string $eanCode = null, string $comparison = null)

Filter the query on the ean_code column

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

Parameters

string $eanCode 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 892
OrderProductQuery filterByTaxRuleTitle( string $taxRuleTitle = null, string $comparison = null)

Filter the query on the taxruletitle column

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

Parameters

string $taxRuleTitle 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 921
OrderProductQuery filterByTaxRuleDescription( string $taxRuleDescription = null, string $comparison = null)

Filter the query on the taxruledescription column

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

Parameters

string $taxRuleDescription 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 953
OrderProductQuery filterByParent( mixed $parent = null, string $comparison = null)

Filter the query on the parent column

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

Parameters

mixed $parent 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 994
OrderProductQuery 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1032
OrderProductQuery filterByVirtualDocument( string $virtualDocument = null, string $comparison = null)

Filter the query on the virtual_document column

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

Parameters

string $virtualDocument 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1066
OrderProductQuery 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1109
OrderProductQuery 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

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1140
OrderProductQuery filterByOrder( Order|ObjectCollection $order, string $comparison = null)

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

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1165
OrderProductQuery joinOrder( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Order relation

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1200
OrderQuery useOrderQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Order relation Order 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

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

See also

useQuery()

in OrderProductQuery at line 1215
OrderProductQuery filterByOrderProductAttributeCombination( OrderProductAttributeCombination|ObjectCollection $orderProductAttributeCombination, string $comparison = null)

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

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1238
OrderProductQuery joinOrderProductAttributeCombination( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the OrderProductAttributeCombination relation

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1273
OrderProductAttributeCombinationQuery useOrderProductAttributeCombinationQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the OrderProductAttributeCombination relation OrderProductAttributeCombination 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

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

See also

useQuery()

in OrderProductQuery at line 1288
OrderProductQuery filterByOrderProductTax( OrderProductTax|ObjectCollection $orderProductTax, string $comparison = null)

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

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1311
OrderProductQuery joinOrderProductTax( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the OrderProductTax relation

Parameters

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

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1346
OrderProductTaxQuery useOrderProductTaxQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the OrderProductTax relation OrderProductTax 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

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

See also

useQuery()

in OrderProductQuery at line 1360
OrderProductQuery prune( OrderProduct $orderProduct = null)

Exclude object from result

Parameters

OrderProduct $orderProduct Object to remove from the list of results

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1375
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the order_product table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

in OrderProductQuery at line 1412
int delete( ConnectionInterface $con = null)

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

in OrderProductQuery at line 1453
OrderProductQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1465
OrderProductQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1475
OrderProductQuery lastUpdatedFirst()

Order by update date desc

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1485
OrderProductQuery firstUpdatedFirst()

Order by update date asc

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1495
OrderProductQuery lastCreatedFirst()

Order by create date desc

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 1505
OrderProductQuery firstCreatedFirst()

Order by create date asc

Return Value

OrderProductQuery The current query, for fluid interface

in OrderProductQuery at line 140
ChildOrderProductQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByOrderId($order = Criteria::ASC)

Order by the order_id column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByProductRef($order = Criteria::ASC)

Order by the product_ref column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByProductSaleElementsRef($order = Criteria::ASC)

Order by the productsaleelements_ref column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByProductSaleElementsId($order = Criteria::ASC)

Order by the productsaleelements_id column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByTitle($order = Criteria::ASC)

Order by the title column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByChapo($order = Criteria::ASC)

Order by the chapo column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByDescription($order = Criteria::ASC)

Order by the description column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByQuantity($order = Criteria::ASC)

Order by the quantity column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByPrice($order = Criteria::ASC)

Order by the price column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByPromoPrice($order = Criteria::ASC)

Order by the promo_price column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByWasNew($order = Criteria::ASC)

Order by the was_new column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByWasInPromo($order = Criteria::ASC)

Order by the wasinpromo column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByWeight($order = Criteria::ASC)

Order by the weight column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByEanCode($order = Criteria::ASC)

Order by the ean_code column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByTaxRuleTitle($order = Criteria::ASC)

Order by the taxruletitle column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByTaxRuleDescription($order = Criteria::ASC)

Order by the taxruledescription column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByParent($order = Criteria::ASC)

Order by the parent column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByVirtual($order = Criteria::ASC)

Order by the virtual column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByVirtualDocument($order = Criteria::ASC)

Order by the virtual_document column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupById()

Group by the id column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByOrderId()

Group by the order_id column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByProductRef()

Group by the product_ref column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByProductSaleElementsRef()

Group by the productsaleelements_ref column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByProductSaleElementsId()

Group by the productsaleelements_id column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByTitle()

Group by the title column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByChapo()

Group by the chapo column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByDescription()

Group by the description column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByPostscriptum()

Group by the postscriptum column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByQuantity()

Group by the quantity column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByPrice()

Group by the price column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByPromoPrice()

Group by the promo_price column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByWasNew()

Group by the was_new column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByWasInPromo()

Group by the wasinpromo column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByWeight()

Group by the weight column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByEanCode()

Group by the ean_code column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByTaxRuleTitle()

Group by the taxruletitle column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByTaxRuleDescription()

Group by the taxruledescription column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByParent()

Group by the parent column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByVirtual()

Group by the virtual column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByVirtualDocument()

Group by the virtual_document column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery leftJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery rightJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery innerJoinOrder($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery leftJoinOrderProductAttributeCombination($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery rightJoinOrderProductAttributeCombination($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery innerJoinOrderProductAttributeCombination($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery leftJoinOrderProductTax($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery rightJoinOrderProductTax($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProductQuery innerJoinOrderProductTax($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderProductQuery

in OrderProductQuery at line 140
ChildOrderProduct findOne( ConnectionInterface $con = null)

Return the first ChildOrderProduct matching the query

Parameters

ConnectionInterface $con

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneById( int $id)

Return the first ChildOrderProduct filtered by the id column

Parameters

int $id

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByOrderId( int $order_id)

Return the first ChildOrderProduct filtered by the order_id column

Parameters

int $order_id

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByProductRef( string $product_ref)

Return the first ChildOrderProduct filtered by the product_ref column

Parameters

string $product_ref

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByProductSaleElementsRef( string $product_sale_elements_ref)

Return the first ChildOrderProduct filtered by the productsaleelements_ref column

Parameters

string $product_sale_elements_ref

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByProductSaleElementsId( int $product_sale_elements_id)

Return the first ChildOrderProduct filtered by the productsaleelements_id column

Parameters

int $product_sale_elements_id

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByTitle( string $title)

Return the first ChildOrderProduct filtered by the title column

Parameters

string $title

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByChapo( string $chapo)

Return the first ChildOrderProduct filtered by the chapo column

Parameters

string $chapo

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByDescription( string $description)

Return the first ChildOrderProduct filtered by the description column

Parameters

string $description

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByPostscriptum( string $postscriptum)

Return the first ChildOrderProduct filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByQuantity( double $quantity)

Return the first ChildOrderProduct filtered by the quantity column

Parameters

double $quantity

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByPrice( string $price)

Return the first ChildOrderProduct filtered by the price column

Parameters

string $price

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByPromoPrice( string $promo_price)

Return the first ChildOrderProduct filtered by the promo_price column

Parameters

string $promo_price

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByWasNew( int $was_new)

Return the first ChildOrderProduct filtered by the was_new column

Parameters

int $was_new

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByWasInPromo( int $was_in_promo)

Return the first ChildOrderProduct filtered by the wasinpromo column

Parameters

int $was_in_promo

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByWeight( string $weight)

Return the first ChildOrderProduct filtered by the weight column

Parameters

string $weight

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByEanCode( string $ean_code)

Return the first ChildOrderProduct filtered by the ean_code column

Parameters

string $ean_code

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByTaxRuleTitle( string $tax_rule_title)

Return the first ChildOrderProduct filtered by the taxruletitle column

Parameters

string $tax_rule_title

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByTaxRuleDescription( string $tax_rule_description)

Return the first ChildOrderProduct filtered by the taxruledescription column

Parameters

string $tax_rule_description

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByParent( int $parent)

Return the first ChildOrderProduct filtered by the parent column

Parameters

int $parent

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByVirtual( int $virtual)

Return the first ChildOrderProduct filtered by the virtual column

Parameters

int $virtual

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByVirtualDocument( string $virtual_document)

Return the first ChildOrderProduct filtered by the virtual_document column

Parameters

string $virtual_document

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByCreatedAt( string $created_at)

Return the first ChildOrderProduct filtered by the created_at column

Parameters

string $created_at

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
ChildOrderProduct findOneByUpdatedAt( string $updated_at)

Return the first ChildOrderProduct filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildOrderProduct

in OrderProductQuery at line 140
array findById( int $id)

Return ChildOrderProduct objects filtered by the id column

Parameters

int $id

Return Value

array

in OrderProductQuery at line 140
array findByOrderId( int $order_id)

Return ChildOrderProduct objects filtered by the order_id column

Parameters

int $order_id

Return Value

array

in OrderProductQuery at line 140
array findByProductRef( string $product_ref)

Return ChildOrderProduct objects filtered by the product_ref column

Parameters

string $product_ref

Return Value

array

in OrderProductQuery at line 140
array findByProductSaleElementsRef( string $product_sale_elements_ref)

Return ChildOrderProduct objects filtered by the productsaleelements_ref column

Parameters

string $product_sale_elements_ref

Return Value

array

in OrderProductQuery at line 140
array findByProductSaleElementsId( int $product_sale_elements_id)

Return ChildOrderProduct objects filtered by the productsaleelements_id column

Parameters

int $product_sale_elements_id

Return Value

array

in OrderProductQuery at line 140
array findByTitle( string $title)

Return ChildOrderProduct objects filtered by the title column

Parameters

string $title

Return Value

array

in OrderProductQuery at line 140
array findByChapo( string $chapo)

Return ChildOrderProduct objects filtered by the chapo column

Parameters

string $chapo

Return Value

array

in OrderProductQuery at line 140
array findByDescription( string $description)

Return ChildOrderProduct objects filtered by the description column

Parameters

string $description

Return Value

array

in OrderProductQuery at line 140
array findByPostscriptum( string $postscriptum)

Return ChildOrderProduct objects filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

array

in OrderProductQuery at line 140
array findByQuantity( double $quantity)

Return ChildOrderProduct objects filtered by the quantity column

Parameters

double $quantity

Return Value

array

in OrderProductQuery at line 140
array findByPrice( string $price)

Return ChildOrderProduct objects filtered by the price column

Parameters

string $price

Return Value

array

in OrderProductQuery at line 140
array findByPromoPrice( string $promo_price)

Return ChildOrderProduct objects filtered by the promo_price column

Parameters

string $promo_price

Return Value

array

in OrderProductQuery at line 140
array findByWasNew( int $was_new)

Return ChildOrderProduct objects filtered by the was_new column

Parameters

int $was_new

Return Value

array

in OrderProductQuery at line 140
array findByWasInPromo( int $was_in_promo)

Return ChildOrderProduct objects filtered by the wasinpromo column

Parameters

int $was_in_promo

Return Value

array

in OrderProductQuery at line 140
array findByWeight( string $weight)

Return ChildOrderProduct objects filtered by the weight column

Parameters

string $weight

Return Value

array

in OrderProductQuery at line 140
array findByEanCode( string $ean_code)

Return ChildOrderProduct objects filtered by the ean_code column

Parameters

string $ean_code

Return Value

array

in OrderProductQuery at line 140
array findByTaxRuleTitle( string $tax_rule_title)

Return ChildOrderProduct objects filtered by the taxruletitle column

Parameters

string $tax_rule_title

Return Value

array

in OrderProductQuery at line 140
array findByTaxRuleDescription( string $tax_rule_description)

Return ChildOrderProduct objects filtered by the taxruledescription column

Parameters

string $tax_rule_description

Return Value

array

in OrderProductQuery at line 140
array findByParent( int $parent)

Return ChildOrderProduct objects filtered by the parent column

Parameters

int $parent

Return Value

array

in OrderProductQuery at line 140
array findByVirtual( int $virtual)

Return ChildOrderProduct objects filtered by the virtual column

Parameters

int $virtual

Return Value

array

in OrderProductQuery at line 140
array findByVirtualDocument( string $virtual_document)

Return ChildOrderProduct objects filtered by the virtual_document column

Parameters

string $virtual_document

Return Value

array

in OrderProductQuery at line 140
array findByCreatedAt( string $created_at)

Return ChildOrderProduct objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

in OrderProductQuery at line 140
array findByUpdatedAt( string $updated_at)

Return ChildOrderProduct objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array

at line 20
static getSaleStats($productRef, DateTime $startDate = null, DateTime $endDate = null, $orderStatus = array(2, 3, 4), $customerId = null)

Parameters

$productRef
DateTime $startDate
DateTime $endDate
$orderStatus
$customerId