SaleProductQuery
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
Initializes internal state of \Thelia\Model\Base\SaleProductQuery object.
Returns a new ChildSaleProductQuery 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 sale_id column
Filter the query on the product_id column
Filter the query on the attributeavid column
Filter the query by a related \Thelia\Model\Sale object
Adds a JOIN clause to the query using the Sale relation
Use the Sale relation Sale object
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\AttributeAv object
Adds a JOIN clause to the query using the AttributeAv relation
Use the AttributeAv relation AttributeAv object
Deletes all rows from the sale_product table.
Performs a DELETE on the database, given a ChildSaleProduct or Criteria object OR a primary key value.
Order by the id column
Order by the sale_id column
Order by the product_id column
Order by the attributeavid column
Group by the attributeavid 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 Sale relation
Adds a RIGHT JOIN clause to the query using the Sale relation
Adds a INNER JOIN clause to the query using the Sale relation
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 AttributeAv relation
Adds a RIGHT JOIN clause to the query using the AttributeAv relation
Adds a INNER JOIN clause to the query using the AttributeAv relation
Return the first ChildSaleProduct matching the query
Return the first ChildSaleProduct matching the query, or a new ChildSaleProduct object populated from the query conditions when no match is found
Return the first ChildSaleProduct filtered by the id column
Return the first ChildSaleProduct filtered by the sale_id column
Return the first ChildSaleProduct filtered by the product_id column
Return the first ChildSaleProduct filtered by the attributeavid column
Return ChildSaleProduct objects filtered by the id column
Return ChildSaleProduct objects filtered by the sale_id column
Return ChildSaleProduct objects filtered by the product_id column
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.
in
SaleProductQuery at line 87
static
SaleProductQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildSaleProductQuery object.
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);
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);
in
SaleProductQuery at line 220
SaleProductQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
SaleProductQuery at line 233
SaleProductQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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
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
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
in
SaleProductQuery at line 417
SaleProductQuery
filterBySale(
Sale|ObjectCollection $sale,
string $comparison = null)
Filter the query by a related \Thelia\Model\Sale object
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
in
SaleProductQuery at line 477
SaleQuery
useSaleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Sale relation Sale object
in
SaleProductQuery at line 492
SaleProductQuery
filterByProduct(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
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
in
SaleProductQuery at line 552
ProductQuery
useProductQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Product relation Product object
in
SaleProductQuery at line 567
SaleProductQuery
filterByAttributeAv(
AttributeAv|ObjectCollection $attributeAv,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeAv object
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
in
SaleProductQuery at line 627
AttributeAvQuery
useAttributeAvQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the AttributeAv relation AttributeAv object
in
SaleProductQuery at line 641
SaleProductQuery
prune(
SaleProduct $saleProduct = null)
Exclude object from result
in
SaleProductQuery at line 656
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the sale_product table.
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.
in
SaleProductQuery at line 64
ChildSaleProductQuery
orderById($order = Criteria::ASC)
Order by the id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
orderBySaleId($order = Criteria::ASC)
Order by the sale_id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
orderByAttributeAvId($order = Criteria::ASC)
Order by the attributeavid column
in
SaleProductQuery at line 64
ChildSaleProductQuery
groupById()
Group by the id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
groupBySaleId()
Group by the sale_id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
groupByProductId()
Group by the product_id column
in
SaleProductQuery at line 64
ChildSaleProductQuery
groupByAttributeAvId()
Group by the attributeavid column
in
SaleProductQuery at line 64
ChildSaleProductQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
SaleProductQuery at line 64
ChildSaleProductQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
SaleProductQuery at line 64
ChildSaleProductQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
SaleProductQuery at line 64
ChildSaleProductQuery
leftJoinSale($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Sale relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
rightJoinSale($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Sale relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
innerJoinSale($relationAlias = null)
Adds a INNER JOIN clause to the query using the Sale relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
leftJoinProduct($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Product relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
rightJoinProduct($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Product relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
innerJoinProduct($relationAlias = null)
Adds a INNER JOIN clause to the query using the Product relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
leftJoinAttributeAv($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeAv relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
rightJoinAttributeAv($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeAv relation
in
SaleProductQuery at line 64
ChildSaleProductQuery
innerJoinAttributeAv($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeAv relation
in
SaleProductQuery at line 64
ChildSaleProduct
findOne(
ConnectionInterface $con = null)
Return the first ChildSaleProduct matching the query
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
in
SaleProductQuery at line 64
ChildSaleProduct
findOneById(
int $id)
Return the first ChildSaleProduct filtered by the id column
in
SaleProductQuery at line 64
ChildSaleProduct
findOneBySaleId(
int $sale_id)
Return the first ChildSaleProduct filtered by the sale_id column
in
SaleProductQuery at line 64
ChildSaleProduct
findOneByProductId(
int $product_id)
Return the first ChildSaleProduct filtered by the product_id column
in
SaleProductQuery at line 64
ChildSaleProduct
findOneByAttributeAvId(
int $attribute_av_id)
Return the first ChildSaleProduct filtered by the attributeavid column
in
SaleProductQuery at line 64
array
findById(
int $id)
Return ChildSaleProduct objects filtered by the id column
in
SaleProductQuery at line 64
array
findBySaleId(
int $sale_id)
Return ChildSaleProduct objects filtered by the sale_id column
in
SaleProductQuery at line 64
array
findByProductId(
int $product_id)
Return ChildSaleProduct objects filtered by the product_id column
in
SaleProductQuery at line 64
array
findByAttributeAvId(
int $attribute_av_id)
Return ChildSaleProduct objects filtered by the attributeavid column