Get profile id by email.
| public static getIdByEmail ( string $email ) : integer | ||
| string | Email address. | |
| 리턴 | integer | |
/**
* Get the login/profile status for the given e-mail and password.
*
* @param string $email Profile email address.
* @param string $password Profile password.
* @return string One of the FrontendProfilesAuthentication::LOGIN_* constants.
*/
public static function getLoginStatus($email, $password)
{
$email = (string) $email;
$password = (string) $password;
// get profile id
$profileId = FrontendProfilesModel::getIdByEmail($email);
// encrypt password
$encryptedPassword = FrontendProfilesModel::getEncryptedString($password, FrontendProfilesModel::getSetting($profileId, 'salt'));
// get the status
$loginStatus = FrontendModel::getContainer()->get('database')->getVar('SELECT p.status
FROM profiles AS p
WHERE p.email = ? AND p.password = ?', array($email, $encryptedPassword));
return empty($loginStatus) ? self::LOGIN_INVALID : $loginStatus;
}
/**
* Validate the form
*/
private function validateForm()
{
// is the form submitted
if ($this->frm->isSubmitted()) {
// get field
$txtEmail = $this->frm->getField('email');
// field is filled in?
if ($txtEmail->isFilled(FL::getError('EmailIsRequired'))) {
// valid email?
if ($txtEmail->isEmail(FL::getError('EmailIsInvalid'))) {
// email exists?
if (FrontendProfilesModel::existsByEmail($txtEmail->getValue())) {
// get profile id using the filled in email
$profileId = FrontendProfilesModel::getIdByEmail($txtEmail->getValue());
// get profile
$profile = FrontendProfilesModel::get($profileId);
// must be inactive
if ($profile->getStatus() != FrontendProfilesAuthentication::LOGIN_INACTIVE) {
$txtEmail->addError(FL::getError('ProfileIsActive'));
}
} else {
// email don't exist
$txtEmail->addError(FL::getError('EmailIsInvalid'));
}
}
}
// valid login
if ($this->frm->isCorrect()) {
// activation URL
$mailValues['activationUrl'] = SITE_URL . FrontendNavigation::getURLForBlock('Profiles', 'Activate') . '/' . $profile->getSetting('activation_key');
// trigger event
FrontendModel::triggerEvent('Profiles', 'after_resend_activation', array('id' => $profileId));
// send email
$from = $this->get('fork.settings')->get('Core', 'mailer_from');
$replyTo = $this->get('fork.settings')->get('Core', 'mailer_reply_to');
$message = Message::newInstance(FL::getMessage('RegisterSubject'))->setFrom(array($from['email'] => $from['name']))->setTo(array($profile->getEmail() => ''))->setReplyTo(array($replyTo['email'] => $replyTo['name']))->parseHtml('/Profiles/Layout/Templates/Mails/Register.html.twig', $mailValues, true);
$this->get('mailer')->send($message);
// redirect
$this->redirect(SITE_URL . $this->URL->getQueryString() . '?sent=true');
} else {
$this->tpl->assign('resendActivationHasError', true);
}
}
}
/**
* Validate the form.
*/
private function validateForm()
{
// is the form submitted
if ($this->frm->isSubmitted()) {
// get fields
$txtEmail = $this->frm->getField('email');
$txtPassword = $this->frm->getField('password');
$chkRemember = $this->frm->getField('remember');
// required fields
$txtEmail->isFilled(FL::getError('EmailIsRequired'));
$txtPassword->isFilled(FL::getError('PasswordIsRequired'));
// both fields filled in
if ($txtEmail->isFilled() && $txtPassword->isFilled()) {
// valid email?
if ($txtEmail->isEmail(FL::getError('EmailIsInvalid'))) {
// get the status for the given login
$loginStatus = FrontendProfilesAuthentication::getLoginStatus($txtEmail->getValue(), $txtPassword->getValue());
// valid login?
if ($loginStatus !== FrontendProfilesAuthentication::LOGIN_ACTIVE) {
// get the error string to use
$errorString = sprintf(FL::getError('Profiles' . \SpoonFilter::toCamelCase($loginStatus) . 'Login'), FrontendNavigation::getURLForBlock('Profiles', 'ResendActivation'));
// add the error to stack
$this->frm->addError($errorString);
// add the error to the template variables
$this->tpl->assign('loginError', $errorString);
}
}
}
// valid login
if ($this->frm->isCorrect()) {
// get profile id
$profileId = FrontendProfilesModel::getIdByEmail($txtEmail->getValue());
// login
FrontendProfilesAuthentication::login($profileId, $chkRemember->getChecked());
// update salt and password for Dieter's security features
FrontendProfilesAuthentication::updatePassword($profileId, $txtPassword->getValue());
// trigger event
FrontendModel::triggerEvent('Profiles', 'after_logged_in', array('id' => $profileId));
// query string
$queryString = urldecode(\SpoonFilter::getGetValue('queryString', null, SITE_URL));
// redirect
$this->redirect($queryString);
}
}
}
/**
* Validate the form
*/
private function validateForm()
{
// is the form submitted
if ($this->frm->isSubmitted()) {
// get field
$txtEmail = $this->frm->getField('email');
// field is filled in?
if ($txtEmail->isFilled(FL::getError('EmailIsRequired'))) {
// valid email?
if ($txtEmail->isEmail(FL::getError('EmailIsInvalid'))) {
// email exists?
if (!FrontendProfilesModel::existsByEmail($txtEmail->getValue())) {
$txtEmail->addError(FL::getError('EmailIsUnknown'));
}
}
}
// valid login
if ($this->frm->isCorrect()) {
// get profile id
$profileId = FrontendProfilesModel::getIdByEmail($txtEmail->getValue());
// generate forgot password key
$key = FrontendProfilesModel::getEncryptedString($profileId . microtime(), FrontendProfilesModel::getRandomString());
// insert forgot password key
FrontendProfilesModel::setSetting($profileId, 'forgot_password_key', $key);
// reset url
$mailValues['resetUrl'] = SITE_URL . FrontendNavigation::getURLForBlock('Profiles', 'ResetPassword') . '/' . $key;
$mailValues['firstName'] = FrontendProfilesModel::getSetting($profileId, 'first_name');
$mailValues['lastName'] = FrontendProfilesModel::getSetting($profileId, 'last_name');
// trigger event
FrontendModel::triggerEvent('Profiles', 'after_forgot_password', array('id' => $profileId));
// send email
$from = $this->get('fork.settings')->get('Core', 'mailer_from');
$replyTo = $this->get('fork.settings')->get('Core', 'mailer_reply_to');
$message = \Common\Mailer\Message::newInstance(FL::getMessage('ForgotPasswordSubject'))->setFrom(array($from['email'] => $from['name']))->setTo(array($txtEmail->getValue() => ''))->setReplyTo(array($replyTo['email'] => $replyTo['name']))->parseHtml(FRONTEND_MODULES_PATH . '/Profiles/Layout/Templates/Mails/ForgotPassword.tpl', $mailValues, true);
$this->get('mailer')->send($message);
// redirect
$this->redirect(SITE_URL . '/' . $this->URL->getQueryString() . '?sent=true');
} else {
$this->tpl->assign('forgotPasswordHasError', true);
}
}
}