CouponVersionQuery

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

Returns a new ChildCouponVersionQuery 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(array(12, 34), $con);

Find objects by primary key $objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $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\Coupon object

Adds a JOIN clause to the query using the Coupon relation

Use the Coupon relation Coupon object

Exclude object from result

Deletes all rows from the coupon_version table.

Performs a DELETE on the database, given a ChildCouponVersion or Criteria object OR a primary key value.

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

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

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

Return the first ChildCouponVersion matching the query

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

Return the first ChildCouponVersion filtered by the id column

Return the first ChildCouponVersion filtered by the code column

Return the first ChildCouponVersion filtered by the type column

Return the first ChildCouponVersion filtered by the serialized_effects column

Return the first ChildCouponVersion filtered by the is_enabled column

Return the first ChildCouponVersion filtered by the start_date column

Return the first ChildCouponVersion filtered by the expiration_date column

Return the first ChildCouponVersion filtered by the max_usage column

Return the first ChildCouponVersion filtered by the is_cumulative column

Return the first ChildCouponVersion filtered by the isremovingpostage column

Return the first ChildCouponVersion filtered by the isavailableonspecialoffers column

Return the first ChildCouponVersion filtered by the is_used column

Return the first ChildCouponVersion filtered by the serialized_conditions column

Return the first ChildCouponVersion filtered by the percustomerusage_count column

Return the first ChildCouponVersion filtered by the created_at column

Return the first ChildCouponVersion filtered by the updated_at column

Return the first ChildCouponVersion filtered by the version column

Return the first ChildCouponVersion filtered by the versioncreatedat column

Return the first ChildCouponVersion filtered by the versioncreatedby column

Return ChildCouponVersion objects filtered by the id column

Return ChildCouponVersion objects filtered by the code column

Return ChildCouponVersion objects filtered by the type column

Return ChildCouponVersion objects filtered by the serialized_effects column

Return ChildCouponVersion objects filtered by the is_enabled column

Return ChildCouponVersion objects filtered by the start_date column

Return ChildCouponVersion objects filtered by the expiration_date column

Return ChildCouponVersion objects filtered by the max_usage column

Return ChildCouponVersion objects filtered by the is_cumulative column

Return ChildCouponVersion objects filtered by the isremovingpostage column

Return ChildCouponVersion objects filtered by the isavailableonspecialoffers column

Return ChildCouponVersion objects filtered by the is_used column

Return ChildCouponVersion objects filtered by the serialized_conditions column

Return ChildCouponVersion objects filtered by the percustomerusage_count column

Return ChildCouponVersion objects filtered by the created_at column

Return ChildCouponVersion objects filtered by the updated_at column

Return ChildCouponVersion objects filtered by the version column

Return ChildCouponVersion objects filtered by the versioncreatedat column

Return ChildCouponVersion objects filtered by the versioncreatedby column