<?php
require_once 'config.php';
requireLogin();
date_default_timezone_set('Asia/Kolkata');

// SendGrid API key (same as used across the platform)
define('SHOP_SENDGRID_API_KEY', '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');
define('SHOP_SENDER_EMAIL',    'registration@relevantreflex.com');
define('SHOP_SENDER_NAME',     'Relevant Reflex');
define('MEMBER_SITE_URL',      'https://relevantreflex.com');

// Format numeric ID as RR member ID (e.g., 1 → RR0000001)
function formatMemberId($id) {
    return 'RR' . str_pad((int)$id, 7, '0', STR_PAD_LEFT);
}

$page_title = 'Panel Management';
$page_description = 'Manage registered panel members';

// =========================================================
// HANDLE MEMBER DELETION
// =========================================================
if (isset($_POST['delete_member']) && isLoggedIn()) {
    $member_id = intval($_POST['member_id'] ?? 0);
    if ($member_id > 0) {
        try {
            $panelPdo = getPanelDBConnection();
            $panelPdo->beginTransaction();

            $panelPdo->prepare("DELETE FROM point_transactions WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM user_points WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM redemption_requests WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM support_tickets WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM support_messages WHERE sender_type = 'user' AND sender_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM user_profiler WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM profiler_completion WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM mobile_verifications WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM email_verifications WHERE user_id = ?")->execute([$member_id]);
            $panelPdo->prepare("DELETE FROM users WHERE id = ?")->execute([$member_id]);

            $panelPdo->commit();

            logActivity($_SESSION['admin_id'], 'delete_member', "Deleted member #$member_id", 'member', $member_id);
            $success_message = 'Member deleted successfully!';
        } catch (Exception $e) {
            $panelPdo->rollBack();
            error_log("Delete member error: " . $e->getMessage());
            $error_message = 'Error deleting member. Please try again.';
        }
    }
}

