<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

$success = '';

// Handle approval (only if payment is done)
if (isset($_GET['approve'])) {
    $member_id = (int)$_GET['approve'];
    $check_sql = "SELECT payment_status FROM members WHERE id = $member_id";
    $check_result = $conn->query($check_sql);
    if ($check_result->num_rows > 0) {
        $member_data = $check_result->fetch_assoc();
        if ($member_data['payment_status'] == 1) {
            $sql = "UPDATE members SET is_approved = 1 WHERE id = $member_id";
            if ($conn->query($sql)) {
                $success = "Member approved successfully!";
            }
        } else {
            $success = "Cannot approve: Payment not completed yet!";
        }
    }
}

// Handle delete
if (isset($_GET['delete'])) {
    $member_id = (int)$_GET['delete'];
    $conn->query("DELETE FROM survey_reviews WHERE member_id = $member_id");
    $conn->query("DELETE FROM contact_messages WHERE member_id = $member_id");
    $delete_sql = "DELETE FROM members WHERE id = $member_id";
    if ($conn->query($delete_sql)) {
        $success = "Member deleted successfully!";
    } else {
        $success = "Failed to delete member: " . $conn->error;
    }
}

// Handle re-verify (resend verification email)
if (isset($_GET['reverify'])) {
    $member_id = (int)$_GET['reverify'];
    $member_sql = "SELECT * FROM members WHERE id = $member_id AND is_verified = 0";
    $member_result = $conn->query($member_sql);
    
    if ($member_result->num_rows > 0) {
        $member_data = $member_result->fetch_assoc();
        
        // Generate new verification token
        $new_token = bin2hex(random_bytes(32));
        $update_token_sql = "UPDATE members SET verification_token = '$new_token' WHERE id = $member_id";
        
        if ($conn->query($update_token_sql)) {
            // Increment reverify count
            $conn->query("UPDATE members SET reverify_count = reverify_count + 1 WHERE id = $member_id");
            
            $verification_link = SITE_URL . "/verify-email.php?token=" . $new_token;
            
            $to = $member_data['email'];
            $subject = "Verify Your Email - Paid Survey Hub India";
            $message = "Hello " . $member_data['full_name'] . ",\n\n";
            $message .= "We are resending this verification email for your Paid Survey Hub India account.\n\n";
            $message .= "Please click the link below to verify your email address:\n";
            $message .= $verification_link . "\n\n";
            $message .= "If you did not create this account, please ignore this email.\n\n";
            $message .= "Best regards,\n";
            $message .= "Paid Survey Hub India Team";
            
            $headers = "From: noreply@paidsurveyhub.in\r\n";
            $headers .= "Reply-To: signupverification@paidsurveyhub.in\r\n";
            
            if (mail($to, $subject, $message, $headers)) {
                $success = "Verification email resent successfully to " . htmlspecialchars($member_data['email']) . "!";
            } else {
                $success = "Failed to send verification email. Please try again.";
            }
        } else {
            $success = "Failed to generate new verification token.";
        }
    } else {
        $success = "Member not found or already verified.";
    }
}

// Build query with filters
$where_clauses = ["1=1"];

$search = isset($_GET['search']) ? clean_input($_GET['search']) : '';
if (!empty($search)) {
    $where_clauses[] = "(full_name LIKE '%$search%' OR email LIKE '%$search%' OR phone LIKE '%$search%')";
}

if (isset($_GET['verified']) && $_GET['verified'] !== '') {
    $verified = (int)$_GET['verified'];
    $where_clauses[] = "is_verified = $verified";
}

if (isset($_GET['approved']) && $_GET['approved'] !== '') {
    $approved = (int)$_GET['approved'];
    $where_clauses[] = "is_approved = $approved";
}

if (isset($_GET['paid']) && $_GET['paid'] !== '') {
    $paid = (int)$_GET['paid'];
    $where_clauses[] = "payment_status = $paid";
}

$date_from = isset($_GET['date_from']) ? clean_input($_GET['date_from']) : '';
$date_to = isset($_GET['date_to']) ? clean_input($_GET['date_to']) : '';

if (!empty($date_from)) {
    $where_clauses[] = "created_at >= '$date_from 00:00:00'";
}
if (!empty($date_to)) {
    $where_clauses[] = "created_at <= '$date_to 23:59:59'";
}

