OrderQuery

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

Returns a new ChildOrderQuery 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 ref column

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

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

Filter the query on the invoiceorderaddress_id column

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

Filter the query on the deliveryorderaddress_id column

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

Filter the query on the invoice_date column

Example usage: $query->filterByInvoiceDate('2011-03-14'); // WHERE invoicedate = '2011-03-14' $query->filterByInvoiceDate('now'); // WHERE invoicedate = '2011-03-14' $query->filterByInvoiceDate(array('max' => 'yesterday')); // WHERE invoice_date > '2011-03-13'

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

Filter the query on the currency_rate column

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

Filter the query on the transaction_ref column

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

Filter the query on the delivery_ref column

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

Filter the query on the invoice_ref column

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

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

Filter the query on the postage column

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

Filter the query on the postage_tax column

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

Filter the query on the postagetaxrule_title column

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

Filter the query on the paymentmoduleid column

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

Filter the query on the deliverymoduleid column

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

Filter the query on the status_id column

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

Filter the query on the lang_id column

Example usage: $query->filterByLangId(1234); // WHERE langid = 1234 $query->filterByLangId(array(12, 34)); // WHERE langid IN (12, 34) $query->filterByLangId(array('min' => 12)); // WHERE lang_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 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 on the version column

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

Filter the query on the versioncreatedat column

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

Filter the query on the versioncreatedby column

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

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\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\OrderAddress object

Adds a JOIN clause to the query using the OrderAddressRelatedByInvoiceOrderAddressId relation

Use the OrderAddressRelatedByInvoiceOrderAddressId relation OrderAddress object

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

Adds a JOIN clause to the query using the OrderAddressRelatedByDeliveryOrderAddressId relation

Use the OrderAddressRelatedByDeliveryOrderAddressId relation OrderAddress object

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

Adds a JOIN clause to the query using the OrderStatus relation

Use the OrderStatus relation OrderStatus object

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

Adds a JOIN clause to the query using the ModuleRelatedByPaymentModuleId relation

Use the ModuleRelatedByPaymentModuleId relation Module object

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

Adds a JOIN clause to the query using the ModuleRelatedByDeliveryModuleId relation

Use the ModuleRelatedByDeliveryModuleId relation Module object

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

Adds a JOIN clause to the query using the Lang relation

Use the Lang relation Lang object

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

Adds a JOIN clause to the query using the OrderProduct relation

Use the OrderProduct relation OrderProduct object

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

Adds a JOIN clause to the query using the OrderCoupon relation

Use the OrderCoupon relation OrderCoupon object

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

Adds a JOIN clause to the query using the OrderVersion relation

Use the OrderVersion relation OrderVersion object

Exclude object from result

Deletes all rows from the order table.

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

Checks whether versioning is enabled

Enables versioning

Disables versioning

Order by the id column

Order by the ref column

Order by the customer_id column

Order by the invoiceorderaddress_id column

Order by the deliveryorderaddress_id column

Order by the invoice_date column

Order by the currency_id column

Order by the currency_rate column

Order by the transaction_ref column

Order by the delivery_ref column

Order by the invoice_ref column

Order by the discount column

Order by the postage column

Order by the postage_tax column

Order by the postagetaxrule_title column

Order by the paymentmoduleid column

Order by the deliverymoduleid column

Order by the status_id column

Order by the lang_id column

Order by the cart_id column

Order by the created_at column

Order by the updated_at column

Order by the version column

Order by the versioncreatedat column

Order by the versioncreatedby column

Group by the id column

Group by the ref column

Group by the customer_id column

Group by the invoiceorderaddress_id column

Group by the deliveryorderaddress_id column

Group by the invoice_date column

Group by the currency_id column

Group by the currency_rate column

Group by the transaction_ref column

Group by the delivery_ref column

Group by the invoice_ref column

Group by the discount column

Group by the postage column

Group by the postage_tax column

Group by the postagetaxrule_title column

Group by the paymentmoduleid column

Group by the deliverymoduleid column

Group by the status_id column

Group by the lang_id column

Group by the cart_id column

Group by the created_at column

Group by the updated_at column

Group by the version column

Group by the versioncreatedat column

Group by the versioncreatedby 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 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 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 OrderAddressRelatedByInvoiceOrderAddressId relation

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Return the first ChildOrder matching the query

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

Return the first ChildOrder filtered by the id column

Return the first ChildOrder filtered by the ref column

Return the first ChildOrder filtered by the customer_id column

Return the first ChildOrder filtered by the invoiceorderaddress_id column

Return the first ChildOrder filtered by the deliveryorderaddress_id column

Return the first ChildOrder filtered by the invoice_date column

Return the first ChildOrder filtered by the currency_id column

Return the first ChildOrder filtered by the currency_rate column

Return the first ChildOrder filtered by the transaction_ref column

Return the first ChildOrder filtered by the delivery_ref column

Return the first ChildOrder filtered by the invoice_ref column

Return the first ChildOrder filtered by the discount column

Return the first ChildOrder filtered by the postage column

Return the first ChildOrder filtered by the postage_tax column

Return the first ChildOrder filtered by the postagetaxrule_title column

Return the first ChildOrder filtered by the paymentmoduleid column

Return the first ChildOrder filtered by the deliverymoduleid column

Return the first ChildOrder filtered by the status_id column

Return the first ChildOrder filtered by the lang_id column

Return the first ChildOrder filtered by the cart_id column

Return the first ChildOrder filtered by the created_at column

Return the first ChildOrder filtered by the updated_at column

Return the first ChildOrder filtered by the version column

Return the first ChildOrder filtered by the versioncreatedat column

Return the first ChildOrder filtered by the versioncreatedby column

Return ChildOrder objects filtered by the id column

Return ChildOrder objects filtered by the ref column

Return ChildOrder objects filtered by the customer_id column

Return ChildOrder objects filtered by the invoiceorderaddress_id column

Return ChildOrder objects filtered by the deliveryorderaddress_id column

Return ChildOrder objects filtered by the invoice_date column

Return ChildOrder objects filtered by the currency_id column

Return ChildOrder objects filtered by the currency_rate column