public static function getByEmail($email)
{
$db = Database::get();
$data = $db->GetRow("SELECT * FROM pkgNewsletterEmails WHERE email=?", $email);
if (!empty($data)) {
$order = new Email();
$order->setPropertiesFromArray($data);
}
return $order instanceof Email ? $order : false;
}
public function unsubscribe()
{
$email = urldecode($this->get('e'));
$hash = urldecode($this->get('h'));
$json = $this->get('json', false);
if ($email && $hash) {
$nEmail = NewsletterEmail::getByEmail(urldecode($email));
if ($nEmail->eID) {
//
$nEmail->unsubscribed = 1;
$nEmail->save();
$state = 'success';
} else {
$state = 'failure';
}
$this->set('state', 'failure');
if ($json) {
header('Content-Type: application/json');
echo json_encode(array('state' => $state));
exit;
}
}
}
public function getResult($queryRow)
{
return NewsletterEmail::getByID($queryRow['eID']);
}
public function delete($eID)
{
$nEmail = NewsletterEmail::getByID($eID);
$nEmail->delete();
$this->redirect("dashboard/reports/newsletter_emails/");
}