$i++;
$xtpl->parse("main.update.group_tickets.group_ticket_info1");
}
$xtpl->parse("main.update.group_tickets");
get_group_operations($xtpl, "main.update", "form1", 0, 0);
$type_message = array("comment"=>"Add comments", "reply"=>"Send answer");
$xtpl->assign("TYPE_MESSAGE", get_drop_down_list($type_message, "message_status"));
$xtpl->assign("MESSAGE_STATUS", $_REQUEST["message_status"]);
if($template > 0) $xtpl->assign("MESSAGE", get_template($template, 0, 0));
}
$query = "SELECT id, name FROM " . T_TEMPLATES . "
WHERE template_website='" . $_SESSION['website_url'] . "'";
$rows = SQL_select($query);
$templates_list = array();
if($rows) foreach($rows as $val) $templates_list[$val["id"]] = StripSlashes(htmlspecialchars($val["name"]));
$xtpl->assign("TEMPLATES_LIST", get_drop_down_list($templates_list, "template", "", "Select template", 0, "", " onchange=\"document.getElementById('form2').submit();\""));
get_queues_status($xtpl);
$sign_text=showsignature();
$sign_text2="\n\n\n\n\n".$sign_text;
if ($template==0)
$xtpl->assign("MESSAGE",$sign_text2);
$xtpl->parse("main.update");
$xtpl->parse("main");
$xtpl->out("main");
?>
//upper selects filling
//managers
$query = "SELECT id, login FROM " . T_USERS . " WHERE access=1 ORDER BY login";
$managers = SQL_select($query);
$users = array();
foreach($managers as $val) $users[$val["id"]] = $val["login"];
$xtpl->assign("MANAGERS", get_drop_down_list($users, "user", "", "Select manager"));
//years
$years=array("1"=>"2003","2"=>"2004","3"=>"2005","4"=>"2006","5"=>"2007","6"=>"2008","7"=>"2008","9"=>"2010");
$xtpl->assign("YEARS",get_drop_down_list($years,"year","","Select year"));
//monthes
$mquery="SELECT * FROM monthes";
$monthes=SQL_select($mquery);
$mdroplist=array();
foreach ($monthes as $k=>$v) $mdroplist[$v['month_id']]=$v['month_name'];
$xtpl->assign("MONTHES", get_drop_down_list($mdroplist, "month", "", "last 30 days"));
//year set
$today=getdate();
if ( (isset($_POST['year'])) and ($_POST['year'])!=0 )
$year=$years[$_POST['year']];
else
$year=$today['year'];
//month set
if ( (isset($_POST['month'])) and ($_POST['month'])!=0 )
$month=$_POST['month'];
function change_queue()
{
if((int)$_REQUEST["new_queue"] > 0)
{
$query = "SELECT group_id
FROM " . T_USERS_GROUPS . "
WHERE user_id=" . $_SESSION["uid"] . "
AND group_id=" . $_REQUEST["new_queue"];
$row = SQL_select($query, 0);
if($row)
{
foreach($_SESSION["selected_tickets"] as $ticket_id)
{
$query = "SELECT status, user_id, group_id FROM " . T_TICKETS . " WHERE id=" . $ticket_id;
$row1 = SQL_select($query, 0);
if($row1["group_id"] != (int)$_REQUEST["new_queue"])
{
$query = "INSERT
INTO " . T_TICKETS_ACTIONS . " (ticket_id,
user_action,
now_user_id,
prev_user_id,
now_ticket_status,
prev_ticket_status,
now_group_id,
prev_group_id,
created)
VALUES (" . $ticket_id . ",
'changed_group',
" . $_SESSION["uid"] . ",
" . $row1["user_id"] . ",
'" . $row1["status"] . "',
'" . $row1["status"] . "',
" . (int)$_REQUEST["new_queue"] . ",
" . $row1["group_id"] . ",
now())";
SQL_request($query);
$query = "UPDATE " . T_TICKETS . " SET group_id=" . (int)$_REQUEST["new_queue"] . ", updated=now() WHERE id=" . $ticket_id;
SQL_request($query);
}
ini_set("max_execution_time", 29);
}
}
}
}
elseif($val["message_type"] == "outcoming")
{
$comment = "The user <b>" . get_user_login($val["now_user_id"]) . "</b> sent the answer";
$xtpl->assign("MESSAGE_CLASS", "answer");
$xtpl->assign("BGCOLOR", "FFFFFF");
}elseif($val["message_type"] == "comment")
{
$xtpl->assign("MESSAGE_CLASS", "comment");
$comment = "The user <b>" . get_user_login($val["now_user_id"]) . "</b> added comments";
$xtpl->assign("BGCOLOR", "EFEFEF");
$actions = $temp_actions;
}
}
$xtpl->assign("COMMENT", $comment);
$xtpl->assign("ACTIONS", $actions);
$query = "SELECT body FROM " . T_BODIES . " WHERE id=" . $val["body_id"];
$row1 = SQL_select($query, 0);
if($row1 && trim($row1["body"]) != "")
{
$message_body = str_replace("$","$", StripSlashes(nl2br(htmlspecialchars($row1["body"]))));
$xtpl->assign("MESSAGE_BODY", $message_body);
$xtpl->parse("main.show_ticket.history_list.body_exists");
}
$xtpl->parse("main.show_ticket.history_list");
}
}
get_queues_status($xtpl);
$xtpl->parse("main.show_ticket");
$xtpl->parse("main");
$xtpl->out("main");
?>
if (isset($res4['id']) and !empty($res4['id']))
{
$xtpl->assign("SUBJECT", "<a href=\"show_ticket.php?ticket_id=" . $id . "\" class=\"ticket\">RE::" . $subject . "</a>");
}
else {
$xtpl->assign("SUBJECT", "<a href=\"show_ticket.php?ticket_id=" . $id . "\" class=\"ticket\">" . $subject . "</a>");
}
$query = "SELECT name FROM " . T_GROUPS . " WHERE id=" . $group_id . "";
$row1 = SQL_select($query, 0);
$query = "SELECT login FROM " . T_USERS . " WHERE id=" . $user_id . "";
$rowx = SQL_select($query, 0);
$xtpl->assign("QUEUE", StripSlashes(htmlspecialchars($row1["name"])));
$xtpl->assign("OWNER", $rowx["login"]);
if($cc_member_id > 0) $member = "<span class=\"grey\">member id:</span> <strong>" . $cc_member_id ."</strong>";
else $member = "<span class=\"grey\">member id:</span> <strong>none</strong>";
$golden = ($golden == "true" and (int)$cc_member_id) ? "<br><span class='golden'>[GOLDEN]</span>":"";
if(strlen($from_email) > 0) $from_email = "<span class=\"grey\">email:</span> <strong>" . $from_email."</strong>";
else $from_email = "<span class=\"grey\">email:</span> <strong>none</strong>";
$applicant_name = "";
if(trim($cc_fname) != "" || trim($cc_lname != "")) $applicant_name = "<br><span class=\"grey\">name:</span> <strong>" . ucwords(htmlspecialchars($cc_fname)) . " " . ucwords(htmlspecialchars($cc_lname))."</strong>";
$xtpl->assign("FROM", $member . $applicant_name . "<br>" . $from_email . $golden);
$xtpl->assign("STATUS_CLASS", $status);
$xtpl->assign("TICKET_STATUS", $status);
