iNextrix / ASTPP

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;

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>";   
 								}
 							}

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);

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);

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;

 	}

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;
 			}
 		}

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

Spacing +32 added lines, -32 removed lines

@@ -31,10 +31,10 @@ 
 		$this->load->library('astpp/form');
 		$this->load->model('opensips_model');
 		$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);
 		if ($this->session->userdata('user_login') == FALSE)
-			redirect(base_url() . '/astpp/login');
+			redirect(base_url().'/astpp/login');
 	}
 
 	function opensips_add() {
@@ -69,7 +69,7 @@ 
 		$data['form'] = $this->form->build_form($this->opensips_form->get_opensips_form_fields_for_customer($accountid), $edit_data);
 		$this->load->view('view_opensips_add_edit', $data);
 	}
-	 function customer_opensips_add($accountid='') {
+	 function customer_opensips_add($accountid = '') {
 		$data['username'] = $this->session->userdata('user_name');
 		$data['flag'] = 'create';
 		$data['page_title'] = 'Create Opensips';
@@ -88,11 +88,11 @@ 
 				exit;
 			} else {
 				$auth_flag = $this->validate_device_data($add_array);
-				if($auth_flag == "TRUE"){
+				if ($auth_flag == "TRUE") {
 						$this->opensips_model->edit_opensipsdevices($add_array, $add_array['id']);
 						echo json_encode(array("SUCCESS"=> " OpenSips updated successfully!"));
 						exit;
-				}else{
+				} else {
 					   echo json_encode($auth_flag);
 					   exit;
 				}
@@ -105,36 +105,36 @@ 
 				exit;
 			} else {
 				$auth_flag = $this->validate_device_data($add_array);
-				if($auth_flag == "TRUE"){
+				if ($auth_flag == "TRUE") {
 						$this->opensips_model->add_opensipsdevices($add_array);
 						echo json_encode(array("SUCCESS"=> "OpenSips added successfully!"));
 						exit;
-				}else{
+				} else {
 					   echo json_encode($auth_flag);
 						exit;
 				}
 			}
 		}
 	}
-	function validate_device_data($data){
+	function validate_device_data($data) {
 
-		if(isset($data["username"]) && $data["username"] != ""){
+		if (isset($data["username"]) && $data["username"] != "") {
 				$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);
 				$where = array("username"=>$data["username"]);
-				if($data['id'] != ""){
-					$this->opensips_db->where("id <>",$data['id']);
+				if ($data['id'] != "") {
+					$this->opensips_db->where("id <>", $data['id']);
 				}
 				$this->opensips_db->where($where);
 				$auth_flag = $this->opensips_db->get("subscriber");
 				$auth_flag = $auth_flag->num_rows();
-				if($auth_flag == 0){
+				if ($auth_flag == 0) {
 					return "TRUE";
-				}else{
+				} else {
 					return array("username_error"=>"Duplicate Email Address Found Email Must Be Unique.");
 				}
-		}else{
+		} else {
 		  return array("username_error"=>"User name is required field.");
 		}
 		return "0";
@@ -155,13 +155,13 @@ 
 				echo json_encode(array("SUCCESS"=> "Opensips Updated Successfully!"));
 				exit;
 			}
-		}else{
+		} else {
 		  $data['page_title'] = 'Add Opensips';
 		  if ($this->form_validation->run() == FALSE) {
 				$data['validation_errors'] = validation_errors();
 				echo $data['validation_errors'];
 				exit;
-			}else{
+			} else {
 		$this->opensips_model->add_opensipsdevices($array_add);
 				echo json_encode(array("SUCCESS"=> "Opensips Added Successfully!"));
 				exit;
@@ -184,13 +184,13 @@ 
 				echo json_encode(array("SUCCESS"=> "OpenSips Updated Successfully!"));
 				exit;
 			}
-		}else{
+		} else {
 			  $data['page_title'] = 'Add Opensips';
 		  if ($this->form_validation->run() == FALSE) {
 				$data['validation_errors'] = validation_errors();
 				echo $data['validation_errors'];
 				exit;
-			 }else{
+			 } else {
 		$this->opensips_model->add_opensipsdevices($add_array);
 				echo json_encode(array("SUCCESS"=> "OpenSips Added Successfully!"));
 				exit;
@@ -198,14 +198,14 @@ 
 		}
 	}
 
-	function customer_opensips_json($accountid,$accounttype) {
+	function customer_opensips_json($accountid, $accounttype) {
 	
 		$json_data = array();
-		$count_all = $this->opensips_model->getopensipsdevice_customer_list(false, $accountid,$accounttype);
+		$count_all = $this->opensips_model->getopensipsdevice_customer_list(false, $accountid, $accounttype);
 		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
 		$json_data = $paging_data["json_paging"];
 
-		$query = $this->opensips_model->getopensipsdevice_customer_list(true, $accountid,$accounttype, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$query = $this->opensips_model->getopensipsdevice_customer_list(true, $accountid, $accounttype, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
 		$grid_fields = json_decode($this->opensips_form->opensips_customer_build_opensips_list($accountid));
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 
@@ -220,7 +220,7 @@ 
 	function opensips_remove($id) {
 		$this->opensips_model->remove_opensips($id);
 		$this->session->set_flashdata('astpp_notification', 'OpenSips Removed Successfully!');
-		redirect(base_url() . 'opensips/opensips_list/');
+		redirect(base_url().'opensips/opensips_list/');
 	}
 
 	function opensips_list() {
@@ -248,7 +248,7 @@ 
 		$grid_fields = json_decode($this->opensips_form->build_opensips_list());
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 		$result = $this->opensips_db->get("subscriber");
-		if($result->num_rows() <= 0){
+		if ($result->num_rows() <= 0) {
 			$json_data['page'] = 0;
 			$json_data['total'] = 0;
 		}
@@ -267,12 +267,12 @@ 
 			$this->session->set_userdata('opensipsdevice_list_search', $action);
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'opensips/opensips_list/');
+			redirect(base_url().'opensips/opensips_list/');
 		}
 	}
 	function opensips_list_clearsearchfilter() {
-			$this->session->set_userdata('advance_search','');
-			$this->session->set_userdata('opensipsdevice_list_search','');
+			$this->session->set_userdata('advance_search', '');
+			$this->session->set_userdata('opensipsdevice_list_search', '');
 	}
 
 //    dispather List add edit delete
@@ -303,7 +303,7 @@ 
 			$data['page_title'] = 'Edit Dispatcher';
 			if ($this->form_validation->run() == FALSE) {
 				$data['validation_errors'] = validation_errors();
-				echo $data['validation_errors'];exit;
+				echo $data['validation_errors']; exit;
 			} else {
 				$this->opensips_model->edit_opensipsdispatcher($add_array, $add_array['id']);
 				echo json_encode(array("SUCCESS"=> "Dispatcher Updated Successfully!"));
@@ -313,7 +313,7 @@ 
 			$data['page_title'] = 'Add Dispatcher';
 			if ($this->form_validation->run() == FALSE) {
 				$data['validation_errors'] = validation_errors();
-				 echo $data['validation_errors'];exit;
+				 echo $data['validation_errors']; exit;
 			} else {
 				$this->opensips_model->add_opensipsdispatcher($add_array);
 				echo json_encode(array("SUCCESS"=> "Dispatcher Added Successfully!"));
@@ -325,7 +325,7 @@ 
 	function dispatcher_remove($id) {
 		$this->opensips_model->remove_dispatcher($id);
 		$this->session->set_flashdata('astpp_notification', 'Dispatcher Removed Successfully!');
-		redirect(base_url() . 'opensips/dispatcher_list/');
+		redirect(base_url().'opensips/dispatcher_list/');
 	}
 
 	function dispatcher_list() {
@@ -353,7 +353,7 @@ 
 		$grid_fields = json_decode($this->opensips_form->build_opensipsdispatcher_list());
 		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
 		$result = $this->opensips_db->get("subscriber");
-		if($result->num_rows() <= 0){
+		if ($result->num_rows() <= 0) {
 			$json_data['page'] = 0;
 			$json_data['total'] = 0;
 		}
@@ -369,7 +369,7 @@ 
 			$this->session->set_userdata('opensipsdispatcher_list_search', $this->input->post());
 		}
 		if (@$ajax_search != 1) {
-			redirect(base_url() . 'opensips/dispatcher_list/');
+			redirect(base_url().'opensips/dispatcher_list/');
 		}
 	}
 

web_interface/astpp/application/modules/email/models/email_model.php

Spacing +33 added lines, -33 removed lines

@@ -38,27 +38,27 @@ 
 	$account_email = $account_data['email'];
 	$account_type = $account_data['type'];
 	
-	if($account_type == 0){
-		$this->db->where('accountid',$account_id);	
+	if ($account_type == 0) {
+		$this->db->where('accountid', $account_id);	
 	}
-	if($account_type == 1){
+	if ($account_type == 1) {
 	  $this->db->where_in('reseller_id');
 		  $this->db->select('id');
-		  $email_address=$this->db->get('accounts');
+		  $email_address = $this->db->get('accounts');
 
-		  $email_address=$email_address->result_array();
+		  $email_address = $email_address->result_array();
 
-	  if(empty($email_address)){
-		$this->db->or_where('accountid',0);
-	  } else{
-		$this->db->where('reseller_id',$account_id);
+	  if (empty($email_address)) {
+		$this->db->or_where('accountid', 0);
+	  } else {
+		$this->db->where('reseller_id', $account_id);
 	  }
 	  }
 		  $this->db_model->build_search('email_search_list');
 		  if ($flag) {
 		   $query = $this->db_model->select("*", "mail_details", '', "id", "DESC", $limit, $start);
 		  } else {
-			$query = $this->db_model->countQuery("*", "mail_details",'');
+			$query = $this->db_model->countQuery("*", "mail_details", '');
 		  }
 		return $query;
 	}
@@ -78,9 +78,9 @@ 
 		$this->db->where("id", $id);
 		$this->db->update("mail_details", $data);
 	}
-   function customer_get_email_list($flag,$accountid, $start = 0, $limit = 0) {
+   function customer_get_email_list($flag, $accountid, $start = 0, $limit = 0) {
 
-	  $this->db->where('accountid',$accountid);
+	  $this->db->where('accountid', $accountid);
 	   		if ($flag) {
 			$query = $this->db_model->select("*", "mail_details", '', "id", "desc", $limit, $start);
 		} else {
@@ -90,11 +90,11 @@ 
 
 		return $query;
 	}
-	function get_email_client_data($data, $start = 0, $limit = 0){
-	if($data['type'] == ''){
-		$where = array('pricelist_id'=>$data['pricelist_id'],'posttoexternal'=>$data['posttoexternal'],'status'=>$data['status'],'deleted'=>'0');
-	} else{
-		$where = array('pricelist_id'=>$data['pricelist_id'],'posttoexternal'=>$data['posttoexternal'],'status'=>$data['status'],'type'=>$data['type'],'deleted'=>'0');
+	function get_email_client_data($data, $start = 0, $limit = 0) {
+	if ($data['type'] == '') {
+		$where = array('pricelist_id'=>$data['pricelist_id'], 'posttoexternal'=>$data['posttoexternal'], 'status'=>$data['status'], 'deleted'=>'0');
+	} else {
+		$where = array('pricelist_id'=>$data['pricelist_id'], 'posttoexternal'=>$data['posttoexternal'], 'status'=>$data['status'], 'type'=>$data['type'], 'deleted'=>'0');
 	}
 	
 		$query = $this->db_model->getSelect("email,id", "accounts", $where);
@@ -102,28 +102,28 @@ 
 	return $query;	
 	}
 	/*Mass mail*/
-	function multipal_email($data){
-	   $mail_ids=explode(',',$data['to']);
-	foreach($mail_ids as $key=>$val)
+	function multipal_email($data) {
+	   $mail_ids = explode(',', $data['to']);
+	foreach ($mail_ids as $key=>$val)
 	{
-		if($val!='')
+		if ($val != '')
 		{
-			$template_type['message']=$data['template'];
-			$template_type['subject']=$data['subject'];
-			$act_details = $this->db_model->getSelect("*", "accounts", array('email'=>$val,"deleted"=>0));
-			$count=$act_details->num_rows();
-			$account_info=array();
-			if($count<=0)
+			$template_type['message'] = $data['template'];
+			$template_type['subject'] = $data['subject'];
+			$act_details = $this->db_model->getSelect("*", "accounts", array('email'=>$val, "deleted"=>0));
+			$count = $act_details->num_rows();
+			$account_info = array();
+			if ($count <= 0)
 			{
-				$account_info['email']=$val;
-				$account_info['accountid']='0';
-			} else{
+				$account_info['email'] = $val;
+				$account_info['accountid'] = '0';
+			} else {
 				$res_data = $act_details->result_array();
-				$account_info=$res_data[0];
-				$account_info['accountid']=$account_info['id'];
+				$account_info = $res_data[0];
+				$account_info['accountid'] = $account_info['id'];
 			}
 			$account_info['password'] = $this->common->decode($account_info['password']);	
-			$this->email_lib->send_email($template_type,$account_info,'',$data['file'],0,1);
+			$this->email_lib->send_email($template_type, $account_info, '', $data['file'], 0, 1);
 		}
 	}
 		return true;