SaleI18nQuery
class SaleI18nQuery extends ModelCriteria
Base class that represents a query for the 'sale_i18n' table.
Methods
Initializes internal state of \Thelia\Model\Base\SaleI18nQuery object.
Returns a new ChildSaleI18nQuery object.
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 locale column
Filter the query on the title column
Filter the query on the description column
Filter the query on the chapo column
Filter the query on the postscriptum column
Filter the query on the sale_label 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
Deletes all rows from the sale_i18n table.
Performs a DELETE on the database, given a ChildSaleI18n or Criteria object OR a primary key value.
Order by the id column
Order by the locale column
Order by the title column
Order by the description column
Order by the chapo column
Order by the postscriptum column
Order by the sale_label column
Group by the id column
Group by the locale column
Group by the title column
Group by the description column
Group by the chapo column
Group by the postscriptum column
Group by the sale_label 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
Return the first ChildSaleI18n matching the query
Return the first ChildSaleI18n matching the query, or a new ChildSaleI18n object populated from the query conditions when no match is found
Return the first ChildSaleI18n filtered by the id column
Return the first ChildSaleI18n filtered by the locale column
Return the first ChildSaleI18n filtered by the title column
Return the first ChildSaleI18n filtered by the description column
Return the first ChildSaleI18n filtered by the chapo column
Return the first ChildSaleI18n filtered by the postscriptum column
Return the first ChildSaleI18n filtered by the sale_label column
Return ChildSaleI18n objects filtered by the id column
Return ChildSaleI18n objects filtered by the locale column
Return ChildSaleI18n objects filtered by the title column
Return ChildSaleI18n objects filtered by the description column
Return ChildSaleI18n objects filtered by the chapo column
Return ChildSaleI18n objects filtered by the postscriptum column
Return ChildSaleI18n objects filtered by the sale_label column
Details
at line 78
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\SaleI18n',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\SaleI18nQuery object.
at line 91
static
SaleI18nQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildSaleI18nQuery object.
at line 121
SaleI18n|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);
at line 204
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);
at line 225
SaleI18nQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 240
SaleI18nQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 275
SaleI18nQuery
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
SaleI18nQuery
filterByLocale(
string $locale = null,
string $comparison = null)
Filter the query on the locale column
Example usage:
$query->filterByLocale('fooValue'); // WHERE locale = 'fooValue'
$query->filterByLocale('%fooValue%'); // WHERE locale LIKE '%fooValue%'
at line 342
SaleI18nQuery
filterByTitle(
string $title = null,
string $comparison = null)
Filter the query on the title column
Example usage:
$query->filterByTitle('fooValue'); // WHERE title = 'fooValue'
$query->filterByTitle('%fooValue%'); // WHERE title LIKE '%fooValue%'
at line 371
SaleI18nQuery
filterByDescription(
string $description = null,
string $comparison = null)
Filter the query on the description column
Example usage:
$query->filterByDescription('fooValue'); // WHERE description = 'fooValue'
$query->filterByDescription('%fooValue%'); // WHERE description LIKE '%fooValue%'
at line 400
SaleI18nQuery
filterByChapo(
string $chapo = null,
string $comparison = null)
Filter the query on the chapo column
Example usage:
$query->filterByChapo('fooValue'); // WHERE chapo = 'fooValue'
$query->filterByChapo('%fooValue%'); // WHERE chapo LIKE '%fooValue%'
at line 429
SaleI18nQuery
filterByPostscriptum(
string $postscriptum = null,
string $comparison = null)
Filter the query on the postscriptum column
Example usage:
$query->filterByPostscriptum('fooValue'); // WHERE postscriptum = 'fooValue'
$query->filterByPostscriptum('%fooValue%'); // WHERE postscriptum LIKE '%fooValue%'
at line 458
SaleI18nQuery
filterBySaleLabel(
string $saleLabel = null,
string $comparison = null)
Filter the query on the sale_label column
Example usage:
$query->filterBySaleLabel('fooValue'); // WHERE salelabel = 'fooValue'
$query->filterBySaleLabel('%fooValue%'); // WHERE salelabel LIKE '%fooValue%'
at line 480
SaleI18nQuery
filterBySale(
Sale|ObjectCollection $sale,
string $comparison = null)
Filter the query by a related \Thelia\Model\Sale object
at line 505
SaleI18nQuery
joinSale(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the Sale relation
at line 540
SaleQuery
useSaleQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the Sale relation Sale object
at line 554
SaleI18nQuery
prune(
SaleI18n $saleI18n = null)
Exclude object from result
at line 571
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the sale_i18n table.
at line 608
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildSaleI18n or Criteria object OR a primary key value.
at line 68
ChildSaleI18nQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 68
ChildSaleI18nQuery
orderByLocale($order = Criteria::ASC)
Order by the locale column
at line 68
ChildSaleI18nQuery
orderByTitle($order = Criteria::ASC)
Order by the title column
at line 68
ChildSaleI18nQuery
orderByDescription($order = Criteria::ASC)
Order by the description column
at line 68
ChildSaleI18nQuery
orderByChapo($order = Criteria::ASC)
Order by the chapo column
at line 68
ChildSaleI18nQuery
orderByPostscriptum($order = Criteria::ASC)
Order by the postscriptum column
at line 68
ChildSaleI18nQuery
orderBySaleLabel($order = Criteria::ASC)
Order by the sale_label column
at line 68
ChildSaleI18nQuery
groupById()
Group by the id column
at line 68
ChildSaleI18nQuery
groupByLocale()
Group by the locale column
at line 68
ChildSaleI18nQuery
groupByTitle()
Group by the title column
at line 68
ChildSaleI18nQuery
groupByDescription()
Group by the description column
at line 68
ChildSaleI18nQuery
groupByChapo()
Group by the chapo column
at line 68
ChildSaleI18nQuery
groupByPostscriptum()
Group by the postscriptum column
at line 68
ChildSaleI18nQuery
groupBySaleLabel()
Group by the sale_label column
at line 68
ChildSaleI18nQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 68
ChildSaleI18nQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 68
ChildSaleI18nQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 68
ChildSaleI18nQuery
leftJoinSale($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Sale relation
at line 68
ChildSaleI18nQuery
rightJoinSale($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Sale relation
at line 68
ChildSaleI18nQuery
innerJoinSale($relationAlias = null)
Adds a INNER JOIN clause to the query using the Sale relation
at line 68
ChildSaleI18n
findOne(
ConnectionInterface $con = null)
Return the first ChildSaleI18n matching the query
at line 68
ChildSaleI18n
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildSaleI18n matching the query, or a new ChildSaleI18n object populated from the query conditions when no match is found
at line 68
ChildSaleI18n
findOneById(
int $id)
Return the first ChildSaleI18n filtered by the id column
at line 68
ChildSaleI18n
findOneByLocale(
string $locale)
Return the first ChildSaleI18n filtered by the locale column
at line 68
ChildSaleI18n
findOneByTitle(
string $title)
Return the first ChildSaleI18n filtered by the title column
at line 68
ChildSaleI18n
findOneByDescription(
string $description)
Return the first ChildSaleI18n filtered by the description column
at line 68
ChildSaleI18n
findOneByChapo(
string $chapo)
Return the first ChildSaleI18n filtered by the chapo column
at line 68
ChildSaleI18n
findOneByPostscriptum(
string $postscriptum)
Return the first ChildSaleI18n filtered by the postscriptum column
at line 68
ChildSaleI18n
findOneBySaleLabel(
string $sale_label)
Return the first ChildSaleI18n filtered by the sale_label column
at line 68
array
findById(
int $id)
Return ChildSaleI18n objects filtered by the id column
at line 68
array
findByLocale(
string $locale)
Return ChildSaleI18n objects filtered by the locale column
at line 68
array
findByTitle(
string $title)
Return ChildSaleI18n objects filtered by the title column
at line 68
array
findByDescription(
string $description)
Return ChildSaleI18n objects filtered by the description column
at line 68
array
findByChapo(
string $chapo)
Return ChildSaleI18n objects filtered by the chapo column
at line 68
array
findByPostscriptum(
string $postscriptum)
Return ChildSaleI18n objects filtered by the postscriptum column
at line 68
array
findBySaleLabel(
string $sale_label)
Return ChildSaleI18n objects filtered by the sale_label column