iNextrix / ASTPP

web_interface/astpp/cron/cron.php

Spacing +3 added lines, -3 removed lines

@@ -22,7 +22,7 @@ 
         unset($argv[1]);
 //        $argv = array_merge($argv, $config["argv"][$path]);
         $argv[0] = $argv[0];
-        $argv[1] =$config["argv"][$path];
+        $argv[1] = $config["argv"][$path];
         $_SERVER['argv'] = $argv;
     } else
         die('Use: php cron.php controller/method');
@@ -41,11 +41,11 @@ 
 ob_start();
 
 // 	chdir( dirname( CRON_CI_INDEX ) );
-require( CRON_CI_INDEX );           // main CI index.php file
+require(CRON_CI_INDEX); // main CI index.php file
 $output = ob_get_contents();
 
 if (CRON_FLUSH_BUFFERS === TRUE)
-    while (@ob_end_flush());          // display buffer contents
+    while (@ob_end_flush()); // display buffer contents
         else
     ob_end_clean();
 

web_interface/astpp/application/controllers/run_cron.php

Spacing +4 added lines, -4 removed lines

@@ -41,7 +41,7 @@ 
 	function __construct()
 	{
 		parent::__construct();
-		if(!defined( 'CRON' ) )  
+		if ( ! defined('CRON'))  
 		  exit();
 	}
 
@@ -76,7 +76,7 @@ 
 	function generate_sitemap()
 	{	
 		// Live Mode:
-		if( ! CRON_BETA_MODE )
+		if ( ! CRON_BETA_MODE)
 			$cron_id = $this->cron->create('Sitemap (Google|Bing|Ask|Yahoo!)');
 		
 		// Example Code
@@ -89,7 +89,7 @@ 
 		// ...
 
 		// Sandbox Mode:
-		if( CRON_BETA_MODE )
+		if (CRON_BETA_MODE)
 			$this->sitemap->generate_xml(null, false);
 			
 		// Live Mode:
@@ -97,7 +97,7 @@ 
 			echo 'live';
 		
 			$this->sitemap->generate_xml();
-			$this->cron->update( $cron_id );
+			$this->cron->update($cron_id);
 		}
 		
 	}

web_interface/astpp/application/controllers/broadcastemail.php

Spacing +6 added lines, -6 removed lines

@@ -25,21 +25,21 @@
     function __construct()
     {
 	parent::__construct();
-	if(!defined( 'CRON' ) )  
+	if ( ! defined('CRON'))  
 	  exit();
         $this->load->model("db_model");
         $this->load->library("astpp/email_lib");
     }
