PackIt/admin/index.php

<?php
require_once __DIR__ . '/auth.php';
require_once __DIR__ . '/layout.php';
require_admin();

$pdo = get_pdo();

$counts = [];
foreach (['activity_groups','activities','item_groups','items','activity_item_map','selection_hashes'] as $t) {
    $counts[$t] = $pdo->query("SELECT COUNT(*) FROM `$t`")->fetchColumn();
}

admin_head('Dashboard', 'index.php');
?>
<h1>Dashboard</h1>

<div style="display:grid;grid-template-columns:repeat(auto-fill,minmax(180px,1fr));gap:1rem;margin-bottom:2rem;">
<?php
$tiles = [
    ['Activity Groups', $counts['activity_groups'], 'activity_groups.php', '#4fd1c5'],
    ['Activities',      $counts['activities'],      'activities.php',      '#e8c547'],
    ['Item Groups',     $counts['item_groups'],     'item_groups.php',     '#4fd1c5'],
    ['Items',           $counts['items'],           'items.php',           '#e8c547'],
    ['Mappings',        $counts['activity_item_map'],'mappings.php',       '#a78bfa'],
    ['Saved Lists',     $counts['selection_hashes'],'#',                   '#7a8099'],
];
foreach ($tiles as [$label, $count, $href, $color]):
?>
<a href="<?= $href ?>" style="background:var(--surface);border:1px solid var(--border);border-radius:var(--radius);padding:1.25rem 1.5rem;text-decoration:none;display:block;transition:border-color .15s;" onmouseover="this.style.borderColor='<?= $color ?>'" onmouseout="this.style.borderColor='var(--border)'">
  <div style="font-size:2rem;font-family:'Bebas Neue',sans-serif;color:<?= $color ?>;line-height:1;"><?= $count ?></div>
  <div style="font-size:.8rem;color:var(--muted);margin-top:.25rem;text-transform:uppercase;letter-spacing:.06em;"><?= $label ?></div>
</a>
<?php endforeach; ?>
</div>

<div class="card" style="display:grid;grid-template-columns:repeat(auto-fill,minmax(160px,1fr));gap:.75rem;">
  <a href="activities.php"      class="btn btn-secondary">✏️ Activities</a>
  <a href="activity_groups.php" class="btn btn-secondary">📂 Act. Groups</a>
  <a href="items.php"           class="btn btn-secondary">🎒 Items</a>
  <a href="item_groups.php"     class="btn btn-secondary">📂 Item Groups</a>
  <a href="mappings.php"        class="btn btn-secondary">🔗 Mappings</a>
</div>

<?php admin_foot(); ?>