[MOD] Report Page v5.0: Page 6

[MOD] Report Page v5.0

trav1856

Worked like a charm, and my boss is VERY happy. Thank you for this great mod!

scottro

And thanks for the help ntozier, beat me to it ;)

trav1856

First, I want to say this is a great mod.

However, I did notice one area that would make this the PERFECT reporting mod, and that's if it would either generate a popup window with the tickets in the fields you click on, or expanded the table and showed the tickets directly underneath.

I understand the theory on how to make this happen but I have .2% coding ability.

blank

scottro

trav,

Good idea and I've got it partially coded, I just need to get it coded so that it looks at the correct date range and not always "Forever" and then I'll release a new version. I'll get to it as soon as I can.

trav1856

trav,
good idea and i've got it partially coded, i just need to get it coded so that it looks at the correct date range and not always "forever" and then i'll release a new version. I'll get to it as soon as i can.

you rock!!!

scottro

English Version 4.2 has been released. See zip file on my website. Changelog link is located at the bottom of the article.

http://sudobash.net/ostickets-reports(http://sudobash.net/ostickets-reports)

MAJOR BUG FIX RELEASE:

Fixed the "Replies per Staff" Reports, has been broken ever since it was released in version 2.3

Boben

nice mod

Hello,

i've installed the mod too. Unfortunately it doesn't work at the moment.

First i had a problem with the name of the report_file. Everytime i open the report view it creates a file named "Report_.csv" without the timestamp. Then i have replaced manually the code of report.php as following:

for:

$time = $_SERVER;

changed with:

$time = time();

Then it works and the script creates files like "Report_12344578.csv".

But now i got the mysql error:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(HOUR, ost_ticket.created, ost_ticket.closed)),2) AS hoursAVG, ROUND' at line 2"

Can anyone help me?`

Thanks in advance.

Best regards

Ben

Angel2001

Respected Scottro,

I am encountering error while installing Report 4.2 in Osticket 1.7 version.

Can you help me.

Many thanks in Advance.

jawedsoft

Thank you

Thank you for a much needed add-on. Best wishes,

craigmc35

download

The download page is sending 404. When is it working again?

scottro

Oooops! Fixed, thanks!

ghostx

Problem

Hello all,

I have a problem with this mode, when all set to Import base system and try to run this mod from the SCP system throws me a message

Welcome back,

Fatal error: Call to a member function getUsername () on a non-object in C: \ xampp \ htdocs \ amir \ include \ staff \ header.inc.php on line 35

I think it comes to PHP, but I'm not sure, so if somebody has a solution that would like me to respond.

thank you

scottro

Hello all,
I have a problem with this mode, when all set to Import base system and try to run this mod from the SCP system throws me a message
Welcome back,
Fatal error: Call to a member function getUsername () on a non-object in C: \ xampp \ htdocs \ amir \ include \ staff \ header.inc.php on line 35

I think it comes to PHP, but I'm not sure, so if somebody has a solution that would like me to respond.
thank you

What is line 35 of C:\xampp\htdocs\amir\include\staff\header.inc.php ?

ghostx

What is line 35 of C:\xampp\htdocs\amir\include\staff\header.inc.php ?

in 35 line's is:

Welcome back, <?=$thisuser->getUsername()?>

<?php

if($thisuser->isAdmin() && !defined('ADMINPAGE')) { ?>

| Admin Panel | Reports

<?}else{?>

| Staff Panel <? if((!$thisuser->isadmin() && !$thisuser->isManager() && $graphOptions=='staff') ||

(!$thisuser->isadmin() && $thisuser->isManager() && (($graphOptions=='managers') || ($graphOptions=='staff'))) ||

$thisuser->isadmin())

{?> | Reports <?}?>

<?}?>

| <?="$isdeptmanager";?>My Preference | Log Out

<?}?>

that is working with old version php, and now is not working please help...

scottro

The following code in the header is not my code but part of the base install:

<?=$thisuser->getUsername()?>

Can you TEMPORARILY remove this and see if you get further errors? I suspect the issue is not actually getUsername.

Please remove it or comment it out and then see what kind of error, if any, you get and report back.

ghostx

The following code in the header is not my code but part of the base install:
<?=$thisuser->getUsername()?>
Can you TEMPORARILY remove this and see if you get further errors? I suspect the issue is not actually getUsername.
Please remove it or comment it out and then see what kind of error, if any, you get and report back.

When I delete this line i have error

Welcome back,

Fatal error: Call to a member function isAdmin() on a non-object in C:\xampp\htdocs\emir\include\staff\header.inc.php on line 39

on line 39 I have this code

if($thisuser->isAdmin() && !defined('ADMINPAGE')) { ?>

scottro

When I delete this line i have error
Welcome back,
Fatal error: Call to a member function isAdmin() on a non-object in C:\xampp\htdocs\emir\include\staff\header.inc.php on line 39
on line 39 I have this code
if($thisuser->isAdmin() && !defined('ADMINPAGE')) { ?>

Ok, that's what I figured. For whatever reason your object $thisuser appears to be unpopulated. Are you sure you've logged in properly?

ghostx

Ok, that's what I figured. For whatever reason your object $thisuser appears to be unpopulated. Are you sure you've logged in properly?

Yes im sure. I have only one user on osticket...

jimmyeao

Just wanted to say thanks for this - works great!

avijay

Average resolution time column showing 0 in total

Hi Sccotro,

Kudos for this great work. The issue we are facing is the Hours to Resolution time column shows 0. What needs to be fixed to get the correct values?

Thanks.

« Previous Page Next Page »