Rates::csv_to_array() - Code Metrics - Inspection of "Import mapper" - iNextrix/ASTPP - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Pull Request — v3.0 (#189)

unknown
created 2017-03-19 22:42 UTC
Rates::csv_to_array() B

↳ Parent: Rates
Complexity

Conditions	6
Paths	3
Size

Total Lines	18
Code Lines	10
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	6
eloc	10
nc	3
nop	2
dl	0
loc	18
rs	8.8571
c	0
b	0
f	0
<?php
###############################################################################
# ASTPP - Open Source VoIP Billing Solution
#
# Copyright (C) 2016 iNextrix Technologies Pvt. Ltd.
# Samir Doshi <[email protected]>
# ASTPP Version 3.0 and above
# License https://www.gnu.org/licenses/agpl-3.0.html
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
# published by the Free Software Foundation, either version 3 of the
# License, or (at your option) any later version.
# 
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.
# 
# 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/>.
###############################################################################
class Rates extends MX_Controller {

	function Rates() {
		parent::__construct();
class Daddy
{
    protected function getFirstName()
    {
        return "Eidur";
    }

    protected function getSurName()
    {
        return "Gudjohnsen";
    }
}

class Son
{
    public function getFirstName()
    {
        return parent::getSurname();
    }
}

		$this->load->helper('template_inheritance');

		$this->load->library('session');
		$this->load->library('rates_form');
		$this->load->library('astpp/form');
		$this->load->model('rates_model');
		$this->load->library('csvreader');
		ini_set("memory_limit", "2048M");
		ini_set("max_execution_time", "259200");
		ini_set("upload_max_filesize", "200M");
		if ($this->session->userdata('user_login') == FALSE)
			redirect(base_url() . '/astpp/login');
	}

	function termination_rates_list() {
		$data['username'] = $this->session->userdata('user_name');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$data['page_title'] = 'Termination Rates';
		$data['search_flag'] = true;
		$data['batch_update_flag'] = true;
/*********
ASTPP  3.0 
Batch Delete
*********/
		$data['delete_batch_flag'] = true;
/***************/
		$this->session->set_userdata('advance_search', 0);
		$data['grid_fields'] = $this->rates_form->build_termination_rate_for_admin();
		$data["grid_buttons"] = $this->rates_form->build_grid_buttons();
		$data['form_search'] = $this->form->build_serach_form($this->rates_form->get_termination_rate_search_form());
		$data['form_batch_update'] = $this->form->build_batchupdate_form($this->rates_form->termination_rate_batch_update_form());
		$this->load->view('view_termination_rates_list', $data);
	}
	/**
	 * -------Here we write code for controller accounts functions account_list------
	 * Listing of Accounts table data through php function json_encode
	 */
	function termination_rates_list_json() {
		$json_data = array();
		$count_all = $this->rates_model->get_termination_rates_list(false);
		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
		$json_data = $paging_data["json_paging"];

		$query = $this->rates_model->get_termination_rates_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
		$grid_fields = json_decode($this->rates_form->build_termination_rate_for_admin());
		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);

		echo json_encode($json_data);
	}
	  function termination_rates_list_delete($flag='') {

		$json_data = array();
		$this->session->set_userdata('advance_batch_data_delete',1);
		$count_all = $this->rates_model->get_termination_rates_list(false);
	echo $count_all; 
	} 
/****************/
	 function termination_rate_import() {
		$data['page_title'] = 'Import Termination Rates';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$this->session->set_userdata('import_termination_rate_csv',"");
		$this->session->set_userdata('import_termination_rate_csv_error',"");
		$this->load->view('view_import_termination_rate', $data);
	}
	function termination_rate_preview_file(){
		$invalid_flag= false;
	$check_header=$this->input->post('check_header',true);
	$data['page_title'] = 'Import Termination Rates';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$new_final_arr_key = $this->config->item('Termination-rates-field');
		if(empty($_FILES) || !isset($_FILES)){
	  redirect(base_url()."rates/termination_rates_list/");
	}
		if (isset($_FILES['termination_rate_import']['name']) && $_FILES['termination_rate_import']['name'] != "" &&  isset($_POST['trunk_id']) && $_POST['trunk_id'] != '') {
			list($txt, $ext) = explode(".", $_FILES['termination_rate_import']['name']);
<?php

function returnThreeValues() {
    return array('a', 'b', 'c');
}

list($a, $b, $c) = returnThreeValues();

print $a . " - " . $c;
			if($ext == "csv" && $_FILES['termination_rate_import']['size'] > 0){ 
				$error = $_FILES['termination_rate_import']['error'];
				if ($error == 0 ) {
					$uploadedFile = $_FILES["termination_rate_import"]["tmp_name"];
					$csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header);
			if(!empty($csv_data)){
			$full_path = $this->config->item('rates-file-path');
			$actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s"). "." . $ext;
			if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) {
			  $data['csv_tmp_data'] = $csv_data;
			  $data['trunkid'] = $_POST['trunk_id'];
			  $data['check_header']=$check_header;
			  $data['page_title'] = 'Termination Rates Preview';
			  $this->session->set_userdata('import_termination_rate_csv',$actual_file_name);
			}else{
			  $data['error'] = "File Uploading Fail Please Try Again";
			}
					}
				}
				else{
					$data['error']=="File Uploading Fail Please Try Again";
				}
			}else {
				$data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)";
			}
		}else{
		$invalid_flag=true;
		}
		if ($invalid_flag) {
			$str = '';
			if (!isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) {
				$str.= '<br/>Please Create Trunk.';
			}
			if (empty($_FILES['termination_rate_import']['name'])) {
				$str.= '<br/>Please Select  File.';
			}
			$data['error']=$str;
		}
		$this->load->view('view_import_termination_rate', $data);
	}
	function termination_rate_rates_import($trunkID,$check_header=false) {
		$new_final_arr = array();
		$invalid_array = array();
		$new_final_arr_key = $this->config->item('Termination-rates-field');
	$screen_path = $this->config->item('screen_path');
		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
			$account_data = $this->session->userdata("accountinfo");
		}
	$full_path = $this->config->item('rates-file-path');
		$terminationrate_file_name = $this->session->userdata('import_termination_rate_csv');	
		$csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name,$new_final_arr_key,$check_header); 
	$i=0;
		foreach ($csv_tmp_data as $key => $csv_data) {
	 if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){
		$str=null;
		$csv_data['prepend']= isset($csv_data['prepend'])? $csv_data['prepend'] :'';
		$csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :'';
		$csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0;
		$csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0;
		$csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0;
		$csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0;
		$csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :'';
		$csv_data['strip']= isset($csv_data['strip']) ? $csv_data['strip'] :'';
		$csv_data['last_modified_date'] = date("Y-m-d H:i:s");
		$str=$this->data_validate($csv_data);
		if($str != ""){
		  $invalid_array[$i]=$csv_data;
		  $invalid_array[$i]['error'] = $str;
		}
		else{
		  $csv_data['trunk_id']=$trunkID;
		  $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*";
		  $new_final_arr[$i]=$csv_data;
		}
	  }
		  $i++;
		}
		 if(!empty($new_final_arr)){
 		$result = $this->rates_model->bulk_insert_termination_rate($new_final_arr);
		 }
		  unlink($full_path.$terminationrate_file_name);
	  $count=count($invalid_array);
		if($count >0){
			$session_id = "-1";
			$fp = fopen($full_path.$session_id.'.csv', 'w');
			foreach($new_final_arr_key as $key=>$value){
		  $custom_array[0][$key]=ucfirst($key);
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			}
			$custom_array[0]['error']= "Error";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$invalid_array =array_merge($custom_array,$invalid_array);
			foreach($invalid_array as $err_data){
					fputcsv($fp,$err_data);
			}
		   fclose($fp);
		   $this->session->set_userdata('import_termination_rate_csv_error', $session_id.".csv");
		   $data["error"] = $invalid_array;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		   $data['trunkid'] = $trunkID;
		   $data['impoted_count'] = count($new_final_arr);
		   $data['failure_count'] = count($invalid_array)-1;
		   $data['page_title'] = 'Termination Rates Import Error';	
		   $this->load->view('view_import_error',$data);
		 } else{
	  $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Termination rates imported successfully!');
		   redirect(base_url()."rates/termination_rates_list/");
		 }        
	}
	function termination_rate_error_download(){
		$this->load->helper('download');
		$error_data =  $this->session->userdata('import_termination_rate_csv_error');
		$full_path = $this->config->item('rates-file-path');
		$data = file_get_contents($full_path.$error_data);
		force_download("Termination_rate_error.csv", $data); 

	}  
	function origination_rate_import() {
		$data['page_title'] = 'Import Origination Rates';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$this->session->set_userdata('import_origination_rate_csv',"");
		$error_data =  $this->session->userdata('import_origination_rate_csv_error');
		$full_path = $this->config->item('rates-file-path');
		if(file_exists($full_path.$error_data) && $error_data != ""){
			unlink($full_path.$error_data);
			$this->session->set_userdata('import_origination_rate_csv_error',"");
		}
		$this->load->view('view_import_origination_rate', $data);
	}
	function origination_rate_preview_file(){
	$invalid_flag= false;
	$data=array();
	$data['page_title'] = 'Import Origination Rates';
	$check_header=$this->input->post('check_header',true);
	if(empty($_FILES) || !isset($_FILES)){
	  redirect(base_url()."rates/origination_rate_list/");
	}
	$get_extension=strpos($_FILES['origination_rate_import']['name'],'.');
	$new_final_arr_key = $this->config->item('Origination-rates-field');
	if(!$get_extension){
		$data['error']= "Please Upload File Atleast";
		}
		if (isset($_FILES['origination_rate_import']['name']) && $_FILES['origination_rate_import']['name'] != "" && isset($_POST['pricelist_id']) && $_POST['pricelist_id'] != '') {
			list($txt,$ext) = explode(".", $_FILES['origination_rate_import']['name']);
<?php

function returnThreeValues() {
    return array('a', 'b', 'c');
}

list($a, $b, $c) = returnThreeValues();

print $a . " - " . $c;
            
			if($ext == "csv" && $_FILES['origination_rate_import']['size'] > 0){ 
				$error = $_FILES['origination_rate_import']['error'];
				if ($error == 0) {
					$uploadedFile = $_FILES["origination_rate_import"]["tmp_name"];
					$csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header);
					if(!empty($csv_data)){
			$full_path = $this->config->item('rates-file-path');
					$actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s"). "." . $ext;
					if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) {
			$flag=false;
			$data['trunkid']=isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0;
						$data['csv_tmp_data'] = $csv_data;
						$data['pricelistid'] = $_POST['pricelist_id'];
						$data['page_title'] = "Origination Rates Preview";
						$data['check_header']=$check_header;
						$this->session->set_userdata('import_origination_rate_csv',$actual_file_name);
					}else{
						$data['error'] = "File Uploading Fail Please Try Again";
					}
				}
			 }   
			else{
					$data['error']=="File Uploading Fail Please Try Again";
				}
		   }
		   else {
				$data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)";
			}
			}else{
		$invalid_flag=true;
			}
		if ($invalid_flag) {
			$str = '';
			if (!isset($_POST['pricelist_id']) || empty($_POST['pricelist_id'])) {
				$str.= '<br/>Please Create Rate Group.';
			}
			if (empty($_FILES['origination_rate_import']['name'])) {
				$str.= '<br/>Please Select File.';
			}
			$data['error']=$str;
		}
		$this->load->view('view_import_origination_rate', $data);
	}
	function origination_rate_import_file($pricelistID,$trunkid,$check_header=false) {
	   $new_final_arr = array();
		$invalid_array = array();
		$new_final_arr_key = $this->config->item('Origination-rates-field');
	$screen_path = $this->config->item('screen_path');
	$reseller_id=0;
		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
			$reseller_id = $this->session->userdata["accountinfo"]['id'];
		}
        
		$full_path = $this->config->item('rates-file-path');
		$originationrate_file_name = $this->session->userdata('import_origination_rate_csv');	
		$csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name,$new_final_arr_key,$check_header); 
		//echo "<pre>";print_r($csv_tmp_data);exit;

	$i=0;
		foreach ($csv_tmp_data as $key => $csv_data) {	
	  if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){
		$str=null;
		$csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :'';
		$csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0;
		$csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0;
		$csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0;
		$csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0;
		$csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :'';
		$csv_data['last_modified_date'] = date("Y-m-d H:i:s");
		$str=$this->data_validate($csv_data);
		if($str != ""){
		  $invalid_array[$i]=$csv_data;
		  $invalid_array[$i]['error'] = $str;
		}
		else{
		  $csv_data['pricelist_id']=$pricelistID;
		  $csv_data['trunk_id']=$trunkid;
		  $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*";
		  $csv_data['reseller_id']= $reseller_id;
		  $csv_data['creation_date'] = gmdate('Y-m-d H:i:s');
		  $new_final_arr[$i]=$csv_data;
		}
	  }
		  $i++;
		}
		  if(!empty($new_final_arr)){
  		$result = $this->rates_model->bulk_insert_origination_rate($new_final_arr);
		  }
		  unlink($full_path.$originationrate_file_name);
	 $count=count($invalid_array);
		if($count >0){
			$session_id = "-1";
			$fp = fopen($full_path.$session_id.'.csv', 'w');
			foreach($new_final_arr_key as $key=>$value){
		  $custom_array[0][$key]=ucfirst($key);
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			}
			$custom_array[0]['error']= "Error";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$invalid_array =array_merge($custom_array,$invalid_array);
			foreach($invalid_array as $err_data){
					fputcsv($fp,$err_data);
			}
			fclose($fp);
		   $this->session->set_userdata('import_origination_rate_csv_error', $session_id.".csv");
		   $data["error"] = $invalid_array;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		   $data['pricelistid'] = $pricelistID;
		   $data['impoted_count'] = count($new_final_arr);
		   $data['failure_count'] = count($invalid_array)-1;
		   $data['page_title'] = 'Origination Rates Import Error';	
		   $this->load->view('view_import_error',$data);
		 } else{
	   $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Origination rates imported successfully!');
		   redirect(base_url()."rates/origination_rates_list/");
		   }
	}
	 function data_validate($csvdata){
		  $str=null;
	  $alpha_regex = "/^[a-z ,.'-]+$/i";
	  $alpha_numeric_regex = "/^[a-z0-9 ,.'-]+$/i";
	  $email_regex = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/"; 
	  $str.= $csvdata['pattern']!= '' ? null : 'Code,';
	  $str=rtrim($str,',');
	  if(!$str){
		  $str.= is_numeric($csvdata['pattern']) ? null : 'Code,';

		  $str.= !empty($csvdata['connectcost']) && is_numeric( $csvdata['connectcost']) ? null :( empty($csvdata['connectcost']) ? null : 'Connect Cost,');
		  $str.= !empty($csvdata['includedseconds']) && is_numeric( $csvdata['includedseconds']) ? null :( empty($csvdata['includedseconds']) ? null : 'Included Seconds,');

		  $str.= !empty($csvdata['inc']) && is_numeric( $csvdata['inc']) ? null :( empty($csvdata['inc']) ? null : 'Increment,');
		  $str.= !empty($csvdata['precedence']) && is_numeric( $csvdata['precedence']) ? null :( empty($csvdata['precedence']) ? null : 'Precedence,');
		  $str.= (isset($csvdata['strip']) && !empty($csvdata['strip'])) ? (is_numeric($csvdata['strip']) ? null :'Strip,') : null;
		  if($str){
		$str=rtrim($str,',');
		$error_field=explode(',',$str);
		$count = count($error_field);
		$str.= $count > 1 ? ' are not valid' : ' is not Valid';
		return $str;
		  }
		  else{
		  return false;
		  }
	  }
	  else{
	  $str=rtrim($str,',');
		$error_field=explode(',',$str);
		$count = count($error_field);
		$str.= $count > 1 ? ' are required' : ' is Required';
	return $str;
	}
	}
	function origination_rate_error_download(){
		$this->load->helper('download');
		$error_data =  $this->session->userdata('import_origination_rate_csv_error');
		$full_path = $this->config->item('rates-file-path');
		$data = file_get_contents($full_path.$error_data);
		force_download("Origination_rate_error.csv", $data); 
	}
	function origination_rate_add($type = "") {

	
		$data['username'] = $this->session->userdata('user_name');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$data['flag'] = 'create';
		$data['page_title'] = 'Create Origination Rate';
		$data['form'] = $this->form->build_form($this->rates_form->get_origination_rate_form_fields(), '');

		$this->load->view('view_origination_rate_add_edit', $data);
	}

	function origination_rate_edit($edit_id = '') {
		$data['page_title'] = 'Edit Origination Rate';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
			$account_data = $this->session->userdata("accountinfo");
			$reseller = $account_data['id'];
			$where = array('id' => $edit_id, "reseller_id" => $reseller);
		} else {
			$where = array('id' => $edit_id);
		}
		$account = $this->db_model->getSelect("*", "routes", $where);
		if ($account->num_rows > 0) {
			foreach ($account->result_array() as $key => $value) {
				$edit_data = $value;
			}
			$edit_data['connectcost'] = $this->common_model->to_calculate_currency($edit_data['connectcost'], '', '', true, false);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '',true, false);
			$edit_data['pattern'] = filter_var($edit_data['pattern'], FILTER_SANITIZE_NUMBER_INT);

			$data['form'] = $this->form->build_form($this->rates_form->get_origination_rate_form_fields(), $edit_data);
			$this->load->view('view_origination_rate_add_edit', $data);
		} else {
			redirect(base_url() . 'rates/origination_rate_list/');
		}
	}

	function origination_rate_save() {
		$add_array = $this->input->post();
		$data['form'] = $this->form->build_form($this->rates_form->get_origination_rate_form_fields(), $add_array);
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		if ($add_array['id'] != '') {
			$data['page_title'] = 'Edit Origination Rate';
			if ($this->form_validation->run() == FALSE) {
				$data['validation_errors'] = validation_errors();
				echo $data['validation_errors'];
				exit;
			} else {
				$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false);
				$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false);
				$this->rates_model->edit_origination_rate($add_array, $add_array['id']);
				echo json_encode(array("SUCCESS"=> "Origination rate updated successfully!"));
				exit;
			}
		} else {
			$data['page_title'] = 'Add Origination Rate';
			if ($this->form_validation->run() == FALSE) {
				$data['validation_errors'] = validation_errors();
				echo $data['validation_errors'];
				exit;
			} else {

				$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false);
				$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false);
				$this->rates_model->add_origination_rate($add_array);
				echo json_encode(array("SUCCESS"=> "Origination rate added successfully!"));
				exit;
			}
		}
	}

	function origination_rates_list_search() {
		$ajax_search = $this->input->post('ajax_search', 0);

		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
			$action = $this->input->post();
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('origination_rate_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'rates/origination_rates_list/');
		}
	}

	function origination_rates_list_clearsearchfilter() {
		$this->session->set_userdata('advance_search', 0);
		$this->session->set_userdata('account_search', "");
	}

	function termination_rate_delete($id) {
		$this->rates_model->remove_termination_rate($id);
		$this->session->set_flashdata('astpp_notification', 'Termination removed successfully!');
		redirect(base_url() . '/rates/termination_rates_list/');
	}

	function origination_rate_delete($id) {
		$this->rates_model->remove_origination_rate($id);
		$this->session->set_flashdata('astpp_notification', 'Origination rate removed successfully!');
		redirect(base_url() . 'rates/origination_rates_list/');
	}

	function origination_rates_list() {
		$data['username'] = $this->session->userdata('user_name');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$data['page_title'] = 'Origination Rates';
	$data['search_flag'] = true;
	$data['batch_update_flag'] = true;
/*********
ASTPP  3.0 
Batch Delete
*********/
	$data['delete_batch_flag'] = true;
/***************/
		$this->session->set_userdata('advance_search', 0);
		$data['grid_fields'] = $this->rates_form->build_origination_rate_list_for_admin();
		$data["grid_buttons"] = $this->rates_form->build_grid_buttons_origination_rate();
		$data['form_search'] = $this->form->build_serach_form($this->rates_form->get_origination_rate_search_form());
		$data['form_batch_update'] = $this->form->build_batchupdate_form($this->rates_form->origination_rate_batch_update_form());
		$this->load->view('view_origination_rate_list', $data);
	}

