My Tickets showing closed.

[rmcgeown]

I feel like im spamming the forums at the moment! Sorry!

Our staff My Tickets page shows tickets closed by that staff as well as their open. I want it to only show open.

The ticket stats count is correct though.

I had read that this is standard in 1.6...however I have added the MOD to stop showing closed tickets when there are no open.

Any help is appreciated.

[scottro]

Taken from my Reports MOD article:

This will still make the ticket show up under "My Tickets" (even when closed) in order to get it to stop doing that (if you desire), then change the following entry

from:
include/staff/tickets.inc.php

PHP Code:

$qwhere.=' AND ticket.staff_id='.db_input($staffId); 


to:

PHP Code:

$qwhere.=' AND ticket.status="open" AND ticket.staff_id='.db_input($staffId); 


[scottro]

And another portion that you'll probably come back for next

You’ll also need to change the following (otherwise it will count that you have tickets assigned but won’t list them thus confusing everyone).

scp/tickets.php

PHP Code:

'LEFT JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id='.db_input($thisuser->getId()); 


To:

PHP Code:

'LEFT JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND ticket.status=\'open\' AND assigned.staff_id='.db_input($thisuser->getId()); 


[rmcgeown]

Scottro, once again, thank you!

[scottro]

You bet!

[tanyad]

I tried this solution and now my staff can't see any of the tickets listed.