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