Copyright (C) 2010-2023 All Rights Reserved. Contributor(s): Mark J Crane */ //includes files require_once dirname(__DIR__, 2) . "/resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (permission_exists('active_extension_view')) { //access granted } else { echo "access denied"; exit; } //set debug to true or false $debug = false; //http get and set variables if (strlen($_GET['url']) > 0) { $url = $_GET['url']; } if (strlen($_GET['rows']) == 0) { $_GET['rows'] = 0; } //connect to the database $database = new database; //define variables $c = 0; $row_style["0"] = "row_style1"; $row_style["1"] = "row_style1"; //get the user status $sql = "select e.extension, u.username, u.user_status "; $sql .= "from v_users as u, v_extensions as e "; $sql .= "where e.domain_uuid = :domain_uuid "; $sql .= "and u.user_enabled = 'true' "; $sql .= "and u.domain_uuid = :domain_uuid "; //$sql = "select * "; //$sql .= "from v_extensions "; //$sql .= "where domain_uuid = '$domain_uuid' "; //$sql .= "and enabled = 'true' "; if (!(if_group("admin") || if_group("superadmin"))) { if (!empty($_SESSION['user']['extension'])) { $sql .= "and ("; $x = 0; foreach($_SESSION['user']['extension'] as $row) { if ($x > 0) { $sql .= "or "; } $sql .= "e.extension = '".$row['user']."' "; $x++; } $sql .= ")"; } else { //hide any results when a user has not been assigned an extension $sql .= "and extension = 'disabled' "; } } $parameters['domain_uuid'] = $domain_uuid; $result = $database->select($sql, $parameters ?? null, 'all'); unset($sql, $parameters); $x = 0; foreach ($result as &$row) { if (strlen($row["user_status"]) > 0) { $user_array[$row["extension"]]['username'] = $row["username"]; $user_array[$row["extension"]]['user_status'] = $row["user_status"]; $username_array[$row["username"]]['user_status'] = $row["user_status"]; if ($row["username"] == $_SESSION["username"]) { $user_status = $row["user_status"]; } } $x++; } unset ($x); //create the event socket connection $fp = event_socket_create($_SESSION['event_socket_ip_address'], $_SESSION['event_socket_port'], $_SESSION['event_socket_password']); //get information over event socket if (!$fp) { $msg = "

".$text['confirm-socket']."

"; echo "

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

".$text['label-message']."
$msg

\n"; echo "

