function update($id = FALSE, $getview = FALSE) { if ($_POST) { unset($_POST['send']); unset($_POST['_wysihtml5_mode']); unset($_POST['files']); $id = $_POST['id']; $message = Privatemessage::find($id); $message->update_attributes($_POST); if (!$message) { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_write_message_error')); } else { $this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_write_message_success')); } if (isset($view)) { redirect('messages/view/' . $id); } else { redirect('messages'); } } else { $this->view_data['id'] = $id; $this->theme_view = 'modal'; $this->view_data['title'] = $this->lang->line('application_edit_message'); $this->view_data['form_action'] = 'messages/update'; $this->content_view = 'messages/_messages_update'; } }
function view($id = FALSE) { $this->view_data['submenu'] = array($this->lang->line('application_back') => 'messages'); $message = Privatemessage::find($id); if ($message->status == "New") { $message->status = 'Read'; $message->save(); } $sql = 'SELECT privatemessages.id, privatemessages.conversation FROM privatemessages WHERE privatemessages.recipient = "u' . $this->user->id . '" AND privatemessages.`id`="' . $id . '"'; $query = $this->db->query($sql); $row = $query->row(); $sql2 = 'SELECT privatemessages.id, privatemessages.`status`, privatemessages.conversation, privatemessages.subject, privatemessages.message, privatemessages.sender, privatemessages.recipient, privatemessages.`time`, privatemessages.`sender` , clients.`userpic` as userpic_c, users.`userpic` as userpic_u , users.`email` as email_u , clients.`email` as email_c , CONCAT(users.firstname," ", users.lastname) as sender_u, CONCAT(clients.firstname," ", clients.lastname) as sender_c FROM privatemessages LEFT JOIN clients ON CONCAT("c",clients.id) = privatemessages.sender LEFT JOIN users ON CONCAT("u",users.id) = privatemessages.sender GROUP by privatemessages.id HAVING privatemessages.conversation = "' . $row->conversation . '" ORDER BY privatemessages.`id` DESC LIMIT 100'; $query2 = $this->db->query($sql2); $this->view_data["conversation"] = array_filter($query2->result()); $this->theme_view = 'ajax'; $this->view_data['form_action'] = 'messages/write'; $this->view_data['id'] = $id; $this->content_view = 'messages/view'; }
function delete($id = FALSE) { $message = Privatemessage::find($id); $message->status = 'deleted'; $message->save(); $this->content_view = 'messages/all'; if (!$message) { $this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_delete_message_error')); } else { $this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_delete_message_success')); } redirect('cmessages'); }