[MOD] Report Page v5.0: Page 4

[MOD] Report Page v5.0

Emil

Well I'm getting somewhere I hope :)

I am now up to a blank (no pie chart) but I am able to split up and view how many tickets are in that status (see attachment) but for some reason my "sold" status does not show up and it's blank :

Here's my code changes so far, maybe somebody can see what I'm doing wrong or what I'm forgetting to add:

First, I added the ability to choose that report around line 63:

<option value="tixSold" <?if($_POST=='tixSold'){echo "selected";}?>>Ticket Status</option>

Then I "think" I'm supposed to wring something and call the DB somehow around line 100 and maybe that's why I'm not seeing a graph

EDIT: forgot to add another thing I added around line 115

elseif($_POST == 'tixSold'){

$qselect = "SELECT

ost_ticket.sold,

COUNT(DISTINCT(ost_ticket.ticket_id)) AS number FROM ost_ticket";

}

going down, I added my new variable to "group by department" at line 227

elseif($_POST == 'tixSold'){

$qgroup = "GROUP BY ost_ticket.sold ORDER BY ost_ticket.sold";

}

I added a variable $Sold = 0; around line 270 because it looked like I needed it for something

Next I added the headings for the table on the bottom around line 360

elseif($_POST == 'tixSold'){

echo "<tr><th>Status Name</th><th>Number of tickets in that status</th></tr>";

}

Finally towards line 400 I added the if else condition to see what status the ticket is in:

elseif($_POST == 'tixSold'){

if($row == NULL){

$row = Sold;

}

elseif($row == 1){

$row = Unsold;

}

elseif($row == 2){

$row = Pending;

}

elseif($row == 3){

$row = Working;

}

echo "<tr style='font-weight: bold;'><td>" . $row. "</td><td>" . $row ." </td></tr> ";;

}

So from the picture, you can see that I have something going but not quite there yet...

any suggestions/comments/hints :

Thanks

Emil

More updates

So I looked over the code once more and I saw that I was missing another If statements around line 300 where the chart looks like it's being used so I added:

<? if($_POST == 'tixSold'){?>

<? if($graphRow==NULL){ $graphRow='Sold'; }

elseif($graphRow==1){ $graphRow='Unsold';}

elseif($graphRow==2){ $graphRow='Pending';}

elseif($graphRow==3){ $graphRow='Working';}

?>

And that WORKS! : but my "sold" category is still blank like the previous problem... everything else is fine :/

EDIT: Found my mistake.. NULL was not sold.. it was none.. so Sold was a 0 :

Everything is working great! :)

Pelusa

If I understand you correctly then what you want is already built into the current version of reports but it only works if you are on osTickets 1.6ST

My mistake ! I was using spanish version and that version don't have that report !!

Thx ! =)

scottro

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

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

Reports are now able to be exported to csv. Don't forget to put your image file in the correct place, you may need to change it if you somewhere other than the default install.

rashmani

Hi Scott,

first of all thanks for this MOD.

I have a couple of questions though:

- image file: what's the right folder for it?

- when submitting query, I receive error "Can't open reports/Report_xxxxxxxxx.csv", any idea about it?

Image: I suppose the right folder is /scp/images but not sure about it.

I run OST 1.6ST with an Ubuntu 10.4 server.

Ok, my bad, I was unzipping without original folders, forget about the image.

Can't open problem: where should the reports folder be created? Ain't that my problem?

Cheers,

rash*

rashmani

Scott,

ok, figured it out: folder reports goes under /scp and must be writable by apache user (www-data in my case).

Still, I don't see the csv icon... which has been saved in /scp/images.

Again, great MOD, now that I see it in action! :-)

Cheers,

rash*

scottro

Oops, sorry about that. I forgot to mention in the notes that you need to make a reports folder within the scp folder. The image file should have been included in the zip file. The image goes in scp/images and should be named csv.png and should be 644.

melevy

Search?

Scott, this mod is great, thank you for the time you spent on it. One nice addition for the next version would be a search function. I'd like to be able to report on a specific client.

Thanks again!

aamarnath

Dear Scott,

Thank you so much for scripting the reporting tool, its awesome.

I have a query is there a way where we can view the ticket from the report generated.

i.e., a query to the database to pull out the closed/open tickets from the report, where in we can view the details of the ticket.

Thanks in advance....

scottro

Nothing at present but I'll add it to the wish list ;)

scottro

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

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

New report added: Tickets per Client (From)

beeman

Hi Scottro,

Thank you for continually updating your already awesome MOD.

I am looking into into using another MOD here on the forum to add a new field; a CUSTOMER field to be exact and have it pre-populated with our customer names which staff can choose when creating a new ticket. I would then like to be able to report against the "Tickets per Client" but based on this new CUSTOMER field for instance. Would you please look into this if it at all possible? Thank you for your assistance.

Regards,

Beeman

tazmanpa

Version 3.4 en español

espero les sirva la traducción al español de la versión 3.4

[reports_sp_v34.zip](https://forum.osticket.com/assets/files/migrated/a/bca1e3aef2cc9ba2e11dba885bf7b6e.zip)

anavmon

espero les sirva la traducción al español de la versión 3.4

Casi lo hacemos los dos xD

rg00dman

Hi All, I have just installed this wonderful mod but as always someone always wants something else lol. Just wondering if there is a way to add the percentage of calls closed before the due date? I am sure this is possible but sadly its beyond my very limited knowledge, Hope you can help.

Thanks

Rob

tarantula

i get a blank screen when i modify the header.inc

ozkr

is there a way you can update your mod to fit the pending status & autoclose MOD in the graphs?

Everyone would love it!

tostapiej

Report Modification

This report modification is awesome, but has anyone created a report for this mod that shows tickets by Priority with Hours to Resolution?

inajmi

Awesome MOD. Thanks a lot and keep up teh great work.

vreugd005

WOW! what a great MOD!! keep up the good work!

« Previous Page Next Page »