iNextrix / ASTPP

web_interface/astpp/application/modules/accounts/models/accounts_model.php

Spacing +63 added lines, -63 removed lines

@@ -31,12 +31,12 @@ 
 	function add_account($accountinfo) {
 	
 		$account_data = $this->session->userdata("accountinfo");
-		$accountinfo['reseller_id'] = ($account_data['type'] == 1 ) ? $account_data['id'] : 0;
-		$accountinfo['maxchannels'] = ($accountinfo['type'] == 1 || $account_data['type'] == 2 || $account_data['type'] == -1 ) ? "0" : $accountinfo['maxchannels'];
+		$accountinfo['reseller_id'] = ($account_data['type'] == 1) ? $account_data['id'] : 0;
+		$accountinfo['maxchannels'] = ($accountinfo['type'] == 1 || $account_data['type'] == 2 || $account_data['type'] == -1) ? "0" : $accountinfo['maxchannels'];
 		unset($accountinfo['action']);
 		$sip_flag = isset($accountinfo['sip_device_flag']) ? 1 : 0;
 		$opensip_flag = isset($accountinfo['opensips_device_flag']) ? 1 : 0;
-		unset($accountinfo['sip_device_flag'],$accountinfo['opensips_device_flag'],$accountinfo['tax_id']);
+		unset($accountinfo['sip_device_flag'], $accountinfo['opensips_device_flag'], $accountinfo['tax_id']);
 
 		/*         * ******************************** */
 		$accountinfo['creation'] = gmdate('Y-m-d H:i:s');
@@ -51,14 +51,14 @@ 
         }else{
 	  $accountinfo['allow_ip_management']=1;
         }*/
