Print All Tickets

[country101]

Script URL: mtnflyer.net/inventory
Version of script: 2.1
Hosting company: godaddy.com
URL of phpinfo.php: mtnflyer.net/inventory/phpinfo.php
URL of session_test.php: mtnflyer.net/inventory.session_test.php
What terms did you try when SEARCHING for a solution:
"print all tickets"
print all tickets
print all

Write your message below:

I was just curious if there was a way to generate a report to print all the open tickets. I can format it the way I would like it to look, but not sure of the command to generate the report for all open tickets to get them all to list out.

Any help would be greatly appreciated and thank you.

[Klemen]

Sounds like an interesting feature. What kind of format do you have in mind?

[country101]

Well we are using this system as a parts tracker instead of a helpdesk type issue. Right now we use an access database and have a report that we print everyday. The report in terms of HESK would include everything in the ticket, pulled from the database. So would just be simple columns and rows with headers and our logo on the top.

[Klemen]

It's on the "to do" list and will be included in one of the future versions.

[country101]

I sorta of created a workaround where I took the "print_tickets" and the "show_tickets" from what you see in the admin interface, and I then just removed all the admin parts of it, which just left the print out showing the tickets.

My only question from doing this, is how can I have this page display without the user having to login. I just want anyone to be able to see this page since they won't be able to modify the ticket from it anyways. I tried removing the "checkpermission" but I think it takes more than that.

Thanks

[Klemen]

You will probably want to remove hesk_isLoggedIn(); as well.

But I don't recommend making such a file public as it could allow others to print tickets that don't belong to them and possibly lead to privacy/security issues.

[country101]

Thanks for your response, our ticket system is based on orders for airplane parts and privacy is not really an issue, especially since its now being used internally. I am still unable to be able to view this page publicly thought as it still wants me either to login or say it cannot execute the SQL.

/* Get all the required files and functions */
require(HESK_PATH . 'hesk_settings.inc.php');
require(HESK_PATH . 'inc/common.inc.php');
require(HESK_PATH . 'inc/database.inc.php');

hesk_session_start();
hesk_dbConnect();
hesk_isLoggedIn();

/* Check permissions for this feature */
hesk_checkPermission('can_view_tickets');

If i try to disable anything with the session or logged in, it says it cannot execute and if i try disabling the checking of permission the code executes but is unable to still do anything giving me an "invalid action" error message

If you have any other insights that would be great and appreciated.

Thanks

[coeugh]

Hi,

Im using hesk 2.4.2 customized to my needs, and i need to Print all open ticket i mean only the list off the open ticket.

The listing shud be the same as the list of the open ticket.

Is there anyway to do this ?


Thanks

[Klemen]

The only built-in way this can be done in HESK is to list all tickets on a single page then print that page.