[MOD] Show "Assigned To" in Ticket View

webPragmatist

Hello again,

The code below allows you to show the person the ticket is assigned to in the staff control panel. I include a few of the previous lines to help you find where to paste the code as always.

/include/staff/tickets.inc.php (line 157)

$pagelimit=$pagelimit?$pagelimit; //true default...if all fails.

$page=($_GET && is_numeric($_GET))?$_GET;

// *** Edited by webPragmatist

$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,ticket.email,dept_name,staff.username '.

',status,source,isoverdue,ticket.created,pri.* ';

$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '.

' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '.

' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() '.

' LEFT JOIN '.STAFF_TABLE.' staff ON ticket.staff_id=staff.staff_id';

// *** End edit by webPragmatist

/include/staff/tickets.inc.php (line 330)

<th width="110">

<a href="tickets.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>

Addition by webPragmatist

<th width="150" ><a href="tickets.php?sort=ass&order=<?=$negorder?><?=$qstr?>" title="Sort By Assignee <?=$negorder?>">Assigned To</a></th>

End addition by webPragmatist

/include/staff/tickets.inc.php (line 367)

<td nowrap><?=Format:($row,30)?></td>

Addition by webPragmatist

<td nowrap><?=($row) ? $row : 'Not assigned';?></td>

End addition by webPragmatist

/include/staff/tickets.inc.php (line 140)

endif;

//I admit this crap sucks...but who cares??

// Addition by webPragmatist

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

// End addition by webPragmatist

Thanks Tonyb for the sorting addition!

Tonyb

great Work

webPragmatist

great Work

Glad I could help!

gabi_cavaller

This was perfect for me too, so clear to follow and works.

Thank you ever so much.

Have you done any other modifications that could help ?

Tonyb

<a href="tickets.php?sort=ass&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Assigned To</a></th>

//I admit this crap sucks...but who cares??

$sortOptions=array('date'=>'ticket.created','ID'=>'ticketID','pri'=>'priority_urgency','dept'=>'dept_name','ass'=>'username');

also in the same file tickets.inc.php

adding this to your above mentioned mod will allow you to also sort it using the assigned to field.

saaiber

<?=$qstr?>" title="Sort By Category <?=$negorder?>">Assigned To
//I admit this crap sucks...but who cares??
$sortOptions=array('date'=>'ticket.created','ID'=>'ticketID','pri'=>'priority_urgency','dept'=>'dept_name','ass'=>'username');
also in the same file tickets.inc.php
adding this to your above mentioned mod will allow you to also sort it using the assigned to field.

Where exactly can I put this code? Can you give me some linenumbers as reference please?

Grtz,

Nic

Tonyb

line 330 for the first part

and line 140 for 2nd part.

just first do the above webPragmatist part.

IanBrooks

I've followed the instructions for this to the letter, and although it shows the "assigned to" column, it doesn't matter who I assign a ticket to, it always shows the as unassigned in the list view. Is there a reason that this is happening? Have I forgotten to change something I should have done?

Thanks

SLMHC

Just tested mine and this mod works like a charm.

________

(volcano vaporizers)

webPragmatist

@ Tonyb,

Thanks for the info I will update the above code with this mod here in a few.

@[deleted]

Most likely this is because your $row is empty. Try:

<td nowrap><?=Format:($row,30)?></td>

Addition by webPragmatist

<td nowrap><?=$row; ?></td>

End addition by webPragmatist

for the last edit just to see if it echos anything.

IanBrooks

@ Tonyb,
Thanks for the info I will update the above code with this mod here in a few.
@[deleted]
Most likely this is because your $row is empty. Try:
<td nowrap><?=Format:($row,30)?></td>
Addition by webPragmatist
<td nowrap><?=$row; ?></td>
End addition by webPragmatist
for the last edit just to see if it echos anything.

I've tried that, and I now get the "Assigned to" column but it's blank all the way down. Any ideas on where I'm going wrong here?

IanBrooks

Still not having any luck with this, is there a way that I can check the contents of $row to ensure that it isn't empty?

stendum

For you guys who is having problems regarding seeing: "Not Assigned To" you need to comment away the original query on row: 171.

/* RS: Removed

$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '.

',status,source,isoverdue,ticket.created,pri.* ';

$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '.

' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '.

' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() ';

*

webPragmatist

For you guys who is having problems regarding seeing: "Not Assigned To" you need to comment away the original query on row: 171.
/* RS: Removed
$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '.
',status,source,isoverdue,ticket.created,pri.* ';
$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '.
' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '.
' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() ';
*

Thanks for helping out! With any of the MODS I do I try to include the line prior and after so be sure to pay attention :)

IanBrooks

I've done that too, and it still isn't working! Could it be something to do with the names of tables within the database or something of that nature?

Everything within osticket works fine, and when I go into a ticket it tells me who it's assigned to, so it must be that this is pointing somewhere incorrectly!

IanBrooks

Just to let you all know, this is now working, not sure what I did exactly, but after looking at the contents of the table using MySQL administrator to ensure it contained data, it just started working!

Thanks for all your help

jpowers40828

I added a cool feature to your code, where if the ticket is unassigned, a link shows up allowing the logged in user to "claim" it.

(

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

spances

'username' not found

Hello, i tried this add but its shows me like IanBrooks...

I tried to locate 'username' field in table database but i didnt found it.

Can i get some directions...?

Thank you.

spances

found username, still not working

i found username in staff table but is still not working

the qselect and qfrom part is deleted right now and the username part is like

<?=$row; ?>

webPragmatist

i found username in staff table but is still not working
the qselect and qfrom part is deleted right now and the username part is like
<?=$row; ?>

I don't follow, the qselect and qfrom part is deleted? :