iNextrix / ASTPP

web_interface/astpp/application/controllers/getbalance.php

Indentation +13 added lines, -13 removed lines

@@ -27,7 +27,7 @@ 
 	{
 		parent::__construct();
 		$this->load->model('common_model');
-                $this->load->library('common');
+				$this->load->library('common');
 		$this->load->model('db_model');
 		$this->load->model('Astpp_common');
 	}
@@ -35,19 +35,19 @@ 
 	$opensips_flag=common_model::$global_config['system_config']['opensips'];
 	$accountid_arr=0;
  	if($opensips_flag == '1'){
-            $where=array('username'=>$sipnumber);
-            $accountid_arr=$this->db_model->getSelect('accountid','sip_devices',$where);
-        }
+			$where=array('username'=>$sipnumber);
+			$accountid_arr=$this->db_model->getSelect('accountid','sip_devices',$where);
+		}
 	else{
-	      $db_config = Common_model::$global_config['system_config'];
-	      $opensipdsn = "mysql://" . $db_config['opensips_dbuser'] . ":" . $db_config['opensips_dbpass'] . "@" . $db_config['opensips_dbhost'] . "/" . $db_config['opensips_dbname'] . "?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
-	    $this->opensips_db = $this->load->database($opensipdsn, true);
-	    $this->opensips_db->where(array("username"=>$sipnumber));
-	    $accountnum_arr=$this->opensips_db->get("subscriber");
-            $accountnum_arr=$accountnum_arr->result_array();
-	    foreach($accountnum_arr as $value_num){
-	    $accountid_arr = $this->db_model->getSelect('id','accounts',array('number'=>$value_num['accountcode']));
-	    }
+		  $db_config = Common_model::$global_config['system_config'];
+		  $opensipdsn = "mysql://" . $db_config['opensips_dbuser'] . ":" . $db_config['opensips_dbpass'] . "@" . $db_config['opensips_dbhost'] . "/" . $db_config['opensips_dbname'] . "?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
+		$this->opensips_db = $this->load->database($opensipdsn, true);
+		$this->opensips_db->where(array("username"=>$sipnumber));
+		$accountnum_arr=$this->opensips_db->get("subscriber");
+			$accountnum_arr=$accountnum_arr->result_array();
+		foreach($accountnum_arr as $value_num){
+		$accountid_arr = $this->db_model->getSelect('id','accounts',array('number'=>$value_num['accountcode']));
+		}
 	}
 	if($accountid_arr == ''){
 		echo "Please enter proper username of SIP Account";

web_interface/astpp/application/controllers/newmail.php

Indentation +3 added lines, -3 removed lines

@@ -25,7 +25,7 @@ 
 {
 	function __construct()
 	{
-        $this->load->library('astpp/email_lib');
+		$this->load->library('astpp/email_lib');
 		parent::__construct();
 	}
 	
@@ -37,7 +37,7 @@ 
 	}
 	function customer_mail_result($flag=FALSE){
 	$account_info = $this->session->userdata['accountinfo'];
-        $post_array = $this->input->post();
+		$post_array = $this->input->post();
 	$post_array['accountid']=$account_info['id'];
 	$post_array['history_id']=0;
 	$post_array['email']=$post_array['to'];
@@ -46,7 +46,7 @@ 
 		$this->thanks();
 	}
 	function thanks(){
-            $this->load->view('view_mail_response');
+			$this->load->view('view_mail_response');
 	}	
 
 }

web_interface/astpp/application/controllers/generateInvoice.php

Indentation +219 added lines, -219 removed lines

@@ -24,249 +24,249 @@
 
 class GenerateInvoice extends MX_Controller {
 
-    public static $global_config;
+	public static $global_config;
 
-    function __construct() {
-        parent::__construct();
-        $this->load->model("db_model");
-        $this->load->library("astpp/common");
-        $this->load->library('html2pdf');
-        ini_set("memory_limit", "2048M");
-        ini_set("max_execution_time", "259200");
-        $this->get_system_config();
-    }
+	function __construct() {
+		parent::__construct();
+		$this->load->model("db_model");
+		$this->load->library("astpp/common");
+		$this->load->library('html2pdf');
+		ini_set("memory_limit", "2048M");
+		ini_set("max_execution_time", "259200");
+		$this->get_system_config();
+	}
 
-    function get_system_config() {
-        $query = $this->db->get("system");
-        $config = array();
-        $result = $query->result_array();
-        foreach ($result as $row) {
-            $config[$row['name']] = $row['value'];
-        }
-        self::$global_config['system_config'] = $config;
-    }
+	function get_system_config() {
+		$query = $this->db->get("system");
+		$config = array();
+		$result = $query->result_array();
+		foreach ($result as $row) {
+			$config[$row['name']] = $row['value'];
+		}
+		self::$global_config['system_config'] = $config;
+	}
 
-    function getInvoiceData() {
-        $where = array("posttoexternal" => 1, "deleted" => "0", "status" => "0");
-        $query = $this->db_model->getSelect("*", "accounts", $where);
-        if ($query->num_rows > 0) {
-            $account_data = $query->result_array();
-            foreach ($account_data as $data_key => $account_value) {
-                $end_date = gmdate("Y-m-d") . " 23:59:59";
-                $account_value['sweep_id'] = (int) $account_value['sweep_id'];
-                switch ($account_value['sweep_id']) {
-                    case 0:
-                        $start_date = $this->validate_invoice_date($account_value);
-                        if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
-                            $start_date = gmdate("Y-m-d H:i:s");
-                        }
-                        $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 days"));
-                        $this->Generate_Daily_invoice($account_value, $start_date, $end_date);
-                        break;
-                    case 2:
-                        if (date("d") == $account_value['invoice_day']) {
-                            $start_date = $this->validate_invoice_date($account_value);
-                            if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
-                                $start_date = gmdate("Y-m-d H:i:s");
-                            }
-                            $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 month"));
-                            $this->Generate_Monthly_invoice($account_value, $start_date, $end_date);
-                        }
-                        break;
-                }
-            }
-            $screen_path = getcwd() . "/cron";
-            $screen_filename = "Email_Broadcast_" . strtotime('now');
-            $command = "cd " . $screen_path . " && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
-            exec($command);
-        }
-    }
+	function getInvoiceData() {
+		$where = array("posttoexternal" => 1, "deleted" => "0", "status" => "0");
+		$query = $this->db_model->getSelect("*", "accounts", $where);
+		if ($query->num_rows > 0) {
+			$account_data = $query->result_array();
+			foreach ($account_data as $data_key => $account_value) {
+				$end_date = gmdate("Y-m-d") . " 23:59:59";
+				$account_value['sweep_id'] = (int) $account_value['sweep_id'];
+				switch ($account_value['sweep_id']) {
+					case 0:
+						$start_date = $this->validate_invoice_date($account_value);
+						if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
+							$start_date = gmdate("Y-m-d H:i:s");
+						}
+						$end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 days"));
+						$this->Generate_Daily_invoice($account_value, $start_date, $end_date);
+						break;
+					case 2:
+						if (date("d") == $account_value['invoice_day']) {
+							$start_date = $this->validate_invoice_date($account_value);
+							if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
+								$start_date = gmdate("Y-m-d H:i:s");
+							}
+							$end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 month"));
+							$this->Generate_Monthly_invoice($account_value, $start_date, $end_date);
+						}
+						break;
+				}
+			}
+			$screen_path = getcwd() . "/cron";
+			$screen_filename = "Email_Broadcast_" . strtotime('now');
+			$command = "cd " . $screen_path . " && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
+			exec($command);
+		}
+	}
 
-    function validate_invoice_date($account_value) {
-        $last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"],$account_value['reseller_id'],"to_date");
-        $last_invoice_date = ($last_invoice_date) ? $last_invoice_date : $account_value['creation'];
-        $last_invoice_date = gmdate("Y-m-d H:i:s",strtotime("+1 Second",strtotime($last_invoice_date)));
-        return $last_invoice_date;
-    }
+	function validate_invoice_date($account_value) {
+		$last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"],$account_value['reseller_id'],"to_date");
+		$last_invoice_date = ($last_invoice_date) ? $last_invoice_date : $account_value['creation'];
+		$last_invoice_date = gmdate("Y-m-d H:i:s",strtotime("+1 Second",strtotime($last_invoice_date)));
+		return $last_invoice_date;
+	}
 
-    function Generate_Daily_invoice($account_value, $start_date, $end_date) {
-        //  echo "INVOICE SCRIPT-------start date :".$start_date."-------end date....".$end_date;
+	function Generate_Daily_invoice($account_value, $start_date, $end_date) {
+		//  echo "INVOICE SCRIPT-------start date :".$start_date."-------end date....".$end_date;
 
-        require_once('updateBalance.php');
-        $updateBalance = new updateBalance();
-        $updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
-        $updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE);
-        $this->process_invoice($account_value, $start_date, $end_date);
-    }
+		require_once('updateBalance.php');
+		$updateBalance = new updateBalance();
+		$updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
+		$updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE);
+		$this->process_invoice($account_value, $start_date, $end_date);
+	}
 
-    function Generate_Monthly_invoice($account_value, $start_date, $end_date) {
-        require_once('updateBalance.php');
-        $updateBalance = new updateBalance();
-        $updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
-        $updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE); 
-        $this->process_invoice($account_value, $start_date, $end_date);
-    }
+	function Generate_Monthly_invoice($account_value, $start_date, $end_date) {
+		require_once('updateBalance.php');
+		$updateBalance = new updateBalance();
+		$updateBalance->process_subscriptions($account_value, $start_date, $end_date, TRUE);
+		$updateBalance->process_DID_charges($account_value, $start_date, $end_date, TRUE); 
+		$this->process_invoice($account_value, $start_date, $end_date);
+	}
 
-    function process_invoice($accountdata, $start_date, $end_date) {
-        //Get Invoice configuration using single query instead of multiple queries.
-        $invoice_conf = array();
-        $reseller_id = ($accountdata['reseller_id'] == 0) ? 1 : $accountdata['reseller_id'];
-        $where = "accountid IN ('" . $reseller_id . "','1')";
-        $this->db->select('*');
-        $this->db->where($where);
-        $this->db->order_by('accountid', 'desc');
-        $this->db->limit(1);
-        $invoice_conf = $this->db->get('invoice_conf');
-        $invoice_conf = (array)$invoice_conf->first_row();
-        /*******************************************************/
-        $last_invoice_ID = $this->common->get_invoice_date("invoiceid","", $accountdata['reseller_id']);
-        if ($last_invoice_ID && $last_invoice_ID > 0) {
-            $last_invoice_ID = ($last_invoice_ID + 1);
-        } else {
-            $last_invoice_ID = $invoice_conf['invoice_start_from'];
-        }
-        $last_invoice_ID = str_pad($last_invoice_ID, (strlen($last_invoice_ID) + 4), '0', STR_PAD_LEFT);
-        $invoice_sub_total = $this->count_invoice_data($accountdata, $start_date, $end_date);
-        if ($invoice_sub_total > 0) {
-            $invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
-            $this->update_cdrs_data($accountdata['id'], $invoiceid, $start_date, $end_date);
-            $sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
-            $invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
-            $this->download_invoice($invoiceid, $accountdata, $invoice_conf);
-        } else {
-            $invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
-            $sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
-            $invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
-        }
-    }
+	function process_invoice($accountdata, $start_date, $end_date) {
+		//Get Invoice configuration using single query instead of multiple queries.
+		$invoice_conf = array();
+		$reseller_id = ($accountdata['reseller_id'] == 0) ? 1 : $accountdata['reseller_id'];
+		$where = "accountid IN ('" . $reseller_id . "','1')";
+		$this->db->select('*');
+		$this->db->where($where);
+		$this->db->order_by('accountid', 'desc');
+		$this->db->limit(1);
+		$invoice_conf = $this->db->get('invoice_conf');
+		$invoice_conf = (array)$invoice_conf->first_row();
+		/*******************************************************/
+		$last_invoice_ID = $this->common->get_invoice_date("invoiceid","", $accountdata['reseller_id']);
+		if ($last_invoice_ID && $last_invoice_ID > 0) {
+			$last_invoice_ID = ($last_invoice_ID + 1);
+		} else {
+			$last_invoice_ID = $invoice_conf['invoice_start_from'];
+		}
+		$last_invoice_ID = str_pad($last_invoice_ID, (strlen($last_invoice_ID) + 4), '0', STR_PAD_LEFT);
+		$invoice_sub_total = $this->count_invoice_data($accountdata, $start_date, $end_date);
+		if ($invoice_sub_total > 0) {
+			$invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
+			$this->update_cdrs_data($accountdata['id'], $invoiceid, $start_date, $end_date);
+			$sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
+			$invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
+			$this->download_invoice($invoiceid, $accountdata, $invoice_conf);
+		} else {
+			$invoiceid = $this->create_invoice($accountdata, $start_date, $end_date, $last_invoice_ID, $invoice_conf['invoice_prefix'], $invoice_conf);
+			$sort_order = $this->common_model->apply_invoice_taxes($invoiceid, $accountdata, $start_date);
+			$invoice_total = $this->set_invoice_total($invoiceid, $accountdata['id']);
+		}
+	}
 
-    function count_invoice_data($account, $start_date = "", $end_date = "") {
-        $cdr_query = "";
-        $inv_data_query = "";
-        $cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = " . $account['id'];
-        $cdr_query .= " AND callstart >='" . $start_date . "' AND callstart <= '" . $end_date . "' AND invoiceid=0 group by calltype";
+	function count_invoice_data($account, $start_date = "", $end_date = "") {
+		$cdr_query = "";
+		$inv_data_query = "";
+		$cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = " . $account['id'];
+		$cdr_query .= " AND callstart >='" . $start_date . "' AND callstart <= '" . $end_date . "' AND invoiceid=0 group by calltype";
 //echo $cdr_query; 
-        $cdr_data = $this->db->query($cdr_query);
-        if ($cdr_data->num_rows > 0) {
-            $cdr_data = $cdr_data->result_array();
-            //echo '<pre>'; print_r($cdr_data); exit;
-            foreach ($cdr_data as $cdrvalue) {
-                $cdrvalue['debit'] = round($cdrvalue['debit'], self::$global_config['system_config']['decimalpoints']);
-                $tempArr = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "item_id" => "0",
-                    "description" => $cdrvalue['calltype'] . " CALLS for the period (" . $start_date . " to " . $end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
-                $this->db->insert("invoice_details", $tempArr);
-            }
-        }
-        $inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=" . $account['id'] . " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type != 'FREECALL'";
+		$cdr_data = $this->db->query($cdr_query);
+		if ($cdr_data->num_rows > 0) {
+			$cdr_data = $cdr_data->result_array();
+			//echo '<pre>'; print_r($cdr_data); exit;
+			foreach ($cdr_data as $cdrvalue) {
+				$cdrvalue['debit'] = round($cdrvalue['debit'], self::$global_config['system_config']['decimalpoints']);
+				$tempArr = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "item_id" => "0",
+					"description" => $cdrvalue['calltype'] . " CALLS for the period (" . $start_date . " to " . $end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
+				$this->db->insert("invoice_details", $tempArr);
+			}
+		}
+		$inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=" . $account['id'] . " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type != 'FREECALL'";
 //echo $inv_data_query;         
-        $invoice_data = $this->db->query($inv_data_query);
-        if ($invoice_data->num_rows > 0) {
-            $invoice_data = $invoice_data->result_array();
-            foreach ($invoice_data as $data_value) {
-                if ($data_value['count'] > 0) {
-                    $sub_total = ($data_value['debit'] - $data_value['credit']);
-                    $sub_total = round($sub_total, self::$global_config['system_config']['decimalpoints']);
-                    return $sub_total;
-                }
-            }
-        }
-        return "0";
-    }
+		$invoice_data = $this->db->query($inv_data_query);
+		if ($invoice_data->num_rows > 0) {
+			$invoice_data = $invoice_data->result_array();
+			foreach ($invoice_data as $data_value) {
+				if ($data_value['count'] > 0) {
+					$sub_total = ($data_value['debit'] - $data_value['credit']);
+					$sub_total = round($sub_total, self::$global_config['system_config']['decimalpoints']);
+					return $sub_total;
+				}
+			}
+		}
+		return "0";
+	}
 
-    //Change Order of arguements
-    function update_cdrs_data($accountid, $invoiceid, $start_date = "", $end_date = "") {
-        $inv_data_query = "update invoice_details SET invoiceid = '" . $invoiceid . "' where accountid=" . $accountid;
-        $inv_data_query .= " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type !='PAYMENT'";
-        $this->db->query($inv_data_query);
-        return true;
-    }
+	//Change Order of arguements
+	function update_cdrs_data($accountid, $invoiceid, $start_date = "", $end_date = "") {
+		$inv_data_query = "update invoice_details SET invoiceid = '" . $invoiceid . "' where accountid=" . $accountid;
+		$inv_data_query .= " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type !='PAYMENT'";
+		$this->db->query($inv_data_query);
+		return true;
+	}
 
-    function create_invoice($account, $from_date, $to_date, $last_invoice_ID, $INVprefix, $invoiceconf) {
-        //$due_date = gmdate("Y-m-d H:i:s",strtotime($to_date." +".$invoiceconf['interval']." days"));
-        if ($invoiceconf['interval'] > 0) {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoiceconf['interval'] . " days"));
-        } else {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +7 days"));
-        }
-        // echo "due daye-------".$due_date.'----------'.$to_date.'------------> Invoice interval'.$invoiceconf['interval']; 
-        $balance = ($account['credit_limit'] - $account['balance']);
-        $automatic_flag = self::$global_config['system_config']['automatic_invoice'];
+	function create_invoice($account, $from_date, $to_date, $last_invoice_ID, $INVprefix, $invoiceconf) {
+		//$due_date = gmdate("Y-m-d H:i:s",strtotime($to_date." +".$invoiceconf['interval']." days"));
+		if ($invoiceconf['interval'] > 0) {
+			$due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoiceconf['interval'] . " days"));
+		} else {
+			$due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +7 days"));
+		}
+		// echo "due daye-------".$due_date.'----------'.$to_date.'------------> Invoice interval'.$invoiceconf['interval']; 
+		$balance = ($account['credit_limit'] - $account['balance']);
+		$automatic_flag = self::$global_config['system_config']['automatic_invoice'];
 	if($automatic_flag == 1){
-	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
-            $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance);
+			$invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
+			$account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance);
 	}else{
-	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
-            $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance, "confirm" => 1);
+			$invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
+			$account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance, "confirm" => 1);
 	}
-        // echo "<pre>"; print_r($invoice_data); exit;
-        $this->db->insert("invoices", $invoice_data);
-        $invoiceid = $this->db->insert_id();
+		// echo "<pre>"; print_r($invoice_data); exit;
+		$this->db->insert("invoices", $invoice_data);
+		$invoiceid = $this->db->insert_id();
 	if($automatic_flag == 0){
-            $this->download_invoice($invoiceid, $account, $invoiceconf);
+			$this->download_invoice($invoiceid, $account, $invoiceconf);
+	}
+		return $invoiceid;
 	}
-        return $invoiceid;
-    }
 
-    function set_invoice_total($invoiceid, $accountid) {
-        $query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid, "item_type <>" => "FREECALL"));
-        $query = $query->result_array();
-        $sub_total = $query["0"]["total"];
-        $updateArr = array("amount" => $sub_total);
-        $this->db->where(array("id" => $invoiceid));
-        $this->db->update("invoices", $updateArr);
+	function set_invoice_total($invoiceid, $accountid) {
+		$query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid, "item_type <>" => "FREECALL"));
+		$query = $query->result_array();
+		$sub_total = $query["0"]["total"];
+		$updateArr = array("amount" => $sub_total);
+		$this->db->where(array("id" => $invoiceid));
+		$this->db->update("invoices", $updateArr);
 
-        $updateArr = array("balance" => "0.00");
-        $this->db->where(array("id" => $accountid));
-        $this->db->update("accounts", $updateArr);
+		$updateArr = array("balance" => "0.00");
+		$this->db->where(array("id" => $accountid));
+		$this->db->update("accounts", $updateArr);
 
-        return true;
-    }
+		return true;
+	}
 
-    function download_invoice($invoiceid, $accountdata, $invoice_conf) {
-        $invoicedata = $this->db_model->getSelect("*", "invoices", array("id" => $invoiceid));
-        $invoicedata = $invoicedata->result_array();
-        $invoicedata = $invoicedata[0];
-        $FilePath = FCPATH . "invoices/" . $accountdata["id"] . '/' . $invoicedata['invoice_prefix']."".$invoicedata['invoiceid'] . "_invoice.pdf";
-        $Filenm = $invoicedata['invoice_prefix'] ."_". $invoicedata['invoiceid'] . "_invoice.pdf";
-        $this->common->get_invoice_template($invoicedata, $accountdata, false);
-        if ($invoice_conf['invoice_notification']) {
-            $this->send_email_notification($FilePath, $Filenm, $accountdata, $invoice_conf, $invoicedata);
-        }
-    }
+	function download_invoice($invoiceid, $accountdata, $invoice_conf) {
+		$invoicedata = $this->db_model->getSelect("*", "invoices", array("id" => $invoiceid));
+		$invoicedata = $invoicedata->result_array();
+		$invoicedata = $invoicedata[0];
+		$FilePath = FCPATH . "invoices/" . $accountdata["id"] . '/' . $invoicedata['invoice_prefix']."".$invoicedata['invoiceid'] . "_invoice.pdf";
+		$Filenm = $invoicedata['invoice_prefix'] ."_". $invoicedata['invoiceid'] . "_invoice.pdf";
+		$this->common->get_invoice_template($invoicedata, $accountdata, false);
+		if ($invoice_conf['invoice_notification']) {
+			$this->send_email_notification($FilePath, $Filenm, $accountdata, $invoice_conf, $invoicedata);
+		}
+	}
 
-    function send_email_notification($FilePath, $Filenm, $AccountData, $invoice_conf, $invData) {
-        $TemplateData = array();
-        $where = array('name' => 'email_new_invoice');
-        $EmailTemplate = $this->db_model->getSelect("*", "default_templates", $where);
-        foreach ($EmailTemplate->result_array() as $TemplateVal) {
-            $TemplateData = $TemplateVal;
-            $TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['subject']);
-            $TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['subject']);
-            $TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace('#AMOUNT#', $invData['amount'], $TemplateData['template']);
+	function send_email_notification($FilePath, $Filenm, $AccountData, $invoice_conf, $invData) {
+		$TemplateData = array();
+		$where = array('name' => 'email_new_invoice');
+		$EmailTemplate = $this->db_model->getSelect("*", "default_templates", $where);
+		foreach ($EmailTemplate->result_array() as $TemplateVal) {
+			$TemplateData = $TemplateVal;
+			$TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['subject']);
+			$TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['subject']);
+			$TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace('#AMOUNT#', $invData['amount'], $TemplateData['template']);
 
-            $TemplateData['template'] = str_replace("#COMPANY_EMAIL#", $invoice_conf['emailaddress'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#COMPANY_NAME#", $invoice_conf['company_name'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#COMPANY_WEBSITE#", $invoice_conf['website'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#INVOICE_DATE#",$invData['invoice_date'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#DUE_DATE#", $invData['due_date'], $TemplateData['template']);
-        }
-        $dir_path = getcwd() . "/attachments/";
-        $path = $dir_path . $Filenm;
-        $command = "cp " . $FilePath . " " . $path;
-        exec($command);
-        $email_array = array('accountid' => $AccountData['id'],
-            'subject' => $TemplateData['subject'],
-            'body' => $TemplateData['template'],
-            'from' => $invoice_conf['emailaddress'],
-            'to' => $AccountData['email'],
-            'status' => "1",
-            'attachment' => $Filenm,
-            'template' => '');
-        //echo "<pre>"; print_r($TemplateData); exit;
-        $this->db->insert("mail_details", $email_array);
-    }
+			$TemplateData['template'] = str_replace("#COMPANY_EMAIL#", $invoice_conf['emailaddress'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#COMPANY_NAME#", $invoice_conf['company_name'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#COMPANY_WEBSITE#", $invoice_conf['website'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#INVOICE_DATE#",$invData['invoice_date'], $TemplateData['template']);
+			$TemplateData['template'] = str_replace("#DUE_DATE#", $invData['due_date'], $TemplateData['template']);
+		}
+		$dir_path = getcwd() . "/attachments/";
+		$path = $dir_path . $Filenm;
+		$command = "cp " . $FilePath . " " . $path;
+		exec($command);
+		$email_array = array('accountid' => $AccountData['id'],
+			'subject' => $TemplateData['subject'],
+			'body' => $TemplateData['template'],
+			'from' => $invoice_conf['emailaddress'],
+			'to' => $AccountData['email'],
+			'status' => "1",
+			'attachment' => $Filenm,
+			'template' => '');
+		//echo "<pre>"; print_r($TemplateData); exit;
+		$this->db->insert("mail_details", $email_array);
+	}
 
 }
 

