OrderCouponQuery

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

Returns a new ChildOrderCouponQuery 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 order_id column

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

Filter the query on the code column

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

Filter the query on the type column

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

Filter the query on the amount column

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

Filter the query on the title column

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

Filter the query on the short_description column

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

Filter the query on the description column

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

Filter the query on the start_date column

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

Filter the query on the expiration_date column

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

Filter the query on the is_cumulative column

Example usage: $query->filterByIsCumulative(true); // WHERE iscumulative = true $query->filterByIsCumulative('yes'); // WHERE iscumulative = true

Filter the query on the isremovingpostage column

Example usage: $query->filterByIsRemovingPostage(true); // WHERE isremovingpostage = true $query->filterByIsRemovingPostage('yes'); // WHERE isremovingpostage = true

Filter the query on the isavailableonspecialoffers column

Example usage: $query->filterByIsAvailableOnSpecialOffers(true); // WHERE isavailableonspecialoffers = true $query->filterByIsAvailableOnSpecialOffers('yes'); // WHERE isavailableonspecialoffers = true

Filter the query on the serialized_conditions column

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

Filter the query on the percustomerusage_count column

Example usage: $query->filterByPerCustomerUsageCount(true); // WHERE percustomerusagecount = true $query->filterByPerCustomerUsageCount('yes'); // WHERE percustomerusagecount = true

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

Adds a JOIN clause to the query using the Order relation

Use the Order relation Order object

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

Adds a JOIN clause to the query using the OrderCouponCountry relation

Use the OrderCouponCountry relation OrderCouponCountry object

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

Adds a JOIN clause to the query using the OrderCouponModule relation

Use the OrderCouponModule relation OrderCouponModule object

Filter the query by a related Country object using the ordercouponcountry table as cross reference

Filter the query by a related Module object using the ordercouponmodule table as cross reference

Exclude object from result

Deletes all rows from the order_coupon table.

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

Order by the code column

Order by the type column

Order by the amount column

Order by the title column

Order by the short_description column

Order by the description column

Order by the start_date column

Order by the expiration_date column

Order by the is_cumulative column

Order by the isremovingpostage column

Order by the isavailableonspecialoffers column

Order by the serialized_conditions column

Order by the percustomerusage_count column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the order_id column

Group by the code column

Group by the type column

Group by the amount column

Group by the title column

Group by the short_description column

Group by the description column

Group by the start_date column

Group by the expiration_date column

Group by the is_cumulative column

Group by the isremovingpostage column

Group by the isavailableonspecialoffers column

Group by the serialized_conditions column

Group by the percustomerusage_count 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 Order relation

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

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

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

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

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

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

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

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

Return the first ChildOrderCoupon matching the query

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

Return the first ChildOrderCoupon filtered by the id column

Return the first ChildOrderCoupon filtered by the order_id column

Return the first ChildOrderCoupon filtered by the code column

Return the first ChildOrderCoupon filtered by the type column

Return the first ChildOrderCoupon filtered by the amount column

Return the first ChildOrderCoupon filtered by the title column

Return the first ChildOrderCoupon filtered by the short_description column

Return the first ChildOrderCoupon filtered by the description column

Return the first ChildOrderCoupon filtered by the start_date column

Return the first ChildOrderCoupon filtered by the expiration_date column

Return the first ChildOrderCoupon filtered by the is_cumulative column

Return the first ChildOrderCoupon filtered by the isremovingpostage column

Return the first ChildOrderCoupon filtered by the isavailableonspecialoffers column

Return the first ChildOrderCoupon filtered by the serialized_conditions column

Return the first ChildOrderCoupon filtered by the percustomerusage_count column

Return the first ChildOrderCoupon filtered by the created_at column

Return the first ChildOrderCoupon filtered by the updated_at column

Return ChildOrderCoupon objects filtered by the id column

Return ChildOrderCoupon objects filtered by the order_id column

Return ChildOrderCoupon objects filtered by the code column

Return ChildOrderCoupon objects filtered by the type column

Return ChildOrderCoupon objects filtered by the amount column

Return ChildOrderCoupon objects filtered by the title column

Return ChildOrderCoupon objects filtered by the short_description column

Return ChildOrderCoupon objects filtered by the description column

Return ChildOrderCoupon objects filtered by the start_date column

Return ChildOrderCoupon objects filtered by the expiration_date column

Return ChildOrderCoupon objects filtered by the is_cumulative column

Return ChildOrderCoupon objects filtered by the isremovingpostage column

Return ChildOrderCoupon objects filtered by the isavailableonspecialoffers column

Return ChildOrderCoupon objects filtered by the serialized_conditions column

Return ChildOrderCoupon objects filtered by the percustomerusage_count column

Return ChildOrderCoupon objects filtered by the created_at column

Return ChildOrderCoupon objects filtered by the updated_at column