last updated

Monker

Hello, I am working on a mod for v1.6 RC4. People wanted to see when the last time the ticket was updated. I have been able to add an updated column to the ticket menu.

But when I got that menu I noticed that the updated column has a generic date of 11/30/1999 which is because there is no date in the database.

I am trying to add, when you reply to a ticket or do an internal reply that the current date and time goes to the updated column in the database.

I'm going to keep working on it just wanted to see if anyone else has done this before.

drozenski

http://osticket.com/forums/showthread.php?t=2916(http://osticket.com/forums/showthread.php?t=2916)

4 threads down

Monker

Thats not in the spot that we wanted here is a screen shot of where I am talking about.

Monker

Well I have been looking around and would this work?

in /include/class.ticket.php

Here: //Insert Staff Reply

function postResponse($msgid,$response,$signature='none',$attachment=false,$canalert=true){

global $thisuser,$cfg;

if(!$thisuser || !$thisuser->getId() || !$thisuser->isStaff()) //just incase

return 0;

$sql= 'INSERT INTO '.TICKET_RESPONSE_TABLE.' SET created=NOW() '.

',ticket_id='.db_input($this->getId()).

',msg_id='.db_input($msgid).

',response='.db_input(Format:($response)).

',staff_id='.db_input($thisuser->getId()).

',staff_name='.db_input($thisuser->getName()).

',ip_address='.db_input($thisuser->getIP());

$resp_id=0;

Should I add after created;

updated=NOW()

masino_sinaga

I suggest you to use this modification:

http://www.osticket.com/forums/showthread.php?t=736(http://www.osticket.com/forums/showthread.php?t=736)

If you follow all posts in that thread, then you will find the answer (especially in the page number 2).

Cheers!

Sincerely,

Masino Sinaga

Monker

Well the problem is that I do not have a last response column in my database. all the mods that I have seen have that column.

masino_sinaga

That Last Response column value derived from the created field in ticket_response table.

Sincerely,

Masino Sinaga

trbn

Hey,

could someone help me with Internal Notes?

Instead of LastResponseDate I would like to have LastNoteDate from the ost_ticket_note table.

I need this because I don't use the response function for my customers.(They are not able to reply on a ticket.) I always write in the internal notes what I did to solve the problem.

Thanks,

Torben

drozenski

where do you want this? In the overall ticket view of all tickets or when viewing a specific ticket.

trbn

I would like to have this in the overall ticketview like on the screenshot above.

The only difference is that I need the "Last-Update-Time" of the Internal Notes from ost_ticket_note table.