/**
* Gets newsletter.
*
* @param integer $id
* @return NewsletterModel|null
*/
public function getNewsletterById($id)
{
$newsletterRow = $this->db()->select('*')->from('newsletter')->where(array('id' => $id))->execute()->fetchAssoc();
if (empty($newsletterRow)) {
return null;
}
$newsletterModel = new NewsletterModel();
$newsletterModel->setId($newsletterRow['id']);
$newsletterModel->setUserId($newsletterRow['user_id']);
$newsletterModel->setDateCreated($newsletterRow['date_created']);
$newsletterModel->setSubject($newsletterRow['subject']);
$newsletterModel->setText($newsletterRow['text']);
return $newsletterModel;
}
public function treatAction()
{
$newsletterMapper = new NewsletterMapper();
$this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menuNewsletter'), array('action' => 'index'))->add($this->getTranslator()->trans('add'), array('action' => 'treat'));
if ($this->getRequest()->isPost()) {
$newsletterModel = new NewsletterModel();
$subject = trim($this->getRequest()->getPost('subject'));
$text = trim($this->getRequest()->getPost('text'));
if (empty($subject)) {
$this->addMessage('missingSubject', 'danger');
} elseif (empty($text)) {
$this->addMessage('missingText', 'danger');
} else {
$date = new \Ilch\Date();
$newsletterModel->setDateCreated($date);
$newsletterModel->setUserId($this->getUser()->getId());
$newsletterModel->setSubject($this->getRequest()->getPost('subject'));
$newsletterModel->setText($this->getRequest()->getPost('text'));
$newsletterMapper->save($newsletterModel);
if ($_SESSION['layout'] == $this->getConfig()->get('default_layout') && file_exists(APPLICATION_PATH . '/layouts/' . $this->getConfig()->get('default_layout') . '/views/modules/newsletter/layouts/mail/newsletter.php')) {
$messageTemplate = file_get_contents(APPLICATION_PATH . '/layouts/' . $this->getConfig()->get('default_layout') . '/views/modules/newsletter/layouts/mail/newsletter.php');
} else {
$messageTemplate = file_get_contents(APPLICATION_PATH . '/modules/newsletter/layouts/mail/newsletter.php');
}
$emails = $newsletterMapper->getMail();
foreach ($emails as $email) {
$messageReplace = array('{subject}' => $this->getRequest()->getPost('subject'), '{content}' => $this->getRequest()->getPost('text'), '{sitetitle}' => $this->getConfig()->get('page_title'), '{date}' => $date->format("l, d. F Y", true), '{footer}' => $this->getTranslator()->trans('noReplyMailFooter'), '{unreadable}' => $this->getTranslator()->trans('mailUnreadable', $newsletterMapper->getLastId(), $email->getEmail()), '{unsubscribe}' => $this->getTranslator()->trans('mailUnsubscribe', $email->getEmail()));
$message = str_replace(array_keys($messageReplace), array_values($messageReplace), $messageTemplate);
$mail = new \Ilch\Mail();
$mail->setTo($email->getEmail(), '')->setSubject($this->getRequest()->getPost('subject'))->setFrom($this->getConfig()->get('standardMail'), $this->getConfig()->get('page_title'))->setMessage($message)->addGeneralHeader('Content-type', 'text/html; charset="utf-8"');
$mail->send();
}
$this->addMessage('sendSuccess');
$this->redirect(array('action' => 'index'));
}
}
$emails = $newsletterMapper->getMail();
$this->getView()->set('emails', $emails);
}