CartItemQuery

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

Returns a new ChildCartItemQuery object.

Find object by primary key.

Propel uses the instance pool to skip the database if the object exists. Go fast if the query is untouched.

$obj = $c->findPk(12, $con);

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

Filter the query by primary key

Filter the query by a list of primary keys

Filter the query on the id column

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

Filter the query on the cart_id column

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

Filter the query on the product_id column

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

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

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

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

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

Filter the query on the priceendof_life column

Example usage: $query->filterByPriceEndOfLife('2011-03-14'); // WHERE priceendoflife = '2011-03-14' $query->filterByPriceEndOfLife('now'); // WHERE priceendoflife = '2011-03-14' $query->filterByPriceEndOfLife(array('max' => 'yesterday')); // WHERE priceendof_life > '2011-03-13'

Filter the query on the promo column

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

Filter the query on the created_at column

Example usage: $query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'

Filter the query on the updated_at column

Example usage: $query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'

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

Adds a JOIN clause to the query using the Cart relation

Use the Cart relation Cart object

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

Adds a JOIN clause to the query using the Product relation

Use the Product relation Product object

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

Adds a JOIN clause to the query using the ProductSaleElements relation

Use the ProductSaleElements relation ProductSaleElements object

Exclude object from result

Deletes all rows from the cart_item table.

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

Filter by the latest updated

Filter by the latest created

Order by update date desc

Order by update date asc

Order by create date desc

Order by create date asc

Order by the id column

Order by the cart_id column

Order by the product_id column

Order by the quantity column

Order by the productsaleelements_id column

Order by the price column

Order by the promo_price column

Order by the priceendof_life column

Order by the promo column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the cart_id column

Group by the product_id column

Group by the quantity column

Group by the productsaleelements_id column

Group by the price column

Group by the promo_price column

Group by the priceendof_life column

Group by the promo column

Group by the created_at column

Group by the updated_at column

Adds a LEFT JOIN clause to the query

Adds a RIGHT JOIN clause to the query

Adds a INNER JOIN clause to the query

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

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

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

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

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

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

Adds a LEFT JOIN clause to the query using the 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

Return the first ChildCartItem matching the query

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

Return the first ChildCartItem filtered by the id column

Return the first ChildCartItem filtered by the cart_id column

Return the first ChildCartItem filtered by the product_id column

Return the first ChildCartItem filtered by the quantity column

Return the first ChildCartItem filtered by the productsaleelements_id column

Return the first ChildCartItem filtered by the price column

Return the first ChildCartItem filtered by the promo_price column

Return the first ChildCartItem filtered by the priceendof_life column

Return the first ChildCartItem filtered by the promo column

Return the first ChildCartItem filtered by the created_at column

Return the first ChildCartItem filtered by the updated_at column

Return ChildCartItem objects filtered by the id column

Return ChildCartItem objects filtered by the cart_id column

Return ChildCartItem objects filtered by the product_id column

Return ChildCartItem objects filtered by the quantity column

Return ChildCartItem objects filtered by the productsaleelements_id column

Return ChildCartItem objects filtered by the price column

Return ChildCartItem objects filtered by the promo_price column

Return ChildCartItem objects filtered by the priceendof_life column

Return ChildCartItem objects filtered by the promo column

Return ChildCartItem objects filtered by the created_at column

Return ChildCartItem objects filtered by the updated_at column