iNextrix /
ASTPP
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | } |
| 37 | 37 | |
| 38 | 38 | //Build acl xml |
| 39 | -function load_acl($logger, $db,$config) { |
|
| 39 | +function load_acl($logger, $db, $config) { |
|
| 40 | 40 | $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>\n"; |
| 41 | 41 | $xml .= "<document type=\"freeswitch/xml\">\n"; |
| 42 | 42 | $xml .= " <section name=\"Configuration\" description=\"Configuration\">\n"; |
@@ -46,29 +46,29 @@ discard block |
||
| 46 | 46 | |
| 47 | 47 | //For customer and provider ips |
| 48 | 48 | $query = "SELECT ip FROM ip_map,accounts WHERE ip_map.accountid=accounts.id AND accounts.status=0 AND deleted=0"; |
| 49 | - $logger->log("ACL Query : " . $query); |
|
| 49 | + $logger->log("ACL Query : ".$query); |
|
| 50 | 50 | $res_acl = $db->run($query); |
| 51 | 51 | $logger->log($res_acl); |
| 52 | 52 | |
| 53 | 53 | foreach ($res_acl as $res_acl_key => $res_acl_value) { |
| 54 | - $xml .= " <node type=\"allow\" cidr=\"" . $res_acl_value['ip'] . "\"/>\n"; |
|
| 54 | + $xml .= " <node type=\"allow\" cidr=\"".$res_acl_value['ip']."\"/>\n"; |
|
| 55 | 55 | } |
| 56 | 56 | |
| 57 | 57 | //For gateways |
| 58 | 58 | $query = "SELECT * FROM gateways WHERE status=0"; |
| 59 | - $logger->log("Sofia Gateway Query : " . $query); |
|
| 59 | + $logger->log("Sofia Gateway Query : ".$query); |
|
| 60 | 60 | $sp_gw = $db->run($query); |
| 61 | 61 | $logger->log($sp_gw); |
| 62 | 62 | |
| 63 | 63 | foreach ($sp_gw as $sp_gw_key => $sp_gw_value) { |
| 64 | 64 | |
| 65 | - $sp_gw_settings = json_decode($sp_gw_value['gateway_data'], true); |
|
| 65 | + $sp_gw_settings = json_decode($sp_gw_value['gateway_data'], true); |
|
| 66 | 66 | foreach ($sp_gw_settings as $sp_gw_settings_key => $sp_gw_settings_value) { |
| 67 | 67 | if ($sp_gw_settings_value != "" && $sp_gw_settings_key == "proxy") |
| 68 | 68 | { |
| 69 | - $tmp_ip_arr = explode(":",$sp_gw_settings_value); |
|
| 70 | - if (!filter_var($tmp_ip_arr[0], FILTER_VALIDATE_IP) === false) { |
|
| 71 | - $xml .= " <node type=\"allow\" cidr=\"" . $tmp_ip_arr[0] . "/32\"/>\n"; |
|
| 69 | + $tmp_ip_arr = explode(":", $sp_gw_settings_value); |
|
| 70 | + if ( ! filter_var($tmp_ip_arr[0], FILTER_VALIDATE_IP) === false) { |
|
| 71 | + $xml .= " <node type=\"allow\" cidr=\"".$tmp_ip_arr[0]."/32\"/>\n"; |
|
| 72 | 72 | } |
| 73 | 73 | } |
| 74 | 74 | } |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | |
| 78 | 78 | |
| 79 | 79 | //For opensips |
| 80 | - if($config['opensips'] == '0') |
|
| 80 | + if ($config['opensips'] == '0') |
|
| 81 | 81 | { |
| 82 | 82 | $xml .= "<node type=\"allow\" cidr=\"".$config['opensips_domain']."/32\"/>\n"; |
| 83 | 83 | } |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | $xml .= " </list>\n"; |
| 86 | 86 | |
| 87 | 87 | //For loopback |
| 88 | - if($config['opensips'] == '0') |
|
| 88 | + if ($config['opensips'] == '0') |
|
| 89 | 89 | { |
| 90 | 90 | $xml .= "<list name=\"loopback.auto\" default=\"allow\">\n"; |
| 91 | 91 | $xml .= "<node type=\"allow\" cidr=\"".$config['opensips_domain']."/32\"/>\n"; |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | |
| 95 | 95 | //For event handing |
| 96 | 96 | $xml .= "<list name=\"event\" default=\"deny\">\n"; |
| 97 | - $xml .= ($config['opensips'] == "0")?"<node type=\"allow\" cidr=\"".$config['opensips_domain']."/32\"/>\n":"\n"; |
|
| 97 | + $xml .= ($config['opensips'] == "0") ? "<node type=\"allow\" cidr=\"".$config['opensips_domain']."/32\"/>\n" : "\n"; |
|
| 98 | 98 | $xml .= "<node type=\"allow\" cidr=\"127.0.0.0/8\"/>\n"; |
| 99 | 99 | $xml .= "</list>\n"; |
| 100 | 100 | $xml .= " </network-lists>\n"; |
@@ -114,7 +114,7 @@ discard block |
||
| 114 | 114 | $xml .= " <profiles>\n"; |
| 115 | 115 | |
| 116 | 116 | $query = "SELECT * FROM sip_profiles WHERE status=0"; |
| 117 | - $logger->log("Sofia Query : " . $query); |
|
| 117 | + $logger->log("Sofia Query : ".$query); |
|
| 118 | 118 | $res_sp = $db->run($query); |
| 119 | 119 | //$logger->log($res_sp); |
| 120 | 120 | |
@@ -122,40 +122,40 @@ discard block |
||
| 122 | 122 | |
| 123 | 123 | $settings = json_decode($sp_value['profile_data'], true); |
| 124 | 124 | //$logger->log(print_r($settings,true)); |
| 125 | - $xml .= " <profile name=\"" . $sp_value['name'] . "\">\n"; |
|
| 125 | + $xml .= " <profile name=\"".$sp_value['name']."\">\n"; |
|
| 126 | 126 | |
| 127 | 127 | $xml .= " <domains>\n"; |
| 128 | - $xml .= " <domain name=\"" . $sp_value['sip_ip'] . "\" alias=\"true\" parse=\"true\"/>\n"; |
|
| 128 | + $xml .= " <domain name=\"".$sp_value['sip_ip']."\" alias=\"true\" parse=\"true\"/>\n"; |
|
| 129 | 129 | $xml .= " </domains>\n"; |
| 130 | 130 | /*$xml .= " <aliases>\n"; |
| 131 | 131 | $xml .= " <alias name=\"" . $sp_value['sip_ip'] . "\"/>\n"; |
| 132 | 132 | $xml .= " </aliases>\n";*/ |
| 133 | 133 | |
| 134 | 134 | $xml .= " <settings>\n"; |
| 135 | - $xml .= " <param name=\"sip-ip\" value=\"" . $sp_value['sip_ip'] . "\"/>\n"; |
|
| 136 | - $xml .= " <param name=\"sip-port\" value=\"" . $sp_value['sip_port'] . "\"/>\n"; |
|
| 137 | - foreach($settings as $set_key => $set_val) |
|
| 135 | + $xml .= " <param name=\"sip-ip\" value=\"".$sp_value['sip_ip']."\"/>\n"; |
|
| 136 | + $xml .= " <param name=\"sip-port\" value=\"".$sp_value['sip_port']."\"/>\n"; |
|
| 137 | + foreach ($settings as $set_key => $set_val) |
|
| 138 | 138 | { |
| 139 | - $xml .= " <param name=\"" . $set_key . "\" value=\"" . $set_val . "\"/>\n"; |
|
| 139 | + $xml .= " <param name=\"".$set_key."\" value=\"".$set_val."\"/>\n"; |
|
| 140 | 140 | } |
| 141 | 141 | $xml .= " </settings>\n"; |
| 142 | 142 | |
| 143 | 143 | |
| 144 | 144 | //Gateway block start |
| 145 | 145 | $xml .= " <gateways>\n"; |
| 146 | - $query = "SELECT * FROM gateways WHERE sip_profile_id=" . $sp_value['id'] . " AND status=0"; |
|
| 147 | - $logger->log("Sofia Gateway Query : " . $query); |
|
| 146 | + $query = "SELECT * FROM gateways WHERE sip_profile_id=".$sp_value['id']." AND status=0"; |
|
| 147 | + $logger->log("Sofia Gateway Query : ".$query); |
|
| 148 | 148 | $sp_gw = $db->run($query); |
| 149 | 149 | $logger->log($sp_gw); |
| 150 | 150 | foreach ($sp_gw as $sp_gw_key => $sp_gw_value) { |
| 151 | - $xml .= " <gateway name=\"" . $sp_gw_value['name'] . "\">\n"; |
|
| 151 | + $xml .= " <gateway name=\"".$sp_gw_value['name']."\">\n"; |
|
| 152 | 152 | |
| 153 | 153 | |
| 154 | 154 | |
| 155 | - $sp_gw_settings = json_decode($sp_gw_value['gateway_data'], true); |
|
| 155 | + $sp_gw_settings = json_decode($sp_gw_value['gateway_data'], true); |
|
| 156 | 156 | foreach ($sp_gw_settings as $sp_gw_settings_key => $sp_gw_settings_value) { |
| 157 | 157 | if ($sp_gw_settings_value != "") |
| 158 | - $xml .= " <param name=\"" . $sp_gw_settings_key . "\" value=\"" . $sp_gw_settings_value . "\"/>\n"; |
|
| 158 | + $xml .= " <param name=\"".$sp_gw_settings_key."\" value=\"".$sp_gw_settings_value."\"/>\n"; |
|
| 159 | 159 | } |
| 160 | 160 | $xml .= " </gateway>\n"; |
| 161 | 161 | } |
@@ -177,9 +177,9 @@ discard block |
||
| 177 | 177 | function load_directory($logger, $db) { |
| 178 | 178 | $xml = ""; |
| 179 | 179 | |
| 180 | - $query = "SELECT username,dir_params,dir_vars,number as accountcode,accountid FROM sip_devices,accounts WHERE sip_devices.status=0 AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND username='" . $_REQUEST['user']."' limit 1"; |
|
| 180 | + $query = "SELECT username,dir_params,dir_vars,number as accountcode,accountid FROM sip_devices,accounts WHERE sip_devices.status=0 AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND username='".$_REQUEST['user']."' limit 1"; |
|
| 181 | 181 | |
| 182 | - $logger->log("Directory Query : " . $query); |
|
| 182 | + $logger->log("Directory Query : ".$query); |
|
| 183 | 183 | $res_dir = $db->run($query); |
| 184 | 184 | $logger->log($res_dir); |
| 185 | 185 | |
@@ -187,21 +187,21 @@ discard block |
||
| 187 | 187 | $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>\n"; |
| 188 | 188 | $xml .= "<document type=\"freeswitch/xml\">\n"; |
| 189 | 189 | $xml .= " <section name=\"Directory\" description=\"Directory\">\n"; |
| 190 | - $xml .= " <domain name=\"" . $_REQUEST['domain'] . "\" alias=\"true\">\n"; |
|
| 191 | - $xml .= " <user id=\"" . $_REQUEST['user'] . "\">\n"; |
|
| 190 | + $xml .= " <domain name=\"".$_REQUEST['domain']."\" alias=\"true\">\n"; |
|
| 191 | + $xml .= " <user id=\"".$_REQUEST['user']."\">\n"; |
|
| 192 | 192 | |
| 193 | 193 | $params = json_decode($res_dir_value['dir_params'], true); |
| 194 | 194 | |
| 195 | 195 | $vars = json_decode($res_dir_value['dir_vars'], true); |
| 196 | 196 | $param_xml = $var_xml = ""; |
| 197 | - foreach($params as $parms_key => $res_dir_params) |
|
| 197 | + foreach ($params as $parms_key => $res_dir_params) |
|
| 198 | 198 | { |
| 199 | - $param_xml .= "<param name=\"" . $parms_key . "\" value=\"" . $res_dir_params . "\"/>\n"; |
|
| 199 | + $param_xml .= "<param name=\"".$parms_key."\" value=\"".$res_dir_params."\"/>\n"; |
|
| 200 | 200 | } |
| 201 | 201 | |
| 202 | - foreach($vars as $var_key => $res_dir_vars) |
|
| 202 | + foreach ($vars as $var_key => $res_dir_vars) |
|
| 203 | 203 | { |
| 204 | - $var_xml .= "<variable name=\"" . $var_key . "\" value=\"" . $res_dir_vars . "\"/>\n"; |
|
| 204 | + $var_xml .= "<variable name=\"".$var_key."\" value=\"".$res_dir_vars."\"/>\n"; |
|
| 205 | 205 | } |
| 206 | 206 | |
| 207 | 207 | |
@@ -214,8 +214,8 @@ discard block |
||
| 214 | 214 | $xml .= " <variables>\n"; |
| 215 | 215 | $xml .= $var_xml; |
| 216 | 216 | $xml .= "<variable name=\"sipcall\" value=\"true\"/>\n"; |
| 217 | - $xml .= "<variable name=\"accountcode\" value=\"" . $res_dir_value['accountcode'] . "\"/>\n"; |
|
| 218 | - $xml .= "<variable name=\"domain_name\" value=\"" . $_REQUEST['domain'] . "\"/>\n"; |
|
| 217 | + $xml .= "<variable name=\"accountcode\" value=\"".$res_dir_value['accountcode']."\"/>\n"; |
|
| 218 | + $xml .= "<variable name=\"domain_name\" value=\"".$_REQUEST['domain']."\"/>\n"; |
|
| 219 | 219 | $xml .= " </variables>\n"; |
| 220 | 220 | |
| 221 | 221 | $xml .= " </user>\n"; |
@@ -46,15 +46,15 @@ discard block |
||
| 46 | 46 | |
| 47 | 47 | if ($dataVariable['billsec'] == 0 && $dataVariable['hangup_cause'] == 'NORMAL_CLEARING') |
| 48 | 48 | { |
| 49 | - $hangup_cause = isset($dataVariable['last_bridge_hangup_cause'])?$dataVariable['last_bridge_hangup_cause']:$dataVariable['hangup_cause']; |
|
| 50 | - }else{ |
|
| 49 | + $hangup_cause = isset($dataVariable['last_bridge_hangup_cause']) ? $dataVariable['last_bridge_hangup_cause'] : $dataVariable['hangup_cause']; |
|
| 50 | + } else { |
|
| 51 | 51 | $hangup_cause = $dataVariable['hangup_cause']; |
| 52 | 52 | } |
| 53 | 53 | |
| 54 | 54 | if ($dataVariable['error_cdr'] == '1') |
| 55 | 55 | { |
| 56 | 56 | //Get actual hangup cause |
| 57 | - $hangup_cause= (isset($dataVariable['error_cdr'])) ? $dataVariable['last_bridge_hangup_cause'] : (isset($dataVariable['last_bridge_hangup_cause'])?$dataVariable['last_bridge_hangup_cause']:$dataVariable['hangup_cause']); |
|
| 57 | + $hangup_cause = (isset($dataVariable['error_cdr'])) ? $dataVariable['last_bridge_hangup_cause'] : (isset($dataVariable['last_bridge_hangup_cause']) ? $dataVariable['last_bridge_hangup_cause'] : $dataVariable['hangup_cause']); |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | /*#### PATCH FOR ONE WAY AUDIO ####*/ |
@@ -65,14 +65,14 @@ discard block |
||
| 65 | 65 | /*#### ************* END *************####*/ |
| 66 | 66 | |
| 67 | 67 | //Don't thing this will be useful anytime. Need to remove it after testing. |
| 68 | - if($hangup_cause == "NONE") |
|
| 68 | + if ($hangup_cause == "NONE") |
|
| 69 | 69 | { |
| 70 | 70 | $hangup_cause = $dataVariable['current_application_data']; |
| 71 | 71 | } |
| 72 | 72 | |
| 73 | 73 | $dataVariable['hangup_cause'] = $hangup_cause; |
| 74 | 74 | |
| 75 | - if ( ($dataVariable['hangup_cause'] != 'NORMAL_CLEARING') && ($dataVariable['hangup_cause'] != 'ALLOTTED_TIMEOUT')) { |
|
| 75 | + if (($dataVariable['hangup_cause'] != 'NORMAL_CLEARING') && ($dataVariable['hangup_cause'] != 'ALLOTTED_TIMEOUT')) { |
|
| 76 | 76 | $dataVariable['billsec'] = 0; |
| 77 | 77 | } |
| 78 | 78 | |
@@ -86,13 +86,13 @@ discard block |
||
| 86 | 86 | $actual_calltype = $dataVariable['calltype']; |
| 87 | 87 | |
| 88 | 88 | //Normalize origination and termination rates array |
| 89 | - if(isset($dataVariable['origination_rates'])) |
|
| 89 | + if (isset($dataVariable['origination_rates'])) |
|
| 90 | 90 | $origination_rate = normalize_origination_rate($dataVariable['origination_rates']); |
| 91 | - if(isset($dataVariable['termination_rates'])) |
|
| 91 | + if (isset($dataVariable['termination_rates'])) |
|
| 92 | 92 | $termination_rate = normalize_rate($dataVariable['termination_rates']); |
| 93 | 93 | |
| 94 | 94 | //If receiver account id found then explicitly set call direction and call type |
| 95 | - if(isset($dataVariable['receiver_accid'])) |
|
| 95 | + if (isset($dataVariable['receiver_accid'])) |
|
| 96 | 96 | { |
| 97 | 97 | $dataVariable['call_direction'] = "outbound"; |
| 98 | 98 | $dataVariable['calltype'] = "STANDARD"; |
@@ -101,23 +101,23 @@ discard block |
||
| 101 | 101 | //Check if cusotmer have any package seconds left to use |
| 102 | 102 | if ($actual_duration > 0) |
| 103 | 103 | { |
| 104 | - $package_array = package_calculation( $dataVariable['effective_destination_number'],$origination_rate[$accountid]['RATEGROUP'],$actual_duration,$dataVariable['call_direction'],$accountid,$db,$logger); |
|
| 105 | - if(!empty($package_array)) |
|
| 104 | + $package_array = package_calculation($dataVariable['effective_destination_number'], $origination_rate[$accountid]['RATEGROUP'], $actual_duration, $dataVariable['call_direction'], $accountid, $db, $logger); |
|
| 105 | + if ( ! empty($package_array)) |
|
| 106 | 106 | { |
| 107 | 107 | $dataVariable['calltype'] = "FREE"; |
| 108 | - $dataVariable['package_id']= $package_array['package_id']; |
|
| 108 | + $dataVariable['package_id'] = $package_array['package_id']; |
|
| 109 | 109 | } |
| 110 | 110 | } |
| 111 | 111 | |
| 112 | 112 | //Calculate debit of customer call |
| 113 | - $debit = calc_cost($dataVariable,$origination_rate[$accountid],$logger,$decimal_points); |
|
| 113 | + $debit = calc_cost($dataVariable, $origination_rate[$accountid], $logger, $decimal_points); |
|
| 114 | 114 | |
| 115 | 115 | //Calculate cost for customer call for provider |
| 116 | - $provider_cost = calc_cost($dataVariable,$termination_rate,$logger,$decimal_points); |
|
| 116 | + $provider_cost = calc_cost($dataVariable, $termination_rate, $logger, $decimal_points); |
|
| 117 | 117 | |
| 118 | 118 | //Calculate parent cost if customer have any parent |
| 119 | - $parent_cost = ($parentid > 0) ? calc_cost($dataVariable,$origination_rate[$parentid],$logger,$decimal_points) : $provider_cost; |
|
| 120 | - $logger->log("Debit :".$debit ." Cost : ".$cost ." Provider Cost : ".$parent_cost); |
|
| 119 | + $parent_cost = ($parentid > 0) ? calc_cost($dataVariable, $origination_rate[$parentid], $logger, $decimal_points) : $provider_cost; |
|
| 120 | + $logger->log("Debit :".$debit." Cost : ".$cost." Provider Cost : ".$parent_cost); |
|
| 121 | 121 | |
| 122 | 122 | //Initialize final cost variable to use for billing |
| 123 | 123 | $cost = ($parent_cost > 0) ? $parent_cost : $provider_cost; |
@@ -125,33 +125,33 @@ discard block |
||
| 125 | 125 | //Outbound call entry for all type of calls |
| 126 | 126 | $logger->log("*********************** OUTBOUND CALL ENTRY START *************"); |
| 127 | 127 | |
| 128 | - $cdr_string = get_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost,$logger); |
|
| 128 | + $cdr_string = get_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost, $logger); |
|
| 129 | 129 | |
| 130 | 130 | $query = "INSERT INTO cdrs (uniqueid,accountid,type,callerid,callednum,billseconds,trunk_id,trunkip,callerip,disposition,callstart,debit,cost,provider_id,pricelist_id,package_id,pattern,notes,rate_cost,reseller_id,reseller_code,reseller_code_destination,reseller_cost,provider_code,provider_code_destination,provider_cost,provider_call_cost,call_direction,calltype,profile_start_stamp,answer_stamp,bridge_stamp,progress_stamp,progress_media_stamp,end_stamp,billmsec,answermsec,waitmsec,progress_mediamsec,flow_billmsec) values ($cdr_string)"; |
| 131 | 131 | $logger->log($query); |
| 132 | 132 | $db->run($query); |
| 133 | 133 | |
| 134 | 134 | //Update customer balance |
| 135 | - if($debit > 0 && $dataVariable['calltype'] != "FREE") |
|
| 135 | + if ($debit > 0 && $dataVariable['calltype'] != "FREE") |
|
| 136 | 136 | { |
| 137 | 137 | update_balance($accountid, $debit, 0, $logger, $db); |
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | //Update parent or provider balance |
| 141 | - if($parent_cost > 0){ |
|
| 141 | + if ($parent_cost > 0) { |
|
| 142 | 142 | update_balance($termination_rate['PROVIDER'], ($parent_cost * -1), 3, $logger, $db); |
| 143 | 143 | } |
| 144 | 144 | |
| 145 | 145 | //Resellers CDR entry |
| 146 | 146 | $flag_parent = false; |
| 147 | - insert_parent_data($dataVariable,$actual_calltype,$parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points); |
|
| 147 | + insert_parent_data($dataVariable, $actual_calltype, $parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points); |
|
| 148 | 148 | |
| 149 | 149 | $logger->log("*********************** OUTBOUND CALL ENTRY END *************"); |
| 150 | 150 | |
| 151 | 151 | |
| 152 | 152 | //************ ADDING EXTRA ENTRY For local/DID Inbound call **************************** |
| 153 | - $receiver_parentid=0; |
|
| 154 | - if(isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "") |
|
| 153 | + $receiver_parentid = 0; |
|
| 154 | + if (isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "") |
|
| 155 | 155 | { |
| 156 | 156 | $logger->log("*********************** EXTRA ENTRY SECTION FOR BILLING START *************"); |
| 157 | 157 | |
@@ -160,12 +160,12 @@ discard block |
||
| 160 | 160 | $dataVariable['calltype'] = "DID"; |
| 161 | 161 | |
| 162 | 162 | //Override variables if call for DID PSTN |
| 163 | - if(isset($dataVariable['caller_did_account_id'])) |
|
| 163 | + if (isset($dataVariable['caller_did_account_id'])) |
|
| 164 | 164 | { |
| 165 | 165 | $dataVariable['receiver_accid'] = $dataVariable['caller_did_account_id']; |
| 166 | 166 | $dataVariable['call_direction'] = "outbound"; |
| 167 | 167 | $dataVariable['calltype'] = "STANDARD"; |
| 168 | - $dataVariable['effective_destination_number']=$dataVariable['sip_to_user']; |
|
| 168 | + $dataVariable['effective_destination_number'] = $dataVariable['sip_to_user']; |
|
| 169 | 169 | unset($termination_rate); |
| 170 | 170 | unset($provider_cost); |
| 171 | 171 | } |
@@ -173,17 +173,17 @@ discard block |
||
| 173 | 173 | |
| 174 | 174 | |
| 175 | 175 | //Get call receiver account information |
| 176 | - $receiver_carddata = get_accounts($dataVariable['receiver_accid'],$logger,$db); |
|
| 176 | + $receiver_carddata = get_accounts($dataVariable['receiver_accid'], $logger, $db); |
|
| 177 | 177 | $receiver_parentid = $receiver_carddata['reseller_id']; |
| 178 | 178 | |
| 179 | 179 | //For additional cdr entry of receiver |
| 180 | - insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$receiver_parentid,$flag_parent,$dataVariable['receiver_accid'],$logger,$db,$decimal_points); |
|
| 180 | + insert_extra_receiver_entry($dataVariable, $origination_rate, $termination_rate, $account_type, $actual_duration, $provider_cost, $receiver_parentid, $flag_parent, $dataVariable['receiver_accid'], $logger, $db, $decimal_points); |
|
| 181 | 181 | |
| 182 | 182 | $flag_parent = true; |
| 183 | 183 | $dataVariable['uuid'] = $dataVariable['uuid'].$dataVariable['calltype']."_".$receiver_parentid; |
| 184 | 184 | |
| 185 | 185 | //Insert parent reseller cdr |
| 186 | - insert_parent_data($dataVariable,$actual_calltype,$receiver_parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points); |
|
| 186 | + insert_parent_data($dataVariable, $actual_calltype, $receiver_parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points); |
|
| 187 | 187 | $logger->log("*********************** EXTRA ENTRY SECTION FOR BILLING END *************"); |
| 188 | 188 | } |
| 189 | 189 | //***************************************************************************************** |
@@ -195,16 +195,16 @@ discard block |
||
| 195 | 195 | * @param string $provider_cost |
| 196 | 196 | * @param boolean $flag_parent |
| 197 | 197 | */ |
| 198 | -function insert_parent_data($dataVariable,$actual_calltype,$parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points) |
|
| 198 | +function insert_parent_data($dataVariable, $actual_calltype, $parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points) |
|
| 199 | 199 | { |
| 200 | - while($parentid > 0 ) |
|
| 200 | + while ($parentid > 0) |
|
| 201 | 201 | { |
| 202 | 202 | $logger->log("*************** IN PARENT DATA SECTION ********"); |
| 203 | 203 | $dataVariable['calltype'] = $actual_calltype; |
| 204 | - $carddata = get_accounts($parentid,$logger,$db); |
|
| 204 | + $carddata = get_accounts($parentid, $logger, $db); |
|
| 205 | 205 | $accountid = $carddata['id']; |
| 206 | 206 | |
| 207 | - $debit = calc_cost($dataVariable,$origination_rate[$accountid],$logger,$decimal_points); |
|
| 207 | + $debit = calc_cost($dataVariable, $origination_rate[$accountid], $logger, $decimal_points); |
|
| 208 | 208 | |
| 209 | 209 | //If receiver account id found then explicitly set call direction and call type |
| 210 | 210 | /*if(isset($dataVariable['receiver_accid'])) |
@@ -214,31 +214,31 @@ discard block |
||
| 214 | 214 | }*/ |
| 215 | 215 | |
| 216 | 216 | //Check if reseller have any package seconds left to use |
| 217 | - if ($actual_duration > 0) { |
|
| 218 | - $package_array = package_calculation( $dataVariable['effective_destination_number'],$origination_rate[$accountid]['RATEGROUP'],$actual_duration,$dataVariable['call_direction'],$accountid,$db,$logger); |
|
| 219 | - if(!empty($package_array)) |
|
| 217 | + if ($actual_duration > 0) { |
|
| 218 | + $package_array = package_calculation($dataVariable['effective_destination_number'], $origination_rate[$accountid]['RATEGROUP'], $actual_duration, $dataVariable['call_direction'], $accountid, $db, $logger); |
|
| 219 | + if ( ! empty($package_array)) |
|
| 220 | 220 | { |
| 221 | 221 | $dataVariable['calltype'] = "FREE"; |
| 222 | - $dataVariable['package_id']= $package_array['package_id']; |
|
| 222 | + $dataVariable['package_id'] = $package_array['package_id']; |
|
| 223 | 223 | } |
| 224 | 224 | } |
| 225 | 225 | |
| 226 | 226 | //Get parent id for cost calculation |
| 227 | 227 | $parentid = $carddata['reseller_id']; |
| 228 | - $parent_cost = ($parentid > 0) ? calc_cost($dataVariable,$origination_rate[$parentid],$logger,$decimal_points) : $provider_cost; |
|
| 228 | + $parent_cost = ($parentid > 0) ? calc_cost($dataVariable, $origination_rate[$parentid], $logger, $decimal_points) : $provider_cost; |
|
| 229 | 229 | $cost = ($parent_cost > 0) ? $parent_cost : $provider_cost; |
| 230 | 230 | |
| 231 | - if(isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "" && $flag_parent == true) |
|
| 231 | + if (isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "" && $flag_parent == true) |
|
| 232 | 232 | { |
| 233 | 233 | $logger->log("********* IN RESELLER FOR RECEIVER ENTRY START ******"); |
| 234 | 234 | $flag_parent = true; |
| 235 | - insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$parentid,$flag_parent,$accountid,$logger,$db,$decimal_points); |
|
| 235 | + insert_extra_receiver_entry($dataVariable, $origination_rate, $termination_rate, $account_type, $actual_duration, $provider_cost, $parentid, $flag_parent, $accountid, $logger, $db, $decimal_points); |
|
| 236 | 236 | $logger->log("********* IN RESELLER FOR RECEIVER ENTRY END ******"); |
| 237 | 237 | return true; |
| 238 | 238 | |
| 239 | - } else{ |
|
| 239 | + } else { |
|
| 240 | 240 | |
| 241 | - $cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost); |
|
| 241 | + $cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost); |
|
| 242 | 242 | |
| 243 | 243 | $query = "INSERT INTO reseller_cdrs (uniqueid,accountid,callerid,callednum,billseconds,disposition,callstart,debit,cost,pricelist_id,package_id,pattern,notes,rate_cost, |
| 244 | 244 | reseller_id,reseller_code,reseller_code_destination,reseller_cost,call_direction,calltype) values ($cdr_string)"; |
@@ -259,38 +259,38 @@ discard block |
||
| 259 | 259 | /** |
| 260 | 260 | * @param boolean $flag_parent |
| 261 | 261 | */ |
| 262 | -function insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$parentid,$flag_parent,$accountid,$logger,$db,$decimal_points) |
|
| 262 | +function insert_extra_receiver_entry($dataVariable, $origination_rate, $termination_rate, $account_type, $actual_duration, $provider_cost, $parentid, $flag_parent, $accountid, $logger, $db, $decimal_points) |
|
| 263 | 263 | { |
| 264 | 264 | $localVariable = $dataVariable; |
| 265 | 265 | $localVariable['call_direction'] = "inbound"; |
| 266 | 266 | $localVariable['uuid'] = $localVariable['uuid'].$dataVariable['calltype']."_".$accountid; |
| 267 | 267 | |
| 268 | - if($dataVariable['calltype'] == "LOCAL") |
|
| 268 | + if ($dataVariable['calltype'] == "LOCAL") |
|
| 269 | 269 | { |
| 270 | 270 | $origination_rate[$accountid]['CODE'] = $dataVariable['effective_destination_number']; |
| 271 | 271 | $origination_rate[$accountid]['DESTINATION'] = $dataVariable['calltype']; |
| 272 | - if($flag_parent == false){ |
|
| 273 | - $cdr_string = get_cdr_string($localVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,0,0,$logger); |
|
| 274 | - } else{ |
|
| 275 | - $cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost); |
|
| 272 | + if ($flag_parent == false) { |
|
| 273 | + $cdr_string = get_cdr_string($localVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, 0, 0, $logger); |
|
| 274 | + } else { |
|
| 275 | + $cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost); |
|
| 276 | 276 | } |
| 277 | - } else{ |
|
| 277 | + } else { |
|
| 278 | 278 | |
| 279 | 279 | $origination_rate_did = normalize_origination_rate($dataVariable['origination_rates_did']); |
| 280 | - $debit = calc_cost($dataVariable,$origination_rate_did[$accountid],$logger,$decimal_points); |
|
| 280 | + $debit = calc_cost($dataVariable, $origination_rate_did[$accountid], $logger, $decimal_points); |
|
| 281 | 281 | |
| 282 | - if($flag_parent == false){ |
|
| 282 | + if ($flag_parent == false) { |
|
| 283 | 283 | |
| 284 | - $cdr_string = get_cdr_string($localVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate_did,$provider_cost,$parentid,$debit,0,$logger); |
|
| 285 | - } else{ |
|
| 286 | - $cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost); |
|
| 284 | + $cdr_string = get_cdr_string($localVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate_did, $provider_cost, $parentid, $debit, 0, $logger); |
|
| 285 | + } else { |
|
| 286 | + $cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost); |
|
| 287 | 287 | } |
| 288 | 288 | } |
| 289 | 289 | |
| 290 | - if($flag_parent == false) |
|
| 290 | + if ($flag_parent == false) |
|
| 291 | 291 | { |
| 292 | 292 | $query = "INSERT INTO cdrs(uniqueid,accountid,type,callerid,callednum,billseconds,trunk_id,trunkip,callerip,disposition,callstart,debit,cost,provider_id,pricelist_id,package_id,pattern,notes,rate_cost,reseller_id,reseller_code,reseller_code_destination,reseller_cost,provider_code,provider_code_destination,provider_cost,provider_call_cost,call_direction,calltype,profile_start_stamp,answer_stamp,bridge_stamp,progress_stamp,progress_media_stamp,end_stamp,billmsec,answermsec,waitmsec,progress_mediamsec,flow_billmsec) values ($cdr_string)"; |
| 293 | - } else{ |
|
| 293 | + } else { |
|
| 294 | 294 | $query = "INSERT INTO reseller_cdrs (uniqueid,accountid,callerid,callednum,billseconds,disposition,callstart,debit,cost,pricelist_id,package_id,pattern,notes,rate_cost, |
| 295 | 295 | reseller_id,reseller_code,reseller_code_destination,reseller_cost,call_direction,calltype) values ($cdr_string)"; |
| 296 | 296 | } |
@@ -306,20 +306,20 @@ discard block |
||
| 306 | 306 | } |
| 307 | 307 | |
| 308 | 308 | //Generate CDR string for insert query for customer. |
| 309 | -function get_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost,$logger) |
|
| 309 | +function get_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost, $logger) |
|
| 310 | 310 | { |
| 311 | - $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype']; |
|
| 312 | - $callerIdNumber = isset($dataVariable['effective_caller_id_number']) && !empty($dataVariable['effective_caller_id_number'])? $dataVariable['effective_caller_id_number'] :$dataVariable['caller_id']; |
|
| 313 | - return $cdr_string = "'".($dataVariable['uuid'])."','".$accountid."','".$account_type."','".(urldecode($callerIdNumber))."','".($dataVariable['effective_destination_number'])."','".$actual_duration."',".(($termination_rate['TRUNK']) ? $termination_rate['TRUNK'] : '0').",".(($dataVariable['sip_via_host']) ? "'".$dataVariable['sip_via_host']."'" : '').",".(($dataVariable['sip_contact_host']) ? "'".$dataVariable['sip_contact_host']."'" : '').",'".($dataVariable['hangup_cause'])."','".urldecode($dataVariable['callstart'])."','".$debit."','".$cost."',".(($termination_rate['PROVIDER']) ? $termination_rate['PROVIDER'] : '0').",'".$origination_rate[$accountid]['RATEGROUP']."','".$dataVariable['package_id']."','".($origination_rate[$accountid]['CODE'])."',".(($origination_rate[$accountid]['DESTINATION']) ? "'".htmlentities($origination_rate[$accountid]['DESTINATION'],ENT_COMPAT, 'UTF-8')."'" : "'".''."'").",".(($origination_rate[$accountid]['COST']) ? "'".$origination_rate[$accountid]['COST']."'" : "'".'0'."'").",'".$parentid."',".(($origination_rate[$parentid]['CODE'] ) ? "'".$origination_rate[$parentid]['CODE']."'" : "'".'0'."'").",".(($origination_rate[$parentid]['DESTINATION']) ? "'".$origination_rate[$parentid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$parentid]['COST']) ? "'".$origination_rate[$parentid]['COST']."'" : '0').",".(($termination_rate['CODE']) ? "'".$termination_rate['CODE']."'" : "'".''."'" ).",".(($termination_rate['DESTINATION']) ? "'".$termination_rate['DESTINATION']."'" : "'".''."'").",".(($termination_rate['COST']) ? "'".$termination_rate['COST']."'" : '0').",'".$provider_cost."',".(($dataVariable['call_direction']) ? "'".$dataVariable['call_direction']."'" : "'internal'").",'".($dataVariable['calltype'])."','".convert_to_gmt(urldecode($dataVariable['profile_start_stamp']))."','".convert_to_gmt(urldecode($dataVariable['answer_stamp']))."','".convert_to_gmt(urldecode($dataVariable['bridge_stamp']))."','".convert_to_gmt(urldecode(@$dataVariable['progress_stamp']))."','".convert_to_gmt(urldecode(@$dataVariable['progress_media_stamp']))."','".convert_to_gmt(urldecode($dataVariable['end_stamp']))."',".$dataVariable['billmsec'].",'".$dataVariable['answermsec']."','".$dataVariable['waitmsec']."','".$dataVariable['progress_mediamsec']."','".$dataVariable['flow_billmsec']."'"; |
|
| 311 | + $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER') ? "DID" : $dataVariable['calltype']; |
|
| 312 | + $callerIdNumber = isset($dataVariable['effective_caller_id_number']) && ! empty($dataVariable['effective_caller_id_number']) ? $dataVariable['effective_caller_id_number'] : $dataVariable['caller_id']; |
|
| 313 | + return $cdr_string = "'".($dataVariable['uuid'])."','".$accountid."','".$account_type."','".(urldecode($callerIdNumber))."','".($dataVariable['effective_destination_number'])."','".$actual_duration."',".(($termination_rate['TRUNK']) ? $termination_rate['TRUNK'] : '0').",".(($dataVariable['sip_via_host']) ? "'".$dataVariable['sip_via_host']."'" : '').",".(($dataVariable['sip_contact_host']) ? "'".$dataVariable['sip_contact_host']."'" : '').",'".($dataVariable['hangup_cause'])."','".urldecode($dataVariable['callstart'])."','".$debit."','".$cost."',".(($termination_rate['PROVIDER']) ? $termination_rate['PROVIDER'] : '0').",'".$origination_rate[$accountid]['RATEGROUP']."','".$dataVariable['package_id']."','".($origination_rate[$accountid]['CODE'])."',".(($origination_rate[$accountid]['DESTINATION']) ? "'".htmlentities($origination_rate[$accountid]['DESTINATION'], ENT_COMPAT, 'UTF-8')."'" : "'".''."'").",".(($origination_rate[$accountid]['COST']) ? "'".$origination_rate[$accountid]['COST']."'" : "'".'0'."'").",'".$parentid."',".(($origination_rate[$parentid]['CODE']) ? "'".$origination_rate[$parentid]['CODE']."'" : "'".'0'."'").",".(($origination_rate[$parentid]['DESTINATION']) ? "'".$origination_rate[$parentid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$parentid]['COST']) ? "'".$origination_rate[$parentid]['COST']."'" : '0').",".(($termination_rate['CODE']) ? "'".$termination_rate['CODE']."'" : "'".''."'").",".(($termination_rate['DESTINATION']) ? "'".$termination_rate['DESTINATION']."'" : "'".''."'").",".(($termination_rate['COST']) ? "'".$termination_rate['COST']."'" : '0').",'".$provider_cost."',".(($dataVariable['call_direction']) ? "'".$dataVariable['call_direction']."'" : "'internal'").",'".($dataVariable['calltype'])."','".convert_to_gmt(urldecode($dataVariable['profile_start_stamp']))."','".convert_to_gmt(urldecode($dataVariable['answer_stamp']))."','".convert_to_gmt(urldecode($dataVariable['bridge_stamp']))."','".convert_to_gmt(urldecode(@$dataVariable['progress_stamp']))."','".convert_to_gmt(urldecode(@$dataVariable['progress_media_stamp']))."','".convert_to_gmt(urldecode($dataVariable['end_stamp']))."',".$dataVariable['billmsec'].",'".$dataVariable['answermsec']."','".$dataVariable['waitmsec']."','".$dataVariable['progress_mediamsec']."','".$dataVariable['flow_billmsec']."'"; |
|
| 314 | 314 | } |
| 315 | 315 | |
| 316 | 316 | //Generate CDR string for insert query for reseller |
| 317 | -function get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost) |
|
| 317 | +function get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost) |
|
| 318 | 318 | { |
| 319 | - $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype']; |
|
| 320 | - $callerIdNumber = isset($dataVariable['effective_caller_id_number']) && !empty($dataVariable['effective_caller_id_number'])? $dataVariable['effective_caller_id_number'] :$dataVariable['caller_id']; |
|
| 319 | + $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER') ? "DID" : $dataVariable['calltype']; |
|
| 320 | + $callerIdNumber = isset($dataVariable['effective_caller_id_number']) && ! empty($dataVariable['effective_caller_id_number']) ? $dataVariable['effective_caller_id_number'] : $dataVariable['caller_id']; |
|
| 321 | 321 | |
| 322 | - return $cdr_string = "'".($dataVariable['uuid'])."','".$accountid."','".(urldecode($callerIdNumber))."','".($dataVariable['effective_destination_number'])."','".$actual_duration."','".($dataVariable['hangup_cause'])."','".convert_to_gmt(urldecode($dataVariable['callstart']))."','".$debit."','".$cost."','".$origination_rate[$accountid]['RATEGROUP']."','".$dataVariable['package_id']."','".($origination_rate[$accountid]['CODE'])."',".(($origination_rate[$accountid]['DESTINATION']) ? "'".$origination_rate[$accountid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$accountid]['COST']) ? "'".$origination_rate[$accountid]['COST']."'" : "'".'0'."'").",'".$parentid."',".(($origination_rate[$parentid]['CODE'] ) ? "'".$origination_rate[$parentid]['CODE']."'" : "'".'0'."'").",".(($origination_rate[$parentid]['DESTINATION']) ? "'".$origination_rate[$parentid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$parentid]['COST']) ? "'".$origination_rate[$parentid]['COST']."'" : '0').",".(($dataVariable['call_direction']) ? "'".$dataVariable['call_direction']."'" : "'internal'").",'".($dataVariable['calltype'])."'"; |
|
| 322 | + return $cdr_string = "'".($dataVariable['uuid'])."','".$accountid."','".(urldecode($callerIdNumber))."','".($dataVariable['effective_destination_number'])."','".$actual_duration."','".($dataVariable['hangup_cause'])."','".convert_to_gmt(urldecode($dataVariable['callstart']))."','".$debit."','".$cost."','".$origination_rate[$accountid]['RATEGROUP']."','".$dataVariable['package_id']."','".($origination_rate[$accountid]['CODE'])."',".(($origination_rate[$accountid]['DESTINATION']) ? "'".$origination_rate[$accountid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$accountid]['COST']) ? "'".$origination_rate[$accountid]['COST']."'" : "'".'0'."'").",'".$parentid."',".(($origination_rate[$parentid]['CODE']) ? "'".$origination_rate[$parentid]['CODE']."'" : "'".'0'."'").",".(($origination_rate[$parentid]['DESTINATION']) ? "'".$origination_rate[$parentid]['DESTINATION']."'" : "'".''."'").",".(($origination_rate[$parentid]['COST']) ? "'".$origination_rate[$parentid]['COST']."'" : '0').",".(($dataVariable['call_direction']) ? "'".$dataVariable['call_direction']."'" : "'internal'").",'".($dataVariable['calltype'])."'"; |
|
| 323 | 323 | } |
| 324 | 324 | |
| 325 | 325 | //Update user balance |
@@ -328,8 +328,8 @@ discard block |
||
| 328 | 328 | */ |
| 329 | 329 | function update_balance($user_id, $amount, $entity_id, $logger, $db) { |
| 330 | 330 | $math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+'; |
| 331 | - $query = "UPDATE accounts SET balance=balance-" . $amount . " WHERE id=" . $user_id; |
|
| 332 | - $logger->log("Balance update : " . $query); |
|
| 331 | + $query = "UPDATE accounts SET balance=balance-".$amount." WHERE id=".$user_id; |
|
| 332 | + $logger->log("Balance update : ".$query); |
|
| 333 | 333 | $db->run($query); |
| 334 | 334 | } |
| 335 | 335 | |
@@ -388,46 +388,46 @@ discard block |
||
| 388 | 388 | |
| 389 | 389 | if ($billseconds > 0) |
| 390 | 390 | { |
| 391 | - $call_cost += (ceil($billseconds/$rates['INC'])*$rates['INC'])*($rates['COST']/60); |
|
| 391 | + $call_cost += (ceil($billseconds / $rates['INC']) * $rates['INC']) * ($rates['COST'] / 60); |
|
| 392 | 392 | } |
| 393 | 393 | } |
| 394 | - $call_cost = number_format($call_cost,$decimal_points); |
|
| 394 | + $call_cost = number_format($call_cost, $decimal_points); |
|
| 395 | 395 | $logger->log("Return cost ".$call_cost); |
| 396 | 396 | return $call_cost; |
| 397 | 397 | } |
| 398 | 398 | |
| 399 | 399 | // get intial package information |
| 400 | -function package_calculation($destination_number,$pricelist_id,$duration,$call_direction,$accountid,$db,$logger) |
|
| 400 | +function package_calculation($destination_number, $pricelist_id, $duration, $call_direction, $accountid, $db, $logger) |
|
| 401 | 401 | { |
| 402 | 402 | $package_array = array(); |
| 403 | - $custom_destination = number_loop($destination_number,"patterns",$db); |
|
| 403 | + $custom_destination = number_loop($destination_number, "patterns", $db); |
|
| 404 | 404 | |
| 405 | 405 | $query = "SELECT * FROM packages as P inner join package_patterns as PKGPTR on P.id = PKGPTR.package_id WHERE ".$custom_destination." AND status = 0 AND pricelist_id = ".$pricelist_id." ORDER BY LENGTH(PKGPTR.patterns) DESC LIMIT 1"; |
| 406 | 406 | |
| 407 | 407 | $package_info = $db->run($query); |
| 408 | - if($package_info){ |
|
| 408 | + if ($package_info) { |
|
| 409 | 409 | $package_info = $package_info[0]; |
| 410 | 410 | |
| 411 | - if( ($package_info['applicable_for'] == "0" && $call_direction == "outbound") || ($package_info['applicable_for'] == "1" && $call_direction == "inbound") || ($package_info['applicable_for'] == "2") ) { |
|
| 411 | + if (($package_info['applicable_for'] == "0" && $call_direction == "outbound") || ($package_info['applicable_for'] == "1" && $call_direction == "inbound") || ($package_info['applicable_for'] == "2")) { |
|
| 412 | 412 | |
| 413 | - $counter_info = get_counters($accountid,$package_info['package_id'],$db,$logger); |
|
| 413 | + $counter_info = get_counters($accountid, $package_info['package_id'], $db, $logger); |
|
| 414 | 414 | |
| 415 | - if(!$counter_info) { |
|
| 415 | + if ( ! $counter_info) { |
|
| 416 | 416 | $Insert_Query = "INSERT INTO counters (package_id,accountid) VALUES (".$package_info['package_id'].",".$accountid.")"; |
| 417 | - $logger->log("Insert Counters : " . $Insert_query); |
|
| 417 | + $logger->log("Insert Counters : ".$Insert_query); |
|
| 418 | 418 | $db->run($Insert_Query); |
| 419 | - $counter_info = get_counters($accountid,$package_info['package_id'],$db,$logger); |
|
| 419 | + $counter_info = get_counters($accountid, $package_info['package_id'], $db, $logger); |
|
| 420 | 420 | |
| 421 | 421 | } |
| 422 | 422 | //print_r($counter_info); |
| 423 | - if ( $package_info['includedseconds'] > ($counter_info['seconds'] )) { |
|
| 423 | + if ($package_info['includedseconds'] > ($counter_info['seconds'])) { |
|
| 424 | 424 | $availableseconds = $package_info['includedseconds'] - $counter_info['seconds']; |
| 425 | 425 | $freeseconds = ($availableseconds >= $duration) ? $duration : $availableseconds; |
| 426 | 426 | $duration = ($availableseconds >= $duration) ? $duration : $availableseconds; |
| 427 | - $update_query = "UPDATE counters SET seconds = ".($counter_info['seconds'] + $freeseconds ). " WHERE id = ". $counter_info['id']; |
|
| 428 | - $logger->log("Update Counters : " . $update_query); |
|
| 427 | + $update_query = "UPDATE counters SET seconds = ".($counter_info['seconds'] + $freeseconds)." WHERE id = ".$counter_info['id']; |
|
| 428 | + $logger->log("Update Counters : ".$update_query); |
|
| 429 | 429 | $db->run($update_query); |
| 430 | - $package_array['package_id']= $package_info['package_id']; |
|
| 430 | + $package_array['package_id'] = $package_info['package_id']; |
|
| 431 | 431 | $package_array['calltype'] = "FREE"; |
| 432 | 432 | } |
| 433 | 433 | } |
@@ -436,21 +436,21 @@ discard block |
||
| 436 | 436 | } |
| 437 | 437 | |
| 438 | 438 | // Getting used package minutes in counter table |
| 439 | -function get_counters($accountid,$package_id,$db,$logger) |
|
| 439 | +function get_counters($accountid, $package_id, $db, $logger) |
|
| 440 | 440 | { |
| 441 | 441 | $query_counter = "SELECT id,seconds FROM counters WHERE accountid = ".$accountid." AND package_id = ".$package_id." AND status=1 LIMIT 1"; |
| 442 | 442 | $counter = $db->run($query_counter); |
| 443 | - $logger->log("GET Counters : " . $query_counter); |
|
| 444 | - if($counter) |
|
| 443 | + $logger->log("GET Counters : ".$query_counter); |
|
| 444 | + if ($counter) |
|
| 445 | 445 | return $counter[0]; |
| 446 | 446 | else |
| 447 | 447 | return ""; |
| 448 | 448 | } |
| 449 | 449 | |
| 450 | 450 | //Get user info |
| 451 | -function get_accounts($parent_id,$logger, $db) { |
|
| 452 | - $query = "SELECT * FROM accounts WHERE id=" . $parent_id; |
|
| 453 | - $logger->log("GET configuration : " . $query); |
|
| 451 | +function get_accounts($parent_id, $logger, $db) { |
|
| 452 | + $query = "SELECT * FROM accounts WHERE id=".$parent_id; |
|
| 453 | + $logger->log("GET configuration : ".$query); |
|
| 454 | 454 | $res_user = $db->run($query); |
| 455 | 455 | return $res_user[0]; |
| 456 | 456 | } |
@@ -460,7 +460,7 @@ discard block |
||
| 460 | 460 | { |
| 461 | 461 | $query = "SELECT name,value FROM system WHERE name='decimal_points' and group_title = 'global'"; |
| 462 | 462 | $config = $db->run($query); |
| 463 | - $logger->log("GET configuration : " . $query); |
|
| 463 | + $logger->log("GET configuration : ".$query); |
|
| 464 | 464 | return $config[0]; |
| 465 | 465 | } |
| 466 | 466 | |
@@ -468,16 +468,16 @@ discard block |
||
| 468 | 468 | /** |
| 469 | 469 | * @param string $field |
| 470 | 470 | */ |
| 471 | -function number_loop($destination,$field,$db) |
|
| 471 | +function number_loop($destination, $field, $db) |
|
| 472 | 472 | { |
| 473 | - $max_len_prefix = strlen($destination); |
|
| 473 | + $max_len_prefix = strlen($destination); |
|
| 474 | 474 | $number_prefix = '('; |
| 475 | - while ($max_len_prefix > 0) |
|
| 475 | + while ($max_len_prefix > 0) |
|
| 476 | 476 | { |
| 477 | - $number_prefix .= "$field='^".substr($destination,0,$max_len_prefix).".*' OR "; |
|
| 477 | + $number_prefix .= "$field='^".substr($destination, 0, $max_len_prefix).".*' OR "; |
|
| 478 | 478 | $max_len_prefix--; |
| 479 | 479 | } |
| 480 | - $number_prefix .= "$field='^defaultprefix.*')";//echo $number_prefix;exit; |
|
| 480 | + $number_prefix .= "$field='^defaultprefix.*')"; //echo $number_prefix;exit; |
|
| 481 | 481 | return $number_prefix; |
| 482 | 482 | } |
| 483 | 483 | |
@@ -487,6 +487,6 @@ discard block |
||
| 487 | 487 | */ |
| 488 | 488 | function convert_to_gmt($date) |
| 489 | 489 | { |
| 490 | - return gmdate('Y-m-d H:i:s', strtotime($date) ); |
|
| 490 | + return gmdate('Y-m-d H:i:s', strtotime($date)); |
|
| 491 | 491 | } |
| 492 | 492 | ?> |
