query("SELECT id, full_name FROM students ORDER BY full_name")->fetchAll(); function getTotalCoursePrice($conn, $student_id) { $stmt = $conn->prepare(" SELECT SUM(c.price) FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = ? "); $stmt->execute([$student_id]); return $stmt->fetchColumn() ?? 0; } function getTotalPayments($conn, $student_id) { $stmt = $conn->prepare("SELECT SUM(amount_paid) FROM payments WHERE student_id = ?"); $stmt->execute([$student_id]); return $stmt->fetchColumn() ?? 0; } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $student_id = $_POST['student_id'] ?? 0; $amount = $_POST['amount_paid'] ?? 0; $payment_date = $_POST['payment_date'] ?? date('Y-m-d'); $notes = $_POST['notes'] ?? ''; if ($student_id && $amount > 0) { $stmt = $conn->prepare("INSERT INTO payments (student_id, amount_paid, payment_date, notes) VALUES (?, ?, ?, ?)"); $stmt->execute([$student_id, $amount, $payment_date, $notes]); header("Location: add.php?success=1&student_id=$student_id"); exit; } else { $error = "يرجى اختيار الطالب والمبلغ بشكل صحيح"; } } ?>

📥 إضافة دفعة مالية للطالب

✅ تم إضافة الدفعة بنجاح
🔙 الرجوع إلى صفحة الدفعات 🔙 الرجوع إلى التقرير