function Request($security_key, $called, $calling, $callerid, $callback_time, $uniqueid) { global $A2B; /* $status = 'PENDING'; $server_ip = 'localhost'; $num_attempt = 0; $channel = 'SIP/'.$phone_number.'@mylittleIP'; $exten = $phone_number; $context = 'a2billing'; $priority = 1; //$timeout callerid $variable = "phonenumber=$phone_number|callerid=$callerid"; */ $phone_number = $called; $insert_id_callback = 'null'; if (strlen($uniqueid) == 0) { $uniqueid = MDP_STRING(5) . '-' . MDP_NUMERIC(10); } $FG_regular[] = array("^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})\$", "(YYYY-MM-DD HH:MM:SS)"); // The wrapper variables for security // $security_key = API_SECURITY_KEY; write_log(LOG_CALLBACK, " Service_Callback( security_key={$security_key}, called={$called}, calling={$calling}, callerid={$callerid}, uniqueid={$uniqueid}, callback_time={$callback_time})"); $mysecurity_key = API_SECURITY_KEY; // CHECK CALLERID if (strlen($callerid) < 1) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT CALLERID AT LEAST 1 DIGIT "); sleep(2); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT CALLERID AT LEAST 1 DIGIT "); } // CHECK PHONE_NUMBER if (strlen($phone_number) < 10) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT PHONENUMBER AT LEAST 10 DIGITS "); sleep(2); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT PHONENUMBER AT LEAST 10 DIGITS "); } // CHECK CALLBACK TIME if (strlen($callback_time) > 1 && !ereg($FG_regular[0][0], $callback_time)) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT CALLBACKTIME : " . $FG_regular[0][0]); sleep(2); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT CALLBACKTIME : " . $FG_regular[0][0]); } // CHECK SECURITY KEY if (md5($mysecurity_key) !== $security_key || strlen($security_key) == 0) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " CODE_ERROR SECURITY_KEY"); sleep(2); return array($insert_id_callback, 'result=Error', ' KEY - BAD PARAMETER '); } $DBHandle = DbConnect(); if (!$DBHandle) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR CONNECT DB"); sleep(2); return array($insert_id_callback, 'result=Error', ' ERROR - CONNECT DB '); } $A2B->DBHandle = $DBHandle; $instance_table = new Table(); $A2B->set_instance_table($instance_table); $called = ereg_replace("^\\+", "011", $called); $calling = ereg_replace("^\\+", "011", $calling); $called = ereg_replace("[^0-9]", "", $called); $calling = ereg_replace("[^0-9]", "", $calling); $called = ereg_replace("^01100", "011", $called); $calling = ereg_replace("^01100", "011", $calling); $called = ereg_replace("^00", "011", $called); $calling = ereg_replace("^00", "011", $calling); $called = ereg_replace("^0111", "1", $called); $calling = ereg_replace("^0111", "1", $calling); $A2B->credit = 1000; $A2B->tariff = $A2B->config["callback"]['all_callback_tariff']; $RateEngine = new RateEngine(); // $RateEngine -> webui = 0; // LOOKUP RATE : FIND A RATE FOR THIS DESTINATION $A2B->dnid = $A2B->destination = $caller_areacode . $calling; $resfindrate = $RateEngine->rate_engine_findrates($A2B, $A2B->destination, $A2B->tariff); // IF FIND RATE if ($resfindrate != 0) { //$RateEngine -> debug_st = 1; $res_all_calcultimeout = $RateEngine->rate_engine_all_calcultimeout($A2B, $A2B->credit); if ($res_all_calcultimeout) { // MAKE THE CALL if ($RateEngine->ratecard_obj[0][34] != '-1') { $usetrunk = 34; $usetrunk_failover = 1; $RateEngine->usedtrunk = $RateEngine->ratecard_obj[$k][34]; } else { $usetrunk = 29; $RateEngine->usedtrunk = $RateEngine->ratecard_obj[$k][29]; $usetrunk_failover = 0; } $prefix = $RateEngine->ratecard_obj[0][$usetrunk + 1]; $tech = $RateEngine->ratecard_obj[0][$usetrunk + 2]; $ipaddress = $RateEngine->ratecard_obj[0][$usetrunk + 3]; $removeprefix = $RateEngine->ratecard_obj[0][$usetrunk + 4]; $timeout = $RateEngine->ratecard_obj[0]['timeout']; $failover_trunk = $RateEngine->ratecard_obj[0][40 + $usetrunk_failover]; $addparameter = $RateEngine->ratecard_obj[0][42 + $usetrunk_failover]; $destination = $A2B->destination; if (strncmp($destination, $removeprefix, strlen($removeprefix)) == 0) { $destination = substr($destination, strlen($removeprefix)); } $pos_dialingnumber = strpos($ipaddress, '%dialingnumber%'); $ipaddress = str_replace("%cardnumber%", $A2B->cardnumber, $ipaddress); $ipaddress = str_replace("%dialingnumber%", $prefix . $destination, $ipaddress); if ($pos_dialingnumber !== false) { $dialstr = "{$tech}/{$ipaddress}" . $dialparams; } else { if ($A2B->agiconfig['switchdialcommand'] == 1) { $dialstr = "{$tech}/{$prefix}{$destination}@{$ipaddress}" . $dialparams; } else { $dialstr = "{$tech}/{$ipaddress}/{$prefix}{$destination}" . $dialparams; } } //ADDITIONAL PARAMETER %dialingnumber%, %cardnumber% if (strlen($addparameter) > 0) { $addparameter = str_replace("%cardnumber%", $A2B->cardnumber, $addparameter); $addparameter = str_replace("%dialingnumber%", $prefix . $destination, $addparameter); $dialstr .= $addparameter; } $channel = $dialstr; $exten = $calling; $context = $A2B->config["callback"]['context_callback']; $id_server_group = $A2B->config["callback"]['id_server_group']; $priority = 1; $timeout = $A2B->config["callback"]['timeout'] * 1000; $application = ''; $status = 'PENDING'; $server_ip = 'localhost'; $num_attempt = 0; $variable = "MODE=CID|CALLED={$called}|CALLING={$calling}|CBID={$uniqueid}|TARIFF=" . $A2B->tariff; if (is_numeric($A2B->config["callback"]['sec_wait_before_callback']) && $A2B->config["callback"]['sec_wait_before_callback'] >= 1) { $sec_wait_before_callback = $A2B->config["callback"]['sec_wait_before_callback']; } else { $sec_wait_before_callback = 1; } // LIST FIELDS TO INSERT CALLBACK REQUEST $QUERY_FIELS = 'uniqueid, status, server_ip, num_attempt, channel, exten, context, priority, variable, id_server_group, callback_time, account, callerid, timeout'; // DEFINE THE CORRECT VALUE FOR THE INSERT if (strlen($callback_time) > 1) { $QUERY_VALUES = "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', '{$callback_time}', '{$account}', '{$callerid}', '30000'"; } else { if ($A2B->config["database"]['dbtype'] != "postgres") { // MYSQL $QUERY_VALUES = "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', ADDDATE( CURRENT_TIMESTAMP, INTERVAL {$sec_wait_before_callback} SECOND ), '{$account}', '{$callerid}', '30000'"; } else { // POSTGRESQL $QUERY_VALUES = "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', (CURRENT_TIMESTAMP + INTERVAL '{$sec_wait_before_callback} SECOND'), '{$account}', '{$callerid}', '30000'"; } } $insert_id_callback = $instance_table->Add_table($DBHandle, $QUERY_VALUES, $QUERY_FIELS, 'cc_callback_spool', 'id'); if (!$insert_id_callback) { // FAIL INSERT write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR INSERT -> \n QUERY=" . $QUERY); sleep(2); return array($insert_id_callback, 'result=Error', ' ERROR - INSERT INTO DB'); } // SUCCEED INSERT write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " CALLBACK INSERTED -> \n QUERY=" . $QUERY); return array($insert_id_callback, 'result=Success', " Success - Callback request has been accepted "); } else { $error_msg = 'Error : You don t have enough credit to call you back !!!'; } } else { $error_msg = 'Error : There is no route to call back your phonenumber !!!'; } // CALLBACK FAIL write_log(LOG_CALLBACK, "error_msg = {$error_msg}"); return array($insert_id_callback, 'result=Error', " ERROR - {$error_msg}"); }
Header("Location: " . $HD_Form->FG_GO_LINK_AFTER_ACTION); exit; } $form_action = "add"; $_POST['accountcode'] = $_POST['username'] = $_POST['name'] = $_POST['cardnumber'] = $cardnumber; $_POST['allow'] = FRIEND_ALLOW; $_POST['context'] = FRIEND_CONTEXT; $_POST['nat'] = FRIEND_NAT; $_POST['amaflags'] = FRIEND_AMAFLAGS; $_POST['regexten'] = $cardnumber; $_POST['id_cc_card'] = $id_cc_card; $_POST['callerid'] = $useralias; $_POST['qualify'] = FRIEND_QUALIFY; $_POST['host'] = FRIEND_HOST; $_POST['dtmfmode'] = FRIEND_DTMFMODE; $_POST['secret'] = MDP_NUMERIC(5) . MDP_STRING(10) . MDP_NUMERIC(5); // for the getProcessed var $HD_Form->_vars = array_merge((array) $_GET, (array) $_POST); } $HD_Form->FG_EDITION_LINK = filter_input(INPUT_SERVER, 'PHP_SELF', FILTER_SANITIZE_URL) . "?form_action=ask-edit&atmenu={$atmenu}&id="; $HD_Form->FG_DELETION_LINK = filter_input(INPUT_SERVER, 'PHP_SELF', FILTER_SANITIZE_URL) . "?form_action=ask-delete&atmenu={$atmenu}&id="; if ($id != "" || !is_null($id)) { $HD_Form->FG_EDITION_CLAUSE = str_replace("%id", "{$id}", $HD_Form->FG_EDITION_CLAUSE); } if (!isset($form_action)) { $form_action = "list"; } //ask-add if (!isset($action)) { $action = $form_action; }
if (isset($iax) && $iax == 1) { $iax_buddy = 1; } $creditlimit = is_numeric($creditlimit) ? $creditlimit : 0; //initialize refill parameter $description_refill = gettext("CREATION CARD REFILL"); $field_insert_refill = " credit,card_id, description"; $instance_refill_table = new Table("cc_logrefill", $field_insert_refill); for ($k = 0; $k < $nbcard; $k++) { $arr_card_alias = gen_card_with_alias("cc_card", 0, $cardnumberlenght_list); $accountnumber = $arr_card_alias[0]; $useralias = $arr_card_alias[1]; if (!is_numeric($addcredit)) { $addcredit = 0; } $passui_secret = MDP_NUMERIC(5) . MDP_STRING(10) . MDP_NUMERIC(5); $FG_ADITION_SECOND_ADD_VALUE = "'{$accountnumber}', '{$useralias}', '{$addcredit}', '{$choose_tariff}', 't', '{$gen_id}', '', '', '', '', '', '{$id_country}', '', '', {$choose_simultaccess}, '{$choose_currency}', " . "{$choose_typepaid}, {$creditlimit}, {$enableexpire}, '{$expirationdate}', {$expiredays}, '{$passui_secret}', '{$runservice}', '{$tag}', '{$id_group}', '{$discount}', '{$id_seria}', " . "'{$id_didgroup}', {$sip_buddy}, {$iax_buddy}, '{$vat}'"; if (DB_TYPE != "postgres") { $FG_ADITION_SECOND_ADD_VALUE .= ", now() "; } $id_cc_card = $instance_sub_table->Add_table($HD_Form->DBHandle, $FG_ADITION_SECOND_ADD_VALUE, null, null, $HD_Form->FG_TABLE_ID); //create refill for each cards if ($addcredit > 0) { $value_insert_refill = "'{$addcredit}', '{$id_cc_card}', '{$description_refill}' "; $instance_refill_table->Add_table($HD_Form->DBHandle, $value_insert_refill, null, null); } $instance_realtime->insert_voip_config($sip, $iax, $id_cc_card, $accountnumber, $passui_secret); } // Save Sip accounts to file if (isset($sip)) { $instance_realtime->create_trunk_config_file('sip');
function Create_Instance ($security_key, $instance_name) { if (!$this->Check_SecurityKey ($security_key)) { return array("ERROR", "INVALID KEY"); } if (!strlen($instance_name) > 0) { return array("ERROR", "NO INSTANCE_NAME PROVIDED"); } $this->instance_table = new Table(); $instance_key = $instance_name.'_'.MDP_STRING(4).'-'.MDP_NUMERIC(4); // Check that there is not an existing Group with this name $QUERY = "SELECT count(*) FROM cc_card_group WHERE name='$instance_key'"; $result = $this->instance_table -> SQLExec ($this->DBHandle, $QUERY); if (!is_array($result) || $result[0][0] > 0 ) { return array(false, "EXISTING GROUP WITH SAME NAME AND KEY"); } $value = "'$instance_key'"; $func_fields = "name"; $func_table = 'cc_card_group'; $id_name = "id"; $inserted = $this->instance_table->Add_table($this->DBHandle, $value, $func_fields, $func_table, $id_name); if (!$inserted) { return array(false, "ERROR CREATING ACCOUNT GROUP"); } return array($instance_key, "Create_Instance SUCCESS"); }
//default callerid $callerid = '111111111'; $cidgroupid = $phone["id_cid_group"]; if ($A2B->config["database"]['dbtype'] == "postgres") { $QUERY = "SELECT cid FROM cc_outbound_cid_list WHERE activated = 1 AND outbound_cid_group = {$cidgroupid} ORDER BY RANDOM() LIMIT 1"; } else { $QUERY = "SELECT cid FROM cc_outbound_cid_list WHERE activated = 1 AND outbound_cid_group = {$cidgroupid} ORDER BY RAND() LIMIT 1"; } $instance_cid_table = new Table(); echo "QUERY CID : " . $QUERY; $cidresult = $instance_cid_table->SQLExec($A2B->DBHandle, $QUERY); if (is_array($cidresult) && count($cidresult) > 0) { $callerid = $cidresult[0][0]; } $account = $_SESSION["pr_login"]; $uniqueid = MDP_NUMERIC(5) . '-' . MDP_STRING(7); $status = 'PENDING'; $server_ip = 'localhost'; $num_attempt = 0; $variable = "CALLED={$destination}|USERNAME={$phone['8']}|USERID={$phone['6']}|CBID={$uniqueid}|PHONENUMBER_ID=" . $phone['cc_phonenumber_id'] . "|CAMPAIGN_ID=" . $phone['cc_campaign_id']; $res = $instance_table->Add_table($A2B->DBHandle, "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', now(), '{$account}', '{$callerid}', '30000'", "uniqueid, status, server_ip, num_attempt, channel, exten, context, priority, variable, id_server_group, callback_time, account, callerid, timeout", "cc_callback_spool", "id"); if (!$res) { if ($verbose_level >= 1) { echo "[Cannot insert the callback request in the spool!]"; } } else { if ($verbose_level >= 1) { echo "[Your callback request has been queued correctly!]"; } if ($action == "update") { $query = "UPDATE cc_campaign_phonestatus SET id_callback = '{$uniqueid}', lastuse = CURRENT_TIMESTAMP WHERE id_phonenumber ={$phone['0']} AND id_campaign = {$phone['2']} ";
} // ----------------------------------- // CREATE CARDS // ----------------------------------- $instance_callplan = new Table("cc_tariffgroup", "id"); $result_callplan_id = $instance_callplan->Get_list($A2B->DBHandle, null, null, null, null, null, 1000, 1); $nb_db_callplan = sizeof($result_callplan_id); for ($i = 0; $i < $nb_customer; $i++) { if ($verbose > 1) { echo "CREATE CARD : {$i}\n"; } $id_callplan = $result_callplan_id[rand(0, $nb_db_callplan)]['id']; $array_card_generated = gen_card_with_alias("cc_card", 0, 10, $A2B->DBHandle); $card_number = $array_card_generated[0]; $card_alias = $array_card_generated[1]; $pass = MDP_NUMERIC(5) . MDP_STRING(10) . MDP_NUMERIC(5); $query = "INSERT INTO cc_card (username, useralias, uipass, id_group, credit, language, tariff, id_didgroup, status, simultaccess, currency, runservice, autorefill, initialbalance, typepaid, enableexpire, expirationdate, expiredays, voicemail_permitted, voicemail_activated, invoiceday, lastname, firstname, country, id_timezone, sip_buddy, iax_buddy, inuse, credit_notification, notify_email ) values" . "('1111', '11111', '1111', '1', '10', 'en', '1', '-1', '-1', '1', 'USD', '0', '0', '0', '0', '0', '2018-09-02 23:21:33', '0', '1', '0', '0', '11111', 'card', 'AFG', '1', '0', '0', '0', '-1', '0'); "; $instance_table->SQLExec($A2B->DBHandle, $query); } $query = "SELECT count(*) FROM cc_card;"; $nb_db_card = $instance_table->SQLExec($A2B->DBHandle, $query, 1); if ($verbose > 0) { echo "TOTAL DB CARDS : " . $nb_db_card[0][0] . " <br><br>\n\n"; } // Get a list of card $instance_card = new Table("cc_card", "id"); $result_card_id = $instance_card->Get_list($A2B->DBHandle, null, null, null, null, null, 1000, 1); $nb_db_card = sizeof($result_card_id); // ----------------------------------- // CALLERID // -----------------------------------
* * **/ include './lib/customer.defines.php'; include './lib/customer.module.access.php'; include './lib/Form/Class.FormHandler.inc.php'; if (!isset($form_action)) { $form_action = "ask-add"; } if (!isset($action)) { $action = $form_action; } // PROVISION TEST DATA if (false) { $_POST["lastname"] = $_POST["firstname"] = $_POST["address"] = $_POST["city"] = $_POST["state"] = $_POST["country"] = 'SIGN-' . MDP_STRING(5) . '-' . MDP_NUMERIC(3); $_POST["email"] = MDP_STRING(10) . '@sign-up.com'; $_POST["zipcode"] = $_POST["phone"] = '12345667789'; } include './form_data/FG_var_signup.inc'; include './lib/customer.smarty.php'; if (!$A2B->config["signup"]['enable_signup']) { echo "No Signup page!"; exit; } getpost_ifset(array('subscriber_signup')); if (!is_numeric($subscriber_signup)) { //check subscriber_signup $table_check_subscriber = new Table("cc_subscription_signup", "COUNT(*)"); $clause_check_subscriber = ""; $result_check_subscriber = $table_check_subscriber->Get_list(DbConnect(), $clause_check_subscriber); $check_subscriber = $result_check_subscriber[0][0];
<?php include("../lib/customer.defines.php"); $code = MDP_STRING(6); $_SESSION["captcha_code"] = $code; $seed = MDP_NUMERIC(6); $captcha_gd = 1; if ($captcha_gd) { include('captcha_gd.php'); } else { include('captcha_non_gd.php'); } $captcha = new captcha(); $captcha->execute($code, $seed);
function Create_Card($security_key, $transaction_code, $account_number, $tariff, $uipass, $credit, $language, $activated, $status, $simultaccess, $currency, $runservice, $typepaid, $creditlimit, $enableexpire, $expirationdate, $expiredays, $lastname, $firstname, $address, $city, $state, $country, $zipcode, $phone, $fax, $callerid_list, $iax_friend, $sip_friend) { // The wrapper variables for security // $security_key = API_SECURITY_KEY; $logfile = SOAP_LOGFILE; $mysecurity_key = API_SECURITY_KEY; $mail_content = "[" . date("Y/m/d G:i:s", mktime()) . "] " . "SOAP API - Request asked: Create_Card [{$transaction_code}, {$account_number}, {$tariff}, {$uipass}, {$credit}, {$language}, {$activated}, {$simultaccess}, {$currency}, {$runservice}, {$typepaid}, {$creditlimit}, {$enableexpire}, {$expirationdate}, {$expiredays}, {$lastname}, {$firstname}, {$address}, {$city}, {$state}, {$country}, {$zipcode}, {$phone}, {$fax}, {$callerid_list}, {$iax_friend}, {$sip_friend}]"; // CHECK SECURITY KEY if (md5($mysecurity_key) !== $security_key || strlen($security_key) == 0) { a2b_mail(EMAIL_ADMIN, "ALARM : API - CODE_ERROR SECURITY_KEY ", $mail_content); error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . " CODE_ERROR SECURITY_KEY" . "\n", 3, $logfile); sleep(2); return array($transaction_code, '', '', '', '', 'Error', 'KEY - BAD PARAMETER' . "{$security_key} - {$mysecurity_key}"); } // Create new account $FG_ADITION_SECOND_ADD_TABLE = "cc_card"; $FG_ADITION_SECOND_ADD_FIELDS = "username, useralias, credit, tariff, id_didgroup, activated, status, lastname, firstname, email, address, city, state, country, zipcode, phone, fax, userpass, simultaccess, currency, typepaid, creditlimit, language, runservice, enableexpire, expirationdate, expiredays, uipass, sip_buddy, iax_buddy"; $arr_card_alias = gen_card_with_alias('cc_card', 1); $cardnum = $arr_card_alias[0]; $useralias = $arr_card_alias[1]; if ($uipass == '' || strlen($uipass) == 0) { $uipass = MDP_STRING(); } // CHECK PARAMETERS LASTNAME ; FIRSTNAME ; ADDRESS ; .... if (!is_numeric($credit) || !is_numeric($creditlimit) || !is_numeric($expiredays) || $activated != 0 && $activated != 1 || $simultaccess != 0 && $simultaccess != 1 || $runservice != 0 && $runservice != 1 || strlen($lastname) > 40 || strlen($firstname) > 40 || strlen($address) > 100 || strlen($city) > 40 || strlen($state) > 40 || strlen($country) > 40 || strlen($zipcode) > 40 || strlen($phone) > 40 || strlen($email) > 60 || strlen($fax) > 40) { a2b_mail(EMAIL_ADMIN, "ALARM : API - BAD PARAMETER ", $mail_content); error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . " - BAD PARAMETER " . "\n", 3, $logfile); return array($transaction_code, '', '', '', '', 'Error', 'BAD PARAMETER'); } else { if ($expirationdate == '') { $expirationdate = "now()"; } else { $expirationdate = "'{$expirationdate}'"; } $DBHandle = DbConnect(); $instance_sub_table = new Table($FG_ADITION_SECOND_ADD_TABLE, $FG_ADITION_SECOND_ADD_FIELDS); $FG_ADITION_SECOND_ADD_VALUE = "'{$cardnum}', '{$useralias}', '" . $credit . "', '" . $tariff . "', '0', '{$activated}', '{$status}', '{$lastname}', '{$firstname}', '{$email}', '{$address}', '{$city}', " . "'{$state}', '{$country}', '{$zipcode}', '{$phone}', '{$fax}', '{$cardnum}', " . $simultaccess . ", '" . $currency . "', '" . $typepaid . "','" . $creditlimit . "', '" . $language . "', '" . $runservice . "', '" . $enableexpire . "', {$expirationdate}, '{$expiredays}', '{$uipass}', '{$iax_friend}', '{$sip_friend}'"; $result_query = $instance_sub_table->Add_table($DBHandle, $FG_ADITION_SECOND_ADD_VALUE, null, null, 'id'); if ($result_query) { $id_cc_card = $result_query; if (strlen($callerid_list) > 1) { $callerid_list = split(',', $callerid_list); if (count($callerid_list) > 0) { $k = 0; foreach ($callerid_list as $mycallerid) { $k++; if (strlen($mycallerid) > 1) { $QUERY = "SELECT * FROM cc_callerid WHERE cid='{$mycallerid}'"; $result = $instance_sub_table->SQLExec($DBHandle, $QUERY); if (!is_array($result)) { $QUERY = "INSERT INTO cc_callerid (cid, id_cc_card) VALUES ('{$mycallerid}', '{$id_cc_card}')"; $result = $instance_sub_table->SQLExec($DBHandle, $QUERY, 0); if ($result == false) { $callerid_result .= "|callerid{$k}-{$mycallerid}=NOK"; } else { $callerid_result .= "|callerid{$k}-{$mycallerid}=OK"; } } else { $callerid_result .= "|callerid{$k}-{$mycallerid}=NOK"; } } } } } //return array('transaction_code', 'account_number', 'card_number', $useralias, 'uipass', 'result', "IDCARD_CREATED=$id_cc_card"."$callerid_result"); //|LASTQUERY=$QUERY // CHECK IF THERE IS A FRIEND TO CREATE if ($iax_friend || $sip_friend) { // NEW ACCOUNT CREATED $type = FRIEND_TYPE; $allow = FRIEND_ALLOW; $context = FRIEND_CONTEXT; $nat = FRIEND_NAT; $amaflags = FRIEND_AMAFLAGS; $qualify = FRIEND_QUALIFY; $host = FRIEND_HOST; $dtmfmode = FRIEND_DTMFMODE; $uipass = MDP_STRING(); $FG_QUERY_ADITION_SIP_IAX = 'name, type, username, accountcode, regexten, callerid, amaflags, secret, md5secret, nat, dtmfmode, qualify, canreinvite,disallow, allow, host, callgroup, context, defaultip, fromuser, fromdomain, insecure, language, mailbox, permit, deny, mask, pickupgroup, port,restrictcid, rtptimeout, rtpholdtimeout, musiconhold, regseconds, ipaddr, cancallforward'; // For IAX and SIP $param_add_fields = "name, accountcode, regexten, amaflags, callerid, context, dtmfmode, host, type, username, allow, secret"; $param_add_value = "'{$cardnum}', '{$cardnum}', '{$cardnum}', '{$amaflags}', '{$cardnum}', '{$context}', '{$dtmfmode}','{$host}', '{$type}', '{$cardnum}', '{$allow}', '" . $uipass . "', '{$id_cc_card}', '{$nat}', '{$qualify}'"; $list_names = explode(",", $FG_QUERY_ADITION_SIP_IAX); $FG_TABLE_SIP_NAME = "cc_sip_buddies"; $FG_TABLE_IAX_NAME = "cc_iax_buddies"; for ($ki = 0; $ki < 2; $ki++) { if ($ki == 0) { if (!$sip_friend) { continue; } $cfriend = 'sip'; $FG_TABLE_NAME = "cc_sip_buddies"; $buddyfile = BUDDY_SIP_FILE; } else { if (!$iax_friend) { continue; } $cfriend = 'iax'; $FG_TABLE_NAME = "cc_iax_buddies"; $buddyfile = BUDDY_IAX_FILE; } // Insert Sip/Iax account info if ($ki == 0 && $sip_friend || $ki == 1 && $iax_friend) { $instance_table1 = new Table($FG_TABLE_NAME, $FG_QUERY_ADITION_SIP_IAX); $result_query1 = $instance_table1->Add_table($DBHandle, $param_add_value, $param_add_fields, null, null); $instance_table_friend = new Table($FG_TABLE_NAME, 'id, ' . $FG_QUERY_ADITION_SIP_IAX); $list_friend = $instance_table_friend->Get_list($DBHandle, '', null, null, null, null); $fd = fopen($buddyfile, "w"); if (!$fd) { a2b_mail($email_alarm, "ALARM : SOAP-API - Could not open buddy file '{$buddyfile}'", $mail_content); error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . "[Could not open buddy file '{$buddyfile}'] - SOAP-API " . "\n", 3, $logfile); return array($transaction_code, '', '', '', '', 'Error', 'SOAP-API - Could not open buddy file $buddyfile'); } else { foreach ($list_friend as $data) { $line = "\n\n[" . $data[1] . "]\n"; if (fwrite($fd, $line) === FALSE) { error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . "[Impossible to write to the file ({$buddyfile})] - CODE_ERROR 8" . "\n", 3, $logfile); return array($transaction_code, '', '', '', '', 'Error', 'SOAP-API Impossible to write to the file ($buddyfile)'); } else { for ($i = 1; $i < count($data) - 1; $i++) { if (strlen($data[$i + 1]) > 0) { if (trim($list_names[$i]) == 'allow') { $codecs = explode(",", $data[$i + 1]); $line = ""; foreach ($codecs as $value) { $line .= trim($list_names[$i]) . '=' . $value . "\n"; } } else { $line = trim($list_names[$i]) . '=' . $data[$i + 1] . "\n"; } if (fwrite($fd, $line) === FALSE) { error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . "[Impossible to write to the file ({$buddyfile})] - CODE_ERROR 8" . "\n", 3, $logfile); return array($transaction_code, '', '', '', '', 'Error', 'SOAP-API ERROR : Card created in the DB but Impossible to write to the file ($buddyfile)'); } } } } } fclose($fd); } } } // END OF FOR - KI } // END if ($iax_friend || $sip_friend) return array($transaction_code, $account_number, $cardnum, $useralias, $uipass, 'result=OK', "ID CARD_CREATED={$result_query}{$callerid_result}"); } else { a2b_mail(EMAIL_ADMIN, "ALARM : SOAP-API (Add_table)", "{$FG_ADITION_SECOND_ADD_VALUE}\n\n" . $mail_content); error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . "[SOAP-API CODE_ERROR Add_table " . "\n", 3, $logfile); return array($transaction_code, '', '', '', '', 'Error', 'SOAP-API CODE_ERROR Add_table'); } } // END - CHECK PARAMETERS LASTNAME ; FIRSTNAME ; ADDRESS ; .... }
public function Request($security_key, $called, $calling, $callerid, $callback_time, $uniqueid, $accountnumber) { // $called : PHONE NUMBER PERSON CALLING // $calling : DESTINATION PHONE NUMBER global $A2B; /* $status = 'PENDING'; $server_ip = 'localhost'; $num_attempt = 0; $channel = 'SIP/'.$phone_number.'@mylittleIP'; $exten = $phone_number; $context = 'a2billing'; $priority = 1; //$timeout callerid $variable = "phonenumber=$phone_number|callerid=$callerid"; */ $phone_number = $called; $insert_id_callback = 'null'; if (strlen($uniqueid) == 0) { $uniqueid = MDP_STRING(5) . '-' . MDP_NUMERIC(5) . MDP_STRING(10) . MDP_NUMERIC(5); } $FG_regular[] = array("^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})\$", "(YYYY-MM-DD HH:MM:SS)"); // The wrapper variables for security // $security_key = API_SECURITY_KEY; write_log(LOG_CALLBACK, " Service_Callback( security_key={$security_key}, called={$called}, calling={$calling}, callerid={$callerid}, uniqueid={$uniqueid}, callback_time={$callback_time})"); $mysecurity_key = API_SECURITY_KEY; // CHECK CALLERID if (strlen($callerid) < 1) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT CALLERID AT LEAST 1 DIGIT "); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT CALLERID AT LEAST 1 DIGIT "); } // CHECK PHONE_NUMBER if (strlen($phone_number) < 10) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT PHONENUMBER AT LEAST 10 DIGITS "); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT PHONENUMBER AT LEAST 10 DIGITS "); } // CHECK DESTINATION NUMBER if (strlen($calling) < 2) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT DESTINATION NUMBER AT LEAST 2 DIGITS "); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT DESTINATION NUMBER AT LEAST 2 DIGITS "); } // CHECK CALLBACK TIME if (strlen($callback_time) > 1 && !preg_match("/" . $FG_regular[0][0] . "/", $callback_time)) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR FORMAT CALLBACKTIME : " . $FG_regular[0][0]); return array($insert_id_callback, 'result=Error', " ERROR - FORMAT CALLBACKTIME : " . $FG_regular[0][0]); } // CHECK SECURITY KEY if (md5($mysecurity_key) !== $security_key || strlen($security_key) == 0) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " CODE_ERROR SECURITY_KEY"); sleep(2); return array($insert_id_callback, 'result=Error', ' KEY - BAD PARAMETER '); } $DBHandle = DbConnect(); if (!$DBHandle) { write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR CONNECT DB"); sleep(2); return array($insert_id_callback, 'result=Error', ' ERROR - CONNECT DB '); } $A2B->DBHandle = $DBHandle; $instance_table = new Table(); $A2B->set_instance_table($instance_table); $A2B->credit = 1000; $A2B->tariff = $A2B->config["callback"]['all_callback_tariff']; if (strlen($accountnumber) > 1) { // IF WE HAVE AN ACCOUNT NUMBER DEFINED $QUERY = "SELECT tariff, typepaid, credit, creditlimit FROM cc_card WHERE username='******'"; $card_data = $instance_table->SQLExec($DBHandle, $QUERY); if (is_array($card_data)) { $A2B->credit = $card_data[0]['credit']; if ($card_data[0]['typepaid'] == 1) { $A2B->credit = $A2B->credit + $card_data[0]['creditlimit']; } $A2B->tariff = $card_data[0]['tariff']; } //Else find accountnumber from caller's CallerID } else { $QUERY .= "SELECT cc_card.tariff, cc_card.typepaid, cc_card.credit, cc_card.creditlimit, cc_card.username" . " FROM cc_card " . " JOIN cc_callerid" . " ON cc_card.id=cc_callerid.id_cc_card " . " WHERE cc_callerid.cid='" . $phone_number . "'"; $QUERY .= "ORDER BY 1"; $card_data = $instance_table->SQLExec($DBHandle, $QUERY); if (!is_array($card_data)) { return array($insert_id_callback, 'result=Error', "CALLING'S PARTY CALLERID DOES NOT EXIST IN DATABASE"); } $accountnumber = $card_data[0]['username']; if (is_array($card_data)) { $A2B->credit = $card_data[0]['credit']; if ($card_data[0]['typepaid'] == 1) { $A2B->credit = $A2B->credit + $card_data[0]['creditlimit']; } $A2B->tariff = $card_data[0]['tariff']; } } $RateEngine = new RateEngine(); $A2B->extension = $A2B->dnid = $A2B->destination = $called; // LOOKUP RATE : FIND A RATE FOR THIS DESTINATION $resfindrate = $RateEngine->rate_engine_findrates($A2B, $A2B->destination, $A2B->tariff); if ($resfindrate != 0) { //$RateEngine -> debug_st = 1; $res_all_calcultimeout = $RateEngine->rate_engine_all_calcultimeout($A2B, $A2B->credit); if ($res_all_calcultimeout) { // MAKE THE CALL if ($RateEngine->ratecard_obj[0][34] != '-1') { $usetrunk = 34; $usetrunk_failover = 1; $RateEngine->usedtrunk = $RateEngine->ratecard_obj[0][34]; } else { $usetrunk = 29; $RateEngine->usedtrunk = $RateEngine->ratecard_obj[0][29]; $usetrunk_failover = 0; } $prefix = $RateEngine->ratecard_obj[0][$usetrunk + 1]; $tech = $RateEngine->ratecard_obj[0][$usetrunk + 2]; $ipaddress = $RateEngine->ratecard_obj[0][$usetrunk + 3]; $removeprefix = $RateEngine->ratecard_obj[0][$usetrunk + 4]; $timeout = $RateEngine->ratecard_obj[0]['timeout']; $failover_trunk = $RateEngine->ratecard_obj[0][40 + $usetrunk_failover]; $addparameter = $RateEngine->ratecard_obj[0][42 + $usetrunk_failover]; $destination = $A2B->destination; if (strncmp($destination, $removeprefix, strlen($removeprefix)) == 0) { $destination = substr($destination, strlen($removeprefix)); } $pos_dialingnumber = strpos($ipaddress, '%dialingnumber%'); $ipaddress = str_replace("%cardnumber%", $A2B->cardnumber, $ipaddress); $ipaddress = str_replace("%dialingnumber%", $prefix . $destination, $ipaddress); $dialparams = ''; if ($pos_dialingnumber !== false) { $dialstr = "{$tech}/{$ipaddress}" . $dialparams; } else { if ($A2B->agiconfig['switchdialcommand'] == 1) { $dialstr = "{$tech}/{$prefix}{$destination}@{$ipaddress}" . $dialparams; } else { $dialstr = "{$tech}/{$ipaddress}/{$prefix}{$destination}" . $dialparams; } } //ADDITIONAL PARAMETER %dialingnumber%, %cardnumber% if (strlen($addparameter) > 0) { $addparameter = str_replace("%cardnumber%", $A2B->cardnumber, $addparameter); $addparameter = str_replace("%dialingnumber%", $prefix . $destination, $addparameter); $dialstr .= $addparameter; } $channel = $dialstr; $exten = $calling; $context = $A2B->config["callback"]['context_callback']; $id_server_group = $A2B->config["callback"]['id_server_group']; $priority = 1; $timeout = $A2B->config["callback"]['timeout'] * 1000; $application = ''; $status = 'PENDING'; $server_ip = 'localhost'; $num_attempt = 0; $sep = $A2B->config['global']['asterisk_version'] == "1_2" || $A2B->config['global']['asterisk_version'] == "1_4" ? '|' : ','; $variable = "CALLED={$called}" . $sep . "CALLING={$calling}" . $sep . "CBID={$uniqueid}" . $sep . "TARIFF=" . $A2B->tariff; if (is_numeric($A2B->config["callback"]['sec_wait_before_callback']) && $A2B->config["callback"]['sec_wait_before_callback'] >= 1) { $sec_wait_before_callback = $A2B->config["callback"]['sec_wait_before_callback']; } else { $sec_wait_before_callback = 1; } // LIST FIELDS TO INSERT CALLBACK REQUEST $QUERY_FIELS = 'uniqueid, status, server_ip, num_attempt, channel, exten, context, priority, variable, id_server_group, callback_time, account, callerid, timeout'; // DEFINE THE CORRECT VALUE FOR THE INSERT if (strlen($callback_time) > 1) { $QUERY_VALUES = "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', '{$callback_time}', '{$accountnumber}', '{$callerid}', '30000'"; } else { $QUERY_VALUES = "'{$uniqueid}', '{$status}', '{$server_ip}', '{$num_attempt}', '{$channel}', '{$exten}', '{$context}', '{$priority}', '{$variable}', '{$id_server_group}', ADDDATE( CURRENT_TIMESTAMP, INTERVAL {$sec_wait_before_callback} SECOND ), '{$accountnumber}', '{$callerid}', '30000'"; } $insert_id_callback = $instance_table->Add_table($DBHandle, $QUERY_VALUES, $QUERY_FIELS, 'cc_callback_spool', 'id'); if (!$insert_id_callback) { // FAIL INSERT write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " ERROR INSERT -> \n QUERY= {$QUERY_FIELS} :: {$QUERY_VALUES}"); sleep(2); return array($insert_id_callback, 'result=Error', ' ERROR - INSERT INTO DB'); } // SUCCEED INSERT write_log(LOG_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[" . date("Y/m/d G:i:s", mktime()) . "] " . " CALLBACK INSERTED -> \n QUERY= {$QUERY_FIELS} :: {$QUERY_VALUES}"); return array($insert_id_callback, 'result=Success', " Success - Callback request has been accepted "); } else { $error_msg = 'Error : You don t have enough credit to call you back !!!'; } } else { $error_msg = 'Error : There is no route to call back your phonenumber !!!'; } // CALLBACK FAIL write_log(LOG_CALLBACK, "error_msg = {$error_msg}"); return array($insert_id_callback, 'result=Error', " ERROR - {$error_msg}"); }
exit; } if ($FG_DEBUG > 0) { echo "NEW ACCOUNT CREATED - <b>result_query={$result_query}</b> <br> {$FG_ADITION_SECOND_ADD_VALUE}"; } $id_cc_card = $result_query; $type = FRIEND_TYPE; $allow = FRIEND_ALLOW; $context = FRIEND_CONTEXT; $nat = FRIEND_NAT; $amaflags = FRIEND_AMAFLAGS; $qualify = FRIEND_QUALIFY; $host = FRIEND_HOST; $dtmfmode = FRIEND_DTMFMODE; $FG_QUERY_ADITION_SIP_IAX = 'name, type, username, accountcode, regexten, callerid, amaflags, secret, md5secret, nat, dtmfmode, qualify, canreinvite,disallow, allow, host, callgroup, context, defaultip, fromuser, fromdomain, insecure, language, mailbox, permit, deny, mask, pickupgroup, port,restrictcid, rtptimeout, rtpholdtimeout, musiconhold, regseconds, ipaddr, cancallforward'; $uipass = MDP_STRING(); // For IAX and SIP $param_add_fields = "name, accountcode, regexten, amaflags, callerid, context, dtmfmode, host, type, username, allow, secret, id_cc_card, nat, qualify"; $param_add_value = "'{$cardnum}', '{$cardnum}', '{$cardnum}', '{$amaflags}', '{$cardnum}', '{$context}', '{$dtmfmode}','{$host}', '{$type}', '{$cardnum}', '{$allow}', '" . $uipass . "', '{$id_cc_card}', '{$nat}', '{$qualify}'"; $list_names = explode(",", $FG_QUERY_ADITION_SIP_IAX); $FG_TABLE_SIP_NAME = "cc_sip_buddies"; $FG_TABLE_IAX_NAME = "cc_iax_buddies"; for ($ki = 0; $ki < 2; $ki++) { if ($ki == 0) { $cfriend = 'sip'; $FG_TABLE_NAME = "cc_sip_buddies"; $buddyfile = BUDDY_SIP_FILE; } else { $cfriend = 'iax'; $FG_TABLE_NAME = "cc_iax_buddies"; $buddyfile = BUDDY_IAX_FILE;
public function Create_Customer($security_key, $instance, $id_callplan, $id_didgroup, $units, $accountnumber_len, $balance, $activated, $status, $simultaccess, $currency, $typepaid, $sip, $iax, $language, $voicemail_enabled, $country) { $arr_check = $this->Check_KeyInstance($security_key, $instance); if ($arr_check[0] == 'ERROR') { return $arr_check; } $id_group = $arr_check[0]; if (!is_numeric($id_callplan)) { return array("ERROR", "NO ID_CALLPLAN PROVIDED"); } if ($accountnumber_len < 2 || $accountnumber_len > 40) { return array("ERROR", "WRONG ACCOUNT NUMBER LENGTH - {$accountnumber_len}"); } if (strlen($country) == 3) { $country = strtoupper($country); } else { $country = 'USA'; } if (strlen($language) == 2) { $language = strtolower($language); } else { $language = 'en'; } if ($activated) { $activated = 't'; } else { $activated = 'f'; } $instance_realtime = new Realtime(); $FG_ADITION_SECOND_ADD_TABLE = "cc_card"; $FG_ADITION_SECOND_ADD_FIELDS = "username, useralias, credit, tariff, country, language, activated, simultaccess, currency, typepaid, uipass, id_group, id_didgroup, sip_buddy, iax_buddy"; if (DB_TYPE != "postgres") { $FG_ADITION_SECOND_ADD_FIELDS .= ",creationdate "; } $instance_sub_table = new Table($FG_ADITION_SECOND_ADD_TABLE, $FG_ADITION_SECOND_ADD_FIELDS); $sip_buddy = $iax_buddy = 0; if (isset($sip) && $sip == 1) { $sip_buddy = 1; } if (isset($iax) && $iax == 1) { $iax_buddy = 1; } //initialize refill parameter $description_refill = gettext("CREATION CARD REFILL"); $field_insert_refill = "credit, card_id, description"; $instance_refill_table = new Table("cc_logrefill", $field_insert_refill); $arr_account = array(); for ($k = 0; $k < $units; $k++) { $arr_card_alias = gen_card_with_alias("cc_card", 0, $accountnumber_len); $accountnumber = $arr_card_alias[0]; $useralias = $arr_card_alias[1]; if (!is_numeric($balance)) { $balance = 0; } $passui_secret = MDP_NUMERIC(5) . MDP_STRING(10) . MDP_NUMERIC(5); $FG_ADITION_SECOND_ADD_VALUE = "'{$accountnumber}', '{$useralias}', '{$balance}', '{$id_callplan}', '{$country}', '{$language}', '{$activated}', " . " {$simultaccess}, '{$currency}', {$typepaid}, '{$passui_secret}', '{$id_group}', '{$id_didgroup}', {$sip_buddy}, {$iax_buddy}"; if (DB_TYPE != "postgres") { $FG_ADITION_SECOND_ADD_VALUE .= ", now() "; } $id_cc_card = $instance_sub_table->Add_table($this->DBHandle, $FG_ADITION_SECOND_ADD_VALUE, null, null, 'id'); if (!$id_cc_card) { return array(false, "ERROR CREATING ACCOUNT (" . $k . " Accounts created)"); } $arr_account[] = array($accountnumber, $id_cc_card); // create refill for card if ($balance > 0) { $value_insert_refill = "'{$balance}', '{$id_cc_card}', '{$description_refill}' "; $instance_refill_table->Add_table($this->DBHandle, $value_insert_refill, null, null); } $instance_realtime->insert_voip_config($sip_buddy, $iax_buddy, $id_cc_card, $accountnumber, $passui_secret); } // Save Sip accounts to file $instance_realtime->create_trunk_config_file('sip'); // Save IAX accounts to file $instance_realtime->create_trunk_config_file('iax'); return array(serialize($arr_account), "Create_Customer SUCCESS - " . $k . " ACCOUNTS CREATED"); }