prepare("SELECT * FROM students WHERE id = ?");
$student_stmt->execute([$student_id]);
$student = $student_stmt->fetch(PDO::FETCH_ASSOC);
if (!$student) {
die(__('error_student_not_found'));
}
// حساب السعر الكلي للكورسات
$total_price_stmt = $conn->prepare("
SELECT SUM(c.price) FROM enrollments e
JOIN courses c ON e.course_id = c.id
WHERE e.student_id = ?
");
$total_price_stmt->execute([$student_id]);
$total_price = $total_price_stmt->fetchColumn() ?? 0;
// حساب المبلغ المدفوع والخصومات السابقة
$total_paid_stmt = $conn->prepare("SELECT SUM(amount_paid + discount) FROM payments WHERE student_id = ?");
$total_paid_stmt->execute([$student_id]);
$total_paid = $total_paid_stmt->fetchColumn() ?? 0;
$remaining = $total_price - $total_paid;
$error = '';
$success = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$amount_paid = floatval($_POST['amount_paid']);
$discount = floatval($_POST['discount'] ?? 0);
$payment_date = $_POST['payment_date'];
$payment_method = $_POST['payment_method'];
if ($amount_paid < 0 || $discount < 0) {
$error = __('error_invalid_amounts');
} elseif (($amount_paid + $discount) > $remaining + 0.01) {
$error = __('error_payment_exceeds_remaining');
} else {
$stmt = $conn->prepare("INSERT INTO payments (student_id, amount_paid, discount, payment_date, payment_method) VALUES (?, ?, ?, ?, ?)");
$stmt->execute([$student_id, $amount_paid, $discount, $payment_date, $payment_method]);
$payment_id = $conn->lastInsertId();
$success = __('success_payment_recorded');
$total_paid += $amount_paid + $discount;
$remaining -= $amount_paid + $discount;
// تسجيل عمولة المسوق
if (!empty($student['marketing_source'])) {
$marketer_stmt = $conn->prepare("SELECT id, commission_percent FROM marketers WHERE name = ?");
$marketer_stmt->execute([$student['marketing_source']]);
$marketer = $marketer_stmt->fetch(PDO::FETCH_ASSOC);
if ($marketer) {
$check_commission = $conn->prepare("SELECT COUNT(*) FROM marketer_commissions WHERE student_id = ?");
$check_commission->execute([$student_id]);
$already_counted = $check_commission->fetchColumn();
if (!$already_counted) {
$commission_amount = $marketer['commission_percent'] ?? 0;
$conn->prepare("INSERT INTO marketer_commissions (marketer_id, student_id, payment_id, commission_amount) VALUES (?, ?, ?, ?)")
->execute([$marketer['id'], $student_id, $payment_id, $commission_amount]);
}
}
}
}
}
?>