CartQuery
class CartQuery extends CartQuery
Skeleton subclass for performing query and update operations on the 'cart' 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
Initializes internal state of \Thelia\Model\Base\CartQuery object.
Returns a new ChildCartQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
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.
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 created_at column
Order by the updated_at column
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 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 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
in
CartQuery at line 102
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Cart',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CartQuery object.
in
CartQuery at line 115
static
CartQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCartQuery object.
in
CartQuery 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);
in
CartQuery 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);
in
CartQuery at line 261
CartQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CartQuery 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
in
CartQuery 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%'
in
CartQuery 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
in
CartQuery 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
in
CartQuery 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
in
CartQuery 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
in
CartQuery 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
in
CartQuery 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'
in
CartQuery 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'
in
CartQuery at line 644
CartQuery
filterByCustomer(
Customer|ObjectCollection $customer,
string $comparison = null)
Filter the query by a related \Thelia\Model\Customer object
in
CartQuery at line 669
CartQuery
joinCustomer(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Customer relation
in
CartQuery at line 704
CustomerQuery
useCustomerQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Customer relation Customer object
in
CartQuery at line 719
CartQuery
filterByAddressRelatedByAddressDeliveryId(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
in
CartQuery at line 744
CartQuery
joinAddressRelatedByAddressDeliveryId(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
in
CartQuery at line 779
AddressQuery
useAddressRelatedByAddressDeliveryIdQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the AddressRelatedByAddressDeliveryId relation Address object
in
CartQuery at line 794
CartQuery
filterByAddressRelatedByAddressInvoiceId(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
in
CartQuery at line 819
CartQuery
joinAddressRelatedByAddressInvoiceId(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
in
CartQuery at line 854
AddressQuery
useAddressRelatedByAddressInvoiceIdQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the AddressRelatedByAddressInvoiceId relation Address object
in
CartQuery at line 869
CartQuery
filterByCurrency(
Currency|ObjectCollection $currency,
string $comparison = null)
Filter the query by a related \Thelia\Model\Currency object
in
CartQuery at line 894
CartQuery
joinCurrency(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Currency relation
in
CartQuery at line 929
CurrencyQuery
useCurrencyQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Currency relation Currency object
in
CartQuery at line 944
CartQuery
filterByCartItem(
CartItem|ObjectCollection $cartItem,
string $comparison = null)
Filter the query by a related \Thelia\Model\CartItem object
in
CartQuery at line 967
CartQuery
joinCartItem(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CartItem relation
in
CartQuery at line 1002
CartItemQuery
useCartItemQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CartItem relation CartItem object
in
CartQuery at line 1031
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the cart table.
in
CartQuery 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.
in
CartQuery at line 92
ChildCartQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CartQuery at line 92
ChildCartQuery
orderByToken($order = Criteria::ASC)
Order by the token column
in
CartQuery at line 92
ChildCartQuery
orderByCustomerId($order = Criteria::ASC)
Order by the customer_id column
in
CartQuery at line 92
ChildCartQuery
orderByAddressDeliveryId($order = Criteria::ASC)
Order by the addressdeliveryid column
in
CartQuery at line 92
ChildCartQuery
orderByAddressInvoiceId($order = Criteria::ASC)
Order by the addressinvoiceid column
in
CartQuery at line 92
ChildCartQuery
orderByCurrencyId($order = Criteria::ASC)
Order by the currency_id column
in
CartQuery at line 92
ChildCartQuery
orderByDiscount($order = Criteria::ASC)
Order by the discount column
in
CartQuery at line 92
ChildCartQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CartQuery at line 92
ChildCartQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CartQuery at line 92
ChildCartQuery
groupById()
Group by the id column
in
CartQuery at line 92
ChildCartQuery
groupByToken()
Group by the token column
in
CartQuery at line 92
ChildCartQuery
groupByCustomerId()
Group by the customer_id column
in
CartQuery at line 92
ChildCartQuery
groupByAddressDeliveryId()
Group by the addressdeliveryid column
in
CartQuery at line 92
ChildCartQuery
groupByAddressInvoiceId()
Group by the addressinvoiceid column
in
CartQuery at line 92
ChildCartQuery
groupByCurrencyId()
Group by the currency_id column
in
CartQuery at line 92
ChildCartQuery
groupByDiscount()
Group by the discount column
in
CartQuery at line 92
ChildCartQuery
groupByCreatedAt()
Group by the created_at column
in
CartQuery at line 92
ChildCartQuery
groupByUpdatedAt()
Group by the updated_at column
in
CartQuery at line 92
ChildCartQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CartQuery at line 92
ChildCartQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CartQuery at line 92
ChildCartQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CartQuery at line 92
ChildCartQuery
leftJoinCustomer($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Customer relation
in
CartQuery at line 92
ChildCartQuery
rightJoinCustomer($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Customer relation
in
CartQuery at line 92
ChildCartQuery
innerJoinCustomer($relationAlias = null)
Adds a INNER JOIN clause to the query using the Customer relation
in
CartQuery at line 92
ChildCartQuery
leftJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
in
CartQuery at line 92
ChildCartQuery
rightJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
in
CartQuery at line 92
ChildCartQuery
innerJoinAddressRelatedByAddressDeliveryId($relationAlias = null)
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressDeliveryId relation
in
CartQuery at line 92
ChildCartQuery
leftJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
in
CartQuery at line 92
ChildCartQuery
rightJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
in
CartQuery at line 92
ChildCartQuery
innerJoinAddressRelatedByAddressInvoiceId($relationAlias = null)
Adds a INNER JOIN clause to the query using the AddressRelatedByAddressInvoiceId relation
in
CartQuery at line 92
ChildCartQuery
leftJoinCurrency($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Currency relation
in
CartQuery at line 92
ChildCartQuery
rightJoinCurrency($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Currency relation
in
CartQuery at line 92
ChildCartQuery
innerJoinCurrency($relationAlias = null)
Adds a INNER JOIN clause to the query using the Currency relation
in
CartQuery at line 92
ChildCartQuery
leftJoinCartItem($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CartItem relation
in
CartQuery at line 92
ChildCartQuery
rightJoinCartItem($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CartItem relation
in
CartQuery at line 92
ChildCartQuery
innerJoinCartItem($relationAlias = null)
Adds a INNER JOIN clause to the query using the CartItem relation
in
CartQuery at line 92
ChildCart
findOne(
ConnectionInterface $con = null)
Return the first ChildCart matching the query
in
CartQuery 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
in
CartQuery at line 92
ChildCart
findOneById(
int $id)
Return the first ChildCart filtered by the id column
in
CartQuery at line 92
ChildCart
findOneByToken(
string $token)
Return the first ChildCart filtered by the token column
in
CartQuery at line 92
ChildCart
findOneByCustomerId(
int $customer_id)
Return the first ChildCart filtered by the customer_id column
in
CartQuery at line 92
ChildCart
findOneByAddressDeliveryId(
int $address_delivery_id)
Return the first ChildCart filtered by the addressdeliveryid column
in
CartQuery at line 92
ChildCart
findOneByAddressInvoiceId(
int $address_invoice_id)
Return the first ChildCart filtered by the addressinvoiceid column
in
CartQuery at line 92
ChildCart
findOneByCurrencyId(
int $currency_id)
Return the first ChildCart filtered by the currency_id column
in
CartQuery at line 92
ChildCart
findOneByDiscount(
string $discount)
Return the first ChildCart filtered by the discount column
in
CartQuery at line 92
ChildCart
findOneByCreatedAt(
string $created_at)
Return the first ChildCart filtered by the created_at column
in
CartQuery at line 92
ChildCart
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCart filtered by the updated_at column
in
CartQuery at line 92
array
findById(
int $id)
Return ChildCart objects filtered by the id column
in
CartQuery at line 92
array
findByToken(
string $token)
Return ChildCart objects filtered by the token column
in
CartQuery at line 92
array
findByCustomerId(
int $customer_id)
Return ChildCart objects filtered by the customer_id column
in
CartQuery at line 92
array
findByAddressDeliveryId(
int $address_delivery_id)
Return ChildCart objects filtered by the addressdeliveryid column
in
CartQuery at line 92
array
findByAddressInvoiceId(
int $address_invoice_id)
Return ChildCart objects filtered by the addressinvoiceid column
in
CartQuery at line 92
array
findByCurrencyId(
int $currency_id)
Return ChildCart objects filtered by the currency_id column
in
CartQuery at line 92
array
findByDiscount(
string $discount)
Return ChildCart objects filtered by the discount column
in
CartQuery at line 92
array
findByCreatedAt(
string $created_at)
Return ChildCart objects filtered by the created_at column
in
CartQuery at line 92
array
findByUpdatedAt(
string $updated_at)
Return ChildCart objects filtered by the updated_at column