-    function broadcast_email(){
+    function broadcast_email() {
 	
        $where = array("status"=>"1");
         $query = $this->db_model->getSelect("*", "mail_details", $where);
-        if($query->num_rows >0){
+        if ($query->num_rows > 0) {
             $account_data = $query->result_array();
-            foreach($account_data as $data_key =>$account_value){
-		     $account_value['history_id']=$account_value['id'];
+            foreach ($account_data as $data_key =>$account_value) {
+		     $account_value['history_id'] = $account_value['id'];
 		     unset($account_value['id']);
-		     $this->email_lib->send_email('',$account_value,'',$account_value['attachment'],1,0,1);
+		     $this->email_lib->send_email('', $account_value, '', $account_value['attachment'], 1, 0, 1);
             }
         }
     }

web_interface/astpp/application/controllers/getstatus.php

Spacing +4 added lines, -4 removed lines

@@ -31,11 +31,11 @@
 	}
 	
 	
-	function customer_list_status($id){
+	function customer_list_status($id) {
 			 $post_data = $this->input->post();
-             $post_data['table']=$this->common->decode($post_data['table']);
-             $data['status']=$post_data['status'] =='true'? 0:1;
-             $result=$post_data['table'] =='accounts' && $post_data['id'] == 1 ? null:$this->db->update($post_data['table'],$data,array("id"=>$post_data['id']));
+             $post_data['table'] = $this->common->decode($post_data['table']);
+             $data['status'] = $post_data['status'] == 'true' ? 0 : 1;
+             $result = $post_data['table'] == 'accounts' && $post_data['id'] == 1 ? null : $this->db->update($post_data['table'], $data, array("id"=>$post_data['id']));
              echo TRUE;
 	}
 		

web_interface/astpp/application/controllers/feedback.php

Spacing +38 added lines, -38 removed lines

@@ -28,59 +28,59 @@ 
 		parent::__construct();
 	}
 	
-	function index(){
+	function index() {
 		$data['account_info'] = $this->session->userdata['accountinfo'];
 		$data['username'] = $this->session->userdata('user_name');
 		$data['page_title'] = "Feedback";
-		$this->load->view('view_feedback',$data);
+		$this->load->view('view_feedback', $data);
 	}
-	function customer_feedback_result($flag=FALSE){
-		if($flag){
+	function customer_feedback_result($flag = FALSE) {
+		if ($flag) {
 			$account_info = array();
-			$this->db->where("accountid","1");
+			$this->db->where("accountid", "1");
 			$res = $this->db->get('invoice_conf');
-			if($res->num_rows > 0){
+			if ($res->num_rows > 0) {
 				$masterdata = $res->result_array();
 				$account_info = $masterdata['0'];
 
-				$company_name=$account_info['company_name'];
-				$address=$account_info['address'];
-				$city=$account_info['city'];
-				$province=$account_info['province'];
-				$country=$account_info['country'];
-				$zipcode=$account_info['zipcode'];
-				$telephone=$account_info['telephone'];
-				$fax=$account_info['fax'];
-				$emailaddress=$account_info['emailaddress'];
-				$website=$account_info['website'];
+				$company_name = $account_info['company_name'];
+				$address = $account_info['address'];
+				$city = $account_info['city'];
+				$province = $account_info['province'];
+				$country = $account_info['country'];
+				$zipcode = $account_info['zipcode'];
+				$telephone = $account_info['telephone'];
+				$fax = $account_info['fax'];
+				$emailaddress = $account_info['emailaddress'];
+				$website = $account_info['website'];
 
-				$data=array("name"=>"Admin","company_name"=>$company_name,"address"=>$address,"city"=>$city,"province"=>$province,"country"=>$country,"zipcode"=>$zipcode,"telephone"=>$telephone,"fax"=>$fax,"emailaddress"=>$emailaddress,"website"=>$website,"serverip"=>$_SERVER['SERVER_NAME'],"FLAG"=>"TRUE");				
+				$data = array("name"=>"Admin", "company_name"=>$company_name, "address"=>$address, "city"=>$city, "province"=>$province, "country"=>$country, "zipcode"=>$zipcode, "telephone"=>$telephone, "fax"=>$fax, "emailaddress"=>$emailaddress, "website"=>$website, "serverip"=>$_SERVER['SERVER_NAME'], "FLAG"=>"TRUE");				
 			}
-		}else{
+		} else {
 			$account_info = array();
-			$this->db->where("type","-1");
+			$this->db->where("type", "-1");
 			$res = $this->db->get('accounts');
-			if($res->num_rows > 0){
+			if ($res->num_rows > 0) {
 				$masterdata = $res->result_array();
 				$account_info = $masterdata['0'];
 
-			$name=$_REQUEST['name']="Admin";
-			$email=$_REQUEST['email']=$account_info['email'];
-			$feedback=$_REQUEST['feedback'];
-			$first_name=$account_info['first_name'];
-			$last_name=$account_info['last_name'];
-			$city=$account_info['city'];
-			$telephone_1=$account_info['telephone_1'];
-			$account_email=$account_info['email'];
-			$company_name=$account_info['company_name'];
-			$address_1=$account_info['address_1'];
-			$address_2=$account_info['address_2'];
-			$telephone_2=$account_info['telephone_2'];
-			$province=$account_info['province'];
+			$name = $_REQUEST['name'] = "Admin";
+			$email = $_REQUEST['email'] = $account_info['email'];
+			$feedback = $_REQUEST['feedback'];
+			$first_name = $account_info['first_name'];
+			$last_name = $account_info['last_name'];
+			$city = $account_info['city'];
+			$telephone_1 = $account_info['telephone_1'];
+			$account_email = $account_info['email'];
+			$company_name = $account_info['company_name'];
+			$address_1 = $account_info['address_1'];
+			$address_2 = $account_info['address_2'];
+			$telephone_2 = $account_info['telephone_2'];
+			$province = $account_info['province'];
 
-			$data=array("name"=>$name,"email"=>$email,"feedback"=>$feedback,"first_name"=>$first_name,"last_name"=>$last_name,"city"=>$city,"telephone_1"=>$telephone_1,"account_email"=>$account_email,"company_name"=>$company_name,"address_1"=>$address_1,"address_2"=>$address_2,"telephone_2"=>$telephone_2,"province"=>$province,"serverip"=>$_SERVER['SERVER_ADDR'],"FLAG"=>"FALSE");
+			$data = array("name"=>$name, "email"=>$email, "feedback"=>$feedback, "first_name"=>$first_name, "last_name"=>$last_name, "city"=>$city, "telephone_1"=>$telephone_1, "account_email"=>$account_email, "company_name"=>$company_name, "address_1"=>$address_1, "address_2"=>$address_2, "telephone_2"=>$telephone_2, "province"=>$province, "serverip"=>$_SERVER['SERVER_ADDR'], "FLAG"=>"FALSE");
 
-		        $data_new= json_encode($data);
+		        $data_new = json_encode($data);
 	        }
 		}
         $ch = curl_init();
@@ -96,12 +96,12 @@ 
 		curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
 
         $response = curl_exec($ch);
-        if(!$flag)
-	     redirect(base_url() . 'feedback/thanks');
+        if ( ! $flag)
+	     redirect(base_url().'feedback/thanks');
 	    
 
 	}
-	function thanks(){
+	function thanks() {
             $this->load->view('view_feedback_response');
 	}	
 

web_interface/astpp/application/controllers/updateBalance.php

Spacing +28 added lines, -28 removed lines

@@ -50,7 +50,7 @@ 
         
         // Check Charge is applied that is for first time or already calculated before
 
-        $where = "(charge_upto ='0000-00-00 00:00:00' OR charge_upto <='" . gmdate("Y-m-d H:i:s") . "')";
+        $where = "(charge_upto ='0000-00-00 00:00:00' OR charge_upto <='".gmdate("Y-m-d H:i:s")."')";
         $this->db->where('accountid', $accountinfo['id']);
         $this->db->where($where);
         $this->db->select('*');
@@ -61,13 +61,13 @@ 
             foreach ($accountchargs as $accharges) {
                 //Get information from database of active charges.
                 $charge_data = $this->get_table_data("*", "charges", array("id" => $accharges['charge_id'], "status" => "0"));
-                if ($charge_data && !empty($charge_data)) {
+                if ($charge_data && ! empty($charge_data)) {
                     $charge_data = $charge_data[0];
                     //Get Start Date of Charge
                     $charge_upto = ($accharges["charge_upto"] != "0000-00-00 00:00:00" && $accharges["charge_upto"] != "") ?
-                            date("Y-m-d H:i:s", strtotime("+1 Second", strtotime($accharges["charge_upto"]))) :$accharges["assign_date"];
-                   if($accountinfo['original_sweep_id'] == 2 && $charge_data['pro_rate'] == 0 && $charge_data['sweep_id'] == 2 && ($accountinfo['invoice_day']< gmdate("d",strtotime($accharges['assign_date'])))) {
-                      $charge_upto=   date("Y-m-" . $accountinfo['invoice_day'] . " H:i:s", strtotime($accharges["assign_date"]));
+                            date("Y-m-d H:i:s", strtotime("+1 Second", strtotime($accharges["charge_upto"]))) : $accharges["assign_date"];
+                   if ($accountinfo['original_sweep_id'] == 2 && $charge_data['pro_rate'] == 0 && $charge_data['sweep_id'] == 2 && ($accountinfo['invoice_day'] < gmdate("d", strtotime($accharges['assign_date'])))) {
+                      $charge_upto = date("Y-m-".$accountinfo['invoice_day']." H:i:s", strtotime($accharges["assign_date"]));
                    }
                     //Overwrite Billing scehdule of customer assign proper charge
                     if ($accountinfo['sweep_id'] != $charge_data['sweep_id']) {
@@ -134,7 +134,7 @@ 
                                 $lastdate = $this->calculate_charges($reseller_acc_data, $itemArr, $reseller_dids["monthlycost"], $fromdate, $todate, "1");
                                 if ($lastdate)
                                     $this->db->update("reseller_pricing", array("charge_upto" => $lastdate), array("note" => $did_value["number"], "reseller_id" => $reseller_acc_data["id"]));
-                            }else {
+                            } else {
                                 //Apply charges to Resellers.
                                 $lastdate = $this->calculate_charges($reseller_acc_data, $itemArr, $reseller_dids["monthlycost"], $fromdate, $todate, "1");
                                 if ($lastdate)
@@ -156,39 +156,39 @@ 
     function calculate_charges($AccountDATA, $itemArr, $charge, $fromdate, $todate, $pro_rate = "1") {
         $lastdate = false;
         $billing_cycle = ($AccountDATA['sweep_id'] == "0") ? "1 day" : "1 month";
-        $last_invoice_date = $this->common->get_invoice_date("invoice_date",$AccountDATA['id'],$AccountDATA['reseller_id']);
+        $last_invoice_date = $this->common->get_invoice_date("invoice_date", $AccountDATA['id'], $AccountDATA['reseller_id']);
       //Below variable gives date based on assign or creation or monthly user billing day
-        $last_invoice_date = ($last_invoice_date) ? $last_invoice_date : (($pro_rate == 0 && $AccountDATA['original_sweep_id'] == 2 && ($AccountDATA['invoice_day']< gmdate("d",strtotime($itemArr['assign_date'])))) ? date("Y-m-" . $AccountDATA['invoice_day'] . " 00:00:00") : (($pro_rate == 1 && $AccountDATA['original_sweep_id'] == 0) ? date("Y-m-d 00:00:00", strtotime($itemArr['assign_date'])) : date("Y-m-d 00:00:00", strtotime($AccountDATA['creation']))));
+        $last_invoice_date = ($last_invoice_date) ? $last_invoice_date : (($pro_rate == 0 && $AccountDATA['original_sweep_id'] == 2 && ($AccountDATA['invoice_day'] < gmdate("d", strtotime($itemArr['assign_date'])))) ? date("Y-m-".$AccountDATA['invoice_day']." 00:00:00") : (($pro_rate == 1 && $AccountDATA['original_sweep_id'] == 0) ? date("Y-m-d 00:00:00", strtotime($itemArr['assign_date'])) : date("Y-m-d 00:00:00", strtotime($AccountDATA['creation']))));
         $last_invoice_date = ($last_invoice_date <= $fromdate) ? $last_invoice_date : $fromdate;
         $Charges_date_range = array();
-        $prorate_array =array();
+        $prorate_array = array();
         $daylen = 60 * 60 * 24;
         /*Get assign day and billing day for postpaid monthly user.
          */
-        $assign_day=($AccountDATA['original_sweep_id']==2 && $AccountDATA['posttoexternal']==1) ? gmdate("d",strtotime($itemArr['assign_date'])):0;
-        $billing_day=($AccountDATA['original_sweep_id']==2 && $AccountDATA['posttoexternal']==1) ? $AccountDATA['invoice_day']:0;
+        $assign_day = ($AccountDATA['original_sweep_id'] == 2 && $AccountDATA['posttoexternal'] == 1) ? gmdate("d", strtotime($itemArr['assign_date'])) : 0;
+        $billing_day = ($AccountDATA['original_sweep_id'] == 2 && $AccountDATA['posttoexternal'] == 1) ? $AccountDATA['invoice_day'] : 0;
         //Create an array if charge not applied yet and invoice day is greater than assign_day
-        if($itemArr['charge_upto'] == "0000-00-00 00:00:00" && ($billing_day > $assign_day) && $pro_rate==0 && $itemArr['cycle']==2 && $AccountDATA['original_sweep_id']==2){
-	  $last_invoice_date = gmdate("Y-m-d H:i:s",strtotime("-1 second",strtotime(date("Y-m-" . $AccountDATA['invoice_day'] . " 00:00:00", strtotime($itemArr["assign_date"])))));
-	  $prorate_array[] = array("start_date" => date("Y-m-d H:i:s",strtotime($itemArr['assign_date'])), "end_date" => $last_invoice_date);
+        if ($itemArr['charge_upto'] == "0000-00-00 00:00:00" && ($billing_day > $assign_day) && $pro_rate == 0 && $itemArr['cycle'] == 2 && $AccountDATA['original_sweep_id'] == 2) {
+	  $last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("-1 second", strtotime(date("Y-m-".$AccountDATA['invoice_day']." 00:00:00", strtotime($itemArr["assign_date"])))));
+	  $prorate_array[] = array("start_date" => date("Y-m-d H:i:s", strtotime($itemArr['assign_date'])), "end_date" => $last_invoice_date);
 	  
         }
         while (strtotime($last_invoice_date) <= strtotime($todate)) {
-            $startdate=$last_invoice_date;
-            $last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("+" . $billing_cycle, strtotime($last_invoice_date)));
-            $Charges_date_range[] = array("start_date" =>gmdate("Y-m-d H:i:s",strtotime("+1 Second",strtotime($startdate))), "end_date" => $last_invoice_date);
+            $startdate = $last_invoice_date;
+            $last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("+".$billing_cycle, strtotime($last_invoice_date)));
+            $Charges_date_range[] = array("start_date" =>gmdate("Y-m-d H:i:s", strtotime("+1 Second", strtotime($startdate))), "end_date" => $last_invoice_date);
         }
-        if(!empty($prorate_array)){
+        if ( ! empty($prorate_array)) {
          array_pop($Charges_date_range);
-         $Charges_date_range=array_merge($prorate_array,$Charges_date_range);
+         $Charges_date_range = array_merge($prorate_array, $Charges_date_range);
         }
-        if (!empty($Charges_date_range)) {
+        if ( ! empty($Charges_date_range)) {
             foreach ($Charges_date_range as $ChargeVal) {
-                if (($pro_rate == 0 && $itemArr['cycle'] != 2) || (($billing_day <= $assign_day) && $pro_rate==0 && $itemArr['cycle']==2 && $AccountDATA['original_sweep_id']==2)) {
+                if (($pro_rate == 0 && $itemArr['cycle'] != 2) || (($billing_day <= $assign_day) && $pro_rate == 0 && $itemArr['cycle'] == 2 && $AccountDATA['original_sweep_id'] == 2)) {
                     $ChargeVal['end_date'] = gmdate("Y-m-d 23:59:59", strtotime("-1 Day", strtotime($ChargeVal['end_date'])));
                 }
-                if (!empty($itemArr['charge_upto']) && empty($lastdate)) {
-                    $start_date = ($itemArr['charge_upto'] == '0000-00-00 00:00:00' && $AccountDATA['sweep_id'] == 2 ) ? $itemArr['assign_date'] : $ChargeVal['start_date'];
+                if ( ! empty($itemArr['charge_upto']) && empty($lastdate)) {
+                    $start_date = ($itemArr['charge_upto'] == '0000-00-00 00:00:00' && $AccountDATA['sweep_id'] == 2) ? $itemArr['assign_date'] : $ChargeVal['start_date'];
                 } else {
                     $start_date = (empty($lastdate)) ? $ChargeVal['start_date'] : gmdate("Y-m-d H:i:s", strtotime("+1 second", strtotime($lastdate)));
                 }
@@ -222,13 +222,13 @@ 
         $Bal = "0.00"; 
         if ($AccountData["posttoexternal"] == 0) {
 	    $reseller_id = $AccountData['type'] == 1 ? $AccountData['id'] : 0;
-	    $where = "accountid IN ('" . $reseller_id . "','1')";
+	    $where = "accountid IN ('".$reseller_id."','1')";
 	    $this->db->where($where);
 	    $this->db->select('*');
 	    $this->db->order_by('accountid', 'desc');
 	    $this->db->limit(1);
 	    $invoiceconf = $this->db->get('invoice_conf');
-	    $invoice_conf = (array) $invoiceconf->first_row();
+	    $invoice_conf = (array)$invoiceconf->first_row();
 	    $last_invoiceid = $this->common->get_invoice_date('invoiceid', '', $AccountData['reseller_id']);
 	    if ($last_invoiceid && $last_invoiceid > 0) {
 	    	$last_invoiceid = ($last_invoiceid + 1);
@@ -237,10 +237,10 @@ 
 	    }
 	    $last_invoiceid = str_pad($last_invoiceid, (strlen($last_invoiceid) + 4), '0', STR_PAD_LEFT);
 	    $invoice_prefix = $invoice_conf['invoice_prefix'];
-	    $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoice_conf['interval'] . " days"));
+	    $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoice_conf['interval']." days"));
 
             $invoiceid = $this->common_model->generate_receipt($AccountData["id"], $charge, $AccountData, $last_invoiceid, $invoice_prefix, $due_date);
-            $this->db->set('balance', 'balance-' . $charge, FALSE);
+            $this->db->set('balance', 'balance-'.$charge, FALSE);
             $this->db->where('id', $AccountData["id"]);
             $this->db->update("accounts");
             $AccountData['balance'] = ($AccountData['balance'] - $charge);
@@ -255,7 +255,7 @@ 
         }
         $invoice_item_arr = array("accountid" => $AccountData["id"],
             "reseller_id" => $AccountData["reseller_id"],
-            "description" => trim($description . "-" . $fromdate . " to " . $todate),
+            "description" => trim($description."-".$fromdate." to ".$todate),
             "item_id" => $item_id, "debit" => $charge, "invoiceid" => $invoiceid,
             "created_date" => trim($invoicedate),
             "item_type" => $type

web_interface/astpp/application/controllers/getbalance.php

Spacing +52 added lines, -52 removed lines

@@ -31,88 +31,88 @@
 		$this->load->model('db_model');
 		$this->load->model('Astpp_common');
 	}
-	function index($sipnumber=''){
-	$opensips_flag=common_model::$global_config['system_config']['opensips'];
-	$accountid_arr=0;
- 	if($opensips_flag == '1'){
-            $where=array('username'=>$sipnumber);
-            $accountid_arr=$this->db_model->getSelect('accountid','sip_devices',$where);
+	function index($sipnumber = '') {
+	$opensips_flag = common_model::$global_config['system_config']['opensips'];
+	$accountid_arr = 0;
+ 	if ($opensips_flag == '1') {
+            $where = array('username'=>$sipnumber);
+            $accountid_arr = $this->db_model->getSelect('accountid', 'sip_devices', $where);
         }
-	else{
+	else {
 	      $db_config = Common_model::$global_config['system_config'];
-	      $opensipdsn = "mysql://" . $db_config['opensips_dbuser'] . ":" . $db_config['opensips_dbpass'] . "@" . $db_config['opensips_dbhost'] . "/" . $db_config['opensips_dbname'] . "?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
+	      $opensipdsn = "mysql://".$db_config['opensips_dbuser'].":".$db_config['opensips_dbpass']."@".$db_config['opensips_dbhost']."/".$db_config['opensips_dbname']."?char_set=utf8&dbcollat=utf8_general_ci&cache_on=true&cachedir=";
 	    $this->opensips_db = $this->load->database($opensipdsn, true);
 	    $this->opensips_db->where(array("username"=>$sipnumber));
-	    $accountnum_arr=$this->opensips_db->get("subscriber");
-            $accountnum_arr=$accountnum_arr->result_array();
-	    foreach($accountnum_arr as $value_num){
-	    $accountid_arr = $this->db_model->getSelect('id','accounts',array('number'=>$value_num['accountcode']));
+	    $accountnum_arr = $this->opensips_db->get("subscriber");
+            $accountnum_arr = $accountnum_arr->result_array();
+	    foreach ($accountnum_arr as $value_num) {
+	    $accountid_arr = $this->db_model->getSelect('id', 'accounts', array('number'=>$value_num['accountcode']));
 	    }
 	}
-	if($accountid_arr == ''){
+	if ($accountid_arr == '') {
 		echo "Please enter proper username of SIP Account";
 	}
-	if($accountid_arr->num_rows()==0 ){
-		$where=array('number'=>$sipnumber);
-		$accountid_arr=$this->db_model->getSelect('id','accounts',$where);
+	if ($accountid_arr->num_rows() == 0) {
+		$where = array('number'=>$sipnumber);
+		$accountid_arr = $this->db_model->getSelect('id', 'accounts', $where);
 	}
-	if($accountid_arr->num_rows()>0){
-		$accountid_arr=$accountid_arr->result_array();
-		if($opensips_flag == '1'){
-		   foreach($accountid_arr[0] as $key=>$value){
+	if ($accountid_arr->num_rows() > 0) {
+		$accountid_arr = $accountid_arr->result_array();
+		if ($opensips_flag == '1') {
+		   foreach ($accountid_arr[0] as $key=>$value) {
 		   }
-		  if($key== 'id'){
-			$accountid=$accountid_arr[0]['id'];
+		  if ($key == 'id') {
+			$accountid = $accountid_arr[0]['id'];
 		  }
-		  else{
-			$accountid=$accountid_arr[0]['accountid'];
+		  else {
+			$accountid = $accountid_arr[0]['accountid'];
 		 }
 		}
-		else{
-			$accountid=$accountid_arr[0]['id'];
+		else {
+			$accountid = $accountid_arr[0]['id'];
 		}
 		$to_currency = common_model::$global_config['system_config']['base_currency'];
-		if($accountid > 0){
-		$where=array('id'=>$accountid);
-		$balance=$this->db_model->getSelect('balance,currency_id','accounts',$where);
-			if($balance->num_rows() > 0){
+		if ($accountid > 0) {
+		$where = array('id'=>$accountid);
+		$balance = $this->db_model->getSelect('balance,currency_id', 'accounts', $where);
+			if ($balance->num_rows() > 0) {
 				//get balance,currency using by user from account number.
 				$balance_arr = $balance->result_array();
-				$balance=$balance_arr['0']['balance'];
-				$currency=$balance_arr['0']['currency_id'];
+				$balance = $balance_arr['0']['balance'];
+				$currency = $balance_arr['0']['currency_id'];
 				//Get Base Currency From System which is main currency of system.
-				$base_currency_arr=$this->db_model->getSelect('value','system',array('name'=>'base_currency'));
-				$base_currency_arr=$base_currency_arr->result_array();
-				$base_currency=$base_currency_arr['0']['value'];
+				$base_currency_arr = $this->db_model->getSelect('value', 'system', array('name'=>'base_currency'));
+				$base_currency_arr = $base_currency_arr->result_array();
+				$base_currency = $base_currency_arr['0']['value'];
 				//Get basse Currency rate from Currency Name.
-				$base_currency_info=$this->db_model->getSelect('*','currency',array('currency'=>$base_currency));
-				$base_currency_info=$base_currency_info->result_array();
-				$base_currency_rate=$base_currency_info['0']['currencyrate'];
-				$base_currency_name=$base_currency_info['0']['currency'];
+				$base_currency_info = $this->db_model->getSelect('*', 'currency', array('currency'=>$base_currency));
+				$base_currency_info = $base_currency_info->result_array();
+				$base_currency_rate = $base_currency_info['0']['currencyrate'];
+				$base_currency_name = $base_currency_info['0']['currency'];
 				//Find Currency Rate of user Currency from its currency_id
-				$where= array('id'=>$currency);
-				$user_currency_info=$this->db_model->getSelect("*",'currency',$where);
+				$where = array('id'=>$currency);
+				$user_currency_info = $this->db_model->getSelect("*", 'currency', $where);
 				//user Currency Is deleted or Not
-				if($user_currency_info->num_rows() > 0){
-					$user_currency_info=$user_currency_info->result_array();
-					$user_currency=$user_currency_info['0']['currencyrate'];
-					$user_currency_name=$user_currency_info['0']['currency'];
+				if ($user_currency_info->num_rows() > 0) {
+					$user_currency_info = $user_currency_info->result_array();
+					$user_currency = $user_currency_info['0']['currencyrate'];
+					$user_currency_name = $user_currency_info['0']['currency'];
 				}
-				else{
-					$user_currency=$base_currency_rate;
-					$user_currency_name=$base_currency_name;
+				else {
+					$user_currency = $base_currency_rate;
+					$user_currency_name = $base_currency_name;
 				}
 				// Convert Balance of user in user currency
-				$convert_balance=round(($balance * $user_currency)/$base_currency_rate,2);
-				$convert_balance=sprintf("%.2f", $convert_balance).' '.$user_currency_name;
+				$convert_balance = round(($balance * $user_currency) / $base_currency_rate, 2);
+				$convert_balance = sprintf("%.2f", $convert_balance).' '.$user_currency_name;
 				echo "Balance : ".$convert_balance;
 			}
 		}
-		else{
+		else {
 			echo "0.00 ".$to_currency;
 		}
 	}
-	else{
+	else {
 		echo "Please enter proper username of SIP Account";
 	}
   }

web_interface/astpp/application/controllers/newmail.php

Spacing +8 added lines, -8 removed lines

@@ -29,23 +29,23 @@
 		parent::__construct();
 	}
 	
-	function index(){
+	function index() {
 		$data['account_info'] = $this->session->userdata['accountinfo'];
 		$data['username'] = $this->session->userdata('user_name');
 		$data['page_title'] = "Test Mail";
-		$this->load->view('view_newmail',$data);
+		$this->load->view('view_newmail', $data);
 	}
-	function customer_mail_result($flag=FALSE){
+	function customer_mail_result($flag = FALSE) {
 	$account_info = $this->session->userdata['accountinfo'];
         $post_array = $this->input->post();
-	$post_array['accountid']=$account_info['id'];
-	$post_array['history_id']=0;
-	$post_array['email']=$post_array['to'];
+	$post_array['accountid'] = $account_info['id'];
+	$post_array['history_id'] = 0;
+	$post_array['email'] = $post_array['to'];
 	unset($post_array['to']);
-	$this->email_lib->send_email($post_array,$post_array,'','',0,0);
+	$this->email_lib->send_email($post_array, $post_array, '', '', 0, 0);
 		$this->thanks();
 	}
-	function thanks(){
+	function thanks() {
             $this->load->view('view_mail_response');
 	}	
 

web_interface/astpp/application/controllers/generateInvoice.php

Spacing +32 added lines, -32 removed lines

@@ -52,15 +52,15 @@ 
         if ($query->num_rows > 0) {
             $account_data = $query->result_array();
             foreach ($account_data as $data_key => $account_value) {
-                $end_date = gmdate("Y-m-d") . " 23:59:59";
-                $account_value['sweep_id'] = (int) $account_value['sweep_id'];
+                $end_date = gmdate("Y-m-d")." 23:59:59";
+                $account_value['sweep_id'] = (int)$account_value['sweep_id'];
                 switch ($account_value['sweep_id']) {
                     case 0:
                         $start_date = $this->validate_invoice_date($account_value);
                         if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
                             $start_date = gmdate("Y-m-d H:i:s");
                         }
-                        $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 days"));
+                        $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 days"));
                         $this->Generate_Daily_invoice($account_value, $start_date, $end_date);
                         break;
                     case 2:
@@ -69,23 +69,23 @@ 
                             if (strtotime($start_date) >= strtotime(gmdate("Y-m-d H:i:s"))) {
                                 $start_date = gmdate("Y-m-d H:i:s");
                             }
-                            $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date . " + 1 month"));
+                            $end_date = gmdate("Y-m-d 23:59:59", strtotime($start_date." + 1 month"));
                             $this->Generate_Monthly_invoice($account_value, $start_date, $end_date);
                         }
                         break;
                 }
             }
-            $screen_path = getcwd() . "/cron";
-            $screen_filename = "Email_Broadcast_" . strtotime('now');
-            $command = "cd " . $screen_path . " && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
+            $screen_path = getcwd()."/cron";
+            $screen_filename = "Email_Broadcast_".strtotime('now');
+            $command = "cd ".$screen_path." && /usr/bin/screen -d -m -S  $screen_filename php cron.php BroadcastEmail";
             exec($command);
         }
     }
 
     function validate_invoice_date($account_value) {
-        $last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"],$account_value['reseller_id'],"to_date");
+        $last_invoice_date = $this->common->get_invoice_date("to_date", $account_value["id"], $account_value['reseller_id'], "to_date");
         $last_invoice_date = ($last_invoice_date) ? $last_invoice_date : $account_value['creation'];
-        $last_invoice_date = gmdate("Y-m-d H:i:s",strtotime("+1 Second",strtotime($last_invoice_date)));
+        $last_invoice_date = gmdate("Y-m-d H:i:s", strtotime("+1 Second", strtotime($last_invoice_date)));
         return $last_invoice_date;
     }
 
@@ -111,7 +111,7 @@ 
         //Get Invoice configuration using single query instead of multiple queries.
         $invoice_conf = array();
         $reseller_id = ($accountdata['reseller_id'] == 0) ? 1 : $accountdata['reseller_id'];
-        $where = "accountid IN ('" . $reseller_id . "','1')";
+        $where = "accountid IN ('".$reseller_id."','1')";
         $this->db->select('*');
         $this->db->where($where);
         $this->db->order_by('accountid', 'desc');
@@ -119,7 +119,7 @@ 
         $invoice_conf = $this->db->get('invoice_conf');
         $invoice_conf = (array)$invoice_conf->first_row();
         /*******************************************************/
-        $last_invoice_ID = $this->common->get_invoice_date("invoiceid","", $accountdata['reseller_id']);
+        $last_invoice_ID = $this->common->get_invoice_date("invoiceid", "", $accountdata['reseller_id']);
         if ($last_invoice_ID && $last_invoice_ID > 0) {
             $last_invoice_ID = ($last_invoice_ID + 1);
         } else {
@@ -143,8 +143,8 @@ 
     function count_invoice_data($account, $start_date = "", $end_date = "") {
         $cdr_query = "";
         $inv_data_query = "";
-        $cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = " . $account['id'];
-        $cdr_query .= " AND callstart >='" . $start_date . "' AND callstart <= '" . $end_date . "' AND invoiceid=0 group by calltype";
+        $cdr_query = "select calltype,sum(debit) as debit from cdrs where accountid = ".$account['id'];
+        $cdr_query .= " AND callstart >='".$start_date."' AND callstart <= '".$end_date."' AND invoiceid=0 group by calltype";
 //echo $cdr_query; 
         $cdr_data = $this->db->query($cdr_query);
         if ($cdr_data->num_rows > 0) {
@@ -153,11 +153,11 @@ 
             foreach ($cdr_data as $cdrvalue) {
                 $cdrvalue['debit'] = round($cdrvalue['debit'], self::$global_config['system_config']['decimalpoints']);
                 $tempArr = array("accountid" => $account['id'], "reseller_id" => $account['reseller_id'], "item_id" => "0",
-                    "description" => $cdrvalue['calltype'] . " CALLS for the period (" . $start_date . " to " . $end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
+                    "description" => $cdrvalue['calltype']." CALLS for the period (".$start_date." to ".$end_date, "debit" => $cdrvalue['debit'], "item_type" => $cdrvalue['calltype'], "created_date" => $end_date);
                 $this->db->insert("invoice_details", $tempArr);
             }
         }
-        $inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=" . $account['id'] . " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type != 'FREECALL'";
+        $inv_data_query = "select count(id) as count,sum(debit) as debit,sum(credit) as credit from invoice_details where accountid=".$account['id']." AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type != 'FREECALL'";
 //echo $inv_data_query;         
         $invoice_data = $this->db->query($inv_data_query);
         if ($invoice_data->num_rows > 0) {
@@ -175,8 +175,8 @@ 
 
     //Change Order of arguements
     function update_cdrs_data($accountid, $invoiceid, $start_date = "", $end_date = "") {
-        $inv_data_query = "update invoice_details SET invoiceid = '" . $invoiceid . "' where accountid=" . $accountid;
-        $inv_data_query .= " AND created_date >='" . $start_date . "' AND created_date <= '" . $end_date . "'  AND invoiceid=0 AND item_type !='PAYMENT'";
+        $inv_data_query = "update invoice_details SET invoiceid = '".$invoiceid."' where accountid=".$accountid;
+        $inv_data_query .= " AND created_date >='".$start_date."' AND created_date <= '".$end_date."'  AND invoiceid=0 AND item_type !='PAYMENT'";
         $this->db->query($inv_data_query);
         return true;
     }
@@ -184,24 +184,24 @@ 
     function create_invoice($account, $from_date, $to_date, $last_invoice_ID, $INVprefix, $invoiceconf) {
         //$due_date = gmdate("Y-m-d H:i:s",strtotime($to_date." +".$invoiceconf['interval']." days"));
         if ($invoiceconf['interval'] > 0) {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +" . $invoiceconf['interval'] . " days"));
+            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +".$invoiceconf['interval']." days"));
         } else {
-            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s") . " +7 days"));
+            $due_date = gmdate("Y-m-d H:i:s", strtotime(gmdate("Y-m-d H:i:s")." +7 days"));
         }
         // echo "due daye-------".$due_date.'----------'.$to_date.'------------> Invoice interval'.$invoiceconf['interval']; 
         $balance = ($account['credit_limit'] - $account['balance']);
         $automatic_flag = self::$global_config['system_config']['automatic_invoice'];
-	if($automatic_flag == 1){
+	if ($automatic_flag == 1) {
 	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
             $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance);
-	}else{
+	} else {
 	        $invoice_data = array("accountid" => $account['id'], "invoice_prefix" => $INVprefix, "invoiceid" => $last_invoice_ID, "reseller_id" =>
             $account['reseller_id'], "invoice_date" => gmdate("Y-m-d H:i:s"), "from_date" => $from_date, "to_date" => $to_date, "due_date" => $due_date, "status" => 1, "amount" => "0.00", "balance" => $balance, "confirm" => 1);
 	}
         // echo "<pre>"; print_r($invoice_data); exit;
         $this->db->insert("invoices", $invoice_data);
         $invoiceid = $this->db->insert_id();
-	if($automatic_flag == 0){
+	if ($automatic_flag == 0) {
             $this->download_invoice($invoiceid, $account, $invoiceconf);
 	}
         return $invoiceid;
@@ -226,8 +226,8 @@ 
         $invoicedata = $this->db_model->getSelect("*", "invoices", array("id" => $invoiceid));
         $invoicedata = $invoicedata->result_array();
         $invoicedata = $invoicedata[0];
-        $FilePath = FCPATH . "invoices/" . $accountdata["id"] . '/' . $invoicedata['invoice_prefix']."".$invoicedata['invoiceid'] . "_invoice.pdf";
-        $Filenm = $invoicedata['invoice_prefix'] ."_". $invoicedata['invoiceid'] . "_invoice.pdf";
+        $FilePath = FCPATH."invoices/".$accountdata["id"].'/'.$invoicedata['invoice_prefix']."".$invoicedata['invoiceid']."_invoice.pdf";
+        $Filenm = $invoicedata['invoice_prefix']."_".$invoicedata['invoiceid']."_invoice.pdf";
         $this->common->get_invoice_template($invoicedata, $accountdata, false);
         if ($invoice_conf['invoice_notification']) {
             $this->send_email_notification($FilePath, $Filenm, $accountdata, $invoice_conf, $invoicedata);
@@ -240,21 +240,21 @@ 
         $EmailTemplate = $this->db_model->getSelect("*", "default_templates", $where);
         foreach ($EmailTemplate->result_array() as $TemplateVal) {
             $TemplateData = $TemplateVal;
-            $TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['subject']);
-            $TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['subject']);
-            $TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name'] . " " . $AccountData['last_name'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'] . $invData['invoiceid'], $TemplateData['template']);
+            $TemplateData['subject'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['subject']);
+            $TemplateData['subject'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['subject']);
+            $TemplateData['template'] = str_replace('#NAME#', $AccountData['first_name']." ".$AccountData['last_name'], $TemplateData['template']);
+            $TemplateData['template'] = str_replace('#INVOICE_NUMBER#', $invData['invoice_prefix'].$invData['invoiceid'], $TemplateData['template']);
             $TemplateData['template'] = str_replace('#AMOUNT#', $invData['amount'], $TemplateData['template']);
 
             $TemplateData['template'] = str_replace("#COMPANY_EMAIL#", $invoice_conf['emailaddress'], $TemplateData['template']);
             $TemplateData['template'] = str_replace("#COMPANY_NAME#", $invoice_conf['company_name'], $TemplateData['template']);
             $TemplateData['template'] = str_replace("#COMPANY_WEBSITE#", $invoice_conf['website'], $TemplateData['template']);
-            $TemplateData['template'] = str_replace("#INVOICE_DATE#",$invData['invoice_date'], $TemplateData['template']);
+            $TemplateData['template'] = str_replace("#INVOICE_DATE#", $invData['invoice_date'], $TemplateData['template']);
             $TemplateData['template'] = str_replace("#DUE_DATE#", $invData['due_date'], $TemplateData['template']);
         }
-        $dir_path = getcwd() . "/attachments/";
-        $path = $dir_path . $Filenm;
-        $command = "cp " . $FilePath . " " . $path;
+        $dir_path = getcwd()."/attachments/";
+        $path = $dir_path.$Filenm;
+        $command = "cp ".$FilePath." ".$path;
         exec($command);
         $email_array = array('accountid' => $AccountData['id'],
             'subject' => $TemplateData['subject'],