iNextrix / ASTPP

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

Indentation +224 added lines, -224 removed lines

@@ -24,17 +24,17 @@ 
 
 class DID_model extends CI_Model {
 
-    function DID_model() {
-        parent::__construct();
-    }
+	function DID_model() {
+		parent::__construct();
+	}
 
-    function add_did($add_array) {
+	function add_did($add_array) {
 	if($add_array['accountid'] > 0 ){
 	  $add_array['assign_date']=gmdate('Y-m-d H:i:s');
 	}
 	unset($add_array["action"]);
 	$this->db->insert("dids", $add_array);
-        if($add_array['accountid'] > 0 ){
+		if($add_array['accountid'] > 0 ){
 	  $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$add_array['accountid']))->first_row();
 	  $currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id']));
 	  $available_bal = $this->db_model->update_balance( $add_array["setup"], $add_array['accountid'], "debit");
@@ -46,103 +46,103 @@ 
 	  $accountinfo['did_monthlycost'] =$this->common_model->calculate_currency($add_array['monthlycost'],'',$currency_name,true,true);
 	  $accountinfo['did_maxchannels'] = $add_array['maxchannels'];
 	  $this->common->mail_to_users('email_add_did', $accountinfo);
-       }
-       return true;
-    }
-    function insert_pricelist() {
-        $insert_array = array('name' => 'default', 'markup' => '', 'inc' => '');
-        return $this->db->insert_id();
-    }
+	   }
+	   return true;
+	}
+	function insert_pricelist() {
+		$insert_array = array('name' => 'default', 'markup' => '', 'inc' => '');
+		return $this->db->insert_id();
+	}
 
-    function edit_did($data, $id,$number) {
-        unset($data["action"]);
-        $this->db->where('number',$number);
-        $this->db->select('parent_id,accountid');
-        $did_result=$this->db->get('dids');
-        $did_result=(array)$did_result->first_row();
-        if($did_result['accountid'] > 0 || $did_result['parent_id'] > 0){
-         $data['accountid']=$did_result['accountid'];
-         $data['parent_id']=$did_result['parent_id'];
-        }
+	function edit_did($data, $id,$number) {
+		unset($data["action"]);
+		$this->db->where('number',$number);
+		$this->db->select('parent_id,accountid');
+		$did_result=$this->db->get('dids');
+		$did_result=(array)$did_result->first_row();
+		if($did_result['accountid'] > 0 || $did_result['parent_id'] > 0){
+		 $data['accountid']=$did_result['accountid'];
+		 $data['parent_id']=$did_result['parent_id'];
+		}
 	/**
 	  ASTPP  3.0 
 	  In did edit last modified date and assign date update
-	**/
-        $data['last_modified_date']=gmdate("Y-m-d H:i:s");
-        if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
-	    $data['assign_date']=gmdate("Y-m-d H:i:s");
+	 **/
+		$data['last_modified_date']=gmdate("Y-m-d H:i:s");
+		if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
+		$data['assign_date']=gmdate("Y-m-d H:i:s");
 	} 
 	$this->db->where("number", $number);
 	$this->db->where("id", $id);
 	$this->db->update("dids", $data);
-        /**************************************/
-        if($did_result['parent_id'] > 0 ){
-            $update_array['call_type']=$data['call_type'];
-            $update_array['extensions']=$data['extensions'];
-            $this->db->where("note", $number);
-            $this->db->update("reseller_pricing", $update_array);
-        }
-        if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
-	    $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$data['accountid']))->first_row();
-	    $currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id']));
-	    $available_bal = $this->db_model->update_balance( $data["setup"], $data['accountid'], "debit");
-	    $this->common->add_invoice_details($accountinfo, "DIDCHRG", $data["setup"], $number);
-	    $accountinfo['did_number'] = $number;
-	    $country_id = $this->common->get_field_name('country', 'countrycode', $data['country_id']);
-	    $accountinfo['did_country_id'] = $country_id;
-	    $accountinfo['did_setup'] = $this->common_model->calculate_currency($data['setup'],'',$currency_name,true,true);
-	    $accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($data['monthlycost'],'',$currency_name,true,true);
-	    $accountinfo['did_maxchannels'] = $data['maxchannels'];
-	    $this->common->mail_to_users('email_add_did', $accountinfo);
-        }        
-    }
+		/**************************************/
+		if($did_result['parent_id'] > 0 ){
+			$update_array['call_type']=$data['call_type'];
+			$update_array['extensions']=$data['extensions'];
+			$this->db->where("note", $number);
+			$this->db->update("reseller_pricing", $update_array);
+		}
+		if($did_result['accountid'] ==0 && $data['accountid'] > 0 ){
+		$accountinfo=(array)$this->db->get_where('accounts',array("id"=>$data['accountid']))->first_row();
+		$currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id']));
+		$available_bal = $this->db_model->update_balance( $data["setup"], $data['accountid'], "debit");
+		$this->common->add_invoice_details($accountinfo, "DIDCHRG", $data["setup"], $number);
+		$accountinfo['did_number'] = $number;
+		$country_id = $this->common->get_field_name('country', 'countrycode', $data['country_id']);
+		$accountinfo['did_country_id'] = $country_id;
+		$accountinfo['did_setup'] = $this->common_model->calculate_currency($data['setup'],'',$currency_name,true,true);
+		$accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($data['monthlycost'],'',$currency_name,true,true);
+		$accountinfo['did_maxchannels'] = $data['maxchannels'];
+		$this->common->mail_to_users('email_add_did', $accountinfo);
+		}        
+	}
 
