iNextrix / ASTPP

web_interface/astpp/application/modules/login/controllers/login.php

Indentation +18 added lines, -18 removed lines

@@ -301,34 +301,34 @@
 				'invoiceid'=>$invoice_id,
 				'description'=>"Your account has been credited due to your customer account recharge done by paypal",
 				'item_type'=>'PAYMENT',
-		  	        'before_balance'=>$account_data['balance'],
+		  			'before_balance'=>$account_data['balance'],
 				'after_balance'=>$account_data['balance']+$balance_amt,
 			   );
-		          $this->db->insert("invoice_details", $details_insert); 
-	          	  $this->db_model->update_balance($balance_amt,$account_data["id"],"credit");  			         
+				  $this->db->insert("invoice_details", $details_insert); 
+			  	  $this->db_model->update_balance($balance_amt,$account_data["id"],"credit");  			         
 			}
-		      }
+			  }
 		}
 		redirect(base_url() . 'user/user/');
-        }
-      }         
+		}
+	  }         
 	redirect(base_url() . 'user/user/');
-    }
+	}
 
-    /**
-     * @param integer $last_invoice_ID
-     * @param string $due_date
-     */
-    function generate_receipt($accountid,$amount,$accountinfo,$last_invoice_ID,$invoice_prefix,$due_date){
+	/**
+	 * @param integer $last_invoice_ID
+	 * @param string $due_date
+	 */
+	function generate_receipt($accountid,$amount,$accountinfo,$last_invoice_ID,$invoice_prefix,$due_date){
 		$invoice_data = array("accountid"=>$accountid,"invoice_prefix" =>$invoice_prefix,"invoiceid"=>'0000'.$last_invoice_ID,"reseller_id"=>$accountinfo['reseller_id'],"invoice_date"=>gmdate("Y-m-d H:i:s"),"from_date"=>  gmdate("Y-m-d H:i:s"),"to_date"=>gmdate("Y-m-d H:i:s"),"due_date"=>$due_date,"status"=>1,"balance"=>$accountinfo['balance'],"amount"=>$amount,"type"=>'R',"confirm"=>'1');            
-        $this->db->insert("invoices",$invoice_data);
-        $invoiceid = $this->db->insert_id();    
-        return  $invoiceid;  
-    }
+		$this->db->insert("invoices",$invoice_data);
+		$invoiceid = $this->db->insert_id();    
+		return  $invoiceid;  
+	}
     
-    function get_language_text(){
+	function get_language_text(){
    // echo '<pre>'; print_r($_POST); exit;
-      echo gettext($_POST['display']); 
+	  echo gettext($_POST['display']); 
  	}  
     
 }

Spacing +75 added lines, -75 removed lines

@@ -31,23 +31,23 @@ 
 		$this->load->model('db_model');
 	}
     
