BrandQuery
class BrandQuery extends BrandQuery
Skeleton subclass for performing query and update operations on the 'brand' 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\BrandQuery object.
Returns a new ChildBrandQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the logoimageid 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\BrandImage object
Adds a JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
Use the BrandImageRelatedByLogoImageId relation BrandImage object
Filter the query by a related \Thelia\Model\Product object
Adds a JOIN clause to the query using the Product relation
Use the Product relation Product object
Filter the query by a related \Thelia\Model\BrandDocument object
Adds a JOIN clause to the query using the BrandDocument relation
Use the BrandDocument relation BrandDocument object
Filter the query by a related \Thelia\Model\BrandImage object
Adds a JOIN clause to the query using the BrandImageRelatedByBrandId relation
Use the BrandImageRelatedByBrandId relation BrandImage object
Filter the query by a related \Thelia\Model\BrandI18n object
Adds a JOIN clause to the query using the BrandI18n relation
Use the BrandI18n relation BrandI18n object
Deletes all rows from the brand table.
Performs a DELETE on the database, given a ChildBrand or Criteria object OR a primary key value.
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 position column
Order by the logoimageid column
Order by the created_at column
Order by the updated_at column
Adds a LEFT JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
Adds a RIGHT JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
Adds a INNER JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
Adds a LEFT JOIN clause to the query using the Product relation
Adds a RIGHT JOIN clause to the query using the Product relation
Adds a INNER JOIN clause to the query using the Product relation
Adds a LEFT JOIN clause to the query using the BrandDocument relation
Adds a RIGHT JOIN clause to the query using the BrandDocument relation
Adds a INNER JOIN clause to the query using the BrandDocument relation
Adds a LEFT JOIN clause to the query using the BrandImageRelatedByBrandId relation
Adds a RIGHT JOIN clause to the query using the BrandImageRelatedByBrandId relation
Adds a INNER JOIN clause to the query using the BrandImageRelatedByBrandId relation
Adds a LEFT JOIN clause to the query using the BrandI18n relation
Adds a RIGHT JOIN clause to the query using the BrandI18n relation
Adds a INNER JOIN clause to the query using the BrandI18n relation
Return the first ChildBrand matching the query
Return the first ChildBrand matching the query, or a new ChildBrand object populated from the query conditions when no match is found
Return the first ChildBrand filtered by the id column
Return the first ChildBrand filtered by the visible column
Return the first ChildBrand filtered by the position column
Return the first ChildBrand filtered by the logoimageid column
Return the first ChildBrand filtered by the created_at column
Return the first ChildBrand filtered by the updated_at column
Return ChildBrand objects filtered by the visible column
Return ChildBrand objects filtered by the position column
Return ChildBrand objects filtered by the logoimageid column
Return ChildBrand objects filtered by the created_at column
Return ChildBrand objects filtered by the updated_at column
Details
in
BrandQuery at line 91
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Brand',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\BrandQuery object.
in
BrandQuery at line 104
static
BrandQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildBrandQuery object.
in
BrandQuery at line 134
Brand|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
BrandQuery at line 216
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
BrandQuery at line 237
BrandQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
BrandQuery at line 250
BrandQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
BrandQuery at line 274
BrandQuery
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
BrandQuery at line 315
BrandQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
in
BrandQuery at line 356
BrandQuery
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
in
BrandQuery at line 399
BrandQuery
filterByLogoImageId(
mixed $logoImageId = null,
string $comparison = null)
Filter the query on the logoimageid column
Example usage:
$query->filterByLogoImageId(1234); // WHERE logoimageid = 1234
$query->filterByLogoImageId(array(12, 34)); // WHERE logoimageid IN (12, 34)
$query->filterByLogoImageId(array('min' => 12)); // WHERE logoimageid > 12
in
BrandQuery at line 442
BrandQuery
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
BrandQuery at line 485
BrandQuery
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
BrandQuery at line 516
BrandQuery
filterByBrandImageRelatedByLogoImageId(
BrandImage|ObjectCollection $brandImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\BrandImage object
in
BrandQuery at line 541
BrandQuery
joinBrandImageRelatedByLogoImageId(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
in
BrandQuery at line 576
BrandImageQuery
useBrandImageRelatedByLogoImageIdQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the BrandImageRelatedByLogoImageId relation BrandImage object
in
BrandQuery at line 591
BrandQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
in
BrandQuery at line 614
BrandQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Product relation
in
BrandQuery at line 649
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Product relation Product object
in
BrandQuery at line 664
BrandQuery
filterByBrandDocument(
BrandDocument|ObjectCollection $brandDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\BrandDocument object
in
BrandQuery at line 687
BrandQuery
joinBrandDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the BrandDocument relation
in
BrandQuery at line 722
BrandDocumentQuery
useBrandDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the BrandDocument relation BrandDocument object
in
BrandQuery at line 737
BrandQuery
filterByBrandImageRelatedByBrandId(
BrandImage|ObjectCollection $brandImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\BrandImage object
in
BrandQuery at line 760
BrandQuery
joinBrandImageRelatedByBrandId(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the BrandImageRelatedByBrandId relation
in
BrandQuery at line 795
BrandImageQuery
useBrandImageRelatedByBrandIdQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the BrandImageRelatedByBrandId relation BrandImage object
in
BrandQuery at line 810
BrandQuery
filterByBrandI18n(
BrandI18n|ObjectCollection $brandI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\BrandI18n object
in
BrandQuery at line 833
BrandQuery
joinBrandI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the BrandI18n relation
in
BrandQuery at line 868
BrandI18nQuery
useBrandI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the BrandI18n relation BrandI18n object
in
BrandQuery at line 882
BrandQuery
prune(
Brand $brand = null)
Exclude object from result
in
BrandQuery at line 897
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the brand table.
in
BrandQuery at line 934
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildBrand or Criteria object OR a primary key value.
in
BrandQuery at line 975
BrandQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
BrandQuery at line 987
BrandQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
BrandQuery at line 997
BrandQuery
lastUpdatedFirst()
Order by update date desc
in
BrandQuery at line 1007
BrandQuery
firstUpdatedFirst()
Order by update date asc
in
BrandQuery at line 1017
BrandQuery
lastCreatedFirst()
Order by create date desc
in
BrandQuery at line 1027
BrandQuery
firstCreatedFirst()
Order by create date asc
in
BrandQuery at line 1043
BrandQuery
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
BrandQuery at line 1061
BrandQuery
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
BrandQuery at line 1082
BrandI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
BrandQuery at line 81
ChildBrandQuery
orderById($order = Criteria::ASC)
Order by the id column
in
BrandQuery at line 81
ChildBrandQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
BrandQuery at line 81
ChildBrandQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
BrandQuery at line 81
ChildBrandQuery
orderByLogoImageId($order = Criteria::ASC)
Order by the logoimageid column
in
BrandQuery at line 81
ChildBrandQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
BrandQuery at line 81
ChildBrandQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
BrandQuery at line 81
ChildBrandQuery
groupById()
Group by the id column
in
BrandQuery at line 81
ChildBrandQuery
groupByVisible()
Group by the visible column
in
BrandQuery at line 81
ChildBrandQuery
groupByPosition()
Group by the position column
in
BrandQuery at line 81
ChildBrandQuery
groupByLogoImageId()
Group by the logoimageid column
in
BrandQuery at line 81
ChildBrandQuery
groupByCreatedAt()
Group by the created_at column
in
BrandQuery at line 81
ChildBrandQuery
groupByUpdatedAt()
Group by the updated_at column
in
BrandQuery at line 81
ChildBrandQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
BrandQuery at line 81
ChildBrandQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
BrandQuery at line 81
ChildBrandQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
BrandQuery at line 81
ChildBrandQuery
leftJoinBrandImageRelatedByLogoImageId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
in
BrandQuery at line 81
ChildBrandQuery
rightJoinBrandImageRelatedByLogoImageId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
in
BrandQuery at line 81
ChildBrandQuery
innerJoinBrandImageRelatedByLogoImageId($relationAlias = null)
Adds a INNER JOIN clause to the query using the BrandImageRelatedByLogoImageId relation
in
BrandQuery at line 81
ChildBrandQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
in
BrandQuery at line 81
ChildBrandQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
in
BrandQuery at line 81
ChildBrandQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
in
BrandQuery at line 81
ChildBrandQuery
leftJoinBrandDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the BrandDocument relation
in
BrandQuery at line 81
ChildBrandQuery
rightJoinBrandDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the BrandDocument relation
in
BrandQuery at line 81
ChildBrandQuery
innerJoinBrandDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the BrandDocument relation
in
BrandQuery at line 81
ChildBrandQuery
leftJoinBrandImageRelatedByBrandId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the BrandImageRelatedByBrandId relation
in
BrandQuery at line 81
ChildBrandQuery
rightJoinBrandImageRelatedByBrandId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the BrandImageRelatedByBrandId relation
in
BrandQuery at line 81
ChildBrandQuery
innerJoinBrandImageRelatedByBrandId($relationAlias = null)
Adds a INNER JOIN clause to the query using the BrandImageRelatedByBrandId relation
in
BrandQuery at line 81
ChildBrandQuery
leftJoinBrandI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the BrandI18n relation
in
BrandQuery at line 81
ChildBrandQuery
rightJoinBrandI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the BrandI18n relation
in
BrandQuery at line 81
ChildBrandQuery
innerJoinBrandI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the BrandI18n relation
in
BrandQuery at line 81
ChildBrand
findOne(
ConnectionInterface $con = null)
Return the first ChildBrand matching the query
in
BrandQuery at line 81
ChildBrand
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildBrand matching the query, or a new ChildBrand object populated from the query conditions when no match is found
in
BrandQuery at line 81
ChildBrand
findOneById(
int $id)
Return the first ChildBrand filtered by the id column
in
BrandQuery at line 81
ChildBrand
findOneByVisible(
int $visible)
Return the first ChildBrand filtered by the visible column
in
BrandQuery at line 81
ChildBrand
findOneByPosition(
int $position)
Return the first ChildBrand filtered by the position column
in
BrandQuery at line 81
ChildBrand
findOneByLogoImageId(
int $logo_image_id)
Return the first ChildBrand filtered by the logoimageid column
in
BrandQuery at line 81
ChildBrand
findOneByCreatedAt(
string $created_at)
Return the first ChildBrand filtered by the created_at column
in
BrandQuery at line 81
ChildBrand
findOneByUpdatedAt(
string $updated_at)
Return the first ChildBrand filtered by the updated_at column
in
BrandQuery at line 81
array
findById(
int $id)
Return ChildBrand objects filtered by the id column
in
BrandQuery at line 81
array
findByVisible(
int $visible)
Return ChildBrand objects filtered by the visible column
in
BrandQuery at line 81
array
findByPosition(
int $position)
Return ChildBrand objects filtered by the position column
in
BrandQuery at line 81
array
findByLogoImageId(
int $logo_image_id)
Return ChildBrand objects filtered by the logoimageid column
in
BrandQuery at line 81
array
findByCreatedAt(
string $created_at)
Return ChildBrand objects filtered by the created_at column
in
BrandQuery at line 81
array
findByUpdatedAt(
string $updated_at)
Return ChildBrand objects filtered by the updated_at column