-    function getdid_list($flag, $start = 0, $limit = 0) {
-            $accountinfo=$this->session->userdata('accountinfo');
-            $parent_id= $accountinfo['type']==1 ? $accountinfo['reseller_id'] : 0 ;
+	function getdid_list($flag, $start = 0, $limit = 0) {
+			$accountinfo=$this->session->userdata('accountinfo');
+			$parent_id= $accountinfo['type']==1 ? $accountinfo['reseller_id'] : 0 ;
 	    
-	    if($accountinfo['type']==1)
-	    {
-	      $where = array('reseller_id' => $accountinfo['id'],"parent_id"=>$parent_id);
+		if($accountinfo['type']==1)
+		{
+		  $where = array('reseller_id' => $accountinfo['id'],"parent_id"=>$parent_id);
 		if ($flag) {
 		  if($accountinfo['reseller_id'] > 0 ){
-		     $search_string=$this->db_model->build_search_string('did_list_search');
-		     $search_string= !empty($search_string) ? " AND ".$search_string : null;
-		      if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+			 $search_string=$this->db_model->build_search_string('did_list_search');
+			 $search_string= !empty($search_string) ? " AND ".$search_string : null;
+			  if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
 			$this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-		      }
-		      $this->db->limit($limit, $start);
-		      $query=$this->db->query("SELECT a.note AS number,a.*,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND a.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = a.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=a.note)) AS accountid FROM reseller_pricing AS a where a.reseller_id=".$accountinfo['id']." AND a.parent_id =".$accountinfo['reseller_id'].$search_string);
+			  }
+			  $this->db->limit($limit, $start);
+			  $query=$this->db->query("SELECT a.note AS number,a.*,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND a.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = a.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=a.note)) AS accountid FROM reseller_pricing AS a where a.reseller_id=".$accountinfo['id']." AND a.parent_id =".$accountinfo['reseller_id'].$search_string);
 		  }
 		  else{
-		    $this->db_model->build_search('did_list_search');
-		    $query = $this->db_model->select("*,note as number,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND reseller_pricing.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = reseller_pricing.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=reseller_pricing.note)) AS accountid", "reseller_pricing", $where, "note", "desc", $limit, $start);
+			$this->db_model->build_search('did_list_search');
+			$query = $this->db_model->select("*,note as number,IF((SELECT COUNT( id ) AS count FROM reseller_pricing AS b WHERE b.parent_id =".$accountinfo['id']." AND reseller_pricing.note = b.note ) >0,(SELECT reseller_id AS accountid FROM reseller_pricing AS c WHERE c.note = reseller_pricing.note AND c.parent_id =".$accountinfo['id']."), (SELECT accountid from dids as d where d.parent_id = ".$accountinfo['id']." AND d.number=reseller_pricing.note)) AS accountid", "reseller_pricing", $where, "note", "desc", $limit, $start);
 		  }
 		} else {
 		  $this->db_model->build_search('did_list_search');
 		  $query = $this->db_model->countQuery("*", "reseller_pricing", $where);
 		}
 
-	    }
-	    else
-	    {	
-	      $this->db_model->build_search('did_list_search');
-	      if ($flag) {
-	      /*
+		}
+		else
+		{	
+		  $this->db_model->build_search('did_list_search');
+		  if ($flag) {
+		  /*
 	      ASTPP  3.0  last_modified_date,assign_date put in query.
 	      */
 		$this->db->select('dids.id,dids.connectcost,dids.includedseconds,dids.last_modified_date,dids.assign_date,dids.number,dids.extensions,dids.call_type,dids.country_id,dids.init_inc,dids.inc,dids.cost,dids.setup,dids.monthlycost,dids.status,(CASE when parent_id > 0 THEN (SELECT reseller_id as accountid from reseller_pricing where dids.number=reseller_pricing.note AND reseller_pricing.parent_id=0) ELSE dids.accountid END ) as accountid');
-                if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-                    $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-                }
+				if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+					$this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+				}
 		/*********************************************************88*/
 		$this->db->limit($limit, $start);
 		$query=$this->db->get('dids');
-	      } else {
+		  } else {
 		$query = $this->db_model->countQuery("*", "dids");
-	      }
-	    }
-	    return $query;
+		  }
+		}
+		return $query;
   }
   function remove_did($id) {
  /**
@@ -154,10 +154,10 @@ 
 	$this->db->select('accountid,number,parent_id');
 	$did_info=(array)$this->db->get('dids')->first_row();
 	$this->db->where("id", $id);
-        $this->db->delete("dids");
-        $this->db->where("note", $did_info['number']);
-        $this->db->delete("reseller_pricing");
-        if($did_info['accountid'] == 0 && $did_info['parent_id'] > 0){
+		$this->db->delete("dids");
+		$this->db->where("note", $did_info['number']);
+		$this->db->delete("reseller_pricing");
+		if($did_info['accountid'] == 0 && $did_info['parent_id'] > 0){
 	  $accountinfo=$this->session->userdata('accountinfo');
 	  $did_info['accountid']=$accouninfo['id'];
 	  $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$did_info['parent_id']))->first_row();
@@ -168,177 +168,177 @@ 
 	  $accountinfo['did_number'] = $did_info['number'];
 	  $this->common->mail_to_users('email_remove_did', $accountinfo);
 	}
-        return true;
-    }
+		return true;
+	}
 
-    function get_coutry_id_by_name($field_value) {
-        $this->db->where("country", ucfirst($field_value));
-        $query = $this->db->get('countrycode');
-        $data = $query->result();
-        if ($query->num_rows > 0)
-            return $data[0]->id;
-        else
-            return '';
-    }
+	function get_coutry_id_by_name($field_value) {
+		$this->db->where("country", ucfirst($field_value));
+		$query = $this->db->get('countrycode');
+		$data = $query->result();
+		if ($query->num_rows > 0)
+			return $data[0]->id;
+		else
+			return '';
+	}
 
-    function bulk_insert_dids($field_value) {
-        $this->db->insert_batch('dids', $field_value);
-        $affected_row = $this->db->affected_rows();
-        return $affected_row;
-    }
+	function bulk_insert_dids($field_value) {
+		$this->db->insert_batch('dids', $field_value);
+		$affected_row = $this->db->affected_rows();
+		return $affected_row;
+	}
 
-    function get_account($accountdata) {
-        $q = "SELECT * FROM accounts WHERE number = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
-        $query = $this->db->query($q);
-        if ($query->num_rows() > 0) {
-            $row = $query->row_array();
-            return $row;
-        }
+	function get_account($accountdata) {
+		$q = "SELECT * FROM accounts WHERE number = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$query = $this->db->query($q);
+		if ($query->num_rows() > 0) {
+			$row = $query->row_array();
+			return $row;
+		}
 
-        $q = "SELECT * FROM accounts WHERE cc = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
-        $query = $this->db->query($q);
-        if ($query->num_rows() > 0) {
-            $row = $query->row_array();
-            return $row;
-        }
+		$q = "SELECT * FROM accounts WHERE cc = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$query = $this->db->query($q);
+		if ($query->num_rows() > 0) {
+			$row = $query->row_array();
+			return $row;
+		}
 
-        $q = "SELECT * FROM accounts WHERE accountid = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
-        $query = $this->db->query($q);
-        if ($query->num_rows() > 0) {
-            $row = $query->row_array();
-            return $row;
-        }
+		$q = "SELECT * FROM accounts WHERE accountid = '" . $this->db->escape_str($accountdata) . "' AND status = 0";
+		$query = $this->db->query($q);
+		if ($query->num_rows() > 0) {
+			$row = $query->row_array();
+			return $row;
+		}
 
-        return NULL;
-    }
+		return NULL;
+	}
 
-    function get_did_reseller_new($did, $reseller_id = "") {
-        $sql = "SELECT dids.number AS number, "
-                . "reseller_pricing.monthlycost AS monthlycost, "
-                . "reseller_pricing.prorate AS prorate, "
-                . "reseller_pricing.setup AS setup, "
-                . "reseller_pricing.cost AS cost, "
-                . "reseller_pricing.connectcost AS connectcost, "
-                . "reseller_pricing.includedseconds AS includedseconds, "
-                . "reseller_pricing.inc AS inc, "
-                . "reseller_pricing.disconnectionfee AS disconnectionfee, "
-                . "dids.provider_id AS provider_id, "
-                . "dids.country_id AS country_id, "
-                . "dids.city AS city, "
-                . "dids.province AS province, "
-                . "dids.extensions AS extensions, "
-                . "dids.accountid AS account, "
-                . "dids.variables AS variables, "
-                . "dids.options AS options, "
-                . "dids.maxchannels AS maxchannels, "
-                . "dids.chargeonallocation AS chargeonallocation, "
-                . "dids.allocation_bill_status AS allocation_bill_status, "
-                . "dids.limittime AS limittime, "
-                . "dids.dial_as AS dial_as, "
-                . "dids.status AS status "
-                . "FROM dids, reseller_pricing "
-                . "WHERE dids.id = " . $did
-                . " AND reseller_pricing.type = '1' AND reseller_pricing.reseller_id = "
-                . $reseller_id;
-        $query = $this->db->query($sql);
-        if ($query->num_rows() > 0) {
-            return $query->row_array();
-        }
-    }
+	function get_did_reseller_new($did, $reseller_id = "") {
+		$sql = "SELECT dids.number AS number, "
+				. "reseller_pricing.monthlycost AS monthlycost, "
+				. "reseller_pricing.prorate AS prorate, "
+				. "reseller_pricing.setup AS setup, "
+				. "reseller_pricing.cost AS cost, "
+				. "reseller_pricing.connectcost AS connectcost, "
+				. "reseller_pricing.includedseconds AS includedseconds, "
+				. "reseller_pricing.inc AS inc, "
+				. "reseller_pricing.disconnectionfee AS disconnectionfee, "
+				. "dids.provider_id AS provider_id, "
+				. "dids.country_id AS country_id, "
+				. "dids.city AS city, "
+				. "dids.province AS province, "
+				. "dids.extensions AS extensions, "
+				. "dids.accountid AS account, "
+				. "dids.variables AS variables, "
+				. "dids.options AS options, "
+				. "dids.maxchannels AS maxchannels, "
+				. "dids.chargeonallocation AS chargeonallocation, "
+				. "dids.allocation_bill_status AS allocation_bill_status, "
+				. "dids.limittime AS limittime, "
+				. "dids.dial_as AS dial_as, "
+				. "dids.status AS status "
+				. "FROM dids, reseller_pricing "
+				. "WHERE dids.id = " . $did
+				. " AND reseller_pricing.type = '1' AND reseller_pricing.reseller_id = "
+				. $reseller_id;
+		$query = $this->db->query($sql);
+		if ($query->num_rows() > 0) {
+			return $query->row_array();
+		}
+	}
 
-    function get_did_by_number($number) {
-        $this->db->where("id", $number);
-        $this->db->or_where("number", $number);
-        $query = $this->db->get("dids");
-        if ($query->num_rows() > 0)
-            return $query->row_array();
-        else
-            return false;
-    }
+	function get_did_by_number($number) {
+		$this->db->where("id", $number);
+		$this->db->or_where("number", $number);
+		$query = $this->db->get("dids");
+		if ($query->num_rows() > 0)
+			return $query->row_array();
+		else
+			return false;
+	}
    function edit_did_reseller($did_id,$post) {
-        $accountinfo = $this->session->userdata('accountinfo');
+		$accountinfo = $this->session->userdata('accountinfo');
 
-        $where_array=array('reseller_id' => $accountinfo['id'], 'note' => $post['number'], 'type' => '1');
+		$where_array=array('reseller_id' => $accountinfo['id'], 'note' => $post['number'], 'type' => '1');
 	$this->db->where($where_array);
 	$flag='0';
-        $query = $this->db->get('reseller_pricing');
-        if($query->num_rows() > 0){
+		$query = $this->db->get('reseller_pricing');
+		if($query->num_rows() > 0){
 	  $flag='1';
-        }
+		}
         
-        $this->insert_reseller_pricing($accountinfo, $post);
-        return $flag;
-    }
+		$this->insert_reseller_pricing($accountinfo, $post);
+		return $flag;
+	}
 
-    function delete_pricing_reseller($username, $number) {
-        $where = array('reseller_id' => $username, 'note' => $number, 'type' => '1');
-        $this->db->where($where);
-        $this->db->delete('reseller_pricing');
-        return true;
-    }
+	function delete_pricing_reseller($username, $number) {
+		$where = array('reseller_id' => $username, 'note' => $number, 'type' => '1');
+		$this->db->where($where);
+		$this->db->delete('reseller_pricing');
+		return true;
+	}
 
 function insert_reseller_pricing($accountinfo, $post) {
-        $insert_array = array('reseller_id' => $accountinfo['id'], 'type' => '1', 'note' => $post['number'],
-            'parent_id'=>$accountinfo['reseller_id'],
-            'monthlycost' => $post['monthlycost'],
-            'prorate' => $post['prorate'],
-            'setup' => $post['setup'],
-            'cost' => $post['cost'],
-            'inc' => $post['inc'],
-            'extensions'=>$post['extensions'],
-            'call_type'=>$post['call_type'],
-            'disconnectionfee' => $post['disconnectionfee'],
-            'connectcost' => $post['connectcost'],
-            'includedseconds' => $post['includedseconds'],
-            'status' => '0',
-	    'assign_date'=>gmdate('Y-m-d H:i:s'));
+		$insert_array = array('reseller_id' => $accountinfo['id'], 'type' => '1', 'note' => $post['number'],
+			'parent_id'=>$accountinfo['reseller_id'],
+			'monthlycost' => $post['monthlycost'],
+			'prorate' => $post['prorate'],
+			'setup' => $post['setup'],
+			'cost' => $post['cost'],
+			'inc' => $post['inc'],
+			'extensions'=>$post['extensions'],
+			'call_type'=>$post['call_type'],
+			'disconnectionfee' => $post['disconnectionfee'],
+			'connectcost' => $post['connectcost'],
+			'includedseconds' => $post['includedseconds'],
+			'status' => '0',
+		'assign_date'=>gmdate('Y-m-d H:i:s'));
 
-        $this->db->insert('reseller_pricing', $insert_array);
-        return true;
-    }
+		$this->db->insert('reseller_pricing', $insert_array);
+		return true;
+	}
 
-    function update_dids_reseller($post) {
-        $where = array('id' => $post['did_id']);
-        $update_array = array('dial_as' => $post['dial_as'], 'extensions' => $post['extension']);
-        $this->db->where($where);
-        $this->db->update('dids', $update_array);
-    }
+	function update_dids_reseller($post) {
+		$where = array('id' => $post['did_id']);
+		$update_array = array('dial_as' => $post['dial_as'], 'extensions' => $post['extension']);
+		$this->db->where($where);
+		$this->db->update('dids', $update_array);
+	}
 
-    function delete_routes($id, $number, $pricelist_id) {
-        $number = "^" . $number . ".*";
-        $where = array('pricelist_id' => $pricelist_id, 'pattern' => $number);
-        $this->db->where($where);
-        $this->db->delete('routes');
-    }
+	function delete_routes($id, $number, $pricelist_id) {
+		$number = "^" . $number . ".*";
+		$where = array('pricelist_id' => $pricelist_id, 'pattern' => $number);
+		$this->db->where($where);
+		$this->db->delete('routes');
+	}
 
-    function insert_routes($post, $pricelist_id) {
-        $commment = "DID:" . $post['country'] . "," . $post['province'] . "," . $post['city'];
-        $insert_array = array('pattern' => "^" . $post['number'] . ".*", 'comment' => $commment, 'pricelist_id' => $pricelist_id,
-            'connectcost' => $post['connectcost'], 'includedseconds' => $post['included'], 'cost' => $post['cost'], 'inc' => $post['inc']);
-        $this->db->insert('routes', $insert_array);
-        return true;
-    }
+	function insert_routes($post, $pricelist_id) {
+		$commment = "DID:" . $post['country'] . "," . $post['province'] . "," . $post['city'];
+		$insert_array = array('pattern' => "^" . $post['number'] . ".*", 'comment' => $commment, 'pricelist_id' => $pricelist_id,
+			'connectcost' => $post['connectcost'], 'includedseconds' => $post['included'], 'cost' => $post['cost'], 'inc' => $post['inc']);
+		$this->db->insert('routes', $insert_array);
+		return true;
+	}
 
-    function add_invoice_data($accountid,$charge_type,$description,$credit)
-    {
+	function add_invoice_data($accountid,$charge_type,$description,$credit)
+	{
 	$insert_array = array('accountid' => $accountid, 
-			      'charge_type' => $charge_type, 
-			      'description' => $description,
-			      'credit' => $credit,
-			      'charge_id' => '0',
-			      'package_id' => '0'
-			    );
+				  'charge_type' => $charge_type, 
+				  'description' => $description,
+				  'credit' => $credit,
+				  'charge_id' => '0',
+				  'package_id' => '0'
+				);
 
-        $this->db->insert('invoice_item', $insert_array);
-        return true;
-    }
-    function check_unique_did($number)
-    {
+		$this->db->insert('invoice_item', $insert_array);
+		return true;
+	}
+	function check_unique_did($number)
+	{
 
-      $where=array('number'=>$number);
-      $query = $this->db_model->countQuery("*", "dids", $where);
-      return $query;
-    }
+	  $where=array('number'=>$number);
+	  $query = $this->db_model->countQuery("*", "dids", $where);
+	  return $query;
+	}
    
 
 }

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

Indentation +382 added lines, -382 removed lines

@@ -23,142 +23,142 @@ 
 
 class Package extends MX_Controller {
 
-    function Package() {
-        parent::__construct();
+	function Package() {
+		parent::__construct();
 
-        $this->load->helper('template_inheritance');
+		$this->load->helper('template_inheritance');
 
-        $this->load->library('session');
-        $this->load->library('package_form');
-        $this->load->library('astpp/form');
-        $this->load->model('package_model');
-        $this->load->library('csvreader');
+		$this->load->library('session');
+		$this->load->library('package_form');
+		$this->load->library('astpp/form');
+		$this->load->model('package_model');
+		$this->load->library('csvreader');
 
-        if ($this->session->userdata('user_login') == FALSE)
-            redirect(base_url() . '/astpp/login');
-    }
+		if ($this->session->userdata('user_login') == FALSE)
+			redirect(base_url() . '/astpp/login');
+	}
 
    
-    function package_list() {
-        $data['username'] = $this->session->userdata('user_name');
-        $data['page_title'] = 'Packages';
+	function package_list() {
+		$data['username'] = $this->session->userdata('user_name');
+		$data['page_title'] = 'Packages';
 $data['search_flag'] = true;
-        $this->session->set_userdata('advance_search', 0);
-        $data['grid_fields'] = $this->package_form->build_package_list_for_admin();
-        $data["grid_buttons"] = $this->package_form->build_grid_buttons();
-        $data['form_search'] = $this->form->build_serach_form($this->package_form->get_package_search_form());
-        $this->load->view('view_package_list', $data);
-    }
-
-    /**
-     * -------Here we write code for controller accounts functions account_list------
-     * Listing of Accounts table data through php function json_encode
-     */
-    function package_list_json() {
-        $json_data = array();
-        $count_all = $this->package_model->getpackage_list(false);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-
-        $query = $this->package_model->getpackage_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-        $grid_fields = json_decode($this->package_form->build_package_list_for_admin());
-        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
-
-        echo json_encode($json_data);
-    }
-    function package_list_reseller($accountid,$accounttype){
+		$this->session->set_userdata('advance_search', 0);
+		$data['grid_fields'] = $this->package_form->build_package_list_for_admin();
+		$data["grid_buttons"] = $this->package_form->build_grid_buttons();
+		$data['form_search'] = $this->form->build_serach_form($this->package_form->get_package_search_form());
+		$this->load->view('view_package_list', $data);
+	}
+
+	/**
+	 * -------Here we write code for controller accounts functions account_list------
+	 * Listing of Accounts table data through php function json_encode
+	 */
+	function package_list_json() {
+		$json_data = array();
+		$count_all = $this->package_model->getpackage_list(false);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+
+		$query = $this->package_model->getpackage_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$grid_fields = json_decode($this->package_form->build_package_list_for_admin());
+		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
+
+		echo json_encode($json_data);
+	}
+	function package_list_reseller($accountid,$accounttype){
 	$json_data = array();
-        $count_all = $this->package_model->get_reseller_package_list(false,$accountid,$accounttype);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-        $query = $this->package_model->get_reseller_package_list(true,$accountid,$accounttype,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-        $grid_fields = json_decode($this->package_form->build_package_list_for_reseller());
-        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
-        echo json_encode($json_data);
-    }
+		$count_all = $this->package_model->get_reseller_package_list(false,$accountid,$accounttype);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+		$query = $this->package_model->get_reseller_package_list(true,$accountid,$accounttype,$paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$grid_fields = json_decode($this->package_form->build_package_list_for_reseller());
+		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
+		echo json_encode($json_data);
+	}
    function package_list_search() {
-        $ajax_search = $this->input->post('ajax_search', 0);
-
-        if ($this->input->post('advance_search', TRUE) == 1) {
-            $this->session->set_userdata('advance_search', $this->input->post('advance_search'));
-            $action = $this->input->post();
-            unset($action['action']);
-            unset($action['advance_search']);
-            $this->session->set_userdata('package_list_search', $action);
-        }
-        if (@$ajax_search != 1) {
-            redirect(base_url() . 'package/package_list/');
-        }
-    }
+		$ajax_search = $this->input->post('ajax_search', 0);
+
+		if ($this->input->post('advance_search', TRUE) == 1) {
+			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
+			$action = $this->input->post();
+			unset($action['action']);
+			unset($action['advance_search']);
+			$this->session->set_userdata('package_list_search', $action);
+		}
+		if (@$ajax_search != 1) {
+			redirect(base_url() . 'package/package_list/');
+		}
+	}
     
-    function package_list_clearsearchfilter() {
-        $this->session->set_userdata('advance_search', 0);
-        $this->session->set_userdata('package_list_search', "");
-    }
+	function package_list_clearsearchfilter() {
+		$this->session->set_userdata('advance_search', 0);
+		$this->session->set_userdata('package_list_search', "");
+	}
     
-     function package_add($type = "") {
-        $data['page_title'] = 'Create Package';
-        $data['form'] = $this->form->build_form($this->package_form->get_package_form_fields(), '');
-        $this->load->view('view_package_add', $data);
-    }
+	 function package_add($type = "") {
+		$data['page_title'] = 'Create Package';
+		$data['form'] = $this->form->build_form($this->package_form->get_package_form_fields(), '');
+		$this->load->view('view_package_add', $data);
+	}
 
-    function package_edit($edit_id = '') {
+	function package_edit($edit_id = '') {
 		$data['page_title'] = 'Package Details';
-        $accountinfo = $this->session->userdata("accountinfo");
-        $reseller_id=$accountinfo['type'] == 1 ? $accountinfo['id']:0;
-        $package_result = $this->db_model->getSelect("*", " packages", array('id' => $edit_id,"reseller_id"=>$reseller_id));
-        if ($package_result->num_rows > 0) {
-            $package_info=(array)$package_result->first_row();
-            $data['form'] = $this->form->build_form($this->package_form->get_package_form_fields($package_info['id']), $package_info);
-            $data['edit_id']=$package_info['id'];
-            $this->load->view('view_packages_edit', $data);
-        } else {
-            redirect(base_url() . 'package/package_list/');
-        }
-    }
-
-    function package_save($id="") {
-        $add_array = $this->input->post();
-        $data['form'] = $this->form->build_form($this->package_form->get_package_form_fields($add_array['id']), $add_array);
-        if ($add_array['id'] != '') {
-            if ($this->form_validation->run() == FALSE) {
-                $data['edit_id']= $add_array['id'];
-                $data['validation_errors'] = validation_errors();
-                $this->load->view('view_packages_edit', $data);
-            } else {
-                $this->package_model->edit_package($add_array, $add_array['id']);
-                $this->session->set_flashdata('astpp_errormsg', 'Package updated successfully!');
-                redirect(base_url() . 'package/package_list/');
-                exit;
-            }
-        } else {
-            $data['page_title'] = 'Create Package';
-            if ($this->form_validation->run() == FALSE) {
-                $data['validation_errors'] = validation_errors();
-                $this->load->view('view_package_add', $data);
-            } else {
-
-                $this->package_model->add_package($add_array);
+		$accountinfo = $this->session->userdata("accountinfo");
+		$reseller_id=$accountinfo['type'] == 1 ? $accountinfo['id']:0;
+		$package_result = $this->db_model->getSelect("*", " packages", array('id' => $edit_id,"reseller_id"=>$reseller_id));
+		if ($package_result->num_rows > 0) {
+			$package_info=(array)$package_result->first_row();
+			$data['form'] = $this->form->build_form($this->package_form->get_package_form_fields($package_info['id']), $package_info);
+			$data['edit_id']=$package_info['id'];
+			$this->load->view('view_packages_edit', $data);
+		} else {
+			redirect(base_url() . 'package/package_list/');
+		}
+	}
+
+	function package_save($id="") {
+		$add_array = $this->input->post();
+		$data['form'] = $this->form->build_form($this->package_form->get_package_form_fields($add_array['id']), $add_array);
+		if ($add_array['id'] != '') {
+			if ($this->form_validation->run() == FALSE) {
+				$data['edit_id']= $add_array['id'];
+				$data['validation_errors'] = validation_errors();
+				$this->load->view('view_packages_edit', $data);
+			} else {
+				$this->package_model->edit_package($add_array, $add_array['id']);
+				$this->session->set_flashdata('astpp_errormsg', 'Package updated successfully!');
+				redirect(base_url() . 'package/package_list/');
+				exit;
+			}
+		} else {
+			$data['page_title'] = 'Create Package';
+			if ($this->form_validation->run() == FALSE) {
+				$data['validation_errors'] = validation_errors();
+				$this->load->view('view_package_add', $data);
+			} else {
+
+				$this->package_model->add_package($add_array);
 /**
 ASTPP  3.0 
 For Email Broadcast when package is add
 **/
 		$accountinfo = $this->db_model->getSelect("*", "accounts", array("pricelist_id" => $add_array['pricelist_id'],"status"=>0, "deleted"=>0));
 		$accountinfo = $accountinfo->result_array();
-                $this->session->set_flashdata('astpp_errormsg', 'Package added successfully!');
+				$this->session->set_flashdata('astpp_errormsg', 'Package added successfully!');
 		foreach($accountinfo as $key => $value){
 			$this->common->mail_to_users('add_package', $value);
 		}
 /**************************************/
-                redirect(base_url() . 'package/package_list/');
-                exit;
-            }
-        }
-    }
+				redirect(base_url() . 'package/package_list/');
+				exit;
+			}
+		}
+	}
 
     
 
-    function package_delete($id) {
+	function package_delete($id) {
 /**
 ASTPP  3.0 
 For Email Broadcast when package is add
@@ -167,188 +167,188 @@ 
 	$package_detail = $package_detail->result_array();
 	$package_detail = $package_detail[0];
 	$accountinfo = $this->db_model->getSelect("*", "accounts", array("pricelist_id" => $package_detail['pricelist_id'],"status"=>0, "deleted"=>0)); 
-        $this->package_model->remove_package($id);
-        $this->session->set_flashdata('astpp_notification', 'Package removed successfully!');
+		$this->package_model->remove_package($id);
+		$this->session->set_flashdata('astpp_notification', 'Package removed successfully!');
 	foreach($accountinfo->result_array() as $key => $value){
 		$this->common->mail_to_users('remove_package', $value);
 	}	
 /******************************************/
-        redirect(base_url() . 'package/package_list/');
-    }
+		redirect(base_url() . 'package/package_list/');
+	}
     
-    function package_delete_multiple() {
-        $ids = $this->input->post("selected_ids", true);
-        $where = "id IN ($ids)";
-        $this->db->where($where);
-        echo $this->db->delete("packages");
-    }
-
-    function package_pattern_list($package_id){
+	function package_delete_multiple() {
+		$ids = $this->input->post("selected_ids", true);
+		$where = "id IN ($ids)";
+		$this->db->where($where);
+		echo $this->db->delete("packages");
+	}
+
+	function package_pattern_list($package_id){
 		$data['page_title'] = 'Package Codes';
-        if(!empty($package_id)){
-            $data['grid_fields'] = $this->package_form->build_pattern_list_for_customer($package_id);
-            $data['grid_buttons'] = $this->package_form->set_pattern_grid_buttons($package_id);
-            $data["edit_id"] = $package_id;
-            $this->load->view("view_package_pattern_list",$data);
-        }else{
-            redirect(base_url()."package/package_list/");
-        }    
-    }
-    function package_pattern_list_json($package_id){
-        $json_data = array();
-        $instant_search=$this->session->userdata('left_panel_search_package_pattern');
-        $like_str=!empty($instant_search) ? "(patterns like '%$instant_search%'  OR destination like '%$instant_search%' )" :null;
-        if(!empty($like_str))
-        $this->db->where($like_str);
-        $where = array('package_id' => $package_id);
-        $count_all = $this->db_model->countQuery("*", "package_patterns", $where);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-        if(!empty($like_str))
-        $this->db->where($like_str);
-        $pattern_data = $this->db_model->select("*", "package_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]);
+		if(!empty($package_id)){
+			$data['grid_fields'] = $this->package_form->build_pattern_list_for_customer($package_id);
+			$data['grid_buttons'] = $this->package_form->set_pattern_grid_buttons($package_id);
+			$data["edit_id"] = $package_id;
+			$this->load->view("view_package_pattern_list",$data);
+		}else{
+			redirect(base_url()."package/package_list/");
+		}    
+	}
+	function package_pattern_list_json($package_id){
+		$json_data = array();
+		$instant_search=$this->session->userdata('left_panel_search_package_pattern');
+		$like_str=!empty($instant_search) ? "(patterns like '%$instant_search%'  OR destination like '%$instant_search%' )" :null;
+		if(!empty($like_str))
+		$this->db->where($like_str);
+		$where = array('package_id' => $package_id);
+		$count_all = $this->db_model->countQuery("*", "package_patterns", $where);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+		if(!empty($like_str))
+		$this->db->where($like_str);
+		$pattern_data = $this->db_model->select("*", "package_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]);
         
-        $grid_fields = json_decode($this->package_form->build_pattern_list_for_customer($package_id));
-        $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields);
-
-        echo json_encode($json_data);
-    }
-    function package_counter() {
-        $data['username'] = $this->session->userdata('user_name');
-        $data['page_title'] = 'Usage Report';
-        $data['grid_fields'] = $this->package_form->build_package_counter_list_for_admin();
+		$grid_fields = json_decode($this->package_form->build_pattern_list_for_customer($package_id));
+		$json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields);
+
+		echo json_encode($json_data);
+	}
+	function package_counter() {
+		$data['username'] = $this->session->userdata('user_name');
+		$data['page_title'] = 'Usage Report';
+		$data['grid_fields'] = $this->package_form->build_package_counter_list_for_admin();
 	$data["grid_buttons"] = $this->package_form->build_package_counter_report();
-        $this->load->view('view_package_counter_report', $data);
-    }
-
-    /**
-     * -------Here we write code for controller accounts functions account_list------
-     * Listing of Accounts table data through php function json_encode
-     */
-    function package_counter_json() {
-        $json_data = array();
-        $count_all = $this->package_model->getpackage_counter_list(false);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-
-        $query = $this->package_model->getpackage_counter_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-        $grid_fields = json_decode($this->package_form->build_package_counter_list_for_admin());
-        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
-
-        echo json_encode($json_data);
-    }
-    function package_counter_report_export(){
-        $query = $this->db_model->getSelect("*", "counters", '');
-        $outbound_array = array();
-        ob_clean();
-        $outbound_array[] = array("Package Name", "Account",  "Used Seconds");
-        if ($query->num_rows() > 0) {
-
-            foreach ($query->result_array() as $row) {
-             $outbound_array[] = array(
-                        $this->common->get_field_name('package_name', 'packages', $row['package_id']),
-                        $this->common->get_field_name_coma_new('first_name,last_name,number', 'accounts', $row['accountid']),
-                        $row['seconds']
-                        );
-                }
-            }
-        $this->load->helper('csv');
-        array_to_csv($outbound_array, 'Usage_Report_' . date("Y-m-d") . '.csv');
+		$this->load->view('view_package_counter_report', $data);
+	}
+
+	/**
+	 * -------Here we write code for controller accounts functions account_list------
+	 * Listing of Accounts table data through php function json_encode
+	 */
+	function package_counter_json() {
+		$json_data = array();
+		$count_all = $this->package_model->getpackage_counter_list(false);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+
+		$query = $this->package_model->getpackage_counter_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$grid_fields = json_decode($this->package_form->build_package_counter_list_for_admin());
+		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
+
+		echo json_encode($json_data);
+	}
+	function package_counter_report_export(){
+		$query = $this->db_model->getSelect("*", "counters", '');
+		$outbound_array = array();
+		ob_clean();
+		$outbound_array[] = array("Package Name", "Account",  "Used Seconds");
+		if ($query->num_rows() > 0) {
+
+			foreach ($query->result_array() as $row) {
+			 $outbound_array[] = array(
+						$this->common->get_field_name('package_name', 'packages', $row['package_id']),
+						$this->common->get_field_name_coma_new('first_name,last_name,number', 'accounts', $row['accountid']),
+						$row['seconds']
+						);
+				}
+			}
+		$this->load->helper('csv');
+		array_to_csv($outbound_array, 'Usage_Report_' . date("Y-m-d") . '.csv');
     
-    }
-    function package_pattern_json($package_id){
-        $json_data = array();
-        $where = array('package_id' => $package_id);
+	}
+	function package_pattern_json($package_id){
+		$json_data = array();
+		$where = array('package_id' => $package_id);
 
-        $count_all = $this->db_model->countQuery("*", "package_patterns", $where);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
+		$count_all = $this->db_model->countQuery("*", "package_patterns", $where);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
 
-        $pattern_data = $this->db_model->select("*", "package_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]);
-        $grid_fields = json_decode($this->package_form->build_pattern_list_for_customer($package_id));
-        $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields);
+		$pattern_data = $this->db_model->select("*", "package_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]);
+		$grid_fields = json_decode($this->package_form->build_pattern_list_for_customer($package_id));
+		$json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields);
 
-        echo json_encode($json_data);
-    }
+		echo json_encode($json_data);
+	}
     
-    function package_patterns_add($packageid) {
-        $data['username'] = $this->session->userdata('user_name');
-        $data['page_title'] = 'Unblocked Prefixes';
-        $this->session->set_userdata('advance_search', 0);
-        $this->load->module('rates/rates');
-        $data['patters_grid_fields'] = $this->rates->rates_form->build_block_pattern_list_for_customer();
-        $data["packageid"] = $packageid;
-        $this->load->view('view_prefix_list', $data);
-    }
-    function package_patterns_add_json($accountid) {
-        $this->load->module('rates/rates');
-        $json_data = array();
-        $count_all = $this->rates_model->getunblocked_package_pattern($accountid,false);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-
-        $query = $this->rates->rates_model->getunblocked_package_pattern($accountid,true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-        $grid_fields = json_decode($this->rates->rates_form->build_block_pattern_list_for_customer());
-        $json_data['rows'] = $this->rates->form->build_grid($query, $grid_fields);
-
-        echo json_encode($json_data);
-    }
-    function package_patterns_add_info($packageid) {	
-        $result = $this->package_model->insert_package_pattern($this->input->post('prefixies', true),$packageid);
-        unset($_POST);
-        echo $result;
-        exit;
-    }
-    function package_patterns_delete($packageid, $patternid) {
-        $this->db->delete("package_patterns", array("id" => $patternid));
-        redirect(base_url() . "package/package_pattern_list/$packageid");
-    }
-    function package_patterns_selected_delete(){
-        $ids = $this->input->post("selected_ids", true);
-        $where = "id IN ($ids)";
-        unset($_POST);
-        echo $this->db->delete("package_patterns",$where);
-    }
+	function package_patterns_add($packageid) {
+		$data['username'] = $this->session->userdata('user_name');
+		$data['page_title'] = 'Unblocked Prefixes';
+		$this->session->set_userdata('advance_search', 0);
+		$this->load->module('rates/rates');
+		$data['patters_grid_fields'] = $this->rates->rates_form->build_block_pattern_list_for_customer();
+		$data["packageid"] = $packageid;
+		$this->load->view('view_prefix_list', $data);
+	}
+	function package_patterns_add_json($accountid) {
+		$this->load->module('rates/rates');
+		$json_data = array();
+		$count_all = $this->rates_model->getunblocked_package_pattern($accountid,false);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+
+		$query = $this->rates->rates_model->getunblocked_package_pattern($accountid,true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$grid_fields = json_decode($this->rates->rates_form->build_block_pattern_list_for_customer());
+		$json_data['rows'] = $this->rates->form->build_grid($query, $grid_fields);
+
+		echo json_encode($json_data);
+	}
+	function package_patterns_add_info($packageid) {	
+		$result = $this->package_model->insert_package_pattern($this->input->post('prefixies', true),$packageid);
+		unset($_POST);
+		echo $result;
+		exit;
+	}
+	function package_patterns_delete($packageid, $patternid) {
+		$this->db->delete("package_patterns", array("id" => $patternid));
+		redirect(base_url() . "package/package_pattern_list/$packageid");
+	}
+	function package_patterns_selected_delete(){
+		$ids = $this->input->post("selected_ids", true);
+		$where = "id IN ($ids)";
+		unset($_POST);
+		echo $this->db->delete("package_patterns",$where);
+	}
     
-    function package_quick_search($module_name){
-        $action = $this->input->post();
-        $this->session->set_userdata('left_panel_search_package_pattern',"");
-        if(!empty($action['left_panel_search'])){
-            $this->session->set_userdata('left_panel_search_package_pattern', $action['left_panel_search']);
-        }
-    }
+	function package_quick_search($module_name){
+		$action = $this->input->post();
+		$this->session->set_userdata('left_panel_search_package_pattern',"");
+		if(!empty($action['left_panel_search'])){
+			$this->session->set_userdata('left_panel_search_package_pattern', $action['left_panel_search']);
+		}
+	}
 
 
 	function package_patterns_import($edit_id) {
 		//echo "nick";exit;
-        $data['page_title'] = 'Import Package Patterns';
-        $this->session->set_userdata('import_package_code_csv',"");
-        $error_data =  $this->session->userdata('import_package_code_csv_error');
-        $full_path = $this->config->item('rates-file-path');
-        if(file_exists($full_path.$error_data) && $error_data != ""){
-            unlink($full_path.$error_data);
-            $this->session->set_userdata('import_package_code_csv_error',"");
-        }
-        $data['edit_id'] = $edit_id;
-        $this->load->view('view_import_package_code', $data);
-    }
+		$data['page_title'] = 'Import Package Patterns';
+		$this->session->set_userdata('import_package_code_csv',"");
+		$error_data =  $this->session->userdata('import_package_code_csv_error');
+		$full_path = $this->config->item('rates-file-path');
+		if(file_exists($full_path.$error_data) && $error_data != ""){
+			unlink($full_path.$error_data);
+			$this->session->set_userdata('import_package_code_csv_error',"");
+		}
+		$data['edit_id'] = $edit_id;
+		$this->load->view('view_import_package_code', $data);
+	}
     
     
-    function package_patterns_download_sample_file($file_name){
-        $this->load->helper('download');
+	function package_patterns_download_sample_file($file_name){
+		$this->load->helper('download');
 		$full_path = base_url()."assets/Rates_File/".$file_name.".csv";
-        $arrContextOptions=array(
+		$arrContextOptions=array(
 			"ssl"=>array(
 			"verify_peer"=>false,
 			"verify_peer_name"=>false,
 			),
 		);  
-        $file = file_get_contents($full_path, false, stream_context_create($arrContextOptions));
-        force_download("samplefile.csv", $file); 
-    }
+		$file = file_get_contents($full_path, false, stream_context_create($arrContextOptions));
+		force_download("samplefile.csv", $file); 
+	}
     
     
-    function package_patterns_preview_file($edit_id){
+	function package_patterns_preview_file($edit_id){
 	$invalid_flag= false;
 	$data=array();
 	$data['page_title'] = 'Import Package Patterns';
@@ -360,79 +360,79 @@ 
 	$new_final_arr_key = $this->config->item('package-code-field');
 	if(!$get_extension){
 		$data['error']= "Please Upload File Atleast";
-        }
-        //echo "<pre>";print_r($_FILES);exit;
-        if (isset($_FILES['package_code_import']['name']) && $_FILES['package_code_import']['name'] != "" ) {
-            list($txt,$ext) = explode(".", $_FILES['package_code_import']['name']);
+		}
+		//echo "<pre>";print_r($_FILES);exit;
+		if (isset($_FILES['package_code_import']['name']) && $_FILES['package_code_import']['name'] != "" ) {
+			list($txt,$ext) = explode(".", $_FILES['package_code_import']['name']);
             
-            if($ext == "csv" && $_FILES['package_code_import']['size'] > 0){ 
-                $error = $_FILES['package_code_import']['error'];
-                if ($error == 0) {
-                    $uploadedFile = $_FILES["package_code_import"]["tmp_name"];
-                    $csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header);
-                    if(!empty($csv_data)){
-		    $full_path = $this->config->item('rates-file-path');
-		    //echo "<pre>";print_r($full_path);exit;
-                    $actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s"). "." . $ext;
-                    //echo "<pre>";print_r($actual_file_name);exit;
-                    if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) {
+			if($ext == "csv" && $_FILES['package_code_import']['size'] > 0){ 
+				$error = $_FILES['package_code_import']['error'];
+				if ($error == 0) {
+					$uploadedFile = $_FILES["package_code_import"]["tmp_name"];
+					$csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header);
+					if(!empty($csv_data)){
+			$full_path = $this->config->item('rates-file-path');
+			//echo "<pre>";print_r($full_path);exit;
+					$actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s"). "." . $ext;
+					//echo "<pre>";print_r($actual_file_name);exit;
+					if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) {
 			$flag=false;
 			//$data['trunkid']=isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0;
-                        $data['csv_tmp_data'] = $csv_data;
-                        //$data['pricelistid'] = $_POST['pricelist_id'];
-                        $data['page_title'] = "Package Patterns Preview";
-                        $data['check_header']=$check_header;
-                        $this->session->set_userdata('import_package_code_csv',$actual_file_name);
-                    }else{
-                        $data['error'] = "File Uploading Fail Please Try Again";
-                    }
-                }
-             }   
-            else{
-                    $data['error']=="File Uploading Fail Please Try Again";
-                }
-           }
-           else {
-                $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)";
-            }
-            }else{
+						$data['csv_tmp_data'] = $csv_data;
+						//$data['pricelistid'] = $_POST['pricelist_id'];
+						$data['page_title'] = "Package Patterns Preview";
+						$data['check_header']=$check_header;
+						$this->session->set_userdata('import_package_code_csv',$actual_file_name);
+					}else{
+						$data['error'] = "File Uploading Fail Please Try Again";
+					}
+				}
+			 }   
+			else{
+					$data['error']=="File Uploading Fail Please Try Again";
+				}
+		   }
+		   else {
+				$data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)";
+			}
+			}else{
 		$invalid_flag=true;
-            }
-        if ($invalid_flag) {
-            $str = '';
-            if (empty($_FILES['package_code_import']['name'])) {
-                $str.= '<br/>Please Select File.';
-            }
-            $data['error']=$str;
-        }
-         $data['edit_id'] = $edit_id;
-        $this->load->view('view_import_package_code', $data);
-    }
+			}
+		if ($invalid_flag) {
+			$str = '';
+			if (empty($_FILES['package_code_import']['name'])) {
+				$str.= '<br/>Please Select File.';
+			}
+			$data['error']=$str;
+		}
+		 $data['edit_id'] = $edit_id;
+		$this->load->view('view_import_package_code', $data);
+	}
     
     
-    function package_patterns_import_file($edit_id,$check_header=false) {
+	function package_patterns_import_file($edit_id,$check_header=false) {
 		//echo $edit_id."===="; exit;
-       $new_final_arr = array();
-        $invalid_array = array();
-        $new_final_arr_key = $this->config->item('package-code-field');
+	   $new_final_arr = array();
+		$invalid_array = array();
+		$new_final_arr_key = $this->config->item('package-code-field');
 	$screen_path = $this->config->item('screen_path');
 	$reseller_id=0;
-        if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
-            $reseller_id = $this->session->userdata["accountinfo"]['id'];
-        }
+		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
+			$reseller_id = $this->session->userdata["accountinfo"]['id'];
+		}
         
 		$full_path = $this->config->item('rates-file-path');
 		//echo "<pre>";print_r($full_path);exit;
