/**
* Forward Tracker
*
* @return void
*/
private function forwardTrackingTask()
{
//get reqest vars
$token = Request::getVar('t', '');
//parse mailing token
$recipient = Helper::parseMailingToken($token);
//if we found an object lets track it
if (is_object($recipient) && $recipient->id) {
//new mailing recipient action objec
$newsletterMailingRecipientAction = new MailingRecipientAction($this->database);
//create object holding our vars to store action
$action = new stdClass();
$action->mailingid = $recipient->mid;
$action->action = 'forward';
$action->action_vars = null;
$action->email = $recipient->email;
$action->ip = $_SERVER['REMOTE_ADDR'];
$action->user_agent = $_SERVER['HTTP_USER_AGENT'];
$action->date = \Date::toSql();
//save action
$newsletterMailingRecipientAction->save($action);
}
}
/**
* Unsubscribe User Mailing Lists
*
* @return void
*/
public function doUnsubscribeTask()
{
//get request vars
$email = urldecode(Request::getVar('e', ''));
$token = Request::getVar('t', '');
$reason = Request::getVar('reason', '');
$reason_alt = Request::getVar('reason-alt', '');
//grab the reason explaination if user selected other
if ($reason == 'Other') {
$reason = $reason_alt;
}
//parse mailing token
$recipient = Helper::parseMailingToken($token);
//make sure the token is valid
if (!is_object($recipient) || $email != $recipient->email) {
App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe'), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_LINK_ISSUE'), 'error');
return;
}
//get newsletter mailing to get mailing list id mailing was sent to
$newsletterMailing = new Mailing($this->database);
$mailing = $newsletterMailing->getMailings($recipient->mid);
//make sure we have a mailing object
if (!is_object($mailing)) {
App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe'), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_NO_MAILING'), 'error');
return;
}
//are we unsubscribing from default list?
$sql = '';
if ($mailing->lid == '-1') {
if (!User::isGuest()) {
$sql = "UPDATE #__xprofiles SET mailPreferenceOption=0 WHERE uidNumber=" . $this->database->quote(User::get('id'));
} else {
//build return url and redirect url
$return = Route::url('index.php?option=com_newsletter&task=unsubscribe&e=' . $email . '&t=' . $token);
//inform user and redirect
App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return)), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_MUST_LOGIN'), 'warning');
return;
}
} else {
//update the emails status on the mailing list
$sql = "UPDATE #__newsletter_mailinglist_emails\n\t\t\t\t\tSET status=" . $this->database->quote('unsubscribed') . "\n\t\t\t\t\tWHERE mid=" . $this->database->quote($mailing->lid) . "\n\t\t\t\t\tAND email=" . $this->database->quote($recipient->email);
}
//set query and execute
$this->database->setQuery($sql);
if (!$this->database->query()) {
App::redirect(Route::url('index.php?option=com_newsletter&task=unsubscribe&e=' . $email . '&t=' . $token), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_ERROR'), 'error');
return;
}
//insert unsubscribe reason
$sql = "INSERT INTO #__newsletter_mailinglist_unsubscribes(mid,email,reason)\n\t\t\t\tVALUES(" . $this->database->quote($mailing->lid) . "," . $this->database->quote($recipient->email) . "," . $this->database->quote($reason) . ")";
$this->database->setQuery($sql);
$this->database->query();
//inform user of successful unsubscribe
Notify::success(Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_SUCCESS'));
if (User::isGuest()) {
App::redirect(Route::url('index.php?option=com_newsletter'));
return;
}
App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe'));
}
