<?php
require_once 'client-session.php';
requireClientLogin();

$project_id = intval($_GET['id'] ?? 0);

if (!$project_id) {
    header('Location: projects-list.php');
    exit;
}

$pdo = getClientDBConnection();

// Get project details
$stmt = $pdo->prepare("
    SELECT * FROM projects 
    WHERE id = ? AND client_id = ?
");
$stmt->execute([$project_id, $_SESSION['client_id']]);
$project = $stmt->fetch();

if (!$project) {
    header('Location: projects-list.php');
    exit;
}

// ===== PROJECT COST CALCULATIONS =====
// Load pricing from company_settings
$pricing = [
    'base_sample' => 0, 'base_incentive' => 0,
    'incr_sample' => 0, 'incr_incentive' => 0,
    'usd_factor' => 0, 'eur_factor' => 0,
];
$client_currency = 'INR';
$currency_symbol = '₹';

try {
    // Get client currency
    $stmt = $pdo->prepare("SELECT currency FROM clients WHERE id = ?");
    $stmt->execute([$_SESSION['client_id']]);
    $cRow = $stmt->fetch();
    if ($cRow && !empty($cRow['currency'])) {
        $client_currency = $cRow['currency'];
        if ($client_currency === 'USD') $currency_symbol = '$';
        elseif ($client_currency === 'EUR') $currency_symbol = '€';
    }
    
    // Load pricing config
    $stmt = $pdo->query("SELECT setting_key, setting_value FROM company_settings WHERE setting_key LIKE 'pricing_%'");
    while ($row = $stmt->fetch()) {
        switch ($row['setting_key']) {
            case 'pricing_base_sample_cost': $pricing['base_sample'] = (float)$row['setting_value']; break;
            case 'pricing_base_incentive': $pricing['base_incentive'] = (float)$row['setting_value']; break;
            case 'pricing_loi_increment_sample': $pricing['incr_sample'] = (float)$row['setting_value']; break;
            case 'pricing_loi_increment_incentive': $pricing['incr_incentive'] = (float)$row['setting_value']; break;
            case 'pricing_usd_factor': $pricing['usd_factor'] = (float)$row['setting_value']; break;
            case 'pricing_eur_factor': $pricing['eur_factor'] = (float)$row['setting_value']; break;
        }
    }
} catch (Exception $e) {
    error_log("Pricing load error: " . $e->getMessage());
}

// Pricing formula: extraMin = max(0, LOI - 5)
// sample_cost_per = base_sample + (extraMin * incr_sample)
// incentive_per   = base_incentive + (extraMin * incr_incentive)
function calcCosts($loi_minutes, $sample_count, $pricing, $client_currency) {
    $extraMin = max(0, $loi_minutes - 5);
    $sampleCostINR = $pricing['base_sample'] + ($extraMin * $pricing['incr_sample']);
    $incentiveINR = $pricing['base_incentive'] + ($extraMin * $pricing['incr_incentive']);
    
    // Currency conversion
    $sampleCost = $sampleCostINR;
    $incentive = $incentiveINR;
    if ($client_currency === 'USD') {
        $factor = 1 + $pricing['usd_factor'] / 100;
        $sampleCost = $sampleCostINR * $factor;
        $incentive = $incentiveINR * $factor;
    } elseif ($client_currency === 'EUR') {
        $factor = 1 + $pricing['eur_factor'] / 100;
        $sampleCost = $sampleCostINR * $factor;
        $incentive = $incentiveINR * $factor;
    }
    
    $totalPerSample = $sampleCost + $incentive;
    return [
        'sample_per' => $sampleCost,
        'incentive_per' => $incentive,
        'total_per' => $totalPerSample,
        'sample_total' => $sampleCost * $sample_count,
        'incentive_total' => $incentive * $sample_count,
        'total' => $totalPerSample * $sample_count,
        'loi' => $loi_minutes,
        'sample_count' => $sample_count,
    ];
}

// 1. ESTIMATED COST (project's eloi + sample_size)
$estCost = calcCosts($project['eloi'], $project['sample_size'], $pricing, $client_currency);

// 2. ACTUAL COST (avg LOI of valid completes + valid complete count)
// Valid = status='complete' AND quality_flag='valid' (excludes speedster, ip_duplicate, client_flagged)
$actualLoi = 0;
$actualSample = 0;
$actualCost = null;
$loiFallback = false;
try {
    $stmt = $pdo->prepare("
        SELECT 
            COUNT(*) as valid_completes,
            AVG(actual_loi_seconds) as avg_loi_seconds,
            SUM(CASE WHEN actual_loi_seconds IS NOT NULL THEN 1 ELSE 0 END) as with_loi_count
        FROM survey_urls 
        WHERE project_id = ? 
          AND status = 'complete' 
          AND quality_flag = 'valid'
    ");
    $stmt->execute([$project['project_id']]);
    $actStats = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($actStats && $actStats['valid_completes'] > 0) {
        $actualSample = (int)$actStats['valid_completes'];
        if ($actStats['with_loi_count'] > 0 && $actStats['avg_loi_seconds'] > 0) {
            // Use actual average LOI from tracked completes
            $actualLoi = round($actStats['avg_loi_seconds'] / 60, 1);
        } else {
            // No LOI data (pre-tracking completes) — fall back to project ELOI
            $actualLoi = (float)$project['eloi'];
            $loiFallback = true;
        }
        $actualCost = calcCosts($actualLoi, $actualSample, $pricing, $client_currency);
    }
    
    // Also get rejected count separately for display
    $stmt2 = $pdo->prepare("
        SELECT COUNT(*) as cnt FROM survey_urls 
        WHERE project_id = ? AND status = 'complete' AND quality_flag != 'valid'
    ");
    $stmt2->execute([$project['project_id']]);
    $rejRow = $stmt2->fetch();
    $rejectedCount = $rejRow ? (int)$rejRow['cnt'] : 0;
} catch (Exception $e) {
    error_log("Actual cost calc error: " . $e->getMessage());
}

$isClosed = ($project['status'] === 'Closed');
$hasPricing = ($pricing['base_sample'] > 0 || $pricing['base_incentive'] > 0);

// Fetch selections for this project
try {
    $stmt = $pdo->prepare("
        SELECT ps.*, 
               COUNT(DISTINCT sm.user_id) as actual_selected,
               c.company_name as created_by_name,
               SUM(CASE WHEN sm.sample_status = 'pending' THEN 1 ELSE 0 END) as cnt_pending,
               SUM(CASE WHEN sm.sample_status = 'complete' THEN 1 ELSE 0 END) as cnt_complete,
               SUM(CASE WHEN sm.sample_status = 'screen_out' THEN 1 ELSE 0 END) as cnt_screen_out,
               SUM(CASE WHEN sm.sample_status = 'quota_full' THEN 1 ELSE 0 END) as cnt_quota_full,
               SUM(CASE WHEN sm.sample_status = 'over_quota' THEN 1 ELSE 0 END) as cnt_over_quota
        FROM project_selections ps
        LEFT JOIN selection_members sm ON ps.id = sm.selection_id
        LEFT JOIN clients c ON ps.created_by = c.id
        WHERE ps.project_id = ? AND ps.client_id = ?
        GROUP BY ps.id
        ORDER BY ps.created_at DESC
    ");
    $stmt->execute([$project_id, $_SESSION['client_id']]);
    $selections = $stmt->fetchAll();
    
    // Get count of URLs sent per selection (via sent_to_user_id matching selection_members)
    $selectionUrlCounts = [];
    $selectionLoiStats = [];
    $projectLoiStats = ['avg_loi' => 0, 'min_loi' => 0, 'max_loi' => 0, 'total_completes' => 0, 'speedsters' => 0, 'ip_dups' => 0];
    if (!empty($selections)) {
        $selIds = array_column($selections, 'id');
        $placeholders = implode(',', array_fill(0, count($selIds), '?'));
        $stmt = $pdo->prepare("
            SELECT sm.selection_id,
                   COUNT(DISTINCT su.id) as urls_sent,
                   SUM(CASE WHEN su.status = 'complete' THEN 1 ELSE 0 END) as urls_complete,
                   SUM(CASE WHEN su.status = 'partial' THEN 1 ELSE 0 END) as urls_partial,
                   SUM(CASE WHEN su.status IN ('earlyscreenout','latescreenout') THEN 1 ELSE 0 END) as urls_screenout,
                   SUM(CASE WHEN su.status = 'timeout' THEN 1 ELSE 0 END) as urls_timeout,
                   SUM(CASE WHEN su.status = 'quotafull' THEN 1 ELSE 0 END) as urls_quotafull
            FROM selection_members sm
            INNER JOIN survey_urls su ON su.sent_to_user_id = sm.user_id AND su.project_id = ?
            WHERE sm.selection_id IN ($placeholders)
            GROUP BY sm.selection_id
        ");
        $stmt->execute(array_merge([$project['project_id']], $selIds));
        foreach ($stmt->fetchAll() as $row) {
            $selectionUrlCounts[$row['selection_id']] = $row;
        }
        
        // LOI stats per selection
        $stmt = $pdo->prepare("
            SELECT sm.selection_id,
                   AVG(CASE WHEN su.status = 'complete' AND su.actual_loi_seconds IS NOT NULL THEN su.actual_loi_seconds END) as avg_loi,
                   MIN(CASE WHEN su.status = 'complete' AND su.actual_loi_seconds IS NOT NULL THEN su.actual_loi_seconds END) as min_loi,
                   MAX(CASE WHEN su.status = 'complete' AND su.actual_loi_seconds IS NOT NULL THEN su.actual_loi_seconds END) as max_loi,
                   SUM(CASE WHEN su.quality_flag = 'speedster' THEN 1 ELSE 0 END) as speedsters,
                   SUM(CASE WHEN su.quality_flag = 'ip_duplicate' THEN 1 ELSE 0 END) as ip_dups
            FROM selection_members sm
            INNER JOIN survey_urls su ON su.sent_to_user_id = sm.user_id AND su.project_id = ?
            WHERE sm.selection_id IN ($placeholders)
            GROUP BY sm.selection_id
        ");
        $stmt->execute(array_merge([$project['project_id']], $selIds));
        foreach ($stmt->fetchAll() as $row) {
            $selectionLoiStats[$row['selection_id']] = $row;
        }
        
        // Project-wide LOI stats
        $stmt = $pdo->prepare("
            SELECT 
                AVG(CASE WHEN status = 'complete' AND actual_loi_seconds IS NOT NULL THEN actual_loi_seconds END) as avg_loi,
                MIN(CASE WHEN status = 'complete' AND actual_loi_seconds IS NOT NULL THEN actual_loi_seconds END) as min_loi,
                MAX(CASE WHEN status = 'complete' AND actual_loi_seconds IS NOT NULL THEN actual_loi_seconds END) as max_loi,
                SUM(CASE WHEN status = 'complete' THEN 1 ELSE 0 END) as total_completes,
                SUM(CASE WHEN quality_flag = 'speedster' THEN 1 ELSE 0 END) as speedsters,
                SUM(CASE WHEN quality_flag = 'ip_duplicate' THEN 1 ELSE 0 END) as ip_dups
            FROM survey_urls
            WHERE project_id = ?
        ");
        $stmt->execute([$project['project_id']]);
        $pStats = $stmt->fetch(PDO::FETCH_ASSOC);
        if ($pStats) $projectLoiStats = $pStats;
    }
} catch (Exception $e) {
    error_log("Selections fetch error: " . $e->getMessage());
    $selections = [];
    $selectionUrlCounts = [];
}

$page_title = 'View Project';
$is_live = $project['status'] === 'Live';

// Status colors
$status_colors = [
    'Created' => '#059669',
    'Targeted' => '#ffc107',
    'Live' => '#28a745',
    'On hold' => '#dc2626',
    'Closed' => '#666'
];
$status_color = $status_colors[$project['status']] ?? '#666';

// Define redirect statuses
$redirect_statuses = [
    'complete' => ['name' => 'Complete', 'color' => '#28a745'],
    'partial' => ['name' => 'Partial Complete', 'color' => '#059669'],
    'earlyscreenout' => ['name' => 'Early Screen Out', 'color' => '#dc2626'],
    'latescreenout' => ['name' => 'Late Screen Out', 'color' => '#ffc107'],
    'timeout' => ['name' => 'Timed Out', 'color' => '#666'],
    'quotafull' => ['name' => 'Quota Full', 'color' => '#ff6b6b']
];

$base_url = 'https://relevantreflex.com/r/';

include 'client-portal-header.php';
?>

<style>
/* Main container */
.view-project-container {
    max-width: 1400px;
    margin: 0 auto;
    padding: 0 20px;
}

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

.project-title-row {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 16px;
}

.project-title-row h1 {
    margin: 0;
    font-size: 28px;
    color: #1a1a1a;
}

.project-actions {
    display: flex;
    gap: 12px;
}

.btn {
    padding: 10px 20px;
    border-radius: 8px;
    font-size: 14px;
    font-weight: 600;
    text-decoration: none;
    border: none;
    cursor: pointer;
    transition: all 0.2s;
    display: inline-block;
}

.btn-primary {
    background: #059669;
    color: white;
}

.btn-primary:hover {
    background: #047857;
}

.btn-secondary {
    background: #6b7280;
    color: white;
}

.btn-secondary:hover {
    background: #4b5563;
}

.btn-add {
    background: #059669;
    color: white;
    padding: 8px 16px;
    border-radius: 6px;
    text-decoration: none;
    font-size: 14px;
    font-weight: 600;
    transition: all 0.2s;
}

.btn-add:hover {
    background: #047857;
}

.project-meta {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 16px;
    padding-top: 16px;
    border-top: 1px solid #e5e7eb;
}

.meta-item {
    display: flex;
    flex-direction: column;
    gap: 4px;
}

.meta-label {
    font-size: 12px;
    color: #6b7280;
    text-transform: uppercase;
    font-weight: 600;
}

.meta-value {
    font-size: 15px;
    color: #1a1a1a;
    font-weight: 500;
}

.status-badge {
    display: inline-block;
    padding: 4px 12px;
    border-radius: 12px;
    font-size: 13px;
    font-weight: 600;
    color: white;
}

/* Section styling */
.section {
    background: white;
    padding: 24px;
    border-radius: 12px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
    margin-bottom: 24px;
}

.section-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 20px;
    padding-bottom: 16px;
    border-bottom: 2px solid #e5e7eb;
}

.section-title {
    font-size: 20px;
    font-weight: 600;
    color: #1a1a1a;
    margin: 0;
}

/* Redirect URLs Grid */
.urls-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(350px, 1fr));
    gap: 16px;
}

.url-item {
    padding: 12px;
    background: #f9fafb;
    border-radius: 8px;
    border: 1px solid #e5e7eb;
}

.url-label {
    font-size: 12px;
    font-weight: 600;
    color: #6b7280;
    margin-bottom: 6px;
    display: flex;
    align-items: center;
    gap: 6px;
}

.url-value {
    display: flex;
    align-items: center;
    gap: 8px;
}

.url-text {
    font-size: 13px;
    color: #1a1a1a;
    font-family: 'Courier New', monospace;
    flex: 1;
    overflow: hidden;
    text-overflow: ellipsis;
    white-space: nowrap;
}

.copy-btn {
    padding: 4px 8px;
    background: #059669;
    color: white;
    border: none;
    border-radius: 4px;
    font-size: 11px;
    cursor: pointer;
    white-space: nowrap;
}

.copy-btn:hover {
    background: #047857;
}

/* Selections Table */
.selections-table-container {
    overflow-x: auto;
}

.selections-table {
    width: 100%;
    border-collapse: collapse;
    font-size: 12px;
}

.selections-table thead {
    background: #f9fafb;
    border-bottom: 2px solid #e5e7eb;
}

.selections-table th {
    padding: 6px 5px;
    text-align: left;
    font-weight: 600;
    color: #374151;
    font-size: 10px;
    text-transform: uppercase;
    letter-spacing: 0.3px;
    white-space: nowrap;
}

.selections-table tbody tr {
    border-bottom: 1px solid #e5e7eb;
    transition: background 0.2s;
}

.selections-table tbody tr:hover {
    background: #f9fafb;
}

.selections-table td {
    padding: 6px 5px;
    color: #1a1a1a;
}

.selection-id-cell {
    font-family: 'Courier New', monospace;
    font-weight: 600;
    color: #059669;
    font-size: 11px;
}

.selection-name-cell {
    font-weight: 500;
    max-width: 100px;
    overflow: hidden;
    text-overflow: ellipsis;
    white-space: nowrap;
}

.selection-status {
    display: inline-block;
    padding: 2px 7px;
    border-radius: 12px;
    font-size: 10px;
    font-weight: 600;
    text-transform: capitalize;
    white-space: nowrap;
}

.status-draft {
    background: #fef3c7;
    color: #92400e;
}

.status-launched {
    background: #d1fae5;
    color: #065f46;
}

.status-paused {
    background: #fee2e2;
    color: #991b1b;
}

.status-closed {
    background: #e5e7eb;
    color: #374151;
}

.selection-stats {
    font-size: 11px;
    color: #6b7280;
    white-space: nowrap;
}

.selection-actions {
    display: flex;
    gap: 4px;
}

.action-btn {
    padding: 3px 7px;
    border: none;
    border-radius: 6px;
    font-size: 11px;
    font-weight: 600;
    cursor: pointer;
    text-decoration: none;
    display: inline-block;
    transition: all 0.2s;
    white-space: nowrap;
}

.action-view {
    background: #e0f2fe;
    color: #0369a1;
}

.action-view:hover {
    background: #bae6fd;
}

.action-edit {
    background: #fef3c7;
    color: #92400e;
}

.action-edit:hover {
    background: #fde68a;
}

.action-delete {
    background: #fee2e2;
    color: #991b1b;
}

.action-delete:hover {
    background: #fecaca;
}

.action-btn:disabled {
    opacity: 0.5;
    cursor: not-allowed;
}

/* Table for survey URLs */
.table-container {
    overflow-x: auto;
}

.data-table {
    width: 100%;
    border-collapse: collapse;
    font-size: 14px;
}

.data-table thead {
    background: #f9fafb;
    border-bottom: 2px solid #e5e7eb;
}

.data-table th {
    padding: 12px;
    text-align: left;
    font-weight: 600;
    color: #374151;
    font-size: 12px;
    text-transform: uppercase;
}

.data-table tbody tr {
    border-bottom: 1px solid #e5e7eb;
    transition: background 0.2s;
}

.data-table tbody tr:hover {
    background: #f9fafb;
}

.data-table td {
    padding: 12px;
}

.badge {
    display: inline-block;
    padding: 4px 10px;
    border-radius: 12px;
    font-size: 12px;
    font-weight: 600;
}

.badge-info {
    background: #dbeafe;
    color: #1e40af;
}

/* Status count pills */
.status-counts {
    display: flex;
    flex-wrap: wrap;
    gap: 6px;
}

.status-pill {
    display: inline-flex;
    align-items: center;
    gap: 3px;
    padding: 1px 5px;
    border-radius: 10px;
    font-size: 10px;
    font-weight: 600;
    white-space: nowrap;
}

.pill-available { background: #f3f4f6; color: #6b7280; }
.pill-sent { background: #dbeafe; color: #1e40af; }
.pill-clicked { background: #fef3c7; color: #92400e; }
.pill-complete { background: #d1fae5; color: #065f46; }
.pill-partial { background: #e0f2fe; color: #0369a1; }
.pill-earlyscreenout { background: #fee2e2; color: #991b1b; }
.pill-latescreenout { background: #fef3c7; color: #854d0e; }
.pill-timeout { background: #e5e7eb; color: #374151; }
.pill-quotafull { background: #fce7f3; color: #9d174d; }

/* Sample status pills (selection_members) */
.pill-pending { background: #fef3c7; color: #92400e; }
.pill-screen_out { background: #fee2e2; color: #991b1b; }
.pill-over_quota { background: #f3e8ff; color: #6b21a8; }

.sample-status-row {
    display: flex;
    flex-wrap: wrap;
    gap: 3px;
    margin-top: 2px;
}

/* Export Section */
.export-section {
    background: #f8fafc;
    border: 1px solid #e2e8f0;
    border-radius: 10px;
    padding: 20px;
    margin-top: 16px;
}
.export-section h3 {
    margin: 0 0 16px 0;
    font-size: 16px;
    color: #1e293b;
}
.export-controls {
    display: flex;
    flex-wrap: wrap;
    gap: 12px;
    align-items: flex-end;
}
.export-controls .control-group {
    display: flex;
    flex-direction: column;
    gap: 4px;
}
.export-controls label {
    font-size: 12px;
    font-weight: 600;
    color: #475569;
}
.export-controls select {
    padding: 8px 12px;
    border: 1px solid #cbd5e1;
    border-radius: 6px;
    font-size: 13px;
    background: white;
    min-width: 180px;
}
.btn-export {
    display: inline-flex;
    align-items: center;
    gap: 6px;
    padding: 8px 20px;
    background: #059669;
    color: white;
    border: none;
    border-radius: 6px;
    font-size: 13px;
    font-weight: 600;
    cursor: pointer;
    text-decoration: none;
    transition: background 0.2s;
}
.btn-export:hover { background: #047857; }
.btn-export-complete {
    background: #059669;
}
.btn-export-complete:hover { background: #047857; }

/* Quality flag badges */
.quality-badge { 
    display: inline-block; padding: 2px 6px; border-radius: 4px; 
    font-size: 10px; font-weight: 700; text-transform: uppercase; 
}
.badge-speedster { background: #fef3c7; color: #92400e; }
.badge-ip-dup { background: #fce7f3; color: #9d174d; }
.badge-flagged { background: #fee2e2; color: #991b1b; }

/* LOI stats */
.loi-stat { font-size: 11px; color: #475569; }
.loi-stat strong { color: #1e293b; }
.loi-warning { color: #dc2626; }
.selection-loi-row { margin-top: 6px; padding-top: 6px; border-top: 1px solid #f1f5f9; }

/* Empty state */
.empty-state {
    text-align: center;
    padding: 60px 20px;
}

.empty-state-icon {
    font-size: 64px;
    margin-bottom: 16px;
    opacity: 0.3;
}

.empty-state-title {
    font-size: 18px;
    font-weight: 600;
    color: #374151;
    margin-bottom: 8px;
}

.empty-state-description {
    font-size: 14px;
    color: #6b7280;
    margin-bottom: 24px;
}
/* ===== PROJECT COST CARDS ===== */
.cost-banner {
    display: grid;
    grid-template-columns: 1fr 1fr;
    gap: 20px;
    margin-bottom: 24px;
}
@media (max-width: 768px) {
    .cost-banner { grid-template-columns: 1fr; }
}
.cost-card {
    background: white;
    border-radius: 12px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
    overflow: hidden;
    border: 2px solid #e5e7eb;
    position: relative;
}
.cost-card.card-estimate {
    border-color: #bfdbfe;
}
.cost-card.card-actual {
    border-color: #6ee7b7;
}
.cost-card.card-primary {
    border-color: #059669;
    box-shadow: 0 4px 16px rgba(5,150,105,0.15);
}
.cost-card.card-dimmed {
    opacity: 0.6;
}
.cost-card-header {
    padding: 14px 20px;
    display: flex;
    align-items: center;
    justify-content: space-between;
    gap: 8px;
}
.cost-card.card-estimate .cost-card-header {
    background: #eff6ff;
}
.cost-card.card-actual .cost-card-header,
.cost-card.card-primary .cost-card-header {
    background: #ecfdf5;
}
.cost-card.card-primary .cost-card-header {
    background: #059669;
}
.cost-card-title {
    font-size: 13px;
    font-weight: 700;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    color: #334155;
    display: flex;
    align-items: center;
    gap: 6px;
}
.cost-card.card-primary .cost-card-title {
    color: #fff;
}
.cost-card-badge {
    font-size: 10px;
    font-weight: 700;
    padding: 3px 8px;
    border-radius: 4px;
    text-transform: uppercase;
    letter-spacing: 0.3px;
}
.badge-estimate {
    background: #dbeafe;
    color: #1e40af;
}
.badge-live {
    background: #d1fae5;
    color: #065f46;
    animation: pulse-badge 2s ease-in-out infinite;
}
.badge-final {
    background: #065f46;
    color: #fff;
}
@keyframes pulse-badge {
    0%, 100% { opacity: 1; }
    50% { opacity: 0.6; }
}
.cost-card-body {
    padding: 20px;
}
.cost-grand-total {
    font-size: 28px;
    font-weight: 800;
    color: #0f172a;
    margin-bottom: 16px;
    letter-spacing: -0.5px;
}
.cost-card.card-primary .cost-grand-total {
    color: #059669;
}
.cost-breakdown-grid {
    display: grid;
    grid-template-columns: 1fr 1fr;
    gap: 10px;
}
.cost-breakdown-item {
    background: #f8fafc;
    border: 1px solid #e2e8f0;
    border-radius: 8px;
    padding: 10px 14px;
}
.cost-breakdown-label {
    font-size: 11px;
    color: #64748b;
    font-weight: 600;
    text-transform: uppercase;
    letter-spacing: 0.3px;
    margin-bottom: 4px;
}
.cost-breakdown-value {
    font-size: 16px;
    font-weight: 700;
    color: #0f172a;
}
.cost-breakdown-detail {
    font-size: 11px;
    color: #94a3b8;
    margin-top: 2px;
}
.cost-meta {
    display: flex;
    gap: 16px;
    margin-top: 14px;
    padding-top: 12px;
    border-top: 1px solid #e2e8f0;
    font-size: 12px;
    color: #64748b;
    flex-wrap: wrap;
}
.cost-meta strong {
    color: #334155;
}
.cost-no-data {
    text-align: center;
    padding: 20px;
    color: #94a3b8;
    font-size: 13px;
}
.cost-rejected-note {
    margin-top: 10px;
    padding: 8px 12px;
    background: #fef2f2;
    border: 1px solid #fecaca;
    border-radius: 6px;
    font-size: 11px;
    color: #991b1b;
}
</style>

<div class="view-project-container">
    <?php if (!empty($_SESSION['success'])): ?>
    <div style="padding: 12px 16px; background: #f0fdf4; color: #065f46; border: 1px solid #bbf7d0; border-radius: 8px; margin-bottom: 16px;">
        <?php echo htmlspecialchars($_SESSION['success']); unset($_SESSION['success']); ?>
    </div>
    <?php endif; ?>
    <?php if (!empty($_SESSION['error'])): ?>
    <div style="padding: 12px 16px; background: #fef2f2; color: #991b1b; border: 1px solid #fecaca; border-radius: 8px; margin-bottom: 16px;">
        <?php echo htmlspecialchars($_SESSION['error']); unset($_SESSION['error']); ?>
    </div>
    <?php endif; ?>
    <?php if (!empty($_SESSION['info'])): ?>
    <div style="padding: 12px 16px; background: #eff6ff; color: #1e40af; border: 1px solid #bfdbfe; border-radius: 8px; margin-bottom: 16px;">
        <?php echo htmlspecialchars($_SESSION['info']); unset($_SESSION['info']); ?>
    </div>
    <?php endif; ?>
    <!-- Project Header -->
    <div class="project-header">
        <div class="project-title-row">
            <h1><?php echo htmlspecialchars($project['project_name']); ?></h1>
            <div class="project-actions">
                <?php if ($project['status'] !== 'Closed'): ?>
                <a href="edit-project.php?id=<?php echo $project_id; ?>" class="btn btn-secondary">Edit Project</a>
                <?php endif; ?>
                <?php if (in_array($project['status'], ['Live', 'On hold', 'Targeted', 'Created'])): ?>
                <a href="close-project.php?id=<?php echo $project_id; ?>" class="btn btn-secondary" style="background: #dc2626; color: white; border-color: #dc2626;">Close Project</a>
                <?php endif; ?>
                <?php if ($project['status'] === 'Closed'): ?>
                <span class="status-badge" style="background: #475569; color: white;">Project Closed</span>
                <?php endif; ?>
                <?php if (isset($project['closure_status']) && $project['closure_status'] === 'pending_review'): ?>
                <span class="status-badge" style="background: #f59e0b; color: white;">Closure Pending Admin Review</span>
                <?php endif; ?>
                <a href="projects-list.php" class="btn btn-secondary">Back to Projects</a>
            </div>
        </div>
        
        <div class="project-meta">
            <div class="meta-item">
                <span class="meta-label">Status</span>
                <span class="meta-value">
                    <span class="status-badge" style="background-color: <?php echo $status_color; ?>;">
                        <?php echo $project['status']; ?>
                    </span>
                </span>
            </div>
            <div class="meta-item">
                <span class="meta-label">Project ID</span>
                <span class="meta-value"><?php echo $project['project_id']; ?></span>
            </div>
            <div class="meta-item">
                <span class="meta-label">Country</span>
                <span class="meta-value"><?php echo htmlspecialchars($project['country']); ?></span>
            </div>
            <div class="meta-item">
                <span class="meta-label">Created</span>
                <span class="meta-value"><?php echo date('M d, Y', strtotime($project['created_at'])); ?></span>
            </div>
        </div>
    </div>

    <!-- ===== PROJECT COST CARDS ===== -->
    <?php if ($hasPricing): ?>
    <div class="cost-banner">
        <!-- ESTIMATED COST -->
        <div class="cost-card card-estimate <?php echo $isClosed ? 'card-dimmed' : ''; ?>">
            <div class="cost-card-header">
                <span class="cost-card-title">&#128202; Estimated Project Cost</span>
                <span class="cost-card-badge badge-estimate">Estimate</span>
            </div>
            <div class="cost-card-body">
                <div class="cost-grand-total">
                    <?php echo $currency_symbol . number_format($estCost['total'], 2); ?>
                </div>
                <div class="cost-breakdown-grid">
                    <div class="cost-breakdown-item">
                        <div class="cost-breakdown-label">Sample Cost</div>
                        <div class="cost-breakdown-value"><?php echo $currency_symbol . number_format($estCost['sample_total'], 2); ?></div>
                        <div class="cost-breakdown-detail"><?php echo $currency_symbol . number_format($estCost['sample_per'], 2); ?> &times; <?php echo number_format($estCost['sample_count']); ?> samples</div>
                    </div>
                    <div class="cost-breakdown-item">
                        <div class="cost-breakdown-label">Incentives</div>
                        <div class="cost-breakdown-value"><?php echo $currency_symbol . number_format($estCost['incentive_total'], 2); ?></div>
                        <div class="cost-breakdown-detail"><?php echo $currency_symbol . number_format($estCost['incentive_per'], 2); ?> &times; <?php echo number_format($estCost['sample_count']); ?> samples</div>
                    </div>
                </div>
                <div class="cost-meta">
                    <span><strong>ELOI:</strong> <?php echo $project['eloi']; ?> min</span>
                    <span><strong>Sample Size:</strong> <?php echo number_format($project['sample_size']); ?></span>
                    <span><strong>Rate/Sample:</strong> <?php echo $currency_symbol . number_format($estCost['total_per'], 2); ?></span>
                </div>
            </div>
        </div>

        <!-- ACTUAL COST -->
        <div class="cost-card <?php echo $isClosed ? 'card-primary' : 'card-actual'; ?>">
            <div class="cost-card-header">
                <span class="cost-card-title"><?php echo $isClosed ? '&#9989;' : '&#9889;'; ?> Actual Project Cost</span>
                <?php if ($isClosed): ?>
                    <span class="cost-card-badge badge-final">Final</span>
                <?php else: ?>
                    <span class="cost-card-badge badge-live">Live</span>
                <?php endif; ?>
            </div>
            <div class="cost-card-body">
                <?php if ($actualCost): ?>
                    <div class="cost-grand-total">
                        <?php echo $currency_symbol . number_format($actualCost['total'], 2); ?>
                    </div>
                    <div class="cost-breakdown-grid">
                        <div class="cost-breakdown-item">
                            <div class="cost-breakdown-label">Sample Cost</div>
                            <div class="cost-breakdown-value"><?php echo $currency_symbol . number_format($actualCost['sample_total'], 2); ?></div>
                            <div class="cost-breakdown-detail"><?php echo $currency_symbol . number_format($actualCost['sample_per'], 2); ?> &times; <?php echo number_format($actualCost['sample_count']); ?> valid completes</div>
                        </div>
                        <div class="cost-breakdown-item">
                            <div class="cost-breakdown-label">Incentives</div>
                            <div class="cost-breakdown-value"><?php echo $currency_symbol . number_format($actualCost['incentive_total'], 2); ?></div>
                            <div class="cost-breakdown-detail"><?php echo $currency_symbol . number_format($actualCost['incentive_per'], 2); ?> &times; <?php echo number_format($actualCost['sample_count']); ?> valid completes</div>
                        </div>
                    </div>
                    <div class="cost-meta">
                        <span><strong><?php echo $loiFallback ? 'LOI (est):' : 'Avg LOI:'; ?></strong> <?php echo $actualCost['loi']; ?> min<?php if($loiFallback):?> <span style="font-size:10px;color:#f59e0b" title="LOI data not available for these completes — using project ELOI">&#9888; ELOI used</span><?php endif;?></span>
                        <span><strong>Valid Completes:</strong> <?php echo number_format($actualCost['sample_count']); ?></span>
                        <span><strong>Rate/Sample:</strong> <?php echo $currency_symbol . number_format($actualCost['total_per'], 2); ?></span>
                        <?php if ($isClosed): ?>
                            <span><strong>Closed:</strong> <?php echo date('M d, Y', strtotime($project['closed_at'])); ?></span>
                        <?php endif; ?>
                    </div>
                    <?php if ($rejectedCount > 0): ?>
                        <div class="cost-rejected-note">
                            <strong>&#9888; <?php echo $rejectedCount; ?> interview<?php echo $rejectedCount > 1 ? 's' : ''; ?> excluded</strong> from cost calculation (flagged as speedster, IP duplicate, or client-rejected).
                        </div>
                    <?php endif; ?>
                <?php else: ?>
                    <div class="cost-no-data">
                        <div style="font-size: 32px; margin-bottom: 8px;">&#128202;</div>
                        No completed interviews yet. Actual cost will appear once respondents complete the survey.
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>
    <?php endif; ?>

    <!-- Redirect URLs Section -->
    <div class="section">
        <div class="section-header">
            <h2 class="section-title">&#128279; Redirect URLs</h2>
        </div>
        
        <div class="urls-grid">
            <?php foreach ($redirect_statuses as $code => $info): ?>
            <div class="url-item">
                <div class="url-label">
                    <span style="color: <?php echo $info['color']; ?>;">&#9679;</span>
                    <?php echo $info['name']; ?>
                </div>
                <div class="url-value">
                    <span class="url-text"><?php echo $base_url . $project['project_id'] . '/' . $code; ?></span>
                    <button class="copy-btn" onclick="copyToClipboard('<?php echo $base_url . $project['project_id'] . '/' . $code; ?>')">
                        Copy
                    </button>
                </div>
            </div>
            <?php endforeach; ?>
        </div>
    </div>

    <!-- Selections Section -->
    <div class="section">
        <div class="section-header">
            <h2 class="section-title">&#128101; Panel Member Selections (<?php echo count($selections); ?>)</h2>
            <a href="create-selection.php?project_id=<?php echo $project_id; ?>" class="btn-primary">
                + Create Selection
            </a>
        </div>
        
        <?php if (floatval($projectLoiStats['total_completes']) > 0): ?>
        <div style="display: flex; flex-wrap: wrap; gap: 12px; margin-bottom: 12px; padding: 10px 14px; background: #f0fdf4; border: 1px solid #bbf7d0; border-radius: 8px; font-size: 12px;">
            <div class="loi-stat">
                <strong>Project aLOI:</strong> 
                <?php echo round(floatval($projectLoiStats['avg_loi']) / 60, 1); ?>min avg
                (<?php echo round(floatval($projectLoiStats['min_loi']) / 60, 1); ?>&ndash;<?php echo round(floatval($projectLoiStats['max_loi']) / 60, 1); ?>min range)
                &nbsp;|&nbsp; <strong>ELOI:</strong> <?php echo $project['eloi']; ?>min
                &nbsp;|&nbsp; <strong>Speedster Threshold:</strong> 
                <?php 
                $thresholdPct = floatval($project['speedster_threshold_pct'] ?? 33.33);
                $thresholdMin = round($project['eloi'] * ($thresholdPct / 100), 1);
                ?>
                &lt;<?php echo $thresholdMin; ?>min (<?php echo $thresholdPct; ?>% of ELOI = <?php echo $project['eloi']; ?>min)
            </div>
            <div class="loi-stat">
                <strong>Completes:</strong> <?php echo intval($projectLoiStats['total_completes']); ?>
                <?php if (intval($projectLoiStats['speedsters']) > 0): ?>
                    &nbsp;|&nbsp; <span class="loi-warning"><strong>&#9889; <?php echo intval($projectLoiStats['speedsters']); ?> Possible Speedster<?php echo intval($projectLoiStats['speedsters']) > 1 ? 's' : ''; ?></strong></span>
                <?php endif; ?>
                <?php if (intval($projectLoiStats['ip_dups']) > 0): ?>
                    &nbsp;|&nbsp; <span class="loi-warning"><strong>&#128279; <?php echo intval($projectLoiStats['ip_dups']); ?> Possible IP Duplication<?php echo intval($projectLoiStats['ip_dups']) > 1 ? 's' : ''; ?></strong></span>
                <?php endif; ?>
            </div>
        </div>
        <?php endif; ?>
        
        <?php if (empty($selections)): ?>
        <div class="empty-state">
            <div class="empty-state-icon">&#128203;</div>
            <div class="empty-state-title">No Selections Created Yet</div>
            <div class="empty-state-description">
                Create your first selection to start recruiting panel members for this project.
            </div>
            <a href="create-selection.php?project_id=<?php echo $project_id; ?>" class="btn btn-primary">
                + Create Your First Selection
            </a>
        </div>
        <?php else: ?>
        <div class="selections-table-container">
            <table class="selections-table">
                <thead>
                    <tr>
                        <th>Selection ID</th>
                        <th>Name</th>
                        <th>Status</th>
                        <th>Required</th>
                        <th>Selected</th>
                        <th>Sample Status</th>
                        <th>URLs Sent</th>
                        <th>Avg LOI</th>
                        <th>Quality Flags</th>
                        <th>Incidence</th>
                        <th>Created</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($selections as $selection): 
                        $urlStats = $selectionUrlCounts[$selection['id']] ?? [];
                        $urlsSent = intval($urlStats['urls_sent'] ?? 0);
                    ?>
                    <tr>
                        <td class="selection-id-cell">
                            <?php echo htmlspecialchars($selection['selection_id'] ?? 'SEL-' . str_pad($selection['id'], 4, '0', STR_PAD_LEFT)); ?>
                        </td>
                        <td class="selection-name-cell">
                            <?php echo htmlspecialchars($selection['selection_name']); ?>
                        </td>
                        <td>
                            <span class="selection-status status-<?php echo strtolower($selection['status']); ?>">
                                <?php echo $selection['status']; ?>
                            </span>
                        </td>
                        <td class="selection-stats"><?php echo number_format($selection['required_samples']); ?></td>
                        <td class="selection-stats"><?php echo number_format($selection['actual_selected']); ?></td>
                        <td>
                            <div class="sample-status-row">
                                <?php if (intval($selection['cnt_pending']) > 0): ?>
                                    <span class="status-pill pill-pending">Pending: <?php echo $selection['cnt_pending']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($selection['cnt_complete']) > 0): ?>
                                    <span class="status-pill pill-complete">Complete: <?php echo $selection['cnt_complete']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($selection['cnt_screen_out']) > 0): ?>
                                    <span class="status-pill pill-screen_out">Screen Out: <?php echo $selection['cnt_screen_out']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($selection['cnt_quota_full']) > 0): ?>
                                    <span class="status-pill pill-quotafull">Quota Full: <?php echo $selection['cnt_quota_full']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($selection['cnt_over_quota']) > 0): ?>
                                    <span class="status-pill pill-over_quota">Over Quota: <?php echo $selection['cnt_over_quota']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($selection['actual_selected']) == 0): ?>
                                    <span style="color: #9ca3af; font-size: 11px;">No members</span>
                                <?php endif; ?>
                            </div>
                        </td>
                        <td>
                            <?php if ($urlsSent > 0): ?>
                            <div class="sample-status-row">
                                <span class="status-pill pill-sent">Sent: <?php echo $urlsSent; ?></span>
                                <?php if (intval($urlStats['urls_complete'] ?? 0) > 0): ?>
                                    <span class="status-pill pill-complete"><?php echo $urlStats['urls_complete']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($urlStats['urls_screenout'] ?? 0) > 0): ?>
                                    <span class="status-pill pill-earlyscreenout">SO: <?php echo $urlStats['urls_screenout']; ?></span>
                                <?php endif; ?>
                                <?php if (intval($urlStats['urls_timeout'] ?? 0) > 0): ?>
                                    <span class="status-pill pill-timeout">TO: <?php echo $urlStats['urls_timeout']; ?></span>
                                <?php endif; ?>
                            </div>
                            <?php else: ?>
                                <span style="color: #9ca3af; font-size: 11px;">None</span>
                            <?php endif; ?>
                        </td>
                        <td class="selection-stats">
                            <?php 
                            $loiStats = $selectionLoiStats[$selection['id']] ?? [];
                            $avgLoi = $loiStats['avg_loi'] ?? null;
                            if ($avgLoi !== null): 
                                $avgLoiMin = round($avgLoi / 60, 1);
                            ?>
                                <span class="loi-stat"><strong><?php echo $avgLoiMin; ?>m</strong></span>
                            <?php else: ?>
                                <span style="color: #9ca3af; font-size: 11px;">-</span>
                            <?php endif; ?>
                        </td>
                        <td>
                            <?php 
                            $speedsters = intval($loiStats['speedsters'] ?? 0);
                            $ipDups = intval($loiStats['ip_dups'] ?? 0);
                            if ($speedsters > 0 || $ipDups > 0): ?>
                            <div class="sample-status-row">
                                <?php if ($speedsters > 0): ?>
                                    <span class="quality-badge badge-speedster">&#9889; <?php echo $speedsters; ?> Speedster<?php echo $speedsters > 1 ? 's' : ''; ?></span>
                                <?php endif; ?>
                                <?php if ($ipDups > 0): ?>
                                    <span class="quality-badge badge-ip-dup">&#128279; <?php echo $ipDups; ?> IP Dup<?php echo $ipDups > 1 ? 's' : ''; ?></span>
                                <?php endif; ?>
                            </div>
                            <?php else: ?>
                                <span style="color: #9ca3af; font-size: 11px;">Clean</span>
                            <?php endif; ?>
                        </td>
                        <td class="selection-stats"><?php echo number_format($selection['estimated_incidence_rate'], 2); ?>%</td>
                        <td class="selection-stats"><?php echo date('M d, Y', strtotime($selection['created_at'])); ?></td>
                        <td>
                            <div class="selection-actions">
                                <a href="view-selection.php?id=<?php echo $selection['id']; ?>" class="action-btn action-view">
                                    View
                                </a>
                                <?php if ($selection['status'] === 'draft'): ?>
                                <a href="create-selection.php?id=<?php echo $selection['id']; ?>" class="action-btn action-edit">
                                    Edit
                                </a>
                                <button onclick="deleteSelection(<?php echo $selection['id']; ?>, '<?php echo htmlspecialchars($selection['selection_name'], ENT_QUOTES); ?>')" 
                                        class="action-btn action-delete">
                                    Delete
                                </button>
                                <?php else: ?>
                                <span class="action-btn action-edit" style="opacity: 0.3; cursor: not-allowed;">Edit</span>
                                <span class="action-btn action-delete" style="opacity: 0.3; cursor: not-allowed;">Delete</span>
                                <?php endif; ?>
                            </div>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
        
        <!-- Export URLs Section -->
        <div class="export-section">
            <h3>&#128229; Export URL Data</h3>
            <form id="exportForm" action="export-url-data.php" method="GET" target="_blank">
                <input type="hidden" name="project_id" value="<?php echo $project['project_id']; ?>">
                <input type="hidden" name="project_db_id" value="<?php echo $project_id; ?>">
                <div class="export-controls">
                    <div class="control-group">
                        <label>Selection</label>
                        <select name="selection_id" id="exportSelection">
                            <option value="all">All Selections</option>
                            <?php foreach ($selections as $sel): ?>
                            <option value="<?php echo $sel['id']; ?>">
                                <?php echo htmlspecialchars($sel['selection_name']); ?>
                            </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="control-group">
                        <label>URL Status</label>
                        <select name="url_status" id="exportStatus">
                            <option value="all">All Statuses</option>
                            <option value="sent">Sent</option>
                            <option value="clicked">Clicked</option>
                            <option value="complete">Complete</option>
                            <option value="partial">Partial</option>
                            <option value="earlyscreenout">Early Screen Out</option>
                            <option value="latescreenout">Late Screen Out</option>
                            <option value="timeout">Timeout</option>
                            <option value="quotafull">Quota Full</option>
                        </select>
                    </div>
                    <button type="submit" class="btn-export">
                        &#128196; Export Filtered CSV
                    </button>
                    <a href="export-url-data.php?project_id=<?php echo urlencode($project['project_id']); ?>&project_db_id=<?php echo $project_id; ?>&mode=complete" 
                       class="btn-export btn-export-complete" target="_blank">
                        &#128203; Export Complete Report
                    </a>
                </div>
            </form>
        </div>
        <?php endif; ?>
    </div>

    <!-- Survey URLs Section -->
    <div class="section">
        <div class="section-header">
            <h2 class="section-title">&#128202; Survey URLs</h2>
            <div style="display: flex; gap: 8px;">
                <a href="export-url-data.php?project_id=<?php echo urlencode($project['project_id']); ?>&project_db_id=<?php echo $project_id; ?>&mode=complete" 
                   class="btn-export btn-export-complete" style="font-size: 12px; padding: 6px 14px;" target="_blank">
                    &#128229; Export All URLs
                </a>
                <a href="manage-survey-urls.php?project_id=<?php echo $project['project_id']; ?>" class="btn-add">
                    + Add URLs
                </a>
            </div>
        </div>
        
        <?php
        // Get URL batches and status counts separately (avoids GROUP BY strict mode issues)
        try {
            // Query 1: Get batches
            $stmt = $pdo->prepare("
                SELECT 
                    batch_number,
                    total_urls,
                    sent_count,
                    upload_type,
                    created_at
                FROM survey_url_batches
                WHERE project_id = ?
                ORDER BY batch_number DESC
            ");
            $stmt->execute([$project['project_id']]);
            $url_batches = $stmt->fetchAll(PDO::FETCH_ASSOC);
            
            // Query 2: Get status counts per batch in one query
            $batch_status_counts = [];
            if (!empty($url_batches)) {
                $stmt = $pdo->prepare("
                    SELECT 
                        batch_number,
                        status,
                        COUNT(*) as cnt
                    FROM survey_urls
                    WHERE project_id = ?
                    GROUP BY batch_number, status
                ");
                $stmt->execute([$project['project_id']]);
                $status_rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
                
                foreach ($status_rows as $row) {
                    $bn = $row['batch_number'];
                    $st = $row['status'];
                    if (!isset($batch_status_counts[$bn])) {
                        $batch_status_counts[$bn] = [];
                    }
                    $batch_status_counts[$bn][$st] = (int)$row['cnt'];
                }
            }
        } catch (Exception $e) {
            $url_batches = [];
            $batch_status_counts = [];
            error_log("Error fetching URL batches: " . $e->getMessage());
        }
        ?>
        
        <?php if (empty($url_batches)): ?>
        <div class="empty-state">
            <div class="empty-state-icon">&#128279;</div>
            <div class="empty-state-title">No Survey URLs Yet</div>
            <div class="empty-state-description">
                Add survey URLs to track panel member responses and manage redirects.
            </div>
            <a href="manage-survey-urls.php?project_id=<?php echo $project['project_id']; ?>" class="btn-add" style="margin-top: 16px; display: inline-block;">
                + Add Your First Batch
            </a>
        </div>
        <?php else: ?>
        <div class="table-container">
            <table class="data-table">
                <thead>
                    <tr>
                        <th>Batch #</th>
                        <th>Type</th>
                        <th>Total</th>
                        <th>Status Breakdown</th>
                        <th>Created</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($url_batches as $batch): ?>
                    <tr>
                        <td>
                            <span style="font-weight: 600; color: #059669;">
                                Batch #<?php echo $batch['batch_number']; ?>
                            </span>
                        </td>
                        <td>
                            <span class="badge badge-info">
                                <?php echo ucfirst($batch['upload_type']); ?>
                            </span>
                        </td>
                        <td style="font-weight: 600;"><?php echo number_format($batch['total_urls']); ?></td>
                        <td>
                            <?php 
                            $bn = $batch['batch_number'];
                            $counts = $batch_status_counts[$bn] ?? [];
                            $all_statuses = [
                                'available' => ['label' => 'Available', 'class' => 'pill-available'],
                                'sent' => ['label' => 'Sent', 'class' => 'pill-sent'],
                                'clicked' => ['label' => 'Clicked', 'class' => 'pill-clicked'],
                                'complete' => ['label' => 'Complete', 'class' => 'pill-complete'],
                                'partial' => ['label' => 'Partial', 'class' => 'pill-partial'],
                                'earlyscreenout' => ['label' => 'Early SO', 'class' => 'pill-earlyscreenout'],
                                'latescreenout' => ['label' => 'Late SO', 'class' => 'pill-latescreenout'],
                                'timeout' => ['label' => 'Timeout', 'class' => 'pill-timeout'],
                                'quotafull' => ['label' => 'Quota Full', 'class' => 'pill-quotafull'],
                            ];
                            ?>
                            <div class="status-counts">
                                <?php foreach ($all_statuses as $status_key => $status_info): ?>
                                    <?php if (isset($counts[$status_key]) && $counts[$status_key] > 0): ?>
                                        <span class="status-pill <?php echo $status_info['class']; ?>">
                                            <?php echo $status_info['label']; ?>: <?php echo $counts[$status_key]; ?>
                                        </span>
                                    <?php endif; ?>
                                <?php endforeach; ?>
                                <?php if (empty($counts)): ?>
                                    <span style="color: #9ca3af; font-size: 12px;">No activity yet</span>
                                <?php endif; ?>
                            </div>
                        </td>
                        <td><?php echo date('M d, Y', strtotime($batch['created_at'])); ?></td>
                        <td>
                            <div class="selection-actions">
                                <a href="view-batch-urls.php?project_id=<?php echo urlencode($project['project_id']); ?>&batch=<?php echo $batch['batch_number']; ?>" 
                                   class="action-btn action-view">View</a>
                                <a href="export-batch-urls.php?project_id=<?php echo urlencode($project['project_id']); ?>&batch=<?php echo $batch['batch_number']; ?>" 
                                   class="action-btn action-edit" target="_blank">Export</a>
                            </div>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
        
        <div style="margin-top: 16px; padding: 12px; background: #f0f9ff; border-left: 4px solid #059669; border-radius: 4px;">
            <p style="margin: 0; font-size: 14px; color: #1e40af;">
                <strong>&#128269; Note:</strong> URLs that remain without a result for over 2 hours are automatically marked as <strong>Timeout</strong>.
            </p>
        </div>
        <?php endif; ?>
    </div>
</div>


<script>
function copyToClipboard(text) {
    navigator.clipboard.writeText(text).then(function() {
        alert('URL copied to clipboard!');
    }, function() {
        alert('Failed to copy URL');
    });
}

function deleteSelection(selectionId, selectionName) {
    if (!confirm('Are you sure you want to delete the selection "' + selectionName + '"?\n\nThis will also remove all assigned members. This action cannot be undone.')) {
        return;
    }
    
    // Send delete request
    fetch('delete-selection.php', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
        },
        body: 'selection_id=' + selectionId
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            alert('Selection deleted successfully!');
            window.location.reload();
        } else {
            alert('Error: ' + (data.message || 'Failed to delete selection'));
        }
    })
    .catch(error => {
        alert('Error: ' + error.message);
    });
}
</script>

<?php include 'client-portal-footer.php'; ?>