\n"; } else { //get the agent list from event socket $switch_cmd = 'callcenter_config agent list'; $event_socket_str = trim(event_socket_request($fp, 'api '.$switch_cmd)); $agent_array = csv_to_named_array($event_socket_str, '|'); //set the status on the user_array by using the extension as the key foreach ($agent_array as $row) { if (count($_SESSION['domains']) == 1) { //get the extension status from the call center agent list preg_match('/user\/(\d{2,7})/', $row['contact'], $matches); $extension = $matches[1]; $user_array[$extension]['username'] = $tmp[0]; if ($user_array[$extension]['user_status'] != "Do Not Disturb") { $user_array[$extension]['user_status'] = $row['status']; } } else { $tmp = explode('@',$row["name"]); if ($tmp[1] == $_SESSION['domain_name']) { //get the extension status from the call center agent list preg_match('/user\/(\d{2,7})/', $row['contact'], $matches); $extension = $matches[1]; $user_array[$extension]['username'] = $tmp[0]; if ($user_array[$extension]['user_status'] != "Do Not Disturb") { $user_array[$extension]['user_status'] = $row['status']; } } } } //send the api command over event socket //$switch_cmd = 'valet_info'; //$valet_xml_str = trim(event_socket_request($fp, 'api '.$switch_cmd)); //parse the xml //try { // $valet_xml = new SimpleXMLElement($valet_xml_str); //} //catch(Exception $e) { // //echo $e->getMessage(); //} //$valet_xml = new SimpleXMLElement($valet_xml_str); //foreach ($valet_xml as $row) { // $valet_name = (string) $row->attributes()->name; // foreach ($row->extension as $row2) { // $extension = (string) $row2; // $uuid = (string) $row2->attributes()->uuid; // $uuid = trim($uuid); // $valet_array[$uuid]['name'] = $valet_name; // $valet_array[$uuid]['extension'] = $extension; // } //} //send the event socket command $switch_cmd = 'show channels as xml'; $xml_str = trim(event_socket_request($fp, 'api '.$switch_cmd)); //parse the xml try { $xml = new SimpleXMLElement($xml_str); } catch(Exception $e) { //echo $e->getMessage(); } //active channels array $x = 1; foreach ($xml as $row) { //set the original array id $channels_array[$x]['x'] = $x; //get the values from xml and set them to the channel array $channels_array[$x]['uuid'] = $row->uuid; $channels_array[$x]['direction'] = $row->direction; $channels_array[$x]['created'] = $row->created; $channels_array[$x]['created_epoch'] = $row->created_epoch; $channels_array[$x]['name'] = $row->name; $channels_array[$x]['state'] = $row->state; $channels_array[$x]['cid_name'] = $row->cid_name; $channels_array[$x]['cid_num'] = $row->cid_num; $channels_array[$x]['ip_addr'] = $row->ip_addr; $channels_array[$x]['dest'] = $row->dest; $channels_array[$x]['application'] = $row->application; $channels_array[$x]['application_data'] = $row->application_data; $channels_array[$x]['dialplan'] = $row->dialplan; $channels_array[$x]['context'] = $row->context; $channels_array[$x]['read_codec'] = $row->read_codec; $channels_array[$x]['read_rate'] = $row->read_rate; $channels_array[$x]['read_bit_rate'] = $row->read_bit_rate; $channels_array[$x]['write_codec'] = $row->write_codec; $channels_array[$x]['write_rate'] = $row->write_rate; $channels_array[$x]['write_bit_rate'] = $row->write_bit_rate; $channels_array[$x]['secure'] = $row->secure; $channels_array[$x]['hostname'] = $row->hostname; $channels_array[$x]['presence_id'] = $row->presence_id; $channels_array[$x]['presence_data'] = $row->presence_data; $channels_array[$x]['callstate'] = $row->callstate; $channels_array[$x]['callee_name'] = $row->callee_name; $channels_array[$x]['callee_num'] = $row->callee_num; $channels_array[$x]['callee_direction'] = $row->callee_direction; $channels_array[$x]['call_uuid'] = $row->call_uuid; //remove other domains if (count($_SESSION["domains"]) > 1) { //unset domains that are not related to this tenant $temp_array = explode("@", $channels_array[$x]['presence_id']); if ($temp_array[1] != $_SESSION['domain_name']) { unset($channels_array[$x]); } } //parse some of the php variables\ $temp_array = explode("@", $channels_array[$x]['presence_id']); $channels_array[$x]['number'] = $temp_array[0]; //remove the '+' because it breaks the call recording $channels_array[$x]['cid_num'] = $temp_array[0] = str_replace("+", "", $channels_array[$x]['cid_num']); //calculate and set the call length $call_length_seconds = time() - $channels_array[$x]['created_epoch']; $call_length_hour = floor($call_length_seconds/3600); $call_length_min = floor($call_length_seconds/60 - ($call_length_hour * 60)); $call_length_sec = $call_length_seconds - (($call_length_hour * 3600) + ($call_length_min * 60)); $call_length_min = sprintf("%02d", $call_length_min); $call_length_sec = sprintf("%02d", $call_length_sec); $call_length = $call_length_hour.':'.$call_length_min.':'.$call_length_sec; $channels_array[$x]['call_length'] = $call_length; //valet park //if (is_array($valet_array[$uuid])) { // $valet_array[$uuid]['context'] = $channels_array[$x]['context']; // $valet_array[$uuid]['cid_name'] = $channels_array[$x]['cid_name']; // $valet_array[$uuid]['cid_num'] = $channels_array[$x]['cid_num']; // $valet_array[$uuid]['call_length'] = $call_length; //} //increment the array index $x++; } //active extensions //get the extension information if (!empty($debug)) { unset($_SESSION['extension_array']); } if (empty($_SESSION['extension_array'])) { $sql = "select * from v_extensions "; $x = 0; $range_array = $_GET['range']; foreach($range_array as $tmp_range) { $tmp_range = str_replace(":", "-", $tmp_range); $tmp_array = explode("-", $tmp_range); $tmp_min = $tmp_array[0]; $tmp_max = $tmp_array[1]; if ($x == 0) { $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and extension >= $tmp_min "; $sql .= "and extension <= $tmp_max "; $sql .= "and enabled = 'true' "; } else { $sql .= "or domain_uuid = :domain_uuid "; $sql .= "and extension >= $tmp_min "; $sql .= "and extension <= $tmp_max "; $sql .= "and enabled = 'true' "; } $x++; } if (empty($range_array)) { $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and enabled = 'true' "; } $sql .= "order by extension asc "; $parameters['domain_uuid'] = $domain_uuid; $result = $database->select($sql, $parameters ?? null, 'all'); unset($sql, $parameters); foreach ($result as &$row) { if ($row["enabled"] == "true") { $extension = $row["extension"]; $extension_array[$extension]['domain_uuid'] = $row["domain_uuid"]; $extension_array[$extension]['extension'] = $row["extension"]; //$extension_array[$extension]['password'] = $row["password"]; $extension_array[$extension]['mailbox'] = $row["mailbox"]; //$vm_password = $row["vm_password"]; //$vm_password = str_replace("#", "", $vm_password); //preserves leading zeros //$_SESSION['extension_array'][$extension]['vm_password'] = $vm_password; $extension_array[$extension]['accountcode'] = $row["accountcode"]; $extension_array[$extension]['effective_caller_id_name'] = $row["effective_caller_id_name"]; $extension_array[$extension]['effective_caller_id_number'] = $row["effective_caller_id_number"]; $extension_array[$extension]['outbound_caller_id_name'] = $row["outbound_caller_id_name"]; $extension_array[$extension]['outbound_caller_id_number'] = $row["outbound_caller_id_number"]; $extension_array[$extension]['vm_enabled'] = $row["vm_enabled"]; $extension_array[$extension]['vm_mailto'] = $row["vm_mailto"]; $extension_array[$extension]['vm_attach_file'] = $row["vm_attach_file"]; $extension_array[$extension]['vm_keep_local_after_email'] = $row["vm_keep_local_after_email"]; $extension_array[$extension]['user_context'] = $row["user_context"]; $extension_array[$extension]['call_group'] = $row["call_group"]; $extension_array[$extension]['auth_acl'] = $row["auth_acl"]; $extension_array[$extension]['cidr'] = $row["cidr"]; $extension_array[$extension]['sip_force_contact'] = $row["sip_force_contact"]; //$extension_array[$extension]['enabled'] = $row["enabled"]; $extension_array[$extension]['effective_caller_id_name'] = $row["effective_caller_id_name"]; } } $_SESSION['extension_array'] = $extension_array; } //get a list of assigned extensions for this user //include "active_extension_assigned_inc.php"; //list all extensions if (permission_exists('active_extension_view')) { echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; if ($_SESSION['user_status_display'] == "false") { //hide the user_status when it is set to false } else { echo "\n"; } echo "\n"; if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } echo "\n"; if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { echo "\n"; } } echo "\n"; $x = 1; foreach ($_SESSION['extension_array'] as $row) { $domain_uuid = $row['domain_uuid']; $extension = $row['extension']; $enabled = $row['enabled']; $effective_caller_id_name = $row['effective_caller_id_name']; $found_extension = false; foreach ($channels_array as $row) { //set the php variables foreach ($row as $key => $value) { $$key = $value; } //check to see if the extension is found in the channel array if ($number == $extension) { $found_extension = true; break; } } if ($found_extension) { if ($application == "conference") { $alt_color = "background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_active.gif"; } switch ($application) { case "conference": $style_alternate = "style=\"color: #444444; background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_conference.gif');\""; break; case "fifo": $style_alternate = "style=\"color: #444444; background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_fifo.gif');\""; break; case "valet_park": $style_alternate = "style=\"color: #444444; background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_fifo.gif');\""; break; default: $style_alternate = "style=\"color: #444444; background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_active.gif');\""; } echo "\n"; echo "\n"; if ($_SESSION['user_status_display'] == "false") { //hide the user_status when it is set to false } else { echo "\n"; } echo "\n"; if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { if (strlen($url) == 0) { $url = PROJECT_PATH."/core/contacts/contacts.php?search_all={cid_num}"; } $url = str_replace ("{cid_num}", escape($cid_num), $url); $url = str_replace ("{cid_name}", escape($cid_name), $url); echo "\n"; echo "\n"; } } if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { echo "\n"; echo "\n"; echo "\n"; } } } else { $style_alternate = "style=\"color: #444444; background-image: url('".PROJECT_PATH."/themes/".$_SESSION['domain']['template']['name']."/images/background_cell_light.gif');\""; echo "\n"; echo "\n"; if ($_SESSION['user_status_display'] == "false") { //hide the user_status when it is set to false } else { echo "\n"; } echo "\n"; if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } } echo "\n"; if (if_group("admin") || if_group("superadmin")) { if (strlen(($_GET['rows'])) == 0) { if ($found_extension) { echo "\n"; } else { echo "\n"; } } } echo "\n"; if ($y == $_GET['rows'] && !empty($_GET['rows'])) { $y = 0; echo "

".$text['label-extension']."	".$text['label-status']."	".$text['label-time']."	".$text['label-cid-name']."	".$text['label-cid-number']."	".$text['label-destination']."	".$text['label-app']."	".$text['label-secure']."	".$text['label-name']."	".$text['label-opt']."
".escape($extension)."	".escape($user_array[$extension]['user_status'])."	".$call_length."	".escape($cid_name)."	".escape($cid_num)."	\n"; echo "".escape($dest)." \n"; echo "	\n"; if ($application == "fifo") { echo "queue \n"; } else { echo escape($application)." \n"; } echo "	\n"; echo escape($secure)." \n"; echo "
".escape($extension)."	".escape($user_array[$extension]['user_status'])."							\n"; echo " ".escape($effective_caller_id_name)." \n"; echo "	\n"; //transfer echo " ".$text['label-transfer']." \n"; //park echo " ".$text['label-park']." \n"; //hangup echo " ".$text['label-hangup']." \n"; //record start/stop $tmp_file = $_SESSION['switch']['recordings']['dir']."/archive/".date("Y")."/".date("M")."/".date("d")."/".$uuid.".wav"; if (file_exists($tmp_file)) { //stop echo " ".$text['label-stop']." \n"; } else { //start echo " ".$text['label-start']." \n"; } echo " "; echo "	\n"; echo " "; echo "

\n"; echo "

".$text['label-ext']."	".$text['label-status']."	".$text['label-time']."	".$text['label-cid-name']."	".$text['label-cid-number']."	".$text['label-destination']."	".$text['label-app']."	".$text['label-secure']."	".$text['label-name']."	".$text['label-opt']."

\n"; echo "

\n"; //valet park //echo "\n"; //echo "\n"; //echo "\n"; //echo "\n"; //echo "\n"; //echo "\n"; //echo "\n"; //foreach ($valet_array as $row) { // if (strlen($row['extension']) > 0) { // if ($row['context'] == $_SESSION['domain_name'] || $row['context'] == "default") { // echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // } // } //} //echo "

".$text['label-park-ext']."	".$text['label-time']."	".$text['label-cid-name']."	".$text['label-cid-number']."
*".escape($row['extension'])."	".escape($row['call_length'])."	".escape($row['cid_name'])."	".escape($row['cid_num'])."

\n"; } //end permission echo "

\n"; if ($user_status == "Available (On Demand)") { $user_status = "Available_On_Demand"; } $user_status = str_replace(" ", "_", $user_status); echo "".escape($user_status)."\n"; echo "

\n"; echo "

\n"; } ?>