public function editPrivate($id = null) { if ($id != null) { $form = new editPrivateMessageForm(); $message = new privateMessageModel(); $data = $message->supervisorLoad($id); $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 privateMessageModel(); $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 loadSupervisorMessages() { $user = new userModel(); $userId = $user->getId(); $date = new DateTime(); $date->setTime(0, 0, 0); $sql = "SELECT id FROM privateMessages WHERE supervisorId = '" . $userId . "' AND expireDate >= '" . $date->format('U') . "' ORDER BY postDate ASC"; $query = $this->db->query($sql); $data = array(); while ($result = $query->fetch_assoc()) { $message = new privateMessageModel(); $data[] = $message->supervisorLoad($result['id']); } return $data; }