Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

[MOD] Report Page v5.0

edited November 2013 in Mods and Customizations
The long requested ever absent Reports page:

http://sudobash.net/?p=821
Now also available en espanol (v3.3.1) - thanks to camilojaraba
Now also available in italiano (v3.4) - thanks to playsoft

image
«134567

Comments

  • Version 1.2 has been released. See zip file on my website. Changelog is located at the bottom of the article.
  • Version 2.0 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    Biggest change: Graphs! (Pie Charts)
  • very sweet, thanks!
  • mouseware;21834 said:
    very sweet, thanks!
    My pleasure! Thanks for the feedback! ;)
  • Because tickets by department mean more to me than anything, i tweaked the reports.php file to use PHP for dates rather than MySQL, that way I could use these dates to make the output table under the pie chart link back to the search page based on the query.
  • This is a fantastic mod and I recommend it. First off let me say that the installation of this mod was easy enough that a first day OST newbie that is not familiar with PHP but is minorly familiar with HTML should have no problem doing it. Secondly the charts look fantastic when they work (see browser tests below). While the authors implementation integrates well with the OST architecture, I will be adding it as a tab also. I will also be sending some ideas to the author or modding his code to implement some of my own custom reporting that others may find useful.

    I have tested this on the following browsers:
    Firefix 4.0.1 works as expected.
    Opera 11.11 works as expected.
    Internet Explorer does not display graphs.
    Chrome 12.0.742.100 works as expected.

    I have emailed the author to let him know these results. I suspect that either IE is mishandling the google graph drawing routines, or the google graph drawing routines have a bug. Either way I hope that an IE 'fix' will be forth coming because it still has a large market share.

    kudos to Scottro for this wonderful contribution!
  • Thanks all, glad everyone is enjoying it!

    Feel free to keep the suggestions coming (I'll see them fastest if you post them to my site.)

    Version 2.1 has been released. See zip file on my website. Changelog is located at the bottom of the article.
  • Version Español / Spanish version

    Hello!!! here is an spanish version of this excellent mod.

    Hola!!! aqui les dejo una version en español de este excelente mod.
    traducida por mi.

    espero que les sirva... solo deben seguir las instrucciones en la pagina original: http://sudobash.net/?p=821

    y el archivo que usaran es el adjunto! de resto todo igual...

    saludos y bendiciones!!

    K.
    reports.php.zip
    4K
  • camilojaraba;21889 said:
    Hello!!! here is an spanish version of this excellent mod.

    Hola!!! aqui les dejo una version en español de este excelente mod.
    traducida por mi.

    espero que les sirva... solo deben seguir las instrucciones en la pagina original: http://sudobash.net/?p=821

    y el archivo que usaran es el adjunto! de resto todo igual...

    saludos y bendiciones!!

    K.
    Awesome! Thank you! Do you mind if I add this to my website article?
  • scottro;21890 said:
    Awesome! Thank you! Do you mind if I add this to my website article?
    Excellent!!! thanks to you.
  • English Version 2.1.1 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    Spanish Version 2.1 posted
  • IE Graph Problem

    Hi Scotro, thank you so much for the reporting module, however, has the IE graph problem been sorted?:confused:

    Surjan
  • Thanks Scotto,

    A wonderful addition to osticket. Brilliant work:). Two questions though;

    How do I enable normal user or staff logged in to use this feature as it seems to be only enabled for the Admin user?

    The graphs are not displaying on my setup; do my server need to have internet connectivty for the graphs to display?

    Thanks you for your great work. Reporting on osticket is looooong overdue.
    Regards,
    Beeman
  • surjan;21901 said:
    Hi Scotro, thank you so much for the reporting module, however, has the IE graph problem been sorted?:confused:

    Surjan
    No, I haven't had a chance to work on it yet. I've been working on restoring someones webserver for the last week and a half and its been a nightmare. I'll get too it as soon as I can though.
  • beeman;21902 said:
    How do I enable normal user or staff logged in to use this feature as it seems to be only enabled for the Admin user?
    Instead of having the following:
    <?if($thisuser->isAdmin()) {?> | <a href=\"reports.php\">Reports</a> <?}?>


    Just use:
    | <a href=\"reports.php\">Reports</a>

    beeman;21902 said:
    The graphs are not displaying on my setup; does my server need to have internet connectivty for the graphs to display?
    Yes, the server needs to have internet connectivity as the graph uses the google graphs API to connect to google for the rendering. Also, for the time being the graphs do not show up in IE.
  • In a future version I will be adding a Reports Admin page and database entries that will allow for easier manipulation.

    This will likely include at least the following:

    - Turn graphs on or off
    - Toggle 3D graphs
    - Switch from Pie Chart to Bars ( I didn't like the way it looked but maybe some of you will )
    - Control graph size
    - Set if reports can be viewed by Admins, Managers, or all staff.
  • English Version 2.1.2 has been released. See zip file on my website. Changelog is located at the bottom of the article.
  • English Version 2.2 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821
  • English Version 2.2.1 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    Apologies to anyone who downloaded v2.2 for the 10 minutes it was out, its already out-dated ;)
  • English Version 2.2.2 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821
  • English Version 2.2.3 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    This is a bug fix release.
  • When I change

    <?if($thisuser->isAdmin()) {?> | Reports <?}?>

    to

    | Reports

    I get a blank page after logging in.:confused:
  • beeman;21956 said:
    When I change

    <?if($thisuser->isAdmin()) {?> | Reports <?}?>

    to

    | Reports

    I get a blank page after logging in.:confused:
    Sorry, should have looked at the code and tested it before replying. Just change that whole section to:

    <?php
    if($thisuser->isAdmin() && !defined('ADMINPAGE')) { ?>
    | <a href=\"admin.php\">Admin Panel</a>
    <?}else{?>
    | <a href=\"index.php\">Staff Panel</a>
    <?}?>
    | <a href=\"profile.php?t=pref\">My Preference</a> | <a href=\"reports.php\">Reports</a></a> | <a href=\"logout.php\">Log Out</a></p>
  • English Version 2.2.4 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    This is a clarification release.
  • English Version 2.3 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    This is a "new report" release.
  • English Version 2.4 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    This fixes graphs so they will show up in Internet Explorer.
  • English Version 2.4.1 has been released. See zip file on my website. Changelog is located at the bottom of the article.

    http://sudobash.net/?p=821

    Bug Fix release.
  • This is great, just wondering if there were any plans to report by helptopic?
  • Yep, its one of the next things on my to do list.
  • kevin80;22001 said:
    This is great, just wondering if there were any plans to report by helptopic?
    In response to another requester asking for the same thing on my website:
    I looked into this but I don’t think I can do anything with it. The tickets table has nothing in common with the help_topics table except a field labeled “topic”. In my tickets database all of the “topic” fields are either empty or NULL. It would appear that the only use for the Help Topics is in getting them assigned to the right department. There is no way to count how many tickets have been created as a result of using a Help Topic. Please correct me if I’m wrong but that’s what I’ve found. However, we don’t use the web interface for customers so its one of the things I’m least knowledgeable about.
Sign In or Register to comment.