ProductDocumentQuery
class ProductDocumentQuery extends ProductDocumentQuery
Skeleton subclass for performing query and update operations on the 'product_document' 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.
Methods
Initializes internal state of \Thelia\Model\Base\ProductDocumentQuery object.
Returns a new ChildProductDocumentQuery 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 product_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\Product object
Adds a JOIN clause to the query using the Product relation
Use the Product relation Product object
Filter the query by a related \Thelia\Model\ProductSaleElementsProductDocument object
Adds a JOIN clause to the query using the ProductSaleElementsProductDocument relation
Use the ProductSaleElementsProductDocument relation ProductSaleElementsProductDocument object
Filter the query by a related \Thelia\Model\ProductDocumentI18n object
Adds a JOIN clause to the query using the ProductDocumentI18n relation
Use the ProductDocumentI18n relation ProductDocumentI18n object
Filter the query by a related ProductSaleElements object using the productsaleelementsproductdocument table as cross reference
Deletes all rows from the product_document table.
Performs a DELETE on the database, given a ChildProductDocument or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
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 product_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 product_id 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 Product relation
Adds a RIGHT JOIN clause to the query using the Product relation
Adds a INNER JOIN clause to the query using the Product relation
Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductDocument relation
Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductDocument relation
Adds a INNER JOIN clause to the query using the ProductSaleElementsProductDocument relation
Adds a LEFT JOIN clause to the query using the ProductDocumentI18n relation
Adds a RIGHT JOIN clause to the query using the ProductDocumentI18n relation
Adds a INNER JOIN clause to the query using the ProductDocumentI18n relation
Return the first ChildProductDocument matching the query
Return the first ChildProductDocument matching the query, or a new ChildProductDocument object populated from the query conditions when no match is found
Return the first ChildProductDocument filtered by the id column
Return the first ChildProductDocument filtered by the product_id column
Return the first ChildProductDocument filtered by the file column
Return the first ChildProductDocument filtered by the visible column
Return the first ChildProductDocument filtered by the position column
Return the first ChildProductDocument filtered by the created_at column
Return the first ChildProductDocument filtered by the updated_at column
Return ChildProductDocument objects filtered by the id column
Return ChildProductDocument objects filtered by the product_id column
Return ChildProductDocument objects filtered by the file column
Return ChildProductDocument objects filtered by the visible column
Return ChildProductDocument objects filtered by the position column
Return ChildProductDocument objects filtered by the created_at column
Return ChildProductDocument objects filtered by the updated_at column
Details
in
ProductDocumentQuery at line 87
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProductDocument',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProductDocumentQuery object.
in
ProductDocumentQuery at line 100
static
ProductDocumentQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProductDocumentQuery object.
in
ProductDocumentQuery at line 130
ProductDocument|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
ProductDocumentQuery at line 212
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
ProductDocumentQuery at line 233
ProductDocumentQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ProductDocumentQuery at line 246
ProductDocumentQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ProductDocumentQuery at line 270
ProductDocumentQuery
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
ProductDocumentQuery at line 313
ProductDocumentQuery
filterByProductId(
mixed $productId = null,
string $comparison = null)
Filter the query on the product_id column
Example usage:
$query->filterByProductId(1234); // WHERE productid = 1234
$query->filterByProductId(array(12, 34)); // WHERE productid IN (12, 34)
$query->filterByProductId(array('min' => 12)); // WHERE product_id > 12
in
ProductDocumentQuery at line 351
ProductDocumentQuery
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%'
in
ProductDocumentQuery at line 383
ProductDocumentQuery
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
ProductDocumentQuery at line 424
ProductDocumentQuery
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
ProductDocumentQuery at line 467
ProductDocumentQuery
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
ProductDocumentQuery at line 510
ProductDocumentQuery
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
ProductDocumentQuery at line 541
ProductDocumentQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
in
ProductDocumentQuery at line 566
ProductDocumentQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Product relation
in
ProductDocumentQuery at line 601
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
in
ProductDocumentQuery at line 616
ProductDocumentQuery
filterByProductSaleElementsProductDocument(
ProductSaleElementsProductDocument|ObjectCollection $productSaleElementsProductDocument,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductSaleElementsProductDocument object
in
ProductDocumentQuery at line 639
ProductDocumentQuery
joinProductSaleElementsProductDocument(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductSaleElementsProductDocument relation
in
ProductDocumentQuery at line 674
ProductSaleElementsProductDocumentQuery
useProductSaleElementsProductDocumentQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductSaleElementsProductDocument relation ProductSaleElementsProductDocument object
in
ProductDocumentQuery at line 689
ProductDocumentQuery
filterByProductDocumentI18n(
ProductDocumentI18n|ObjectCollection $productDocumentI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductDocumentI18n object
in
ProductDocumentQuery at line 712
ProductDocumentQuery
joinProductDocumentI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ProductDocumentI18n relation
in
ProductDocumentQuery at line 747
ProductDocumentI18nQuery
useProductDocumentI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ProductDocumentI18n relation ProductDocumentI18n object
in
ProductDocumentQuery at line 763
ProductDocumentQuery
filterByProductSaleElements(
ProductSaleElements $productSaleElements,
string $comparison = Criteria::EQUAL)
Filter the query by a related ProductSaleElements object using the productsaleelementsproductdocument table as cross reference
in
ProductDocumentQuery at line 778
ProductDocumentQuery
prune(
ProductDocument $productDocument = null)
Exclude object from result
in
ProductDocumentQuery at line 793
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the product_document table.
in
ProductDocumentQuery at line 830
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProductDocument or Criteria object OR a primary key value.
in
ProductDocumentQuery at line 871
ProductDocumentQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ProductDocumentQuery at line 883
ProductDocumentQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ProductDocumentQuery at line 893
ProductDocumentQuery
lastUpdatedFirst()
Order by update date desc
in
ProductDocumentQuery at line 903
ProductDocumentQuery
firstUpdatedFirst()
Order by update date asc
in
ProductDocumentQuery at line 913
ProductDocumentQuery
lastCreatedFirst()
Order by create date desc
in
ProductDocumentQuery at line 923
ProductDocumentQuery
firstCreatedFirst()
Order by create date asc
in
ProductDocumentQuery at line 939
ProductDocumentQuery
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
ProductDocumentQuery at line 957
ProductDocumentQuery
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
ProductDocumentQuery at line 978
ProductDocumentI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByFile($order = Criteria::ASC)
Order by the file column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupById()
Group by the id column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByProductId()
Group by the product_id column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByFile()
Group by the file column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByVisible()
Group by the visible column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByPosition()
Group by the position column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByCreatedAt()
Group by the created_at column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
groupByUpdatedAt()
Group by the updated_at column
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
leftJoinProductSaleElementsProductDocument($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductDocument relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
rightJoinProductSaleElementsProductDocument($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductDocument relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
innerJoinProductSaleElementsProductDocument($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductSaleElementsProductDocument relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
leftJoinProductDocumentI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductDocumentI18n relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
rightJoinProductDocumentI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductDocumentI18n relation
in
ProductDocumentQuery at line 77
ChildProductDocumentQuery
innerJoinProductDocumentI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductDocumentI18n relation
in
ProductDocumentQuery at line 77
ChildProductDocument
findOne(
ConnectionInterface $con = null)
Return the first ChildProductDocument matching the query
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProductDocument matching the query, or a new ChildProductDocument object populated from the query conditions when no match is found
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneById(
int $id)
Return the first ChildProductDocument filtered by the id column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByProductId(
int $product_id)
Return the first ChildProductDocument filtered by the product_id column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByFile(
string $file)
Return the first ChildProductDocument filtered by the file column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByVisible(
int $visible)
Return the first ChildProductDocument filtered by the visible column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByPosition(
int $position)
Return the first ChildProductDocument filtered by the position column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByCreatedAt(
string $created_at)
Return the first ChildProductDocument filtered by the created_at column
in
ProductDocumentQuery at line 77
ChildProductDocument
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProductDocument filtered by the updated_at column
in
ProductDocumentQuery at line 77
array
findById(
int $id)
Return ChildProductDocument objects filtered by the id column
in
ProductDocumentQuery at line 77
array
findByProductId(
int $product_id)
Return ChildProductDocument objects filtered by the product_id column
in
ProductDocumentQuery at line 77
array
findByFile(
string $file)
Return ChildProductDocument objects filtered by the file column
in
ProductDocumentQuery at line 77
array
findByVisible(
int $visible)
Return ChildProductDocument objects filtered by the visible column
in
ProductDocumentQuery at line 77
array
findByPosition(
int $position)
Return ChildProductDocument objects filtered by the position column
in
ProductDocumentQuery at line 77
array
findByCreatedAt(
string $created_at)
Return ChildProductDocument objects filtered by the created_at column
in
ProductDocumentQuery at line 77
array
findByUpdatedAt(
string $updated_at)
Return ChildProductDocument objects filtered by the updated_at column