FolderImageQuery
class FolderImageQuery extends ModelCriteria
Base class that represents a query for the 'folder_image' table.
Methods
Initializes internal state of \Thelia\Model\Base\FolderImageQuery object.
Returns a new ChildFolderImageQuery 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 folder_id column
Filter the query on the file 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 by a related \Thelia\Model\Folder object
Adds a JOIN clause to the query using the Folder relation
Use the Folder relation Folder object
Filter the query by a related \Thelia\Model\FolderImageI18n object
Adds a JOIN clause to the query using the FolderImageI18n relation
Use the FolderImageI18n relation FolderImageI18n object
Deletes all rows from the folder_image table.
Performs a DELETE on the database, given a ChildFolderImage 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
Order by the id column
Order by the folder_id column
Order by the file column
Order by the visible column
Order by the position column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the folder_id column
Group by the file column
Group by the visible column
Group by the position column
Group by the created_at column
Group by the updated_at 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 Folder relation
Adds a RIGHT JOIN clause to the query using the Folder relation
Adds a INNER JOIN clause to the query using the Folder relation
Adds a LEFT JOIN clause to the query using the FolderImageI18n relation
Adds a RIGHT JOIN clause to the query using the FolderImageI18n relation
Adds a INNER JOIN clause to the query using the FolderImageI18n relation
Return the first ChildFolderImage matching the query
Return the first ChildFolderImage matching the query, or a new ChildFolderImage object populated from the query conditions when no match is found
Return the first ChildFolderImage filtered by the id column
Return the first ChildFolderImage filtered by the folder_id column
Return the first ChildFolderImage filtered by the file column
Return the first ChildFolderImage filtered by the visible column
Return the first ChildFolderImage filtered by the position column
Return the first ChildFolderImage filtered by the created_at column
Return the first ChildFolderImage filtered by the updated_at column
Return ChildFolderImage objects filtered by the id column
Return ChildFolderImage objects filtered by the folder_id column
Return ChildFolderImage objects filtered by the file column
Return ChildFolderImage objects filtered by the visible column
Return ChildFolderImage objects filtered by the position column
Return ChildFolderImage objects filtered by the created_at column
Return ChildFolderImage objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\FolderImage',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\FolderImageQuery object.
at line 96
static
FolderImageQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildFolderImageQuery object.
at line 126
FolderImage|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 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 229
FolderImageQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
FolderImageQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
FolderImageQuery
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 309
FolderImageQuery
filterByFolderId(
mixed $folderId = null,
string $comparison = null)
Filter the query on the folder_id column
Example usage:
$query->filterByFolderId(1234); // WHERE folderid = 1234
$query->filterByFolderId(array(12, 34)); // WHERE folderid IN (12, 34)
$query->filterByFolderId(array('min' => 12)); // WHERE folder_id > 12
at line 347
FolderImageQuery
filterByFile(
string $file = null,
string $comparison = null)
Filter the query on the file column
Example usage:
$query->filterByFile('fooValue'); // WHERE file = 'fooValue'
$query->filterByFile('%fooValue%'); // WHERE file LIKE '%fooValue%'
at line 379
FolderImageQuery
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 420
FolderImageQuery
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 463
FolderImageQuery
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 506
FolderImageQuery
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 537
FolderImageQuery
filterByFolder(
Folder|ObjectCollection $folder,
string $comparison = null)
Filter the query by a related \Thelia\Model\Folder object
at line 562
FolderImageQuery
joinFolder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Folder relation
at line 597
FolderQuery
useFolderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Folder relation Folder object
at line 612
FolderImageQuery
filterByFolderImageI18n(
FolderImageI18n|ObjectCollection $folderImageI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\FolderImageI18n object
at line 635
FolderImageQuery
joinFolderImageI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the FolderImageI18n relation
at line 670
FolderImageI18nQuery
useFolderImageI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the FolderImageI18n relation FolderImageI18n object
at line 684
FolderImageQuery
prune(
FolderImage $folderImage = null)
Exclude object from result
at line 699
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the folder_image table.
at line 736
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildFolderImage or Criteria object OR a primary key value.
at line 777
FolderImageQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 789
FolderImageQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 799
FolderImageQuery
lastUpdatedFirst()
Order by update date desc
at line 809
FolderImageQuery
firstUpdatedFirst()
Order by update date asc
at line 819
FolderImageQuery
lastCreatedFirst()
Order by create date desc
at line 829
FolderImageQuery
firstCreatedFirst()
Order by create date asc
at line 845
FolderImageQuery
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 863
FolderImageQuery
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 884
FolderImageI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildFolderImageQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildFolderImageQuery
orderByFolderId($order = Criteria::ASC)
Order by the folder_id column
at line 73
ChildFolderImageQuery
orderByFile($order = Criteria::ASC)
Order by the file column
at line 73
ChildFolderImageQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 73
ChildFolderImageQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildFolderImageQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildFolderImageQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildFolderImageQuery
groupById()
Group by the id column
at line 73
ChildFolderImageQuery
groupByFolderId()
Group by the folder_id column
at line 73
ChildFolderImageQuery
groupByFile()
Group by the file column
at line 73
ChildFolderImageQuery
groupByVisible()
Group by the visible column
at line 73
ChildFolderImageQuery
groupByPosition()
Group by the position column
at line 73
ChildFolderImageQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildFolderImageQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildFolderImageQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildFolderImageQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildFolderImageQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildFolderImageQuery
leftJoinFolder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Folder relation
at line 73
ChildFolderImageQuery
rightJoinFolder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Folder relation
at line 73
ChildFolderImageQuery
innerJoinFolder($relationAlias = null)
Adds a INNER JOIN clause to the query using the Folder relation
at line 73
ChildFolderImageQuery
leftJoinFolderImageI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the FolderImageI18n relation
at line 73
ChildFolderImageQuery
rightJoinFolderImageI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the FolderImageI18n relation
at line 73
ChildFolderImageQuery
innerJoinFolderImageI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the FolderImageI18n relation
at line 73
ChildFolderImage
findOne(
ConnectionInterface $con = null)
Return the first ChildFolderImage matching the query
at line 73
ChildFolderImage
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildFolderImage matching the query, or a new ChildFolderImage object populated from the query conditions when no match is found
at line 73
ChildFolderImage
findOneById(
int $id)
Return the first ChildFolderImage filtered by the id column
at line 73
ChildFolderImage
findOneByFolderId(
int $folder_id)
Return the first ChildFolderImage filtered by the folder_id column
at line 73
ChildFolderImage
findOneByFile(
string $file)
Return the first ChildFolderImage filtered by the file column
at line 73
ChildFolderImage
findOneByVisible(
int $visible)
Return the first ChildFolderImage filtered by the visible column
at line 73
ChildFolderImage
findOneByPosition(
int $position)
Return the first ChildFolderImage filtered by the position column
at line 73
ChildFolderImage
findOneByCreatedAt(
string $created_at)
Return the first ChildFolderImage filtered by the created_at column
at line 73
ChildFolderImage
findOneByUpdatedAt(
string $updated_at)
Return the first ChildFolderImage filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildFolderImage objects filtered by the id column
at line 73
array
findByFolderId(
int $folder_id)
Return ChildFolderImage objects filtered by the folder_id column
at line 73
array
findByFile(
string $file)
Return ChildFolderImage objects filtered by the file column
at line 73
array
findByVisible(
int $visible)
Return ChildFolderImage objects filtered by the visible column
at line 73
array
findByPosition(
int $position)
Return ChildFolderImage objects filtered by the position column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildFolderImage objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildFolderImage objects filtered by the updated_at column