CartItemQuery
class CartItemQuery extends ModelCriteria
Base class that represents a query for the 'cart_item' table.
Methods
Initializes internal state of \Thelia\Model\Base\CartItemQuery object.
Returns a new ChildCartItemQuery 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 cart_id column
Filter the query on the product_id column
Filter the query on the quantity column
Filter the query on the productsaleelements_id column
Filter the query on the price column
Filter the query on the promo_price column
Filter the query on the priceendof_life column
Filter the query on the promo column
Filter the query on the created_at column
Filter the query on the updated_at column
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
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
Details
at line 102
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CartItem',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CartItemQuery object.
at line 115
static
CartItemQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCartItemQuery object.
at line 145
CartItem|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 227
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 248
CartItemQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 261
CartItemQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 285
CartItemQuery
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 328
CartItemQuery
filterByCartId(
mixed $cartId = null,
string $comparison = null)
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
at line 371
CartItemQuery
filterByProductId(
mixed $productId = null,
string $comparison = null)
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
at line 412
CartItemQuery
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
at line 455
CartItemQuery
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
at line 496
CartItemQuery
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
at line 537
CartItemQuery
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
at line 580
CartItemQuery
filterByPriceEndOfLife(
mixed $priceEndOfLife = null,
string $comparison = null)
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'
at line 621
CartItemQuery
filterByPromo(
mixed $promo = null,
string $comparison = null)
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
at line 664
CartItemQuery
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 707
CartItemQuery
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 738
CartItemQuery
filterByCart(
Cart|ObjectCollection $cart,
string $comparison = null)
Filter the query by a related \Thelia\Model\Cart object
at line 763
CartItemQuery
joinCart(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Cart relation
at line 798
CartQuery
useCartQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Cart relation Cart object
at line 813
CartItemQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 838
CartItemQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Product relation
at line 873
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
at line 888
CartItemQuery
filterByProductSaleElements(
ProductSaleElements|ObjectCollection $productSaleElements,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductSaleElements object
at line 913
CartItemQuery
joinProductSaleElements(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductSaleElements relation
at line 948
ProductSaleElementsQuery
useProductSaleElementsQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductSaleElements relation ProductSaleElements object
at line 962
CartItemQuery
prune(
CartItem $cartItem = null)
Exclude object from result
at line 977
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the cart_item table.
at line 1014
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCartItem or Criteria object OR a primary key value.
at line 1055
CartItemQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1067
CartItemQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1077
CartItemQuery
lastUpdatedFirst()
Order by update date desc
at line 1087
CartItemQuery
firstUpdatedFirst()
Order by update date asc
at line 1097
CartItemQuery
lastCreatedFirst()
Order by create date desc
at line 1107
CartItemQuery
firstCreatedFirst()
Order by create date asc
at line 92
ChildCartItemQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 92
ChildCartItemQuery
orderByCartId($order = Criteria::ASC)
Order by the cart_id column
at line 92
ChildCartItemQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
at line 92
ChildCartItemQuery
orderByQuantity($order = Criteria::ASC)
Order by the quantity column
at line 92
ChildCartItemQuery
orderByProductSaleElementsId($order = Criteria::ASC)
Order by the productsaleelements_id column
at line 92
ChildCartItemQuery
orderByPrice($order = Criteria::ASC)
Order by the price column
at line 92
ChildCartItemQuery
orderByPromoPrice($order = Criteria::ASC)
Order by the promo_price column
at line 92
ChildCartItemQuery
orderByPriceEndOfLife($order = Criteria::ASC)
Order by the priceendof_life column
at line 92
ChildCartItemQuery
orderByPromo($order = Criteria::ASC)
Order by the promo column
at line 92
ChildCartItemQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 92
ChildCartItemQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 92
ChildCartItemQuery
groupById()
Group by the id column
at line 92
ChildCartItemQuery
groupByCartId()
Group by the cart_id column
at line 92
ChildCartItemQuery
groupByProductId()
Group by the product_id column
at line 92
ChildCartItemQuery
groupByQuantity()
Group by the quantity column
at line 92
ChildCartItemQuery
groupByProductSaleElementsId()
Group by the productsaleelements_id column
at line 92
ChildCartItemQuery
groupByPrice()
Group by the price column
at line 92
ChildCartItemQuery
groupByPromoPrice()
Group by the promo_price column
at line 92
ChildCartItemQuery
groupByPriceEndOfLife()
Group by the priceendof_life column
at line 92
ChildCartItemQuery
groupByPromo()
Group by the promo column
at line 92
ChildCartItemQuery
groupByCreatedAt()
Group by the created_at column
at line 92
ChildCartItemQuery
groupByUpdatedAt()
Group by the updated_at column
at line 92
ChildCartItemQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 92
ChildCartItemQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 92
ChildCartItemQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 92
ChildCartItemQuery
leftJoinCart($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Cart relation
at line 92
ChildCartItemQuery
rightJoinCart($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Cart relation
at line 92
ChildCartItemQuery
innerJoinCart($relationAlias = null)
Adds a INNER JOIN clause to the query using the Cart relation
at line 92
ChildCartItemQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
at line 92
ChildCartItemQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
at line 92
ChildCartItemQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
at line 92
ChildCartItemQuery
leftJoinProductSaleElements($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductSaleElements relation
at line 92
ChildCartItemQuery
rightJoinProductSaleElements($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductSaleElements relation
at line 92
ChildCartItemQuery
innerJoinProductSaleElements($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductSaleElements relation
at line 92
ChildCartItem
findOne(
ConnectionInterface $con = null)
Return the first ChildCartItem matching the query
at line 92
ChildCartItem
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCartItem matching the query, or a new ChildCartItem object populated from the query conditions when no match is found
at line 92
ChildCartItem
findOneById(
int $id)
Return the first ChildCartItem filtered by the id column
at line 92
ChildCartItem
findOneByCartId(
int $cart_id)
Return the first ChildCartItem filtered by the cart_id column
at line 92
ChildCartItem
findOneByProductId(
int $product_id)
Return the first ChildCartItem filtered by the product_id column
at line 92
ChildCartItem
findOneByQuantity(
double $quantity)
Return the first ChildCartItem filtered by the quantity column
at line 92
ChildCartItem
findOneByProductSaleElementsId(
int $product_sale_elements_id)
Return the first ChildCartItem filtered by the productsaleelements_id column
at line 92
ChildCartItem
findOneByPrice(
string $price)
Return the first ChildCartItem filtered by the price column
at line 92
ChildCartItem
findOneByPromoPrice(
string $promo_price)
Return the first ChildCartItem filtered by the promo_price column
at line 92
ChildCartItem
findOneByPriceEndOfLife(
string $price_end_of_life)
Return the first ChildCartItem filtered by the priceendof_life column
at line 92
ChildCartItem
findOneByPromo(
int $promo)
Return the first ChildCartItem filtered by the promo column
at line 92
ChildCartItem
findOneByCreatedAt(
string $created_at)
Return the first ChildCartItem filtered by the created_at column
at line 92
ChildCartItem
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCartItem filtered by the updated_at column
at line 92
array
findById(
int $id)
Return ChildCartItem objects filtered by the id column
at line 92
array
findByCartId(
int $cart_id)
Return ChildCartItem objects filtered by the cart_id column
at line 92
array
findByProductId(
int $product_id)
Return ChildCartItem objects filtered by the product_id column
at line 92
array
findByQuantity(
double $quantity)
Return ChildCartItem objects filtered by the quantity column
at line 92
array
findByProductSaleElementsId(
int $product_sale_elements_id)
Return ChildCartItem objects filtered by the productsaleelements_id column
at line 92
array
findByPrice(
string $price)
Return ChildCartItem objects filtered by the price column
at line 92
array
findByPromoPrice(
string $promo_price)
Return ChildCartItem objects filtered by the promo_price column
at line 92
array
findByPriceEndOfLife(
string $price_end_of_life)
Return ChildCartItem objects filtered by the priceendof_life column
at line 92
array
findByPromo(
int $promo)
Return ChildCartItem objects filtered by the promo column
at line 92
array
findByCreatedAt(
string $created_at)
Return ChildCartItem objects filtered by the created_at column
at line 92
array
findByUpdatedAt(
string $updated_at)
Return ChildCartItem objects filtered by the updated_at column