<?php
session_start();
if(file_exists('inc/config.php')): require_once('inc/config.php'); else: die('Required file doesn\'t exist.'); endif;

$files_inc = array('encryptions.class', 'functions.class', 'transaction.class', 'MPDF53/mpdf');
foreach($files_inc as $file_inc):
	if(file_exists(MYF.$file_inc.'.php')): require_once(MYF.$file_inc.'.php'); else: die('Required file doesn\'t exist.'); endif;
endforeach;

if($dbhost === '127.0.0.1'):
	$db = new mysqli('127.0.0.1', 'root', '', 'akinik');
else:
	$db = new mysqli('localhost', 'akinikpublicatio', '2-xu&*3qAh%C', 'akinikpublication');
endif;
if($db->connect_error):
	die('Database connection failed.');
endif;

$stmt = $mysqli->prepare("SELECT websitename FROM settings ORDER BY settingsid DESC LIMIT 1") or die('An error occurred. Please try after some time.');
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($websitename);
$stmt->fetch();
$stmt->close();

if(isset($_POST['generate_receipt']) && $_SERVER['REQUEST_METHOD'] === 'POST'):
	$txnid = filter_input(INPUT_POST, 'txnid', FILTER_SANITIZE_STRING);
	$txnid = strip_tags($fn->remaspace($fn->escape($txnid)));
	$email = filter_input(INPUT_POST, 'email', FILTER_SANITIZE_EMAIL);
	$email = strip_tags(urldecode($fn->remaspace($fn->escape($email))));

	$stmt = $db->prepare("SELECT name, email, phone, address, country, amount, currency, description, source, creation FROM transactions WHERE (email = ? AND txnid = ?) LIMIT 1") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('ss', $email, $txnid);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($name, $email, $phone, $address, $country, $amount, $currency, $description, $source, $creation);
	$stmt->fetch();
	$stmt->close();
	if($count_rows == 1):
		$stmt = $db->prepare("SELECT journal, journalemail, fromname, fromemail, replyname, replyemail, domain FROM journals WHERE journal = ? LIMIT 1") or die('An error occurred. Please try after some time.');
		$stmt->bind_param('s', $source);
		$stmt->execute();
		$stmt->store_result();
		$stmt->bind_result($journal, $journalemail, $fromname, $fromemail, $replyname, $replyemail, $domain);
		$stmt->fetch();
		$stmt->close();

		if(method_exists('transaction', 'receipt')):
			$tn->receipt($txnid, $name, $description, $amount, $currency, $creation, $journal, $journalemail, $domain);

			header('Content-Description: File Transfer');
			header('Content-Type: application/octet-stream');
			header('Content-Disposition: attachment; filename='.basename($txnid.'.pdf'));
			header('Content-Transfer-Encoding: binary');
			header('Expires: 0');
			header('Cache-Control: must-revalidate');
			header('Pragma: public');
			header('Content-Length: '.filesize($txnid.'.pdf'));
			ob_clean();
			flush();
			readfile($txnid.'.pdf');
			@unlink($txnid.'.pdf');
			exit();
		else:
			header('location:'.$baseurl);
			exit();
		endif;
	else:
		header('location:'.$baseurl);
		exit();
	endif;
else:
	header('location:'.$baseurl);
	exit();
endif;
?>