CustomerQuery

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

Returns a new ChildCustomerQuery 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 title_id column

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

Filter the query on the lang_id column

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

Filter the query on the ref column

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

Filter the query on the firstname column

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

Filter the query on the lastname column

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

Filter the query on the email column

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

Filter the query on the password column

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

Filter the query on the algo column

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

Filter the query on the reseller column

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

Filter the query on the sponsor column

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

Filter the query on the discount column

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

Filter the query on the remembermetoken column

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

Filter the query on the remembermeserial column

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

Filter the query on the enable column

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

Filter the query on the confirmation_token column

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

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

Adds a JOIN clause to the query using the CustomerTitle relation

Use the CustomerTitle relation CustomerTitle object

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

Adds a JOIN clause to the query using the LangModel relation

Use the LangModel relation Lang object

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

Adds a JOIN clause to the query using the Address relation

Use the Address relation Address object

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

Adds a JOIN clause to the query using the Cart relation

Use the Cart relation Cart 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\CustomerVersion object

Adds a JOIN clause to the query using the CustomerVersion relation

Use the CustomerVersion relation CustomerVersion object

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

Exclude object from result

Deletes all rows from the customer table.

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

Checks whether versioning is enabled

Enables versioning

Disables versioning

Order by the id column

Order by the title_id column

Order by the lang_id column

Order by the ref column

Order by the firstname column

Order by the lastname column

Order by the email column

Order by the password column

Order by the algo column

Order by the reseller column

Order by the sponsor column

Order by the discount column

Order by the remembermetoken column

Order by the remembermeserial column

Order by the enable column

Order by the confirmation_token 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 title_id column

Group by the lang_id column

Group by the ref column

Group by the firstname column

Group by the lastname column

Group by the email column

Group by the password column

Group by the algo column

Group by the reseller column

Group by the sponsor column

Group by the discount column

Group by the remembermetoken column

Group by the remembermeserial column

Group by the enable column

Group by the confirmation_token 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 CustomerTitle relation

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

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

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

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

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

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

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

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

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

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

Adds a INNER JOIN clause to the query using the Cart 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 CustomerVersion relation

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

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

Return the first ChildCustomer matching the query

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

Return the first ChildCustomer filtered by the id column

Return the first ChildCustomer filtered by the title_id column

Return the first ChildCustomer filtered by the lang_id column

Return the first ChildCustomer filtered by the ref column

Return the first ChildCustomer filtered by the firstname column

Return the first ChildCustomer filtered by the lastname column

Return the first ChildCustomer filtered by the email column

Return the first ChildCustomer filtered by the password column

Return the first ChildCustomer filtered by the algo column

Return the first ChildCustomer filtered by the reseller column

Return the first ChildCustomer filtered by the sponsor column

Return the first ChildCustomer filtered by the discount column

Return the first ChildCustomer filtered by the remembermetoken column

Return the first ChildCustomer filtered by the remembermeserial column

Return the first ChildCustomer filtered by the enable column

Return the first ChildCustomer filtered by the confirmation_token column

Return the first ChildCustomer filtered by the created_at column

Return the first ChildCustomer filtered by the updated_at column

Return the first ChildCustomer filtered by the version column

Return the first ChildCustomer filtered by the versioncreatedat column

Return the first ChildCustomer filtered by the versioncreatedby column

Return ChildCustomer objects filtered by the id column

Return ChildCustomer objects filtered by the title_id column

Return ChildCustomer objects filtered by the lang_id column

Return ChildCustomer objects filtered by the ref column

Return ChildCustomer objects filtered by the firstname column

Return ChildCustomer objects filtered by the lastname column

Return ChildCustomer objects filtered by the email column

Return ChildCustomer objects filtered by the password column

Return ChildCustomer objects filtered by the algo column

Return ChildCustomer objects filtered by the reseller column

Return ChildCustomer objects filtered by the sponsor column

Return ChildCustomer objects filtered by the discount column

Return ChildCustomer objects filtered by the remembermetoken column

Return ChildCustomer objects filtered by the remembermeserial column

Return ChildCustomer objects filtered by the enable column

Return ChildCustomer objects filtered by the confirmation_token column

Return ChildCustomer objects filtered by the created_at column

Return ChildCustomer objects filtered by the updated_at column

Return ChildCustomer objects filtered by the version column

Return ChildCustomer objects filtered by the versioncreatedat column

Return ChildCustomer objects filtered by the versioncreatedby column