Esempio n. 1
0
 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';
     }
 }
Esempio n. 2
0
    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';
    }
Esempio n. 3
0
 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');
 }