ContentQuery
class ContentQuery extends ModelCriteria
Base class that represents a query for the 'content' table.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled |
Methods
Initializes internal state of \Thelia\Model\Base\ContentQuery object.
Returns a new ChildContentQuery 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 visible 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 on the version column
Filter the query on the versioncreatedat column
Filter the query on the versioncreatedby column
Filter the query by a related \Thelia\Model\ContentFolder object
Adds a JOIN clause to the query using the ContentFolder relation
Use the ContentFolder relation ContentFolder object
Filter the query by a related \Thelia\Model\ContentImage object
Adds a JOIN clause to the query using the ContentImage relation
Use the ContentImage relation ContentImage object
Filter the query by a related \Thelia\Model\ContentDocument object
Adds a JOIN clause to the query using the ContentDocument relation
Use the ContentDocument relation ContentDocument object
Filter the query by a related \Thelia\Model\ProductAssociatedContent object
Adds a JOIN clause to the query using the ProductAssociatedContent relation
Use the ProductAssociatedContent relation ProductAssociatedContent object
Filter the query by a related \Thelia\Model\CategoryAssociatedContent object
Adds a JOIN clause to the query using the CategoryAssociatedContent relation
Use the CategoryAssociatedContent relation CategoryAssociatedContent object
Filter the query by a related \Thelia\Model\ContentI18n object
Adds a JOIN clause to the query using the ContentI18n relation
Use the ContentI18n relation ContentI18n object
Filter the query by a related \Thelia\Model\ContentVersion object
Adds a JOIN clause to the query using the ContentVersion relation
Use the ContentVersion relation ContentVersion object
Filter the query by a related Folder object using the content_folder table as cross reference
Deletes all rows from the content table.
Performs a DELETE on the database, given a ChildContent 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
Checks whether versioning is enabled
Enables versioning
Disables versioning
Order by the id column
Order by the visible column
Order by the position column
Order by the created_at column
Order by the updated_at column
Order by the version column
Order by the versioncreatedat column
Order by the versioncreatedby column
Group by the id column
Group by the visible column
Group by the position column
Group by the created_at column
Group by the updated_at column
Group by the version column
Group by the versioncreatedat column
Group by the versioncreatedby 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 ContentFolder relation
Adds a RIGHT JOIN clause to the query using the ContentFolder relation
Adds a INNER JOIN clause to the query using the ContentFolder relation
Adds a LEFT JOIN clause to the query using the ContentImage relation
Adds a RIGHT JOIN clause to the query using the ContentImage relation
Adds a INNER JOIN clause to the query using the ContentImage relation
Adds a LEFT JOIN clause to the query using the ContentDocument relation
Adds a RIGHT JOIN clause to the query using the ContentDocument relation
Adds a INNER JOIN clause to the query using the ContentDocument relation
Adds a LEFT JOIN clause to the query using the ProductAssociatedContent relation
Adds a RIGHT JOIN clause to the query using the ProductAssociatedContent relation
Adds a INNER JOIN clause to the query using the ProductAssociatedContent relation
Adds a LEFT JOIN clause to the query using the CategoryAssociatedContent relation
Adds a RIGHT JOIN clause to the query using the CategoryAssociatedContent relation
Adds a INNER JOIN clause to the query using the CategoryAssociatedContent relation
Adds a LEFT JOIN clause to the query using the ContentI18n relation
Adds a RIGHT JOIN clause to the query using the ContentI18n relation
Adds a INNER JOIN clause to the query using the ContentI18n relation
Adds a LEFT JOIN clause to the query using the ContentVersion relation
Adds a RIGHT JOIN clause to the query using the ContentVersion relation
Adds a INNER JOIN clause to the query using the ContentVersion relation
Return the first ChildContent matching the query
Return the first ChildContent matching the query, or a new ChildContent object populated from the query conditions when no match is found
Return the first ChildContent filtered by the id column
Return the first ChildContent filtered by the visible column
Return the first ChildContent filtered by the position column
Return the first ChildContent filtered by the created_at column
Return the first ChildContent filtered by the updated_at column
Return the first ChildContent filtered by the version column
Return the first ChildContent filtered by the versioncreatedat column
Return the first ChildContent filtered by the versioncreatedby column
Return ChildContent objects filtered by the id column
Return ChildContent objects filtered by the visible column
Return ChildContent objects filtered by the position column
Return ChildContent objects filtered by the created_at column
Return ChildContent objects filtered by the updated_at column
Return ChildContent objects filtered by the version column
Return ChildContent objects filtered by the versioncreatedat column
Return ChildContent objects filtered by the versioncreatedby column
Details
at line 114
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Content',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ContentQuery object.
at line 127
static
ContentQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildContentQuery object.
at line 157
Content|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 239
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 260
ContentQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 273
ContentQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 297
ContentQuery
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 338
ContentQuery
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
at line 379
ContentQuery
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 422
ContentQuery
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 465
ContentQuery
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 506
ContentQuery
filterByVersion(
mixed $version = null,
string $comparison = null)
Filter the query on the version column
Example usage:
$query->filterByVersion(1234); // WHERE version = 1234
$query->filterByVersion(array(12, 34)); // WHERE version IN (12, 34)
$query->filterByVersion(array('min' => 12)); // WHERE version > 12
at line 549
ContentQuery
filterByVersionCreatedAt(
mixed $versionCreatedAt = null,
string $comparison = null)
Filter the query on the versioncreatedat column
Example usage:
$query->filterByVersionCreatedAt('2011-03-14'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt('now'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt(array('max' => 'yesterday')); // WHERE versioncreatedat > '2011-03-13'
at line 587
ContentQuery
filterByVersionCreatedBy(
string $versionCreatedBy = null,
string $comparison = null)
Filter the query on the versioncreatedby column
Example usage:
$query->filterByVersionCreatedBy('fooValue'); // WHERE versioncreatedby = 'fooValue'
$query->filterByVersionCreatedBy('%fooValue%'); // WHERE versioncreatedby LIKE '%fooValue%'
at line 609
ContentQuery
filterByContentFolder(
ContentFolder|ObjectCollection $contentFolder,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentFolder object
at line 632
ContentQuery
joinContentFolder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentFolder relation
at line 667
ContentFolderQuery
useContentFolderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentFolder relation ContentFolder object
at line 682
ContentQuery
filterByContentImage(
ContentImage|ObjectCollection $contentImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentImage object
at line 705
ContentQuery
joinContentImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentImage relation
at line 740
ContentImageQuery
useContentImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentImage relation ContentImage object
at line 755
ContentQuery
filterByContentDocument(
ContentDocument|ObjectCollection $contentDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentDocument object
at line 778
ContentQuery
joinContentDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentDocument relation
at line 813
ContentDocumentQuery
useContentDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentDocument relation ContentDocument object
at line 828
ContentQuery
filterByProductAssociatedContent(
ProductAssociatedContent|ObjectCollection $productAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductAssociatedContent object
at line 851
ContentQuery
joinProductAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductAssociatedContent relation
at line 886
ProductAssociatedContentQuery
useProductAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductAssociatedContent relation ProductAssociatedContent object
at line 901
ContentQuery
filterByCategoryAssociatedContent(
CategoryAssociatedContent|ObjectCollection $categoryAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryAssociatedContent object
at line 924
ContentQuery
joinCategoryAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryAssociatedContent relation
at line 959
CategoryAssociatedContentQuery
useCategoryAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryAssociatedContent relation CategoryAssociatedContent object
at line 974
ContentQuery
filterByContentI18n(
ContentI18n|ObjectCollection $contentI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentI18n object
at line 997
ContentQuery
joinContentI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ContentI18n relation
at line 1032
ContentI18nQuery
useContentI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ContentI18n relation ContentI18n object
at line 1047
ContentQuery
filterByContentVersion(
ContentVersion|ObjectCollection $contentVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentVersion object
at line 1070
ContentQuery
joinContentVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentVersion relation
at line 1105
ContentVersionQuery
useContentVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentVersion relation ContentVersion object
at line 1121
ContentQuery
filterByFolder(
Folder $folder,
string $comparison = Criteria::EQUAL)
Filter the query by a related Folder object using the content_folder table as cross reference
at line 1136
ContentQuery
prune(
Content $content = null)
Exclude object from result
at line 1151
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the content table.
at line 1188
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildContent or Criteria object OR a primary key value.
at line 1229
ContentQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1241
ContentQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1251
ContentQuery
lastUpdatedFirst()
Order by update date desc
at line 1261
ContentQuery
firstUpdatedFirst()
Order by update date asc
at line 1271
ContentQuery
lastCreatedFirst()
Order by create date desc
at line 1281
ContentQuery
firstCreatedFirst()
Order by create date asc
at line 1297
ContentQuery
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 1315
ContentQuery
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 1336
ContentI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 1350
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
at line 1358
static
enableVersioning()
Enables versioning
at line 1366
static
disableVersioning()
Disables versioning
at line 97
ChildContentQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 97
ChildContentQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 97
ChildContentQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 97
ChildContentQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 97
ChildContentQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 97
ChildContentQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 97
ChildContentQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 97
ChildContentQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 97
ChildContentQuery
groupById()
Group by the id column
at line 97
ChildContentQuery
groupByVisible()
Group by the visible column
at line 97
ChildContentQuery
groupByPosition()
Group by the position column
at line 97
ChildContentQuery
groupByCreatedAt()
Group by the created_at column
at line 97
ChildContentQuery
groupByUpdatedAt()
Group by the updated_at column
at line 97
ChildContentQuery
groupByVersion()
Group by the version column
at line 97
ChildContentQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 97
ChildContentQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 97
ChildContentQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 97
ChildContentQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 97
ChildContentQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 97
ChildContentQuery
leftJoinContentFolder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentFolder relation
at line 97
ChildContentQuery
rightJoinContentFolder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentFolder relation
at line 97
ChildContentQuery
innerJoinContentFolder($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentFolder relation
at line 97
ChildContentQuery
leftJoinContentImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentImage relation
at line 97
ChildContentQuery
rightJoinContentImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentImage relation
at line 97
ChildContentQuery
innerJoinContentImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentImage relation
at line 97
ChildContentQuery
leftJoinContentDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentDocument relation
at line 97
ChildContentQuery
rightJoinContentDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentDocument relation
at line 97
ChildContentQuery
innerJoinContentDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentDocument relation
at line 97
ChildContentQuery
leftJoinProductAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductAssociatedContent relation
at line 97
ChildContentQuery
rightJoinProductAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductAssociatedContent relation
at line 97
ChildContentQuery
innerJoinProductAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductAssociatedContent relation
at line 97
ChildContentQuery
leftJoinCategoryAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryAssociatedContent relation
at line 97
ChildContentQuery
rightJoinCategoryAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryAssociatedContent relation
at line 97
ChildContentQuery
innerJoinCategoryAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryAssociatedContent relation
at line 97
ChildContentQuery
leftJoinContentI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentI18n relation
at line 97
ChildContentQuery
rightJoinContentI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentI18n relation
at line 97
ChildContentQuery
innerJoinContentI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentI18n relation
at line 97
ChildContentQuery
leftJoinContentVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentVersion relation
at line 97
ChildContentQuery
rightJoinContentVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentVersion relation
at line 97
ChildContentQuery
innerJoinContentVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentVersion relation
at line 97
ChildContent
findOne(
ConnectionInterface $con = null)
Return the first ChildContent matching the query
at line 97
ChildContent
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildContent matching the query, or a new ChildContent object populated from the query conditions when no match is found
at line 97
ChildContent
findOneById(
int $id)
Return the first ChildContent filtered by the id column
at line 97
ChildContent
findOneByVisible(
int $visible)
Return the first ChildContent filtered by the visible column
at line 97
ChildContent
findOneByPosition(
int $position)
Return the first ChildContent filtered by the position column
at line 97
ChildContent
findOneByCreatedAt(
string $created_at)
Return the first ChildContent filtered by the created_at column
at line 97
ChildContent
findOneByUpdatedAt(
string $updated_at)
Return the first ChildContent filtered by the updated_at column
at line 97
ChildContent
findOneByVersion(
int $version)
Return the first ChildContent filtered by the version column
at line 97
ChildContent
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildContent filtered by the versioncreatedat column
at line 97
ChildContent
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildContent filtered by the versioncreatedby column
at line 97
array
findById(
int $id)
Return ChildContent objects filtered by the id column
at line 97
array
findByVisible(
int $visible)
Return ChildContent objects filtered by the visible column
at line 97
array
findByPosition(
int $position)
Return ChildContent objects filtered by the position column
at line 97
array
findByCreatedAt(
string $created_at)
Return ChildContent objects filtered by the created_at column
at line 97
array
findByUpdatedAt(
string $updated_at)
Return ChildContent objects filtered by the updated_at column
at line 97
array
findByVersion(
int $version)
Return ChildContent objects filtered by the version column
at line 97
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildContent objects filtered by the versioncreatedat column
at line 97
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildContent objects filtered by the versioncreatedby column