<?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;
}

// Fetch selections with member counts
$stmt = $pdo->prepare("
    SELECT ps.*, 
           COUNT(DISTINCT sm.user_id) as actual_selected,
           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
    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();

// URL stats per selection + LOI per selection
$selUrlStats = [];
$selLoiStats = [];
$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');
    $ph = implode(',', array_fill(0, count($selIds), '?'));

    // URL status counts per selection
    $stmt = $pdo->prepare("
        SELECT assigned_to_selection_id as sel_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
        FROM survey_urls
        WHERE assigned_to_selection_id IN ($ph)
        GROUP BY assigned_to_selection_id
    ");
    $stmt->execute($selIds);
    foreach ($stmt->fetchAll() as $r) $selUrlStats[$r['sel_id']] = $r;

    // LOI + quality per selection
    $stmt = $pdo->prepare("
        SELECT assigned_to_selection_id as sel_id,
               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 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,
               SUM(CASE WHEN quality_flag='client_flagged' THEN 1 ELSE 0 END) as flagged
        FROM survey_urls
        WHERE assigned_to_selection_id IN ($ph)
        GROUP BY assigned_to_selection_id
    ");
    $stmt->execute($selIds);
    foreach ($stmt->fetchAll() as $r) $selLoiStats[$r['sel_id']] = $r;

    // Project-wide stats
    $stmt = $pdo->prepare("
        SELECT 
            COUNT(*) as total_urls,
            SUM(CASE WHEN status = 'complete' THEN 1 ELSE 0 END) as total_completes,
            SUM(CASE WHEN status = 'clicked' THEN 1 ELSE 0 END) as total_clicked,
            SUM(CASE WHEN status IN ('earlyscreenout','latescreenout') THEN 1 ELSE 0 END) as total_screenout,
            SUM(CASE WHEN status = 'quotafull' THEN 1 ELSE 0 END) as total_quotafull,
            SUM(CASE WHEN status = 'timeout' THEN 1 ELSE 0 END) as total_timeout,
            SUM(CASE WHEN status = 'partial' THEN 1 ELSE 0 END) as total_partial,
            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 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,
            SUM(CASE WHEN quality_flag='client_flagged' THEN 1 ELSE 0 END) as flagged
        FROM survey_urls
        WHERE project_id = ?
    ");
    $stmt->execute([$project['project_id']]);
    $ps = $stmt->fetch(PDO::FETCH_ASSOC);
    if ($ps) $projectLoiStats = $ps;
}

// Compute totals from selections
$total_required = array_sum(array_column($selections, 'required_samples'));
$total_selected = array_sum(array_column($selections, 'actual_selected'));

$status_colors = [
    'Created' => '#0066cc', 'Targeted' => '#d97706', 'Live' => '#059669',
    'On hold' => '#dc2626', 'Closed' => '#6b7280'
];
$color = $status_colors[$project['status']] ?? '#6b7280';
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Project <?php echo htmlspecialchars($project['project_id']); ?></title>
    <style>
        * { box-sizing: border-box; }
        body { font-family: Arial, sans-serif; padding: 30px; color: #1a1a1a; font-size: 12px; }
        .header { text-align: center; margin-bottom: 30px; border-bottom: 3px solid #059669; padding-bottom: 15px; }
        .header h1 { color: #059669; margin: 0 0 4px 0; font-size: 22px; }
        .header .subtitle { font-size: 14px; color: #666; }
        .header .generated { font-size: 10px; color: #999; margin-top: 6px; }

        .section { margin-bottom: 20px; border: 1px solid #e5e7eb; border-radius: 6px; overflow: hidden; }
        .section-title { background: #059669; color: white; padding: 8px 14px; font-size: 13px; font-weight: bold; margin: 0; }

        .info-grid { display: grid; grid-template-columns: 1fr 1fr 1fr; padding: 14px; gap: 12px; }
        .info-item .label { font-size: 10px; color: #6b7280; text-transform: uppercase; font-weight: 600; }
        .info-item .value { font-size: 14px; font-weight: 700; color: #1a1a1a; margin-top: 2px; }
        .info-item .value.green { color: #059669; }
        .info-item .value.red { color: #dc2626; }
        .info-item .value.blue { color: #0066cc; }

        .kpi-row { display: flex; gap: 0; border-bottom: 1px solid #e5e7eb; }
        .kpi-box { flex: 1; text-align: center; padding: 12px 8px; border-right: 1px solid #e5e7eb; }
        .kpi-box:last-child { border-right: none; }
        .kpi-num { font-size: 22px; font-weight: 800; color: #059669; }
        .kpi-num.red { color: #dc2626; }
        .kpi-num.amber { color: #d97706; }
        .kpi-label { font-size: 9px; color: #6b7280; text-transform: uppercase; font-weight: 600; margin-top: 2px; }

        .progress-bar { background: #e5e7eb; border-radius: 4px; height: 8px; margin: 0 14px 14px; }
        .progress-fill { background: #059669; border-radius: 4px; height: 100%; }

        table { width: 100%; border-collapse: collapse; }
        table th { background: #f3f4f6; padding: 6px 5px; text-align: left; font-size: 9px; font-weight: 700; color: #374151; text-transform: uppercase; border-bottom: 2px solid #d1d5db; }
        table td { padding: 5px 5px; font-size: 10px; border-bottom: 1px solid #f3f4f6; }
        table tr:nth-child(even) { background: #f9fafb; }

        .badge { padding: 2px 6px; border-radius: 8px; font-size: 9px; font-weight: 700; white-space: nowrap; display: inline-block; }
        .badge-green { background: #d1fae5; color: #065f46; }
        .badge-red { background: #fee2e2; color: #991b1b; }
        .badge-amber { background: #fef3c7; color: #92400e; }
        .badge-blue { background: #dbeafe; color: #1e40af; }
        .badge-gray { background: #e5e7eb; color: #374151; }

        .footer { margin-top: 30px; text-align: center; color: #999; font-size: 10px; border-top: 1px solid #e5e7eb; padding-top: 12px; }

        @media print { body { padding: 20px; } .section { break-inside: avoid; } }
    </style>
</head>
<body>
    <div class="header">
        <h1>RELEVANT REFLEX</h1>
        <div class="subtitle">Project Completion Report &mdash; <?php echo htmlspecialchars($project['project_id']); ?></div>
        <div class="generated">Generated <?php echo date('M j, Y g:i A'); ?> | Client: <?php echo htmlspecialchars($_SESSION['client_name']); ?></div>
    </div>

    <!-- Project Info -->
    <div class="section">
        <div class="section-title">Project Information</div>
        <div class="info-grid">
            <div class="info-item">
                <div class="label">Project Name</div>
                <div class="value"><?php echo htmlspecialchars($project['project_name']); ?></div>
            </div>
            <div class="info-item">
                <div class="label">Project ID</div>
                <div class="value blue"><?php echo htmlspecialchars($project['project_id']); ?></div>
            </div>
            <div class="info-item">
                <div class="label">Status</div>
                <div class="value"><span class="badge" style="background:<?php echo $color; ?>;color:white;font-size:11px;padding:3px 10px;"><?php echo $project['status']; ?></span></div>
            </div>
            <div class="info-item">
                <div class="label">Industry</div>
                <div class="value"><?php echo htmlspecialchars($project['industry']); ?></div>
            </div>
            <div class="info-item">
                <div class="label">eLOI</div>
                <div class="value"><?php echo $project['eloi']; ?> min</div>
            </div>
            <div class="info-item">
                <div class="label">Sample Size (eN)</div>
                <div class="value"><?php echo number_format($project['sample_size']); ?></div>
            </div>
            <?php if ($project['client_reference']): ?>
            <div class="info-item">
                <div class="label">Client Reference</div>
                <div class="value"><?php echo htmlspecialchars($project['client_reference']); ?></div>
            </div>
            <?php endif; ?>
            <div class="info-item">
                <div class="label">Deadline</div>
                <div class="value"><?php echo date('d M Y, H:i', strtotime($project['deadline'])); ?></div>
            </div>
            <div class="info-item">
                <div class="label">Created</div>
                <div class="value"><?php echo date('d M Y', strtotime($project['created_at'])); ?></div>
            </div>
        </div>
    </div>

    <!-- Completion Dashboard -->
    <div class="section">
        <div class="section-title">Completion Dashboard</div>
        <?php
            $completes = intval($projectLoiStats['total_completes'] ?? 0);
            $target = intval($project['sample_size']);
            $pct = $target > 0 ? min(100, round(($completes / $target) * 100, 1)) : 0;
            $speedsters = intval($projectLoiStats['speedsters'] ?? 0);
            $ip_dups = intval($projectLoiStats['ip_dups'] ?? 0);
            $flagged = intval($projectLoiStats['flagged'] ?? 0);
            $quality_issues = $speedsters + $ip_dups + $flagged;
            $screenouts = intval($projectLoiStats['total_screenout'] ?? 0);
            $quotafull = intval($projectLoiStats['total_quotafull'] ?? 0);
            $timeouts = intval($projectLoiStats['total_timeout'] ?? 0);
            $avgLoiMin = ($projectLoiStats['avg_loi'] > 0) ? round($projectLoiStats['avg_loi'] / 60, 1) : '-';
            $minLoiMin = ($projectLoiStats['min_loi'] > 0) ? round($projectLoiStats['min_loi'] / 60, 1) : '-';
            $maxLoiMin = ($projectLoiStats['max_loi'] > 0) ? round($projectLoiStats['max_loi'] / 60, 1) : '-';
        ?>
        <div class="kpi-row">
            <div class="kpi-box">
                <div class="kpi-num"><?php echo $completes; ?>/<?php echo number_format($target); ?></div>
                <div class="kpi-label">Completes / Target</div>
            </div>
            <div class="kpi-box">
                <div class="kpi-num"><?php echo $pct; ?>%</div>
                <div class="kpi-label">Completion Rate</div>
            </div>
            <div class="kpi-box">
                <div class="kpi-num"><?php echo $avgLoiMin; ?></div>
                <div class="kpi-label">Avg LOI (min)</div>
            </div>
            <div class="kpi-box">
                <div class="kpi-num"><?php echo $minLoiMin; ?>&ndash;<?php echo $maxLoiMin; ?></div>
                <div class="kpi-label">LOI Range (min)</div>
            </div>
            <div class="kpi-box">
                <div class="kpi-num <?php echo $quality_issues > 0 ? 'red' : ''; ?>"><?php echo $quality_issues; ?></div>
                <div class="kpi-label">Quality Issues</div>
            </div>
        </div>
        <div style="padding: 10px 14px 4px; font-size: 10px; color: #6b7280;">Completion: <?php echo $pct; ?>%</div>
        <div class="progress-bar"><div class="progress-fill" style="width: <?php echo $pct; ?>%;"></div></div>

        <!-- Status Breakdown -->
        <div class="kpi-row" style="border-top: 1px solid #e5e7eb;">
            <div class="kpi-box"><div class="kpi-num"><?php echo $screenouts; ?></div><div class="kpi-label">Screen Outs</div></div>
            <div class="kpi-box"><div class="kpi-num"><?php echo $quotafull; ?></div><div class="kpi-label">Quota Full</div></div>
            <div class="kpi-box"><div class="kpi-num"><?php echo $timeouts; ?></div><div class="kpi-label">Timeouts</div></div>
            <div class="kpi-box"><div class="kpi-num <?php echo $speedsters > 0 ? 'amber' : ''; ?>"><?php echo $speedsters; ?></div><div class="kpi-label">Speedsters</div></div>
            <div class="kpi-box"><div class="kpi-num <?php echo $ip_dups > 0 ? 'amber' : ''; ?>"><?php echo $ip_dups; ?></div><div class="kpi-label">IP Duplicates</div></div>
            <div class="kpi-box"><div class="kpi-num"><?php echo count($selections); ?></div><div class="kpi-label">Selections</div></div>
        </div>
    </div>

    <!-- Selections Table -->
    <?php if (!empty($selections)): ?>
    <div class="section">
        <div class="section-title">Selections Breakdown (<?php echo count($selections); ?>)</div>
        <table>
            <thead>
                <tr>
                    <th>Selection</th>
                    <th>Status</th>
                    <th>Required</th>
                    <th>Selected</th>
                    <th>Completes</th>
                    <th>Screen Out</th>
                    <th>Quota Full</th>
                    <th>URLs Sent</th>
                    <th>Avg LOI</th>
                    <th>Speedsters</th>
                    <th>IP Dups</th>
                    <th>Incidence</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($selections as $sel):
                    $us = $selUrlStats[$sel['id']] ?? [];
                    $ls = $selLoiStats[$sel['id']] ?? [];
                    $selAvgLoi = isset($ls['avg_loi']) && $ls['avg_loi'] > 0 ? round($ls['avg_loi'] / 60, 1) . 'm' : '-';
                    $selSpd = intval($ls['speedsters'] ?? 0);
                    $selIpd = intval($ls['ip_dups'] ?? 0);
                ?>
                <tr>
                    <td>
                        <strong><?php echo htmlspecialchars($sel['selection_name']); ?></strong><br>
                        <span style="color:#059669;font-family:monospace;font-size:9px;"><?php echo htmlspecialchars($sel['selection_id'] ?? 'SEL-' . str_pad($sel['id'], 4, '0', STR_PAD_LEFT)); ?></span>
                    </td>
                    <td><span class="badge badge-<?php echo in_array($sel['status'], ['live','closed']) ? ($sel['status']==='live'?'green':'gray') : 'amber'; ?>"><?php echo ucfirst($sel['status']); ?></span></td>
                    <td><?php echo number_format($sel['required_samples']); ?></td>
                    <td><?php echo number_format($sel['actual_selected']); ?></td>
                    <td><strong><?php echo intval($sel['cnt_complete']); ?></strong></td>
                    <td><?php echo intval($sel['cnt_screen_out']); ?></td>
                    <td><?php echo intval($us['urls_quotafull'] ?? 0); ?></td>
                    <td><?php echo intval($us['urls_total'] ?? 0); ?></td>
                    <td><?php echo $selAvgLoi; ?></td>
                    <td><?php echo $selSpd > 0 ? '<span class="badge badge-amber">' . $selSpd . '</span>' : '0'; ?></td>
                    <td><?php echo $selIpd > 0 ? '<span class="badge badge-red">' . $selIpd . '</span>' : '0'; ?></td>
                    <td><?php echo number_format($sel['estimated_incidence_rate'], 1); ?>%</td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>
    <?php endif; ?>

    <!-- Timeline -->
    <div class="section">
        <div class="section-title">Timeline</div>
        <div class="info-grid" style="grid-template-columns: 1fr 1fr;">
            <div class="info-item">
                <div class="label">Created</div>
                <div class="value"><?php echo date('d M Y, H:i', strtotime($project['created_at'])); ?></div>
            </div>
            <div class="info-item">
                <div class="label">Last Updated</div>
                <div class="value"><?php echo date('d M Y, H:i', strtotime($project['updated_at'])); ?></div>
            </div>
            <?php if ($project['made_live_at']): ?>
            <div class="info-item">
                <div class="label">Made Live</div>
                <div class="value"><?php echo date('d M Y, H:i', strtotime($project['made_live_at'])); ?></div>
            </div>
            <?php endif; ?>
            <div class="info-item">
                <div class="label">Deadline</div>
                <div class="value"><?php echo date('d M Y, H:i', strtotime($project['deadline'])); ?></div>
            </div>
        </div>
    </div>

    <?php if ($project['description']): ?>
    <div class="section">
        <div class="section-title">Description</div>
        <div style="padding: 12px 14px; font-size: 11px; line-height: 1.5;"><?php echo nl2br(htmlspecialchars($project['description'])); ?></div>
    </div>
    <?php endif; ?>

    <div class="footer">
        Relevant Reflex &mdash; Project Completion Report &mdash; <?php echo date('F j, Y g:i A'); ?>
    </div>

    <script>window.onload = function() { window.print(); };</script>
</body>
</html>