prepare("SELECT p.amount_paid, p.discount, p.payment_date, p.payment_method, p.student_id, s.full_name, s.phone, s.address FROM payments p JOIN students s ON p.student_id = s.id WHERE p.id = ?"); $stmt->execute([$payment_id]); $data = $stmt->fetch(); if (!$data) { ob_end_clean(); die(__('error_payment_not_found')); } $student_id = $data['student_id']; // 4. حساب إجمالي سعر الدورات المسجل بها الطالب $stmtPrice = $conn->prepare("SELECT SUM(c.price) as total_required FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = ?"); $stmtPrice->execute([$student_id]); $totalRequired = $stmtPrice->fetch()['total_required'] ?? 0; // 5. حساب إجمالي ما تم دفعه + الخصومات السابقة والحالية $stmtPaid = $conn->prepare("SELECT (SUM(amount_paid) + SUM(discount)) as total_processed FROM payments WHERE student_id = ?"); $stmtPaid->execute([$student_id]); $totalProcessed = $stmtPaid->fetch()['total_processed'] ?? 0; // 6. حساب المتبقي النهائي $remainingAmount = $totalRequired - $totalProcessed; if ($remainingAmount < 0) $remainingAmount = 0; // تصميم الـ HTML - نستخدم دالة __() داخل النصوص $html = '

' . __('institute_name') . '

' . __('receipt_voucher_no') . ': #' . $payment_id . ' | ' . __('date_label') . ': ' . date('Y-m-d', strtotime($data['payment_date'])) . '

' . __('student_name_label') . ':	' . htmlspecialchars($data['full_name']) . '
' . __('payment_method_label') . ':	' . __($data['payment_method']) . '	' . __('branch_label') . ':	' . __($data['address'] ?: 'default_city') . '

' . __('statement_label_table') . '	' . __('value_label') . ' (' . __('currency_symbol') . ')
' . __('current_paid_amount') . '	' . number_format($data['amount_paid'], 2) . '
' . __('granted_discount') . '	' . number_format($data['discount'], 2) . '
' . __('remaining_balance_on_student') . '	' . number_format($remainingAmount, 2) . '

'; $mpdf = new Mpdf([ 'mode' => 'utf-8', 'format' => 'A5-L', 'default_font' => 'dejavusans', 'margin_left' => 5, 'margin_right' => 5, 'margin_top' => 5, 'margin_bottom' => 5, ]); $mpdf->SetDirectionality($dir); $mpdf->WriteHTML($html); $pdfFileName = "Receipt_" . $payment_id . ".pdf"; $pdfPath = __DIR__ . "/../receipts/{$pdfFileName}"; // إنشاء المجلد إذا لم يكن موجوداً if (!file_exists(__DIR__ . "/../receipts/")) { mkdir(__DIR__ . "/../receipts/", 0777, true); } $mpdf->Output($pdfPath, \Mpdf\Output\Destination::FILE); $domain = (isset($_SERVER['HTTPS']) ? "https://" : "http://") . $_SERVER['HTTP_HOST']; $pdfUrl = "{$domain}/receipts/{$pdfFileName}"; // معالجة رقم الهاتف $rawPhone = preg_replace('/[^0-9]/', '', $data['phone']); $phone = ltrim($rawPhone, '0'); if (strlen($phone) == 9) $phone = "962" . $phone; // استخدام قالب رسالة واتساب مترجم $wa_message = str_replace( ['{name}', '{remaining}', '{url}'], [$data['full_name'], number_format($remainingAmount, 2), $pdfUrl], __('whatsapp_receipt_msg_template') ); $wa_link = "https://wa.me/{$phone}?text=" . urlencode($wa_message); // 7. تنظيف الذاكرة المؤقتة تماماً لضمان عدم وجود أي مخرجات نصية ob_end_clean(); // 8. التوجه الآن للواتساب بدون أخطاء header("Location: $wa_link"); exit;