CustomerTitleQuery
class CustomerTitleQuery extends ModelCriteria
Base class that represents a query for the 'customer_title' table.
Methods
Initializes internal state of \Thelia\Model\Base\CustomerTitleQuery object.
Returns a new ChildCustomerTitleQuery object.
Find object by primary key.
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
Filter the query on the by_default column
Filter the query on the position column
Filter the query on the created_at column
Filter the query on the updated_at column
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\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\OrderAddress object
Adds a JOIN clause to the query using the OrderAddress relation
Use the OrderAddress relation OrderAddress object
Filter the query by a related \Thelia\Model\CustomerTitleI18n object
Adds a JOIN clause to the query using the CustomerTitleI18n relation
Use the CustomerTitleI18n relation CustomerTitleI18n object
Deletes all rows from the customer_title table.
Performs a DELETE on the database, given a ChildCustomerTitle 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
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Order by the id column
Order by the by_default column
Order by the position column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the by_default column
Group by the position 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 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 OrderAddress relation
Adds a RIGHT JOIN clause to the query using the OrderAddress relation
Adds a INNER JOIN clause to the query using the OrderAddress relation
Adds a LEFT JOIN clause to the query using the CustomerTitleI18n relation
Adds a RIGHT JOIN clause to the query using the CustomerTitleI18n relation
Adds a INNER JOIN clause to the query using the CustomerTitleI18n relation
Return the first ChildCustomerTitle matching the query
Return the first ChildCustomerTitle matching the query, or a new ChildCustomerTitle object populated from the query conditions when no match is found
Return the first ChildCustomerTitle filtered by the id column
Return the first ChildCustomerTitle filtered by the by_default column
Return the first ChildCustomerTitle filtered by the position column
Return the first ChildCustomerTitle filtered by the created_at column
Return the first ChildCustomerTitle filtered by the updated_at column
Return ChildCustomerTitle objects filtered by the id column
Return ChildCustomerTitle objects filtered by the by_default column
Return ChildCustomerTitle objects filtered by the position column
Return ChildCustomerTitle objects filtered by the created_at column
Return ChildCustomerTitle objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CustomerTitle',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CustomerTitleQuery object.
at line 96
static
CustomerTitleQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCustomerTitleQuery object.
at line 126
CustomerTitle|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);
at line 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 229
CustomerTitleQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
CustomerTitleQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
CustomerTitleQuery
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
at line 307
CustomerTitleQuery
filterByByDefault(
mixed $byDefault = null,
string $comparison = null)
Filter the query on the by_default column
Example usage:
$query->filterByByDefault(1234); // WHERE bydefault = 1234
$query->filterByByDefault(array(12, 34)); // WHERE bydefault IN (12, 34)
$query->filterByByDefault(array('min' => 12)); // WHERE by_default > 12
at line 345
CustomerTitleQuery
filterByPosition(
string $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition('fooValue'); // WHERE position = 'fooValue'
$query->filterByPosition('%fooValue%'); // WHERE position LIKE '%fooValue%'
at line 379
CustomerTitleQuery
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'
at line 422
CustomerTitleQuery
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'
at line 453
CustomerTitleQuery
filterByCustomer(
Customer|ObjectCollection $customer,
string $comparison = null)
Filter the query by a related \Thelia\Model\Customer object
at line 476
CustomerTitleQuery
joinCustomer(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Customer relation
at line 511
CustomerQuery
useCustomerQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Customer relation Customer object
at line 526
CustomerTitleQuery
filterByAddress(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
at line 549
CustomerTitleQuery
joinAddress(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Address relation
at line 584
AddressQuery
useAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Address relation Address object
at line 599
CustomerTitleQuery
filterByOrderAddress(
OrderAddress|ObjectCollection $orderAddress,
string $comparison = null)
Filter the query by a related \Thelia\Model\OrderAddress object
at line 622
CustomerTitleQuery
joinOrderAddress(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the OrderAddress relation
at line 657
OrderAddressQuery
useOrderAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the OrderAddress relation OrderAddress object
at line 672
CustomerTitleQuery
filterByCustomerTitleI18n(
CustomerTitleI18n|ObjectCollection $customerTitleI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\CustomerTitleI18n object
at line 695
CustomerTitleQuery
joinCustomerTitleI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the CustomerTitleI18n relation
at line 730
CustomerTitleI18nQuery
useCustomerTitleI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the CustomerTitleI18n relation CustomerTitleI18n object
at line 744
CustomerTitleQuery
prune(
CustomerTitle $customerTitle = null)
Exclude object from result
at line 759
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the customer_title table.
at line 796
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCustomerTitle or Criteria object OR a primary key value.
at line 837
CustomerTitleQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 849
CustomerTitleQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 859
CustomerTitleQuery
lastUpdatedFirst()
Order by update date desc
at line 869
CustomerTitleQuery
firstUpdatedFirst()
Order by update date asc
at line 879
CustomerTitleQuery
lastCreatedFirst()
Order by create date desc
at line 889
CustomerTitleQuery
firstCreatedFirst()
Order by create date asc
at line 905
CustomerTitleQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
at line 923
CustomerTitleQuery
joinWithI18n(
string $locale = 'en_US',
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query and hydrates the related I18n object.
Shortcut for $c->joinI18n($locale)->with()
at line 944
CustomerTitleI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildCustomerTitleQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildCustomerTitleQuery
orderByByDefault($order = Criteria::ASC)
Order by the by_default column
at line 73
ChildCustomerTitleQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildCustomerTitleQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildCustomerTitleQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildCustomerTitleQuery
groupById()
Group by the id column
at line 73
ChildCustomerTitleQuery
groupByByDefault()
Group by the by_default column
at line 73
ChildCustomerTitleQuery
groupByPosition()
Group by the position column
at line 73
ChildCustomerTitleQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildCustomerTitleQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildCustomerTitleQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildCustomerTitleQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildCustomerTitleQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildCustomerTitleQuery
leftJoinCustomer($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Customer relation
at line 73
ChildCustomerTitleQuery
rightJoinCustomer($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Customer relation
at line 73
ChildCustomerTitleQuery
innerJoinCustomer($relationAlias = null)
Adds a INNER JOIN clause to the query using the Customer relation
at line 73
ChildCustomerTitleQuery
leftJoinAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Address relation
at line 73
ChildCustomerTitleQuery
rightJoinAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Address relation
at line 73
ChildCustomerTitleQuery
innerJoinAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the Address relation
at line 73
ChildCustomerTitleQuery
leftJoinOrderAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the OrderAddress relation
at line 73
ChildCustomerTitleQuery
rightJoinOrderAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the OrderAddress relation
at line 73
ChildCustomerTitleQuery
innerJoinOrderAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the OrderAddress relation
at line 73
ChildCustomerTitleQuery
leftJoinCustomerTitleI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CustomerTitleI18n relation
at line 73
ChildCustomerTitleQuery
rightJoinCustomerTitleI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CustomerTitleI18n relation
at line 73
ChildCustomerTitleQuery
innerJoinCustomerTitleI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the CustomerTitleI18n relation
at line 73
ChildCustomerTitle
findOne(
ConnectionInterface $con = null)
Return the first ChildCustomerTitle matching the query
at line 73
ChildCustomerTitle
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCustomerTitle matching the query, or a new ChildCustomerTitle object populated from the query conditions when no match is found
at line 73
ChildCustomerTitle
findOneById(
int $id)
Return the first ChildCustomerTitle filtered by the id column
at line 73
ChildCustomerTitle
findOneByByDefault(
int $by_default)
Return the first ChildCustomerTitle filtered by the by_default column
at line 73
ChildCustomerTitle
findOneByPosition(
string $position)
Return the first ChildCustomerTitle filtered by the position column
at line 73
ChildCustomerTitle
findOneByCreatedAt(
string $created_at)
Return the first ChildCustomerTitle filtered by the created_at column
at line 73
ChildCustomerTitle
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCustomerTitle filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildCustomerTitle objects filtered by the id column
at line 73
array
findByByDefault(
int $by_default)
Return ChildCustomerTitle objects filtered by the by_default column
at line 73
array
findByPosition(
string $position)
Return ChildCustomerTitle objects filtered by the position column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildCustomerTitle objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildCustomerTitle objects filtered by the updated_at column