Adding new column in display ticket~~~

alexanderltc

Hi,

I'm new to osTicket and I have successfully install it without any problems.

So I was playing around with it and I immediately realize that there are something that I wanted to add in.

I've add a new column called "Assign to" as displayed below:

blank

I wanted the column "Assign to" display the assign staff name for each ticket (If the ticket has assigned).

<?=Format:($row,22,strpos($row,'@'))?>

//Display staff assign

Can anyone please help me with this? Thank you so much.

Jessie

tarick

Your going to need to add another line. with something like this.

$thisuser->getId()==$ticket->getStaffId()

Look on the viewticket.inc.php there is a line in there which displays who its assigned to.

I am too new to this, but that's my guess. Maybe someone else here will be able to help in detail.

Cheers and good luck.

tarick

<?=Format:($row,22,strpos($row,'@'))?>

That will give you the staff id. If I figure it out I will post it.

alexanderltc

Thanks ^^ I'll be waiting then...

alexanderltc

I try to add this code that I found it on viewticket.inc.php:

<?=$staff?Format:($staff->getName()):'- unassigned -'?>

but in the assign to column, it returns -unassigned- even if the ticket is already assign..

Hmmm, did I miss out something.. >.

alexanderltc

<?=Format:($row,22,strpos($row,'@'))?>
That will give you the staff id. If I figure it out I will post it.

Using phpmyadmin i actually noticed that the staff_id is retrieved from the ost_ticket table and not the ost_staff table.

Is it possible to add in a new column called firstname and make a connection to the table so that the column 'firstname' will appear in ost_ticket table?

please show me the steps >.

Thanks..

dohcjs

You wanna do a join on the staff table using staff_id.

In tickets.inc.php add the fields you want from the staff table, i.e staff.fname, staff.lname to the qselect string. Add a join " left join OST_STAFF_TABLE on OST_TICKETS_TABLE.staff_id=OST_STAFF_TABLE.staff_id. Then you will have the first and last name of the staff member each ticket is assigned to.

This is general outline of the logic. If you need actual source code let me know

alexanderltc

You wanna do a join on the staff table using staff_id.
In tickets.inc.php add the fields you want from the staff table, i.e staff.fname, staff.lname to the qselect string. Add a join " left join OST_STAFF_TABLE on OST_TICKETS_TABLE.staff_id=OST_STAFF_TABLE.staff_id. Then you will have the first and last name of the staff member each ticket is assigned to.
This is general outline of the logic. If you need actual source code let me know

A source code would be great for me =)

Thanks

P.S. : To display in the name, is that the code that i should put to display staff name? Or I should type staff.firstname?

<?=Format:($row,22,strpos($row,'@'))?>

dohcjs

Here we go

Line 209 in tickets.inc.php under upload/include/staff/ should look like this

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

',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';

Change it to this

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

',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments, staff.firstname, staff.lastname ';

Add this between line 231 and 232

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

So that it looks like this

$qfrom.=' 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 '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE.' attach ON ticket.ticket_id=attach.ticket_id';

after doing this $row will contain the assigned staff members first name and likewise $row will contain their last name. As for the html you can format it to suit your needs. Examples

Just First name

<?=$row?>

First and last name

<?=$row.' '.$row?>

First 20 characters of first and last name

<?=Format:($row.' '.$row,20)?>

Hope this helps.

alexanderltc

dohcjs,

I've already follow your code but the query returned 0 results:

blank

Any other way to let it display the staff name? or perhaps reedit the code again?

dohcjs

This is probably related to a typo on someones part. Look under admin panel->sys log

Pretty sure your going to have an error there.

Let me know what it says, also you can add an

echo $query to tickets.inc.php after the query string is completed and let me know what that looks like.

alexanderltc

I've done it..^^

Just create an extra function that writes staff name whenever the assign staff is executed.