$order_by = "created_at";
$order_dir = "DESC";
if (isset($_GET['sort'])) {
    $allowed_sorts = ['full_name', 'email', 'phone', 'created_at', 'is_verified', 'is_approved', 'payment_status'];
    if (in_array($_GET['sort'], $allowed_sorts)) {
        $order_by = $_GET['sort'];
    }
}
if (isset($_GET['dir']) && strtoupper($_GET['dir']) === 'ASC') {
    $order_dir = 'ASC';
}

$where_sql = implode(" AND ", $where_clauses);

// Count total records for pagination
$count_sql = "SELECT COUNT(*) as total FROM members WHERE $where_sql";
$count_result = $conn->query($count_sql);
$total_records = $count_result->fetch_assoc()['total'];

$per_page = 25;
$total_pages = max(1, ceil($total_records / $per_page));
$current_page = isset($_GET['page']) ? max(1, min((int)$_GET['page'], $total_pages)) : 1;
$offset = ($current_page - 1) * $per_page;

$sql = "SELECT * FROM members WHERE $where_sql ORDER BY $order_by $order_dir LIMIT $offset, $per_page";
$result = $conn->query($sql);

// Export functionality (exports ALL matching records)
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="members_' . date('Y-m-d_H-i-s') . '.csv"');
    
    $export_sql = "SELECT * FROM members WHERE $where_sql ORDER BY $order_by $order_dir";
    $export_result = $conn->query($export_sql);
    
    $output = fopen('php://output', 'w');
    fputcsv($output, ['ID', 'Full Name', 'Email', 'Phone', 'Verified', 'Approved', 'Paid', 'Reverify Count', 'Registered Date']);
    
    while ($row = $export_result->fetch_assoc()) {
        fputcsv($output, [
            $row['id'],
            $row['full_name'],
            $row['email'],
            $row['phone'],
            $row['is_verified'] ? 'Yes' : 'No',
            $row['is_approved'] ? 'Yes' : 'No',
            $row['payment_status'] ? 'Yes' : 'No',
            $row['reverify_count'],
            date('Y-m-d H:i:s', strtotime($row['created_at']))
        ]);
    }
    fclose($output);
    exit();
}

// Helper: Build query string preserving all current filters
function build_query_params($overrides = []) {
    $params = [];
    $keys = ['search', 'verified', 'approved', 'paid', 'sort', 'dir', 'date_from', 'date_to', 'page'];
    foreach ($keys as $key) {
        if (isset($overrides[$key])) {
            if ($overrides[$key] !== '') {
                $params[$key] = $overrides[$key];
            }
        } elseif (isset($_GET[$key]) && $_GET[$key] !== '') {
            $params[$key] = $_GET[$key];
        }
    }
    return http_build_query($params);
}

$page_title = 'Manage Members';
include '../includes/header.php';
?>

