class OrderAddressQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildOrderAddressQuery object.

OrderAddress|array|mixed
findPk( mixed $key, ConnectionInterface $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(12, 56, 832), $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

filterByCustomerTitleId( mixed $customerTitleId = null, string $comparison = null)

Filter the query on the customertitleid column

filterByCompany( string $company = null, string $comparison = null)

Filter the query on the company column

filterByFirstname( string $firstname = null, string $comparison = null)

Filter the query on the firstname column

filterByLastname( string $lastname = null, string $comparison = null)

Filter the query on the lastname column

filterByAddress1( string $address1 = null, string $comparison = null)

Filter the query on the address1 column

filterByAddress2( string $address2 = null, string $comparison = null)

Filter the query on the address2 column

filterByAddress3( string $address3 = null, string $comparison = null)

Filter the query on the address3 column

filterByZipcode( string $zipcode = null, string $comparison = null)

Filter the query on the zipcode column

filterByCity( string $city = null, string $comparison = null)

Filter the query on the city column

filterByPhone( string $phone = null, string $comparison = null)

Filter the query on the phone column

filterByCellphone( string $cellphone = null, string $comparison = null)

Filter the query on the cellphone column

filterByCountryId( mixed $countryId = null, string $comparison = null)

Filter the query on the country_id column

filterByStateId( mixed $stateId = null, string $comparison = null)

Filter the query on the state_id 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

filterByCustomerTitle( CustomerTitle|ObjectCollection $customerTitle, string $comparison = null)

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

joinCustomerTitle( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the CustomerTitle relation

useCustomerTitleQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the CustomerTitle relation CustomerTitle object

filterByCountry( Country|ObjectCollection $country, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Country relation

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

Use the Country relation Country object

filterByState( State|ObjectCollection $state, string $comparison = null)

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

joinState( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the State relation

useStateQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the State relation State object

filterByOrderRelatedByInvoiceOrderAddressId( Order|ObjectCollection $order, string $comparison = null)

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

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

Adds a JOIN clause to the query using the OrderRelatedByInvoiceOrderAddressId relation

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

Use the OrderRelatedByInvoiceOrderAddressId relation Order object

filterByOrderRelatedByDeliveryOrderAddressId( Order|ObjectCollection $order, string $comparison = null)

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

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

Adds a JOIN clause to the query using the OrderRelatedByDeliveryOrderAddressId relation

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

Use the OrderRelatedByDeliveryOrderAddressId relation Order object

prune( OrderAddress $orderAddress = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the order_address table.

int
delete( ConnectionInterface $con = null)

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

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildOrderAddressQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildOrderAddressQuery
orderByCustomerTitleId($order = Criteria::ASC)

Order by the customertitleid column

ChildOrderAddressQuery
orderByCompany($order = Criteria::ASC)

Order by the company column

ChildOrderAddressQuery
orderByFirstname($order = Criteria::ASC)

Order by the firstname column

ChildOrderAddressQuery
orderByLastname($order = Criteria::ASC)

Order by the lastname column

ChildOrderAddressQuery
orderByAddress1($order = Criteria::ASC)

Order by the address1 column

ChildOrderAddressQuery
orderByAddress2($order = Criteria::ASC)

Order by the address2 column

ChildOrderAddressQuery
orderByAddress3($order = Criteria::ASC)

Order by the address3 column

ChildOrderAddressQuery
orderByZipcode($order = Criteria::ASC)

Order by the zipcode column

ChildOrderAddressQuery
orderByCity($order = Criteria::ASC)

Order by the city column

ChildOrderAddressQuery
orderByPhone($order = Criteria::ASC)

Order by the phone column

ChildOrderAddressQuery
orderByCellphone($order = Criteria::ASC)

Order by the cellphone column

ChildOrderAddressQuery
orderByCountryId($order = Criteria::ASC)

Order by the country_id column

ChildOrderAddressQuery
orderByStateId($order = Criteria::ASC)

Order by the state_id column

ChildOrderAddressQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildOrderAddressQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildOrderAddressQuery
groupById()

Group by the id column

ChildOrderAddressQuery
groupByCustomerTitleId()

Group by the customertitleid column

ChildOrderAddressQuery
groupByCompany()

Group by the company column

ChildOrderAddressQuery
groupByFirstname()

Group by the firstname column

ChildOrderAddressQuery
groupByLastname()

Group by the lastname column

ChildOrderAddressQuery
groupByAddress1()

Group by the address1 column

ChildOrderAddressQuery
groupByAddress2()

Group by the address2 column

ChildOrderAddressQuery
groupByAddress3()

Group by the address3 column

ChildOrderAddressQuery
groupByZipcode()

Group by the zipcode column

ChildOrderAddressQuery
groupByCity()

Group by the city column

ChildOrderAddressQuery
groupByPhone()

Group by the phone column

ChildOrderAddressQuery
groupByCellphone()

Group by the cellphone column

ChildOrderAddressQuery
groupByCountryId()

Group by the country_id column

ChildOrderAddressQuery
groupByStateId()

Group by the state_id column

ChildOrderAddressQuery
groupByCreatedAt()

Group by the created_at column

ChildOrderAddressQuery
groupByUpdatedAt()

Group by the updated_at column

ChildOrderAddressQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildOrderAddressQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildOrderAddressQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildOrderAddressQuery
leftJoinCustomerTitle($relationAlias = null)

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

ChildOrderAddressQuery
rightJoinCustomerTitle($relationAlias = null)

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

ChildOrderAddressQuery
innerJoinCustomerTitle($relationAlias = null)

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

ChildOrderAddressQuery
leftJoinCountry($relationAlias = null)

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

ChildOrderAddressQuery
rightJoinCountry($relationAlias = null)

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

ChildOrderAddressQuery
innerJoinCountry($relationAlias = null)

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

ChildOrderAddressQuery
leftJoinState($relationAlias = null)

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

ChildOrderAddressQuery
rightJoinState($relationAlias = null)

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

ChildOrderAddressQuery
innerJoinState($relationAlias = null)

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

ChildOrderAddressQuery
leftJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

ChildOrderAddressQuery
rightJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

ChildOrderAddressQuery
innerJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

ChildOrderAddressQuery
leftJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

ChildOrderAddressQuery
rightJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

ChildOrderAddressQuery
innerJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

ChildOrderAddress
findOne( ConnectionInterface $con = null)

Return the first ChildOrderAddress matching the query

ChildOrderAddress
findOneOrCreate( ConnectionInterface $con = null)

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

ChildOrderAddress
findOneById( int $id)

Return the first ChildOrderAddress filtered by the id column

ChildOrderAddress
findOneByCustomerTitleId( int $customer_title_id)

Return the first ChildOrderAddress filtered by the customertitleid column

ChildOrderAddress
findOneByCompany( string $company)

Return the first ChildOrderAddress filtered by the company column

ChildOrderAddress
findOneByFirstname( string $firstname)

Return the first ChildOrderAddress filtered by the firstname column

ChildOrderAddress
findOneByLastname( string $lastname)

Return the first ChildOrderAddress filtered by the lastname column

ChildOrderAddress
findOneByAddress1( string $address1)

Return the first ChildOrderAddress filtered by the address1 column

ChildOrderAddress
findOneByAddress2( string $address2)

Return the first ChildOrderAddress filtered by the address2 column

ChildOrderAddress
findOneByAddress3( string $address3)

Return the first ChildOrderAddress filtered by the address3 column

ChildOrderAddress
findOneByZipcode( string $zipcode)

Return the first ChildOrderAddress filtered by the zipcode column

ChildOrderAddress
findOneByCity( string $city)

Return the first ChildOrderAddress filtered by the city column

ChildOrderAddress
findOneByPhone( string $phone)

Return the first ChildOrderAddress filtered by the phone column

ChildOrderAddress
findOneByCellphone( string $cellphone)

Return the first ChildOrderAddress filtered by the cellphone column

ChildOrderAddress
findOneByCountryId( int $country_id)

Return the first ChildOrderAddress filtered by the country_id column

ChildOrderAddress
findOneByStateId( int $state_id)

Return the first ChildOrderAddress filtered by the state_id column

ChildOrderAddress
findOneByCreatedAt( string $created_at)

Return the first ChildOrderAddress filtered by the created_at column

ChildOrderAddress
findOneByUpdatedAt( string $updated_at)

Return the first ChildOrderAddress filtered by the updated_at column

array
findById( int $id)

Return ChildOrderAddress objects filtered by the id column

array
findByCustomerTitleId( int $customer_title_id)

Return ChildOrderAddress objects filtered by the customertitleid column

array
findByCompany( string $company)

Return ChildOrderAddress objects filtered by the company column

array
findByFirstname( string $firstname)

Return ChildOrderAddress objects filtered by the firstname column

array
findByLastname( string $lastname)

Return ChildOrderAddress objects filtered by the lastname column

array
findByAddress1( string $address1)

Return ChildOrderAddress objects filtered by the address1 column

array
findByAddress2( string $address2)

Return ChildOrderAddress objects filtered by the address2 column

array
findByAddress3( string $address3)

Return ChildOrderAddress objects filtered by the address3 column

array
findByZipcode( string $zipcode)

Return ChildOrderAddress objects filtered by the zipcode column

array
findByCity( string $city)

Return ChildOrderAddress objects filtered by the city column

array
findByPhone( string $phone)

Return ChildOrderAddress objects filtered by the phone column

array
findByCellphone( string $cellphone)

Return ChildOrderAddress objects filtered by the cellphone column

array
findByCountryId( int $country_id)

Return ChildOrderAddress objects filtered by the country_id column

array
findByStateId( int $state_id)

Return ChildOrderAddress objects filtered by the state_id column

array
findByCreatedAt( string $created_at)

Return ChildOrderAddress objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildOrderAddress objects filtered by the updated_at column

Details

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

Initializes internal state of \Thelia\Model\Base\OrderAddressQuery 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 143
static OrderAddressQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildOrderAddressQuery object.

Parameters

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

Return Value

OrderAddressQuery

at line 173
OrderAddress|array|mixed findPk( mixed $key, ConnectionInterface $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(12, $con);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

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

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

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $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 276
OrderAddressQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

OrderAddressQuery The current query, for fluid interface

at line 289
OrderAddressQuery 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

OrderAddressQuery The current query, for fluid interface

at line 313
OrderAddressQuery 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

OrderAddressQuery The current query, for fluid interface

at line 356
OrderAddressQuery filterByCustomerTitleId( mixed $customerTitleId = null, string $comparison = null)

Filter the query on the customertitleid column

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

Parameters

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

OrderAddressQuery The current query, for fluid interface

See also

filterByCustomerTitle()

at line 394
OrderAddressQuery filterByCompany( string $company = null, string $comparison = null)

Filter the query on the company column

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

Parameters

string $company 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

OrderAddressQuery The current query, for fluid interface

at line 423
OrderAddressQuery filterByFirstname( string $firstname = null, string $comparison = null)

Filter the query on the firstname column

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

Parameters

string $firstname 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

OrderAddressQuery The current query, for fluid interface

at line 452
OrderAddressQuery filterByLastname( string $lastname = null, string $comparison = null)

Filter the query on the lastname column

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

Parameters

string $lastname 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

OrderAddressQuery The current query, for fluid interface

at line 481
OrderAddressQuery filterByAddress1( string $address1 = null, string $comparison = null)

Filter the query on the address1 column

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

Parameters

string $address1 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

OrderAddressQuery The current query, for fluid interface

at line 510
OrderAddressQuery filterByAddress2( string $address2 = null, string $comparison = null)

Filter the query on the address2 column

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

Parameters

string $address2 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

OrderAddressQuery The current query, for fluid interface

at line 539
OrderAddressQuery filterByAddress3( string $address3 = null, string $comparison = null)

Filter the query on the address3 column

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

Parameters

string $address3 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

OrderAddressQuery The current query, for fluid interface

at line 568
OrderAddressQuery filterByZipcode( string $zipcode = null, string $comparison = null)

Filter the query on the zipcode column

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

Parameters

string $zipcode 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

OrderAddressQuery The current query, for fluid interface

at line 597
OrderAddressQuery filterByCity( string $city = null, string $comparison = null)

Filter the query on the city column

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

Parameters

string $city 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

OrderAddressQuery The current query, for fluid interface

at line 626
OrderAddressQuery filterByPhone( string $phone = null, string $comparison = null)

Filter the query on the phone column

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

Parameters

string $phone 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

OrderAddressQuery The current query, for fluid interface

at line 655
OrderAddressQuery filterByCellphone( string $cellphone = null, string $comparison = null)

Filter the query on the cellphone column

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

Parameters

string $cellphone 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

OrderAddressQuery The current query, for fluid interface

at line 689
OrderAddressQuery filterByCountryId( mixed $countryId = null, string $comparison = null)

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

Parameters

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

OrderAddressQuery The current query, for fluid interface

See also

filterByCountry()

at line 732
OrderAddressQuery filterByStateId( mixed $stateId = null, string $comparison = null)

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

Parameters

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

OrderAddressQuery The current query, for fluid interface

See also

filterByState()

at line 775
OrderAddressQuery 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

OrderAddressQuery The current query, for fluid interface

at line 818
OrderAddressQuery 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

OrderAddressQuery The current query, for fluid interface

at line 849
OrderAddressQuery filterByCustomerTitle( CustomerTitle|ObjectCollection $customerTitle, string $comparison = null)

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

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 874
OrderAddressQuery joinCustomerTitle( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the CustomerTitle relation

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 909
CustomerTitleQuery useCustomerTitleQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

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

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

See also

useQuery()

at line 924
OrderAddressQuery filterByCountry( Country|ObjectCollection $country, string $comparison = null)

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

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 949
OrderAddressQuery joinCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Country relation

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 984
CountryQuery useCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 999
OrderAddressQuery filterByState( State|ObjectCollection $state, string $comparison = null)

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

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1024
OrderAddressQuery joinState( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the State relation

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1059
StateQuery useStateQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

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

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

See also

useQuery()

at line 1074
OrderAddressQuery filterByOrderRelatedByInvoiceOrderAddressId( Order|ObjectCollection $order, string $comparison = null)

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

Parameters

Order|ObjectCollection $order the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1097
OrderAddressQuery joinOrderRelatedByInvoiceOrderAddressId( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the OrderRelatedByInvoiceOrderAddressId relation

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1132
OrderQuery useOrderRelatedByInvoiceOrderAddressIdQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the OrderRelatedByInvoiceOrderAddressId relation Order 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

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

See also

useQuery()

at line 1147
OrderAddressQuery filterByOrderRelatedByDeliveryOrderAddressId( Order|ObjectCollection $order, string $comparison = null)

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

Parameters

Order|ObjectCollection $order the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1170
OrderAddressQuery joinOrderRelatedByDeliveryOrderAddressId( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the OrderRelatedByDeliveryOrderAddressId relation

Parameters

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

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1205
OrderQuery useOrderRelatedByDeliveryOrderAddressIdQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the OrderRelatedByDeliveryOrderAddressId relation Order 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

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

See also

useQuery()

at line 1219
OrderAddressQuery prune( OrderAddress $orderAddress = null)

Exclude object from result

Parameters

OrderAddress $orderAddress Object to remove from the list of results

Return Value

OrderAddressQuery The current query, for fluid interface

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

Deletes all rows from the order_address table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

Performs a DELETE on the database, given a ChildOrderAddress 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 1312
OrderAddressQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1324
OrderAddressQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1334
OrderAddressQuery lastUpdatedFirst()

Order by update date desc

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1344
OrderAddressQuery firstUpdatedFirst()

Order by update date asc

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1354
OrderAddressQuery lastCreatedFirst()

Order by create date desc

Return Value

OrderAddressQuery The current query, for fluid interface

at line 1364
OrderAddressQuery firstCreatedFirst()

Order by create date asc

Return Value

OrderAddressQuery The current query, for fluid interface

at line 120
ChildOrderAddressQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCustomerTitleId($order = Criteria::ASC)

Order by the customertitleid column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCompany($order = Criteria::ASC)

Order by the company column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByFirstname($order = Criteria::ASC)

Order by the firstname column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByLastname($order = Criteria::ASC)

Order by the lastname column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByAddress1($order = Criteria::ASC)

Order by the address1 column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByAddress2($order = Criteria::ASC)

Order by the address2 column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByAddress3($order = Criteria::ASC)

Order by the address3 column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByZipcode($order = Criteria::ASC)

Order by the zipcode column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCity($order = Criteria::ASC)

Order by the city column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByPhone($order = Criteria::ASC)

Order by the phone column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCellphone($order = Criteria::ASC)

Order by the cellphone column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCountryId($order = Criteria::ASC)

Order by the country_id column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByStateId($order = Criteria::ASC)

Order by the state_id column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupById()

Group by the id column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCustomerTitleId()

Group by the customertitleid column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCompany()

Group by the company column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByFirstname()

Group by the firstname column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByLastname()

Group by the lastname column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByAddress1()

Group by the address1 column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByAddress2()

Group by the address2 column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByAddress3()

Group by the address3 column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByZipcode()

Group by the zipcode column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCity()

Group by the city column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByPhone()

Group by the phone column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCellphone()

Group by the cellphone column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCountryId()

Group by the country_id column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByStateId()

Group by the state_id column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoinCustomerTitle($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoinCustomerTitle($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoinCustomerTitle($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoinOrderRelatedByInvoiceOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery leftJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery rightJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddressQuery innerJoinOrderRelatedByDeliveryOrderAddressId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildOrderAddressQuery

at line 120
ChildOrderAddress findOne( ConnectionInterface $con = null)

Return the first ChildOrderAddress matching the query

Parameters

ConnectionInterface $con

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneById( int $id)

Return the first ChildOrderAddress filtered by the id column

Parameters

int $id

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCustomerTitleId( int $customer_title_id)

Return the first ChildOrderAddress filtered by the customertitleid column

Parameters

int $customer_title_id

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCompany( string $company)

Return the first ChildOrderAddress filtered by the company column

Parameters

string $company

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByFirstname( string $firstname)

Return the first ChildOrderAddress filtered by the firstname column

Parameters

string $firstname

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByLastname( string $lastname)

Return the first ChildOrderAddress filtered by the lastname column

Parameters

string $lastname

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByAddress1( string $address1)

Return the first ChildOrderAddress filtered by the address1 column

Parameters

string $address1

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByAddress2( string $address2)

Return the first ChildOrderAddress filtered by the address2 column

Parameters

string $address2

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByAddress3( string $address3)

Return the first ChildOrderAddress filtered by the address3 column

Parameters

string $address3

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByZipcode( string $zipcode)

Return the first ChildOrderAddress filtered by the zipcode column

Parameters

string $zipcode

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCity( string $city)

Return the first ChildOrderAddress filtered by the city column

Parameters

string $city

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByPhone( string $phone)

Return the first ChildOrderAddress filtered by the phone column

Parameters

string $phone

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCellphone( string $cellphone)

Return the first ChildOrderAddress filtered by the cellphone column

Parameters

string $cellphone

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCountryId( int $country_id)

Return the first ChildOrderAddress filtered by the country_id column

Parameters

int $country_id

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByStateId( int $state_id)

Return the first ChildOrderAddress filtered by the state_id column

Parameters

int $state_id

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByCreatedAt( string $created_at)

Return the first ChildOrderAddress filtered by the created_at column

Parameters

string $created_at

Return Value

ChildOrderAddress

at line 120
ChildOrderAddress findOneByUpdatedAt( string $updated_at)

Return the first ChildOrderAddress filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildOrderAddress

at line 120
array findById( int $id)

Return ChildOrderAddress objects filtered by the id column

Parameters

int $id

Return Value

array

at line 120
array findByCustomerTitleId( int $customer_title_id)

Return ChildOrderAddress objects filtered by the customertitleid column

Parameters

int $customer_title_id

Return Value

array

at line 120
array findByCompany( string $company)

Return ChildOrderAddress objects filtered by the company column

Parameters

string $company

Return Value

array

at line 120
array findByFirstname( string $firstname)

Return ChildOrderAddress objects filtered by the firstname column

Parameters

string $firstname

Return Value

array

at line 120
array findByLastname( string $lastname)

Return ChildOrderAddress objects filtered by the lastname column

Parameters

string $lastname

Return Value

array

at line 120
array findByAddress1( string $address1)

Return ChildOrderAddress objects filtered by the address1 column

Parameters

string $address1

Return Value

array

at line 120
array findByAddress2( string $address2)

Return ChildOrderAddress objects filtered by the address2 column

Parameters

string $address2

Return Value

array

at line 120
array findByAddress3( string $address3)

Return ChildOrderAddress objects filtered by the address3 column

Parameters

string $address3

Return Value

array

at line 120
array findByZipcode( string $zipcode)

Return ChildOrderAddress objects filtered by the zipcode column

Parameters

string $zipcode

Return Value

array

at line 120
array findByCity( string $city)

Return ChildOrderAddress objects filtered by the city column

Parameters

string $city

Return Value

array

at line 120
array findByPhone( string $phone)

Return ChildOrderAddress objects filtered by the phone column

Parameters

string $phone

Return Value

array

at line 120
array findByCellphone( string $cellphone)

Return ChildOrderAddress objects filtered by the cellphone column

Parameters

string $cellphone

Return Value

array

at line 120
array findByCountryId( int $country_id)

Return ChildOrderAddress objects filtered by the country_id column

Parameters

int $country_id

Return Value

array

at line 120
array findByStateId( int $state_id)

Return ChildOrderAddress objects filtered by the state_id column

Parameters

int $state_id

Return Value

array

at line 120
array findByCreatedAt( string $created_at)

Return ChildOrderAddress objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 120
array findByUpdatedAt( string $updated_at)

Return ChildOrderAddress objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array