Ask not what osTicket community can do for you - ask what you can do for osTicket community

Go Back   osTicket Forums > osTicket 1.6.x > Mods and Customizations

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-13-2011, 05:02 PM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Exclamation [MOD] Report Page v5.0

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


Last edited by scottro; 06-22-2012 at 02:56 PM. Reason: Updated Version
Reply With Quote
  #2  
Old 06-15-2011, 10:04 AM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Default

Version 1.2 has been released. See zip file on my website. Changelog is located at the bottom of the article.
Reply With Quote
  #3  
Old 06-15-2011, 11:12 AM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Default

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)
Reply With Quote
  #4  
Old 06-15-2011, 04:12 PM
mouseware mouseware is offline
Junior Member
 
Join Date: Jun 2011
Posts: 8
Default

very sweet, thanks!
Reply With Quote
  #5  
Old 06-16-2011, 08:46 AM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Default

Quote:
Originally Posted by mouseware View Post
very sweet, thanks!
My pleasure! Thanks for the feedback!
Reply With Quote
  #6  
Old 06-16-2011, 12:21 PM
mouseware mouseware is offline
Junior Member
 
Join Date: Jun 2011
Posts: 8
Default

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.
Reply With Quote
  #7  
Old 08-24-2011, 05:05 PM
aamarnath aamarnath is offline
Junior Member
 
Join Date: Aug 2011
Posts: 1
Default

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....
Reply With Quote
  #8  
Old 08-24-2011, 05:16 PM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Default

Nothing at present but I'll add it to the wish list
Reply With Quote
  #9  
Old 08-30-2011, 01:20 PM
scottro's Avatar
scottro scottro is offline
Senior Member
 
Join Date: Jul 2009
Posts: 726
Default

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

New report added: Tickets per Client (From)
Reply With Quote
  #10  
Old 08-31-2011, 11:20 AM
beeman beeman is offline
Member
 
Join Date: May 2009
Posts: 62
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:09 PM.