So, after doing some digging and dabbling with some code, I was able to create something like I was looking for, however the process in making it work involved a lot of mysql queries and if lines to redirect to login pages or the main page depending what department the ticket was assigned to.
In the first image "main-page", I used and modified the "display_open_topics" MOD that is available and made it look a little more perty.
The "outage-board" uses the same MOD but with a slightly different SQL query.
here is the query I used for the outage board:
$query = "SELECT * FROM ost_ticket WHERE dept_id REGEXP '(3|4)' ORDER BY created DESC LIMIT 0,$limit";
For security, the output for "outage-ticket" comes from another file included within a customer page I created called outage.php. To limit who can see what tickets, I used a few 'if' statements to redirect to the appropriate pages. Here's the code I used for it, it's a little ugly but I couldn't figure any other way to do.
if ($id == NULL){
header("Location: open.php");
}
if ($id !== $ticket){
header("Location: tickets.php");
}
if ($dept == "1"){
header("Location: tickets.php");
}
else
{
include('view_outage_ticket.php');
}
The only thing I haven't figured out yet, is changing the ticket format so outages have an "O" in the front of it.
When I find some time later, I will try to add the pages I created so others can use this if they'd like to.
