class CouponCustomerCountQuery extends ModelCriteria

Base class that represents a query for the 'couponcustomercount' table.

Methods

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

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

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

Returns a new ChildCouponCustomerCountQuery object.

CouponCustomerCount|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

filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

filterByCustomerId( mixed $customerId = null, string $comparison = null)

Filter the query on the customer_id column

filterByCount( mixed $count = null, string $comparison = null)

Filter the query on the count column

filterByCustomer( Customer|ObjectCollection $customer, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Customer relation

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

Use the Customer relation Customer object

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( CouponCustomerCount $couponCustomerCount = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the couponcustomercount table.

int
delete( ConnectionInterface $con = null)

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

ChildCouponCustomerCountQuery
orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

ChildCouponCustomerCountQuery
orderByCustomerId($order = Criteria::ASC)

Order by the customer_id column

ChildCouponCustomerCountQuery
orderByCount($order = Criteria::ASC)

Order by the count column

ChildCouponCustomerCountQuery
groupByCouponId()

Group by the coupon_id column

ChildCouponCustomerCountQuery
groupByCustomerId()

Group by the customer_id column

ChildCouponCustomerCountQuery
groupByCount()

Group by the count column

ChildCouponCustomerCountQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCouponCustomerCountQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCouponCustomerCountQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCouponCustomerCountQuery
leftJoinCustomer($relationAlias = null)

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

ChildCouponCustomerCountQuery
rightJoinCustomer($relationAlias = null)

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

ChildCouponCustomerCountQuery
innerJoinCustomer($relationAlias = null)

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

ChildCouponCustomerCountQuery
leftJoinCoupon($relationAlias = null)

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

ChildCouponCustomerCountQuery
rightJoinCoupon($relationAlias = null)

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

ChildCouponCustomerCountQuery
innerJoinCoupon($relationAlias = null)

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

ChildCouponCustomerCount
findOne( ConnectionInterface $con = null)

Return the first ChildCouponCustomerCount matching the query

ChildCouponCustomerCount
findOneOrCreate( ConnectionInterface $con = null)

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

ChildCouponCustomerCount
findOneByCouponId( int $coupon_id)

Return the first ChildCouponCustomerCount filtered by the coupon_id column

ChildCouponCustomerCount
findOneByCustomerId( int $customer_id)

Return the first ChildCouponCustomerCount filtered by the customer_id column

ChildCouponCustomerCount
findOneByCount( int $count)

Return the first ChildCouponCustomerCount filtered by the count column

array
findByCouponId( int $coupon_id)

Return ChildCouponCustomerCount objects filtered by the coupon_id column

array
findByCustomerId( int $customer_id)

Return ChildCouponCustomerCount objects filtered by the customer_id column

array
findByCount( int $count)

Return ChildCouponCustomerCount objects filtered by the count column

Details

at line 66
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CouponCustomerCount', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\CouponCustomerCountQuery 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'

at line 79
static CouponCustomerCountQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCouponCustomerCountQuery object.

Parameters

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

Return Value

CouponCustomerCountQuery

at line 109
CouponCustomerCount|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

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

at line 192
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

at line 213
CouponCustomerCountQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CouponCustomerCountQuery The current query, for fluid interface

at line 228
CouponCustomerCountQuery 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

CouponCustomerCountQuery The current query, for fluid interface

at line 263
CouponCustomerCountQuery filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

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

Parameters

mixed $couponId 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

CouponCustomerCountQuery The current query, for fluid interface

See also

filterByCoupon()

at line 306
CouponCustomerCountQuery filterByCustomerId( mixed $customerId = null, string $comparison = null)

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

Parameters

mixed $customerId 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

CouponCustomerCountQuery The current query, for fluid interface

See also

filterByCustomer()

at line 347
CouponCustomerCountQuery filterByCount( mixed $count = null, string $comparison = null)

Filter the query on the count column

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

Parameters

mixed $count 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

CouponCustomerCountQuery The current query, for fluid interface

at line 378
CouponCustomerCountQuery filterByCustomer( Customer|ObjectCollection $customer, string $comparison = null)

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

Parameters

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

Return Value

CouponCustomerCountQuery The current query, for fluid interface

at line 403
CouponCustomerCountQuery joinCustomer( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Customer relation

Parameters

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

Return Value

CouponCustomerCountQuery The current query, for fluid interface

at line 438
CustomerQuery useCustomerQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Customer relation Customer 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

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

See also

useQuery()

at line 453
CouponCustomerCountQuery 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

CouponCustomerCountQuery The current query, for fluid interface

at line 478
CouponCustomerCountQuery 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

CouponCustomerCountQuery The current query, for fluid interface

at line 513
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()

at line 527
CouponCustomerCountQuery prune( CouponCustomerCount $couponCustomerCount = null)

Exclude object from result

Parameters

CouponCustomerCount $couponCustomerCount Object to remove from the list of results

Return Value

CouponCustomerCountQuery The current query, for fluid interface

at line 544
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the couponcustomercount table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

at line 581
int delete( ConnectionInterface $con = null)

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

at line 56
ChildCouponCustomerCountQuery orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

Parameters

$order

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery orderByCustomerId($order = Criteria::ASC)

Order by the customer_id column

Parameters

$order

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery orderByCount($order = Criteria::ASC)

Order by the count column

Parameters

$order

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery groupByCouponId()

Group by the coupon_id column

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery groupByCustomerId()

Group by the customer_id column

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery groupByCount()

Group by the count column

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery leftJoinCustomer($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery rightJoinCustomer($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery innerJoinCustomer($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery leftJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery rightJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCountQuery innerJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCustomerCountQuery

at line 56
ChildCouponCustomerCount findOne( ConnectionInterface $con = null)

Return the first ChildCouponCustomerCount matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCouponCustomerCount

at line 56
ChildCouponCustomerCount findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildCouponCustomerCount

at line 56
ChildCouponCustomerCount findOneByCouponId( int $coupon_id)

Return the first ChildCouponCustomerCount filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

ChildCouponCustomerCount

at line 56
ChildCouponCustomerCount findOneByCustomerId( int $customer_id)

Return the first ChildCouponCustomerCount filtered by the customer_id column

Parameters

int $customer_id

Return Value

ChildCouponCustomerCount

at line 56
ChildCouponCustomerCount findOneByCount( int $count)

Return the first ChildCouponCustomerCount filtered by the count column

Parameters

int $count

Return Value

ChildCouponCustomerCount

at line 56
array findByCouponId( int $coupon_id)

Return ChildCouponCustomerCount objects filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

array

at line 56
array findByCustomerId( int $customer_id)

Return ChildCouponCustomerCount objects filtered by the customer_id column

Parameters

int $customer_id

Return Value

array

at line 56
array findByCount( int $count)

Return ChildCouponCustomerCount objects filtered by the count column

Parameters

int $count

Return Value

array