web_interface/astpp/application/controllers/lowcreditlimit.php

Indentation +18 added lines, -18 removed lines

@@ -22,27 +22,27 @@
 ###############################################################################
 
 class Lowcreditlimit extends CI_Controller {
-    function __construct()
-    {
+	function __construct()
+	{
 	parent::__construct();
 	if(!defined( 'CRON' ) )  
 	  exit();
-        $this->load->model("db_model");
-        $this->load->library("astpp/common");
-    }
-    function low_creditlimit(){
-        $where = array("posttoexternal"=>1,"deleted" => "0","status"=>"0");
-        $query = $this->db_model->getSelect("*", "accounts", $where);
-        if($query->num_rows >0){
-            $account_data = $query->result_array();
-            foreach($account_data as $data_key =>$account_value){
-                if(($account_value["balance"]) >= $account_value["credit_limit"]){
-                  $this->common->mail_to_users("email_low_balance",$account_value);   
-                }
-            }
-        }
-        exit;
-    }
+		$this->load->model("db_model");
+		$this->load->library("astpp/common");
+	}
+	function low_creditlimit(){
+		$where = array("posttoexternal"=>1,"deleted" => "0","status"=>"0");
+		$query = $this->db_model->getSelect("*", "accounts", $where);
+		if($query->num_rows >0){
+			$account_data = $query->result_array();
+			foreach($account_data as $data_key =>$account_value){
+				if(($account_value["balance"]) >= $account_value["credit_limit"]){
+				  $this->common->mail_to_users("email_low_balance",$account_value);   
+				}
+			}
+		}
+		exit;
+	}
 } 
 ?>
  

web_interface/astpp/application/controllers/currencyupdate.php

Indentation +48 added lines, -48 removed lines

@@ -21,60 +21,60 @@
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
 class Currencyupdate extends CI_Controller {
-    function __construct()
-    {
-        parent::__construct();
-     //   if(!defined( 'CRON' ) )
-       //   exit();
-        $this->load->model("db_model");
-        $this->load->library("astpp/common");
-    }
-    function update_currency(){
-        $where = array("currency <>"=> Common_model::$global_config['system_config']['base_currency']);
-        $query = $this->db_model->getSelect("*", "currency", $where);
+	function __construct()
+	{
+		parent::__construct();
+	 //   if(!defined( 'CRON' ) )
+	   //   exit();
+		$this->load->model("db_model");
+		$this->load->library("astpp/common");
+	}
+	function update_currency(){
+		$where = array("currency <>"=> Common_model::$global_config['system_config']['base_currency']);
+		$query = $this->db_model->getSelect("*", "currency", $where);
 
-        if($query->num_rows >0){
-            $currency_data =$query->result_array();
-    		$url = "http://finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s=";
-	    	foreach ($currency_data as $currency_value) {
-	    	    $url .= Common_model::$global_config['system_config']['base_currency'].$currency_value['currency'].'=X+';
-	    	}
-	    	$url .= '&f=l1';
+		if($query->num_rows >0){
+			$currency_data =$query->result_array();
+			$url = "http://finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s=";
+			foreach ($currency_data as $currency_value) {
+				$url .= Common_model::$global_config['system_config']['base_currency'].$currency_value['currency'].'=X+';
+			}
+			$url .= '&f=l1';
 
-	    	$sql='';
-	    	$response = $this->curl_response($url);
-	    	$content_data = explode(' ',$response);
+			$sql='';
+			$response = $this->curl_response($url);
+			$content_data = explode(' ',$response);
 
-	    	foreach ($content_data as $content_data1){
-	    	   $currency_arr= explode("\n", $content_data1);
-	    	    foreach($currency_arr as $final_val)
-	    	    {
-	    	        $currency_final = array();
-	    		    $currency_final= explode(',', $final_val);
-	    		    if(isset($currency_final[1]) && $currency_final[1] != "" && $currency_final[0]!='' && $currency_final[1] != 'N/A'){
-			      $sql = "UPDATE currency SET currencyRate = ".$currency_final[1]." WHERE currency = '".substr($currency_final[0],4,3)."'";
-			      $this->db->query($sql);
-	    		    }
-	    	    }
-	    	}
-	    	$sql = "UPDATE currency SET currencyRate = '1' WHERE currency = '".Common_model::$global_config['system_config']['base_currency']."'";
-                $this->db->query($sql);
-      }
-	      $this->session->set_flashdata("astpp_errormsg", "Currency exchange rates successfully updated.");
-	      redirect(base_url()."/systems/currency_list/");
-	      exit;
+			foreach ($content_data as $content_data1){
+			   $currency_arr= explode("\n", $content_data1);
+				foreach($currency_arr as $final_val)
+				{
+					$currency_final = array();
+					$currency_final= explode(',', $final_val);
+					if(isset($currency_final[1]) && $currency_final[1] != "" && $currency_final[0]!='' && $currency_final[1] != 'N/A'){
+				  $sql = "UPDATE currency SET currencyRate = ".$currency_final[1]." WHERE currency = '".substr($currency_final[0],4,3)."'";
+				  $this->db->query($sql);
+					}
+				}
+			}
+			$sql = "UPDATE currency SET currencyRate = '1' WHERE currency = '".Common_model::$global_config['system_config']['base_currency']."'";
+				$this->db->query($sql);
+	  }
+		  $this->session->set_flashdata("astpp_errormsg", "Currency exchange rates successfully updated.");
+		  redirect(base_url()."/systems/currency_list/");
+		  exit;
 	}
 	function curl_response($url)
 	{
-		    $ch = curl_init();  // Initialising cURL
-		    curl_setopt ( $ch, CURLOPT_URL, $url );
-		    curl_setopt ( $ch, CURLOPT_FOLLOWLOCATION, 1 );
-		    curl_setopt ( $ch, CURLOPT_RETURNTRANSFER, 1 );
-		    curl_setopt ( $ch, CURLOPT_ENCODING, "" );
-		    curl_setopt ( $ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)" );
-		    $data = curl_exec($ch); // Executing the cURL request and assigning the returned data to the $data variable
-		    curl_close($ch);        // Closing cURL
-		    return $data;
+			$ch = curl_init();  // Initialising cURL
+			curl_setopt ( $ch, CURLOPT_URL, $url );
+			curl_setopt ( $ch, CURLOPT_FOLLOWLOCATION, 1 );
+			curl_setopt ( $ch, CURLOPT_RETURNTRANSFER, 1 );
+			curl_setopt ( $ch, CURLOPT_ENCODING, "" );
+			curl_setopt ( $ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)" );
+			$data = curl_exec($ch); // Executing the cURL request and assigning the returned data to the $data variable
+			curl_close($ch);        // Closing cURL
+			return $data;
 	}
 }
 ?>

web_interface/astpp/application/controllers/lowbalance.php

Indentation +18 added lines, -18 removed lines

@@ -22,26 +22,26 @@
 ###############################################################################
 
 class Lowbalance extends CI_Controller {
-    function __construct()
-    {
+	function __construct()
+	{
 	parent::__construct();
 	if(!defined( 'CRON' ) )  
 	  exit();
-        $this->load->model("db_model");
-        $this->load->library("astpp/common");
-    }
-    function low_balance(){
-        $where = array("posttoexternal"=>0,"notify_flag"=>0,"deleted" => "0","status"=>"0");
-        $query = $this->db_model->getSelect("*", "accounts", $where);
-        if($query->num_rows >0){
-            $account_data = $query->result_array();
-            foreach($account_data as $data_key =>$accountinfo){
-                if(($accountinfo["balance"]) <= $accountinfo["notify_credit_limit"]){
-                  $this->common->mail_to_users("email_low_balance",$accountinfo);   
-                }
-            }
-        }
-        exit;
-    }
+		$this->load->model("db_model");
+		$this->load->library("astpp/common");
+	}
+	function low_balance(){
+		$where = array("posttoexternal"=>0,"notify_flag"=>0,"deleted" => "0","status"=>"0");
+		$query = $this->db_model->getSelect("*", "accounts", $where);
+		if($query->num_rows >0){
+			$account_data = $query->result_array();
+			foreach($account_data as $data_key =>$accountinfo){
+				if(($accountinfo["balance"]) <= $accountinfo["notify_credit_limit"]){
+				  $this->common->mail_to_users("email_low_balance",$accountinfo);   
+				}
+			}
+		}
+		exit;
+	}
 } 
 ?>

web_interface/astpp/application/libraries/Timezone.php

Indentation +41 added lines, -41 removed lines

@@ -29,64 +29,64 @@
   }
 
   function uset_timezone(){
-	    $account_data = $this->CI->session->userdata('accountinfo');
-	    return $account_data['timezone_id'] ;
+		$account_data = $this->CI->session->userdata('accountinfo');
+		return $account_data['timezone_id'] ;
   }
   function display_GMT($currDate,$fulldate = 1)
   {	
-      $number = $this->uset_timezone();
-      $SERVER_GMT='0';
+	  $number = $this->uset_timezone();
+	  $SERVER_GMT='0';
 
-      $result=$this->CI->db->query("select gmtoffset from timezone where id =".$number);
-      $timezone_offset = $result->result();
+	  $result=$this->CI->db->query("select gmtoffset from timezone where id =".$number);
+	  $timezone_offset = $result->result();
 
-      $USER_GMT = $timezone_offset['0']->gmtoffset;
+	  $USER_GMT = $timezone_offset['0']->gmtoffset;
 
-      $date_time_array = getdate(strtotime($currDate));
+	  $date_time_array = getdate(strtotime($currDate));
       
-      $hours = $date_time_array['hours'];
-      $minutes = $date_time_array['minutes'];
-      $seconds = $date_time_array['seconds'];
-      $month = $date_time_array['mon'];
-      $day = $date_time_array['mday'];
-      $year = $date_time_array['year'];
-      $timestamp = mktime($hours, $minutes, $seconds, $month, $day, $year);
+	  $hours = $date_time_array['hours'];
+	  $minutes = $date_time_array['minutes'];
+	  $seconds = $date_time_array['seconds'];
+	  $month = $date_time_array['mon'];
+	  $day = $date_time_array['mday'];
+	  $year = $date_time_array['year'];
+	  $timestamp = mktime($hours, $minutes, $seconds, $month, $day, $year);
 
-      $timestamp = $timestamp+($USER_GMT-$SERVER_GMT);
-      if ($fulldate == 1) {
+	  $timestamp = $timestamp+($USER_GMT-$SERVER_GMT);
+	  if ($fulldate == 1) {
 		$date = date("Y-m-d H:i:s", $timestamp);
-      } else {
-	      $date = date("Y-m-d", $timestamp);
-      }
+	  } else {
+		  $date = date("Y-m-d", $timestamp);
+	  }
       
-      return $date;
+	  return $date;
   }
 
   function convert_to_GMT($currDate,$fulldate = 1){
-      $number = $this->uset_timezone();
-      $SERVER_GMT='0';
+	  $number = $this->uset_timezone();
+	  $SERVER_GMT='0';
 
-      $result=$this->CI->db->query("select gmtoffset from timezone where id =".$number);
-      $timezone_offset = $result->result();
+	  $result=$this->CI->db->query("select gmtoffset from timezone where id =".$number);
+	  $timezone_offset = $result->result();
 
-      $USER_GMT = $timezone_offset['0']->gmtoffset;
+	  $USER_GMT = $timezone_offset['0']->gmtoffset;
 
-      $date_time_array = getdate(strtotime($currDate));
-      $hours = $date_time_array['hours'];
-      $minutes = $date_time_array['minutes'];
-      $seconds = $date_time_array['seconds'];
-      $month = $date_time_array['mon'];
-      $day = $date_time_array['mday'];
-      $year = $date_time_array['year'];
-      $timestamp = mktime($hours, $minutes, $seconds, $month, $day, $year);
+	  $date_time_array = getdate(strtotime($currDate));
+	  $hours = $date_time_array['hours'];
+	  $minutes = $date_time_array['minutes'];
+	  $seconds = $date_time_array['seconds'];
+	  $month = $date_time_array['mon'];
+	  $day = $date_time_array['mday'];
+	  $year = $date_time_array['year'];
+	  $timestamp = mktime($hours, $minutes, $seconds, $month, $day, $year);
 
-      $timestamp = $timestamp - ($SERVER_GMT - $USER_GMT);
-      if ($fulldate == 1) {
-	      $date = date("Y-m-d H:i:s", $timestamp);
-      } else {
-	      $date = date("Y-m-d", $timestamp);
-      }
-      return $date;
+	  $timestamp = $timestamp - ($SERVER_GMT - $USER_GMT);
+	  if ($fulldate == 1) {
+		  $date = date("Y-m-d H:i:s", $timestamp);
+	  } else {
+		  $date = date("Y-m-d", $timestamp);
+	  }
+	  return $date;
   }
 }
 ?>

web_interface/astpp/application/libraries/csvreader.php

Indentation +72 added lines, -72 removed lines

@@ -12,96 +12,96 @@
 */
 class CSVReader {
 
-    var $fields;        /** columns names retrieved after parsing */
-    var $separator = ',';    /** separator used to explode each line */
+	var $fields;        /** columns names retrieved after parsing */
+	var $separator = ',';    /** separator used to explode each line */
 
-    /**
-     * Parse a text containing CSV formatted data.
-     *
-     * @access    public
-     * @param    string
-     * @return    array
-     */
-    function parse_text($p_Text) {
-        $lines = explode("\n", $p_Text);
-        return $this->parse_lines($lines);
-    }
+	/**
+	 * Parse a text containing CSV formatted data.
+	 *
+	 * @access    public
+	 * @param    string
+	 * @return    array
+	 */
+	function parse_text($p_Text) {
+		$lines = explode("\n", $p_Text);
+		return $this->parse_lines($lines);
+	}
 
-    /**
-     * Parse a file containing CSV formatted data.
-     *
-     * @access    public
-     * @param    string
-     * @return    array
-     */
-    function parse_file($p_Filepath,$config_variable,$check_header_flag=false) {
-        $lines = file($p_Filepath);
-        //Giving line numbers
-        for($i=0;$i<sizeof($lines);$i++)
-        {
+	/**
+	 * Parse a file containing CSV formatted data.
+	 *
+	 * @access    public
+	 * @param    string
+	 * @return    array
+	 */
+	function parse_file($p_Filepath,$config_variable,$check_header_flag=false) {
+		$lines = file($p_Filepath);
+		//Giving line numbers
+		for($i=0;$i<sizeof($lines);$i++)
+		{
         
-            if(trim($lines[$i]) != "")
-            {
-                $columnname = explode($this->separator, $lines[$i]);
-                for($i=0;$i<sizeof($columnname);$i++)
-                {
-                    $columnname[$i]=$columnname[$i];
-                }
-                 break;                    
-            }
-        }
+			if(trim($lines[$i]) != "")
+			{
+				$columnname = explode($this->separator, $lines[$i]);
+				for($i=0;$i<sizeof($columnname);$i++)
+				{
+					$columnname[$i]=$columnname[$i];
+				}
+				 break;                    
+			}
+		}
 	return $this->parse_lines($lines,$config_variable,$check_header_flag);
-    }
-    /**
-     * Parse an array of text lines containing CSV formatted data.
-     *
-     * @access    public
-     * @param    array
-     * @return    array
-     */
-    function parse_lines($p_CSVLines,$config_variable,$check_header_flag=false) {
+	}
+	/**
+	 * Parse an array of text lines containing CSV formatted data.
+	 *
+	 * @access    public
+	 * @param    array
+	 * @return    array
+	 */
+	function parse_lines($p_CSVLines,$config_variable,$check_header_flag=false) {
 //     echo "<pre>";
-         $t=0;    
-         $content=array();
-         $custom_array=array();
-         $i=0;
-         $flag_data=false;
-         $data_arr[0]=$config_variable;
-         $field_name_arr=array_keys($config_variable);
+		 $t=0;    
+		 $content=array();
+		 $custom_array=array();
+		 $i=0;
+		 $flag_data=false;
+		 $data_arr[0]=$config_variable;
+		 $field_name_arr=array_keys($config_variable);
 	foreach( $p_CSVLines as $line_num => $line )
-        {
+		{
 	  $line=trim($line);
-          if(!empty($line)){
-          // skip empty lines
-	      $elements = explode($this->separator, $line);
+		  if(!empty($line)){
+		  // skip empty lines
+		  $elements = explode($this->separator, $line);
 	      
-	      if(array_filter($elements,'trim')) {
+		  if(array_filter($elements,'trim')) {
 		$custom_array[]=$elements;
-	      }
-	      $i++;
+		  }
+		  $i++;
 	   }
-        }
+		}
         
-        if($check_header_flag == 'on'){
-         unset($custom_array[0]);
-        }
+		if($check_header_flag == 'on'){
+		 unset($custom_array[0]);
+		}
 	 foreach($custom_array as $data){
 	  $j=0;
 	  foreach($data as $key=>$value){
-	    $value=str_replace('"', '', $value);
-	    $value=str_replace("'", '', $value);
-	    if(isset($field_name_arr[$j])){
-	        $field_key_value =$config_variable[$field_name_arr[$j]];
+		$value=str_replace('"', '', $value);
+		$value=str_replace("'", '', $value);
+		if(isset($field_name_arr[$j])){
+			$field_key_value =$config_variable[$field_name_arr[$j]];
 		$value= strip_slashes(trim($value));
-                $value = preg_replace('#<script.*</script>#is', '', $value);
-                if(isset($field_key_value) && !empty($field_key_value))
+				$value = preg_replace('#<script.*</script>#is', '', $value);
+				if(isset($field_key_value) && !empty($field_key_value))
 		  $content[$field_key_value] =  strip_tags(filter_var($value, FILTER_SANITIZE_STRING));                  
 		$j++;
-	    }  
+		}  
 	  }
 	  $data_arr[]=$content;
-        }
-        return $data_arr;
-    }
+		}
+		return $data_arr;
+	}
 }
 ?>

web_interface/astpp/application/libraries/astpp/common.php

Indentation +1773 added lines, -1773 removed lines

@@ -23,453 +23,453 @@ 
 ###############################################################################
 
 if (!defined('BASEPATH'))
