AddressQuery

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

Returns a new ChildAddressQuery 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 label column

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

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

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

Example usage: $query->filterByCompany('fooValue'); // WHERE company = 'fooValue' $query->filterByCompany('%fooValue%'); // WHERE company 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 address1 column

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

Filter the query on the address2 column

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

Filter the query on the address3 column

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

Filter the query on the zipcode column

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

Filter the query on the city column

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

Filter the query on the country_id column

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

Filter the query on the state_id column

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

Filter the query on the phone column

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

Filter the query on the cellphone column

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

Filter the query on the is_default column

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

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 by a related \Thelia\Model\Customer object

Adds a JOIN clause to the query using the Customer relation

Use the Customer relation Customer object

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

Adds a JOIN clause to the query using the Country relation

Use the Country relation Country object

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

Adds a JOIN clause to the query using the State relation

Use the State relation State object

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

Adds a JOIN clause to the query using the CartRelatedByAddressDeliveryId relation

Use the CartRelatedByAddressDeliveryId relation Cart object

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

Adds a JOIN clause to the query using the CartRelatedByAddressInvoiceId relation

Use the CartRelatedByAddressInvoiceId relation Cart object

Exclude object from result

Deletes all rows from the address table.

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

Order by the id column

Order by the label column

Order by the customer_id column

Order by the title_id column

Order by the company column

Order by the firstname column

Order by the lastname column

Order by the address1 column

Order by the address2 column

Order by the address3 column

Order by the zipcode column

Order by the city column

Order by the country_id column

Order by the state_id column

Order by the phone column

Order by the cellphone column

Order by the is_default column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the label column

Group by the customer_id column

Group by the title_id column

Group by the company column

Group by the firstname column

Group by the lastname column

Group by the address1 column

Group by the address2 column

Group by the address3 column

Group by the zipcode column

Group by the city column

Group by the country_id column

Group by the state_id column

Group by the phone column

Group by the cellphone column

Group by the is_default column

Group by the created_at column

Group by the updated_at 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 Customer relation

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Return the first ChildAddress matching the query

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

Return the first ChildAddress filtered by the id column

Return the first ChildAddress filtered by the label column

Return the first ChildAddress filtered by the customer_id column

Return the first ChildAddress filtered by the title_id column

Return the first ChildAddress filtered by the company column

Return the first ChildAddress filtered by the firstname column

Return the first ChildAddress filtered by the lastname column

Return the first ChildAddress filtered by the address1 column

Return the first ChildAddress filtered by the address2 column

Return the first ChildAddress filtered by the address3 column

Return the first ChildAddress filtered by the zipcode column

Return the first ChildAddress filtered by the city column

Return the first ChildAddress filtered by the country_id column

Return the first ChildAddress filtered by the state_id column

Return the first ChildAddress filtered by the phone column

Return the first ChildAddress filtered by the cellphone column

Return the first ChildAddress filtered by the is_default column

Return the first ChildAddress filtered by the created_at column

Return the first ChildAddress filtered by the updated_at column

Return ChildAddress objects filtered by the id column

Return ChildAddress objects filtered by the label column

Return ChildAddress objects filtered by the customer_id column

Return ChildAddress objects filtered by the title_id column

Return ChildAddress objects filtered by the company column

Return ChildAddress objects filtered by the firstname column

Return ChildAddress objects filtered by the lastname column

Return ChildAddress objects filtered by the address1 column

Return ChildAddress objects filtered by the address2 column

Return ChildAddress objects filtered by the address3 column

Return ChildAddress objects filtered by the zipcode column

Return ChildAddress objects filtered by the city column

Return ChildAddress objects filtered by the country_id column

Return ChildAddress objects filtered by the state_id column

Return ChildAddress objects filtered by the phone column

Return ChildAddress objects filtered by the cellphone column

Return ChildAddress objects filtered by the is_default column

Return ChildAddress objects filtered by the created_at column

Return ChildAddress objects filtered by the updated_at column