Portions created by the Initial Developer are Copyright (C) 2008-2019 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane Luis Daniel Lucio Quiroz Original version of Call Block was written by Gerrit Visser */ //includes require_once "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (!permission_exists('call_block_edit') && !permission_exists('call_block_add')) { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); //action add or update if (is_uuid($_REQUEST["id"])) { $action = "update"; $call_block_uuid = $_REQUEST["id"]; } else { $action = "add"; } //get http post variables and set them to php variables if (count($_POST) > 0) { $call_block_direction = $_POST["call_block_direction"]; $extension_uuid = $_POST["extension_uuid"]; $call_block_name = $_POST["call_block_name"]; $call_block_country_code = $_POST["call_block_country_code"]; $call_block_number = $_POST["call_block_number"]; $call_block_enabled = $_POST["call_block_enabled"]; $call_block_description = $_POST["call_block_description"]; $action_array = explode(':', $_POST["call_block_action"]); $call_block_app = $action_array[0]; $call_block_data = $action_array[1]; } //handle the http post if (count($_POST) > 0 && strlen($_POST["persistformvar"]) == 0) { //handle action if ($_POST['action'] != '') { switch ($_POST['action']) { case 'delete': if (permission_exists('call_block_delete') && is_uuid($call_block_uuid)) { //prepare $array[0]['checked'] = 'true'; $array[0]['uuid'] = $call_block_uuid; //delete $obj = new call_block; $obj->delete($array); } break; case 'add': $xml_cdrs = $_POST['xml_cdrs']; if (permission_exists('call_block_add') && is_array($xml_cdrs) && @sizeof($xml_cdrs) != 0) { $obj = new call_block; $obj->call_block_direction = $call_block_direction; $obj->extension_uuid = $extension_uuid; $obj->call_block_app = $call_block_app; $obj->call_block_data = $call_block_data; $obj->add($xml_cdrs); } break; } header('Location: call_block.php'); exit; } //validate the token $token = new token; if (!$token->validate($_SERVER['PHP_SELF'])) { message::add($text['message-invalid_token'],'negative'); header('Location: call_block.php'); exit; } //check for all required data $msg = ''; //if (strlen($call_block_name) == 0) { $msg .= $text['label-provide-name']."
\n"; } //if (strlen($call_block_number) == 0) { $msg .= $text['label-provide-number']."
\n"; } if (strlen($call_block_enabled) == 0) { $msg .= $text['label-provide-enabled']."
\n"; } if (strlen($msg) > 0 && strlen($_POST["persistformvar"]) == 0) { require_once "resources/header.php"; require_once "resources/persist_form_var.php"; echo "

\n"; echo "

\n"; echo $msg."
"; echo "

\n"; persistformvar($_POST); echo "