-    exit('No direct script access allowed');
+	exit('No direct script access allowed');
 
 /**
  * Dynamically build forms for display
  */
 class common {
 
-    protected $CI; // codeigniter
+	protected $CI; // codeigniter
 
-    function __construct($library_name = '') {
+	function __construct($library_name = '') {
 
-        $this->CI = & get_instance();
-        $this->CI->load->library("timezone");
-        $this->CI->load->model('db_model');
-        $this->CI->load->library('email');
-        $this->CI->load->library('session');
-    }
+		$this->CI = & get_instance();
+		$this->CI->load->library("timezone");
+		$this->CI->load->model('db_model');
+		$this->CI->load->library('email');
+		$this->CI->load->library('session');
+	}
 
 // __construct
-    /**
-     * adds raw html to the field array
-     * @param type $label
-     * @param type $field add
-     */
-    function generate_password() {
-        $pass = substr(md5(rand(0, 1000000000)), 0, common_model::$global_config['system_config']['pinlength']);
-        return $pass;
-    }
-
-    function find_uniq_rendno($size = '', $field = '', $tablename = '') {
-
-        if ($tablename != '') {
-            $accounttype_array = array();
-            $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-            $where = array($field => $uname);
-            $acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
-            $acc_result = $acc_result->result();
-            while ($acc_result[0]->count != 0) {
-                $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-                $acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
-            }
-        } else {
-            $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-        }
-        return $uname;
-    }
-
-    function find_uniq_rendno_customer($size = '', $field = '', $tablename = '') {
-        if ($tablename != '') {
-            $accounttype_array = array();
-            $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-            $where = array($field => $uname);
-            $acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
-            $acc_result = $acc_result->result();
-            while ($acc_result[0]->count != 0) {
-                $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-                $acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
-            }
-        } else {
-            $uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
-        }
-        $start_prifix_value = common_model::$global_config['system_config']['startingdigit'];
-        if ($tablename == 'accounts' && $start_prifix_value != 0) {
-            $length = strlen($start_prifix_value);
-            $uname = substr($uname, $length);
-            $uname = $start_prifix_value . $uname;
-        }
-        return $uname;
-    }
-
-    function random_string($length) {
-        $chars = "1234567890"; //length:36
-        $final_rand = '';
-        for ($i = 0; $i < $length; $i++) {
-            $final_rand .= $chars[rand(0, strlen($chars) - 1)];
-        }
-        return $final_rand;
-    }
-
-    function find_uniq_rendno_accno($length = '', $field = '', $tablename = '', $default, $creation_count) {
-        $number = array();
-        $j = 0;
-
-        $total_count = pow(10, $length);
-        for ($i = 1; $i <= $total_count; $i++) {
-
-            $flag = false;
-            $uname = $this->random_string($length);
-            $uname = strtolower($uname);
-            if (isset($default))
-                $uname = $default . $uname;
-            if (!in_array($uname, $number)) {
-                $where = array($field => $uname);
-                $acc_result = $this->CI->db_model->getSelect('Count(id) as count', $tablename, $where);
-                $acc_result = $acc_result->result_array();
-                if ($acc_result[0]['count'] == 0 && !in_array($uname, $number)) {
-                    $number[] = $uname;
-                    $j++;
-                }
-                if ($j == $creation_count) {
-                    break;
-                }
-            } else {
-                $total_count++;
-            }
-        }
-        return $number;
-    }
-
-    function get_field_count($select, $table, $where) {
+	/**
+	 * adds raw html to the field array
+	 * @param type $label
+	 * @param type $field add
+	 */
+	function generate_password() {
+		$pass = substr(md5(rand(0, 1000000000)), 0, common_model::$global_config['system_config']['pinlength']);
+		return $pass;
+	}
+
+	function find_uniq_rendno($size = '', $field = '', $tablename = '') {
+
+		if ($tablename != '') {
+			$accounttype_array = array();
+			$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+			$where = array($field => $uname);
+			$acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
+			$acc_result = $acc_result->result();
+			while ($acc_result[0]->count != 0) {
+				$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+				$acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
+			}
+		} else {
+			$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+		}
+		return $uname;
+	}
+
+	function find_uniq_rendno_customer($size = '', $field = '', $tablename = '') {
+		if ($tablename != '') {
+			$accounttype_array = array();
+			$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+			$where = array($field => $uname);
+			$acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
+			$acc_result = $acc_result->result();
+			while ($acc_result[0]->count != 0) {
+				$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+				$acc_result = $this->CI->db_model->getSelect('Count(*) as count', $tablename, $where);
+			}
+		} else {
+			$uname = rand(pow(10, $size - 1), pow(10, $size) - 1);
+		}
+		$start_prifix_value = common_model::$global_config['system_config']['startingdigit'];
+		if ($tablename == 'accounts' && $start_prifix_value != 0) {
+			$length = strlen($start_prifix_value);
+			$uname = substr($uname, $length);
+			$uname = $start_prifix_value . $uname;
+		}
+		return $uname;
+	}
+
+	function random_string($length) {
+		$chars = "1234567890"; //length:36
+		$final_rand = '';
+		for ($i = 0; $i < $length; $i++) {
+			$final_rand .= $chars[rand(0, strlen($chars) - 1)];
+		}
+		return $final_rand;
+	}
+
+	function find_uniq_rendno_accno($length = '', $field = '', $tablename = '', $default, $creation_count) {
+		$number = array();
+		$j = 0;
+
+		$total_count = pow(10, $length);
+		for ($i = 1; $i <= $total_count; $i++) {
+
+			$flag = false;
+			$uname = $this->random_string($length);
+			$uname = strtolower($uname);
+			if (isset($default))
+				$uname = $default . $uname;
+			if (!in_array($uname, $number)) {
+				$where = array($field => $uname);
+				$acc_result = $this->CI->db_model->getSelect('Count(id) as count', $tablename, $where);
+				$acc_result = $acc_result->result_array();
+				if ($acc_result[0]['count'] == 0 && !in_array($uname, $number)) {
+					$number[] = $uname;
+					$j++;
+				}
+				if ($j == $creation_count) {
+					break;
+				}
+			} else {
+				$total_count++;
+			}
+		}
+		return $number;
+	}
+
+	function get_field_count($select, $table, $where) {
 //        echo $select."=====".$table."===".$where;
-        if (is_array($where)) {
-            $where = $where;
-        } else {
-            $where = array($select => $where);
-        }
-        $field_name = $this->CI->db_model->countQuery($select, $table, $where);
-        if (isset($field_name) && !empty($field_name)) {
-            return $field_name;
-        } else {
-            return "0";
-        }
-    }
-
-    function get_field_name($select, $table, $where) {
-        if (is_array($where)) {
-            $where = $where;
-        } else {
-            $where = array("id" => $where);
-        }
-        $field_name = $this->CI->db_model->getSelect($select, $table, $where);
-        $field_name = $field_name->result();
-        if (isset($field_name) && !empty($field_name)) {
-            return $field_name[0]->$select;
-        } else {
-            return "";
-        }
-    }
-
-    function get_field_name_coma_new($select, $table, $where) {
-        $value = '';
-        if (is_array($where)) {
-            $where = $where;
-        } else {
-            $where = explode(',', $where);
-        }
-        $select1 = explode(',', $select);
-        for ($i = 0; $i < count($where); $i++) {
-            $where_in = array("id" => $where[$i]);
-
-            $field_name = $this->CI->db_model->getSelect($select, $table, $where_in);
-            $field_name = $field_name->result();
-            if (isset($field_name) && !empty($field_name)) {
-                foreach ($select1 as $sel) {
-                    if ($sel == 'number') {
-                        $value.="(" . $field_name[0]->$sel . ")";
-                    } else {
-                        $value.= $field_name[0]->$sel . " ";
-                    }
-                }
-            } else {
-                $value = "";
-            }
-        }
-        return rtrim($value, ',');
-    }
-
-    function check_did_avl($select, $table, $where) {
-        $accountinfo = $this->CI->session->userdata('accountinfo');
-        $flag_status = "";
-        $where = array("number" => $where);
-        $field_name = $this->CI->db_model->getSelect("id,accountid,parent_id", 'dids', $where);
-        $field_name = $field_name->result();
-        if (isset($field_name) && !empty($field_name)) {
-            if (isset($field_name[0]) && $accountinfo['type'] != 1) {
-                if ($field_name[0]->accountid != 0 && $field_name[0]->parent_id ==0) {
-                    $flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(C)<span></a>";
-                } else if ($field_name[0]->parent_id != 0) {
-                    $flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
-                } else {
-                    $flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
-                }
-            } else {
-                $reseller_id = $accountinfo['type'] != 1 ? 0 : $accountinfo['id'];
-                $where = array("note" => $field_name[0]->number, 'parent_id' => $reseller_id);
-                $field_name_re = $this->CI->db_model->getSelect("reseller_id", 'reseller_pricing', $where);
-                $field_name_re = $field_name_re->result();
-
-                if (isset($field_name_re) && !empty($field_name_re)) {
-                    $flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
-                } else {
-                    $flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
-                }
-            }
-        } else {
-            $flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
-        }
-        return $flag_status;
-    }
-    function check_did_avl_export($number){
-      $this->CI->db->where('number',$number);
-      $this->CI->db->select('id,accountid,parent_id');
-      $status=null;
-      $did_info=(array)$this->CI->db->get('dids')->first_row();
-      $accountinfo=$this->CI->session->userdata('accountinfo');
-      if($did_info['accountid'] ==0 && $did_info['parent_id']==0){
+		if (is_array($where)) {
+			$where = $where;
+		} else {
+			$where = array($select => $where);
+		}
+		$field_name = $this->CI->db_model->countQuery($select, $table, $where);
+		if (isset($field_name) && !empty($field_name)) {
+			return $field_name;
+		} else {
+			return "0";
+		}
+	}
+
+	function get_field_name($select, $table, $where) {
+		if (is_array($where)) {
+			$where = $where;
+		} else {
+			$where = array("id" => $where);
+		}
+		$field_name = $this->CI->db_model->getSelect($select, $table, $where);
+		$field_name = $field_name->result();
+		if (isset($field_name) && !empty($field_name)) {
+			return $field_name[0]->$select;
+		} else {
+			return "";
+		}
+	}
+
+	function get_field_name_coma_new($select, $table, $where) {
+		$value = '';
+		if (is_array($where)) {
+			$where = $where;
+		} else {
+			$where = explode(',', $where);
+		}
+		$select1 = explode(',', $select);
+		for ($i = 0; $i < count($where); $i++) {
+			$where_in = array("id" => $where[$i]);
+
+			$field_name = $this->CI->db_model->getSelect($select, $table, $where_in);
+			$field_name = $field_name->result();
+			if (isset($field_name) && !empty($field_name)) {
+				foreach ($select1 as $sel) {
+					if ($sel == 'number') {
+						$value.="(" . $field_name[0]->$sel . ")";
+					} else {
+						$value.= $field_name[0]->$sel . " ";
+					}
+				}
+			} else {
+				$value = "";
+			}
+		}
+		return rtrim($value, ',');
+	}
+
+	function check_did_avl($select, $table, $where) {
+		$accountinfo = $this->CI->session->userdata('accountinfo');
+		$flag_status = "";
+		$where = array("number" => $where);
+		$field_name = $this->CI->db_model->getSelect("id,accountid,parent_id", 'dids', $where);
+		$field_name = $field_name->result();
+		if (isset($field_name) && !empty($field_name)) {
+			if (isset($field_name[0]) && $accountinfo['type'] != 1) {
+				if ($field_name[0]->accountid != 0 && $field_name[0]->parent_id ==0) {
+					$flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(C)<span></a>";
+				} else if ($field_name[0]->parent_id != 0) {
+					$flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
+				} else {
+					$flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
+				}
+			} else {
+				$reseller_id = $accountinfo['type'] != 1 ? 0 : $accountinfo['id'];
+				$where = array("note" => $field_name[0]->number, 'parent_id' => $reseller_id);
+				$field_name_re = $this->CI->db_model->getSelect("reseller_id", 'reseller_pricing', $where);
+				$field_name_re = $field_name_re->result();
+
+				if (isset($field_name_re) && !empty($field_name_re)) {
+					$flag_status = "<a href='../did_list_release/" . $field_name[0]->id . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
+				} else {
+					$flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
+				}
+			}
+		} else {
+			$flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
+		}
+		return $flag_status;
+	}
+	function check_did_avl_export($number){
+	  $this->CI->db->where('number',$number);
+	  $this->CI->db->select('id,accountid,parent_id');
+	  $status=null;
+	  $did_info=(array)$this->CI->db->get('dids')->first_row();
+	  $accountinfo=$this->CI->session->userdata('accountinfo');
+	  if($did_info['accountid'] ==0 && $did_info['parent_id']==0){
 	$status='Not in use';
-      }
-      elseif($accountinfo['type'] !=1){
+	  }
+	  elseif($accountinfo['type'] !=1){
 	if($did_info['accountid'] ==0 && $did_info['parent_id'] > 0){
 	  $status='Purchase by Reseller';
 	}
 	if($did_info['accountid'] > 0 && $did_info['parent_id'] == 0){
 	  $status='Purchase by Customer';
 	}
-      }else{
-       $where_arr=array('note'=>$did_info['number'],"parent_id"=>$accountinfo['id']);
-       $this->db->where($where);
-       $this->CI->db->select('reseller_id,parent_id');
-       $reseller_pricing = (array)$this->db->get('reseller_pricing')->first_row();
-       if($reseller_pricing['reseller_id']==0 && $did_info['accountid']==0 && $did_info['parent_id']==$accountinfo['id']){
-        $status='Not in use';
-       }
-       if($reseller_pricing['reseller_id']==0 && $did_info['accountid']==0){
-       $status='Not in use';
-       }
-      }
-      return $status;
+	  }else{
+	   $where_arr=array('note'=>$did_info['number'],"parent_id"=>$accountinfo['id']);
+	   $this->db->where($where);
+	   $this->CI->db->select('reseller_id,parent_id');
+	   $reseller_pricing = (array)$this->db->get('reseller_pricing')->first_row();
+	   if($reseller_pricing['reseller_id']==0 && $did_info['accountid']==0 && $did_info['parent_id']==$accountinfo['id']){
+		$status='Not in use';
+	   }
+	   if($reseller_pricing['reseller_id']==0 && $did_info['accountid']==0){
+	   $status='Not in use';
+	   }
+	  }
+	  return $status;
       
-    }
-    function check_did_avl_reseller($select, $table, $where) {
-        $accountinfo = $this->CI->session->userdata('accountinfo');
-        $flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
-        $this->CI->db->where('number',$where);
-        $this->CI->db->select('id,accountid,parent_id,number');
-        $did_info=(array)$this->CI->db->get('dids')->first_row();
-        if($did_info['accountid'] > 0 && $did_info['parent_id'] == $accountinfo['id']){
-	    $flag_status = "<a href='../did_list_release/" . $did_info['id'] . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(C)<span></a>";
-	}
-        else if($accountinfo['type']!=1 && $did_info['parent_id'] != $accountinfo['id']){
-	    $flag_status = "<a href='../did_list_release/" . $did_info['id'] . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
-        }else{
-	    $reseller_id= $accountinfo['type'] != 1 ? 0 : $accountinfo['id'];
-	    $where = array("note" => $did_info['number'],'parent_id'=>$reseller_id);
-            $this->CI->db->where($where);
-	    $this->CI->db->select('reseller_id,id');
-	    $reseller_pricing_info=(array)$this->CI->db->get('reseller_pricing')->first_row();
-	    if (isset($reseller_pricing_info) && !empty($reseller_pricing_info)) {
+	}
+	function check_did_avl_reseller($select, $table, $where) {
+		$accountinfo = $this->CI->session->userdata('accountinfo');
+		$flag_status = "<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
+		$this->CI->db->where('number',$where);
+		$this->CI->db->select('id,accountid,parent_id,number');
+		$did_info=(array)$this->CI->db->get('dids')->first_row();
+		if($did_info['accountid'] > 0 && $did_info['parent_id'] == $accountinfo['id']){
+		$flag_status = "<a href='../did_list_release/" . $did_info['id'] . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(C)<span></a>";
+	}
+		else if($accountinfo['type']!=1 && $did_info['parent_id'] != $accountinfo['id']){
+		$flag_status = "<a href='../did_list_release/" . $did_info['id'] . "' title='Release' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
+		}else{
+		$reseller_id= $accountinfo['type'] != 1 ? 0 : $accountinfo['id'];
+		$where = array("note" => $did_info['number'],'parent_id'=>$reseller_id);
+			$this->CI->db->where($where);
+		$this->CI->db->select('reseller_id,id');
+		$reseller_pricing_info=(array)$this->CI->db->get('reseller_pricing')->first_row();
+		if (isset($reseller_pricing_info) && !empty($reseller_pricing_info)) {
 		  $flag_status="<a href='../did/did_reseller_edit/delete/".$reseller_pricing_info['id']."' title='Reliase' onClick='return get_reliase_msg();'><span class=' label label-sm label-inverse_blue arrowed_blue-in' title='release'>Release(R)</span></a>";
-	    }else{
-	      $flag_status="<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
-	    }
-        }
-        return $flag_status;
-    }
+		}else{
+		  $flag_status="<span class=' label label-sm label-inverse arrowed-in' title='Not in use'>Not in use</span>";
+		}
+		}
+		return $flag_status;
+	}
 
 //    get data for Comma seprated
-    function get_field_name_coma($select, $table, $where) {
-        $value = '';
-        if (is_array($where)) {
-            $where = $where;
-        } else {
-            $where = explode(',', $where);
-        }
-        for ($i = 0; $i < count($where); $i++) {
-            $where_in = array("id" => $where[$i]);
-
-            $field_name = $this->CI->db_model->getSelect($select, $table, $where_in);
-            $field_name = $field_name->result();
-            if (isset($field_name) && !empty($field_name)) {
-                $value.= $field_name[0]->$select . ",";
-            } else {
-                $value = "";
-            }
-        }
-        return rtrim($value, ',');
-    }
-
-    function set_invoice_option($select = "", $table = "", $call_type = "", $edit_value = '') {
-
-        $invoice_date = false;
-        $uri_segment = $this->CI->uri->segments;
-        if (isset($uri_segment[3]) && $uri_segment[3] > 0 && empty($edit_value)) {
-            $field_name = $this->CI->db_model->getSelect("sweep_id,invoice_day", "accounts", array("id" => $uri_segment[3]));
-            $field_name = $field_name->result_array();
-            $select = $field_name[0]["sweep_id"];
-            $invoice_date = $field_name[0]["invoice_day"];
-        } else {
-            $invoice_date = $edit_value;
-        }
-        if ($select == "" || $select == "0") {
-            $daily_arr = array("0" => "0");
-            return $daily_arr;
-        }
-        if ($select == 1) {
-            $week_arr = array("1" => "Monday", "2" => "Tuesday", "3" => "Wednesday", "4" => "Thursday", "5" => "Friday",
-                "6" => "Saturday", "7" => "Sunday");
-            $rawDate = date("Y-m-d");
-            $day = date('N', strtotime($rawDate));
-            if (isset($uri_segment[3])) {
-                return $week_arr;
-            } else {
-                $week_drp = form_dropdown(array("name" => 'invoice_day','style'=>"width: 100% !important;" , "class" => "invoice_day"), $week_arr, $day);
-                return $week_drp;
-            }
-        }
-        if ($select != 0 && $select != 1) {
-            for ($i = 1; $i < 29; $i++) {
-                $mon_arr[$i] = $i;
-            }
-            if (isset($uri_segment[3]) && $uri_segment[3] > 0 && empty($edit_value)) {
-                return $mon_arr;
-            } else {
-                $day = $invoice_date > 0 ? $invoice_date : date('d');
-                $month_drp = form_dropdown(array("name" => 'invoice_day',"class" => "width_dropdown invoice_day"), $mon_arr, $day);
-                return $month_drp;
-            }
-        }
-    }
-
-    function set_status($status = '') {
-        $status_array = array('0' => 'Active', '1' => 'Inactive',);
-        return $status_array;
-    }
-
-    function set_routetype($status = '') {
-        $status_array = array( '0' => 'LCR','1' => 'COST',);
-        return $status_array;
-    }
-
-    function set_prorate($status = '') {
-        $status_array = array('0' => 'Yes', '1' => 'No',);
-        return $status_array;
-    }
-    /*
+	function get_field_name_coma($select, $table, $where) {
+		$value = '';
+		if (is_array($where)) {
+			$where = $where;
+		} else {
+			$where = explode(',', $where);
+		}
+		for ($i = 0; $i < count($where); $i++) {
+			$where_in = array("id" => $where[$i]);
+
+			$field_name = $this->CI->db_model->getSelect($select, $table, $where_in);
+			$field_name = $field_name->result();
+			if (isset($field_name) && !empty($field_name)) {
+				$value.= $field_name[0]->$select . ",";
+			} else {
+				$value = "";
+			}
+		}
+		return rtrim($value, ',');
+	}
+
+	function set_invoice_option($select = "", $table = "", $call_type = "", $edit_value = '') {
+
+		$invoice_date = false;
+		$uri_segment = $this->CI->uri->segments;
+		if (isset($uri_segment[3]) && $uri_segment[3] > 0 && empty($edit_value)) {
+			$field_name = $this->CI->db_model->getSelect("sweep_id,invoice_day", "accounts", array("id" => $uri_segment[3]));
+			$field_name = $field_name->result_array();
+			$select = $field_name[0]["sweep_id"];
+			$invoice_date = $field_name[0]["invoice_day"];
+		} else {
+			$invoice_date = $edit_value;
+		}
+		if ($select == "" || $select == "0") {
+			$daily_arr = array("0" => "0");
+			return $daily_arr;
+		}
+		if ($select == 1) {
+			$week_arr = array("1" => "Monday", "2" => "Tuesday", "3" => "Wednesday", "4" => "Thursday", "5" => "Friday",
+				"6" => "Saturday", "7" => "Sunday");
+			$rawDate = date("Y-m-d");
+			$day = date('N', strtotime($rawDate));
+			if (isset($uri_segment[3])) {
+				return $week_arr;
+			} else {
+				$week_drp = form_dropdown(array("name" => 'invoice_day','style'=>"width: 100% !important;" , "class" => "invoice_day"), $week_arr, $day);
+				return $week_drp;
+			}
+		}
+		if ($select != 0 && $select != 1) {
+			for ($i = 1; $i < 29; $i++) {
+				$mon_arr[$i] = $i;
+			}
+			if (isset($uri_segment[3]) && $uri_segment[3] > 0 && empty($edit_value)) {
+				return $mon_arr;
+			} else {
+				$day = $invoice_date > 0 ? $invoice_date : date('d');
+				$month_drp = form_dropdown(array("name" => 'invoice_day',"class" => "width_dropdown invoice_day"), $mon_arr, $day);
+				return $month_drp;
+			}
+		}
+	}
+
+	function set_status($status = '') {
+		$status_array = array('0' => 'Active', '1' => 'Inactive',);
+		return $status_array;
+	}
+
+	function set_routetype($status = '') {
+		$status_array = array( '0' => 'LCR','1' => 'COST',);
+		return $status_array;
+	}
+
+	function set_prorate($status = '') {
+		$status_array = array('0' => 'Yes', '1' => 'No',);
+		return $status_array;
+	}
+	/*
       Add For Package Inbound or Outbound or both?
     */
-    function set_package_type($applicable_for = "") {
-        $package_applicable = array('0' => 'Outbound', '1' => 'Inbound', '2' => 'Both');
-        return $package_applicable;
-    }
-
-    function get_package_type($status = '', $table = "", $applicable_for) {
-        $package_applicable = array('0' => 'Outbound', '1' => 'Inbound', '2' => 'Both');
-        return $package_applicable[$applicable_for];
-    }
-    /******************************************** */
-    function set_allow($status = '') {
-        $status_array = array('1' => 'Yes', '0' => 'No');
-        return $status_array;
-    }
-    function set_allow_invoice($status = '') {
-        $status_array = array('1' => 'Yes', '0' => 'No');
-        return $status_array;
-    }
-    function set_pin_allow($status=''){
-        $status_array = array('0' => 'Disable','1' => 'Enable');
-        return $status_array;
-    }
-    function set_pin_allow_customer($status=''){
-        $status_array = array('0' => 'No','1' => 'Yes');
-        return $status_array;
-    }
-    function get_allow($select = "", $table = "", $status) {
-        return ($status == 1) ? "Yes" : "No";
-    }
-
-    function set_call_type($call_type = "") {
-        $call_type_array = array("-1" => "--Select--",'1' => 'DID-Local',"3"=>"SIP-DID", '0' => 'PSTN',  '2' => 'Other',);
-        return $call_type_array;
-    }
-    function set_call_type_search(){
+	function set_package_type($applicable_for = "") {
+		$package_applicable = array('0' => 'Outbound', '1' => 'Inbound', '2' => 'Both');
+		return $package_applicable;
+	}
+
+	function get_package_type($status = '', $table = "", $applicable_for) {
+		$package_applicable = array('0' => 'Outbound', '1' => 'Inbound', '2' => 'Both');
+		return $package_applicable[$applicable_for];
+	}
+	/******************************************** */
+	function set_allow($status = '') {
+		$status_array = array('1' => 'Yes', '0' => 'No');
+		return $status_array;
+	}
+	function set_allow_invoice($status = '') {
+		$status_array = array('1' => 'Yes', '0' => 'No');
+		return $status_array;
+	}
+	function set_pin_allow($status=''){
+		$status_array = array('0' => 'Disable','1' => 'Enable');
+		return $status_array;
+	}
+	function set_pin_allow_customer($status=''){
+		$status_array = array('0' => 'No','1' => 'Yes');
+		return $status_array;
+	}
+	function get_allow($select = "", $table = "", $status) {
+		return ($status == 1) ? "Yes" : "No";
+	}
+
+	function set_call_type($call_type = "") {
+		$call_type_array = array("-1" => "--Select--",'1' => 'DID-Local',"3"=>"SIP-DID", '0' => 'PSTN',  '2' => 'Other',);
+		return $call_type_array;
+	}
+	function set_call_type_search(){
 	$call_type_array = array("" => "--Select--",'1' => 'DID-Local',"3"=>"SIP-DID", '0' => 'PSTN',  '2' => 'Other',);
-        return $call_type_array;
-    }
-    function get_call_type($select = "", $table = "", $call_type) {
-        $call_type_array = array('1' => 'DID-Local',"3"=>"SIP-DID",'0' => 'PSTN',  '2' => 'Other','-1'=>"");
-        return $call_type_array[$call_type];
-    }
-
-    function get_custom_call_type($call_type) {
-        $call_type_array = array('DID-Local' => '1',"SIP-DID"=>"3",'PSTN' => '0','Other' => '2',""=>"-1");
-        return $call_type_array[$call_type];
-    }
-
-    function set_sip_config_option($option = "") {
-        $config_option = array("true" => "True", "false" => "False");
-        return $config_option;
-    }
-
-    function get_entity_type($select = "", $table = "", $entity_type) {
-        $entity_array = array('-1' => "Administrator", '0' => 'Customer', '1' => 'Reseller', '2' => 'Admin', '3' => "Provider", "4" => "Subadmin", "5" => "Callshop");
-        return($entity_array[$entity_type]);
-    }
-
-    function set_entity_type_customer($entity_type = "") {
-        $entity_array = array('' => "--Select--", '0' => 'Customer', '3' => "Provider");
-        return $entity_array;
-    }
-
-    function set_entity_type_admin($entity_type = "") {
-        $entity_array = array('' => "--Select--", '2' => 'Admin', "4" => "Sub Admin");
-        return $entity_array;
-    }
+		return $call_type_array;
+	}
+	function get_call_type($select = "", $table = "", $call_type) {
+		$call_type_array = array('1' => 'DID-Local',"3"=>"SIP-DID",'0' => 'PSTN',  '2' => 'Other','-1'=>"");
+		return $call_type_array[$call_type];
+	}
+
+	function get_custom_call_type($call_type) {
+		$call_type_array = array('DID-Local' => '1',"SIP-DID"=>"3",'PSTN' => '0','Other' => '2',""=>"-1");
+		return $call_type_array[$call_type];
+	}
+
+	function set_sip_config_option($option = "") {
+		$config_option = array("true" => "True", "false" => "False");
+		return $config_option;
+	}
+
+	function get_entity_type($select = "", $table = "", $entity_type) {
+		$entity_array = array('-1' => "Administrator", '0' => 'Customer', '1' => 'Reseller', '2' => 'Admin', '3' => "Provider", "4" => "Subadmin", "5" => "Callshop");
+		return($entity_array[$entity_type]);
+	}
+
+	function set_entity_type_customer($entity_type = "") {
+		$entity_array = array('' => "--Select--", '0' => 'Customer', '3' => "Provider");
+		return $entity_array;
+	}
+
+	function set_entity_type_admin($entity_type = "") {
+		$entity_array = array('' => "--Select--", '2' => 'Admin', "4" => "Sub Admin");
+		return $entity_array;
+	}
 
 	function set_entity_type_email_mass($entity_type = "") {
-        $entity_array = array('' => "--Select--", '0' => 'Customer','1'=>'Reseller','3' => "Provider");
-        return $entity_array;
-    }
-
-    function set_sip_config_options($option = "") {
-        $config_option = array("false" => "False", "true" => "True");
-        return $config_option;
-    }
-
-    function set_sip_config_default($option = "") {
-        $config_option = array("" => "--SELECT--", "false" => "False", "true" => "True");
-        return $config_option;
-    }
-
-    function set_sip_bind_params($option = "") {
-        $config_option = array("" => "--SELECT--", "udp" => "UDP", "tcp" => "TCP");
-        return $config_option;
-    }
-
-    function set_sip_vad_option() {
-        $config_option = array("in" => "In", "out" => "Out", "both" => "Both");
-        return $config_option;
-    }
-
-    function set_sip_drp_option($option = "") {
-        $status_array = array('no' => 'No', 'yes' => 'Yes');
-        return $status_array;
-    }
-
-    function set_status_callingcard($status = '') {
-        $status_array = array('1' => 'Active', '0' => 'Inactive', '2' => 'Deleted');
-        return $status_array;
-    }
+		$entity_array = array('' => "--Select--", '0' => 'Customer','1'=>'Reseller','3' => "Provider");
+		return $entity_array;
+	}
+
+	function set_sip_config_options($option = "") {
+		$config_option = array("false" => "False", "true" => "True");
+		return $config_option;
+	}
+
+	function set_sip_config_default($option = "") {
+		$config_option = array("" => "--SELECT--", "false" => "False", "true" => "True");
+		return $config_option;
+	}
+
+	function set_sip_bind_params($option = "") {
+		$config_option = array("" => "--SELECT--", "udp" => "UDP", "tcp" => "TCP");
+		return $config_option;
+	}
+
+	function set_sip_vad_option() {
+		$config_option = array("in" => "In", "out" => "Out", "both" => "Both");
+		return $config_option;
+	}
+
+	function set_sip_drp_option($option = "") {
+		$status_array = array('no' => 'No', 'yes' => 'Yes');
+		return $status_array;
+	}
+
+	function set_status_callingcard($status = '') {
+		$status_array = array('1' => 'Active', '0' => 'Inactive', '2' => 'Deleted');
+		return $status_array;
+	}
    /*
    show status on all grid
    */
    function get_status($select = "", $table = "", $status) {
-       if($select !='export'){
-        $status_tab=$this->encode($table);
-        $status['table']="'".$status_tab."'";
-        if($status['status'] == 0){
+	   if($select !='export'){
+		$status_tab=$this->encode($table);
+		$status['table']="'".$status_tab."'";
+		if($status['status'] == 0){
 	$status_array = '<div style="width: 100%; text-align: -moz-center; padding: 0;"><input type="checkbox" name="onoffswitch" class="onoffswitch-checkbox" id=switch'.$status['id'].' value='.$status['status'].' onclick="javascript:processForm('.$status['id'].','.$status['table'].')" checked>
 	<label class="onoffswitch-label" for=switch'.$status["id"].'>
      	<span class="onoffswitch-inner"></span>
@@ -484,246 +484,246 @@ 
 		return ($status == 0) ? "Active" : "Inactive";
 	}
 	return $status_array;
-    }
+	}
    
-    function get_routetype($select = "", $table = "", $status) {
-        return ($status == 0) ? "LCR" : "COST";
-    }
+	function get_routetype($select = "", $table = "", $status) {
+		return ($status == 0) ? "LCR" : "COST";
+	}
    
    function get_prorate($select = "", $table = "", $status) {
-        return ($status == 0) ? "Yes" : "No";
-    }
+		return ($status == 0) ? "Yes" : "No";
+	}
     
-    function get_import_status($status){
-     return strtolower(trim($status)) == 'active' ? 0 : 1;
+	function get_import_status($status){
+	 return strtolower(trim($status)) == 'active' ? 0 : 1;
      
-    }
-    function get_did_status($select,$table,$status){
+	}
+	function get_did_status($select,$table,$status){
     
-      return ($status['status']==0) ? "<span class='label label-sm label-inverse arrowed-in' title='release'>Active<span>" : "<span class='label label-sm' title='release'>Inactive<span>";
-    }
+	  return ($status['status']==0) ? "<span class='label label-sm label-inverse arrowed-in' title='release'>Active<span>" : "<span class='label label-sm' title='release'>Inactive<span>";
+	}
    
 
-    function get_invoice_date($select, $accountid = 0, $reseller_id, $order_by = 'id') {
-        $where = array("reseller_id" => $reseller_id);
-        if ($accountid > 0) {
-            $where['accountid'] = $accountid;
-        }
-        $invoice_res = $this->CI->db_model->select($select, "invoices", $where, $order_by, "DESC", "1", "0");
-        if ($invoice_res->num_rows > 0) {
-            $invoice_info = (array) $invoice_res->first_row();
-            return $invoice_info[$select];
-        }
-        return false;
-    }
-
-    function convert_to_date($select = '', $table = '', $from_date) {
-
-        $from_date = date('Y-m-d', strtotime($from_date));
-        return $from_date;
-    }
-
-
-    function get_account_balance($select = "", $table = "", $amount) {
-        $this->CI->load->model('common_model');
-        if ($amount == 0) {
-            return $amount;
-        } else {
-            $balance = $this->CI->common_model->add_calculate_currency(($amount), "", '', true, true);
-
-            return $balance;
-        }
-    }
-
-    function convert_to_currency($select = "", $table = "", $amount) {
-        $this->CI->load->model('common_model');
-        return $this->CI->common_model->calculate_currency($amount,'','',true,false);
-    }
-    function account_number_icon($select = "", $table = "", $number){
-    $return_value='';
-    $where=array('number'=>$number);
-    $account_res = (array)$this->CI->db->get_where("accounts",$where)->first_row();
-    if($account_res['type'] == 0){
-    $return_value= '<div class="flx_font flx_magenta" title="Customer">C</div>'." <span title='Edit'>". $account_res['number']." </span>";    
-    }
-    if($account_res['type']==3){
-    $return_value='<div class="flx_font flx_blue" title="Provider">P</div>'." <span title='Edit'>".$account_res['number']." </span>";
-    }
-    if($account_res['type']== -1 || $account_res['type']==2){
-      $return_value='<div class="flx_font flx_pink" title="Admin">A</div>'." <span title='Edit'>".$account_res['number']." </span>";
-    }
-    if($account_res['type']== 4){
-      $return_value='<div class="flx_font flx_purple" title="Subadmin">S</div>'." <span title='Edit'>".$account_res['number']." </span>";
-    }
-    return $return_value;
-    }
-    function convert_to_currency_account($select = "", $table = "", $amount) {
-        $this->CI->load->model('common_model');
-        return $this->CI->common_model->calculate_currency_customer($amount);
-    }
-
-    function get_paid_status($select = "", $table = "", $status) {
-        return ($status == 1) ? "Paid" : "Unpaid";
-    }
-
-    function set_account_type($status = '') {
-        $status_array = array('0' => 'Prepaid', '1' => 'Postpaid');
-        return $status_array;
-    }
-
-    function set_account_type_search($status = '') {
-        $status_array = array('' => "--Select--", '0' => 'Prepaid', '1' => 'Postpaid');
-        return $status_array;
-    }
-
-    function get_account_type($select = "", $table = "", $PTE) {
-        return ($PTE == 1) ? "Postpaid" : "Prepaid";
-    }
-
-    /******
+	function get_invoice_date($select, $accountid = 0, $reseller_id, $order_by = 'id') {
+		$where = array("reseller_id" => $reseller_id);
+		if ($accountid > 0) {
+			$where['accountid'] = $accountid;
+		}
+		$invoice_res = $this->CI->db_model->select($select, "invoices", $where, $order_by, "DESC", "1", "0");
+		if ($invoice_res->num_rows > 0) {
+			$invoice_info = (array) $invoice_res->first_row();
+			return $invoice_info[$select];
+		}
+		return false;
+	}
+
+	function convert_to_date($select = '', $table = '', $from_date) {
+
+		$from_date = date('Y-m-d', strtotime($from_date));
+		return $from_date;
+	}
+
+
+	function get_account_balance($select = "", $table = "", $amount) {
+		$this->CI->load->model('common_model');
+		if ($amount == 0) {
+			return $amount;
+		} else {
+			$balance = $this->CI->common_model->add_calculate_currency(($amount), "", '', true, true);
+
+			return $balance;
+		}
+	}
+
+	function convert_to_currency($select = "", $table = "", $amount) {
+		$this->CI->load->model('common_model');
+		return $this->CI->common_model->calculate_currency($amount,'','',true,false);
+	}
+	function account_number_icon($select = "", $table = "", $number){
+	$return_value='';
+	$where=array('number'=>$number);
+	$account_res = (array)$this->CI->db->get_where("accounts",$where)->first_row();
+	if($account_res['type'] == 0){
+	$return_value= '<div class="flx_font flx_magenta" title="Customer">C</div>'." <span title='Edit'>". $account_res['number']." </span>";    
+	}
+	if($account_res['type']==3){
+	$return_value='<div class="flx_font flx_blue" title="Provider">P</div>'." <span title='Edit'>".$account_res['number']." </span>";
+	}
+	if($account_res['type']== -1 || $account_res['type']==2){
+	  $return_value='<div class="flx_font flx_pink" title="Admin">A</div>'." <span title='Edit'>".$account_res['number']." </span>";
+	}
+	if($account_res['type']== 4){
+	  $return_value='<div class="flx_font flx_purple" title="Subadmin">S</div>'." <span title='Edit'>".$account_res['number']." </span>";
+	}
+	return $return_value;
+	}
+	function convert_to_currency_account($select = "", $table = "", $amount) {
+		$this->CI->load->model('common_model');
+		return $this->CI->common_model->calculate_currency_customer($amount);
+	}
+
+	function get_paid_status($select = "", $table = "", $status) {
+		return ($status == 1) ? "Paid" : "Unpaid";
+	}
+
+	function set_account_type($status = '') {
+		$status_array = array('0' => 'Prepaid', '1' => 'Postpaid');
+		return $status_array;
+	}
+
+	function set_account_type_search($status = '') {
+		$status_array = array('' => "--Select--", '0' => 'Prepaid', '1' => 'Postpaid');
+		return $status_array;
+	}
+
+	function get_account_type($select = "", $table = "", $PTE) {
+		return ($PTE == 1) ? "Postpaid" : "Prepaid";
+	}
+
+	/******
       Payment to refill
     ******/
 
-    function get_refill_by($select = "", $table = "", $type) {
-        if ($type == '-1') {
-            $type = "Admin";
-        } else {
-            $type = $this->get_field_name("number", "accounts", array("id" => $type));
-        }
-        return $type;
-    }
-
-    /******************* */
-
-    function get_payment_by($select = "", $table = "", $type) {
-        if ($type == '-1') {
-            $type = "Admin";
-        } else {
-            $type = $this->get_field_name("number", "accounts", array("id" => $type));
-        }
-        return $type;
-    }
-
-    function set_payment_type($payment_type = '') {
-        /*
+	function get_refill_by($select = "", $table = "", $type) {
+		if ($type == '-1') {
+			$type = "Admin";
+		} else {
+			$type = $this->get_field_name("number", "accounts", array("id" => $type));
+		}
+		return $type;
+	}
+
+	/******************* */
+
+	function get_payment_by($select = "", $table = "", $type) {
+		if ($type == '-1') {
+			$type = "Admin";
+		} else {
+			$type = $this->get_field_name("number", "accounts", array("id" => $type));
+		}
+		return $type;
+	}
+
+	function set_payment_type($payment_type = '') {
+		/*
          * Recharge to Refill
          */
-        $status_array = array('0' => 'Refill', '1' => 'Postcharge',);
-        return $status_array;
-    }
-
-    function search_int_type($status = '') {
-        $status_array = array('1' => 'Is Equal To', '2' => 'Is Not Equal To', '3' => 'Greater Than', '4' => 'Less Than', '5' => 'Greater Or Equal Than', '6' => 'Less Or Equal Than');
-        return $status_array;
-    }
-
-    function update_int_type($status = '') {
-        $status_array = array('1' => 'Preserve', '2' => 'Set To', '3' => 'Increase By', '4' => 'Decrease By');
-        return $status_array;
-    }
-
-    function update_drp_type($status = '') {
-        $status_array = array('1' => 'Preserve', '2' => 'Set To');
-        return $status_array;
-    }
-
-    function search_string_type($status = '') {
-        $status_array = array('5'=>"Begins With",'1' => 'Contains', '2' => 'Doesnt Contain', '3' => 'Is Equal To', '4' => 'Is Not Equal To',"6"=>"Ends With");
-        return $status_array;
-    }
-
-    function set_protocal($protpcal = '') {
-        $status_array = array('SIP' => 'SIP', 'IAX2' => 'IAX2', 'Zap' => 'Zap', 'Local' => 'Local', 'OH323' => 'OH323', 'OOH323C' => 'OOH323C');
-        return $status_array;
-    }
-
-    /*
+		$status_array = array('0' => 'Refill', '1' => 'Postcharge',);
+		return $status_array;
+	}
+
+	function search_int_type($status = '') {
+		$status_array = array('1' => 'Is Equal To', '2' => 'Is Not Equal To', '3' => 'Greater Than', '4' => 'Less Than', '5' => 'Greater Or Equal Than', '6' => 'Less Or Equal Than');
+		return $status_array;
+	}
+
+	function update_int_type($status = '') {
+		$status_array = array('1' => 'Preserve', '2' => 'Set To', '3' => 'Increase By', '4' => 'Decrease By');
+		return $status_array;
+	}
+
+	function update_drp_type($status = '') {
+		$status_array = array('1' => 'Preserve', '2' => 'Set To');
+		return $status_array;
+	}
+
+	function search_string_type($status = '') {
+		$status_array = array('5'=>"Begins With",'1' => 'Contains', '2' => 'Doesnt Contain', '3' => 'Is Equal To', '4' => 'Is Not Equal To',"6"=>"Ends With");
+		return $status_array;
+	}
+
+	function set_protocal($protpcal = '') {
+		$status_array = array('SIP' => 'SIP', 'IAX2' => 'IAX2', 'Zap' => 'Zap', 'Local' => 'Local', 'OH323' => 'OH323', 'OOH323C' => 'OOH323C');
+		return $status_array;
+	}
+
+	/*
      *
      * Purpose : Add Profit Margin report
      * Version 2.1
      */
 
-    function set_notify_by($status = '') {
-        $status_array = array('' => 'Select Notify By', '0' => 'CSV', '1' => 'Email');
-        return $status_array;
-    }
+	function set_notify_by($status = '') {
+		$status_array = array('' => 'Select Notify By', '0' => 'CSV', '1' => 'Email');
+		return $status_array;
+	}
 
-    function convert_to_percentage($select = "", $table = "", $amount) {
-        return round($amount, 2) . " %";
-    }
+	function convert_to_percentage($select = "", $table = "", $amount) {
+		return round($amount, 2) . " %";
+	}
 
-    function convert_to_minutes($select = "", $table = "", $amount) {
-        return str_replace('.', ':', round($amount / 60, 2));
-    }
+	function convert_to_minutes($select = "", $table = "", $amount) {
+		return str_replace('.', ':', round($amount / 60, 2));
+	}
 
-    function set_filter_type_search($status = '') {
-        $status_array = array('pricelist_id' => 'Rate Group', 'accountid' => 'Customer', 'reseller_id' => 'Reseller');
-        return $status_array;
-    }
+	function set_filter_type_search($status = '') {
+		$status_array = array('pricelist_id' => 'Rate Group', 'accountid' => 'Customer', 'reseller_id' => 'Reseller');
+		return $status_array;
+	}
     
-    	function set_routetype_status($select= ''){
-        $status_array = array("" => "--Select--",
-            "0" => "LCR",
-            "1" => "COST"
-        );
-        return $status_array;
+		function set_routetype_status($select= ''){
+		$status_array = array("" => "--Select--",
+			"0" => "LCR",
+			"1" => "COST"
+		);
+		return $status_array;
 }
 	
 
-    //attachment download in email module...
-    function attachment_icons($select = "", $table = "", $attachement = "") {
-        if ($attachement != "") {
-            $array = explode(",", $attachement);
-            $str = '';	
-            foreach ($array as $key => $val) {
-                $link = base_url() . "email/email_history_list_attachment/" . $val;
-                $str.="<a href='" . $link . "' title='" . $val . "' class='btn btn-royelblue btn-sm'><i class='fa fa-paperclip fa-fw'></i></a>&nbsp;&nbsp;";
-            }
-            return $str;
-        } else {
-            return "";
-        }
-    }
-
-    /*     * ************************************************************* */
-
-    function set_despostion($dis = '') {
-        $status_array = array("" => "--Select Disposition--",
-            "UNSPECIFIED" => "UNSPECIFIED",
-            "UNALLOCATED_NUMBER" => "UNALLOCATED_NUMBER",
-            "NO_ROUTE_DESTINATION" => "NO_ROUTE_DESTINATION",
-            "CHANNEL_UNACCEPTABLE" => "CHANNEL_UNACCEPTABLE",
-            "NORMAL_CLEARING" => "NORMAL_CLEARING",
-            "SUCCESS" => "SUCCESS",
-            "USER_BUSY" => "USER_BUSY",
-            "NO_USER_RESPONSE" => "NO_USER_RESPONSE",
-            "NO_ANSWER" => "NO_ANSWER",
-            "CALL_REJECTED" => "CALL_REJECTED",
-            "NUMBER_CHANGED" => "NUMBER_CHANGED",
-            "DESTINATION_OUT_OF_ORDER" => "DESTINATION_OUT_OF_ORDER",
-            "INVALID_NUMBER_FORMAT" => "INVALID_NUMBER_FORMAT",
-            "FACILITY_REJECTED" => "FACILITY_REJECTED",
-            "NORMAL_UNSPECIFIED" => "NORMAL_UNSPECIFIED",
-            "NORMAL_CIRCUIT_CONGESTION" => "NORMAL_CIRCUIT_CONGESTION",
-            "NETWORK_OUT_OF_ORDER" => "NETWORK_OUT_OF_ORDER",
-            "NORMAL_TEMPORARY_FAILURE" => "NORMAL_TEMPORARY_FAILURE",
-            "SWITCH_CONGESTION" => "SWITCH_CONGESTION",
-            "FACILITY_NOT_SUBSCRIBED" => "FACILITY_NOT_SUBSCRIBED",
-            "OUTGOING_CALL_BARRED" => "OUTGOING_CALL_BARRED",
-            "BEARERCAPABILITY_NOTAUTH" => "BEARERCAPABILITY_NOTAUTH",
-            "BEARERCAPABILITY_NOTAVAIL" => "BEARERCAPABILITY_NOTAVAIL",
-            "SERVICE_UNAVAILABLE" => "SERVICE_UNAVAILABLE",
-            "BEARERCAPABILITY_NOTIMPL" => "BEARERCAPABILITY_NOTIMPL",
-            "CHAN_NOT_IMPLEMENTED" => "CHAN_NOT_IMPLEMENTED",
-            "FACILITY_NOT_IMPLEMENTED" => "FACILITY_NOT_IMPLEMENTED",
-            "SERVICE_NOT_IMPLEMENTED" => "SERVICE_NOT_IMPLEMENTED",
-            "INCOMPATIBLE_DESTINATION" => "INCOMPATIBLE_DESTINATION",
-            "RECOVERY_ON_TIMER_EXPIRE" => "RECOVERY_ON_TIMER_EXPIRE",
-            "ORIGINATOR_CANCEL" => "ORIGINATOR_CANCEL",
-            "ALLOTTED_TIMEOUT" => "ALLOTTED_TIMEOUT",
-            "MEDIA_TIMEOUT" => "MEDIA_TIMEOUT",
-            "PROGRESS_TIMEOUT" => "PROGRESS_TIMEOUT",
-            "AUTHENTICATION_FAIL" => "AUTHENTICATION_FAIL",
+	//attachment download in email module...
+	function attachment_icons($select = "", $table = "", $attachement = "") {
+		if ($attachement != "") {
+			$array = explode(",", $attachement);
+			$str = '';	
+			foreach ($array as $key => $val) {
+				$link = base_url() . "email/email_history_list_attachment/" . $val;
+				$str.="<a href='" . $link . "' title='" . $val . "' class='btn btn-royelblue btn-sm'><i class='fa fa-paperclip fa-fw'></i></a>&nbsp;&nbsp;";
+			}
+			return $str;
+		} else {
+			return "";
+		}
+	}
+
+	/*     * ************************************************************* */
+
+	function set_despostion($dis = '') {
+		$status_array = array("" => "--Select Disposition--",
+			"UNSPECIFIED" => "UNSPECIFIED",
+			"UNALLOCATED_NUMBER" => "UNALLOCATED_NUMBER",
+			"NO_ROUTE_DESTINATION" => "NO_ROUTE_DESTINATION",
+			"CHANNEL_UNACCEPTABLE" => "CHANNEL_UNACCEPTABLE",
+			"NORMAL_CLEARING" => "NORMAL_CLEARING",
+			"SUCCESS" => "SUCCESS",
+			"USER_BUSY" => "USER_BUSY",
+			"NO_USER_RESPONSE" => "NO_USER_RESPONSE",
+			"NO_ANSWER" => "NO_ANSWER",
+			"CALL_REJECTED" => "CALL_REJECTED",
+			"NUMBER_CHANGED" => "NUMBER_CHANGED",
+			"DESTINATION_OUT_OF_ORDER" => "DESTINATION_OUT_OF_ORDER",
+			"INVALID_NUMBER_FORMAT" => "INVALID_NUMBER_FORMAT",
+			"FACILITY_REJECTED" => "FACILITY_REJECTED",
+			"NORMAL_UNSPECIFIED" => "NORMAL_UNSPECIFIED",
+			"NORMAL_CIRCUIT_CONGESTION" => "NORMAL_CIRCUIT_CONGESTION",
+			"NETWORK_OUT_OF_ORDER" => "NETWORK_OUT_OF_ORDER",
+			"NORMAL_TEMPORARY_FAILURE" => "NORMAL_TEMPORARY_FAILURE",
+			"SWITCH_CONGESTION" => "SWITCH_CONGESTION",
+			"FACILITY_NOT_SUBSCRIBED" => "FACILITY_NOT_SUBSCRIBED",
+			"OUTGOING_CALL_BARRED" => "OUTGOING_CALL_BARRED",
+			"BEARERCAPABILITY_NOTAUTH" => "BEARERCAPABILITY_NOTAUTH",
+			"BEARERCAPABILITY_NOTAVAIL" => "BEARERCAPABILITY_NOTAVAIL",
+			"SERVICE_UNAVAILABLE" => "SERVICE_UNAVAILABLE",
+			"BEARERCAPABILITY_NOTIMPL" => "BEARERCAPABILITY_NOTIMPL",
+			"CHAN_NOT_IMPLEMENTED" => "CHAN_NOT_IMPLEMENTED",
+			"FACILITY_NOT_IMPLEMENTED" => "FACILITY_NOT_IMPLEMENTED",
+			"SERVICE_NOT_IMPLEMENTED" => "SERVICE_NOT_IMPLEMENTED",
+			"INCOMPATIBLE_DESTINATION" => "INCOMPATIBLE_DESTINATION",
+			"RECOVERY_ON_TIMER_EXPIRE" => "RECOVERY_ON_TIMER_EXPIRE",
+			"ORIGINATOR_CANCEL" => "ORIGINATOR_CANCEL",
+			"ALLOTTED_TIMEOUT" => "ALLOTTED_TIMEOUT",
+			"MEDIA_TIMEOUT" => "MEDIA_TIMEOUT",
+			"PROGRESS_TIMEOUT" => "PROGRESS_TIMEOUT",
+			"AUTHENTICATION_FAIL" => "AUTHENTICATION_FAIL",
 			"ACCOUNT_INACTIVE_DELETED" => "ACCOUNT_INACTIVE_DELETED",
 			"ACCOUNT_EXPIRE" => "ACCOUNT_EXPIRE",
 			"NO_SUFFICIENT_FUND" => "NO_SUFFICIENT_FUND",
@@ -732,141 +732,141 @@ 
 			"RESELLER_COST_CHEAP" => "RESELLER_COST_CHEAP",
 			"TERMINATION_RATE_NOT_FOUND" => "TERMINATION_RATE_NOT_FOUND",
 			"DID_DESTINATION_NOT_FOUND" => "DID_DESTINATION_NOT_FOUND",
-        );
-        return $status_array;
-    }
-
-    function set_calltype($type = '') {
-        $status_array = array("" => "--Select Type--",
-            "STANDARD" => "STANDARD",
-            "DID" => "DID",
-            "CALLINGCARD" => "CALLINGCARD",
-            "FREE" => "FREE",
-        );
-        return $status_array;
-    }
-
-    function set_search_status($select = '') {
-        $status_array = array("" => "--Select--",
-            "0" => "Active",
-            "1" => "Inactive"
-        );
-        return $status_array;
-    }
+		);
+		return $status_array;
+	}
+
+	function set_calltype($type = '') {
+		$status_array = array("" => "--Select Type--",
+			"STANDARD" => "STANDARD",
+			"DID" => "DID",
+			"CALLINGCARD" => "CALLINGCARD",
+			"FREE" => "FREE",
+		);
+		return $status_array;
+	}
+
+	function set_search_status($select = '') {
+		$status_array = array("" => "--Select--",
+			"0" => "Active",
+			"1" => "Inactive"
+		);
+		return $status_array;
+	}
         
-    function set_Billing_Schedule_status($select = '') {
-        $status_array = array("" => "--Select--",
-            "0" => "Daily",
-            "2" => "Monthly"
-        );
-        return $status_array;
-    }
-
-    function get_action_buttons($buttons_arr, $linkid) {
-        $ret_url = '';
-        if (!empty($buttons_arr) && $buttons_arr != '') {
-            foreach ($buttons_arr as $button_key => $buttons_params) {
-                if (strtoupper($button_key) == "EDIT") {
-                    $ret_url .= $this->build_edit_button($buttons_params, $linkid);
-                }
-                /*
+	function set_Billing_Schedule_status($select = '') {
+		$status_array = array("" => "--Select--",
+			"0" => "Daily",
+			"2" => "Monthly"
+		);
+		return $status_array;
+	}
+
+	function get_action_buttons($buttons_arr, $linkid) {
+		$ret_url = '';
+		if (!empty($buttons_arr) && $buttons_arr != '') {
+			foreach ($buttons_arr as $button_key => $buttons_params) {
+				if (strtoupper($button_key) == "EDIT") {
+					$ret_url .= $this->build_edit_button($buttons_params, $linkid);
+				}
+				/*
                  *
                  * Purpose : Add resend link
                  * Version 2.1
                  */
-                if (strtoupper($button_key) == "RESEND") {
-                    $ret_url .= $this->build_edit_button_resend($buttons_params, $linkid);
-                }
-                /*                 * ************************************* */
-                if (strtoupper($button_key) == "EDIT_RESTORE") {
-                    $ret_url .= $this->build_edit_button_restore($buttons_params, $linkid);
-                }
-                if (strtoupper($button_key) == "DELETE") {
-                    $ret_url .= $this->build_delete_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "VIEW") {
-                    $ret_url .= $this->build_view_button($buttons_params, $linkid);
-                }
-                if (strtoupper($button_key) == "TAXES") {
-                    $ret_url .= $this->build_add_taxes_button($buttons_params, $linkid);
-                }
-                if (strtoupper($button_key) == "BLUEBOX_LOGIN") {
-                    $ret_url .= $this->build_bluebox_login($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "CALLERID") {
-                    $ret_url .= $this->build_add_callerid_button($buttons_params, $linkid);
-                }
-                if (strtoupper($button_key) == "PAYMENT") {
-                    $ret_url .= $this->build_add_payment_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "DOWNLOAD") {
-                    $ret_url .= $this->build_add_download_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "START") {
-                    $ret_url .= $this->build_start_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "STOP") {
-                    $ret_url .= $this->build_stop_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "RELOAD") {
-                    $ret_url .= $this->build_reload_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "RESCAN") {
-                    $ret_url .= $this->build_rescan_button($buttons_params->url, $linkid);
-                }
-
-                if (strtoupper($button_key) == "DOWNLOAD_DATABASE") {
-                    $ret_url .= $this->build_add_download_database_button($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "DELETE_ANIMAP") {
-                    $ret_url .= $this->build_delete_button_animap($buttons_params->url, $linkid);
-                }
-                if (strtoupper($button_key) == "EDIT_ANIMAP") {
-                    $ret_url .= $this->build_edit_button_animap($buttons_params, $linkid);
-                }
-                if (strtoupper($button_key) == "ANIMAP") {
-                    $ret_url .= $this->build_animap_button($buttons_params, $linkid);
-                }
-            }
-        }
-        return $ret_url;
-    }
-
-    function build_delete_button_animap($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="javascript:void(0)" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg_destination(' . $linkid . ');"><i class="fa fa-trash fa-fw"></i></a>';
-    }
-
-    function build_edit_button_animap($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        return '<a href="javascript:void(0);" id="destination_new" class="btn btn-royelblue btn-sm" onclick="return get_destination(' . $linkid . ');" title="Update"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
-    }
-
-    function build_animap_button($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm animap_image" rel="facebox" title="ANI Map"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-    }
-
-    function build_edit_button($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
+				if (strtoupper($button_key) == "RESEND") {
+					$ret_url .= $this->build_edit_button_resend($buttons_params, $linkid);
+				}
+				/*                 * ************************************* */
+				if (strtoupper($button_key) == "EDIT_RESTORE") {
+					$ret_url .= $this->build_edit_button_restore($buttons_params, $linkid);
+				}
+				if (strtoupper($button_key) == "DELETE") {
+					$ret_url .= $this->build_delete_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "VIEW") {
+					$ret_url .= $this->build_view_button($buttons_params, $linkid);
+				}
+				if (strtoupper($button_key) == "TAXES") {
+					$ret_url .= $this->build_add_taxes_button($buttons_params, $linkid);
+				}
+				if (strtoupper($button_key) == "BLUEBOX_LOGIN") {
+					$ret_url .= $this->build_bluebox_login($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "CALLERID") {
+					$ret_url .= $this->build_add_callerid_button($buttons_params, $linkid);
+				}
+				if (strtoupper($button_key) == "PAYMENT") {
+					$ret_url .= $this->build_add_payment_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "DOWNLOAD") {
+					$ret_url .= $this->build_add_download_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "START") {
+					$ret_url .= $this->build_start_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "STOP") {
+					$ret_url .= $this->build_stop_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "RELOAD") {
+					$ret_url .= $this->build_reload_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "RESCAN") {
+					$ret_url .= $this->build_rescan_button($buttons_params->url, $linkid);
+				}
+
+				if (strtoupper($button_key) == "DOWNLOAD_DATABASE") {
+					$ret_url .= $this->build_add_download_database_button($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "DELETE_ANIMAP") {
+					$ret_url .= $this->build_delete_button_animap($buttons_params->url, $linkid);
+				}
+				if (strtoupper($button_key) == "EDIT_ANIMAP") {
+					$ret_url .= $this->build_edit_button_animap($buttons_params, $linkid);
+				}
+				if (strtoupper($button_key) == "ANIMAP") {
+					$ret_url .= $this->build_animap_button($buttons_params, $linkid);
+				}
+			}
+		}
+		return $ret_url;
+	}
+
+	function build_delete_button_animap($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="javascript:void(0)" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg_destination(' . $linkid . ');"><i class="fa fa-trash fa-fw"></i></a>';
+	}
+
+	function build_edit_button_animap($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		return '<a href="javascript:void(0);" id="destination_new" class="btn btn-royelblue btn-sm" onclick="return get_destination(' . $linkid . ');" title="Update"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
+	}
+
+	function build_animap_button($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm animap_image" rel="facebox" title="ANI Map"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+	}
+
+	function build_edit_button($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
        
-        if ($button_params->mode == 'popup') {
-            $rel = (isset($button_params->layout) && $button_params->layout != '')?"facebox_".$button_params->layout:"facebox";
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="'.$rel.'" title="Edit" ="small"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
+		if ($button_params->mode == 'popup') {
+			$rel = (isset($button_params->layout) && $button_params->layout != '')?"facebox_".$button_params->layout:"facebox";
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="'.$rel.'" title="Edit" ="small"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
             
-        }else if(strpos($link,'customer_edit') !== false){
-        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Edit"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
-        }else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Edit"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
-        }
-    }
-
-    /**
+		}else if(strpos($link,'customer_edit') !== false){
+		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Edit"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
+		}else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Edit"><i class="fa fa-pencil-square-o fa-fw"></i></a>&nbsp;';
+		}
+	}
+
+	/**
       For Edit on Account number or name
-     **/
-    function build_custome_edit_button($button_params, $field, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if(isset($button_params->layout)){
+	 **/
+	function build_custome_edit_button($button_params, $field, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if(isset($button_params->layout)){
 			if ($button_params->mode == 'popup') {
 				return '<a href="' . $link . '" style="cursor:pointer;color:#005298;" rel="facebox_medium" title="Update">' . $field . '</a>&nbsp;';
 			} else {
@@ -879,258 +879,258 @@ 
 				return '<a href="' . $link . '" style="cursor:pointer;color:#005298;" title="Edit">' . $field . '</a>&nbsp;';
 			}
 		}
-    }
-
-    /************************************ */
-
-    function build_edit_button_restore($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if ($button_params->mode == 'popup') {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Restore" onClick="return get_alert_msg();"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        } else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Restore" onClick="return get_alert_msg_restore();"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        }
-    }
-
-    function build_delete_button($url, $linkid) {
-        $flag='0';
-        $data=  explode("/",$url);
-        $link = base_url() . $url . "" . $linkid;
-        foreach($data as $key=>$value){
-            if($value == 'price_delete')
-                $flag = '1';
-            if($value == 'trunk_remove')
-                $flag='2';
-            if($value == 'customer_delete' ||$value =='provider_delete')
-                $flag='3';
-            if($value == 'reseller_delete')
-                $flag='4';
-            }    
-            if($flag=='1'){
-                $where=array('pricelist_id'=>$linkid,'deleted !=' =>'1');
-                $customer_cnt=$this->get_field_count('id','accounts',$where);
-                    $where=array('pricelist_id'=>$linkid);
-                    $rategroup_cnt=$this->get_field_count('id','routes',$where);
-                    if($rategroup_cnt > 0 || $customer_cnt > 0 ){
+	}
+
+	/************************************ */
+
+	function build_edit_button_restore($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if ($button_params->mode == 'popup') {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Restore" onClick="return get_alert_msg();"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		} else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Restore" onClick="return get_alert_msg_restore();"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		}
+	}
+
+	function build_delete_button($url, $linkid) {
+		$flag='0';
+		$data=  explode("/",$url);
+		$link = base_url() . $url . "" . $linkid;
+		foreach($data as $key=>$value){
+			if($value == 'price_delete')
+				$flag = '1';
+			if($value == 'trunk_remove')
+				$flag='2';
+			if($value == 'customer_delete' ||$value =='provider_delete')
+				$flag='3';
+			if($value == 'reseller_delete')
+				$flag='4';
+			}    
+			if($flag=='1'){
+				$where=array('pricelist_id'=>$linkid,'deleted !=' =>'1');
+				$customer_cnt=$this->get_field_count('id','accounts',$where);
+					$where=array('pricelist_id'=>$linkid);
+					$rategroup_cnt=$this->get_field_count('id','routes',$where);
+					if($rategroup_cnt > 0 || $customer_cnt > 0 ){
                         
-                        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message('.$rategroup_cnt.','.$customer_cnt.','.$linkid.',1);"><i class="fa fa-trash fa-fw"></i></a>';
-                    }
-                    else{
-                        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
-                    }
-            }
-            if($flag=='2'){
-                $where=array('trunk_id'=>$linkid);
-                $trunk_cnt=$this->get_field_count('id','outbound_routes',$where);
-                if($trunk_cnt > 0){
-                    return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message('.$trunk_cnt.',null,'.$linkid.',2);"><i class="fa fa-trash fa-fw"></i></a>';
-                }
-                else{
-                    return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
-                }
-            }
-            if($flag == '3'){
+						return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message('.$rategroup_cnt.','.$customer_cnt.','.$linkid.',1);"><i class="fa fa-trash fa-fw"></i></a>';
+					}
+					else{
+						return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
+					}
+			}
+			if($flag=='2'){
+				$where=array('trunk_id'=>$linkid);
+				$trunk_cnt=$this->get_field_count('id','outbound_routes',$where);
+				if($trunk_cnt > 0){
+					return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message('.$trunk_cnt.',null,'.$linkid.',2);"><i class="fa fa-trash fa-fw"></i></a>';
+				}
+				else{
+					return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
+				}
+			}
+			if($flag == '3'){
 		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message(0,null,'.$linkid.',3);">
 		<i class="fa fa-trash fa-fw"></i></a>';
-            }
-            if($flag == '4'){
+			}
+			if($flag == '4'){
 		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_message(0,null,'.$linkid.',4);">
 		<i class="fa fa-trash fa-fw"></i></a>';
-            }
-            if($flag=='0' && $url.$linkid !='accounts/admin_delete/1' ){
-                return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
-            }  
-    }
-
-    function build_view_button($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if ($button_params->mode == 'popup') {
+			}
+			if($flag=='0' && $url.$linkid !='accounts/admin_delete/1' ){
+				return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Delete" onClick="return get_alert_msg();"><i class="fa fa-trash fa-fw"></i></a>';
+			}  
+	}
+
+	function build_view_button($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if ($button_params->mode == 'popup') {
 			$rel = (isset($button_params->layout) && $button_params->layout != '')?"facebox_".$button_params->layout:"facebox";
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="'.$rel.'" title="View Details"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        } else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="View Details"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        }
-    }
-
-    function build_add_taxes_button($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if ($button_params->mode == 'popup') {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Add Account Taxes"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        } else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Add Account Taxes"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
-        }
-    }
-
-    function build_add_download_database_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm "  title="Download Database" ><i class="fa-fw fa fa-file-archive-o"></i></a>&nbsp;';
-    }
-
-    function build_add_callerid_button($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if ($button_params->mode == 'popup') {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Force Caller Id"><i class="fa fa-mobile-phone fa-fw"></i></a>&nbsp;';
-        } else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="CallerID"><i class="fa fa-mobile-phone fa-fw"></i></a>&nbsp;';
-        }
-    }
-
-    function build_start_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-
-        return '<a href="' . $link . '" class=""  title="Start" style="text-decoration:none;color: #428BCA;"><b>Start |</b></a>&nbsp;';
-    }
-
-    function build_stop_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class=""  title="Stop" style="text-decoration:none;color: #428BCA;" ><b>Stop |</b></a>&nbsp;';
-    }
-
-    function build_reload_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class=""  title="reload" style="text-decoration:none;color: #428BCA;"><b>Reload |</b></a>&nbsp;';
-    }
-
-    function build_rescan_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class=""  title="rescan" style="text-decoration:none;color: #428BCA;"><b>Rescan</b></a>&nbsp;';
-    }
-
-    function build_add_payment_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Refill" ><i class="fa fa-usd fa-fw"></i></a>&nbsp;';
-    }
-
-    function build_add_download_button($url, $linkid) {
-        $link = base_url() . $url . "" . $linkid;
-        return '<a href="' . $link . '" class="btn btn-royelblue btn-sm"  title="Download Invoice" ><i class="fa fa-cloud-download fa-fw"></i></a>&nbsp;';
-    }
-
-    /*
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="'.$rel.'" title="View Details"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		} else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="View Details"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		}
+	}
+
+	function build_add_taxes_button($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if ($button_params->mode == 'popup') {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Add Account Taxes"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		} else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Add Account Taxes"><i class="fa fa-reorder fa-fw"></i></a>&nbsp;';
+		}
+	}
+
+	function build_add_download_database_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm "  title="Download Database" ><i class="fa-fw fa fa-file-archive-o"></i></a>&nbsp;';
+	}
+
+	function build_add_callerid_button($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if ($button_params->mode == 'popup') {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Force Caller Id"><i class="fa fa-mobile-phone fa-fw"></i></a>&nbsp;';
+		} else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="CallerID"><i class="fa fa-mobile-phone fa-fw"></i></a>&nbsp;';
+		}
+	}
+
+	function build_start_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+
+		return '<a href="' . $link . '" class=""  title="Start" style="text-decoration:none;color: #428BCA;"><b>Start |</b></a>&nbsp;';
+	}
+
+	function build_stop_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class=""  title="Stop" style="text-decoration:none;color: #428BCA;" ><b>Stop |</b></a>&nbsp;';
+	}
+
+	function build_reload_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class=""  title="reload" style="text-decoration:none;color: #428BCA;"><b>Reload |</b></a>&nbsp;';
+	}
+
+	function build_rescan_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class=""  title="rescan" style="text-decoration:none;color: #428BCA;"><b>Rescan</b></a>&nbsp;';
+	}
+
+	function build_add_payment_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Refill" ><i class="fa fa-usd fa-fw"></i></a>&nbsp;';
+	}
+
+	function build_add_download_button($url, $linkid) {
+		$link = base_url() . $url . "" . $linkid;
+		return '<a href="' . $link . '" class="btn btn-royelblue btn-sm"  title="Download Invoice" ><i class="fa fa-cloud-download fa-fw"></i></a>&nbsp;';
+	}
+
+	/*
      * Purpose : Add following for resent icon
      * Version 2.1
      */
 
-    function build_edit_button_resend($button_params, $linkid) {
-        $link = base_url() . $button_params->url . "" . $linkid;
-        if ($button_params->mode == 'popup') {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Resend Mail"><i class="fa fa-repeat"></i></a>&nbsp;';
-        } else {
-            return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Resend Mail"><i class="fa fa-repeat"></i></a>&nbsp;';
-        }
-    }
+	function build_edit_button_resend($button_params, $linkid) {
+		$link = base_url() . $button_params->url . "" . $linkid;
+		if ($button_params->mode == 'popup') {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" rel="facebox" title="Resend Mail"><i class="fa fa-repeat"></i></a>&nbsp;';
+		} else {
+			return '<a href="' . $link . '" class="btn btn-royelblue btn-sm" title="Resend Mail"><i class="fa fa-repeat"></i></a>&nbsp;';
+		}
+	}
 
-    /*
+	/*
      * ----------------------------------------------------------------------------
      */
 
-    function get_only_numeric_val($select = "", $table = "", $string) {
-        return filter_var($string, FILTER_SANITIZE_NUMBER_INT);
-    }
+	function get_only_numeric_val($select = "", $table = "", $string) {
+		return filter_var($string, FILTER_SANITIZE_NUMBER_INT);
+	}
 
-    function mail_to_users($type, $accountinfo, $attachment = "", $amount = "") {
+	function mail_to_users($type, $accountinfo, $attachment = "", $amount = "") {
 		$subject = "";
-        $settings_reply_email = 'astpp@astpp.com';
-        $reseller_id=$accountinfo['reseller_id'] > 0 ? $accountinfo['reseller_id'] : 0;
+		$settings_reply_email = 'astpp@astpp.com';
+		$reseller_id=$accountinfo['reseller_id'] > 0 ? $accountinfo['reseller_id'] : 0;
 		$where="accountid IN ('".$reseller_id."','1')";
-        $this->CI->db->where($where);
-        $this->CI->db->select('emailaddress');
-        $this->CI->db->order_by('accountid', 'desc');
-        $this->CI->db->limit(1);
-        $invoiceconf = $this->CI->db->get('invoice_conf');
-        $invoiceconf = (array)$invoiceconf->first_row();
-        $settings_reply_email=$invoiceconf['emailaddress'];
-        $company_name=Common_model::$global_config['system_config']['company_name'];
-        $company_website=Common_model::$global_config['system_config']['company_website'];
-        $where = array('name' => $type);
-        $query = $this->CI->db_model->getSelect("*", "default_templates", $where);
-        $query = $query->result();
-        $message = $query[0]->template;
-        $useremail = $accountinfo['email'];
-        $message = html_entity_decode($message);
-        $message = str_replace("#COMPANY_EMAIL#", $settings_reply_email, $message);
-        $message = str_replace("#COMPANY_NAME#", $company_name, $message);
-        $message = str_replace("#COMPANY_WEBSITE#", $company_website, $message);
-        $message = str_replace("</p>", "", $message);
+		$this->CI->db->where($where);
+		$this->CI->db->select('emailaddress');
+		$this->CI->db->order_by('accountid', 'desc');
+		$this->CI->db->limit(1);
+		$invoiceconf = $this->CI->db->get('invoice_conf');
+		$invoiceconf = (array)$invoiceconf->first_row();
+		$settings_reply_email=$invoiceconf['emailaddress'];
+		$company_name=Common_model::$global_config['system_config']['company_name'];
+		$company_website=Common_model::$global_config['system_config']['company_website'];
+		$where = array('name' => $type);
+		$query = $this->CI->db_model->getSelect("*", "default_templates", $where);
+		$query = $query->result();
+		$message = $query[0]->template;
+		$useremail = $accountinfo['email'];
+		$message = html_entity_decode($message);
+		$message = str_replace("#COMPANY_EMAIL#", $settings_reply_email, $message);
+		$message = str_replace("#COMPANY_NAME#", $company_name, $message);
+		$message = str_replace("#COMPANY_WEBSITE#", $company_website, $message);
+		$message = str_replace("</p>", "", $message);
 		if(isset($accountinfo['refill_amount']) && $accountinfo['refill_amount']!= ""){
 			$refillamount = $accountinfo['refill_amount'];
 		}else{
 			$refillamount = "0";
 		}
 		
-        switch ($type) {
-            case 'email_add_user':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#NUMBER#', $accountinfo['number'], $message);
-                $message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
-                $message = str_replace('#LINK#', $accountinfo['confirm'], $message);
-                break;
-            case 'email_forgot_user':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#NUMBER#', $accountinfo['number'], $message);
-                $message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
-                $message = str_replace('#LINK#', $accountinfo['link'], $message);
-                break;
-
-            case 'email_forgot_confirmation':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#CONFIRM#', $accountinfo['confirm'], $message);
-                break;
-
-            case 'email_signup_confirmation':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#CONFIRM#', $accountinfo['confirm'], $message);
-                break;
-            case 'add_sip_device':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#USERNAME#', $accountinfo['number'], $message);
-                $message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
-                break;
+		switch ($type) {
+			case 'email_add_user':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#NUMBER#', $accountinfo['number'], $message);
+				$message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
+				$message = str_replace('#LINK#', $accountinfo['confirm'], $message);
+				break;
+			case 'email_forgot_user':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#NUMBER#', $accountinfo['number'], $message);
+				$message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
+				$message = str_replace('#LINK#', $accountinfo['link'], $message);
+				break;
+
+			case 'email_forgot_confirmation':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#CONFIRM#', $accountinfo['confirm'], $message);
+				break;
+
+			case 'email_signup_confirmation':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#CONFIRM#', $accountinfo['confirm'], $message);
+				break;
+			case 'add_sip_device':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#USERNAME#', $accountinfo['number'], $message);
+				$message = str_replace('#PASSWORD#', $accountinfo['password'], $message);
+				break;
                               
-            case 'voip_account_refilled':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#REFILLBALANCE#', $accountinfo['refill_amount'], $message);
-                $message = str_replace('#BALANCE#', $accountinfo['refill_amount'] + $accountinfo['balance'], $message);
-                break;
-            case 'voip_child_account_refilled':
-                $reseller_number= $this->CI->common->get_field_name('number', 'accounts', $accountinfo['reseller_id']);
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#REFILLBALANCE#', $accountinfo['refill_amount'], $message);
-                $message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
-                $message = str_replace('#ACCOUNTNUMBER#',$reseller_number, $message);
-                break;
-            case 'add_subscription':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                break;
-            case 'remove_subscription':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                break;
-            case 'add_package':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                break;
-            case 'remove_package':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                break;
-            case 'email_calling_card':
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#CARDNUMBER#', $accountinfo['cardnumber'], $message);
-                $message = str_replace('#PIN#', $accountinfo['pin'], $message);
-                $message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
-                break;
-            case 'email_low_balance';
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $to_currency = $this->CI->common->get_field_name('currency', 'currency', $accountinfo['currency_id']);
-                $balance = $this->CI->common_model->calculate_currency($accountinfo['balance'], "", $to_currency, true, true);
-                $message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
-                break;
-            case 'email_new_invoice';
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#AMOUNT#', $amount, $message);
-                $message = str_replace('#INVOICE_NUMBER#', $amount, $message);
-                $subject = $query[0]->subject;
-                $subject = str_replace("#INVOICE_NUMBER#", $amount, $subject);
-                break;
-             case 'email_add_did';
+			case 'voip_account_refilled':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#REFILLBALANCE#', $accountinfo['refill_amount'], $message);
+				$message = str_replace('#BALANCE#', $accountinfo['refill_amount'] + $accountinfo['balance'], $message);
+				break;
+			case 'voip_child_account_refilled':
+				$reseller_number= $this->CI->common->get_field_name('number', 'accounts', $accountinfo['reseller_id']);
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#REFILLBALANCE#', $accountinfo['refill_amount'], $message);
+				$message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
+				$message = str_replace('#ACCOUNTNUMBER#',$reseller_number, $message);
+				break;
+			case 'add_subscription':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				break;
+			case 'remove_subscription':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				break;
+			case 'add_package':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				break;
+			case 'remove_package':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				break;
+			case 'email_calling_card':
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#CARDNUMBER#', $accountinfo['cardnumber'], $message);
+				$message = str_replace('#PIN#', $accountinfo['pin'], $message);
+				$message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
+				break;
+			case 'email_low_balance';
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$to_currency = $this->CI->common->get_field_name('currency', 'currency', $accountinfo['currency_id']);
+				$balance = $this->CI->common_model->calculate_currency($accountinfo['balance'], "", $to_currency, true, true);
+				$message = str_replace('#BALANCE#', $accountinfo['balance'], $message);
+				break;
+			case 'email_new_invoice';
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#AMOUNT#', $amount, $message);
+				$message = str_replace('#INVOICE_NUMBER#', $amount, $message);
+				$subject = $query[0]->subject;
+				$subject = str_replace("#INVOICE_NUMBER#", $amount, $subject);
+				break;
+			 case 'email_add_did';
 				if(isset($accountinfo['did_maxchannels']) && $accountinfo['did_maxchannels']!= ""){
 					$accountinfo['did_maxchannels'] = $accountinfo['did_maxchannels'];
 				}else if($accountinfo['did_maxchannels'] == "0"){
@@ -1138,758 +1138,758 @@ 
 				}else{
 					$accountinfo['did_maxchannels'] = "Unlimited";
 				}
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#DIDNUMBER#', $accountinfo['did_number'] , $message);
-                $message = str_replace('#COUNTRYNAME#',$accountinfo['did_country_id'], $message);
-                $message = str_replace('#SETUPFEE#',$accountinfo['did_setup'], $message);
-                $message = str_replace('#MONTHLYFEE#',$accountinfo['did_monthlycost'], $message);
-                $message = str_replace('#MAXCHANNEL#',$accountinfo['did_maxchannels'], $message);
-                $message = str_replace('#NUMBER#', $accountinfo['number'], $message);	
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#DIDNUMBER#', $accountinfo['did_number'] , $message);
+				$message = str_replace('#COUNTRYNAME#',$accountinfo['did_country_id'], $message);
+				$message = str_replace('#SETUPFEE#',$accountinfo['did_setup'], $message);
+				$message = str_replace('#MONTHLYFEE#',$accountinfo['did_monthlycost'], $message);
+				$message = str_replace('#MAXCHANNEL#',$accountinfo['did_maxchannels'], $message);
+				$message = str_replace('#NUMBER#', $accountinfo['number'], $message);	
 				$subject = $query[0]->subject;
 				$subject = str_replace("#NUMBER#", $accountinfo['number'], $subject);
 				$subject = str_replace("#DIDNUMBER#", $accountinfo['did_number'], $subject);
-                break;
-            case 'email_remove_did';
-                $message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
-                $message = str_replace('#DIDNUMBER#', $accountinfo['did_number'],$message);
-                $message = str_replace('#NUMBER#', $accountinfo['number'], $message);	
+				break;
+			case 'email_remove_did';
+				$message = str_replace('#NAME#', $accountinfo['first_name'] . " " . $accountinfo['last_name'], $message);
+				$message = str_replace('#DIDNUMBER#', $accountinfo['did_number'],$message);
+				$message = str_replace('#NUMBER#', $accountinfo['number'], $message);	
 				$subject = $query[0]->subject;
 				$subject = str_replace("#NUMBER#", $accountinfo['number'], $subject);
 				$subject = str_replace("#DIDNUMBER#", $accountinfo['did_number'], $subject);
-                break;
-        }
+				break;
+		}
         
-        if($subject == ""){
+		if($subject == ""){
 			$subject = $query[0]->subject;
 			$subject = str_replace("#NAME#", $accountinfo['first_name'] . " " . $accountinfo['last_name'], $subject);
 			$subject = str_replace("#COMPANY_NAME#", $company_name, $subject);	
 		}
-        $account_id = (isset($accountinfo['last_id']) && $accountinfo['last_id'] != "") ? $accountinfo['last_id'] : $accountinfo['id'];
-        $reseller_id = $accountinfo['reseller_id'];
-        if ($reseller_id != "0") {
-            $reseller_result = $this->CI->db_model->getSelect("email", "accounts", array("id" => $reseller_id));
-            $reseller_info = (array)$reseller_result->first_row();
-            $settings_reply_email = $reseller_info['email'];
-        }
-        $this->emailFunction($settings_reply_email, $useremail, $subject, $message, $company_name, $attachment, $account_id, $reseller_id);
-
-    }
-
-    function emailFunction($from, $to, $subject, $message, $company_name = "", $attachment = "", $account_id, $reseller_id) {
-        $send_mail_details = array('from' => $from,
-            'to' => $to,
-            'subject' => $subject,
-            'body' => $message,
-            'accountid' => $account_id,
-            'status' => '1',
-            'attachment' => $attachment,
-            'reseller_id' => $reseller_id,
-        );
+		$account_id = (isset($accountinfo['last_id']) && $accountinfo['last_id'] != "") ? $accountinfo['last_id'] : $accountinfo['id'];
+		$reseller_id = $accountinfo['reseller_id'];
+		if ($reseller_id != "0") {
+			$reseller_result = $this->CI->db_model->getSelect("email", "accounts", array("id" => $reseller_id));
+			$reseller_info = (array)$reseller_result->first_row();
+			$settings_reply_email = $reseller_info['email'];
+		}
+		$this->emailFunction($settings_reply_email, $useremail, $subject, $message, $company_name, $attachment, $account_id, $reseller_id);
+
+	}
+
+	function emailFunction($from, $to, $subject, $message, $company_name = "", $attachment = "", $account_id, $reseller_id) {
+		$send_mail_details = array('from' => $from,
+			'to' => $to,
+			'subject' => $subject,
+			'body' => $message,
+			'accountid' => $account_id,
+			'status' => '1',
+			'attachment' => $attachment,
+			'reseller_id' => $reseller_id,
+		);
                 
-        $this->CI->db->insert('mail_details', $send_mail_details);
-        return $this->CI->db->insert_id();
-    }
+		$this->CI->db->insert('mail_details', $send_mail_details);
+		return $this->CI->db->insert_id();
+	}
 
-    /*
+	/*
       convert GMT id 0000 condition
      */
 
-    function convert_GMT_to($select = "", $table = "", $date) {
-        if ($date == '0000-00-00 00:00:00') {
-            return $date;
-        } else {
-            return $this->CI->timezone->display_GMT($date);
-        }
-    }
-
-    function convert_GMT($date) {
-        return $this->CI->timezone->convert_to_GMT($select = "", $table = "", $date);
-    }
-
-    function convert_to_ucfirst($select = "", $table = "", $str_value) {
-        return ucfirst($str_value);
-    }
-
-    function set_charge_type($status = '') {
-        $status_array = array('1' => 'Accounts', '2' => 'Rate Group');
-        return $status_array;
-    }
-
-    function build_concat_string($select, $table, $id_where = '') {
-        $select_params = explode(',', $select);
-        $where = array("1");
-        if ($id_where != '') {
-            $where = array("id" => $id_where);
-        }
-        $select_params = explode(',', $select);
-        if (isset($select_params[3])) {
-            $cnt_str = " $select_params[0],' ',$select_params[1],' ','(',$select_params[2],')' ";
-        } else {
-            $cnt_str = " $select_params[0],' (',$select_params[1],')' ";
-        }
-        $select = "concat($cnt_str) as $select_params[0] ";
-        $drp_array = $this->CI->db_model->getSelect($select, $table, $where);
-        $drp_array = $drp_array->result();
-        if (isset($drp_array[0]))
-            return $drp_array[0]->$select_params[0];
-    }
-
-    /* 
+	function convert_GMT_to($select = "", $table = "", $date) {
+		if ($date == '0000-00-00 00:00:00') {
+			return $date;
+		} else {
+			return $this->CI->timezone->display_GMT($date);
+		}
+	}
+
+	function convert_GMT($date) {
+		return $this->CI->timezone->convert_to_GMT($select = "", $table = "", $date);
+	}
+
+	function convert_to_ucfirst($select = "", $table = "", $str_value) {
+		return ucfirst($str_value);
+	}
+
+	function set_charge_type($status = '') {
+		$status_array = array('1' => 'Accounts', '2' => 'Rate Group');
+		return $status_array;
+	}
+
+	function build_concat_string($select, $table, $id_where = '') {
+		$select_params = explode(',', $select);
+		$where = array("1");
+		if ($id_where != '') {
+			$where = array("id" => $id_where);
+		}
+		$select_params = explode(',', $select);
+		if (isset($select_params[3])) {
+			$cnt_str = " $select_params[0],' ',$select_params[1],' ','(',$select_params[2],')' ";
+		} else {
+			$cnt_str = " $select_params[0],' (',$select_params[1],')' ";
+		}
+		$select = "concat($cnt_str) as $select_params[0] ";
+		$drp_array = $this->CI->db_model->getSelect($select, $table, $where);
+		$drp_array = $drp_array->result();
+		if (isset($drp_array[0]))
+			return $drp_array[0]->$select_params[0];
+	}
+
+	/* 
      * Change invoice_total to invoice details 
      */
 
-    function get_invoice_total($select = '', $table = '', $id) {
-        $where_arr = array('invoiceid' => $id, 'item_type <>' => "FREE");
-        $this->CI->db->where($where_arr);
-        $this->CI->db->select('*');
-        $result = $this->CI->db->get('invoice_details');
-        if ($result->num_rows() > 0) {
-            $result = $result->result_array();
-	    if($select == 'debit'){
+	function get_invoice_total($select = '', $table = '', $id) {
+		$where_arr = array('invoiceid' => $id, 'item_type <>' => "FREE");
+		$this->CI->db->where($where_arr);
+		$this->CI->db->select('*');
+		$result = $this->CI->db->get('invoice_details');
+		if ($result->num_rows() > 0) {
+			$result = $result->result_array();
+		if($select == 'debit'){
 		if($result[0]['item_type'] == 'POSTCHARG'){
-	            return $this->convert_to_currency('', '', $result[0]['debit']);
+				return $this->convert_to_currency('', '', $result[0]['debit']);
 		}else{
-	            return $this->convert_to_currency('', '', $result[0]['credit']);
+				return $this->convert_to_currency('', '', $result[0]['credit']);
 		}
-	    }else{
+		}else{
 		   return $result[0][$select];
-	    }
-        } else {
-            return null;
-        }
-    }
-
-    function get_array($select, $table_name, $where = false) {
-        $new_array = array();
-        $select_params = array();
-        $select_params = explode(",", $select);
-        if (isset($select_params[3])) {
-            $cnt_str = " $select_params[1],'(',$select_params[2],' ',$select_params[3],')' ";
-            $select = "concat($cnt_str) as $select_params[3] ";
-            $field_name = $select_params[3];
-        } elseif (isset($select_params[2])) {
-            $cnt_str = " $select_params[1],' ','(',$select_params[2],')' ";
-            $select = "concat($cnt_str) as $select_params[2] ";
-            $field_name = $select_params[2];
-        } else {
-            $select = $select_params[1];
-            $field_name = $select_params[1];
-        }
-        if ($where) {
-            $this->CI->db->where($where);
-        }
-        $this->CI->db->select("$select_params[0],$select", false);
-        $result = $this->CI->db->get($table_name);
-        foreach ($result->result_array() as $key => $value) {
-            $new_array[$value[$select_params[0]]] = $value[$field_name];
-        }
-        ksort($new_array);
-        return $new_array;
-    }
-
-    function get_timezone_offset() {
-        $gmtoffset = 0;
-        $accountinfo = $this->CI->session->userdata('accountinfo');
-        $account_result = $this->CI->db->get_where('accounts', array('id' => $accountinfo['id']));
-        $account_result = $account_result->result_array();
-        $accountinfo = $account_result[0];
-        $timezone_id_arr = array($accountinfo['timezone_id']);
-        $this->CI->db->where_in('id', $timezone_id_arr);
-        $this->CI->db->select('gmtoffset');
-        $this->CI->db->from('timezone');
-        $timezone_result = $this->CI->db->get();
-        if ($timezone_result->num_rows() > 0) {
-
-            $timezone_result = $timezone_result->result_array();
-            foreach ($timezone_result as $data) {
-                $gmtoffset+=$data['gmtoffset'];
-            }
-        }
+		}
+		} else {
+			return null;
+		}
+	}
+
+	function get_array($select, $table_name, $where = false) {
+		$new_array = array();
+		$select_params = array();
+		$select_params = explode(",", $select);
+		if (isset($select_params[3])) {
+			$cnt_str = " $select_params[1],'(',$select_params[2],' ',$select_params[3],')' ";
+			$select = "concat($cnt_str) as $select_params[3] ";
+			$field_name = $select_params[3];
+		} elseif (isset($select_params[2])) {
+			$cnt_str = " $select_params[1],' ','(',$select_params[2],')' ";
+			$select = "concat($cnt_str) as $select_params[2] ";
+			$field_name = $select_params[2];
+		} else {
+			$select = $select_params[1];
+			$field_name = $select_params[1];
+		}
+		if ($where) {
+			$this->CI->db->where($where);
+		}
+		$this->CI->db->select("$select_params[0],$select", false);
+		$result = $this->CI->db->get($table_name);
+		foreach ($result->result_array() as $key => $value) {
+			$new_array[$value[$select_params[0]]] = $value[$field_name];
+		}
+		ksort($new_array);
+		return $new_array;
+	}
+
+	function get_timezone_offset() {
+		$gmtoffset = 0;
+		$accountinfo = $this->CI->session->userdata('accountinfo');
+		$account_result = $this->CI->db->get_where('accounts', array('id' => $accountinfo['id']));
+		$account_result = $account_result->result_array();
+		$accountinfo = $account_result[0];
+		$timezone_id_arr = array($accountinfo['timezone_id']);
+		$this->CI->db->where_in('id', $timezone_id_arr);
+		$this->CI->db->select('gmtoffset');
+		$this->CI->db->from('timezone');
+		$timezone_result = $this->CI->db->get();
+		if ($timezone_result->num_rows() > 0) {
+
+			$timezone_result = $timezone_result->result_array();
+			foreach ($timezone_result as $data) {
+				$gmtoffset+=$data['gmtoffset'];
+			}
+		}
 // 	  echo $gmtoffset;exit;
-        return $gmtoffset;
-    }
-    /** Version 2.1
-     * Purpose : Set default data for new created profile
-     * */
-    function sip_profile_date() {
-        $defualt_profile_data = '{"rtp_ip":"$${local_ip_v4}","dialplan":"XML","user-agent-string":"ASTPP","debug":"0","sip-trace":"no","tls":"false","inbound-reg-force-matching-username":"true","disable-transcoding":"true","all-reg-options-ping":"false","unregister-on-options-fail":"true","log-auth-failures":"true","status":"0","inbound-bypass-media":"false","inbound-proxy-media":"false","disable-transfer":"true","enable-100rel":"false","rtp-timeout-sec":"60","dtmf-duration":"2000","manual-redirect":"false","aggressive-nat-detection":"false","enable-timer":"false","minimum-session-expires":"120","session-timeout-pt":"1800","auth-calls":"true","apply-inbound-acl":"default","inbound-codec-prefs":"PCMU,PCMA,G729","outbound-codec-prefs":"PCMU,PCMA,G729","inbound-late-negotiation":"false"}';
-        return $defualt_profile_data;
-    }
+		return $gmtoffset;
+	}
+	/** Version 2.1
+	 * Purpose : Set default data for new created profile
+	 * */
+	function sip_profile_date() {
+		$defualt_profile_data = '{"rtp_ip":"$${local_ip_v4}","dialplan":"XML","user-agent-string":"ASTPP","debug":"0","sip-trace":"no","tls":"false","inbound-reg-force-matching-username":"true","disable-transcoding":"true","all-reg-options-ping":"false","unregister-on-options-fail":"true","log-auth-failures":"true","status":"0","inbound-bypass-media":"false","inbound-proxy-media":"false","disable-transfer":"true","enable-100rel":"false","rtp-timeout-sec":"60","dtmf-duration":"2000","manual-redirect":"false","aggressive-nat-detection":"false","enable-timer":"false","minimum-session-expires":"120","session-timeout-pt":"1800","auth-calls":"true","apply-inbound-acl":"default","inbound-codec-prefs":"PCMU,PCMA,G729","outbound-codec-prefs":"PCMU,PCMA,G729","inbound-late-negotiation":"false"}';
+		return $defualt_profile_data;
+	}
 
-    /* ===================================================================== */
-    /*
+	/* ===================================================================== */
+	/*
      * Purpose : Add following for mass mail and mail history
      * Version 2.1
      */
 
-    function set_search_temp($select = '') {
-        $status_array = array("0" => "--Select--",
-            "1" => "Voip account refilled",
-            "3" => "Email add user",
-            "4" => "Add sip device",
-            "8" => "Email add did",
-            "9" => "Email remove did",
-            "10" => "Email new invoice",
-            "11" => "Email low balance",
-            "12" => "Email signup confirmation",
-            "13" => "Password successfully changed",
-            "14" => "Reset your password",
-            "15" => "Email add subscription",
-            "16" => "Email remove subscription",
-            "17" => "Email add package",
-            "18" => "Email remove package",
-            "19" => "Voip child accont refilled",
-        );
-        return $status_array;
-    }
-
-    /*     ***
+	function set_search_temp($select = '') {
+		$status_array = array("0" => "--Select--",
+			"1" => "Voip account refilled",
+			"3" => "Email add user",
+			"4" => "Add sip device",
+			"8" => "Email add did",
+			"9" => "Email remove did",
+			"10" => "Email new invoice",
+			"11" => "Email low balance",
+			"12" => "Email signup confirmation",
+			"13" => "Password successfully changed",
+			"14" => "Reset your password",
+			"15" => "Email add subscription",
+			"16" => "Email remove subscription",
+			"17" => "Email add package",
+			"18" => "Email remove package",
+			"19" => "Voip child accont refilled",
+		);
+		return $status_array;
+	}
+
+	/*     ***
       Refill coupon dropdown
      * ** */
 
-    function set_refill_coupon_status($select = '', $table = '', $status = '') {
-        $refill_coupon_array = array("" => "--Select--", '2' => 'Yes', '0' => 'No');
-        return $refill_coupon_array;
-    }
+	function set_refill_coupon_status($select = '', $table = '', $status = '') {
+		$refill_coupon_array = array("" => "--Select--", '2' => 'Yes', '0' => 'No');
+		return $refill_coupon_array;
+	}
 
-    function get_refill_coupon_status($select = '', $table = '', $status) {
-        $refill_coupon_array = array('0' => 'Inactive', '1' => 'Active', '2' => 'Inuse', "3" => "Expired");
-        return $refill_coupon_array[$status];
-    }
+	function get_refill_coupon_status($select = '', $table = '', $status) {
+		$refill_coupon_array = array('0' => 'Inactive', '1' => 'Active', '2' => 'Inuse', "3" => "Expired");
+		return $refill_coupon_array[$status];
+	}
 
-    function firstused_check($select = '', $table = '', $status) {
+	function firstused_check($select = '', $table = '', $status) {
 
-        if ($status == '0000-00-00 00:00:00') {
-            return '-';
-        }
-        return $status;
-    }
+		if ($status == '0000-00-00 00:00:00') {
+			return '-';
+		}
+		return $status;
+	}
 
-    function get_refill_coupon_used($select = '', $table = '', $status) {
-        return $status['status'] == 2 ? '<img src= "'.base_url().'assets/images/true.png" style="height:20px;width:20px;" title="Yes">' : '<img src= "'. base_url().'/assets/images/false.png" style="height:20px;width:20px;" title="No">';
-    }
+	function get_refill_coupon_used($select = '', $table = '', $status) {
+		return $status['status'] == 2 ? '<img src= "'.base_url().'assets/images/true.png" style="height:20px;width:20px;" title="Yes">' : '<img src= "'. base_url().'/assets/images/false.png" style="height:20px;width:20px;" title="No">';
+	}
 
-    /*     * *******
+	/*     * *******
       Password encode decode
      * ******* */
 
-    function encode_params($string) {
-        $data = base64_encode($string);
-        $data = str_replace(array('+', '/', '='), array('-', '$', ''), $data);
-        return $data;
-    }
-
-    function encode($value) {
-        $text = $value;
-        $iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB);
-        $iv = mcrypt_create_iv($iv_size, MCRYPT_RAND);
-        $crypttext = mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $this->CI->config->item('private_key'), $text, MCRYPT_MODE_ECB, $iv);
-        return trim($this->encode_params($crypttext));
-    }
-
-    function decode_params($string) {
-        $data = str_replace(array('-', '$'), array('+', '/'), $string);
-        $mod4 = strlen($data) % 4;
-        if ($mod4) {
-            $data .= substr('====', $mod4);
-        }
-        return base64_decode($data);
-    }
-
-    function decode($value) {
-        $crypttext = $this->decode_params($value);
-        $iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB);
-        $iv = mcrypt_create_iv($iv_size, MCRYPT_RAND);
-        $decrypttext = mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $this->CI->config->item('private_key'), $crypttext, MCRYPT_MODE_ECB, $iv);
-        return trim($decrypttext);
-    }
-
-    /******
+	function encode_params($string) {
+		$data = base64_encode($string);
+		$data = str_replace(array('+', '/', '='), array('-', '$', ''), $data);
+		return $data;
+	}
+
+	function encode($value) {
+		$text = $value;
+		$iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB);
+		$iv = mcrypt_create_iv($iv_size, MCRYPT_RAND);
+		$crypttext = mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $this->CI->config->item('private_key'), $text, MCRYPT_MODE_ECB, $iv);
+		return trim($this->encode_params($crypttext));
+	}
+
+	function decode_params($string) {
+		$data = str_replace(array('-', '$'), array('+', '/'), $string);
+		$mod4 = strlen($data) % 4;
+		if ($mod4) {
+			$data .= substr('====', $mod4);
+		}
+		return base64_decode($data);
+	}
+
+	function decode($value) {
+		$crypttext = $this->decode_params($value);
+		$iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB);
+		$iv = mcrypt_create_iv($iv_size, MCRYPT_RAND);
+		$decrypttext = mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $this->CI->config->item('private_key'), $crypttext, MCRYPT_MODE_ECB, $iv);
+		return trim($decrypttext);
+	}
+
+	/******
       Recording enable/disable dropdown
      * ** */
 
