Rates::resellersrates_xls() - Code Metrics - Inspection of "Issue 142" - iNextrix/ASTPP - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Pull Request — v3.0 (#146)

unknown
created 2016-11-10 13:09 UTC
Rates::resellersrates_xls() B

↳ Parent: Rates
Complexity

Conditions	3
Paths	2
Size

Total Lines	37
Code Lines	28
Duplication

Lines	16
Ratio	43.24 %
Importance

Changes
Metric	Value
cc	3
eloc	28
nc	2
nop	0
dl	16
loc	37
rs	8.8571
c	0
b	0
f	0
<?php

// ##############################################################################
// ASTPP - Open Source VoIP Billing Solution
// test66666666666
// 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]));
					echo "7";
					$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, true));

					// echo "<br /><br />";
					// var_dump($field_select);

					// echo "<br /><br />";
					// var_dump($csv_data);

					// echo "<br /><br />";
					// $csv_data = $this->csvreader->parse_file($uploadedFile,$field_select);


					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['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);
		}

		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 (#146)

Rates::resellersrates_xls() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1			<?php
2
3			// ##############################################################################
4			// ASTPP - Open Source VoIP Billing Solution
5			// test66666666666
6			// Copyright (C) 2016 iNextrix Technologies Pvt. Ltd.
7			// Samir Doshi <[email protected]>
8			// ASTPP Version 3.0 and above
9			// License https://www.gnu.org/licenses/agpl-3.0.html
10			//
11			// This program is free software: you can redistribute it and/or modify
12			// it under the terms of the GNU Affero General Public License as
13			// published by the Free Software Foundation, either version 3 of the
14			// License, or (at your option) any later version.
15			//
16			// This program is distributed in the hope that it will be useful,
17			// but WITHOUT ANY WARRANTY; without even the implied warranty of
18			// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19			// GNU Affero General Public License for more details.
20			//
21			// You should have received a copy of the GNU Affero General Public License
22			// along with this program. If not, see <http://www.gnu.org/licenses/>.
23			// ##############################################################################
24
25			class Rates extends MX_Controller
26
27			{
28			function Rates()
29			{
30			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...
31			$this->load->helper('template_inheritance');
32			$this->load->library('session');
33			$this->load->library('rates_form');
34			$this->load->library('astpp/form');
35			$this->load->model('rates_model');
36			$this->load->library('csvreader');
37			ini_set("memory_limit", "2048M");
38			ini_set("max_execution_time", "259200");
39			ini_set("upload_max_filesize", "200M");
iNextrix / ASTPP

Pull Request — v3.0 (#146)

Rates::resellersrates_xls() B

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like
