Last Ticket

[wibi]

I all,

I'de like to display the "last respond" for a message in ticket.php (in fact in place of the date (of creation).

The idea is to be abble to see in the staff panel which message had the lastest respond.

Does anyone has an idea ?

B regards,

[jpowers40828]

These are written to replace the date created column, however, if you wish to keep it, simply add the codes from part 2&3 after the date section rather than replacing it.

In include/staff/tickets.inc.php ~ line 140

Modify this

$sortOptions=array('date'=>'ticket.created','ID'=> 'ticketID','pri'=>'priority_urgency','dept'=>'dept _name', 'ass'=>'username', 'from' => 'name', 'subject' => 'subject', 'updated' => 'updated');

to include

'updated' => 'updated'


In include/staff/tickets.inc.php ~ line 333

Change this

<th width="70">
<a href="tickets.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Date</a></th>

To be

<th width="70"><a href="tickets.php?sort=updated&order=<?=$negorder?><?=$qstr?>" title="Sort By Response <?=$negorder?>">Response</a></th>


In include/staff/tickets.inc.php ~ line 377

CHANGE

<td align="left" nowrap><?=Format::db_date($row['created'])?></td>

To this

<td align="left" nowrap><? if($row['updated']!="0000-00-00 00:00:00") echo Format::db_date($row['updated']);
else echo "none";?></td>