-    function set_recording($status = '') {
-        $status_array = array('0' => 'On', '1' => 'Off',);
-        return $status_array;
-    }
+	function set_recording($status = '') {
+		$status_array = array('0' => 'On', '1' => 'Off',);
+		return $status_array;
+	}
 
-    /*     * ************************** */
+	/*     * ************************** */
 
-    function email_status($select = "", $table = "", $status) {
-        $status = ($status['status'] == 0) ? "Sent" : "Not Sent";
+	function email_status($select = "", $table = "", $status) {
+		$status = ($status['status'] == 0) ? "Sent" : "Not Sent";
 	return $status;    
-    }
+	}
 
-    function email_search_status($select = '') {
-        $status_array = array("" => "--Select--",
-            "0" => "Sent",
-            "1" => "Not Sent"
-        );
-        return $status_array;
-    }
+	function email_search_status($select = '') {
+		$status_array = array("" => "--Select--",
+			"0" => "Sent",
+			"1" => "Not Sent"
+		);
+		return $status_array;
+	}
 
-    /* ===================================================================== */
+	/* ===================================================================== */
 
 
-    /*
+	/*
      * Purpose : Add following for setting page
      * Version 2.1
      */
 
-    function paypal_status($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
-    function playback_audio_notification($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
-    function custom_status($status){
+	function paypal_status($status = '') {
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
+	function playback_audio_notification($status = '') {
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
+	function custom_status($status){
 		$status_array = array('0' => 'Yes', '1' => 'No');
-        return $status_array;
-    }
+		return $status_array;
+	}
     
-    function custom_status_active($status){
-      $status_array = array('0' => 'Active', '1' => 'InActive');
-      return $status_array;
-    }
-    function custom_status_true($status){
-      $status_array = array('0' => 'TRUE', '1' => 'FALSE');
-      return $status_array;
-    }
-    function custom_status_voicemail($status){
-      $status_array = array('true' => 'True', 'false' => 'False');
-      return $status_array;
-    }
-
-    /******
+	function custom_status_active($status){
+	  $status_array = array('0' => 'Active', '1' => 'InActive');
+	  return $status_array;
+	}
+	function custom_status_true($status){
+	  $status_array = array('0' => 'TRUE', '1' => 'FALSE');
+	  return $status_array;
+	}
+	function custom_status_voicemail($status){
+	  $status_array = array('true' => 'True', 'false' => 'False');
+	  return $status_array;
+	}
+
+	/******
       For enable Signup module
      * */
-    function create_sipdevice($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
+	function create_sipdevice($status = '') {
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
 
-    function enable_signup($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
+	function enable_signup($status = '') {
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
 
 	function balance_announce($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
 	function minutes_announce($status = '') {
-        $status_array = array('0' => 'Enable', '1' => 'Disable');
-        return $status_array;
-    }
+		$status_array = array('0' => 'Enable', '1' => 'Disable');
+		return $status_array;
+	}
 	
-    function enable_disable_option(){
-        $option_array = array('0' => 'Enable', '1' => 'Disable');
-        return $option_array;
-    }
-
-    function paypal_mode($status = '') {
-        $status_array = array('0' => 'Live', '1' => 'Sandbox',);
-        return $status_array;
-    }
-
-    function paypal_fee($status = '') {
-        $status_array = array('0' => 'Paid By Admin', '1' => 'Paid By Customer',);
-        return $status_array;
-    }
-
-    function email() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable',);
-        return $status_array;
-    }
-
-    function smtp() {
-        return $this->set_allow();
-    }
-
-    function debug() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable',);
-        return $status_array;
-    }
-    function default_signup_rategroup(){
-        $this->CI->db->select("id,name");
-        $this->CI->db->where("status",0);
-        $this->CI->db->where("reseller_id",0);
-        $pricelist_result=$this->CI->db->get("pricelists")->result_array();
-        $pricelist_arr=array();
-        foreach($pricelist_result as $result){
-            $pricelist_arr[$result['id']]=$result['name'];
-        }
-        return $pricelist_arr;
+	function enable_disable_option(){
+		$option_array = array('0' => 'Enable', '1' => 'Disable');
+		return $option_array;
+	}
+
+	function paypal_mode($status = '') {
+		$status_array = array('0' => 'Live', '1' => 'Sandbox',);
+		return $status_array;
+	}
+
+	function paypal_fee($status = '') {
+		$status_array = array('0' => 'Paid By Admin', '1' => 'Paid By Customer',);
+		return $status_array;
+	}
+
+	function email() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable',);
+		return $status_array;
+	}
+
+	function smtp() {
+		return $this->set_allow();
+	}
+
+	function debug() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable',);
+		return $status_array;
+	}
+	function default_signup_rategroup(){
+		$this->CI->db->select("id,name");
+		$this->CI->db->where("status",0);
+		$this->CI->db->where("reseller_id",0);
+		$pricelist_result=$this->CI->db->get("pricelists")->result_array();
+		$pricelist_arr=array();
+		foreach($pricelist_result as $result){
+			$pricelist_arr[$result['id']]=$result['name'];
+		}
+		return $pricelist_arr;
         
-    }
-    /******
+	}
+	/******
       Enable Fax feature
      * */
-    function outbound_fax() {
-        $status_array = array('0' => 'Enable', '1' => 'Disable',);
-        return $status_array;
-    }
-
-    function inbound_fax() {
-        $status_array = array('0' => 'Enable', '1' => 'Disable',);
-        return $status_array;
-    }
-
-
-    function opensips() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function cc_ani_auth() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function calling_cards_balance_announce() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function calling_cards_timelimit_announce() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function calling_cards_rate_announce() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function startingdigit() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function SMPT() {
-        $status_array = array('1' => 'Enable', '0' => 'Disable');
-        return $status_array;
-    }
-
-    function country() {
-        return $this->CI->common_model->get_country_list();
-    }
-
-    function default_timezone() {
-        return $this->CI->db_model->build_dropdown('id,gmtzone', 'timezone');
-    }
-
-    function timezone() {
-        return $this->CI->db_model->build_dropdown('gmttime,gmttime', 'timezone');
-    }
-
-    function base_currency() {
-        return $this->CI->db_model->build_dropdown('currency,currencyname', 'currency');
-    }
-
-    /******	
+	function outbound_fax() {
+		$status_array = array('0' => 'Enable', '1' => 'Disable',);
+		return $status_array;
+	}
+
+	function inbound_fax() {
+		$status_array = array('0' => 'Enable', '1' => 'Disable',);
+		return $status_array;
+	}
+
+
+	function opensips() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function cc_ani_auth() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function calling_cards_balance_announce() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function calling_cards_timelimit_announce() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function calling_cards_rate_announce() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function startingdigit() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function SMPT() {
+		$status_array = array('1' => 'Enable', '0' => 'Disable');
+		return $status_array;
+	}
+
+	function country() {
+		return $this->CI->common_model->get_country_list();
+	}
+
+	function default_timezone() {
+		return $this->CI->db_model->build_dropdown('id,gmtzone', 'timezone');
+	}
+
+	function timezone() {
+		return $this->CI->db_model->build_dropdown('gmttime,gmttime', 'timezone');
+	}
+
+	function base_currency() {
+		return $this->CI->db_model->build_dropdown('currency,currencyname', 'currency');
+	}
+
+	/******	
       Calculate Currency manually.
      */
 
-    function calculate_currency_manually($currency_info, $amount, $show_currency_flag = true,$number_format=true) {
-        $decimal_points = $currency_info['decimalpoints'];
-        $system_currency_rate = $currency_info['base_currency']['currencyrate'];
-        $user_currency_rate = $currency_info['user_currency']['currencyrate'];
-        $calculated_amount=(float)(($amount * $currency_info['user_currency']['currencyrate']) / $currency_info['base_currency']['currencyrate']); 
-        if($number_format){
-         $calculated_amount = number_format($calculated_amount,$currency_info['decimalpoints']);
-        }
-        if ($show_currency_flag){
-          return $calculated_amount." ".$currency_info['user_currency']['currency'];
-        }else{
-          return $calculated_amount;
-        }
-    }
-
-    /*
+	function calculate_currency_manually($currency_info, $amount, $show_currency_flag = true,$number_format=true) {
+		$decimal_points = $currency_info['decimalpoints'];
+		$system_currency_rate = $currency_info['base_currency']['currencyrate'];
+		$user_currency_rate = $currency_info['user_currency']['currencyrate'];
+		$calculated_amount=(float)(($amount * $currency_info['user_currency']['currencyrate']) / $currency_info['base_currency']['currencyrate']); 
+		if($number_format){
+		 $calculated_amount = number_format($calculated_amount,$currency_info['decimalpoints']);
+		}
+		if ($show_currency_flag){
+		  return $calculated_amount." ".$currency_info['user_currency']['currency'];
+		}else{
+		  return $calculated_amount;
+		}
+	}
+
+	/*
       Using By Summary Report search
      */
 
-    function search_report_in($select = '') {
-        $status_array = array("minutes" => "Minutes", "seconds" => "Seconds");
-        return $status_array;
-    }
-
-    function set_summarycustomer_groupby($status = '') {
-        $status_array = array('' => "--Select--", 'accountid' => 'Account', 'pattern' => 'Code','package_id'=>"Package");
-        return $status_array;
-    }
-
-    function set_summaryprovider_groupby($status = '') {
-        $status_array = array('' => "--Select--", 'provider_id' => 'Account', 'trunk_id' => "Trunks", 'pattern' => 'Code');
-        return $status_array;
-    }
-
-    function get_currency_info() {
-        //System Currency info 
-        $base_currency = Common_model::$global_config['system_config']['base_currency'];
-        //Get Account Information from session to get currency_id
-        $accountinfo = $this->CI->session->userdata('accountinfo');
-        //Get User Currency id 
-        $user_currency_id = $accountinfo['currency_id'] > 0 ? $accountinfo['currency_id'] : $base_currency;
-        $where = "currency = '" . $base_currency . "' OR id= " . $user_currency_id;
-        $this->CI->db->where($where);
-        $this->CI->db->select('*');
-        $currency_result = $this->CI->db->get('currency');
-
-        if ($currency_result->num_rows() == 2) {
-            $currency_result = $currency_result->result_array();
-            foreach ($currency_result as $key => $records) {
-                //User Currency is currency details of logged in user.
-                if ($records['id'] == $user_currency_id) {
-                    $currency_info['user_currency'] = $records;
-                }
-                //System Currency is currency details of system.
-                if ($records['currency'] == Common_model::$global_config['system_config']['base_currency']) {
-                    $currency_info['base_currency'] = $records;
-                }
-            }
-        } else if ($currency_result->num_rows() == 1) {
-            $currency_info['user_currency'] = $currency_info['base_currency'] = (array) $currency_result->first_row();
-        }
-        //Get Decimal points as per defined from system.
-        $currency_info['decimalpoints'] = Common_model::$global_config['system_config']['decimalpoints'];
-        return $currency_info;
-    }
-
-    function convert_to_show_in($search_name = "", $table = "", $second) {
-        $search_arr = $this->CI->session->userdata($search_name);
-        $show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
-        return ($show_seconds === 'minutes') ? ($second > 0 ) ?
-                        sprintf('%02d',$second / 60) . ":" . sprintf('%02d', ($second % 60)) : "00:00"  : sprintf('%02d', $second);
-    }
-
-    function array_column($input, $columnKey, $indexKey = null) {
-        $array = array();
-        foreach ($input as $value) {
-            if (!isset($value[$columnKey])) {
-                trigger_error("Key \"$columnKey\" does not exist in array");
-                return false;
-            }
-
-            if (is_null($indexKey)) {
-                $array[] = $value[$columnKey];
-            } else {
-                if (!isset($value[$indexKey])) {
-                    trigger_error("Key \"$indexKey\" does not exist in array");
-                    return false;
-                }
-                if (!is_scalar($value[$indexKey])) {
-                    trigger_error("Key \"$indexKey\" does not contain scalar value");
-                    return false;
-                }
-                $array[$value[$indexKey]] = $value[$columnKey];
-            }
-        }
-
-        return $array;
-    }
-
-    function group_by_time() {
-        $status_array = array('' => "--Select--", 'HOUR' => 'Hour', 'DAY' => "Day", 'MONTH' => 'Month', "YEAR" => "Year");
-        return $status_array;
-    }
-
-    function currency_decimal($amount) {
+	function search_report_in($select = '') {
+		$status_array = array("minutes" => "Minutes", "seconds" => "Seconds");
+		return $status_array;
+	}
+
+	function set_summarycustomer_groupby($status = '') {
+		$status_array = array('' => "--Select--", 'accountid' => 'Account', 'pattern' => 'Code','package_id'=>"Package");
+		return $status_array;
+	}
+
+	function set_summaryprovider_groupby($status = '') {
+		$status_array = array('' => "--Select--", 'provider_id' => 'Account', 'trunk_id' => "Trunks", 'pattern' => 'Code');
+		return $status_array;
+	}
+
+	function get_currency_info() {
+		//System Currency info 
+		$base_currency = Common_model::$global_config['system_config']['base_currency'];
+		//Get Account Information from session to get currency_id
+		$accountinfo = $this->CI->session->userdata('accountinfo');
+		//Get User Currency id 
+		$user_currency_id = $accountinfo['currency_id'] > 0 ? $accountinfo['currency_id'] : $base_currency;
+		$where = "currency = '" . $base_currency . "' OR id= " . $user_currency_id;
+		$this->CI->db->where($where);
+		$this->CI->db->select('*');
+		$currency_result = $this->CI->db->get('currency');
+
+		if ($currency_result->num_rows() == 2) {
+			$currency_result = $currency_result->result_array();
+			foreach ($currency_result as $key => $records) {
+				//User Currency is currency details of logged in user.
+				if ($records['id'] == $user_currency_id) {
+					$currency_info['user_currency'] = $records;
+				}
+				//System Currency is currency details of system.
+				if ($records['currency'] == Common_model::$global_config['system_config']['base_currency']) {
+					$currency_info['base_currency'] = $records;
+				}
+			}
+		} else if ($currency_result->num_rows() == 1) {
+			$currency_info['user_currency'] = $currency_info['base_currency'] = (array) $currency_result->first_row();
+		}
+		//Get Decimal points as per defined from system.
+		$currency_info['decimalpoints'] = Common_model::$global_config['system_config']['decimalpoints'];
+		return $currency_info;
+	}
+
+	function convert_to_show_in($search_name = "", $table = "", $second) {
+		$search_arr = $this->CI->session->userdata($search_name);
+		$show_seconds = (!empty($search_arr['search_in'])) ? $search_arr['search_in'] : 'minutes';
+		return ($show_seconds === 'minutes') ? ($second > 0 ) ?
+						sprintf('%02d',$second / 60) . ":" . sprintf('%02d', ($second % 60)) : "00:00"  : sprintf('%02d', $second);
+	}
+
+	function array_column($input, $columnKey, $indexKey = null) {
+		$array = array();
+		foreach ($input as $value) {
+			if (!isset($value[$columnKey])) {
+				trigger_error("Key \"$columnKey\" does not exist in array");
+				return false;
+			}
+
+			if (is_null($indexKey)) {
+				$array[] = $value[$columnKey];
+			} else {
+				if (!isset($value[$indexKey])) {
+					trigger_error("Key \"$indexKey\" does not exist in array");
+					return false;
+				}
+				if (!is_scalar($value[$indexKey])) {
+					trigger_error("Key \"$indexKey\" does not contain scalar value");
+					return false;
+				}
+				$array[$value[$indexKey]] = $value[$columnKey];
+			}
+		}
+
+		return $array;
+	}
+
+	function group_by_time() {
+		$status_array = array('' => "--Select--", 'HOUR' => 'Hour', 'DAY' => "Day", 'MONTH' => 'Month', "YEAR" => "Year");
+		return $status_array;
+	}
+
+	function currency_decimal($amount) {
 		$amount = str_replace( ',', '', $amount );
-        $decimal_amount = Common_model::$global_config['system_config']['decimalpoints'];
-        $number_convert = number_format((float) $amount, $decimal_amount, '.', '');
-        return $number_convert;
-    }
-
-    function add_invoice_details($account_arr, $charge_type, $amount,$description) {
-        $accountinfo = $this->CI->session->userdata('accountinfo');
-        $reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;
-        $where = "accountid IN ('" . $reseller_id . "','1')";
-        $this->CI->db->where($where);
-        $this->CI->db->select('*');
-        $this->CI->db->order_by('accountid', 'desc');
-        $this->CI->db->limit(1);
-        $invoiceconf = $this->CI->db->get('invoice_conf');
-        $invoice_conf = (array) $invoiceconf->first_row();
-        $last_invoiceid = $this->get_invoice_date('invoiceid', '', $account_arr['reseller_id']);
-        if ($last_invoiceid && $last_invoiceid > 0) {
-            $last_invoiceid = ($last_invoiceid + 1);
-        } else {
-            $last_invoiceid = $invoice_conf['invoice_start_from'];
-        }
-        $last_invoiceid = str_pad($last_invoiceid, (strlen($last_invoiceid) + 4), '0', STR_PAD_LEFT);
-        $invoice_prefix = $invoice_conf['invoice_prefix'];
-        $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoice_conf['interval'] . " days"));
-        $invoiceid = $account_arr['posttoexternal'] == 0 ? $this->CI->common_model->generate_receipt($account_arr['id'], $amount, $account_arr, $last_invoiceid, $invoice_prefix, $due_date) : 0;
+		$decimal_amount = Common_model::$global_config['system_config']['decimalpoints'];
+		$number_convert = number_format((float) $amount, $decimal_amount, '.', '');
+		return $number_convert;
+	}
+
+	function add_invoice_details($account_arr, $charge_type, $amount,$description) {
+		$accountinfo = $this->CI->session->userdata('accountinfo');
+		$reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0;
+		$where = "accountid IN ('" . $reseller_id . "','1')";
+		$this->CI->db->where($where);
+		$this->CI->db->select('*');
+		$this->CI->db->order_by('accountid', 'desc');
+		$this->CI->db->limit(1);
+		$invoiceconf = $this->CI->db->get('invoice_conf');
+		$invoice_conf = (array) $invoiceconf->first_row();
+		$last_invoiceid = $this->get_invoice_date('invoiceid', '', $account_arr['reseller_id']);
+		if ($last_invoiceid && $last_invoiceid > 0) {
+			$last_invoiceid = ($last_invoiceid + 1);
+		} else {
+			$last_invoiceid = $invoice_conf['invoice_start_from'];
+		}
+		$last_invoiceid = str_pad($last_invoiceid, (strlen($last_invoiceid) + 4), '0', STR_PAD_LEFT);
+		$invoice_prefix = $invoice_conf['invoice_prefix'];
+		$due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoice_conf['interval'] . " days"));
+		$invoiceid = $account_arr['posttoexternal'] == 0 ? $this->CI->common_model->generate_receipt($account_arr['id'], $amount, $account_arr, $last_invoiceid, $invoice_prefix, $due_date) : 0;
         
-        $insert_arr = array("accountid" => $account_arr['id'],
-            "description" => $description,
-            "debit" => $amount,
-            "credit" => '0',
-            "created_date" => gmdate("Y-m-d H:i:s"),
-            "invoiceid" => $invoiceid,
-            "reseller_id" => $account_arr['reseller_id'],
-            "item_type" => $charge_type,
-            "item_id" => '0',
-        );
-        $this->CI->db->insert("invoice_details", $insert_arr);
-        return true;
-    }
-    /* ASTPP  3.0  Remove all information related to going to delete customer.
+		$insert_arr = array("accountid" => $account_arr['id'],
+			"description" => $description,
+			"debit" => $amount,
+			"credit" => '0',
+			"created_date" => gmdate("Y-m-d H:i:s"),
+			"invoiceid" => $invoiceid,
+			"reseller_id" => $account_arr['reseller_id'],
+			"item_type" => $charge_type,
+			"item_id" => '0',
+		);
+		$this->CI->db->insert("invoice_details", $insert_arr);
+		return true;
+	}
+	/* ASTPP  3.0  Remove all information related to going to delete customer.
      */
-    function customer_delete_dependencies($id){
-          $this->delete_data('ani_map',array('accountid'=>$id));
-          $this->delete_data('block_patterns',array('accountid'=>$id));
-          $this->delete_data('charge_to_account',array('accountid'=>$id));
-          $this->delete_data('counters',array('accountid'=>$id));
-          $this->delete_data('ip_map',array('accountid'=>$id));
-          $this->delete_data('sip_devices',array('accountid'=>$id));
-          $this->delete_data('speed_dial',array('accountid'=>$id));
-          $this->delete_data('taxes_to_accounts',array('accountid'=>$id));
-          $this->delete_data('mail_details',array('accountid'=>$id));
-          $this->update_data('dids',array("accountid"=>$id),array('accountid'=>0));
-          $this->update_data("accounts",array("id"=>$id),array("deleted"=>1));
-    }
-    /*
+	function customer_delete_dependencies($id){
+		  $this->delete_data('ani_map',array('accountid'=>$id));
+		  $this->delete_data('block_patterns',array('accountid'=>$id));
+		  $this->delete_data('charge_to_account',array('accountid'=>$id));
+		  $this->delete_data('counters',array('accountid'=>$id));
+		  $this->delete_data('ip_map',array('accountid'=>$id));
+		  $this->delete_data('sip_devices',array('accountid'=>$id));
+		  $this->delete_data('speed_dial',array('accountid'=>$id));
+		  $this->delete_data('taxes_to_accounts',array('accountid'=>$id));
+		  $this->delete_data('mail_details',array('accountid'=>$id));
+		  $this->update_data('dids',array("accountid"=>$id),array('accountid'=>0));
+		  $this->update_data("accounts",array("id"=>$id),array("deleted"=>1));
+	}
+	/*
      *  ASTPP  3.0 
      *  Remove all information related to going to delete reseller.
      */
-    function reseller_delete_dependencies($id){
-        $accountinfo=$this->CI->session->userdata('accountinfo');
-        $child_arr=$this->select_data("accounts",array("reseller_id"=>$id,"type"=>0),'id,reseller_id');
-        if($child_arr){
-            foreach($child_arr as $value){
-                $this->customer_delete_dependencies($value['id']);
-            }
-        }
-        $package_arr=$this->select_data("packages",array("reseller_id"=>$id),'id');
-        if($package_arr){
-            foreach($package_arr as $value){
-                $this->delete_data('package_patterns',array("id"=>$value['id']));
-            }
-        }
-        $acc_arr=$this->select_data('accounts',array("id"=>$id),'id,reseller_id');
-        $parent_id=0;
-        if($acc_arr){
-            $parent_id=$acc_arr[0]['reseller_id'];
-        }
-        $pricelist_arr=$this->select_data('pricelists',array('reseller_id'=>$id),'id');
-        if($pricelist_arr){
-             foreach($pricelist_arr as $value){
-                $this->delete_data("routing",array("pricelist_id"=>$value['id']));
-                $this->delete_data("routes",array("pricelist_id"=>$value['id']));
-                $this->update_data('pricelists',array('id'=>$value['id']),array('status'=>2));         
-             }
-        }
-        $charge_arr=$this->select_data('charges',array('reseller_id'=>$id),'id');
-        if($charge_arr){
-             foreach($charge_arr as $value){
-                $this->delete_data("charge_to_account",array("charge_id"=>$value['id']));
-             }
-        }
-        $this->delete_data('charges',array('reseller_id'=>$id));
-        $this->update_data('dids',array('parent_id'=>$id),array("parent_id"=>$parent_id));
-        $this->delete_data('reseller_pricing',array("reseller_id"=>$id));
-        $this->delete_data('refill_coupon',array("reseller_id"=>$id));
-        $this->delete_data('mail_details',array('accountid'=>$id));
-        $taxes_arr=$this->select_data('taxes',array("reseller_id"=>$id),'id');
-        if($taxes_arr){
-             foreach($taxes_arr as $value){
-                $this->delete_data("taxes_to_accounts",array("taxes_id"=>$value['id']));
-             }
-        }
-        $this->delete_data('taxes',array("reseller_id"=>$id));
-        $this->delete_data('default_templates',array("reseller_id"=>$id));
-        $package_arr=$this->select_data('packages',array('reseller_id'=>$id),'id');
-        if($package_arr){
-            $this->delete_data("counters",array("package_id"=>$value['id']));
-            $this->delete_data("package_patterns",array("package_id"=>$value['id']));
-        }
-        $this->delete_data('invoice_conf',array('accountid'=>$id));
-        $this->delete_data('packages',array("reseller_id"=>$id));
-        $this->update_data('accounts',array("id"=>$id),array("deleted"=>1));
-    }
-    function subreseller_list($parent_id = '') {
-        $customer_id = $parent_id;
-        $this->reseller_delete_dependencies($parent_id);
-        $query = 'select id,type from accounts where reseller_id = ' . $parent_id .' AND deleted =0';
-        $result = $this->CI->db->query($query);
-        if ($result->num_rows() > 0) {
-            $result = $result->result_array();
-            foreach ($result as $data) {
-	      if($data['type']==1){
+	function reseller_delete_dependencies($id){
+		$accountinfo=$this->CI->session->userdata('accountinfo');
+		$child_arr=$this->select_data("accounts",array("reseller_id"=>$id,"type"=>0),'id,reseller_id');
+		if($child_arr){
+			foreach($child_arr as $value){
+				$this->customer_delete_dependencies($value['id']);
+			}
+		}
+		$package_arr=$this->select_data("packages",array("reseller_id"=>$id),'id');
+		if($package_arr){
+			foreach($package_arr as $value){
+				$this->delete_data('package_patterns',array("id"=>$value['id']));
+			}
+		}
+		$acc_arr=$this->select_data('accounts',array("id"=>$id),'id,reseller_id');
+		$parent_id=0;
+		if($acc_arr){
+			$parent_id=$acc_arr[0]['reseller_id'];
+		}
+		$pricelist_arr=$this->select_data('pricelists',array('reseller_id'=>$id),'id');
+		if($pricelist_arr){
+			 foreach($pricelist_arr as $value){
+				$this->delete_data("routing",array("pricelist_id"=>$value['id']));
+				$this->delete_data("routes",array("pricelist_id"=>$value['id']));
+				$this->update_data('pricelists',array('id'=>$value['id']),array('status'=>2));         
+			 }
+		}
+		$charge_arr=$this->select_data('charges',array('reseller_id'=>$id),'id');
+		if($charge_arr){
+			 foreach($charge_arr as $value){
+				$this->delete_data("charge_to_account",array("charge_id"=>$value['id']));
+			 }
+		}
+		$this->delete_data('charges',array('reseller_id'=>$id));
+		$this->update_data('dids',array('parent_id'=>$id),array("parent_id"=>$parent_id));
+		$this->delete_data('reseller_pricing',array("reseller_id"=>$id));
+		$this->delete_data('refill_coupon',array("reseller_id"=>$id));
+		$this->delete_data('mail_details',array('accountid'=>$id));
+		$taxes_arr=$this->select_data('taxes',array("reseller_id"=>$id),'id');
+		if($taxes_arr){
+			 foreach($taxes_arr as $value){
+				$this->delete_data("taxes_to_accounts",array("taxes_id"=>$value['id']));
+			 }
+		}
+		$this->delete_data('taxes',array("reseller_id"=>$id));
+		$this->delete_data('default_templates',array("reseller_id"=>$id));
+		$package_arr=$this->select_data('packages',array('reseller_id'=>$id),'id');
+		if($package_arr){
+			$this->delete_data("counters",array("package_id"=>$value['id']));
+			$this->delete_data("package_patterns",array("package_id"=>$value['id']));
+		}
+		$this->delete_data('invoice_conf',array('accountid'=>$id));
+		$this->delete_data('packages',array("reseller_id"=>$id));
+		$this->update_data('accounts',array("id"=>$id),array("deleted"=>1));
+	}
+	function subreseller_list($parent_id = '') {
+		$customer_id = $parent_id;
+		$this->reseller_delete_dependencies($parent_id);
+		$query = 'select id,type from accounts where reseller_id = ' . $parent_id .' AND deleted =0';
+		$result = $this->CI->db->query($query);
+		if ($result->num_rows() > 0) {
+			$result = $result->result_array();
+			foreach ($result as $data) {
+		  if($data['type']==1){
 		  $this->reseller_delete_dependencies($data['id']);
 		  $this->subreseller_list($data['id']);
-	      }else{
+		  }else{
 		  $this->customer_delete_dependencies($data['id']);
-	      }
-            }
-        }
-    }
+		  }
+			}
+		}
+	}
     
-    function delete_data($table_name,$where_arr){
-        $this->CI->db->where($where_arr);
-        $this->CI->db->delete($table_name);
-    }
-    function update_data($table_name,$where_arr,$update_arr){
-        $this->CI->db->where($where_arr);
-        $this->CI->db->update($table_name,$update_arr);
-    }
-    function select_data($table_name,$where_arr,$select){
-        $this->CI->db->where($where_arr);
-        $this->CI->db->select($select);
-        $result=$this->CI->db->get($table_name);
-        if($result->num_rows() > 0){
-            return $result->result_array();
-        }else{
-            return false;
-        }
-    }
+	function delete_data($table_name,$where_arr){
+		$this->CI->db->where($where_arr);
+		$this->CI->db->delete($table_name);
+	}
+	function update_data($table_name,$where_arr,$update_arr){
+		$this->CI->db->where($where_arr);
+		$this->CI->db->update($table_name,$update_arr);
+	}
+	function select_data($table_name,$where_arr,$select){
+		$this->CI->db->where($where_arr);
+		$this->CI->db->select($select);
+		$result=$this->CI->db->get($table_name);
+		if($result->num_rows() > 0){
+			return $result->result_array();
+		}else{
+			return false;
+		}
+	}
     
-    function set_call_waiting($status = '') {
+	function set_call_waiting($status = '') {
 		$status_array = array('0' => 'Enable', '1' => 'Disable');
 		return $status_array;
 	} 
-    function get_call_waiting($select = "", $table = "", $status) {
-        return ($status == 0) ? "Enable" : "Disable";
+	function get_call_waiting($select = "", $table = "", $status) {
+		return ($status == 0) ? "Enable" : "Disable";
 	}
   function set_invoice_details($select= ''){
-        $status_array = array("invoice_select" => "--Select--",
-            "invoice_inactive" => "Deleted Invoices",
-            "invoice_active" => "All Invoices",
-        );
-        return $status_array;
+		$status_array = array("invoice_select" => "--Select--",
+			"invoice_inactive" => "Deleted Invoices",
+			"invoice_active" => "All Invoices",
+		);
+		return $status_array;
 }
 function get_invoice_template($invoicedata,$accountdata,$flag){
-      $login_info = $this->CI->session->userdata('accountinfo');
-
-      $invoice_config = $this->CI->db_model->getSelect("*", "invoice_conf", array('accountid'=>$login_info['id']));
-      $invoice_config= $invoice_config->result_array();
-      $invoice_config_res= $invoice_config[0];
-
-      $accountdata["currency_id"] = $this->get_field_name('currency', 'currency', $accountdata["currency_id"]);
-      $accountdata["country"] = $this->get_field_name('country', 'countrycode', $accountdata["country_id"]);
-      $data["to_currency"] = Common_model::$global_config['system_config']['base_currency'];
-      if($login_info['type'] == -1){
-          $currency = $data["to_currency"];
-      }elseif($login_info['type'] == 1){
+	  $login_info = $this->CI->session->userdata('accountinfo');
+
+	  $invoice_config = $this->CI->db_model->getSelect("*", "invoice_conf", array('accountid'=>$login_info['id']));
+	  $invoice_config= $invoice_config->result_array();
+	  $invoice_config_res= $invoice_config[0];
+
+	  $accountdata["currency_id"] = $this->get_field_name('currency', 'currency', $accountdata["currency_id"]);
+	  $accountdata["country"] = $this->get_field_name('country', 'countrycode', $accountdata["country_id"]);
+	  $data["to_currency"] = Common_model::$global_config['system_config']['base_currency'];
+	  if($login_info['type'] == -1){
+		  $currency = $data["to_currency"];
+	  }elseif($login_info['type'] == 1){
 	  $accountdata["currency_id"] = $this->get_field_name('currency', 'currency', $login_info["currency_id"]);
-          $currency = $accountdata["currency_id"];
-      }else{
-          $currency = $accountdata["currency_id"];
-      }
-      $decimal_amount=Common_model::$global_config['system_config']['decimalpoints'];
-      ob_start();
-      $this->CI->load->library('/html2pdf/html2pdf');
-      $this->CI->html2pdf = new HTML2PDF('P','A4','en');
-      $this->CI->html2pdf->pdf->SetDisplayMode('fullpage');
-      $template_config=$this->CI->config->item('invoice_template');
-      include($template_config.'invoice_template.php');
-      $content = ob_get_clean();
-      ob_clean();
+		  $currency = $accountdata["currency_id"];
+	  }else{
+		  $currency = $accountdata["currency_id"];
+	  }
+	  $decimal_amount=Common_model::$global_config['system_config']['decimalpoints'];
+	  ob_start();
+	  $this->CI->load->library('/html2pdf/html2pdf');
+	  $this->CI->html2pdf = new HTML2PDF('P','A4','en');
+	  $this->CI->html2pdf->pdf->SetDisplayMode('fullpage');
+	  $template_config=$this->CI->config->item('invoice_template');
+	  include($template_config.'invoice_template.php');
+	  $content = ob_get_clean();
+	  ob_clean();
 
 	$ACCOUNTADD = '';
 	$ACCOUNTADD_CUSTOMER ='';
@@ -1912,57 +1912,57 @@ 
 	$due_date =date("Y-m-d",$duedate);
 
 /*************************** Company Address Code START ***************************************************/
-        $ACCOUNTADD .= '<tr>';
-        $ACCOUNTADD .= '<td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>'.$invoice_config_res['company_name'].'</b></td>';
-        $ACCOUNTADD .= '</tr>';
+		$ACCOUNTADD .= '<tr>';
+		$ACCOUNTADD .= '<td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>'.$invoice_config_res['company_name'].'</b></td>';
+		$ACCOUNTADD .= '</tr>';
 	if ( $invoice_config_res['address'] != ""){
 
-        $ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['address'].'</td></tr>';
-    }
+		$ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['address'].'</td></tr>';
+	}
 	if ( $invoice_config_res['city'] != ""){
 
-        $ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['city'].'</td></tr>';
-    }
+		$ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['city'].'</td></tr>';
+	}
 	if ( $invoice_config_res['province'] != ""){
 
-        $ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['province'].'</td></tr>';
-    }
+		$ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['province'].'</td></tr>';
+	}
 	if ( $invoice_config_res['country'] != ""){
 
-        $ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['country'].'</td></tr>';
-    }
+		$ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['country'].'</td></tr>';
+	}
 	if ( $invoice_config_res['zipcode'] != ""){
 
-        $ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['zipcode'].'</td></tr>';
-    }
+		$ACCOUNTADD .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$invoice_config_res['zipcode'].'</td></tr>';
+	}
 /*************************** Company Address Code END ***************************************************/
 
 /*************************** Customer Address Code START ***************************************************/
 
