LangQuery
class LangQuery extends ModelCriteria
Base class that represents a query for the 'lang' table.
Methods
Initializes internal state of \Thelia\Model\Base\LangQuery object.
Returns a new ChildLangQuery object.
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 title column
Filter the query on the code column
Filter the query on the locale column
Filter the query on the url column
Filter the query on the date_format column
Filter the query on the time_format column
Filter the query on the datetime_format column
Filter the query on the decimal_separator column
Filter the query on the thousands_separator column
Filter the query on the active column
Filter the query on the visible column
Filter the query on the decimals column
Filter the query on the by_default 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\Customer object
Adds a JOIN clause to the query using the Customer relation
Use the Customer relation Customer object
Filter the query by a related \Thelia\Model\Order object
Adds a JOIN clause to the query using the Order relation
Use the Order relation Order object
Deletes all rows from the lang table.
Performs a DELETE on the database, given a ChildLang 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
Order by the id column
Order by the title column
Order by the code column
Order by the locale column
Order by the url column
Order by the date_format column
Order by the time_format column
Order by the datetime_format column
Order by the decimal_separator column
Order by the thousands_separator column
Order by the active column
Order by the visible column
Order by the decimals column
Order by the by_default 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 title column
Group by the code column
Group by the locale column
Group by the url column
Group by the date_format column
Group by the time_format column
Group by the datetime_format column
Group by the decimal_separator column
Group by the thousands_separator column
Group by the active column
Group by the visible column
Group by the decimals column
Group by the by_default 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 Customer relation
Adds a RIGHT JOIN clause to the query using the Customer relation
Adds a INNER JOIN clause to the query using the Customer relation
Adds a LEFT JOIN clause to the query using the Order relation
Adds a RIGHT JOIN clause to the query using the Order relation
Adds a INNER JOIN clause to the query using the Order relation
Return the first ChildLang matching the query
Return the first ChildLang matching the query, or a new ChildLang object populated from the query conditions when no match is found
Return the first ChildLang filtered by the id column
Return the first ChildLang filtered by the title column
Return the first ChildLang filtered by the code column
Return the first ChildLang filtered by the locale column
Return the first ChildLang filtered by the url column
Return the first ChildLang filtered by the date_format column
Return the first ChildLang filtered by the time_format column
Return the first ChildLang filtered by the datetime_format column
Return the first ChildLang filtered by the decimal_separator column
Return the first ChildLang filtered by the thousands_separator column
Return the first ChildLang filtered by the active column
Return the first ChildLang filtered by the visible column
Return the first ChildLang filtered by the decimals column
Return the first ChildLang filtered by the by_default column
Return the first ChildLang filtered by the position column
Return the first ChildLang filtered by the created_at column
Return the first ChildLang filtered by the updated_at column
Return ChildLang objects filtered by the id column
Return ChildLang objects filtered by the title column
Return ChildLang objects filtered by the code column
Return ChildLang objects filtered by the locale column
Return ChildLang objects filtered by the url column
Return ChildLang objects filtered by the date_format column
Return ChildLang objects filtered by the time_format column
Return ChildLang objects filtered by the datetime_format column
Return ChildLang objects filtered by the decimal_separator column
Return ChildLang objects filtered by the thousands_separator column
Return ChildLang objects filtered by the active column
Return ChildLang objects filtered by the visible column
Return ChildLang objects filtered by the decimals column
Return ChildLang objects filtered by the by_default column
Return ChildLang objects filtered by the position column
Return ChildLang objects filtered by the created_at column
Return ChildLang objects filtered by the updated_at column
Details
at line 122
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Lang',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\LangQuery object.
at line 135
static
LangQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildLangQuery object.
at line 165
Lang|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 247
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 268
LangQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 281
LangQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 305
LangQuery
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 343
LangQuery
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 372
LangQuery
filterByCode(
string $code = null,
string $comparison = null)
Filter the query on the code column
Example usage:
$query->filterByCode('fooValue'); // WHERE code = 'fooValue'
$query->filterByCode('%fooValue%'); // WHERE code LIKE '%fooValue%'
at line 401
LangQuery
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 430
LangQuery
filterByUrl(
string $url = null,
string $comparison = null)
Filter the query on the url column
Example usage:
$query->filterByUrl('fooValue'); // WHERE url = 'fooValue'
$query->filterByUrl('%fooValue%'); // WHERE url LIKE '%fooValue%'
at line 459
LangQuery
filterByDateFormat(
string $dateFormat = null,
string $comparison = null)
Filter the query on the date_format column
Example usage:
$query->filterByDateFormat('fooValue'); // WHERE dateformat = 'fooValue'
$query->filterByDateFormat('%fooValue%'); // WHERE dateformat LIKE '%fooValue%'
at line 488
LangQuery
filterByTimeFormat(
string $timeFormat = null,
string $comparison = null)
Filter the query on the time_format column
Example usage:
$query->filterByTimeFormat('fooValue'); // WHERE timeformat = 'fooValue'
$query->filterByTimeFormat('%fooValue%'); // WHERE timeformat LIKE '%fooValue%'
at line 517
LangQuery
filterByDatetimeFormat(
string $datetimeFormat = null,
string $comparison = null)
Filter the query on the datetime_format column
Example usage:
$query->filterByDatetimeFormat('fooValue'); // WHERE datetimeformat = 'fooValue'
$query->filterByDatetimeFormat('%fooValue%'); // WHERE datetimeformat LIKE '%fooValue%'
at line 546
LangQuery
filterByDecimalSeparator(
string $decimalSeparator = null,
string $comparison = null)
Filter the query on the decimal_separator column
Example usage:
$query->filterByDecimalSeparator('fooValue'); // WHERE decimalseparator = 'fooValue'
$query->filterByDecimalSeparator('%fooValue%'); // WHERE decimalseparator LIKE '%fooValue%'
at line 575
LangQuery
filterByThousandsSeparator(
string $thousandsSeparator = null,
string $comparison = null)
Filter the query on the thousands_separator column
Example usage:
$query->filterByThousandsSeparator('fooValue'); // WHERE thousandsseparator = 'fooValue'
$query->filterByThousandsSeparator('%fooValue%'); // WHERE thousandsseparator LIKE '%fooValue%'
at line 607
LangQuery
filterByActive(
boolean|string $active = null,
string $comparison = null)
Filter the query on the active column
Example usage:
$query->filterByActive(true); // WHERE active = true
$query->filterByActive('yes'); // WHERE active = true
at line 634
LangQuery
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 672
LangQuery
filterByDecimals(
string $decimals = null,
string $comparison = null)
Filter the query on the decimals column
Example usage:
$query->filterByDecimals('fooValue'); // WHERE decimals = 'fooValue'
$query->filterByDecimals('%fooValue%'); // WHERE decimals LIKE '%fooValue%'
at line 704
LangQuery
filterByByDefault(
mixed $byDefault = null,
string $comparison = null)
Filter the query on the by_default column
Example usage:
$query->filterByByDefault(1234); // WHERE bydefault = 1234
$query->filterByByDefault(array(12, 34)); // WHERE bydefault IN (12, 34)
$query->filterByByDefault(array('min' => 12)); // WHERE by_default > 12
at line 745
LangQuery
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 788
LangQuery
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 831
LangQuery
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 862
LangQuery
filterByCustomer(
Customer|ObjectCollection $customer,
string $comparison = null)
Filter the query by a related \Thelia\Model\Customer object
at line 885
LangQuery
joinCustomer(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Customer relation
at line 920
CustomerQuery
useCustomerQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Customer relation Customer object
at line 935
LangQuery
filterByOrder(
Order|ObjectCollection $order,
string $comparison = null)
Filter the query by a related \Thelia\Model\Order object
at line 958
LangQuery
joinOrder(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Order relation
at line 993
OrderQuery
useOrderQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Order relation Order object
at line 1022
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the lang table.
at line 1059
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildLang or Criteria object OR a primary key value.
at line 1100
LangQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 1112
LangQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 1122
LangQuery
lastUpdatedFirst()
Order by update date desc
at line 1132
LangQuery
firstUpdatedFirst()
Order by update date asc
at line 1142
LangQuery
lastCreatedFirst()
Order by create date desc
at line 1152
LangQuery
firstCreatedFirst()
Order by create date asc
at line 112
ChildLangQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 112
ChildLangQuery
orderByTitle($order = Criteria::ASC)
Order by the title column
at line 112
ChildLangQuery
orderByCode($order = Criteria::ASC)
Order by the code column
at line 112
ChildLangQuery
orderByLocale($order = Criteria::ASC)
Order by the locale column
at line 112
ChildLangQuery
orderByUrl($order = Criteria::ASC)
Order by the url column
at line 112
ChildLangQuery
orderByDateFormat($order = Criteria::ASC)
Order by the date_format column
at line 112
ChildLangQuery
orderByTimeFormat($order = Criteria::ASC)
Order by the time_format column
at line 112
ChildLangQuery
orderByDatetimeFormat($order = Criteria::ASC)
Order by the datetime_format column
at line 112
ChildLangQuery
orderByDecimalSeparator($order = Criteria::ASC)
Order by the decimal_separator column
at line 112
ChildLangQuery
orderByThousandsSeparator($order = Criteria::ASC)
Order by the thousands_separator column
at line 112
ChildLangQuery
orderByActive($order = Criteria::ASC)
Order by the active column
at line 112
ChildLangQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 112
ChildLangQuery
orderByDecimals($order = Criteria::ASC)
Order by the decimals column
at line 112
ChildLangQuery
orderByByDefault($order = Criteria::ASC)
Order by the by_default column
at line 112
ChildLangQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 112
ChildLangQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 112
ChildLangQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 112
ChildLangQuery
groupById()
Group by the id column
at line 112
ChildLangQuery
groupByTitle()
Group by the title column
at line 112
ChildLangQuery
groupByCode()
Group by the code column
at line 112
ChildLangQuery
groupByLocale()
Group by the locale column
at line 112
ChildLangQuery
groupByUrl()
Group by the url column
at line 112
ChildLangQuery
groupByDateFormat()
Group by the date_format column
at line 112
ChildLangQuery
groupByTimeFormat()
Group by the time_format column
at line 112
ChildLangQuery
groupByDatetimeFormat()
Group by the datetime_format column
at line 112
ChildLangQuery
groupByDecimalSeparator()
Group by the decimal_separator column
at line 112
ChildLangQuery
groupByThousandsSeparator()
Group by the thousands_separator column
at line 112
ChildLangQuery
groupByActive()
Group by the active column
at line 112
ChildLangQuery
groupByVisible()
Group by the visible column
at line 112
ChildLangQuery
groupByDecimals()
Group by the decimals column
at line 112
ChildLangQuery
groupByByDefault()
Group by the by_default column
at line 112
ChildLangQuery
groupByPosition()
Group by the position column
at line 112
ChildLangQuery
groupByCreatedAt()
Group by the created_at column
at line 112
ChildLangQuery
groupByUpdatedAt()
Group by the updated_at column
at line 112
ChildLangQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 112
ChildLangQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 112
ChildLangQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 112
ChildLangQuery
leftJoinCustomer($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Customer relation
at line 112
ChildLangQuery
rightJoinCustomer($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Customer relation
at line 112
ChildLangQuery
innerJoinCustomer($relationAlias = null)
Adds a INNER JOIN clause to the query using the Customer relation
at line 112
ChildLangQuery
leftJoinOrder($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Order relation
at line 112
ChildLangQuery
rightJoinOrder($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Order relation
at line 112
ChildLangQuery
innerJoinOrder($relationAlias = null)
Adds a INNER JOIN clause to the query using the Order relation
at line 112
ChildLang
findOne(
ConnectionInterface $con = null)
Return the first ChildLang matching the query
at line 112
ChildLang
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildLang matching the query, or a new ChildLang object populated from the query conditions when no match is found
at line 112
ChildLang
findOneById(
int $id)
Return the first ChildLang filtered by the id column
at line 112
ChildLang
findOneByTitle(
string $title)
Return the first ChildLang filtered by the title column
at line 112
ChildLang
findOneByCode(
string $code)
Return the first ChildLang filtered by the code column
at line 112
ChildLang
findOneByLocale(
string $locale)
Return the first ChildLang filtered by the locale column
at line 112
ChildLang
findOneByUrl(
string $url)
Return the first ChildLang filtered by the url column
at line 112
ChildLang
findOneByDateFormat(
string $date_format)
Return the first ChildLang filtered by the date_format column
at line 112
ChildLang
findOneByTimeFormat(
string $time_format)
Return the first ChildLang filtered by the time_format column
at line 112
ChildLang
findOneByDatetimeFormat(
string $datetime_format)
Return the first ChildLang filtered by the datetime_format column
at line 112
ChildLang
findOneByDecimalSeparator(
string $decimal_separator)
Return the first ChildLang filtered by the decimal_separator column
at line 112
ChildLang
findOneByThousandsSeparator(
string $thousands_separator)
Return the first ChildLang filtered by the thousands_separator column
at line 112
ChildLang
findOneByActive(
boolean $active)
Return the first ChildLang filtered by the active column
at line 112
ChildLang
findOneByVisible(
int $visible)
Return the first ChildLang filtered by the visible column
at line 112
ChildLang
findOneByDecimals(
string $decimals)
Return the first ChildLang filtered by the decimals column
at line 112
ChildLang
findOneByByDefault(
int $by_default)
Return the first ChildLang filtered by the by_default column
at line 112
ChildLang
findOneByPosition(
int $position)
Return the first ChildLang filtered by the position column
at line 112
ChildLang
findOneByCreatedAt(
string $created_at)
Return the first ChildLang filtered by the created_at column
at line 112
ChildLang
findOneByUpdatedAt(
string $updated_at)
Return the first ChildLang filtered by the updated_at column
at line 112
array
findById(
int $id)
Return ChildLang objects filtered by the id column
at line 112
array
findByTitle(
string $title)
Return ChildLang objects filtered by the title column
at line 112
array
findByCode(
string $code)
Return ChildLang objects filtered by the code column
at line 112
array
findByLocale(
string $locale)
Return ChildLang objects filtered by the locale column
at line 112
array
findByUrl(
string $url)
Return ChildLang objects filtered by the url column
at line 112
array
findByDateFormat(
string $date_format)
Return ChildLang objects filtered by the date_format column
at line 112
array
findByTimeFormat(
string $time_format)
Return ChildLang objects filtered by the time_format column
at line 112
array
findByDatetimeFormat(
string $datetime_format)
Return ChildLang objects filtered by the datetime_format column
at line 112
array
findByDecimalSeparator(
string $decimal_separator)
Return ChildLang objects filtered by the decimal_separator column
at line 112
array
findByThousandsSeparator(
string $thousands_separator)
Return ChildLang objects filtered by the thousands_separator column
at line 112
array
findByActive(
boolean $active)
Return ChildLang objects filtered by the active column
at line 112
array
findByVisible(
int $visible)
Return ChildLang objects filtered by the visible column
at line 112
array
findByDecimals(
string $decimals)
Return ChildLang objects filtered by the decimals column
at line 112
array
findByByDefault(
int $by_default)
Return ChildLang objects filtered by the by_default column
at line 112
array
findByPosition(
int $position)
Return ChildLang objects filtered by the position column
at line 112
array
findByCreatedAt(
string $created_at)
Return ChildLang objects filtered by the created_at column
at line 112
array
findByUpdatedAt(
string $updated_at)
Return ChildLang objects filtered by the updated_at column