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

$page_title = 'Projects';

$success = '';
$error = '';

$pdo = getClientDBConnection();

// Handle delete
if (isset($_GET['delete']) && isset($_GET['id'])) {
    $project_id = intval($_GET['id']);
    
    // Check if project belongs to client and is not Live
    $checkStmt = $pdo->prepare("
        SELECT status FROM projects 
        WHERE id = ? AND client_id = ?
    ");
    $checkStmt->execute([$project_id, $_SESSION['client_id']]);
    $project = $checkStmt->fetch();
    
    if ($project && $project['status'] !== 'Live') {
        $deleteStmt = $pdo->prepare("DELETE FROM projects WHERE id = ?");
        $deleteStmt->execute([$project_id]);
        $success = 'Project deleted successfully.';
    } else {
        $error = 'Cannot delete this project. Live projects cannot be deleted.';
    }
}

// Get filter values
$filter_status = $_GET['status'] ?? '';
$filter_industry = $_GET['industry'] ?? '';
$filter_from_date = $_GET['from_date'] ?? '';
$filter_to_date = $_GET['to_date'] ?? '';
$filter_min_loi = $_GET['min_loi'] ?? '';
$filter_max_loi = $_GET['max_loi'] ?? '';

// Build query with filters
$query = "SELECT * FROM projects WHERE client_id = ?";
$params = [$_SESSION['client_id']];

if ($filter_status) {
    $query .= " AND status = ?";
    $params[] = $filter_status;
}

if ($filter_industry) {
    $query .= " AND industry = ?";
    $params[] = $filter_industry;
}

if ($filter_from_date) {
    $query .= " AND DATE(created_at) >= ?";
    $params[] = $filter_from_date;
}

if ($filter_to_date) {
    $query .= " AND DATE(created_at) <= ?";
    $params[] = $filter_to_date;
}

if ($filter_min_loi) {
    $query .= " AND eloi >= ?";
    $params[] = intval($filter_min_loi);
}

if ($filter_max_loi) {
    $query .= " AND eloi <= ?";
    $params[] = intval($filter_max_loi);
}

$query .= " ORDER BY created_at DESC";

$stmt = $pdo->prepare($query);
$stmt->execute($params);
$projects = $stmt->fetchAll();

// ─── Per-project stats: aggregate survey_urls counts + avg actual LOI ───
$statsByProject = [];          // project_id (varchar) => stats array
$estIncByProject = [];         // project_id (varchar) => weighted-avg estimated incidence

if (!empty($projects)) {
    $project_id_list = array_map(function($p) { return $p['project_id']; }, $projects);
    $placeholders = implode(',', array_fill(0, count($project_id_list), '?'));

    // Aggregate survey_urls by project_id for url counts + avg actual LOI on completes
    $sStmt = $pdo->prepare("
        SELECT
            project_id,
            COUNT(*)                                                           AS urls_total,
            SUM(CASE WHEN status = 'sent'           THEN 1 ELSE 0 END)         AS urls_sent,
            SUM(CASE WHEN status = 'clicked'        THEN 1 ELSE 0 END)         AS urls_clicked,
            SUM(CASE WHEN status = 'complete'       THEN 1 ELSE 0 END)         AS urls_complete,
            SUM(CASE WHEN status = 'partial'        THEN 1 ELSE 0 END)         AS urls_partial,
            SUM(CASE WHEN status IN ('earlyscreenout','latescreenout') THEN 1 ELSE 0 END) AS urls_screenout,
            SUM(CASE WHEN status = 'quotafull'      THEN 1 ELSE 0 END)         AS urls_quotafull,
            SUM(CASE WHEN status = 'timeout'        THEN 1 ELSE 0 END)         AS urls_timeout,
            ROUND(AVG(CASE WHEN status = 'complete' AND actual_loi_seconds > 0 THEN actual_loi_seconds END), 0) AS avg_loi_secs
        FROM survey_urls
        WHERE project_id IN ($placeholders)
        GROUP BY project_id
    ");
    $sStmt->execute($project_id_list);
    foreach ($sStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $statsByProject[$row['project_id']] = $row;
    }

    // Weighted-average estimated incidence per project (using project_selections)
    // Note: project_selections.project_id is the int FK referencing projects.id
    $project_pk_list = array_map(function($p) { return (int)$p['id']; }, $projects);
    $pkPlaceholders  = implode(',', array_fill(0, count($project_pk_list), '?'));
    $eStmt = $pdo->prepare("
        SELECT
            project_id AS pk_id,
            CASE WHEN SUM(required_samples) > 0
                 THEN ROUND(SUM(estimated_incidence_rate * required_samples) / SUM(required_samples), 2)
                 ELSE NULL END AS weighted_eir
        FROM project_selections
        WHERE project_id IN ($pkPlaceholders)
        GROUP BY project_id
    ");
    $eStmt->execute($project_pk_list);
    $eByPk = [];
    foreach ($eStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $eByPk[(int)$row['pk_id']] = $row['weighted_eir'];
    }
    foreach ($projects as $p) {
        $estIncByProject[$p['project_id']] = $eByPk[(int)$p['id']] ?? null;
    }
}

// Helper: format LOI seconds → "Xm Ys" or "Xs"
if (!function_exists('fmtLoi')) {
    function fmtLoi($secs) {
        if (!$secs || $secs <= 0) return '—';
        $secs = (int)$secs;
        if ($secs < 60) return $secs . 's';
        $m = floor($secs / 60); $s = $secs % 60;
        return $m . 'm' . ($s > 0 ? ' ' . $s . 's' : '');
    }
}

// Helper: returns CSS color for a metric based on healthy/borderline/poor thresholds
// $direction: 'higher_better' (response, incidence achievement) or 'lower_better' (screenout)
if (!function_exists('metricColor')) {
    function metricColor($value, $good, $ok, $direction = 'higher_better') {
        if ($direction === 'higher_better') {
            if ($value >= $good) return '#059669';  // green
            if ($value >= $ok)   return '#d97706';  // amber
            return '#dc2626';                        // red
        } else {
            if ($value <= $good) return '#059669';
            if ($value <= $ok)   return '#d97706';
            return '#dc2626';
        }
    }
}

// Get industries for filter
$industriesStmt = $pdo->query("SELECT DISTINCT industry FROM projects WHERE client_id = " . $_SESSION['client_id'] . " ORDER BY industry");
$industries = $industriesStmt->fetchAll();

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

<div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 32px;">
    <div>
        <h1 class="page-title" style="margin-bottom: 0;">Projects</h1>
        <p class="page-subtitle" style="margin-bottom: 0;">Manage your survey projects</p>
    </div>
    <a href="create-project.php" class="btn btn-primary">
        + Create New Project
    </a>
</div>

<?php if ($success): ?>
    <div style="background: #d1fae5; color: #065f46; padding: 16px 20px; border-radius: 8px; margin-bottom: 24px; border-left: 4px solid #059669;">
        <i class="fas fa-check-circle" style="color:#059669"></i> <?php echo htmlspecialchars($success); ?>
    </div>
<?php endif; ?>

<?php if ($error): ?>
    <div style="background: #fee2e2; color: #991b1b; padding: 16px 20px; border-radius: 8px; margin-bottom: 24px; border-left: 4px solid #dc2626;">
        <i class="fas fa-exclamation-triangle" style="color:#dc2626"></i> <?php echo htmlspecialchars($error); ?>
    </div>
<?php endif; ?>

<!-- Filters -->
<div class="card" style="margin-bottom: 24px;">
    <h3 style="color: #1a1a1a; font-size: 18px; margin-bottom: 16px;"><i class="fas fa-filter"></i> Filters</h3>
    <form method="GET" style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 16px;">
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">Status</label>
            <select name="status" style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;">
                <option value="">All Statuses</option>
                <option value="Created" <?php echo $filter_status === 'Created' ? 'selected' : ''; ?>>Created</option>
                <option value="Targeted" <?php echo $filter_status === 'Targeted' ? 'selected' : ''; ?>>Targeted</option>
                <option value="Live" <?php echo $filter_status === 'Live' ? 'selected' : ''; ?>>Live</option>
                <option value="On hold" <?php echo $filter_status === 'On hold' ? 'selected' : ''; ?>>On hold</option>
                <option value="Closed" <?php echo $filter_status === 'Closed' ? 'selected' : ''; ?>>Closed</option>
            </select>
        </div>
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">Industry</label>
            <select name="industry" style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;">
                <option value="">All Industries</option>
                <?php foreach ($industries as $ind): ?>
                    <option value="<?php echo htmlspecialchars($ind['industry']); ?>" 
                            <?php echo $filter_industry === $ind['industry'] ? 'selected' : ''; ?>>
                        <?php echo htmlspecialchars($ind['industry']); ?>
                    </option>
                <?php endforeach; ?>
            </select>
        </div>
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">From Date</label>
            <input type="date" name="from_date" value="<?php echo htmlspecialchars($filter_from_date); ?>"
                   style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;">
        </div>
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">To Date</label>
            <input type="date" name="to_date" value="<?php echo htmlspecialchars($filter_to_date); ?>"
                   style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;">
        </div>
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">Min LOI</label>
            <input type="number" name="min_loi" value="<?php echo htmlspecialchars($filter_min_loi); ?>" min="0"
                   style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;"
                   placeholder="Min minutes">
        </div>
        
        <div>
            <label style="display: block; font-weight: 600; color: #1a1a1a; font-size: 13px; margin-bottom: 6px;">Max LOI</label>
            <input type="number" name="max_loi" value="<?php echo htmlspecialchars($filter_max_loi); ?>" min="0"
                   style="width: 100%; padding: 8px; border: 2px solid #e5e7eb; border-radius: 6px; font-size: 13px;"
                   placeholder="Max minutes">
        </div>
        
        <div style="display: flex; gap: 8px; align-items: flex-end;">
            <button type="submit" class="btn btn-primary" style="padding: 8px 16px; font-size: 13px;">
                Apply Filters
            </button>
            <a href="projects-list.php" class="btn btn-secondary" style="padding: 8px 16px; font-size: 13px;">
                Clear
            </a>
        </div>
        
    </form>
</div>

<!-- Export Options -->
<div style="margin-bottom: 16px; display: flex; gap: 8px; justify-content: flex-end;">
    <a href="export-projects.php?<?php echo http_build_query($_GET); ?>" target="_blank" class="btn btn-secondary" style="padding: 8px 16px; font-size: 13px;">
        <i class="fas fa-file-pdf"></i> Export Filtered Projects (PDF)
    </a>
</div>

<!-- Projects Table -->
<div class="card">
    <h3 style="color: #1a1a1a; font-size: 18px; margin-bottom: 16px;">
        Projects (<?php echo count($projects); ?>)
    </h3>
    
    <?php if (empty($projects)): ?>
        <div style="text-align: center; padding: 60px 20px; color: #666;">
            <div style="font-size: 48px; margin-bottom: 16px;"><i class="fas fa-clipboard-list" style="color:#059669"></i></div>
            <p style="font-size: 16px; margin-bottom: 8px;">No projects found</p>
            <p style="font-size: 14px;">Create your first project to get started!</p>
            <a href="create-project.php" class="btn btn-primary" style="margin-top: 16px; display: inline-block;">
                + Create Project
            </a>
        </div>
    <?php else: ?>
        <div style="overflow-x: auto;">
            <table style="width: 100%; border-collapse: collapse; font-size:12px;">
                <thead>
                    <tr style="background: #f9f9f9; border-bottom: 2px solid #e5e7eb;">
                        <th style="padding:10px 8px; text-align:left; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Project</th>
                        <th style="padding:10px 8px; text-align:center; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Status</th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Sample<br><small style="font-weight:500;color:#999;text-transform:none;">target / done</small></th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Sent</th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Funnel<br><small style="font-weight:500;color:#999;text-transform:none;">C / P / SO / QF / TO</small></th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Resp %</th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Inc %<br><small style="font-weight:500;color:#999;text-transform:none;">vs estimated</small></th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">SO %</th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Avg LOI<br><small style="font-weight:500;color:#999;text-transform:none;">vs eLOI</small></th>
                        <th style="padding:10px 8px; text-align:right; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Deadline</th>
                        <th style="padding:10px 8px; text-align:center; font-weight:700; color:#1a1a1a; font-size:11px; text-transform:uppercase; letter-spacing:.3px;">Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($projects as $project): 
                        $status_colors = [
                            'Created' => '#059669',
                            'Targeted' => '#ffc107',
                            'Live' => '#28a745',
                            'On hold' => '#dc2626',
                            'Closed' => '#666'
                        ];
                        $status_color = $status_colors[$project['status']] ?? '#666';
                        $is_live = $project['status'] === 'Live';

                        // Pull stats for this project
                        $st = $statsByProject[$project['project_id']] ?? null;
                        $urls_sent      = $st ? (int)$st['urls_sent']      : 0;
                        $urls_clicked   = $st ? (int)$st['urls_clicked']   : 0;
                        $urls_complete  = $st ? (int)$st['urls_complete']  : 0;
                        $urls_partial   = $st ? (int)$st['urls_partial']   : 0;
                        $urls_screenout = $st ? (int)$st['urls_screenout'] : 0;
                        $urls_quotafull = $st ? (int)$st['urls_quotafull'] : 0;
                        $urls_timeout   = $st ? (int)$st['urls_timeout']   : 0;
                        $avg_loi_secs   = $st && $st['avg_loi_secs'] ? (int)$st['avg_loi_secs'] : 0;

                        $totalClicks     = $urls_clicked + $urls_complete + $urls_partial + $urls_screenout + $urls_quotafull + $urls_timeout;
                        $totalDispatched = $urls_sent + $totalClicks;
                        $responseRate    = $totalDispatched > 0 ? ($totalClicks / $totalDispatched) * 100 : 0;
                        $incidenceRate   = $totalClicks > 0 ? ($urls_complete / $totalClicks) * 100 : 0;
                        $screenoutRate   = $totalDispatched > 0 ? ($urls_screenout / $totalDispatched) * 100 : 0;

                        $estIncidence    = $estIncByProject[$project['project_id']] ?? null;
                        $eloiSecs        = (int)$project['eloi'] * 60;

                        // Color codes
                        $respColor   = metricColor($responseRate, 20, 10, 'higher_better');
                        $soColor     = metricColor($screenoutRate, 30, 50, 'lower_better');
                        $incColor    = '#666';
                        if ($estIncidence > 0 && $totalClicks >= 10) {
                            $achievementPct = ($incidenceRate / $estIncidence) * 100;
                            $incColor = metricColor($achievementPct, 90, 70, 'higher_better');
                        }
                        $loiColor = '#666';
                        if ($avg_loi_secs > 0 && $eloiSecs > 0) {
                            $ratio = $avg_loi_secs / $eloiSecs;
                            // healthy if 70%–130% of estimated, amber if 50-150, red otherwise
                            if ($ratio >= 0.7 && $ratio <= 1.3)      $loiColor = '#059669';
                            elseif ($ratio >= 0.5 && $ratio <= 1.5)  $loiColor = '#d97706';
                            else                                       $loiColor = '#dc2626';
                        }
                    ?>
                    <tr style="border-bottom: 1px solid #e5e7eb;">
                        <!-- Project (id + name + industry + ref) -->
                        <td style="padding:10px 8px; vertical-align:top;">
                            <div style="font-family:monospace; font-weight:700; color:#059669; font-size:12px;"><?php echo htmlspecialchars($project['project_id']); ?></div>
                            <div style="color:#1a1a1a; font-weight:600; margin-top:2px;"><?php echo htmlspecialchars($project['project_name']); ?></div>
                            <div style="color:#999; font-size:11px; margin-top:1px;"><?php echo htmlspecialchars($project['industry']); ?><?php if ($project['client_reference']): ?> · Ref: <?php echo htmlspecialchars($project['client_reference']); ?><?php endif; ?></div>
                        </td>

                        <!-- Status -->
                        <td style="padding:10px 8px; text-align:center; vertical-align:top;">
                            <span style="background:<?php echo $status_color; ?>; color:white; padding:3px 9px; border-radius:11px; font-size:10px; font-weight:700; text-transform:uppercase;">
                                <?php echo htmlspecialchars($project['status']); ?>
                            </span>
                        </td>

                        <!-- Sample (target / done) -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <div style="color:#1a1a1a; font-weight:600;"><?php echo number_format($project['sample_size']); ?></div>
                            <?php if ($urls_complete > 0): ?>
                                <div style="font-size:11px; color:#059669; font-weight:600;"><?php echo number_format($urls_complete); ?> done</div>
                                <div style="font-size:10px; color:#999;"><?php echo round($urls_complete / max(1, (int)$project['sample_size']) * 100); ?>% of target</div>
                            <?php else: ?>
                                <div style="font-size:11px; color:#999;">—</div>
                            <?php endif; ?>
                        </td>

                        <!-- Sent -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <div style="color:#1a1a1a; font-weight:600;"><?php echo number_format($totalDispatched); ?></div>
                            <?php if ($urls_sent > 0): ?>
                                <div style="font-size:10px; color:#999;"><?php echo number_format($urls_sent); ?> awaiting</div>
                            <?php endif; ?>
                        </td>

                        <!-- Funnel breakdown: Complete / Partial / Screenout / QuotaFull / Timeout -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums; font-size:11px;">
                            <?php if ($totalClicks > 0): ?>
                                <span title="Complete" style="color:#059669; font-weight:700;"><?php echo number_format($urls_complete); ?></span>
                                <span style="color:#ccc;">/</span>
                                <span title="Partial" style="color:#0891b2; font-weight:600;"><?php echo number_format($urls_partial); ?></span>
                                <span style="color:#ccc;">/</span>
                                <span title="Screen-out (early+late)" style="color:#d97706; font-weight:600;"><?php echo number_format($urls_screenout); ?></span>
                                <span style="color:#ccc;">/</span>
                                <span title="Quota Full" style="color:#7c3aed; font-weight:600;"><?php echo number_format($urls_quotafull); ?></span>
                                <span style="color:#ccc;">/</span>
                                <span title="Timeout" style="color:#dc2626; font-weight:600;"><?php echo number_format($urls_timeout); ?></span>
                                <?php if ($urls_clicked > 0): ?>
                                    <div style="font-size:10px; color:#999; margin-top:2px;"><?php echo number_format($urls_clicked); ?> in progress</div>
                                <?php endif; ?>
                            <?php else: ?>
                                <span style="color:#ccc;">—</span>
                            <?php endif; ?>
                        </td>

                        <!-- Response % -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <?php if ($totalDispatched > 0): ?>
                                <span style="color:<?php echo $respColor; ?>; font-weight:700; font-size:13px;"><?php echo number_format($responseRate, 1); ?>%</span>
                            <?php else: ?>
                                <span style="color:#ccc;">—</span>
                            <?php endif; ?>
                        </td>

                        <!-- Incidence % vs estimated -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <?php if ($totalClicks > 0): ?>
                                <span style="color:<?php echo $incColor; ?>; font-weight:700; font-size:13px;"><?php echo number_format($incidenceRate, 1); ?>%</span>
                                <?php if ($estIncidence !== null): ?>
                                    <div style="font-size:10px; color:#999;">est <?php echo number_format($estIncidence, 1); ?>%</div>
                                <?php endif; ?>
                            <?php else: ?>
                                <span style="color:#ccc;">—</span>
                                <?php if ($estIncidence !== null): ?>
                                    <div style="font-size:10px; color:#999;">est <?php echo number_format($estIncidence, 1); ?>%</div>
                                <?php endif; ?>
                            <?php endif; ?>
                        </td>

                        <!-- Screen-out % -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <?php if ($totalDispatched > 0): ?>
                                <span style="color:<?php echo $soColor; ?>; font-weight:700; font-size:13px;"><?php echo number_format($screenoutRate, 1); ?>%</span>
                            <?php else: ?>
                                <span style="color:#ccc;">—</span>
                            <?php endif; ?>
                        </td>

                        <!-- Avg LOI vs eLOI -->
                        <td style="padding:10px 8px; text-align:right; vertical-align:top; font-variant-numeric:tabular-nums;">
                            <?php if ($avg_loi_secs > 0): ?>
                                <span style="color:<?php echo $loiColor; ?>; font-weight:700; font-size:12px;"><?php echo fmtLoi($avg_loi_secs); ?></span>
                                <div style="font-size:10px; color:#999;">est <?php echo (int)$project['eloi']; ?>m</div>
                            <?php else: ?>
                                <span style="color:#ccc;">—</span>
                                <div style="font-size:10px; color:#999;">est <?php echo (int)$project['eloi']; ?>m</div>
                            <?php endif; ?>
                        </td>

                        <!-- Deadline -->
                        <td style="padding:10px 8px; text-align:right; font-size:11px; color:#666; vertical-align:top;">
                            <?php echo date('d M Y', strtotime($project['deadline'])); ?><br>
                            <span style="color:#999; font-size:10px;"><?php echo date('H:i', strtotime($project['deadline'])); ?></span>
                        </td>

                        <!-- Actions -->
                        <td style="padding:10px 8px; text-align:center; vertical-align:top;">
                            <div style="display: flex; gap: 8px; justify-content: center;">
                                <a href="view-project.php?id=<?php echo $project['id']; ?>" 
                                   style="color: #059669; text-decoration: none; font-size: 18px;" title="View"><i class="fas fa-eye"></i></a>
                                
                                <?php if (!$is_live): ?>
                                    <a href="edit-project.php?id=<?php echo $project['id']; ?>" 
                                       style="color: #059669; text-decoration: none; font-size: 18px;" title="Edit"><i class="fas fa-edit"></i></a>
                                    <a href="?delete=1&id=<?php echo $project['id']; ?>" 
                                       onclick="return confirm('Are you sure you want to delete this project?');"
                                       style="color: #dc2626; text-decoration: none; font-size: 18px;" title="Delete"><i class="fas fa-trash-alt"></i></a>
                                <?php else: ?>
                                    <span style="color: #ccc; font-size: 18px;" title="Cannot edit Live project"><i class="fas fa-edit"></i></span>
                                    <span style="color: #ccc; font-size: 18px;" title="Cannot delete Live project"><i class="fas fa-trash-alt"></i></span>
                                <?php endif; ?>
                                
                                <a href="export-project.php?id=<?php echo $project['id']; ?>" target="_blank"
                                   style="color: #059669; text-decoration: none; font-size: 18px;" title="Export PDF"><i class="fas fa-file-export"></i></a>
                            </div>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>

        <!-- Legend -->
        <div style="margin-top:14px; padding:10px 14px; background:#f9fafb; border-radius:6px; font-size:11px; color:#666; line-height:1.6;">
            <strong style="color:#1a1a1a;">Funnel:</strong> <span style="color:#059669;font-weight:700;">C</span>omplete /
            <span style="color:#0891b2;font-weight:700;">P</span>artial /
            <span style="color:#d97706;font-weight:700;">SO</span> Screen-out /
            <span style="color:#7c3aed;font-weight:700;">QF</span> Quota-full /
            <span style="color:#dc2626;font-weight:700;">TO</span> Timeout
            &nbsp;·&nbsp;
            <strong style="color:#1a1a1a;">Resp%</strong> = clicks ÷ dispatched
            &nbsp;·&nbsp;
            <strong style="color:#1a1a1a;">Inc%</strong> = completes ÷ clicks
            &nbsp;·&nbsp;
            <strong style="color:#1a1a1a;">SO%</strong> = screen-outs ÷ dispatched
        </div>
    <?php endif; ?>
</div>

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