notification close ticket

[Girl]

hi everybody...
i need ur help cuz i dont know about php...
i want receive an email when someone closes a ticket...
it would be perfect if the email contains all the historic with the client...

thank you very much <3

[michael.therrien]

It's do-able. Someone actually already asked for this:
http://osticket.com/forums/showthread.php?t=1810

I'll see what I can whip up! Bug me if I don't get to it soon.

[Girl]

Originally Posted by michael.therrien

It's do-able. Someone actually already asked for this:
http://osticket.com/forums/showthread.php?t=1810

I'll see what I can whip up! Bug me if I don't get to it soon.

thank you very much... its urgent...pls pls ty

[michael.therrien]

Like I said, don't have much time recently, but this should do the basic part of what you are looking for:
In /include/class.ticket.php
MODIFY:

PHP Code:

    //Close the ticket
    function close(){
        
        $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '.
              ' WHERE ticket_id='.db_input($this->getId());
        return (db_query($sql) && db_affected_rows())?true:false;
    } 


To be this:

PHP Code:

    //Close the ticket
    function close(){
        
        $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '.
              ' WHERE ticket_id='.db_input($this->getId());
        return (db_query($sql) && db_affected_rows())?true:false;
        $subj= "Ticket #" .$this->getId(). " has been closed.";
        $body= "This is a notification that Ticket #" .$this->getId(). " has been closed.";
        $email->send($ticket->getEmail(),$subj,$body);
    } 


[Girl]

i understand and im sorry...
it doesnt work >.<
ty anyway

[ByteRot]

I have not tried the mod but looking at the code, the return statement should be moved to the bottom. It will never execute the email code.

    //Close the ticket
    function close(){
        
        $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '.
              ' WHERE ticket_id='.db_input($this->getId());
        $subj= "Ticket #" .$this->getId(). " has been closed.";
        $body= "This is a notification that Ticket #" .$this->getId(). " has been closed.";
        $email->send($ticket->getEmail(),$subj,$body);

        return (db_query($sql) && db_affected_rows())?true:false;
    }

[ozkr]

does this mod works?

[djbooya]

Originally Posted by ozkr

does this mod works?

Here's my version of this:

PHP Code:

    // ALL CHANGES IN class.ticket.php
    function close(){

        $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '.
              ' WHERE ticket_id='.db_input($this->getId());
// NEW MOD CODE STARTS HERE
// get dept object
$dept = new Dept($this->getDeptId());
// get email object for current  
$email = new Email($this->getEmail()); 
// see if the department ticket is configured for is setup for auto response on
// new tickets.  I have some departments I don't want notification on close
// A new attribute could be used, but I piggy backed on an existing as it
// suited my needs fine for now.
if ($dept->autoRespONNewTicket()) {
  // small debug message that prints at the top of ticket screen so I know
  // an email was sent
  print "<b>Email Sent</b>";
  // subject for email -- totally configurable.  code in previous post was 
  // showing the internal ID, not the external ID a user would need
  $subj= "Helpdesk Request #" .$this->getExtId(). " has been closed.";
  // I added a link in the body to the ticket for the user if they wanted
  // to view it just after I closed it.
  $body= "This is a notification that Request#" .$this->getExtId(). " has been closed.  You can see request information here: http://" . $_SERVER["SERVER_NAME"] . "/view.php?e=" . $this->getEmail() . "&t=" . $this->getExtId() . ".";
  // this sends out the email ensuring the "From" address is whatever
  // is configured for the department
  $dept->getEmail()->send($this->getEmail(),$subj,$body);
}
// NEW MOD CODE ENDS HERE
        return (db_query($sql) && db_affected_rows())?true:false;
    } 


I am using this with osticket_1.6rc5 right now. Just installed it last night and added this mod as it was important for my installation. I modified it from the above code to suit my needs a little better. And to answer your question, it's a minimal addition to see if it works in your installation. Just throw the code in and test, if it doesn't do what you want either remove the code or just restore from your backup. Quick and painless with this mod since it's confined to just 1 function in 1 class.

Enjoy my updates!
--DJBooya

[Girl]

Originally Posted by djbooya

Here's my version of this:

PHP Code:

    // ALL CHANGES IN class.ticket.php
    function close(){

        $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '.
              ' WHERE ticket_id='.db_input($this->getId());
// NEW MOD CODE STARTS HERE
// get dept object
$dept = new Dept($this->getDeptId());
// get email object for current  
$email = new Email($this->getEmail()); 
// see if the department ticket is configured for is setup for auto response on
// new tickets.  I have some departments I don't want notification on close
// A new attribute could be used, but I piggy backed on an existing as it
// suited my needs fine for now.
if ($dept->autoRespONNewTicket()) {
  // small debug message that prints at the top of ticket screen so I know
  // an email was sent
  print "<b>Email Sent</b>";
  // subject for email -- totally configurable.  code in previous post was 
  // showing the internal ID, not the external ID a user would need
  $subj= "Helpdesk Request #" .$this->getExtId(). " has been closed.";
  // I added a link in the body to the ticket for the user if they wanted
  // to view it just after I closed it.
  $body= "This is a notification that Request#" .$this->getExtId(). " has been closed.  You can see request information here: http://" . $_SERVER["SERVER_NAME"] . "/view.php?e=" . $this->getEmail() . "&t=" . $this->getExtId() . ".";
  // this sends out the email ensuring the "From" address is whatever
  // is configured for the department
  $dept->getEmail()->send($this->getEmail(),$subj,$body);
}
// NEW MOD CODE ENDS HERE
        return (db_query($sql) && db_affected_rows())?true:false;
    } 


I am using this with osticket_1.6rc5 right now. Just installed it last night and added this mod as it was important for my installation. I modified it from the above code to suit my needs a little better. And to answer your question, it's a minimal addition to see if it works in your installation. Just throw the code in and test, if it doesn't do what you want either remove the code or just restore from your backup. Quick and painless with this mod since it's confined to just 1 function in 1 class.

Enjoy my updates!
--DJBooya

hi guys..

did it work with you?
not with me...

thank you

[seth260]

Works Perfectly for me!

I would like to know how to make the notification goto the department admin as well though. I can't seem to add another to address to the function.

Can anyone help?