erdo
/
exit-game


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180
							<?php
include 'db_config.php'; 

// --- 1. DATEN LADEN ---
$allTeams = $pdo->query("SELECT * FROM spieler ORDER BY name ASC")->fetchAll();
$teamFilter = isset($_GET['team_id']) ? (int)$_GET['team_id'] : 0;

// Neue SQL-Struktur mit Joins für Reihe und Typ
$sql = "SELECT sp.*, 
               sc.zeit, sc.hilfe, sc.sterne, 
               s.name as team_name, 
               r.name as reihe_name,
               t.bezeichnung as typ_name
        FROM spiele sp
        JOIN scores sc ON sp.id = sc.spiel_id
        JOIN spieler s ON sc.spieler_id = s.id
        LEFT JOIN game_reihe r ON sp.game_reihe_id = r.id
        LEFT JOIN game_typ t ON sp.game_typ_id = t.id";

if ($teamFilter > 0) {
    $sql .= " WHERE s.id = $teamFilter";
}

// Sortierung nach Reihenname, Spieltitel und dann Score-Zeit
$sql .= " ORDER BY r.name ASC, sp.titel ASC, sc.zeit ASC"; 
$stmt = $pdo->query($sql);
$results = $stmt->fetchAll();

// --- 2. GRUPPIERUNG NACH REIHE UND SPIEL ---
$groupedData = [];
foreach ($results as $row) {
    $reihe = !empty($row['reihe_name']) ? $row['reihe_name'] : 'Sonstige';
    $gameId = $row['id']; // ID als Key nutzen, falls Titel doppelt vorkommen könnten
    
    if (!isset($groupedData[$reihe][$gameId])) {
        $groupedData[$reihe][$gameId] = [
            'titel' => $row['titel'],
            'bild_url' => $row['bild_url'],
            'typ_name' => $row['typ_name'],
            'teams' => []
        ];
    }
    $groupedData[$reihe][$gameId]['teams'][] = [
        'name' => $row['team_name'],
        'zeit' => (int)$row['zeit'],
        'hilfe' => (int)$row['hilfe'],
        'sterne' => (int)$row['sterne']
    ];
}
?>
<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <title>EXIT Log - Gelöste Abenteuer</title>
    <style>
        :root { 
            --bg: #f4f7f6; --card: #ffffff; --text: #333; --border: #ddd; --accent: #e67e22;
            --muted: #888; --reihe-bg: #2c3e50;
        }
        .dark-theme { 
            --bg: #121212; --card: #1e1e1e; --text: #ffffff; --border: #333; --muted: #aaa;
        }

        body { font-family: 'Segoe UI', sans-serif; background: var(--bg); color: var(--text); padding: 20px; transition: 0.3s; }
        .container { max-width: 1200px; margin: 0 auto; }

        header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 30px; border-bottom: 2px solid var(--accent); padding-bottom: 10px; }
        h1 { color: var(--accent); margin: 0; font-size: 1.8rem; }
        
        .btn-nav { background: var(--accent); color: white; text-decoration: none; padding: 10px 15px; border-radius: 8px; font-weight: bold; font-size: 0.9em; display: inline-block; }
        .theme-toggle { background: none; border: none; font-size: 1.5rem; cursor: pointer; padding: 0; line-height: 1; }

        .filter-bar { background: var(--card); padding: 15px; border-radius: 12px; border: 1px solid var(--border); margin-bottom: 25px; display: flex; align-items: center; gap: 15px; box-shadow: 0 4px 15px rgba(0,0,0,0.05); }
        select { padding: 8px 15px; border-radius: 6px; border: 1px solid var(--border); background: var(--bg); color: var(--text); cursor: pointer; }

        .reihe-divider { grid-column: 1 / -1; margin: 40px 0 20px; padding: 12px 20px; background: var(--reihe-bg); color: white; border-radius: 8px; font-size: 1.1rem; font-weight: bold; text-transform: uppercase; letter-spacing: 2px; box-shadow: 0 4px 10px rgba(0,0,0,0.1); }
        .reihe-divider:first-of-type { margin-top: 0; }

        .grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(300px, 1fr)); gap: 25px; }
        .item { background: var(--card); border-radius: 12px; border: 1px solid var(--border); box-shadow: 0 4px 15px rgba(0,0,0,0.1); overflow: hidden; display: flex; flex-direction: column; }
        .item img { width: 100%; height: 200px; object-fit: cover; background: #2a2a2a; border-bottom: 1px solid var(--border); }
        
        .stats { padding: 15px; flex-grow: 1; }
        .game-title { font-weight: bold; display: block; margin-bottom: 5px; font-size: 1.2em; color: var(--accent); text-align: center; line-height: 1.2; }
        .game-subtitle { display: block; text-align: center; font-size: 0.75em; opacity: 0.6; margin-bottom: 15px; text-transform: uppercase; }
        
        .team-section-label { font-size: 0.7em; color: var(--muted); display: block; text-transform: uppercase; letter-spacing: 1px; margin-bottom: 10px; border-bottom: 1px solid var(--border); padding-bottom: 5px; }

        .team-entry { margin-bottom: 12px; padding-bottom: 12px; border-bottom: 1px dashed var(--border); }
        .team-entry:last-child { border-bottom: none; margin-bottom: 0; padding-bottom: 0; }
        
        .team-name-text { font-size: 0.95em; font-weight: bold; display: block; margin-bottom: 5px; }
        
        .result-row { display: flex; justify-content: space-between; font-size: 0.8em; }
        .res-item span { opacity: 0.6; margin-right: 4px; }
        .res-item b { color: var(--accent); }
        .res-only-solved { font-size: 0.8em; color: var(--muted); font-style: italic; }

        @media (max-width: 600px) {
            header { flex-direction: column; gap: 15px; text-align: center; }
            .filter-bar { flex-direction: column; align-items: stretch; }
            .grid { grid-template-columns: 1fr; }
        }
    </style>
</head>
<body>

<div class="container">
    <header>
        <h1>📂 Gelöste Abenteuer</h1>
        <div style="display: flex; align-items: center; gap: 15px;">
            <button onclick="toggleTheme()" class="theme-toggle" id="theme-icon">🌙</button>
            <a href="index.php" class="btn-nav">Dashboard</a>
        </div>
    </header>

    <div class="filter-bar">
        <strong>Filter nach Team:</strong>
        <form id="filterForm" method="GET">
            <select name="team_id" onchange="this.form.submit()">
                <option value="0">-- Alle Teams --</option>
                <?php foreach ($allTeams as $t): ?>
                    <option value="<?= $t['id'] ?>" <?= $teamFilter == $t['id'] ? 'selected' : '' ?>>
                        <?= htmlspecialchars($t['name']) ?>
                    </option>
                <?php endforeach; ?>
            </select>
        </form>
    </div>

    <div class="grid">
        <?php foreach ($groupedData as $reiheName => $games): ?>
            <div class="reihe-divider"><?= htmlspecialchars($reiheName) ?></div>
            
            <?php foreach ($games as $gameId => $data): ?>
                <div class="item">
                    <img src="<?= htmlspecialchars($data['bild_url']) ?>" onerror="this.src='https://via.placeholder.com/300x200?text=Escape+Spiel'">
                    <div class="stats">
                        <span class="game-title"><?= htmlspecialchars($data['titel']) ?></span>
                        <span class="game-subtitle"><?= htmlspecialchars($data['typ_name'] ?: '') ?></span>
                        
                        <span class="team-section-label">Gelöst von</span>
                        
                        <?php foreach ($data['teams'] as $team): ?>
                            <div class="team-entry">
                                <span class="team-name-text">👥 <?= htmlspecialchars($team['name']) ?></span>
                                
                                <?php if ($team['zeit'] === 0 && $team['hilfe'] === 0 && $team['sterne'] === 0): ?>
                                    <div class="res-only-solved">✅ Erfolgreich gelöst (Archiv)</div>
                                <?php else: ?>
                                    <div class="result-row">
                                        <div class="res-item"><span>Zeit:</span><b><?= $team['zeit'] ?> Min.</b></div>
                                        <div class="res-item"><span>Hilfe:</span><b><?= $team['hilfe'] ?></b></div>
                                        <div class="res-item"><b>⭐ <?= $team['sterne'] ?></b></div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        <?php endforeach; ?>
                    </div>
                </div>
            <?php endforeach; ?>
        <?php endforeach; ?>
    </div>
</div>

<script>
    const themeIcon = document.getElementById('theme-icon');
    function toggleTheme() {
        const isDark = document.documentElement.classList.toggle('dark-theme');
        localStorage.setItem('theme', isDark ? 'dark' : 'light');
        themeIcon.innerText = isDark ? '☀️' : '🌙';
    }
    if (localStorage.getItem('theme') === 'dark') {
        document.documentElement.classList.add('dark-theme');
        themeIcon.innerText = '☀️';
    }
</script>
</body>
</html>