$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"),