\n"; require_once "resources/footer.php"; return; } //add or update the database if (is_array($_POST) && sizeof($_POST) != 0 && $_POST["persistformvar"] != "true") { //ensure call block is enabled in the dialplan if ($action == "add" || $action == "update") { $sql = "select dialplan_uuid from v_dialplans where true "; $sql .= "and domain_uuid = :domain_uuid "; $sql .= "and app_uuid = 'b1b31930-d0ee-4395-a891-04df94599f1f' "; $sql .= "and dialplan_enabled <> 'true' "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $rows = $database->select($sql, $parameters); if (is_array($rows) && sizeof($rows) != 0) { foreach ($rows as $index => $row) { $array['dialplans'][$index]['dialplan_uuid'] = $row['dialplan_uuid']; $array['dialplans'][$index]['dialplan_enabled'] = 'true'; } $p = new permissions; $p->add('dialplan_edit', 'temp'); $database = new database; $database->save($array); unset($array); $p->delete('dialplan_edit', 'temp'); } } //if user doesn't have call block all then use the assigned extension_uuid if (!permission_exists('call_block_all')) { $extension_uuid = $_SESSION['user']['extension'][0]['extension_uuid']; } //save the data to the database if ($action == "add") { $array['call_block'][0]['call_block_uuid'] = uuid(); $array['call_block'][0]['domain_uuid'] = $_SESSION['domain_uuid']; $array['call_block'][0]['call_block_direction'] = $call_block_direction; if (is_uuid($extension_uuid)) { $array['call_block'][0]['extension_uuid'] = $extension_uuid; } $array['call_block'][0]['call_block_name'] = $call_block_name; $array['call_block'][0]['call_block_country_code'] = $call_block_country_code; $array['call_block'][0]['call_block_number'] = $call_block_number; $array['call_block'][0]['call_block_count'] = 0; $array['call_block'][0]['call_block_app'] = $call_block_app; $array['call_block'][0]['call_block_data'] = $call_block_data; $array['call_block'][0]['call_block_enabled'] = $call_block_enabled; $array['call_block'][0]['date_added'] = time(); $array['call_block'][0]['call_block_description'] = $call_block_description; $database = new database; $database->app_name = 'call_block'; $database->app_uuid = '9ed63276-e085-4897-839c-4f2e36d92d6c'; $database->save($array); $response = $database->message; unset($array); message::add($text['label-add-complete']); header("Location: call_block.php"); return; } if ($action == "update") { $sql = "select c.call_block_country_code, c.call_block_number, d.domain_name "; $sql .= "from v_call_block as c "; $sql .= "join v_domains as d on c.domain_uuid = d.domain_uuid "; $sql .= "where c.domain_uuid = :domain_uuid "; $sql .= "and c.call_block_uuid = :call_block_uuid "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $parameters['call_block_uuid'] = $call_block_uuid; $database = new database; $result = $database->select($sql, $parameters); if (is_array($result) && sizeof($result) != 0) { //set the domain_name $domain_name = $result[0]["domain_name"]; //clear the cache $cache = new cache; $cache->delete("app:call_block:".$domain_name.":".$call_block_country_code.$call_block_number); } unset($sql, $parameters); $array['call_block'][0]['call_block_uuid'] = $call_block_uuid; $array['call_block'][0]['domain_uuid'] = $_SESSION['domain_uuid']; $array['call_block'][0]['call_block_direction'] = $call_block_direction; if (is_uuid($extension_uuid)) { $array['call_block'][0]['extension_uuid'] = $extension_uuid; } $array['call_block'][0]['call_block_name'] = $call_block_name; $array['call_block'][0]['call_block_country_code'] = $call_block_country_code; $array['call_block'][0]['call_block_number'] = $call_block_number; $array['call_block'][0]['call_block_app'] = $call_block_app; $array['call_block'][0]['call_block_data'] = $call_block_data; $array['call_block'][0]['call_block_enabled'] = $call_block_enabled; $array['call_block'][0]['date_added'] = time(); $array['call_block'][0]['call_block_description'] = $call_block_description; $database = new database; $database->app_name = 'call_block'; $database->app_uuid = '9ed63276-e085-4897-839c-4f2e36d92d6c'; $database->save($array); $response = $database->message; unset($array); message::add($text['label-update-complete']); header("Location: call_block.php"); return; } } } //pre-populate the form if (count($_GET) > 0 && $_POST["persistformvar"] != "true") { $call_block_uuid = $_GET["id"]; $sql = "select * from v_call_block "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and call_block_uuid = :call_block_uuid "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $parameters['call_block_uuid'] = $call_block_uuid; $database = new database; $row = $database->select($sql, $parameters, 'row'); if (is_array($row) && sizeof($row) != 0) { $call_block_direction = $row["call_block_direction"]; $extension_uuid = $row["extension_uuid"]; $call_block_name = $row["call_block_name"]; $call_block_country_code = $row["call_block_country_code"]; $call_block_number = $row["call_block_number"]; $call_block_app = $row["call_block_app"]; $call_block_data = $row["call_block_data"]; $call_block_enabled = $row["call_block_enabled"]; $call_block_description = $row["call_block_description"]; } unset($sql, $parameters, $row); } //get the extensions if (permission_exists('call_block_all') || permission_exists('call_block_extension')) { $sql = "select extension_uuid, extension, number_alias, user_context, description from v_extensions "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and enabled = 'true' "; $sql .= "order by extension asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $extensions = $database->select($sql, $parameters); } //get the ivr's if (permission_exists('call_block_all') || permission_exists('call_block_ivr')) { $sql = "select ivr_menu_uuid,ivr_menu_name, ivr_menu_extension, ivr_menu_description from v_ivr_menus "; $sql .= "where domain_uuid = :domain_uuid "; // $sql .= "and enabled = 'true' "; $sql .= "order by ivr_menu_extension asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $ivrs = $database->select($sql, $parameters); } //get the ring groups if (permission_exists('call_block_all') || permission_exists('call_block_ring_group')) { $sql = "select ring_group_uuid,ring_group_name, ring_group_extension, ring_group_description from v_ring_groups "; $sql .= "where domain_uuid = :domain_uuid "; // $sql .= "and ring_group_enabled = 'true' "; $sql .= "order by ring_group_extension asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $ring_groups = $database->select($sql, $parameters); } //get the voicemails $sql = "select voicemail_uuid, voicemail_id, voicemail_description "; $sql .= "from v_voicemails "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and voicemail_enabled = 'true' "; $sql .= "order by voicemail_id asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $voicemails = $database->select($sql, $parameters); //create token $object = new token; $token = $object->create($_SERVER['PHP_SELF']); //show the header $document['title'] = $text['title-call-block']; require_once "resources/header.php"; //show the content echo "