-        $originationrate_file_name = $this->session->userdata('import_package_code_csv');	
-        $csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name,$new_final_arr_key,$check_header); 
-        //echo "<pre>";print_r($csv_tmp_data);exit;
+		$originationrate_file_name = $this->session->userdata('import_package_code_csv');	
+		$csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name,$new_final_arr_key,$check_header); 
+		//echo "<pre>";print_r($csv_tmp_data);exit;
 	$i=0; 
-	     $pattern_arr=array();
-        foreach ($csv_tmp_data as $key => $csv_data) {	
+		 $pattern_arr=array();
+		foreach ($csv_tmp_data as $key => $csv_data) {	
 	  if(isset($csv_data['patterns']) && $csv_data['patterns']!= '' && $i != 0){
-	    $str=null;
-	    $pattern=$csv_data['patterns'];
-	     if(!in_array($csv_data['patterns'],$pattern_arr)){
+		$str=null;
+		$pattern=$csv_data['patterns'];
+		 if(!in_array($csv_data['patterns'],$pattern_arr)){
 			$this->db->select('count(id) as count');
 			$this->db->where('patterns',"^".$csv_data['patterns'].".*");
 			$this->db->where('package_id',$edit_id);
@@ -443,97 +443,97 @@ 
 			if($str != ""){
 			$invalid_array[$i]=$csv_data;
 			$invalid_array[$i]['error'] = $str;
-	    }
-	    else{
-	      $csv_data['patterns'] = "^" . $csv_data['patterns'] . ".*";
-	      $csv_data['package_id'] = $edit_id;
-	      $new_final_arr[$i]=$csv_data;
-	      $pattern_arr[$csv_data['patterns']]=$csv_data['patterns'];
-	    }
-	    }else{
+		}
+		else{
+		  $csv_data['patterns'] = "^" . $csv_data['patterns'] . ".*";
+		  $csv_data['package_id'] = $edit_id;
+		  $new_final_arr[$i]=$csv_data;
+		  $pattern_arr[$csv_data['patterns']]=$csv_data['patterns'];
+		}
+		}else{
 			$invalid_array[$i]=$csv_data;
 			$invalid_array[$i]['error'] = "Duplicate pattern found from  database.";
-	     }
+		 }
 	  }else{
 		  $invalid_array[$i]=$csv_data;
-	      $invalid_array[$i]['error'] = "Duplicate pattern found from import file";
+		  $invalid_array[$i]['error'] = "Duplicate pattern found from import file";
 		  }
 		  $pattern_arr[$csv_data['patterns']]=$pattern;
 	  }
 