-        $ACCOUNTADD_CUSTOMER .= '<table><tr>';
-        $ACCOUNTADD_CUSTOMER .= '<td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>'.$accountdata['company_name'].'</b></td></tr>';
+		$ACCOUNTADD_CUSTOMER .= '<table><tr>';
+		$ACCOUNTADD_CUSTOMER .= '<td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>'.$accountdata['company_name'].'</b></td></tr>';
 
 	if ( $accountdata['address_1'] != ""){
 
-        $ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['address_1'].'</td></tr>';
-    }
+		$ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['address_1'].'</td></tr>';
+	}
 	if ( $accountdata['city'] != ""){
 
-        $ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['city'].'</td></tr>';
-    }
+		$ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['city'].'</td></tr>';
+	}
 	if ( $accountdata['province'] != ""){
 
-        $ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['province'].'</td></tr>';
-    }
+		$ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['province'].'</td></tr>';
+	}
 	if ( $accountdata['country'] != ""){
 
-        $ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['country'].'</td></tr>';
-    }
+		$ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['country'].'</td></tr>';
+	}
 	if ( $accountdata['postal_code'] != ""){
 
-        $ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['postal_code'].'</td></tr>';
-    }
-    $ACCOUNTADD_CUSTOMER .="</table>"; 
+		$ACCOUNTADD_CUSTOMER .= '<tr><td style="width:100%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$accountdata['postal_code'].'</td></tr>';
+	}
+	$ACCOUNTADD_CUSTOMER .="</table>"; 
 /*************************** Customer Address Code END ***************************************************/
 
 
