<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	include('include/header.php');
	header('Content-Type: text/html; charset=utf-8');	
	date_default_timezone_set('Asia/Ho_Chi_Minh');	
	include('include/config_db.php');
	$conn = new mysqli($servername, $username, $password, $dbname);
	mysqli_set_charset($conn, 'UTF8');
	// Check connection
	if ($conn->connect_error) {
	  die("Connection failed: " . $conn->connect_error);
	}
	
	if(isset($_SESSION['username']) && $_SESSION['username'] && isset($_GET['name']) && isset($_GET['id'])){	
		$result = $conn->query("SELECT * FROM package WHERE id = '".$_GET['id']."' AND name = '".$_GET['name']."'");
		if($result->num_rows > 0){
			while($row = $result->fetch_assoc()){
				$result_st = $conn->query("SELECT paypal_client_id FROM settings WHERE id = 1");
				while($row2 = $result_st->fetch_assoc()){
?>
					<script src="https://www.paypal.com/sdk/js?client-id=<?=$row2['paypal_client_id'] ?>&currency=USD"></script>
				<?php }?>	
				<div class="container main py-3">
					<div class="row">
						<h2>Buy <strong><?=$row['name'] ?></strong> package, you can check <strong><?=number_format($row['credits']) ?></strong> emails</h2>
					</div>
					<div class="col-md-6">
						<table class="table table-hover table-striped">
							<thead>
								<tr><th> </th></tr>
							</thead>
							<tbody>
								<tr><td>Package name:</td> <td><?=$row['name'] ?></td></tr>	
								<tr><td>Number of emails to be verified (Credits):</td> <td><?=number_format($row['credits']) ?></td></tr>
								<tr><td>Price (USD):</td> <td><?='$'.number_format($row['price']) ?></td></tr>
							</tbody>
						</table>
					</div>
					<?php
					/** Tạo mã giao dịch cho user khi trang này được truy cập và update mã token vào tài khoản.**/
						$chars = "abcdefghijklmnopqrstuvwxyzJKLMNOPQRSTUVWXYZ0123456789-_ABCDEFGHIJKABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_ABCOPQRSTUVWXYZ0123456789-_";
						$token = substr(str_shuffle($chars),0, 120);
						$sql_update = "UPDATE users SET token_tranfer_money = '$token', token_tranfer_money_created = '".date('Y-m-d H:i:s')."'
							WHERE username='".$_SESSION['username']."'";
						if ($conn->query($sql_update) === TRUE) {
							//echo "<p style='text-align: center;'>Update User Success!</p>";							
						//header("Location: $site/users.php");
						} else {
						  echo "Error updating record: " . $conn->error;
						}
						//$current_time = strtotime(date('Y-m-d H:i:s'));
						$_SESSION['price'] = $row['price'];
						$sub_url = "/payment-completed.php?username=".$_SESSION['username']."&price=".$row['price']."&credits=".$row['credits']."&token=".$token;
					?>
					<div class="col-md-6">
						<div id="paypal-button-container"></div>
							<script>
								 paypal.Buttons({
									createOrder: function(data, actions) {
									  // This function sets up the details of the transaction, including the amount and line item details.
									  return actions.order.create({
										purchase_units: [{
										  amount: {
											value: '<?php echo $row['price']; ?>'
										  }
										}]
									  });
									},
									onApprove: function(data, actions) {
									  // This function captures the funds from the transaction.					 
									  return actions.order.capture().then(function(details) {
										// This function shows a transaction success message to your buyer.
										alert('Transaction completed by ' + details.payer.name.given_name);
										//window.open("http://check-emails.net/payment-completed/<?php echo $sub_url; ?>", "_blank", "height=400, width=550, status=yes, toolbar=no, menubar=no, location=no, addressbar=no, top=200, left=300");
										location.replace("<?php echo $site.$sub_url; ?>");
									  });
									}
								  }).render('#paypal-button-container');
								  //This function displays Smart Payment Buttons on your web page.
							</script>
					</div>				
				</div>
<?php
			}
		}
	}
	$conn->close();
?>



<?php
	include('include/footer.php'); 
?>