/**
* Verifica que el correo electronico este registrado y activado.
* Genera un codigo unico para confirmar por correo electronico el cambio de password
* @param string $email
* @throws Exception
* @return string $changePasswordCode
*/
public function updateChangePasswordCodeforValidUserActive($email)
{
//*
$response = array();
$connection = Yii::app()->db;
$sql = Querys::SEARCH_USER_ACTIVATED;
$command = $connection->createCommand($sql);
$index = 0;
$command->bindValue(++$index, $email, PDO::PARAM_STR);
$data = $command->query();
foreach ($data as $row) {
$changePasswordCode = CodeGenerator::generateChangePasswordCode($email, $row['idusers'], $row['name']);
$command->update('users', array('change_password_code' => $changePasswordCode), 'idusers=:id', array(':id' => $row['idusers']));
return $changePasswordCode;
}
$connection->active = false;
throw new Exception(Constants::ERROR_DATA_FORM);
}
