MessageQuery
class MessageQuery extends ModelCriteria
Base class that represents a query for the 'message' table.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled |
Methods
Initializes internal state of \Thelia\Model\Base\MessageQuery object.
Returns a new ChildMessageQuery 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 name column
Filter the query on the secured column
Filter the query on the textlayoutfile_name column
Filter the query on the texttemplatefile_name column
Filter the query on the htmllayoutfile_name column
Filter the query on the htmltemplatefile_name 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\MessageI18n object
Adds a JOIN clause to the query using the MessageI18n relation
Use the MessageI18n relation MessageI18n object
Filter the query by a related \Thelia\Model\MessageVersion object
Adds a JOIN clause to the query using the MessageVersion relation
Use the MessageVersion relation MessageVersion object
Deletes all rows from the message table.
Performs a DELETE on the database, given a ChildMessage 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
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Checks whether versioning is enabled
Enables versioning
Disables versioning
Order by the id column
Order by the name column
Order by the secured column
Order by the textlayoutfile_name column
Order by the texttemplatefile_name column
Order by the htmllayoutfile_name column
Order by the htmltemplatefile_name 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 id column
Group by the name column
Group by the secured column
Group by the textlayoutfile_name column
Group by the texttemplatefile_name column
Group by the htmllayoutfile_name column
Group by the htmltemplatefile_name column
Group by the created_at column
Group by the updated_at column
Group by the version 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 MessageI18n relation
Adds a RIGHT JOIN clause to the query using the MessageI18n relation
Adds a INNER JOIN clause to the query using the MessageI18n relation
Adds a LEFT JOIN clause to the query using the MessageVersion relation
Adds a RIGHT JOIN clause to the query using the MessageVersion relation
Adds a INNER JOIN clause to the query using the MessageVersion relation
Return the first ChildMessage matching the query
Return the first ChildMessage matching the query, or a new ChildMessage object populated from the query conditions when no match is found
Return the first ChildMessage filtered by the id column
Return the first ChildMessage filtered by the name column
Return the first ChildMessage filtered by the secured column
Return the first ChildMessage filtered by the textlayoutfile_name column
Return the first ChildMessage filtered by the texttemplatefile_name column
Return the first ChildMessage filtered by the htmllayoutfile_name column
Return the first ChildMessage filtered by the htmltemplatefile_name column
Return the first ChildMessage filtered by the created_at column
Return the first ChildMessage filtered by the updated_at column
Return the first ChildMessage filtered by the version column
Return the first ChildMessage filtered by the versioncreatedat column
Return the first ChildMessage filtered by the versioncreatedby column
Return ChildMessage objects filtered by the id column
Return ChildMessage objects filtered by the name column
Return ChildMessage objects filtered by the secured column
Return ChildMessage objects filtered by the textlayoutfile_name column
Return ChildMessage objects filtered by the texttemplatefile_name column
Return ChildMessage objects filtered by the htmllayoutfile_name column
Return ChildMessage objects filtered by the htmltemplatefile_name column
Return ChildMessage objects filtered by the created_at column
Return ChildMessage objects filtered by the updated_at column
Return ChildMessage objects filtered by the version column
Return ChildMessage objects filtered by the versioncreatedat column
Return ChildMessage objects filtered by the versioncreatedby column
Details
at line 110
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Message',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\MessageQuery object.
at line 123
static
MessageQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildMessageQuery object.
at line 153
Message|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 235
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 256
MessageQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 269
MessageQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 293
MessageQuery
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 331
MessageQuery
filterByName(
string $name = null,
string $comparison = null)
Filter the query on the name column
Example usage:
$query->filterByName('fooValue'); // WHERE name = 'fooValue'
$query->filterByName('%fooValue%'); // WHERE name LIKE '%fooValue%'
at line 363
MessageQuery
filterBySecured(
mixed $secured = null,
string $comparison = null)
Filter the query on the secured column
Example usage:
$query->filterBySecured(1234); // WHERE secured = 1234
$query->filterBySecured(array(12, 34)); // WHERE secured IN (12, 34)
$query->filterBySecured(array('min' => 12)); // WHERE secured > 12
at line 401
MessageQuery
filterByTextLayoutFileName(
string $textLayoutFileName = null,
string $comparison = null)
Filter the query on the textlayoutfile_name column
Example usage:
$query->filterByTextLayoutFileName('fooValue'); // WHERE textlayoutfilename = 'fooValue'
$query->filterByTextLayoutFileName('%fooValue%'); // WHERE textlayoutfilename LIKE '%fooValue%'
at line 430
MessageQuery
filterByTextTemplateFileName(
string $textTemplateFileName = null,
string $comparison = null)
Filter the query on the texttemplatefile_name column
Example usage:
$query->filterByTextTemplateFileName('fooValue'); // WHERE texttemplatefilename = 'fooValue'
$query->filterByTextTemplateFileName('%fooValue%'); // WHERE texttemplatefilename LIKE '%fooValue%'
at line 459
MessageQuery
filterByHtmlLayoutFileName(
string $htmlLayoutFileName = null,
string $comparison = null)
Filter the query on the htmllayoutfile_name column
Example usage:
$query->filterByHtmlLayoutFileName('fooValue'); // WHERE htmllayoutfilename = 'fooValue'
$query->filterByHtmlLayoutFileName('%fooValue%'); // WHERE htmllayoutfilename LIKE '%fooValue%'
at line 488
MessageQuery
filterByHtmlTemplateFileName(
string $htmlTemplateFileName = null,
string $comparison = null)
Filter the query on the htmltemplatefile_name column
Example usage:
$query->filterByHtmlTemplateFileName('fooValue'); // WHERE htmltemplatefilename = 'fooValue'
$query->filterByHtmlTemplateFileName('%fooValue%'); // WHERE htmltemplatefilename LIKE '%fooValue%'
at line 522
MessageQuery
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 565
MessageQuery
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 606
MessageQuery
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
at line 649
MessageQuery
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'
at line 687
MessageQuery
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%'
at line 709
MessageQuery
filterByMessageI18n(
MessageI18n|ObjectCollection $messageI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\MessageI18n object
at line 732
MessageQuery
joinMessageI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the MessageI18n relation
at line 767
MessageI18nQuery
useMessageI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the MessageI18n relation MessageI18n object
at line 782
MessageQuery
filterByMessageVersion(
MessageVersion|ObjectCollection $messageVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\MessageVersion object
at line 805
MessageQuery
joinMessageVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the MessageVersion relation
at line 840
MessageVersionQuery
useMessageVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the MessageVersion relation MessageVersion object
at line 854
MessageQuery
prune(
Message $message = null)
Exclude object from result
at line 869
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the message table.
at line 906
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildMessage or Criteria object OR a primary key value.
at line 947
MessageQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 959
MessageQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 969
MessageQuery
lastUpdatedFirst()
Order by update date desc
at line 979
MessageQuery
firstUpdatedFirst()
Order by update date asc
at line 989
MessageQuery
lastCreatedFirst()
Order by create date desc
at line 999
MessageQuery
firstCreatedFirst()
Order by create date asc
at line 1015
MessageQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
at line 1033
MessageQuery
joinWithI18n(
string $locale = 'en_US',
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query and hydrates the related I18n object.
Shortcut for $c->joinI18n($locale)->with()
at line 1054
MessageI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 1068
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
at line 1076
static
enableVersioning()
Enables versioning
at line 1084
static
disableVersioning()
Disables versioning
at line 93
ChildMessageQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 93
ChildMessageQuery
orderByName($order = Criteria::ASC)
Order by the name column
at line 93
ChildMessageQuery
orderBySecured($order = Criteria::ASC)
Order by the secured column
at line 93
ChildMessageQuery
orderByTextLayoutFileName($order = Criteria::ASC)
Order by the textlayoutfile_name column
at line 93
ChildMessageQuery
orderByTextTemplateFileName($order = Criteria::ASC)
Order by the texttemplatefile_name column
at line 93
ChildMessageQuery
orderByHtmlLayoutFileName($order = Criteria::ASC)
Order by the htmllayoutfile_name column
at line 93
ChildMessageQuery
orderByHtmlTemplateFileName($order = Criteria::ASC)
Order by the htmltemplatefile_name column
at line 93
ChildMessageQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 93
ChildMessageQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 93
ChildMessageQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 93
ChildMessageQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 93
ChildMessageQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 93
ChildMessageQuery
groupById()
Group by the id column
at line 93
ChildMessageQuery
groupByName()
Group by the name column
at line 93
ChildMessageQuery
groupBySecured()
Group by the secured column
at line 93
ChildMessageQuery
groupByTextLayoutFileName()
Group by the textlayoutfile_name column
at line 93
ChildMessageQuery
groupByTextTemplateFileName()
Group by the texttemplatefile_name column
at line 93
ChildMessageQuery
groupByHtmlLayoutFileName()
Group by the htmllayoutfile_name column
at line 93
ChildMessageQuery
groupByHtmlTemplateFileName()
Group by the htmltemplatefile_name column
at line 93
ChildMessageQuery
groupByCreatedAt()
Group by the created_at column
at line 93
ChildMessageQuery
groupByUpdatedAt()
Group by the updated_at column
at line 93
ChildMessageQuery
groupByVersion()
Group by the version column
at line 93
ChildMessageQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 93
ChildMessageQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 93
ChildMessageQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 93
ChildMessageQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 93
ChildMessageQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 93
ChildMessageQuery
leftJoinMessageI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the MessageI18n relation
at line 93
ChildMessageQuery
rightJoinMessageI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the MessageI18n relation
at line 93
ChildMessageQuery
innerJoinMessageI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the MessageI18n relation
at line 93
ChildMessageQuery
leftJoinMessageVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the MessageVersion relation
at line 93
ChildMessageQuery
rightJoinMessageVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the MessageVersion relation
at line 93
ChildMessageQuery
innerJoinMessageVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the MessageVersion relation
at line 93
ChildMessage
findOne(
ConnectionInterface $con = null)
Return the first ChildMessage matching the query
at line 93
ChildMessage
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildMessage matching the query, or a new ChildMessage object populated from the query conditions when no match is found
at line 93
ChildMessage
findOneById(
int $id)
Return the first ChildMessage filtered by the id column
at line 93
ChildMessage
findOneByName(
string $name)
Return the first ChildMessage filtered by the name column
at line 93
ChildMessage
findOneBySecured(
int $secured)
Return the first ChildMessage filtered by the secured column
at line 93
ChildMessage
findOneByTextLayoutFileName(
string $text_layout_file_name)
Return the first ChildMessage filtered by the textlayoutfile_name column
at line 93
ChildMessage
findOneByTextTemplateFileName(
string $text_template_file_name)
Return the first ChildMessage filtered by the texttemplatefile_name column
at line 93
ChildMessage
findOneByHtmlLayoutFileName(
string $html_layout_file_name)
Return the first ChildMessage filtered by the htmllayoutfile_name column
at line 93
ChildMessage
findOneByHtmlTemplateFileName(
string $html_template_file_name)
Return the first ChildMessage filtered by the htmltemplatefile_name column
at line 93
ChildMessage
findOneByCreatedAt(
string $created_at)
Return the first ChildMessage filtered by the created_at column
at line 93
ChildMessage
findOneByUpdatedAt(
string $updated_at)
Return the first ChildMessage filtered by the updated_at column
at line 93
ChildMessage
findOneByVersion(
int $version)
Return the first ChildMessage filtered by the version column
at line 93
ChildMessage
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildMessage filtered by the versioncreatedat column
at line 93
ChildMessage
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildMessage filtered by the versioncreatedby column
at line 93
array
findById(
int $id)
Return ChildMessage objects filtered by the id column
at line 93
array
findByName(
string $name)
Return ChildMessage objects filtered by the name column
at line 93
array
findBySecured(
int $secured)
Return ChildMessage objects filtered by the secured column
at line 93
array
findByTextLayoutFileName(
string $text_layout_file_name)
Return ChildMessage objects filtered by the textlayoutfile_name column
at line 93
array
findByTextTemplateFileName(
string $text_template_file_name)
Return ChildMessage objects filtered by the texttemplatefile_name column
at line 93
array
findByHtmlLayoutFileName(
string $html_layout_file_name)
Return ChildMessage objects filtered by the htmllayoutfile_name column
at line 93
array
findByHtmlTemplateFileName(
string $html_template_file_name)
Return ChildMessage objects filtered by the htmltemplatefile_name column
at line 93
array
findByCreatedAt(
string $created_at)
Return ChildMessage objects filtered by the created_at column
at line 93
array
findByUpdatedAt(
string $updated_at)
Return ChildMessage objects filtered by the updated_at column
at line 93
array
findByVersion(
int $version)
Return ChildMessage objects filtered by the version column
at line 93
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildMessage objects filtered by the versioncreatedat column
at line 93
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildMessage objects filtered by the versioncreatedby column