getVar("support_dep") == 0) { // Get the result $newsupport = $jakdb->select("support_tickets", ["[>]support_departments" => ["depid" => "id"], "[>]ticketpriority" => ["priorityid" => "id"], "[>]clients" => ["clientid" => "id"]], ["support_tickets.id", "support_tickets.subject", "support_tickets.content", "support_tickets.status", "ticketpriority.title(titleprio)", "ticketpriority.class", "support_tickets.initiated", "support_departments.title(titledep)", "clients.name"], ["OR" => ["support_tickets.private" => 0, "support_tickets.clientid" => JAK_CLIENTID], "ORDER" => ["support_tickets.updated" => "DESC"], "LIMIT" => "3" ]); // Only for certain categories } else { // Get the result $newsupport = $jakdb->select("support_tickets", ["[>]support_departments" => ["depid" => "id"], "[>]ticketpriority" => ["priorityid" => "id"], "[>]clients" => ["clientid" => "id"]], ["support_tickets.id", "support_tickets.subject", "support_tickets.content", "support_tickets.status", "ticketpriority.title(titleprio)", "ticketpriority.class", "support_tickets.initiated", "support_departments.title(titledep)", "clients.name"], ["OR" => ["support_tickets.private" => 0, "support_tickets.depid" => [$jakclient->getVar("support_dep")], "support_tickets.clientid" => JAK_CLIENTID], "ORDER" => ["support_tickets.updated" => "DESC"], "LIMIT" => "3" ]); } // Can see all active articles } elseif (JAK_USERID) { if ($jakuser->getVar("support_dep") == 0) { // Get the result $newsupport = $jakdb->select("support_tickets", ["[>]support_departments" => ["depid" => "id"], "[>]ticketpriority" => ["priorityid" => "id"], "[>]clients" => ["clientid" => "id"]], ["support_tickets.id", "support_tickets.subject", "support_tickets.content", "support_tickets.status", "support_tickets.initiated", "ticketpriority.title(titleprio)", "ticketpriority.class", "support_departments.title(titledep)", "clients.name"], [ "ORDER" => ["support_tickets.updated" => "DESC"], "LIMIT" => "3" ]); } else { // Get the result $newsupport = $jakdb->select("support_tickets", ["[>]support_departments" => ["depid" => "id"], "[>]ticketpriority" => ["priorityid" => "id"], "[>]clients" => ["clientid" => "id"]], ["support_tickets.id", "support_tickets.subject", "support_tickets.content", "support_tickets.status", "support_tickets.initiated", "ticketpriority.title(titleprio)", "ticketpriority.class", "support_departments.title(titledep)", "clients.name"], ["support_tickets.depid" => [$jakuser->getVar("support_dep")], "ORDER" => ["support_tickets.updated" => "DESC"], "LIMIT" => "3" ]); } // Can see categories for guests } else { // Get the result $newsupport = $jakdb->select("support_tickets", ["[>]support_departments" => ["depid" => "id"], "[>]ticketpriority" => ["priorityid" => "id"], "[>]clients" => ["clientid" => "id"]], ["support_tickets.id", "support_tickets.subject", "support_tickets.content", "support_tickets.status", "ticketpriority.title(titleprio)", "ticketpriority.class", "support_tickets.initiated", "support_departments.title(titledep)", "clients.name"], ["AND" => ["support_tickets.private" => 0, "support_departments.guesta" => 1], "ORDER" => ["support_tickets.updated" => "DESC"], "LIMIT" => "3" ]); } if (isset($newsupport) && !empty($newsupport)) { ?>
'.$jkl['hd14'].'' : ($supn["status"] == 2 ? ''.$jkl['hd15'].'' : ''.$jkl['hd16'].''));?> / ">