-          $i++;
-        }
-          if(!empty($new_final_arr)){
-  	    $result = $this->package_model->bulk_insert_package_pattern($new_final_arr);
-          }
-       //unlink($full_path.$originationrate_file_name);
+		  $i++;
+		}
+		  if(!empty($new_final_arr)){
+  		$result = $this->package_model->bulk_insert_package_pattern($new_final_arr);
+		  }
+	   //unlink($full_path.$originationrate_file_name);
 	 $count=count($invalid_array);
 	 //echo "<pre>";print_r($count);exit;
-        if($count >0){
-            $session_id = "-1";
-            $fp = fopen($full_path.$session_id.'.csv', 'w');
-            foreach($new_final_arr_key as $key=>$value){
-	      $custom_array[0][$key]=ucfirst($key);
-            }
-            $custom_array[0]['error']= "Error";
-            $invalid_array =array_merge($custom_array,$invalid_array);
-            foreach($invalid_array as $err_data){
-                    fputcsv($fp,$err_data);
-            }
-            fclose($fp);
-           $this->session->set_userdata('import_package_code_csv_error', $session_id.".csv");
-           $data["error"] = $invalid_array;
-           $data['packageid'] = $edit_id;
-           $data['impoted_count'] = count($new_final_arr);
-           $data['failure_count'] = count($invalid_array)-1;
-           $data['page_title'] = 'Package Patterns Import Error';
-           //print_r($data)	;exit;
-           $this->load->view('view_import_error',$data);
-         } else{
+		if($count >0){
+			$session_id = "-1";
+			$fp = fopen($full_path.$session_id.'.csv', 'w');
+			foreach($new_final_arr_key as $key=>$value){
+		  $custom_array[0][$key]=ucfirst($key);
+			}
+			$custom_array[0]['error']= "Error";
+			$invalid_array =array_merge($custom_array,$invalid_array);
+			foreach($invalid_array as $err_data){
+					fputcsv($fp,$err_data);
+			}
+			fclose($fp);
+		   $this->session->set_userdata('import_package_code_csv_error', $session_id.".csv");
+		   $data["error"] = $invalid_array;
+		   $data['packageid'] = $edit_id;
+		   $data['impoted_count'] = count($new_final_arr);
+		   $data['failure_count'] = count($invalid_array)-1;
+		   $data['page_title'] = 'Package Patterns Import Error';
+		   //print_r($data)	;exit;
+		   $this->load->view('view_import_error',$data);
+		 } else{
 	   $this->session->set_flashdata('astpp_errormsg', 'Package patterns imported successfully!');
 	   //echo base_url()."package/package_pattern_list/" . $edit_id . "/";exit;
-           redirect(base_url()."package/package_pattern_list/" . $edit_id . "/");
-           }
-    }
+		   redirect(base_url()."package/package_pattern_list/" . $edit_id . "/");
+		   }
+	}
     
 	  function data_validate($csvdata){
-          $str=null;
+		  $str=null;
 	  $alpha_regex = "/^[a-z ,.'-]+$/i";
 	  $alpha_numeric_regex = "/^[a-z0-9 ,.'-]+$/i";
 	  $email_regex = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/"; 
 	  $str.= $csvdata['patterns']!= '' ? null : 'Code,';
 	  $str=rtrim($str,',');
 	  if(!$str){
-	      $str.= is_numeric($csvdata['patterns']) ? null : 'Code,';
+		  $str.= is_numeric($csvdata['patterns']) ? null : 'Code,';
 
 			$str.= preg_match( $alpha_numeric_regex, $csvdata['destination'] ) ? null :'Destination,';
 	      
-	      if($str){
+		  if($str){
 		$str=rtrim($str,',');
 		$error_field=explode(',',$str);
 		$count = count($error_field);
 		$str.= $count > 1 ? ' are not valid' : ' is not Valid';
 		return $str;
-	      }
-	      else{
-	      return false;
-	      }
+		  }
+		  else{
+		  return false;
+		  }
 	  }
 	  else{
 	  $str=rtrim($str,',');
-	    $error_field=explode(',',$str);
-	    $count = count($error_field);
-	    $str.= $count > 1 ? ' are required' : ' is Required';
-    return $str;
-    }
+		$error_field=explode(',',$str);
+		$count = count($error_field);
+		$str.= $count > 1 ? ' are required' : ' is Required';
+	return $str;
+	}
   }
     
