File upload failed.'; } if (!$msg) { $stmt = $conn->prepare("INSERT INTO payments (booking_id, customer_id, amount, payment_type, payment_method, transaction_id, receipt_image, notes) VALUES (?, ?, ?, 'advance', ?, ?, ?, ?)"); $stmt->bind_param("iissss", $booking_id, $_SESSION['customer_id'], $amount, $method, $transaction_id, $receipt, $notes); if ($stmt->execute()) { $stmt = $conn->prepare("UPDATE bookings SET advance_amount = advance_amount + ?, balance_amount = total_price - advance_amount, payment_status = 'advance_paid', status = 'waiting_payment' WHERE id = ?"); $stmt->bind_param("di", $amount, $booking_id); $stmt->execute(); addNotification('Payment Submitted', 'Payment of ' . formatPrice($amount) . ' received for booking ' . $booking['booking_id'], SITE_URL . 'admin/payments.php', 'admin'); $msg = '
Bank: = getSetting('bank_name') ?>
Account Name: = getSetting('bank_account_name') ?>
Account No: = getSetting('bank_account_no') ?>
Branch: = getSetting('bank_branch') ?>
After making the payment, upload the receipt or provide transaction details. We will verify and update your booking status.