<?
require 'vendor/autoload.php';
require 'db.php';



// Retrieve the raw body from the request
// $input = @file_get_contents("php://input");
// $sigHeader = $_SERVER['HTTP_STRIPE_SIGNATURE']; // Stripe signature from the headers
// $endpointSecret = 'whsec_zyHsSELNDRifaYvrtEHScDyQW0yMLZcK'; // Replace with your webhook signing secret
// $endpointSecret = $_ENV['STRIPE_ENDPOINT_SECRET'];


$payload = @file_get_contents('php://input');
$sigHeader = $_SERVER['HTTP_STRIPE_SIGNATURE']; // Stripe signature from the headers
$event = json_decode($payload, true);



// echo $event;

if ($event['type'] === 'checkout.session.completed') {
// if ($event['object']['object'] === 'checkout.session') {
	// echo "qq";
	// Nämä on checkout.session.complete requestistä
    $session = $event['data']['object'];
	$stripepayment_id=$event['id'];
	$stripepayment_intent=$event['data']['object']['payment_intent'] ;
    $purchaseId = $session['metadata']['purchase_id'] ; // Retrieve the purchase ID
    $customerId = $session['metadata']['customer_id']; // Retrieve customer id 
	$paymentstatus = $event['data']['object']['status'];
	$amounttotal = $event['data']['object']['amount_total'];
	$clientname=$event['data']['object']['customer_details']['name'];
	$clientemail=$event['data']['object']['customer_details']['email'];
	
	
	
	
	
	// Katsotaan tuleeko tiedot sitten eventistä checkout.session -event
	// $stripepayment_id=$event['object']['id'];
	// $stripepayment_intent=$event['object']['payment_intent'] ;
    // $purchaseId = $event['object']['metadata']['purchase_id'] ; // Retrieve the purchase ID
    // $customerId = $event['object']['metadata']['customer_id']; // Retrieve customer id 
	// $paymentstatus = $event['object']['status'];
	// $amounttotal = $event['object']['amount_total'];
	// $clientname=$event['object']['customer_details']['name'];
	// $clientemail=$event['object']['customer_details']['email'];
	
	
	
	
	$application ="Sorastus";
	
	// echo "stripepayment_id:" . $stripepayment_id ."\n";
	// echo "stripepayment_intent:" . $stripepayment_intent ."\n";
	// echo "application:" . $application ."\n";
	// echo "purchaseId:" . $purchaseId ."\n";
	// echo "customerId:" . $customerId ."\n";
	// echo "paymentstatus:" . $paymentstatus ."\n";
	// echo "amounttotal:" . $amounttotal ."\n";
	// echo "clientname:" . $clientname ."\n";
	// echo "clientemail:" . $clientemail ."\n";

    // Process your order here
    // echo "Payment completed for Purchase ID: $purchaseId";
	
	
	// Laitetaan tähän väliin kirjoitus tietokantaan
	$sql = "INSERT INTO stripepayments ";
	$sql .= "(
	stripepayment_id, 
	stripepayment_intent,
	application, 
	customerId, 
	purchaseId, 
	clientname,
	clientemail,
	amounttotal,
	paymentstatus
	) ";
	$sql .= "VALUES ";
	$sql .= "(
	'$stripepayment_id', 
	'$stripepayment_intent', 
	'$application', 
	'$customerId',
	'$purchaseId',
	'$clientname',
	'$clientemail', 
	'$amounttotal', 
	'$paymentstatus'
	)";
	
	// echo $sql;
	$mysqli->query($sql);
	
	
	
	// Jos $status on 'complete' tai 'paid' niin sitten voidaan antaa asiakkaalle lisää aikaa yksi kuukausi tästä hetkestä eteenpäin tai tietokannassa olevasta valid until päivästä eteenpäin
	
	// Ensin haetaan ko asiakkaan tämänhetkinen tilauksen päättymispäivä
	$UserID = $mysqli->escape_string($_GET["UserID"]);
	$sql = "SELECT subscriptionvaliduntil";
	$sql .= " FROM odemarkusers";
	$sql .= " WHERE id = '".$UserID."'";
	$result = $mysqli->query($sql);
	// echo $sql;
	$row = $result->fetch_row();
	// echo $row;
	$Tulos=$row[0];
	$date = date('Y-m-d',time());//date variable
	$time1=strtotime($Tulos);
	$time2=strtotime($date);

	// echo "Valid until:" . $Tulos ."\n";
	// echo "Today:" . $date ."\n";
	
	If ($time1>=$time2)
	{
		// Database validuntil is bigger
		$NewDate=$Tulos;
	}
	else
	{
		// Today is bigger
		$NewDate=$date;
	}
	$date = $NewDate;
	$newdate2 = strtotime ( '31 day' , strtotime ( $date ) ) ;
	$newdate2 = date ( 'Y-m-j' , $newdate2 );

	// echo "New validuntil:" . $newdate2;
						
	$newvaliduntil= newdate2; // date('Y-m-d h:i:s', strtotime("+31 days"));
	if ($status =='complete' || $status =='paid') 
	{
		$sql = "UPDATE odemarkusers 
				SET
				subscriptionvaliduntil='$newvaliduntil'
				WHERE 
				id =" . $customerId ." ";
			$mysqli->query($sql);
			// echo $sql;
	}
	
}
?>