-    function package_patterns_error_download(){
-        $this->load->helper('download');
-        $error_data =  $this->session->userdata('import_package_code_csv_error');
-        $full_path = $this->config->item('rates-file-path');
-        $data = file_get_contents($full_path.$error_data);
-        force_download("Package_Code_error.csv", $data); 
+	function package_patterns_error_download(){
+		$this->load->helper('download');
+		$error_data =  $this->session->userdata('import_package_code_csv_error');
+		$full_path = $this->config->item('rates-file-path');
+		$data = file_get_contents($full_path.$error_data);
+		force_download("Package_Code_error.csv", $data); 
 
 		}
 

web_interface/astpp/application/modules/package/libraries/package_form.php

Indentation +96 added lines, -96 removed lines

@@ -23,142 +23,142 @@
 ###############################################################################

 

 if (!defined('BASEPATH'))

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

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

 

 class Package_form {

 

-    function get_package_form_fields($id='') {

-        $form['forms'] = array(base_url() . 'package/package_save/'.$id."/",array('id'=>'packeage_form','method'=>'POST','name'=>'packeage_form'));

-        $form['Package Information'] = array(

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

-            array('', 'HIDDEN', array('name' => 'status', 'value' => '1'), '', '', ''),

-            array('Name', 'INPUT', array('name' => 'package_name', 'size' => '20',  'class' => "text field medium"), 'trim|required|xss_clean', 'tOOL TIP', ''),

-            array('Rate Group', 'pricelist_id', 'SELECT', '', 'dropdown', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id" => "0")),

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

+	function get_package_form_fields($id='') {

+		$form['forms'] = array(base_url() . 'package/package_save/'.$id."/",array('id'=>'packeage_form','method'=>'POST','name'=>'packeage_form'));

+		$form['Package Information'] = array(

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

+			array('', 'HIDDEN', array('name' => 'status', 'value' => '1'), '', '', ''),

+			array('Name', 'INPUT', array('name' => 'package_name', 'size' => '20',  'class' => "text field medium"), 'trim|required|xss_clean', 'tOOL TIP', ''),

+			array('Rate Group', 'pricelist_id', 'SELECT', '', 'dropdown', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id" => "0")),

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

 /**

 ASTPP  3.0 

 Add For Package Inbound or Outbound or both?

 **/   

-	    array('Applicable For?', 'applicable_for', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_package_type', ''),

+		array('Applicable For?', 'applicable_for', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_package_type', ''),

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

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

-        );

-        $form['button_cancel'] = array('name' => 'action', 'content' => 'Cancel', 'value' => 'cancel', 'type' => 'button', 'class' => 'btn btn-line-sky margin-x-10', 'onclick' => 'return redirect_page(\'/package/package_list/\')');

-        $form['button_save'] = array('name' => 'action', 'content' => 'Save', 'value' => 'save', 'type' => 'submit', 'class' => 'btn btn-line-parrot');

-

-        return $form;

-    }

-

-    function get_package_search_form() {

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

-        $form['Search'] = array(

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

-            array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id" => "0")),

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

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

+		);

+		$form['button_cancel'] = array('name' => 'action', 'content' => 'Cancel', 'value' => 'cancel', 'type' => 'button', 'class' => 'btn btn-line-sky margin-x-10', 'onclick' => 'return redirect_page(\'/package/package_list/\')');

+		$form['button_save'] = array('name' => 'action', 'content' => 'Save', 'value' => 'save', 'type' => 'submit', 'class' => 'btn btn-line-parrot');

+

+		return $form;

+	}

+

+	function get_package_search_form() {

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

+		$form['Search'] = array(

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

+			array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id" => "0")),

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

 /**

 ASTPP  3.0 

 Add For Package Inbound or Outbound or both?

 **/ 	    

- 	    array('Applicable For?', 'applicable_for', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_package_type', '',''),

+ 		array('Applicable For?', 'applicable_for', 'SELECT', '', '', 'tOOL TIP', '', '', '', '', 'set_package_type', '',''),

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

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

             

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

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

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

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

 

-        );

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

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

+		);

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

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

 

-        return $form;

-    }

+		return $form;

+	}

 

-    function build_package_list_for_admin() {

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

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

+	function build_package_list_for_admin() {

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

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

 /**

 ASTPP  3.0 

 For Package edit on Name

 **/ 

-            array("Name", "170", "package_name", "", "", "","EDITABLE","true","center"),

+			array("Name", "170", "package_name", "", "", "","EDITABLE","true","center"),

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

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

-            array("Included Seconds", "160", "includedseconds", "", "", "","","true","center"),

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

+			array("Included Seconds", "160", "includedseconds", "", "", "","","true","center"),

 /**

 ASTPP  3.0 

 Add For Package Inbound or Outbound or both?

 **/	    

-	    array("Applicable For?", "200", "applicable_for", "applicable_for", "applicable_for", "get_package_type","","true","center"),

+		array("Applicable For?", "200", "applicable_for", "applicable_for", "applicable_for", "get_package_type","","true","center"),

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

-	    /*

+		/*

             ASTPP  3.0 

             Creation date,last modified date show in grid

             */

-             array("Status", "140", "status", "status", "packages", "get_status","","true","center"),

-            array("Created Date", "120", "creation_date", "creation_date", "creation_date", "convert_GMT_to","","true","center"),

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

-            /***************************************************************/

-            /*

+			 array("Status", "140", "status", "status", "packages", "get_status","","true","center"),

+			array("Created Date", "120", "creation_date", "creation_date", "creation_date", "convert_GMT_to","","true","center"),

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

+			/***************************************************************/

+			/*

 	    ASTPP  3.0 

 	    status show active or inactive

 	    */

            

-            /********************************************/

-            array("Action", "160", "", "", "", array("EDIT" => array("url" => "package/package_edit/", "mode" => "single"),

-                    "DELETE" => array("url" => "package/package_delete/", "mode" => "single")))

-                ));

-        return $grid_field_arr;

-    }

-

-    function build_grid_buttons() {

-        $buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/package/package_add/"),

-            array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/package/package_delete_multiple/")

-            ));

-        return $buttons_json;

-    }

-

-

-

-    function build_package_counter_list_for_admin() {

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

-        $grid_field_arr = json_encode(array(array("Package Name", "430", "package_id", "package_name", "packages", "get_field_name","","true","center"),

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

-            array("Used Seconds", "420", "seconds", "", "", "","","true","center"),

-                ));

-        return $grid_field_arr;

-    }

-    function build_pattern_list_for_customer($packageid) {

-        $grid_field_arr = json_encode(array(

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

-            array("Code", "450", "patterns", "patterns", "", "get_only_numeric_val"),

-            array("Destination", "450", "destination", "", "", ""),

-            array("Action", "100", "", "", "", array("DELETE" => array("url" => "package/package_patterns_delete/$packageid/", "mode" => "single")))

-                ));

-        return $grid_field_arr;

-    }

-    function set_pattern_grid_buttons($packageid) {

-        $buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/package/customer_add_patterns/$packageid", "popup")));

-        return $buttons_json;

-    }

+			/********************************************/

+			array("Action", "160", "", "", "", array("EDIT" => array("url" => "package/package_edit/", "mode" => "single"),

+					"DELETE" => array("url" => "package/package_delete/", "mode" => "single")))

+				));

+		return $grid_field_arr;

+	}

+

+	function build_grid_buttons() {

+		$buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/package/package_add/"),

+			array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/package/package_delete_multiple/")

+			));

+		return $buttons_json;

+	}

+

+

+

+	function build_package_counter_list_for_admin() {

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

+		$grid_field_arr = json_encode(array(array("Package Name", "430", "package_id", "package_name", "packages", "get_field_name","","true","center"),

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

+			array("Used Seconds", "420", "seconds", "", "", "","","true","center"),

+				));

+		return $grid_field_arr;

+	}

+	function build_pattern_list_for_customer($packageid) {

+		$grid_field_arr = json_encode(array(

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

+			array("Code", "450", "patterns", "patterns", "", "get_only_numeric_val"),

+			array("Destination", "450", "destination", "", "", ""),

+			array("Action", "100", "", "", "", array("DELETE" => array("url" => "package/package_patterns_delete/$packageid/", "mode" => "single")))

+				));

+		return $grid_field_arr;

+	}

+	function set_pattern_grid_buttons($packageid) {

+		$buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/package/customer_add_patterns/$packageid", "popup")));

+		return $buttons_json;

+	}

 

 

 

 function build_package_counter_report() {

-        $buttons_json = json_encode(array(

-            array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/package/package_counter_report_export/", 'single')

+		$buttons_json = json_encode(array(

+			array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/package/package_counter_report_export/", 'single')

             

-            ));

-        return $buttons_json;

-    }

-    function build_package_list_for_reseller(){

-            $grid_field_arr = json_encode(array(

-            array("Name", "310", "package_name", "", "", "","","true","center"),

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

-            array("Included Seconds", "260", "includedseconds", "", "", "","","true","center"),

-            array("Status", "160", "status", "status", "status", "get_status","","true","center"),

-                ));

-        return $grid_field_arr;

-    }

+			));

+		return $buttons_json;

+	}

+	function build_package_list_for_reseller(){

+			$grid_field_arr = json_encode(array(

+			array("Name", "310", "package_name", "", "", "","","true","center"),

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

+			array("Included Seconds", "260", "includedseconds", "", "", "","","true","center"),

+			array("Status", "160", "status", "status", "status", "get_status","","true","center"),

+				));

+		return $grid_field_arr;

+	}

 

 

 }

web_interface/astpp/application/modules/package/views/view_package_add.php

Indentation +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
         <div class="w-section inverse no-padding">
             <?php echo $form; ?>
              <?php