-		if(isset($accountinfo['local_call'])){
-	  $accountinfo['local_call']=0;
-		}else{
-	  $accountinfo['local_call']=1;
+		if (isset($accountinfo['local_call'])) {
+	  $accountinfo['local_call'] = 0;
+		} else {
+	  $accountinfo['local_call'] = 1;
 		}
-		if ($accountinfo['type'] == 1){
+		if ($accountinfo['type'] == 1) {
 		$invoice_config = $accountinfo['invoice_config_flag'];
-		}else{
+		} else {
 		$invoice_config = "";		
 		}
 		unset($accountinfo['invoice_config_flag']);
@@ -86,8 +86,8 @@ 
 			}
 		if ($sip_flag == '1') {
 			$this->db->select('id');
-			$this->db->where('name','default');
-			$sipprofile_result=(array)$this->db->get('sip_profiles')->first_row();
+			$this->db->where('name', 'default');
+			$sipprofile_result = (array)$this->db->get('sip_profiles')->first_row();
 			$free_switch_array = array('fs_username' => $accountinfo['number'],
 				'fs_password' => $this->common->decode($accountinfo['password']),
 				'context' => 'default',
@@ -109,8 +109,8 @@ 
 			$this->load->model('opensips/opensips_model');
 			$this->opensips_model->add_opensipsdevices($opensips_array);
 		}
-		$accountinfo['confirm'] =  base_url();
-		if($accountinfo['id'] == ""){
+		$accountinfo['confirm'] = base_url();
+		if ($accountinfo['id'] == "") {
 		$accountinfo['id'] = $last_id;
 		}
 		$accountinfo['password'] = $this->common->decode($accountinfo['password']);    
@@ -154,16 +154,16 @@ 
 				if ($query_pricelist->num_rows > 0) {
 					$description = '';
 					if ($update_array['balance']['operator'] == '2') {
-						$description .="Reseller update set balance by admin";
+						$description .= "Reseller update set balance by admin";
 					}
 					if ($update_array['balance']['operator'] == '3') {
-						$description .="Reseller update increase balance by admin";
+						$description .= "Reseller update increase balance by admin";
 					}
 					if ($update_array['balance']['operator'] == '4') {
-						$description .="Reseller update descrise balance by admin";
+						$description .= "Reseller update descrise balance by admin";
 					}
 					foreach ($query_pricelist->result_array() as $key => $reseller_payment) {
-						if (!empty($reseller_payment['reseller_id']) && $reseller_payment['reseller_id'] != '') {
+						if ( ! empty($reseller_payment['reseller_id']) && $reseller_payment['reseller_id'] != '') {
 							$payment_by = $reseller_payment['reseller_id'];
 						} else {
 							$payment_by = '-1';
@@ -218,16 +218,16 @@ 
 			if ($query_pricelist->num_rows > 0) {
 				$description = '';
 				if ($update_array['balance']['operator'] == '2') {
-					$description .="Customer update set balance by admin";
+					$description .= "Customer update set balance by admin";
 				}
 				if ($update_array['balance']['operator'] == '3') {
-					$description .="Customer update increase balance by admin";
+					$description .= "Customer update increase balance by admin";
 				}
 				if ($update_array['balance']['operator'] == '4') {
-					$description .="Customer update descrise balance by admin";
+					$description .= "Customer update descrise balance by admin";
 				}
 				foreach ($query_pricelist->result_array() as $key => $customer_payment) {
-					if (!empty($customer_payment['reseller_id']) && $customer_payment['reseller_id'] != '0') {
+					if ( ! empty($customer_payment['reseller_id']) && $customer_payment['reseller_id'] != '0') {
 						$payment_by = $customer_payment['reseller_id'];
 					} else {
 						$payment_by = '-1';
@@ -283,11 +283,11 @@ 
 			$pin = $this->common->find_uniq_rendno_accno($number_length, 'pin', 'accounts', '', $count);
 		}
 		$sip_flag = false;
-		$opensip_flag=false;
-		if (isset($add_array['sip_device_flag']) && common_model::$global_config['system_config']['opensips']== 0) {
+		$opensip_flag = false;
+		if (isset($add_array['sip_device_flag']) && common_model::$global_config['system_config']['opensips'] == 0) {
 			$sip_flag = true;
 		}
-		if (isset($add_array['opensips_device_flag']) && common_model::$global_config['system_config']['opensips']== 1) {
+		if (isset($add_array['opensips_device_flag']) && common_model::$global_config['system_config']['opensips'] == 1) {
 			$opensip_flag = true;
 		}
 		unset(
@@ -298,20 +298,20 @@ 
 				$add_array['sip_device_flag'],
 				$add_array['opensips_device_flag']
 		);
-		if(isset($add_array['is_recording']) &&  $add_array['is_recording'] != ''){
-		$is_recording=1;
-		}else{
-		$is_recording=0;
+		if (isset($add_array['is_recording']) && $add_array['is_recording'] != '') {
+		$is_recording = 1;
+		} else {
+		$is_recording = 0;
 		}
-		if(isset($add_array['allow_ip_management']) &&  $add_array['allow_ip_management'] != ''){
-		$allow_ip_management=1;
-		}else{
-		$allow_ip_management=0;
+		if (isset($add_array['allow_ip_management']) && $add_array['allow_ip_management'] != '') {
+		$allow_ip_management = 1;
+		} else {
+		$allow_ip_management = 0;
 		}
-		if(isset($add_array['local_call']) &&  $add_array['local_call'] != ''){
-		$local_call=1;
-		}else{
-		$local_call=0;
+		if (isset($add_array['local_call']) && $add_array['local_call'] != '') {
+		$local_call = 1;
+		} else {
+		$local_call = 0;
 		}
 		if ($sip_flag) {
 			$query = $this->db_model->select("*", "sip_profiles", array('status' => "0"), "id", "ASC", '1', '0');
@@ -419,7 +419,7 @@ 
 			$this->db->insert_batch('accounts', $insert_array);
 			if ($opensip_flag == 1) {
 				$db_config = Common_model::$global_config['system_config'];
-				$opensipdsn = "mysql://" . $db_config['opensips_dbuser'] . ":" . $db_config['opensips_dbpass'] . "@" . $db_config['opensips_dbhost'] . "/" . $db_config['opensips_dbname'] . "?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
+				$opensipdsn = "mysql://".$db_config['opensips_dbuser'].":".$db_config['opensips_dbpass']."@".$db_config['opensips_dbhost']."/".$db_config['opensips_dbname']."?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
 				$this->opensips_db = $this->load->database($opensipdsn, true);
 				$this->opensips_db->insert_batch("subscriber", $opensips_array);
 			}
@@ -428,7 +428,7 @@ 
 	}
 
 	function get_max_limit($add_array) {
-		$this->db->where('deleted','0');
+		$this->db->where('deleted', '0');
 		$this->db->where("length(number)", $add_array['account_length']);
 		$this->db->like('number', $add_array['prefix'], 'after');
 		$this->db->select("count(id) as count");
@@ -444,16 +444,16 @@ 
 	}
 	function account_process_payment($data) {
 	$data['accountid'] = $data['id'];
-		$accountdata=(array)$this->db->get_where('accounts',array("id"=>$data['accountid']))->first_row();
-		$accountinfo =$this->session->userdata('accountinfo');
+		$accountdata = (array)$this->db->get_where('accounts', array("id"=>$data['accountid']))->first_row();
+		$accountinfo = $this->session->userdata('accountinfo');
 	$data["payment_by"] = $accountdata['reseller_id'] > 0 ? $accountdata['reseller_id'] : '-1';
 	$data['payment_mode'] = $data['payment_type'];
-	unset($data['action'],$data['id'],$data['account_currency'],$data['payment_type']);
-	if (isset($data) && !empty($accountdata)) {
-		$data['credit']=$data['credit'] =='' ?  0 : $data['credit'];
+	unset($data['action'], $data['id'], $data['account_currency'], $data['payment_type']);
+	if (isset($data) && ! empty($accountdata)) {
+		$data['credit'] = $data['credit'] == '' ? 0 : $data['credit'];
 		$date = gmdate('Y-m-d H:i:s');
-		if($data['payment_mode']== 1){       
-		  $balance = $this->update_balance($data['credit'], $data['accountid'],$data['payment_mode']);
+		if ($data['payment_mode'] == 1) {       
+		  $balance = $this->update_balance($data['credit'], $data['accountid'], $data['payment_mode']);
 			  $insert_arr = array("accountid" => $data['accountid'],
 			  "credit" => "-".$data['credit'],
 			  'payment_mode'=>$data['payment_mode'],
@@ -474,11 +474,11 @@ 
 			  'payment_by'=>$data['payment_by'],
 		  );
 		  $this->db->insert("payments", $insert_arr);
-		  $accountdata['refill_amount']=$data['credit'];
-		  $current_id=$accountinfo['type'] ==1 ? $accountinfo['id'] : '0';
-		  if($accountdata['reseller_id'] == $current_id){
+		  $accountdata['refill_amount'] = $data['credit'];
+		  $current_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : '0';
+		  if ($accountdata['reseller_id'] == $current_id) {
 			$this->common->mail_to_users('voip_account_refilled', $accountdata);
-		  }else{
+		  } else {
 			$this->common->mail_to_users('voip_child_account_refilled', $accountdata);
 		  }
 		}
@@ -488,7 +488,7 @@ 
 
 	function get_admin_Account_list($flag, $start = 0, $limit = 0, $reseller_id = 0) {
 		$this->db_model->build_search('admin_list_search');
-		$where = "reseller_id =" . $reseller_id . " AND deleted =0 AND type in (2,4,-1)";
+		$where = "reseller_id =".$reseller_id." AND deleted =0 AND type in (2,4,-1)";
 		if ($this->session->userdata('advance_search') == 1) {
 			$search = $this->session->userdata('admin_list_search');
 			if ($search['type'] == '') {
@@ -504,10 +504,10 @@ 
 		if ($flag) {
 			$this->db->limit($limit, $start);
 		}
-		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
-			$this->db->order_by('number','desc');
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
+			$this->db->order_by('number', 'desc');
 		}
 		$result = $this->db->get('accounts');
 
@@ -535,13 +535,13 @@ 
 			$this->db->where($type);
 		}
 		if ($flag) {
-			if (!$export)
+			if ( ! $export)
 				$this->db->limit($limit, $start);
 		}
-		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
-			$this->db->order_by('number','desc');
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
+			$this->db->order_by('number', 'desc');
 		}
 		$result = $this->db->get('accounts');
 		if ($flag) {
@@ -590,7 +590,7 @@ 
 	function insert_block($data, $accountid) {
 		$data = explode(",", $data);
 		$tmp = array();
-		if (!empty($data)) {
+		if ( ! empty($data)) {
 			foreach ($data as $key => $data_value) {
 				$tmp[$key]["accountid"] = $accountid;
 				$result = $this->get_pattern_by_id($data_value);
@@ -621,7 +621,7 @@ 
 	}
 
 	function add_callerid($data) {
-		unset($data['action'],$data['flag']);
+		unset($data['action'], $data['flag']);
 		$data['accountid'] = $this->common->get_field_name('id', 'accounts', array('number' => $data['accountid']));
 		$this->db->insert('accounts_callerid', $data);
 		return true;
@@ -706,10 +706,10 @@ 
 
 	function update_balance($amount, $accountid, $payment_type) {
 		if ($payment_type == 0) {
-			$query = 'UPDATE `accounts` SET `balance` = (balance + ' . $amount . ') WHERE `id` = ' . $accountid;
+			$query = 'UPDATE `accounts` SET `balance` = (balance + '.$amount.') WHERE `id` = '.$accountid;
 			return $this->db->query($query);
 		}if ($payment_type == 1) {
-			$query = 'UPDATE `accounts` SET `balance` = (balance - ' . $amount . ') WHERE `id` = ' . $accountid;
+			$query = 'UPDATE `accounts` SET `balance` = (balance - '.$amount.') WHERE `id` = '.$accountid;
 			return $this->db->query($query);
 		}
 	}

web_interface/astpp/application/modules/accounts/views/view_customer_speed_dial.php

Spacing +1 added lines, -1 removed lines

@@ -131,7 +131,7 @@
                                             </label>
                                             </div>
                                                <div class="col-md-3">
-                                            <input class="col-md-2 form-control" name="speed_dial_<?php echo $i; ?>" id="speed_dial_<?php echo $i; ?>" size="16" type="text"  value="<?php if (isset($speeddial[$i]) && !empty($speeddial[$i])) {
+                                            <input class="col-md-2 form-control" name="speed_dial_<?php echo $i; ?>" id="speed_dial_<?php echo $i; ?>" size="16" type="text"  value="<?php if (isset($speeddial[$i]) && ! empty($speeddial[$i])) {
 		echo $speeddial[$i];
 	} ?>">
                                                </div>

web_interface/astpp/application/modules/accounts/views/view_bulk_account_creation.php

Spacing +3 added lines, -3 removed lines

@@ -57,10 +57,10 @@
                     <div style="color:red;margin-left: 60px;">
                         <?php
 						if (isset($validation_errors)) {
-						   $validation_array=json_decode($validation_errors);
-						   if(is_object($validation_array)){
+						   $validation_array = json_decode($validation_errors);
+						   if (is_object($validation_array)) {
 						   $validation_array = get_object_vars($validation_array);
-						   foreach($validation_array as $key=>$value)
+						   foreach ($validation_array as $key=>$value)
 					  echo $value."<br/>";
 						   }
 						   else

web_interface/astpp/application/modules/accounts/views/view_reseller_invoices_config.php

Spacing +6 added lines, -6 removed lines

@@ -206,13 +206,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/modules/accounts/views/view_customer_alert_threshold.php

Spacing +1 added lines, -1 removed lines

@@ -51,7 +51,7 @@
 					}
 					$data_errrors = json_decode($validation_errors);
 					foreach ($data_errrors as $key => $value) {
-						echo $value . "<br/>";
+						echo $value."<br/>";
 					}
 					?> 
                 </div>

web_interface/astpp/application/modules/accounts/views/view_admin_details.php

Spacing +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
 <!--                                <?php
 								$data_errrors = json_decode($validation_errors);
 								foreach ($data_errrors as $key => $value) {
-									echo $value . "<br/>";
+									echo $value."<br/>";
 								}
 								?> 
                           </div>

web_interface/astpp/application/modules/rates/models/rates_model.php

Spacing +14 added lines, -14 removed lines

@@ -32,10 +32,10 @@ 
 ASTPP  3.0 
 Batch Delete
 ********/
-		if($this->session->userdata('advance_batch_delete') == 1){
+		if ($this->session->userdata('advance_batch_delete') == 1) {
 		   $this->db->where(array("trunk_id >"=>"0"));
 		   $this->db->delete("outbound_routes");
-		   $this->session->set_userdata('advance_batch_delete','0');
+		   $this->session->set_userdata('advance_batch_delete', '0');
 		   $this->session->unset_userdata('advance_batch_delete');
 	   }
 /**************/
@@ -53,7 +53,7 @@ 
 			if ($export)
 				$this->db->limit($limit, $start);
 			$result = $this->db->get();
-		}else {
+		} else {
 			$result = $this->db->count_all_results();
 		}
 		return $result;
@@ -74,14 +74,14 @@ 
 			if ($export)
 				$this->db->limit($limit, $start);
 			$result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start);
-		}else {
+		} else {
 			$result = $this->db_model->countQuery("*", "routes", $where);
 		}
 // 	echo "<pre>";print_r($result->result());exit;
 		return $result;
 	}
 
-	function get_origination_rate_for_user($flag, $start = 0, $limit = 0,$export = true) {
+	function get_origination_rate_for_user($flag, $start = 0, $limit = 0, $export = true) {
 		$this->db_model->build_search('origination_rate_list_search');
 
 		$account_data = $this->session->userdata("accountinfo");
@@ -93,7 +93,7 @@ 
 			if ($export)
 				$this->db->limit($limit, $start);
 			$result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start);
-		}else {
+		} else {
 			$result = $this->db_model->countQuery("*", "routes", $where);
 		}
 		return $result;
@@ -111,11 +111,11 @@ 
 ASTPP  3.0 
 Batch delete
 ************/
-		if($this->session->userdata('advance_batch_delete') == 1){
+		if ($this->session->userdata('advance_batch_delete') == 1) {
 			$this->db->where($where);
 			$this->db->delete("routes");
 			//echo $this->db->last_query(); exit;
-			$this->session->set_userdata('advance_batch_delete','0');
+			$this->session->set_userdata('advance_batch_delete', '0');
 			$this->session->unset_userdata('advance_batch_delete');
 			
 		}
@@ -336,21 +336,21 @@ 
     /**
      * @param string $table_name
      */
-    function insert_if_not_exitst($add_array,$table_name){
+    function insert_if_not_exitst($add_array, $table_name) {
         $insert_str = "Insert into $table_name (";
         $insert_key = "";
         $insert_value = "";
         $update_str = "";
-        foreach($add_array as $key => $value){
-           if($key != 'id'){
+        foreach ($add_array as $key => $value) {
+           if ($key != 'id') {
                    $insert_key .= $key.",";
                    $insert_value .= "'$value',";   
                    $update_str .= $key." = '$value',";
            }
         }
-        $insert_key = rtrim($insert_key,",");
-        $insert_value = rtrim($insert_value,",");
-        $update_str = rtrim($update_str,",");
+        $insert_key = rtrim($insert_key, ",");
+        $insert_value = rtrim($insert_value, ",");
+        $update_str = rtrim($update_str, ",");
         $insert_str .= $insert_key.") values"."(".$insert_value.")  ON DUPLICATE KEY UPDATE $update_str";
         $this->db->query($insert_str);
     }   

web_interface/astpp/application/modules/rates/views/view_import_termination_rate.php

Spacing +9 added lines, -9 removed lines

@@ -18,7 +18,7 @@ 
                <div class="col-md-12">
             	<div class="w-box">
             	 <span  style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;">
-                    <? if(isset($error) && !empty($error)) {
+                    <? if (isset($error) && ! empty($error)) {
 						echo $error;
 					}?>
                  </span>
@@ -34,7 +34,7 @@ 
                            <div class="col-md-12 no-padding">
                                <label class="col-md-3">Trunk List:</label>
                                <div class="">
-                               <? $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr",array("status " => "0")), '');
+                               <? $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array("status " => "0")), '');
 							echo $trunklist; ?></div>
                            </div>
                            <div class="col-md-12 no-padding">
@@ -88,7 +88,7 @@ 
 <?}?>    
         
 <?php
-	if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?>
+	if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { ?>
         
 <section class="slice color-three padding-b-20">
 	<div class="w-section inverse no-padding">
@@ -97,14 +97,14 @@ 
                 <div class="col-md-12 margin-t-10">  
             <form id="import_form" name="import_form" action="<?=base_url()?>rates/termination_rate_rates_import/<?= $trunkid?>/<?=$check_header?>/" method="POST">
             <table width="100%" border="1"  class="details_table table">
-                <?  $cnt =7;
-					foreach($csv_tmp_data as $csv_key => $csv_value){
-						if($csv_key <  15){
+                <?  $cnt = 7;
+					foreach ($csv_tmp_data as $csv_key => $csv_value) {
+						if ($csv_key < 15) {
 							echo "<tr>";
-							foreach($csv_value as $field_name => $field_val){
-								if($csv_key == 0){
+							foreach ($csv_value as $field_name => $field_val) {
+								if ($csv_key == 0) {
 									echo "<th>".ucfirst($field_name)."</th>";
-								}else{
+								} else {
 									echo "<td class='portlet-content'>".$field_val."</td>";   
 								}
 							}

web_interface/astpp/application/modules/signup/models/signup_model.php

Spacing +20 added lines, -20 removed lines

@@ -51,49 +51,49 @@
 		$data['reseller_id'] = $data['key_unique'];	
 		unset($data['agreeCheck']);
 		unset($data['key_unique']);
-		$data['creation']=gmdate('Y-m-d H:i:s');
+		$data['creation'] = gmdate('Y-m-d H:i:s');
 		$data['expiry'] = date('Y-m-d H:i:s', strtotime('+10 years'));
-		$this->db->insert("accounts",$data);
+		$this->db->insert("accounts", $data);
 		return   $this->db->insert_id();
 		}
 
-	function check_user($accno,$email,$balance)
+	function check_user($accno, $email, $balance)
 	{
-		$info = array("number"=>$accno,"email"=>$email,"status"=>1);
+		$info = array("number"=>$accno, "email"=>$email, "status"=>1);
 						$this->db->where($info);
 						$this->db->select('*');
-		$acc_res=$this->db->get('accounts');
-		if($acc_res->num_rows() > 0)	
+		$acc_res = $this->db->get('accounts');
+		if ($acc_res->num_rows() > 0)	
 		{         
-						$acc_res=$acc_res->result_array();
-						$acc_res=$acc_res[0];
-						$this->db->where('pricelist_id',$acc_res['pricelist_id']);
+						$acc_res = $acc_res->result_array();
+						$acc_res = $acc_res[0];
+						$this->db->where('pricelist_id', $acc_res['pricelist_id']);
 						$this->db->select("*");
-						$charge_res=$this->db->get('charges');
+						$charge_res = $this->db->get('charges');
                         
-			if($charge_res->num_rows() > 0){
-			$charge_res=$charge_res->result_array();
-						$charge_res=$charge_res[0];
-						$charge_acc_arr=array(
+			if ($charge_res->num_rows() > 0) {
+			$charge_res = $charge_res->result_array();
+						$charge_res = $charge_res[0];
+						$charge_acc_arr = array(
 						"charge_id"=>$charge_res['id'],
 						"accountid"=>$acc_res['id'],
 						"status"=>0,
 						"assign_date"=>date('Y-m-d H:i:s')
 						 );
-			}else{
-			$charge_res=$charge_res->result_array();
+			} else {
+			$charge_res = $charge_res->result_array();
 			//echo "<pre>"; print_r($charge_res); exit;
 			$charge_acc_arr = array("charge_id"=>'id',
 						"accountid"=>$acc_res['id'],
 						"assign_date"=>date('Y-m-d H:i:s'));
 			}
-						$result=$this->db->insert("charge_to_account",$charge_acc_arr);
-			$update = array("status" => 0,"balance" => $balance );
+						$result = $this->db->insert("charge_to_account", $charge_acc_arr);
+			$update = array("status" => 0, "balance" => $balance);
 			$this->db->where($info);
 			$result = $this->db->update('accounts', $update);
-			$sip_device_update = array('username'=>$accno,"status"=>1);
+			$sip_device_update = array('username'=>$accno, "status"=>1);
 			return 1;
-		} else{
+		} else {
 			return 0;
 		}
 	}