iNextrix / ASTPP

web_interface/astpp/application/models/db_model.php

Indentation +823 added lines, -823 removed lines

@@ -23,438 +23,438 @@ 
 
 class Db_model extends CI_Model {
 
-    function Db_model() {
+	function Db_model() {
 //		parent::Model();		
-        parent::__construct();
-        $this->db->query("SET time_zone='+0:00'");
-    }
+		parent::__construct();
+		$this->db->query("SET time_zone='+0:00'");
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function getCriteria(Where=Condition in Array Format)
      * ******************************************************** */
 
-    function getCriteria($condition = "", $tableName) {
-        //print_r($condition);
-        if ($condition != "") {
-            $this->db->where($condition);
-        }
-        return $this->db->get($tableName);
-    }
+	function getCriteria($condition = "", $tableName) {
+		//print_r($condition);
+		if ($condition != "") {
+			$this->db->where($condition);
+		}
+		return $this->db->get($tableName);
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function save() for addingthe record
      * ******************************************************** */
 
-    function save($tableName, $arr, $val = 'false') {
-        $str = $this->db->insert_string($tableName, $arr);
-        $rs = $this->db->query($str);
-        if ($val == true)
-            return $this->db->insert_id();
-        else
-            return $rs;
-    }
+	function save($tableName, $arr, $val = 'false') {
+		$str = $this->db->insert_string($tableName, $arr);
+		$rs = $this->db->query($str);
+		if ($val == true)
+			return $this->db->insert_id();
+		else
+			return $rs;
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function update() for editing the record
      * ******************************************************** */
 
-    function update($tableName, $arr, $where) {
-        $str = $this->db->update_string($tableName, $arr, $where);
-        $rs = $this->db->query($str);
-        return $rs;
-    }
+	function update($tableName, $arr, $where) {
+		$str = $this->db->update_string($tableName, $arr, $where);
+		$rs = $this->db->query($str);
+		return $rs;
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function getSelect()n for displaying record
      * ******************************************************** */
 
-    function getSelect($select, $tableName, $where) {
-        $this->db->select($select, false);
-        $this->db->from($tableName);
-        if ($where != '') {
-            $this->db->where($where);
-        }
-        $query = $this->db->get();
-        return $query;
-    }
-
-    /*     * ********************************************************
+	function getSelect($select, $tableName, $where) {
+		$this->db->select($select, false);
+		$this->db->from($tableName);
+		if ($where != '') {
+			$this->db->where($where);
+		}
+		$query = $this->db->get();
+		return $query;
+	}
+
+	/*     * ********************************************************
       Function getSelectWithOrder()n for displaying record
      * ******************************************************** */
 
-    function getSelectWithOrder($select, $tableName, $where, $order_type, $order_by) {
-        $this->db->select($select);
-        $this->db->from($tableName);
-        $this->db->where($where);
-        $this->db->order_by($order_by,$order_type);
-        $query = $this->db->get();
-        return $query;
-    }
+	function getSelectWithOrder($select, $tableName, $where, $order_type, $order_by) {
+		$this->db->select($select);
+		$this->db->from($tableName);
+		$this->db->where($where);
+		$this->db->order_by($order_by,$order_type);
+		$query = $this->db->get();
+		return $query;
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function getSelectWithOrderAndLimit()n for displaying record
      * ******************************************************** */
 
-    function getSelectWithOrderAndLimit($select, $tableName, $where, $order_type, $order_by, $paging_limit) {
-        $this->db->select($select);
-        $this->db->from($tableName);
-        $this->db->where($where);
-        $this->db->order_by($order_by, $order_type);
-        $this->db->limit($paging_limit);
-        $query = $this->db->get();
-        return $query;
-    }
-
-    /*     * ********************************************************
+	function getSelectWithOrderAndLimit($select, $tableName, $where, $order_type, $order_by, $paging_limit) {
+		$this->db->select($select);
+		$this->db->from($tableName);
+		$this->db->where($where);
+		$this->db->order_by($order_by, $order_type);
+		$this->db->limit($paging_limit);
+		$query = $this->db->get();
+		return $query;
+	}
+
+	/*     * ********************************************************
       Function delete() for deletingthe record
      * ******************************************************** */
 
-    function delete($tableName, $where) {
-        $this->db->where($where);
-        $this->db->delete($tableName);
-    }
+	function delete($tableName, $where) {
+		$this->db->where($where);
+		$this->db->delete($tableName);
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function excecute() take compelet query
      * ******************************************************** */
 
-    function excecute($query) {
-        $rs = $this->db->query($query);
-        return $rs;
-    }
+	function excecute($query) {
+		$rs = $this->db->query($query);
+		return $rs;
+	}
 
-    /*     * ********************************************************
+	/*     * ********************************************************
       Function select() take full complete perms
      * ******************************************************** */
      
-    function select($select, $tableName, $where, $order_by, $order_type, $paging_limit = '', $start_limit = '', $groupby = '') {
-        $this->db->select($select);
-        $this->db->from($tableName);
-        if ($where != "") {
-            $this->db->where($where);
-        }
+	function select($select, $tableName, $where, $order_by, $order_type, $paging_limit = '', $start_limit = '', $groupby = '') {
+		$this->db->select($select);
+		$this->db->from($tableName);
+		if ($where != "") {
+			$this->db->where($where);
+		}
         
-        if ($paging_limit)
-            $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
-            $this->db->group_by($groupby);
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
-        }        
-        $query = $this->db->get();
-        return $query;
-    }
-
-    /*     * ********************************************************
+		if ($paging_limit)
+			$this->db->limit($paging_limit, $start_limit);
+		if (!empty($groupby))
+			$this->db->group_by($groupby);
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+		}else{
+		   if($order_by)
+			$this->db->order_by($order_by, $order_type);
+		}        
+		$query = $this->db->get();
+		return $query;
+	}
+
+	/*     * ********************************************************
       Function select for In query () take full complete perms
      * ******************************************************** */
 
-    function select_by_in($select, $tableName, $where, $order_by, $order_type, $paging_limit, $start_limit, $groupby = '', $key, $where_in) {
-        $this->db->select($select);
-        $this->db->from($tableName);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        $this->db->where_in($key, $where_in);
-        $this->db->order_by($order_by, $order_type);
-        if ($paging_limit)
-            $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
-            $this->db->groupby($groupby);
-        $query = $this->db->get();
-
-        return $query;
-    }
-
-    /*     * ********************************************************
+	function select_by_in($select, $tableName, $where, $order_by, $order_type, $paging_limit, $start_limit, $groupby = '', $key, $where_in) {
+		$this->db->select($select);
+		$this->db->from($tableName);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		$this->db->where_in($key, $where_in);
+		$this->db->order_by($order_by, $order_type);
+		if ($paging_limit)
+			$this->db->limit($paging_limit, $start_limit);
+		if (!empty($groupby))
+			$this->db->groupby($groupby);
+		$query = $this->db->get();
+
+		return $query;
+	}
+
+	/*     * ********************************************************
       Function countQuery() take table name and select feild
      * ******************************************************** */
 
-    function countQuery($select, $table, $where = "") {
-        $this->db->select($select);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        $this->db->from($table);
-        $query = $this->db->get();
-        return $query->num_rows();
-    }
-
-    /*     * ********************************************************
+	function countQuery($select, $table, $where = "") {
+		$this->db->select($select);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		$this->db->from($table);
+		$query = $this->db->get();
+		return $query->num_rows();
+	}
+
+	/*     * ********************************************************
       Function countQuery for where in query() take table name and select feild
      * ******************************************************** */
 
-    function countQuery_by_in($select, $table, $where = "", $key, $where_in) {
-        $this->db->select($select);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        if (!empty($where_in)) {
-            $this->db->where_in($key, $where_in);
-        }
-        $this->db->from($table);
-        $query = $this->db->get();
-        return $query->num_rows();
-    }
-
-    /*     * ********************************************************
+	function countQuery_by_in($select, $table, $where = "", $key, $where_in) {
+		$this->db->select($select);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		if (!empty($where_in)) {
+			$this->db->where_in($key, $where_in);
+		}
+		$this->db->from($table);
+		$query = $this->db->get();
+		return $query->num_rows();
+	}
+
+	/*     * ********************************************************
       Function maxQuery() take table name and select feild
      * ******************************************************** */
 
-    function maxQuery($table, $select, $where = "", $name) {
-
-        $this->db->select($select);
-        $this->db->from($table);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        $query = $this->db->get();
-        if ($query->num_rows() > 0) {
-            $rowP = $query->row();
-            return $rowP->$name;
-        } else {
-            return 0;
-        }
-    }
-
-    /*     * ********************************************************
+	function maxQuery($table, $select, $where = "", $name) {
+
+		$this->db->select($select);
+		$this->db->from($table);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		$query = $this->db->get();
+		if ($query->num_rows() > 0) {
+			$rowP = $query->row();
+			return $rowP->$name;
+		} else {
+			return 0;
+		}
+	}
+
+	/*     * ********************************************************
       Function getCurrent get current value of the feild
      * ******************************************************** */
 
-    function getCurrent($table, $feild, $where) {
+	function getCurrent($table, $feild, $where) {
 //		echo "<pre>table====><br>".$table."field====><br>".$feild."where====><br>".print_r($where);
-        $this->db->select($feild);
-        $this->db->from($table);
-        $this->db->where($where);
-        $query = $this->db->get();
-        if ($query->num_rows() > 0) {
-
-            $rowP = $query->row();
-            return $rowP->$feild;
-        } else {
-            return false;
-        }
-    }
-
-    /*     * ********************************************************
+		$this->db->select($feild);
+		$this->db->from($table);
+		$this->db->where($where);
+		$query = $this->db->get();
+		if ($query->num_rows() > 0) {
+
+			$rowP = $query->row();
+			return $rowP->$feild;
+		} else {
+			return false;
+		}
+	}
+
+	/*     * ********************************************************
       Function getJionQuery get result set on criteria
      * ******************************************************** */
 
-    function getJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
-        $this->db->select($feild);
-        $this->db->from($table);
-        $this->db->join($jionTable, $jionCondition, $type);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
-        }
-
-        if ($group_by != '') {
-            $this->db->group_by($group_by);
-        }
-
-        $this->db->limit($start, $end);
-
-        return $query = $this->db->get();
-    }
-
-    function getJionQueryCount($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
-        $this->db->select($feild);
-        $this->db->from($table);
-        $this->db->join($jionTable, $jionCondition, $type);
-        if ($where != "") {
-            $this->db->where($where);
-        }
-
-        if ($order_type != '' && $order_by != '') {
-            $this->db->orderby($order_type, $order_by);
-        }
-
-        if ($group_by != '') {
-            $this->db->group_by($group_by);
-        }
-
-
-        $query = $this->db->get();
-        return $query->num_rows();
-    }
-
-    function getAllJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type, $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
-        $this->db->select($feild);
-        $this->db->from($table);
-        $jion_table_count = count($jionTable);
-        for ($i = 0; $i < $jion_table_count; $i++) {
-            $this->db->join($jionTable[$i], $jionCondition[$i], $type[$i]);
-        }
-
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
-        }
-
-        if ($group_by != '') {
-            $this->db->group_by($group_by);
-        }
-
-        if ($start != '' && $end != '') {
-            $this->db->limit($start, $end);
-        }
-
-        if ($start != '' && $end == '') {
-            $this->db->limit($start);
-        }
-
-        return $query = $this->db->get();
-    }
-
-    function getCountWithJion($table, $feild, $where = "", $jionTable, $jionCondition, $type, $group_by = '') {
-        $this->db->select($feild);
-        $this->db->from($table);
-        $jion_table_count = count($jionTable);
-        for ($i = 0; $i < $jion_table_count; $i++) {
-            $this->db->join($jionTable[$i], $jionCondition[$i], $type[$i]);
-        }
-
-        if ($where != "") {
-            $this->db->where($where);
-        }
-        if ($group_by != '') {
-            $this->db->group_by($group_by);
-        }
-        $query = $this->db->get();
-        if ($query->num_rows() > 0) {
-            return $query->num_rows();	   
-        } else {
-            return false;
-        }
-    }
-
-    /*     * ********************************************************
+	function getJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
+		$start = (int) $start;
+		$end = (int) $end;
+		$this->db->select($feild);
+		$this->db->from($table);
+		$this->db->join($jionTable, $jionCondition, $type);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+		}else{
+		   if($order_by)
+			$this->db->order_by($order_by, $order_type);
+		}
+
+		if ($group_by != '') {
+			$this->db->group_by($group_by);
+		}
+
+		$this->db->limit($start, $end);
+
+		return $query = $this->db->get();
+	}
+
+	function getJionQueryCount($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
+		$start = (int) $start;
+		$end = (int) $end;
+		$this->db->select($feild);
+		$this->db->from($table);
+		$this->db->join($jionTable, $jionCondition, $type);
+		if ($where != "") {
+			$this->db->where($where);
+		}
+
+		if ($order_type != '' && $order_by != '') {
+			$this->db->orderby($order_type, $order_by);
+		}
+
+		if ($group_by != '') {
+			$this->db->group_by($group_by);
+		}
+
+
+		$query = $this->db->get();
+		return $query->num_rows();
+	}
+
+	function getAllJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type, $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
+		$start = (int) $start;
+		$end = (int) $end;
+		$this->db->select($feild);
+		$this->db->from($table);
+		$jion_table_count = count($jionTable);
+		for ($i = 0; $i < $jion_table_count; $i++) {
+			$this->db->join($jionTable[$i], $jionCondition[$i], $type[$i]);
+		}
+
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
+		  $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
+		}else{
+		   if($order_by)
+			$this->db->order_by($order_by, $order_type);
+		}
+
+		if ($group_by != '') {
+			$this->db->group_by($group_by);
+		}
+
+		if ($start != '' && $end != '') {
+			$this->db->limit($start, $end);
+		}
+
+		if ($start != '' && $end == '') {
+			$this->db->limit($start);
+		}
+
+		return $query = $this->db->get();
+	}
+
+	function getCountWithJion($table, $feild, $where = "", $jionTable, $jionCondition, $type, $group_by = '') {
+		$this->db->select($feild);
+		$this->db->from($table);
+		$jion_table_count = count($jionTable);
+		for ($i = 0; $i < $jion_table_count; $i++) {
+			$this->db->join($jionTable[$i], $jionCondition[$i], $type[$i]);
+		}
+
+		if ($where != "") {
+			$this->db->where($where);
+		}
+		if ($group_by != '') {
+			$this->db->group_by($group_by);
+		}
+		$query = $this->db->get();
+		if ($query->num_rows() > 0) {
+			return $query->num_rows();	   
+		} else {
+			return false;
+		}
+	}
+
+	/*     * ********************************************************
       Function getCurrentWithOrder
      * ******************************************************** */
 
-    function getCurrentWithOrder($table, $feild, $where, $order, $order_by, $limit, $option) {
-        $this->db->select($feild);
-        $this->db->from($table);
-        $this->db->where($where);
-        $this->db->order_by($order, $order_by);
-        if ($limit != 0) {
-            $this->db->limit($limit);
-        }
-        $query = $this->db->get();
-        if ($query->num_rows() > 0) {
-            $rowP = $query->row();
-            if ($option == 'yes') {
-                return $rowP->$feild;
-            } else {
-                return $query;
-            }
-        } else {
-            if ($option == 'no') {
-                return $query;
-            } else {
-                return false;
-            }
-        }
-    }
-
-    /*     * ********************************************************
+	function getCurrentWithOrder($table, $feild, $where, $order, $order_by, $limit, $option) {
+		$this->db->select($feild);
+		$this->db->from($table);
+		$this->db->where($where);
+		$this->db->order_by($order, $order_by);
+		if ($limit != 0) {
+			$this->db->limit($limit);
+		}
+		$query = $this->db->get();
+		if ($query->num_rows() > 0) {
+			$rowP = $query->row();
+			if ($option == 'yes') {
+				return $rowP->$feild;
+			} else {
+				return $query;
+			}
+		} else {
+			if ($option == 'no') {
+				return $query;
+			} else {
+				return false;
+			}
+		}
+	}
+
+	/*     * ********************************************************
       Function getReferPatients
      * ******************************************************** */
 
-    function getAllWithOrder($table, $feild, $where) {
-        $this->db->select($feild);
-        $this->db->from($table);
-        $this->db->where($where);
-        $query = $this->db->get();
-        if ($query->num_rows() > 0) {
-            $rowP = $query->row();
-            return $rowP->$feild;
-        } else {
-            return false;
-        }
-    }
-
-    function getCommaSperated($table, $select, $where, $limit, $return_message = FALSE, $message = '') {
-        if ($table != '') {
-            $this->db->select($select);
-            $this->db->from($table);
-            $this->db->where($where);
-            if ($limit != 0) {
-                $this->db->limit($limit);
-            }
-            $query = $this->db->get();
-            $string = '';
-            if ($query->num_rows() > 0) {
-                foreach ($query->result() as $rows) {
-                    $string .= $rows->$select . ',';
-                }
-
-                return substr($string, '', -1);
-            } else {
-                if ($return_message == FALSE) {
-                    return '';
-                } else {
-                    return $message;
-                }
-            }
-        } else {
-            return '';
-        }
-    }
-
-    function build_concat_dropdown($select, $table, $id_where = '', $id_value = '') {
-        $select_params = explode(',', $select);
-        if (isset($select_params[3])) {
-            $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
-        } else {
-            $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
-        }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
-        $logintype = $this->session->userdata('logintype');
-        if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
-            $account_data = $this->session->userdata("accountinfo");
-            $id_value['reseller_id'] = $account_data['id'];
-        }
-        if(isset($id_value['type']) && $id_value['type'] == '0,3'){
-            $twhere = "type IN (".$id_value["type"].")";
-            $this->db->where($twhere);
-            unset($id_value['type']);
-        }        
-        $where = $id_value;
-        $drp_array = $this->getSelect($select, $table, $where);
-        $drp_array = $drp_array->result();
-
-        $drp_list = array();
-        foreach ($drp_array as $drp_value) {
-            $drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
-        }
-        return $drp_list;
-    }
+	function getAllWithOrder($table, $feild, $where) {
+		$this->db->select($feild);
+		$this->db->from($table);
+		$this->db->where($where);
+		$query = $this->db->get();
+		if ($query->num_rows() > 0) {
+			$rowP = $query->row();
+			return $rowP->$feild;
+		} else {
+			return false;
+		}
+	}
+
+	function getCommaSperated($table, $select, $where, $limit, $return_message = FALSE, $message = '') {
+		if ($table != '') {
+			$this->db->select($select);
+			$this->db->from($table);
+			$this->db->where($where);
+			if ($limit != 0) {
+				$this->db->limit($limit);
+			}
+			$query = $this->db->get();
+			$string = '';
+			if ($query->num_rows() > 0) {
+				foreach ($query->result() as $rows) {
+					$string .= $rows->$select . ',';
+				}
+
+				return substr($string, '', -1);
+			} else {
+				if ($return_message == FALSE) {
+					return '';
+				} else {
+					return $message;
+				}
+			}
+		} else {
+			return '';
+		}
+	}
+
+	function build_concat_dropdown($select, $table, $id_where = '', $id_value = '') {
+		$select_params = explode(',', $select);
+		if (isset($select_params[3])) {
+			$cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
+		} else {
+			$cnt_str = " $select_params[1],' (',$select_params[2],')' ";
+		}
+		$select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
+		$logintype = $this->session->userdata('logintype');
+		if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
+			$account_data = $this->session->userdata("accountinfo");
+			$id_value['reseller_id'] = $account_data['id'];
+		}
+		if(isset($id_value['type']) && $id_value['type'] == '0,3'){
+			$twhere = "type IN (".$id_value["type"].")";
+			$this->db->where($twhere);
+			unset($id_value['type']);
+		}        
+		$where = $id_value;
+		$drp_array = $this->getSelect($select, $table, $where);
+		$drp_array = $drp_array->result();
+
+		$drp_list = array();
+		foreach ($drp_array as $drp_value) {
+			$drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
+		}
+		return $drp_list;
+	}
 /******
 ASTPP  3.0 
 Recording enable/disable dropdown
 ****/
-    function build_concat_dropdown_refill_coupon($select, $table, $id_where = '', $id_value = '') {
+	function build_concat_dropdown_refill_coupon($select, $table, $id_where = '', $id_value = '') {
 	$select_params = explode(',', $select);
 	$account_data = $this->session->userdata("accountinfo");
 	if (isset($select_params[3])) {
@@ -479,225 +479,225 @@ 
 		$drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
 	}
 	return $drp_list;
-    }
+	}
 /***********************************/
 function build_concat_select_dropdown($select, $table, $id_where = '', $id_value = '') {         
-        $select_params = explode(',', $select);
-        if (isset($select_params[3])) {
-            $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
-        } else {
-            $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
-        }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
+		$select_params = explode(',', $select);
+		if (isset($select_params[3])) {
+			$cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
+		} else {
+			$cnt_str = " $select_params[1],' (',$select_params[2],')' ";
+		}
+		$select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
 	$where = $id_value;
-        $drp_array = $this->getSelect($select, $table, $id_value);
-        $drp_array = $drp_array->result();
-
-        $drp_list = array();
-        $drp_list[0] = "--Select--";
-        foreach ($drp_array as $drp_value) {
-            $drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
-        }
-        return $drp_list;
-    }
-    function build_dropdown($select, $table, $id_where = '', $id_value = '') {
-        $select_params = explode(',', $select);
-        $where = '';
-        if(isset($id_value["type"]) && $id_value["type"] == "GLOBAL"){
-            $where = "type IN ('0','3')";
-            $this->db->where($where);
-            unset($id_value["type"]);
-        }
-        if ($id_where != '' && $id_value != '') {
-            if ($id_where == 'group_by') {
-                $this->db->group_by($id_value);
-            } else if ($id_where == "where_arr") {
-                $logintype = $this->session->userdata('logintype');
-                if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr' && $this->db->field_exists('reseller_id',$table)) {
-                    $id_value['reseller_id'] = $this->session->userdata["accountinfo"]['id'];
-                }
-                $where = $id_value;
-            } else {
-                $logintype = $this->session->userdata('logintype');
-                if (($logintype == 1 || $logintype == 5) && $id_where == 'reseller_id') {
-                    $account_data = $this->session->userdata("accountinfo");
-                    $id_value = $account_data['id'];
-                }
-                $where = array($id_where => $id_value);
-            }
-        }
-
-        $drp_array = $this->getSelect($select, $table, $where);
-        $drp_array = $drp_array->result();
-
-        $drp_list = array();
-        foreach ($drp_array as $drp_value) {
-            $drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
-        }
-        return $drp_list;
-    }
+		$drp_array = $this->getSelect($select, $table, $id_value);
+		$drp_array = $drp_array->result();
+
+		$drp_list = array();
+		$drp_list[0] = "--Select--";
+		foreach ($drp_array as $drp_value) {
+			$drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
+		}
+		return $drp_list;
+	}
+	function build_dropdown($select, $table, $id_where = '', $id_value = '') {
+		$select_params = explode(',', $select);
+		$where = '';
+		if(isset($id_value["type"]) && $id_value["type"] == "GLOBAL"){
+			$where = "type IN ('0','3')";
+			$this->db->where($where);
+			unset($id_value["type"]);
+		}
+		if ($id_where != '' && $id_value != '') {
+			if ($id_where == 'group_by') {
+				$this->db->group_by($id_value);
+			} else if ($id_where == "where_arr") {
+				$logintype = $this->session->userdata('logintype');
+				if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr' && $this->db->field_exists('reseller_id',$table)) {
+					$id_value['reseller_id'] = $this->session->userdata["accountinfo"]['id'];
+				}
+				$where = $id_value;
+			} else {
+				$logintype = $this->session->userdata('logintype');
+				if (($logintype == 1 || $logintype == 5) && $id_where == 'reseller_id') {
+					$account_data = $this->session->userdata("accountinfo");
+					$id_value = $account_data['id'];
+				}
+				$where = array($id_where => $id_value);
+			}
+		}
+
+		$drp_array = $this->getSelect($select, $table, $where);
+		$drp_array = $drp_array->result();
+
+		$drp_list = array();
+		foreach ($drp_array as $drp_value) {
+			$drp_list[$drp_value->$select_params[0]] = $drp_value->$select_params[1];
+		}
+		return $drp_list;
+	}
   function build_dropdown_deleted($select, $table, $id_where = '', $id_value = '') {
-        $select_params = explode(',', $select);
-        if(isset($id_value["type"]) ){
-            $where = $id_value["type"] == "GLOBAL" ? "type IN ('0','3')": "type IN (".$id_value["type"].")";
-            $this->db->where($where);
-            unset($id_value["type"]);
-        }
-        $where = '';
-        if ($id_where != '' && $id_value != '') {
-            if ($id_where == 'group_by') {
-                $this->db->group_by($id_value);
+		$select_params = explode(',', $select);
+		if(isset($id_value["type"]) ){
+			$where = $id_value["type"] == "GLOBAL" ? "type IN ('0','3')": "type IN (".$id_value["type"].")";
+			$this->db->where($where);
+			unset($id_value["type"]);
+		}
+		$where = '';
+		if ($id_where != '' && $id_value != '') {
+			if ($id_where == 'group_by') {
+				$this->db->group_by($id_value);
 
 	 } else if ($id_where == "where_arr") {
-                $logintype = $this->session->userdata('logintype');
-                if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
-                    $account_data = $this->session->userdata("accountinfo");
-                    $id_value['reseller_id'] = $account_data['id'];
-                }
-                $where = $id_value;
-            } else {
-                $logintype = $this->session->userdata('logintype');
-                if (($logintype == 1 || $logintype == 5) && $id_where == 'reseller_id') {
-                    $account_data = $this->session->userdata("accountinfo");
-                    $id_value = $account_data['id'];
-                }
-                $where = array($id_where => $id_value);
-            }
-        }
-
-        $drp_array = $this->getSelect($select, $table, $where);
-
-        $drp_array = $drp_array->result();
-
-        $name=explode("as",$select);
-        if(isset($name[3])){
-            $name=trim($name[3]);
-        }else{
-            $name=trim($name[1]);
-        }
-
-        $drp_list = array();
-        $dele =array();
-        foreach ($drp_array as $drp_value) {
-            $dele=explode("^",$drp_value->$name);
-            if(isset($dele[1]))
-            {
-               $drp_list['Deleted'][$drp_value->$select_params[0]] =  str_replace("^","",$drp_value->$name);
-            }else{
-               $drp_list['Active'][$drp_value->$select_params[0]] = $drp_value->$name;
-            }
-        }
+				$logintype = $this->session->userdata('logintype');
+				if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
+					$account_data = $this->session->userdata("accountinfo");
+					$id_value['reseller_id'] = $account_data['id'];
+				}
+				$where = $id_value;
+			} else {
+				$logintype = $this->session->userdata('logintype');
+				if (($logintype == 1 || $logintype == 5) && $id_where == 'reseller_id') {
+					$account_data = $this->session->userdata("accountinfo");
+					$id_value = $account_data['id'];
+				}
+				$where = array($id_where => $id_value);
+			}
+		}
+
+		$drp_array = $this->getSelect($select, $table, $where);
+
+		$drp_array = $drp_array->result();
+
+		$name=explode("as",$select);
+		if(isset($name[3])){
+			$name=trim($name[3]);
+		}else{
+			$name=trim($name[1]);
+		}
+
+		$drp_list = array();
+		$dele =array();
+		foreach ($drp_array as $drp_value) {
+			$dele=explode("^",$drp_value->$name);
+			if(isset($dele[1]))
+			{
+			   $drp_list['Deleted'][$drp_value->$select_params[0]] =  str_replace("^","",$drp_value->$name);
+			}else{
+			   $drp_list['Active'][$drp_value->$select_params[0]] = $drp_value->$name;
+			}
+		}
 	ksort($drp_list);
