[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

[wyotriumphrider]

Originally Posted by masino_sinaga

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:

PHP Code:

if ($staffid) {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.'';
} else {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0"';
} 


to:

PHP Code:

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

PHP Code:

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


to:

PHP Code:

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


and this (Line 113):

PHP Code:

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


to:

PHP Code:

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


[masino_sinaga]

Originally Posted by wyotriumphrider

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.


@roniwahyu,

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.

@Scirocco,

Thanks for your modification.

Sincerely,
Masino Sinaga

[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