FolderQuery
class FolderQuery extends FolderQuery
Skeleton subclass for performing query and update operations on the 'folder' 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 FolderQuery |
Methods
Initializes internal state of \Thelia\Model\Base\FolderQuery object.
Returns a new ChildFolderQuery 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 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.
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
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
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 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
count how many direct contents a folder has
find all contents for a given folder.
Return all folder IDs of a folder tree, starting at $folderId, up to a depth of $depth
Details
in
FolderQuery at line 110
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Folder',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\FolderQuery object.
in
FolderQuery at line 123
static
FolderQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildFolderQuery object.
in
FolderQuery 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);
in
FolderQuery 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);
in
FolderQuery at line 256
FolderQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
FolderQuery at line 269
FolderQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
FolderQuery 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
in
FolderQuery 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
in
FolderQuery 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
in
FolderQuery 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
in
FolderQuery 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'
in
FolderQuery 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'
in
FolderQuery 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
in
FolderQuery 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'
in
FolderQuery 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%'
in
FolderQuery at line 646
FolderQuery
filterByContentFolder(
ContentFolder|ObjectCollection $contentFolder,
string $comparison = null)
Filter the query by a related \Thelia\Model\ContentFolder object
in
FolderQuery at line 669
FolderQuery
joinContentFolder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ContentFolder relation
in
FolderQuery at line 704
ContentFolderQuery
useContentFolderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ContentFolder relation ContentFolder object
in
FolderQuery at line 719
FolderQuery
filterByFolderImage(
FolderImage|ObjectCollection $folderImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderImage object
in
FolderQuery at line 742
FolderQuery
joinFolderImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderImage relation
in
FolderQuery at line 777
FolderImageQuery
useFolderImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderImage relation FolderImage object
in
FolderQuery at line 792
FolderQuery
filterByFolderDocument(
FolderDocument|ObjectCollection $folderDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderDocument object
in
FolderQuery at line 815
FolderQuery
joinFolderDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderDocument relation
in
FolderQuery at line 850
FolderDocumentQuery
useFolderDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderDocument relation FolderDocument object
in
FolderQuery at line 865
FolderQuery
filterByFolderI18n(
FolderI18n|ObjectCollection $folderI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderI18n object
in
FolderQuery at line 888
FolderQuery
joinFolderI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the FolderI18n relation
in
FolderQuery at line 923
FolderI18nQuery
useFolderI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the FolderI18n relation FolderI18n object
in
FolderQuery at line 938
FolderQuery
filterByFolderVersion(
FolderVersion|ObjectCollection $folderVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderVersion object
in
FolderQuery at line 961
FolderQuery
joinFolderVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the FolderVersion relation
in
FolderQuery at line 996
FolderVersionQuery
useFolderVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the FolderVersion relation FolderVersion object
in
FolderQuery 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
in
FolderQuery at line 1027
FolderQuery
prune(
Folder $folder = null)
Exclude object from result
in
FolderQuery at line 1042
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the folder table.
in
FolderQuery 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.
in
FolderQuery at line 1120
FolderQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
FolderQuery at line 1132
FolderQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
FolderQuery at line 1142
FolderQuery
lastUpdatedFirst()
Order by update date desc
in
FolderQuery at line 1152
FolderQuery
firstUpdatedFirst()
Order by update date asc
in
FolderQuery at line 1162
FolderQuery
lastCreatedFirst()
Order by create date desc
in
FolderQuery at line 1172
FolderQuery
firstCreatedFirst()
Order by create date asc
in
FolderQuery 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
in
FolderQuery 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()
in
FolderQuery at line 1227
FolderI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
FolderQuery at line 1241
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
in
FolderQuery at line 1249
static
enableVersioning()
Enables versioning
in
FolderQuery at line 1257
static
disableVersioning()
Disables versioning
in
FolderQuery at line 93
ChildFolderQuery
orderById($order = Criteria::ASC)
Order by the id column
in
FolderQuery at line 93
ChildFolderQuery
orderByParent($order = Criteria::ASC)
Order by the parent column
in
FolderQuery at line 93
ChildFolderQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
FolderQuery at line 93
ChildFolderQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
FolderQuery at line 93
ChildFolderQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
FolderQuery at line 93
ChildFolderQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
FolderQuery at line 93
ChildFolderQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
in
FolderQuery at line 93
ChildFolderQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
in
FolderQuery at line 93
ChildFolderQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
in
FolderQuery at line 93
ChildFolderQuery
groupById()
Group by the id column
in
FolderQuery at line 93
ChildFolderQuery
groupByParent()
Group by the parent column
in
FolderQuery at line 93
ChildFolderQuery
groupByVisible()
Group by the visible column
in
FolderQuery at line 93
ChildFolderQuery
groupByPosition()
Group by the position column
in
FolderQuery at line 93
ChildFolderQuery
groupByCreatedAt()
Group by the created_at column
in
FolderQuery at line 93
ChildFolderQuery
groupByUpdatedAt()
Group by the updated_at column
in
FolderQuery at line 93
ChildFolderQuery
groupByVersion()
Group by the version column
in
FolderQuery at line 93
ChildFolderQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
in
FolderQuery at line 93
ChildFolderQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
in
FolderQuery at line 93
ChildFolderQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
FolderQuery at line 93
ChildFolderQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
FolderQuery at line 93
ChildFolderQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
FolderQuery at line 93
ChildFolderQuery
leftJoinContentFolder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ContentFolder relation
in
FolderQuery at line 93
ChildFolderQuery
rightJoinContentFolder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ContentFolder relation
in
FolderQuery at line 93
ChildFolderQuery
innerJoinContentFolder($relationAlias = null)
Adds a INNER JOIN clause to the query using the ContentFolder relation
in
FolderQuery at line 93
ChildFolderQuery
leftJoinFolderImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderImage relation
in
FolderQuery at line 93
ChildFolderQuery
rightJoinFolderImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderImage relation
in
FolderQuery at line 93
ChildFolderQuery
innerJoinFolderImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderImage relation
in
FolderQuery at line 93
ChildFolderQuery
leftJoinFolderDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderDocument relation
in
FolderQuery at line 93
ChildFolderQuery
rightJoinFolderDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderDocument relation
in
FolderQuery at line 93
ChildFolderQuery
innerJoinFolderDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderDocument relation
in
FolderQuery at line 93
ChildFolderQuery
leftJoinFolderI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderI18n relation
in
FolderQuery at line 93
ChildFolderQuery
rightJoinFolderI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderI18n relation
in
FolderQuery at line 93
ChildFolderQuery
innerJoinFolderI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderI18n relation
in
FolderQuery at line 93
ChildFolderQuery
leftJoinFolderVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderVersion relation
in
FolderQuery at line 93
ChildFolderQuery
rightJoinFolderVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderVersion relation
in
FolderQuery at line 93
ChildFolderQuery
innerJoinFolderVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderVersion relation
in
FolderQuery at line 93
ChildFolder
findOne(
ConnectionInterface $con = null)
Return the first ChildFolder matching the query
in
FolderQuery 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
in
FolderQuery at line 93
ChildFolder
findOneById(
int $id)
Return the first ChildFolder filtered by the id column
in
FolderQuery at line 93
ChildFolder
findOneByParent(
int $parent)
Return the first ChildFolder filtered by the parent column
in
FolderQuery at line 93
ChildFolder
findOneByVisible(
int $visible)
Return the first ChildFolder filtered by the visible column
in
FolderQuery at line 93
ChildFolder
findOneByPosition(
int $position)
Return the first ChildFolder filtered by the position column
in
FolderQuery at line 93
ChildFolder
findOneByCreatedAt(
string $created_at)
Return the first ChildFolder filtered by the created_at column
in
FolderQuery at line 93
ChildFolder
findOneByUpdatedAt(
string $updated_at)
Return the first ChildFolder filtered by the updated_at column
in
FolderQuery at line 93
ChildFolder
findOneByVersion(
int $version)
Return the first ChildFolder filtered by the version column
in
FolderQuery at line 93
ChildFolder
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildFolder filtered by the versioncreatedat column
in
FolderQuery at line 93
ChildFolder
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildFolder filtered by the versioncreatedby column
in
FolderQuery at line 93
array
findById(
int $id)
Return ChildFolder objects filtered by the id column
in
FolderQuery at line 93
array
findByParent(
int $parent)
Return ChildFolder objects filtered by the parent column
in
FolderQuery at line 93
array
findByVisible(
int $visible)
Return ChildFolder objects filtered by the visible column
in
FolderQuery at line 93
array
findByPosition(
int $position)
Return ChildFolder objects filtered by the position column
in
FolderQuery at line 93
array
findByCreatedAt(
string $created_at)
Return ChildFolder objects filtered by the created_at column
in
FolderQuery at line 93
array
findByUpdatedAt(
string $updated_at)
Return ChildFolder objects filtered by the updated_at column
in
FolderQuery at line 93
array
findByVersion(
int $version)
Return ChildFolder objects filtered by the version column
in
FolderQuery at line 93
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildFolder objects filtered by the versioncreatedat column
in
FolderQuery at line 93
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildFolder objects filtered by the versioncreatedby column
at line 27
static
int
countChild(
int $parent)
count how many direct contents a folder has
at line 40
static
Folder[]
findAllChild(
int $folderId,
int $depth,
int $currentPosition)
find all contents for a given folder.
at line 76
static
int[]
getFolderTreeIds(
int|int[] $folderId,
int $depth = 1)
Return all folder IDs of a folder tree, starting at $folderId, up to a depth of $depth