ProductVersionQuery
class ProductVersionQuery extends ProductVersionQuery
Skeleton subclass for performing query and update operations on the 'product_version' 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\ProductVersionQuery object.
Returns a new ChildProductVersionQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $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 taxruleid column
Filter the query on the ref column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the template_id column
Filter the query on the brand_id column
Filter the query on the virtual 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\Product object
Adds a JOIN clause to the query using the Product relation
Use the Product relation Product object
Deletes all rows from the product_version table.
Performs a DELETE on the database, given a ChildProductVersion or Criteria object OR a primary key value.
Order by the id column
Order by the taxruleid column
Order by the ref column
Order by the visible column
Order by the position column
Order by the template_id column
Order by the brand_id column
Order by the virtual 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
Group by the template_id column
Group by the versioncreatedat column
Group by the versioncreatedby 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
Return the first ChildProductVersion matching the query
Return the first ChildProductVersion matching the query, or a new ChildProductVersion object populated from the query conditions when no match is found
Return the first ChildProductVersion filtered by the id column
Return the first ChildProductVersion filtered by the taxruleid column
Return the first ChildProductVersion filtered by the ref column
Return the first ChildProductVersion filtered by the visible column
Return the first ChildProductVersion filtered by the position column
Return the first ChildProductVersion filtered by the template_id column
Return the first ChildProductVersion filtered by the brand_id column
Return the first ChildProductVersion filtered by the virtual column
Return the first ChildProductVersion filtered by the created_at column
Return the first ChildProductVersion filtered by the updated_at column
Return the first ChildProductVersion filtered by the version column
Return the first ChildProductVersion filtered by the versioncreatedat column
Return the first ChildProductVersion filtered by the versioncreatedby column
Return ChildProductVersion objects filtered by the id column
Return ChildProductVersion objects filtered by the taxruleid column
Return ChildProductVersion objects filtered by the ref column
Return ChildProductVersion objects filtered by the visible column
Return ChildProductVersion objects filtered by the position column
Return ChildProductVersion objects filtered by the template_id column
Return ChildProductVersion objects filtered by the brand_id column
Return ChildProductVersion objects filtered by the virtual column
Return ChildProductVersion objects filtered by the created_at column
Return ChildProductVersion objects filtered by the updated_at column
Return ChildProductVersion objects filtered by the version column
Return ChildProductVersion objects filtered by the versioncreatedat column
Return ChildProductVersion objects filtered by the versioncreatedby column
Details
in
ProductVersionQuery at line 102
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProductVersion',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProductVersionQuery object.
in
ProductVersionQuery at line 115
static
ProductVersionQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProductVersionQuery object.
in
ProductVersionQuery at line 145
ProductVersion|array|mixed
findPk($key, $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(array(12, 34), $con);
in
ProductVersionQuery at line 228
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
in
ProductVersionQuery at line 249
ProductVersionQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ProductVersionQuery at line 264
ProductVersionQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ProductVersionQuery at line 299
ProductVersionQuery
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
ProductVersionQuery at line 340
ProductVersionQuery
filterByTaxRuleId(
mixed $taxRuleId = null,
string $comparison = null)
Filter the query on the taxruleid column
Example usage:
$query->filterByTaxRuleId(1234); // WHERE taxruleid = 1234
$query->filterByTaxRuleId(array(12, 34)); // WHERE taxruleid IN (12, 34)
$query->filterByTaxRuleId(array('min' => 12)); // WHERE taxruleid > 12
in
ProductVersionQuery at line 378
ProductVersionQuery
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%'
in
ProductVersionQuery at line 410
ProductVersionQuery
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
ProductVersionQuery at line 451
ProductVersionQuery
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
ProductVersionQuery at line 492
ProductVersionQuery
filterByTemplateId(
mixed $templateId = null,
string $comparison = null)
Filter the query on the template_id column
Example usage:
$query->filterByTemplateId(1234); // WHERE templateid = 1234
$query->filterByTemplateId(array(12, 34)); // WHERE templateid IN (12, 34)
$query->filterByTemplateId(array('min' => 12)); // WHERE template_id > 12
in
ProductVersionQuery at line 533
ProductVersionQuery
filterByBrandId(
mixed $brandId = null,
string $comparison = null)
Filter the query on the brand_id column
Example usage:
$query->filterByBrandId(1234); // WHERE brandid = 1234
$query->filterByBrandId(array(12, 34)); // WHERE brandid IN (12, 34)
$query->filterByBrandId(array('min' => 12)); // WHERE brand_id > 12
in
ProductVersionQuery at line 574
ProductVersionQuery
filterByVirtual(
mixed $virtual = null,
string $comparison = null)
Filter the query on the virtual column
Example usage:
$query->filterByVirtual(1234); // WHERE virtual = 1234
$query->filterByVirtual(array(12, 34)); // WHERE virtual IN (12, 34)
$query->filterByVirtual(array('min' => 12)); // WHERE virtual > 12
in
ProductVersionQuery at line 617
ProductVersionQuery
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
ProductVersionQuery at line 660
ProductVersionQuery
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
ProductVersionQuery at line 701
ProductVersionQuery
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
ProductVersionQuery at line 744
ProductVersionQuery
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
ProductVersionQuery at line 782
ProductVersionQuery
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
ProductVersionQuery at line 804
ProductVersionQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
in
ProductVersionQuery at line 829
ProductVersionQuery
joinProduct(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Product relation
in
ProductVersionQuery at line 864
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
in
ProductVersionQuery at line 878
ProductVersionQuery
prune(
ProductVersion $productVersion = null)
Exclude object from result
in
ProductVersionQuery at line 895
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the product_version table.
in
ProductVersionQuery at line 932
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProductVersion or Criteria object OR a primary key value.
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByTaxRuleId($order = Criteria::ASC)
Order by the taxruleid column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByTemplateId($order = Criteria::ASC)
Order by the template_id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByBrandId($order = Criteria::ASC)
Order by the brand_id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByVirtual($order = Criteria::ASC)
Order by the virtual column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupById()
Group by the id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByTaxRuleId()
Group by the taxruleid column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByRef()
Group by the ref column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByVisible()
Group by the visible column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByPosition()
Group by the position column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByTemplateId()
Group by the template_id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByBrandId()
Group by the brand_id column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByVirtual()
Group by the virtual column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByCreatedAt()
Group by the created_at column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByUpdatedAt()
Group by the updated_at column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByVersion()
Group by the version column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
in
ProductVersionQuery at line 92
ChildProductVersionQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ProductVersionQuery at line 92
ChildProductVersionQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ProductVersionQuery at line 92
ChildProductVersionQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ProductVersionQuery at line 92
ChildProductVersionQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
in
ProductVersionQuery at line 92
ChildProductVersionQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
in
ProductVersionQuery at line 92
ChildProductVersionQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
in
ProductVersionQuery at line 92
ChildProductVersion
findOne(
ConnectionInterface $con = null)
Return the first ChildProductVersion matching the query
in
ProductVersionQuery at line 92
ChildProductVersion
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProductVersion matching the query, or a new ChildProductVersion object populated from the query conditions when no match is found
in
ProductVersionQuery at line 92
ChildProductVersion
findOneById(
int $id)
Return the first ChildProductVersion filtered by the id column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByTaxRuleId(
int $tax_rule_id)
Return the first ChildProductVersion filtered by the taxruleid column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByRef(
string $ref)
Return the first ChildProductVersion filtered by the ref column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByVisible(
int $visible)
Return the first ChildProductVersion filtered by the visible column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByPosition(
int $position)
Return the first ChildProductVersion filtered by the position column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByTemplateId(
int $template_id)
Return the first ChildProductVersion filtered by the template_id column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByBrandId(
int $brand_id)
Return the first ChildProductVersion filtered by the brand_id column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByVirtual(
int $virtual)
Return the first ChildProductVersion filtered by the virtual column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByCreatedAt(
string $created_at)
Return the first ChildProductVersion filtered by the created_at column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProductVersion filtered by the updated_at column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByVersion(
int $version)
Return the first ChildProductVersion filtered by the version column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildProductVersion filtered by the versioncreatedat column
in
ProductVersionQuery at line 92
ChildProductVersion
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildProductVersion filtered by the versioncreatedby column
in
ProductVersionQuery at line 92
array
findById(
int $id)
Return ChildProductVersion objects filtered by the id column
in
ProductVersionQuery at line 92
array
findByTaxRuleId(
int $tax_rule_id)
Return ChildProductVersion objects filtered by the taxruleid column
in
ProductVersionQuery at line 92
array
findByRef(
string $ref)
Return ChildProductVersion objects filtered by the ref column
in
ProductVersionQuery at line 92
array
findByVisible(
int $visible)
Return ChildProductVersion objects filtered by the visible column
in
ProductVersionQuery at line 92
array
findByPosition(
int $position)
Return ChildProductVersion objects filtered by the position column
in
ProductVersionQuery at line 92
array
findByTemplateId(
int $template_id)
Return ChildProductVersion objects filtered by the template_id column
in
ProductVersionQuery at line 92
array
findByBrandId(
int $brand_id)
Return ChildProductVersion objects filtered by the brand_id column
in
ProductVersionQuery at line 92
array
findByVirtual(
int $virtual)
Return ChildProductVersion objects filtered by the virtual column
in
ProductVersionQuery at line 92
array
findByCreatedAt(
string $created_at)
Return ChildProductVersion objects filtered by the created_at column
in
ProductVersionQuery at line 92
array
findByUpdatedAt(
string $updated_at)
Return ChildProductVersion objects filtered by the updated_at column
in
ProductVersionQuery at line 92
array
findByVersion(
int $version)
Return ChildProductVersion objects filtered by the version column
in
ProductVersionQuery at line 92
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildProductVersion objects filtered by the versioncreatedat column
in
ProductVersionQuery at line 92
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildProductVersion objects filtered by the versioncreatedby column