\n"; echo "

"; if ($action == "add") { echo "".$text['label-edit-add']."\n"; } if ($action == "update") { echo "".$text['label-edit-edit']."\n"; } echo "

\n"; echo "

\n"; echo button::create(['type'=>'button','label'=>$text['button-back'],'icon'=>$_SESSION['theme']['button_icon_back'],'id'=>'btn_back','collapse'=>'hide-xs','style'=>'margin-right: 15px;','link'=>'call_block.php']); if ($action == 'update' && permission_exists('call_block_delete')) { echo button::create(['type'=>'button','label'=>$text['button-delete'],'icon'=>$_SESSION['theme']['button_icon_delete'],'name'=>'btn_delete','collapse'=>'hide-xs','style'=>'margin-right: 15px;','onclick'=>"modal_open('modal-delete','btn_delete');"]); } echo button::create(['type'=>'submit','label'=>$text['button-save'],'icon'=>$_SESSION['theme']['button_icon_save'],'id'=>'btn_save','collapse'=>'hide-xs']); echo "

\n"; echo "

\n"; if ($action == 'update' && permission_exists('call_block_delete')) { echo modal::create(['id'=>'modal-delete','type'=>'delete','actions'=>button::create(['type'=>'submit','label'=>$text['button-continue'],'icon'=>'check','id'=>'btn_delete','style'=>'float: right; margin-left: 15px;','collapse'=>'never','name'=>'action','value'=>'delete','onclick'=>"modal_close();"])]); } if ($action == "add") { echo $text['label-add-note']."\n"; } if ($action == "update") { echo $text['label-edit-note']."\n"; } echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (permission_exists('call_block_all')) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo " ".$text['label-direction']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo $text['description-direction']."\n"; echo "\n"; echo "
\n"; echo " ".$text['label-extension']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo $text['description-extension']."\n"; echo "\n"; echo "
\n"; echo " ".$text['label-name']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo $text['description-call_block_name']."\n"; echo "
\n"; echo " ".$text['label-number']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo " \n"; echo $text['description-call_block_number']."\n"; echo " \n"; echo "
\n"; echo " ".$text['label-action']."\n"; echo "	\n"; function call_block_action_select($label = false) { global $select_margin, $text, $call_block_app, $call_block_data, $extensions, $ivrs, $voicemails, $ring_groups; echo ""; } call_block_action_select(); echo " \n"; echo $text['description-action']."\n"; echo "\n"; echo "
\n"; echo " ".$text['label-enabled']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo $text['description-enable']."\n"; echo "\n"; echo "
\n"; echo " ".$text['label-description']."\n"; echo "	\n"; echo " \n"; echo " \n"; echo $text['description-description']."\n"; echo "

"; echo "

"; if ($action == "update") { echo "\n"; } echo "\n"; echo "

"; //get recent calls from the db (if not editing an existing call block record) if (!is_uuid($_REQUEST["id"])) { //without block all permission, limit to assigned extension(s) if (!permission_exists('call_block_all') && is_array($_SESSION['user']['extension'])) { foreach ($_SESSION['user']['extension'] as $assigned_extension) { $assigned_extensions[$assigned_extension['extension_uuid']] = $assigned_extension['user']; } if (is_array($assigned_extensions) && sizeof($assigned_extensions) != 0) { $x = 0; foreach ($assigned_extensions as $assigned_extension_uuid => $assigned_extension) { $sql_where_array[] = "extension_uuid = :extension_uuid_".$x; $parameters['extension_uuid_'.$x] = $assigned_extension_uuid; $x++; } if (is_array($sql_where_array) && sizeof($sql_where_array) != 0) { $sql_where .= "and (".implode(' or ', $sql_where_array).") "; } unset($sql_where_array); } } //get recent calls $sql = "select caller_id_name, caller_id_number, caller_destination, start_epoch, direction, hangup_cause, duration, billsec, xml_cdr_uuid "; $sql .= "from v_xml_cdr where domain_uuid = :domain_uuid "; $sql .= "and direction <> 'local' "; $sql .= $sql_where; $sql .= "order by start_stamp desc "; $sql .= limit_offset($_SESSION['call_block']['recent_call_limit']['text']); $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $database = new database; $result = $database->select($sql, $parameters); unset($sql, $parameters); echo "

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

