<?php

	$servername = "localhost";
	$username = "betterplanning_admin";
	$password = "@Kokodi12@";
	$dbname = "betterplanning_betasms";
	
	// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	// Check connection
	if ($conn->connect_error) {
	  die("Connection failed: " . $conn->connect_error);
	}
	
	// $userName = 'global.wallet@betterplanning.net';
    // $pass = 'GlobalWallet';
    
    $userName = 'Fontah.derick@betterplanning.net';
    $pass = 'testbetter';
	
	date_default_timezone_set("Africa/Douala");
	
	$sql = "SELECT id, message, phone, title, quantity, account_id FROM account_sms";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
	    
	  // output data of each row
	  while($row = $result->fetch_assoc()) {
	      
	      $id = $row["id"];
	      
	      $mobileNumber = $row["phone"];
	      $senderId = $row["title"];
	      $message = $row["message"];
	      
	      $quantity = $row["quantity"];
	      $account_id = $row["account_id"];
		
		// Get Account 
		$sqlAccount = "SELECT sms, table_name FROM security_user where id = $account_id";
	    $resultAccount = $conn->query($sqlAccount);
		
		if ($resultAccount->num_rows > 0){
		    
		    $rowAccount = $resultAccount->fetch_assoc();
		    
		    // Get Account SMS credit and table name
		    $accountSms = $rowAccount["sms"];
		    $tableName = $rowAccount["table_name"];
		    
		    if ($accountSms > $quantity)
            {
                // We can process de sms
                $url = "https://smsvas.com/bulk/public/index.php/api/v1/sendsms?user=".$userName."&password=".$pass."&senderid=".$senderId."&mobiles=".$mobileNumber."&sms=".urlencode($message);
                $execute = file_get_contents($url);
    
                if(!empty($execute))
                {
                    $output = json_decode($execute);
    
                    if($output->{'sms'}[0]->{'status'} == "success")
                    {
                        $status = '000';
                        
                        // Account sms reduction
                        $balance = $accountSms - $quantity;
                        $sqlAccountSmsUpdate = "UPDATE security_user SET sms=$balance WHERE id=$account_id";
                        
                        if ($conn->query($sqlAccountSmsUpdate) === TRUE) {
                          // echo "Record updated successfully";
                        } else {
                          // echo "Error updating record: " . $conn->error;
                        }
                        
                        // Delete sms into account sms
                        $sqlDelete = "DELETE FROM account_sms WHERE id=$id";

                        if ($conn->query($sqlDelete) === TRUE) {
                          echo "Record deleted successfully";
                        } else {
                          echo "Error deleting record: " . $conn->error;
                        }
                    }
                    else{
                        $status = '001';
                    }
                }
                else
                {
                    $status = '002';
                }
    
            }
		    
		}
		
		// History 
		
		$dateFormat = "'".date('Y-m-d H:i:s', strtotime(str_replace('-', '/', date('H:i:s'))))."'";
		
		$sqlInsert = "INSERT INTO $tableName (climsgid, MSG, RECEIVER, SENDER, DATESEND, DATVAL, STATUS, is_archive)
        VALUES ('100', '$message', $mobileNumber, '$senderId', $dateFormat, $dateFormat, '$status', 0)";
        
        if ($conn->query($sqlInsert) === TRUE) {
          // echo "New record created successfully";
        } else {
          // echo "Error: " . $sqlInsert . "<br>" . $conn->error;
        }
		
		die();
		
	  }
	  
	} 
	/*else {
	  echo "0 results";
	}*/
	
	$conn->close();

?>