<?php
include "general2.php";
include "connect.php";
include 'sendmailclient.php';
	   $loginuser = $_SESSION['loginuser'];
	   if($loginuser ==='')
	   {
	   header('Location: index.php?err=2');
	   }
$adminemail = $_SESSION['email'];
//$pin = $_SESSION['pin'];
$pass = $_SESSION['pass'];

//echo $adminemail;
//echo $pin;
//echo $pass;

//exit();


$clientusername =$_POST["username"]; 
$amt =$_POST["amount"]; 
//$mpin =$_POST["pin"]; 
//$transid =$_GET["transid"]; 
//$amt =$_GET["amt"];
//$username =$_GET["pusername"];


//echo $clientusername ."<br>";
//echo $amt;
//exit();


//echo $email;
//echo $amt; 
//echo $newbal;
//echo $oldbal; 


//check if admin is authorized
date_default_timezone_set('Europe/London');

$profile = $_SESSION['profile'];
if ($profile== "1")
{
  header('Location: index.php?err=1');
  exit();
}

//echo $query;
//echo $cnt;
//exit();

	
//get his phone number
$query ="select * from userlogin where username='". $clientusername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  echo mysqli_error($con);
  echo "-2";
   mysqli_close($con);
   exit();
}

$cnt = mysqli_num_rows($result);

if ($cnt != 1)
{
  header('Location: adminlogged.php?err=4');
  exit();
}



while($row = mysqli_fetch_array($result))
{
	$phonenumber = $row['phonenumber'];
	$clientemail = $row['email'];
}



//get his smsprofile

$query ="select * from smsprofile where username='". $clientusername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  echo mysqli_error($con);
  echo "-2";
   mysqli_close($con);
   exit();
}

$cnt = mysqli_num_rows($result);

if ($cnt != 1)
{
  header('Location: adminlogged.php?err=5');
  exit();
}



while($row = mysqli_fetch_array($result))
{
	$subprofile = $row['subprofile'];
  
}





//get is old balance 
  $query ="select * from smsaccount where username='". $clientusername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  echo mysqli_error($con);
  echo "-2";
   mysqli_close($con);
   exit();
}

//$cnt = 1000;

while($row = mysqli_fetch_array($result))
{
    if ($subprofile == '1')
	{
	   $oldbal = $row['balnaira'];
	}
	
	if ($subprofile == '2')
	{
	   $oldbal = $row['baleuro'];
	}
	
	if ($subprofile == '3')
	{
	   $oldbal = $row['baldollar'];
	}
}


$newbal = $oldbal + $amt;
//echo $oldbal."<br>";
//echo $amt ."<br>";
//echo $newbal ."<br>";

//exit();

if ($subprofile == '1')
 {
 $query ="update smsaccount set balnaira='". $newbal. "',dateused='".date('Y-m-d H:i:s')."' where username='". $clientusername ."' and domain='".$domain."'";
 }
 
 
 if ($subprofile == '2')
 {
 $query ="update smsaccount set baleuro='". $newbal. "',dateused='".date('Y-m-d H:i:s')."' where username='". $clientusername ."' and domain='".$domain."'";
 echo query;
 
 }
 
 
 if ($subprofile == '3')
 {
 $query ="update smsaccount set baldollar='". $newbal. "',dateused='".date('Y-m-d H:i:s')."' where username='". $clientusername ."' and domain='".$domain."'";
 }
 

if(!$result= mysqli_query($con,$query))
{
  echo mysqli_error($con);
  echo "-2";
   mysqli_close($con);
   exit();
}

$query ="INSERT INTO transferlogs (adminname, username,oldbal,amtcredited,newbal,datecredited,domain)  VALUES ('". $username ."','".  $clientusername  ."','". $oldbal ."','".$amt."','".$newbal."','". date('Y-m-d H:i:s')."','".$domain."')";

echo query;

if(!$result= mysqli_query($con,$query))
{
  echo mysqli_error($con);
 // echo mysqli_error($con);
  echo "-3";
   mysqli_close($con);
   exit();
}

//echo "0";

$mysub = "Account Topup Report ".$domain ;
$myMessage ="Dear ". $clientusername. ",<br><br>";
$myMessage .= "Your ". $domain. " account has just be credited : <br><br>"; 
if ($subprofile =='1' ){
$myMessage .= "Amount Credited : N" . $amt . "<br>";
}

if ($subprofile =='2' ){
$myMessage .= "Amount Credited : &euro;" . $amt . "<br>";
}

if ($subprofile =='3' ){
$myMessage .= "Amount Credited : $" . $amt . "<br>";
}
$myMessage .= "Old Bal: " . $oldbal. "<br>";
$myMessage .= "New Bal: " . $newbal .  "<br><br>"; 
$myMessage .= "Thanks for doing business with us. " . "<br>";
$myMessage .= "Billing @ ".$domain;


$myMessage2 .= $myMessage;
$mymail = sendmailtoclient($email,$myMessage,$myMmessage2,$mysub,$mfrom,$mfromname);

//send sms

$transid =  generateTransID();
   $mtype ="1";
   $mess= "Dear ".  $username ."\n". "Account Topup Report" ."\n". "Old Balance " .number_format($amtold,2,'.',','). "\n" . "Amount Credited " .number_format($amt,2,'.',',')."\n". "New Balance ". number_format($newbal,2,'.',',') . "\n" . "Thanks from sales@".$domain;  
   $phonenumber = getPhonenumber($username,$domain);
   $ct = sendSMS( $username,$phonenumber, $transid, $domain,$mess,$sender,$mtype);

mysqli_close($con);
header('Location: index.php?err=0');
exit();
?>