Copyright (C) 2008-2023 All Rights Reserved. Contributor(s): Mark J Crane Tony Fernandez */ //includes files require_once dirname(__DIR__, 2) . "/resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (permission_exists('xml_cdr_search_advanced')) { //access granted } else { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); //declare variables $direction = ""; $caller_id_name = ""; $caller_id_number = ""; $destination_number = ""; $context = ""; $start_stamp_begin = ""; $start_stamp_end = ""; $answer_stamp_begin = ""; $answer_stamp_end = ""; $end_stamp_begin = ""; $end_stamp_end = ""; $duration_min = ""; $duration_max = ""; $billsec = ""; $hangup_cause = ""; $xml_cdr_uuid = ""; $bridge_uuid = ""; $accountcode = ""; $read_codec = ""; $write_codec = ""; $remote_media_ip = ""; $network_addr = ""; $mos_score = ""; //get the list of extensions $sql = "select extension_uuid, extension, number_alias from v_extensions "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "order by extension asc, number_alias asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $extensions = $database->select($sql, $parameters, 'all'); //get the list of call center queues if (permission_exists('xml_cdr_call_center_queue')) { $sql = "select call_center_queue_uuid, queue_name, queue_extension from v_call_center_queues "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "order by queue_extension asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $call_center_queues = $database->select($sql, $parameters, 'all'); } //send the header $document['title'] = $text['title-advanced_search']; require_once "resources/header.php"; //javascript to toggle input/select boxes echo ""; //start the html form if (isset($_GET['redirect']) && $_GET['redirect'] == 'xml_cdr_statistics') { echo "

\n"; } else { echo "\n"; } echo "

\n"; echo "

".$text['title-advanced_search']."

\n"; echo "

\n"; echo button::create(['type'=>'button','label'=>$text['button-back'],'icon'=>$_SESSION['theme']['button_icon_back'],'id'=>'btn_back','style'=>'margin-right: 15px;','link'=>'xml_cdr.php']); echo button::create(['type'=>'submit','label'=>$text['button-search'],'icon'=>$_SESSION['theme']['button_icon_search'],'id'=>'btn_save']); echo "

\n"; echo "

\n"; echo "\n"; echo " \n"; echo " "; echo " "; echo " "; echo "

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " "; echo " "; //source name echo " "; echo " "; echo " "; echo " "; //source number echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; if (permission_exists('xml_cdr_all')) { echo " "; echo " "; echo " "; } echo "

\n"; echo " ".$text['label-direction']."\n"; echo "	\n"; echo " \n"; if (permission_exists('xml_cdr_b_leg')){ echo " \n"; } echo "
".$text['label-caller_id_name']."
".$text['label-extension']."	"; echo " \n"; echo " \n"; echo " \n"; echo "
".$text['label-destination']."
".$text['label-context']."
".$text['label-start_range']."	"; echo " \n"; echo " "; echo " "; echo " "; echo " \n"; echo " \n"; echo "
".$text['label-answer_range']."	"; echo " \n"; echo " "; echo " "; echo " "; echo " \n"; echo " \n"; echo "
".$text['label-end_range']."	"; echo " \n"; echo " "; echo " "; echo " "; echo " \n"; echo " \n"; echo "
".$text['label-duration']." (".$text['label-seconds'].")	\n"; echo " \n"; echo " \n"; echo "
".$text['button-show_all']."	\n"; if (permission_exists('xml_cdr_all') && isset($_REQUEST['show']) && $_REQUEST['show'] == "all") { echo " "; } else { echo " "; } echo "	"; echo "

"; echo "

\n"; echo "\n"; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; if (permission_exists('xml_cdr_account_code')) { echo " "; echo " "; echo " "; echo " "; } echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; if (isset($_SESSION['cdr']['field']) && is_array($_SESSION['cdr']['field'])) { foreach ($_SESSION['cdr']['field'] as $field) { $array = explode(",", $field); $field_name = end($array); $field_label = ucwords(str_replace("_", " ", $field_name)); $field_label = str_replace("Sip", "SIP", $field_label); if ($field_name != "destination_number") { echo " "; echo " "; echo " "; echo " "; } } } echo " "; echo " "; echo " "; echo " \n"; if (permission_exists('xml_cdr_search_call_center_queues')) { echo " "; echo " "; echo " "; echo " \n"; unset($sql, $parameters, $call_center_queues, $row, $selected); } echo "

".$text['label-billsec']."
".$text['label-hangup_cause']."
".$text['label-uuid']."
".$text['label-bridge_uuid']."
".$text['label-accountcode']."
".$text['label-read_codec']."
".$text['label-write_codec']."
".$text['label-remote_media_ip']."
".$text['label-network_addr']."
".escape($field_label)."
".$text['label-mos_score']."	"; echo " \n"; echo " \n"; echo "
".$text['label-call_center_queue']."	"; echo " \n"; echo "

\n"; echo "

"; echo "

"; echo "

"; //include footer require_once "resources/footer.php"; ?>