/*********
ASTPP  3.0 
Batch Delete
*********/
	function origination_rates_list_json() {
		$json_data = array();
		$count_all = $this->rates_model->get_origination_rate_list(false);
		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
		$json_data = $paging_data["json_paging"];
//echo "<pre>"; print_r($json_data); 

		$query = $this->rates_model->get_origination_rate_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
		$grid_fields = json_decode($this->rates_form->build_origination_rate_list_for_admin());
		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);

		echo json_encode($json_data);
	}

	  function origination_rates_list_delete($flag='') {

		$json_data = array();
		$this->session->set_userdata('advance_batch_data_delete',1);
		$count_all = $this->rates_model->get_origination_rate_list(false);
		echo $count_all; 
	} 
/*******************/
	function termination_rate_add($type = "") {

		$data['username'] = $this->session->userdata('user_name');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$data['flag'] = 'create';
		$data['page_title'] = 'Create Termination Rate';
		$data['form'] = $this->form->build_form($this->rates_form->get_termination_rate_form_fields(), '');
		$this->load->view('view_termination_rate_add_edit', $data);
	}

	function termination_rate_edit($edit_id = '') {
    
		$data['page_title'] = 'Edit Termination Rate';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$where = array('id' => $edit_id);
		$account = $this->db_model->getSelect("*", "outbound_routes", $where);
		foreach ($account->result_array() as $key => $value) {
			$edit_data = $value;
		}
	$edit_data['connectcost'] = $this->common_model->to_calculate_currency($edit_data['connectcost'], '', '', false, false);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
	$edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '', false, false);

		$edit_data['pattern'] = filter_var($edit_data['pattern'], FILTER_SANITIZE_NUMBER_INT);
		$data['form'] = $this->form->build_form($this->rates_form->get_termination_rate_form_fields(), $edit_data);
		$this->load->view('view_termination_rate_add_edit', $data);
	}

	function termination_rate_save() {
		$add_array = $this->input->post();
		$data['form'] = $this->form->build_form($this->rates_form->get_termination_rate_form_fields(), $add_array);
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		if ($add_array['id'] != '') {
			$data['page_title'] = 'Edit Termination Rate';
			if ($this->form_validation->run() == FALSE) {
				$data['validation_errors'] = validation_errors();
				echo $data['validation_errors'];
				exit;
			} else {
				$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false);
				$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false);
				$this->rates_model->edit_termination_rate($add_array, $add_array['id']);
				echo json_encode(array("SUCCESS"=> "Termination updated successfully!"));
				exit;
			}
		} else {
			$data['page_title'] = 'Add Termination Rate';
			if ($this->form_validation->run() == FALSE) {
				$data['validation_errors'] = validation_errors();
				echo $data['validation_errors'];
				exit;
			} else {

				$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false);
				$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false);
				$this->rates_model->add_termination_rate($add_array);
				echo json_encode(array("SUCCESS"=> "Termination added successfully!"));
				exit;
			}
		}
		$this->load->view('view_termination_rate_add_edit', $data);
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
	}

	function termination_rates_list_search() {
		$ajax_search = $this->input->post('ajax_search', 0);

		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
			$action = $this->input->post();
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('termination_rates_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'rates/termination_rates_list/');
		}
	}

	function termination_rates_list_clearsearchfilter() {
		$this->session->set_userdata('advance_search', 0);
		$this->session->set_userdata('account_search', "");
	}

	function customer_block_pattern_list($accountid,$accounttype) {
		$json_data = array();
		$where = array('accountid' => $accountid);
		$instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); 
		$like_str=!empty($instant_search) ? "(blocked_patterns like '%$instant_search%'  OR  destination like '%$instant_search%' )" :null;
		if(!empty($like_str))
		$this->db->where($like_str);
		$count_all = $this->db_model->countQuery("*", "block_patterns", $where);
		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
		$json_data = $paging_data["json_paging"];
		if(!empty($like_str))
		$this->db->where($like_str);
		$pattern_data = $this->db_model->getSelect("*", "block_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]);
		$grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid,$accounttype));
		$json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields);
		echo json_encode($json_data);
	}

	function termination_rate_delete_multiple() {
		$ids = $this->input->post("selected_ids", true);
		$where = "id IN ($ids)";
		$this->db->where($where);
		echo $this->db->delete("outbound_routes");
	}

	function origination_rate_delete_multiple() {
		$ids = $this->input->post("selected_ids", true);
		$where = "id IN ($ids)";
		$this->db->where($where);
		echo $this->db->delete("routes");
	}

	function user_origination_rate_list_json() {
		$json_data = array();
		$account_data = $this->session->userdata("accountinfo");
		$markup = $this->common->get_field_name('markup', 'pricelists', array('id'=>$account_data["pricelist_id"]));
		$markup = ($markup > 0)?$markup:1;

		$count_all = $this->rates_model->get_origination_rate_list_for_user(false);
		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
		$json_data = $paging_data["json_paging"];

		$query = $this->rates_model->get_origination_rate_list_for_user(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
		$grid_fields = json_decode($this->rates_form->build_origination_rate_list_for_user());
		foreach ($query->result_array() as $key => $value) {
			$json_data['rows'][] = array('cell' => array(
					$this->common->get_only_numeric_val("","",$value["pattern"]),
					$value['comment'],
					$value['inc'],
					$this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','',true),
					$this->common_model->calculate_currency($value['connectcost'],'','','',true),
					$value['includedseconds']                    
			));
		}
//        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);

		echo json_encode($json_data);
	}

	function user_origination_rate_list_search() {
		$ajax_search = $this->input->post('ajax_search', 0);

		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
			$action = $this->input->post();
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('origination_rate_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'user/user_rates_list/');
		}
	}

	function user_origination_rate_list_clearsearchfilter() {
		$this->session->set_userdata('advance_search', 0);
		$this->session->set_userdata('account_search', "");
	}
	function customer_rates_download_sample_file($file_name){
		$this->load->helper('download');
		$full_path = base_url()."assets/Rates_File/".$file_name.".csv";
		$arrContextOptions=array(
			"ssl"=>array(
			"verify_peer"=>false,
			"verify_peer_name"=>false,
			),
		);  
		$file = file_get_contents($full_path, false, stream_context_create($arrContextOptions));
		force_download("samplefile.csv", $file); 
	}
	function termination_rate_batch_update(){
		$batch_update_arr = $this->input->post();
	$batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000";
	$batch_update_arr["connectcost"]["connectcost"] = isset($batch_update_arr["connectcost"]["connectcost"])?$this->common_model->add_calculate_currency($batch_update_arr["connectcost"]["connectcost"], '', '', true, false):"0.0000";
//        $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4"));

		$result = $this->rates_model->termination_rate_batch_update($batch_update_arr);
		echo json_encode(array("SUCCESS"=> "Termination rates batch updated successfully!"));
		exit;
	}
    
	function origination_rate_batch_update(){
		$batch_update_arr = $this->input->post();
		 $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000";
//        $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4"));

		$result = $this->rates_model->origination_rate_batch_update($batch_update_arr);
		echo json_encode(array("SUCCESS"=> "Origination rates batch updated successfully!"));
		exit;
	}

	function termination_rate_export_cdr_xls() {
		$account_info = $accountinfo = $this->session->userdata('accountinfo');
		$currency_id=$account_info['currency_id'];
		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
		$query = $this->rates_model->get_termination_rate(true, '', '', false);
		$outbound_array = array();
		ob_clean();
		$outbound_array[] = array("Code", "Destination",  "Connect Cost($currency)", "Included Seconds","Per Minute Cost($currency)","Initial Increment", "Increment","Priority","Strip","Prepend","Trunk","Status","Created Date");
		if ($query->num_rows() > 0) {

			foreach ($query->result_array() as $row) {
				//echo"<pre>";print_r($row);exit;

					$outbound_array[] = array(
						$row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false),
                        
						$row['includedseconds'],
			$this->common_model->calculate_currency($row['cost'],'','',TRUE,false),
/**
ASTPP  3.0 
For Add Initial Increment field
**/
			$row['init_inc'],
/****************************************/
						$row['inc'],
						$row['precedence'],
						$row['strip'],
						$row['prepend'],
						//$row['trunk_id'],
						$this->common->get_field_name('name','trunks',$row["trunk_id"]),
						$this->common->get_status('export', '', $row['status']),
						$row['creation_date'],
                        
						);
				}
			}
		$this->load->helper('csv');
        
		array_to_csv($outbound_array, 'Termination_Rates_' . date("Y-m-d") . '.csv');
       
	}

	function termination_rate_export_cdr_pdf() {
		$query = $this->rates_model->get_termination_rate(true, '', '', false);
		$outbound_array = array();
		$this->load->library('fpdf');
		$this->load->library('pdf');
		$this->fpdf = new PDF('P', 'pt');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->fpdf->initialize('P', 'mm', 'A4');
		$this->fpdf->tablewidths = array(20, 30, 20, 20, 20, 20, 20,20,20);
		$outbound_array[] = array("Code", "Destination",  "Connect Cost","Included Seconds","Per Minute Cost","Initial Increment", "Increment","Precedence","Prepend","Strip");
		if ($query->num_rows() > 0) {

			foreach ($query->result_array() as $row) {
					$outbound_array[] = array(
			$row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$row['connectcost'],
						$row['includedseconds'],
			$this->common_model->calculate_currency($row['cost']),
/**
ASTPP  3.0 
For Add Initial Increment field
**/
			$row['init_inc'],
/*******************************************/
						$row['inc'],
						$row['precedence'],
						$row['prepend'],
						$row['strip']
					);
				}
		}
		$this->fpdf->AliasNbPages();
		$this->fpdf->AddPage();

		$this->fpdf->SetFont('Arial', '', 15);
		$this->fpdf->SetXY(60, 5);
		$this->fpdf->Cell(100, 10, "Outbound Rates Report " . date('Y-m-d'));

		$this->fpdf->SetY(20);
		$this->fpdf->SetFont('Arial', '', 7);
		$this->fpdf->SetFillColor(255, 255, 255);
		$this->fpdf->lMargin = 2;

		$dimensions = $this->fpdf->export_pdf($outbound_array, "7");
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
$object = $a->getObject();
		$this->fpdf->Output('Termination_Rate_' . date("Y-m-d") . '.pdf', "D");
	}
    

	function origination_rate_export_cdr_xls() {
		$account_info = $accountinfo = $this->session->userdata('accountinfo');
		$currency_id=$account_info['currency_id'];
		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
		$query = $this->rates_model->get_origination_rate(true, '', '', false);
	//echo "<pre>";print_r($query);exit;

		$inbound_array = array();
		ob_clean();
		$inbound_array[] = array("Code", "Destination","Connect Cost($currency)","Included Seconds","Per Minute Cost($currency)", "Initial Increment", "Increment","Rate Group","Status","Created Date");
		if ($query->num_rows() > 0) {

			foreach ($query->result_array() as $row) {
				//echo"<pre>";print_r($row);exit;

					$inbound_array[] = array(
						$row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false),
						$row['includedseconds'],
						$this->common_model->calculate_currency($row['cost'],'','',TRUE,false),
/**
ASTPP  3.0 
For Add Initial Increment field
**/
						$row['init_inc'],
/********************************************/
						$row['inc'],
					   // $row['precedence'],

						$this->common->get_field_name('name', 'pricelists', $row['pricelist_id']),
						$this->common->get_status('export', '', $row['status']),
						$row['creation_date'],
					);
				}
			}
		$this->load->helper('csv');
		array_to_csv($inbound_array, 'Origination_Rates_' . date("Y-m-d") . '.csv');
	}
	function origination_rate_export_cdr_pdf() {
		$query = $this->rates_model->get_origination_rate(true, '', '', false);
	
		$inbound_array = array();
		$this->load->library('fpdf');
		$this->load->library('pdf');
		$this->fpdf = new PDF('P', 'pt');

		$this->fpdf->initialize('P', 'mm', 'A4');
		$this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20);
	$inbound_array[] = array("Code", "Destination","Connect Cost","Included Seconds","Per Minute Cost","Initial Increment","Increment");
		if ($query->num_rows() > 0) {
			foreach ($query->result_array() as $row) {
					$inbound_array[] = array(
					   $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$row['connectcost'],
						$row['includedseconds'],
						$this->common_model->calculate_currency($row['cost'],'','','',false),
/**
ASTPP  3.0 
For Add Initial Increment field
**/
			$row['init_inc'],
/*************************************************/
						$row['inc']
					);
				}
		}
		$this->fpdf->AliasNbPages();
		$this->fpdf->AddPage();

		$this->fpdf->SetFont('Arial', '', 15);
		$this->fpdf->SetXY(60, 5);
		$this->fpdf->Cell(100, 10, "Origination Rates Report " . date('Y-m-d'));

		$this->fpdf->SetY(20);
		$this->fpdf->SetFont('Arial', '', 7);
		$this->fpdf->SetFillColor(255, 255, 255);
		$this->fpdf->lMargin = 2;

		$dimensions = $this->fpdf->export_pdf($inbound_array, "5");
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
$object = $a->getObject();
		$this->fpdf->Output('Origination_Rate_' . date("Y-m-d") . '.pdf', "D");
	}

  
	function user_origination_rate_cdr_pdf() {
		$query = $this->rates_model->get_origination_rate_for_user(true, '', '', false);
		$inbound_array = array();
		$this->load->library('fpdf');
		$this->load->library('pdf');
		$this->fpdf = new PDF('P', 'pt');

		$this->fpdf->initialize('P', 'mm', 'A4');
	$this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20);
		$inbound_array[] = array("Code", "Destination", "Increment","Cost Per Minutes",  "Connect Charge", "Included Seconds");
		if ($query->num_rows() > 0) {
			foreach ($query->result_array() as $row) {
					$inbound_array[] = array(
					   $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$row['inc'],
			$this->common_model->calculate_currency($row['cost'],'','','',false),
						$row['connectcost'],
						$row['includedseconds']
					);
			}
		}

		$this->fpdf->AliasNbPages();
		$this->fpdf->AddPage();

		$this->fpdf->SetFont('Arial', '', 15);
		$this->fpdf->SetXY(60, 5);
		$this->fpdf->Cell(100, 10, "Rates Report " . date('Y-m-d'));

		$this->fpdf->SetY(20);
		$this->fpdf->SetFont('Arial', '', 7);
		$this->fpdf->SetFillColor(255, 255, 255);
		$this->fpdf->lMargin = 2;

		$dimensions = $this->fpdf->export_pdf($inbound_array, "5");
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
$object = $a->getObject();
		$this->fpdf->Output('Rates_' . date("Y-m-d") . '.pdf', "D");
	}
	function resellersrates_list(){
	$accountinfo=$this->session->userdata('accountinfo');
	$data['username'] = $this->session->userdata('user_name');
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$data['page_title'] = 'My Rates' ;
		$data['search_flag'] = true;
		$this->session->set_userdata('advance_search', 0);
		$data['grid_fields'] = $this->rates_form->build_rates_list_for_reseller();
		$data["grid_buttons"] = $this->rates_form->build_grid_buttons_rates();
		$data['form_search'] = $this->form->build_serach_form($this->rates_form->get_reseller_origination_rate_search_form());
		$this->load->view('view_resellersrates_list', $data);
	}
	function resellersrates_list_json() {
		$json_data = array();
		$account_data = $this->session->userdata("accountinfo");
		$markup = $this->common->get_field_name('markup', 'pricelists', array('id'=>$account_data["pricelist_id"]));
		//$markup = ($markup > 0)?$markup:1;

		$count_all = $this->rates_model->getreseller_rates_list(false);
		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
		$json_data = $paging_data["json_paging"];
		$query = $this->rates_model->getreseller_rates_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
		$grid_fields = json_decode($this->rates_form->build_rates_list_for_reseller());
		foreach ($query->result_array() as $key => $value) {
			$json_data['rows'][] = array('cell' => array(
					$this->common->get_only_numeric_val("","",$value["pattern"]),
					$value['comment'],
					$this->common_model->calculate_currency($value['connectcost'],'','','true',true),
					$value['includedseconds'],
					$this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','true',true),
					$value['inc'],
					$value['precedence'],
			));
		}
//        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);

		echo json_encode($json_data);
	}
	function resellersrates_list_search() {
		$ajax_search = $this->input->post('ajax_search', 0);

		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
			$action = $this->input->post();
            
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('resellerrates_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'rates/resellersrates_list/');
		}
	}
	function resellersrates_list_clearsearchfilter() {
		$this->session->set_userdata('advance_search', 0);
		$this->session->set_userdata('resellerrates_list_search', "");
	}
	function resellersrates_xls()
	{
		$account_info = $accountinfo = $this->session->userdata('accountinfo');
		$currency_id = $account_info['currency_id'];
		$currency = $this->common->get_field_name('currency', 'currency', $currency_id);
	$query = $this->rates_model->getreseller_rates_list(true, '0', '0', '1');
	$customer_array = array();
	ob_clean();

	$customer_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds", "Per Minute Cost($currency)", "Increment", "Precedence");


	if ($query->num_rows() > 0) {

			foreach ($query->result_array() as $row) {
                
					$customer_array[] = array(
						$row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]),
						$row['comment'],
						$row['connectcost'],
			$row['includedseconds'],
			$this->common_model->calculate_currency($row['cost']),
						$row['inc'],
						$row['precedence']
					);
                
			}
		}
		$this->load->helper('csv');
		array_to_csv($customer_array, 'My_Own_Rate_' . date("Y-m-d") . '.csv');
		exit;
	}
