class CouponVersionQuery extends CouponVersionQuery

Skeleton subclass for performing query and update operations on the 'coupon_version' 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

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CouponVersion', string $modelAlias = null)

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

create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCouponVersionQuery object.

CouponVersion|array|mixed
findPk($key, $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByCode( string $code = null, string $comparison = null)

Filter the query on the code column

filterByType( string $type = null, string $comparison = null)

Filter the query on the type column

filterBySerializedEffects( string $serializedEffects = null, string $comparison = null)

Filter the query on the serialized_effects column

filterByIsEnabled( boolean|string $isEnabled = null, string $comparison = null)

Filter the query on the is_enabled column

filterByStartDate( mixed $startDate = null, string $comparison = null)

Filter the query on the start_date column

filterByExpirationDate( mixed $expirationDate = null, string $comparison = null)

Filter the query on the expiration_date column

filterByMaxUsage( mixed $maxUsage = null, string $comparison = null)

Filter the query on the max_usage column

filterByIsCumulative( boolean|string $isCumulative = null, string $comparison = null)

Filter the query on the is_cumulative column

filterByIsRemovingPostage( boolean|string $isRemovingPostage = null, string $comparison = null)

Filter the query on the isremovingpostage column

filterByIsAvailableOnSpecialOffers( boolean|string $isAvailableOnSpecialOffers = null, string $comparison = null)

Filter the query on the isavailableonspecialoffers column

filterByIsUsed( boolean|string $isUsed = null, string $comparison = null)

Filter the query on the is_used column

filterBySerializedConditions( string $serializedConditions = null, string $comparison = null)

Filter the query on the serialized_conditions column

filterByPerCustomerUsageCount( boolean|string $perCustomerUsageCount = null, string $comparison = null)

Filter the query on the percustomerusage_count column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByVersion( mixed $version = null, string $comparison = null)

Filter the query on the version column

filterByVersionCreatedAt( mixed $versionCreatedAt = null, string $comparison = null)

Filter the query on the versioncreatedat column

filterByVersionCreatedBy( string $versionCreatedBy = null, string $comparison = null)

Filter the query on the versioncreatedby column

filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

joinCoupon( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Coupon relation

useCouponQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Coupon relation Coupon object

prune( CouponVersion $couponVersion = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the coupon_version table.

int
delete( ConnectionInterface $con = null)

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

ChildCouponVersionQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildCouponVersionQuery
orderByCode($order = Criteria::ASC)

Order by the code column

ChildCouponVersionQuery
orderByType($order = Criteria::ASC)

Order by the type column

ChildCouponVersionQuery
orderBySerializedEffects($order = Criteria::ASC)

Order by the serialized_effects column

ChildCouponVersionQuery
orderByIsEnabled($order = Criteria::ASC)

Order by the is_enabled column

ChildCouponVersionQuery
orderByStartDate($order = Criteria::ASC)

Order by the start_date column

ChildCouponVersionQuery
orderByExpirationDate($order = Criteria::ASC)

Order by the expiration_date column

ChildCouponVersionQuery
orderByMaxUsage($order = Criteria::ASC)

Order by the max_usage column

ChildCouponVersionQuery
orderByIsCumulative($order = Criteria::ASC)

Order by the is_cumulative column

ChildCouponVersionQuery
orderByIsRemovingPostage($order = Criteria::ASC)

Order by the isremovingpostage column

ChildCouponVersionQuery
orderByIsAvailableOnSpecialOffers($order = Criteria::ASC)

Order by the isavailableonspecialoffers column

ChildCouponVersionQuery
orderByIsUsed($order = Criteria::ASC)

Order by the is_used column

ChildCouponVersionQuery
orderBySerializedConditions($order = Criteria::ASC)

Order by the serialized_conditions column

ChildCouponVersionQuery
orderByPerCustomerUsageCount($order = Criteria::ASC)

Order by the percustomerusage_count column

ChildCouponVersionQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildCouponVersionQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildCouponVersionQuery
orderByVersion($order = Criteria::ASC)

Order by the version column

ChildCouponVersionQuery
orderByVersionCreatedAt($order = Criteria::ASC)

Order by the versioncreatedat column

ChildCouponVersionQuery
orderByVersionCreatedBy($order = Criteria::ASC)

Order by the versioncreatedby column

ChildCouponVersionQuery
groupById()

Group by the id column

ChildCouponVersionQuery
groupByCode()

Group by the code column

ChildCouponVersionQuery
groupByType()

Group by the type column

ChildCouponVersionQuery
groupBySerializedEffects()

Group by the serialized_effects column

ChildCouponVersionQuery
groupByIsEnabled()

Group by the is_enabled column

ChildCouponVersionQuery
groupByStartDate()

Group by the start_date column

ChildCouponVersionQuery
groupByExpirationDate()

Group by the expiration_date column

ChildCouponVersionQuery
groupByMaxUsage()

Group by the max_usage column

ChildCouponVersionQuery
groupByIsCumulative()

Group by the is_cumulative column

ChildCouponVersionQuery
groupByIsRemovingPostage()

Group by the isremovingpostage column

ChildCouponVersionQuery
groupByIsAvailableOnSpecialOffers()

Group by the isavailableonspecialoffers column

ChildCouponVersionQuery
groupByIsUsed()

Group by the is_used column

ChildCouponVersionQuery
groupBySerializedConditions()

Group by the serialized_conditions column

ChildCouponVersionQuery
groupByPerCustomerUsageCount()

Group by the percustomerusage_count column

ChildCouponVersionQuery
groupByCreatedAt()

Group by the created_at column

ChildCouponVersionQuery
groupByUpdatedAt()

Group by the updated_at column

ChildCouponVersionQuery
groupByVersion()

Group by the version column

ChildCouponVersionQuery
groupByVersionCreatedAt()

Group by the versioncreatedat column

ChildCouponVersionQuery
groupByVersionCreatedBy()

Group by the versioncreatedby column

ChildCouponVersionQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCouponVersionQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCouponVersionQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCouponVersionQuery
leftJoinCoupon($relationAlias = null)

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

ChildCouponVersionQuery
rightJoinCoupon($relationAlias = null)

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

ChildCouponVersionQuery
innerJoinCoupon($relationAlias = null)

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

ChildCouponVersion
findOne( ConnectionInterface $con = null)

Return the first ChildCouponVersion matching the query

ChildCouponVersion
findOneOrCreate( ConnectionInterface $con = null)

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

ChildCouponVersion
findOneById( int $id)

Return the first ChildCouponVersion filtered by the id column

ChildCouponVersion
findOneByCode( string $code)

Return the first ChildCouponVersion filtered by the code column

ChildCouponVersion
findOneByType( string $type)

Return the first ChildCouponVersion filtered by the type column

ChildCouponVersion
findOneBySerializedEffects( string $serialized_effects)

Return the first ChildCouponVersion filtered by the serialized_effects column

ChildCouponVersion
findOneByIsEnabled( boolean $is_enabled)

Return the first ChildCouponVersion filtered by the is_enabled column

ChildCouponVersion
findOneByStartDate( string $start_date)

Return the first ChildCouponVersion filtered by the start_date column

ChildCouponVersion
findOneByExpirationDate( string $expiration_date)

Return the first ChildCouponVersion filtered by the expiration_date column

ChildCouponVersion
findOneByMaxUsage( int $max_usage)

Return the first ChildCouponVersion filtered by the max_usage column

ChildCouponVersion
findOneByIsCumulative( boolean $is_cumulative)

Return the first ChildCouponVersion filtered by the is_cumulative column

ChildCouponVersion
findOneByIsRemovingPostage( boolean $is_removing_postage)

Return the first ChildCouponVersion filtered by the isremovingpostage column

ChildCouponVersion
findOneByIsAvailableOnSpecialOffers( boolean $is_available_on_special_offers)

Return the first ChildCouponVersion filtered by the isavailableonspecialoffers column

ChildCouponVersion
findOneByIsUsed( boolean $is_used)

Return the first ChildCouponVersion filtered by the is_used column

ChildCouponVersion
findOneBySerializedConditions( string $serialized_conditions)

Return the first ChildCouponVersion filtered by the serialized_conditions column

ChildCouponVersion
findOneByPerCustomerUsageCount( boolean $per_customer_usage_count)

Return the first ChildCouponVersion filtered by the percustomerusage_count column

ChildCouponVersion
findOneByCreatedAt( string $created_at)

Return the first ChildCouponVersion filtered by the created_at column

ChildCouponVersion
findOneByUpdatedAt( string $updated_at)

Return the first ChildCouponVersion filtered by the updated_at column

ChildCouponVersion
findOneByVersion( int $version)

Return the first ChildCouponVersion filtered by the version column

ChildCouponVersion
findOneByVersionCreatedAt( string $version_created_at)

Return the first ChildCouponVersion filtered by the versioncreatedat column

ChildCouponVersion
findOneByVersionCreatedBy( string $version_created_by)

Return the first ChildCouponVersion filtered by the versioncreatedby column

array
findById( int $id)

Return ChildCouponVersion objects filtered by the id column

array
findByCode( string $code)

Return ChildCouponVersion objects filtered by the code column

array
findByType( string $type)

Return ChildCouponVersion objects filtered by the type column

array
findBySerializedEffects( string $serialized_effects)

Return ChildCouponVersion objects filtered by the serialized_effects column

array
findByIsEnabled( boolean $is_enabled)

Return ChildCouponVersion objects filtered by the is_enabled column

array
findByStartDate( string $start_date)

Return ChildCouponVersion objects filtered by the start_date column

array
findByExpirationDate( string $expiration_date)

Return ChildCouponVersion objects filtered by the expiration_date column

array
findByMaxUsage( int $max_usage)

Return ChildCouponVersion objects filtered by the max_usage column

array
findByIsCumulative( boolean $is_cumulative)

Return ChildCouponVersion objects filtered by the is_cumulative column

array
findByIsRemovingPostage( boolean $is_removing_postage)

Return ChildCouponVersion objects filtered by the isremovingpostage column

array
findByIsAvailableOnSpecialOffers( boolean $is_available_on_special_offers)

Return ChildCouponVersion objects filtered by the isavailableonspecialoffers column

array
findByIsUsed( boolean $is_used)

Return ChildCouponVersion objects filtered by the is_used column

array
findBySerializedConditions( string $serialized_conditions)

Return ChildCouponVersion objects filtered by the serialized_conditions column

array
findByPerCustomerUsageCount( boolean $per_customer_usage_count)

Return ChildCouponVersion objects filtered by the percustomerusage_count column

array
findByCreatedAt( string $created_at)

Return ChildCouponVersion objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildCouponVersion objects filtered by the updated_at column

array
findByVersion( int $version)

Return ChildCouponVersion objects filtered by the version column

array
findByVersionCreatedAt( string $version_created_at)

Return ChildCouponVersion objects filtered by the versioncreatedat column

array
findByVersionCreatedBy( string $version_created_by)

Return ChildCouponVersion objects filtered by the versioncreatedby column

Details

in CouponVersionQuery at line 126
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CouponVersion', string $modelAlias = null)

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

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

in CouponVersionQuery at line 139
static CouponVersionQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCouponVersionQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

CouponVersionQuery

in CouponVersionQuery at line 169
CouponVersion|array|mixed findPk($key, $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(array(12, 34), $con);

Parameters

$key
$con

Return Value

CouponVersion|array|mixed the result, formatted by the current formatter

in CouponVersionQuery at line 252
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

in CouponVersionQuery at line 273
CouponVersionQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 288
CouponVersionQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 323
CouponVersionQuery 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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

See also

filterByCoupon()

in CouponVersionQuery at line 361
CouponVersionQuery filterByCode( string $code = null, string $comparison = null)

Filter the query on the code column

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

Parameters

string $code The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 390
CouponVersionQuery filterByType( string $type = null, string $comparison = null)

Filter the query on the type column

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

Parameters

string $type The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 419
CouponVersionQuery filterBySerializedEffects( string $serializedEffects = null, string $comparison = null)

Filter the query on the serialized_effects column

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

Parameters

string $serializedEffects The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 451
CouponVersionQuery filterByIsEnabled( boolean|string $isEnabled = null, string $comparison = null)

Filter the query on the is_enabled column

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

Parameters

boolean|string $isEnabled The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 480
CouponVersionQuery filterByStartDate( mixed $startDate = null, string $comparison = null)

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'

Parameters

mixed $startDate The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 523
CouponVersionQuery filterByExpirationDate( mixed $expirationDate = null, string $comparison = null)

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'

Parameters

mixed $expirationDate The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 564
CouponVersionQuery filterByMaxUsage( mixed $maxUsage = null, string $comparison = null)

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

Parameters

mixed $maxUsage The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 605
CouponVersionQuery filterByIsCumulative( boolean|string $isCumulative = null, string $comparison = null)

Filter the query on the is_cumulative column

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

Parameters

boolean|string $isCumulative The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 632
CouponVersionQuery filterByIsRemovingPostage( boolean|string $isRemovingPostage = null, string $comparison = null)

Filter the query on the isremovingpostage column

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

Parameters

boolean|string $isRemovingPostage The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 659
CouponVersionQuery filterByIsAvailableOnSpecialOffers( boolean|string $isAvailableOnSpecialOffers = null, string $comparison = null)

Filter the query on the isavailableonspecialoffers column

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

Parameters

boolean|string $isAvailableOnSpecialOffers The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 686
CouponVersionQuery filterByIsUsed( boolean|string $isUsed = null, string $comparison = null)

Filter the query on the is_used column

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

Parameters

boolean|string $isUsed The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 710
CouponVersionQuery filterBySerializedConditions( string $serializedConditions = null, string $comparison = null)

Filter the query on the serialized_conditions column

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

Parameters

string $serializedConditions The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 742
CouponVersionQuery filterByPerCustomerUsageCount( boolean|string $perCustomerUsageCount = null, string $comparison = null)

Filter the query on the percustomerusage_count column

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

Parameters

boolean|string $perCustomerUsageCount The value to use as filter. Non-boolean arguments are converted using the following rules: * 1, '1', 'true', 'on', and 'yes' are converted to boolean true * 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 771
CouponVersionQuery 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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 814
CouponVersionQuery 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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 855
CouponVersionQuery filterByVersion( mixed $version = null, string $comparison = null)

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

Parameters

mixed $version The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 898
CouponVersionQuery filterByVersionCreatedAt( mixed $versionCreatedAt = null, string $comparison = null)

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'

Parameters

mixed $versionCreatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 936
CouponVersionQuery filterByVersionCreatedBy( string $versionCreatedBy = null, string $comparison = null)

Filter the query on the versioncreatedby column

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

Parameters

string $versionCreatedBy The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 958
CouponVersionQuery filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

Parameters

Coupon|ObjectCollection $coupon The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 983
CouponVersionQuery joinCoupon( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Coupon relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 1018
CouponQuery useCouponQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Coupon relation Coupon object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CouponQuery A secondary query class using the current class as primary query

See also

useQuery()

in CouponVersionQuery at line 1032
CouponVersionQuery prune( CouponVersion $couponVersion = null)

Exclude object from result

Parameters

CouponVersion $couponVersion Object to remove from the list of results

Return Value

CouponVersionQuery The current query, for fluid interface

in CouponVersionQuery at line 1049
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the coupon_version table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

in CouponVersionQuery at line 1086
int delete( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByCode($order = Criteria::ASC)

Order by the code column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByType($order = Criteria::ASC)

Order by the type column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderBySerializedEffects($order = Criteria::ASC)

Order by the serialized_effects column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByIsEnabled($order = Criteria::ASC)

Order by the is_enabled column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByStartDate($order = Criteria::ASC)

Order by the start_date column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByExpirationDate($order = Criteria::ASC)

Order by the expiration_date column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByMaxUsage($order = Criteria::ASC)

Order by the max_usage column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByIsCumulative($order = Criteria::ASC)

Order by the is_cumulative column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByIsRemovingPostage($order = Criteria::ASC)

Order by the isremovingpostage column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByIsAvailableOnSpecialOffers($order = Criteria::ASC)

Order by the isavailableonspecialoffers column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByIsUsed($order = Criteria::ASC)

Order by the is_used column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderBySerializedConditions($order = Criteria::ASC)

Order by the serialized_conditions column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByPerCustomerUsageCount($order = Criteria::ASC)

Order by the percustomerusage_count column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByVersion($order = Criteria::ASC)

Order by the version column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByVersionCreatedAt($order = Criteria::ASC)

Order by the versioncreatedat column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery orderByVersionCreatedBy($order = Criteria::ASC)

Order by the versioncreatedby column

Parameters

$order

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupById()

Group by the id column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByCode()

Group by the code column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByType()

Group by the type column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupBySerializedEffects()

Group by the serialized_effects column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByIsEnabled()

Group by the is_enabled column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByStartDate()

Group by the start_date column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByExpirationDate()

Group by the expiration_date column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByMaxUsage()

Group by the max_usage column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByIsCumulative()

Group by the is_cumulative column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByIsRemovingPostage()

Group by the isremovingpostage column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByIsAvailableOnSpecialOffers()

Group by the isavailableonspecialoffers column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByIsUsed()

Group by the is_used column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupBySerializedConditions()

Group by the serialized_conditions column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByPerCustomerUsageCount()

Group by the percustomerusage_count column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByVersion()

Group by the version column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByVersionCreatedAt()

Group by the versioncreatedat column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery groupByVersionCreatedBy()

Group by the versioncreatedby column

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery leftJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery rightJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersionQuery innerJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponVersionQuery

in CouponVersionQuery at line 116
ChildCouponVersion findOne( ConnectionInterface $con = null)

Return the first ChildCouponVersion matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneById( int $id)

Return the first ChildCouponVersion filtered by the id column

Parameters

int $id

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByCode( string $code)

Return the first ChildCouponVersion filtered by the code column

Parameters

string $code

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByType( string $type)

Return the first ChildCouponVersion filtered by the type column

Parameters

string $type

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneBySerializedEffects( string $serialized_effects)

Return the first ChildCouponVersion filtered by the serialized_effects column

Parameters

string $serialized_effects

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByIsEnabled( boolean $is_enabled)

Return the first ChildCouponVersion filtered by the is_enabled column

Parameters

boolean $is_enabled

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByStartDate( string $start_date)

Return the first ChildCouponVersion filtered by the start_date column

Parameters

string $start_date

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByExpirationDate( string $expiration_date)

Return the first ChildCouponVersion filtered by the expiration_date column

Parameters

string $expiration_date

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByMaxUsage( int $max_usage)

Return the first ChildCouponVersion filtered by the max_usage column

Parameters

int $max_usage

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByIsCumulative( boolean $is_cumulative)

Return the first ChildCouponVersion filtered by the is_cumulative column

Parameters

boolean $is_cumulative

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByIsRemovingPostage( boolean $is_removing_postage)

Return the first ChildCouponVersion filtered by the isremovingpostage column

Parameters

boolean $is_removing_postage

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByIsAvailableOnSpecialOffers( boolean $is_available_on_special_offers)

Return the first ChildCouponVersion filtered by the isavailableonspecialoffers column

Parameters

boolean $is_available_on_special_offers

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByIsUsed( boolean $is_used)

Return the first ChildCouponVersion filtered by the is_used column

Parameters

boolean $is_used

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneBySerializedConditions( string $serialized_conditions)

Return the first ChildCouponVersion filtered by the serialized_conditions column

Parameters

string $serialized_conditions

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByPerCustomerUsageCount( boolean $per_customer_usage_count)

Return the first ChildCouponVersion filtered by the percustomerusage_count column

Parameters

boolean $per_customer_usage_count

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByCreatedAt( string $created_at)

Return the first ChildCouponVersion filtered by the created_at column

Parameters

string $created_at

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByUpdatedAt( string $updated_at)

Return the first ChildCouponVersion filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByVersion( int $version)

Return the first ChildCouponVersion filtered by the version column

Parameters

int $version

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByVersionCreatedAt( string $version_created_at)

Return the first ChildCouponVersion filtered by the versioncreatedat column

Parameters

string $version_created_at

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
ChildCouponVersion findOneByVersionCreatedBy( string $version_created_by)

Return the first ChildCouponVersion filtered by the versioncreatedby column

Parameters

string $version_created_by

Return Value

ChildCouponVersion

in CouponVersionQuery at line 116
array findById( int $id)

Return ChildCouponVersion objects filtered by the id column

Parameters

int $id

Return Value

array

in CouponVersionQuery at line 116
array findByCode( string $code)

Return ChildCouponVersion objects filtered by the code column

Parameters

string $code

Return Value

array

in CouponVersionQuery at line 116
array findByType( string $type)

Return ChildCouponVersion objects filtered by the type column

Parameters

string $type

Return Value

array

in CouponVersionQuery at line 116
array findBySerializedEffects( string $serialized_effects)

Return ChildCouponVersion objects filtered by the serialized_effects column

Parameters

string $serialized_effects

Return Value

array

in CouponVersionQuery at line 116
array findByIsEnabled( boolean $is_enabled)

Return ChildCouponVersion objects filtered by the is_enabled column

Parameters

boolean $is_enabled

Return Value

array

in CouponVersionQuery at line 116
array findByStartDate( string $start_date)

Return ChildCouponVersion objects filtered by the start_date column

Parameters

string $start_date

Return Value

array

in CouponVersionQuery at line 116
array findByExpirationDate( string $expiration_date)

Return ChildCouponVersion objects filtered by the expiration_date column

Parameters

string $expiration_date

Return Value

array

in CouponVersionQuery at line 116
array findByMaxUsage( int $max_usage)

Return ChildCouponVersion objects filtered by the max_usage column

Parameters

int $max_usage

Return Value

array

in CouponVersionQuery at line 116
array findByIsCumulative( boolean $is_cumulative)

Return ChildCouponVersion objects filtered by the is_cumulative column

Parameters

boolean $is_cumulative

Return Value

array

in CouponVersionQuery at line 116
array findByIsRemovingPostage( boolean $is_removing_postage)

Return ChildCouponVersion objects filtered by the isremovingpostage column

Parameters

boolean $is_removing_postage

Return Value

array

in CouponVersionQuery at line 116
array findByIsAvailableOnSpecialOffers( boolean $is_available_on_special_offers)

Return ChildCouponVersion objects filtered by the isavailableonspecialoffers column

Parameters

boolean $is_available_on_special_offers

Return Value

array

in CouponVersionQuery at line 116
array findByIsUsed( boolean $is_used)

Return ChildCouponVersion objects filtered by the is_used column

Parameters

boolean $is_used

Return Value

array

in CouponVersionQuery at line 116
array findBySerializedConditions( string $serialized_conditions)

Return ChildCouponVersion objects filtered by the serialized_conditions column

Parameters

string $serialized_conditions

Return Value

array

in CouponVersionQuery at line 116
array findByPerCustomerUsageCount( boolean $per_customer_usage_count)

Return ChildCouponVersion objects filtered by the percustomerusage_count column

Parameters

boolean $per_customer_usage_count

Return Value

array

in CouponVersionQuery at line 116
array findByCreatedAt( string $created_at)

Return ChildCouponVersion objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

in CouponVersionQuery at line 116
array findByUpdatedAt( string $updated_at)

Return ChildCouponVersion objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array

in CouponVersionQuery at line 116
array findByVersion( int $version)

Return ChildCouponVersion objects filtered by the version column

Parameters

int $version

Return Value

array

in CouponVersionQuery at line 116
array findByVersionCreatedAt( string $version_created_at)

Return ChildCouponVersion objects filtered by the versioncreatedat column

Parameters

string $version_created_at

Return Value

array

in CouponVersionQuery at line 116
array findByVersionCreatedBy( string $version_created_by)

Return ChildCouponVersion objects filtered by the versioncreatedby column

Parameters

string $version_created_by

Return Value

array