Reporting Panel [ALPHA RELEASE]

[norhishammohdnor]

still missing one last day //

[quatog]

Hello Jay Dee,

All graphs and advises are ok with me and it works. One problem though, how come I get No number value on the opened column on the user statistics panel?

Only mods I included is this thread: http://www.osticket.com/forums/showthread.php?t=583

I'm using rc4.

Thanks and God Bless.

[shinshigumi]

hello sirs, is this working on RC5? cause i've used so many modifications here in forums. Thanks.

I tried this mode on RC5, and i have some output, but my system log we're bombarded with smtp errors and sql errors.

I'll try to edit some SQL statements.

[shinshigumi]

edited my post.

[quatog]

Can somebody help me with with the script file reporterOpen.php and reporterClosed.php? I need to include the last ticket thread of a ticket. I'm looking at the ost_ticket_message as a possibility but every time I include ost_ticket_message in the FROM statement or any expression like ost_ticket_message.message on the SELECT statement, the CSV output has no values inside. I hope somebody will help me.

Thanks

[Cullin]

Hello, pls have anyone code for this mod on the last version OsTicket, or can anyone edit it? This is very nice mod, but i can't start it on the last version. :-(

[TKE248]

This is probably something simple for someone who knows php the links that exports the current month’s reports aren’t working correctly. It’s getting the default date on the export script link instead of the current months date, if I change it manually it works fine, anyone have any suggestions on how to fix this?

This is what the link looks like:
http://www.domain.com/IT/scp/scripts...12&dept0=1&f=1

[Neo-Tech]

Hey Jaydee

Mark here........


i have found a way to improve on the reporting, but i need your help......


i found a flash chart module called fusioncharts, i have a working ostticket and a working fusioncharts but i need your help integrating it into ostticket

can you help me???

MSN me at markmollentze@vodamail.co.za

thanx

[ediaz]

Originally Posted by JayDee

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. [As observed by Corey]

**************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/ 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 [5.1mb]

reportPanel0.3.tar.gz [4.4mb]

VeraFonts.zip [336.9kb]

VeraFonts.tar.gz [335.7kb]

Dear Jaydee,

I try to implement the reports and graphs but, to the modify the file header.inc.php. appears the following error
"Problems loading requested supervisor page.
Possibly access denied, if you believe this is in error please get technical support"
I know that the problem is theme of permissions but i can't fix it

help please