-	function set_lang_global($post=false){ 
-	if(!is_array($post)){
-		$str=trim($post);
-		$new_arr[$str]=$str;
-		$post=$new_arr;
+	function set_lang_global($post = false) { 
+	if ( ! is_array($post)) {
+		$str = trim($post);
+		$new_arr[$str] = $str;
+		$post = $new_arr;
 	}
-	if(isset($post['fr_FR'])){
-	 $language=$post['fr_FR'];
+	if (isset($post['fr_FR'])) {
+	 $language = $post['fr_FR'];
 	 $this->session->set_userdata('user_language', $language);
 	}
-	if(isset($post['es_ES'])){
-	 $language=$post['es_ES'];
+	if (isset($post['es_ES'])) {
+	 $language = $post['es_ES'];
 	 $this->session->set_userdata('user_language', $language);         
 	}       
-	if(isset($post['en_EN'])){
-	 $language=$post['en_EN'];
-	 $this->session->unset_userdata('user_language',$language);
+	if (isset($post['en_EN'])) {
+	 $language = $post['en_EN'];
+	 $this->session->unset_userdata('user_language', $language);
 	} 
 	$this->locale->set_lang();
 	return true;
@@ -55,17 +55,17 @@ 
 
 	function index() {
 		if ($this->session->userdata('user_login') == FALSE) {
-			if (!empty($_POST) && trim($_POST['username']) != '' && trim($_POST['password']) != '') {
-			$_POST['password']=$this->common->encode($_POST['password']);
+			if ( ! empty($_POST) && trim($_POST['username']) != '' && trim($_POST['password']) != '') {
+			$_POST['password'] = $this->common->encode($_POST['password']);
 				$user_valid = $this->Auth_model->verify_login($_POST['username'], $_POST['password']);
                 
 				if ($user_valid == 1) {
 					$this->session->set_userdata('user_login', TRUE);
 			$where = "number = '".$this->db->escape_str($_POST['username'])."' OR email = '".$this->db->escape_str($_POST['username'])."'";
-					$result = $this->db_model->getSelect("*", "accounts",$where);
+					$result = $this->db_model->getSelect("*", "accounts", $where);
 					$result = $result->result_array();
 					$result = $result[0];
-					 $logintype=$result['type']== -1 ? 2: $result['type'];
+					 $logintype = $result['type'] == -1 ? 2 : $result['type'];
 					$this->session->set_userdata('logintype', $logintype);
 					$this->session->set_userdata('userlevel_logintype', $result['type']);
 					$this->session->set_userdata('username', $_POST['username']);
@@ -118,15 +118,15 @@ 
 					if ($result['type'] == 0 || $result['type'] == 1) {
 						$menu_list = $this->permission->get_module_access($result['type']);
 						$this->session->set_userdata('mode_cur', 'user');
-						if($result['type'] == 1){
-							redirect(base_url() . 'dashboard/');
-						}else{
-							redirect(base_url() . 'user/user/');
+						if ($result['type'] == 1) {
+							redirect(base_url().'dashboard/');
+						} else {
+							redirect(base_url().'user/user/');
 						}
 					} else {
 						$menu_list = $this->permission->get_module_access($result['type']);
 						$this->session->set_userdata('mode_cur', 'admin');
-						redirect(base_url() . 'dashboard/');
+						redirect(base_url().'dashboard/');
 					}
 				} else {
 		   
@@ -151,7 +151,7 @@ 
 			$this->session->set_userdata('user_login', FALSE);
 			$data['app_name'] = 'ASTPP - Open Source Billing Solution';
 			$this->load->view('view_login', $data);
-		}else {
+		} else {
 	/*
 	*
 	* Purpose : Display logo based on domain name
@@ -173,7 +173,7 @@ 
 	//              echo $data['user_logo'];exit;
 /***************************************************************************************/
 		if ($this->session->userdata('logintype') == '2') {
-		redirect(base_url() . 'dashboard/');
+		redirect(base_url().'dashboard/');
 		} else {
 		redirect(base_url().'user/user/');
 		}
@@ -184,25 +184,25 @@ 
 		$this->session->sess_destroy();
 		redirect(base_url());
 	}
-  function paypal_response(){
-	  if(count($_POST)>0)
+  function paypal_response() {
+	  if (count($_POST) > 0)
 	  {
-		$response_arr=$_POST;
-		$fp=fopen("/var/log/astpp/astpp_payment.log","w+");
+		$response_arr = $_POST;
+		$fp = fopen("/var/log/astpp/astpp_payment.log", "w+");
 		$date = date("Y-m-d H:i:s");
-		fwrite($fp,"====================".$date."===============================\n");
-		foreach($response_arr as $key => $value){	  
-			fwrite($fp,$key.":::>".$value."\n");
+		fwrite($fp, "====================".$date."===============================\n");
+		foreach ($response_arr as $key => $value) {	  
+			fwrite($fp, $key.":::>".$value."\n");
 		}
 		$payment_check = $this->db_model->countQuery("txn_id", "payments", array("txn_id" => $response_arr['txn_id']));
-		if( ($response_arr["payment_status"] == "Pending" || $response_arr["payment_status"] == "Complete" || $response_arr["payment_status"] == "Completed" ) && $payment_check == 0){
+		if (($response_arr["payment_status"] == "Pending" || $response_arr["payment_status"] == "Complete" || $response_arr["payment_status"] == "Completed") && $payment_check == 0) {
 
-			$paypal_tax = (array)$this->db->get_where("system", array("name" => "paypal_tax","group_title"=>"paypal"))->first_row();
-			$paypal_tax =$paypal_tax['value'];
+			$paypal_tax = (array)$this->db->get_where("system", array("name" => "paypal_tax", "group_title"=>"paypal"))->first_row();
+			$paypal_tax = $paypal_tax['value'];
 			$balance_amt = $actual_amount = $response_arr["custom"];
-			$paypal_fee = (array)$this->db->get_where("system", array("name" => "paypal_fee","group_title"=>"paypal"))->first_row();
+			$paypal_fee = (array)$this->db->get_where("system", array("name" => "paypal_fee", "group_title"=>"paypal"))->first_row();
 			$paypal_fee = $paypal_fee['value'];
-			$paypalfee = ($paypal_fee == 0)?'0':$response_arr["mc_gross"];
+			$paypalfee = ($paypal_fee == 0) ? '0' : $response_arr["mc_gross"];
 			$account_data = (array)$this->db->get_where("accounts", array("id" => $response_arr["item_number"]))->first_row();
 			$currency = (array)$this->db->get_where('currency', array("id"=>$account_data["currency_id"]))->first_row();
 			$date = date('Y-m-d H:i:s');
@@ -216,35 +216,35 @@ 
 							"currency_rate"=>$currency["currencyrate"],
 							"transaction_details"=>json_encode($response_arr),
 							"date"=>$date);
-			 $paymentid=$this->db->insert('payment_transaction',$payment_trans_array);
-			 $parent_id =$account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : '-1';
+			 $paymentid = $this->db->insert('payment_transaction', $payment_trans_array);
+			 $parent_id = $account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : '-1';
 		 $payment_arr = array("accountid"=> $response_arr["item_number"],
-		 		"payment_mode"=>"1","credit"=>$balance_amt,
+		 		"payment_mode"=>"1", "credit"=>$balance_amt,
 				"type"=>"PAYPAL",
 				"payment_by"=>$parent_id,
 				"notes"=>"Payment Made by Paypal on date:-".$date,
 				"paypalid"=>$paymentid,
 				"txn_id"=>$response_arr["txn_id"],
-				'payment_date'=>gmdate('Y-m-d H:i:s',strtotime($response_arr['payment_date'])));
+				'payment_date'=>gmdate('Y-m-d H:i:s', strtotime($response_arr['payment_date'])));
 		 $this->db->insert('payments', $payment_arr);
 		 $this->db->select('invoiceid');
-		 $this->db->order_by('id','desc');
+		 $this->db->order_by('id', 'desc');
 		 $this->db->limit(1);
- 		 $last_invoice_result=(array)$this->db->get('invoices')->first_row();
- 		 $last_invoice_ID=isset($last_invoice_result['invoiceid'] ) && $last_invoice_result['invoiceid'] > 0 ?$last_invoice_result['invoiceid'] : 1;
- 		 $reseller_id=$account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : 0;
-		 $where="accountid IN ('".$reseller_id."','1')";
+ 		 $last_invoice_result = (array)$this->db->get('invoices')->first_row();
+ 		 $last_invoice_ID = isset($last_invoice_result['invoiceid']) && $last_invoice_result['invoiceid'] > 0 ? $last_invoice_result['invoiceid'] : 1;
+ 		 $reseller_id = $account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : 0;
+		 $where = "accountid IN ('".$reseller_id."','1')";
 		 $this->db->where($where);
 		 $this->db->select('*');
 		 $this->db->order_by('accountid', 'desc');
 		 $this->db->limit(1);
 			 $invoiceconf = $this->db->get('invoice_conf');
 			 $invoiceconf = (array)$invoiceconf->first_row();
-		 $invoice_prefix=$invoiceconf['invoice_prefix'];
+		 $invoice_prefix = $invoiceconf['invoice_prefix'];
 
-		 $due_date = gmdate("Y-m-d H:i:s",strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));  
-		 $invoice_id=$this->generate_receipt($account_data['id'],$balance_amt,$account_data,$last_invoice_ID+1,$invoice_prefix,$due_date);
-		 $details_insert=array(
+		 $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));  
+		 $invoice_id = $this->generate_receipt($account_data['id'], $balance_amt, $account_data, $last_invoice_ID + 1, $invoice_prefix, $due_date);
+		 $details_insert = array(
 			'created_date'=>$date,
 			'credit'=>$balance_amt,
 			'debit'=>'-',
@@ -254,34 +254,34 @@ 
 			'description'=>"Payment Made by Paypal on date:-".$date,
 			'item_type'=>'PAYMENT',
 	  			'before_balance'=>$account_data['balance'],
-			'after_balance'=>$account_data['balance']+$balance_amt,
+			'after_balance'=>$account_data['balance'] + $balance_amt,
 			);
 		$this->db->insert("invoice_details", $details_insert); 
-		$this->db_model->update_balance($balance_amt,$account_data["id"],"credit");            
-		if($parent_id > 0){
-			  $reseller_ids=$this->common->get_parent_info($parent_id,0);
-			  $reseller_ids=rtrim($reseller_ids,",");
-			  $reseller_arr=explode(",",$reseller_ids);
-			  if(!empty($reseller_arr)){
-			foreach($reseller_arr as $key=>$reseller_id){
+		$this->db_model->update_balance($balance_amt, $account_data["id"], "credit");            
+		if ($parent_id > 0) {
+			  $reseller_ids = $this->common->get_parent_info($parent_id, 0);
+			  $reseller_ids = rtrim($reseller_ids, ",");
+			  $reseller_arr = explode(",", $reseller_ids);
+			  if ( ! empty($reseller_arr)) {
+			foreach ($reseller_arr as $key=>$reseller_id) {
 			  $account_data = (array)$this->db->get_where("accounts", array("id" => $reseller_id))->first_row();
 			  $this->db->select('invoiceid');
-				  $this->db->order_by('id','desc');
+				  $this->db->order_by('id', 'desc');
 				  $this->db->limit(1);
- 					  $last_invoice_result=(array)$this->db->get('invoices')->first_row();
- 					  $last_invoice_ID=$last_invoice_result['invoiceid'];
- 		 		  $reseller_id=$account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : 0;
-					  $where="accountid IN ('".$reseller_id."','1')";
+ 					  $last_invoice_result = (array)$this->db->get('invoices')->first_row();
+ 					  $last_invoice_ID = $last_invoice_result['invoiceid'];
+ 		 		  $reseller_id = $account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : 0;
+					  $where = "accountid IN ('".$reseller_id."','1')";
 					  $this->db->where($where);
 				  $this->db->select('*');
 				  $this->db->order_by('accountid', 'desc');
 				  $this->db->limit(1);
 				  $invoiceconf = $this->db->get('invoice_conf');
 				  $invoiceconf = (array)$invoiceconf->first_row();
-					  $invoice_prefix=$invoiceconf['invoice_prefix'];
-		 		  $due_date = gmdate("Y-m-d H:i:s",strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));
-		 		  $invoice_id=$this->generate_receipt($account_data['id'],$balance_amt,$account_data,$last_invoice_ID+1,$invoice_prefix,$due_date);
-			  $parent_id=$account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : -1;
+					  $invoice_prefix = $invoiceconf['invoice_prefix'];
+		 		  $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));
+		 		  $invoice_id = $this->generate_receipt($account_data['id'], $balance_amt, $account_data, $last_invoice_ID + 1, $invoice_prefix, $due_date);
+			  $parent_id = $account_data['reseller_id'] > 0 ? $account_data['reseller_id'] : -1;
 			  $payment_arr = array("accountid"=> $account_data["id"],
 		 					"payment_mode"=>"1",
 		 					"credit"=>$balance_amt,
@@ -290,9 +290,9 @@ 
 							"notes"=>"Your account has been credited due to your customer account recharge done by paypal",
 							"paypalid"=>$paymentid,
 							"txn_id"=>$response_arr["txn_id"],
-							'payment_date'=>gmdate('Y-m-d H:i:s',strtotime($response_arr['payment_date'])));
+							'payment_date'=>gmdate('Y-m-d H:i:s', strtotime($response_arr['payment_date'])));
 	 			  $this->db->insert('payments', $payment_arr);
-			  $details_insert=array(
+			  $details_insert = array(
 				'created_date'=>$date,
 				'credit'=>$balance_amt,
 				'debit'=>'-',
@@ -302,31 +302,31 @@ 
 				'description'=>"Your account has been credited due to your customer account recharge done by paypal",
 				'item_type'=>'PAYMENT',
 		  	        'before_balance'=>$account_data['balance'],
-				'after_balance'=>$account_data['balance']+$balance_amt,
+				'after_balance'=>$account_data['balance'] + $balance_amt,
 			   );
 		          $this->db->insert("invoice_details", $details_insert); 
-	          	  $this->db_model->update_balance($balance_amt,$account_data["id"],"credit");  			         
+	          	  $this->db_model->update_balance($balance_amt, $account_data["id"], "credit");  			         
 			}
 		      }
 		}
-		redirect(base_url() . 'user/user/');
+		redirect(base_url().'user/user/');
         }
       }         
-	redirect(base_url() . 'user/user/');
+	redirect(base_url().'user/user/');
     }
 
     /**
      * @param integer $last_invoice_ID
      * @param string $due_date
      */
-    function generate_receipt($accountid,$amount,$accountinfo,$last_invoice_ID,$invoice_prefix,$due_date){
-		$invoice_data = array("accountid"=>$accountid,"invoice_prefix" =>$invoice_prefix,"invoiceid"=>'0000'.$last_invoice_ID,"reseller_id"=>$accountinfo['reseller_id'],"invoice_date"=>gmdate("Y-m-d H:i:s"),"from_date"=>  gmdate("Y-m-d H:i:s"),"to_date"=>gmdate("Y-m-d H:i:s"),"due_date"=>$due_date,"status"=>1,"balance"=>$accountinfo['balance'],"amount"=>$amount,"type"=>'R',"confirm"=>'1');            
-        $this->db->insert("invoices",$invoice_data);
+    function generate_receipt($accountid, $amount, $accountinfo, $last_invoice_ID, $invoice_prefix, $due_date) {
+		$invoice_data = array("accountid"=>$accountid, "invoice_prefix" =>$invoice_prefix, "invoiceid"=>'0000'.$last_invoice_ID, "reseller_id"=>$accountinfo['reseller_id'], "invoice_date"=>gmdate("Y-m-d H:i:s"), "from_date"=>  gmdate("Y-m-d H:i:s"), "to_date"=>gmdate("Y-m-d H:i:s"), "due_date"=>$due_date, "status"=>1, "balance"=>$accountinfo['balance'], "amount"=>$amount, "type"=>'R', "confirm"=>'1');            
+        $this->db->insert("invoices", $invoice_data);
         $invoiceid = $this->db->insert_id();    
         return  $invoiceid;  
     }
     
-    function get_language_text(){
+    function get_language_text() {
    // echo '<pre>'; print_r($_POST); exit;
       echo gettext($_POST['display']); 
  	}  

Braces +2 added lines, -2 removed lines

@@ -120,7 +120,7 @@ 
 						$this->session->set_userdata('mode_cur', 'user');
 						if($result['type'] == 1){
 							redirect(base_url() . 'dashboard/');
-						}else{
+						} else{
 							redirect(base_url() . 'user/user/');
 						}
 					} else {
@@ -151,7 +151,7 @@ 
 			$this->session->set_userdata('user_login', FALSE);
 			$data['app_name'] = 'ASTPP - Open Source Billing Solution';
 			$this->load->view('view_login', $data);
-		}else {
+		} else {
 	/*
 	*
 	* Purpose : Display logo based on domain name

web_interface/astpp/application/modules/did/models/did_model.php

Spacing +63 added lines, -63 removed lines

@@ -29,21 +29,21 @@ 
 	}
 
 	function add_did($add_array) {
-	if($add_array['accountid'] > 0 ){
-	  $add_array['assign_date']=gmdate('Y-m-d H:i:s');
+	if ($add_array['accountid'] > 0) {
+	  $add_array['assign_date'] = gmdate('Y-m-d H:i:s');
 	}
 	unset($add_array["action"]);
 	$this->db->insert("dids", $add_array);
-		if($add_array['accountid'] > 0 ){
-	  $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$add_array['accountid']))->first_row();
-	  $currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id']));
-	  $available_bal = $this->db_model->update_balance( $add_array["setup"], $add_array['accountid'], "debit");
-	  $this->common->add_invoice_details($accountinfo, "DIDCHRG",  $add_array["setup"], $add_array['number']);
+		if ($add_array['accountid'] > 0) {
+	  $accountinfo = (array)$this->db->get_where('accounts', array("id"=>$add_array['accountid']))->first_row();
+	  $currency_name = $this->common->get_field_name('currency', "currency", array('id'=>$accountinfo['currency_id']));
+	  $available_bal = $this->db_model->update_balance($add_array["setup"], $add_array['accountid'], "debit");
+	  $this->common->add_invoice_details($accountinfo, "DIDCHRG", $add_array["setup"], $add_array['number']);
 	  $accountinfo['did_number'] = $add_array['number'];
 	  $country_id = $this->common->get_field_name('country', 'countrycode', $add_array['country_id']);
 	  $accountinfo['did_country_id'] = $country_id;
-	  $accountinfo['did_setup'] = $this->common_model->calculate_currency($add_array['setup'],'',$currency_name,true,true);
-	  $accountinfo['did_monthlycost'] =$this->common_model->calculate_currency($add_array['monthlycost'],'',$currency_name,true,true);
+	  $accountinfo['did_setup'] = $this->common_model->calculate_currency($add_array['setup'], '', $currency_name, true, true);
+	  $accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($add_array['monthlycost'], '', $currency_name, true, true);
 	  $accountinfo['did_maxchannels'] = $add_array['maxchannels'];
 	  $this->common->mail_to_users('email_add_did', $accountinfo);
 	   }
@@ -54,67 +54,67 @@ 
 		return $this->db->insert_id();
 	}
 
-	function edit_did($data, $id,$number) {
+	function edit_did($data, $id, $number) {
 		unset($data["action"]);
-		$this->db->where('number',$number);
+		$this->db->where('number', $number);
 		$this->db->select('parent_id,accountid');
-		$did_result=$this->db->get('dids');
-		$did_result=(array)$did_result->first_row();
-		if($did_result['accountid'] > 0 || $did_result['parent_id'] > 0){
-		 $data['accountid']=$did_result['accountid'];
-		 $data['parent_id']=$did_result['parent_id'];
+		$did_result = $this->db->get('dids');
+		$did_result = (array)$did_result->first_row();
+		if ($did_result['accountid'] > 0 || $did_result['parent_id'] > 0) {
+		 $data['accountid'] = $did_result['accountid'];
+		 $data['parent_id'] = $did_result['parent_id'];
 		}
 	/**
 	  ASTPP  3.0 
 	  In did edit last modified date and assign date update
 	 **/
-		$data['last_modified_date']=gmdate("Y-m-d H:i:s");
-		if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
-		$data['assign_date']=gmdate("Y-m-d H:i:s");
+		$data['last_modified_date'] = gmdate("Y-m-d H:i:s");
+		if ($did_result['accountid'] == 0 && $data['accountid'] > 0) {
+		$data['assign_date'] = gmdate("Y-m-d H:i:s");
 	} 
 	$this->db->where("number", $number);
 	$this->db->where("id", $id);
 	$this->db->update("dids", $data);
 		/**************************************/
-		if($did_result['parent_id'] > 0 ){
-			$update_array['call_type']=$data['call_type'];
-			$update_array['extensions']=$data['extensions'];
+		if ($did_result['parent_id'] > 0) {
+			$update_array['call_type'] = $data['call_type'];
+			$update_array['extensions'] = $data['extensions'];
 			$this->db->where("note", $number);
 			$this->db->update("reseller_pricing", $update_array);
 		}
-		if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
-		$accountinfo=(array)$this->db->get_where('accounts',array("id"=>$data['accountid']))->first_row();
-		$currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id']));
-		$available_bal = $this->db_model->update_balance( $data["setup"], $data['accountid'], "debit");
+		if ($did_result['accountid'] == 0 && $data['accountid'] > 0) {
+		$accountinfo = (array)$this->db->get_where('accounts', array("id"=>$data['accountid']))->first_row();
+		$currency_name = $this->common->get_field_name('currency', "currency", array('id'=>$accountinfo['currency_id']));
+		$available_bal = $this->db_model->update_balance($data["setup"], $data['accountid'], "debit");
 		$this->common->add_invoice_details($accountinfo, "DIDCHRG", $data["setup"], $number);
 		$accountinfo['did_number'] = $number;
 		$country_id = $this->common->get_field_name('country', 'countrycode', $data['country_id']);
 		$accountinfo['did_country_id'] = $country_id;
-		$accountinfo['did_setup'] = $this->common_model->calculate_currency($data['setup'],'',$currency_name,true,true);
-		$accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($data['monthlycost'],'',$currency_name,true,true);
+		$accountinfo['did_setup'] = $this->common_model->calculate_currency($data['setup'], '', $currency_name, true, true);
+		$accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($data['monthlycost'], '', $currency_name, true, true);
 		$accountinfo['did_maxchannels'] = $data['maxchannels'];
 		$this->common->mail_to_users('email_add_did', $accountinfo);
 		}        
 	}
 
 	function getdid_list($flag, $start = 0, $limit = 0) {
-			$accountinfo=$this->session->userdata('accountinfo');
-			$parent_id= $accountinfo['type']==1 ? $accountinfo['reseller_id'] : 0 ;
+			$accountinfo = $this->session->userdata('accountinfo');
+			$parent_id = $accountinfo['type'] == 1 ? $accountinfo['reseller_id'] : 0;
 	    
-		if($accountinfo['type']==1)
+		if ($accountinfo['type'] == 1)
 		{
-		  $where = array('reseller_id' => $accountinfo['id'],"parent_id"=>$parent_id);
+		  $where = array('reseller_id' => $accountinfo['id'], "parent_id"=>$parent_id);
 		if ($flag) {
-		  if($accountinfo['reseller_id'] > 0 ){
-			 $search_string=$this->db_model->build_search_string('did_list_search');
-			 $search_string= !empty($search_string) ? " AND ".$search_string : null;
-			  if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-			$this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+		  if ($accountinfo['reseller_id'] > 0) {
+			 $search_string = $this->db_model->build_search_string('did_list_search');
+			 $search_string = ! empty($search_string) ? " AND ".$search_string : null;
+			  if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+			$this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
 			  }
 			  $this->db->limit($limit, $start);
-			  $query=$this->db->query("SELECT a.note AS number,a.*,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND a.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = a.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=a.note)) AS accountid FROM reseller_pricing AS a where a.reseller_id=".$accountinfo['id']." AND a.parent_id =".$accountinfo['reseller_id'].$search_string);
+			  $query = $this->db->query("SELECT a.note AS number,a.*,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND a.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = a.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=a.note)) AS accountid FROM reseller_pricing AS a where a.reseller_id=".$accountinfo['id']." AND a.parent_id =".$accountinfo['reseller_id'].$search_string);
 		  }
-		  else{
+		  else {
 			$this->db_model->build_search('did_list_search');
 			$query = $this->db_model->select("*,note as number,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND reseller_pricing.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = reseller_pricing.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=reseller_pricing.note)) AS accountid", "reseller_pricing", $where, "note", "desc", $limit, $start);
 		  }
@@ -132,12 +132,12 @@ 
 	      ASTPP  3.0  last_modified_date,assign_date put in query.
 	      */
 		$this->db->select('dids.id,dids.connectcost,dids.includedseconds,dids.last_modified_date,dids.assign_date,dids.number,dids.extensions,dids.call_type,dids.country_id,dids.init_inc,dids.inc,dids.cost,dids.setup,dids.monthlycost,dids.status,(CASE when parent_id > 0 THEN (SELECT reseller_id as accountid from reseller_pricing where dids.number=reseller_pricing.note AND reseller_pricing.parent_id=0) ELSE dids.accountid END ) as accountid');
-				if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-					$this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+				if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+					$this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
 				}
 		/*********************************************************88*/
 		$this->db->limit($limit, $start);
-		$query=$this->db->get('dids');
+		$query = $this->db->get('dids');
 		  } else {
 		$query = $this->db_model->countQuery("*", "dids");
 		  }
@@ -152,19 +152,19 @@ 
 	$where = array('id' => $id);
 	$this->db->where($where);
 	$this->db->select('accountid,number,parent_id');
-	$did_info=(array)$this->db->get('dids')->first_row();
+	$did_info = (array)$this->db->get('dids')->first_row();
 	$this->db->where("id", $id);
 		$this->db->delete("dids");
 		$this->db->where("note", $did_info['number']);
 		$this->db->delete("reseller_pricing");
-		if($did_info['accountid'] == 0 && $did_info['parent_id'] > 0){
-	  $accountinfo=$this->session->userdata('accountinfo');
-	  $did_info['accountid']=$accouninfo['id'];
-	  $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$did_info['parent_id']))->first_row();
+		if ($did_info['accountid'] == 0 && $did_info['parent_id'] > 0) {
+	  $accountinfo = $this->session->userdata('accountinfo');
+	  $did_info['accountid'] = $accouninfo['id'];
+	  $accountinfo = (array)$this->db->get_where('accounts', array("id"=>$did_info['parent_id']))->first_row();
 	  $accountinfo['did_number'] = $accountinfo['number'];
 	  $this->common->mail_to_users('email_remove_did', $accountinfo);
-	} elseif($did_info['accountid'] > 0 ){
-	  $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$did_info['accountid']))->first_row();
+	} elseif ($did_info['accountid'] > 0) {
+	  $accountinfo = (array)$this->db->get_where('accounts', array("id"=>$did_info['accountid']))->first_row();
 	  $accountinfo['did_number'] = $did_info['number'];
 	  $this->common->mail_to_users('email_remove_did', $accountinfo);
 	}
@@ -188,21 +188,21 @@ 
 	}
 
 	function get_account($accountdata) {
-		$q = "SELECT * FROM accounts WHERE number = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$q = "SELECT * FROM accounts WHERE number = '".$this->db->escape_str($accountdata)."' AND status = 0";
 		$query = $this->db->query($q);
 		if ($query->num_rows() > 0) {
 			$row = $query->row_array();
 			return $row;
 		}
 
-		$q = "SELECT * FROM accounts WHERE cc = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$q = "SELECT * FROM accounts WHERE cc = '".$this->db->escape_str($accountdata)."' AND status = 0";
 		$query = $this->db->query($q);
 		if ($query->num_rows() > 0) {
 			$row = $query->row_array();
 			return $row;
 		}
 
-		$q = "SELECT * FROM accounts WHERE accountid = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$q = "SELECT * FROM accounts WHERE accountid = '".$this->db->escape_str($accountdata)."' AND status = 0";
 		$query = $this->db->query($q);
 		if ($query->num_rows() > 0) {
 			$row = $query->row_array();
@@ -237,7 +237,7 @@ 
 				. "dids.dial_as AS dial_as, "
 				. "dids.status AS status "
 				. "FROM dids, reseller_pricing "
-				. "WHERE dids.id = " . $did
+				. "WHERE dids.id = ".$did
 				. " AND reseller_pricing.type = '1' AND reseller_pricing.reseller_id = "
 				. $reseller_id;
 		$query = $this->db->query($sql);
@@ -255,15 +255,15 @@ 
 		else
 			return false;
 	}
-   function edit_did_reseller($did_id,$post) {
+   function edit_did_reseller($did_id, $post) {
 		$accountinfo = $this->session->userdata('accountinfo');
 
-		$where_array=array('reseller_id' => $accountinfo['id'], 'note' => $post['number'], 'type' => '1');
+		$where_array = array('reseller_id' => $accountinfo['id'], 'note' => $post['number'], 'type' => '1');
 	$this->db->where($where_array);
-	$flag='0';
+	$flag = '0';
 		$query = $this->db->get('reseller_pricing');
-		if($query->num_rows() > 0){
-	  $flag='1';
+		if ($query->num_rows() > 0) {
+	  $flag = '1';
 		}
         
 		$this->insert_reseller_pricing($accountinfo, $post);
@@ -305,21 +305,21 @@ 
 	}
 
 	function delete_routes($id, $number, $pricelist_id) {
-		$number = "^" . $number . ".*";
+		$number = "^".$number.".*";
 		$where = array('pricelist_id' => $pricelist_id, 'pattern' => $number);
 		$this->db->where($where);
 		$this->db->delete('routes');
 	}
 
 	function insert_routes($post, $pricelist_id) {
-		$commment = "DID:" . $post['country'] . "," . $post['province'] . "," . $post['city'];
-		$insert_array = array('pattern' => "^" . $post['number'] . ".*", 'comment' => $commment, 'pricelist_id' => $pricelist_id,
+		$commment = "DID:".$post['country'].",".$post['province'].",".$post['city'];
+		$insert_array = array('pattern' => "^".$post['number'].".*", 'comment' => $commment, 'pricelist_id' => $pricelist_id,
 			'connectcost' => $post['connectcost'], 'includedseconds' => $post['included'], 'cost' => $post['cost'], 'inc' => $post['inc']);
 		$this->db->insert('routes', $insert_array);
 		return true;
 	}
 
-	function add_invoice_data($accountid,$charge_type,$description,$credit)
+	function add_invoice_data($accountid, $charge_type, $description, $credit)
 	{
 	$insert_array = array('accountid' => $accountid, 
 				  'charge_type' => $charge_type, 
@@ -335,7 +335,7 @@ 
 	function check_unique_did($number)
 	{
 
-	  $where=array('number'=>$number);
+	  $where = array('number'=>$number);
 	  $query = $this->db_model->countQuery("*", "dids", $where);
 	  return $query;
 	}

Braces +12 added lines, -12 removed lines

@@ -113,8 +113,7 @@ 
 			  }
 			  $this->db->limit($limit, $start);
 			  $query=$this->db->query("SELECT a.note AS number,a.*,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND a.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = a.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=a.note)) AS accountid FROM reseller_pricing AS a where a.reseller_id=".$accountinfo['id']." AND a.parent_id =".$accountinfo['reseller_id'].$search_string);
-		  }
-		  else{
+		  } else{
 			$this->db_model->build_search('did_list_search');
 			$query = $this->db_model->select("*,note as number,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND reseller_pricing.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = reseller_pricing.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=reseller_pricing.note)) AS accountid", "reseller_pricing", $where, "note", "desc", $limit, $start);
 		  }
@@ -123,8 +122,7 @@ 
 		  $query = $this->db_model->countQuery("*", "reseller_pricing", $where);
 		}
 
-		}
-		else
+		} else
 		{	
 		  $this->db_model->build_search('did_list_search');
 		  if ($flag) {
@@ -175,10 +173,11 @@ 
 		$this->db->where("country", ucfirst($field_value));
 		$query = $this->db->get('countrycode');
 		$data = $query->result();
-		if ($query->num_rows > 0)
-			return $data[0]->id;
-		else
-			return '';
+		if ($query->num_rows > 0) {
+					return $data[0]->id;
+		} else {
+					return '';
+		}
 	}
 
 	function bulk_insert_dids($field_value) {
@@ -250,10 +249,11 @@ 
 		$this->db->where("id", $number);
 		$this->db->or_where("number", $number);
 		$query = $this->db->get("dids");
-		if ($query->num_rows() > 0)
-			return $query->row_array();
-		else
-			return false;
+		if ($query->num_rows() > 0) {
+					return $query->row_array();
+		} else {
+					return false;
+		}
 	}
    function edit_did_reseller($did_id,$post) {
 		$accountinfo = $this->session->userdata('accountinfo');

web_interface/astpp/application/modules/did/libraries/did_form.php

Spacing +73 added lines, -73 removed lines

@@ -22,7 +22,7 @@ 
 # 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 did_form {

@@ -31,48 +31,48 @@ 
 		$this->CI = & get_instance();

 	}

 

-	function get_dids_form_fields($id=false,$parent_id='0',$account_id='0') {

-	if ($id != 0){

-	  if($parent_id > 0){

-	  $account_dropdown =  array('Reseller',  array('name' => 'parent_id', 'disabled' => 'disabled','class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"1", "deleted" => "0","status" => "0"));                

-	  }else{

-	  if($account_id > 0){

-		$account_dropdown =  array('Account ',  array('name' => 'accountid', 'disabled' => 'disabled','class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"0,3", "deleted" => "0","status" => "0"));

+	function get_dids_form_fields($id = false, $parent_id = '0', $account_id = '0') {

+	if ($id != 0) {

+	  if ($parent_id > 0) {

+	  $account_dropdown = array('Reseller', array('name' => 'parent_id', 'disabled' => 'disabled', 'class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type"=>"1", "deleted" => "0", "status" => "0"));                

+	  } else {

+	  if ($account_id > 0) {

+		$account_dropdown = array('Account ', array('name' => 'accountid', 'disabled' => 'disabled', 'class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type"=>"0,3", "deleted" => "0", "status" => "0"));

 	  }

-	  else{

-		$account_dropdown = array('Account', 'accountid', 'SELECT', '',array("name"=>"accountid","rules"=>"did_account_checking"), 'tOOL TIP', 'Please Enter account number', 'id',  'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type" => "0,3","deleted" => "0","status" => "0" ));

+	  else {

+		$account_dropdown = array('Account', 'accountid', 'SELECT', '', array("name"=>"accountid", "rules"=>"did_account_checking"), 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type" => "0,3", "deleted" => "0", "status" => "0"));

 	  }

 	  }

-   } else{

-	$account_dropdown = array('Account', 'accountid', 'SELECT','' , array("name"=>"accountid","rules"=>"did_account_checking"), 'tOOL TIP', 'Please Enter account number', 'id',  'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type" => "0,3", "deleted" => "0","status" => "0" ));

+   } else {

+	$account_dropdown = array('Account', 'accountid', 'SELECT', '', array("name"=>"accountid", "rules"=>"did_account_checking"), 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type" => "0,3", "deleted" => "0", "status" => "0"));

    }

 

-	$val= $id > 0 ? 'dids.number.'.$id : 'dids.number';

-		$form['forms'] = array(base_url() . '/did/did_save/', array('id' => 'did_form', 'method' => 'POST', 'name' => 'did_form'));

+	$val = $id > 0 ? 'dids.number.'.$id : 'dids.number';

+		$form['forms'] = array(base_url().'/did/did_save/', array('id' => 'did_form', 'method' => 'POST', 'name' => 'did_form'));

 		$form['DID Information'] = array(

 			array('', 'HIDDEN', array('name' => 'id'), '', '', '', ''),

 			array('DID', 'INPUT', array('name' => 'number', 'size' => '20', 'class' => "text field medium"), 'trim|required|is_numeric|xss_clean|integer', 'tOOL TIP', 'Please Enter account number'),

-			  array('Country',array('name'=>'country_id','class'=>'country_id'), 'SELECT', '',array("name"=>"country_id","rules"=>"required"), 'tOOL TIP', 'Please Enter account number', 'id', 'country', 'countrycode', 'build_dropdown', '', ''),

+			  array('Country', array('name'=>'country_id', 'class'=>'country_id'), 'SELECT', '', array("name"=>"country_id", "rules"=>"required"), 'tOOL TIP', 'Please Enter account number', 'id', 'country', 'countrycode', 'build_dropdown', '', ''),

 			array('City', 'INPUT', array('name' => 'city', 'size' => '20', 'class' => "text field medium"), '', 'tOOL TIP', 'Please Enter Password'),

 			array('Province', 'INPUT', array('name' => 'province', 'size' => '15', 'class' => "text field medium"), '', 'tOOL TIP', 'Please Enter Password'),

-			array('Provider', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("type" => "3", "deleted" => "0","status" => "0")),

+			array('Provider', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("type" => "3", "deleted" => "0", "status" => "0")),

 		);

 

 		$form['Billing Information'] = array(

 			$account_dropdown,    

-			array('Connection Cost', 'INPUT', array('name' => 'connectcost', 'size' => '15',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),       

-			array('Included Seconds', 'INPUT', array('name' => 'includedseconds', 'size' => '50',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

-			array('Per Minute Cost', 'INPUT', array('name' => 'cost', 'size' => '15',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

-			array('Initial Increment', 'INPUT', array('name' => 'init_inc', 'size' => '20',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Initial Increment'),

-			array('Increment', 'INPUT', array('name' => 'inc', 'size' => '20',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Increment'),

-			array('Setup Fee', 'INPUT', array('name' => 'setup',  'size' => '15', 'class' => 'text field medium'), 'trim|is_numeric|xss_clean', 'tOOL TIP', ''),

-			array('Monthly<br>Fee', 'INPUT', array('name' => 'monthlycost', 'size' => '15',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

+			array('Connection Cost', 'INPUT', array('name' => 'connectcost', 'size' => '15', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),       

+			array('Included Seconds', 'INPUT', array('name' => 'includedseconds', 'size' => '50', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

+			array('Per Minute Cost', 'INPUT', array('name' => 'cost', 'size' => '15', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

+			array('Initial Increment', 'INPUT', array('name' => 'init_inc', 'size' => '20', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Initial Increment'),

+			array('Increment', 'INPUT', array('name' => 'inc', 'size' => '20', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Increment'),

+			array('Setup Fee', 'INPUT', array('name' => 'setup', 'size' => '15', 'class' => 'text field medium'), 'trim|is_numeric|xss_clean', 'tOOL TIP', ''),

+			array('Monthly<br>Fee', 'INPUT', array('name' => 'monthlycost', 'size' => '15', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter Password'),

 		);

 

 		$form['DID Setting'] = array(

 			array('Call Type', 'call_type', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_call_type', ''),

 			array('Destination', 'INPUT', array('name' => 'extensions', 'size' => '20', 'class' => "text field medium"), '', 'tOOL TIP', 'Please Enter Password'),

-			array('Concurrent Calls', 'INPUT', array('name' => 'maxchannels', 'size' => '20',  'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter account number'),

+			array('Concurrent Calls', 'INPUT', array('name' => 'maxchannels', 'size' => '20', 'class' => "text field medium"), 'trim|is_numeric|xss_clean', 'tOOL TIP', 'Please Enter account number'),

 			array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Select Status', '', '', '', 'set_status'),

 

 		);

@@ -91,13 +91,13 @@ 
 		$form['Search'] = array(

 			array('DID', 'INPUT', array('name' => 'number[number]', '', 'size' => '20', 'class' => "text field"), '', 'tOOL TIP', '1', 'number[number-string]', '', '', '', 'search_string_type', ''),

 			array('Country', 'country_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'country', 'countrycode', 'build_dropdown', '', ''),

-			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"0", "deleted" => "0")),

+			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type"=>"0", "deleted" => "0")),

 			array('Initial Increment', 'INPUT', array('name' => 'init_inc[init_inc]', '', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', 'init_inc[init_inc-integer]', '', '', '', 'search_int_type', ''),

-			array('Call Type', 'call_type', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_call_type_search', '',''),

+			array('Call Type', 'call_type', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_call_type_search', '', ''),

 			array('Destination', 'INPUT', array('name' => 'extensions[extensions]', '', 'size' => '20', 'class' => "text field"), '', 'tOOL TIP', '1', 'extensions[extensions-string]', '', '', '', 'search_string_type', ''),

 		array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_search_status', '', ''),

             

-		array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', '')

+		array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', '')

 		  );

 

 		$form['button_search'] = array('name' => 'action', 'id' => "did_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

@@ -112,11 +112,11 @@ 
 		$form['forms'] = array("", array('id' => "did_search"));

 		$form['Search'] = array(

 			array('DID', 'INPUT', array('name' => 'note[note]', '', 'size' => '20', 'class' => "text field"), '', 'tOOL TIP', '1', 'note[note-string]', '', '', '', 'search_string_type', ''),

- 	  array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"0", "deleted" => "0")),

-	   array('Call Type', 'call_type', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_call_type_search', '',''),

+ 	  array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type"=>"0", "deleted" => "0")),

+	   array('Call Type', 'call_type', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_call_type_search', '', ''),

 	  array('Destination', 'INPUT', array('name' => 'extensions[extensions]', '', 'size' => '20', 'class' => "text field"), '', 'tOOL TIP', '1', 'extensions[extensions-string]', '', '', '', 'search_string_type', ''),

 	  array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_search_status', '', ''),

-	  array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', '')

+	  array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', '')

 		  );

 

 		$form['button_search'] = array('name' => 'action', 'id' => "did_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

@@ -131,31 +131,31 @@ 
     */

 	function build_did_list_for_admin() {

 		  $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-	$currency_id=$account_info['currency_id'];

-	 $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+	$currency_id = $account_info['currency_id'];

+	 $currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 		

 		

 	   // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

-		$grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),

+		$grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),

 

 /**

 ASTPP  3.0 

 For DID edit on DID number

 **/

-			array(gettext("DID"), "80", "number", "", "", "","EDITABLE","true","center"),

-			array(gettext("Country"), "60", "country_id", "country", "countrycode", "get_field_name","","true","center"),

+			array(gettext("DID"), "80", "number", "", "", "", "EDITABLE", "true", "center"),

+			array(gettext("Country"), "60", "country_id", "country", "countrycode", "get_field_name", "", "true", "center"),

 			array(gettext("Account"), "95", "accountid", "first_name,last_name,number", "accounts", "get_field_name_coma_new"),

-			array("Per Minute <br>Cost($currency)", "85", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-			array(gettext("Initial <br>Increment"), "80", "init_inc", "", "", "","","true","center"),

-			array(gettext("Increment"), "90", "inc", "", "", "","","true","center"),

-			array("Setup <br>Fee($currency)", "70", "setup", "setup", "setup", "convert_to_currency","","true","right"),

-			array("Monthly<br>Fee($currency)", "90", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency","","true","right"),

-			array(gettext("Call Type"), "90", "call_type", "call_type", "call_type", "get_call_type","","true","center"),

-			array(gettext("Destination"), "80", "extensions", "", "", "","","true","center"),       

-			array(gettext("Status"), "90", "status", "status", "dids", "get_status","","true","center"),

-			array(gettext("Modified <br/>Date"), "90", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to","","true","center"),

-			array(gettext("Is Purchased?"), "110", "number", "number", "number", "check_did_avl","","true","center"),

-			array("Action", "100", "", "", "", array("EDIT" => array("url" => "did/did_edit/", "mode" => "popup","layout"=>"medium"),

+			array("Per Minute <br>Cost($currency)", "85", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+			array(gettext("Initial <br>Increment"), "80", "init_inc", "", "", "", "", "true", "center"),

+			array(gettext("Increment"), "90", "inc", "", "", "", "", "true", "center"),

+			array("Setup <br>Fee($currency)", "70", "setup", "setup", "setup", "convert_to_currency", "", "true", "right"),

+			array("Monthly<br>Fee($currency)", "90", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency", "", "true", "right"),

+			array(gettext("Call Type"), "90", "call_type", "call_type", "call_type", "get_call_type", "", "true", "center"),

+			array(gettext("Destination"), "80", "extensions", "", "", "", "", "true", "center"),       

+			array(gettext("Status"), "90", "status", "status", "dids", "get_status", "", "true", "center"),

+			array(gettext("Modified <br/>Date"), "90", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to", "", "true", "center"),

+			array(gettext("Is Purchased?"), "110", "number", "number", "number", "check_did_avl", "", "true", "center"),

+			array("Action", "100", "", "", "", array("EDIT" => array("url" => "did/did_edit/", "mode" => "popup", "layout"=>"medium"),

 					"DELETE" => array("url" => "did/did_remove/", "mode" => "single")))

 			));

 		return $grid_field_arr;

@@ -167,22 +167,22 @@ 
      */

 		function build_did_list_for_reseller_login() {

 	 $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-	 	$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);	

+		$currency_id = $account_info['currency_id'];

+	 	$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);	

 		// array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

 		$grid_field_arr = json_encode(array(

-			array("DID", "90", "number", "", "", "","EDITABLE","","true","center"),

-			array("Account", "100", "accountid", "first_name,last_name,number", "accounts", "get_field_name_coma_new","","true","center"),

-			array("Per Minute<br>Cost($currency)", "80", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-			array("Initial <br>Increment", "100", "init_inc", "", "", "","","true","center"),

-			array("Increment", "95", "inc", "", "", "","","true","center"),

-			array("Setup <br> Fee($currency)", "90", "setup", "setup", "setup", "convert_to_currency","","true","right"),

-			array("Monthly<br> fee($currency)", "90", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency","","true","right"),

-			array("Call Type", "80", "call_type", "call_type", "call_type", "get_call_type","","true","center"),

-			array("Destination", "95", "extensions", "", "", "","","true","center"),

-			array("Status", "90", "status", "status", "reseller_pricing", "get_status","","true","center"),

-			array("Modified Date", "130", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to","","true","center"),

-			array("Is purchased?", "100", "number", "number", "number", "check_did_avl_reseller","","true","center"),

+			array("DID", "90", "number", "", "", "", "EDITABLE", "", "true", "center"),

+			array("Account", "100", "accountid", "first_name,last_name,number", "accounts", "get_field_name_coma_new", "", "true", "center"),

+			array("Per Minute<br>Cost($currency)", "80", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+			array("Initial <br>Increment", "100", "init_inc", "", "", "", "", "true", "center"),

+			array("Increment", "95", "inc", "", "", "", "", "true", "center"),

+			array("Setup <br> Fee($currency)", "90", "setup", "setup", "setup", "convert_to_currency", "", "true", "right"),

+			array("Monthly<br> fee($currency)", "90", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency", "", "true", "right"),

+			array("Call Type", "80", "call_type", "call_type", "call_type", "get_call_type", "", "true", "center"),

+			array("Destination", "95", "extensions", "", "", "", "", "true", "center"),

+			array("Status", "90", "status", "status", "reseller_pricing", "get_status", "", "true", "center"),

+			array("Modified Date", "130", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to", "", "true", "center"),

+			array("Is purchased?", "100", "number", "number", "number", "check_did_avl_reseller", "", "true", "center"),

 		array("Action", "90", "", "", "", array("EDIT" => array("url" => "did/did_reseller_edit/edit/", "mode" => "popup"),

 					"DELETE" => array("url" => "did/did_reseller_edit/delete/", "mode" => "single")))

 				));

@@ -191,27 +191,27 @@ 
 	/************************************************************************/

 	function build_grid_buttons() {

 		$buttons_json = json_encode(array(

-			array(gettext("Create"),"btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/did/did_add/", "popup","medium"),

-			array(gettext("Delete"), "btn btn-line-danger","fa fa-times-circle fa-lg", "button_action", "/did/did_delete_multiple/"),

-			array(gettext("Import"), "btn btn-line-blue","fa fa-upload fa-lg", "button_action", "/did/did_import/", '',"small"),            

-			array(gettext("Export"),"btn btn-xing" ,"fa fa-download fa-lg", "button_action", "/did/did_export_data_xls", 'single')

+			array(gettext("Create"), "btn btn-line-warning btn", "fa fa-plus-circle fa-lg", "button_action", "/did/did_add/", "popup", "medium"),

+			array(gettext("Delete"), "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/did/did_delete_multiple/"),

+			array(gettext("Import"), "btn btn-line-blue", "fa fa-upload fa-lg", "button_action", "/did/did_import/", '', "small"),            

+			array(gettext("Export"), "btn btn-xing", "fa fa-download fa-lg", "button_action", "/did/did_export_data_xls", 'single')

 			));

 		return $buttons_json;

 	}

 

 	function build_did_list_for_customer($accountid, $accounttype) {

 	$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-	$currency_id=$account_info['currency_id'];

-	$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+	$currency_id = $account_info['currency_id'];

+	$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 		// array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

 		$grid_field_arr = json_encode(array(

-	array("DID", "110", "number", "", "", "","","true","center"),

-	array("Country", "110", "country_id", "country", "countrycode", "get_field_name","","true","center"),

-	array("Per Minute Cost($currency)", "150", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-	array("Initial Increment", "140", "init_inc", "", "", "","","true","center"),

-	array("Increment", "120", "inc", "", "", "","","true","center"),

-	array("Setup Fee($currency)", "140", "setup", "setup", "setup", "convert_to_currency","","true","right"),

-	array("Monthly Fee($currency)", "140", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency","","true","right"),

+	array("DID", "110", "number", "", "", "", "", "true", "center"),

+	array("Country", "110", "country_id", "country", "countrycode", "get_field_name", "", "true", "center"),

+	array("Per Minute Cost($currency)", "150", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+	array("Initial Increment", "140", "init_inc", "", "", "", "", "true", "center"),

+	array("Increment", "120", "inc", "", "", "", "", "true", "center"),

+	array("Setup Fee($currency)", "140", "setup", "setup", "setup", "convert_to_currency", "", "true", "right"),

+	array("Monthly Fee($currency)", "140", "monthlycost", "monthlycost", "monthlycost", "convert_to_currency", "", "true", "right"),

 	array("Action", "110", "", "", "", array("DELETE" => array("url" => "accounts/".$accounttype."_dids_action/delete/$accountid/$accounttype/", "mode" => "single")))

 		));

 		return $grid_field_arr;

Braces +5 added lines, -5 removed lines

@@ -22,8 +22,9 @@ 
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.

 ###############################################################################

 

-if (!defined('BASEPATH'))

-	exit('No direct script access allowed');

+if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 

 class did_form {

 

@@ -35,11 +36,10 @@ 
 	if ($id != 0){

 	  if($parent_id > 0){

 	  $account_dropdown =  array('Reseller',  array('name' => 'parent_id', 'disabled' => 'disabled','class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"1", "deleted" => "0","status" => "0"));                

-	  }else{

+	  } else{

 	  if($account_id > 0){

 		$account_dropdown =  array('Account ',  array('name' => 'accountid', 'disabled' => 'disabled','class' => 'accountid', 'id' => 'accountid'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"0,3", "deleted" => "0","status" => "0"));

-	  }

-	  else{

+	  } else{

 		$account_dropdown = array('Account', 'accountid', 'SELECT', '',array("name"=>"accountid","rules"=>"did_account_checking"), 'tOOL TIP', 'Please Enter account number', 'id',  'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type" => "0,3","deleted" => "0","status" => "0" ));

 	  }

 	  }

web_interface/astpp/application/modules/did/views/view_import_did.php

Spacing +11 added lines, -11 removed lines

@@ -15,12 +15,12 @@ 
               <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>
                    <h3 class="padding-t-10 padding-l-16">File must be in the following format(.csv):</h3>
-            <p><?= $fields;?></p>
+            <p><?= $fields; ?></p>
                  </div>
                </div>
                <div class="col-md-12  no-padding">
@@ -30,7 +30,7 @@ 
                            <div class="col-md-12 no-padding">
                                <label class="col-md-3">Provider:</label>
                                <div>
-                               <? $provider_id = form_dropdown('provider_id', $this->db_model->build_concat_select_dropdown("id,first_name,number", " accounts", "where_arr", array("type" => "3","status"=>"0","deleted" => "0")), '');
+                               <? $provider_id = form_dropdown('provider_id', $this->db_model->build_concat_select_dropdown("id,first_name,number", " accounts", "where_arr", array("type" => "3", "status"=>"0", "deleted" => "0")), '');
 							echo $provider_id;
 							  ?> </div>
                            </div>
@@ -84,24 +84,24 @@ 
 <?php }?>    
         
 <?php
-	if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?>
+	if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { ?>
  <section class="slice color-three">
 	<div class="w-section inverse no-padding">
            <div class="container">
 	<div class="row">
              
         <div class="col-md-12 margin-t-10">        
-            <form id="import_form" name="import_form" action="<?=base_url()?>did/did_import_file/<?= $provider_id?>/<?=$check_header;?>/" method="POST">
+            <form id="import_form" name="import_form" action="<?=base_url()?>did/did_import_file/<?= $provider_id?>/<?=$check_header; ?>/" method="POST">
             <table width="100%" border="1"  class="details_table table">
-                <?php  $cnt =0;
-					foreach($csv_tmp_data as $csv_key => $csv_value){
-						if($csv_key <  15){
+                <?php  $cnt = 0;
+					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) {
 					$cnt++;
 									echo "<th>".ucfirst($field_name)."</th>";
-								}else{
+								} else {
 									echo "<td class='portlet-content'>".$field_val."</td>";   
 								}
 							}

Braces +1 added lines, -1 removed lines

@@ -101,7 +101,7 @@
 								if($csv_key == 0){
 					$cnt++;
 									echo "<th>".ucfirst($field_name)."</th>";
-								}else{
+								} else{
 									echo "<td class='portlet-content'>".$field_val."</td>";   
 								}
 							}

web_interface/astpp/application/modules/did/views/view_did_manage_reseller_add.php

Spacing +3 added lines, -3 removed lines

@@ -46,9 +46,9 @@
         	      <li class="col-md-12">
                         <label class="col-md-3 no-padding">Call Type</label>
                   		  <select name="call_type" class="col-md-5 form-control selectpicker" data-live-search='true'>
-                  		  <?php $calltype=$this->common->set_call_type();
-				  			 foreach($calltype as $key=>$value){
-				  			   $selected=$reseller_didinfo['call_type']==$key ? "selected='selected'" : '';
+                  		  <?php $calltype = $this->common->set_call_type();
+				  			 foreach ($calltype as $key=>$value) {
+				  			   $selected = $reseller_didinfo['call_type'] == $key ? "selected='selected'" : '';
 				  			   echo "<option value='$key'$selected>$value</option>";
 				  			 }
 				  			 ?>

web_interface/astpp/application/modules/reports/models/reports_model.php

Spacing +64 added lines, -64 removed lines

@@ -29,31 +29,31 @@ 
 ASTPP  3.0 
     For Detail Customer Report List,Export
 **/
-	function getcustomer_cdrs($flag, $start, $limit,$export =false) {
+	function getcustomer_cdrs($flag, $start, $limit, $export = false) {
 		$this->db_model->build_search('customer_cdr_list_search');
 		$account_data = $this->session->userdata("accountinfo");
-		$where['reseller_id']=$account_data['type']== 1 ? $account_data['id']:0;
+		$where['reseller_id'] = $account_data['type'] == 1 ? $account_data['id'] : 0;
 		//$where['type']=0;
-		if($this->session->userdata('advance_search') != 1){
-		$where['callstart >= ']=date("Y-m-d")." 00:00:00";
-			$where['callstart <=']=date("Y-m-d")." 23:59:59";
+		if ($this->session->userdata('advance_search') != 1) {
+		$where['callstart >= '] = date("Y-m-d")." 00:00:00";
+			$where['callstart <='] = date("Y-m-d")." 23:59:59";
 		}
 
-		$types = array('0','3');
+		$types = array('0', '3');
 		//$this->db->or_where_in('type', $types);    
 		$this->db->where_in('type', $types);  
 		
 		$this->db->where($where);
-		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
+			if ( ! $export)
 				$this->db->limit($limit, $start);
 			$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,disposition,debit,cost,accountid,pricelist_id,calltype,is_recording,trunk_id,uniqueid');
-		}else {
+		} else {
 			$this->db->select('count(*) as count,sum(billseconds) as billseconds,sum(debit) as total_debit,sum(cost) as total_cost,group_concat(distinct(pricelist_id)) as pricelist_ids,group_concat(distinct(trunk_id)) as trunk_ids,group_concat(distinct(accountid)) as accounts_ids');
 		}
 		$result = $this->db->get('cdrs');
@@ -62,23 +62,23 @@ 
 /*
  * Below function using by Detail reseller report
  */
-	function getreseller_cdrs($flag, $start, $limit,$export=false) {
+	function getreseller_cdrs($flag, $start, $limit, $export = false) {
 		$this->db_model->build_search('reseller_cdr_list_search');
 		$account_data = $this->session->userdata("accountinfo");
-		$where['reseller_id']=$account_data['type']== 1 ? $account_data['id']:0;
-		$where["accountid <>"]=$account_data['type']== 1 ? $account_data['id']:0;
-	if($this->session->userdata('advance_search') != 1){
-		$where['callstart >= ']=date("Y-m-d")." 00:00:00";
-			$where['callstart <=']=date("Y-m-d")." 23:59:59";
+		$where['reseller_id'] = $account_data['type'] == 1 ? $account_data['id'] : 0;
+		$where["accountid <>"] = $account_data['type'] == 1 ? $account_data['id'] : 0;
+	if ($this->session->userdata('advance_search') != 1) {
+		$where['callstart >= '] = date("Y-m-d")." 00:00:00";
+			$where['callstart <='] = date("Y-m-d")." 23:59:59";
 		}
 		$this->db->where($where);
-		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
+			if ( ! $export)
 				$this->db->limit($limit, $start);
 				$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,disposition,debit,cost,accountid,pricelist_id,calltype');
 		} else {
@@ -89,48 +89,48 @@ 
 	}
 		/*Below function using by Detail provider report
   */
-	function getprovider_cdrs($flag, $start, $limit,$export=false) {
+	function getprovider_cdrs($flag, $start, $limit, $export = false) {
 		$this->db_model->build_search('provider_cdr_list_search');
 		$account_data = $this->session->userdata("accountinfo");
-		$where=array();
-		if($account_data['type']== 3 ){ 
-			$where['provider_id']= $account_data['id'];
+		$where = array();
+		if ($account_data['type'] == 3) { 
+			$where['provider_id'] = $account_data['id'];
 		}
         
-		if($this->session->userdata('advance_search') != 1){
-		$where['callstart >= ']=date("Y-m-d")." 00:00:00";
-			$where['callstart <=']=date("Y-m-d")." 23:59:59";
+		if ($this->session->userdata('advance_search') != 1) {
+		$where['callstart >= '] = date("Y-m-d")." 00:00:00";
+			$where['callstart <='] = date("Y-m-d")." 23:59:59";
 		}
 		$this->db->where('trunk_id !=', '');
 		$this->db->where($where);
-		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
+			if ( ! $export)
 				$this->db->limit($limit, $start);
 			$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,provider_call_cost,disposition,provider_id,cost');
-		}else {
+		} else {
 			$this->db->select('count(*) as count,sum(billseconds) as billseconds,sum(cost) as total_cost');
 		}
 		$result = $this->db->get('cdrs');
 	  //  echo $this->db->last_query();
 		return $result;
 	}
-	 function users_cdrs_list($flag,$accountid,$entity_type,$start,$limit) {
+	 function users_cdrs_list($flag, $accountid, $entity_type, $start, $limit) {
 		$where = "callstart >= '".date('Y-m-d 00:00:00')."' AND callstart <='".date('Y-m-d 23:59:59')."' AND ";
-		$account_type= $entity_type =='provider' ? 'provider_id' :'accountid';
-		$where.="accountid = '".$accountid."' ";
+		$account_type = $entity_type == 'provider' ? 'provider_id' : 'accountid';
+		$where .= "accountid = '".$accountid."' ";
 		//~ if($entity_type == 'provider'){
 		 //~ $where.="OR provider_id = '".$accountid."'";
 		//~ }
-		$table=$entity_type=='reseller'?'reseller_cdrs' : 'cdrs';
+		$table = $entity_type == 'reseller' ? 'reseller_cdrs' : 'cdrs';
 		if ($flag) {
 			$query = $this->db_model->select("*", $table, $where, "callstart", "DESC", $limit, $start);
 		} else {
-			$query = $this->db_model->countQuery("*",$table, $where);
+			$query = $this->db_model->countQuery("*", $table, $where);
 		}
 		return $query;
 
@@ -154,13 +154,13 @@ 
 		return $query;
 	}
 
-	function get_refill_list($flag, $start, $limit,$export=false) {
+	function get_refill_list($flag, $start, $limit, $export = false) {
 		$this->db_model->build_search('cdr_refill_search');
 		$accountinfo = $this->session->userdata('accountinfo');
-		$where['payment_by']=$accountinfo['type']==1 ? $accountinfo['id']:-1;
+		$where['payment_by'] = $accountinfo['type'] == 1 ? $accountinfo['id'] : -1;
 		if ($flag) {
-			if($export)
-		  $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC","","");
+			if ($export)
+		  $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC", "", "");
 			else
 		   $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC", $limit, $start);
 		} else {
@@ -179,10 +179,10 @@ 
 			$reseller_id = "0";
 		}
 		if ($flag) {
-			$query = $this->db_model->select_by_in("*", "commission","" , "date", "DESC", $limit, $start,"","reseller_id",$reseller_id);
+			$query = $this->db_model->select_by_in("*", "commission", "", "date", "DESC", $limit, $start, "", "reseller_id", $reseller_id);
 
 		} else {
-			$query = $this->db_model->countQuery_by_in("*", "commission", "","reseller_id",$reseller_id);
+			$query = $this->db_model->countQuery_by_in("*", "commission", "", "reseller_id", $reseller_id);
 		}
 
 		return $query;
@@ -192,22 +192,22 @@ 
 Charge History
 ***********/
 	function getcharges_list($flag, $start = 0, $limit = 0) {
-	$accountinfo=$this->session->userdata('accountinfo');
-	$reseller_id=$accountinfo['id'];
-	if($accountinfo['type'] == 1){
-		$where['reseller_id']=$reseller_id;
-	} else{
-		$where['reseller_id']=0;
+	$accountinfo = $this->session->userdata('accountinfo');
+	$reseller_id = $accountinfo['id'];
+	if ($accountinfo['type'] == 1) {
+		$where['reseller_id'] = $reseller_id;
+	} else {
+		$where['reseller_id'] = 0;
 	}
-	if($this->session->userdata('advance_search') != 1){
-		$where['created_date >=']=gmdate("Y-m-01 00:00:01");
-		$where['created_date <=']=gmdate("Y-m-d 23:59:59");
+	if ($this->session->userdata('advance_search') != 1) {
+		$where['created_date >='] = gmdate("Y-m-01 00:00:01");
+		$where['created_date <='] = gmdate("Y-m-d 23:59:59");
 	}
 	$this->db_model->build_search('charges_list_search');
 	$this->db->where($where);
-	$whr= "( invoiceid =0 OR invoiceid in (  select id  from invoices where confirm = 1) )";
+	$whr = "( invoiceid =0 OR invoiceid in (  select id  from invoices where confirm = 1) )";
 	$this->db->where($whr);
-	$this->db->where('item_type <>','STANDARD');
+	$this->db->where('item_type <>', 'STANDARD');
 	if ($flag) {
 		$query = $this->db_model->select('*', "invoice_details", "", "id", "DESC", $limit, $start);
 	} else {
@@ -220,15 +220,15 @@ 
 	/* ASTPP  3.0 
      * This function using for customer edit
      */
-   function get_customer_charge_list($flag,$accountid,$start = 0, $limit = 0){
+   function get_customer_charge_list($flag, $accountid, $start = 0, $limit = 0) {
 		$this->db_model->build_search('charges_list_search');
-		$accountinfo=$this->session->userdata('accountinfo');
-		$reseller_id=$accountinfo['type']==1 ? $accountinfo['id'] : 0;
-		$where['reseller_id']=$reseller_id;
-		$where['accountid']=$accountid;
-		if($this->session->userdata('advance_search') != 1){
-			 $where['created_date >=']=gmdate("Y-m-1 00:00:00");
-			 $where['created_date <=']=gmdate("Y-m-d 23:59:59");
+		$accountinfo = $this->session->userdata('accountinfo');
+		$reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;
+		$where['reseller_id'] = $reseller_id;
+		$where['accountid'] = $accountid;
+		if ($this->session->userdata('advance_search') != 1) {
+			 $where['created_date >='] = gmdate("Y-m-1 00:00:00");
+			 $where['created_date <='] = gmdate("Y-m-d 23:59:59");
 		}
 		if ($flag) {
 			$query = $this->db_model->select("*", "invoice_details", $where, "id", "DESC", $limit, $start);
@@ -237,7 +237,7 @@ 
 		}
 		return $query;        
 	}
-	function get_customer_refillreport($flag,$accountid,$start = 0, $limit = 0){
+	function get_customer_refillreport($flag, $accountid, $start = 0, $limit = 0) {
 		$where = array("accountid"=>$accountid);
 		if ($flag) {
 			$query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC", $limit, $start);

Braces +19 added lines, -15 removed lines

@@ -46,14 +46,15 @@ 
 		$this->db->where($where);
 		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		} else{
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
-				$this->db->limit($limit, $start);
+			if (!$export) {
+							$this->db->limit($limit, $start);
+			}
 			$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,disposition,debit,cost,accountid,pricelist_id,calltype,is_recording,trunk_id,uniqueid');
-		}else {
+		} else {
 			$this->db->select('count(*) as count,sum(billseconds) as billseconds,sum(debit) as total_debit,sum(cost) as total_cost,group_concat(distinct(pricelist_id)) as pricelist_ids,group_concat(distinct(trunk_id)) as trunk_ids,group_concat(distinct(accountid)) as accounts_ids');
 		}
 		$result = $this->db->get('cdrs');
@@ -74,12 +75,13 @@ 
 		$this->db->where($where);
 		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		} else{
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
-				$this->db->limit($limit, $start);
+			if (!$export) {
+							$this->db->limit($limit, $start);
+			}
 				$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,disposition,debit,cost,accountid,pricelist_id,calltype');
 		} else {
 		   $this->db->select('count(*) as count,sum(billseconds) as billseconds,sum(debit) as total_debit,sum(cost) as total_cost,group_concat(distinct(pricelist_id)) as pricelist_ids');
@@ -105,14 +107,15 @@ 
 		$this->db->where($where);
 		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		} else{
 		   $this->db->order_by("callstart desc");
 		}
 		if ($flag) {
-			if (!$export)
-				$this->db->limit($limit, $start);
+			if (!$export) {
+							$this->db->limit($limit, $start);
+			}
 			$this->db->select('callstart,callerid,callednum,pattern,notes,billseconds,provider_call_cost,disposition,provider_id,cost');
-		}else {
+		} else {
 			$this->db->select('count(*) as count,sum(billseconds) as billseconds,sum(cost) as total_cost');
 		}
 		$result = $this->db->get('cdrs');
@@ -159,10 +162,11 @@ 
 		$accountinfo = $this->session->userdata('accountinfo');
 		$where['payment_by']=$accountinfo['type']==1 ? $accountinfo['id']:-1;
 		if ($flag) {
-			if($export)
-		  $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC","","");
-			else
-		   $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC", $limit, $start);
+			if($export) {
+					  $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC","","");
+			} else {
+					   $query = $this->db_model->select("*", "payments", $where, "payment_date", "DESC", $limit, $start);
+			}
 		} else {
 			$query = $this->db_model->countQuery("*", "payments", $where);
 		}

web_interface/astpp/application/modules/reports/controllers/reports.php

Spacing +203 added lines, -203 removed lines

@@ -39,7 +39,7 @@ 
 		$this->fpdf->initialize('P', 'mm', 'A4');
 
 		if ($this->session->userdata('user_login') == FALSE)
-			redirect(base_url() . '/astpp/login');
+			redirect(base_url().'/astpp/login');
 	}
 
 	function customerReport() {
@@ -59,7 +59,7 @@ 
 
 	function customerReport_json() {
 		$count_res = $this->reports_model->getcustomer_cdrs(false, "", "");
-		$count_all = (array) $count_res->first_row();
+		$count_all = (array)$count_res->first_row();
 		$paging_data = $this->form->load_grid_config($count_all['count'], $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
 		$query = $this->reports_model->getcustomer_cdrs(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
@@ -69,10 +69,10 @@ 
 			$trunk_arr = array();
 			// Get search information from session.
 			$search_arr = $this->session->userdata('customer_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
 			$query = $query->result_array();
 
-			$where = "id IN (" . $count_all['pricelist_ids'] . ")";
+			$where = "id IN (".$count_all['pricelist_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,name');
 			$pricelist_res = $this->db->get('pricelists');
@@ -80,7 +80,7 @@ 
 			foreach ($pricelist_res as $value) {
 				$pricelist_arr[$value['id']] = $value['name'];
 			}
-			$where = "id IN (" . $count_all['trunk_ids'] . ")";
+			$where = "id IN (".$count_all['trunk_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,name');
 			$trunk_res = $this->db->get('trunks');
@@ -88,22 +88,22 @@ 
 			foreach ($trunk_res as $value) {
 				$trunk_arr[$value['id']] = $value['name'];
 			}
-			$where = "id IN (" . $count_all['accounts_ids'] . ")";
+			$where = "id IN (".$count_all['accounts_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,number,first_name,last_name');
 			$account_res = $this->db->get('accounts');
 			foreach ($account_res->result_array() as $value) {
-				$account_arr[$value['id']] =$value['first_name'] . " " . $value['last_name'] . ' (' . $value['number'] . ')';
+				$account_arr[$value['id']] = $value['first_name']." ".$value['last_name'].' ('.$value['number'].')';
 			}            
             
 			//Get Decimal points,system currency and user currency.
 			$currency_info = $this->common->get_currency_info();
 			foreach ($query as $value) {
-				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
-							 sprintf('%02d',$value['billseconds'] / 60) . ":" . sprintf('%02d', $value['billseconds'] % 60) : "00:00"  : $value['billseconds'];
-				$account=isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
+				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0) ?
+							 sprintf('%02d', $value['billseconds'] / 60).":".sprintf('%02d', $value['billseconds'] % 60) : "00:00" : $value['billseconds'];
+				$account = isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
 				$uid = $value['uniqueid'];
-				$recording = ($value['is_recording'] == 0) ? '<a title="Recording file" href="../customerReport_recording_download/demo.wav"><img src="' . base_url() . 'assets/images/play_file.png" height="20px" width="20px"/></a>' : '<img src="' . base_url() . 'assets/images/false.png" height="20px" alt="file not found" width="20px"/>';
+				$recording = ($value['is_recording'] == 0) ? '<a title="Recording file" href="../customerReport_recording_download/demo.wav"><img src="'.base_url().'assets/images/play_file.png" height="20px" width="20px"/></a>' : '<img src="'.base_url().'assets/images/false.png" height="20px" alt="file not found" width="20px"/>';
 				$json_data['rows'][] = array('cell' => array(
 						$this->common->convert_GMT_to('', '', $value['callstart']),
 						$value['callerid'],
@@ -111,8 +111,8 @@ 
 						filter_var($value['pattern'], FILTER_SANITIZE_NUMBER_INT),
 						$value['notes'],
 						$duration,
-						$this->common->calculate_currency_manually($currency_info, $value['debit'],false),
-						$this->common->calculate_currency_manually($currency_info, $value['cost'],false),
+						$this->common->calculate_currency_manually($currency_info, $value['debit'], false),
+						$this->common->calculate_currency_manually($currency_info, $value['cost'], false),
 						$value['disposition'],
 						$account,
 						isset($trunk_arr[$value['trunk_id']]) ? $trunk_arr[$value['trunk_id']] : '',
@@ -121,8 +121,8 @@ 
 						$recording,
 						));
 			}
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							floor($count_all['billseconds'] / 60) . ":" . sprintf('%02d', $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							floor($count_all['billseconds'] / 60).":".sprintf('%02d', $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$json_data['rows'][] = array("cell" => array(
 					"<b>Grand Total</b>",
 					"",
@@ -131,8 +131,8 @@ 
 					"",
 					"<b>$duration</b>",
 					//$count_all['total_debit'],
-					"<b>".$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'],false)."</b>",
-					"<b>".$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'],false)."</b>",
+					"<b>".$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'], false)."</b>",
+					"<b>".$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'], false)."</b>",
 					"",
 					"",
 					"",
@@ -152,10 +152,10 @@ 
      * **** */
 
 	function customerReport_recording_download($file_name) {
-		$file_name = getcwd() . "/recording/" . $file_name;
+		$file_name = getcwd()."/recording/".$file_name;
 		header('Content-Description: File Transfer');
 		header('Content-Type: application/octet-stream');
-		header('Content-Disposition: attachment; filename=' . basename($file_name));
+		header('Content-Disposition: attachment; filename='.basename($file_name));
 		header('Content-Transfer-Encoding: binary');
 		header('Expires: 0');
 		header('Cache-Control: must-revalidate');
@@ -176,7 +176,7 @@ 
 			$this->session->set_userdata('customer_cdr_list_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'reports/customerReport/');
+			redirect(base_url().'reports/customerReport/');
 		}
 	}
 
@@ -191,23 +191,23 @@ 
 	 * */
 	function customerReport_export() {
 		 $account_info = $accountinfo = $this->session->userdata('accountinfo');
-	 $currency_id=$account_info['currency_id'];
-	 $currency=$this->common->get_field_name('currency', 'currency', $currency_id);
+	 $currency_id = $account_info['currency_id'];
+	 $currency = $this->common->get_field_name('currency', 'currency', $currency_id);
 		 $count_res = $this->reports_model->getcustomer_cdrs(false, "", "");
-		 $count_all = (array) $count_res->first_row();
+		 $count_all = (array)$count_res->first_row();
 		 ob_clean();
 		if ($count_all['count'] > 0) {
 			//Initialization of Rategroup and Trunk Array
 			$pricelist_arr = array();
 			$trunk_arr = array();
-			$account_arr=array();
+			$account_arr = array();
 			$query = $this->reports_model->getcustomer_cdrs(true, '', '', true);
 			//Get Decimal points,system currency and user currency.
 			$currency_info = $this->common->get_currency_info();
 			//Get search information from session.
 			$search_arr = $this->session->userdata('customer_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
-			$where = "id IN (" . $count_all['pricelist_ids'] . ")";
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$where = "id IN (".$count_all['pricelist_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,name');
 			$pricelist_res = $this->db->get('pricelists');
@@ -215,17 +215,17 @@ 
 			foreach ($pricelist_res as $value) {
 				$pricelist_arr[$value['id']] = $value['name'];
 			}
-			$where = "id IN (" . $count_all['accounts_ids'] . ")";
+			$where = "id IN (".$count_all['accounts_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,number,first_name,last_name');
 			$account_res = $this->db->get('accounts');
 			foreach ($account_res->result_array() as $value) {
-				$account_arr[$value['id']] =$value['first_name'] . " " . $value['last_name'] . ' (' . $value['number'] . ')';
+				$account_arr[$value['id']] = $value['first_name']." ".$value['last_name'].' ('.$value['number'].')';
 			}            
             
-			if($accountinfo['type'] !=1){
+			if ($accountinfo['type'] != 1) {
 				$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account", "Trunk", "Rate Group", "Call Type");
-			$where = "id IN (" . $count_all['trunk_ids'] . ")";
+			$where = "id IN (".$count_all['trunk_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,name');
 			$trunk_res = $this->db->get('trunks');
@@ -234,9 +234,9 @@ 
 				$trunk_arr[$value['id']] = $value['name'];
 			}
 		foreach ($query->result_array() as $value) {
-				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
-								floor($value['billseconds'] / 60) . ":" . sprintf('%02d', $value['billseconds'] % 60) : "00:00"  : $value['billseconds'];
-				$account=isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
+				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0) ?
+								floor($value['billseconds'] / 60).":".sprintf('%02d', $value['billseconds'] % 60) : "00:00" : $value['billseconds'];
+				$account = isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
 				$customer_array[] = array(
 					$this->common->convert_GMT_to('', '', $value['callstart']),
 					$value['callerid'],
@@ -244,8 +244,8 @@ 
 					filter_var($value['pattern'], FILTER_SANITIZE_NUMBER_INT),
 					$value['notes'],
 					$duration,
-					$this->common->calculate_currency_manually($currency_info, $value['debit'],false,false),
-					$this->common->calculate_currency_manually($currency_info, $value['cost'],false,false),
+					$this->common->calculate_currency_manually($currency_info, $value['debit'], false, false),
+					$this->common->calculate_currency_manually($currency_info, $value['cost'], false, false),
 					$value['disposition'],
 					$account,
 					isset($trunk_arr[$value['trunk_id']]) ? $trunk_arr[$value['trunk_id']] : '',
@@ -253,16 +253,16 @@ 
 					$value['calltype'],
 				);
 			}
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-			floor($count_all['billseconds'] / 60) . ":" . sprintf('%02d', $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+			floor($count_all['billseconds'] / 60).":".sprintf('%02d', $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$customer_array[] = array("Grand Total",
 				"",
 				"",
 				"",
 				"",
 				$duration,
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'],false,false),
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'],false,false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'], false, false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'], false, false),
 				"",
 				"",
 				"",
@@ -272,12 +272,12 @@ 
 				"",
 				"",
 			);
-			}else{
-							$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account","Rate Group", "Call Type");
+			} else {
+							$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account", "Rate Group", "Call Type");
 			   foreach ($query->result_array() as $value) {
-				   $duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
-				   floor($value['billseconds'] / 60) . ":" . sprintf('%02d', $value['billseconds'] % 60) : "00:00"  : $value['billseconds'];
-				$account=isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
+				   $duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0) ?
+				   floor($value['billseconds'] / 60).":".sprintf('%02d', $value['billseconds'] % 60) : "00:00" : $value['billseconds'];
+				$account = isset($account_arr[$value['accountid']]) ? $account_arr[$value['accountid']] : 'Anonymous';
 				$customer_array[] = array(
 					$this->common->convert_GMT_to('', '', $value['callstart']),
 					$value['callerid'],
@@ -285,24 +285,24 @@ 
 					filter_var($value['pattern'], FILTER_SANITIZE_NUMBER_INT),
 					$value['notes'],
 					$duration,
-					$this->common->calculate_currency_manually($currency_info, $value['debit'],false,false),
-					$this->common->calculate_currency_manually($currency_info, $value['cost'],false,false),
+					$this->common->calculate_currency_manually($currency_info, $value['debit'], false, false),
+					$this->common->calculate_currency_manually($currency_info, $value['cost'], false, false),
 					$value['disposition'],
 					$account,
 					isset($pricelist_arr[$value['pricelist_id']]) ? $pricelist_arr[$value['pricelist_id']] : '',
 					$value['calltype'],
 				);
 			}
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							floor($count_all['billseconds'] / 60) . ":" . sprintf('%02d', $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							floor($count_all['billseconds'] / 60).":".sprintf('%02d', $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$customer_array[] = array("Grand Total",
 				"",
 				"",
 				"",
 				"",
 				$duration,
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'],false,false),
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'],false,false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'], false, false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'], false, false),
 				"",
 				"",
 				"",
@@ -314,11 +314,11 @@ 
 			}
 		}
 		$this->load->helper('csv');
-		if(isset($customer_array)){
-		array_to_csv($customer_array, 'Customer_CDR_' . date("Y-m-d") . '.csv');
-	} else{
-		$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account","Rate Group", "Call Type");
-		array_to_csv($customer_array, 'Customer_CDR_' . date("Y-m-d") . '.csv');
+		if (isset($customer_array)) {
+		array_to_csv($customer_array, 'Customer_CDR_'.date("Y-m-d").'.csv');
+	} else {
+		$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account", "Rate Group", "Call Type");
+		array_to_csv($customer_array, 'Customer_CDR_'.date("Y-m-d").'.csv');
 	}
 	}
 
@@ -342,7 +342,7 @@ 
 
 		//Get Total Count,Total debit,Total cost information
 		$count_res = $this->reports_model->getreseller_cdrs(false, "", "");
-		$count_all = (array) $count_res->first_row();
+		$count_all = (array)$count_res->first_row();
 		$paging_data = $this->form->load_grid_config($count_all['count'], $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
 		$query = $this->reports_model->getreseller_cdrs(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
@@ -350,9 +350,9 @@ 
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 		if ($count_all['count'] > 0) {
 			$search_arr = $this->session->userdata('reseller_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							sprintf('%02d', $count_all['billseconds'] / 60) . ":" . sprintf('%02d', $count_all['billseconds'] % 60) : "00:00"  : sprintf('%02d', $count_all['billseconds'] );
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							sprintf('%02d', $count_all['billseconds'] / 60).":".sprintf('%02d', $count_all['billseconds'] % 60) : "00:00" : sprintf('%02d', $count_all['billseconds']);
 			$json_data['rows'][] = array("cell" => array(
 					"<b>Grand Total</b>",
 					"",
@@ -360,8 +360,8 @@ 
 					"",
 					"",
 					"<b>$duration</b>",
-					"<b>".$this->common_model->calculate_currency($count_all['total_debit'],'','',true,false)."</b>",
-					"<b>".$this->common_model->calculate_currency($count_all['total_cost'],'','',true,false)."</b>",
+					"<b>".$this->common_model->calculate_currency($count_all['total_debit'], '', '', true, false)."</b>",
+					"<b>".$this->common_model->calculate_currency($count_all['total_cost'], '', '', true, false)."</b>",
 					"",
 					"",
 					"",
@@ -385,7 +385,7 @@ 
 			$this->session->set_userdata('reseller_cdr_list_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'reports/resellerReport/');
+			redirect(base_url().'reports/resellerReport/');
 		}
 	}
 
@@ -397,10 +397,10 @@ 
 	function resellerReport_export() {
 		//Get All count related information.
 		$account_info = $accountinfo = $this->session->userdata('accountinfo');
-		$currency_id=$account_info['currency_id'];
-		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
+		$currency_id = $account_info['currency_id'];
+		$currency = $this->common->get_field_name('currency', 'currency', $currency_id);
 		$count_res = $this->reports_model->getreseller_cdrs(false, "", "");
-		$count_all = (array) $count_res->first_row();
+		$count_all = (array)$count_res->first_row();
 		ob_clean();
 		$reseller_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account", "Rate Group", "Call Type");
 		if ($count_all['count'] > 0) {
@@ -411,8 +411,8 @@ 
 			$currency_info = $this->common->get_currency_info();
 			// Get search information from session.
 			$search_arr = $this->session->userdata('reseller_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
-			$where = "id IN (" . $count_all['pricelist_ids'] . ")";
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$where = "id IN (".$count_all['pricelist_ids'].")";
 			$this->db->where($where);
 			$this->db->select('id,name');
 			$pricelist_res = $this->db->get('pricelists');
@@ -421,8 +421,8 @@ 
 				$pricelist_arr[$value['id']] = $value['name'];
 			}
 			foreach ($query->result_array() as $value) {
-				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
-								sprintf('%02d',$value['billseconds'] / 60) . ":" . sprintf('%02d', $value['billseconds'] % 60) : "00:00"  : $value['billseconds'];
+				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0) ?
+								sprintf('%02d', $value['billseconds'] / 60).":".sprintf('%02d', $value['billseconds'] % 60) : "00:00" : $value['billseconds'];
 				$reseller_array[] = array(
 					$this->common->convert_GMT_to('', '', $value['callstart']),
 					$value['callerid'],
@@ -430,24 +430,24 @@ 
 					filter_var($value['pattern'], FILTER_SANITIZE_NUMBER_INT),
 					$value['notes'],
 					$duration,
-					$this->common->calculate_currency_manually($currency_info, $value['debit'],false,false),
-					$this->common->calculate_currency_manually($currency_info, $value['cost'],false,false),
+					$this->common->calculate_currency_manually($currency_info, $value['debit'], false, false),
+					$this->common->calculate_currency_manually($currency_info, $value['cost'], false, false),
 					$value['disposition'],
 					$this->common->build_concat_string("first_name,last_name,number", "accounts", $value['accountid']),
 					isset($pricelist_arr[$value['pricelist_id']]) ? $pricelist_arr[$value['pricelist_id']] : '',
 					$value['calltype'],
 				);
 			}
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							floor($count_all['billseconds'] / 60) . ":" . sprintf('%02d', $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							floor($count_all['billseconds'] / 60).":".sprintf('%02d', $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$reseller_array[] = array("Grand Total",
 				"",
 				"",
 				"",
 				"",
 				$duration,
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'],false,false),
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'],false,false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_debit'], false, false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'], false, false),
 				"",
 				"",
 				"",
@@ -459,7 +459,7 @@ 
 			);
 		}
 		$this->load->helper('csv');
-		array_to_csv($reseller_array, 'Reseller_CDR_' . date("Y-m-d") . '.csv');
+		array_to_csv($reseller_array, 'Reseller_CDR_'.date("Y-m-d").'.csv');
 	}
 
 	function providerReport() {
@@ -475,7 +475,7 @@ 
 	function providerReport_json() {
 		//Get All count related information.
 		$count_res = $this->reports_model->getprovider_cdrs(false, "", "");
-		$count_all = (array) $count_res->first_row();
+		$count_all = (array)$count_res->first_row();
 		$paging_data = $this->form->load_grid_config($count_all['count'], $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
 
@@ -484,9 +484,9 @@ 
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 		if ($count_all['count'] > 0) {
 			$search_arr = $this->session->userdata('provider_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							floor($count_all['billseconds'] / 60) . ":" . sprintf("%02d", $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							floor($count_all['billseconds'] / 60).":".sprintf("%02d", $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$json_data['rows'][] = array("cell" => array(
 					"<b>Grand Total</b>",
 					"",
@@ -494,7 +494,7 @@ 
 					"",
 					"",
 					"<b>$duration</b>",
-					"<b>".$this->common_model->calculate_currency($count_all['total_cost'],'','',true,false)."</b>",
+					"<b>".$this->common_model->calculate_currency($count_all['total_cost'], '', '', true, false)."</b>",
 					"",
 					"",
 					));
@@ -512,7 +512,7 @@ 
 			$this->session->set_userdata('provider_cdr_list_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'reports/providerReport/');
+			redirect(base_url().'reports/providerReport/');
 		}
 	}
 
@@ -526,10 +526,10 @@ 
           Get All count information as well All total information
          */
 		 $account_info = $accountinfo = $this->session->userdata('accountinfo');
-		$currency_id=$account_info['currency_id'];
-		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
+		$currency_id = $account_info['currency_id'];
+		$currency = $this->common->get_field_name('currency', 'currency', $currency_id);
 		$count_res = $this->reports_model->getprovider_cdrs(false, "", "");
-		$count_all = (array) $count_res->first_row();
+		$count_all = (array)$count_res->first_row();
 		ob_clean();
 		$provider_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Cost($currency)", "Disposition", "Account");
 		if ($count_all['count'] > 0) {
@@ -538,15 +538,15 @@ 
 			$currency_info = $this->common->get_currency_info();
 			// Get search information from session.
 			$search_arr = $this->session->userdata('provider_cdr_list_search');
-			$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+			$show_seconds = ( ! empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
 			foreach ($query->result_array() as $value) {
 			//	echo"<pre>";print_r($value);exit;
-				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
-								floor($value['billseconds'] / 60) . ":" . sprintf("%02d", $value['billseconds'] % 60) : "00:00"  : $value['billseconds'];
+				$duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0) ?
+								floor($value['billseconds'] / 60).":".sprintf("%02d", $value['billseconds'] % 60) : "00:00" : $value['billseconds'];
 				$account_arr = $this->db_model->getSelect('*', 'accounts', array('id' => $value['provider_id']));
 				if ($account_arr->num_rows() > 0) {
 					$account_array = $account_arr->result_array();
-					$account = $account_array[0]['first_name'] . " " . $account_array[0]['last_name'] . ' (' . $account_array[0]['number'] . ')';
+					$account = $account_array[0]['first_name']." ".$account_array[0]['last_name'].' ('.$account_array[0]['number'].')';
 				} else {
 					$account = "Anonymous";
 				}
@@ -557,13 +557,13 @@ 
 					filter_var($value['pattern'], FILTER_SANITIZE_NUMBER_INT),
 					$value['notes'],
 					$duration,
-					$this->common->calculate_currency_manually($currency_info, $value['cost'],false,false),
+					$this->common->calculate_currency_manually($currency_info, $value['cost'], false, false),
 					$value['disposition'],
 					$account,
 				);
 			}
-			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0 ) ?
-							floor($count_all['billseconds'] / 60) . ":" . sprintf("%02d", $count_all['billseconds'] % 60) : "00:00"  : $count_all['billseconds'];
+			$duration = ($show_seconds == 'minutes') ? ($count_all['billseconds'] > 0) ?
+							floor($count_all['billseconds'] / 60).":".sprintf("%02d", $count_all['billseconds'] % 60) : "00:00" : $count_all['billseconds'];
 			$provider_array[] = array("Grand Total",
 				"",
 				"",
@@ -571,7 +571,7 @@ 
 				"",
 				$duration,
 				//$this->common->calculate_currency_manually($currency_info, $count_all['total_debit']),
-				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'],false,false),
+				$this->common->calculate_currency_manually($currency_info, $count_all['total_cost'], false, false),
 				"",
 				"",
 				"",
@@ -584,7 +584,7 @@ 
 		}
 		//echo "<pre>";print_r($provider_array);exit;
 		$this->load->helper('csv');
-		array_to_csv($provider_array, 'Provider_CDR_' . date("Y-m-d") . '.csv');
+		array_to_csv($provider_array, 'Provider_CDR_'.date("Y-m-d").'.csv');
 	}
 
 
@@ -616,7 +616,7 @@ 
 			$this->session->set_userdata('cdr_refill_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'user/user_cdrs_report/');
+			redirect(base_url().'user/user_cdrs_report/');
 		}
 	}
 
@@ -628,9 +628,9 @@ 
 	/*     * ************************** */
 
 	function customer_cdrreport($accountid, $accounttype) {
-		  $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_cdrs'); 
+		  $instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_cdrs'); 
 		$instant_search_currency = $this->common_model->add_calculate_currency($instant_search, "", '', true, false);
-		$like_str=!empty($instant_search) ? "(callstart like '%$instant_search%'  
+		$like_str = ! empty($instant_search) ? "(callstart like '%$instant_search%'  
                                             OR  callerid like '%$instant_search%'
                                             OR  callednum like '%$instant_search%' 
                                             OR  notes like '%$instant_search%'
@@ -642,12 +642,12 @@ 
 										   :null;
         
 		$json_data = array();
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
 		$count_all = $this->reports_model->users_cdrs_list(false, $accountid, $accounttype, "", "");
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
 		$query = $this->reports_model->users_cdrs_list(true, $accountid, $accounttype, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 		$grid_fields = json_decode($this->reports_form->build_report_list_for_user($accounttype));
@@ -664,7 +664,7 @@ 
 		$data['page_title'] = 'Refill Report';
 		$data['search_flag'] = true;
 		$this->session->set_userdata('advance_search', 0);
-		$data['grid_buttons']=$this->reports_form->build_refillreport_buttons();
+		$data['grid_buttons'] = $this->reports_form->build_refillreport_buttons();
 		$data['grid_fields'] = $this->reports_form->build_refill_report_for_admin();
 		$data['form_search'] = $this->form->build_serach_form($this->reports_form->build_search_refill_report_for_admin());
 		$this->load->view('view_refill_report', $data);
@@ -683,22 +683,22 @@ 
     
 	function refillreport_export() {
 		$account_info = $accountinfo = $this->session->userdata('accountinfo');
-		$currency_id=$account_info['currency_id'];
-		$reseller_id=$accountinfo['reseller_id'] > 0 ? $accountinfo['reseller_id'] : 0;
-		$account_arr=array();
+		$currency_id = $account_info['currency_id'];
+		$reseller_id = $accountinfo['reseller_id'] > 0 ? $accountinfo['reseller_id'] : 0;
+		$account_arr = array();
 		$currency_info = $this->common->get_currency_info();
-		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
+		$currency = $this->common->get_field_name('currency', 'currency', $currency_id);
 		ob_clean();
 		$customer_array[] = array("Date", "Account", "Amount($currency)", "Refill By", "Note");
-		$query = $this->reports_model->get_refill_list(true,"","",true);
-			 $this->db->select("concat(first_name,' ',last_name,' ','(',number,')') as first_name,id",false);
-			 $this->db->where('reseller_id',$reseller_id);
-			 $this->db->where_not_in('type',array("-1,2,4"));
-		$account_res=$this->db->get('accounts');
-		if($account_res->num_rows() > 0){
-	  $account_res=$account_res->result_array();
-	  foreach($account_res as $key=>$value){
-	   $account_arr[$value['id']]=$value['first_name'];
+		$query = $this->reports_model->get_refill_list(true, "", "", true);
+			 $this->db->select("concat(first_name,' ',last_name,' ','(',number,')') as first_name,id", false);
+			 $this->db->where('reseller_id', $reseller_id);
+			 $this->db->where_not_in('type', array("-1,2,4"));
+		$account_res = $this->db->get('accounts');
+		if ($account_res->num_rows() > 0) {
+	  $account_res = $account_res->result_array();
+	  foreach ($account_res as $key=>$value) {
+	   $account_arr[$value['id']] = $value['first_name'];
 	  }
 		}
 		if ($query->num_rows() > 0) {
@@ -706,14 +706,14 @@ 
 				$customer_array[] = array(
 			$row['payment_date'],
 					isset($account_arr[$row['accountid']]) ? $account_arr[$row['accountid']] : 'Anonymous',
-					number_format((float) (($row['credit'] * $currency_info['user_currency']['currencyrate']) / $currency_info['base_currency']['currencyrate']), $currency_info['decimalpoints'],".",""),
-					$this->common->get_refill_by("","",$row['payment_by']),
+					number_format((float)(($row['credit'] * $currency_info['user_currency']['currencyrate']) / $currency_info['base_currency']['currencyrate']), $currency_info['decimalpoints'], ".", ""),
+					$this->common->get_refill_by("", "", $row['payment_by']),
 					$row['notes']
 				);
 			}
 		}
 		$this->load->helper('csv');
-		array_to_csv($customer_array, 'Refill_Report_' . date("Y-m-d") . '.csv');
+		array_to_csv($customer_array, 'Refill_Report_'.date("Y-m-d").'.csv');
 	}
 
 	function customer_refillreport_search() {
@@ -726,7 +726,7 @@ 
 			$this->session->set_userdata('cdr_refill_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'user/user_cdrs_report/');
+			redirect(base_url().'user/user_cdrs_report/');
 		}
 	}
 
@@ -755,43 +755,43 @@ 
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
 		$query = $this->reports_model->getcharges_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-	$result= $query->result_array();
-		$query1 = $this->reports_model->getcharges_list(true,'','');
-	$res= $query1->result_array();
-	$debit=0;
-	$credit=0;
-	$before_balance=0;
-	$after_balance=0;
-	$i=0;
+	$result = $query->result_array();
+		$query1 = $this->reports_model->getcharges_list(true, '', '');
+	$res = $query1->result_array();
+	$debit = 0;
+	$credit = 0;
+	$before_balance = 0;
+	$after_balance = 0;
+	$i = 0;
 		foreach ($result as $key => $value) {
-			 $date=$this->common->convert_GMT_to('','',$value['created_date']);
+			 $date = $this->common->convert_GMT_to('', '', $value['created_date']);
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
-			$invoice_prefix= $entity_type =$this->common->get_field_name('invoice_prefix','invoices',array('id'=>$value['invoiceid']));
-			$invoiceid= $entity_type =$this->common->get_field_name('invoiceid','invoices',array('id'=>$value['invoiceid']));
-		$invoice_num=$invoice_prefix.$invoiceid;
-		$account=$this->common->get_field_name_coma_new('first_name,last_name,number','accounts',$value['accountid']);
-		$reseller=$this->common->reseller_select_value('first_name,last_name,number','accounts',$value['reseller_id']);
-		$item_type=$value['item_type'];
-		if($value['before_balance'] == '-'){
-			$before_balance='-';
-		} else{		
-			$before_balance=$this->common->convert_to_currency('','',$value['before_balance']);
+			$invoice_prefix = $entity_type = $this->common->get_field_name('invoice_prefix', 'invoices', array('id'=>$value['invoiceid']));
+			$invoiceid = $entity_type = $this->common->get_field_name('invoiceid', 'invoices', array('id'=>$value['invoiceid']));
+		$invoice_num = $invoice_prefix.$invoiceid;
+		$account = $this->common->get_field_name_coma_new('first_name,last_name,number', 'accounts', $value['accountid']);
+		$reseller = $this->common->reseller_select_value('first_name,last_name,number', 'accounts', $value['reseller_id']);
+		$item_type = $value['item_type'];
+		if ($value['before_balance'] == '-') {
+			$before_balance = '-';
+		} else {		
+			$before_balance = $this->common->convert_to_currency('', '', $value['before_balance']);
 		}
-		if($value['debit'] == '-'){
-			$debit='-';
-		} else{		
-			$debit=$this->common->convert_to_currency('','',$value['debit']);
+		if ($value['debit'] == '-') {
+			$debit = '-';
+		} else {		
+			$debit = $this->common->convert_to_currency('', '', $value['debit']);
 		}
-		$credit=$this->common->convert_to_currency('','',$value['credit']);
-			 if($cust_type == 0 && $value['item_type'] == 'INVPAY'){
+		$credit = $this->common->convert_to_currency('', '', $value['credit']);
+			 if ($cust_type == 0 && $value['item_type'] == 'INVPAY') {
 		$credit = '(-) '.$credit;
 		 }
-		if($value['after_balance'] == '-'){
-			$after_balance='-';
-		} else{		
-			$after_balance=$this->common->convert_to_currency('','',$value['after_balance']);
+		if ($value['after_balance'] == '-') {
+			$after_balance = '-';
+		} else {		
+			$after_balance = $this->common->convert_to_currency('', '', $value['after_balance']);
 		}
-		$description=$value['description'];
+		$description = $value['description'];
 			$cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
 		if ($this->session->userdata('logintype') == 1) {
 			$json_data['rows'][] = array('cell' => array(
@@ -806,7 +806,7 @@ 
 							$after_balance,
 							$description,
 									));
-	}else{
+	} else {
 			$json_data['rows'][] = array('cell' => array(
 							$date,
 							$invoice_num,
@@ -823,7 +823,7 @@ 
 		}
 	$debit_sum = 0;
 	$credit_sum = 0;
-	foreach($res as $value){
+	foreach ($res as $value) {
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
 		$debit_sum += $value['debit'];
@@ -832,9 +832,9 @@ 
 		$after_balance += $value['after_balance'];
 	}
 		if ($this->session->userdata('logintype') == 1) {
-			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
-	}else{
-			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
+			$json_data['rows'][$count_all]['cell'] = array('<b>Total</b>', '-', '-', '-', '-', '<b>'.$this->common->convert_to_currency('', '', $debit_sum).'</b>', '<b>'.$this->common->convert_to_currency('', '', $credit_sum).'</b>', '-', '-');
+	} else {
+			$json_data['rows'][$count_all]['cell'] = array('<b>Total</b>', '-', '-', '-', '-', '<b>'.$this->common->convert_to_currency('', '', $debit_sum).'</b>', '<b>'.$this->common->convert_to_currency('', '', $credit_sum).'</b>', '-', '-');
 
 	}
 	  echo json_encode($json_data);
@@ -849,7 +849,7 @@ 
 			$this->session->set_userdata('charges_list_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'accounts/admin_list/');
+			redirect(base_url().'accounts/admin_list/');
 		}
 	}
 
@@ -861,62 +861,62 @@ 
 	/* ASTPP  3.0 
      * This function using for customer edit
      */
-	function customer_charge_history($accountid,$accounttype){
+	function customer_charge_history($accountid, $accounttype) {
 		$json_data = array();
-		$instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_charges'); 
-		$like_str=!empty($instant_search) ? "(created_date like '%$instant_search%'  
+		$instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_charges'); 
+		$like_str = ! empty($instant_search) ? "(created_date like '%$instant_search%'  
                                             OR  item_type like '%$instant_search%'
                                             OR  'debit' like '%$instant_search%'
                                             OR 'credit' like '%$instant_search%'
                                             OR  'description' like '%$instant_search%')"
 											:null;
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
-		$count_all = $this->reports_model->get_customer_charge_list(false,$accountid);
+		$count_all = $this->reports_model->get_customer_charge_list(false, $accountid);
 
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
-		$query = $this->reports_model->get_customer_charge_list(true,$accountid,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-	$result= $query->result_array();
-		$query1 = $this->reports_model->get_customer_charge_list(true,$accountid,'','');
-	$res= $query1->result_array();
-
-	$debit=0;
-	$credit=0;
-	$before_balance=0;
-	$after_balance=0;
-	$i=0;
+		$query = $this->reports_model->get_customer_charge_list(true, $accountid, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+	$result = $query->result_array();
+		$query1 = $this->reports_model->get_customer_charge_list(true, $accountid, '', '');
+	$res = $query1->result_array();
+
+	$debit = 0;
+	$credit = 0;
+	$before_balance = 0;
+	$after_balance = 0;
+	$i = 0;
 		foreach ($result as $key => $value) {
-			 $date=$this->common->convert_GMT_to('','',$value['created_date']);
+			 $date = $this->common->convert_GMT_to('', '', $value['created_date']);
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
-			$invoice_prefix= $entity_type =$this->common->get_field_name('invoice_prefix','invoices',array('id'=>$value['invoiceid']));
-			$invoiceid= $entity_type =$this->common->get_field_name('invoiceid','invoices',array('id'=>$value['invoiceid']));
-		$invoice_num=$invoice_prefix.$invoiceid;
-		$account=$this->common->get_field_name_coma_new('first_name,last_name,number','accounts',$value['accountid']);
-		$reseller=$this->common->reseller_select_value('first_name,last_name,number','accounts',$value['reseller_id']);
-		$item_type=$value['item_type'];
-		if($value['before_balance'] == '-'){
-			$before_balance='-';
-		} else{		
-			$before_balance=$this->common->convert_to_currency('','',$value['before_balance']);
+			$invoice_prefix = $entity_type = $this->common->get_field_name('invoice_prefix', 'invoices', array('id'=>$value['invoiceid']));
+			$invoiceid = $entity_type = $this->common->get_field_name('invoiceid', 'invoices', array('id'=>$value['invoiceid']));
+		$invoice_num = $invoice_prefix.$invoiceid;
+		$account = $this->common->get_field_name_coma_new('first_name,last_name,number', 'accounts', $value['accountid']);
+		$reseller = $this->common->reseller_select_value('first_name,last_name,number', 'accounts', $value['reseller_id']);
+		$item_type = $value['item_type'];
+		if ($value['before_balance'] == '-') {
+			$before_balance = '-';
+		} else {		
+			$before_balance = $this->common->convert_to_currency('', '', $value['before_balance']);
 		}
-		if($value['debit'] == '-'){
-			$debit='-';
-		} else{		
-			$debit=$this->common->convert_to_currency('','',$value['debit']);
+		if ($value['debit'] == '-') {
+			$debit = '-';
+		} else {		
+			$debit = $this->common->convert_to_currency('', '', $value['debit']);
 		}
-		$credit=$this->common->convert_to_currency('','',$value['credit']);
-			 if($cust_type == 0 && $value['item_type'] == 'INVPAY'){
+		$credit = $this->common->convert_to_currency('', '', $value['credit']);
+			 if ($cust_type == 0 && $value['item_type'] == 'INVPAY') {
 		$credit = '(-) '.$credit;
 		 }
-		if($value['after_balance'] == '-'){
-			$after_balance='-';
-		} else{		
-			$after_balance=$this->common->convert_to_currency('','',$value['after_balance']);
+		if ($value['after_balance'] == '-') {
+			$after_balance = '-';
+		} else {		
+			$after_balance = $this->common->convert_to_currency('', '', $value['after_balance']);
 		}
-		$description=$value['description'];
+		$description = $value['description'];
 			$cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
 		if ($this->session->userdata('logintype') == 1) {
 			$json_data['rows'][] = array('cell' => array(
@@ -929,7 +929,7 @@ 
 							$after_balance,
 							$description,
 									));
-	}else{
+	} else {
 			$json_data['rows'][] = array('cell' => array(
 							$date,
 							$invoice_num,
@@ -945,7 +945,7 @@ 
 		}
 	$debit_sum = 0;
 	$credit_sum = 0;
-	foreach($res as $value){
+	foreach ($res as $value) {
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
  		 $cust_type = $this->common->get_field_name('posttoexternal', 'accounts', $value['accountid']);	    
 		$debit_sum += $value['debit'];
@@ -954,31 +954,31 @@ 
 		$after_balance += $value['after_balance'];
 	}
 		if ($this->session->userdata('logintype') == 1) {
-			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
-	}else{
-			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
+			$json_data['rows'][$count_all]['cell'] = array('<b>Total</b>', '-', '-', '-', '<b>'.$this->common->convert_to_currency('', '', $debit_sum).'</b>', '<b>'.$this->common->convert_to_currency('', '', $credit_sum).'</b>', '-', '-');
+	} else {
+			$json_data['rows'][$count_all]['cell'] = array('<b>Total</b>', '-', '-', '-', '<b>'.$this->common->convert_to_currency('', '', $debit_sum).'</b>', '<b>'.$this->common->convert_to_currency('', '', $credit_sum).'</b>', '-', '-');
 
 	}
 	  echo json_encode($json_data);
 	}
     
-	function customer_refillreport($accountid,$accounttype){
+	function customer_refillreport($accountid, $accounttype) {
 		$json_data = array();
-		$instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_refill');
-		$like_str=!empty($instant_search) ? "(payment_date like '%$instant_search%'
+		$instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_refill');
+		$like_str = ! empty($instant_search) ? "(payment_date like '%$instant_search%'
                                             OR  credit like '%$instant_search%'
                                             OR  payment_by like '%$instant_search%'
                                             OR  notes like '%$instant_search%'
                                                 )"
 										   :null;
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
-		$count_all = $this->reports_model->get_customer_refillreport(false,$accountid);
+		$count_all = $this->reports_model->get_customer_refillreport(false, $accountid);
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->db->where($like_str);
-		$query = $this->reports_model->get_customer_refillreport(true,$accountid,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$query = $this->reports_model->get_customer_refillreport(true, $accountid, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 		$grid_fields = json_decode($this->reports_form->build_refillreport_for_customer());
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 		echo json_encode($json_data);

Braces +26 added lines, -19 removed lines

@@ -38,8 +38,9 @@ 
 		$this->fpdf = new PDF('P', 'pt');
 		$this->fpdf->initialize('P', 'mm', 'A4');
 
-		if ($this->session->userdata('user_login') == FALSE)
-			redirect(base_url() . '/astpp/login');
+		if ($this->session->userdata('user_login') == FALSE) {
+					redirect(base_url() . '/astpp/login');
+		}
 	}
 
 	function customerReport() {
@@ -272,7 +273,7 @@ 
 				"",
 				"",
 			);
-			}else{
+			} else{
 							$customer_array[] = array("Date", "CallerID", "Called Number", "Code", "Destination", "Duration", "Debit($currency)", "Cost($currency)", "Disposition", "Account","Rate Group", "Call Type");
 			   foreach ($query->result_array() as $value) {
 				   $duration = ($show_seconds == 'minutes') ? ($value['billseconds'] > 0 ) ?
@@ -642,13 +643,15 @@ 
 										   :null;
         
 		$json_data = array();
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$count_all = $this->reports_model->users_cdrs_list(false, $accountid, $accounttype, "", "");
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$query = $this->reports_model->users_cdrs_list(true, $accountid, $accounttype, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 		$grid_fields = json_decode($this->reports_form->build_report_list_for_user($accounttype));
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
@@ -806,7 +809,7 @@ 
 							$after_balance,
 							$description,
 									));
-	}else{
+	} else{
 			$json_data['rows'][] = array('cell' => array(
 							$date,
 							$invoice_num,
@@ -833,7 +836,7 @@ 
 	}
 		if ($this->session->userdata('logintype') == 1) {
 			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
-	}else{
+	} else{
 			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
 
 	}
@@ -870,14 +873,16 @@ 
                                             OR 'credit' like '%$instant_search%'
                                             OR  'description' like '%$instant_search%')"
 											:null;
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$count_all = $this->reports_model->get_customer_charge_list(false,$accountid);
 
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$query = $this->reports_model->get_customer_charge_list(true,$accountid,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 	$result= $query->result_array();
 		$query1 = $this->reports_model->get_customer_charge_list(true,$accountid,'','');
@@ -929,7 +934,7 @@ 
 							$after_balance,
 							$description,
 									));
-	}else{
+	} else{
 			$json_data['rows'][] = array('cell' => array(
 							$date,
 							$invoice_num,
@@ -955,7 +960,7 @@ 
 	}
 		if ($this->session->userdata('logintype') == 1) {
 			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
-	}else{
+	} else{
 			$json_data['rows'][$count_all]['cell']=array('<b>Total</b>','-','-','-','<b>'.$this->common->convert_to_currency('','',$debit_sum).'</b>','<b>'.$this->common->convert_to_currency('','',$credit_sum).'</b>','-','-');
 
 	}
@@ -971,13 +976,15 @@ 
                                             OR  notes like '%$instant_search%'
                                                 )"
 										   :null;
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$count_all = $this->reports_model->get_customer_refillreport(false,$accountid);
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
-		if(!empty($like_str))
-		$this->db->where($like_str);
+		if(!empty($like_str)) {
+				$this->db->where($like_str);
+		}
 		$query = $this->reports_model->get_customer_refillreport(true,$accountid,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 		$grid_fields = json_decode($this->reports_form->build_refillreport_for_customer());
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);

web_interface/astpp/application/modules/reports/libraries/reports_form.php

Spacing +177 added lines, -177 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 Reports_form {

@@ -29,7 +29,7 @@ 
 	}

 	function get_customer_cdr_form() {

 		$logintype = $this->CI->session->userdata('userlevel_logintype');

-		 if($logintype != 1){

+		 if ($logintype != 1) {

 		if ($this->CI->session->userdata('logintype') == 1 || $this->CI->session->userdata('logintype') == 5) {

 			$accountinfo = $this->CI->session->userdata['accountinfo'];

 			$reseller_id = $accountinfo["id"];

@@ -48,7 +48,7 @@ 
 		array('Debit ', 'INPUT', array('name' => 'debit[debit]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'debit[debit-integer]', '', '', '', 'search_int_type', ''),

 			array('Cost ', 'INPUT', array('name' => 'cost[cost]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'cost[cost-integer]', '', '', '', 'search_int_type', ''),

 		array('Disposition', 'disposition', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_despostion'),

-			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"GLOBAL")),

+			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"GLOBAL")),

  

 	  array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`status`=2, concat(name,"","^"),name) as name', 'trunks', 'build_dropdown_deleted', '', array("status" => "1")),

 

@@ -71,7 +71,7 @@ 
 		array('Debit ', 'INPUT', array('name' => 'debit[debit]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'debit[debit-integer]', '', '', '', 'search_int_type', ''),

 			array('Cost ', 'INPUT', array('name' => 'cost[cost]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'cost[cost-integer]', '', '', '', 'search_int_type', ''),

 		array('Disposition', 'disposition', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_despostion'),

-			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"GLOBAL")),

+			array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"GLOBAL")),

  

 	  //array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`status`=2, concat(name,"","^"),name) as name', 'trunks', 'build_dropdown_deleted', '', array("status" => "1")),

 

@@ -109,17 +109,17 @@ 
 			array('Cost ', 'INPUT', array('name' => 'cost[cost]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'cost[cost-integer]', '', '', '', 'search_int_type', ''),

             

 			array('Disposition', 'disposition', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_despostion'),

-		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"1")),

+		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"1")),

 		 array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`status`=2, concat(name,"","^"),name) as name', 'pricelists', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0")),

 			array('Call Type', 'calltype', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_calltype'),

         

 			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),

 			array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

 		if ($this->CI->session->userdata('logintype') != 1 && $this->CI->session->userdata('logintype') != 5) {

-	  $new_Array=array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "1"));     

+	  $new_Array = array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "1"));     

 	}

 	

-	$form['display_in']=array('name' => 'search_in',"id"=>"search_in","function"=>"search_report_in", "content"=>"Display records in &nbsp;&nbsp;",'label_class' => "search_label col-md-3 no-padding","dropdown_class"=>"form-control","label_style"=>"font-size:13px;text-align:right;","dropdown_style"=>"background: #ddd; width: 23% !important;");

+	$form['display_in'] = array('name' => 'search_in', "id"=>"search_in", "function"=>"search_report_in", "content"=>"Display records in &nbsp;&nbsp;", 'label_class' => "search_label col-md-3 no-padding", "dropdown_class"=>"form-control", "label_style"=>"font-size:13px;text-align:right;", "dropdown_style"=>"background: #ddd; width: 23% !important;");

 	

 	/****************************************/

 		$form['button_search'] = array('name' => 'action', 'id' => "reseller_cdr_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

@@ -141,14 +141,14 @@ 
 		array('Cost ', 'INPUT', array('name' => 'provider_call_cost[provider_call_cost]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'provider_call_cost[provider_call_cost-integer]', '', '', '', 'search_int_type', ''),

 //	  array('Cost ', 'INPUT', array('name' => 'cost[cost]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'cost[cost-integer]', '', '', '', 'search_int_type', ''),

 		  array('Disposition', 'disposition', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_despostion'),

- array('Account', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"3")),

-			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', '')

+ array('Account', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"3")),

+			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', '')

 

 //	  array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', '', ''),

             

             

 		);

-	$form['display_in']=array('name' => 'search_in',"id"=>"search_in","function"=>"search_report_in", "content"=>"Display records in",'label_class' => "search_label col-md-3 no-padding","dropdown_class"=>"form-control","label_style"=>"font-size:13px;","dropdown_style"=>"background: #ddd; width: 21% !important;");

+	$form['display_in'] = array('name' => 'search_in', "id"=>"search_in", "function"=>"search_report_in", "content"=>"Display records in", 'label_class' => "search_label col-md-3 no-padding", "dropdown_class"=>"form-control", "label_style"=>"font-size:13px;", "dropdown_style"=>"background: #ddd; width: 21% !important;");

 	

 	/****************************************/

 		$form['button_search'] = array('name' => 'action', 'id' => "provider_cdr_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

@@ -163,52 +163,52 @@ 
 ******/

 	function build_report_list_for_customer() {

 		$logintype = $this->CI->session->userdata('userlevel_logintype');

-		 if($logintype != 1){

+		 if ($logintype != 1) {

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+		$currency_id = $account_info['currency_id'];

+		$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

              

-			 $recording=array();

+			 $recording = array();

 			 $account_data = $this->CI->session->userdata("accountinfo");

-		 if($account_data['type'] == 1){

-				$recording=array("Recording", "127", "recording", "", "", ""); 

+		 if ($account_data['type'] == 1) {

+				$recording = array("Recording", "127", "recording", "", "", ""); 

 			 }

 		$grid_field_arr = json_encode(array(

-		array(gettext("Date"), "100", "callstart","callstart", "callstart", "convert_GMT_to","","true","center"),

-		array("Caller ID", "120", "callerid", "", "", "","","true","center"),

-		array("Called Number", "103", "callednum", "", "", "","","true","center"),

-		array("Code", "71", "pattern", "pattern", "", "get_only_numeric_val","","true","center"),

-		array("Destination", "90", "notes", "", "", "","","true","center"),

-		array("Duration", "80", "billseconds", "customer_cdr_list_search", "billseconds", "convert_to_show_in","","true","center"),

-		array("Debit($currency)", "75", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-		array("Cost($currency)", "75", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-		array("Disposition", "150", "disposition", "", "", "","","true","center"),

-		array("Account", "110", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

-		array("Trunk", "90", "trunk_id", "name", "trunks", "get_field_name","","true","center"),

-		array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name","","true","center"),

+		array(gettext("Date"), "100", "callstart", "callstart", "callstart", "convert_GMT_to", "", "true", "center"),

+		array("Caller ID", "120", "callerid", "", "", "", "", "true", "center"),

+		array("Called Number", "103", "callednum", "", "", "", "", "true", "center"),

+		array("Code", "71", "pattern", "pattern", "", "get_only_numeric_val", "", "true", "center"),

+		array("Destination", "90", "notes", "", "", "", "", "true", "center"),

+		array("Duration", "80", "billseconds", "customer_cdr_list_search", "billseconds", "convert_to_show_in", "", "true", "center"),

+		array("Debit($currency)", "75", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+		array("Cost($currency)", "75", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+		array("Disposition", "150", "disposition", "", "", "", "", "true", "center"),

+		array("Account", "110", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

+		array("Trunk", "90", "trunk_id", "name", "trunks", "get_field_name", "", "true", "center"),

+		array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name", "", "true", "center"),

 		array("Call Type", "112", "calltype", "", "", ""),

 				$recording,

 				));

                 

 				}

-				else{

+				else {

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

-		$recording=array("Recording", "127", "recording", "", "", "");			

+		$currency_id = $account_info['currency_id'];

+		$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

+		$recording = array("Recording", "127", "recording", "", "", "");			

 		$grid_field_arr = json_encode(array(

-		array("Date", "100", "callstart","callstart", "callstart", "convert_GMT_to","","true","center"),

-		array("Caller ID", "100", "callerid", "", "", "","","true","center"),

-		array("Called Number", "103", "callednum", "", "", "","","true","center"),

-		array("Code", "71", "pattern", "pattern", "", "get_only_numeric_val","","true","center"),

-		array("Destination", "90", "notes", "", "", "","","true","center"),

-		array("Duration", "80", "billseconds", "customer_cdr_list_search", "billseconds", "convert_to_show_in","","true","center"),

-		array("Debit($currency)", "75", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-		array("Cost($currency)", "75", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-		array("Disposition", "130", "disposition", "", "", "","","true","center"),

-		array("Account", "110", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

+		array("Date", "100", "callstart", "callstart", "callstart", "convert_GMT_to", "", "true", "center"),

+		array("Caller ID", "100", "callerid", "", "", "", "", "true", "center"),

+		array("Called Number", "103", "callednum", "", "", "", "", "true", "center"),

+		array("Code", "71", "pattern", "pattern", "", "get_only_numeric_val", "", "true", "center"),

+		array("Destination", "90", "notes", "", "", "", "", "true", "center"),

+		array("Duration", "80", "billseconds", "customer_cdr_list_search", "billseconds", "convert_to_show_in", "", "true", "center"),

+		array("Debit($currency)", "75", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+		array("Cost($currency)", "75", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+		array("Disposition", "130", "disposition", "", "", "", "", "true", "center"),

+		array("Account", "110", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

 		//array("Trunk", "90", "trunk_id", "name", "trunks", "get_field_name","","true","center"),

-		array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name","","true","center"),

+		array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name", "", "true", "center"),

 		array("Call Type", "112", "calltype", "", "", ""),

 				$recording,

 				));

@@ -222,23 +222,23 @@ 
 	function build_report_list_for_reseller() {

 		

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-$currency_id=$account_info['currency_id'];

-$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+$currency_id = $account_info['currency_id'];

+$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 		

 		// array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

 		$grid_field_arr = json_encode(array(

-			array("Date", "100", "callstart", "callstart", "callstart", "convert_GMT_to","","true","center"),

-			array("Caller ID", "100", "callerid", "", "", "","","true","center"),

-			array("Called Number", "120", "callednum", "", "", "","","true","center"),

-			array("Code", "80", "pattern", "pattern", "", "get_only_numeric_val","","true","center"),

-			array("Destination", "120", "notes", "", "", "","","true","center"),

-			array("Duration", "107", "billseconds", "reseller_cdr_list_search", "billseconds", "convert_to_show_in","","true","center"),

-			array("Debit($currency)", "105", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-			array("Cost($currency)", "104", "cost", "cost", "cost", "convert_to_currency","","true","right"),

-			array("Disposition", "100", "disposition", "", "", "","","true","center"),

-			array("Account", "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

-			array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name","","true","center"),

- 			array("Call Type", "120", "calltype", "", "", "","","true","center"), 

+			array("Date", "100", "callstart", "callstart", "callstart", "convert_GMT_to", "", "true", "center"),

+			array("Caller ID", "100", "callerid", "", "", "", "", "true", "center"),

+			array("Called Number", "120", "callednum", "", "", "", "", "true", "center"),

+			array("Code", "80", "pattern", "pattern", "", "get_only_numeric_val", "", "true", "center"),

+			array("Destination", "120", "notes", "", "", "", "", "true", "center"),

+			array("Duration", "107", "billseconds", "reseller_cdr_list_search", "billseconds", "convert_to_show_in", "", "true", "center"),

+			array("Debit($currency)", "105", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+			array("Cost($currency)", "104", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),

+			array("Disposition", "100", "disposition", "", "", "", "", "true", "center"),

+			array("Account", "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

+			array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name", "", "true", "center"),

+ 			array("Call Type", "120", "calltype", "", "", "", "", "true", "center"), 

 		    

 		   ));

 		return $grid_field_arr;

@@ -247,25 +247,25 @@ 
 	function build_report_list_for_provider() {

 

 $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-$currency_id=$account_info['currency_id'];

-$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+$currency_id = $account_info['currency_id'];

+$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 		

 		// array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

-		$grid_field_arr = json_encode(array(array("Date", "100", "callstart", "callstart", "callstart", "convert_GMT_to","","true","center"),

-		  array("Caller ID", "120", "callerid", "", "", "","","true","center"),

-		  array("Called Number", "160", "callednum", "", "", "","","true","center"),

-		  array("Code", "117", "pattern", "pattern", "", "get_only_numeric_val","","true","center"),

-		  array("Destination", "130", "notes", "", "", "","","true","center"),

-		  array("Duration", "110", "billseconds", "provider_cdr_list_search", "billseconds", "convert_to_show_in","","true","center"),

-		  array("Cost($currency)", "150", "provider_call_cost", "provider_cost", "provider_cost", "convert_to_currency","","true","right"),

-		  array("Disposition", "200", "disposition", "", "", "","","true","center"),

-		  array("Account", "181", "provider_id", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

+		$grid_field_arr = json_encode(array(array("Date", "100", "callstart", "callstart", "callstart", "convert_GMT_to", "", "true", "center"),

+		  array("Caller ID", "120", "callerid", "", "", "", "", "true", "center"),

+		  array("Called Number", "160", "callednum", "", "", "", "", "true", "center"),

+		  array("Code", "117", "pattern", "pattern", "", "get_only_numeric_val", "", "true", "center"),

+		  array("Destination", "130", "notes", "", "", "", "", "true", "center"),

+		  array("Duration", "110", "billseconds", "provider_cdr_list_search", "billseconds", "convert_to_show_in", "", "true", "center"),

+		  array("Cost($currency)", "150", "provider_call_cost", "provider_cost", "provider_cost", "convert_to_currency", "", "true", "right"),

+		  array("Disposition", "200", "disposition", "", "", "", "", "true", "center"),

+		  array("Account", "181", "provider_id", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

 		));

 		return $grid_field_arr;

 	}

 

 	function build_grid_customer() {

-		$buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/customerReport_export/", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/customerReport_export/", 'single')));

 		return $buttons_json;

 	}

 /**

@@ -274,43 +274,43 @@ 
 **/

 

 	function build_grid_buttons_user() {

-		$buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/user/user_report_export/", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/user/user_report_export/", 'single')));

 		return $buttons_json;

 	}

 /*****************************************************************/

 	function build_grid_buttons_reseller() {

-		$buttons_json = json_encode(array( array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/resellerReport_export/", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/resellerReport_export/", 'single')));

 		return $buttons_json;

 	}

 	function build_grid_buttons_provider() {

-		$buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/providerReport_export/", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/providerReport_export/", 'single')));

 		return $buttons_json;

 	}

     

 	function build_report_list_for_user($accounttype = 'customer') {

 		

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);			

+		$currency_id = $account_info['currency_id'];

+		$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);			

 		

 		

-		if($accounttype == 'customer' || $accounttype =='reseller'){

-			$cost_array=array("Debit($currency)", "100", "debit", "debit", "debit", "convert_to_currency","","true","right");

+		if ($accounttype == 'customer' || $accounttype == 'reseller') {

+			$cost_array = array("Debit($currency)", "100", "debit", "debit", "debit", "convert_to_currency", "", "true", "right");

 		}

-		if(strtolower($accounttype)=='provider'){

-			$cost_array=array("Debit($currency)", "140", "cost", "cost", "cost", "convert_to_currency");

+		if (strtolower($accounttype) == 'provider') {

+			$cost_array = array("Debit($currency)", "140", "cost", "cost", "cost", "convert_to_currency");

 		}

 	 // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name);

 		$grid_field_arr = json_encode(array(

-		array("Date", "130", "callstart", "callstart", "callstart", "convert_GMT_to","","true","center"),

-			array("Caller ID", "100", "callerid", "", "", "","","true","center"),

-			array("Called Number", "120", "callednum", "", "", "","","true","center"),

-			array("Destination", "135", "notes", "", "", "","","true","center"),

+		array("Date", "130", "callstart", "callstart", "callstart", "convert_GMT_to", "", "true", "center"),

+			array("Caller ID", "100", "callerid", "", "", "", "", "true", "center"),

+			array("Called Number", "120", "callednum", "", "", "", "", "true", "center"),

+			array("Destination", "135", "notes", "", "", "", "", "true", "center"),

 //            array("Account Number", "120", "accountid", "number", "accounts", "get_field_name"),

-			array("Duration", "120", "billseconds", "user_cdrs_report_search", "billseconds", "convert_to_show_in","","true","center"),

+			array("Duration", "120", "billseconds", "user_cdrs_report_search", "billseconds", "convert_to_show_in", "", "true", "center"),

 			$cost_array,

-			array("Disposition", "160", "disposition", "", "", "","","true","center"),

-			array("Call Type", "140", "calltype", "", "", "","","true","center"),

+			array("Disposition", "160", "disposition", "", "", "", "", "true", "center"),

+			array("Call Type", "140", "calltype", "", "", "", "", "true", "center"),

 				));

 		return $grid_field_arr;

 	}

@@ -322,37 +322,37 @@ 
 	function build_refill_report_for_admin() {

 		

 		  $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-	$currency_id=$account_info['currency_id'];

-	 $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+	$currency_id = $account_info['currency_id'];

+	 $currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 	  $grid_field_arr = json_encode(array(

-			array(gettext("Date"), "225", "payment_date", "", "", "","","true","center"),

-			array(gettext("Account"), "240", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

-			array("Amount($currency)", "250", "credit", "credit", "credit", "convert_to_currency","","true","right"),

-			array(gettext("Refill By"), "230", "payment_by", "payment_by", "payment_by", "get_refill_by","","true","center"),

-			array(gettext("Note"), "327", "notes", "", "", "","","true","center")

+			array(gettext("Date"), "225", "payment_date", "", "", "", "", "true", "center"),

+			array(gettext("Account"), "240", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

+			array("Amount($currency)", "250", "credit", "credit", "credit", "convert_to_currency", "", "true", "right"),

+			array(gettext("Refill By"), "230", "payment_by", "payment_by", "payment_by", "get_refill_by", "", "true", "center"),

+			array(gettext("Note"), "327", "notes", "", "", "", "", "true", "center")

 				));

 		return $grid_field_arr;

 	}

 	function build_refillreport_buttons() {

-		$buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/refillreport_export/", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/refillreport_export/", 'single')));

 		return $buttons_json;

 	}

 	function build_search_refill_report_for_admin() {

-		 $accountinfo=$this->CI->session->userdata('accountinfo');

-		 $reseller_id=$accountinfo['type']==1 ? $accountinfo['id'] : 0 ;

+		 $accountinfo = $this->CI->session->userdata('accountinfo');

+		 $reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;

 		 $form['forms'] = array("", array('id' => "cdr_refill_search"));

 			 $account_data = $this->CI->session->userdata("accountinfo");

-			 $acc_arr= array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id,"type"=>"0,1,3"));

+			 $acc_arr = array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id, "type"=>"0,1,3"));

 			 $logintype = $this->CI->session->userdata('logintype');

 		if ($logintype == 1 || $logintype == 5) {

 			$account_data = $this->CI->session->userdata("accountinfo");

 			$loginid = $account_data['id'];

 

-		}else{

+		} else {

 			$loginid = "0";

 		}

-		if($logintype==0 || $logintype==3){

-		$acc_arr=null;

+		if ($logintype == 0 || $logintype == 3) {

+		$acc_arr = null;

 		}    

 		$form['Search'] = array(

 		array('From Date', 'INPUT', array('name' => 'payment_date[]', 'id' => 'refill_from_date', 'size' => '20',

@@ -362,7 +362,7 @@ 
 //	    array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"0")), 

 			array('Amount ', 'INPUT', array('name' => 'credit[credit]', 'value' => '', 'size' => '20', 'class' => "text field"), '', 'Tool tips info', '1', 'credit[credit-integer]', '', '', '', 'search_int_type', ''),

 		   // array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', ''),

-			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

+			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

 

 		$form['button_search'] = array('name' => 'action', 'id' => "cusotmer_cdr_refill_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

 		$form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');

@@ -392,9 +392,9 @@ 
 			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),

 			array('', 'HIDDEN', 'advance_search', '1', '', '', ''),

 			array('From Date', 'INPUT', array('name' => 'date[]', 'id' => 'commission_from_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'start_date[start_date-date]'),

-			array('To Date', 'INPUT', array('name' => 'date[]', 'id' => 'commission_to_date', 'size' => '20',  'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

-		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0","type"=>"1", "deleted" => "0")),

-			array('Amount', 'INPUT', array('name' => 'amount[amount]', 'value' => '', 'size' => '20',  'class' => "text field"), '', 'Tool tips info', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),

+			array('To Date', 'INPUT', array('name' => 'date[]', 'id' => 'commission_to_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

+		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("reseller_id" => "0", "type"=>"1", "deleted" => "0")),

+			array('Amount', 'INPUT', array('name' => 'amount[amount]', 'value' => '', 'size' => '20', 'class' => "text field"), '', 'Tool tips info', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),

 		);

 

 		$form['button_search'] = array('name' => 'action', 'id' => "commission_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'ui-state-default float-right ui-corner-all ui-button');

@@ -407,8 +407,8 @@ 
 		$form['Search'] = array(

 	array('From Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_from_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'start_date[start_date-date]'),

 			array('To Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_to_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

-		   array('Account', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"3")),

-		   array('Code ', 'INPUT', array('name' => 'pattern[pattern]', 'value' => '', 'size' => '20',  'class' => "text field "), '', 'Tool tips info', '1', 'pattern[pattern-string]', '', '', '', 'search_string_type', ''),

+		   array('Account', 'provider_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"3")),

+		   array('Code ', 'INPUT', array('name' => 'pattern[pattern]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'pattern[pattern-string]', '', '', '', 'search_string_type', ''),

             

 			array('Destination ', 'INPUT', array('name' => 'notes[notes]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'notes[notes-string]', '', '', '', 'search_string_type', ''), 

 		// array('Account Number', 'number', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("type"=>"3", "deleted" => "0")),

@@ -419,99 +419,99 @@ 
 

 		return $form;

 	}

-	function build_providersummary(){

+	function build_providersummary() {

 		$grid_field_arr = json_encode(array(

 			array("Provider", "220", "provider_id", "first_name,last_name,number", "accounts", "build_concat_string"),

 			array("Code", "120", "pattern", "pattern", "", "get_only_numeric_val"),

 			array("Destination", "150", "notes", "", "", ""),

 			array("Attempted Calls", "130", "attempted_calls", "", "", ""),

 			array("Completed Calls", "150", "description", "", "", ""),

-			array("ASR","95","asr",'','',''),

-			array("ACD","95","acd  ",'','',''),

-			array("MCD","95","mcd",'','',''),

-			array("Bilable","100","billable",'','',''),

-			array("Cost","115","cost",'','',''),

+			array("ASR", "95", "asr", '', '', ''),

+			array("ACD", "95", "acd  ", '', '', ''),

+			array("MCD", "95", "mcd", '', '', ''),

+			array("Bilable", "100", "billable", '', '', ''),

+			array("Cost", "115", "cost", '', '', ''),

 //            array("Profit", "95", "profit", "", "", ""),

 			));

 		return $grid_field_arr;

 	}

 	function build_grid_buttons_providersummary() {

-	   $buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/providersummary_export_cdr_xls", 'single')));

+	   $buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/providersummary_export_cdr_xls", 'single')));

 		return $buttons_json;

 	}

 	function get_resellersummary_search_form() {

-		$form['forms'] = array("",array('id' => "resellersummary_search"));

+		$form['forms'] = array("", array('id' => "resellersummary_search"));

 		$form['Search'] = array(

 			array('From Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_from_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'start_date[start_date-date]'),

 			array('To Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_to_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

-		array('Account', 'reseller_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"1")),

-		   array('Code ', 'INPUT', array('name' => 'pattern[pattern]', 'value' => '', 'size' => '20',  'class' => "text field "), '', 'Tool tips info', '1', 'pattern[pattern-string]', '', '', '', 'search_string_type', ''),

+		array('Account', 'reseller_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"1")),

+		   array('Code ', 'INPUT', array('name' => 'pattern[pattern]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'pattern[pattern-string]', '', '', '', 'search_string_type', ''),

             

 			array('Destination ', 'INPUT', array('name' => 'notes[notes]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'notes[notes-string]', '', '', '', 'search_string_type', ''), 

 		   // array('Account Number', 'number', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("type"=>"1", "deleted" => "0")),

-array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

+array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

 		$form['button_search'] = array('name' => 'action', 'id' => "resellersummary_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

 		$form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');

 

 		return $form;

 	}

-	function build_resellersummary(){

+	function build_resellersummary() {

 		$grid_field_arr = json_encode(array(

 			array("Account", "148", "accountid", "first_name,last_name,number", "accounts", "build_concat_string"),

 			array("Code", "120", "pattern", "pattern", "", "get_only_numeric_val"),

 			array("Destination", "150", "notes", "", "", ""),

 			array("Attempted Calls", "120", "attempted_calls", "", "", ""),

 			array("Completed Calls", "120", "description", "", "", ""),

-			array("ASR","80","asr",'','',''),

-			array("ACD","80","acd  ",'','',''),

-			array("MCD","80","mcd",'','',''),

-			array("Bilable","90","billable",'','',''),

-			array("Price","90","price",'','',''),

-			array("Cost","90","cost",'','',''),

+			array("ASR", "80", "asr", '', '', ''),

+			array("ACD", "80", "acd  ", '', '', ''),

+			array("MCD", "80", "mcd", '', '', ''),

+			array("Bilable", "90", "billable", '', '', ''),

+			array("Price", "90", "price", '', '', ''),

+			array("Cost", "90", "cost", '', '', ''),

 			array("Profit", "100", "profit", "", "", ""),

 			));

 		return $grid_field_arr;

 	}

 	function build_grid_buttons_resellersummary() {

-		 $buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/resellersummary_export_cdr_xls", 'single')));

+		 $buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/resellersummary_export_cdr_xls", 'single')));

 		return $buttons_json;

 	}

 	function get_customersummary_search_form() {

-		$form['forms'] = array("",array('id' => "customersummary_search"));

+		$form['forms'] = array("", array('id' => "customersummary_search"));

 		$form['Search'] = array(

 			array('From Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_from_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'start_date[start_date-date]'),

 			array('To Date', 'INPUT', array('name' => 'callstart[]', 'id' => 'customer_to_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

-		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0","type"=>"GLOBAL")),

+		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => "0", "type"=>"GLOBAL")),

 			array('Code ', 'INPUT', array('name' => 'pattern[pattern]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'pattern[pattern-string]', '', '', '', 'search_string_type', ''),

             

 			array('Destination ', 'INPUT', array('name' => 'notes[notes]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'notes[notes-string]', '', '', '', 'search_string_type', ''),

 		   // array('Account Number', 'number', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'first_name,last_name,number', 'accounts', 'build_concat_dropdown', 'where_arr', array("type"=>"0", "deleted" => "0")),

-	array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),array('', 'HIDDEN', 'advance_search', '1', '', '', '')

+	array('', 'HIDDEN', 'ajax_search', '1', '', '', ''), array('', 'HIDDEN', 'advance_search', '1', '', '', '')

 		);

 		$form['button_search'] = array('name' => 'action', 'id' => "customersummary_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');

 		$form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');

 

 		return $form;

 	}

-	function build_customersummary(){

+	function build_customersummary() {

 		$grid_field_arr = json_encode(array(

 			array("Account", "190", "accountid", "first_name,last_name,number", "accounts", "build_concat_string"),

 			array("Code", "80", "pattern", "pattern", "", "get_only_numeric_val"),

 			array("Destination", "110", "notes", "", "", ""),

 			array("Attempted Calls", "140", "attempted_calls", "", "", ""),

 			array("Completed Calls", "130", "description", "", "", ""),

-			array("ASR","70","asr",'','',''),

-			array("ACD","70","acd  ",'','',''),

-			array("MCD","80","mcd",'','',''),

-			array("Bilable","80","billable",'','',''),

-			array("Debit","85","cost",'','',''),

-			array("Cost","110","price",'','',''),            

+			array("ASR", "70", "asr", '', '', ''),

+			array("ACD", "70", "acd  ", '', '', ''),

+			array("MCD", "80", "mcd", '', '', ''),

+			array("Bilable", "80", "billable", '', '', ''),

+			array("Debit", "85", "cost", '', '', ''),

+			array("Cost", "110", "price", '', '', ''),            

 			array("Profit", "123", "profit", "", "", ""),

 			));

 		return $grid_field_arr;

 	}

 	function build_grid_buttons_customersummary() {

-		$buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/reports/customersummary_export_cdr_xls", 'single')));

+		$buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/reports/customersummary_export_cdr_xls", 'single')));

 		return $buttons_json;

 	}

 /*********

@@ -520,45 +520,45 @@ 
 *********/

 	function build_charge_list_for_admin() {

 	$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-	$currency_id=$account_info['currency_id'];

-	$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

+	$currency_id = $account_info['currency_id'];

+	$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);

 	 if ($this->CI->session->userdata("logintype") == '1') {

 		$grid_field_arr = json_encode(array(

-			array(gettext("Created Date"), "120", "created_date", "", "", "","","true","center"),

-			array(gettext("Invoice Number"), "120", "created_date", "", "", "","","true","center"),

-			array(gettext("Account"), "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

+			array(gettext("Created Date"), "120", "created_date", "", "", "", "", "true", "center"),

+			array(gettext("Invoice Number"), "120", "created_date", "", "", "", "", "true", "center"),

+			array(gettext("Account"), "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

 //            array("Reseller", "120", "reseller_id", "first_name,last_name,number", "accounts", "reseller_select_value"),

-			array(gettext("Charge Type"), "120", "item_type", "", "", "","","true","center"),

-			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency","","true","right"),

-			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency","","true","right"),

-		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency","","true","right"),	

-			array(gettext("Description"), "300", "description", "", "", "","","true","center"),

+			array(gettext("Charge Type"), "120", "item_type", "", "", "", "", "true", "center"),

+			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency", "", "true", "right"),

+			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency", "", "true", "right"),

+		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency", "", "true", "right"),	

+			array(gettext("Description"), "300", "description", "", "", "", "", "true", "center"),

 				));

-	}else{

+	} else {

 		$grid_field_arr = json_encode(array(

-			array("Created Date", "120", "created_date", "", "", "","","true","center"),

-			array("Invoice Number", "120", "created_date", "", "", "","","true","center"),

-   		array("Account", "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),

-			array("Charge Type", "120", "item_type", "", "", "","","true","center"),

-			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency","","true","right"),

-			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency","","true","right"),

-		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency","","true","right"),	

-			array("Description", "300", "description", "", "", "","","true","center"),

+			array("Created Date", "120", "created_date", "", "", "", "", "true", "center"),

+			array("Invoice Number", "120", "created_date", "", "", "", "", "true", "center"),

+   		array("Account", "120", "accountid", "first_name,last_name,number", "accounts", "build_concat_string", "", "true", "center"),

+			array("Charge Type", "120", "item_type", "", "", "", "", "true", "center"),

+			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency", "", "true", "right"),

+			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency", "", "true", "right"),

+		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency", "", "true", "right"),	

+			array("Description", "300", "description", "", "", "", "", "true", "center"),

 				));

 

 	}

 		return $grid_field_arr;

 	}

 	function get_charges_search_form() {

-		$accountinfo=$this->CI->session->userdata('accountinfo');

-		$reseller_id=$accountinfo['type']==1 ? $accountinfo['id'] : 0;

+		$accountinfo = $this->CI->session->userdata('accountinfo');

+		$reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;

 		$form['forms'] = array("", array('id' => "charges_search"));

 		$form['Search'] = array(

 			array('From Date', 'INPUT', array('name' => 'created_date[]', 'id' => 'charge_from_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'start_date[start_date-date]'),

 			array('To Date', 'INPUT', array('name' => 'created_date[]', 'id' => 'charge_to_date', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '', 'end_date[end_date-date]'),

-		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id,"type"=>"GLOBAL")),

+		array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id, "type"=>"GLOBAL")),

 		array('Debit ', 'INPUT', array('name' => 'debit[debit]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'debit[debit-integer]', '', '', '', 'search_int_type', ''),

 		array('Credit ', 'INPUT', array('name' => 'credit[credit]', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', 'credit[credit-integer]', '', '', '', 'search_int_type', ''),

 

@@ -575,20 +575,20 @@ 
         ASTPP  3.0

         Charges History

     *********/

-	function build_charge_list_for_customer(){

+	function build_charge_list_for_customer() {

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);	

+		$currency_id = $account_info['currency_id'];

+		$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);	

 		

 		$grid_field_arr = json_encode(array(

-			array("Created Date", "100", "created_date", "", "", "","","true","center"),

-			array("Invoice Number", "110", "created_date", "", "", "","","true","center"),

-			array("Charge Type", "100", "item_type", "", "", "","","true","center"),

-			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency","","true","right"),

-			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency","","true","right"),

-			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency","","true","right"),

-		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency","","true","right"),

-			array("Description", "270", "description", "", "", "","","true","center"),

+			array("Created Date", "100", "created_date", "", "", "", "", "true", "center"),

+			array("Invoice Number", "110", "created_date", "", "", "", "", "true", "center"),

+			array("Charge Type", "100", "item_type", "", "", "", "", "true", "center"),

+			array("Before Balance<br/>($currency)", "120", "before_balance", "before_balance", "before_balance", "convert_to_currency", "", "true", "right"),

+			array("Debit (-)<br/>($currency)", "110", "debit", "debit", "debit", "convert_to_currency", "", "true", "right"),

+			array("Credit (+)<br/>($currency)", "110", "credit", "credit", "credit", "convert_to_currency", "", "true", "right"),

+		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency", "", "true", "right"),

+			array("Description", "270", "description", "", "", "", "", "true", "center"),

 				));

 		return $grid_field_arr;

 	}

@@ -596,17 +596,17 @@ 
         ASTPP  3.0

         Refill History

     *********/

-	function build_refillreport_for_customer(){

+	function build_refillreport_for_customer() {

 		

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

-		$currency_id=$account_info['currency_id'];

-		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);		

+		$currency_id = $account_info['currency_id'];

+		$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);		

 		

 		 $grid_field_arr = json_encode(array(

-			array("Date", "225", "payment_date", "", "", "","","true","center"),

-			array("Amount($currency)", "250", "credit", "credit", "credit", "convert_to_currency","","true","right"),

-			array("Refill By", "230", "payment_by", "payment_by", "payment_by", "get_refill_by","","true","center"),

-			array("Note", "325", "notes", "", "", "","","true","center")

+			array("Date", "225", "payment_date", "", "", "", "", "true", "center"),

+			array("Amount($currency)", "250", "credit", "credit", "credit", "convert_to_currency", "", "true", "right"),

+			array("Refill By", "230", "payment_by", "payment_by", "payment_by", "get_refill_by", "", "true", "center"),

+			array("Note", "325", "notes", "", "", "", "", "true", "center")

 				));

 		return $grid_field_arr;

 	}

Braces +7 added lines, -8 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'))

-	exit('No direct script access allowed');

+if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 

 class Reports_form {

 	function __construct() {

@@ -56,8 +57,7 @@ 
 			array('Call Type', 'calltype', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_calltype'),

 			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),

 			array('', 'HIDDEN', 'advance_search', '1', '', '', ''));

-			 }

-		else

+			 } else

 		{

 		$form['forms'] = array("", array('id' => "cdr_customer_search"));

 		$form['Search'] = array(

@@ -190,8 +190,7 @@ 
 				$recording,

 				));

                 

-				}

-				else{

+				} else{

 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');

 		$currency_id=$account_info['currency_id'];

 		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);

@@ -348,7 +347,7 @@ 
 			$account_data = $this->CI->session->userdata("accountinfo");

 			$loginid = $account_data['id'];

 

-		}else{

+		} else{

 			$loginid = "0";

 		}

 		if($logintype==0 || $logintype==3){

@@ -535,7 +534,7 @@ 
 		array("After Balance<br/>($currency)", "120", "after_balance", "after_balance", "after_balance", "convert_to_currency","","true","right"),	

 			array(gettext("Description"), "300", "description", "", "", "","","true","center"),

 				));

-	}else{

+	} else{

 		$grid_field_arr = json_encode(array(

 			array("Created Date", "120", "created_date", "", "", "","","true","center"),

 			array("Invoice Number", "120", "created_date", "", "", "","","true","center"),

web_interface/astpp/application/modules/opensips/models/opensips_model.php

Spacing +44 added lines, -44 removed lines

@@ -25,21 +25,21 @@ 
 	function Opensips_model() {
 		parent::__construct();
 		$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);
 	}
     
 	function getopensipsdevice_list($flag, $start = 0, $limit = 0) {
-		$this->db_model->build_search_opensips($this->opensips_db,'opensipsdevice_list_search');
-		$accountinfo=$this->session->userdata('accountinfo');
-	$reseller_id=$accountinfo['type']==1 ? $accountinfo['id'] : 0;
-		$this->opensips_db->where('reseller_id',$reseller_id);
+		$this->db_model->build_search_opensips($this->opensips_db, 'opensipsdevice_list_search');
+		$accountinfo = $this->session->userdata('accountinfo');
+	$reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;
+		$this->opensips_db->where('reseller_id', $reseller_id);
 		if ($flag) {
-			$this->opensips_db->limit($limit,$start);
-			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
-			$this->opensips_db->order_by('username','asc');
+			$this->opensips_db->limit($limit, $start);
+			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
+			$this->opensips_db->order_by('username', 'asc');
 		}
 			$query = $this->opensips_db->get("subscriber");
 		} else {
@@ -49,52 +49,52 @@ 
 		return $query;
 	}
     
-	function getopensipsdevice_customer_list($flag, $accountid = "",$accounttype, $start = "0", $limit = "0") {
+	function getopensipsdevice_customer_list($flag, $accountid = "", $accounttype, $start = "0", $limit = "0") {
 
 		if ($accountid != "") {
 			$where = array("accountcode" => $this->common->get_field_name('number', 'accounts', array('id' => $accountid)));
 		}
-		$instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_opensips');
-		$like_str=!empty($instant_search) ? "(username like '%$instant_search%'
+		$instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_opensips');
+		$like_str = ! empty($instant_search) ? "(username like '%$instant_search%'
                                             OR  password like '%$instant_search%'
                                             OR  domain like '%$instant_search%'
                                             OR  effective_caller_id_name like '%$instant_search%'
                                             OR  effective_caller_id_number like '%$instant_search%'
                                                 )"
 										   :null;
-		if(!empty($like_str))
+		if ( ! empty($like_str))
 		$this->opensips_db->where($like_str);
 		$this->opensips_db->where($where);
 		if ($flag) {
-		  $this->opensips_db->limit($limit,$start);            
+		  $this->opensips_db->limit($limit, $start);            
 		}
 		$result = $this->opensips_db->get("subscriber");
-		if($result->num_rows() > 0){
-	  if($flag){
+		if ($result->num_rows() > 0) {
+	  if ($flag) {
 		return $result;
 	  }
-	  else{
+	  else {
 		return $result->num_rows();
 	  }
-		}else{
-		 if($flag){
-		  $result=(object)array('num_rows'=>0);
+		} else {
+		 if ($flag) {
+		  $result = (object)array('num_rows'=>0);
 	  }
-	  else{
-		  $result=0;
+	  else {
+		  $result = 0;
 	  }
 	  return $result;
 		}
 	}
 
 	function getopensipsdispatcher_list($flag, $start = '', $limit = '') {
-	   $this->db_model->build_search_opensips($this->opensips_db,'opensipsdispatcher_list_search');
+	   $this->db_model->build_search_opensips($this->opensips_db, 'opensipsdispatcher_list_search');
 	  if ($flag) {
-			$this->opensips_db->limit( $limit,$start);
-			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
-			$this->opensips_db->order_by('setid','asc');
+			$this->opensips_db->limit($limit, $start);
+			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+		} else {
+			$this->opensips_db->order_by('setid', 'asc');
 		}
 			$query = $this->opensips_db->get("dispatcher");
 		} else {
@@ -109,18 +109,18 @@ 
 
  function add_opensipsdevices($data) {
 		unset($data["action"]);
-		$data['creation_date']=gmdate("Y-m-d H:i:s");
-		$accountinfo=$this->session->userdata('accountinfo');
-		$data['reseller_id']=$accountinfo['type']==1 ? $accountinfo['id'] : 0;
+		$data['creation_date'] = gmdate("Y-m-d H:i:s");
+		$accountinfo = $this->session->userdata('accountinfo');
+		$data['reseller_id'] = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;
 		unset($data["id"]);	
 		$this->opensips_db->insert("subscriber", $data);
 	}
 
 	function edit_opensipsdevices($data, $id) {
 	  unset($data["action"]);
-	  $data=array("username"=>$data['username'],"password"=>$data['password'],"accountcode"=>$data['accountcode'],"domain"=>$data['domain'],"effective_caller_id_name"=>$data['effective_caller_id_name'],"effective_caller_id_number"=>$data['effective_caller_id_number'],"status"=>$data['status']);
+	  $data = array("username"=>$data['username'], "password"=>$data['password'], "accountcode"=>$data['accountcode'], "domain"=>$data['domain'], "effective_caller_id_name"=>$data['effective_caller_id_name'], "effective_caller_id_number"=>$data['effective_caller_id_number'], "status"=>$data['status']);
 	  $this->opensips_db->where("id", $id);
-	  $data['last_modified_date']=gmdate("Y-m-d H:i:s");
+	  $data['last_modified_date'] = gmdate("Y-m-d H:i:s");
 	  $this->opensips_db->update("subscriber", $data);
 	}
 	function delete_opensips_devices($id) {
@@ -160,11 +160,11 @@ 
 			foreach ($account_search as $key => $value) {
 				if ($value != "") {
 					if (is_array($value)) {
-						if (array_key_exists($key . "-integer", $value)) {
-							$this->get_interger_array($key, $value[$key . "-integer"], $value[$key]);
+						if (array_key_exists($key."-integer", $value)) {
+							$this->get_interger_array($key, $value[$key."-integer"], $value[$key]);
 						}
-						if (array_key_exists($key . "-string", $value)) {
-							$this->get_string_array($key, $value[$key . "-string"], $value[$key]);
+						if (array_key_exists($key."-string", $value)) {
+							$this->get_string_array($key, $value[$key."-string"], $value[$key]);
 						}
 					} else {
 						$this->opensips_db->where($key, $value);
@@ -181,19 +181,19 @@ 
 					$this->opensips_db->where($field, $search_array);
 					break;
 				case "2":
-					$this->opensips_db->where($field . ' <>', $search_array);
+					$this->opensips_db->where($field.' <>', $search_array);
 					break;
 				case "3":
-					$this->opensips_db->where($field . ' > ', $search_array);
+					$this->opensips_db->where($field.' > ', $search_array);
 					break;
 				case "4":
-					$this->opensips_db->where($field . ' < ', $search_array);
+					$this->opensips_db->where($field.' < ', $search_array);
 					break;
 				case "5":
-					$this->opensips_db->where($field . ' >= ', $search_array);
+					$this->opensips_db->where($field.' >= ', $search_array);
 					break;
 				case "6":
-					$this->opensips_db->where($field . ' <= ', $search_array);
+					$this->opensips_db->where($field.' <= ', $search_array);
 					break;
 			}
 		}
@@ -212,7 +212,7 @@ 
 					$this->opensips_db->where($field, $search_array);
 					break;
 				case "4":
-					$this->opensips_db->where($field . ' <>', $search_array);
+					$this->opensips_db->where($field.' <>', $search_array);
 					break;
 			}
 		}

Braces +8 added lines, -9 removed lines

@@ -38,7 +38,7 @@ 
 			$this->opensips_db->limit($limit,$start);
 			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		} else{
 			$this->opensips_db->order_by('username','asc');
 		}
 			$query = $this->opensips_db->get("subscriber");
@@ -62,8 +62,9 @@ 
                                             OR  effective_caller_id_number like '%$instant_search%'
                                                 )"
 										   :null;
-		if(!empty($like_str))
-		$this->opensips_db->where($like_str);
+		if(!empty($like_str)) {
+				$this->opensips_db->where($like_str);
+		}
 		$this->opensips_db->where($where);
 		if ($flag) {
 		  $this->opensips_db->limit($limit,$start);            
@@ -72,15 +73,13 @@ 
 		if($result->num_rows() > 0){
 	  if($flag){
 		return $result;
-	  }
-	  else{
+	  } else{
 		return $result->num_rows();
 	  }
-		}else{
+		} else{
 		 if($flag){
 		  $result=(object)array('num_rows'=>0);
-	  }
-	  else{
+	  } else{
 		  $result=0;
 	  }
 	  return $result;
@@ -93,7 +92,7 @@ 
 			$this->opensips_db->limit( $limit,$start);
 			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 		$this->opensips_db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		}else{
+		} else{
 			$this->opensips_db->order_by('setid','asc');
 		}
 			$query = $this->opensips_db->get("dispatcher");