prepare("
SELECT
p.amount_paid,
p.discount AS payment_discount,
p.payment_date,
p.payment_method,
s.full_name,
s.address,
s.id AS student_id
FROM payments p
JOIN students s ON p.student_id = s.id
WHERE p.id = ?
LIMIT 1
");
$stmt->execute([$payment_id]);
$payment = $stmt->fetch();
if (!$payment) {
die(__('error_payment_not_found'));
}
// حساب الإجمالي والمتبقي
$totalCoursePriceStmt = $conn->prepare("SELECT SUM(c.price) AS total FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = ?");
$totalCoursePriceStmt->execute([$payment['student_id']]);
$totalCoursesPrice = $totalCoursePriceStmt->fetch()['total'] ?? 0;
$totalPaidStmt = $conn->prepare("SELECT SUM(amount_paid) AS total_paid, SUM(discount) AS total_discount FROM payments WHERE student_id = ?");
$totalPaidStmt->execute([$payment['student_id']]);
$paidData = $totalPaidStmt->fetch();
$totalPaid = $paidData['total_paid'] ?? 0;
$totalDiscount = $paidData['total_discount'] ?? 0;
$totalRemaining = $totalCoursesPrice - ($totalPaid + $totalDiscount);
if ($totalRemaining < 0) $totalRemaining = 0;
$courses_stmt = $conn->prepare("SELECT c.course_name, c.price, e.attendance_type FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = ?");
$courses_stmt->execute([$payment['student_id']]);
$enrolled_courses = $courses_stmt->fetchAll();
// توليد QR
$protocol = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? "https" : "http";
$full_url = "$protocol://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
ob_start();
QRcode::png($full_url, null, QR_ECLEVEL_L, 4);
$imageString = base64_encode(ob_get_contents());
ob_end_clean();
?>
<?= __('receipt_voucher_no') ?> #<?= $payment_id ?>
