CustomerTitleQuery
class CustomerTitleQuery extends CustomerTitleQuery
Skeleton subclass for performing query and update operations on the 'customer_title' table.
You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.
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
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
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
in
CustomerTitleQuery at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CustomerTitle',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CustomerTitleQuery object.
in
CustomerTitleQuery at line 96
static
CustomerTitleQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCustomerTitleQuery object.
in
CustomerTitleQuery 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);
in
CustomerTitleQuery 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);
in
CustomerTitleQuery at line 229
CustomerTitleQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
CustomerTitleQuery at line 242
CustomerTitleQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CustomerTitleQuery 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
in
CustomerTitleQuery 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
in
CustomerTitleQuery 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%'
in
CustomerTitleQuery 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'
in
CustomerTitleQuery 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'
in
CustomerTitleQuery at line 453
CustomerTitleQuery
filterByCustomer(
Customer|ObjectCollection $customer,
string $comparison = null)
Filter the query by a related \Thelia\Model\Customer object
in
CustomerTitleQuery at line 476
CustomerTitleQuery
joinCustomer(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Customer relation
in
CustomerTitleQuery at line 511
CustomerQuery
useCustomerQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Customer relation Customer object
in
CustomerTitleQuery at line 526
CustomerTitleQuery
filterByAddress(
Address|ObjectCollection $address,
string $comparison = null)
Filter the query by a related \Thelia\Model\Address object
in
CustomerTitleQuery at line 549
CustomerTitleQuery
joinAddress(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Address relation
in
CustomerTitleQuery at line 584
AddressQuery
useAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Address relation Address object
in
CustomerTitleQuery at line 599
CustomerTitleQuery
filterByOrderAddress(
OrderAddress|ObjectCollection $orderAddress,
string $comparison = null)
Filter the query by a related \Thelia\Model\OrderAddress object
in
CustomerTitleQuery at line 622
CustomerTitleQuery
joinOrderAddress(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the OrderAddress relation
in
CustomerTitleQuery at line 657
OrderAddressQuery
useOrderAddressQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the OrderAddress relation OrderAddress object
in
CustomerTitleQuery at line 672
CustomerTitleQuery
filterByCustomerTitleI18n(
CustomerTitleI18n|ObjectCollection $customerTitleI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\CustomerTitleI18n object
in
CustomerTitleQuery at line 695
CustomerTitleQuery
joinCustomerTitleI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the CustomerTitleI18n relation
in
CustomerTitleQuery at line 730
CustomerTitleI18nQuery
useCustomerTitleI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the CustomerTitleI18n relation CustomerTitleI18n object
in
CustomerTitleQuery at line 744
CustomerTitleQuery
prune(
CustomerTitle $customerTitle = null)
Exclude object from result
in
CustomerTitleQuery at line 759
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the customer_title table.
in
CustomerTitleQuery 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.
in
CustomerTitleQuery at line 837
CustomerTitleQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
CustomerTitleQuery at line 849
CustomerTitleQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
CustomerTitleQuery at line 859
CustomerTitleQuery
lastUpdatedFirst()
Order by update date desc
in
CustomerTitleQuery at line 869
CustomerTitleQuery
firstUpdatedFirst()
Order by update date asc
in
CustomerTitleQuery at line 879
CustomerTitleQuery
lastCreatedFirst()
Order by create date desc
in
CustomerTitleQuery at line 889
CustomerTitleQuery
firstCreatedFirst()
Order by create date asc
in
CustomerTitleQuery 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
in
CustomerTitleQuery 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()
in
CustomerTitleQuery at line 944
CustomerTitleI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
orderByByDefault($order = Criteria::ASC)
Order by the by_default column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
groupById()
Group by the id column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
groupByByDefault()
Group by the by_default column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
groupByPosition()
Group by the position column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
groupByCreatedAt()
Group by the created_at column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
groupByUpdatedAt()
Group by the updated_at column
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
leftJoinCustomer($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Customer relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
rightJoinCustomer($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Customer relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
innerJoinCustomer($relationAlias = null)
Adds a INNER JOIN clause to the query using the Customer relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
leftJoinAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Address relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
rightJoinAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Address relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
innerJoinAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the Address relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
leftJoinOrderAddress($relationAlias = null)
Adds a LEFT JOIN clause to the query using the OrderAddress relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
rightJoinOrderAddress($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the OrderAddress relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
innerJoinOrderAddress($relationAlias = null)
Adds a INNER JOIN clause to the query using the OrderAddress relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
leftJoinCustomerTitleI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CustomerTitleI18n relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
rightJoinCustomerTitleI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CustomerTitleI18n relation
in
CustomerTitleQuery at line 73
ChildCustomerTitleQuery
innerJoinCustomerTitleI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the CustomerTitleI18n relation
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOne(
ConnectionInterface $con = null)
Return the first ChildCustomerTitle matching the query
in
CustomerTitleQuery 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
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOneById(
int $id)
Return the first ChildCustomerTitle filtered by the id column
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOneByByDefault(
int $by_default)
Return the first ChildCustomerTitle filtered by the by_default column
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOneByPosition(
string $position)
Return the first ChildCustomerTitle filtered by the position column
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOneByCreatedAt(
string $created_at)
Return the first ChildCustomerTitle filtered by the created_at column
in
CustomerTitleQuery at line 73
ChildCustomerTitle
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCustomerTitle filtered by the updated_at column
in
CustomerTitleQuery at line 73
array
findById(
int $id)
Return ChildCustomerTitle objects filtered by the id column
in
CustomerTitleQuery at line 73
array
findByByDefault(
int $by_default)
Return ChildCustomerTitle objects filtered by the by_default column
in
CustomerTitleQuery at line 73
array
findByPosition(
string $position)
Return ChildCustomerTitle objects filtered by the position column
in
CustomerTitleQuery at line 73
array
findByCreatedAt(
string $created_at)
Return ChildCustomerTitle objects filtered by the created_at column
in
CustomerTitleQuery at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildCustomerTitle objects filtered by the updated_at column