FolderQuery
class FolderQuery extends ModelCriteria
Base class that represents a query for the 'folder' table.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled |
Methods
Initializes internal state of \Thelia\Model\Base\FolderQuery object.
Returns a new ChildFolderQuery object.
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 parent 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\FolderImage object
Adds a JOIN clause to the query using the FolderImage relation
Use the FolderImage relation FolderImage object
Filter the query by a related \Thelia\Model\FolderDocument object
Adds a JOIN clause to the query using the FolderDocument relation
Use the FolderDocument relation FolderDocument object
Filter the query by a related \Thelia\Model\FolderI18n object
Adds a JOIN clause to the query using the FolderI18n relation
Use the FolderI18n relation FolderI18n object
Filter the query by a related \Thelia\Model\FolderVersion object
Adds a JOIN clause to the query using the FolderVersion relation
Use the FolderVersion relation FolderVersion object
Filter the query by a related Content object using the content_folder table as cross reference
Deletes all rows from the folder table.
Performs a DELETE on the database, given a ChildFolder 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 parent 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 parent 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 FolderImage relation
Adds a RIGHT JOIN clause to the query using the FolderImage relation
Adds a INNER JOIN clause to the query using the FolderImage relation
Adds a LEFT JOIN clause to the query using the FolderDocument relation
Adds a RIGHT JOIN clause to the query using the FolderDocument relation
Adds a INNER JOIN clause to the query using the FolderDocument relation
Adds a LEFT JOIN clause to the query using the FolderI18n relation
Adds a RIGHT JOIN clause to the query using the FolderI18n relation
Adds a INNER JOIN clause to the query using the FolderI18n relation
Adds a LEFT JOIN clause to the query using the FolderVersion relation
Adds a RIGHT JOIN clause to the query using the FolderVersion relation
Adds a INNER JOIN clause to the query using the FolderVersion relation
Return the first ChildFolder matching the query
Return the first ChildFolder matching the query, or a new ChildFolder object populated from the query conditions when no match is found
Return the first ChildFolder filtered by the id column
Return the first ChildFolder filtered by the parent column
Return the first ChildFolder filtered by the visible column
Return the first ChildFolder filtered by the position column
Return the first ChildFolder filtered by the created_at column
Return the first ChildFolder filtered by the updated_at column
Return the first ChildFolder filtered by the version column
Return the first ChildFolder filtered by the versioncreatedat column
Return the first ChildFolder filtered by the versioncreatedby column
Return ChildFolder objects filtered by the id column
Return ChildFolder objects filtered by the parent column
Return ChildFolder objects filtered by the visible column
Return ChildFolder objects filtered by the position column
Return ChildFolder objects filtered by the created_at column
Return ChildFolder objects filtered by the updated_at column
Return ChildFolder objects filtered by the version column
Return ChildFolder objects filtered by the versioncreatedat column
Return ChildFolder objects filtered by the versioncreatedby column
Details
at line 110
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Folder',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\FolderQuery object.
at line 123
static
FolderQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildFolderQuery object.
at line 153
Folder|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 235
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 256
FolderQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 269
FolderQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 293
FolderQuery
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 334
FolderQuery
filterByParent(
mixed $parent = null,
string $comparison = null)
Filter the query on the parent column
Example usage:
$query->filterByParent(1234); // WHERE parent = 1234
$query->filterByParent(array(12, 34)); // WHERE parent IN (12, 34)
$query->filterByParent(array('min' => 12)); // WHERE parent > 12
at line 375
FolderQuery
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 416
FolderQuery
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 459
FolderQuery
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 502
FolderQuery
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 543
FolderQuery
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 586
FolderQuery
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 624
FolderQuery
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 646
FolderQuery
filterByContentFolder(
ContentFolder|ObjectCollection $contentFolder,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentFolder object
at line 669
FolderQuery
joinContentFolder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentFolder relation
at line 704
ContentFolderQuery
useContentFolderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentFolder relation ContentFolder object
at line 719
FolderQuery
filterByFolderImage(
FolderImage|ObjectCollection $folderImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderImage object
at line 742
FolderQuery
joinFolderImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderImage relation
at line 777
FolderImageQuery
useFolderImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderImage relation FolderImage object
at line 792
FolderQuery
filterByFolderDocument(
FolderDocument|ObjectCollection $folderDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderDocument object
at line 815
FolderQuery
joinFolderDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderDocument relation
at line 850
FolderDocumentQuery
useFolderDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderDocument relation FolderDocument object
at line 865
FolderQuery
filterByFolderI18n(
FolderI18n|ObjectCollection $folderI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderI18n object
at line 888
FolderQuery
joinFolderI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the FolderI18n relation
at line 923
FolderI18nQuery
useFolderI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the FolderI18n relation FolderI18n object
at line 938
FolderQuery
filterByFolderVersion(
FolderVersion|ObjectCollection $folderVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderVersion object
at line 961
FolderQuery
joinFolderVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderVersion relation
at line 996
FolderVersionQuery
useFolderVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderVersion relation FolderVersion object
at line 1012
FolderQuery
filterByContent(
Content $content,
string $comparison = Criteria::EQUAL)
Filter the query by a related Content object using the content_folder table as cross reference
at line 1027
FolderQuery
prune(
Folder $folder = null)
Exclude object from result
at line 1042
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the folder table.
at line 1079
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildFolder or Criteria object OR a primary key value.
at line 1120
FolderQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1132
FolderQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1142
FolderQuery
lastUpdatedFirst()
Order by update date desc
at line 1152
FolderQuery
firstUpdatedFirst()
Order by update date asc
at line 1162
FolderQuery
lastCreatedFirst()
Order by create date desc
at line 1172
FolderQuery
firstCreatedFirst()
Order by create date asc
at line 1188
FolderQuery
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 1206
FolderQuery
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 1227
FolderI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 1241
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
at line 1249
static
enableVersioning()
Enables versioning
at line 1257
static
disableVersioning()
Disables versioning
at line 93
ChildFolderQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 93
ChildFolderQuery
orderByParent($order = Criteria::ASC)
Order by the parent column
at line 93
ChildFolderQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 93
ChildFolderQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 93
ChildFolderQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 93
ChildFolderQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 93
ChildFolderQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 93
ChildFolderQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 93
ChildFolderQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 93
ChildFolderQuery
groupById()
Group by the id column
at line 93
ChildFolderQuery
groupByParent()
Group by the parent column
at line 93
ChildFolderQuery
groupByVisible()
Group by the visible column
at line 93
ChildFolderQuery
groupByPosition()
Group by the position column
at line 93
ChildFolderQuery
groupByCreatedAt()
Group by the created_at column
at line 93
ChildFolderQuery
groupByUpdatedAt()
Group by the updated_at column
at line 93
ChildFolderQuery
groupByVersion()
Group by the version column
at line 93
ChildFolderQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 93
ChildFolderQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 93
ChildFolderQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 93
ChildFolderQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 93
ChildFolderQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 93
ChildFolderQuery
leftJoinContentFolder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentFolder relation
at line 93
ChildFolderQuery
rightJoinContentFolder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentFolder relation
at line 93
ChildFolderQuery
innerJoinContentFolder($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentFolder relation
at line 93
ChildFolderQuery
leftJoinFolderImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderImage relation
at line 93
ChildFolderQuery
rightJoinFolderImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderImage relation
at line 93
ChildFolderQuery
innerJoinFolderImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderImage relation
at line 93
ChildFolderQuery
leftJoinFolderDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderDocument relation
at line 93
ChildFolderQuery
rightJoinFolderDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderDocument relation
at line 93
ChildFolderQuery
innerJoinFolderDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderDocument relation
at line 93
ChildFolderQuery
leftJoinFolderI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderI18n relation
at line 93
ChildFolderQuery
rightJoinFolderI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderI18n relation
at line 93
ChildFolderQuery
innerJoinFolderI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderI18n relation
at line 93
ChildFolderQuery
leftJoinFolderVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderVersion relation
at line 93
ChildFolderQuery
rightJoinFolderVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderVersion relation
at line 93
ChildFolderQuery
innerJoinFolderVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderVersion relation
at line 93
ChildFolder
findOne(
ConnectionInterface $con = null)
Return the first ChildFolder matching the query
at line 93
ChildFolder
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildFolder matching the query, or a new ChildFolder object populated from the query conditions when no match is found
at line 93
ChildFolder
findOneById(
int $id)
Return the first ChildFolder filtered by the id column
at line 93
ChildFolder
findOneByParent(
int $parent)
Return the first ChildFolder filtered by the parent column
at line 93
ChildFolder
findOneByVisible(
int $visible)
Return the first ChildFolder filtered by the visible column
at line 93
ChildFolder
findOneByPosition(
int $position)
Return the first ChildFolder filtered by the position column
at line 93
ChildFolder
findOneByCreatedAt(
string $created_at)
Return the first ChildFolder filtered by the created_at column
at line 93
ChildFolder
findOneByUpdatedAt(
string $updated_at)
Return the first ChildFolder filtered by the updated_at column
at line 93
ChildFolder
findOneByVersion(
int $version)
Return the first ChildFolder filtered by the version column
at line 93
ChildFolder
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildFolder filtered by the versioncreatedat column
at line 93
ChildFolder
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildFolder filtered by the versioncreatedby column
at line 93
array
findById(
int $id)
Return ChildFolder objects filtered by the id column
at line 93
array
findByParent(
int $parent)
Return ChildFolder objects filtered by the parent column
at line 93
array
findByVisible(
int $visible)
Return ChildFolder objects filtered by the visible column
at line 93
array
findByPosition(
int $position)
Return ChildFolder objects filtered by the position column
at line 93
array
findByCreatedAt(
string $created_at)
Return ChildFolder objects filtered by the created_at column
at line 93
array
findByUpdatedAt(
string $updated_at)
Return ChildFolder objects filtered by the updated_at column
at line 93
array
findByVersion(
int $version)
Return ChildFolder objects filtered by the version column
at line 93
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildFolder objects filtered by the versioncreatedat column
at line 93
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildFolder objects filtered by the versioncreatedby column