[MOD] Ticket Aging, Ticket Summary, and Ticket For Staff Report

masino_sinaga

Dear osTicket Community,

I have successfully created three kinds of report related to the ticket items monitoring. These reports can be accessed from the Dashboard in Admin Panel of your osTicket. The first time they were being displayed, you will see only the description and its count based on the report criteria. However, you will be able to view the detail (ticket items) by expanding/clicking the description or its count.

Here are the screenshots:

1) Ticket Aging:

blank

Active Tickets means that the tickets are Open, but they are assigned and

currently actively being worked on.

2) Ticket Summary:

blank

3) Ticket For Staff:

blank

I will publish the modification code tomorrow, and I hope this will be helpful for all of you. So, stay tuned! ;)

Sincerely,

Masino Sinaga

masino_sinaga

Modification Code

As I promised yesterday, you can now get the modification code:

(Adding Ticket Aging, Ticket Summary, and Ticket for Staff Report Feature into osTicket v1.6 RC5)

Thanks.

Sincerely,

Masino Sinaga

masino_sinaga

Feedback?

Please do not hesitate to post any feedback regarding the MOD I created above.

Thanks,

Masino Sinaga

beeman

Thanks Masino,

I am looking to add some reporting functionality to my osTicket and I think your MOD will come in handy. Can you enable Department managers to be able to use this feature over and above just the administrator? Thanks.

Regards

Beeman

asaygi

Very good

Thank you masino_sinaga. I have install and no problem work at the system :)

Good Job.

masino_sinaga

Glad you like it

@[deleted],

You're welcome. I will try to implement it for being to be used by dapartment managers, too. :)

@[deleted],

You're welcome. Glad it works fine at yours. :)

Sincerely,

Masino Sinaga

kpascoe

Excellent work. Only thing I had to do to get it to stop throwing database errors was change the staffid variable on line 115 in ticketsummary.inc.php from

$sqltotalclosed='SELECT * FROM '.TICKET_TABLE.' WHERE status = "closed" and staff_id='.$staff_id.'';

$sqltotalclosed='SELECT * FROM '.TICKET_TABLE.' WHERE status = "closed" and staff_id='.$staffid.'';

masino_sinaga

@[deleted],

Thanks for the correction, so it will stop throwing the database error in System Logs page. :)

Actually, that SQL does not have affected since the closed tickets will have staff id value = "0" (zero) in ost_ticket table. In other words, that SQL above will always give the result as "0" record, whereas this SQL below will give the result all of the closed tickets (else section):

$sqltotalclosed='SELECT * FROM '.TICKET_TABLE.' WHERE status = "closed"';

CMIIW.

Sincerely,

Masino Sinaga

beeman

Hi Masino,

Just wanted to know if it is possible you could expand your reporting MOD to include the MTTR reporting as requested by myself on the other thread; please see here;http://www.osticket.com/forums/showthread.php?t=3411(http://www.osticket.com/forums/showthread.php?t=3411)

I will appreciate your in this regard.

Thanks

Beeman

quatog

Any chance this will work on rc4? Can you include a per department statistics? How about graphical representations to the data?

shinshigumi

Any chance this will work on rc4? Can you include a per department statistics? How about graphical representations to the data?

hoping for this kind of mod which shows graphs. :)

Drumplayr

Thanks

I appreciate your hard work. Works like a charm. First thing I noticed is how many tickets that were unassigned that should have. Thanks again!

Synymy

No number of closed Tickets

I have a litte question about this MOD.

In the View 'Ticket Summary' I see the total number of closed Tickets.

But if I choose a Staffmember to view his personal summary, his number of closed tickets is '0'. Why?

There is the 'german'-Mod and the 'faq'-Mod installed, too. Osticket 1.6 stable.

Thanks in advance...

Syn

roniwahyu

salam

As I promised yesterday, you can now get the modification code:
(Adding Ticket Aging, Ticket Summary, and Ticket for Staff Report Feature into osTicket v1.6 RC5)
Thanks.
Sincerely,
Masino Sinaga

Halo pak, salam kenal

Saya sering membaca artikel Anda di luar masalah osTicket...Anda cukup terkenal di kalangan mahasiswa yang baru belajar masalah PHP dan Web Programming

Pak, saya baru belajar masalah osTicket, kebetulan intranet di perusahaan saya memerlukan adanya osTicket dan berbagai modifikasinya...mohon bantuannya dan bimbingannya gan.....thanks

----

Hello, sir, greetings...

i'm new in osTicket, fortunely our company is needed issue ticket system like osTicket.sure with many modification and improvement to collaborate with intranet. Would you please to give guidance and help to us?thanks

wyotriumphrider

Please do not hesitate to post any feedback regarding the MOD I created above.
Thanks,
Masino Sinaga

Fantastic job! This mod is exactly what my boss was looking for...

By the way, I have this mod (and a couple of others) up and running on 1.6ST.

Thank you!

Scirocco

If I have the mod "Allocation of tickets to maintain closed" installed, an incorrect amount of active tickets will be displayed.

I have corrected the error with the following addition:

in ticketsummary.inc.php

this:

if ($staffid) {

$sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.'';

} else {

$sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0"';

}to:

if ($staffid) {

$sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.' AND status = "open"';

} else {

$sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0" AND status = "open"';

}

sorry for my english :

Scirocco

in ticketstaff.inc.php the same:

this (Line 95):

$sqln='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id='.$row.'';

to:

$sqln='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id='.$row.' AND status = "open"';

and this (Line 113):

$sqlt='SELECT ticketID, ticket_id FROM '.TICKET_TABLE.' WHERE staff_id='.$row.'';

to:

$sqlt='SELECT ticketID, ticket_id FROM '.TICKET_TABLE.' WHERE staff_id='.$row.' AND status = "open"';

masino_sinaga

Thanks for the feedback!

Fantastic job! This mod is exactly what my boss was looking for...
By the way, I have this mod (and a couple of others) up and running on 1.6ST.
Thank you

Thanks for informing us about it, as many people asked me whether this mod working in 1.6 ST version or not. Now it has been answered as well.

@[deleted],

You may visit my blog, and there you can find another mods and or guidance how you can customize your osTicket. Click/follow the link that I have given in the second post in this thread.

@[deleted],

Thanks for your modification.

Sincerely,

Masino Sinaga

jackcksn

May i know what the problem?

Hi,

I'm os 1.6 ST new user , i have try install this mod ,but the Ticket Aging and Ticket for Staff functions have not working ,may i know what the problem ?::

Please help ,i have attach the print screen follows:

http://img535.imageshack.us/img535/5392/21980870.jpg(http://img535.imageshack.us/img535/5392/21980870.jpg)

http://img709.imageshack.us/img709/2220/12288219.jpg(http://img709.imageshack.us/img709/2220/12288219.jpg)

Have a nice day ,thank you.

Any can help ?:

cpham55

Hi masino_sinaga,

I added your MOD now I find out the tab "Ticket for staff" have ten pages but I can not click other pages like 2,3,4,5,6,7,8,910 only page 1 is working. Please help. When I click on page 2 look like this scp/admin.php?&p=2 then it is go back to systems log page.

Thank you,