AdminQuery
class AdminQuery extends ModelCriteria
Base class that represents a query for the 'admin' table.
Methods
Initializes internal state of \Thelia\Model\Base\AdminQuery object.
Returns a new ChildAdminQuery 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 profile_id column
Filter the query on the firstname column
Filter the query on the lastname column
Filter the query on the login column
Filter the query on the password column
Filter the query on the locale column
Filter the query on the algo column
Filter the query on the salt column
Filter the query on the remembermetoken column
Filter the query on the remembermeserial column
Filter the query on the email column
Filter the query on the passwordrenewtoken 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\Profile object
Adds a JOIN clause to the query using the Profile relation
Use the Profile relation Profile object
Deletes all rows from the admin table.
Performs a DELETE on the database, given a ChildAdmin 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 profile_id column
Order by the firstname column
Order by the lastname column
Order by the login column
Order by the password column
Order by the locale column
Order by the algo column
Order by the salt column
Order by the remembermetoken column
Order by the remembermeserial column
Order by the email column
Order by the passwordrenewtoken column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the profile_id column
Group by the firstname column
Group by the lastname column
Group by the login column
Group by the password column
Group by the locale column
Group by the algo column
Group by the salt column
Group by the remembermetoken column
Group by the remembermeserial column
Group by the email column
Group by the passwordrenewtoken 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 Profile relation
Adds a RIGHT JOIN clause to the query using the Profile relation
Adds a INNER JOIN clause to the query using the Profile relation
Return the first ChildAdmin matching the query
Return the first ChildAdmin matching the query, or a new ChildAdmin object populated from the query conditions when no match is found
Return the first ChildAdmin filtered by the id column
Return the first ChildAdmin filtered by the profile_id column
Return the first ChildAdmin filtered by the firstname column
Return the first ChildAdmin filtered by the lastname column
Return the first ChildAdmin filtered by the login column
Return the first ChildAdmin filtered by the password column
Return the first ChildAdmin filtered by the locale column
Return the first ChildAdmin filtered by the algo column
Return the first ChildAdmin filtered by the salt column
Return the first ChildAdmin filtered by the remembermetoken column
Return the first ChildAdmin filtered by the remembermeserial column
Return the first ChildAdmin filtered by the email column
Return the first ChildAdmin filtered by the passwordrenewtoken column
Return the first ChildAdmin filtered by the created_at column
Return the first ChildAdmin filtered by the updated_at column
Return ChildAdmin objects filtered by the id column
Return ChildAdmin objects filtered by the profile_id column
Return ChildAdmin objects filtered by the firstname column
Return ChildAdmin objects filtered by the lastname column
Return ChildAdmin objects filtered by the login column
Return ChildAdmin objects filtered by the password column
Return ChildAdmin objects filtered by the locale column
Return ChildAdmin objects filtered by the algo column
Return ChildAdmin objects filtered by the salt column
Return ChildAdmin objects filtered by the remembermetoken column
Return ChildAdmin objects filtered by the remembermeserial column
Return ChildAdmin objects filtered by the email column
Return ChildAdmin objects filtered by the passwordrenewtoken column
Return ChildAdmin objects filtered by the created_at column
Return ChildAdmin objects filtered by the updated_at column
Details
at line 110
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Admin',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\AdminQuery object.
at line 123
static
AdminQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAdminQuery object.
at line 153
Admin|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
AdminQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 269
AdminQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 293
AdminQuery
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 336
AdminQuery
filterByProfileId(
mixed $profileId = null,
string $comparison = null)
Filter the query on the profile_id column
Example usage:
$query->filterByProfileId(1234); // WHERE profileid = 1234
$query->filterByProfileId(array(12, 34)); // WHERE profileid IN (12, 34)
$query->filterByProfileId(array('min' => 12)); // WHERE profile_id > 12
at line 374
AdminQuery
filterByFirstname(
string $firstname = null,
string $comparison = null)
Filter the query on the firstname column
Example usage:
$query->filterByFirstname('fooValue'); // WHERE firstname = 'fooValue'
$query->filterByFirstname('%fooValue%'); // WHERE firstname LIKE '%fooValue%'
at line 403
AdminQuery
filterByLastname(
string $lastname = null,
string $comparison = null)
Filter the query on the lastname column
Example usage:
$query->filterByLastname('fooValue'); // WHERE lastname = 'fooValue'
$query->filterByLastname('%fooValue%'); // WHERE lastname LIKE '%fooValue%'
at line 432
AdminQuery
filterByLogin(
string $login = null,
string $comparison = null)
Filter the query on the login column
Example usage:
$query->filterByLogin('fooValue'); // WHERE login = 'fooValue'
$query->filterByLogin('%fooValue%'); // WHERE login LIKE '%fooValue%'
at line 461
AdminQuery
filterByPassword(
string $password = null,
string $comparison = null)
Filter the query on the password column
Example usage:
$query->filterByPassword('fooValue'); // WHERE password = 'fooValue'
$query->filterByPassword('%fooValue%'); // WHERE password LIKE '%fooValue%'
at line 490
AdminQuery
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 519
AdminQuery
filterByAlgo(
string $algo = null,
string $comparison = null)
Filter the query on the algo column
Example usage:
$query->filterByAlgo('fooValue'); // WHERE algo = 'fooValue'
$query->filterByAlgo('%fooValue%'); // WHERE algo LIKE '%fooValue%'
at line 548
AdminQuery
filterBySalt(
string $salt = null,
string $comparison = null)
Filter the query on the salt column
Example usage:
$query->filterBySalt('fooValue'); // WHERE salt = 'fooValue'
$query->filterBySalt('%fooValue%'); // WHERE salt LIKE '%fooValue%'
at line 577
AdminQuery
filterByRememberMeToken(
string $rememberMeToken = null,
string $comparison = null)
Filter the query on the remembermetoken column
Example usage:
$query->filterByRememberMeToken('fooValue'); // WHERE remembermetoken = 'fooValue'
$query->filterByRememberMeToken('%fooValue%'); // WHERE remembermetoken LIKE '%fooValue%'
at line 606
AdminQuery
filterByRememberMeSerial(
string $rememberMeSerial = null,
string $comparison = null)
Filter the query on the remembermeserial column
Example usage:
$query->filterByRememberMeSerial('fooValue'); // WHERE remembermeserial = 'fooValue'
$query->filterByRememberMeSerial('%fooValue%'); // WHERE remembermeserial LIKE '%fooValue%'
at line 635
AdminQuery
filterByEmail(
string $email = null,
string $comparison = null)
Filter the query on the email column
Example usage:
$query->filterByEmail('fooValue'); // WHERE email = 'fooValue'
$query->filterByEmail('%fooValue%'); // WHERE email LIKE '%fooValue%'
at line 664
AdminQuery
filterByPasswordRenewToken(
string $passwordRenewToken = null,
string $comparison = null)
Filter the query on the passwordrenewtoken column
Example usage:
$query->filterByPasswordRenewToken('fooValue'); // WHERE passwordrenewtoken = 'fooValue'
$query->filterByPasswordRenewToken('%fooValue%'); // WHERE passwordrenewtoken LIKE '%fooValue%'
at line 698
AdminQuery
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 741
AdminQuery
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 772
AdminQuery
filterByProfile(
Profile|ObjectCollection $profile,
string $comparison = null)
Filter the query by a related \Thelia\Model\Profile object
at line 797
AdminQuery
joinProfile(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Profile relation
at line 832
ProfileQuery
useProfileQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Profile relation Profile object
at line 846
AdminQuery
prune(
Admin $admin = null)
Exclude object from result
at line 861
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the admin table.
at line 898
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildAdmin or Criteria object OR a primary key value.
at line 939
AdminQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 951
AdminQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 961
AdminQuery
lastUpdatedFirst()
Order by update date desc
at line 971
AdminQuery
firstUpdatedFirst()
Order by update date asc
at line 981
AdminQuery
lastCreatedFirst()
Order by create date desc
at line 991
AdminQuery
firstCreatedFirst()
Order by create date asc
at line 100
ChildAdminQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 100
ChildAdminQuery
orderByProfileId($order = Criteria::ASC)
Order by the profile_id column
at line 100
ChildAdminQuery
orderByFirstname($order = Criteria::ASC)
Order by the firstname column
at line 100
ChildAdminQuery
orderByLastname($order = Criteria::ASC)
Order by the lastname column
at line 100
ChildAdminQuery
orderByLogin($order = Criteria::ASC)
Order by the login column
at line 100
ChildAdminQuery
orderByPassword($order = Criteria::ASC)
Order by the password column
at line 100
ChildAdminQuery
orderByLocale($order = Criteria::ASC)
Order by the locale column
at line 100
ChildAdminQuery
orderByAlgo($order = Criteria::ASC)
Order by the algo column
at line 100
ChildAdminQuery
orderBySalt($order = Criteria::ASC)
Order by the salt column
at line 100
ChildAdminQuery
orderByRememberMeToken($order = Criteria::ASC)
Order by the remembermetoken column
at line 100
ChildAdminQuery
orderByRememberMeSerial($order = Criteria::ASC)
Order by the remembermeserial column
at line 100
ChildAdminQuery
orderByEmail($order = Criteria::ASC)
Order by the email column
at line 100
ChildAdminQuery
orderByPasswordRenewToken($order = Criteria::ASC)
Order by the passwordrenewtoken column
at line 100
ChildAdminQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 100
ChildAdminQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 100
ChildAdminQuery
groupById()
Group by the id column
at line 100
ChildAdminQuery
groupByProfileId()
Group by the profile_id column
at line 100
ChildAdminQuery
groupByFirstname()
Group by the firstname column
at line 100
ChildAdminQuery
groupByLastname()
Group by the lastname column
at line 100
ChildAdminQuery
groupByLogin()
Group by the login column
at line 100
ChildAdminQuery
groupByPassword()
Group by the password column
at line 100
ChildAdminQuery
groupByLocale()
Group by the locale column
at line 100
ChildAdminQuery
groupByAlgo()
Group by the algo column
at line 100
ChildAdminQuery
groupBySalt()
Group by the salt column
at line 100
ChildAdminQuery
groupByRememberMeToken()
Group by the remembermetoken column
at line 100
ChildAdminQuery
groupByRememberMeSerial()
Group by the remembermeserial column
at line 100
ChildAdminQuery
groupByEmail()
Group by the email column
at line 100
ChildAdminQuery
groupByPasswordRenewToken()
Group by the passwordrenewtoken column
at line 100
ChildAdminQuery
groupByCreatedAt()
Group by the created_at column
at line 100
ChildAdminQuery
groupByUpdatedAt()
Group by the updated_at column
at line 100
ChildAdminQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 100
ChildAdminQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 100
ChildAdminQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 100
ChildAdminQuery
leftJoinProfile($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Profile relation
at line 100
ChildAdminQuery
rightJoinProfile($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Profile relation
at line 100
ChildAdminQuery
innerJoinProfile($relationAlias = null)
Adds a INNER JOIN clause to the query using the Profile relation
at line 100
ChildAdmin
findOne(
ConnectionInterface $con = null)
Return the first ChildAdmin matching the query
at line 100
ChildAdmin
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildAdmin matching the query, or a new ChildAdmin object populated from the query conditions when no match is found
at line 100
ChildAdmin
findOneById(
int $id)
Return the first ChildAdmin filtered by the id column
at line 100
ChildAdmin
findOneByProfileId(
int $profile_id)
Return the first ChildAdmin filtered by the profile_id column
at line 100
ChildAdmin
findOneByFirstname(
string $firstname)
Return the first ChildAdmin filtered by the firstname column
at line 100
ChildAdmin
findOneByLastname(
string $lastname)
Return the first ChildAdmin filtered by the lastname column
at line 100
ChildAdmin
findOneByLogin(
string $login)
Return the first ChildAdmin filtered by the login column
at line 100
ChildAdmin
findOneByPassword(
string $password)
Return the first ChildAdmin filtered by the password column
at line 100
ChildAdmin
findOneByLocale(
string $locale)
Return the first ChildAdmin filtered by the locale column
at line 100
ChildAdmin
findOneByAlgo(
string $algo)
Return the first ChildAdmin filtered by the algo column
at line 100
ChildAdmin
findOneBySalt(
string $salt)
Return the first ChildAdmin filtered by the salt column
at line 100
ChildAdmin
findOneByRememberMeToken(
string $remember_me_token)
Return the first ChildAdmin filtered by the remembermetoken column
at line 100
ChildAdmin
findOneByRememberMeSerial(
string $remember_me_serial)
Return the first ChildAdmin filtered by the remembermeserial column
at line 100
ChildAdmin
findOneByEmail(
string $email)
Return the first ChildAdmin filtered by the email column
at line 100
ChildAdmin
findOneByPasswordRenewToken(
string $password_renew_token)
Return the first ChildAdmin filtered by the passwordrenewtoken column
at line 100
ChildAdmin
findOneByCreatedAt(
string $created_at)
Return the first ChildAdmin filtered by the created_at column
at line 100
ChildAdmin
findOneByUpdatedAt(
string $updated_at)
Return the first ChildAdmin filtered by the updated_at column
at line 100
array
findById(
int $id)
Return ChildAdmin objects filtered by the id column
at line 100
array
findByProfileId(
int $profile_id)
Return ChildAdmin objects filtered by the profile_id column
at line 100
array
findByFirstname(
string $firstname)
Return ChildAdmin objects filtered by the firstname column
at line 100
array
findByLastname(
string $lastname)
Return ChildAdmin objects filtered by the lastname column
at line 100
array
findByLogin(
string $login)
Return ChildAdmin objects filtered by the login column
at line 100
array
findByPassword(
string $password)
Return ChildAdmin objects filtered by the password column
at line 100
array
findByLocale(
string $locale)
Return ChildAdmin objects filtered by the locale column
at line 100
array
findByAlgo(
string $algo)
Return ChildAdmin objects filtered by the algo column
at line 100
array
findBySalt(
string $salt)
Return ChildAdmin objects filtered by the salt column
at line 100
array
findByRememberMeToken(
string $remember_me_token)
Return ChildAdmin objects filtered by the remembermetoken column
at line 100
array
findByRememberMeSerial(
string $remember_me_serial)
Return ChildAdmin objects filtered by the remembermeserial column
at line 100
array
findByEmail(
string $email)
Return ChildAdmin objects filtered by the email column
at line 100
array
findByPasswordRenewToken(
string $password_renew_token)
Return ChildAdmin objects filtered by the passwordrenewtoken column
at line 100
array
findByCreatedAt(
string $created_at)
Return ChildAdmin objects filtered by the created_at column
at line 100
array
findByUpdatedAt(
string $updated_at)
Return ChildAdmin objects filtered by the updated_at column