ExportQuery
class ExportQuery extends ModelCriteria
Base class that represents a query for the 'export' table.
Methods
Initializes internal state of \Thelia\Model\Base\ExportQuery object.
Returns a new ChildExportQuery 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 ref column
Filter the query on the position column
Filter the query on the exportcategoryid column
Filter the query on the handle_class 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\ExportCategory object
Adds a JOIN clause to the query using the ExportCategory relation
Use the ExportCategory relation ExportCategory object
Filter the query by a related \Thelia\Model\ExportI18n object
Adds a JOIN clause to the query using the ExportI18n relation
Use the ExportI18n relation ExportI18n object
Deletes all rows from the export table.
Performs a DELETE on the database, given a ChildExport 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 ref column
Order by the position column
Order by the exportcategoryid column
Order by the handle_class column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the ref column
Group by the position column
Group by the exportcategoryid column
Group by the handle_class 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 ExportCategory relation
Adds a RIGHT JOIN clause to the query using the ExportCategory relation
Adds a INNER JOIN clause to the query using the ExportCategory relation
Adds a LEFT JOIN clause to the query using the ExportI18n relation
Adds a RIGHT JOIN clause to the query using the ExportI18n relation
Adds a INNER JOIN clause to the query using the ExportI18n relation
Return the first ChildExport matching the query
Return the first ChildExport matching the query, or a new ChildExport object populated from the query conditions when no match is found
Return the first ChildExport filtered by the id column
Return the first ChildExport filtered by the ref column
Return the first ChildExport filtered by the position column
Return the first ChildExport filtered by the exportcategoryid column
Return the first ChildExport filtered by the handle_class column
Return the first ChildExport filtered by the created_at column
Return the first ChildExport filtered by the updated_at column
Return ChildExport objects filtered by the id column
Return ChildExport objects filtered by the ref column
Return ChildExport objects filtered by the position column
Return ChildExport objects filtered by the exportcategoryid column
Return ChildExport objects filtered by the handle_class column
Return ChildExport objects filtered by the created_at column
Return ChildExport objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Export',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ExportQuery object.
at line 96
static
ExportQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildExportQuery object.
at line 126
Export|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
ExportQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
ExportQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
ExportQuery
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 304
ExportQuery
filterByRef(
string $ref = null,
string $comparison = null)
Filter the query on the ref column
Example usage:
$query->filterByRef('fooValue'); // WHERE ref = 'fooValue'
$query->filterByRef('%fooValue%'); // WHERE ref LIKE '%fooValue%'
at line 336
ExportQuery
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 379
ExportQuery
filterByExportCategoryId(
mixed $exportCategoryId = null,
string $comparison = null)
Filter the query on the exportcategoryid column
Example usage:
$query->filterByExportCategoryId(1234); // WHERE exportcategoryid = 1234
$query->filterByExportCategoryId(array(12, 34)); // WHERE exportcategoryid IN (12, 34)
$query->filterByExportCategoryId(array('min' => 12)); // WHERE exportcategoryid > 12
at line 417
ExportQuery
filterByHandleClass(
string $handleClass = null,
string $comparison = null)
Filter the query on the handle_class column
Example usage:
$query->filterByHandleClass('fooValue'); // WHERE handleclass = 'fooValue'
$query->filterByHandleClass('%fooValue%'); // WHERE handleclass LIKE '%fooValue%'
at line 451
ExportQuery
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 494
ExportQuery
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 525
ExportQuery
filterByExportCategory(
ExportCategory|ObjectCollection $exportCategory,
string $comparison = null)
Filter the query by a related \Thelia\Model\ExportCategory object
at line 550
ExportQuery
joinExportCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ExportCategory relation
at line 585
ExportCategoryQuery
useExportCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ExportCategory relation ExportCategory object
at line 600
ExportQuery
filterByExportI18n(
ExportI18n|ObjectCollection $exportI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ExportI18n object
at line 623
ExportQuery
joinExportI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ExportI18n relation
at line 658
ExportI18nQuery
useExportI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ExportI18n relation ExportI18n object
at line 672
ExportQuery
prune(
Export $export = null)
Exclude object from result
at line 687
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the export table.
at line 724
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildExport or Criteria object OR a primary key value.
at line 765
ExportQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 777
ExportQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 787
ExportQuery
lastUpdatedFirst()
Order by update date desc
at line 797
ExportQuery
firstUpdatedFirst()
Order by update date asc
at line 807
ExportQuery
lastCreatedFirst()
Order by create date desc
at line 817
ExportQuery
firstCreatedFirst()
Order by create date asc
at line 833
ExportQuery
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 851
ExportQuery
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 872
ExportI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildExportQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildExportQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
at line 73
ChildExportQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 73
ChildExportQuery
orderByExportCategoryId($order = Criteria::ASC)
Order by the exportcategoryid column
at line 73
ChildExportQuery
orderByHandleClass($order = Criteria::ASC)
Order by the handle_class column
at line 73
ChildExportQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildExportQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildExportQuery
groupById()
Group by the id column
at line 73
ChildExportQuery
groupByRef()
Group by the ref column
at line 73
ChildExportQuery
groupByPosition()
Group by the position column
at line 73
ChildExportQuery
groupByExportCategoryId()
Group by the exportcategoryid column
at line 73
ChildExportQuery
groupByHandleClass()
Group by the handle_class column
at line 73
ChildExportQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildExportQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildExportQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildExportQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildExportQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildExportQuery
leftJoinExportCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ExportCategory relation
at line 73
ChildExportQuery
rightJoinExportCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ExportCategory relation
at line 73
ChildExportQuery
innerJoinExportCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ExportCategory relation
at line 73
ChildExportQuery
leftJoinExportI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ExportI18n relation
at line 73
ChildExportQuery
rightJoinExportI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ExportI18n relation
at line 73
ChildExportQuery
innerJoinExportI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ExportI18n relation
at line 73
ChildExport
findOne(
ConnectionInterface $con = null)
Return the first ChildExport matching the query
at line 73
ChildExport
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildExport matching the query, or a new ChildExport object populated from the query conditions when no match is found
at line 73
ChildExport
findOneById(
int $id)
Return the first ChildExport filtered by the id column
at line 73
ChildExport
findOneByRef(
string $ref)
Return the first ChildExport filtered by the ref column
at line 73
ChildExport
findOneByPosition(
int $position)
Return the first ChildExport filtered by the position column
at line 73
ChildExport
findOneByExportCategoryId(
int $export_category_id)
Return the first ChildExport filtered by the exportcategoryid column
at line 73
ChildExport
findOneByHandleClass(
string $handle_class)
Return the first ChildExport filtered by the handle_class column
at line 73
ChildExport
findOneByCreatedAt(
string $created_at)
Return the first ChildExport filtered by the created_at column
at line 73
ChildExport
findOneByUpdatedAt(
string $updated_at)
Return the first ChildExport filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildExport objects filtered by the id column
at line 73
array
findByRef(
string $ref)
Return ChildExport objects filtered by the ref column
at line 73
array
findByPosition(
int $position)
Return ChildExport objects filtered by the position column
at line 73
array
findByExportCategoryId(
int $export_category_id)
Return ChildExport objects filtered by the exportcategoryid column
at line 73
array
findByHandleClass(
string $handle_class)
Return ChildExport objects filtered by the handle_class column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildExport objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildExport objects filtered by the updated_at column