/** * 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; }