<?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);
