ContentQuery
class ContentQuery extends ContentQuery
Skeleton subclass for performing query and update operations on the 'content' 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.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled | from ContentQuery |
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 a list of primary keys
Filter the query on the id column
Filter the query on the visible column
No description
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.
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 visible column
No description
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
No description
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
No description
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 visible column
No description
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
in
ContentQuery at line 114
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Content',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ContentQuery object.
in
ContentQuery at line 127
static
ContentQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildContentQuery object.
in
ContentQuery 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);
in
ContentQuery 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);
in
ContentQuery at line 260
ContentQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ContentQuery at line 273
ContentQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ContentQuery 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
in
ContentQuery 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 22
ContentQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
in
ContentQuery 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'
in
ContentQuery 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'
in
ContentQuery 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
in
ContentQuery 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'
in
ContentQuery 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%'
in
ContentQuery at line 609
ContentQuery
filterByContentFolder(
ContentFolder|ObjectCollection $contentFolder,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentFolder object
in
ContentQuery at line 632
ContentQuery
joinContentFolder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentFolder relation
in
ContentQuery at line 667
ContentFolderQuery
useContentFolderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentFolder relation ContentFolder object
in
ContentQuery at line 682
ContentQuery
filterByContentImage(
ContentImage|ObjectCollection $contentImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentImage object
in
ContentQuery at line 705
ContentQuery
joinContentImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentImage relation
in
ContentQuery at line 740
ContentImageQuery
useContentImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentImage relation ContentImage object
in
ContentQuery at line 755
ContentQuery
filterByContentDocument(
ContentDocument|ObjectCollection $contentDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentDocument object
in
ContentQuery at line 778
ContentQuery
joinContentDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentDocument relation
in
ContentQuery at line 813
ContentDocumentQuery
useContentDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentDocument relation ContentDocument object
in
ContentQuery at line 828
ContentQuery
filterByProductAssociatedContent(
ProductAssociatedContent|ObjectCollection $productAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductAssociatedContent object
in
ContentQuery at line 851
ContentQuery
joinProductAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductAssociatedContent relation
in
ContentQuery at line 886
ProductAssociatedContentQuery
useProductAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductAssociatedContent relation ProductAssociatedContent object
in
ContentQuery at line 901
ContentQuery
filterByCategoryAssociatedContent(
CategoryAssociatedContent|ObjectCollection $categoryAssociatedContent,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryAssociatedContent object
in
ContentQuery at line 924
ContentQuery
joinCategoryAssociatedContent(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the CategoryAssociatedContent relation
in
ContentQuery at line 959
CategoryAssociatedContentQuery
useCategoryAssociatedContentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the CategoryAssociatedContent relation CategoryAssociatedContent object
in
ContentQuery at line 974
ContentQuery
filterByContentI18n(
ContentI18n|ObjectCollection $contentI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentI18n object
in
ContentQuery at line 997
ContentQuery
joinContentI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ContentI18n relation
in
ContentQuery at line 1032
ContentI18nQuery
useContentI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ContentI18n relation ContentI18n object
in
ContentQuery at line 1047
ContentQuery
filterByContentVersion(
ContentVersion|ObjectCollection $contentVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentVersion object
in
ContentQuery at line 1070
ContentQuery
joinContentVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentVersion relation
in
ContentQuery at line 1105
ContentVersionQuery
useContentVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentVersion relation ContentVersion object
in
ContentQuery 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
in
ContentQuery at line 1136
ContentQuery
prune(
Content $content = null)
Exclude object from result
in
ContentQuery at line 1151
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the content table.
in
ContentQuery 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.
in
ContentQuery at line 1229
ContentQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ContentQuery at line 1241
ContentQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ContentQuery at line 1251
ContentQuery
lastUpdatedFirst()
Order by update date desc
in
ContentQuery at line 1261
ContentQuery
firstUpdatedFirst()
Order by update date asc
in
ContentQuery at line 1271
ContentQuery
lastCreatedFirst()
Order by create date desc
in
ContentQuery at line 1281
ContentQuery
firstCreatedFirst()
Order by create date asc
in
ContentQuery 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
in
ContentQuery 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()
in
ContentQuery at line 1336
ContentI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
ContentQuery at line 1350
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
in
ContentQuery at line 1358
static
enableVersioning()
Enables versioning
in
ContentQuery at line 1366
static
disableVersioning()
Disables versioning
in
ContentQuery at line 97
ChildContentQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ContentQuery at line 97
ChildContentQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 31
ChildContentQuery
orderByPosition($order = Criteria::ASC)
in
ContentQuery at line 97
ChildContentQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ContentQuery at line 97
ChildContentQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ContentQuery at line 97
ChildContentQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
in
ContentQuery at line 97
ChildContentQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
in
ContentQuery at line 97
ChildContentQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
in
ContentQuery at line 97
ChildContentQuery
groupById()
Group by the id column
in
ContentQuery at line 97
ChildContentQuery
groupByVisible()
Group by the visible column
at line 40
ChildContentQuery
groupByPosition()
in
ContentQuery at line 97
ChildContentQuery
groupByCreatedAt()
Group by the created_at column
in
ContentQuery at line 97
ChildContentQuery
groupByUpdatedAt()
Group by the updated_at column
in
ContentQuery at line 97
ChildContentQuery
groupByVersion()
Group by the version column
in
ContentQuery at line 97
ChildContentQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
in
ContentQuery at line 97
ChildContentQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
in
ContentQuery at line 97
ChildContentQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ContentQuery at line 97
ChildContentQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ContentQuery at line 97
ChildContentQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ContentQuery at line 97
ChildContentQuery
leftJoinContentFolder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentFolder relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinContentFolder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentFolder relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinContentFolder($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentFolder relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinContentImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentImage relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinContentImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentImage relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinContentImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentImage relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinContentDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentDocument relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinContentDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentDocument relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinContentDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentDocument relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinProductAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinProductAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinProductAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinCategoryAssociatedContent($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinCategoryAssociatedContent($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinCategoryAssociatedContent($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryAssociatedContent relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinContentI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentI18n relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinContentI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentI18n relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinContentI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentI18n relation
in
ContentQuery at line 97
ChildContentQuery
leftJoinContentVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentVersion relation
in
ContentQuery at line 97
ChildContentQuery
rightJoinContentVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentVersion relation
in
ContentQuery at line 97
ChildContentQuery
innerJoinContentVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentVersion relation
in
ContentQuery at line 97
ChildContent
findOne(
ConnectionInterface $con = null)
Return the first ChildContent matching the query
in
ContentQuery 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
in
ContentQuery at line 97
ChildContent
findOneById(
int $id)
Return the first ChildContent filtered by the id column
in
ContentQuery at line 97
ChildContent
findOneByVisible(
int $visible)
Return the first ChildContent filtered by the visible column
at line 49
ChildContent
findOneByPosition(
int $position)
in
ContentQuery at line 97
ChildContent
findOneByCreatedAt(
string $created_at)
Return the first ChildContent filtered by the created_at column
in
ContentQuery at line 97
ChildContent
findOneByUpdatedAt(
string $updated_at)
Return the first ChildContent filtered by the updated_at column
in
ContentQuery at line 97
ChildContent
findOneByVersion(
int $version)
Return the first ChildContent filtered by the version column
in
ContentQuery at line 97
ChildContent
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildContent filtered by the versioncreatedat column
in
ContentQuery at line 97
ChildContent
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildContent filtered by the versioncreatedby column
in
ContentQuery at line 97
array
findById(
int $id)
Return ChildContent objects filtered by the id column
in
ContentQuery at line 97
array
findByVisible(
int $visible)
Return ChildContent objects filtered by the visible column
at line 58
array
findByPosition(
int $position)
in
ContentQuery at line 97
array
findByCreatedAt(
string $created_at)
Return ChildContent objects filtered by the created_at column
in
ContentQuery at line 97
array
findByUpdatedAt(
string $updated_at)
Return ChildContent objects filtered by the updated_at column
in
ContentQuery at line 97
array
findByVersion(
int $version)
Return ChildContent objects filtered by the version column
in
ContentQuery at line 97
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildContent objects filtered by the versioncreatedat column
in
ContentQuery at line 97
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildContent objects filtered by the versioncreatedby column