// =========================================================
// HANDLE BULK VERIFICATION EMAIL SEND — batched AJAX endpoint
// =========================================================
if (isset($_POST['send_verification_emails']) && isLoggedIn()) {
    @set_time_limit(120);
    ignore_user_abort(true);
    header('Content-Type: application/json');

    $from_date = trim($_POST['from_date'] ?? '');
    $to_date   = trim($_POST['to_date']   ?? '');
    $offset    = max(0, intval($_POST['offset'] ?? 0));
    $batch     = 10; // emails per request

    if (empty($from_date) || empty($to_date)) {
        echo json_encode(['success' => false, 'message' => 'Please select both From and To dates.']);
        exit;
    }

    try {
        $panelPdo = getPanelDBConnection();

        // Total count (always fresh so JS knows the full picture)
        $cntStmt = $panelPdo->prepare("
            SELECT COUNT(*) FROM users
            WHERE email_verified = 0
              AND DATE(created_at) >= ? AND DATE(created_at) <= ?
        ");
        $cntStmt->execute([$from_date, $to_date]);
        $total = (int)$cntStmt->fetchColumn();

        if ($total === 0) {
            echo json_encode(['success' => true, 'done' => true, 'sent' => 0,
                'failed' => 0, 'total' => 0,
                'message' => 'No unverified members found in the selected date range.']);
            exit;
        }

        // Fetch this batch
        $stmt = $panelPdo->prepare("
            SELECT id, email FROM users
            WHERE email_verified = 0
              AND DATE(created_at) >= ? AND DATE(created_at) <= ?
            ORDER BY created_at ASC
            LIMIT {$batch} OFFSET {$offset}
        ");
        $stmt->execute([$from_date, $to_date]);
        $batchUsers = $stmt->fetchAll();

        $sentCount   = 0;
        $failedCount = 0;
        $firstError  = null;

        foreach ($batchUsers as $user) {
            $panelPdo->prepare("DELETE FROM email_verifications WHERE user_id = ?")
                     ->execute([$user['id']]);

            $token     = bin2hex(random_bytes(32));
            $expiresAt = date('Y-m-d H:i:s', strtotime('+48 hours'));
            $panelPdo->prepare("
                INSERT INTO email_verifications (user_id, token, expires_at, created_at)
                VALUES (?, ?, ?, NOW())
            ")->execute([$user['id'], $token, $expiresAt]);

            $verifyUrl = MEMBER_SITE_URL . '/verify.php?token=' . $token;
            $subject   = 'Verify Your Email - Relevant Reflex';
            $htmlBody  = '<!DOCTYPE html><html><head><meta charset="UTF-8"></head>
<body style="font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:600px;margin:0 auto;padding:20px;">
<div style="background:#f9f9f9;padding:30px;border-radius:10px;margin:20px 0;">
  <div style="background:#28a745;color:white;padding:20px;text-align:center;border-radius:10px 10px 0 0;margin:-30px -30px 30px -30px;">
    <h1 style="margin:0;">Relevant Reflex</h1>
    <p style="margin:4px 0 0;">Welcome to India\'s Trusted Survey Platform</p>
  </div>
  <h2>Please Verify Your Email</h2>
  <p>To activate your account and start earning through paid surveys, please verify your email address:</p>
  <div style="text-align:center;margin:28px 0;">
    <a href="' . $verifyUrl . '" style="display:inline-block;background:#f39c12;color:white;padding:15px 30px;text-decoration:none;border-radius:25px;font-weight:bold;">Verify My Email Address</a>
  </div>
  <div style="background:#fff3cd;border:1px solid #ffeaa7;padding:15px;border-radius:5px;margin:20px 0;">
    <p style="margin:0;"><strong>Note:</strong> This link expires in 48 hours.</p>
  </div>
  <p>If the button doesn\'t work: <a href="' . $verifyUrl . '">' . $verifyUrl . '</a></p>
  <p>Best regards,<br>The Relevant Reflex Team</p>
</div></body></html>';

            $payload = [
                'personalizations' => [['to' => [['email' => $user['email']]], 'subject' => $subject]],
                'from'    => ['email' => SHOP_SENDER_EMAIL, 'name' => SHOP_SENDER_NAME],
                'content' => [['type' => 'text/html', 'value' => $htmlBody]]
            ];

            // Helper: send one email, with one retry on 429 rate-limit
            $sendOnce = function() use ($payload) {
                $ch = curl_init('https://api.sendgrid.com/v3/mail/send');
                curl_setopt_array($ch, [
                    CURLOPT_POST           => true,
                    CURLOPT_POSTFIELDS     => json_encode($payload),
                    CURLOPT_RETURNTRANSFER => true,
                    CURLOPT_HTTPHEADER     => [
                        'Authorization: Bearer ' . SHOP_SENDGRID_API_KEY,
                        'Content-Type: application/json'
                    ],
                    CURLOPT_TIMEOUT        => 20,
                    CURLOPT_SSL_VERIFYPEER => true
                ]);
                $response   = curl_exec($ch);
                $statusCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
                curl_close($ch);
                return [$statusCode, $response];
            };

            [$statusCode, $response] = $sendOnce();

            // If rate-limited (429), wait 2 seconds and retry once
            if ($statusCode === 429) {
                sleep(2);
                [$statusCode, $response] = $sendOnce();
            }

            if ($statusCode === 202) {
                $sentCount++;
            } else {
                $failedCount++;
                $rawError = "HTTP $statusCode | Key(last6):" . substr(SHOP_SENDGRID_API_KEY, -6) . " | Body: $response";
                error_log("SendGrid failed for {$user['email']}: $rawError");
                if ($firstError === null) {
                    $decoded = json_decode($response, true);
                    $msg = $decoded['errors'][0]['message'] ?? $decoded['message'] ?? $response;
                    $firstError = "HTTP $statusCode: $msg (raw: " . substr($response, 0, 200) . ")";
                }
            }

            // 300ms pause between each email to stay within SendGrid rate limits
            usleep(300000);
        }

        $newOffset = $offset + count($batchUsers);
        $done      = ($newOffset >= $total);

        if ($done) {
            logActivity($_SESSION['admin_id'], 'bulk_verification_email',
                "Bulk verification complete. Range: $from_date to $to_date. Total: $total");
        }

        echo json_encode([
            'success'    => true,
            'done'       => $done,
            'sent'       => $sentCount,
            'failed'     => $failedCount,
            'processed'  => $newOffset,
            'total'      => $total,
            'firstError' => $firstError,
        ]);
    } catch (Exception $e) {
        error_log("Bulk verification email error: " . $e->getMessage());
        echo json_encode(['success' => false, 'message' => 'Server error: ' . $e->getMessage()]);
    }
    exit;
}

// =========================================================
// HANDLE SINGLE MEMBER VERIFICATION EMAIL RESEND — AJAX
// =========================================================
if (isset($_POST['resend_verification']) && isLoggedIn()) {
    header('Content-Type: application/json');
    $member_id = intval($_POST['member_id'] ?? 0);
    if ($member_id <= 0) {
        echo json_encode(['success' => false, 'message' => 'Invalid member ID.']);
        exit;
    }
    try {
        $panelPdo = getPanelDBConnection();

        $stmt = $panelPdo->prepare("SELECT id, email, email_verified FROM users WHERE id = ?");
        $stmt->execute([$member_id]);
        $user = $stmt->fetch();

        if (!$user) {
            echo json_encode(['success' => false, 'message' => 'Member not found.']);
            exit;
        }
        if ($user['email_verified']) {
            echo json_encode(['success' => false, 'message' => 'This member is already verified.']);
            exit;
        }

        // Fresh token
        $panelPdo->prepare("DELETE FROM email_verifications WHERE user_id = ?")->execute([$member_id]);
        $token     = bin2hex(random_bytes(32));
        $expiresAt = date('Y-m-d H:i:s', strtotime('+48 hours'));
        $panelPdo->prepare("
            INSERT INTO email_verifications (user_id, token, expires_at, created_at)
            VALUES (?, ?, ?, NOW())
        ")->execute([$member_id, $token, $expiresAt]);

        $verifyUrl = MEMBER_SITE_URL . '/verify.php?token=' . $token;
        $subject   = 'Verify Your Email - Relevant Reflex';
        $htmlBody  = '<!DOCTYPE html><html><head><meta charset="UTF-8"></head>
<body style="font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:600px;margin:0 auto;padding:20px;">
<div style="background:#f9f9f9;padding:30px;border-radius:10px;margin:20px 0;">
  <div style="background:#28a745;color:white;padding:20px;text-align:center;border-radius:10px 10px 0 0;margin:-30px -30px 30px -30px;">
    <h1 style="margin:0;">Relevant Reflex</h1>
    <p style="margin:4px 0 0;">Welcome to India\'s Trusted Survey Platform</p>
  </div>
  <h2>Please Verify Your Email</h2>
  <p>To activate your account and start earning through paid surveys, please verify your email address:</p>
  <div style="text-align:center;margin:28px 0;">
    <a href="' . $verifyUrl . '" style="display:inline-block;background:#f39c12;color:white;padding:15px 30px;text-decoration:none;border-radius:25px;font-weight:bold;">Verify My Email Address</a>
  </div>
  <div style="background:#fff3cd;border:1px solid #ffeaa7;padding:15px;border-radius:5px;margin:20px 0;">
    <p style="margin:0;"><strong>Note:</strong> This link expires in 48 hours.</p>
  </div>
  <p>If the button doesn\'t work: <a href="' . $verifyUrl . '">' . $verifyUrl . '</a></p>
  <p>Best regards,<br>The Relevant Reflex Team</p>
</div></body></html>';

        $payload = [
            'personalizations' => [['to' => [['email' => $user['email']]], 'subject' => $subject]],
            'from'    => ['email' => SHOP_SENDER_EMAIL, 'name' => SHOP_SENDER_NAME],
            'content' => [['type' => 'text/html', 'value' => $htmlBody]]
        ];

        $ch = curl_init('https://api.sendgrid.com/v3/mail/send');
        curl_setopt_array($ch, [
            CURLOPT_POST           => true,
            CURLOPT_POSTFIELDS     => json_encode($payload),
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_HTTPHEADER     => [
                'Authorization: Bearer ' . SHOP_SENDGRID_API_KEY,
                'Content-Type: application/json'
            ],
            CURLOPT_TIMEOUT        => 20,
            CURLOPT_SSL_VERIFYPEER => true
        ]);
        $response   = curl_exec($ch);
        $statusCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        curl_close($ch);

        if ($statusCode === 202) {
            logActivity($_SESSION['admin_id'], 'resend_verification', "Resent verification email to member #$member_id ({$user['email']})");
            echo json_encode(['success' => true, 'message' => 'Verification email sent to ' . $user['email']]);
        } else {
            $decoded = json_decode($response, true);
            $msg = $decoded['errors'][0]['message'] ?? $decoded['message'] ?? $response;
            error_log("Resend verification failed for {$user['email']}: HTTP $statusCode — $response");
            echo json_encode(['success' => false, 'message' => "Failed (HTTP $statusCode): $msg — (raw: " . substr($response, 0, 200) . ")"]);
        }
    } catch (Exception $e) {
        error_log("Resend verification error: " . $e->getMessage());
        echo json_encode(['success' => false, 'message' => 'Server error: ' . $e->getMessage()]);
    }
    exit;
}


try {
    $panelPdo = getPanelDBConnection();
    $stmt = $panelPdo->query("
        SELECT 
            u.*,
            up.points as current_points,
            up.total_earned,
            up.total_redeemed,
            mv.mobile_number,
            mv.is_verified as mobile_verified,
            ev.token as verify_token
        FROM users u
        LEFT JOIN user_points up ON u.id = up.user_id
        LEFT JOIN mobile_verifications mv ON u.id = mv.user_id
        LEFT JOIN email_verifications ev ON ev.id = (
            SELECT id FROM email_verifications WHERE user_id = u.id ORDER BY created_at DESC LIMIT 1
        )
        ORDER BY u.created_at DESC
    ");
    $members = $stmt->fetchAll();
} catch (Exception $e) {
    $members = [];
    error_log("Fetch members error: " . $e->getMessage());
}

include 'includes/header.php';
?>

<style>
/* Same enhanced styling as members.php */
.panel-page-container {
    padding: 24px;
    max-width: 1400px;
    margin: 0 auto;
}

.panel-stats-cards {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 20px;
    margin-bottom: 30px;
}

.stats-card {
    background: #059669;
    border-radius: 12px;
    padding: 24px;
    color: white;
    box-shadow: 0 4px 12px rgba(0,0,0,0.1);
    transition: transform 0.2s;
}

.stats-card:hover {
    transform: translateY(-4px);
    box-shadow: 0 6px 20px rgba(0,0,0,0.15);
}

.stats-card:nth-child(2) { background: linear-gradient(135deg, #059669 0%, #047857 100%); }
.stats-card:nth-child(3) { background: linear-gradient(135deg, #059669 0%, #047857 100%); }
.stats-card:nth-child(4) { background: linear-gradient(135deg, #f59e0b 0%, #d97706 100%); }
.stats-card:nth-child(5) { background: linear-gradient(135deg, #10b981 0%, #047857 100%); }
.stats-card:nth-child(6) { background: linear-gradient(135deg, #06b6d4 0%, #0891b2 100%); }

.stats-card-number { font-size: 32px; font-weight: 700; margin-bottom: 8px; }
.stats-card-label  { font-size: 14px; opacity: 0.9; font-weight: 500; }

.table-header-section {
    background: white;
    border-radius: 12px;
    padding: 20px;
    margin-bottom: 24px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
}

.table-controls {
    display: flex;
    gap: 16px;
    flex-wrap: wrap;
    align-items: center;
}

.search-box { flex: 1; min-width: 250px; }
.search-box input {
    width: 100%;
    padding: 10px 16px 10px 40px;
    border: 2px solid #e5e7eb;
    border-radius: 8px;
    font-size: 14px;
    transition: all 0.2s;
    background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='20' height='20' viewBox='0 0 24 24' fill='none' stroke='%236b7280' stroke-width='2'%3E%3Ccircle cx='11' cy='11' r='8'/%3E%3Cpath d='m21 21-4.35-4.35'/%3E%3C/svg%3E");
    background-repeat: no-repeat;
    background-position: 12px center;
}
.search-box input:focus {
    outline: none;
    border-color: #059669;
    box-shadow: 0 0 0 3px rgba(5,150,105,0.1);
}

.filter-group { display: flex; gap: 12px; }
.filter-select {
    padding: 10px 36px 10px 12px;
    border: 2px solid #e5e7eb;
    border-radius: 8px;
    font-size: 14px;
    background: white;
    cursor: pointer;
    transition: all 0.2s;
    appearance: none;
    background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='16' height='16' viewBox='0 0 24 24' fill='none' stroke='%236b7280' stroke-width='2'%3E%3Cpath d='m6 9 6 6 6-6'/%3E%3C/svg%3E");
    background-repeat: no-repeat;
    background-position: right 12px center;
}
.filter-select:focus { outline: none; border-color: #059669; }

.panel-table-container {
    background: white;
    border-radius: 12px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
    overflow-x: auto;
}

.panel-table {
    width: 100%;
    border-collapse: separate;
    border-spacing: 0;
}
.panel-table thead { background: linear-gradient(to right, #f9fafb, #f3f4f6); }
.panel-table th {
    padding: 10px 8px;
    text-align: left;
    font-size: 11px;
    font-weight: 700;
    color: #374151;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    border-bottom: 2px solid #e5e7eb;
    white-space: nowrap;
}
.panel-table td {
    padding: 10px 8px;
    font-size: 13px;
    color: #1f2937;
    border-bottom: 1px solid #f3f4f6;
    vertical-align: middle;
}
.panel-table tbody tr { transition: background 0.2s; }
.panel-table tbody tr:hover { background: #f9fafb; }

.member-email-cell { max-width: 180px; }
.member-email { font-weight: 600; color: #111827; display: block; margin-bottom: 2px; font-size: 12px; }
.verified-badge { display: inline-flex; align-items: center; gap: 3px; font-size: 10px; color: #059669; font-weight: 600; }
.member-dob-cell { min-width: 90px; }
.dob-primary { font-weight: 500; color: #111827; font-size: 12px; }
.dob-age { font-size: 10px; color: #6b7280; margin-top: 1px; }

.points-badge {
    display: inline-block;
    padding: 4px 8px;
    background: linear-gradient(135deg, #059669, #047857);
    color: white;
    border-radius: 5px;
    font-weight: 700;
    font-size: 12px;
}

.status-badge {
    display: inline-block;
    padding: 3px 8px;
    border-radius: 10px;
    font-size: 10px;
    font-weight: 700;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}
.status-badge.status-active   { background: #d1fae5; color: #065f46; }
.status-badge.status-inactive  { background: #fee2e2; color: #991b1b; }
.status-badge.status-suspended { background: #fef3c7; color: #92400e; }

.joined-cell { min-width: 85px; }
.joined-date { font-weight: 500; color: #111827; font-size: 12px; }
.joined-time { font-size: 10px; color: #6b7280; margin-top: 1px; }

.action-buttons {
    display: flex;
    gap: 4px;
    justify-content: center;
    align-items: center;
}

.btn-action {
    color: #059669;
    text-decoration: none;
    font-size: 16px;
    cursor: pointer;
    border: none;
    background: none;
    padding: 3px;
    transition: all 0.2s;
    display: inline-flex;
    align-items: center;
}
.btn-action:hover { transform: scale(1.2); }
.btn-view   { color: #059669; }
.btn-edit   { color: #059669; }
.btn-resend { color: #2563eb; }
.btn-delete { color: #dc2626; }
.btn-copy-wa { color: #059669; }
.btn-view:hover   { color: #047857; }
.btn-edit:hover   { color: #047857; }
.btn-resend:hover { color: #1d4ed8; }
.btn-delete:hover { color: #991b1b; }
.btn-copy-wa:hover { color: #047857; }

.empty-state { text-align: center; padding: 60px 20px; color: #9ca3af; }
.empty-state-icon { font-size: 48px; margin-bottom: 16px; }
.empty-state-text { font-size: 16px; font-weight: 500; }

/* Modal Styles */
.modal {
    display: none;
    position: fixed;
    top: 0; left: 0;
    width: 100%; height: 100%;
    background: rgba(0,0,0,0.5);
    z-index: 9999;
    align-items: center;
    justify-content: center;
}
.modal.active { display: flex; }
.modal-content {
    background: white;
    border-radius: 12px;
    padding: 24px;
    max-width: 450px;
    width: 90%;
    box-shadow: 0 20px 60px rgba(0,0,0,0.3);
}
.modal-header { display: flex; align-items: center; gap: 12px; margin-bottom: 16px; }
.modal-icon {
    width: 48px; height: 48px;
    background: #fee2e2; color: #dc2626;
    border-radius: 50%;
    display: flex; align-items: center; justify-content: center;
    font-size: 24px;
}
.modal-icon-blue { background: #dbeafe; color: #2563eb; }
.modal-title { font-size: 20px; font-weight: 700; color: #111827; }
.modal-body  { margin-bottom: 24px; color: #6b7280; line-height: 1.6; }
.modal-actions { display: flex; gap: 12px; justify-content: flex-end; }
.btn-modal {
    padding: 10px 20px;
    border-radius: 8px; border: none;
    font-size: 14px; font-weight: 600;
    cursor: pointer; transition: all 0.2s;
}
.btn-cancel          { background: #f3f4f6; color: #374151; }
.btn-cancel:hover    { background: #e5e7eb; }
.btn-confirm-delete  { background: #dc2626; color: white; }
.btn-confirm-delete:hover { background: #b91c1c; }
.btn-confirm-send    { background: #2563eb; color: white; }
.btn-confirm-send:hover   { background: #1d4ed8; }

/* Bulk email section */
.bulk-email-section {
    background: white;
    border-radius: 12px;
    padding: 20px 24px;
    margin-bottom: 24px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
    border-left: 4px solid #2563eb;
}
.bulk-email-section h3 {
    font-size: 15px;
    font-weight: 700;
    color: #1e40af;
    margin: 0 0 14px 0;
}
.bulk-email-controls {
    display: flex;
    gap: 14px;
    flex-wrap: wrap;
    align-items: flex-end;
}
.bulk-email-controls .field-group {
    display: flex;
    flex-direction: column;
    gap: 5px;
}
.bulk-email-controls label {
    font-size: 12px;
    font-weight: 600;
    color: #374151;
    text-transform: uppercase;
    letter-spacing: 0.4px;
}
.bulk-email-controls input[type="date"] {
    padding: 9px 12px;
    border: 2px solid #e5e7eb;
    border-radius: 8px;
    font-size: 14px;
    transition: border-color 0.2s;
    min-width: 160px;
}
.bulk-email-controls input[type="date"]:focus {
    outline: none;
    border-color: #2563eb;
}
.btn-send-verification {
    padding: 10px 20px;
    background: #2563eb;
    color: white;
    border: none;
    border-radius: 8px;
    font-size: 14px;
    font-weight: 600;
    cursor: pointer;
    transition: background 0.2s;
    white-space: nowrap;
}
.btn-send-verification:hover { background: #1d4ed8; }

/* Notifications */
.notification {
    position: fixed;
    top: 20px; right: 20px;
    padding: 16px 24px;
    border-radius: 8px;
    box-shadow: 0 4px 12px rgba(0,0,0,0.15);
    z-index: 10000;
    animation: slideIn 0.3s ease;
    max-width: 400px;
}
@keyframes slideIn {
    from { transform: translateX(400px); opacity: 0; }
    to   { transform: translateX(0); opacity: 1; }
}
.notification-success { background: #d1fae5; color: #065f46; border-left: 4px solid #059669; }
.notification-error   { background: #fee2e2; color: #991b1b; border-left: 4px solid #dc2626; }
.notification-info    { background: #dbeafe; color: #1e40af; border-left: 4px solid #2563eb; }

@media (max-width: 768px) {
    .panel-stats-cards { grid-template-columns: repeat(2, 1fr); }
    .table-controls { flex-direction: column; }
    .search-box { width: 100%; }
    .panel-table-container { overflow-x: auto; }
    .panel-table { min-width: 1000px; }
    .bulk-email-controls { flex-direction: column; }
    .bulk-email-controls input[type="date"] { min-width: 100%; }
}
</style>

<div class="panel-page-container">
    <?php if (isset($success_message)): ?>
    <div class="notification notification-success">
        &#9989; <?php echo htmlspecialchars($success_message); ?>
    </div>
    <?php endif; ?>

    <?php if (isset($error_message)): ?>
    <div class="notification notification-error">
        &#9888; <?php echo htmlspecialchars($error_message); ?>
    </div>
    <?php endif; ?>

    <?php if (isset($info_message)): ?>
    <div class="notification notification-info">
        &#8505; <?php echo htmlspecialchars($info_message); ?>
    </div>
    <?php endif; ?>

    <div class="page-header">
        <div>
            <h1>Panel Management</h1>
            <p class="page-subtitle">Manage all registered survey panel members</p>
        </div>
    </div>

    <!-- Statistics Cards -->
    <div class="panel-stats-cards">
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count($members); ?></div>
            <div class="stats-card-label">Total Members</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count(array_filter($members, fn($m) => $m['status'] === 'active')); ?></div>
            <div class="stats-card-label">Active Members</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count(array_filter($members, fn($m) => $m['email_verified'] == 1)); ?></div>
            <div class="stats-card-label">Email Verified</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count(array_filter($members, fn($m) => $m['mobile_verified'] == 1)); ?></div>
            <div class="stats-card-label">Mobile Verified</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count(array_filter($members, fn($m) => $m['onboarding_completed'] == 1)); ?></div>
            <div class="stats-card-label">Onboarded</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo count(array_filter($members, fn($m) => !empty($m['isec_class']))); ?></div>
            <div class="stats-card-label">SEC Classified</div>
        </div>
        <div class="stats-card">
            <div class="stats-card-number"><?php echo number_format(array_sum(array_column($members, 'current_points')), 0); ?></div>
            <div class="stats-card-label">Total Points</div>
        </div>
    </div>

    <!-- ===== BULK VERIFICATION EMAIL SECTION ===== -->
    <?php if (isLoggedIn()): ?>
    <div class="bulk-email-section">
        <h3>&#9993; Send Verification Emails to Unverified Members</h3>
        <div class="bulk-email-controls">
            <div class="field-group">
                <label for="bulk_from_date">Registration From</label>
                <input type="date" id="bulk_from_date"
                       max="<?php echo date('Y-m-d'); ?>"
                       value="<?php echo date('Y-m-d', strtotime('-30 days')); ?>">
            </div>
            <div class="field-group">
                <label for="bulk_to_date">Registration To</label>
                <input type="date" id="bulk_to_date"
                       max="<?php echo date('Y-m-d'); ?>"
                       value="<?php echo date('Y-m-d'); ?>">
            </div>
            <button class="btn-send-verification" onclick="confirmSendVerification()">
                Send Verification Emails
            </button>
        </div>
        <p style="margin:10px 0 0;font-size:12px;color:#6b7280;">
            Sends a fresh 48-hour verification link to all members who registered in the selected date range and have not yet verified their email.
        </p>
    </div>
    <?php endif; ?>

    <!-- Table Controls -->
    <div class="table-header-section">
        <div class="table-controls">
            <div class="search-box">
                <input type="text" id="memberSearch" placeholder="Search by email, postcode, or ID..." />
            </div>
            <div class="filter-group">
                <select class="filter-select" id="statusFilter">
                    <option value="">All Status</option>
                    <option value="active">Active</option>
                    <option value="inactive">Inactive</option>
                    <option value="suspended">Suspended</option>
                </select>
                <select class="filter-select" id="verificationFilter">
                    <option value="">All Verification</option>
                    <option value="verified">Email Verified</option>
                    <option value="not_verified">Not Verified</option>
                </select>
                <select class="filter-select" id="secFilter">
                    <option value="">All SEC</option>
                    <option value="A">SEC A</option>
                    <option value="B">SEC B</option>
                    <option value="C">SEC C</option>
                    <option value="D">SEC D</option>
                    <option value="E">SEC E</option>
                    <option value="none">Not Classified</option>
                </select>
            </div>
            <div class="filter-group" style="align-items:center;gap:8px;">
                <label style="font-size:13px;color:#6b7280;white-space:nowrap;">Joined:</label>
                <input type="date" id="dateFrom" class="filter-select" style="padding:9px 12px;" title="From date" />
                <span style="font-size:13px;color:#9ca3af;">&ndash;</span>
                <input type="date" id="dateTo" class="filter-select" style="padding:9px 12px;" title="To date" />
                <button onclick="clearDates()" id="clearDatesBtn" style="display:none;padding:8px 12px;border:2px solid #e5e7eb;border-radius:8px;background:#fff;color:#6b7280;font-size:12px;cursor:pointer;" title="Clear dates">&#x2715;</button>
            </div>
            <button onclick="exportCSV()" style="padding:9px 18px;background:#059669;color:#fff;border:none;border-radius:8px;font-size:13px;font-weight:600;cursor:pointer;display:flex;align-items:center;gap:6px;white-space:nowrap;transition:background 0.2s;" onmouseover="this.style.background='#047857'" onmouseout="this.style.background='#059669'">
                <svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg>
                Export CSV
            </button>
        </div>
    </div>

    <!-- Members Table -->
    <div class="panel-table-container">
        <table class="panel-table" id="membersTable">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Email</th>
                    <th>Gen</th>
                    <th>Date of Birth</th>
                    <th>Postcode</th>
                    <th>SEC</th>
                    <th>Points</th>
                    <th>Mobile</th>
                    <th>Status</th>
                    <th>Joined</th>
                    <th>Actions</th>
                </tr>
            </thead>
            <tbody>
                <?php if (empty($members)): ?>
                <tr>
                    <td colspan="11">
                        <div class="empty-state">
                            <div class="empty-state-icon">&#128101;</div>
                            <div class="empty-state-text">No panel members found</div>
                        </div>
                    </td>
                </tr>
                <?php else: ?>
                    <?php foreach ($members as $member): ?>
                    <tr data-member-id="<?php echo strtolower(formatMemberId($member['id'])); ?>"
                        data-email="<?php echo strtolower($member['email']); ?>"
                        data-postcode="<?php echo strtolower($member['postcode']); ?>"
                        data-status="<?php echo $member['status']; ?>"
                        data-verified="<?php echo $member['email_verified'] ? 'verified' : 'not_verified'; ?>"
                        data-sec="<?php echo !empty($member['isec_class']) ? $member['isec_class'] : 'none'; ?>"
                        data-joined="<?php echo date('Y-m-d', strtotime($member['created_at'])); ?>"
                        data-raw-id="<?php echo $member['id']; ?>"
                        data-raw-gender="<?php echo htmlspecialchars($member['gender'], ENT_QUOTES); ?>"
                        data-raw-dob="<?php echo htmlspecialchars($member['date_of_birth'] ?? '', ENT_QUOTES); ?>"
                        data-raw-postcode="<?php echo htmlspecialchars($member['postcode'], ENT_QUOTES); ?>"
                        data-raw-sec="<?php echo htmlspecialchars($member['isec_class'] ?? '', ENT_QUOTES); ?>"
                        data-raw-points="<?php echo intval($member['current_points'] ?? 0); ?>"
                        data-raw-mobile="<?php echo $member['mobile_verified'] ? 'Yes' : 'No'; ?>"
                        data-raw-whatsapp="<?php echo htmlspecialchars($member['whatsapp_number'] ?? '', ENT_QUOTES); ?>"
                        data-raw-is-whatsapp="<?php echo !empty($member['whatsapp_is_whatsapp']) ? 'Yes' : 'No'; ?>"
                        data-raw-wa-msg="<?php
                           if (!$member['email_verified'] && !empty($member['whatsapp_number']) && !empty($member['verify_token'])) {
    $vUrl = 'https://relevantreflex.com/verify.php?token=' . $member['verify_token'] . '&via=whatsapp';
    $waMsg = "Verification link from Relevant Reflex Surveys:\n\n" . $vUrl . "\n\nAlternatively, you can check your registered email address for the verification link. Please check Spam/Junk folders and mark our email as NOT SPAM or Move the verification mail to inbox.\n\nPlease ignore if you have already verified your account. Thanks!";
    echo htmlspecialchars($waMsg, ENT_QUOTES);
}
                        ?>"
                        data-raw-created="<?php echo date('Y-m-d H:i:s', strtotime($member['created_at'])); ?>">
                        <td><strong style="font-size:12px;"><?php echo formatMemberId($member['id']); ?></strong></td>
                        <td class="member-email-cell">
                            <div class="member-email" style="max-width:180px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;" title="<?php echo htmlspecialchars($member['email']); ?>">
                                <?php echo htmlspecialchars($member['email']); ?>
                            </div>
                            <?php if ($member['email_verified']): ?>
                                <?php $via = $member['email_verified_via'] ?? 'email'; ?>
                                <?php if ($via === 'whatsapp'): ?>
                                <div class="verified-badge" style="color:#059669;" title="Verified via WhatsApp link">
                                    <svg width="10" height="10" viewBox="0 0 24 24" fill="currentColor"><path d="M9 16.17L4.83 12l-1.42 1.41L9 19 21 7l-1.41-1.41L9 16.17z"/></svg>
                                    Verified &nbsp;&#128241;
                                </div>
                                <?php else: ?>
                                <div class="verified-badge" title="Verified via Email link">
                                    <svg width="10" height="10" viewBox="0 0 24 24" fill="currentColor"><path d="M9 16.17L4.83 12l-1.42 1.41L9 19 21 7l-1.41-1.41L9 16.17z"/></svg>
                                    Verified &nbsp;&#9993;
                                </div>
                                <?php endif; ?>
                            <?php endif; ?>
                        </td>
                        <td style="font-size:12px;"><?php echo $member['gender'] === 'Male' ? 'M' : ($member['gender'] === 'Female' ? 'F' : htmlspecialchars($member['gender'])); ?></td>
                        <td class="member-dob-cell">
                            <?php
                            $dob = new DateTime($member['date_of_birth']);
                            $age = (new DateTime())->diff($dob)->y;
                            ?>
                            <div class="dob-primary"><?php echo $dob->format('d M Y'); ?></div>
                            <div class="dob-age"><?php echo $age; ?>y</div>
                        </td>
                        <td><?php echo htmlspecialchars($member['postcode']); ?></td>
                        <td>
                            <?php if (!empty($member['isec_class'])): ?>
                                <?php
                                $secColors = ['A'=>'#059669','B'=>'#0d9488','C'=>'#2563eb','D'=>'#d97706','E'=>'#dc2626'];
                                $bgc = $secColors[$member['isec_class']] ?? '#94a3b8';
                                ?>
                                <span style="background:<?php echo $bgc;?>;color:#fff;padding:2px 8px;border-radius:4px;font-size:11px;font-weight:700;">
                                    <?php echo $member['isec_class']; ?>
                                </span>
                            <?php else: ?>
                                <span style="color:#cbd5e1;font-size:11px;">—</span>
                            <?php endif; ?>
                        </td>
                        <td>
                            <span class="points-badge">
                                <?php echo number_format($member['current_points'] ?? 0, 0); ?>
                            </span>
                        </td>
                        <td style="font-size:12px;white-space:nowrap;">
                            <?php if (!empty($member['mobile_number'])): ?>
                                <div style="font-weight:600;color:#111827;"><?php echo htmlspecialchars($member['mobile_number']); ?></div>
                                <?php if ($member['mobile_verified']): ?>
                                    <div style="font-size:10px;color:#059669;font-weight:600;">&#10003; Verified</div>
                                <?php else: ?>
                                    <div style="font-size:10px;color:#f59e0b;font-weight:600;">Unverified</div>
                                <?php endif; ?>
                            <?php else: ?>
                                <span style="color:#cbd5e1;">—</span>
                            <?php endif; ?>
                        </td>
                        <td>
                            <span class="status-badge status-<?php echo strtolower($member['status']); ?>">
                                <?php echo ucfirst($member['status']); ?>
                            </span>
                        </td>
                        <td class="joined-cell">
                            <div class="joined-date"><?php echo date('d M Y', strtotime($member['created_at'])); ?></div>
                            <div class="joined-time"><?php echo date('g:i A', strtotime($member['created_at'])); ?></div>
                        </td>
                        <td>
                            <div class="action-buttons">
                                <a href="member_view.php?id=<?php echo $member['id']; ?>" class="btn-action btn-view" title="View Member">
                                    &#128065;
                                </a>
                                <a href="member_edit.php?id=<?php echo $member['id']; ?>" class="btn-action btn-edit" title="Edit Member">
                                    &#9999;
                                </a>
                                <?php if (!$member['email_verified']): ?>
                                <button class="btn-action btn-resend"
                                    onclick="resendVerification(<?php echo $member['id']; ?>, '<?php echo htmlspecialchars($member['email'], ENT_QUOTES); ?>', this)"
                                    title="Resend Verification Email">
                                    &#9993;
                                </button>
                                <?php if (!empty($member['whatsapp_number']) && !empty($member['verify_token'])): ?>
                                <?php
    $waUrl  = 'https://relevantreflex.com/verify.php?token=' . $member['verify_token'] . '&via=whatsapp';
    $waText = "Verification link from Relevant Reflex Surveys:\n\n" . $waUrl . "\n\nAlternatively, you can check your registered email address for the verification link. Please check Spam/Junk folders and mark our email as NOT SPAM or Move the verification mail to inbox.\n\nPlease ignore if you have already verified your account. Thanks!";
?>
                                <button class="btn-action btn-copy-wa"
                                    onclick="copyWaMsg(this, <?php echo htmlspecialchars(json_encode($waText), ENT_QUOTES); ?>)"
                                    title="Copy WhatsApp Verification Message">
                                    &#128203;
                                </button>
                                <?php endif; ?>
                                <?php endif; ?>
                                <button class="btn-action btn-delete"
                                    onclick="confirmDelete(<?php echo $member['id']; ?>, '<?php echo htmlspecialchars($member['email'], ENT_QUOTES); ?>')"
                                    title="Delete Member">
                                    &#128465;
                                </button>
                            </div>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                <?php endif; ?>
            </tbody>
        </table>
    </div>
    <!-- Pagination -->
    <div id="paginationControls" style="display:flex;align-items:center;justify-content:space-between;padding:14px 18px;border-top:1px solid #e5e7eb;background:#f9fafb;flex-wrap:wrap;gap:10px;">
        <div id="paginationInfo" style="font-size:13px;color:#6b7280;"></div>
        <div id="paginationButtons" style="display:flex;gap:6px;flex-wrap:wrap;"></div>
    </div>
</div>

<!-- Delete Confirmation Modal -->
<div id="deleteModal" class="modal">
    <div class="modal-content">
        <div class="modal-header">
            <div class="modal-icon">&#9888;</div>
            <h3 class="modal-title">Confirm Deletion</h3>
        </div>
        <div class="modal-body">
            <p>Are you sure you want to delete member <strong id="deleteMemberEmail"></strong>?</p>
            <p>This action cannot be undone and will permanently delete:</p>
            <ul style="margin:12px 0;padding-left:20px;">
                <li>Member profile and account data</li>
                <li>All points and transaction history</li>
                <li>Redemption requests</li>
                <li>Support tickets and messages</li>
                <li>Profiler data</li>
            </ul>
        </div>
        <div class="modal-actions">
            <button class="btn-modal btn-cancel" onclick="closeDeleteModal()">Cancel</button>
            <form method="POST" style="display:inline;">
                <input type="hidden" name="member_id" id="deleteMemberId" />
                <button type="submit" name="delete_member" class="btn-modal btn-confirm-delete">
                    Delete Member
                </button>
            </form>
        </div>
    </div>
</div>

<!-- Send Verification Emails Confirmation Modal -->
<div id="sendVerificationModal" class="modal">
    <div class="modal-content">
        <div class="modal-header">
            <div class="modal-icon modal-icon-blue" id="sendModalIcon">&#9993;</div>
            <h3 class="modal-title" id="sendModalTitle">Confirm Send Verification Emails</h3>
        </div>
        <div class="modal-body" id="sendModalBody">
            <p>You are about to send verification emails to all <strong>unverified members</strong> who registered between:</p>
            <p style="background:#f0f9ff;border-radius:8px;padding:12px 16px;margin:12px 0;font-weight:600;color:#1e40af;">
                &#128197; <span id="confirmDateRange"></span>
            </p>
            <p>Each member will receive a fresh verification link valid for 48 hours. Members who are already verified will <strong>not</strong> receive an email.</p>
        </div>
        <!-- Sending progress state (hidden initially) -->
        <div id="sendProgressBody" style="display:none;text-align:center;padding:12px 0 20px;">
            <div style="margin-bottom:16px;">
                <svg width="40" height="40" viewBox="0 0 50 50" style="animation:spin 1s linear infinite;">
                    <circle cx="25" cy="25" r="20" fill="none" stroke="#2563eb" stroke-width="5" stroke-dasharray="31.4 94.2" stroke-linecap="round"/>
                </svg>
            </div>
            <!-- Progress bar -->
            <div style="background:#e5e7eb;border-radius:8px;height:10px;margin:0 0 14px;overflow:hidden;">
                <div id="sendProgressBar" style="height:100%;width:0%;background:linear-gradient(90deg,#2563eb,#60a5fa);border-radius:8px;transition:width 0.4s ease;"></div>
            </div>
            <!-- Live counter -->
            <p style="font-weight:700;font-size:22px;color:#1e40af;margin:0 0 4px;">
                <span id="sendCountDone">0</span> / <span id="sendCountTotal">…</span>
            </p>
            <p style="font-size:13px;font-weight:600;color:#2563eb;margin:0 0 6px;">emails sent</p>
            <p style="font-size:12px;color:#6b7280;margin:0;">Do not close this window.</p>
        </div>
        <div class="modal-actions" id="sendModalActions">
            <button class="btn-modal btn-cancel" onclick="closeSendVerificationModal()">Cancel</button>
            <button class="btn-modal btn-confirm-send" onclick="executeSendVerification()">
                &#128232; Send Emails
            </button>
        </div>
    </div>
</div>

<script>
// Auto-hide notifications after 6 seconds
setTimeout(() => {
    document.querySelectorAll('.notification').forEach(n => {
        n.style.transition = 'opacity 0.4s';
        n.style.opacity = '0';
        setTimeout(() => n.remove(), 400);
    });
}, 6000);

// Search, Filter & Pagination
const searchInput        = document.getElementById('memberSearch');
const statusFilter       = document.getElementById('statusFilter');
const verificationFilter = document.getElementById('verificationFilter');
const secFilter          = document.getElementById('secFilter');
const dateFrom           = document.getElementById('dateFrom');
const dateTo             = document.getElementById('dateTo');
const clearDatesBtn      = document.getElementById('clearDatesBtn');
const allRows            = Array.from(document.querySelectorAll('#membersTable tbody tr[data-member-id]'));

const PAGE_SIZE = 50;
let currentPage = 1;
let filteredRows = [];

function getFilteredRows() {
    const searchTerm        = (searchInput?.value || '').toLowerCase();
    const statusValue       = statusFilter?.value || '';
    const verificationValue = verificationFilter?.value || '';
    const secValue          = secFilter?.value || '';
    const fromVal           = dateFrom?.value || '';
    const toVal             = dateTo?.value   || '';

    return allRows.filter(row => {
        const matchesSearch       = !searchTerm        || (row.dataset.memberId||'').includes(searchTerm) || (row.dataset.email||'').includes(searchTerm) || (row.dataset.postcode||'').includes(searchTerm);
        const matchesStatus       = !statusValue       || row.dataset.status   === statusValue;
        const matchesVerification = !verificationValue || row.dataset.verified === verificationValue;
        const matchesSec          = !secValue          || row.dataset.sec      === secValue;
        const joined              = row.dataset.joined || '';
        const matchesFrom         = !fromVal || joined >= fromVal;
        const matchesTo           = !toVal   || joined <= toVal;
        return matchesSearch && matchesStatus && matchesVerification && matchesSec && matchesFrom && matchesTo;
    });
}

function clearDates() {
    dateFrom.value = '';
    dateTo.value = '';
    clearDatesBtn.style.display = 'none';
    filterTable();
}

function exportCSV() {
    const rows = getFilteredRows();
    const headers = ['Member ID','Email','Email Verified','Gender','Date of Birth','Postcode','SEC Class','Points','Mobile Verified','Status','Joined'];
    const csvRows = [headers.join(',')];
    rows.forEach(row => {
        const d = row.dataset;
        const cols = [
            '"' + (d.memberId || '').toUpperCase() + '"',
            '"' + (d.email || '') + '"',
            '"' + (d.verified === 'verified' ? 'Yes' : 'No') + '"',
            '"' + (d.rawGender || '') + '"',
            '"' + (d.rawDob || '') + '"',
            '"' + (d.rawPostcode || '') + '"',
            '"' + (d.rawSec || '') + '"',
            d.rawPoints || '0',
            '"' + (d.rawMobile || '') + '"',
            '"' + (d.status || '') + '"',
            '"' + (d.rawCreated || '') + '"',
        ];
        csvRows.push(cols.join(','));
    });
    const blob = new Blob([csvRows.join('\n')], {type:'text/csv;charset=utf-8;'});
    const url  = URL.createObjectURL(blob);
    const a    = document.createElement('a');
    const from = dateFrom?.value || '';
    const to   = dateTo?.value   || '';
    const dateSuffix = from || to ? '_' + (from||'start') + '_to_' + (to||'end') : '';
    a.href     = url;
    a.download = 'panel_export' + dateSuffix + '_' + new Date().toISOString().slice(0,10) + '.csv';
    a.click();
    URL.revokeObjectURL(url);
}

function renderPage(page) {
    currentPage = page;
    filteredRows = getFilteredRows();

    const totalPages = Math.max(1, Math.ceil(filteredRows.length / PAGE_SIZE));
    if (currentPage > totalPages) currentPage = totalPages;

    const start = (currentPage - 1) * PAGE_SIZE;
    const end   = start + PAGE_SIZE;

    // Show/hide rows
    allRows.forEach(row => row.style.display = 'none');
    filteredRows.forEach((row, i) => {
        row.style.display = (i >= start && i < end) ? '' : 'none';
    });

    // Info text
    const infoEl = document.getElementById('paginationInfo');
    const btnEl  = document.getElementById('paginationButtons');
    if (!infoEl || !btnEl) return;

    const from = filteredRows.length === 0 ? 0 : start + 1;
    const to   = Math.min(end, filteredRows.length);
    infoEl.textContent = `Showing ${from}–${to} of ${filteredRows.length} members`;

    // Build page buttons
    btnEl.innerHTML = '';
    if (totalPages <= 1) return;

    const btnStyle = (active) =>
        `style="padding:5px 10px;border-radius:5px;border:1px solid ${active ? '#059669' : '#d1d5db'};background:${active ? '#059669' : '#fff'};color:${active ? '#fff' : '#374151'};cursor:pointer;font-size:12px;font-weight:${active ? '600' : '400'};"`;

    // Prev
    const prev = document.createElement('button');
    prev.innerHTML = '&laquo;';
    prev.setAttribute('style', `padding:5px 10px;border-radius:5px;border:1px solid #d1d5db;background:#fff;color:#374151;cursor:pointer;font-size:12px;${currentPage===1?'opacity:.4;cursor:default;':''}`);
    prev.disabled = currentPage === 1;
    prev.onclick = () => renderPage(currentPage - 1);
    btnEl.appendChild(prev);

    // Page numbers — show window of 5 around current
    let pageStart = Math.max(1, currentPage - 2);
    let pageEnd   = Math.min(totalPages, pageStart + 4);
    if (pageEnd - pageStart < 4) pageStart = Math.max(1, pageEnd - 4);

    if (pageStart > 1) {
        const b = document.createElement('button');
        b.textContent = '1'; b.setAttribute(...Object.entries({style:`padding:5px 10px;border-radius:5px;border:1px solid #d1d5db;background:#fff;color:#374151;cursor:pointer;font-size:12px;`}));
        b.onclick = () => renderPage(1); btnEl.appendChild(b);
        if (pageStart > 2) { const s = document.createElement('span'); s.textContent='…'; s.style.cssText='padding:5px 4px;color:#9ca3af;font-size:12px;'; btnEl.appendChild(s); }
    }

    for (let p = pageStart; p <= pageEnd; p++) {
        const b = document.createElement('button');
        b.textContent = p;
        b.setAttribute('style', `padding:5px 10px;border-radius:5px;border:1px solid ${p===currentPage?'#059669':'#d1d5db'};background:${p===currentPage?'#059669':'#fff'};color:${p===currentPage?'#fff':'#374151'};cursor:pointer;font-size:12px;font-weight:${p===currentPage?'600':'400'};`);
        b.onclick = ((pg) => () => renderPage(pg))(p);
        btnEl.appendChild(b);
    }

    if (pageEnd < totalPages) {
        if (pageEnd < totalPages - 1) { const s = document.createElement('span'); s.textContent='…'; s.style.cssText='padding:5px 4px;color:#9ca3af;font-size:12px;'; btnEl.appendChild(s); }
        const b = document.createElement('button');
        b.textContent = totalPages; b.setAttribute('style','padding:5px 10px;border-radius:5px;border:1px solid #d1d5db;background:#fff;color:#374151;cursor:pointer;font-size:12px;');
        b.onclick = () => renderPage(totalPages); btnEl.appendChild(b);
    }

    // Next
    const next = document.createElement('button');
    next.innerHTML = '&raquo;';
    next.setAttribute('style', `padding:5px 10px;border-radius:5px;border:1px solid #d1d5db;background:#fff;color:#374151;cursor:pointer;font-size:12px;${currentPage===totalPages?'opacity:.4;cursor:default;':''}`);
    next.disabled = currentPage === totalPages;
    next.onclick = () => renderPage(currentPage + 1);
    btnEl.appendChild(next);
}

function filterTable() { renderPage(1); }

// Init
renderPage(1);

searchInput?.addEventListener('input',  filterTable);
statusFilter?.addEventListener('change', filterTable);
verificationFilter?.addEventListener('change', filterTable);
secFilter?.addEventListener('change', filterTable);
dateFrom?.addEventListener('change', () => {
    clearDatesBtn.style.display = (dateFrom.value || dateTo.value) ? '' : 'none';
    filterTable();
});
dateTo?.addEventListener('change', () => {
    clearDatesBtn.style.display = (dateFrom.value || dateTo.value) ? '' : 'none';
    filterTable();
});

// ── Copy WhatsApp Verification Message ───────────────────────────────
function copyWaMsg(btn, msg) {
    if (!msg) {
        showToast(false, 'No WhatsApp message available for this member.');
        return;
    }
    navigator.clipboard.writeText(msg).then(function() {
        const original = btn.innerHTML;
        btn.innerHTML = '&#10003;';
        btn.style.color = '#059669';
        setTimeout(function() { btn.innerHTML = original; btn.style.color = ''; }, 2000);
        showToast(true, 'WhatsApp message copied! Open WhatsApp and paste to send.');
    }).catch(function() {
        // Fallback for older browsers
        const ta = document.createElement('textarea');
        ta.value = msg;
        ta.style.position = 'fixed';
        ta.style.opacity = '0';
        document.body.appendChild(ta);
        ta.select();
        document.execCommand('copy');
        document.body.removeChild(ta);
        showToast(true, 'WhatsApp message copied! Open WhatsApp and paste to send.');
    });
}

// ── Delete Modal ──────────────────────────────────────────
function confirmDelete(memberId, memberEmail) {
    document.getElementById('deleteMemberId').value          = memberId;
    document.getElementById('deleteMemberEmail').textContent = memberEmail;
    document.getElementById('deleteModal').classList.add('active');
}
function closeDeleteModal() {
    document.getElementById('deleteModal').classList.remove('active');
}
document.getElementById('deleteModal')?.addEventListener('click', e => {
    if (e.target === document.getElementById('deleteModal')) closeDeleteModal();
});

// ── Send Verification Modal ───────────────────────────────
let pendingFromDate = '';
let pendingToDate   = '';

function confirmSendVerification() {
    const fromDate = document.getElementById('bulk_from_date').value;
    const toDate   = document.getElementById('bulk_to_date').value;
    if (!fromDate || !toDate) { alert('Please select both From and To dates.'); return; }
    if (fromDate > toDate)    { alert('"From" date cannot be later than "To" date.'); return; }

    pendingFromDate = fromDate;
    pendingToDate   = toDate;

    const fmt = d => new Date(d + 'T00:00:00').toLocaleDateString('en-IN', {day:'numeric',month:'short',year:'numeric'});
    document.getElementById('confirmDateRange').textContent = fmt(fromDate) + ' — ' + fmt(toDate);

    // Reset modal to confirm state
    document.getElementById('sendModalBody').style.display    = '';
    document.getElementById('sendProgressBody').style.display = 'none';
    document.getElementById('sendModalActions').style.display = '';
    document.getElementById('sendModalTitle').textContent     = 'Confirm Send Verification Emails';
    document.getElementById('sendModalIcon').textContent      = '✉';

    document.getElementById('sendVerificationModal').classList.add('active');
}

function closeSendVerificationModal() {
    document.getElementById('sendVerificationModal').classList.remove('active');
}

document.getElementById('sendVerificationModal')?.addEventListener('click', e => {
    if (e.target === document.getElementById('sendVerificationModal')) closeSendVerificationModal();
});

function executeSendVerification() {
    // Switch modal to sending/progress state
    document.getElementById('sendModalBody').style.display    = 'none';
    document.getElementById('sendProgressBody').style.display = '';
    document.getElementById('sendModalActions').style.display = 'none';
    document.getElementById('sendModalTitle').textContent     = 'Sending Emails…';
    document.getElementById('sendModalIcon').innerHTML        =
        '<svg width="28" height="28" viewBox="0 0 50 50" style="animation:spin 1s linear infinite"><circle cx="25" cy="25" r="20" fill="none" stroke="#2563eb" stroke-width="5" stroke-dasharray="31.4 94.2" stroke-linecap="round"/></svg>';

    // Reset counters
    document.getElementById('sendCountDone').textContent  = '0';
    document.getElementById('sendCountTotal').textContent = '…';
    document.getElementById('sendProgressBar').style.width = '0%';

    let totalSent   = 0;
    let totalFailed = 0;
    let grandTotal  = 0;

    function sendBatch(offset) {
        const formData = new FormData();
        formData.append('send_verification_emails', '1');
        formData.append('from_date', pendingFromDate);
        formData.append('to_date',   pendingToDate);
        formData.append('offset',    offset);

        fetch(window.location.pathname, { method: 'POST', body: formData })
        .then(r => {
            if (!r.ok) throw new Error('HTTP ' + r.status);
            return r.json();
        })
        .then(data => {
            if (!data.success) {
                closeSendVerificationModal();
                showToast(false, data.message || 'An error occurred. Please try again.');
                return;
            }

            // Update running totals
            totalSent   += (data.sent   || 0);
            totalFailed += (data.failed || 0);
            grandTotal   = data.total   || grandTotal;

            const processed = data.processed || (offset + (data.sent + data.failed));

            // Update live UI
            document.getElementById('sendCountTotal').textContent = grandTotal;
            document.getElementById('sendCountDone').textContent  = processed;
            const pct = grandTotal > 0 ? Math.min(100, Math.round(processed / grandTotal * 100)) : 100;
            document.getElementById('sendProgressBar').style.width = pct + '%';

            if (data.done) {
                // All done
                closeSendVerificationModal();
                if (grandTotal === 0) {
                    showToast(true, 'No unverified members found in the selected date range.');
                } else if (totalFailed === 0) {
                    showToast(true, '&#10003; All done! Verification emails sent to ' + totalSent + ' member(s) successfully.');
                } else {
                    const errHint = data.firstError ? ' — Error: ' + data.firstError : '';
                    showToast(false, 'Completed: ' + totalSent + ' sent, ' + totalFailed + ' failed.' + errHint);
                }
            } else {
                // Fire next batch
                sendBatch(processed);
            }
        })
        .catch(err => {
            closeSendVerificationModal();
            showToast(false, 'Connection error after sending ' + totalSent + ' emails. You may retry. (' + err.message + ')');
        });
    }

    sendBatch(0);
}

// ── Toast notification helper ─────────────────────────────
function showToast(success, message) {
    // Remove any existing toast
    document.querySelectorAll('.notification').forEach(n => n.remove());

    const toast = document.createElement('div');
    toast.className = 'notification ' + (success ? 'notification-success' : 'notification-error');
    toast.innerHTML = (success ? '&#9989; ' : '&#9888; ') + message;
    document.body.appendChild(toast);

    // Auto-hide after 8 seconds
    setTimeout(() => {
        toast.style.transition = 'opacity 0.4s';
        toast.style.opacity = '0';
        setTimeout(() => toast.remove(), 400);
    }, 8000);
}

// Escape key closes any open modal
document.addEventListener('keydown', e => {
    if (e.key === 'Escape') { closeDeleteModal(); closeSendVerificationModal(); }
});

// ── Resend Verification Email ─────────────────────────────
function resendVerification(memberId, memberEmail, btn) {
    if (!confirm('Send verification email to ' + memberEmail + '?')) return;

    // Show spinner on the button
    const original = btn.innerHTML;
    btn.innerHTML  = '<svg width="16" height="16" viewBox="0 0 50 50" style="animation:spin 1s linear infinite;vertical-align:middle"><circle cx="25" cy="25" r="20" fill="none" stroke="#2563eb" stroke-width="6" stroke-dasharray="31.4 94.2" stroke-linecap="round"/></svg>';
    btn.disabled   = true;

    const formData = new FormData();
    formData.append('resend_verification', '1');
    formData.append('member_id', memberId);

    fetch(window.location.pathname, { method: 'POST', body: formData })
    .then(r => r.json())
    .then(data => {
        btn.innerHTML = original;
        btn.disabled  = false;
        if (data.success) {
            // Briefly flash green checkmark on the button
            btn.innerHTML = '&#10003;';
            btn.style.color = '#059669';
            setTimeout(() => { btn.innerHTML = original; btn.style.color = ''; }, 2000);
        }
        showToast(data.success, data.message);
    })
    .catch(() => {
        btn.innerHTML = original;
        btn.disabled  = false;
        showToast(false, 'Connection error. Please try again.');
    });
}

// Force reload on back button to prevent stale state
window.addEventListener('pageshow', e => { if (e.persisted) window.location.reload(); });
</script>

<style>
@keyframes spin { from { transform: rotate(0deg); } to { transform: rotate(360deg); } }
</style>

<?php include 'includes/footer.php'; ?>