public function edit($id = null) { if ($id != null) { $form = new editMessageForm(); $message = new messageModel(); $message->load($id); $this->view->id = $message->getId(); $data['id'] = $message->getId(); $data['message'] = $message->getMessage(); $data['expireDate'] = $message->getExpireDate(); $form->setAction($this->_link(array('messages', 'edit', $message->getId()))); $form->addData($data); if ($form->wasSubmitted()) { $form->addData($_POST); if ($form->validate()) { $data = $form->exportFormData(); $message = new messageModel(); $message->setId($id); $message->setMessage($data['message']); $message->setExpireDate($data['expireDate']); $message->save(); header("location:" . $this->_link(array('messages')) . ""); } else { $this->view->form = $form; } } else { $this->view->form = $form; } } else { header("location: " . $this->_link(array('messages')) . ""); } }
private function loadExpiredSystemMessages() { $user = new userModel(); $uid = $user->getId(); $date = new DateTime(); $date->setTime(23, 59, 59); $timestamp = $date->format('U'); $sql = "SELECT id FROM messages WHERE expireDate < '{$timestamp}' ORDER BY postDate ASC"; $query = $this->db->query($sql); $data = array(); while ($result = $query->fetch_assoc()) { $message = new messageModel(); $data[] = $message->load($result['id']); } return $data; }