-                if(isset($validation_errors) && $validation_errors != ''){ ?>
+				if(isset($validation_errors) && $validation_errors != ''){ ?>
                     <script>
                         var ERR_STR = '<?php echo $validation_errors; ?>';
                         print_error(ERR_STR);

web_interface/astpp/application/modules/package/views/view_import_package_code.php

Indentation +19 added lines, -19 removed lines

@@ -16,8 +16,8 @@ 
             	<div class="w-box">
                    <span  style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;">
                     <? if(isset($error) && !empty($error)) {
-                        echo $error;
-                    }?>
+						echo $error;
+					}?>
                    </span>            	
                    <h3 class="padding-t-10 padding-l-16">File must be in the following format(.csv):</h3>
                    <p>Code,Destination.</p>
@@ -36,7 +36,7 @@ 
                            </div>
 				<?
 				 $logintype=$this->session->userdata('userlevel_logintype');
-				       // $trunk=null;
+					   // $trunk=null;
 				 if($logintype !=1) { ?>
                            <div class="col-md-12 no-padding">
                               
@@ -98,7 +98,7 @@ 
 <?}?>    
         
 <?php
-    if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?>
+	if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?>
 
 <section class="slice color-three">
 	<div class="w-section inverse no-padding">
@@ -108,24 +108,24 @@ 
             <form id="import_form" name="import_form" action="<?=base_url()?>package/package_patterns_import_file/<?=$edit_id?>/<?=$check_header?>/" method="POST">
             <table width="100%" border="1"  class="details_table table">
                 <?  $cnt =7;
-                    foreach($csv_tmp_data as $csv_key => $csv_value){
-                        if($csv_key <  15){
-                            echo "<tr>";
-                            foreach($csv_value as $field_name => $field_val){
-                                if($csv_key == 0){
-                                    echo "<th>".ucfirst($field_name)."</th>";
-                                }else{
-                                    echo "<td class='portlet-content'>".$field_val."</td>";   
-                                }
-                            }
-                            echo "</tr>";
-                        }
-                    }
+					foreach($csv_tmp_data as $csv_key => $csv_value){
+						if($csv_key <  15){
+							echo "<tr>";
+							foreach($csv_value as $field_name => $field_val){
+								if($csv_key == 0){
+									echo "<th>".ucfirst($field_name)."</th>";
+								}else{
+									echo "<td class='portlet-content'>".$field_val."</td>";   
+								}
+							}
+							echo "</tr>";
+						}
+					}
                     
-                    echo "<tr><td colspan='".$cnt."'>
+					echo "<tr><td colspan='".$cnt."'>
                         <a href='".base_url()."package/package_patterns_import/$edit_id'><input type='button' class='btn btn-line-sky pull-right  margin-x-10' value='Back'/></a>
                         <input type='submit' class='btn btn-line-parrot pull-right' id='Process' value='Process'/></td></tr>";
-        ?> </table></form>  
+		?> </table></form>  
         </div>
 </div></div></div>
     </section>  

web_interface/astpp/application/modules/package/models/package_model.php

Indentation +147 added lines, -147 removed lines

@@ -22,88 +22,88 @@ 
 ###############################################################################
 class Package_model extends CI_Model {
 
-    function Package_model() {
-        parent::__construct();
-    }
+	function Package_model() {
+		parent::__construct();
+	}
 
-    function getpackage_list($flag, $start = 0, $limit = 0) {
-        $this->db_model->build_search('package_list_search');
-        if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
-            $account_data = $this->session->userdata("accountinfo");
-            $where = array("reseller_id" => $account_data['id']);
-        } else {
-            $where = array("reseller_id"=>"0");
-        }
-        if ($flag) {
-            $query = $this->db_model->select("*", "packages", $where, "id", "ASC", $limit, $start);
-        } else {
-            $query = $this->db_model->countQuery("*", "packages", $where);
-        }
-        return $query;
-    }
-    function get_reseller_package_list($flag,$accountid,$accounttype,$start = 0, $limit = 0){
-         $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_packages'); 
-     $instant_search_currency = $this->common_model->add_calculate_currency($instant_search, "", '', true, false);
-     $like_str=!empty($instant_search) ? "(package_name like '%$instant_search%'  
+	function getpackage_list($flag, $start = 0, $limit = 0) {
+		$this->db_model->build_search('package_list_search');
+		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
+			$account_data = $this->session->userdata("accountinfo");
+			$where = array("reseller_id" => $account_data['id']);
+		} else {
+			$where = array("reseller_id"=>"0");
+		}
+		if ($flag) {
+			$query = $this->db_model->select("*", "packages", $where, "id", "ASC", $limit, $start);
+		} else {
+			$query = $this->db_model->countQuery("*", "packages", $where);
+		}
+		return $query;
+	}
+	function get_reseller_package_list($flag,$accountid,$accounttype,$start = 0, $limit = 0){
+		 $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_packages'); 
+	 $instant_search_currency = $this->common_model->add_calculate_currency($instant_search, "", '', true, false);
+	 $like_str=!empty($instant_search) ? "(package_name like '%$instant_search%'  
                                         OR includedseconds like '%$instant_search%')":null;
-     $this->db->where('id',$accountid);
-     $this->db->select('pricelist_id');
-     $account_info=(array)$this->db->get('accounts')->first_row();     
-     $where=array('pricelist_id'=>$account_info['pricelist_id']);
-      if(!empty($like_str))
-      $this->db->where($like_str); 
-     if ($flag) {
-       $query = $this->db_model->select("*", "packages", $where, "id", "ASC", $limit, $start);
-     }else {
-       $query = $this->db_model->countQuery("*", "packages", $where);
-     }
-      return $query;
-    }
-    function add_package($add_array) {
-        if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
-            $account_data = $this->session->userdata("accountinfo");
-            $add_array["reseller_id"] = $account_data['id'];
-        }
-        unset($add_array["action"]);
-        /*
+	 $this->db->where('id',$accountid);
+	 $this->db->select('pricelist_id');
+	 $account_info=(array)$this->db->get('accounts')->first_row();     
+	 $where=array('pricelist_id'=>$account_info['pricelist_id']);
+	  if(!empty($like_str))
+	  $this->db->where($like_str); 
+	 if ($flag) {
+	   $query = $this->db_model->select("*", "packages", $where, "id", "ASC", $limit, $start);
+	 }else {
+	   $query = $this->db_model->countQuery("*", "packages", $where);
+	 }
+	  return $query;
+	}
+	function add_package($add_array) {
+		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
+			$account_data = $this->session->userdata("accountinfo");
+			$add_array["reseller_id"] = $account_data['id'];
+		}
+		unset($add_array["action"]);
+		/*
         ASTPP  3.0  Add creation date 
         */
-        $add_array['creation_date']=gmdate('Y-m-d H:i:s');
-        /*******************************************/
-        $this->db->insert("packages", $add_array);
-        return true;
-    }
+		$add_array['creation_date']=gmdate('Y-m-d H:i:s');
+		/*******************************************/
+		$this->db->insert("packages", $add_array);
+		return true;
+	}
 
-    function edit_package($data, $id) {
-        unset($data["action"]);
-        /*
+	function edit_package($data, $id) {
+		unset($data["action"]);
+		/*
         ASTPP  3.0  add last modified field.
         */
-        $data['last_modified_date']=gmdate('Y-m-d H:i:s');
-        /********************************************/
-        if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
-            $account_data = $this->session->userdata("accountinfo");
-            $add_array["reseller_id"] = $account_data['id'];
-        }
-        $this->db->where("id", $id);
-        $this->db->update("packages", $data);
-        return true;
-    }
+		$data['last_modified_date']=gmdate('Y-m-d H:i:s');
+		/********************************************/
+		if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) {
+			$account_data = $this->session->userdata("accountinfo");
+			$add_array["reseller_id"] = $account_data['id'];
+		}
+		$this->db->where("id", $id);
+		$this->db->update("packages", $data);
+		return true;
+	}
 
-    function remove_package($id) {
-        /* ASTPP  3.0 
+	function remove_package($id) {
+		/* ASTPP  3.0 
          * Remove Package information from table package_patterns as well.
         */
-        $this->db->where('package_id',$id);
-        $this->db->delete('package_patterns');
-        /***************************************/
-        $this->db->where("id", $id);
-        $this->db->delete("packages");
-        return true;
-    }
+		$this->db->where('package_id',$id);
+		$this->db->delete('package_patterns');
+		/***************************************/
+		$this->db->where("id", $id);
+		$this->db->delete("packages");
+		return true;
+	}
 
-    function getpackage_counter_list($flag, $start = 0, $limit = 0) {
-        $where = array();
+	function getpackage_counter_list($flag, $start = 0, $limit = 0) {
+		$where = array();
 	$accountinfo = $this->session->userdata('accountinfo');
 	$reseller_id=$accountinfo['type']== -1 ? 0 : $accountinfo['id'];
 	$this->db->where('reseller_id',$reseller_id);
@@ -114,109 +114,109 @@ 
 	  if($result->num_rows() >0){
 	  $acc_arr=array();
 	  $result=$result->result_array();
-	    foreach($result as $data){
-	      $acc_arr[]=$data['id'];
-	    }
-	    $this->db->where_in('accountid',$acc_arr);
-	    if($flag){
-	      $this->db->select('*');
-	    }
-	    else{
-	      $this->db->select('count(id) as count');
-	    }
-	    if($flag){
-	      $this->db->limit($limit, $start);
-	    }
-            if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-                $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-            }else{
-                $this->db->order_by('seconds','desc');
-            }
-	    $result=$this->db->get('counters');
+		foreach($result as $data){
+		  $acc_arr[]=$data['id'];
+		}
+		$this->db->where_in('accountid',$acc_arr);
+		if($flag){
+		  $this->db->select('*');
+		}
+		else{
+		  $this->db->select('count(id) as count');
+		}
+		if($flag){
+		  $this->db->limit($limit, $start);
+		}
+			if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+				$this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+			}else{
+				$this->db->order_by('seconds','desc');
+			}
+		$result=$this->db->get('counters');
 // 	    echo $this->db->last_query();exit;    
-	    if($flag){
-	      return $result;
-	    }else{
-	      $result=$result->result_array();
-	      return $result[0]['count'];
-	    }
+		if($flag){
+		  return $result;
+		}else{
+		  $result=$result->result_array();
+		  return $result[0]['count'];
+		}
 	  }else{
-            if($flag){
-                $query=(object)array('num_rows'=>0);
-            }
-            else{
-                $query=0;
-            }
+			if($flag){
+				$query=(object)array('num_rows'=>0);
+			}
+			else{
+				$query=0;
+			}
 	  return $query;
-        }
-    }else{
+		}
+	}else{
           
-         if($result->num_rows() >0){
-	    $acc_arr=array();
-	    $result=$result->result_array();
-	    foreach($result as $data){
-	      $acc_arr[]=$data['id'];
-	    }
-	    $this->db->where_in('accountid',$acc_arr);
+		 if($result->num_rows() >0){
+		$acc_arr=array();
+		$result=$result->result_array();
+		foreach($result as $data){
+		  $acc_arr[]=$data['id'];
+		}
+		$this->db->where_in('accountid',$acc_arr);
 	}
          
-         if($flag){
+		 if($flag){
 	  $this->db->select('*');
-         }
-         else{
-          $this->db->select('count(id) as count');
-         }
-         if($flag){
+		 }
+		 else{
+		  $this->db->select('count(id) as count');
+		 }
+		 if($flag){
 	  $this->db->order_by('seconds','desc');
 	  $this->db->limit($limit, $start);
-         }
-         $result=$this->db->get('counters');
+		 }
+		 $result=$this->db->get('counters');
 //  	echo $this->db->last_query();exit;              
-         if($result->num_rows() > 0){
-	      if($flag){
+		 if($result->num_rows() > 0){
+		  if($flag){
 	        
 		return $result;
-	      }else{
+		  }else{
 		$result=$result->result_array();
 		
 		return $result[0]['count'];
-	      }
-         }else{
-	      if($flag){
+		  }
+		 }else{
+		  if($flag){
 	          
 		  $query=(object)array('num_rows'=>0);
-	      }
-	      else{
+		  }
+		  else{
 		  $query=0;
-	      }
+		  }
 // 	echo $this->db->last_query();exit;    
 	return $query;
 	}
-    }
-    }
-    function insert_package_pattern($data, $packageid) {
+	}
+	}
+	function insert_package_pattern($data, $packageid) {
 
 		//echo "<pre>"; prit_r($data); exit;
-        $this->db->select("pattern,comment");
-        $this->db->where("id IN (".$data.")");
-        $result=$this->db->get("routes")->result_array();
+		$this->db->select("pattern,comment");
+		$this->db->where("id IN (".$data.")");
+		$result=$this->db->get("routes")->result_array();
        
-        $tmp = array();
-        foreach ($result as $key => $data_value) {
-            $tmp[$key]["package_id"] = $packageid;
-            $tmp[$key]["patterns"] = $data_value['pattern'];
-            $tmp[$key]["destination"] = $data_value['comment'];
-        } 
-        return $this->db->insert_batch("package_patterns", $tmp);
-    }
+		$tmp = array();
+		foreach ($result as $key => $data_value) {
+			$tmp[$key]["package_id"] = $packageid;
+			$tmp[$key]["patterns"] = $data_value['pattern'];
+			$tmp[$key]["destination"] = $data_value['comment'];
+		} 
+		return $this->db->insert_batch("package_patterns", $tmp);
+	}
     
     
-    function bulk_insert_package_pattern($inserted_array) {
+	function bulk_insert_package_pattern($inserted_array) {
 		  //echo "<pre>";print_r($inserted_array);exit;
-        $this->db->insert_batch('package_patterns', $inserted_array);
-        $affected_row = $this->db->affected_rows();
-        return $affected_row;
-    }
+		$this->db->insert_batch('package_patterns', $inserted_array);
+		$affected_row = $this->db->affected_rows();
+		return $affected_row;
+	}
 
 
 

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

Indentation +144 added lines, -144 removed lines