@@ -1970,26 +1970,26 @@ 
 
  	$ACCOUNT_DESCRIPTION .= '<tr style="background-color:#375C7C;">';
 	$ACCOUNT_DESCRIPTION .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Date</td>';
-        $ACCOUNT_DESCRIPTION .= '<td  style="width:40%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Description</td>';
-        $ACCOUNT_DESCRIPTION .= '<td  style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Charge Type</td>';
+		$ACCOUNT_DESCRIPTION .= '<td  style="width:40%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Description</td>';
+		$ACCOUNT_DESCRIPTION .= '<td  style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Charge Type</td>';
 	$ACCOUNT_DESCRIPTION .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;text-align:right;">Amount ('.$currency .')</td>';
-        $ACCOUNT_DESCRIPTION .= '</tr>';
+		$ACCOUNT_DESCRIPTION .= '</tr>';
 
 
 	$ACCOUNT_CDRS .= '<tr style="background-color:#375C7C;">';
 	$ACCOUNT_CDRS .= '<td style="width:40%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Description</td>';
 	$ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Duration (Seconds)</td>';
-        $ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Total Calls</td>';
+		$ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;">Total Calls</td>';
 	$ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#fff;font-family:arial; line-height: 22px;text-align:right;">Amount ('.$currency .')</td>';
-        $ACCOUNT_CDRS .= '</tr>';
+		$ACCOUNT_CDRS .= '</tr>';
 
 	/*** manual invoice **/
 	$this->CI->db->where('item_type <>','INVPAY');