-        return $drp_list;
-    }
-
-    function build_search($accounts_list_search) {
-        if ($this->session->userdata('advance_search') == 1) {
-            $account_search = $this->session->userdata($accounts_list_search);
-            unset($account_search["ajax_search"]);
-            unset($account_search["advance_search"]);
-            /* ASTPP  3.0 
+		return $drp_list;
+	}
+
+	function build_search($accounts_list_search) {
+		if ($this->session->userdata('advance_search') == 1) {
+			$account_search = $this->session->userdata($accounts_list_search);
+			unset($account_search["ajax_search"]);
+			unset($account_search["advance_search"]);
+			/* ASTPP  3.0 
              Display Records in
             */
-            unset($account_search['search_in'],$account_search['time']);
-            if (!empty($account_search)) {
-                foreach ($account_search as $key => $value) {
-                    if ($value != "") {
-                        if (is_array($value)) {
-                            if (array_key_exists($key . "-integer", $value)) {
-                                $this->get_interger_array($key, $value[$key . "-integer"], $value[$key]);
-                            }
-                            if (array_key_exists($key . "-string", $value)) {
-                                $this->get_string_array($key, $value[$key . "-string"], $value[$key]);
-                            }
+			unset($account_search['search_in'],$account_search['time']);
+			if (!empty($account_search)) {
+				foreach ($account_search as $key => $value) {
+					if ($value != "") {
+						if (is_array($value)) {
+							if (array_key_exists($key . "-integer", $value)) {
+								$this->get_interger_array($key, $value[$key . "-integer"], $value[$key]);
+							}
+							if (array_key_exists($key . "-string", $value)) {
+								$this->get_string_array($key, $value[$key . "-string"], $value[$key]);
+							}
                             
-                            /**
+							/**
                             ASTPP  3.0 
                             first used,creation,expiry search date picker
-                            **/ 
-                            if ($key == 'callstart'||
-                                $key == 'date'||
-                                $key =='payment_date' ||
-                                $key == 'first_used'  ||
-                                $key == 'creation'  ||
-                                $key =='from_date'||
-                                $key =='invoice_date' ||
-                                $key =='expiry' ||
-                                $key =='created_date' ||
-                                $key=='to_date') {
-                            /***********************************************/
-                                $this->get_date_array($key, $value);
-                            }
-                        } else {
-                            $this->db->where($key, $value);
-                        }
+							 **/ 
+							if ($key == 'callstart'||
+								$key == 'date'||
+								$key =='payment_date' ||
+								$key == 'first_used'  ||
+								$key == 'creation'  ||
+								$key =='from_date'||
+								$key =='invoice_date' ||
+								$key =='expiry' ||
+								$key =='created_date' ||
+								$key=='to_date') {
+							/***********************************************/
+								$this->get_date_array($key, $value);
+							}
+						} else {
+							$this->db->where($key, $value);
+						}
                         
-                    }
-                }
+					}
+				}
 		return true;
-            }
-        }
-    }
+			}
+		}
+	}
 
