G'day all,
There has been a few requests for some kind of reporting and it's something that I have been putting a bit of work into the last few months.. so here is my finished-ish product.
But first a warning...
******************WARNING************************
Use these files at your own risk
I am by no means a very accomplished programmer, just managed to put the braces in the right spots...
Backup your existing files before installing this panel. It will overwrite a couple of fairly important files.
I will try and give some feed back as often as I can if you have any questions but I still have other obligations, so be patient and I will help when I can.
This release is not yet fully secure, all graphs and CSV files are visible by anyone who know the correct addresses to type.
**************End of WARNING********************
Okay now we have that out of the way here are a couple of screen shots.
A few simple graphs:
And some users Stats:
Installation
The archive file, reportPanel0.3.zip, you see linked at the bottom of this post are to copy over the top of your existing osTicket files. The following files are overwritten in this process...
/include/class.nav.php
/include/staff/header.inc.php
/scp/tickets.php
/scp/css/style.css
My code additions are clearly marked inside each of these files. A key word search on "Jay" should find all the blocks.
(JpGraph)
This is what I have used to generate the graph images, these images are created dynamically when the page is loaded, direct from your database.
There are two files you will have to configure specific to your Server.
/include/jpgraph/dbConnect.php
This is the file where a connection is made to your server, I have only used mySQL so I'm not sure how it will work with other servers. I have left instructions in the file on what to change.
/include/jpgraph/jpg-config.inc.php
This is where you specify the directory to your system fonts. Instructions are also included in the file. The graphs I have made use the Vera font set, I have included this set as an attachment to this post.((Vera is an open source font set))
To run the graphs your server must be running PHP 5.x and have the GD library installed. See http://www.aditus.nu/jpgraph(http://www.aditus.nu/jpgraph) for more details.
I have placed the graphs in the scp directory: /scp/graphs They are pretty strait forward to manipulate. I look forward to seeing what other graphs people can come up with if they have any time.
I have also included the example graphs that came with the original JpGraph and all documentation if you feel like making some of your own graphs up.
Reporting Panel
Just a quick overview of the panel now. You can go into the panel from the top "Welcome back box" you should notice a new "Reporting panel" option appear there.
From there you are given each of your departments that you are allowed access to in tab form along the top and then 3 options for the reporting.
Overview
Just a quick glance at the months work... CSV's also available from this section
User Statistics
A detailed look at each staff member. Current stuff member will always be located at the top. Managers will be able to see all staff in their accessible departments, staff members will only see them selves.
Correlated Graphs
Not visible to staff members at all... only to managers and Admin's.
You may also notice that the month you are looking at is maintained when clicking between the different reporting sections and even departments. I felt this would be helpful when comparing departments etc...
Enjoy
Deep_CuTz has provided a few fixes in his version available here: (http://osticket.com/forums/showthread.php?t=1537&page=3
)
Let me know what you think :)
AND
Make sure you have read the warnings above.
(reportPanel0.3.zip)
(reportPanel0.3.tar.gz)
(VeraFonts.zip)
(VeraFonts.tar.gz)