class SaleProductQuery extends SaleProductQuery

Skeleton subclass for performing query and update operations on the 'sale_product' 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

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\SaleProduct', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\SaleProductQuery object.

static  SaleProductQuery
create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildSaleProductQuery object.

SaleProduct|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterBySaleId( mixed $saleId = null, string $comparison = null)

Filter the query on the sale_id column

filterByProductId( mixed $productId = null, string $comparison = null)

Filter the query on the product_id column

filterByAttributeAvId( mixed $attributeAvId = null, string $comparison = null)

Filter the query on the attributeavid column

filterBySale( Sale|ObjectCollection $sale, string $comparison = null)

Filter the query by a related \Thelia\Model\Sale object

joinSale( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Sale relation

useSaleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Sale relation Sale object

filterByProduct( Product|ObjectCollection $product, string $comparison = null)

Filter the query by a related \Thelia\Model\Product object

joinProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Product relation

useProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Product relation Product object

filterByAttributeAv( AttributeAv|ObjectCollection $attributeAv, string $comparison = null)

Filter the query by a related \Thelia\Model\AttributeAv object

joinAttributeAv( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the AttributeAv relation

useAttributeAvQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the AttributeAv relation AttributeAv object

prune( SaleProduct $saleProduct = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the sale_product table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildSaleProduct or Criteria object OR a primary key value.

ChildSaleProductQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildSaleProductQuery
orderBySaleId($order = Criteria::ASC)

Order by the sale_id column

ChildSaleProductQuery
orderByProductId($order = Criteria::ASC)

Order by the product_id column

ChildSaleProductQuery
orderByAttributeAvId($order = Criteria::ASC)

Order by the attributeavid column

ChildSaleProductQuery
groupById()

Group by the id column

ChildSaleProductQuery
groupBySaleId()

Group by the sale_id column

ChildSaleProductQuery
groupByProductId()

Group by the product_id column

ChildSaleProductQuery
groupByAttributeAvId()

Group by the attributeavid column

ChildSaleProductQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildSaleProductQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildSaleProductQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildSaleProductQuery
leftJoinSale($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Sale relation

ChildSaleProductQuery
rightJoinSale($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Sale relation

ChildSaleProductQuery
innerJoinSale($relationAlias = null)

Adds a INNER JOIN clause to the query using the Sale relation

ChildSaleProductQuery
leftJoinProduct($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Product relation

ChildSaleProductQuery
rightJoinProduct($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Product relation

ChildSaleProductQuery
innerJoinProduct($relationAlias = null)

Adds a INNER JOIN clause to the query using the Product relation

ChildSaleProductQuery
leftJoinAttributeAv($relationAlias = null)

Adds a LEFT JOIN clause to the query using the AttributeAv relation

ChildSaleProductQuery
rightJoinAttributeAv($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the AttributeAv relation

ChildSaleProductQuery
innerJoinAttributeAv($relationAlias = null)

Adds a INNER JOIN clause to the query using the AttributeAv relation

ChildSaleProduct
findOne( ConnectionInterface $con = null)

Return the first ChildSaleProduct matching the query

ChildSaleProduct
findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildSaleProduct matching the query, or a new ChildSaleProduct object populated from the query conditions when no match is found

ChildSaleProduct
findOneById( int $id)

Return the first ChildSaleProduct filtered by the id column

ChildSaleProduct
findOneBySaleId( int $sale_id)

Return the first ChildSaleProduct filtered by the sale_id column

ChildSaleProduct
findOneByProductId( int $product_id)

Return the first ChildSaleProduct filtered by the product_id column

ChildSaleProduct
findOneByAttributeAvId( int $attribute_av_id)

Return the first ChildSaleProduct filtered by the attributeavid column

array
findById( int $id)

Return ChildSaleProduct objects filtered by the id column

array
findBySaleId( int $sale_id)

Return ChildSaleProduct objects filtered by the sale_id column

array
findByProductId( int $product_id)

Return ChildSaleProduct objects filtered by the product_id column

array
findByAttributeAvId( int $attribute_av_id)

Return ChildSaleProduct objects filtered by the attributeavid column

Details

in SaleProductQuery at line 74
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\SaleProduct', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\SaleProductQuery object.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

in SaleProductQuery at line 87
static SaleProductQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildSaleProductQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

SaleProductQuery

in SaleProductQuery at line 117
SaleProduct|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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

SaleProduct|array|mixed the result, formatted by the current formatter

in SaleProductQuery at line 199
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

in SaleProductQuery at line 220
SaleProductQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 233
SaleProductQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 257
SaleProductQuery 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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 300
SaleProductQuery filterBySaleId( mixed $saleId = null, string $comparison = null)

Filter the query on the sale_id column

Example usage: $query->filterBySaleId(1234); // WHERE saleid = 1234 $query->filterBySaleId(array(12, 34)); // WHERE saleid IN (12, 34) $query->filterBySaleId(array('min' => 12)); // WHERE sale_id > 12

Parameters

mixed $saleId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

See also

filterBySale()

in SaleProductQuery at line 343
SaleProductQuery 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

Parameters

mixed $productId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

See also

filterByProduct()

in SaleProductQuery at line 386
SaleProductQuery filterByAttributeAvId( mixed $attributeAvId = null, string $comparison = null)

Filter the query on the attributeavid column

Example usage: $query->filterByAttributeAvId(1234); // WHERE attributeavid = 1234 $query->filterByAttributeAvId(array(12, 34)); // WHERE attributeavid IN (12, 34) $query->filterByAttributeAvId(array('min' => 12)); // WHERE attributeavid > 12

Parameters

mixed $attributeAvId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

See also

filterByAttributeAv()

in SaleProductQuery at line 417
SaleProductQuery filterBySale( Sale|ObjectCollection $sale, string $comparison = null)

Filter the query by a related \Thelia\Model\Sale object

Parameters

Sale|ObjectCollection $sale The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 442
SaleProductQuery joinSale( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Sale relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 477
SaleQuery useSaleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Sale relation Sale object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

SaleQuery A secondary query class using the current class as primary query

See also

useQuery()

in SaleProductQuery at line 492
SaleProductQuery filterByProduct( Product|ObjectCollection $product, string $comparison = null)

Filter the query by a related \Thelia\Model\Product object

Parameters

Product|ObjectCollection $product The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 517
SaleProductQuery joinProduct( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Product relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 552
ProductQuery useProductQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Product relation Product object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProductQuery A secondary query class using the current class as primary query

See also

useQuery()

in SaleProductQuery at line 567
SaleProductQuery filterByAttributeAv( AttributeAv|ObjectCollection $attributeAv, string $comparison = null)

Filter the query by a related \Thelia\Model\AttributeAv object

Parameters

AttributeAv|ObjectCollection $attributeAv The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 592
SaleProductQuery joinAttributeAv( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the AttributeAv relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 627
AttributeAvQuery useAttributeAvQuery( string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the AttributeAv relation AttributeAv object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AttributeAvQuery A secondary query class using the current class as primary query

See also

useQuery()

in SaleProductQuery at line 641
SaleProductQuery prune( SaleProduct $saleProduct = null)

Exclude object from result

Parameters

SaleProduct $saleProduct Object to remove from the list of results

Return Value

SaleProductQuery The current query, for fluid interface

in SaleProductQuery at line 656
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the sale_product table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

in SaleProductQuery at line 693
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildSaleProduct or Criteria object OR a primary key value.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

in SaleProductQuery at line 64
ChildSaleProductQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery orderBySaleId($order = Criteria::ASC)

Order by the sale_id column

Parameters

$order

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery orderByProductId($order = Criteria::ASC)

Order by the product_id column

Parameters

$order

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery orderByAttributeAvId($order = Criteria::ASC)

Order by the attributeavid column

Parameters

$order

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery groupById()

Group by the id column

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery groupBySaleId()

Group by the sale_id column

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery groupByProductId()

Group by the product_id column

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery groupByAttributeAvId()

Group by the attributeavid column

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery leftJoinSale($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Sale relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery rightJoinSale($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Sale relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery innerJoinSale($relationAlias = null)

Adds a INNER JOIN clause to the query using the Sale relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery leftJoinProduct($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery rightJoinProduct($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery innerJoinProduct($relationAlias = null)

Adds a INNER JOIN clause to the query using the Product relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery leftJoinAttributeAv($relationAlias = null)

Adds a LEFT JOIN clause to the query using the AttributeAv relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery rightJoinAttributeAv($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the AttributeAv relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProductQuery innerJoinAttributeAv($relationAlias = null)

Adds a INNER JOIN clause to the query using the AttributeAv relation

Parameters

$relationAlias

Return Value

ChildSaleProductQuery

in SaleProductQuery at line 64
ChildSaleProduct findOne( ConnectionInterface $con = null)

Return the first ChildSaleProduct matching the query

Parameters

ConnectionInterface $con

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
ChildSaleProduct findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildSaleProduct matching the query, or a new ChildSaleProduct object populated from the query conditions when no match is found

Parameters

ConnectionInterface $con

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
ChildSaleProduct findOneById( int $id)

Return the first ChildSaleProduct filtered by the id column

Parameters

int $id

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
ChildSaleProduct findOneBySaleId( int $sale_id)

Return the first ChildSaleProduct filtered by the sale_id column

Parameters

int $sale_id

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
ChildSaleProduct findOneByProductId( int $product_id)

Return the first ChildSaleProduct filtered by the product_id column

Parameters

int $product_id

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
ChildSaleProduct findOneByAttributeAvId( int $attribute_av_id)

Return the first ChildSaleProduct filtered by the attributeavid column

Parameters

int $attribute_av_id

Return Value

ChildSaleProduct

in SaleProductQuery at line 64
array findById( int $id)

Return ChildSaleProduct objects filtered by the id column

Parameters

int $id

Return Value

array

in SaleProductQuery at line 64
array findBySaleId( int $sale_id)

Return ChildSaleProduct objects filtered by the sale_id column

Parameters

int $sale_id

Return Value

array

in SaleProductQuery at line 64
array findByProductId( int $product_id)

Return ChildSaleProduct objects filtered by the product_id column

Parameters

int $product_id

Return Value

array

in SaleProductQuery at line 64
array findByAttributeAvId( int $attribute_av_id)

Return ChildSaleProduct objects filtered by the attributeavid column

Parameters

int $attribute_av_id

Return Value

array