-    function get_date_array($field, $value) {
-        if ($value != '') {
-             if (!empty($value[0])) {
+	function get_date_array($field, $value) {
+		if ($value != '') {
+			 if (!empty($value[0])) {
 				if($field == 'invoice_date'){
 					$this->db->where($field . ' >= ', gmdate("Y-m-d", strtotime($value['0']))." 00:00:01");
 					$this->db->where($field . ' <= ', gmdate("Y-m-d", strtotime($value['0']))." 23:59:59");
 				}else{
-                $this->db->where($field . ' >= ', gmdate('Y-m-d H:i:s',strtotime($value[0])));
+				$this->db->where($field . ' >= ', gmdate('Y-m-d H:i:s',strtotime($value[0])));
 				}
 			}
-            if (!empty($value[1])) {
-                $this->db->where($field . ' <= ', gmdate('Y-m-d H:i:s',strtotime($value[1])));
-            }
-        }
-    }
-
-    function get_interger_array($field, $value, $search_array) {	
-        if ($search_array != '') {
-            switch ($value) {
-                case "1":
-                    $this->db->where($field, $search_array);
-                    break;
-                case "2":
-                    $this->db->where($field . ' <>', $search_array);
-                    break;
-                case "3":
-                    $this->db->where($field . ' > ', $search_array);
-                    break;
-                case "4":
-                    $this->db->where($field . ' < ', $search_array);
-                    break;
-                case "5":
-                    $this->db->where($field . ' >= ', $search_array);
-                    break;
-                case "6":
-                    $this->db->where($field . ' <= ', $search_array);
-                    break;
-            }
-        }
-    }
-
-    function get_string_array($field, $value, $search_array) {
-        if ($search_array != '') {
-            switch ($value) {
-                case "1":
-                    $str1 = $field . " LIKE '%$search_array%'";
-                    $this->db->where($str1);
-                    break;
-                case "2":
-                    $str1 = $field . " NOT LIKE '%$search_array%'";
-                    $this->db->where($str1);
-                    break;
-                case "3":
-                    $this->db->where($field, $search_array);
-                    break;
-                case "4":
-                    $this->db->where($field . ' <>', $search_array);
-                    break;
-                case "5":
+			if (!empty($value[1])) {
+				$this->db->where($field . ' <= ', gmdate('Y-m-d H:i:s',strtotime($value[1])));
+			}
+		}
+	}
+
+	function get_interger_array($field, $value, $search_array) {	
+		if ($search_array != '') {
+			switch ($value) {
+				case "1":
+					$this->db->where($field, $search_array);
+					break;
+				case "2":
+					$this->db->where($field . ' <>', $search_array);
+					break;
+				case "3":
+					$this->db->where($field . ' > ', $search_array);
+					break;
+				case "4":
+					$this->db->where($field . ' < ', $search_array);
+					break;
+				case "5":
+					$this->db->where($field . ' >= ', $search_array);
+					break;
+				case "6":
+					$this->db->where($field . ' <= ', $search_array);
+					break;
+			}
+		}
+	}
+
+	function get_string_array($field, $value, $search_array) {
+		if ($search_array != '') {
+			switch ($value) {
+				case "1":
+					$str1 = $field . " LIKE '%$search_array%'";
+					$this->db->where($str1);
+					break;
+				case "2":
+					$str1 = $field . " NOT LIKE '%$search_array%'";
+					$this->db->where($str1);
+					break;
+				case "3":
+					$this->db->where($field, $search_array);
+					break;
+				case "4":
+					$this->db->where($field . ' <>', $search_array);
+					break;
+				case "5":
 					if($field == "pattern"){
 							$str1 = $field . " LIKE '^".$search_array."%'";
 							$this->db->where($str1);
@@ -706,8 +706,8 @@ 
 							$this->db->where($str1);
 					}
 
-                    break;
-                case "6":
+					break;
+				case "6":
 					if($field == "pattern"){
 							$str1 = $field . " LIKE '%".$search_array.".*'";
 							$this->db->where($str1);
@@ -716,293 +716,293 @@ 
 							$this->db->where($str1);
 					}		
 
-                    break;
-            }       
-        }
-    }
+					break;
+			}       
+		}
+	}
   function build_search_string($accounts_list_search) {
 	 $where = null;
 	 $search=$this->session->userdata($accounts_list_search);
-        if ($this->session->userdata('advance_search') == 1) {
-            $account_search = $this->session->userdata($accounts_list_search);
-            unset($account_search["ajax_search"]);
-            unset($account_search["advance_search"]);
-            if (!empty($account_search)) {
-                foreach ($account_search as $key => $value) {
-                    if ($value != "") {
-                        if (is_array($value)) {
-                            if (array_key_exists($key . "-integer", $value)) {
+		if ($this->session->userdata('advance_search') == 1) {
+			$account_search = $this->session->userdata($accounts_list_search);
+			unset($account_search["ajax_search"]);
+			unset($account_search["advance_search"]);
+			if (!empty($account_search)) {
+				foreach ($account_search as $key => $value) {
+					if ($value != "") {
+						if (is_array($value)) {
+							if (array_key_exists($key . "-integer", $value)) {
 				$string=null;
-                                $string =$this->build_interger_where($key, $value[$key . "-integer"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
-                            }
-                            if (array_key_exists($key . "-string", $value)) {
+								$string =$this->build_interger_where($key, $value[$key . "-integer"], $value[$key]);
+								if($string)
+								$where.= "$string AND ";
+							}
+							if (array_key_exists($key . "-string", $value)) {
 				$string=null;
-                                $string=$this->build_string_where($key, $value[$key . "-string"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
-                            }
-                            if ($key == 'callstart'|| $key == 'date'||$key== 'log_time') {
+								$string=$this->build_string_where($key, $value[$key . "-string"], $value[$key]);
+								if($string)
+								$where.= "$string AND ";
+							}
+							if ($key == 'callstart'|| $key == 'date'||$key== 'log_time') {
 				$string=null;
-                                $string=$this->build_date_where($key, $value);
-                                if($string)
-                                $where.= "$string AND ";
-                            }
-                        } else {
-			      $where.="$key = '$value'AND ";
-                        }
-                    }
-                }
-            }
-        }
-        $where =rtrim($where ," AND ");
-        return $where;
-    }
-    // This function using by reports module don't delete it
-    function build_string_where($field, $value, $search_array){
+								$string=$this->build_date_where($key, $value);
+								if($string)
+								$where.= "$string AND ";
+							}
+						} else {
+				  $where.="$key = '$value'AND ";
+						}
+					}
+				}
+			}
+		}
+		$where =rtrim($where ," AND ");
+		return $where;
+	}
+	// This function using by reports module don't delete it
+	function build_string_where($field, $value, $search_array){
 	$where=null;
-         if ($search_array != '') {
-            switch ($value) {
-                case "1":
-                    $where = "$field LIKE '%$search_array%'";
-                    break;
-                case "2":
-                    $where = "$field NOT LIKE '%$search_array%'";
-                    break;
-                case "3":
-                    $where = "$field = '$search_array'";
-                    break;
-                case "4":
-                    $where = "$field <> '$search_array'";
-                    break;
-                case "5":
-		    if($field == "pattern"){
-		      $where = $field . " LIKE '^".$search_array."%'";
-		    }else{
-		      $where = $field . " LIKE '".$search_array."%'";
-		    }
-                    break;
-                case "6":
-		    if($field == "pattern"){
-		       $str1 = $field . " LIKE '%".$search_array.".*'";
-		    }else{
-		       $str1 = $field . " LIKE '%".$search_array."'";
-		    }
-		    break;
-            }
-        }
-        return $where;
-    }
+		 if ($search_array != '') {
+			switch ($value) {
+				case "1":
+					$where = "$field LIKE '%$search_array%'";
+					break;
+				case "2":
+					$where = "$field NOT LIKE '%$search_array%'";
+					break;
+				case "3":
+					$where = "$field = '$search_array'";
+					break;
+				case "4":
+					$where = "$field <> '$search_array'";
+					break;
+				case "5":
+			if($field == "pattern"){
+			  $where = $field . " LIKE '^".$search_array."%'";
+			}else{
+			  $where = $field . " LIKE '".$search_array."%'";
+			}
+					break;
+				case "6":
+			if($field == "pattern"){
+			   $str1 = $field . " LIKE '%".$search_array.".*'";
+			}else{
+			   $str1 = $field . " LIKE '%".$search_array."'";
+			}
+			break;
+			}
+		}
+		return $where;
+	}
     
-    function build_interger_where($field, $value, $search_array) {
+	function build_interger_where($field, $value, $search_array) {
 	$where=null;
-        if ($search_array != '') {
-	    if(is_numeric($search_array))
-	    {
+		if ($search_array != '') {
+		if(is_numeric($search_array))
+		{
 		switch ($value) {
-		    case "1":
+			case "1":
 			$where = "$field = '$search_array'";
 			break;
-		    case "2":
+			case "2":
 			$where = "$field <> '$search_array'";
 			break;
-		    case "3":
+			case "3":
 			$where = "$field > '$search_array'";
 			break;
-		    case "4":
+			case "4":
 			$where = "$field < '$search_array'";
 			break;
-		    case "5":
+			case "5":
 			$where = "$field >= '$search_array'";
 			break;
-		    case "6":
+			case "6":
 			$where = "$field <= '$search_array'";
 			break;
 		}
-            }
-            else
-            {
-	      $this->db->where("$field IS NULL");
-	      $where= "$field IS NULL";
-            }
-        }
-        return $where;
-    }
-    function build_date_where($field, $value) {
+			}
+			else
+			{
+		  $this->db->where("$field IS NULL");
+		  $where= "$field IS NULL";
+			}
+		}
+		return $where;
+	}
+	function build_date_where($field, $value) {
 	$where =null;
-        if ($value != '') {
-            if (!empty($value[0])) {
+		if ($value != '') {
+			if (!empty($value[0])) {
 		$string=null;
-                $string="$field >= '$value[0]'";
-                if($string)
-                $where.=$string." AND ";
-            }
-            if (!empty($value[1])) {
+				$string="$field >= '$value[0]'";
+				if($string)
+				$where.=$string." AND ";
+			}
+			if (!empty($value[1])) {
 		$string=null;
-                $string="$field <= '$value[1]'";
-                if($string)
-                $where.=$string." AND ";
-            }
-        }
-        if($where){
+				$string="$field <= '$value[1]'";
+				if($string)
+				$where.=$string." AND ";
+			}
+		}
+		if($where){
 	  $where =rtrim($where," AND ");
-        }
-        return $where;
-    }
-    function get_available_bal($account_info) {
-        $available_bal = 0;
-        $available_bal = ($account_info["balance"]) + $account_info["posttoexternal"] * ($account_info["credit_limit"]);
-        return $available_bal;
-    }
-
-    function update_balance($amount, $accountid, $payment_type) {
-        if ($payment_type == "debit") {
-            $query = 'UPDATE `accounts` SET `balance` = (balance - ' . $amount . ') WHERE `id` = ' . $accountid;
-            return $this->db->query($query);
-        } else {
-            $query = 'UPDATE `accounts` SET `balance` = (balance + ' . $amount . ') WHERE `id` = ' . $accountid;
-            return $this->db->query($query);
-        }
-    }
-
-    function build_batch_update_array($update_array) {
-        $updateflg = false;
-        foreach ($update_array as $key => $update_fields) {
-            if (is_array($update_fields)) {
-                switch ($update_fields["operator"]) {
-                    case "1":
-                        //                        $this->db->where($field, $search_array);
-                        break;
-                    case "2":
-                        if($update_fields[$key] != ''){
-                            $updateflg = true;
-                            $this->db->set($key,$update_fields[$key]);    
-                        }
-                        break;
-                    case "3":
-                        $this->db->set($key, $key . "+" . $update_fields[$key], FALSE);
-                        $updateflg = true;
-                        break;
-                    case "4":
-                        $this->db->set($key, $key . "-" . $update_fields[$key], FALSE);
-                        $updateflg = true;
-                        break;
-                }
-            } else {
-                if ($update_fields != ""){
-                    $this->db->set($key,$update_fields);
-                    $updateflg = true;
-                }
-            }
-        }
-        return $updateflg;
-    }
-    function build_search_opensips($opensips_db_obj,$accounts_list_search) {
-        if ($this->session->userdata('advance_search') == 1) {
-            $account_search = $this->session->userdata($accounts_list_search);
-            unset($account_search["ajax_search"]);
-            unset($account_search["advance_search"]);
-            foreach ($account_search as $key => $value) {
-                if ($value != "") {
-                    if (is_array($value)) {
-                        if (array_key_exists($key . "-integer", $value)) {
-                            $this->get_opensips_interger_array($opensips_db_obj,$key, $value[$key . "-integer"], $value[$key]);
-                        }
-                        if (array_key_exists($key . "-string", $value)) {
-                            $this->get_opensips_string_array($opensips_db_obj,$key, $value[$key . "-string"], $value[$key]);
-                        }
-                    } else {
-                        $opensips_db_obj->where($key, $value);
-                    }
-                }
-            }
-        }
-    }
-
-    function get_opensips_interger_array($opensips_db_obj,$field, $value, $search_array) {
-        if ($search_array != '') {
-            switch ($value) {
-                case "1":
-                    $opensips_db_obj->where($field, $search_array);
-                    break;
-                case "2":
-                    $opensips_db_obj->where($field . ' <>', $search_array);
-                    break;
-                case "3":
-                    $opensips_db_obj->where($field . ' > ', $search_array);
-                    break;
-                case "4":
-                    $opensips_db_obj->where($field . ' < ', $search_array);
-                    break;
-                case "5":
-                    $opensips_db_obj->where($field . ' >= ', $search_array);
-                    break;
-                case "6":
-                    $opensips_db_obj->where($field . ' <= ', $search_array);
-                    break;
-            }
-        }
-    }
-
-    function get_opensips_string_array($opensips_db_obj,$field, $value, $search_array) {
-        if ($search_array != '') {
-            switch ($value) {
-                case "1":
-                    $opensips_db_obj->like($field, $search_array);
-                    break;
-                case "2":
-                    $opensips_db_obj->not_like($field, $search_array);
-                    break;
-                case "3":
-                    $opensips_db_obj->where($field, $search_array);
-                    break;
-                case "4":
-                    $opensips_db_obj->where($field . ' <>', $search_array);
-                    break;
-                case "5":
-		    $str1 = $field . " LIKE '".$search_array."%'";
-		    $opensips_db_obj->where($str1);
-		    break;
+		}
+		return $where;
+	}
+	function get_available_bal($account_info) {
+		$available_bal = 0;
+		$available_bal = ($account_info["balance"]) + $account_info["posttoexternal"] * ($account_info["credit_limit"]);
+		return $available_bal;
+	}
+
+	function update_balance($amount, $accountid, $payment_type) {
+		if ($payment_type == "debit") {
+			$query = 'UPDATE `accounts` SET `balance` = (balance - ' . $amount . ') WHERE `id` = ' . $accountid;
+			return $this->db->query($query);
+		} else {
+			$query = 'UPDATE `accounts` SET `balance` = (balance + ' . $amount . ') WHERE `id` = ' . $accountid;
+			return $this->db->query($query);
+		}
+	}
+
+	function build_batch_update_array($update_array) {
+		$updateflg = false;
+		foreach ($update_array as $key => $update_fields) {
+			if (is_array($update_fields)) {
+				switch ($update_fields["operator"]) {
+					case "1":
+						//                        $this->db->where($field, $search_array);
+						break;
+					case "2":
+						if($update_fields[$key] != ''){
+							$updateflg = true;
+							$this->db->set($key,$update_fields[$key]);    
+						}
+						break;
+					case "3":
+						$this->db->set($key, $key . "+" . $update_fields[$key], FALSE);
+						$updateflg = true;
+						break;
+					case "4":
+						$this->db->set($key, $key . "-" . $update_fields[$key], FALSE);
+						$updateflg = true;
+						break;
+				}
+			} else {
+				if ($update_fields != ""){
+					$this->db->set($key,$update_fields);
+					$updateflg = true;
+				}
+			}
+		}
+		return $updateflg;
+	}
+	function build_search_opensips($opensips_db_obj,$accounts_list_search) {
+		if ($this->session->userdata('advance_search') == 1) {
+			$account_search = $this->session->userdata($accounts_list_search);
+			unset($account_search["ajax_search"]);
+			unset($account_search["advance_search"]);
+			foreach ($account_search as $key => $value) {
+				if ($value != "") {
+					if (is_array($value)) {
+						if (array_key_exists($key . "-integer", $value)) {
+							$this->get_opensips_interger_array($opensips_db_obj,$key, $value[$key . "-integer"], $value[$key]);
+						}
+						if (array_key_exists($key . "-string", $value)) {
+							$this->get_opensips_string_array($opensips_db_obj,$key, $value[$key . "-string"], $value[$key]);
+						}
+					} else {
+						$opensips_db_obj->where($key, $value);
+					}
+				}
+			}
+		}
+	}
+
+	function get_opensips_interger_array($opensips_db_obj,$field, $value, $search_array) {
+		if ($search_array != '') {
+			switch ($value) {
+				case "1":
+					$opensips_db_obj->where($field, $search_array);
+					break;
+				case "2":
+					$opensips_db_obj->where($field . ' <>', $search_array);
+					break;
+				case "3":
+					$opensips_db_obj->where($field . ' > ', $search_array);
+					break;
+				case "4":
+					$opensips_db_obj->where($field . ' < ', $search_array);
+					break;
+				case "5":
+					$opensips_db_obj->where($field . ' >= ', $search_array);
+					break;
+				case "6":
+					$opensips_db_obj->where($field . ' <= ', $search_array);
+					break;
+			}
+		}
+	}
+
+	function get_opensips_string_array($opensips_db_obj,$field, $value, $search_array) {
+		if ($search_array != '') {
+			switch ($value) {
+				case "1":
+					$opensips_db_obj->like($field, $search_array);
+					break;
+				case "2":
+					$opensips_db_obj->not_like($field, $search_array);
+					break;
+				case "3":
+					$opensips_db_obj->where($field, $search_array);
+					break;
+				case "4":
+					$opensips_db_obj->where($field . ' <>', $search_array);
+					break;
+				case "5":
+			$str1 = $field . " LIKE '".$search_array."%'";
+			$opensips_db_obj->where($str1);
+			break;
 		case "6":
-		    $str1 = $field . " LIKE '%".$search_array."'";
-		    $opensips_db_obj->where($str1);
-		    break;
-            }
-        }
-    }
+			$str1 = $field . " LIKE '%".$search_array."'";
+			$opensips_db_obj->where($str1);
+			break;
+			}
+		}
+	}
 /********invoice changes *********/
   function build_dropdown_invoices($select, $table, $id_where = '', $id_value = '') {
-        $select_params = explode(',', $select);
-        $select_params = explode(',', $select);
-        if (isset($select_params[3])) {
-            $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
-        } else {
-            $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
-        }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ,".$select_params[4] ;
-        $logintype = $this->session->userdata('logintype');
-        if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
-            $account_data = $this->session->userdata("accountinfo");
-            $id_value['reseller_id'] = $account_data['id'];
-        }
-        $where = $id_value;
-        $drp_array = $this->getSelect($select, $table, $where);
-        $drp_array = $drp_array->result();
-        $drp_list = array();
-        foreach ($drp_array as $drp_value) {
-            if($drp_value->type == 3)
-            {
-               $drp_list['Provider'][$drp_value->id] = $drp_value->first_name;
-            }elseif($drp_value->type == 1){
-               $drp_list['Reseller'][$drp_value->id] = $drp_value->first_name;
-            }else{
-               $drp_list['Customer'][$drp_value->id] = $drp_value->first_name;
-            }
-        }
+		$select_params = explode(',', $select);
+		$select_params = explode(',', $select);
+		if (isset($select_params[3])) {
+			$cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' ";
+		} else {
+			$cnt_str = " $select_params[1],' (',$select_params[2],')' ";
+		}
+		$select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ,".$select_params[4] ;
+		$logintype = $this->session->userdata('logintype');
+		if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
+			$account_data = $this->session->userdata("accountinfo");
+			$id_value['reseller_id'] = $account_data['id'];
+		}
+		$where = $id_value;
+		$drp_array = $this->getSelect($select, $table, $where);
+		$drp_array = $drp_array->result();
+		$drp_list = array();
+		foreach ($drp_array as $drp_value) {
+			if($drp_value->type == 3)
+			{
+			   $drp_list['Provider'][$drp_value->id] = $drp_value->first_name;
+			}elseif($drp_value->type == 1){
+			   $drp_list['Reseller'][$drp_value->id] = $drp_value->first_name;
+			}else{
+			   $drp_list['Customer'][$drp_value->id] = $drp_value->first_name;
+			}
+		}
 	ksort($drp_list);
-        return $drp_list;
-    }
+		return $drp_list;
+	}
 }
 
 ?>

Spacing +155 added lines, -155 removed lines

@@ -86,7 +86,7 @@ 
         $this->db->select($select);
         $this->db->from($tableName);
         $this->db->where($where);
-        $this->db->order_by($order_by,$order_type);
+        $this->db->order_by($order_by, $order_type);
         $query = $this->db->get();
         return $query;
     }
@@ -136,12 +136,12 @@ 
         
         if ($paging_limit)
             $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
+        if ( ! empty($groupby))
             $this->db->group_by($groupby);
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
+        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+          $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+        } else {
+           if ($order_by)
             $this->db->order_by($order_by, $order_type);
         }        
         $query = $this->db->get();
@@ -162,7 +162,7 @@ 
         $this->db->order_by($order_by, $order_type);
         if ($paging_limit)
             $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
+        if ( ! empty($groupby))
             $this->db->groupby($groupby);
         $query = $this->db->get();
 
@@ -192,7 +192,7 @@ 
         if ($where != "") {
             $this->db->where($where);
         }
-        if (!empty($where_in)) {
+        if ( ! empty($where_in)) {
             $this->db->where_in($key, $where_in);
         }
         $this->db->from($table);
@@ -244,18 +244,18 @@ 
      * ******************************************************** */
 
     function getJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
+        $start = (int)$start;
+        $end = (int)$end;
         $this->db->select($feild);
         $this->db->from($table);
         $this->db->join($jionTable, $jionCondition, $type);
         if ($where != "") {
             $this->db->where($where);
         }
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
+        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+          $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+        } else {
+           if ($order_by)
             $this->db->order_by($order_by, $order_type);
         }
 
@@ -269,8 +269,8 @@ 
     }
 
     function getJionQueryCount($table, $feild, $where = "", $jionTable, $jionCondition, $type = 'inner', $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
+        $start = (int)$start;
+        $end = (int)$end;
         $this->db->select($feild);
         $this->db->from($table);
         $this->db->join($jionTable, $jionCondition, $type);
@@ -292,8 +292,8 @@ 
     }
 
     function getAllJionQuery($table, $feild, $where = "", $jionTable, $jionCondition, $type, $start = '', $end = '', $order_type = '', $order_by = '', $group_by = '') {
-        $start = (int) $start;
-        $end = (int) $end;
+        $start = (int)$start;
+        $end = (int)$end;
         $this->db->select($feild);
         $this->db->from($table);
         $jion_table_count = count($jionTable);
@@ -304,10 +304,10 @@ 
         if ($where != "") {
             $this->db->where($where);
         }
-        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
-          $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
+        if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined') {
+          $this->db->order_by($_GET['sortname'], ($_GET['sortorder'] == 'undefined') ? 'desc' : $_GET['sortorder']);
+        } else {
+           if ($order_by)
             $this->db->order_by($order_by, $order_type);
         }
 
@@ -406,7 +406,7 @@ 
             $string = '';
             if ($query->num_rows() > 0) {
                 foreach ($query->result() as $rows) {
-                    $string .= $rows->$select . ',';
+                    $string .= $rows->$select.',';
                 }
 
                 return substr($string, '', -1);
@@ -429,13 +429,13 @@ 
         } else {
             $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
         }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
+        $select = $select_params[0].", concat($cnt_str) as $select_params[1] ";
         $logintype = $this->session->userdata('logintype');
         if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
             $account_data = $this->session->userdata("accountinfo");
             $id_value['reseller_id'] = $account_data['id'];
         }
-        if(isset($id_value['type']) && $id_value['type'] == '0,3'){
+        if (isset($id_value['type']) && $id_value['type'] == '0,3') {
             $twhere = "type IN (".$id_value["type"].")";
             $this->db->where($twhere);
             unset($id_value['type']);
@@ -462,12 +462,12 @@ 
 	} else {
 		$cnt_str = " $select_params[1],' (',$select_params[2],')' ";
 	}
-	$select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
+	$select = $select_params[0].", concat($cnt_str) as $select_params[1] ";
 	$logintype = $this->session->userdata('logintype');
 	if ($account_data['type'] == 1 && $id_where == 'where_arr') {
 	  $id_value['reseller_id'] = $account_data['id'];
-	}else{
-	  $this->db->or_where('type',3);
+	} else {
+	  $this->db->or_where('type', 3);
 	}
 	$where = $id_value;
 	$this->db->where($where);
@@ -488,7 +488,7 @@ 
         } else {
             $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
         }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ";
