prepare("SELECT full_name, phone, address FROM students WHERE id = ?");
$stmt->execute([$student_id]);
$student = $stmt->fetch();
if (!$student) {
die(__('error_student_not_found'));
}
// جلب المدفوعات
$stmt = $conn->prepare("SELECT amount_paid, discount, payment_date, payment_method FROM payments WHERE student_id = ? ORDER BY payment_date DESC");
$stmt->execute([$student_id]);
$payments = $stmt->fetchAll();
// حساب الإجماليات للعرض في السند
$total_paid = 0;
foreach($payments as $p) { $total_paid += $p['amount_paid']; }
ob_start();
?>
set('isRemoteEnabled', true);
$options->set('defaultFont', 'dejavu sans');
$dompdf = new Dompdf($options);
$dompdf->loadHtml($html);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();
// حفظ الملف
$pdfFileName = "Statement_{$student_id}_" . time() . ".pdf";
$pdfPath = __DIR__ . "/../receipts/{$pdfFileName}";
file_put_contents($pdfPath, $dompdf->output());
// إعداد الرابط
$domain = (isset($_SERVER['HTTPS']) ? "https://" : "http://") . $_SERVER['HTTP_HOST'];
$pdfUrl = "{$domain}/receipts/{$pdfFileName}";
// تجهيز رسالة الواتساب
$rawPhone = preg_replace('/[^0-9]/', '', $student['phone']);
$phone = ltrim($rawPhone, '0');
if (strlen($phone) == 9) $phone = "962" . $phone;
// استخدام القوالب المترجمة لرسالة الواتساب
$wa_message = str_replace(
['{name}', '{url}'],
[$student['full_name'], $pdfUrl],
__('whatsapp_statement_msg_template')
);
$wa_link = "https://wa.me/{$phone}?text={$wa_message}";
header("Location: $wa_link");
exit;