-        $invoice_details = $this->CI->db_model->getSelect('*', 'invoice_details',array("invoiceid"=> $invoicedata['id'],'item_type <>'=> 'TAX' ));
+		$invoice_details = $this->CI->db_model->getSelect('*', 'invoice_details',array("invoiceid"=> $invoicedata['id'],'item_type <>'=> 'TAX' ));
 	$invoice_details= $invoice_details->result_array();
 	$total_sum=0;
 	foreach($invoice_details as $charge_res){
-	    if($charge_res['item_type'] == 'DIDCHRG' || $charge_res['item_type'] == 'SUBCHRG' || $charge_res['item_type'] == 'manual_inv' ){
+		if($charge_res['item_type'] == 'DIDCHRG' || $charge_res['item_type'] == 'SUBCHRG' || $charge_res['item_type'] == 'manual_inv' ){
 		if($charge_res['item_type'] == 'manual_inv'){
 			$charge_res['item_type'] = 'Manual Invoice';
 		}
@@ -2007,10 +2007,10 @@ 
 
 		$ACCOUNT_DESCRIPTION .= '<td style="width:20%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;text-align:right;">'.$this->currency_decimal($this->CI->common_model->calculate_currency($charge_res['debit'])).'</td>';
 		$ACCOUNT_DESCRIPTION .= '</tr>';
-	     }else{
-            $cdrs_data = $this->CI->db_model->getSelect("sum(billseconds) as billseconds,count(*) as count", "cdrs", array("accountid" => $charge_res['accountid'],"calltype" => $charge_res['item_type']));
-            $cdrs_result = $cdrs_data->result_array();
-	    if($cdrs_result[0]['count'] > 0 ){
+		 }else{
+			$cdrs_data = $this->CI->db_model->getSelect("sum(billseconds) as billseconds,count(*) as count", "cdrs", array("accountid" => $charge_res['accountid'],"calltype" => $charge_res['item_type']));
+			$cdrs_result = $cdrs_data->result_array();
+		if($cdrs_result[0]['count'] > 0 ){
 		$cdrs_record_count=$cdrs_result[0]['count'] ;
 		$cdrs_record_billseconds=$cdrs_result[0]['billseconds'] ;
 /*echo '<pre>'.$cdrs_record_count;
@@ -2022,8 +2022,8 @@ 
 		$ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;">'.$cdrs_record_count.'</td>';
 		$ACCOUNT_CDRS .= '<td style="width:20%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;text-align:right;">'.$this->currency_decimal($this->CI->common_model->calculate_currency($charge_res['debit'])).'</td>';
 		$ACCOUNT_CDRS .= '</tr>';
-	     }
-	    }
+		 }
+		}
 		$total_sum += $charge_res['debit'];
 	}
 /*************************** Charge Histry Code END ***************************************************/
@@ -2031,7 +2031,7 @@ 
 /**********************************Tax Apply Start********************************************************************/
 	$total_sum = $total_sum;
 	$total_sum=$this->currency_decimal($this->CI->common_model->calculate_currency($total_sum));
-        $invoice_tax = $this->CI->db_model->getSelect('*', 'invoice_details',array("invoiceid"=> $invoicedata['id'],'item_type '=> 'TAX'));
+		$invoice_tax = $this->CI->db_model->getSelect('*', 'invoice_details',array("invoiceid"=> $invoicedata['id'],'item_type '=> 'TAX'));
  	//$ACCOUNT_TOTAL .= '<td><table style="width:100%;margin-left:360px;">';
 
 	$ACCOUNT_TOTAL .= '<tr>';
@@ -2039,7 +2039,7 @@ 
 	$ACCOUNT_TOTAL .= '<td style="width:40%;font-size: 12px;color:#000;font-family:arial; line-height: 22px;"></td>';
 //        $ACCOUNT_TOTAL .= '<td style="width:20%;font-size: 12px;color:#000;font-family:arial; line-height: 22px;"><b>Total Exclusive:</b></td>';
 //	$ACCOUNT_TOTAL .= '<td style="width:20%;font-size: 12px;color:#000;font-family:arial; line-height: 22px;text-align:right;">'.$total_sum .'</td>';
-        $ACCOUNT_TOTAL .= '</tr>';
+		$ACCOUNT_TOTAL .= '</tr>';
 
 	if($invoice_tax->num_rows() > 0 ){
 	   foreach($invoice_tax->result_array() as $invoice_tax){
@@ -2077,16 +2077,16 @@ 
 
 /*************************** Invoice Details Code START ***************************************************/
 
-        $ACCOUNTADD_RIGHT .= '<table style="width:100%;"><tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Number:</b></td>';
-        $ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$invoicedata["invoice_prefix"].$invoicedata["invoiceid"].'</td></tr>';
+		$ACCOUNTADD_RIGHT .= '<table style="width:100%;"><tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Number:</b></td>';
+		$ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$invoicedata["invoice_prefix"].$invoicedata["invoiceid"].'</td></tr>';
 
-        $ACCOUNTADD_RIGHT .= '<tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Date:</b></td>';
-        $ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$from_date.'</td></tr>';
-        $ACCOUNTADD_RIGHT .= '<tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Due Date:</b></td>';
-        $ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$due_date.'</td></tr>';
+		$ACCOUNTADD_RIGHT .= '<tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Date:</b></td>';
+		$ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$from_date.'</td></tr>';
+		$ACCOUNTADD_RIGHT .= '<tr style="width:100%;"><td style="width:40%;font-size: 12px;color:#525252;font-family:arial; line-height: 22px;"><b>Due Date:</b></td>';
+		$ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#525252;font-family:arial;text-align:right; line-height: 22px;">'.$due_date.'</td></tr>';
 
-        $ACCOUNTADD_RIGHT .= '<tr style="background-color:#375C7C;width:100%; line-height: 30px;"><td style="width:40%;font-size: 12px;color:#fff;font-family:arial; line-height: 30px;"><b>Total Due:</b></td>';
-        $ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#fff;font-family:arial;text-align:right; line-height: 30px;">'.$this->currency_decimal($sub_total).'</td></tr>';
+		$ACCOUNTADD_RIGHT .= '<tr style="background-color:#375C7C;width:100%; line-height: 30px;"><td style="width:40%;font-size: 12px;color:#fff;font-family:arial; line-height: 30px;"><b>Total Due:</b></td>';
+		$ACCOUNTADD_RIGHT .= '<td style="width:60%;font-size: 10px;color:#fff;font-family:arial;text-align:right; line-height: 30px;">'.$this->currency_decimal($sub_total).'</td></tr>';
 	$ACCOUNTADD_RIGHT .= "</table>";
 
 /*************************** Invoice Details Code END ***************************************************/
@@ -2097,8 +2097,8 @@ 
 
 
 /*************************** Invoice Note Code END ***************************************************/
-        $invoice_notes = $this->CI->db_model->getSelect('*', 'invoices', array('id'=>$invoicedata['id']));
-        $invoice_notes=$invoice_notes->result_array();
+		$invoice_notes = $this->CI->db_model->getSelect('*', 'invoices', array('id'=>$invoicedata['id']));
+		$invoice_notes=$invoice_notes->result_array();
 	if(isset($invoice_notes[0]['notes'])){
 		$invoice_notes=$invoice_notes[0]['notes'];
 	}else{
@@ -2125,106 +2125,106 @@ 
 	$ACCOUNT_TOTAL_FINAL .= '<td style="width:40%;font-size: 12px;color:#000;font-family:arial; line-height: 22px;"></td>';
 	$ACCOUNT_TOTAL_FINAL .= '</tr>';
 
-      //  $content = str_replace("<LOGO>",$image_logo,$content);   
-        $content = str_replace("<ACCOUNTADD>",$ACCOUNTADD,$content);
-        $content = str_replace("<ACCOUNTADD_CUSTOMER>",$ACCOUNTADD_CUSTOMER,$content);
-        $content = str_replace("<ACCOUNTADD_RIGHT>",$ACCOUNTADD_RIGHT,$content);
+	  //  $content = str_replace("<LOGO>",$image_logo,$content);   
+		$content = str_replace("<ACCOUNTADD>",$ACCOUNTADD,$content);
+		$content = str_replace("<ACCOUNTADD_CUSTOMER>",$ACCOUNTADD_CUSTOMER,$content);
+		$content = str_replace("<ACCOUNTADD_RIGHT>",$ACCOUNTADD_RIGHT,$content);
 	$content = str_replace("<ACCOUNT_DESCRIPTION>",$ACCOUNT_DESCRIPTION,$content);
 	$content = str_replace("<ACCOUNT_CDRS>",$ACCOUNT_CDRS,$content);
 	$content = str_replace("<ACCOUNT_TOTAL>",$ACCOUNT_TOTAL,$content);
 	$content = str_replace("<ACCOUNT_TOTAL_FINAL>",$ACCOUNT_TOTAL_FINAL,$content);
-        $content = str_replace("<NOTES>",$invoice_notes,$content);
+		$content = str_replace("<NOTES>",$invoice_notes,$content);
 
 //echo $content; exit;
 
 	$invoice_path=$this->CI->config->item('invoices_path');
 	$download_path = $invoice_path.$accountdata["id"].'/'.$invoicedata['invoice_prefix'].$invoicedata['invoiceid']."_invoice.pdf"; 
-       //echo  $download_path; exit;
-       $this->CI->html2pdf->pdf->SetDisplayMode('fullpage');
-       $this->CI->html2pdf->writeHTML($content);
+	   //echo  $download_path; exit;
+	   $this->CI->html2pdf->pdf->SetDisplayMode('fullpage');
+	   $this->CI->html2pdf->writeHTML($content);
        
-       if($flag== 'TRUE'){
-        $download_path = $invoicedata['invoice_prefix'].$invoicedata['invoiceid'].".pdf";
+	   if($flag== 'TRUE'){
+		$download_path = $invoicedata['invoice_prefix'].$invoicedata['invoiceid'].".pdf";
        
-        $this->CI->html2pdf->Output($download_path,"D");        
-       }else{
-        $current_dir = getcwd()."/invoices/";
-        $dir_name = $accountdata["id"];
-        if(!is_dir($current_dir.$dir_name)){
-                mkdir($current_dir.$dir_name,0777, true);
-                chmod($current_dir.$dir_name, 0777);        
-        }        
-        $invoice_path=$this->CI->config->item('invoices_path');
-        $download_path = $invoice_path.$accountdata["id"].'/'.$invoicedata['invoice_prefix'].$invoicedata['invoiceid']."_invoice.pdf"; 
-        $this->CI->html2pdf->Output($download_path,"F");         
-       }
+		$this->CI->html2pdf->Output($download_path,"D");        
+	   }else{
+		$current_dir = getcwd()."/invoices/";
+		$dir_name = $accountdata["id"];
+		if(!is_dir($current_dir.$dir_name)){
+				mkdir($current_dir.$dir_name,0777, true);
+				chmod($current_dir.$dir_name, 0777);        
+		}        
+		$invoice_path=$this->CI->config->item('invoices_path');
+		$download_path = $invoice_path.$accountdata["id"].'/'.$invoicedata['invoice_prefix'].$invoicedata['invoiceid']."_invoice.pdf"; 
+		$this->CI->html2pdf->Output($download_path,"F");         
+	   }
 }
-    function reseller_select_value($select, $table, $id_where = '') {
-        $select_params = explode(',', $select);
-        $where = array("1");
-        if ($id_where != '') {
-            $where = array("id" => $id_where);
-        }
-        $select_params = explode(',', $select);
-        $cnt_str = " $select_params[0],' ',$select_params[1],' ','(',$select_params[2],')' ";
-        $select = "concat($cnt_str) as $select_params[2] ";
-        $drp_array = $this->CI->db_model->getSelect($select, $table, $where);
-        $drp_array = $drp_array->result();
-        if (isset($drp_array[0]))
-            return $drp_array[0]->$select_params[2];
+	function reseller_select_value($select, $table, $id_where = '') {
+		$select_params = explode(',', $select);
+		$where = array("1");
+		if ($id_where != '') {
+			$where = array("id" => $id_where);
+		}
+		$select_params = explode(',', $select);
+		$cnt_str = " $select_params[0],' ',$select_params[1],' ','(',$select_params[2],')' ";
+		$select = "concat($cnt_str) as $select_params[2] ";
+		$drp_array = $this->CI->db_model->getSelect($select, $table, $where);
+		$drp_array = $drp_array->result();
+		if (isset($drp_array[0]))
+			return $drp_array[0]->$select_params[2];
 	else
 	   return 'Admin';
-    }
+	}
     
-    function get_subreseller_info($parent_id){
-        if(!empty($parent_id)){
+	function get_subreseller_info($parent_id){
+		if(!empty($parent_id)){
 	  $str=$parent_id.",";
-        }else{
-          $str=null;
-        }
-        $query = "select id from accounts where reseller_id = '$parent_id' AND deleted =0 AND type=1";
-        $result = $this->CI->db->query($query);
-        if($result->num_rows() > 0){
-        $result = $result->result_array();
+		}else{
+		  $str=null;
+		}
+		$query = "select id from accounts where reseller_id = '$parent_id' AND deleted =0 AND type=1";
+		$result = $this->CI->db->query($query);
+		if($result->num_rows() > 0){
+		$result = $result->result_array();
 	  foreach ($result as $data){
-	    if(!empty($data['id'])){
-	      $str.=$this->get_subreseller_info($data['id']);
-	    }
+		if(!empty($data['id'])){
+		  $str.=$this->get_subreseller_info($data['id']);
+		}
 	  }
 	}
 	return $str;
-    }
-    function get_parent_info($child_id,$parent_id){
-        if(!empty($child_id)){
+	}
+	function get_parent_info($child_id,$parent_id){
+		if(!empty($child_id)){
 	  $str=$child_id.",";
-        }else{
-          $str=null;
-        }
-        if($child_id > 0){
-        $query = "select reseller_id from accounts where id = '$child_id'";
-        $result = $this->CI->db->query($query);
-        if($result->num_rows() > 0){
-        $parent_info = (array)$result->first_row();
+		}else{
+		  $str=null;
+		}
+		if($child_id > 0){
+		$query = "select reseller_id from accounts where id = '$child_id'";
+		$result = $this->CI->db->query($query);
+		if($result->num_rows() > 0){
+		$parent_info = (array)$result->first_row();
 	  if($parent_info['reseller_id'] != $parent_id){
-	    $str.=$this->get_parent_info($parent_info['reseller_id'],$parent_id);
+		$str.=$this->get_parent_info($parent_info['reseller_id'],$parent_id);
 	  }
 	}
 	}
 	return $str;
-    }
-    function get_did_accountid($select,$table,$where){
-      $accountinfo=$this->CI->session->userdata('accountinfo');
-      $this->CI->db->where('note',$where);
-      $this->CI->db->where('parent_id',$accountinfo['id']);
-      $this->CI->db->select('reseller_id');
-      $reseller_pricing_result=$this->CI->db->get('reseller_pricing');
-      $account_info=(array)$reseller_pricing_result->first_row();
-      $account_name=$this->get_field_name_coma_new('first_name,last_name,number','accounts',$account_info['reseller_id']);
-      return $account_name;     
-    }
-
-    function get_status_new($select = "",$table = "",$status = "") {
-      return ($status['status']==0) ? "<span class='label label-sm label-inverse arrowed-in' title='release'>Active<span>" : "<span class='label label-sm' title='release'>Inactive<span>";
-    }
+	}
+	function get_did_accountid($select,$table,$where){
+	  $accountinfo=$this->CI->session->userdata('accountinfo');
+	  $this->CI->db->where('note',$where);
+	  $this->CI->db->where('parent_id',$accountinfo['id']);
+	  $this->CI->db->select('reseller_id');
+	  $reseller_pricing_result=$this->CI->db->get('reseller_pricing');
+	  $account_info=(array)$reseller_pricing_result->first_row();
+	  $account_name=$this->get_field_name_coma_new('first_name,last_name,number','accounts',$account_info['reseller_id']);
+	  return $account_name;     
+	}
+
+	function get_status_new($select = "",$table = "",$status = "") {
+	  return ($status['status']==0) ? "<span class='label label-sm label-inverse arrowed-in' title='release'>Active<span>" : "<span class='label label-sm' title='release'>Inactive<span>";
+	}
     
 }