+        $select = $select_params[0].", concat($cnt_str) as $select_params[1] ";
 	$where = $id_value;
         $drp_array = $this->getSelect($select, $table, $id_value);
         $drp_array = $drp_array->result();
@@ -503,7 +503,7 @@ 
     function build_dropdown($select, $table, $id_where = '', $id_value = '') {
         $select_params = explode(',', $select);
         $where = '';
-        if(isset($id_value["type"]) && $id_value["type"] == "GLOBAL"){
+        if (isset($id_value["type"]) && $id_value["type"] == "GLOBAL") {
             $where = "type IN ('0','3')";
             $this->db->where($where);
             unset($id_value["type"]);
@@ -513,7 +513,7 @@ 
                 $this->db->group_by($id_value);
             } else if ($id_where == "where_arr") {
                 $logintype = $this->session->userdata('logintype');
-                if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr' && $this->db->field_exists('reseller_id',$table)) {
+                if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr' && $this->db->field_exists('reseller_id', $table)) {
                     $id_value['reseller_id'] = $this->session->userdata["accountinfo"]['id'];
                 }
                 $where = $id_value;
@@ -538,8 +538,8 @@ 
     }
   function build_dropdown_deleted($select, $table, $id_where = '', $id_value = '') {
         $select_params = explode(',', $select);
-        if(isset($id_value["type"]) ){
-            $where = $id_value["type"] == "GLOBAL" ? "type IN ('0','3')": "type IN (".$id_value["type"].")";
+        if (isset($id_value["type"])) {
+            $where = $id_value["type"] == "GLOBAL" ? "type IN ('0','3')" : "type IN (".$id_value["type"].")";
             $this->db->where($where);
             unset($id_value["type"]);
         }
@@ -569,21 +569,21 @@ 
 
         $drp_array = $drp_array->result();
 
-        $name=explode("as",$select);
-        if(isset($name[3])){
-            $name=trim($name[3]);
-        }else{
-            $name=trim($name[1]);
+        $name = explode("as", $select);
+        if (isset($name[3])) {
+            $name = trim($name[3]);
+        } else {
+            $name = trim($name[1]);
         }
 
         $drp_list = array();
-        $dele =array();
+        $dele = array();
         foreach ($drp_array as $drp_value) {
-            $dele=explode("^",$drp_value->$name);
-            if(isset($dele[1]))
+            $dele = explode("^", $drp_value->$name);
+            if (isset($dele[1]))
             {
-               $drp_list['Deleted'][$drp_value->$select_params[0]] =  str_replace("^","",$drp_value->$name);
-            }else{
+               $drp_list['Deleted'][$drp_value->$select_params[0]] = str_replace("^", "", $drp_value->$name);
+            } else {
                $drp_list['Active'][$drp_value->$select_params[0]] = $drp_value->$name;
             }
         }
@@ -599,32 +599,32 @@ 
             /* ASTPP  3.0 
              Display Records in
             */
-            unset($account_search['search_in'],$account_search['time']);
-            if (!empty($account_search)) {
+            unset($account_search['search_in'], $account_search['time']);
+            if ( ! empty($account_search)) {
                 foreach ($account_search as $key => $value) {
                     if ($value != "") {
                         if (is_array($value)) {
-                            if (array_key_exists($key . "-integer", $value)) {
-                                $this->get_interger_array($key, $value[$key . "-integer"], $value[$key]);
+                            if (array_key_exists($key."-integer", $value)) {
+                                $this->get_interger_array($key, $value[$key."-integer"], $value[$key]);
                             }
-                            if (array_key_exists($key . "-string", $value)) {
-                                $this->get_string_array($key, $value[$key . "-string"], $value[$key]);
+                            if (array_key_exists($key."-string", $value)) {
+                                $this->get_string_array($key, $value[$key."-string"], $value[$key]);
                             }
                             
                             /**
                             ASTPP  3.0 
                             first used,creation,expiry search date picker
                             **/ 
-                            if ($key == 'callstart'||
-                                $key == 'date'||
-                                $key =='payment_date' ||
-                                $key == 'first_used'  ||
-                                $key == 'creation'  ||
-                                $key =='from_date'||
-                                $key =='invoice_date' ||
-                                $key =='expiry' ||
-                                $key =='created_date' ||
-                                $key=='to_date') {
+                            if ($key == 'callstart' ||
+                                $key == 'date' ||
+                                $key == 'payment_date' ||
+                                $key == 'first_used' ||
+                                $key == 'creation' ||
+                                $key == 'from_date' ||
+                                $key == 'invoice_date' ||
+                                $key == 'expiry' ||
+                                $key == 'created_date' ||
+                                $key == 'to_date') {
                             /***********************************************/
                                 $this->get_date_array($key, $value);
                             }
@@ -641,16 +641,16 @@ 
 
     function get_date_array($field, $value) {
         if ($value != '') {
-             if (!empty($value[0])) {
-				if($field == 'invoice_date'){
-					$this->db->where($field . ' >= ', gmdate("Y-m-d", strtotime($value['0']))." 00:00:01");
-					$this->db->where($field . ' <= ', gmdate("Y-m-d", strtotime($value['0']))." 23:59:59");
-				}else{
-                $this->db->where($field . ' >= ', gmdate('Y-m-d H:i:s',strtotime($value[0])));
+             if ( ! empty($value[0])) {
+				if ($field == 'invoice_date') {
+					$this->db->where($field.' >= ', gmdate("Y-m-d", strtotime($value['0']))." 00:00:01");
+					$this->db->where($field.' <= ', gmdate("Y-m-d", strtotime($value['0']))." 23:59:59");
+				} else {
+                $this->db->where($field.' >= ', gmdate('Y-m-d H:i:s', strtotime($value[0])));
 				}
 			}
-            if (!empty($value[1])) {
-                $this->db->where($field . ' <= ', gmdate('Y-m-d H:i:s',strtotime($value[1])));
+            if ( ! empty($value[1])) {
+                $this->db->where($field.' <= ', gmdate('Y-m-d H:i:s', strtotime($value[1])));
             }
         }
     }
@@ -662,19 +662,19 @@ 
                     $this->db->where($field, $search_array);
                     break;
                 case "2":
-                    $this->db->where($field . ' <>', $search_array);
+                    $this->db->where($field.' <>', $search_array);
                     break;
                 case "3":
-                    $this->db->where($field . ' > ', $search_array);
+                    $this->db->where($field.' > ', $search_array);
                     break;
                 case "4":
-                    $this->db->where($field . ' < ', $search_array);
+                    $this->db->where($field.' < ', $search_array);
                     break;
                 case "5":
-                    $this->db->where($field . ' >= ', $search_array);
+                    $this->db->where($field.' >= ', $search_array);
                     break;
                 case "6":
-                    $this->db->where($field . ' <= ', $search_array);
+                    $this->db->where($field.' <= ', $search_array);
                     break;
             }
         }
@@ -684,35 +684,35 @@ 
         if ($search_array != '') {
             switch ($value) {
                 case "1":
-                    $str1 = $field . " LIKE '%$search_array%'";
+                    $str1 = $field." LIKE '%$search_array%'";
                     $this->db->where($str1);
                     break;
                 case "2":
-                    $str1 = $field . " NOT LIKE '%$search_array%'";
+                    $str1 = $field." NOT LIKE '%$search_array%'";
                     $this->db->where($str1);
                     break;
                 case "3":
                     $this->db->where($field, $search_array);
                     break;
                 case "4":
-                    $this->db->where($field . ' <>', $search_array);
+                    $this->db->where($field.' <>', $search_array);
                     break;
                 case "5":
-					if($field == "pattern"){
-							$str1 = $field . " LIKE '^".$search_array."%'";
+					if ($field == "pattern") {
+							$str1 = $field." LIKE '^".$search_array."%'";
 							$this->db->where($str1);
-					}else{
-							$str1 = $field . " LIKE '".$search_array."%'";
+					} else {
+							$str1 = $field." LIKE '".$search_array."%'";
 							$this->db->where($str1);
 					}
 
                     break;
                 case "6":
-					if($field == "pattern"){
-							$str1 = $field . " LIKE '%".$search_array.".*'";
+					if ($field == "pattern") {
+							$str1 = $field." LIKE '%".$search_array.".*'";
 							$this->db->where($str1);
-					}else{
-							$str1 = $field . " LIKE '%".$search_array."'";
+					} else {
+							$str1 = $field." LIKE '%".$search_array."'";
 							$this->db->where($str1);
 					}		
 
@@ -722,46 +722,46 @@ 
     }
   function build_search_string($accounts_list_search) {
 	 $where = null;
-	 $search=$this->session->userdata($accounts_list_search);
+	 $search = $this->session->userdata($accounts_list_search);
         if ($this->session->userdata('advance_search') == 1) {
             $account_search = $this->session->userdata($accounts_list_search);
             unset($account_search["ajax_search"]);
             unset($account_search["advance_search"]);
-            if (!empty($account_search)) {
+            if ( ! empty($account_search)) {
                 foreach ($account_search as $key => $value) {
                     if ($value != "") {
                         if (is_array($value)) {
-                            if (array_key_exists($key . "-integer", $value)) {
-				$string=null;
-                                $string =$this->build_interger_where($key, $value[$key . "-integer"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
+                            if (array_key_exists($key."-integer", $value)) {
+				$string = null;
+                                $string = $this->build_interger_where($key, $value[$key."-integer"], $value[$key]);
+                                if ($string)
+                                $where .= "$string AND ";
                             }
-                            if (array_key_exists($key . "-string", $value)) {
-				$string=null;
-                                $string=$this->build_string_where($key, $value[$key . "-string"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
+                            if (array_key_exists($key."-string", $value)) {
+				$string = null;
+                                $string = $this->build_string_where($key, $value[$key."-string"], $value[$key]);
+                                if ($string)
+                                $where .= "$string AND ";
                             }
-                            if ($key == 'callstart'|| $key == 'date'||$key== 'log_time') {
-				$string=null;
-                                $string=$this->build_date_where($key, $value);
-                                if($string)
-                                $where.= "$string AND ";
+                            if ($key == 'callstart' || $key == 'date' || $key == 'log_time') {
+				$string = null;
+                                $string = $this->build_date_where($key, $value);
+                                if ($string)
+                                $where .= "$string AND ";
                             }
                         } else {
-			      $where.="$key = '$value'AND ";
+			      $where .= "$key = '$value'AND ";
                         }
                     }
                 }
             }
         }
-        $where =rtrim($where ," AND ");
+        $where = rtrim($where, " AND ");
         return $where;
     }
     // This function using by reports module don't delete it
-    function build_string_where($field, $value, $search_array){
-	$where=null;
+    function build_string_where($field, $value, $search_array) {
+	$where = null;
          if ($search_array != '') {
             switch ($value) {
                 case "1":
@@ -777,17 +777,17 @@ 
                     $where = "$field <> '$search_array'";
                     break;
                 case "5":
-		    if($field == "pattern"){
-		      $where = $field . " LIKE '^".$search_array."%'";
-		    }else{
-		      $where = $field . " LIKE '".$search_array."%'";
+		    if ($field == "pattern") {
+		      $where = $field." LIKE '^".$search_array."%'";
+		    } else {
+		      $where = $field." LIKE '".$search_array."%'";
 		    }
                     break;
                 case "6":
-		    if($field == "pattern"){
-		       $str1 = $field . " LIKE '%".$search_array.".*'";
-		    }else{
-		       $str1 = $field . " LIKE '%".$search_array."'";
+		    if ($field == "pattern") {
+		       $str1 = $field." LIKE '%".$search_array.".*'";
+		    } else {
+		       $str1 = $field." LIKE '%".$search_array."'";
 		    }
 		    break;
             }
@@ -796,9 +796,9 @@ 
     }
     
     function build_interger_where($field, $value, $search_array) {
-	$where=null;
+	$where = null;
         if ($search_array != '') {
-	    if(is_numeric($search_array))
+	    if (is_numeric($search_array))
 	    {
 		switch ($value) {
 		    case "1":
@@ -824,29 +824,29 @@ 
             else
             {
 	      $this->db->where("$field IS NULL");
-	      $where= "$field IS NULL";
+	      $where = "$field IS NULL";
             }
         }
         return $where;
     }
     function build_date_where($field, $value) {
-	$where =null;
+	$where = null;
         if ($value != '') {
-            if (!empty($value[0])) {
-		$string=null;
-                $string="$field >= '$value[0]'";
-                if($string)
-                $where.=$string." AND ";
+            if ( ! empty($value[0])) {
+		$string = null;
+                $string = "$field >= '$value[0]'";
+                if ($string)
+                $where .= $string." AND ";
             }
-            if (!empty($value[1])) {
-		$string=null;
-                $string="$field <= '$value[1]'";
-                if($string)
-                $where.=$string." AND ";
+            if ( ! empty($value[1])) {
+		$string = null;
+                $string = "$field <= '$value[1]'";
+                if ($string)
+                $where .= $string." AND ";
             }
         }
-        if($where){
-	  $where =rtrim($where," AND ");
+        if ($where) {
+	  $where = rtrim($where, " AND ");
         }
         return $where;
     }
@@ -858,10 +858,10 @@ 
 
     function update_balance($amount, $accountid, $payment_type) {
         if ($payment_type == "debit") {
-            $query = 'UPDATE `accounts` SET `balance` = (balance - ' . $amount . ') WHERE `id` = ' . $accountid;
+            $query = 'UPDATE `accounts` SET `balance` = (balance - '.$amount.') WHERE `id` = '.$accountid;
             return $this->db->query($query);
         } else {
-            $query = 'UPDATE `accounts` SET `balance` = (balance + ' . $amount . ') WHERE `id` = ' . $accountid;
+            $query = 'UPDATE `accounts` SET `balance` = (balance + '.$amount.') WHERE `id` = '.$accountid;
             return $this->db->query($query);
         }
     }
@@ -875,30 +875,30 @@ 
                         //                        $this->db->where($field, $search_array);
                         break;
                     case "2":
-                        if($update_fields[$key] != ''){
+                        if ($update_fields[$key] != '') {
                             $updateflg = true;
-                            $this->db->set($key,$update_fields[$key]);    
+                            $this->db->set($key, $update_fields[$key]);    
                         }
                         break;
                     case "3":
-                        $this->db->set($key, $key . "+" . $update_fields[$key], FALSE);
+                        $this->db->set($key, $key."+".$update_fields[$key], FALSE);
                         $updateflg = true;
                         break;
                     case "4":
-                        $this->db->set($key, $key . "-" . $update_fields[$key], FALSE);
+                        $this->db->set($key, $key."-".$update_fields[$key], FALSE);
                         $updateflg = true;
                         break;
                 }
             } else {
-                if ($update_fields != ""){
-                    $this->db->set($key,$update_fields);
+                if ($update_fields != "") {
+                    $this->db->set($key, $update_fields);
                     $updateflg = true;
                 }
             }
         }
         return $updateflg;
     }
-    function build_search_opensips($opensips_db_obj,$accounts_list_search) {
+    function build_search_opensips($opensips_db_obj, $accounts_list_search) {
         if ($this->session->userdata('advance_search') == 1) {
             $account_search = $this->session->userdata($accounts_list_search);
             unset($account_search["ajax_search"]);
@@ -906,11 +906,11 @@ 
             foreach ($account_search as $key => $value) {
                 if ($value != "") {
                     if (is_array($value)) {
-                        if (array_key_exists($key . "-integer", $value)) {
-                            $this->get_opensips_interger_array($opensips_db_obj,$key, $value[$key . "-integer"], $value[$key]);
+                        if (array_key_exists($key."-integer", $value)) {
+                            $this->get_opensips_interger_array($opensips_db_obj, $key, $value[$key."-integer"], $value[$key]);
                         }
-                        if (array_key_exists($key . "-string", $value)) {
-                            $this->get_opensips_string_array($opensips_db_obj,$key, $value[$key . "-string"], $value[$key]);
+                        if (array_key_exists($key."-string", $value)) {
+                            $this->get_opensips_string_array($opensips_db_obj, $key, $value[$key."-string"], $value[$key]);
                         }
                     } else {
                         $opensips_db_obj->where($key, $value);
@@ -920,32 +920,32 @@ 
         }
     }
 
-    function get_opensips_interger_array($opensips_db_obj,$field, $value, $search_array) {
+    function get_opensips_interger_array($opensips_db_obj, $field, $value, $search_array) {
         if ($search_array != '') {
             switch ($value) {
                 case "1":
                     $opensips_db_obj->where($field, $search_array);
                     break;
                 case "2":
-                    $opensips_db_obj->where($field . ' <>', $search_array);
+                    $opensips_db_obj->where($field.' <>', $search_array);
                     break;
                 case "3":
-                    $opensips_db_obj->where($field . ' > ', $search_array);
+                    $opensips_db_obj->where($field.' > ', $search_array);
                     break;
                 case "4":
-                    $opensips_db_obj->where($field . ' < ', $search_array);
+                    $opensips_db_obj->where($field.' < ', $search_array);
                     break;
                 case "5":
-                    $opensips_db_obj->where($field . ' >= ', $search_array);
+                    $opensips_db_obj->where($field.' >= ', $search_array);
                     break;
                 case "6":
-                    $opensips_db_obj->where($field . ' <= ', $search_array);
+                    $opensips_db_obj->where($field.' <= ', $search_array);
                     break;
             }
         }
     }
 
-    function get_opensips_string_array($opensips_db_obj,$field, $value, $search_array) {
+    function get_opensips_string_array($opensips_db_obj, $field, $value, $search_array) {
         if ($search_array != '') {
             switch ($value) {
                 case "1":
@@ -958,14 +958,14 @@ 
                     $opensips_db_obj->where($field, $search_array);
                     break;
                 case "4":
-                    $opensips_db_obj->where($field . ' <>', $search_array);
+                    $opensips_db_obj->where($field.' <>', $search_array);
                     break;
                 case "5":
-		    $str1 = $field . " LIKE '".$search_array."%'";
+		    $str1 = $field." LIKE '".$search_array."%'";
 		    $opensips_db_obj->where($str1);
 		    break;
 		case "6":
-		    $str1 = $field . " LIKE '%".$search_array."'";
+		    $str1 = $field." LIKE '%".$search_array."'";
 		    $opensips_db_obj->where($str1);
 		    break;
             }
@@ -980,7 +980,7 @@ 
         } else {
             $cnt_str = " $select_params[1],' (',$select_params[2],')' ";
         }
-        $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ,".$select_params[4] ;
+        $select = $select_params[0].", concat($cnt_str) as $select_params[1] ,".$select_params[4];
         $logintype = $this->session->userdata('logintype');
         if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') {
             $account_data = $this->session->userdata("accountinfo");
@@ -991,12 +991,12 @@ 
         $drp_array = $drp_array->result();
         $drp_list = array();
         foreach ($drp_array as $drp_value) {
-            if($drp_value->type == 3)
+            if ($drp_value->type == 3)
             {
                $drp_list['Provider'][$drp_value->id] = $drp_value->first_name;
-            }elseif($drp_value->type == 1){
+            }elseif ($drp_value->type == 1) {
                $drp_list['Reseller'][$drp_value->id] = $drp_value->first_name;
-            }else{
+            } else {
                $drp_list['Customer'][$drp_value->id] = $drp_value->first_name;
             }
         }

Braces +55 added lines, -43 removed lines

@@ -48,10 +48,11 @@ 
     function save($tableName, $arr, $val = 'false') {
         $str = $this->db->insert_string($tableName, $arr);
         $rs = $this->db->query($str);
-        if ($val == true)
-            return $this->db->insert_id();
-        else
-            return $rs;
+        if ($val == true) {
+                    return $this->db->insert_id();
+        } else {
+                    return $rs;
+        }
     }
 
     /*     * ********************************************************
@@ -134,15 +135,18 @@ 
             $this->db->where($where);
         }
         
-        if ($paging_limit)
-            $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
-            $this->db->group_by($groupby);
+        if ($paging_limit) {
+                    $this->db->limit($paging_limit, $start_limit);
+        }
+        if (!empty($groupby)) {
+                    $this->db->group_by($groupby);
+        }
         if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
           $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
+        } else{
+           if($order_by) {
+                       $this->db->order_by($order_by, $order_type);
+           }
         }        
         $query = $this->db->get();
         return $query;
@@ -160,10 +164,12 @@ 
         }
         $this->db->where_in($key, $where_in);
         $this->db->order_by($order_by, $order_type);
-        if ($paging_limit)
-            $this->db->limit($paging_limit, $start_limit);
-        if (!empty($groupby))
-            $this->db->groupby($groupby);
+        if ($paging_limit) {
+                    $this->db->limit($paging_limit, $start_limit);
+        }
+        if (!empty($groupby)) {
+                    $this->db->groupby($groupby);
+        }
         $query = $this->db->get();
 
         return $query;
@@ -254,9 +260,10 @@ 
         }
         if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
           $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
+        } else{
+           if($order_by) {
+                       $this->db->order_by($order_by, $order_type);
+           }
         }
 
         if ($group_by != '') {
@@ -306,9 +313,10 @@ 
         }
         if (isset($_GET['sortname']) && $_GET['sortname'] != 'undefined'){
           $this->db->order_by($_GET['sortname'], ($_GET['sortorder']=='undefined')?'desc':$_GET['sortorder']);
-        }else{
-           if($order_by)
-            $this->db->order_by($order_by, $order_type);
+        } else{
+           if($order_by) {
+                       $this->db->order_by($order_by, $order_type);
+           }
         }
 
         if ($group_by != '') {
@@ -466,7 +474,7 @@ 
 	$logintype = $this->session->userdata('logintype');
 	if ($account_data['type'] == 1 && $id_where == 'where_arr') {
 	  $id_value['reseller_id'] = $account_data['id'];
-	}else{
+	} else{
 	  $this->db->or_where('type',3);
 	}
 	$where = $id_value;
@@ -572,7 +580,7 @@ 
         $name=explode("as",$select);
         if(isset($name[3])){
             $name=trim($name[3]);
-        }else{
+        } else{
             $name=trim($name[1]);
         }
 
@@ -583,7 +591,7 @@ 
             if(isset($dele[1]))
             {
                $drp_list['Deleted'][$drp_value->$select_params[0]] =  str_replace("^","",$drp_value->$name);
-            }else{
+            } else{
                $drp_list['Active'][$drp_value->$select_params[0]] = $drp_value->$name;
             }
         }
@@ -645,7 +653,7 @@ 
 				if($field == 'invoice_date'){
 					$this->db->where($field . ' >= ', gmdate("Y-m-d", strtotime($value['0']))." 00:00:01");
 					$this->db->where($field . ' <= ', gmdate("Y-m-d", strtotime($value['0']))." 23:59:59");
-				}else{
+				} else{
                 $this->db->where($field . ' >= ', gmdate('Y-m-d H:i:s',strtotime($value[0])));
 				}
 			}
@@ -701,7 +709,7 @@ 
 					if($field == "pattern"){
 							$str1 = $field . " LIKE '^".$search_array."%'";
 							$this->db->where($str1);
-					}else{
+					} else{
 							$str1 = $field . " LIKE '".$search_array."%'";
 							$this->db->where($str1);
 					}
@@ -711,7 +719,7 @@ 
 					if($field == "pattern"){
 							$str1 = $field . " LIKE '%".$search_array.".*'";
 							$this->db->where($str1);
-					}else{
+					} else{
 							$str1 = $field . " LIKE '%".$search_array."'";
 							$this->db->where($str1);
 					}		
@@ -734,20 +742,23 @@ 
                             if (array_key_exists($key . "-integer", $value)) {
 				$string=null;
                                 $string =$this->build_interger_where($key, $value[$key . "-integer"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
+                                if($string) {
+                                                                $where.= "$string AND ";
+                                }
                             }
                             if (array_key_exists($key . "-string", $value)) {
 				$string=null;
                                 $string=$this->build_string_where($key, $value[$key . "-string"], $value[$key]);
-                                if($string)
-                                $where.= "$string AND ";
+                                if($string) {
+                                                                $where.= "$string AND ";
+                                }
                             }
                             if ($key == 'callstart'|| $key == 'date'||$key== 'log_time') {
 				$string=null;
                                 $string=$this->build_date_where($key, $value);
-                                if($string)
-                                $where.= "$string AND ";
+                                if($string) {
+                                                                $where.= "$string AND ";
+                                }
                             }
                         } else {
 			      $where.="$key = '$value'AND ";
@@ -779,14 +790,14 @@ 
                 case "5":
 		    if($field == "pattern"){
 		      $where = $field . " LIKE '^".$search_array."%'";
-		    }else{
+		    } else{
 		      $where = $field . " LIKE '".$search_array."%'";
 		    }
                     break;
                 case "6":
 		    if($field == "pattern"){
 		       $str1 = $field . " LIKE '%".$search_array.".*'";
-		    }else{
+		    } else{
 		       $str1 = $field . " LIKE '%".$search_array."'";
 		    }
 		    break;
@@ -820,8 +831,7 @@ 
 			$where = "$field <= '$search_array'";
 			break;
 		}
-            }
-            else
+            } else
             {
 	      $this->db->where("$field IS NULL");
 	      $where= "$field IS NULL";
@@ -835,14 +845,16 @@ 
             if (!empty($value[0])) {
 		$string=null;
                 $string="$field >= '$value[0]'";
-                if($string)
-                $where.=$string." AND ";
+                if($string) {
+                                $where.=$string." AND ";
+                }
             }
             if (!empty($value[1])) {
 		$string=null;
                 $string="$field <= '$value[1]'";
-                if($string)
-                $where.=$string." AND ";
+                if($string) {
+                                $where.=$string." AND ";
+                }
             }
         }
         if($where){
@@ -994,9 +1006,9 @@ 
             if($drp_value->type == 3)
             {
                $drp_list['Provider'][$drp_value->id] = $drp_value->first_name;
-            }elseif($drp_value->type == 1){
+            } elseif($drp_value->type == 1){
                $drp_list['Reseller'][$drp_value->id] = $drp_value->first_name;
-            }else{
+            } else{
                $drp_list['Customer'][$drp_value->id] = $drp_value->first_name;
             }
         }

web_interface/astpp/application/models/common_model.php

Indentation +290 added lines, -290 removed lines

@@ -22,333 +22,333 @@
 ###############################################################################
 class Common_model extends CI_Model {
 
-    var $host;
-    var $user;
-    var $pass;
-    var $db2;
-    var $db_link;
-    var $conn = false;
-    public static $global_config;
+	var $host;
+	var $user;
+	var $pass;
+	var $db2;
+	var $db_link;
+	var $conn = false;
+	public static $global_config;
 
-    function Common_model() {
-        parent::__construct();
-        $this->get_system_config();
-        $this->get_currencylist();
-        $this->get_language_list();
-        $this->get_country_list();
-        $this->get_admin_info();
-        $this->load->library('astpp/common');
-        $this->db->query('SET time_zone = "+00:00"');
-    }
+	function Common_model() {
+		parent::__construct();
+		$this->get_system_config();
+		$this->get_currencylist();
+		$this->get_language_list();
+		$this->get_country_list();
+		$this->get_admin_info();
+		$this->load->library('astpp/common');
+		$this->db->query('SET time_zone = "+00:00"');
+	}
 
-    function get_language_list() {
-        $query = $this->db->get("language");
-        $result = $query->result_array();
-        $language_list = array();
-        foreach ($result as $row) {
-            $language_list[$row['language']] = $row['languagename'];
-        }
-        self::$global_config['language_list'] = $language_list;
-        return $language_list;
-    }
-    function get_system_config() {
-        $query = $this->db->get("system");
-        $config = array();
-        $result = $query->result_array();
-        foreach ($result as $row) {
+	function get_language_list() {
+		$query = $this->db->get("language");
+		$result = $query->result_array();
+		$language_list = array();
+		foreach ($result as $row) {
+			$language_list[$row['language']] = $row['languagename'];
+		}
+		self::$global_config['language_list'] = $language_list;
+		return $language_list;
+	}
+	function get_system_config() {
+		$query = $this->db->get("system");
+		$config = array();
+		$result = $query->result_array();
+		foreach ($result as $row) {
 			if($row['name'] == 'decimal_points' || $row['name'] == 'starting_digit' || $row['name'] == 'card_length' || $row['name'] == 'pin_length'){
 				$row['name'] = str_replace("_","",$row['name']);
 			}
-            $config[$row['name']] = $row['value'];
-        }
-        self::$global_config['system_config'] = $config;
-        return $config;
-    }
-    function get_country_list() {
-        $query = $this->db->get("countrycode");
-        $result = $query->result_array();
-        $country_list = array();
-        foreach ($result as $row) {
-            $country_list[$row['id']] = $row['country'];
-        }
-        self::$global_config['country_list'] = $country_list;
-        return $country_list;
-    }
+			$config[$row['name']] = $row['value'];
+		}
+		self::$global_config['system_config'] = $config;
+		return $config;
+	}
+	function get_country_list() {
+		$query = $this->db->get("countrycode");
+		$result = $query->result_array();
+		$country_list = array();
+		foreach ($result as $row) {
+			$country_list[$row['id']] = $row['country'];
+		}
+		self::$global_config['country_list'] = $country_list;
+		return $country_list;
+	}
     
-        //Return list of currency with rate
+		//Return list of currency with rate
  function get_currencylist() {
-        $query = $this->db->get("currency");
-        $currencylist = array();
-        $result = $query->result_array();
-        foreach ($result as $row) {
-            $currencylist[$row['currency']] = $row['currencyrate'];
-        }
-        self::$global_config['currency_list'] = $currencylist;
-        return $currencylist;
-    }
+		$query = $this->db->get("currency");
+		$currencylist = array();
+		$result = $query->result_array();
+		foreach ($result as $row) {
+			$currencylist[$row['currency']] = $row['currencyrate'];
+		}
+		self::$global_config['currency_list'] = $currencylist;
+		return $currencylist;
+	}
     
-    function get_admin_info(){
-         $result=$this->db->get_where('accounts',array('type'=>'-1'));
-         $result=$result->result_array();
-         self::$global_config['admin_info'] = $result[0];
-         return $result[0];
-    }
-    /* ASTPP  3.0 
+	function get_admin_info(){
+		 $result=$this->db->get_where('accounts',array('type'=>'-1'));
+		 $result=$result->result_array();
+		 self::$global_config['admin_info'] = $result[0];
+		 return $result[0];
+	}
+	/* ASTPP  3.0 
      * Changes for invoices
      */
-     function generate_receipt($accountid, $amount, $accountinfo, $last_invoice_ID, $invoice_prefix, $due_date) {
+	 function generate_receipt($accountid, $amount, $accountinfo, $last_invoice_ID, $invoice_prefix, $due_date) {
 		$amount = str_replace( ',', '', $amount );
-        $invoice_data = array("accountid" => $accountid,
-                              "invoice_prefix" => $invoice_prefix,
-                              "invoiceid" => $last_invoice_ID,
-                              "reseller_id" =>$accountinfo['reseller_id'],
-                              "invoice_date" => gmdate("Y-m-d H:i:s"),
-                              "from_date" => gmdate("Y-m-d H:i:s"),
-                              "to_date" => gmdate("Y-m-d H:i:s"),
-                              "due_date" => $due_date,
-                              "status" => 1,
-                              "balance" => $accountinfo['balance'],
-                              "amount" => $amount,
-                              "type" => 'R',
-			      "confirm"=>'1'
-                             );
-        $this->db->insert("invoices", $invoice_data);
-        return  $this->db->insert_id();
-    }
+		$invoice_data = array("accountid" => $accountid,
+							  "invoice_prefix" => $invoice_prefix,
+							  "invoiceid" => $last_invoice_ID,
+							  "reseller_id" =>$accountinfo['reseller_id'],
+							  "invoice_date" => gmdate("Y-m-d H:i:s"),
+							  "from_date" => gmdate("Y-m-d H:i:s"),
+							  "to_date" => gmdate("Y-m-d H:i:s"),
+							  "due_date" => $due_date,
+							  "status" => 1,
+							  "balance" => $accountinfo['balance'],
+							  "amount" => $amount,
+							  "type" => 'R',
+				  "confirm"=>'1'
+							 );
+		$this->db->insert("invoices", $invoice_data);
+		return  $this->db->insert_id();
+	}
 
-    function calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
-        $from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
+	function calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
+		$from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
         
-        if ($to_currency == '') {
-                $to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
-                $to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
-        }
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
-        $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency){
-            $cal_amount = $cal_amount . " " . $to_currency;
-        }
-        $cal_amount = str_replace( ',', '', $cal_amount );
-        return $cal_amount;
-    }
-    function calculate_currency_customer($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
-        $from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
+		if ($to_currency == '') {
+				$to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
+				$to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
+		}
+		$from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
+		$to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
+		$amount = str_replace( ',', '', $amount );
+		$cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
+		if ($format_currency)
+			$cal_amount = $this->format_currency($cal_amount);
+		if ($append_currency){
+			$cal_amount = $cal_amount . " " . $to_currency;
+		}
+		$cal_amount = str_replace( ',', '', $cal_amount );
+		return $cal_amount;
+	}
+	function calculate_currency_customer($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
+		$from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
         
-        if ($to_currency == '') {
-                $to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
-                $to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
-        }        
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
-        $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount ;
-        $cal_amount = str_replace( ',', '', $cal_amount );
-        return $cal_amount;
-        }
+		if ($to_currency == '') {
+				$to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
+				$to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
+		}        
+		$from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
+		$to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
+		$amount = str_replace( ',', '', $amount );
+		$cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
+		if ($format_currency)
+			$cal_amount = $this->format_currency($cal_amount);
+		if ($append_currency)
+			$cal_amount = $cal_amount ;
+		$cal_amount = str_replace( ',', '', $cal_amount );
+		return $cal_amount;
+		}
 
-    function add_calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
-        $amount = str_replace( ',', '', $amount );
-        if ($from_currency == '') {
-                $from_currency1 = $this->session->userdata['accountinfo']['currency_id'];
-                $from_currency = $this->common->get_field_name('currency', 'currency', $from_currency1);
-        }
-        $to_currency = ($to_currency == '') ? self::$global_config['system_config']['base_currency'] : $to_currency;
-        if(self::$global_config['currency_list'][$from_currency] > 0){
+	function add_calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
+		$amount = str_replace( ',', '', $amount );
+		if ($from_currency == '') {
+				$from_currency1 = $this->session->userdata['accountinfo']['currency_id'];
+				$from_currency = $this->common->get_field_name('currency', 'currency', $from_currency1);
+		}
+		$to_currency = ($to_currency == '') ? self::$global_config['system_config']['base_currency'] : $to_currency;
+		if(self::$global_config['currency_list'][$from_currency] > 0){
 			$cal_amount = ($amount * self::$global_config['currency_list'][$to_currency]) / self::$global_config['currency_list'][$from_currency];
 		}else{
 			$cal_amount=$amount;
 		}
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
-        $cal_amount = str_replace( ',', '', $cal_amount );
-        return $cal_amount;
-    }
+		if ($format_currency)
+			$cal_amount = $this->format_currency($cal_amount);
+		if ($append_currency)
+			$cal_amount = $cal_amount . " " . $to_currency;
+		$cal_amount = str_replace( ',', '', $cal_amount );
+		return $cal_amount;
+	}
 
-    function to_calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
-        if ($to_currency == '') {
-                $to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
-                $to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
-        }
-        $from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
+	function to_calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
+		if ($to_currency == '') {
+				$to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
+				$to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
+		}
+		$from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
 
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
-        $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
-        $cal_amount = str_replace( ',', '', $cal_amount );
-        return $cal_amount;
-    }
+		$from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
+		$to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
+		$amount = str_replace( ',', '', $amount );
+		$cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
+		if ($format_currency)
+			$cal_amount = $this->format_currency($cal_amount);
+		if ($append_currency)
+			$cal_amount = $cal_amount . " " . $to_currency;
+		$cal_amount = str_replace( ',', '', $cal_amount );
+		return $cal_amount;
+	}
 
-    function format_currency($amount) {
+	function format_currency($amount) {
 		$amount = str_replace( ',', '', $amount );
-        return  number_format($amount,Common_model::$global_config['system_config']['decimalpoints']);
+		return  number_format($amount,Common_model::$global_config['system_config']['decimalpoints']);
 	//	return $amount;
-    }
+	}
 
-    function money_format($format, $number) {
-        $regex = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?' .
-                '(?:#([0-9]+))?(?:\.([0-9]+))?([in%])/';
-        if (setlocale(LC_MONETARY, 0) == 'C') {
-            setlocale(LC_MONETARY, '');
-        }
-        $locale = localeconv();
-        preg_match_all($regex, $format, $matches, PREG_SET_ORDER);
-        foreach ($matches as $fmatch) {
-            $value = floatval($number);
-            $flags = array(
-                'fillchar' => preg_match('/\=(.)/', $fmatch[1], $match) ?
-                        $match[1] : ' ',
-                'nogroup' => preg_match('/\^/', $fmatch[1]) > 0,
-                'usesignal' => preg_match('/\+|\(/', $fmatch[1], $match) ?
-                        $match[0] : '+',
-                'nosimbol' => preg_match('/\!/', $fmatch[1]) > 0,
-                'isleft' => preg_match('/\-/', $fmatch[1]) > 0
-            );
-            $width = trim($fmatch[2]) ? (int) $fmatch[2] : 0;
-            $left = trim($fmatch[3]) ? (int) $fmatch[3] : 0;
-            $right = trim($fmatch[4]) ? (int) $fmatch[4] : $locale['int_frac_digits'];
-            $conversion = $fmatch[5];
+	function money_format($format, $number) {
+		$regex = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?' .
+				'(?:#([0-9]+))?(?:\.([0-9]+))?([in%])/';
+		if (setlocale(LC_MONETARY, 0) == 'C') {
+			setlocale(LC_MONETARY, '');
+		}
+		$locale = localeconv();
+		preg_match_all($regex, $format, $matches, PREG_SET_ORDER);
+		foreach ($matches as $fmatch) {
+			$value = floatval($number);
+			$flags = array(
+				'fillchar' => preg_match('/\=(.)/', $fmatch[1], $match) ?
+						$match[1] : ' ',
+				'nogroup' => preg_match('/\^/', $fmatch[1]) > 0,
+				'usesignal' => preg_match('/\+|\(/', $fmatch[1], $match) ?
+						$match[0] : '+',
+				'nosimbol' => preg_match('/\!/', $fmatch[1]) > 0,
+				'isleft' => preg_match('/\-/', $fmatch[1]) > 0
+			);
+			$width = trim($fmatch[2]) ? (int) $fmatch[2] : 0;
+			$left = trim($fmatch[3]) ? (int) $fmatch[3] : 0;
+			$right = trim($fmatch[4]) ? (int) $fmatch[4] : $locale['int_frac_digits'];
+			$conversion = $fmatch[5];
 
-            $positive = true;
-            if ($value < 0) {
-                $positive = false;
-                $value *= -1;
-            }
-            $letter = $positive ? 'p' : 'n';
+			$positive = true;
+			if ($value < 0) {
+				$positive = false;
+				$value *= -1;
+			}
+			$letter = $positive ? 'p' : 'n';
 
-            $prefix = $suffix = $cprefix = $csuffix = $signal = '';
+			$prefix = $suffix = $cprefix = $csuffix = $signal = '';
 
-            $signal = $positive ? $locale['positive_sign'] : $locale['negative_sign'];
-            switch (true) {
-                case $locale["{$letter}_sign_posn"] == 1 && $flags['usesignal'] == '+':
-                    $prefix = $signal;
-                    break;
-                case $locale["{$letter}_sign_posn"] == 2 && $flags['usesignal'] == '+':
-                    $suffix = $signal;
-                    break;
-                case $locale["{$letter}_sign_posn"] == 3 && $flags['usesignal'] == '+':
-                    $cprefix = $signal;
-                    break;
-                case $locale["{$letter}_sign_posn"] == 4 && $flags['usesignal'] == '+':
-                    $csuffix = $signal;
-                    break;
-                case $flags['usesignal'] == '(':
-                case $locale["{$letter}_sign_posn"] == 0:
-                    $prefix = '(';
-                    $suffix = ')';
-                    break;
-            }
-            if (!$flags['nosimbol']) {
-                $currency = $cprefix .
-                        ($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']) .
-                        $csuffix;
-            } else {
-                $currency = '';
-            }
-            $space = $locale["{$letter}_sep_by_space"] ? ' ' : '';
+			$signal = $positive ? $locale['positive_sign'] : $locale['negative_sign'];
+			switch (true) {
+				case $locale["{$letter}_sign_posn"] == 1 && $flags['usesignal'] == '+':
+					$prefix = $signal;
+					break;
+				case $locale["{$letter}_sign_posn"] == 2 && $flags['usesignal'] == '+':
+					$suffix = $signal;
+					break;
+				case $locale["{$letter}_sign_posn"] == 3 && $flags['usesignal'] == '+':
+					$cprefix = $signal;
+					break;
+				case $locale["{$letter}_sign_posn"] == 4 && $flags['usesignal'] == '+':
+					$csuffix = $signal;
+					break;
+				case $flags['usesignal'] == '(':
+				case $locale["{$letter}_sign_posn"] == 0:
+					$prefix = '(';
+					$suffix = ')';
+					break;
+			}
+			if (!$flags['nosimbol']) {
+				$currency = $cprefix .
+						($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']) .
+						$csuffix;
+			} else {
+				$currency = '';
+			}
+			$space = $locale["{$letter}_sep_by_space"] ? ' ' : '';
 
-            $value = number_format($value, $right, $locale['mon_decimal_point'], $flags['nogroup'] ? '' : $locale['mon_thousands_sep']);
-            $value = @explode($locale['mon_decimal_point'], $value);
+			$value = number_format($value, $right, $locale['mon_decimal_point'], $flags['nogroup'] ? '' : $locale['mon_thousands_sep']);
+			$value = @explode($locale['mon_decimal_point'], $value);
 
-            $n = strlen($prefix) + strlen($currency) + strlen($value[0]);
-            if ($left > 0 && $left > $n) {
-                $value[0] = str_repeat($flags['fillchar'], $left - $n) . $value[0];
-            }
-            $value = implode($locale['mon_decimal_point'], $value);
-            if ($locale["{$letter}_cs_precedes"]) {
-                $value = $prefix . $currency . $space . $value . $suffix;
-            } else {
-                $value = $prefix . $value . $space . $currency . $suffix;
-            }
-            if ($width > 0) {
-                $value = str_pad($value, $width, $flags['fillchar'], $flags['isleft'] ?
-                                STR_PAD_RIGHT : STR_PAD_LEFT);
-            }
+			$n = strlen($prefix) + strlen($currency) + strlen($value[0]);
+			if ($left > 0 && $left > $n) {
+				$value[0] = str_repeat($flags['fillchar'], $left - $n) . $value[0];
+			}
+			$value = implode($locale['mon_decimal_point'], $value);
+			if ($locale["{$letter}_cs_precedes"]) {
+				$value = $prefix . $currency . $space . $value . $suffix;
+			} else {
+				$value = $prefix . $value . $space . $currency . $suffix;
+			}
+			if ($width > 0) {
+				$value = str_pad($value, $width, $flags['fillchar'], $flags['isleft'] ?
+								STR_PAD_RIGHT : STR_PAD_LEFT);
+			}
 
-            $format = str_replace($fmatch[0], $value, $format);
-        }
-        return $format;
-    }
+			$format = str_replace($fmatch[0], $value, $format);
+		}
+		return $format;
+	}
 
-    function get_list_taxes() {
-        $this->db->select('id,taxes_description');
-        $query = $this->db->get("taxes");
-        $taxesList = array();
-        if ($query->num_rows() > 0) {
-            return $query->result();
-        }
-    }
+	function get_list_taxes() {
+		$this->db->select('id,taxes_description');
+		$query = $this->db->get("taxes");
+		$taxesList = array();
+		if ($query->num_rows() > 0) {
+			return $query->result();
+		}
+	}
 
-    function get_params($table_name, $select, $where) {
-        if (is_array($select)) {
+	function get_params($table_name, $select, $where) {
+		if (is_array($select)) {
             
-        } else {
-            $this->db->select($select);
-        }
-        if (is_array($where)) {
+		} else {
+			$this->db->select($select);
+		}
+		if (is_array($where)) {
             
-        } else {
-            $this->db->where($where);
-        }
-        $query = $this->db->get($table_name);
-        $query = $query->result();
-        return $query;
-    }
-    /* ASTPP  3.0 
+		} else {
+			$this->db->where($where);
+		}
+		$query = $this->db->get($table_name);
+		$query = $query->result();
+		return $query;
+	}
+	/* ASTPP  3.0 
      * Using for Payment Functionality from Admin/Reseller Login
      */
-    function get_parent_info($accountid){
-        $this->db->where('id',$accountid);
-        $this->db->select('reseller_id,type');
-        $account_result=$this->db->get('accounts');
-        $account_result=(array)$account_result->first_row();
-        if(isset($account_result['reseller_id']) && $account_result['reseller_id']> 0){
-            return $account_result['reseller_id'];
-        }else{
-            return '0';
-        }
+	function get_parent_info($accountid){
+		$this->db->where('id',$accountid);
+		$this->db->select('reseller_id,type');
+		$account_result=$this->db->get('accounts');
+		$account_result=(array)$account_result->first_row();
+		if(isset($account_result['reseller_id']) && $account_result['reseller_id']> 0){
+			return $account_result['reseller_id'];
+		}else{
+			return '0';
+		}
         
-    }
-    function apply_invoice_taxes($invoiceid, $account, $start_date) {
-        $tax_priority = "";
-        $where = array("accountid" => $account['id']);
-        $accounttax_query = $this->db_model->getSelectWithOrder("*", "taxes_to_accounts", $where, "ASC", "taxes_priority");
-        if ($accounttax_query->num_rows > 0) {
-            $accounttax_query = $accounttax_query->result_array();
-            foreach ($accounttax_query as $tax_value) {
-                $taxes_info = $this->db->get_where('taxes', array('id' => $tax_value['taxes_id']));
-                if ($taxes_info->num_rows() > 0) {
-                    $tax_value = $taxes_info->result_array();
-                    $tax_value = $tax_value[0];
-                    if ($tax_value["taxes_priority"] == "") {
-                        $tax_priority = $tax_value["taxes_priority"];
-                    } else if ($tax_value["taxes_priority"] > $tax_priority) {
-                        $query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid));
-                        $query = $query->result_array();
-                        $sub_total = $query["0"]["total"];
-                    }
-                    $tax_total = (($sub_total * ( $tax_value['taxes_rate'] / 100 )) + $tax_value['taxes_amount'] );
-                    $tax_total = round($tax_total, self::$global_config['system_config']['decimalpoints']);
-                    $tax_array = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "invoiceid" => $invoiceid, "item_id" => "0", "description" => $tax_value['taxes_description'], "debit" => $tax_total, "credit" => "", "item_type" => "TAX", "created_date" => $start_date);
-                    $this->db->insert("invoice_details", $tax_array);
-                }
-            }
-        }
-        return TRUE;
-    }
+	}
+	function apply_invoice_taxes($invoiceid, $account, $start_date) {
+		$tax_priority = "";
+		$where = array("accountid" => $account['id']);
+		$accounttax_query = $this->db_model->getSelectWithOrder("*", "taxes_to_accounts", $where, "ASC", "taxes_priority");
+		if ($accounttax_query->num_rows > 0) {
+			$accounttax_query = $accounttax_query->result_array();
+			foreach ($accounttax_query as $tax_value) {
+				$taxes_info = $this->db->get_where('taxes', array('id' => $tax_value['taxes_id']));
+				if ($taxes_info->num_rows() > 0) {
+					$tax_value = $taxes_info->result_array();
+					$tax_value = $tax_value[0];
+					if ($tax_value["taxes_priority"] == "") {
+						$tax_priority = $tax_value["taxes_priority"];
+					} else if ($tax_value["taxes_priority"] > $tax_priority) {
+						$query = $this->db_model->getSelect("SUM(debit) as total", "invoice_details", array("invoiceid" => $invoiceid));
+						$query = $query->result_array();
+						$sub_total = $query["0"]["total"];
+					}
+					$tax_total = (($sub_total * ( $tax_value['taxes_rate'] / 100 )) + $tax_value['taxes_amount'] );
+					$tax_total = round($tax_total, self::$global_config['system_config']['decimalpoints']);
+					$tax_array = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "invoiceid" => $invoiceid, "item_id" => "0", "description" => $tax_value['taxes_description'], "debit" => $tax_total, "credit" => "", "item_type" => "TAX", "created_date" => $start_date);
+					$this->db->insert("invoice_details", $tax_array);
+				}
+			}
+		}
+		return TRUE;
+	}
     
 }

Spacing +47 added lines, -47 removed lines

@@ -56,8 +56,8 @@ 
         $config = array();
         $result = $query->result_array();
         foreach ($result as $row) {
-			if($row['name'] == 'decimal_points' || $row['name'] == 'starting_digit' || $row['name'] == 'card_length' || $row['name'] == 'pin_length'){
-				$row['name'] = str_replace("_","",$row['name']);
+			if ($row['name'] == 'decimal_points' || $row['name'] == 'starting_digit' || $row['name'] == 'card_length' || $row['name'] == 'pin_length') {
+				$row['name'] = str_replace("_", "", $row['name']);
 			}
             $config[$row['name']] = $row['value'];
         }
@@ -87,9 +87,9 @@ 
         return $currencylist;
     }
     
-    function get_admin_info(){
-         $result=$this->db->get_where('accounts',array('type'=>'-1'));
-         $result=$result->result_array();
+    function get_admin_info() {
+         $result = $this->db->get_where('accounts', array('type'=>'-1'));
+         $result = $result->result_array();
          self::$global_config['admin_info'] = $result[0];
          return $result[0];
     }
@@ -97,7 +97,7 @@ 
      * Changes for invoices
      */
      function generate_receipt($accountid, $amount, $accountinfo, $last_invoice_ID, $invoice_prefix, $due_date) {
-		$amount = str_replace( ',', '', $amount );
+		$amount = str_replace(',', '', $amount);
         $invoice_data = array("accountid" => $accountid,
                               "invoice_prefix" => $invoice_prefix,
                               "invoiceid" => $last_invoice_ID,
@@ -123,16 +123,16 @@ 
                 $to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
                 $to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
         }
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
+        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0) ? self::$global_config['currency_list'][$from_currency] : 1;
+        $to_cur_rate = (self::$global_config['currency_list'][$to_currency]) ? self::$global_config['currency_list'][$to_currency] : 1;
+        $amount = str_replace(',', '', $amount);
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
         if ($format_currency)
             $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency){
-            $cal_amount = $cal_amount . " " . $to_currency;
+        if ($append_currency) {
+            $cal_amount = $cal_amount." ".$to_currency;
         }
-        $cal_amount = str_replace( ',', '', $cal_amount );
+        $cal_amount = str_replace(',', '', $cal_amount);
         return $cal_amount;
     }
     function calculate_currency_customer($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
@@ -142,35 +142,35 @@ 
                 $to_currency1 = $this->session->userdata['accountinfo']['currency_id'];
                 $to_currency = $this->common->get_field_name('currency', 'currency', $to_currency1);
         }        
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
+        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0) ? self::$global_config['currency_list'][$from_currency] : 1;
+        $to_cur_rate = (self::$global_config['currency_list'][$to_currency]) ? self::$global_config['currency_list'][$to_currency] : 1;
+        $amount = str_replace(',', '', $amount);
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
         if ($format_currency)
             $cal_amount = $this->format_currency($cal_amount);
         if ($append_currency)
-            $cal_amount = $cal_amount ;
-        $cal_amount = str_replace( ',', '', $cal_amount );
+            $cal_amount = $cal_amount;
+        $cal_amount = str_replace(',', '', $cal_amount);
         return $cal_amount;
         }
 
     function add_calculate_currency($amount = 0, $from_currency = '', $to_currency = '', $format_currency = true, $append_currency = true) {
-        $amount = str_replace( ',', '', $amount );
+        $amount = str_replace(',', '', $amount);
         if ($from_currency == '') {
                 $from_currency1 = $this->session->userdata['accountinfo']['currency_id'];
                 $from_currency = $this->common->get_field_name('currency', 'currency', $from_currency1);
         }
         $to_currency = ($to_currency == '') ? self::$global_config['system_config']['base_currency'] : $to_currency;
-        if(self::$global_config['currency_list'][$from_currency] > 0){
+        if (self::$global_config['currency_list'][$from_currency] > 0) {
 			$cal_amount = ($amount * self::$global_config['currency_list'][$to_currency]) / self::$global_config['currency_list'][$from_currency];
-		}else{
-			$cal_amount=$amount;
+		} else {
+			$cal_amount = $amount;
 		}
         if ($format_currency)
             $cal_amount = $this->format_currency($cal_amount);
         if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
-        $cal_amount = str_replace( ',', '', $cal_amount );
+            $cal_amount = $cal_amount." ".$to_currency;
+        $cal_amount = str_replace(',', '', $cal_amount);
         return $cal_amount;
     }
 
@@ -181,26 +181,26 @@ 
         }
         $from_currency = ($from_currency == '') ? self::$global_config['system_config']['base_currency'] : $from_currency;
 
-        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0)?self::$global_config['currency_list'][$from_currency]:1;
-        $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
-        $amount = str_replace( ',', '', $amount );
+        $from_cur_rate = (self::$global_config['currency_list'][$from_currency] > 0) ? self::$global_config['currency_list'][$from_currency] : 1;
+        $to_cur_rate = (self::$global_config['currency_list'][$to_currency]) ? self::$global_config['currency_list'][$to_currency] : 1;
+        $amount = str_replace(',', '', $amount);
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
         if ($format_currency)
             $cal_amount = $this->format_currency($cal_amount);
         if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
-        $cal_amount = str_replace( ',', '', $cal_amount );
+            $cal_amount = $cal_amount." ".$to_currency;
+        $cal_amount = str_replace(',', '', $cal_amount);
         return $cal_amount;
     }
 
     function format_currency($amount) {
-		$amount = str_replace( ',', '', $amount );
-        return  number_format($amount,Common_model::$global_config['system_config']['decimalpoints']);
+		$amount = str_replace(',', '', $amount);
+        return  number_format($amount, Common_model::$global_config['system_config']['decimalpoints']);
 	//	return $amount;
     }
 
     function money_format($format, $number) {
-        $regex = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?' .
+        $regex = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?'.
                 '(?:#([0-9]+))?(?:\.([0-9]+))?([in%])/';
         if (setlocale(LC_MONETARY, 0) == 'C') {
             setlocale(LC_MONETARY, '');
@@ -218,9 +218,9 @@ 
                 'nosimbol' => preg_match('/\!/', $fmatch[1]) > 0,
                 'isleft' => preg_match('/\-/', $fmatch[1]) > 0
             );
-            $width = trim($fmatch[2]) ? (int) $fmatch[2] : 0;
-            $left = trim($fmatch[3]) ? (int) $fmatch[3] : 0;
-            $right = trim($fmatch[4]) ? (int) $fmatch[4] : $locale['int_frac_digits'];
+            $width = trim($fmatch[2]) ? (int)$fmatch[2] : 0;
+            $left = trim($fmatch[3]) ? (int)$fmatch[3] : 0;
+            $right = trim($fmatch[4]) ? (int)$fmatch[4] : $locale['int_frac_digits'];
             $conversion = $fmatch[5];
 
             $positive = true;
@@ -252,9 +252,9 @@ 
                     $suffix = ')';
                     break;
             }
-            if (!$flags['nosimbol']) {
-                $currency = $cprefix .
-                        ($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']) .
+            if ( ! $flags['nosimbol']) {
+                $currency = $cprefix.
+                        ($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']).
                         $csuffix;
             } else {
                 $currency = '';
@@ -266,13 +266,13 @@ 
 
             $n = strlen($prefix) + strlen($currency) + strlen($value[0]);
             if ($left > 0 && $left > $n) {
-                $value[0] = str_repeat($flags['fillchar'], $left - $n) . $value[0];
+                $value[0] = str_repeat($flags['fillchar'], $left - $n).$value[0];
             }
             $value = implode($locale['mon_decimal_point'], $value);
             if ($locale["{$letter}_cs_precedes"]) {
-                $value = $prefix . $currency . $space . $value . $suffix;
+                $value = $prefix.$currency.$space.$value.$suffix;
             } else {
-                $value = $prefix . $value . $space . $currency . $suffix;
+                $value = $prefix.$value.$space.$currency.$suffix;
             }
             if ($width > 0) {
                 $value = str_pad($value, $width, $flags['fillchar'], $flags['isleft'] ?
@@ -311,14 +311,14 @@ 
     /* ASTPP  3.0 
      * Using for Payment Functionality from Admin/Reseller Login
      */
-    function get_parent_info($accountid){
-        $this->db->where('id',$accountid);
+    function get_parent_info($accountid) {
+        $this->db->where('id', $accountid);
         $this->db->select('reseller_id,type');
-        $account_result=$this->db->get('accounts');
-        $account_result=(array)$account_result->first_row();
-        if(isset($account_result['reseller_id']) && $account_result['reseller_id']> 0){
+        $account_result = $this->db->get('accounts');
+        $account_result = (array)$account_result->first_row();
+        if (isset($account_result['reseller_id']) && $account_result['reseller_id'] > 0) {
             return $account_result['reseller_id'];
-        }else{
+        } else {
             return '0';
         }
         
@@ -341,7 +341,7 @@ 
                         $query = $query->result_array();
                         $sub_total = $query["0"]["total"];
                     }
-                    $tax_total = (($sub_total * ( $tax_value['taxes_rate'] / 100 )) + $tax_value['taxes_amount'] );
+                    $tax_total = (($sub_total * ($tax_value['taxes_rate'] / 100)) + $tax_value['taxes_amount']);
                     $tax_total = round($tax_total, self::$global_config['system_config']['decimalpoints']);
                     $tax_array = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "invoiceid" => $invoiceid, "item_id" => "0", "description" => $tax_value['taxes_description'], "debit" => $tax_total, "credit" => "", "item_type" => "TAX", "created_date" => $start_date);
                     $this->db->insert("invoice_details", $tax_array);

Braces +23 added lines, -16 removed lines

@@ -127,8 +127,9 @@ 
         $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
         $amount = str_replace( ',', '', $amount );
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
+        if ($format_currency) {
+                    $cal_amount = $this->format_currency($cal_amount);
+        }
         if ($append_currency){
             $cal_amount = $cal_amount . " " . $to_currency;
         }
@@ -146,10 +147,12 @@ 
         $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
         $amount = str_replace( ',', '', $amount );
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount ;
+        if ($format_currency) {
+                    $cal_amount = $this->format_currency($cal_amount);
+        }
+        if ($append_currency) {
+                    $cal_amount = $cal_amount ;
+        }
         $cal_amount = str_replace( ',', '', $cal_amount );
         return $cal_amount;
         }
@@ -163,13 +166,15 @@ 
         $to_currency = ($to_currency == '') ? self::$global_config['system_config']['base_currency'] : $to_currency;
         if(self::$global_config['currency_list'][$from_currency] > 0){
 			$cal_amount = ($amount * self::$global_config['currency_list'][$to_currency]) / self::$global_config['currency_list'][$from_currency];
-		}else{
+		} else{
 			$cal_amount=$amount;
 		}
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
+        if ($format_currency) {
+                    $cal_amount = $this->format_currency($cal_amount);
+        }
+        if ($append_currency) {
+                    $cal_amount = $cal_amount . " " . $to_currency;
+        }
         $cal_amount = str_replace( ',', '', $cal_amount );
         return $cal_amount;
     }
@@ -185,10 +190,12 @@ 
         $to_cur_rate = (self::$global_config['currency_list'][$to_currency])?self::$global_config['currency_list'][$to_currency]:1;
         $amount = str_replace( ',', '', $amount );
         $cal_amount = ($amount * $to_cur_rate) / $from_cur_rate;
-        if ($format_currency)
-            $cal_amount = $this->format_currency($cal_amount);
-        if ($append_currency)
-            $cal_amount = $cal_amount . " " . $to_currency;
+        if ($format_currency) {
+                    $cal_amount = $this->format_currency($cal_amount);
+        }
+        if ($append_currency) {
+                    $cal_amount = $cal_amount . " " . $to_currency;
+        }
         $cal_amount = str_replace( ',', '', $cal_amount );
         return $cal_amount;
     }
@@ -318,7 +325,7 @@ 
         $account_result=(array)$account_result->first_row();
         if(isset($account_result['reseller_id']) && $account_result['reseller_id']> 0){
             return $account_result['reseller_id'];
-        }else{
+        } else{
             return '0';
         }
         

web_interface/astpp/application/helpers/csv_helper.php

Spacing +1 added lines, -1 removed lines

@@ -35,7 +35,7 @@
 			header('Content-type: text/csv; charset=UTF-8');
 			header('Content-Encoding: UTF-8');
 // 			header('Content-Type: application/csv');
-			header('Content-Disposition: attachement; filename="' . $download . '"');
+			header('Content-Disposition: attachement; filename="'.$download.'"');
 			echo "\xEF\xBB\xBF"; // UTF-8 BOM
 			header("Pragma: no-cache");
 			header("Expires: 0");

Braces +4 added lines, -3 removed lines

@@ -1,4 +1,6 @@ 
-<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+<?php  if ( ! defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 // ------------------------------------------------------------------------
 
@@ -59,8 +61,7 @@ 
 		if ($download == "")
 		{
 			return $str;	
-		}
-		else
+		} else
 		{	
 			echo $str;
 		}		

web_interface/astpp/application/helpers/email_csv_helper.php

Indentation +2 added lines, -2 removed lines

@@ -10,8 +10,8 @@
 function send_csv_mail ($csvData, $body, $to, $subject,$file_name) {
 	//print_r($csvData);
 	$where = array('group_title' =>'email');
-        $query = $this->CI->db_model->getSelect("*", "system", $where);
-        $query = $query->result_array();
+		$query = $this->CI->db_model->getSelect("*", "system", $where);
+		$query = $query->result_array();
 	foreach($query as $key=>$val){
 		$from=$val['value'];
 	}

Spacing +4 added lines, -4 removed lines

@@ -1,19 +1,19 @@
 <?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 
 function create_csv_string($data) {
-	if (!$fp = fopen('php://temp', 'w+')) return FALSE;
+	if ( ! $fp = fopen('php://temp', 'w+')) return FALSE;
 	foreach ($data as $line) fputcsv($fp, $line);
 	rewind($fp);
 	return stream_get_contents($fp);
 }
 
-function send_csv_mail ($csvData, $body, $to, $subject,$file_name) {
+function send_csv_mail($csvData, $body, $to, $subject, $file_name) {
 	//print_r($csvData);
 	$where = array('group_title' =>'email');
         $query = $this->CI->db_model->getSelect("*", "system", $where);
         $query = $query->result_array();
-	foreach($query as $key=>$val){
-		$from=$val['value'];
+	foreach ($query as $key=>$val) {
+		$from = $val['value'];
 	}
 	$multipartSep = '-----'.md5(time()).'-----';
 	$headers = array(

Braces +9 added lines, -3 removed lines

@@ -1,8 +1,14 @@
-<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+<?php  if ( ! defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 function create_csv_string($data) {
-	if (!$fp = fopen('php://temp', 'w+')) return FALSE;
-	foreach ($data as $line) fputcsv($fp, $line);
+	if (!$fp = fopen('php://temp', 'w+')) {
+		return FALSE;
+	}
+	foreach ($data as $line) {
+		fputcsv($fp, $line);
+	}
 	rewind($fp);
 	return stream_get_contents($fp);
 }

web_interface/astpp/application/helpers/MY_form_helper.php

Indentation +1 added lines, -1 removed lines

@@ -37,7 +37,7 @@
 			if(strtolower(trim($value)) == strtolower(trim($selected)))
 			{
                             
-                            $form .= ' selected="selected" >';
+							$form .= ' selected="selected" >';
                                 
 			}
 			else

Spacing +66 added lines, -66 removed lines

@@ -1,4 +1,4 @@ 
-<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 	
 // ------------------------------------------------------------------------
 
@@ -12,29 +12,29 @@ 
  * @return	string
  */
 
-if( !function_exists( 'form_countries' ) )
+if ( ! function_exists('form_countries'))
 {
-	function form_countries( $name, $selected = FALSE, $attributes, $form_name="" )
+	function form_countries($name, $selected = FALSE, $attributes, $form_name = "")
 	{
 		$country_list = Common_model::$global_config['country_list'];
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 		
-		if($form_name!=""){
+		if ($form_name != "") {
 			$form .= "\n".'<option value="" selected="selected" >'.$form_name.'</option>';
 		}
 
-		foreach( $country_list as $key => $value )
+		foreach ($country_list as $key => $value)
 		{
-			$form .= "\n".'<option value="'.ucwords( strtolower( $value ) ).'"';
+			$form .= "\n".'<option value="'.ucwords(strtolower($value)).'"';
 
-			if(strtolower(trim($value)) == strtolower(trim($selected)))
+			if (strtolower(trim($value)) == strtolower(trim($selected)))
 			{
                             
                             $form .= ' selected="selected" >';
@@ -45,7 +45,7 @@ 
 				$form .= '>';
 			}
 			
-			$form .= ucwords( strtolower( $value ) ).'</option>';
+			$form .= ucwords(strtolower($value)).'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -54,30 +54,30 @@ 
 	}
 }
 
-if(!function_exists('form_devicetype'))
+if ( ! function_exists('form_devicetype'))
 {
-	function form_devicetype( $name, $selected = FALSE, $attributes )
+	function form_devicetype($name, $selected = FALSE, $attributes)
 	{
-		$CI =& get_instance();
+		$CI = & get_instance();
 
-		$CI->config->load( 'countries' );
+		$CI->config->load('countries');
 
-		$type_list = $CI->config->item( 'device_types' );
+		$type_list = $CI->config->item('device_types');
 
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 
-		foreach( $type_list as $key => $value )
+		foreach ($type_list as $key => $value)
 		{
 			$form .= "\n".'<option value="'.$key.'"';
 
-			if( $key == $selected )
+			if ($key == $selected)
 			{
 				$form .= '  selected="selected">';
 			}
@@ -86,7 +86,7 @@ 
 				$form .= '>';
 			}
 
-			$form .= ucwords( strtolower( $value ) ).'</option>';
+			$form .= ucwords(strtolower($value)).'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -96,30 +96,30 @@ 
 }
 
 // ------------------------------------------------------------------------
-if( !function_exists( 'form_timezone' ) )
+if ( ! function_exists('form_timezone'))
 {
-	function form_timezone( $name, $selected = FALSE, $attributes )
+	function form_timezone($name, $selected = FALSE, $attributes)
 	{
-		$CI =& get_instance();
+		$CI = & get_instance();
 
-		$CI->config->load( 'countries' );
+		$CI->config->load('countries');
 
-		$country_list = $CI->config->item( 'timezone1_list' );
+		$country_list = $CI->config->item('timezone1_list');
 
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 
-		foreach( $country_list as $key => $value )
+		foreach ($country_list as $key => $value)
 		{
-			$form .= "\n".'<option value="'.ucwords( strtolower( $value ) ).'"';
+			$form .= "\n".'<option value="'.ucwords(strtolower($value)).'"';
 
-			if( strtolower($value) == strtolower($selected) )
+			if (strtolower($value) == strtolower($selected))
 			{
 				$form .= '  selected="selected">';
 			}
@@ -128,7 +128,7 @@ 
 				$form .= '>';
 			}
 
-			$form .= ucwords( strtolower( $value ) ).'</option>';
+			$form .= ucwords(strtolower($value)).'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -137,26 +137,26 @@ 
 	}
 }
 //=========================================
-if( !function_exists( 'form_languagelist' ) )
+if ( ! function_exists('form_languagelist'))
 {
-	function form_languagelist( $name, $selected = FALSE, $attributes )
+	function form_languagelist($name, $selected = FALSE, $attributes)
 	{
 		$language_list = Common_model::$global_config['language_list'];
 
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 
-		foreach( $language_list as $key => $value )
+		foreach ($language_list as $key => $value)
 		{
-			$form .= "\n".'<option value="'.( strtolower( $key ) ).'"';
+			$form .= "\n".'<option value="'.(strtolower($key)).'"';
 
-			if( $key == $selected )
+			if ($key == $selected)
 			{
 				$form .= ' selected>';
 			}
@@ -165,7 +165,7 @@ 
 				$form .= '>';
 			}
 
-			$form .=  ucfirst(strtolower($value)).'</option>';
+			$form .= ucfirst(strtolower($value)).'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -175,28 +175,28 @@ 
 }
 
 //-----------------------------------------
-if( !function_exists( 'form_select_default' ) )
+if ( ! function_exists('form_select_default'))
 {
-	function form_select_default( $name,$data, $selected = "", $attributes, $form_name="" )
+	function form_select_default($name, $data, $selected = "", $attributes, $form_name = "")
 	{
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 		
-		if($form_name!=""){
+		if ($form_name != "") {
 			$form .= "\n".'<option value="" selected="selected" >'.$form_name.'</option>';
 		}
 		
-		foreach( $data as $key => $value )
+		foreach ($data as $key => $value)
 		{
 			$form .= "\n".'<option value="'.$key.'"';
 			
-			if( $key == $selected )
+			if ($key == $selected)
 			{
 				$form .= ' selected>';
 			}
@@ -205,7 +205,7 @@ 
 				$form .= '>';
 			}
 
-			$form .= ucwords( strtolower( $value ) ).'</option>';
+			$form .= ucwords(strtolower($value)).'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -215,30 +215,30 @@ 
 	}
 }	
 //-----------------------------------------
-if(!function_exists('form_disposition'))
+if ( ! function_exists('form_disposition'))
 {
-	function form_disposition( $name, $selected = FALSE, $attributes )
+	function form_disposition($name, $selected = FALSE, $attributes)
 	{
-		$CI =& get_instance();
+		$CI = & get_instance();
 
-		$CI->config->load( 'countries' );
+		$CI->config->load('countries');
 
-		$type_list = $CI->config->item( 'disposition' );
+		$type_list = $CI->config->item('disposition');
 
 		$form = '<select name="'.$name.'"';
 
-		foreach( $attributes as $key => $value )
+		foreach ($attributes as $key => $value)
 		{
 			$form .= " ".$key.'="'.$value.'"';
 		}
 
 		$form .= ">";
 
-		foreach( $type_list as $key => $value )
+		foreach ($type_list as $key => $value)
 		{
 			$form .= "\n".'<option value="'.$key.'"';
 
-			if( $key == $selected )
+			if ($key == $selected)
 			{
 				$form .= '  selected="selected">';
 			}
@@ -247,7 +247,7 @@ 
 				$form .= '>';
 			}
 
-			$form .=  $value  .'</option>';
+			$form .= $value.'</option>';
 		}
 
 		$form .= "\n</select>";
@@ -257,27 +257,27 @@ 
 }
 
 //-----------------------------------------
-if( !function_exists( 'form_table_row' ) )
+if ( ! function_exists('form_table_row'))
 {
-	function form_table_row($label,$field,$span){
+	function form_table_row($label, $field, $span) {
 		echo '<tr><th width="10%"><label>'.$label.'</label></th><td>';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td></tr>';	
 	}
 }	
-if( !function_exists( 'form_table_row1' ) )
+if ( ! function_exists('form_table_row1'))
 {
-	function form_table_row1($label,$field,$span){
+	function form_table_row1($label, $field, $span) {
 		echo '<tr><th width="10%"><label>'.$label.'</label></th><td>';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td>';	
 	}
 }
-if( !function_exists( 'form_table_row2' ) )
+if ( ! function_exists('form_table_row2'))
 {
-	function form_table_row2($label,$field,$span){
+	function form_table_row2($label, $field, $span) {
 		echo '<th width="10%" style="padding-left: 20px"><label>'.$label.'</label></th><td>';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
@@ -285,37 +285,37 @@ 
 	}
 }
 //-------------------------------------		
-if( !function_exists( 'form_table_row_1' ) )
+if ( ! function_exists('form_table_row_1'))
 {
-	function form_table_row_1($label,$field,$span,$wh='5',$wd='15'){
+	function form_table_row_1($label, $field, $span, $wh = '5', $wd = '15') {
 		echo '<tr><th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td>';	
 	}
 }
-if( !function_exists( 'form_table_row_2' ) )
+if ( ! function_exists('form_table_row_2'))
 {
-	function form_table_row_2($label,$field,$span,$wh='10',$wd='10'){
+	function form_table_row_2($label, $field, $span, $wh = '10', $wd = '10') {
 		echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td>';	
 	}
 }
-if( !function_exists( 'form_table_row_3' ) )
+if ( ! function_exists('form_table_row_3'))
 {
-	function form_table_row_3($label,$field,$span,$wh='10',$wd='15'){
+	function form_table_row_3($label, $field, $span, $wh = '10', $wd = '15') {
 		echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td>';	
 	}
 }
-if( !function_exists( 'form_table_row_4' ) )
+if ( ! function_exists('form_table_row_4'))
 {
-	function form_table_row_4($label,$field,$span,$wh='10',$wd=''){
-		if(wd == '')
+	function form_table_row_4($label, $field, $span, $wh = '10', $wd = '') {
+		if (wd == '')
 			echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td>';
 		else 
 			echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';

Braces +14 added lines, -17 removed lines

@@ -1,4 +1,6 @@ 
-<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php  if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 	
 // ------------------------------------------------------------------------
 
@@ -39,8 +41,7 @@ 
                             
                             $form .= ' selected="selected" >';
                                 
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -80,8 +81,7 @@ 
 			if( $key == $selected )
 			{
 				$form .= '  selected="selected">';
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -122,8 +122,7 @@ 
 			if( strtolower($value) == strtolower($selected) )
 			{
 				$form .= '  selected="selected">';
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -159,8 +158,7 @@ 
 			if( $key == $selected )
 			{
 				$form .= ' selected>';
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -199,8 +197,7 @@ 
 			if( $key == $selected )
 			{
 				$form .= ' selected>';
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -241,8 +238,7 @@ 
 			if( $key == $selected )
 			{
 				$form .= '  selected="selected">';
-			}
-			else
+			} else
 			{
 				$form .= '>';
 			}
@@ -315,10 +311,11 @@ 
 if( !function_exists( 'form_table_row_4' ) )
 {
 	function form_table_row_4($label,$field,$span,$wh='10',$wd=''){
-		if(wd == '')
-			echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td>';
-		else 
-			echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';
+		if(wd == '') {
+					echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td>';
+		} else {
+					echo '<th width="'.$wh.'%"><label>'.$label.'</label></th><td width="'.$wd.'%">';
+		}
 		echo $field;
 		echo '<br/><span class="helptext">'.$span.'</span>';
 		echo '</td></tr>';	

web_interface/astpp/application/language/spanish/footer_lang.php

Spacing +2 added lines, -2 removed lines

@@ -1,3 +1,3 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
-$lang['FOOTER.FOOTER']='Copyright © 2003 - 2012. ASTPP - Open Source Solución de Facturación VOIP. Todos los Derechos Reservados.';
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+$lang['FOOTER.FOOTER'] = 'Copyright © 2003 - 2012. ASTPP - Open Source Solución de Facturación VOIP. Todos los Derechos Reservados.';
 ?>

Braces +3 added lines, -1 removed lines

@@ -1,4 +1,6 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 //DID list
 $lang['DID.MANAGE_DIDs']='Manage DIDs';

web_interface/astpp/application/language/spanish/menu_lang.php

Spacing +60 added lines, -60 removed lines

@@ -1,97 +1,97 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 //Main Menu
-$lang['Home']='Casa';
-$lang['Global Accounts']='cuentas globales';
-$lang['Accounting']='contabilidad';
-$lang['Services']='servicios';
-$lang['DIDs']='DIDs';
-$lang['Routing']='Enrutamiento';
-$lang['Reports']='informes';
-$lang['System Configuration']='Configuración del sistema';
+$lang['Home'] = 'Casa';
+$lang['Global Accounts'] = 'cuentas globales';
+$lang['Accounting'] = 'contabilidad';
+$lang['Services'] = 'servicios';
+$lang['DIDs'] = 'DIDs';
+$lang['Routing'] = 'Enrutamiento';
+$lang['Reports'] = 'informes';
+$lang['System Configuration'] = 'Configuración del sistema';
 
 
 //gloabalAccounts useraccount Menu
 
-$lang['User Accounts']='Cuentas de usuario';
-$lang['Customer List']='Lista de clientes';
-$lang['Reseller List']='lista distribuidor';
-$lang['Callshop List']='lista locutorio';
+$lang['User Accounts'] = 'Cuentas de usuario';
+$lang['Customer List'] = 'Lista de clientes';
+$lang['Reseller List'] = 'lista distribuidor';
+$lang['Callshop List'] = 'lista locutorio';
 
 //gloabalAccounts  ProviderAccounts Menu
-$lang['Provider Accounts']='Cuentas de Proveedores';
-$lang['Provider List']='Lista de Proveedores';
+$lang['Provider Accounts'] = 'Cuentas de Proveedores';
+$lang['Provider List'] = 'Lista de Proveedores';
 //gloabalAccounts  System Accounts Menu
-$lang['System Accounts']='Cuentas del sistema';
-$lang['Admin List']='Lista de administración';
-$lang['Subadmin List']='Lista Subadmin';
+$lang['System Accounts'] = 'Cuentas del sistema';
+$lang['Admin List'] = 'Lista de administración';
+$lang['Subadmin List'] = 'Lista Subadmin';
 
 //Accounting Manage Invoices Menu
-$lang['Manage Invoice']='Gestione la factura';
-$lang['Invoice List']='Lista de facturas';
-$lang['Invoice Configuration']='Configuración de facturas';
+$lang['Manage Invoice'] = 'Gestione la factura';
+$lang['Invoice List'] = 'Lista de facturas';
+$lang['Invoice Configuration'] = 'Configuración de facturas';
 
 //Accounting Subscription Menu
-$lang['Subscriptions']='Suscripciones';
-$lang['Periodic Charges']='Cargos periódicos';
+$lang['Subscriptions'] = 'Suscripciones';
+$lang['Periodic Charges'] = 'Cargos periódicos';
 
 //Accounting Manage Taxes Menu
-$lang['Manage Taxes']='Gestione impuestos';
-$lang['Taxes']='Impuestos';
+$lang['Manage Taxes'] = 'Gestione impuestos';
+$lang['Taxes'] = 'Impuestos';
 
 //Services Calling Cards Menu
 
-$lang['Calling Cards']='Tarjetas de llamadas';
-$lang['List Cards']='Lista de Tarjetas';
-$lang['CC Brands']='CC Marcas';
-$lang['Calling Card CDRs']='Llamando CDRs Tarjeta';
+$lang['Calling Cards'] = 'Tarjetas de llamadas';
+$lang['List Cards'] = 'Lista de Tarjetas';
+$lang['CC Brands'] = 'CC Marcas';
+$lang['Calling Card CDRs'] = 'Llamando CDRs Tarjeta';
 
 //DID Menu
-$lang['Manage DID']='Gestione DID';
-$lang['Manage DIDs']='Gestione DIDs';
+$lang['Manage DID'] = 'Gestione DID';
+$lang['Manage DIDs'] = 'Gestione DIDs';
 
 //Routing Providers Menu
 
-$lang['Providers']='Proveedores';
-$lang['Trunks']='Baúles';
-$lang['Termination Rates']='Las tarifas de terminación';
-$lang['Gateways']='Entrada';
-$lang['Sip Profile']='Sip Perfil';
+$lang['Providers'] = 'Proveedores';
+$lang['Trunks'] = 'Baúles';
+$lang['Termination Rates'] = 'Las tarifas de terminación';
+$lang['Gateways'] = 'Entrada';
+$lang['Sip Profile'] = 'Sip Perfil';
 
 //Routing Clients Menu
-$lang['Clients']='Clientela';
-$lang['Rate Group']='Cambio de grupo';
-$lang['Origination Rates']='Creaciones de Cambio';
-$lang['Packages']='Paquetes';
-$lang['Package Usage Report']='Informe de uso del paquete';
+$lang['Clients'] = 'Clientela';
+$lang['Rate Group'] = 'Cambio de grupo';
+$lang['Origination Rates'] = 'Creaciones de Cambio';
+$lang['Packages'] = 'Paquetes';
+$lang['Package Usage Report'] = 'Informe de uso del paquete';
 
 //Reports->CallDetail Reports
 
-$lang['Call Detail Reports']='Llame informes de detalles';
-$lang['Customer Reports']='Informes Cliente';
-$lang['Reseller Report']='Informe distribuidor';
-$lang['Provider Report']='Reporte del Proveedor';
+$lang['Call Detail Reports'] = 'Llame informes de detalles';
+$lang['Customer Reports'] = 'Informes Cliente';
+$lang['Reseller Report'] = 'Informe distribuidor';
+$lang['Provider Report'] = 'Reporte del Proveedor';
 
 //Reports->Switch Reports Menu
-$lang['Switch Reports']='Informes interruptor';
-$lang['Live Call Report']='Vivir Informe de llamadas';
-$lang['Trunk Stats']='Estadísticas del tronco';
+$lang['Switch Reports'] = 'Informes interruptor';
+$lang['Live Call Report'] = 'Vivir Informe de llamadas';
+$lang['Trunk Stats'] = 'Estadísticas del tronco';
 
 //Reports->Summary Reports Menu
-$lang['Summary Reports']='Resumen del informe';
-$lang['Provider Reports']='Reporte del Proveedor';
-$lang['User Report']="Informe de usuario";
+$lang['Summary Reports'] = 'Resumen del informe';
+$lang['Provider Reports'] = 'Reporte del Proveedor';
+$lang['User Report'] = "Informe de usuario";
 
 //Reports->Payment Reports Menu
-$lang['Payment Reports']='Informes de pago';
-$lang['Payment Report']='Informe de Pago';
+$lang['Payment Reports'] = 'Informes de pago';
+$lang['Payment Report'] = 'Informe de Pago';
 
 
-$lang['Switch Config']='Cambiar configuración';
-$lang['System']='sistema';
-$lang['Freeswitch SIP Devices']='Dispositivos FreeSWITCH Sip';
-$lang['Freeswitch Server']='Freeswitch servidor';
-$lang['Configuration']='Configuración';
-$lang['Email Template']='Plantilla de correo electrónico';
-$lang['Freeswitch']='Freeswitch';
+$lang['Switch Config'] = 'Cambiar configuración';
+$lang['System'] = 'sistema';
+$lang['Freeswitch SIP Devices'] = 'Dispositivos FreeSWITCH Sip';
+$lang['Freeswitch Server'] = 'Freeswitch servidor';
+$lang['Configuration'] = 'Configuración';
+$lang['Email Template'] = 'Plantilla de correo electrónico';
+$lang['Freeswitch'] = 'Freeswitch';
 ?>
  

Braces +3 added lines, -1 removed lines

@@ -1,4 +1,6 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 //DID list
 $lang['DID.MANAGE_DIDs']='Manage DIDs';

web_interface/astpp/application/language/english/footer_lang.php

Spacing +2 added lines, -2 removed lines

@@ -1,3 +1,3 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
-$lang['FOOTER.FOOTER']='Copyright &copy; 2003 - 2012. ASTPP - Open Source VOIP Billing Solution. All Rights Reserved.';
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+$lang['FOOTER.FOOTER'] = 'Copyright &copy; 2003 - 2012. ASTPP - Open Source VOIP Billing Solution. All Rights Reserved.';
 ?>

Braces +3 added lines, -1 removed lines

@@ -1,4 +1,6 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 //DID list
 $lang['DID.MANAGE_DIDs']='Manage DIDs';

web_interface/astpp/application/language/english/menu_lang.php

Spacing +69 added lines, -69 removed lines

@@ -1,101 +1,101 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 //Main Menu
-$lang['Home']='Home';
-$lang['Global Accounts']='Global Accounts';
-$lang['Accounting']='Accounting';
-$lang['Services']='Services';
-$lang['DIDs']='DIDs';
-$lang['Routing']='Routing';
-$lang['Reports']='Reports';
-$lang['System Configuration']='System Configuration';
-$lang['Accounts']='Accounts';
-$lang['FS Devices']='FS Devices';
+$lang['Home'] = 'Home';
+$lang['Global Accounts'] = 'Global Accounts';
+$lang['Accounting'] = 'Accounting';
+$lang['Services'] = 'Services';
+$lang['DIDs'] = 'DIDs';
+$lang['Routing'] = 'Routing';
+$lang['Reports'] = 'Reports';
+$lang['System Configuration'] = 'System Configuration';
+$lang['Accounts'] = 'Accounts';
+$lang['FS Devices'] = 'FS Devices';
 //gloabalAccounts useraccount Menu
 
-$lang['User Accounts']='User Accounts';
-$lang['Customer List']='Customer List';
-$lang['Reseller List']='Reseller List';
-$lang['Callshop List']='Callshop List';
+$lang['User Accounts'] = 'User Accounts';
+$lang['Customer List'] = 'Customer List';
+$lang['Reseller List'] = 'Reseller List';
+$lang['Callshop List'] = 'Callshop List';
 
 //gloabalAccounts  ProviderAccounts Menu
-$lang['Provider Accounts']='Provider Accounts';
-$lang['Provider List']='Provider List';
+$lang['Provider Accounts'] = 'Provider Accounts';
+$lang['Provider List'] = 'Provider List';
 //gloabalAccounts  System Accounts Menu
-$lang['System Accounts']='System Accounts';
-$lang['Admin List']='Admin List';
-$lang['Subadmin List']='Subadmin List';
+$lang['System Accounts'] = 'System Accounts';
+$lang['Admin List'] = 'Admin List';
+$lang['Subadmin List'] = 'Subadmin List';
 
 //Accounting Manage Invoices Menu
-$lang['Manage Account']='Manage Account';
-$lang['Manage Invoice']='Manage Invoice';
+$lang['Manage Account'] = 'Manage Account';
+$lang['Manage Invoice'] = 'Manage Invoice';
 $lang['Invoices'] = 'Invoices';
-$lang['Invoice List']='Invoice List';
-$lang['Invoice Configuration']='Invoice Configuration';
+$lang['Invoice List'] = 'Invoice List';
+$lang['Invoice Configuration'] = 'Invoice Configuration';
 
 //Accounting Subscription Menu
-$lang['Subscriptions']='Subscriptions';
-$lang['Periodic Charges']='Periodic Charges';
+$lang['Subscriptions'] = 'Subscriptions';
+$lang['Periodic Charges'] = 'Periodic Charges';
 
 //Accounting Manage Taxes Menu
-$lang['Manage Taxes']='Manage Taxes';
-$lang['Taxes']='Taxes';
+$lang['Manage Taxes'] = 'Manage Taxes';
+$lang['Taxes'] = 'Taxes';
 
 //Services Calling Cards Menu
 
-$lang['Calling Cards']='Calling Cards';
-$lang['List Cards']='List Cards';
-$lang['CC Brands']='CC Brands';
-$lang['Calling Card CDRs']='Calling Card CDRs';
+$lang['Calling Cards'] = 'Calling Cards';
+$lang['List Cards'] = 'List Cards';
+$lang['CC Brands'] = 'CC Brands';
+$lang['Calling Card CDRs'] = 'Calling Card CDRs';
 
 //DID Menu
-$lang['Manage DID']='Manage DID';
-$lang['Manage DIDs']='Manage DIDs';
+$lang['Manage DID'] = 'Manage DID';
+$lang['Manage DIDs'] = 'Manage DIDs';
 
 //Routing Providers Menu
 $lang['Freeswitch Devices'] = 'Freeswitch Devices';
-$lang['Providers']='Providers';
-$lang['Trunks']='Trunks';
-$lang['Termination Rates']='Termination Rates';
-$lang['Gateways']='Gateways';
-$lang['Sip Profile']='Sip Profile';
-$lang['SIP Devices']='SIP Devices';
+$lang['Providers'] = 'Providers';
+$lang['Trunks'] = 'Trunks';
+$lang['Termination Rates'] = 'Termination Rates';
+$lang['Gateways'] = 'Gateways';
+$lang['Sip Profile'] = 'Sip Profile';
+$lang['SIP Devices'] = 'SIP Devices';
 
 //Routing Clients Menu
-$lang['Rates']='Rates';
-$lang['Clients']='Clients';
-$lang['Rate Group']='Rate Group';
-$lang['Origination Rates']='Origination Rates';
-$lang['Packages']='Packages';
-$lang['Package Usage Report']='Package Usage Report';
+$lang['Rates'] = 'Rates';
+$lang['Clients'] = 'Clients';
+$lang['Rate Group'] = 'Rate Group';
+$lang['Origination Rates'] = 'Origination Rates';
+$lang['Packages'] = 'Packages';
+$lang['Package Usage Report'] = 'Package Usage Report';
 
 //Reports->CallDetail Reports
-$lang['CDRs Reports']='CDRs Reports';
-$lang['Call Detail Reports']='Call Detail Reports';
-$lang['Customer Reports']='Customer Reports';
-$lang['Reseller Report']='Reseller Report';
-$lang['Provider Report']='Provider Report';
+$lang['CDRs Reports'] = 'CDRs Reports';
+$lang['Call Detail Reports'] = 'Call Detail Reports';
+$lang['Customer Reports'] = 'Customer Reports';
+$lang['Reseller Report'] = 'Reseller Report';
+$lang['Provider Report'] = 'Provider Report';
 
 //Reports->Switch Reports Menu
-$lang['Switch Reports']='Switch Reports';
-$lang['Live Call Report']='Live Call Report';
-$lang['Trunk Stats']='Trunk Stats';
+$lang['Switch Reports'] = 'Switch Reports';
+$lang['Live Call Report'] = 'Live Call Report';
+$lang['Trunk Stats'] = 'Trunk Stats';
 
 //Reports->Summary Reports Menu
-$lang['Summary Reports']='Summary Report';
-$lang['Provider Reports']='Provider Report';
-$lang['User Report']="User Report";
+$lang['Summary Reports'] = 'Summary Report';
+$lang['Provider Reports'] = 'Provider Report';
+$lang['User Report'] = "User Report";
 
 //Reports->Payment Reports Menu
-$lang['Payment Reports']='Payment Reports';
-$lang['Payment Report']='Payment Report';
-
-
-$lang['Switch Config']='Switch Config';
-$lang['Softswitch']='Softswitch';
-$lang['System']='System';
-$lang['Freeswitch SIP Devices']='Freeswitch SIP Devices';
-$lang['Freeswitch Server']='Freeswitch Server';
-$lang['Configuration']='Configuration';
-$lang['Email Template']='Email Template';
-$lang['Freeswitch']='Freeswitch';
+$lang['Payment Reports'] = 'Payment Reports';
+$lang['Payment Report'] = 'Payment Report';
+
+
+$lang['Switch Config'] = 'Switch Config';
+$lang['Softswitch'] = 'Softswitch';
+$lang['System'] = 'System';
+$lang['Freeswitch SIP Devices'] = 'Freeswitch SIP Devices';
+$lang['Freeswitch Server'] = 'Freeswitch Server';
+$lang['Configuration'] = 'Configuration';
+$lang['Email Template'] = 'Email Template';
+$lang['Freeswitch'] = 'Freeswitch';
 ?>

Braces +3 added lines, -1 removed lines

@@ -1,4 +1,6 @@
-<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
+<?php if (!defined('BASEPATH')) {
+	exit('No direct script access allowed');
+}
 
 //DID list
 $lang['DID.MANAGE_DIDs']='Manage DIDs';