/***********
ASTPP  3.0 
Batch delete
***********/
	function termination_rates_list_batch_delete() {
		$ajax_search = $this->input->post('ajax_search', 0);
		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_batch_delete', $this->input->post('advance_search'));
			$action = $this->input->post();
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('termination_rates_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'rates/termination_rates_list/');
		}
	}
	function origination_rates_list_batch_delete() {
		$ajax_search = $this->input->post('ajax_search', 0);
		if ($this->input->post('advance_search', TRUE) == 1) {
			$this->session->set_userdata('advance_batch_delete', $this->input->post('advance_search'));
			$action = $this->input->post();
			unset($action['action']);
			unset($action['advance_search']);
			$this->session->set_userdata('origination_rate_list_search', $action);
		}
		if (@$ajax_search != 1) {
			redirect(base_url() . 'rates/origination_rates_list/');
		}
	}

	/*************************/
	/********* Import Mapper Code - ISSUE-142 **********/
	function termination_rate_import_mapper()
	{
		$data['page_title'] = 'Import Termination Rates using field mapper';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$this->session->set_userdata('import_termination_rate_mapper_csv', "");
		$this->session->set_userdata('import_termination_rate_mapper_csv_error', "");
		$this->load->view('view_import_termination_rate_mapper', $data);
	}

	function csv_to_array($filename = '', $delimiter = ',')
	{
		if (!file_exists($filename) || !is_readable($filename)) return FALSE;
		$header = NULL;
		$data = array();
		if (($handle = fopen($filename, 'r')) !== FALSE)
		{
			while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
			{
				if (!$header) $header = $row;
				else $data[] = array_combine($header, $row);
			}

			fclose($handle);
		}

		return $data;
	}

	function utf8_converter($array)
	{
		array_walk_recursive($array,
		function (&$item, $key)

		{
			if (!mb_detect_encoding($item, 'utf-8', true))
			{
				$item = utf8_encode($item);
			}
		});
		return $array;
	}

	function termination_rate_mapper_preview_file()
	{
		$invalid_flag = false;
		$check_header = $this->input->post('check_header', true);
		$data['page_title'] = 'Import Termination Rates';
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$new_final_arr_key = $this->config->item('Termination-rates-field');
		if (empty($_FILES) || !isset($_FILES))
		{
			redirect(base_url() . "rates/termination_rates_list/");
		}

		$data['mapto_fields'] = $new_final_arr_key;
		if (isset($_FILES['termination_rate_import_mapper']['name']) && $_FILES['termination_rate_import_mapper']['name'] != "" && isset($_POST['trunk_id']) && $_POST['trunk_id'] != '')
		{
			list($txt, $ext) = explode(".", $_FILES['termination_rate_import_mapper']['name']);
<?php

function returnThreeValues() {
    return array('a', 'b', 'c');
}

list($a, $b, $c) = returnThreeValues();

print $a . " - " . $c;
			if ($ext == "csv" && $_FILES['termination_rate_import_mapper']['size'] > 0)
			{
				$error = $_FILES['termination_rate_import_mapper']['error'];
				if ($error == 0)
				{
					$uploadedFile = $_FILES["termination_rate_import_mapper"]["tmp_name"];
					$file_data = $this->csv_to_array($uploadedFile);
					$field_select = (array_keys($file_data[0]));
					$data['file_data'] = $field_select;

					// $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header);


					$csv_data = $this->utf8_converter($this->csvreader->parse_file($uploadedFile, $field_select, $check_header));
					if (!empty($csv_data))
					{
						$full_path = $this->config->item('rates-file-path');
						$actual_file_name = "ASTPP-TERMINATION-RATES-" . date("Y-m-d H:i:s") . "." . $ext;
						$actual_file_name = str_replace(' ', '-', $actual_file_name);
						$actual_file_name = str_replace(':', '-', $actual_file_name);
						if (move_uploaded_file($uploadedFile, $full_path . $actual_file_name))
						{
							$data['field_select'] = serialize($field_select);
							$data['csv_tmp_data'] = $csv_data;
							$data['trunkid'] = $_POST['trunk_id'];
							$data['check_header'] = $check_header;
							$data['page_title'] = 'Map CSV to Termination Rates';
							$this->session->set_userdata('import_termination_rate_mapper_csv', $actual_file_name);
						}
						else
						{
							$data['error'] = "File Uploading Fail Please Try Again";
						}
					}
				}
				else
				{
					$data['error'] == "File Uploading Fail Please Try Again";
				}
			}
			else
			{
				$data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)";
				$data['error'] = var_dump($_FILES);
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
$object = $a->getObject();
			}
		}
		else
		{
			$invalid_flag = true;
		}

		if ($invalid_flag)
		{
			$str = '';
			if (!isset($_POST['trunk_id']) || empty($_POST['trunk_id']))
			{
				$str.= '<br/>Please Create Trunk.';
			}

			if (empty($_FILES['termination_rate_import_mapper']['name']))
			{
				$str.= '<br/>Please Select  File.';
			}

			$data['error'] = $str;
		}

		$this->load->view('view_import_termination_rate_mapper', $data);
	}

	function termination_rate_rates_mapper_import()
	{

		// var_dump($this->input->post());


		$trunkID = $this->input->post("trunkid");
		$check_header = $this->input->post("check_header");
		$pattern_prefix = $this->input->post("pattern-prefix");
		$filefields = unserialize($this->input->post("filefields"));
		$new_final_arr = array();
		$invalid_array = array();
		$new_final_arr_key = array();
		foreach($filefields as $item)
		{
			$new_final_arr_key[$item] = $item;
		}


		$screen_path = $this->config->item('screen_path');
		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5)
		{
			$account_data = $this->session->userdata("accountinfo");
		}

		$full_path = $this->config->item('rates-file-path');
		$terminationrate_file_name = $this->session->userdata('import_termination_rate_mapper_csv');
		$csv_tmp_data = $this->csvreader->parse_file($full_path . $terminationrate_file_name, $new_final_arr_key, $check_header);
		$i = 0;
		foreach($csv_tmp_data as $key => $csv_data)
		{
			if (isset($csv_data[$this->input->post("pattern-select") ]) && $csv_data[$this->input->post("pattern-select") ] != '' && $i != 0)
			{
				$str = null;
				$csv_data['pattern'] = ($this->input->post("pattern-prefix")) ? $this->input->post("pattern-prefix") . $csv_data[$this->input->post("pattern-select") ] : $csv_data[$this->input->post("pattern-select") ];
				$csv_data['cost'] = ($this->input->post("cost-select")) ? $csv_data[$this->input->post("cost-select") ] : "";
				$csv_data['cost'] = ($this->input->post("cost-prefix")) ? $this->input->post("cost-prefix") . $csv_data['cost'] : $csv_data['cost'];
				$csv_data['prepend'] = ($this->input->post("prepend-select")) ? $csv_data[$this->input->post("prepend-select") ] : "";
				$csv_data['prepend'] = ($this->input->post("prepend-prefix")) ? $this->input->post("prepend-prefix") . $csv_data['prepend'] : $csv_data['prepend'];
				$csv_data['comment'] = ($this->input->post("comment-select")) ? $csv_data[$this->input->post("comment-select") ] : "";
				$csv_data['comment'] = ($this->input->post("comment-prefix")) ? $this->input->post("comment-prefix") . $csv_data['comment'] : $csv_data['comment'];
				$csv_data['connectcost'] = ($this->input->post("connectcost-select")) ? $csv_data[$this->input->post("connectcost-select") ] : "0";
				$csv_data['connectcost'] = ($this->input->post("connectcost-prefix")) ? $this->input->post("connectcost-prefix") . $csv_data['connectcost'] : $csv_data['connectcost'];
				$csv_data['includedseconds'] = ($this->input->post("includedseconds-select")) ? $csv_data[$this->input->post("includedseconds-select") ] : "0";
				$csv_data['includedseconds'] = ($this->input->post("includedseconds-prefix")) ? $this->input->post("includedseconds-prefix") . $csv_data['includedseconds'] : $csv_data['includedseconds'];
				$csv_data['inc'] = ($this->input->post("inc-select")) ? $csv_data[$this->input->post("inc-select") ] : "0";
				$csv_data['inc'] = ($this->input->post("inc-prefix")) ? $this->input->post("inc-prefix") . $csv_data['inc'] : $csv_data['inc'];
				$csv_data['precedence'] = ($this->input->post("precedence-select")) ? $csv_data[$this->input->post("precedence-select") ] : "";
				$csv_data['precedence'] = ($this->input->post("precedence-prefix")) ? $this->input->post("precedence-prefix") . $csv_data['precedence'] : $csv_data['precedence'];
				$csv_data['strip'] = ($this->input->post("strip-select")) ? $csv_data[$this->input->post("strip-select") ] : "";
				$csv_data['strip'] = ($this->input->post("strip-prefix")) ? $this->input->post("strip-prefix") . $csv_data['strip'] : $csv_data['strip'];
				$csv_data['last_modified_date'] = date("Y-m-d H:i:s");
				$str = $this->data_validate($csv_data);
				if ($str != "")
				{
					$invalid_array[$i] = $csv_data;
					$invalid_array[$i]['error'] = $str;
				}
				else
				{
					$new_final_arr[$i]['trunk_id'] = $trunkID;
					$new_final_arr[$i]['pattern'] = "^" . $csv_data['pattern'] . ".*";
					$new_final_arr[$i]['prepend'] = $csv_data['prepend'];
					$new_final_arr[$i]['last_modified_date'] = $csv_data['last_modified_date'];
					$new_final_arr[$i]['comment'] = $csv_data['comment'];
					$new_final_arr[$i]['connectcost'] = $csv_data['connectcost'];
					$new_final_arr[$i]['includedseconds'] = $csv_data['includedseconds'];
					$new_final_arr[$i]['cost'] = !empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0;
					$new_final_arr[$i]['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0;
					$new_final_arr[$i]['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : '';
					$new_final_arr[$i]['strip'] = isset($csv_data['strip']) ? $csv_data['strip'] : '';
				}
			}

			$i++;
		}

		if (!empty($new_final_arr))
		{
			$result = $this->rates_model->bulk_insert_termination_rate($new_final_arr);
		}
        		else
        {

           $this->session->set_flashdata('astpp_errormsg', 'Error - Nothing selected to import/process!');
           redirect(base_url() . 'rates/termination_rates_list/');
		}

		unlink($full_path . $terminationrate_file_name);
		$count = count($invalid_array);
		if ($count > 0)
		{
			$session_id = "-1";
			$fp = fopen($full_path . $session_id . '.csv', 'w');
			foreach($new_final_arr_key as $key => $value)
			{
				$custom_array[0][$key] = ucfirst($key);
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			}

			$custom_array[0]['error'] = "Error";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$invalid_array = array_merge($custom_array, $invalid_array);
			foreach($invalid_array as $err_data)
			{
				fputcsv($fp, $err_data);
			}

			fclose($fp);
			$this->session->set_userdata('import_termination_rate_mapper_csv_error', $session_id . ".csv");
			$data["error"] = $invalid_array;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$data['trunkid'] = $trunkID;
			$data['impoted_count'] = count($new_final_arr);
			$data['failure_count'] = count($invalid_array) - 1;
			$data['page_title'] = 'Termination Rates Import Error';
			$this->load->view('view_import_error', $data);
		}
		else
		{
			$this->session->set_flashdata('astpp_errormsg', 'Total ' . count($new_final_arr) . ' Termination rates imported successfully!');
			redirect(base_url() . "rates/termination_rate_list/");
		}
	}

/*************************/
}
?>

 