<style>
    .members-table { width: 100%; border-collapse: collapse; table-layout: fixed; }
    .members-table th, .members-table td { padding: 0.5rem 0.4rem; text-align: left; vertical-align: middle; overflow: hidden; text-overflow: ellipsis; }
    .members-table th { white-space: nowrap; }
    .members-table th a { color: white; text-decoration: none; }
    .members-table .col-name { width: 13%; }
    .members-table .col-email { width: 17%; }
    .members-table .col-phone { width: 10%; }
    .members-table .col-status { width: 6%; text-align: center; }
    .members-table .col-date { width: 9%; }
    .members-table .col-actions { width: 27%; text-align: center; }
    .members-table td.cell-truncate { white-space: nowrap; overflow: hidden; text-overflow: ellipsis; }
    .status-badge { display: inline-block; padding: 0.15rem 0.4rem; border-radius: 4px; font-size: 0.75rem; font-weight: bold; color: var(--navy-blue); }
    .status-yes { background: var(--yellow); }
    .status-no { background: var(--light-grey); }
    .action-btn { display: inline-block; padding: 0.2rem 0.45rem; font-size: 0.72rem; border-radius: 4px; text-decoration: none; white-space: nowrap; cursor: pointer; border: none; font-weight: bold; line-height: 1.4; }
    .action-btn-edit { background: var(--light-grey); color: var(--navy-blue); }
    .action-btn-delete { background: #dc3545; color: white; }
    .action-btn-approve { background: var(--navy-blue); color: white; }
    .action-btn-reverify { background: #17a2b8; color: white; }
    .action-btn-disabled { background: #ccc; color: #666; cursor: not-allowed; }
    .actions-wrap { display: flex; flex-wrap: wrap; gap: 3px; justify-content: center; }
    .pagination-wrap { margin-top: 1.5rem; display: flex; justify-content: center; align-items: center; flex-wrap: wrap; gap: 0.35rem; }
    .page-btn { padding: 0.35rem 0.6rem; border-radius: 5px; text-decoration: none; font-size: 0.85rem; display: inline-block; }
    .page-btn-active { background: var(--yellow); color: var(--navy-blue); font-weight: bold; }
    .page-btn-nav { background: var(--navy-blue); color: white; }
    .page-btn-num { background: var(--light-grey); color: var(--navy-blue); }
    .page-btn-disabled { background: #ccc; color: #666; }
</style>

<div class="container">
    <div class="card">
        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/dashboard.php" style="color: var(--navy-blue); text-decoration: none; display: inline-block; margin-bottom: 1rem;">
            ← Back to Dashboard
        </a>
        
        <h1 class="card-title">Manage Members</h1>
        
        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <!-- Search and Filter Section -->
        <div style="background: var(--light-grey); padding: 1.5rem; border-radius: 8px; margin-bottom: 2rem;">
            <form method="GET" action="">
                <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(155px, 1fr)); gap: 1rem;">
                    <div>
                        <label for="search" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Search</label>
                        <input type="text" id="search" name="search" placeholder="Name, Email, Phone" 
                               value="<?php echo htmlspecialchars($search); ?>"
                               style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                    </div>
                    <div>
                        <label for="verified" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Email Verified</label>
                        <select id="verified" name="verified" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                            <option value="">All</option>
                            <option value="1" <?php echo (isset($_GET['verified']) && $_GET['verified'] === '1') ? 'selected' : ''; ?>>Yes</option>
                            <option value="0" <?php echo (isset($_GET['verified']) && $_GET['verified'] === '0') ? 'selected' : ''; ?>>No</option>
                        </select>
                    </div>
                    <div>
                        <label for="approved" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Approved</label>
                        <select id="approved" name="approved" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                            <option value="">All</option>
                            <option value="1" <?php echo (isset($_GET['approved']) && $_GET['approved'] === '1') ? 'selected' : ''; ?>>Yes</option>
                            <option value="0" <?php echo (isset($_GET['approved']) && $_GET['approved'] === '0') ? 'selected' : ''; ?>>No</option>
                        </select>
                    </div>
                    <div>
                        <label for="paid" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">Payment</label>
                        <select id="paid" name="paid" style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                            <option value="">All</option>
                            <option value="1" <?php echo (isset($_GET['paid']) && $_GET['paid'] === '1') ? 'selected' : ''; ?>>Paid</option>
                            <option value="0" <?php echo (isset($_GET['paid']) && $_GET['paid'] === '0') ? 'selected' : ''; ?>>Unpaid</option>
                        </select>
                    </div>
                    <div>
                        <label for="date_from" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">From Date</label>
                        <input type="date" id="date_from" name="date_from" 
                               value="<?php echo htmlspecialchars($date_from); ?>"
                               style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                    </div>
                    <div>
                        <label for="date_to" style="display: block; margin-bottom: 0.5rem; font-size: 0.9rem;">To Date</label>
                        <input type="date" id="date_to" name="date_to" 
                               value="<?php echo htmlspecialchars($date_to); ?>"
                               style="width: 100%; padding: 0.5rem; border: 2px solid var(--dark-grey); border-radius: 5px;">
                    </div>
                    <div style="display: flex; align-items: flex-end; gap: 0.5rem;">
                        <button type="submit" class="btn btn-primary" style="flex: 1;">Filter</button>
                        <a href="?" class="btn btn-secondary" style="padding: 0.75rem 1rem; text-decoration: none;">Reset</a>
                    </div>
                </div>
            </form>
        </div>
        
        <!-- Export Button & Record Count -->
        <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 1rem; flex-wrap: wrap; gap: 0.5rem;">
            <p style="margin: 0; color: var(--dark-grey); font-weight: bold;">
                Total: <?php echo $total_records; ?> member(s)
                <?php if ($total_pages > 1): ?>
                    | Page <?php echo $current_page; ?> of <?php echo $total_pages; ?>
                <?php endif; ?>
            </p>
            <a href="?export=csv&<?php echo build_query_params(['page' => '']); ?>" class="btn btn-secondary">📊 Export CSV</a>
        </div>
        
        <?php if ($result->num_rows > 0): ?>
            <div style="overflow-x: auto; -webkit-overflow-scrolling: touch;">
                <table class="members-table">
                    <thead>
                        <tr>
                            <th class="col-name">
                                <a href="?<?php echo build_query_params(['sort' => 'full_name', 'dir' => ($order_by === 'full_name' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Name <?php if($order_by === 'full_name') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-email">
                                <a href="?<?php echo build_query_params(['sort' => 'email', 'dir' => ($order_by === 'email' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Email <?php if($order_by === 'email') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-phone">
                                <a href="?<?php echo build_query_params(['sort' => 'phone', 'dir' => ($order_by === 'phone' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Phone <?php if($order_by === 'phone') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-status">
                                <a href="?<?php echo build_query_params(['sort' => 'is_verified', 'dir' => ($order_by === 'is_verified' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Verified <?php if($order_by === 'is_verified') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-status">
                                <a href="?<?php echo build_query_params(['sort' => 'is_approved', 'dir' => ($order_by === 'is_approved' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Approved <?php if($order_by === 'is_approved') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-status">
                                <a href="?<?php echo build_query_params(['sort' => 'payment_status', 'dir' => ($order_by === 'payment_status' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Paid <?php if($order_by === 'payment_status') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-date">
                                <a href="?<?php echo build_query_params(['sort' => 'created_at', 'dir' => ($order_by === 'created_at' && $order_dir === 'ASC') ? 'DESC' : 'ASC', 'page' => '1']); ?>">
                                    Registered <?php if($order_by === 'created_at') echo $order_dir === 'ASC' ? '↑' : '↓'; ?>
                                </a>
                            </th>
                            <th class="col-actions">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($member = $result->fetch_assoc()): ?>
                            <tr>
                                <td class="cell-truncate" title="<?php echo htmlspecialchars($member['full_name']); ?>"><?php echo htmlspecialchars($member['full_name']); ?></td>
                                <td class="cell-truncate" title="<?php echo htmlspecialchars($member['email']); ?>"><?php echo htmlspecialchars($member['email']); ?></td>
                                <td class="cell-truncate"><?php echo htmlspecialchars($member['phone']); ?></td>
                                <td style="text-align: center;">
                                    <span class="status-badge <?php echo $member['is_verified'] ? 'status-yes' : 'status-no'; ?>">
                                        <?php echo $member['is_verified'] ? 'Yes' : 'No'; ?>
                                    </span>
                                    <?php if ($member['reverify_count'] > 0): ?>
                                        <span title="Verification email resent <?php echo $member['reverify_count']; ?> time(s)" 
                                              style="display: inline-block; background: #dc3545; color: white; font-size: 0.65rem; font-weight: bold; 
                                                     width: 16px; height: 16px; line-height: 16px; border-radius: 50%; text-align: center; 
                                                     vertical-align: top; margin-left: 2px; cursor: help;">
                                            <?php echo $member['reverify_count']; ?>
                                        </span>
                                    <?php endif; ?>
                                </td>
                                <td style="text-align: center;">
                                    <span class="status-badge <?php echo $member['is_approved'] ? 'status-yes' : 'status-no'; ?>">
                                        <?php echo $member['is_approved'] ? 'Yes' : 'No'; ?>
                                    </span>
                                </td>
                                <td style="text-align: center;">
                                    <span class="status-badge <?php echo $member['payment_status'] ? 'status-yes' : 'status-no'; ?>">
                                        <?php echo $member['payment_status'] ? 'Yes' : 'No'; ?>
                                    </span>
                                </td>
                                <td style="white-space: nowrap;"><?php echo date('M d, Y', strtotime($member['created_at'])); ?></td>
                                <td>
                                    <div class="actions-wrap">
                                        <a href="<?php echo SITE_URL . ADMIN_PATH; ?>/edit-member.php?id=<?php echo $member['id']; ?>" 
                                           class="action-btn action-btn-edit">✏️ Edit</a>
                                        
                                        <a href="?delete=<?php echo $member['id']; ?>&<?php echo build_query_params(); ?>" 
                                           class="action-btn action-btn-delete"
                                           onclick="return confirm('Are you sure you want to delete this member?\n\nThis will also delete their reviews and tickets.\nThis action cannot be undone!');">🗑️ Delete</a>
                                        
                                        <?php if (!$member['is_verified']): ?>
                                            <a href="?reverify=<?php echo $member['id']; ?>&<?php echo build_query_params(); ?>" 
                                               class="action-btn action-btn-reverify"
                                               onclick="return confirm('Resend verification email to <?php echo htmlspecialchars($member['email']); ?>?<?php echo $member['reverify_count'] > 0 ? '\n\nAlready resent ' . $member['reverify_count'] . ' time(s) before.' : ''; ?>');">📧 Re-verify<?php echo $member['reverify_count'] > 0 ? ' (' . $member['reverify_count'] . ')' : ''; ?></a>
                                        <?php endif; ?>
                                        
                                        <?php if ($member['is_verified'] && !$member['is_approved'] && $member['payment_status'] == 1): ?>
                                            <a href="?approve=<?php echo $member['id']; ?>&<?php echo build_query_params(); ?>" 
                                               class="action-btn action-btn-approve"
                                               onclick="return confirm('Approve this member?');">✅ Approve</a>
                                        <?php elseif ($member['is_verified'] && !$member['is_approved'] && $member['payment_status'] == 0): ?>
                                            <span class="action-btn action-btn-disabled" title="Payment not completed">Approve</span>
                                        <?php endif; ?>
                                    </div>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
            
            <!-- Pagination -->
            <?php if ($total_pages > 1): ?>
                <div class="pagination-wrap">
                    <?php if ($current_page > 1): ?>
                        <a href="?<?php echo build_query_params(['page' => $current_page - 1]); ?>" class="page-btn page-btn-nav">← Prev</a>
                    <?php else: ?>
                        <span class="page-btn page-btn-disabled">← Prev</span>
                    <?php endif; ?>
                    
                    <?php
                    $range = 2;
                    $start_page = max(1, $current_page - $range);
                    $end_page = min($total_pages, $current_page + $range);
                    
                    if ($start_page > 1): ?>
                        <a href="?<?php echo build_query_params(['page' => 1]); ?>" class="page-btn page-btn-num">1</a>
                        <?php if ($start_page > 2): ?>
                            <span style="padding: 0.4rem 0.2rem; color: var(--dark-grey);">...</span>
                        <?php endif; ?>
                    <?php endif; ?>
                    
                    <?php for ($i = $start_page; $i <= $end_page; $i++): ?>
                        <?php if ($i == $current_page): ?>
                            <span class="page-btn page-btn-active"><?php echo $i; ?></span>
                        <?php else: ?>
                            <a href="?<?php echo build_query_params(['page' => $i]); ?>" class="page-btn page-btn-num"><?php echo $i; ?></a>
                        <?php endif; ?>
                    <?php endfor; ?>
                    
                    <?php if ($end_page < $total_pages): ?>
                        <?php if ($end_page < $total_pages - 1): ?>
                            <span style="padding: 0.4rem 0.2rem; color: var(--dark-grey);">...</span>
                        <?php endif; ?>
                        <a href="?<?php echo build_query_params(['page' => $total_pages]); ?>" class="page-btn page-btn-num"><?php echo $total_pages; ?></a>
                    <?php endif; ?>
                    
                    <?php if ($current_page < $total_pages): ?>
                        <a href="?<?php echo build_query_params(['page' => $current_page + 1]); ?>" class="page-btn page-btn-nav">Next →</a>
                    <?php else: ?>
                        <span class="page-btn page-btn-disabled">Next →</span>
                    <?php endif; ?>
                    
                    <!-- Go to Page -->
                    <form method="GET" action="" style="display: inline-flex; align-items: center; gap: 0.3rem; margin-left: 0.8rem;">
                        <?php 
                        $preserve_keys = ['search', 'verified', 'approved', 'paid', 'sort', 'dir', 'date_from', 'date_to'];
                        foreach ($preserve_keys as $key) {
                            if (isset($_GET[$key]) && $_GET[$key] !== '') {
                                echo '<input type="hidden" name="' . $key . '" value="' . htmlspecialchars($_GET[$key]) . '">';
                            }
                        }
                        ?>
                        <label for="goto_page" style="font-size: 0.85rem; color: var(--dark-grey); white-space: nowrap;">Go to:</label>
                        <input type="number" id="goto_page" name="page" min="1" max="<?php echo $total_pages; ?>" 
                               placeholder="<?php echo $current_page; ?>"
                               style="width: 55px; padding: 0.35rem; border: 2px solid var(--dark-grey); border-radius: 5px; text-align: center; font-size: 0.85rem;">
                        <button type="submit" 
                                style="padding: 0.35rem 0.6rem; background: var(--navy-blue); color: white; border: none; border-radius: 5px; cursor: pointer; font-size: 0.85rem;">Go</button>
                    </form>
                </div>
            <?php endif; ?>
            
        <?php else: ?>
            <div class="alert alert-info">
                No members found matching your criteria.
            </div>
        <?php endif; ?>
    </div>
</div>

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