CouponQuery

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

Returns a new ChildCouponQuery 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 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 serialized_effects column

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

Filter the query on the is_enabled column

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

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 max_usage column

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

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 is_used column

Example usage: $query->filterByIsUsed(true); // WHERE isused = true $query->filterByIsUsed('yes'); // WHERE isused = 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 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\CouponCountry object

Adds a JOIN clause to the query using the CouponCountry relation

Use the CouponCountry relation CouponCountry object

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

Adds a JOIN clause to the query using the CouponModule relation

Use the CouponModule relation CouponModule object

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

Adds a JOIN clause to the query using the CouponCustomerCount relation

Use the CouponCustomerCount relation CouponCustomerCount object

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

Adds a JOIN clause to the query using the CouponI18n relation

Use the CouponI18n relation CouponI18n object

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

Adds a JOIN clause to the query using the CouponVersion relation

Use the CouponVersion relation CouponVersion object

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

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

Filter the query by a related Customer object using the couponcustomercount table as cross reference

Exclude object from result

Deletes all rows from the coupon table.

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

Adds a JOIN clause to the query using the i18n relation

Adds a JOIN clause to the query and hydrates the related I18n object.

Shortcut for $c->joinI18n($locale)->with()

Use the I18n relation query object

Checks whether versioning is enabled

Enables versioning

Disables versioning

Order by the id column

Order by the code column

Order by the type column

Order by the serialized_effects column

Order by the is_enabled column

Order by the start_date column

Order by the expiration_date column

Order by the max_usage column

Order by the is_cumulative column

Order by the isremovingpostage column

Order by the isavailableonspecialoffers column

Order by the is_used 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

Order by the version column

Order by the versioncreatedat column

Order by the versioncreatedby column

Group by the id column

Group by the code column

Group by the type column

Group by the serialized_effects column

Group by the is_enabled column

Group by the start_date column

Group by the expiration_date column

Group by the max_usage column

Group by the is_cumulative column

Group by the isremovingpostage column

Group by the isavailableonspecialoffers column

Group by the is_used 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

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 CouponCountry relation

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Return the first ChildCoupon matching the query

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

Return the first ChildCoupon filtered by the id column

Return the first ChildCoupon filtered by the code column

Return the first ChildCoupon filtered by the type column

Return the first ChildCoupon filtered by the serialized_effects column

Return the first ChildCoupon filtered by the is_enabled column

Return the first ChildCoupon filtered by the start_date column

Return the first ChildCoupon filtered by the expiration_date column

Return the first ChildCoupon filtered by the max_usage column

Return the first ChildCoupon filtered by the is_cumulative column

Return the first ChildCoupon filtered by the isremovingpostage column

Return the first ChildCoupon filtered by the isavailableonspecialoffers column

Return the first ChildCoupon filtered by the is_used column

Return the first ChildCoupon filtered by the serialized_conditions column

Return the first ChildCoupon filtered by the percustomerusage_count column

Return the first ChildCoupon filtered by the created_at column

Return the first ChildCoupon filtered by the updated_at column

Return the first ChildCoupon filtered by the version column

Return the first ChildCoupon filtered by the versioncreatedat column

Return the first ChildCoupon filtered by the versioncreatedby column

Return ChildCoupon objects filtered by the id column

Return ChildCoupon objects filtered by the code column

Return ChildCoupon objects filtered by the type column

Return ChildCoupon objects filtered by the serialized_effects column

Return ChildCoupon objects filtered by the is_enabled column

Return ChildCoupon objects filtered by the start_date column

Return ChildCoupon objects filtered by the expiration_date column

Return ChildCoupon objects filtered by the max_usage column

Return ChildCoupon objects filtered by the is_cumulative column

Return ChildCoupon objects filtered by the isremovingpostage column

Return ChildCoupon objects filtered by the isavailableonspecialoffers column

Return ChildCoupon objects filtered by the is_used column

Return ChildCoupon objects filtered by the serialized_conditions column

Return ChildCoupon objects filtered by the percustomerusage_count column

Return ChildCoupon objects filtered by the created_at column

Return ChildCoupon objects filtered by the updated_at column

Return ChildCoupon objects filtered by the version column

Return ChildCoupon objects filtered by the versioncreatedat column

Return ChildCoupon objects filtered by the versioncreatedby column