CartQuery
class CartQuery extends ModelCriteria
Base class that represents a query for the 'cart' table.
Methods
Initializes internal state of \Thelia\Model\Base\CartQuery object.
Returns a new ChildCartQuery object.
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 token column
Filter the query on the customer_id column
Filter the query on the addressdeliveryid column
Filter the query on the addressinvoiceid column
Filter the query on the currency_id column
Filter the query on the discount 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\Customer object
Adds a JOIN clause to the query using the Customer relation
Use the Customer relation Customer object
Filter the query by a related \Thelia\Model\Address object
Adds a JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
Use the AddressRelatedByAddressDeliveryId relation Address object
Filter the query by a related \Thelia\Model\Address object
Adds a JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
Use the AddressRelatedByAddressInvoiceId relation Address object
Filter the query by a related \Thelia\Model\Currency object
Adds a JOIN clause to the query using the Currency relation
Use the Currency relation Currency 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
Deletes all rows from the cart table.
Performs a DELETE on the database, given a ChildCart 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 token column
Order by the customer_id column
Order by the addressdeliveryid column
Order by the addressinvoiceid column
Order by the currency_id column
Order by the discount column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the token column
Group by the customer_id column
Group by the addressdeliveryid column
Group by the addressinvoiceid column
Group by the currency_id column
Group by the discount 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 Customer relation
Adds a RIGHT JOIN clause to the query using the Customer relation
Adds a INNER JOIN clause to the query using the Customer relation
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
Adds a LEFT JOIN clause to the query using the Currency relation
Adds a RIGHT JOIN clause to the query using the Currency relation
Adds a INNER JOIN clause to the query using the Currency 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
Return the first ChildCart matching the query
Return the first ChildCart matching the query, or a new ChildCart object populated from the query conditions when no match is found
Return the first ChildCart filtered by the id column
Return the first ChildCart filtered by the token column
Return the first ChildCart filtered by the customer_id column
Return the first ChildCart filtered by the addressdeliveryid column
Return the first ChildCart filtered by the addressinvoiceid column
Return the first ChildCart filtered by the currency_id column
Return the first ChildCart filtered by the discount column
Return the first ChildCart filtered by the created_at column
Return the first ChildCart filtered by the updated_at column
Return ChildCart objects filtered by the id column
Return ChildCart objects filtered by the token column
Return ChildCart objects filtered by the customer_id column
Return ChildCart objects filtered by the addressdeliveryid column
Return ChildCart objects filtered by the addressinvoiceid column
Return ChildCart objects filtered by the currency_id column
Return ChildCart objects filtered by the discount column
Return ChildCart objects filtered by the created_at column
Return ChildCart objects filtered by the updated_at column
Details
at line 102
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Cart',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CartQuery object.
at line 115
static
CartQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCartQuery object.
at line 145
Cart|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
CartQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 261
CartQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 285
CartQuery
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 323
CartQuery
filterByToken(
string $token = null,
string $comparison = null)
Filter the query on the token column
Example usage:
$query->filterByToken('fooValue'); // WHERE token = 'fooValue'
$query->filterByToken('%fooValue%'); // WHERE token LIKE '%fooValue%'
at line 357
CartQuery
filterByCustomerId(
mixed $customerId = null,
string $comparison = null)
Filter the query on the customer_id column
Example usage:
$query->filterByCustomerId(1234); // WHERE customerid = 1234
$query->filterByCustomerId(array(12, 34)); // WHERE customerid IN (12, 34)
$query->filterByCustomerId(array('min' => 12)); // WHERE customer_id > 12
at line 400
CartQuery
filterByAddressDeliveryId(
mixed $addressDeliveryId = null,
string $comparison = null)
Filter the query on the addressdeliveryid column
Example usage:
$query->filterByAddressDeliveryId(1234); // WHERE addressdeliveryid = 1234
$query->filterByAddressDeliveryId(array(12, 34)); // WHERE addressdeliveryid IN (12, 34)
$query->filterByAddressDeliveryId(array('min' => 12)); // WHERE addressdeliveryid > 12
at line 443
CartQuery
filterByAddressInvoiceId(
mixed $addressInvoiceId = null,
string $comparison = null)
Filter the query on the addressinvoiceid column
Example usage:
$query->filterByAddressInvoiceId(1234); // WHERE addressinvoiceid = 1234
$query->filterByAddressInvoiceId(array(12, 34)); // WHERE addressinvoiceid IN (12, 34)
$query->filterByAddressInvoiceId(array('min' => 12)); // WHERE addressinvoiceid > 12
at line 486
CartQuery
filterByCurrencyId(
mixed $currencyId = null,
string $comparison = null)
Filter the query on the currency_id column
Example usage:
$query->filterByCurrencyId(1234); // WHERE currencyid = 1234
$query->filterByCurrencyId(array(12, 34)); // WHERE currencyid IN (12, 34)
$query->filterByCurrencyId(array('min' => 12)); // WHERE currency_id > 12
at line 527
CartQuery
filterByDiscount(
mixed $discount = null,
string $comparison = null)
Filter the query on the discount column
Example usage:
$query->filterByDiscount(1234); // WHERE discount = 1234
$query->filterByDiscount(array(12, 34)); // WHERE discount IN (12, 34)
$query->filterByDiscount(array('min' => 12)); // WHERE discount > 12
at line 570
CartQuery
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 613
CartQuery
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 644
CartQuery
filterByCustomer(
Customer|ObjectCollection $customer,
string $comparison = null)
Filter the query by a related \Thelia\Model\Customer object
at line 669
CartQuery
joinCustomer(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Customer relation
at line 704
CustomerQuery
useCustomerQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Customer relation Customer object
at line 719
CartQuery
filterByAddressRelatedByAddressDeliveryId(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
at line 744
CartQuery
joinAddressRelatedByAddressDeliveryId(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
at line 779
AddressQuery
useAddressRelatedByAddressDeliveryIdQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the AddressRelatedByAddressDeliveryId relation Address object
at line 794
CartQuery
filterByAddressRelatedByAddressInvoiceId(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
at line 819
CartQuery
joinAddressRelatedByAddressInvoiceId(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
at line 854
AddressQuery
useAddressRelatedByAddressInvoiceIdQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the AddressRelatedByAddressInvoiceId relation Address object
at line 869
CartQuery
filterByCurrency(
Currency|ObjectCollection $currency,
string $comparison = null)
Filter the query by a related \Thelia\Model\Currency object
at line 894
CartQuery
joinCurrency(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Currency relation
at line 929
CurrencyQuery
useCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Currency relation Currency object
at line 944
CartQuery
filterByCartItem(
CartItem|ObjectCollection $cartItem,
string $comparison = null)
Filter the query by a related \Thelia\Model\CartItem object
at line 967
CartQuery
joinCartItem(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CartItem relation
at line 1002
CartItemQuery
useCartItemQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CartItem relation CartItem object
at line 1031
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the cart table.
at line 1068
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCart or Criteria object OR a primary key value.
at line 1109
CartQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1121
CartQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1131
CartQuery
lastUpdatedFirst()
Order by update date desc
at line 1141
CartQuery
firstUpdatedFirst()
Order by update date asc
at line 1151
CartQuery
lastCreatedFirst()
Order by create date desc
at line 1161
CartQuery
firstCreatedFirst()
Order by create date asc
at line 92
ChildCartQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 92
ChildCartQuery
orderByToken($order = Criteria::ASC)
Order by the token column
at line 92
ChildCartQuery
orderByCustomerId($order = Criteria::ASC)
Order by the customer_id column
at line 92
ChildCartQuery
orderByAddressDeliveryId($order = Criteria::ASC)
Order by the addressdeliveryid column
at line 92
ChildCartQuery
orderByAddressInvoiceId($order = Criteria::ASC)
Order by the addressinvoiceid column
at line 92
ChildCartQuery
orderByCurrencyId($order = Criteria::ASC)
Order by the currency_id column
at line 92
ChildCartQuery
orderByDiscount($order = Criteria::ASC)
Order by the discount column
at line 92
ChildCartQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 92
ChildCartQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 92
ChildCartQuery
groupById()
Group by the id column
at line 92
ChildCartQuery
groupByToken()
Group by the token column
at line 92
ChildCartQuery
groupByCustomerId()
Group by the customer_id column
at line 92
ChildCartQuery
groupByAddressDeliveryId()
Group by the addressdeliveryid column
at line 92
ChildCartQuery
groupByAddressInvoiceId()
Group by the addressinvoiceid column
at line 92
ChildCartQuery
groupByCurrencyId()
Group by the currency_id column
at line 92
ChildCartQuery
groupByDiscount()
Group by the discount column
at line 92
ChildCartQuery
groupByCreatedAt()
Group by the created_at column
at line 92
ChildCartQuery
groupByUpdatedAt()
Group by the updated_at column
at line 92
ChildCartQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 92
ChildCartQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 92
ChildCartQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 92
ChildCartQuery
leftJoinCustomer($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Customer relation
at line 92
ChildCartQuery
rightJoinCustomer($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Customer relation
at line 92
ChildCartQuery
innerJoinCustomer($relationAlias = null)
Adds a INNER JOIN clause to the query using the Customer relation
at line 92
ChildCartQuery
leftJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
at line 92
ChildCartQuery
rightJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
at line 92
ChildCartQuery
innerJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
at line 92
ChildCartQuery
leftJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
at line 92
ChildCartQuery
rightJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
at line 92
ChildCartQuery
innerJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
at line 92
ChildCartQuery
leftJoinCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Currency relation
at line 92
ChildCartQuery
rightJoinCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Currency relation
at line 92
ChildCartQuery
innerJoinCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the Currency relation
at line 92
ChildCartQuery
leftJoinCartItem($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CartItem relation
at line 92
ChildCartQuery
rightJoinCartItem($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CartItem relation
at line 92
ChildCartQuery
innerJoinCartItem($relationAlias = null)
Adds a INNER JOIN clause to the query using the CartItem relation
at line 92
ChildCart
findOne(
ConnectionInterface $con = null)
Return the first ChildCart matching the query
at line 92
ChildCart
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCart matching the query, or a new ChildCart object populated from the query conditions when no match is found
at line 92
ChildCart
findOneById(
int $id)
Return the first ChildCart filtered by the id column
at line 92
ChildCart
findOneByToken(
string $token)
Return the first ChildCart filtered by the token column
at line 92
ChildCart
findOneByCustomerId(
int $customer_id)
Return the first ChildCart filtered by the customer_id column
at line 92
ChildCart
findOneByAddressDeliveryId(
int $address_delivery_id)
Return the first ChildCart filtered by the addressdeliveryid column
at line 92
ChildCart
findOneByAddressInvoiceId(
int $address_invoice_id)
Return the first ChildCart filtered by the addressinvoiceid column
at line 92
ChildCart
findOneByCurrencyId(
int $currency_id)
Return the first ChildCart filtered by the currency_id column
at line 92
ChildCart
findOneByDiscount(
string $discount)
Return the first ChildCart filtered by the discount column
at line 92
ChildCart
findOneByCreatedAt(
string $created_at)
Return the first ChildCart filtered by the created_at column
at line 92
ChildCart
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCart filtered by the updated_at column
at line 92
array
findById(
int $id)
Return ChildCart objects filtered by the id column
at line 92
array
findByToken(
string $token)
Return ChildCart objects filtered by the token column
at line 92
array
findByCustomerId(
int $customer_id)
Return ChildCart objects filtered by the customer_id column
at line 92
array
findByAddressDeliveryId(
int $address_delivery_id)
Return ChildCart objects filtered by the addressdeliveryid column
at line 92
array
findByAddressInvoiceId(
int $address_invoice_id)
Return ChildCart objects filtered by the addressinvoiceid column
at line 92
array
findByCurrencyId(
int $currency_id)
Return ChildCart objects filtered by the currency_id column
at line 92
array
findByDiscount(
string $discount)
Return ChildCart objects filtered by the discount column
at line 92
array
findByCreatedAt(
string $created_at)
Return ChildCart objects filtered by the created_at column
at line 92
array
findByUpdatedAt(
string $updated_at)
Return ChildCart objects filtered by the updated_at column