OrderStatusQuery
class OrderStatusQuery extends ModelCriteria
Base class that represents a query for the 'order_status' table.
Methods
Initializes internal state of \Thelia\Model\Base\OrderStatusQuery object.
Returns a new ChildOrderStatusQuery 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 code column
Filter the query on the color column
Filter the query on the position column
Filter the query on the protected_status 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\Order object
Adds a JOIN clause to the query using the Order relation
Use the Order relation Order object
Filter the query by a related \Thelia\Model\OrderStatusI18n object
Adds a JOIN clause to the query using the OrderStatusI18n relation
Use the OrderStatusI18n relation OrderStatusI18n object
Deletes all rows from the order_status table.
Performs a DELETE on the database, given a ChildOrderStatus 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 code column
Order by the color column
Order by the position column
Order by the protected_status column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the code column
Group by the color column
Group by the position column
Group by the protected_status 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 Order relation
Adds a RIGHT JOIN clause to the query using the Order relation
Adds a INNER JOIN clause to the query using the Order relation
Adds a LEFT JOIN clause to the query using the OrderStatusI18n relation
Adds a RIGHT JOIN clause to the query using the OrderStatusI18n relation
Adds a INNER JOIN clause to the query using the OrderStatusI18n relation
Return the first ChildOrderStatus matching the query
Return the first ChildOrderStatus matching the query, or a new ChildOrderStatus object populated from the query conditions when no match is found
Return the first ChildOrderStatus filtered by the id column
Return the first ChildOrderStatus filtered by the code column
Return the first ChildOrderStatus filtered by the color column
Return the first ChildOrderStatus filtered by the position column
Return the first ChildOrderStatus filtered by the protected_status column
Return the first ChildOrderStatus filtered by the created_at column
Return the first ChildOrderStatus filtered by the updated_at column
Return ChildOrderStatus objects filtered by the id column
Return ChildOrderStatus objects filtered by the code column
Return ChildOrderStatus objects filtered by the color column
Return ChildOrderStatus objects filtered by the position column
Return ChildOrderStatus objects filtered by the protected_status column
Return ChildOrderStatus objects filtered by the created_at column
Return ChildOrderStatus objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\OrderStatus',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\OrderStatusQuery object.
at line 96
static
OrderStatusQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildOrderStatusQuery object.
at line 126
OrderStatus|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
OrderStatusQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
OrderStatusQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
OrderStatusQuery
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 304
OrderStatusQuery
filterByCode(
string $code = null,
string $comparison = null)
Filter the query on the code column
Example usage:
$query->filterByCode('fooValue'); // WHERE code = 'fooValue'
$query->filterByCode('%fooValue%'); // WHERE code LIKE '%fooValue%'
at line 333
OrderStatusQuery
filterByColor(
string $color = null,
string $comparison = null)
Filter the query on the color column
Example usage:
$query->filterByColor('fooValue'); // WHERE color = 'fooValue'
$query->filterByColor('%fooValue%'); // WHERE color LIKE '%fooValue%'
at line 365
OrderStatusQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition(1234); // WHERE position = 1234
$query->filterByPosition(array(12, 34)); // WHERE position IN (12, 34)
$query->filterByPosition(array('min' => 12)); // WHERE position > 12
at line 406
OrderStatusQuery
filterByProtectedStatus(
boolean|string $protectedStatus = null,
string $comparison = null)
Filter the query on the protected_status column
Example usage:
$query->filterByProtectedStatus(true); // WHERE protectedstatus = true
$query->filterByProtectedStatus('yes'); // WHERE protectedstatus = true
at line 435
OrderStatusQuery
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 478
OrderStatusQuery
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 509
OrderStatusQuery
filterByOrder(
Order|ObjectCollection $order,
string $comparison = null)
Filter the query by a related \Thelia\Model\Order object
at line 532
OrderStatusQuery
joinOrder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Order relation
at line 567
OrderQuery
useOrderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Order relation Order object
at line 582
OrderStatusQuery
filterByOrderStatusI18n(
OrderStatusI18n|ObjectCollection $orderStatusI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\OrderStatusI18n object
at line 605
OrderStatusQuery
joinOrderStatusI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the OrderStatusI18n relation
at line 640
OrderStatusI18nQuery
useOrderStatusI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the OrderStatusI18n relation OrderStatusI18n object
at line 654
OrderStatusQuery
prune(
OrderStatus $orderStatus = null)
Exclude object from result
at line 669
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the order_status table.
at line 706
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildOrderStatus or Criteria object OR a primary key value.
at line 747
OrderStatusQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 759
OrderStatusQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 769
OrderStatusQuery
lastUpdatedFirst()
Order by update date desc
at line 779
OrderStatusQuery
firstUpdatedFirst()
Order by update date asc
at line 789
OrderStatusQuery
lastCreatedFirst()
Order by create date desc
at line 799
OrderStatusQuery
firstCreatedFirst()
Order by create date asc
at line 815
OrderStatusQuery
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 833
OrderStatusQuery
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 854
OrderStatusI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildOrderStatusQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildOrderStatusQuery
orderByCode($order = Criteria::ASC)
Order by the code column
at line 73
ChildOrderStatusQuery
orderByColor($order = Criteria::ASC)
Order by the color column
at line 73
ChildOrderStatusQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildOrderStatusQuery
orderByProtectedStatus($order = Criteria::ASC)
Order by the protected_status column
at line 73
ChildOrderStatusQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildOrderStatusQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildOrderStatusQuery
groupById()
Group by the id column
at line 73
ChildOrderStatusQuery
groupByCode()
Group by the code column
at line 73
ChildOrderStatusQuery
groupByColor()
Group by the color column
at line 73
ChildOrderStatusQuery
groupByPosition()
Group by the position column
at line 73
ChildOrderStatusQuery
groupByProtectedStatus()
Group by the protected_status column
at line 73
ChildOrderStatusQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildOrderStatusQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildOrderStatusQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildOrderStatusQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildOrderStatusQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildOrderStatusQuery
leftJoinOrder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Order relation
at line 73
ChildOrderStatusQuery
rightJoinOrder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Order relation
at line 73
ChildOrderStatusQuery
innerJoinOrder($relationAlias = null)
Adds a INNER JOIN clause to the query using the Order relation
at line 73
ChildOrderStatusQuery
leftJoinOrderStatusI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the OrderStatusI18n relation
at line 73
ChildOrderStatusQuery
rightJoinOrderStatusI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the OrderStatusI18n relation
at line 73
ChildOrderStatusQuery
innerJoinOrderStatusI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the OrderStatusI18n relation
at line 73
ChildOrderStatus
findOne(
ConnectionInterface $con = null)
Return the first ChildOrderStatus matching the query
at line 73
ChildOrderStatus
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildOrderStatus matching the query, or a new ChildOrderStatus object populated from the query conditions when no match is found
at line 73
ChildOrderStatus
findOneById(
int $id)
Return the first ChildOrderStatus filtered by the id column
at line 73
ChildOrderStatus
findOneByCode(
string $code)
Return the first ChildOrderStatus filtered by the code column
at line 73
ChildOrderStatus
findOneByColor(
string $color)
Return the first ChildOrderStatus filtered by the color column
at line 73
ChildOrderStatus
findOneByPosition(
int $position)
Return the first ChildOrderStatus filtered by the position column
at line 73
ChildOrderStatus
findOneByProtectedStatus(
boolean $protected_status)
Return the first ChildOrderStatus filtered by the protected_status column
at line 73
ChildOrderStatus
findOneByCreatedAt(
string $created_at)
Return the first ChildOrderStatus filtered by the created_at column
at line 73
ChildOrderStatus
findOneByUpdatedAt(
string $updated_at)
Return the first ChildOrderStatus filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildOrderStatus objects filtered by the id column
at line 73
array
findByCode(
string $code)
Return ChildOrderStatus objects filtered by the code column
at line 73
array
findByColor(
string $color)
Return ChildOrderStatus objects filtered by the color column
at line 73
array
findByPosition(
int $position)
Return ChildOrderStatus objects filtered by the position column
at line 73
array
findByProtectedStatus(
boolean $protected_status)
Return ChildOrderStatus objects filtered by the protected_status column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildOrderStatus objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildOrderStatus objects filtered by the updated_at column