Pull Request — v3.0 (#189)

Rates::csv_to_array() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1			<?php
2			###############################################################################
3			# ASTPP - Open Source VoIP Billing Solution
4			#
5			# Copyright (C) 2016 iNextrix Technologies Pvt. Ltd.
6			# Samir Doshi <[email protected]>
7			# ASTPP Version 3.0 and above
8			# License https://www.gnu.org/licenses/agpl-3.0.html
9			#
10			# This program is free software: you can redistribute it and/or modify
11			# it under the terms of the GNU Affero General Public License as
12			# published by the Free Software Foundation, either version 3 of the
13			# License, or (at your option) any later version.
14			#
15			# This program is distributed in the hope that it will be useful,
16			# but WITHOUT ANY WARRANTY; without even the implied warranty of
17			# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18			# GNU Affero General Public License for more details.
19			#
20			# You should have received a copy of the GNU Affero General Public License
21			# along with this program. If not, see <http://www.gnu.org/licenses/>.
22			###############################################################################
23			class Rates extends MX_Controller {
24
25			function Rates() {
26			parent::__construct();
			0 ignored issues – show Comprehensibility Bug introduced 2016-10-16 16:00 UTC by Report Bug Copy Issue Report It seems like you call parent on a different method (`__construct()` instead of `Rates()`). Are you sure this is correct? If so, you might want to change this to `$this->__construct()`. This check looks for a call to a parent method whose name is different than the method from which it is called. Consider the following code: class Daddy { protected function getFirstName() { return "Eidur"; } protected function getSurName() { return "Gudjohnsen"; } } class Son { public function getFirstName() { return parent::getSurname(); } } The `getFirstName()` method in the `Son` calls the wrong method in the parent class. Loading history...
27
28			$this->load->helper('template_inheritance');
29
30			$this->load->library('session');
31			$this->load->library('rates_form');
32			$this->load->library('astpp/form');
33			$this->load->model('rates_model');
34			$this->load->library('csvreader');
35			ini_set("memory_limit", "2048M");
36			ini_set("max_execution_time", "259200");
37			ini_set("upload_max_filesize", "200M");
38			if ($this->session->userdata('user_login') == FALSE)
39			redirect(base_url() . '/astpp/login');
iNextrix / ASTPP

Pull Request — v3.0 (#189)

Rates::csv_to_array() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like
