$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");
?>
$xtpl->assign("PRIORITY",$row["priority"]);
$xtpl->assign("ANOTHER_PRIORITY", get_drop_down_list($tmp_priority, "priority", "", "Select Priority", 0, "", "onchange=\"document.getElementById('act').value='change_priority'; document.getElementById('form1').submit();\""));
$query = "SELECT DISTINCT g.id, g.name
FROM " . T_USERS_GROUPS . " as ug, " . T_GROUPS . " as g
WHERE ug.user_id=" . $_SESSION["uid"] . "
AND ug.group_id=g.id
AND g.id != " . $row["group_id"];
$rows = SQL_select($query);
$queues = array();
foreach($rows as $val) $queues[$val["id"]] = $val["name"];
$query = "SELECT name FROM " . T_GROUPS . " WHERE id=" . $row["group_id"];
$row1 = SQL_select($query, 0);
$xtpl->assign("QUEUE", StripSlashes(htmlspecialchars($row1["name"])));
$xtpl->assign("ANOTHER_QUEUES", get_drop_down_list($queues, "queue", "", "Select another queue", 0, "", "onchange=\"document.getElementById('act').value='change_queue'; document.getElementById('form1').submit();\""));
$xtpl->assign("CREATED", $row["created"]);
$xtpl->assign("TIC_WEBSITE", $row["website"]);
if(!$row["created_days_left"]) $xtpl->assign("CREATED_DAYS_AGO", "Today");
else $xtpl->assign("CREATED_DAYS_AGO", "<br>" . $row["created_days_left"] . " days ago");
$xtpl->assign("UPDATED", $row["updated"]);
if(!$row["updated_days_left"]) $xtpl->assign("UPDATED_DAYS_AGO", "Today");
else $xtpl->assign("UPDATED_DAYS_AGO", "<br>" . $row["updated_days_left"] . " days ago");
$golden = ($row["golden"]=='true' and (int)$row["cc_member_id"])?" <b>[GOLDEN]</b>":"";
if((int)$row["cc_member_id"]) $xtpl->assign("APPLICANT_ID", "<a href='https://suadmctrl8.ualadys.com/members.rpx?id={$row['cc_member_id']}' target='support'>".$row["cc_member_id"]."</a>".$golden);
else $xtpl->assign("APPLICANT_ID", "consumer doesn't exists");
$applicant_name = "";
if(trim($row["cc_fname"]) != "" || trim($row["cc_lname"]) != "")
{
$applicant_name = ucwords(htmlspecialchars($row["cc_fname"])) . " " . ucwords(htmlspecialchars($row["cc_lname"]));
$xtpl->assign("APPLICANT_NAME", $applicant_name);
$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'];
else
$month=$today['mon'];
//days set
function get_group_operations(&$xtpl, $path, $form_id, $group_id = 0, $need_reply = 1)
{
$query = "SELECT id, login FROM " . T_USERS . " WHERE access=1 ORDER BY login";
$rows = SQL_select($query);
$users = array();
foreach($rows as $val) $users[$val["id"]] = $val["login"];
$xtpl->assign("NEW_OWNERS", get_drop_down_list($users, "owner", "", "owner"));
$status = get_enum(T_TICKETS, "status");
$tmp_status = array();
foreach($status as $val) if($val != $row["status"]) $tmp_status[$val] = $val;
$xtpl->assign("NEW_STATUS", get_drop_down_list($tmp_status, "status", "", "status", ""));
$query = "SELECT DISTINCT g.id, g.name
FROM " . T_USERS_GROUPS . " as ug, " . T_GROUPS . " as g
WHERE ug.user_id=" . $_SESSION["uid"] . "
AND ug.group_id=g.id
AND g.id != " . $group_id;
$rows = SQL_select($query);
$queues = array();
foreach($rows as $val) $queues[$val["id"]] = $val["name"];
$xtpl->assign("NEW_QUEUES", get_drop_down_list($queues, "new_queue", "", "queue", 0));
$xtpl->assign("UPDATE", "document.getElementById('act').value='update'; document.getElementById('" . $form_id . "').submit();");
if($need_reply)
{
$xtpl->assign("GA_TITLE", "Group Actions");
$xtpl->assign("REPLY", "document.getElementById('act').value='reply'; document.getElementById('" . $form_id . "').submit();");
$xtpl->assign("ADD_COMMENTS", "document.getElementById('act').value='add_comment'; document.getElementById('" . $form_id . "').submit();");
$xtpl->parse($path . ".group_operations.write_message");
}else $xtpl->assign("GA_TITLE", "Actions");
$xtpl->parse($path . ".group_operations");
}
$prev_ticket_id = $quick_ticket_id-1;
$next_ticket_id = $quick_ticket_id+1;
$xtpl->assign("TICKET_NAV", "<form action='/show_ticket.php' id='quick_ticket_frm' style='display:inline;'><a href='/show_ticket.php?ticket_id={$prev_ticket_id}'>prev</a> <input type='text' name='ticket_id' class='input1' size='7' value='$quick_ticket_id' style='text-align:center'><!--<input type='submit' value='>' style='width:10px;'>--> <a href='/show_ticket.php?ticket_id={$next_ticket_id}'>next</a></form>");
//ticket menu section--
// $xtpl->assign("USERS_STATUS", "<img src=\"" . MAIN_HOST . "images/on-line.gif\" align=\"absmiddle\" alt=\"On-line\"><span class=\"whitetext2\">" . $row["num_users"] . "</span> <img src=\"" . MAIN_HOST . "images/off-line.gif\" align=\"absmiddle\" alt=\"Off-line\"><span class=\"whitetext2\">" . $row1["num_users"] . "</span>");//replaced by ticket menu
if(array_key_exists("website", $_REQUEST))
{
$_SESSION["website_url"] = $_REQUEST["website"];
}elseif(!array_key_exists("website_url", $_SESSION))
{
$def_website = get_enum(T_TICKETS, "website");
$_SESSION["website_url"] = $def_website[0];
}
$xtpl->assign("WEBSITE", get_drop_down_list(array(), "website", T_TICKETS, "", 0, $_SESSION["website_url"], "onchange=\"document.getElementById('website_form').submit();\""));
if ($myDB=="ccss")
{
$xtpl->assign("CURRENT", "External");
$link=$_SERVER['REQUEST_URL'];
$link .="?int=true";
$xtpl->assign("LINKS",$link);
}
else
{
$link=$_SERVER['REQUEST_URL'];
$link="?ext=true";
$xtpl->assign("LINKS",$link);
$xtpl->assign("CURRENT","Internal");
//add new template
if($act == "add")
{
$xtpl->assign("TEMPLATE_WEBSITE", get_drop_down_list(array(), "template_website", T_TEMPLATES, "", 0, $_SESSION["website_url"]));
$xtpl->parse("main.templates.action");
}elseif(($act == "edit")&&($id > 0))
{
$query = "SELECT id, name, message, template_website FROM " . T_TEMPLATES . " WHERE id=" . $id;
$row = SQL_select($query, 0);
if($row)
{
$xtpl->assign("TEMPLATE_NAME", StripSlashes(htmlspecialchars($row["name"])));
$xtpl->assign("ID", "<input type=\"hidden\" name=\"id\" value=\"" . $id . "\">");
$xtpl->assign("MESSAGE", StripSlashes(htmlspecialchars($row["message"])));
$xtpl->assign("TEMPLATE_WEBSITE", get_drop_down_list(array(), "template_website", T_TEMPLATES, "", 0, $row["template_website"]));
$xtpl->parse("main.templates.action");
}else $act = "view";
}else $act = "view";
//view templates list
if($act == "view")
{
$xtpl->assign("ADD_TEMPLATE", "<a href=\"templates.php?act=add\">Add template</a>");
$xtpl->assign("DELETE_TEMPLATE", "<a href=\"\" onclick=\"return false;\" onmouseup=\"if(window.confirm('Are you sure?')) document.getElementById('form1').submit()\">Delete selected</a>");
$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"=>""),
"Template name"=>array("field"=>"name","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"name"),
"Web site"=>array("field"=>"template_website","sort"=>"sort","def_sort_type"=>"","sort_order"=>"","url_name"=>"t_website"),
"Action"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""));
$query = "SELECT id, name, template_website
$xtpl->assign("QUEUES",$queue);
}
list($query, $queue, $ticket_status) = get_query_for_tickets();
$row=array();
$data=date("Y-m-d");
$z=1;
$query = "SELECT id, login FROM " . T_USERS . " WHERE access=1 ORDER BY login";
$rows = SQL_select($query);
$users = array();
foreach($rows as $val) $users[$val["id"]] = $val["login"];
$xtpl->assign("SEL_OWNERS", get_drop_down_list($users, "owners", "", "owners"));
$xtpl->assign("SECTION_NAME", "Brakes");
$view_only="request";
$view_owners=$_SESSION['uid'];
if (isset($_REQUEST['status']))
{
$view_only=$_REQUEST['status'];
}
if (isset($_REQUEST['owners']))
{
$view_owners=$_REQUEST['owners'];
}
$query="SELECT * FROM
permissions,
position,
name
FROM " . T_USERS . "
WHERE id=" . $id;
$row = SQL_select($query, 0);
if($row)
{
$xtpl->assign("LOGIN", $row["login"]);
$xtpl->assign("ID", "<input type=\"hidden\" name=\"id\" value=\"" . $id . "\">");
$query = "SELECT group_id FROM " . T_USERS_GROUPS . " WHERE user_id=" . $id;
$rows = SQL_select($query);
$selected_queues = array();
if($rows) foreach($rows as $val) $selected_queues[] = $val["group_id"];
$xtpl->assign("QUEUES", get_drop_down_list($queues, "queues", "", "", 0, $selected_queues, "", 1));
$xtpl->assign("PERMISSION", get_drop_down_list($permission, "permission", "", "", 0, $row["permissions"]));
$xtpl->assign("POSITION", StripSlashes(htmlspecialchars($row["position"])));
$xtpl->assign("FULLNAME", StripSlashes(htmlspecialchars($row["name"])));
$query = "SELECT signature FROM " . T_SIGNATURES . " WHERE user_id=" . $id;
$row1 = SQL_select($query, 0);
if($row1) $xtpl->assign("SIGNATURE", StripSlashes(htmlspecialchars($row1["signature"])));
$xtpl->parse("main.users.action");
}else $act = "view";
}else $act = "view";
$xtpl->assign("SECTION_NAME", "Users");
$cfg_sort_fields = array("#"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Active"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
"Login"=>array("field"=>"","sort"=>"","def_sort_type"=>"","sort_order"=>"","url_name"=>""),
* very similar to the stat.php except search parameters in query
* include validator.php
*/
include "validator.php";
//from dizel
if(array_key_exists("searching_parameters", $_SESSION)) unset($_SESSION["searching_parameters"]);
$cond1 = array("appear"=>"appear", "not appear"=>"not appear");
$cond2 = array("contain"=>"contain","not contain"=>"not contain","appear"=>"appear", "not appear"=>"not appear");
//upper selects filling
//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);
$today=getdate();
//year set
if ( (isset($_POST['year'])) and ($_POST['year'])!=0 )
$year=$years[$_POST['year']];
else
$year=$today['year'];
$xtpl->assign("SECTION_NAME", "Statistics: Summary for ".$year." year");
//main part: get from db, replace and execute queries
$query = "SELECT id, login FROM " . T_USERS . " WHERE access=1 ORDER BY login";
$rows = SQL_select($query);
$users = array();
foreach($rows as $val) $users[$val["id"]] = $val["login"];
$xtpl->assign("OWNERS", get_drop_down_list($users, "owner", "", "-"));
$xtpl->assign("CONDITION1", get_drop_down_list($cond1, "owner_cond"));
$xtpl->assign("CONDITION2", get_drop_down_list($cond2, "email_cond"));
$xtpl->assign("CONDITION3", get_drop_down_list($cond2, "subj_cond"));
$query = "SELECT DISTINCT g.id, g.name
FROM " . T_USERS_GROUPS . " as ug, " . T_GROUPS . " as g
WHERE ug.user_id=" . $_SESSION["uid"] . "
AND ug.group_id=g.id";
$rows = SQL_select($query);
$queues = array();
foreach($rows as $val) $queues[$val["id"]] = $val["name"];
$xtpl->assign("QUEUES", get_check_boxs($queues, "queue", "", 3));
$xtpl->assign("CONDITION4", get_drop_down_list($cond1, "queue_cond"));
$xtpl->assign("STATUS", get_check_boxs(array(), "status", T_TICKETS, 4));
$xtpl->assign("CONDITION5", get_drop_down_list($cond1, "status_cond"));
//$xtpl->assign("COMPLAIN", "complain or not");
//$xtpl->assign("RATE", "");
get_queues_status($xtpl);
$xtpl->parse("main.search_tickets");
$xtpl->parse("main");
$xtpl->out("main");
?>
