iNextrix / ASTPP

freeswitch/fs/scripts/astpp.directory.php

Spacing +1 added lines, -1 removed lines

@@ -31,7 +31,7 @@
     if ($xml == "")
         xml_not_found();
     echo $xml;
-}else {
+} else {
     xml_not_found();
 }
 $logger->log("*************************** Directory Ends **********************************");

Braces +4 added lines, -3 removed lines

@@ -28,10 +28,11 @@
 
 if (isset($_REQUEST['user']) && isset($_REQUEST['domain'])) {
 	$xml = load_directory($logger, $db);
-	if ($xml == "")
-		xml_not_found();
+	if ($xml == "") {
+			xml_not_found();
+	}
 	echo $xml;
-}else {
+} else {
 	xml_not_found();
 }
 $logger->log("*************************** Directory Ends **********************************");

web_interface/astpp/application/modules/user/views/view_user_invoices_config.php

Braces +1 added lines, -1 removed lines

@@ -208,7 +208,7 @@
 <?php
 	if($account_data['logo']  != ''){
 	     $logo=$account_data['file'];
-	}else{
+	} else{
 	     $logo=$account_data['logo'];
 	}
           if($logo != ''){        

Spacing +6 added lines, -6 removed lines

@@ -198,13 +198,13 @@
 				</div>
 		</div>	
 <?php
-	if($account_data['logo']  != ''){
-		 $logo=$account_data['file'];
-	}else{
-		 $logo=$account_data['logo'];
+	if ($account_data['logo'] != '') {
+		 $logo = $account_data['file'];
+	} else {
+		 $logo = $account_data['logo'];
 	}
-		  if($logo != ''){        
-			 $file_name= base_url()."upload/$logo";
+		  if ($logo != '') {        
+			 $file_name = base_url()."upload/$logo";
 ?>
 
 		<div class='col-md-12 no-padding'>

web_interface/astpp/application/libraries/astpp/permission.php

Braces +2 added lines, -1 removed lines

@@ -20,8 +20,9 @@
 # You should have received a copy of the GNU Affero General Public License
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
-if (!defined('BASEPATH'))
+if (!defined('BASEPATH')) {
     exit('No direct script access allowed');
+}
 
 class Refill_coupon_form {
     function __construct($library_name = '') {

Spacing +14 added lines, -14 removed lines

@@ -20,7 +20,7 @@ 
 # You should have received a copy of the GNU Affero General Public License
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
-if (!defined('BASEPATH'))
+if ( ! defined('BASEPATH'))
 	exit('No direct script access allowed');
 
 class Permission {
@@ -30,31 +30,31 @@ 
 	$this->CI->load->library('session');
 	}
 
-	  function get_module_access($user_type){
+	  function get_module_access($user_type) {
 	  $where = array("userlevelid"=>$user_type);
-	   $modules_arr = $this->CI->db_model->getSelect("module_permissions","userlevels",$where);
-	  if($modules_arr->num_rows > 0){
+	   $modules_arr = $this->CI->db_model->getSelect("module_permissions", "userlevels", $where);
+	  if ($modules_arr->num_rows > 0) {
 	$modules_arr = $modules_arr->result_array();
 	$modules_arr = $modules_arr[0]['module_permissions'];
 
-		$menu_arr = $this->CI->db_model->select("*","menu_modules","id IN ($modules_arr)","priority","asc","","","");
+		$menu_arr = $this->CI->db_model->select("*", "menu_modules", "id IN ($modules_arr)", "priority", "asc", "", "", "");
 	$menu_list = array(); 
 	$permited_modules = array();
 		$modules_seq_arr = array();
-		$modules_seq_arr = explode(",",$modules_arr);
-		$label_arr=array();
-			foreach($menu_arr->result_array() as $menu_key =>$menu_value){ 
-				   if(!isset($label_arr[$menu_value['menu_label']]) && 	$menu_value['menu_label'] != 'Configuration'){
-			$label_arr[$menu_value['menu_label']]=$menu_value['menu_label'];
-					$menu_value["menu_image"] = ($menu_value["menu_image"] == "")?"Home.png":$menu_value["menu_image"];
+		$modules_seq_arr = explode(",", $modules_arr);
+		$label_arr = array();
+			foreach ($menu_arr->result_array() as $menu_key =>$menu_value) { 
+				   if ( ! isset($label_arr[$menu_value['menu_label']]) && $menu_value['menu_label'] != 'Configuration') {
+			$label_arr[$menu_value['menu_label']] = $menu_value['menu_label'];
+					$menu_value["menu_image"] = ($menu_value["menu_image"] == "") ? "Home.png" : $menu_value["menu_image"];
 					$menu_list[$menu_value["menu_title"]][$menu_value["menu_subtitle"]][] = array("menu_label" =>trim($menu_value["menu_label"]),
-												"module_url"=>trim($menu_value["module_url"]),"module"=>trim($menu_value["module_name"]),
+												"module_url"=>trim($menu_value["module_url"]), "module"=>trim($menu_value["module_name"]),
 												"menu_image"=>trim($menu_value["menu_image"]));                    
 		   }
 				$permited_modules[] = trim($menu_value["module_name"]);
 			}                
-	 	$this->CI->session->set_userdata('permited_modules',serialize($permited_modules));
-	$this->CI->session->set_userdata('menuinfo',serialize($menu_list));
+	 	$this->CI->session->set_userdata('permited_modules', serialize($permited_modules));
+	$this->CI->session->set_userdata('menuinfo', serialize($menu_list));
   	return true;
 	  }
 	}

web_interface/astpp/application/libraries/locale.php

Braces +2 added lines, -1 removed lines

@@ -20,8 +20,9 @@
 # You should have received a copy of the GNU Affero General Public License
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
-if (!defined('BASEPATH'))
+if (!defined('BASEPATH')) {
     exit('No direct script access allowed');
+}
 
 class Refill_coupon_form {
     function __construct($library_name = '') {

Spacing +12 added lines, -12 removed lines

@@ -21,13 +21,13 @@ 
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
 
-if (!defined('BASEPATH'))
+if ( ! defined('BASEPATH'))
 	exit('No direct script access allowed');
 
 /**
  * Dynamically build forms for display
  */
-class Locale{
+class Locale {
 
 	function __construct($library_name = '') {
 
@@ -38,23 +38,23 @@ 
 		$this->CI->load->driver('cache');
 	$this->set_lang();
 	}
-	function set_lang($lang=FALSE){
+	function set_lang($lang = FALSE) {
 
-		$current_locale=$this->CI->session->userdata('user_language');
-		if(empty($current_locale)){
-			 $current_locale= 'en_US';
+		$current_locale = $this->CI->session->userdata('user_language');
+		if (empty($current_locale)) {
+			 $current_locale = 'en_US';
 		}
 	putenv("LANG=$current_locale");
 	setlocale(LC_ALL, $current_locale.".UTF-8");
-		setlocale(LC_MESSAGES,$current_locale);
+		setlocale(LC_MESSAGES, $current_locale);
 	setlocale(LC_TIME, $current_locale);
-		setlocale(LC_CTYPE,$current_locale);
-	$domain='messages';
-	$uri_segment='';
+		setlocale(LC_CTYPE, $current_locale);
+	$domain = 'messages';
+	$uri_segment = '';
 	 $uri_segment = $this->CI->uri->segments;
-	if(isset($uri_segment[1])){	
+	if (isset($uri_segment[1])) {	
 		$filename = getcwd().'/application/modules/user/language/'.$lang.'/LC_MESSAGES/messages.mo';
-				bindtextdomain(WEBSITE_DOMAIN,getcwd().'/application/modules/'.$uri_segment[1].'/language/');
+				bindtextdomain(WEBSITE_DOMAIN, getcwd().'/application/modules/'.$uri_segment[1].'/language/');
 	}
 	bind_textdomain_codeset(WEBSITE_DOMAIN, 'UTF-8');
 	textdomain(WEBSITE_DOMAIN);

web_interface/astpp/application/controllers/broadcastemail.php

Braces +3 added lines, -2 removed lines

@@ -25,8 +25,9 @@
     function __construct()
     {
 	parent::__construct();
-	if(!defined( 'CRON' ) )  
-	  exit();
+	if(!defined( 'CRON' ) ) {
+		  exit();
+	}
         $this->load->model("db_model");
         $this->load->library("astpp/common");
     }

Spacing +6 added lines, -6 removed lines

@@ -25,21 +25,21 @@
 	function __construct()
 	{
 	parent::__construct();
-	if(!defined( 'CRON' ) )  
+	if ( ! defined('CRON'))  
 	  exit();
 		$this->load->model("db_model");
 		$this->load->library("astpp/email_lib");
 	}
-	function broadcast_email(){
+	function broadcast_email() {
 	
 	   $where = array("status"=>"1");
 		$query = $this->db_model->getSelect("*", "mail_details", $where);
-		if($query->num_rows >0){
+		if ($query->num_rows > 0) {
 			$account_data = $query->result_array();
-			foreach($account_data as $data_key =>$account_value){
-			 $account_value['history_id']=$account_value['id'];
+			foreach ($account_data as $data_key =>$account_value) {
+			 $account_value['history_id'] = $account_value['id'];
 			 unset($account_value['id']);
-			 $this->email_lib->send_email('',$account_value,'',$account_value['attachment'],1,0,1);
+			 $this->email_lib->send_email('', $account_value, '', $account_value['attachment'], 1, 0, 1);
 			}
 		}
 	}

web_interface/astpp/application/controllers/lowcreditlimit.php

Braces +3 added lines, -2 removed lines

@@ -25,8 +25,9 @@
     function __construct()
     {
 	parent::__construct();
-	if(!defined( 'CRON' ) )  
-	  exit();
+	if(!defined( 'CRON' ) ) {
+		  exit();
+	}
         $this->load->model("db_model");
         $this->load->library("astpp/common");
     }

Spacing +7 added lines, -7 removed lines

@@ -25,19 +25,19 @@
 	function __construct()
 	{
 	parent::__construct();
-	if(!defined( 'CRON' ) )  
+	if ( ! defined('CRON'))  
 	  exit();
 		$this->load->model("db_model");
 		$this->load->library("astpp/common");
 	}
-	function low_creditlimit(){
-		$where = array("posttoexternal"=>1,"deleted" => "0","status"=>"0");
+	function low_creditlimit() {
+		$where = array("posttoexternal"=>1, "deleted" => "0", "status"=>"0");
 		$query = $this->db_model->getSelect("*", "accounts", $where);
-		if($query->num_rows >0){
+		if ($query->num_rows > 0) {
 			$account_data = $query->result_array();
-			foreach($account_data as $data_key =>$account_value){
-				if(($account_value["balance"]) >= $account_value["credit_limit"]){
-				  $this->common->mail_to_users("email_low_balance",$account_value);   
+			foreach ($account_data as $data_key =>$account_value) {
+				if (($account_value["balance"]) >= $account_value["credit_limit"]) {
+				  $this->common->mail_to_users("email_low_balance", $account_value);   
 				}
 			}
 		}

web_interface/astpp/application/config/config.php

Braces +2 added lines, -1 removed lines

@@ -20,8 +20,9 @@
 # You should have received a copy of the GNU Affero General Public License
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
-if (!defined('BASEPATH'))
+if (!defined('BASEPATH')) {
     exit('No direct script access allowed');
+}
 
 class Refill_coupon_form {
     function __construct($library_name = '') {

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-if (!defined('BASEPATH'))
+if ( ! defined('BASEPATH'))
 	exit('No direct script access allowed');
 
 /*

freeswitch/fs/lib/astpp.cdr.php

Doc Comments +1 added lines

@@ -256,6 +256,7 @@
 //Insert callee cdr entry for DID calls
 /**
  * @param boolean $flag_parent
+ * @param string $provider_cost
  */
 function insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$parentid,$flag_parent,$accountid,$logger,$db,$decimal_points)
 {

Braces +13 added lines, -10 removed lines

@@ -47,7 +47,7 @@ 
 	if ($dataVariable['billsec'] == 0 && $dataVariable['hangup_cause'] == 'NORMAL_CLEARING')
 	{
 		$hangup_cause = isset($dataVariable['last_bridge_hangup_cause'])?$dataVariable['last_bridge_hangup_cause']:$dataVariable['hangup_cause'];
-	}else{
+	} else{
 		$hangup_cause = $dataVariable['hangup_cause'];
 	}   
 
@@ -86,10 +86,12 @@ 
 	$actual_calltype = $dataVariable['calltype'];
 	
 	//Normalize origination and termination rates array 		   
-	if(isset($dataVariable['origination_rates']))
-	   $origination_rate = normalize_origination_rate($dataVariable['origination_rates']);
-	if(isset($dataVariable['termination_rates']))
-	   $termination_rate = normalize_rate($dataVariable['termination_rates']);
+	if(isset($dataVariable['origination_rates'])) {
+		   $origination_rate = normalize_origination_rate($dataVariable['origination_rates']);
+	}
+	if(isset($dataVariable['termination_rates'])) {
+		   $termination_rate = normalize_rate($dataVariable['termination_rates']);
+	}
 
 	//If receiver account id found then explicitly set call direction and call type 
 	if(isset($dataVariable['receiver_accid']))
@@ -441,11 +443,12 @@ 
 	$query_counter = "SELECT id,seconds FROM counters  WHERE  accountid = ".$accountid." AND package_id = ".$package_id." AND status=1 LIMIT 1";
 	$counter = $db->run($query_counter);
 	$logger->log("GET Counters  : " . $query_counter);
-	if($counter)
-		return $counter[0];	
-	else
-		return "";
-}
+	if($counter) {
+			return $counter[0];
+	} else {
+			return "";
+	}
+	}
 
 //Get user info
 function get_accounts($parent_id,$logger, $db) {

Indentation +24 added lines, -24 removed lines

@@ -159,16 +159,16 @@ 
 		$dataVariable['call_direction'] = "inbound";
 		$dataVariable['calltype'] = "DID";
 
-    //Override variables if call for DID PSTN
-    if(isset($dataVariable['caller_did_account_id']))
-    {
-        $dataVariable['receiver_accid'] = $dataVariable['caller_did_account_id'];
-    		$dataVariable['call_direction'] = "outbound";
-        $dataVariable['calltype'] = "STANDARD";
-	      $dataVariable['effective_destination_number']=$dataVariable['sip_to_user'];
-        unset($termination_rate);
-        unset($provider_cost);
-     }
+	//Override variables if call for DID PSTN
+	if(isset($dataVariable['caller_did_account_id']))
+	{
+		$dataVariable['receiver_accid'] = $dataVariable['caller_did_account_id'];
+			$dataVariable['call_direction'] = "outbound";
+		$dataVariable['calltype'] = "STANDARD";
+		  $dataVariable['effective_destination_number']=$dataVariable['sip_to_user'];
+		unset($termination_rate);
+		unset($provider_cost);
+	 }
 
         
 
@@ -316,7 +316,7 @@ 
 //Generate CDR string for insert query for reseller
 function get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost)
 {
-        $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype'];
+		$dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype'];
 	$callerIdNumber = isset($dataVariable['effective_caller_id_number']) && !empty($dataVariable['effective_caller_id_number'])? $dataVariable['effective_caller_id_number'] :$dataVariable['caller_id'];
 	
 	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'])."'";
@@ -327,27 +327,27 @@ 
  * @param integer $entity_id
  */
 function update_balance($user_id, $amount, $entity_id, $logger, $db) {
-    $math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+';
-    $query = "UPDATE accounts SET balance=balance-" . $amount . " WHERE id=" . $user_id;
-    $logger->log("Balance update : " . $query);
-    $db->run($query);
+	$math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+';
+	$query = "UPDATE accounts SET balance=balance-" . $amount . " WHERE id=" . $user_id;
+	$logger->log("Balance update : " . $query);
+	$db->run($query);
 }
 
 //Normalize rate string which we are getting from dialplan
 function normalize_rate($dataVariable)
 {
 	$rates = urldecode($dataVariable);
-    $data = explode("|", $rates);
+	$data = explode("|", $rates);
 
 	$newarray = array();
-    foreach ($data as $key => $value)
-    {
-            $data1 = explode(":", $value);
-            foreach ($data1 as $newkey => $newvalue)
-            {
-                    $newarray[$data1[0]] = $data1[$newkey];
-            }
-    }
+	foreach ($data as $key => $value)
+	{
+			$data1 = explode(":", $value);
+			foreach ($data1 as $newkey => $newvalue)
+			{
+					$newarray[$data1[0]] = $data1[$newkey];
+			}
+	}
 	return $newarray;
 }
 

Spacing +90 added lines, -90 removed lines

@@ -46,15 +46,15 @@ 
 
 	if ($dataVariable['billsec'] == 0 && $dataVariable['hangup_cause'] == 'NORMAL_CLEARING')
 	{
-		$hangup_cause = isset($dataVariable['last_bridge_hangup_cause'])?$dataVariable['last_bridge_hangup_cause']:$dataVariable['hangup_cause'];
-	}else{
+		$hangup_cause = isset($dataVariable['last_bridge_hangup_cause']) ? $dataVariable['last_bridge_hangup_cause'] : $dataVariable['hangup_cause'];
+	} else {
 		$hangup_cause = $dataVariable['hangup_cause'];
 	}   
 
 	if ($dataVariable['error_cdr'] == '1')
 	{
 		//Get actual hangup cause 
-		$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']); 
+		$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']); 
 	}
 
 	/*#### PATCH FOR ONE WAY AUDIO ####*/
@@ -65,14 +65,14 @@ 
 	/*#### ************* END *************####*/
 
 	//Don't thing this will be useful anytime. Need to remove it after testing. 
-	if($hangup_cause == "NONE")
+	if ($hangup_cause == "NONE")
 	{
 		$hangup_cause = $dataVariable['current_application_data'];
 	}
 
 	$dataVariable['hangup_cause'] = $hangup_cause;
 
-	if ( ($dataVariable['hangup_cause'] != 'NORMAL_CLEARING') && ($dataVariable['hangup_cause'] != 'ALLOTTED_TIMEOUT')) {
+	if (($dataVariable['hangup_cause'] != 'NORMAL_CLEARING') && ($dataVariable['hangup_cause'] != 'ALLOTTED_TIMEOUT')) {
 	  	$dataVariable['billsec'] = 0;
 	}
 
@@ -86,13 +86,13 @@ 
 	$actual_calltype = $dataVariable['calltype'];
 	
 	//Normalize origination and termination rates array 		   
-	if(isset($dataVariable['origination_rates']))
+	if (isset($dataVariable['origination_rates']))
 	   $origination_rate = normalize_origination_rate($dataVariable['origination_rates']);
-	if(isset($dataVariable['termination_rates']))
+	if (isset($dataVariable['termination_rates']))
 	   $termination_rate = normalize_rate($dataVariable['termination_rates']);
 
 	//If receiver account id found then explicitly set call direction and call type 
-	if(isset($dataVariable['receiver_accid']))
+	if (isset($dataVariable['receiver_accid']))
 	{
 		$dataVariable['call_direction'] = "outbound";
 		$dataVariable['calltype'] = "STANDARD";
@@ -101,23 +101,23 @@ 
 	//Check if cusotmer have any package seconds left to use
 	if ($actual_duration > 0)			
 	{
-			$package_array = package_calculation( $dataVariable['effective_destination_number'],$origination_rate[$accountid]['RATEGROUP'],$actual_duration,$dataVariable['call_direction'],$accountid,$db,$logger);
-			if(!empty($package_array))
+			$package_array = package_calculation($dataVariable['effective_destination_number'], $origination_rate[$accountid]['RATEGROUP'], $actual_duration, $dataVariable['call_direction'], $accountid, $db, $logger);
+			if ( ! empty($package_array))
 			{
 				$dataVariable['calltype'] = "FREE";
-				$dataVariable['package_id']= $package_array['package_id'];
+				$dataVariable['package_id'] = $package_array['package_id'];
 			}
 	}
 	
 	//Calculate debit of customer call 			
-	$debit = calc_cost($dataVariable,$origination_rate[$accountid],$logger,$decimal_points);
+	$debit = calc_cost($dataVariable, $origination_rate[$accountid], $logger, $decimal_points);
 
 	//Calculate cost for customer call for provider
-	$provider_cost = calc_cost($dataVariable,$termination_rate,$logger,$decimal_points);
+	$provider_cost = calc_cost($dataVariable, $termination_rate, $logger, $decimal_points);
 
 	//Calculate parent cost if customer have any parent 
-	$parent_cost = ($parentid > 0) ? calc_cost($dataVariable,$origination_rate[$parentid],$logger,$decimal_points) : $provider_cost;
-	$logger->log("Debit :".$debit ." Cost : ".$cost ." Provider Cost : ".$parent_cost);
+	$parent_cost = ($parentid > 0) ? calc_cost($dataVariable, $origination_rate[$parentid], $logger, $decimal_points) : $provider_cost;
+	$logger->log("Debit :".$debit." Cost : ".$cost." Provider Cost : ".$parent_cost);
     
 	//Initialize final cost variable to use for billing
 	$cost = ($parent_cost > 0) ? $parent_cost : $provider_cost;    
@@ -125,33 +125,33 @@ 
 	//Outbound call entry for all type of calls 
 	$logger->log("*********************** OUTBOUND CALL ENTRY START *************");
 
-	$cdr_string = get_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost,$logger);
+	$cdr_string = get_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost, $logger);
 
 	$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)";
 	$logger->log($query);
 	$db->run($query);
 	
 	//Update customer balance
-	if($debit > 0 && $dataVariable['calltype'] != "FREE")
+	if ($debit > 0 && $dataVariable['calltype'] != "FREE")
 	{
 		update_balance($accountid, $debit, 0, $logger, $db);
 	}
 
 	//Update parent or provider balance
-	if($parent_cost > 0){
+	if ($parent_cost > 0) {
 		update_balance($termination_rate['PROVIDER'], ($parent_cost * -1), 3, $logger, $db);
 	}
 
 	//Resellers CDR entry
 	$flag_parent = false;
-	insert_parent_data($dataVariable,$actual_calltype,$parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points);
+	insert_parent_data($dataVariable, $actual_calltype, $parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points);
 
 	$logger->log("*********************** OUTBOUND CALL ENTRY END *************");
 
    
 	//************ ADDING EXTRA ENTRY For local/DID Inbound call ****************************
-	$receiver_parentid=0;
-	if(isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "")
+	$receiver_parentid = 0;
+	if (isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "")
 	{
 		$logger->log("*********************** EXTRA ENTRY SECTION FOR BILLING START *************");            
 
@@ -160,12 +160,12 @@ 
 		$dataVariable['calltype'] = "DID";
 
     //Override variables if call for DID PSTN
-    if(isset($dataVariable['caller_did_account_id']))
+    if (isset($dataVariable['caller_did_account_id']))
     {
         $dataVariable['receiver_accid'] = $dataVariable['caller_did_account_id'];
     		$dataVariable['call_direction'] = "outbound";
         $dataVariable['calltype'] = "STANDARD";
-	      $dataVariable['effective_destination_number']=$dataVariable['sip_to_user'];
+	      $dataVariable['effective_destination_number'] = $dataVariable['sip_to_user'];
         unset($termination_rate);
         unset($provider_cost);
      }
@@ -173,17 +173,17 @@ 
         
 
 		//Get call receiver account information 
-		$receiver_carddata = get_accounts($dataVariable['receiver_accid'],$logger,$db);
+		$receiver_carddata = get_accounts($dataVariable['receiver_accid'], $logger, $db);
 		$receiver_parentid = $receiver_carddata['reseller_id'];
 
 		//For additional cdr entry of receiver
-		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);
+		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);
 
 		$flag_parent = true;
 		$dataVariable['uuid'] = $dataVariable['uuid'].$dataVariable['calltype']."_".$receiver_parentid;
 
 		//Insert parent reseller cdr
-		insert_parent_data($dataVariable,$actual_calltype,$receiver_parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points);
+		insert_parent_data($dataVariable, $actual_calltype, $receiver_parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points);
 		$logger->log("*********************** EXTRA ENTRY SECTION FOR BILLING END *************");            
 	}
 	//*****************************************************************************************
@@ -195,16 +195,16 @@ 
  * @param string $provider_cost
  * @param boolean $flag_parent
  */
-function insert_parent_data($dataVariable,$actual_calltype,$parentid,$origination_rate,$actual_duration,$provider_cost,$flag_parent,$logger,$db,$decimal_points)
+function insert_parent_data($dataVariable, $actual_calltype, $parentid, $origination_rate, $actual_duration, $provider_cost, $flag_parent, $logger, $db, $decimal_points)
 {
-	while($parentid > 0 )
+	while ($parentid > 0)
 	{
 		$logger->log("*************** IN PARENT DATA SECTION ********");
 		$dataVariable['calltype'] = $actual_calltype;
-		$carddata = get_accounts($parentid,$logger,$db);
+		$carddata = get_accounts($parentid, $logger, $db);
 		$accountid = $carddata['id'];
 
-		$debit = calc_cost($dataVariable,$origination_rate[$accountid],$logger,$decimal_points);
+		$debit = calc_cost($dataVariable, $origination_rate[$accountid], $logger, $decimal_points);
 
 		//If receiver account id found then explicitly set call direction and call type
 		/*if(isset($dataVariable['receiver_accid']))
@@ -214,31 +214,31 @@ 
         }*/
 
 		//Check if reseller have any package seconds left to use        
-		if ($actual_duration > 0)		{
-			$package_array = package_calculation( $dataVariable['effective_destination_number'],$origination_rate[$accountid]['RATEGROUP'],$actual_duration,$dataVariable['call_direction'],$accountid,$db,$logger);
-			if(!empty($package_array))
+		if ($actual_duration > 0) {
+			$package_array = package_calculation($dataVariable['effective_destination_number'], $origination_rate[$accountid]['RATEGROUP'], $actual_duration, $dataVariable['call_direction'], $accountid, $db, $logger);
+			if ( ! empty($package_array))
 			{
 				$dataVariable['calltype'] = "FREE";
-				$dataVariable['package_id']= $package_array['package_id'];
+				$dataVariable['package_id'] = $package_array['package_id'];
 			}
 		}	
 
 		//Get parent id for cost calculation 
 		$parentid = $carddata['reseller_id'];
-		$parent_cost = ($parentid > 0) ? calc_cost($dataVariable,$origination_rate[$parentid],$logger,$decimal_points) : $provider_cost;
+		$parent_cost = ($parentid > 0) ? calc_cost($dataVariable, $origination_rate[$parentid], $logger, $decimal_points) : $provider_cost;
 		$cost = ($parent_cost > 0) ? $parent_cost : $provider_cost;
 	
-		if(isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "" && $flag_parent == true)
+		if (isset($dataVariable['receiver_accid']) && $dataVariable['receiver_accid'] != "" && $flag_parent == true)
 		{
 			$logger->log("********* IN RESELLER FOR RECEIVER ENTRY START ******");
 			$flag_parent = true;
-			insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$parentid,$flag_parent,$accountid,$logger,$db,$decimal_points);
+			insert_extra_receiver_entry($dataVariable, $origination_rate, $termination_rate, $account_type, $actual_duration, $provider_cost, $parentid, $flag_parent, $accountid, $logger, $db, $decimal_points);
 			$logger->log("********* IN RESELLER FOR RECEIVER ENTRY END ******");
 			return true;	
 
-		} else{
+		} else {
 
-			$cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost);	
+			$cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost);	
 
  			$query = "INSERT INTO reseller_cdrs (uniqueid,accountid,callerid,callednum,billseconds,disposition,callstart,debit,cost,pricelist_id,package_id,pattern,notes,rate_cost,
 		reseller_id,reseller_code,reseller_code_destination,reseller_cost,call_direction,calltype) values ($cdr_string)";
@@ -259,38 +259,38 @@ 
 /**
  * @param boolean $flag_parent
  */
-function insert_extra_receiver_entry($dataVariable,$origination_rate,$termination_rate,$account_type,$actual_duration,$provider_cost,$parentid,$flag_parent,$accountid,$logger,$db,$decimal_points)
+function insert_extra_receiver_entry($dataVariable, $origination_rate, $termination_rate, $account_type, $actual_duration, $provider_cost, $parentid, $flag_parent, $accountid, $logger, $db, $decimal_points)
 {
 		$localVariable = $dataVariable;
 		$localVariable['call_direction'] = "inbound";
 		$localVariable['uuid'] = $localVariable['uuid'].$dataVariable['calltype']."_".$accountid;
 		
-		if($dataVariable['calltype'] == "LOCAL")
+		if ($dataVariable['calltype'] == "LOCAL")
 		{
 			$origination_rate[$accountid]['CODE'] = $dataVariable['effective_destination_number'];
 			$origination_rate[$accountid]['DESTINATION'] = $dataVariable['calltype'];
-			if($flag_parent == false){
-				$cdr_string = get_cdr_string($localVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,0,0,$logger);
-			} else{
-				$cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost);
+			if ($flag_parent == false) {
+				$cdr_string = get_cdr_string($localVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, 0, 0, $logger);
+			} else {
+				$cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost);
 			}
-		} else{
+		} else {
 
 			$origination_rate_did = normalize_origination_rate($dataVariable['origination_rates_did']);
-			$debit = calc_cost($dataVariable,$origination_rate_did[$accountid],$logger,$decimal_points);
+			$debit = calc_cost($dataVariable, $origination_rate_did[$accountid], $logger, $decimal_points);
 
-			if($flag_parent == false){
+			if ($flag_parent == false) {
 				
-				$cdr_string = get_cdr_string($localVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate_did,$provider_cost,$parentid,$debit,0,$logger);
-			} else{
-				$cdr_string = get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost);
+				$cdr_string = get_cdr_string($localVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate_did, $provider_cost, $parentid, $debit, 0, $logger);
+			} else {
+				$cdr_string = get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost);
 			}
 		}
 	  
-		if($flag_parent == false)
+		if ($flag_parent == false)
 		{
 			$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)";
-		} else{
+		} else {
 			$query = "INSERT INTO reseller_cdrs (uniqueid,accountid,callerid,callednum,billseconds,disposition,callstart,debit,cost,pricelist_id,package_id,pattern,notes,rate_cost,
 	reseller_id,reseller_code,reseller_code_destination,reseller_cost,call_direction,calltype) values ($cdr_string)";
 		}
@@ -306,20 +306,20 @@ 
 }
 
 //Generate CDR string for insert query for customer.
-function get_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost,$logger)
+function get_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost, $logger)
 {
-   	$dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype'];
-		$callerIdNumber = isset($dataVariable['effective_caller_id_number']) && !empty($dataVariable['effective_caller_id_number'])? $dataVariable['effective_caller_id_number'] :$dataVariable['caller_id'];
-		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']."'";
+   	$dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER') ? "DID" : $dataVariable['calltype'];
+		$callerIdNumber = isset($dataVariable['effective_caller_id_number']) && ! empty($dataVariable['effective_caller_id_number']) ? $dataVariable['effective_caller_id_number'] : $dataVariable['caller_id'];
+		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']."'";
 }
 
 //Generate CDR string for insert query for reseller
-function get_reseller_cdr_string($dataVariable,$accountid,$account_type,$actual_duration,$termination_rate,$origination_rate,$provider_cost,$parentid,$debit,$cost)
+function get_reseller_cdr_string($dataVariable, $accountid, $account_type, $actual_duration, $termination_rate, $origination_rate, $provider_cost, $parentid, $debit, $cost)
 {
-        $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER')?"DID":$dataVariable['calltype'];
-	$callerIdNumber = isset($dataVariable['effective_caller_id_number']) && !empty($dataVariable['effective_caller_id_number'])? $dataVariable['effective_caller_id_number'] :$dataVariable['caller_id'];
+        $dataVariable['calltype'] = ($dataVariable['calltype'] == 'DID-LOCAL' || $dataVariable['calltype'] == 'SIP-DID' || $dataVariable['calltype'] == 'OTHER') ? "DID" : $dataVariable['calltype'];
+	$callerIdNumber = isset($dataVariable['effective_caller_id_number']) && ! empty($dataVariable['effective_caller_id_number']) ? $dataVariable['effective_caller_id_number'] : $dataVariable['caller_id'];
 	
-	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'])."'";
+	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'])."'";
 }
 
 //Update user balance
@@ -328,8 +328,8 @@ 
  */
 function update_balance($user_id, $amount, $entity_id, $logger, $db) {
     $math_sign = ($entity_id == 0 || $entity_id == 1) ? '-' : '+';
-    $query = "UPDATE accounts SET balance=balance-" . $amount . " WHERE id=" . $user_id;
-    $logger->log("Balance update : " . $query);
+    $query = "UPDATE accounts SET balance=balance-".$amount." WHERE id=".$user_id;
+    $logger->log("Balance update : ".$query);
     $db->run($query);
 }
 
@@ -388,46 +388,46 @@ 
     
 			if ($billseconds > 0)
 			{
-				$call_cost += (ceil($billseconds/$rates['INC'])*$rates['INC'])*($rates['COST']/60);
+				$call_cost += (ceil($billseconds / $rates['INC']) * $rates['INC']) * ($rates['COST'] / 60);
 			}
 	}
-	$call_cost = number_format($call_cost,$decimal_points);
+	$call_cost = number_format($call_cost, $decimal_points);
 	$logger->log("Return cost ".$call_cost);
 	return $call_cost;
 }
 
 // get intial package information
-function package_calculation($destination_number,$pricelist_id,$duration,$call_direction,$accountid,$db,$logger)
+function package_calculation($destination_number, $pricelist_id, $duration, $call_direction, $accountid, $db, $logger)
 {
 	$package_array = array();
-	$custom_destination = number_loop($destination_number,"patterns",$db);
+	$custom_destination = number_loop($destination_number, "patterns", $db);
 
 	$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";
 
 	$package_info = $db->run($query);
-	if($package_info){
+	if ($package_info) {
 		$package_info = $package_info[0];
 
-		if( ($package_info['applicable_for'] == "0" && $call_direction == "outbound") || ($package_info['applicable_for'] == "1" && $call_direction == "inbound") || ($package_info['applicable_for'] == "2") ) {
+		if (($package_info['applicable_for'] == "0" && $call_direction == "outbound") || ($package_info['applicable_for'] == "1" && $call_direction == "inbound") || ($package_info['applicable_for'] == "2")) {
 	
-			$counter_info =  get_counters($accountid,$package_info['package_id'],$db,$logger);
+			$counter_info = get_counters($accountid, $package_info['package_id'], $db, $logger);
 
-			if(!$counter_info) {
+			if ( ! $counter_info) {
 				$Insert_Query = "INSERT INTO counters (package_id,accountid) VALUES (".$package_info['package_id'].",".$accountid.")";		
-				$logger->log("Insert Counters  : " . $Insert_query);
+				$logger->log("Insert Counters  : ".$Insert_query);
 				$db->run($Insert_Query);
-				$counter_info =  get_counters($accountid,$package_info['package_id'],$db,$logger);
+				$counter_info = get_counters($accountid, $package_info['package_id'], $db, $logger);
 				
 			}	
 			//print_r($counter_info);
-			if ( $package_info['includedseconds'] > ($counter_info['seconds'] )) {
+			if ($package_info['includedseconds'] > ($counter_info['seconds'])) {
 				$availableseconds = $package_info['includedseconds'] - $counter_info['seconds'];
 				$freeseconds = ($availableseconds >= $duration) ? $duration : $availableseconds;
 				$duration = ($availableseconds >= $duration) ? $duration : $availableseconds;
-				$update_query = "UPDATE counters SET seconds = ".($counter_info['seconds'] + $freeseconds ). " WHERE id = ". $counter_info['id'];
-				$logger->log("Update Counters  : " . $update_query);
+				$update_query = "UPDATE counters SET seconds = ".($counter_info['seconds'] + $freeseconds)." WHERE id = ".$counter_info['id'];
+				$logger->log("Update Counters  : ".$update_query);
 				$db->run($update_query);
-				$package_array['package_id']= $package_info['package_id'];
+				$package_array['package_id'] = $package_info['package_id'];
 				$package_array['calltype'] = "FREE";
 			}						
 		} 
@@ -436,21 +436,21 @@ 
 } 
 
 // Getting used package minutes in counter table
-function get_counters($accountid,$package_id,$db,$logger)
+function get_counters($accountid, $package_id, $db, $logger)
 {
 	$query_counter = "SELECT id,seconds FROM counters  WHERE  accountid = ".$accountid." AND package_id = ".$package_id." AND status=1 LIMIT 1";
 	$counter = $db->run($query_counter);
-	$logger->log("GET Counters  : " . $query_counter);
-	if($counter)
+	$logger->log("GET Counters  : ".$query_counter);
+	if ($counter)
 		return $counter[0];	
 	else
 		return "";
 }
 
 //Get user info
-function get_accounts($parent_id,$logger, $db) {
-	$query = "SELECT * FROM accounts WHERE id=" . $parent_id;
-	$logger->log("GET configuration  : " . $query);
+function get_accounts($parent_id, $logger, $db) {
+	$query = "SELECT * FROM accounts WHERE id=".$parent_id;
+	$logger->log("GET configuration  : ".$query);
 	$res_user = $db->run($query);
 	return $res_user[0];
 }
@@ -460,7 +460,7 @@ 
 {
 	$query = "SELECT name,value FROM system WHERE name='decimal_points' and group_title = 'global'";
 	$config = $db->run($query);
-	$logger->log("GET configuration  : " . $query);
+	$logger->log("GET configuration  : ".$query);
 	return $config[0];
 }
 
@@ -468,16 +468,16 @@ 
 /**
  * @param string $field
  */
-function number_loop($destination,$field,$db)
+function number_loop($destination, $field, $db)
 {
-	$max_len_prefix  = strlen($destination);
+	$max_len_prefix = strlen($destination);
 	$number_prefix = '(';
-	while ($max_len_prefix  > 0)
+	while ($max_len_prefix > 0)
 	{
-		$number_prefix .= "$field='^".substr($destination,0,$max_len_prefix).".*' OR ";
+		$number_prefix .= "$field='^".substr($destination, 0, $max_len_prefix).".*' OR ";
 		$max_len_prefix--;
 	}
-	$number_prefix .= "$field='^defaultprefix.*')";//echo $number_prefix;exit;
+	$number_prefix .= "$field='^defaultprefix.*')"; //echo $number_prefix;exit;
 	return $number_prefix;
 }
 
@@ -487,6 +487,6 @@ 
  */
 function convert_to_gmt($date)
 {
-	return gmdate('Y-m-d H:i:s', strtotime($date) );
+	return gmdate('Y-m-d H:i:s', strtotime($date));
 }
 ?>

web_interface/astpp/application/controllers/generateInvoice.php

Doc Comments +4 added lines

@@ -115,6 +115,10 @@
         $this->process_invoice($account_value, $start_date, $end_date);
     }
 
+    /**
+     * @param string $start_date
+     * @param string $end_date
+     */
     function process_invoice($accountdata, $start_date, $end_date) {
         //Get Invoice configuration using single query instead of multiple queries.
         $invoice_conf = array();

Indentation +234 added lines, -234 removed lines

@@ -24,264 +24,264 @@
 
 class GenerateInvoice extends MX_Controller {
 
-    public static $global_config;
+	public static $global_config;
 
-    function __construct() {
-        parent::__construct();
-        $this->load->model("db_model");
-        $this->load->library("astpp/common");
-        $this->load->library('html2pdf');
-        ini_set("memory_limit", "2048M");
-        ini_set("max_execution_time", "259200");
-        $this->get_system_config();
-    }
+	function __construct() {
+		parent::__construct();
+		$this->load->model("db_model");
+		$this->load->library("astpp/common");
+		$this->load->library('html2pdf');
+		ini_set("memory_limit", "2048M");
+		ini_set("max_execution_time", "259200");
+		$this->get_system_config();
+	}
 
-    function get_system_config() {
-        $query = $this->db->get("system");
-        $config = array();
-        $result = $query->result_array();
-        foreach ($result as $row) {
-            $config[$row['name']] = $row['value'];
-        }
-        self::$global_config['system_config'] = $config;
-    }
+	function get_system_config() {
+		$query = $this->db->get("system");
+		$config = array();
+		$result = $query->result_array();
+		foreach ($result as $row) {
+			$config[$row['name']] = $row['value'];
+		}
+		self::$global_config['system_config'] = $config;
+	}
 
-    function getInvoiceData() {
-        $where = array("posttoexternal" => 1, "deleted" => "0", "status" => "0");
-        $query = $this->db_model->getSelect("*", "accounts", $where);
-        if ($query->num_rows > 0) {
-            $account_data = $query->result_array();
-            foreach ($account_data as $data_key => $account_value) {
-                $end_date = gmdate("Y-m-d")." 23:59:59";
-                $account_value['sweep_id'] = (int)$account_value['sweep_id'];
-                switch ($account_value['sweep_id']) {
-                    case 0:
-                        $start_date = $this->validate_invoice_date($account_value);
-                        if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
-                            $start_date = gmdate("Y-m-d H:i:s");
-                        }
-                        $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 days"));
-                        $this->Generate_Daily_invoice($account_value, $start_date, $end_date);
-                        break;
-                    case 2:
-                        if (date("d") == $account_value['invoice_day']) {
-                            $start_date = $this->validate_invoice_date($account_value);
-                            if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
-                                $start_date = gmdate("Y-m-d H:i:s");
-                            }
-                            $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 month"));
-                            $this->Generate_Monthly_invoice($account_value, $start_date, $end_date);
-                        }
-                        break;
-                }
-            }
-            $screen_path = getcwd()."/cron";
-            $screen_filename = "Email_Broadcast_".strtotime('now');
-            $command = "cd ".$screen_path." && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
-            exec($command);
-        }
-    }
+	function getInvoiceData() {
+		$where = array("posttoexternal" => 1, "deleted" => "0", "status" => "0");
+		$query = $this->db_model->getSelect("*", "accounts", $where);
+		if ($query->num_rows > 0) {
+			$account_data = $query->result_array();
+			foreach ($account_data as $data_key => $account_value) {
+				$end_date = gmdate("Y-m-d")." 23:59:59";
+				$account_value['sweep_id'] = (int)$account_value['sweep_id'];
+				switch ($account_value['sweep_id']) {
+					case 0:
+						$start_date = $this->validate_invoice_date($account_value);
+						if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
+							$start_date = gmdate("Y-m-d H:i:s");
+						}
+						$end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 days"));
+						$this->Generate_Daily_invoice($account_value, $start_date, $end_date);
+						break;
+					case 2:
+						if (date("d") == $account_value['invoice_day']) {
+							$start_date = $this->validate_invoice_date($account_value);
+							if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
+								$start_date = gmdate("Y-m-d H:i:s");
+							}
+							$end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 month"));
+							$this->Generate_Monthly_invoice($account_value, $start_date, $end_date);
+						}
+						break;
+				}
+			}
+			$screen_path = getcwd()."/cron";
+			$screen_filename = "Email_Broadcast_".strtotime('now');
+			$command = "cd ".$screen_path." && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
+			exec($command);
+		}
+	}
 
-    function validate_invoice_date($account_value) {
-        $last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"], $account_value['reseller_id'], "to_date");
-        $last_invoice_date = ($last_invoice_date) ? $last_invoice_date : $account_value['creation'];
-        $last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("+1 Second", strtotime($last_invoice_date)));
-        return $last_invoice_date;
-    }
+	function validate_invoice_date($account_value) {
+		$last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"], $account_value['reseller_id'], "to_date");
+		$last_invoice_date = ($last_invoice_date) ? $last_invoice_date : $account_value['creation'];
+		$last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("+1 Second", strtotime($last_invoice_date)));
+		return $last_invoice_date;
+	}
 
-    /**
-     * @param string $start_date
-     * @param string $end_date
-     */
-    function Generate_Daily_invoice($account_value, $start_date, $end_date) {
-        //  echo "INVOICE SCRIPT-------start date :".$start_date."-------end date....".$end_date;
+	/**
+	 * @param string $start_date
+	 * @param string $end_date
+	 */
+	function Generate_Daily_invoice($account_value, $start_date, $end_date) {
+		//  echo "INVOICE SCRIPT-------start date :".$start_date."-------end date....".$end_date;
 
-        require_once('updateBalance.php');
-        $updateBalance = new updateBalance();
-        $updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
-        $updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE);
-        $this->process_invoice($account_value, $start_date, $end_date);
-    }
+		require_once('updateBalance.php');
+		$updateBalance = new updateBalance();
+		$updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
+		$updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE);
+		$this->process_invoice($account_value, $start_date, $end_date);
+	}
 
-    /**
-     * @param string $start_date
-     * @param string $end_date
-     */
-    function Generate_Monthly_invoice($account_value, $start_date, $end_date) {
-        require_once('updateBalance.php');
-        $updateBalance = new updateBalance();
-        $updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
-        $updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE); 
-        $this->process_invoice($account_value, $start_date, $end_date);
-    }
+	/**
+	 * @param string $start_date
+	 * @param string $end_date
+	 */
+	function Generate_Monthly_invoice($account_value, $start_date, $end_date) {
+		require_once('updateBalance.php');
+		$updateBalance = new updateBalance();
+		$updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
+		$updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE); 
+		$this->process_invoice($account_value, $start_date, $end_date);
+	}
 
-    function process_invoice($accountdata, $start_date, $end_date) {
-        //Get Invoice configuration using single query instead of multiple queries.
-        $invoice_conf = array();
-        $reseller_id = ($accountdata['reseller_id'] == 0) ? 1 : $accountdata['reseller_id'];
-        $where = "accountid IN ('".$reseller_id."','1')";
-        $this->db->select('*');
-        $this->db->where($where);
-        $this->db->order_by('accountid', 'desc');
-        $this->db->limit(1);
-        $invoice_conf = $this->db->get('invoice_conf');
-        $invoice_conf = (array)$invoice_conf->first_row();
-        /*******************************************************/
-        $last_invoice_ID = $this->common->get_invoice_date("invoiceid", "", $accountdata['reseller_id']);
-        if ($last_invoice_ID && $last_invoice_ID > 0) {
-            $last_invoice_ID = ($last_invoice_ID + 1);
-        } else {
-            $last_invoice_ID = $invoice_conf['invoice_start_from'];
-        }
-        $last_invoice_ID = str_pad($last_invoice_ID, (strlen($last_invoice_ID) + 4), '0', STR_PAD_LEFT);
-        $invoice_sub_total = $this->count_invoice_data($accountdata, $start_date, $end_date);
-        if ($invoice_sub_total > 0) {
-            $invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
-            $this->update_cdrs_data($accountdata['id'], $invoiceid, $start_date, $end_date);
-            $sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
-            $invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
-            $this->download_invoice($invoiceid, $accountdata, $invoice_conf);
-        } else {
-            $invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
-            $sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
-            $invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
-        }
-    }
+	function process_invoice($accountdata, $start_date, $end_date) {
+		//Get Invoice configuration using single query instead of multiple queries.
+		$invoice_conf = array();
+		$reseller_id = ($accountdata['reseller_id'] == 0) ? 1 : $accountdata['reseller_id'];
+		$where = "accountid IN ('".$reseller_id."','1')";
+		$this->db->select('*');
+		$this->db->where($where);
+		$this->db->order_by('accountid', 'desc');
+		$this->db->limit(1);
+		$invoice_conf = $this->db->get('invoice_conf');
+		$invoice_conf = (array)$invoice_conf->first_row();
+		/*******************************************************/
+		$last_invoice_ID = $this->common->get_invoice_date("invoiceid", "", $accountdata['reseller_id']);
+		if ($last_invoice_ID && $last_invoice_ID > 0) {
+			$last_invoice_ID = ($last_invoice_ID + 1);
+		} else {
+			$last_invoice_ID = $invoice_conf['invoice_start_from'];
+		}
+		$last_invoice_ID = str_pad($last_invoice_ID, (strlen($last_invoice_ID) + 4), '0', STR_PAD_LEFT);
+		$invoice_sub_total = $this->count_invoice_data($accountdata, $start_date, $end_date);
+		if ($invoice_sub_total > 0) {
+			$invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
+			$this->update_cdrs_data($accountdata['id'], $invoiceid, $start_date, $end_date);
+			$sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
+			$invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
+			$this->download_invoice($invoiceid, $accountdata, $invoice_conf);
+		} else {
+			$invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
+			$sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
+			$invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
+		}
+	}
 
-    function count_invoice_data($account, $start_date = "", $end_date = "") {
-        $cdr_query = "";
-        $inv_data_query = "";
-        $cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = ".$account['id'];
-        $cdr_query .= " AND callstart >='".$start_date."' AND callstart <= '".$end_date."' AND invoiceid=0 group by calltype";
+	function count_invoice_data($account, $start_date = "", $end_date = "") {
+		$cdr_query = "";
+		$inv_data_query = "";
+		$cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = ".$account['id'];
+		$cdr_query .= " AND callstart >='".$start_date."' AND callstart <= '".$end_date."' AND invoiceid=0 group by calltype";
 //echo $cdr_query; 
-        $cdr_data = $this->db->query($cdr_query);
-        if ($cdr_data->num_rows > 0) {
-            $cdr_data = $cdr_data->result_array();
-            //echo '<pre>'; print_r($cdr_data); exit;
-            foreach ($cdr_data as $cdrvalue) {
-                $cdrvalue['debit'] = round($cdrvalue['debit'], self::$global_config['system_config']['decimalpoints']);
-                $tempArr = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "item_id" => "0",
-                    "description" => $cdrvalue['calltype']." CALLS for the period (".$start_date." to ".$end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
-                $this->db->insert("invoice_details", $tempArr);
-            }
-        }
-        $inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=".$account['id']." AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type != 'FREECALL'";
+		$cdr_data = $this->db->query($cdr_query);
+		if ($cdr_data->num_rows > 0) {
+			$cdr_data = $cdr_data->result_array();
+			//echo '<pre>'; print_r($cdr_data); exit;
+			foreach ($cdr_data as $cdrvalue) {
+				$cdrvalue['debit'] = round($cdrvalue['debit'], self::$global_config['system_config']['decimalpoints']);
+				$tempArr = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "item_id" => "0",
+					"description" => $cdrvalue['calltype']." CALLS for the period (".$start_date." to ".$end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
+				$this->db->insert("invoice_details", $tempArr);
+			}
+		}
+		$inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=".$account['id']." AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type != 'FREECALL'";
 //echo $inv_data_query;         
-        $invoice_data = $this->db->query($inv_data_query);
-        if ($invoice_data->num_rows > 0) {
-            $invoice_data = $invoice_data->result_array();
-            foreach ($invoice_data as $data_value) {
-                if ($data_value['count'] > 0) {
-                    $sub_total = ($data_value['debit'] - $data_value['credit']);
-                    $sub_total = round($sub_total, self::$global_config['system_config']['decimalpoints']);
-                    return $sub_total;
-                }
-            }
-        }
-        return "0";
-    }
+		$invoice_data = $this->db->query($inv_data_query);
+		if ($invoice_data->num_rows > 0) {
+			$invoice_data = $invoice_data->result_array();
+			foreach ($invoice_data as $data_value) {
+				if ($data_value['count'] > 0) {
+					$sub_total = ($data_value['debit'] - $data_value['credit']);
+					$sub_total = round($sub_total, self::$global_config['system_config']['decimalpoints']);
+					return $sub_total;
+				}
+			}
+		}
+		return "0";
+	}
 
-    //Change Order of arguements
-    function update_cdrs_data($accountid, $invoiceid, $start_date = "", $end_date = "") {
-        $inv_data_query = "update invoice_details SET invoiceid = '".$invoiceid."' where accountid=".$accountid;
-        $inv_data_query .= " AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type !='PAYMENT'";
-        $this->db->query($inv_data_query);
-        return true;
-    }
+	//Change Order of arguements
+	function update_cdrs_data($accountid, $invoiceid, $start_date = "", $end_date = "") {
+		$inv_data_query = "update invoice_details SET invoiceid = '".$invoiceid."' where accountid=".$accountid;
+		$inv_data_query .= " AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type !='PAYMENT'";
+		$this->db->query($inv_data_query);
+		return true;
+	}
 
-    /**
-     * @param string $last_invoice_ID
-     */
-    function create_invoice($account, $from_date, $to_date, $last_invoice_ID, $INVprefix, $invoiceconf) {
-        //$due_date = gmdate("Y-m-d H:i:s",strtotime($to_date." +".$invoiceconf['interval']." days"));
-        if ($invoiceconf['interval'] > 0) {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));
-        } else {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +7 days"));
-        }
-        // echo "due daye-------".$due_date.'----------'.$to_date.'------------> Invoice interval'.$invoiceconf['interval']; 
-        $balance = ($account['credit_limit'] - $account['balance']);
-        $automatic_flag = self::$global_config['system_config']['automatic_invoice'];
+	/**
+	 * @param string $last_invoice_ID
+	 */
+	function create_invoice($account, $from_date, $to_date, $last_invoice_ID, $INVprefix, $invoiceconf) {
+		//$due_date = gmdate("Y-m-d H:i:s",strtotime($to_date." +".$invoiceconf['interval']." days"));
+		if ($invoiceconf['interval'] > 0) {
+			$due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));
+		} else {
+			$due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +7 days"));
+		}
+		// echo "due daye-------".$due_date.'----------'.$to_date.'------------> Invoice interval'.$invoiceconf['interval']; 
+		$balance = ($account['credit_limit'] - $account['balance']);
+		$automatic_flag = self::$global_config['system_config']['automatic_invoice'];
 	if ($automatic_flag == 1) {
-	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
-            $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance);
+			$invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
+			$account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance);
 	} else {
-	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
-            $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance, "confirm" => 1);
+			$invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
+			$account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance, "confirm" => 1);
 	}
-        // echo "<pre>"; print_r($invoice_data); exit;
-        $this->db->insert("invoices", $invoice_data);
-        $invoiceid = $this->db->insert_id();
+		// echo "<pre>"; print_r($invoice_data); exit;
+		$this->db->insert("invoices", $invoice_data);
+		$invoiceid = $this->db->insert_id();
 	if ($automatic_flag == 0) {
-            $this->download_invoice($invoiceid, $account, $invoiceconf);
+			$this->download_invoice($invoiceid, $account, $invoiceconf);
+	}
+		return $invoiceid;
 	}
-        return $invoiceid;
-    }
 
-    function set_invoice_total($invoiceid, $accountid) {
-        $query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid, "item_type <>" => "FREECALL"));
-        $query = $query->result_array();
-        $sub_total = $query["0"]["total"];
-        $updateArr = array("amount" => $sub_total);
-        $this->db->where(array("id" => $invoiceid));
-        $this->db->update("invoices", $updateArr);
+	function set_invoice_total($invoiceid, $accountid) {
+		$query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid, "item_type <>" => "FREECALL"));
+		$query = $query->result_array();
+		$sub_total = $query["0"]["total"];
+		$updateArr = array("amount" => $sub_total);
+		$this->db->where(array("id" => $invoiceid));
+		$this->db->update("invoices", $updateArr);
 
-        $updateArr = array("balance" => "0.00");
-        $this->db->where(array("id" => $accountid));
-        $this->db->update("accounts", $updateArr);
+		$updateArr = array("balance" => "0.00");
+		$this->db->where(array("id" => $accountid));
+		$this->db->update("accounts", $updateArr);
 
-        return true;
-    }
+		return true;
+	}
 
-    function download_invoice($invoiceid, $accountdata, $invoice_conf) {
-        $invoicedata = $this->db_model->getSelect("*", "invoices", array("id" => $invoiceid));
-        $invoicedata = $invoicedata->result_array();
-        $invoicedata = $invoicedata[0];
-        $FilePath = FCPATH."invoices/".$accountdata["id"].'/'.$invoicedata['invoice_prefix']."".$invoicedata['invoiceid']."_invoice.pdf";
-        $Filenm = $invoicedata['invoice_prefix']."_".$invoicedata['invoiceid']."_invoice.pdf";
-        $this->common->get_invoice_template($invoicedata, $accountdata, false);
-        if ($invoice_conf['invoice_notification']) {
-            $this->send_email_notification($FilePath, $Filenm, $accountdata, $invoice_conf, $invoicedata);
-        }
-    }
+	function download_invoice($invoiceid, $accountdata, $invoice_conf) {
+		$invoicedata = $this->db_model->getSelect("*", "invoices", array("id" => $invoiceid));
+		$invoicedata = $invoicedata->result_array();
+		$invoicedata = $invoicedata[0];
+		$FilePath = FCPATH."invoices/".$accountdata["id"].'/'.$invoicedata['invoice_prefix']."".$invoicedata['invoiceid']."_invoice.pdf";
+		$Filenm = $invoicedata['invoice_prefix']."_".$invoicedata['invoiceid']."_invoice.pdf";
+		$this->common->get_invoice_template($invoicedata, $accountdata, false);
+		if ($invoice_conf['invoice_notification']) {
+			$this->send_email_notification($FilePath, $Filenm, $accountdata, $invoice_conf, $invoicedata);
+		}
+	}
 
-    /**
-     * @param string $FilePath
-     * @param string $Filenm
-     */
-    function send_email_notification($FilePath, $Filenm, $AccountData, $invoice_conf, $invData) {
-        $TemplateData = array();
-        $where = array('name' => 'email_new_invoice');
-        $EmailTemplate = $this->db_model->getSelect("*", "default_templates", $where);
-        foreach ($EmailTemplate->result_array() as $TemplateVal) {
-            $TemplateData = $TemplateVal;
-            $TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['subject']);
-            $TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['subject']);
-            $TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace('#AMOUNT#', $invData['amount'], $TemplateData['template']);
+	/**
+	 * @param string $FilePath
+	 * @param string $Filenm
+	 */
+	function send_email_notification($FilePath, $Filenm, $AccountData, $invoice_conf, $invData) {
+		$TemplateData = array();
+		$where = array('name' => 'email_new_invoice');
+		$EmailTemplate = $this->db_model->getSelect("*", "default_templates", $where);
+		foreach ($EmailTemplate->result_array() as $TemplateVal) {
+			$TemplateData = $TemplateVal;
+			$TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['subject']);
+			$TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['subject']);
+			$TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace('#AMOUNT#', $invData['amount'], $TemplateData['template']);
 
-            $TemplateData['template'] = str_replace("#COMPANY_EMAIL#", $invoice_conf['emailaddress'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#COMPANY_NAME#", $invoice_conf['company_name'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#COMPANY_WEBSITE#", $invoice_conf['website'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#INVOICE_DATE#", $invData['invoice_date'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#DUE_DATE#", $invData['due_date'], $TemplateData['template']);
-        }
-        $dir_path = getcwd()."/attachments/";
-        $path = $dir_path.$Filenm;
-        $command = "cp ".$FilePath." ".$path;
-        exec($command);
-        $email_array = array('accountid' => $AccountData['id'],
-            'subject' => $TemplateData['subject'],
-            'body' => $TemplateData['template'],
-            'from' => $invoice_conf['emailaddress'],
-            'to' => $AccountData['email'],
-            'status' => "1",
-            'attachment' => $Filenm,
-            'template' => '');
-        //echo "<pre>"; print_r($TemplateData); exit;
-        $this->db->insert("mail_details", $email_array);
-    }
+			$TemplateData['template'] = str_replace("#COMPANY_EMAIL#", $invoice_conf['emailaddress'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#COMPANY_NAME#", $invoice_conf['company_name'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#COMPANY_WEBSITE#", $invoice_conf['website'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#INVOICE_DATE#", $invData['invoice_date'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#DUE_DATE#", $invData['due_date'], $TemplateData['template']);
+		}
+		$dir_path = getcwd()."/attachments/";
+		$path = $dir_path.$Filenm;
+		$command = "cp ".$FilePath." ".$path;
+		exec($command);
+		$email_array = array('accountid' => $AccountData['id'],
+			'subject' => $TemplateData['subject'],
+			'body' => $TemplateData['template'],
+			'from' => $invoice_conf['emailaddress'],
+			'to' => $AccountData['email'],
+			'status' => "1",
+			'attachment' => $Filenm,
+			'template' => '');
+		//echo "<pre>"; print_r($TemplateData); exit;
+		$this->db->insert("mail_details", $email_array);
+	}
 
 }