@@ -24,163 +24,163 @@
 
 class Refill_coupon extends MX_Controller {
     
-    function Refill_coupon(){
-	      parent::__construct();
-	      $this->load->helper('template_inheritance');
-	      $this->load->helper('form');
-	      $this->load->model('refill_coupon_model');
-	      $this->load->library("refill_coupon_form");
-	      $this->load->library("astpp/form");
-	      $this->load->library("session");
-	      if ($this->session->userdata('user_login') == FALSE)
-		    redirect(base_url() . 'login/login');
-      }
-    function refill_coupon_list(){
+	function Refill_coupon(){
+		  parent::__construct();
+		  $this->load->helper('template_inheritance');
+		  $this->load->helper('form');
+		  $this->load->model('refill_coupon_model');
+		  $this->load->library("refill_coupon_form");
+		  $this->load->library("astpp/form");
+		  $this->load->library("session");
+		  if ($this->session->userdata('user_login') == FALSE)
+			redirect(base_url() . 'login/login');
+	  }
+	function refill_coupon_list(){
 	if($this->session->userdata('logintype') == 0 || $this->session->userdata('logintype') == 3){
-            redirect(base_url() . 'user/user/');
+			redirect(base_url() . 'user/user/');
 	}
 		$data['username'] = $this->session->userdata('user_name');
-        $data['page_title'] = gettext('Refill Coupon');
-        $data['search_flag'] = true;
-        $this->session->set_userdata('advance_search', 0);
-        $this->session->set_userdata('refill_coupon_list_search', 0);
-        $data['grid_fields'] = $this->refill_coupon_form->build_refill_coupon_grid();
-        $data["grid_buttons"] = $this->refill_coupon_form->build_grid_buttons_refill_coupon();
-        $data['form_search'] = $this->form->build_serach_form($this->refill_coupon_form->get_refill_coupon_search_form());
-        $this->load->view('view_refill_coupon_list', $data);
-    }
-    function refill_coupon_list_json(){
+		$data['page_title'] = gettext('Refill Coupon');
+		$data['search_flag'] = true;
+		$this->session->set_userdata('advance_search', 0);
+		$this->session->set_userdata('refill_coupon_list_search', 0);
+		$data['grid_fields'] = $this->refill_coupon_form->build_refill_coupon_grid();
+		$data["grid_buttons"] = $this->refill_coupon_form->build_grid_buttons_refill_coupon();
+		$data['form_search'] = $this->form->build_serach_form($this->refill_coupon_form->get_refill_coupon_search_form());
+		$this->load->view('view_refill_coupon_list', $data);
+	}
+	function refill_coupon_list_json(){
 	$json_data = array();
-        $count_all = $this->refill_coupon_model->get_refill_coupon_list(false, "", "");
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-        $query = $this->refill_coupon_model->get_refill_coupon_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
-        $grid_fields = json_decode($this->refill_coupon_form->build_refill_coupon_grid());
-        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
-        echo json_encode($json_data);
-    }   
-    function refill_coupon_list_search(){
-        $ajax_search = $this->input->post('ajax_search', 0);
-        if ($this->input->post('advance_search', TRUE) == 1) {
-            $this->session->set_userdata('advance_search', $this->input->post('advance_search'));
-            $action = $this->input->post();
-            unset($action['action']);
-            unset($action['advance_search']);
-            if (isset($action['amount']['amount']) && $action['amount']['amount'] != '') {
-                $action['amount']['amount'] = $this->common_model->add_calculate_currency($action['amount']['amount'], "", '', true, false);
-            }
-            $this->session->set_userdata('refill_coupon_list_search', $action);
-        }
-        if (@$ajax_search != 1) {
-            redirect(base_url() . 'refill_coupon/refill_coupon_list/');
-        }
-    }
-    function refill_coupon_clearsearchfilter(){
+		$count_all = $this->refill_coupon_model->get_refill_coupon_list(false, "", "");
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+		$query = $this->refill_coupon_model->get_refill_coupon_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]);
+		$grid_fields = json_decode($this->refill_coupon_form->build_refill_coupon_grid());
+		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
+		echo json_encode($json_data);
+	}   
+	function refill_coupon_list_search(){
+		$ajax_search = $this->input->post('ajax_search', 0);
+		if ($this->input->post('advance_search', TRUE) == 1) {
+			$this->session->set_userdata('advance_search', $this->input->post('advance_search'));
+			$action = $this->input->post();
+			unset($action['action']);
+			unset($action['advance_search']);
+			if (isset($action['amount']['amount']) && $action['amount']['amount'] != '') {
+				$action['amount']['amount'] = $this->common_model->add_calculate_currency($action['amount']['amount'], "", '', true, false);
+			}
+			$this->session->set_userdata('refill_coupon_list_search', $action);
+		}
+		if (@$ajax_search != 1) {
+			redirect(base_url() . 'refill_coupon/refill_coupon_list/');
+		}
+	}
+	function refill_coupon_clearsearchfilter(){
 	$this->session->set_userdata('advance_search', 0);
-        $this->session->set_userdata('refill_coupon_list_search', "");
-    }
-    function refill_coupon_list_view($id){
-    $data['username'] = $this->session->userdata('user_name');
-        $data['page_title'] = 'View Refill Coupon';
-        if ($cc = $this->refill_coupon_model->get_refill_coupon_details($id)) {
-	    $refill_coupon_details=$cc->result_array();
-	    $data['refill_coupon_details']=$refill_coupon_details[0];
-            $data['refill_coupon_details']['callingcard']= $this->common->get_field_name('cardnumber', 'callingcards', $refill_coupon_details[0]['callingcard_id']);
-            $data['refill_coupon_details']['currency']= $this->common->build_concat_string('currencyname,currency', 'currency', $refill_coupon_details[0]['currency_id']);
-        } else {
-            echo "This card is not available.";
-            return;
-        }
-        $this->load->view('view_refill_coupon_details', $data);
+		$this->session->set_userdata('refill_coupon_list_search', "");
+	}
+	function refill_coupon_list_view($id){
+	$data['username'] = $this->session->userdata('user_name');
+		$data['page_title'] = 'View Refill Coupon';
+		if ($cc = $this->refill_coupon_model->get_refill_coupon_details($id)) {
+		$refill_coupon_details=$cc->result_array();
+		$data['refill_coupon_details']=$refill_coupon_details[0];
+			$data['refill_coupon_details']['callingcard']= $this->common->get_field_name('cardnumber', 'callingcards', $refill_coupon_details[0]['callingcard_id']);
+			$data['refill_coupon_details']['currency']= $this->common->build_concat_string('currencyname,currency', 'currency', $refill_coupon_details[0]['currency_id']);
+		} else {
+			echo "This card is not available.";
+			return;
+		}
+		$this->load->view('view_refill_coupon_details', $data);
     
-    }
-    function refill_coupon_add() {
+	}
+	function refill_coupon_add() {
 	if($this->session->userdata('logintype') == 0 || $this->session->userdata('logintype') == 3){
-            redirect(base_url() . 'user/user/');
+			redirect(base_url() . 'user/user/');
 	}
-        $data['username'] = $this->session->userdata('user_name');
-        $data['flag'] = 'create';
-        $data['page_title'] = 'Create Refill Coupon';
-        $data['form'] = $this->form->build_form($this->refill_coupon_form->get_refill_coupon_form_fields(), '');
-        $this->load->view('view_refill_coupon_add', $data);
-    }
-    function refill_coupon_save() {
-        $account_length=Common_model::$global_config['system_config']['refill_coupon_length'];
-        $add_array = $this->input->post();
-        $add_array['status']=0;
-        $data['form'] = $this->form->build_form($this->refill_coupon_form->get_refill_coupon_form_fields(), $add_array);
+		$data['username'] = $this->session->userdata('user_name');
+		$data['flag'] = 'create';
+		$data['page_title'] = 'Create Refill Coupon';
+		$data['form'] = $this->form->build_form($this->refill_coupon_form->get_refill_coupon_form_fields(), '');
+		$this->load->view('view_refill_coupon_add', $data);
+	}
+	function refill_coupon_save() {
+		$account_length=Common_model::$global_config['system_config']['refill_coupon_length'];
+		$add_array = $this->input->post();
+		$add_array['status']=0;
+		$data['form'] = $this->form->build_form($this->refill_coupon_form->get_refill_coupon_form_fields(), $add_array);
 	$result=$this->refill_coupon_model->refill_coupon_count($add_array);
-        $count=$result[0]['count'];
-        $remaining_length =0;
-        $remaining_length=$account_length - strlen($add_array['prefix']);
-        $currentlength =pow(5,$remaining_length);
-        $currentlength=$currentlength-$count;
-        $data['page_title'] = 'Add Refill Coupon';
-        if ($this->form_validation->run() == FALSE) {
-                $data['validation_errors'] = validation_errors();
-                echo $data['validation_errors'];
-                exit;
-        }
-        else {    
-    	  if($account_length<=strlen($add_array['prefix'])){
-    	      echo json_encode(array("count_error"=>"You Can Not Create ".$add_array['count']." Accounts with ".$add_array['prefix']." prefix."));
-    	      exit;      
-    	  }
-    	  if($currentlength <= 0){
-    		echo json_encode(array("count_error"=>"You Can Not Create ".$add_array['count']." Accounts with ".$add_array['prefix']." prefix"));
-    		exit;  
-    	  }
-    	  if($currentlength > 0 && $add_array['count'] > $currentlength){
-    		echo json_encode(array("count_error"=>"You Can Create Maximum ".$currentlength." accounts with ".$add_array['prefix']." prefix"));
-    		exit;      
-    	  }else{
-    	    $this->refill_coupon_model->add_refill_coupon($add_array);
-    	    echo json_encode(array("SUCCESS"=> "Refill coupon created successfully!"));
-    	    exit;
-    	  }
-    	}
-     }       
-    function refill_coupon_list_delete($id) {
-        $this->refill_coupon_model->remove_refill_coupon($id);
-        $this->session->set_flashdata('astpp_notification', 'Refill coupon removed successfully!');
-        redirect(base_url() . 'refill_coupon/refill_coupon_list/');
-    }
-    function refill_coupon_export(){
+		$count=$result[0]['count'];
+		$remaining_length =0;
+		$remaining_length=$account_length - strlen($add_array['prefix']);
+		$currentlength =pow(5,$remaining_length);
+		$currentlength=$currentlength-$count;
+		$data['page_title'] = 'Add Refill Coupon';
+		if ($this->form_validation->run() == FALSE) {
+				$data['validation_errors'] = validation_errors();
+				echo $data['validation_errors'];
+				exit;
+		}
+		else {    
+		  if($account_length<=strlen($add_array['prefix'])){
+			  echo json_encode(array("count_error"=>"You Can Not Create ".$add_array['count']." Accounts with ".$add_array['prefix']." prefix."));
+			  exit;      
+		  }
+		  if($currentlength <= 0){
+			echo json_encode(array("count_error"=>"You Can Not Create ".$add_array['count']." Accounts with ".$add_array['prefix']." prefix"));
+			exit;  
+		  }
+		  if($currentlength > 0 && $add_array['count'] > $currentlength){
+			echo json_encode(array("count_error"=>"You Can Create Maximum ".$currentlength." accounts with ".$add_array['prefix']." prefix"));
+			exit;      
+		  }else{
+			$this->refill_coupon_model->add_refill_coupon($add_array);
+			echo json_encode(array("SUCCESS"=> "Refill coupon created successfully!"));
+			exit;
+		  }
+		}
+	 }       
+	function refill_coupon_list_delete($id) {
+		$this->refill_coupon_model->remove_refill_coupon($id);
+		$this->session->set_flashdata('astpp_notification', 'Refill coupon removed successfully!');
+		redirect(base_url() . 'refill_coupon/refill_coupon_list/');
+	}
+	function refill_coupon_export(){
 	 $account_info = $accountinfo = $this->session->userdata('accountinfo');
 		$currency_id=$account_info['currency_id'];
 		$currency=$this->common->get_field_name('currency', 'currency', $currency_id);
 	$query = $this->refill_coupon_model->get_refill_coupon_list(true,'','',true);
-        $cc_array = array();
-        ob_clean();
-        $cc_array[] = array('Coupon No.','Description', 'Account','Amount('.$currency.')','Created Date',"Used?",'Used Date');
-        if ($query->num_rows() > 0) {
-            foreach ($query->result_array() as $row) {
-                $row['currency'] = $this->common->build_concat_string('currencyname,currency', 'currency', $row['currency_id']);
-                $row['acc_name'] = $row['account_id'] > 0 ? $this->common->get_field_name('number', 'accounts', $row['account_id']) : "";
-                $row['status']=$this->common->get_refill_coupon_status('','',$row['status']);
-                $cc_array[] = array(
-                    $row['number'],
-                    $row['description'],
-                    $row['acc_name'],
-                    $this->common->convert_to_currency('','',$row['amount']),
-                    $row['creation_date'],
-                    $row['status'],
-                    $row['firstused']
-                );
-            }
-        }
-        $this->load->helper('csv');
-        array_to_csv($cc_array, 'refill_coupon_' . date("Y-m-d") . '.csv');
-    }
-    function refill_coupon_customer_json($accountid){
+		$cc_array = array();
+		ob_clean();
+		$cc_array[] = array('Coupon No.','Description', 'Account','Amount('.$currency.')','Created Date',"Used?",'Used Date');
+		if ($query->num_rows() > 0) {
+			foreach ($query->result_array() as $row) {
+				$row['currency'] = $this->common->build_concat_string('currencyname,currency', 'currency', $row['currency_id']);
+				$row['acc_name'] = $row['account_id'] > 0 ? $this->common->get_field_name('number', 'accounts', $row['account_id']) : "";
+				$row['status']=$this->common->get_refill_coupon_status('','',$row['status']);
+				$cc_array[] = array(
+					$row['number'],
+					$row['description'],
+					$row['acc_name'],
+					$this->common->convert_to_currency('','',$row['amount']),
+					$row['creation_date'],
+					$row['status'],
+					$row['firstused']
+				);
+			}
+		}
+		$this->load->helper('csv');
+		array_to_csv($cc_array, 'refill_coupon_' . date("Y-m-d") . '.csv');
+	}
+	function refill_coupon_customer_json($accountid){
 	$json_data = array();
-        $count_all = $this->refill_coupon_model->get_customer_refill_coupon_list(false, "", "",$accountid);
-        $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
-        $json_data = $paging_data["json_paging"];
-        $query = $this->refill_coupon_model->get_customer_refill_coupon_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"],$accountid);
-        $grid_fields = json_decode($this->refill_coupon_form->build_user_refill_coupon_grid());
-        $json_data['rows'] = $this->form->build_grid($query, $grid_fields);
-        echo json_encode($json_data);
-    }
+		$count_all = $this->refill_coupon_model->get_customer_refill_coupon_list(false, "", "",$accountid);
+		$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']);
+		$json_data = $paging_data["json_paging"];
+		$query = $this->refill_coupon_model->get_customer_refill_coupon_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"],$accountid);
+		$grid_fields = json_decode($this->refill_coupon_form->build_user_refill_coupon_grid());
+		$json_data['rows'] = $this->form->build_grid($query, $grid_fields);
+		echo json_encode($json_data);
+	}
 } 
 ?>

web_interface/astpp/application/modules/refill_coupon/libraries/refill_coupon_form.php

Indentation +85 added lines, -85 removed lines

@@ -21,103 +21,103 @@
 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ###############################################################################
 if (!defined('BASEPATH'))
