$rows = SQL_select($query);
$i = 1;
foreach($rows as $row)
{
if((int)$row["cc_member_id"]) $applicant = "Consumer ID: <b>" . (int)$row["cc_member_id"] . "</b> ";
if($row["from_email"] != "") $applicant .= "E-mail: <b>" . trim($row["from_email"]) . "</b>";
$applicant_name = "";
if(trim($row["cc_fname"]) != "" || trim($row["cc_lname"]) != "") $applicant_name = " <b>" . ucwords(htmlspecialchars($row["cc_fname"])) . " " . ucwords(htmlspecialchars($row["cc_lname"])) . "</b>";
$xtpl->assign("APPLICANT", "#" . $i . ": " . $applicant . $applicant_name . "</br>");
$xtpl->parse("main.update.group_tickets.group_ticket_info");
$xtpl->assign("TICKET_INFO", "#" . $i . ": " . "Owner: <strong>" . get_user_login($row["user_id"]) . "</strong> Queue: <strong>" . get_queue_name($row["group_id"]) . "</strong> Status: <strong>" . $row["status"] . "</strong><br>");
$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();\""));
"<a href=\"#\" onclick=\"return false\" onmouseup=\"select_all_checkboxs('select[]','form1')\" class=\"table_header_text\">Select</a>"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Subject"=>array("field"=>"subject","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"subj"),
"Queues"=>array("field"=>"group_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"queue"),
"Status"=>array("field"=>"status","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"status"),
"Owner"=>array("field"=>"user_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"owner"),
"From"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
"Complain"=>array("field"=>"complain","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"complain"),
"Rate"=>array("field"=>"rate","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"rate"),
"Updated"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
"Created"=>array("field"=>"created","sort"=>"default","def_sort_type"=>"desc","sort_order"=>"0","url_name"=>"created"));
list($query, $queue, $ticket_status) = get_query_for_tickets();
if($query != "")
{
get_group_operations($xtpl, "main.request", "form1", (int)$_REQUEST["queue"]);
$parameters = "";
if(array_key_exists("searching_parameters", $_SESSION))
{
$parameters = get_parameters_string($_SESSION["searching_parameters"]);
if($parameters != "") $parameters = "<a href=\"#\" onclick=\"return false;\" onmouseup=\"window.external.AddFavorite('" . MAIN_HOST . "search_tickets.php?act=search&" . $parameters . "', 'Search results of tickets')\" class=\"topmenu\">Add search results to favorites</a>";
}
$xtpl->assign("SEARCH_LINK", $parameters);
$add_params = array("get"=>array(), "post"=>array(), "post1"=>array());
if($queue > 0)
{
$add_params["get"][] = "queue=" . $queue;
$add_params["post"][] = "<input type=\"hidden\" name=\"queue\" value=\"" . $queue . "\">\n";
$add_params["post1"]["queue"] = $queue;
$xtpl->assign("QUEUES",$queue);
"Subject"=>array("field"=>"subject","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"subj"),
"Queues"=>array("field"=>"group_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"queue"),
"Status"=>array("field"=>"status","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"status"),
"Owner"=>array("field"=>"user_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"owner"),
"Priority"=>array("field"=>"priority","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"priority"),
"From"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
"Complain"=>array("field"=>"complain","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"complain"),
"Rate"=>array("field"=>"rate","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"rate"),
"Updated"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
"Created"=>array("field"=>"created","sort"=>"default","def_sort_type"=>"desc","sort_order"=>"0","url_name"=>"created"));
list($query, $queue, $ticket_status) = get_query_for_tickets();
if($query != "")
{
get_group_operations($xtpl, "main.tickets", "form1", (int)$_REQUEST["queue"]);
$parameters = "";
if(array_key_exists("searching_parameters", $_SESSION))
{
$parameters = get_parameters_string($_SESSION["searching_parameters"]);
if($parameters != "") $parameters = "<a href=\"#\" onclick=\"return false;\" onmouseup=\"window.external.AddFavorite('" . MAIN_HOST . "search_tickets.php?act=search&" . $parameters . "', 'Search results of tickets')\" class=\"topmenu\">Add search results to favorites</a>";
}
$xtpl->assign("SEARCH_LINK", $parameters);
$add_params = array("get"=>array(), "post"=>array(), "post1"=>array());
if($queue > 0)
{
$add_params["get"][] = "queue=" . $queue;
$add_params["post"][] = "<input type=\"hidden\" name=\"queue\" value=\"" . $queue . "\">\n";
$add_params["post1"]["queue"] = $queue;
$xtpl->assign("QUEUES",$queue);
include "validator.php";
//unset session variables
if(array_key_exists("selected_ticket_id", $_SESSION)) unset($_SESSION["selected_ticket_id"]);
if(array_key_exists("searching_parameters", $_SESSION)) unset($_SESSION["searching_parameters"]);
$xtpl->assign("SECTION_NAME", "My Tickets");
//getting ticket info
if(array_key_exists("select", $_REQUEST))
{
$_SESSION["selected_tickets"] = $_REQUEST["select"];
$tmp = new group_operations($act);
}
if(array_key_exists("selected_tickets", $_SESSION)) unset($_SESSION["selected_tickets"]);
get_group_operations($xtpl, "main.account", "form1");
//sort array
$cfg_sort_fields = array("#"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"<a href=\"#\" onclick=\"return false\" onmouseup=\"select_all_checkboxs('select[]','form1')\" class=\"table_header_text\">Select</a>"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Subject"=>array("field"=>"subject","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"subj"),
"Queues"=>array("field"=>"group_id","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"queue"),
"Status"=>array("field"=>"status","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"status"),
"Priority"=>array("field"=>"priority","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"priority"),
"From"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Complain"=>array("field"=>"complain","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"complain"),
"Rate"=>array("field"=>"rate","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"rate"),
"Updated"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Created"=>array("field"=>"created","sort"=>"default","def_sort_type"=>"desc","sort_order"=>"0","url_name"=>"created")
);
<?
include "validator.php";
if(array_key_exists("selected_ticket_id", $_SESSION)) unset($_SESSION["selected_ticket_id"]);
get_group_operations($xtpl, "#", "form1", (int)$_REQUEST["queue"]);
$parameters = "";
if(array_key_exists("select", $_REQUEST))
{
$_SESSION["selected_tickets"] = $_REQUEST["select"];
$tmp = new group_operations($act);
}
if($_SESSION['permission'] != "admin")
{
header("Location: index.php");
exit;
}
$cfg_sort_fields = array("#"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"<a href=\"#\" onclick=\"return false\" onmouseup=\"select_all_checkboxs('select[]','form1')\" class=\"table_header_text\">Select</a>"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Subject"=>array("field"=>"subject","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"subj"),
"Queues"=>array("field"=>"group_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"queue"),
"Status"=>array("field"=>"status","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"status"),
"Owner"=>array("field"=>"user_id","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"owner"),
"From"=>array("field"=>"","sort"=>"","def_sort_type"=>"desc","sort_order"=>"","url_name"=>""),
"Complain"=>array("field"=>"complain","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"complain"),
"Rate"=>array("field"=>"rate","sort"=>"sort","def_sort_type"=>"desc","sort_order"=>"","url_name"=>"rate"),