\n"; echo "

"; echo " ".$text['heading-recent_calls'].""; echo " \n"; echo "

\n"; echo "

\n"; echo button::create(['type'=>'button','id'=>'action_bar_sub_button_back','label'=>$text['button-back'],'icon'=>$_SESSION['theme']['button_icon_back'],'collapse'=>'hide-xs','style'=>'display: none;','link'=>'call_block.php']); if ($result) { $select_margin = 'margin-left: 15px;'; if (permission_exists('call_block_all')) { echo ""; unset($select_margin); } call_block_action_select(true); echo button::create(['type'=>'button','label'=>$text['button-block'],'icon'=>'ban','collapse'=>'hide-xs','onclick'=>"modal_open('modal-block','btn_block');"]); } echo "

\n"; echo "

\n"; if ($result) { echo modal::create(['id'=>'modal-block','type'=>'general','message'=>$text['confirm-block'],'actions'=>button::create(['type'=>'button','label'=>$text['button-continue'],'icon'=>'check','id'=>'btn_block','style'=>'float: right; margin-left: 15px;','collapse'=>'never','onclick'=>"modal_close(); list_form_submit('form_list');"])]); } foreach (['inbound','outbound'] as $direction) { echo "\n"; echo "\n"; echo " \n"; echo "\n"; echo th_order_by('caller_id_name', $text['label-name'], $order_by, $order); echo th_order_by('caller_id_number', $text['label-number'], $order_by, $order); echo th_order_by('caller_id_number', $text['label-destination'], $order_by, $order); echo th_order_by('start_stamp', $text['label-called'], $order_by, $order); echo th_order_by('duration', $text['label-duration'], $order_by, $order, null, "class='right hide-sm-dn'"); echo ""; if (is_array($result) && @sizeof($result) != 0) { foreach ($result as $x => $row) { if ($row['direction'] == $direction) { $list_row_onclick_uncheck = "if (!this.checked) { document.getElementById('checkbox_all_".$direction."').checked = false; }"; $list_row_onclick_toggle = "onclick=\"document.getElementById('checkbox_".$x."').checked = document.getElementById('checkbox_".$x."').checked ? false : true; ".$list_row_onclick_uncheck."\""; if (strlen($row['caller_id_number']) >= 7) { if ($_SESSION['domain']['time_format']['text'] == '24h') { $tmp_start_epoch = date('j M Y', $row['start_epoch'])." ".date('H:i:s', $row['start_epoch']).''; } else { $tmp_start_epoch = date('j M Y', $row['start_epoch'])." ".date('h:i:s a', $row['start_epoch']).''; } echo "\n"; echo " \n"; if ( file_exists($_SERVER["DOCUMENT_ROOT"]."/themes/".$_SESSION['domain']['template']['name']."/images/icon_cdr_inbound_voicemail.png") && file_exists($_SERVER["DOCUMENT_ROOT"]."/themes/".$_SESSION['domain']['template']['name']."/images/icon_cdr_inbound_answered.png") && file_exists($_SERVER["DOCUMENT_ROOT"]."/themes/".$_SESSION['domain']['template']['name']."/images/icon_cdr_outbound_failed.png") && file_exists($_SERVER["DOCUMENT_ROOT"]."/themes/".$_SESSION['domain']['template']['name']."/images/icon_cdr_outbound_answered.png") ) { echo " \n"; } else { echo " "; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; $seconds = ($row['hangup_cause'] == "ORIGINATOR_CANCEL") ? $row['duration'] : $row['billsec']; //if they cancelled, show the ring time, not the bill time. echo " \n"; echo "\n"; } } } } echo "

\n"; echo " \n"; echo "
\n"; echo " \n"; echo " \n"; echo "	"; switch ($row['direction']) { case "inbound": if ($row['billsec'] == 0) { $title_mod = " ".$text['label-missed']; $file_mod = "_voicemail"; } else { $file_mod = "_answered"; } echo "\n"; break; case "outbound": if ($row['billsec'] == 0) { $title_mod = " ".$text['label-failed']; $file_mod = "_failed"; } else { $file_mod = "_answered"; } echo "\n"; break; } echo "		".$row['caller_id_name']."	".format_phone($row['caller_id_number'])."	".format_phone($row['caller_destination'])."	".$tmp_start_epoch."	".gmdate("G:i:s", $seconds)."

\n"; } unset($result); echo "
\n"; echo "\n"; echo "

\n"; //handle hiding and showing of direction recent calls echo "\n"; } //make sub action bar sticky echo "\n"; //include the footer require_once "resources/footer.php"; ?>