-    exit('No direct script access allowed');
+	exit('No direct script access allowed');
 
 class Refill_coupon_form {
-    function __construct($library_name = '') {
-        $this->CI = & get_instance();
-    }
-    function get_refill_coupon_form_fields(){
-        $form['forms'] = array(base_url() . 'refill_coupon/refill_coupon_save/',array("id" => "refill_coupon_form", "name" => "refill_coupon_form"));
-        $form['Coupon Information'] = array(
-	    array('Description', 'INPUT', array('name' => 'description', 'size' => '20',  'class' => "text field medium"), 'trim|xss_clean', 'tOOL TIP', 'Please Enter account number'),
-	    array('Start prefix', 'INPUT', array('name' => 'prefix', 'size' => '20',  'class' => "text field medium"), 'trim|required|numeric|xss_clean', 'tOOL TIP', ''),
-            array('Quantity', 'INPUT', array('name' => 'count', 'size' => '20', 'maxlength' => '5', 'class' => "text field medium"), 'trim|required|is_numeric|greater_than[0]|xss_clean', 'tOOL TIP', 'Please Enter account number'),
-            array('Amount', 'INPUT', array('name' => 'amount', 'size' => '20', 'class' => "text field medium"), 'trim|required|is_numeric|greater_than[0]|xss_clean', 'tOOL TIP', 'Please Enter account number'),
-        );
-       $form['button_cancel'] = array('name' => 'action', 'content' => 'Close', 'value' => 'cancel', 'type' => 'button', 'class' => 'btn btn-line-sky margin-x-10', 'onclick' => 'return redirect_page(\'NULL\')');
-        $form['button_save'] = array('name' => 'action', 'content' => 'Save', 'value' => 'save', 'id' => 'submit', 'type' => 'button', 'class' => 'btn btn-line-parrot');
+	function __construct($library_name = '') {
+		$this->CI = & get_instance();
+	}
+	function get_refill_coupon_form_fields(){
+		$form['forms'] = array(base_url() . 'refill_coupon/refill_coupon_save/',array("id" => "refill_coupon_form", "name" => "refill_coupon_form"));
+		$form['Coupon Information'] = array(
+		array('Description', 'INPUT', array('name' => 'description', 'size' => '20',  'class' => "text field medium"), 'trim|xss_clean', 'tOOL TIP', 'Please Enter account number'),
+		array('Start prefix', 'INPUT', array('name' => 'prefix', 'size' => '20',  'class' => "text field medium"), 'trim|required|numeric|xss_clean', 'tOOL TIP', ''),
+			array('Quantity', 'INPUT', array('name' => 'count', 'size' => '20', 'maxlength' => '5', 'class' => "text field medium"), 'trim|required|is_numeric|greater_than[0]|xss_clean', 'tOOL TIP', 'Please Enter account number'),
+			array('Amount', 'INPUT', array('name' => 'amount', 'size' => '20', 'class' => "text field medium"), 'trim|required|is_numeric|greater_than[0]|xss_clean', 'tOOL TIP', 'Please Enter account number'),
+		);
+	   $form['button_cancel'] = array('name' => 'action', 'content' => 'Close', 'value' => 'cancel', 'type' => 'button', 'class' => 'btn btn-line-sky margin-x-10', 'onclick' => 'return redirect_page(\'NULL\')');
+		$form['button_save'] = array('name' => 'action', 'content' => 'Save', 'value' => 'save', 'id' => 'submit', 'type' => 'button', 'class' => 'btn btn-line-parrot');
 
-        return $form;
-    } 
-    function build_grid_buttons_refill_coupon() {
-        $buttons_json = json_encode(array(
-	    array(gettext("Create"),"btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/refill_coupon/refill_coupon_add/","popup"),
-	    array(gettext("Export"),"btn btn-xing" ," fa fa-download fa-lg", "button_action", "/refill_coupon/refill_coupon_export/", 'single'),
-           ));
-        return $buttons_json;
-    }
-    function build_user_grid_buttons_refill_coupon() {
-        $buttons_json = json_encode(array(
-            array("Refresh", "reload", "/refill_coupon/refill_coupon_clearsearchfilter/")));
-        return $buttons_json;
-    }
-    function get_refill_coupon_search_form() {
-       $accountinfo=$this->CI->session->userdata('accountinfo');
-       $reseller_id=$accountinfo['type']== 1 ?$accountinfo['id'] :  0 ;
-        $form['forms'] = array("", array('id' => "refill_coupon_list_search"));
-        $form['Search'] = array(
-            array('Coupon Number', 'INPUT', array('name' => 'number[number]', '', 'id' => 'number', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'number[number-string]', '', '', '', 'search_string_type', ''),
-            array('Description', 'INPUT', array('name' => 'description[description]', '', 'id' => 'description', 'size' => '15','class' => "text field "), '', 'tOOL TIP', '1', 'description[description-string]', '', '', '', 'search_string_type', ''),
-           array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id,"type"=>"GLOBAL")),
-            array('Amount', 'INPUT', array('name' => 'amount[amount]', '', 'id' => 'amount', 'size' => '15',  'class' => "text field "), '', 'tOOL TIP', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),
-            array('Used?', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_refill_coupon_status', '', ''),
+		return $form;
+	} 
+	function build_grid_buttons_refill_coupon() {
+		$buttons_json = json_encode(array(
+		array(gettext("Create"),"btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/refill_coupon/refill_coupon_add/","popup"),
+		array(gettext("Export"),"btn btn-xing" ," fa fa-download fa-lg", "button_action", "/refill_coupon/refill_coupon_export/", 'single'),
+		   ));
+		return $buttons_json;
+	}
+	function build_user_grid_buttons_refill_coupon() {
+		$buttons_json = json_encode(array(
+			array("Refresh", "reload", "/refill_coupon/refill_coupon_clearsearchfilter/")));
+		return $buttons_json;
+	}
+	function get_refill_coupon_search_form() {
+	   $accountinfo=$this->CI->session->userdata('accountinfo');
+	   $reseller_id=$accountinfo['type']== 1 ?$accountinfo['id'] :  0 ;
+		$form['forms'] = array("", array('id' => "refill_coupon_list_search"));
+		$form['Search'] = array(
+			array('Coupon Number', 'INPUT', array('name' => 'number[number]', '', 'id' => 'number', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'number[number-string]', '', '', '', 'search_string_type', ''),
+			array('Description', 'INPUT', array('name' => 'description[description]', '', 'id' => 'description', 'size' => '15','class' => "text field "), '', 'tOOL TIP', '1', 'description[description-string]', '', '', '', 'search_string_type', ''),
+		   array('Account', 'accountid', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'IF(`deleted`=1,concat( first_name, " ", last_name, " ", "(", number, ")^" ),concat( first_name, " ", last_name, " ", "(", number, ")" )) as number', 'accounts', 'build_dropdown_deleted', 'where_arr', array("reseller_id" => $reseller_id,"type"=>"GLOBAL")),
+			array('Amount', 'INPUT', array('name' => 'amount[amount]', '', 'id' => 'amount', 'size' => '15',  'class' => "text field "), '', 'tOOL TIP', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),
+			array('Used?', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_refill_coupon_status', '', ''),
              
-            array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
-            array('', 'HIDDEN', 'advance_search', '1', '', '', ''),
-        );
-         $form['button_search'] = array('name' => 'action', 'id' => "refill_coupon_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');
-        $form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');
+			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
+			array('', 'HIDDEN', 'advance_search', '1', '', '', ''),
+		);
+		 $form['button_search'] = array('name' => 'action', 'id' => "refill_coupon_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right');
+		$form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');
 
-        return $form;
-    }
-    function get_user_refill_coupon_search_form() {
+		return $form;
+	}
+	function get_user_refill_coupon_search_form() {
 
-        $form['forms'] = array("", array('id' => "user_refill_coupon_list_search"));
-        $form['Search Refill Coupon'] = array(
-            array('Coupon Number', 'INPUT', array('name' => 'number[number]', '', 'id' => 'number', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'number[number-string]', '', '', '', 'search_string_type', ''),
-            array('Description', 'INPUT', array('name' => 'description[description]', '', 'id' => 'description', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'description[description-string]', '', '', '', 'search_string_type', ''),
-            array('Amount', 'INPUT', array('name' => 'amount[amount]', '', 'id' => 'amount', 'size' => '15',  'class' => "text field "), '', 'tOOL TIP', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),
-            array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_refill_coupon_status', '', ''),
-            array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
-            array('', 'HIDDEN', 'advance_search', '1', '', '', ''),
-        );
-        $form['button_search'] = array('name' => 'action', 'id' => "user_refill_coupon_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'ui-state-default float-right ui-corner-all ui-button');
-        $form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear Search Filter', 'value' => 'cancel', 'type' => 'reset', 'class' => 'ui-state-default float-right ui-corner-all ui-button');
-        return $form;
-    }
-    function build_refill_coupon_grid() {
+		$form['forms'] = array("", array('id' => "user_refill_coupon_list_search"));
+		$form['Search Refill Coupon'] = array(
+			array('Coupon Number', 'INPUT', array('name' => 'number[number]', '', 'id' => 'number', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'number[number-string]', '', '', '', 'search_string_type', ''),
+			array('Description', 'INPUT', array('name' => 'description[description]', '', 'id' => 'description', 'size' => '15', 'class' => "text field "), '', 'tOOL TIP', '1', 'description[description-string]', '', '', '', 'search_string_type', ''),
+			array('Amount', 'INPUT', array('name' => 'amount[amount]', '', 'id' => 'amount', 'size' => '15',  'class' => "text field "), '', 'tOOL TIP', '1', 'amount[amount-integer]', '', '', '', 'search_int_type', ''),
+			array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_refill_coupon_status', '', ''),
+			array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
+			array('', 'HIDDEN', 'advance_search', '1', '', '', ''),
+		);
+		$form['button_search'] = array('name' => 'action', 'id' => "user_refill_coupon_search_btn", 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'ui-state-default float-right ui-corner-all ui-button');
+		$form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear Search Filter', 'value' => 'cancel', 'type' => 'reset', 'class' => 'ui-state-default float-right ui-corner-all ui-button');
+		return $form;
+	}
+	function build_refill_coupon_grid() {
 		
 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
 		$currency_id=$account_info['currency_id'];
 		$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
 		
-        $grid_field_arr = json_encode(array(
-            array(gettext("Coupon Number"), "150", "number", "", "", "","","true","center"),
-            array(gettext("Description"), "165", "description", "", "", "","","true","center"),
-            array(gettext("Account"), "165", "account_id", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),
-            array("Amount($currency)", "150", "amount", "amount", "amount", "convert_to_currency","","true","right"),
-            array(gettext("Created Date"), "200", "creation_date", "", "", "","","true","center"),
-            array(gettext("Used?"),"135","status",'status','status','get_refill_coupon_used',"","true","center"),
-            array(gettext("Used Date"), "180", "firstused", "firstused", "firstused", "firstused_check","","true","center"),
-            array("Action", "120", "", "", "", array(
-                    "DELETE" => array("url" => "refill_coupon/refill_coupon_list_delete/", "mode" => "single")
-            ))
-                ));
-        return $grid_field_arr;
-    }
-    function build_user_refill_coupon_grid() {
+		$grid_field_arr = json_encode(array(
+			array(gettext("Coupon Number"), "150", "number", "", "", "","","true","center"),
+			array(gettext("Description"), "165", "description", "", "", "","","true","center"),
+			array(gettext("Account"), "165", "account_id", "first_name,last_name,number", "accounts", "build_concat_string","","true","center"),
+			array("Amount($currency)", "150", "amount", "amount", "amount", "convert_to_currency","","true","right"),
+			array(gettext("Created Date"), "200", "creation_date", "", "", "","","true","center"),
+			array(gettext("Used?"),"135","status",'status','status','get_refill_coupon_used',"","true","center"),
+			array(gettext("Used Date"), "180", "firstused", "firstused", "firstused", "firstused_check","","true","center"),
+			array("Action", "120", "", "", "", array(
+					"DELETE" => array("url" => "refill_coupon/refill_coupon_list_delete/", "mode" => "single")
+			))
+				));
+		return $grid_field_arr;
+	}
+	function build_user_refill_coupon_grid() {
 		$account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
-         $currency_id=$account_info['currency_id'];
-         $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
+		 $currency_id=$account_info['currency_id'];
+		 $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
 		 $grid_field_arr = json_encode(array(
-            array("Coupon Number", "230", "number", "", "", "","","true","center"),
-            array("Description", "210", "description", "", "", "","","true","center"),
-            array("Amount($currency)", "190", "amount", "amount", "amount", "convert_to_currency","","true","right"),
-            array("Created Date", "250", "creation_date", "", "", "","","true","center"),
-            array("Used Date", "250", "firstused", "firstused", "firstused", "firstused_check","","true","center"),
-                ));
-        return $grid_field_arr;
-    }
+			array("Coupon Number", "230", "number", "", "", "","","true","center"),
+			array("Description", "210", "description", "", "", "","","true","center"),
+			array("Amount($currency)", "190", "amount", "amount", "amount", "convert_to_currency","","true","right"),
+			array("Created Date", "250", "creation_date", "", "", "","","true","center"),
+			array("Used Date", "250", "firstused", "firstused", "firstused", "firstused_check","","true","center"),
+				));
+		return $grid_field_arr;
+	}
 }
 ?>

web_interface/astpp/application/modules/refill_coupon/views/view_refill_coupon_details.php

Indentation +4 added lines, -4 removed lines

@@ -49,10 +49,10 @@
           <th>Cost(CAD)</th>
         </tr>
         <?php foreach($cdrs as $cdr){
-	    $debit= '';
-	    $debit =($cdr['debit']/10000);
-	    $debit=$debit+0;
-        ?>
+		$debit= '';
+		$debit =($cdr['debit']/10000);
+		$debit=$debit+0;
+		?>
         <tr>
           <td><?=$cdr['destination']?></td>
           <td><?=$cdr['disposition']?></td>