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