[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:


Active Tickets means that the tickets are Open, but they are assigned and
currently actively being worked on.

2) Ticket Summary:


3) Ticket For Staff:


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]

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]

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]

Thank you masino_sinaga. I have install and no problem work at the system
Good Job.

[masino_sinaga]

@beeman,

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

@asaygi,

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

PHP Code:

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


to

PHP Code:

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


[masino_sinaga]

@kpascoe,

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):

PHP Code:

$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

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?