File Manager

Editing:payment-verify.php

<?php define('PAGE_TITLE', 'Verify Payment'); require_once 'includes/header.php';
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$payment = $conn->query("SELECT p.*, b.booking_id as booking_no, b.id as booking_db_id, b.total_price, b.advance_amount, b.balance_amount, b.status as booking_status, cu.name as cname, cu.email as cemail, cu.phone as cphone FROM payments p JOIN bookings b ON p.booking_id=b.id JOIN customers cu ON p.customer_id=cu.id WHERE p.id=$id")->fetch_assoc();
if (!$payment) { echo '<div class="alert alert-danger">Payment not found</div>'; require_once 'includes/footer.php'; exit; }
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['verify_action'])) {
    $action = $_POST['verify_action'];
    if ($action == 'verify') {
        $conn->query("UPDATE payments SET status='verified', verified_by={$_SESSION['admin_id']}, verified_at=NOW() WHERE id=$id");
        $advance = $payment['advance_amount'] + $payment['amount'];
        $balance = $payment['total_price'] - $advance;
        $pstat = $balance <= 0 ? 'full_paid' : 'advance_paid';
        $conn->query("UPDATE bookings SET advance_amount=$advance, balance_amount=$balance, payment_status='$pstat', status='confirmed' WHERE id={$payment['booking_db_id']}");
        addNotification('Payment Verified', "Payment of {$payment['amount']} verified for booking {$payment['booking_no']}", SITE_URL."admin/booking-details.php?id={$payment['booking_db_id']}", 'customer', $payment['customer_id']);
        $msg = '<div class="alert alert-success">Payment verified! Booking confirmed.</div>';
    } elseif ($action == 'reject') {
        $conn->query("UPDATE payments SET status='rejected', verified_by={$_SESSION['admin_id']}, verified_at=NOW() WHERE id=$id");
        $msg = '<div class="alert alert-warning">Payment rejected.</div>';
    }
}
?>
<div class="d-flex justify-content-between align-items-center mb-4">
  <h4 class="fw-bold text-navy mb-0"><i class="bi bi-shield-check text-warning me-2"></i>Verify Payment #<?= $id ?></h4>
  <a href="payments.php" class="btn btn-outline-premium btn-sm"><i class="bi bi-arrow-left me-1"></i>Back</a>
</div>
<?= $msg ?? '' ?>
<div class="row g-4">
  <div class="col-lg-6">
    <div class="premium-card p-4">
      <h5 class="fw-bold mb-3">Payment Details</h5>
      <div class="d-flex justify-content-between mb-2"><span>Booking:</span><strong><?= $payment['booking_no'] ?></strong></div>
      <div class="d-flex justify-content-between mb-2"><span>Amount:</span><strong class="text-warning"><?= formatPrice($payment['amount']) ?></strong></div>
      <div class="d-flex justify-content-between mb-2"><span>Type:</span><span class="badge bg-info"><?= $payment['payment_type'] ?></span></div>
      <div class="d-flex justify-content-between mb-2"><span>Method:</span><?= $payment['payment_method'] ?: '-' ?></div>
      <div class="d-flex justify-content-between mb-2"><span>Transaction:</span><?= $payment['transaction_id'] ?: '-' ?></div>
      <div class="d-flex justify-content-between mb-2"><span>Status:</span><?= getStatusBadge($payment['status']) ?></div>
      <div class="d-flex justify-content-between mb-2"><span>Notes:</span><?= $payment['notes'] ?: '-' ?></div>
      <?php if ($payment['receipt_image']): ?>
      <div class="mt-3"><label class="fw-bold">Receipt:</label><br><img src="<?= SITE_URL.'uploads/payments/'.$payment['receipt_image'] ?>" style="max-width:100%;border-radius:8px;margin-top:5px;"></div>
      <?php endif; ?>
    </div>
  </div>
  <div class="col-lg-6">
    <div class="premium-card p-4 mb-4">
      <h5 class="fw-bold mb-3">Customer Info</h5>
      <p class="mb-1"><strong>Name:</strong> <?= htmlspecialchars($payment['cname']) ?></p>
      <p class="mb-1"><strong>Email:</strong> <?= $payment['cemail'] ?></p>
      <p class="mb-0"><strong>Phone:</strong> <?= $payment['cphone'] ?></p>
    </div>
    <?php if ($payment['status'] == 'pending'): ?>
    <div class="premium-card p-4">
      <h5 class="fw-bold mb-3">Actions</h5>
      <form method="post">
        <button type="submit" name="verify_action" value="verify" class="btn btn-success w-100 mb-2" onclick="return confirm('Verify this payment?')"><i class="bi bi-check-circle me-2"></i>Verify Payment</button>
        <button type="submit" name="verify_action" value="reject" class="btn btn-danger w-100" onclick="return confirm('Reject this payment?')"><i class="bi bi-x-circle me-2"></i>Reject Payment</button>
      </form>
    </div>
    <?php else: ?>
    <div class="alert alert-info">This payment has already been <?= $payment['status'] ?>.</div>
    <?php endif; ?>
  </div>
</div>
<?php require_once 'includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:payment-verify.php