<?php ################################################################## # Karnaf HelpDesk System - Copyright (C) 2001-2015 Kobi Shmueli. # # See the LICENSE file for more information. # ################################################################## require_once "karnaf_header.php"; CheckOperSession(); $id = $_GET['id']; if (empty($id) || !is_numeric($id)) { safe_die("Invalid Ticket ID!"); } show_title("Ticket #" . $id); make_menus("Karnaf (HelpDesk)"); $query = squery("SELECT t.id,t.randcode,t.status,t.description,t.unick,t.ufullname,t.uemail,t.uphone,t.uip,t.rep_u,\nt.rep_g,t.open_time,t.opened_by,t.is_real,t.is_private,t.email_upd,t.memo_upd,c1.name AS cat1_name,c2.name AS cat2_name,c3.name AS\ncat3_name,s.status_name,up.priority_name AS upriority,sp.priority_name AS priority,g.private_actions,t.merged_to,t.cc,up.priority_id \nAS upriority_id, sp.priority_id,t.ext1,t.ext2,t.ext3,t.title \nFROM (karnaf_tickets AS t INNER JOIN karnaf_cat3 AS c3 ON c3.id=t.cat3_id INNER JOIN karnaf_cat2 AS c2 ON c2.id=c3.parent\nINNER JOIN karnaf_cat1 AS c1 ON c1.id=c2.parent INNER JOIN karnaf_statuses AS s ON s.status_id=t.status INNER JOIN karnaf_priorities AS up ON\nup.priority_id=t.upriority INNER JOIN karnaf_priorities AS sp ON sp.priority_id=t.priority LEFT JOIN groups AS g ON g.name=t.rep_g) WHERE t.id=%d", $id); if (!($result = sql_fetch_array($query))) { safe_die("Invalid Ticket ID!"); } if (!IsGroupMember($result['rep_g']) && !IsKarnafAdminSession()) { AccessDenied("Ticket is assigned to another team."); } $autoload = 1; if (isset($_GET['reassign'])) { $autoload = 5; } $autostatus = ""; if (isset($_POST['is_private']) && $_POST['is_private'] == "on") { $is_private = 1; } else { $is_private = 0; }
<?php ################################################################## # Karnaf HelpDesk System - Copyright (C) 2001-2015 Kobi Shmueli. # # See the LICENSE file for more information. # ################################################################## require_once "karnaf_header.php"; CheckOperSession(80); show_title("Karnaf - Stats"); make_menus("Karnaf (HelpDesk)"); # 1 week: #$starttime = time() - 604800; # 30 days: $starttime = time() - 86400 * 30; echo "<font size=\"+1\">Tickets that were opened or closed since " . showdate($starttime) . ":</font><br><br>\n"; echo "<u>Teams:</u><br>\n"; $query = squery("SELECT t.id,t.rep_g,count(t.rep_g) AS c FROM karnaf_tickets AS t WHERE t.status!=5 AND (t.open_time>=%d OR t.close_time>=%d) GROUP BY rep_g ORDER BY id", $starttime, $starttime); while ($result = sql_fetch_array($query)) { echo $result['rep_g'] . ": " . $result['c'] . "<br>\n"; } sql_free_result($query); echo "<br>\n"; echo "<u>Opers:</u><br>\n"; $query = squery("SELECT t.id,t.rep_u,count(t.rep_u) AS c FROM karnaf_tickets AS t WHERE t.status!=5 AND (t.open_time>=%d OR t.close_time>=%d) GROUP BY rep_u ORDER BY c DESC", $starttime, $starttime); while ($result = sql_fetch_array($query)) { if (empty($result['rep_u'])) { $result['rep_u'] = "None"; } echo $result['rep_u'] . ": " . $result['c'] . "<br>\n"; } sql_free_result($query);