ProductImageQuery
class ProductImageQuery extends ModelCriteria
Base class that represents a query for the 'product_image' table.
Methods
Initializes internal state of \Thelia\Model\Base\ProductImageQuery object.
Returns a new ChildProductImageQuery 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\ProductSaleElementsProductImage object
Adds a JOIN clause to the query using the ProductSaleElementsProductImage relation
Use the ProductSaleElementsProductImage relation ProductSaleElementsProductImage object
Filter the query by a related \Thelia\Model\ProductImageI18n object
Adds a JOIN clause to the query using the ProductImageI18n relation
Use the ProductImageI18n relation ProductImageI18n object
Filter the query by a related ProductSaleElements object using the productsaleelementsproductimage table as cross reference
Deletes all rows from the product_image table.
Performs a DELETE on the database, given a ChildProductImage 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 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 id column
Group by the product_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 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 ProductSaleElementsProductImage relation
Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductImage relation
Adds a INNER JOIN clause to the query using the ProductSaleElementsProductImage relation
Adds a LEFT JOIN clause to the query using the ProductImageI18n relation
Adds a RIGHT JOIN clause to the query using the ProductImageI18n relation
Adds a INNER JOIN clause to the query using the ProductImageI18n relation
Return the first ChildProductImage matching the query
Return the first ChildProductImage matching the query, or a new ChildProductImage object populated from the query conditions when no match is found
Return the first ChildProductImage filtered by the id column
Return the first ChildProductImage filtered by the product_id column
Return the first ChildProductImage filtered by the file column
Return the first ChildProductImage filtered by the visible column
Return the first ChildProductImage filtered by the position column
Return the first ChildProductImage filtered by the created_at column
Return the first ChildProductImage filtered by the updated_at column
Return ChildProductImage objects filtered by the id column
Return ChildProductImage objects filtered by the product_id column
Return ChildProductImage objects filtered by the file column
Return ChildProductImage objects filtered by the visible column
Return ChildProductImage objects filtered by the position column
Return ChildProductImage objects filtered by the created_at column
Return ChildProductImage objects filtered by the updated_at column
Details
at line 87
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProductImage',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProductImageQuery object.
at line 100
static
ProductImageQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProductImageQuery object.
at line 130
ProductImage|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 212
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 233
ProductImageQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 246
ProductImageQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 270
ProductImageQuery
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 313
ProductImageQuery
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
at line 351
ProductImageQuery
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 383
ProductImageQuery
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 424
ProductImageQuery
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 467
ProductImageQuery
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 510
ProductImageQuery
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 541
ProductImageQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 566
ProductImageQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Product relation
at line 601
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
at line 616
ProductImageQuery
filterByProductSaleElementsProductImage(
ProductSaleElementsProductImage|ObjectCollection $productSaleElementsProductImage,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductSaleElementsProductImage object
at line 639
ProductImageQuery
joinProductSaleElementsProductImage(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductSaleElementsProductImage relation
at line 674
ProductSaleElementsProductImageQuery
useProductSaleElementsProductImageQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductSaleElementsProductImage relation ProductSaleElementsProductImage object
at line 689
ProductImageQuery
filterByProductImageI18n(
ProductImageI18n|ObjectCollection $productImageI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProductImageI18n object
at line 712
ProductImageQuery
joinProductImageI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ProductImageI18n relation
at line 747
ProductImageI18nQuery
useProductImageI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ProductImageI18n relation ProductImageI18n object
at line 763
ProductImageQuery
filterByProductSaleElements(
ProductSaleElements $productSaleElements,
string $comparison = Criteria::EQUAL)
Filter the query by a related ProductSaleElements object using the productsaleelementsproductimage table as cross reference
at line 778
ProductImageQuery
prune(
ProductImage $productImage = null)
Exclude object from result
at line 793
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the product_image table.
at line 830
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProductImage or Criteria object OR a primary key value.
at line 871
ProductImageQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 883
ProductImageQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 893
ProductImageQuery
lastUpdatedFirst()
Order by update date desc
at line 903
ProductImageQuery
firstUpdatedFirst()
Order by update date asc
at line 913
ProductImageQuery
lastCreatedFirst()
Order by create date desc
at line 923
ProductImageQuery
firstCreatedFirst()
Order by create date asc
at line 939
ProductImageQuery
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 957
ProductImageQuery
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 978
ProductImageI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 77
ChildProductImageQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 77
ChildProductImageQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
at line 77
ChildProductImageQuery
orderByFile($order = Criteria::ASC)
Order by the file column
at line 77
ChildProductImageQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 77
ChildProductImageQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 77
ChildProductImageQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 77
ChildProductImageQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 77
ChildProductImageQuery
groupById()
Group by the id column
at line 77
ChildProductImageQuery
groupByProductId()
Group by the product_id column
at line 77
ChildProductImageQuery
groupByFile()
Group by the file column
at line 77
ChildProductImageQuery
groupByVisible()
Group by the visible column
at line 77
ChildProductImageQuery
groupByPosition()
Group by the position column
at line 77
ChildProductImageQuery
groupByCreatedAt()
Group by the created_at column
at line 77
ChildProductImageQuery
groupByUpdatedAt()
Group by the updated_at column
at line 77
ChildProductImageQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 77
ChildProductImageQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 77
ChildProductImageQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 77
ChildProductImageQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
at line 77
ChildProductImageQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
at line 77
ChildProductImageQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
at line 77
ChildProductImageQuery
leftJoinProductSaleElementsProductImage($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductSaleElementsProductImage relation
at line 77
ChildProductImageQuery
rightJoinProductSaleElementsProductImage($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductSaleElementsProductImage relation
at line 77
ChildProductImageQuery
innerJoinProductSaleElementsProductImage($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductSaleElementsProductImage relation
at line 77
ChildProductImageQuery
leftJoinProductImageI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductImageI18n relation
at line 77
ChildProductImageQuery
rightJoinProductImageI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductImageI18n relation
at line 77
ChildProductImageQuery
innerJoinProductImageI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductImageI18n relation
at line 77
ChildProductImage
findOne(
ConnectionInterface $con = null)
Return the first ChildProductImage matching the query
at line 77
ChildProductImage
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProductImage matching the query, or a new ChildProductImage object populated from the query conditions when no match is found
at line 77
ChildProductImage
findOneById(
int $id)
Return the first ChildProductImage filtered by the id column
at line 77
ChildProductImage
findOneByProductId(
int $product_id)
Return the first ChildProductImage filtered by the product_id column
at line 77
ChildProductImage
findOneByFile(
string $file)
Return the first ChildProductImage filtered by the file column
at line 77
ChildProductImage
findOneByVisible(
int $visible)
Return the first ChildProductImage filtered by the visible column
at line 77
ChildProductImage
findOneByPosition(
int $position)
Return the first ChildProductImage filtered by the position column
at line 77
ChildProductImage
findOneByCreatedAt(
string $created_at)
Return the first ChildProductImage filtered by the created_at column
at line 77
ChildProductImage
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProductImage filtered by the updated_at column
at line 77
array
findById(
int $id)
Return ChildProductImage objects filtered by the id column
at line 77
array
findByProductId(
int $product_id)
Return ChildProductImage objects filtered by the product_id column
at line 77
array
findByFile(
string $file)
Return ChildProductImage objects filtered by the file column
at line 77
array
findByVisible(
int $visible)
Return ChildProductImage objects filtered by the visible column
at line 77
array
findByPosition(
int $position)
Return ChildProductImage objects filtered by the position column
at line 77
array
findByCreatedAt(
string $created_at)
Return ChildProductImage objects filtered by the created_at column
at line 77
array
findByUpdatedAt(
string $updated_at)
Return ChildProductImage objects filtered by the updated_at column