<?php
require_once __DIR__ . '/includes/config.php';
$videos = q("SELECT v.*, c.name cat_name FROM videos v LEFT JOIN categories c ON c.id=v.category_id WHERE v.status='published' ORDER BY v.featured DESC, v.id DESC");
$pageTitle = 'Video Formazione | ' . SITE_NAME;
$pageDesc  = 'Video sull\'ottimizzazione fiscale, il Metodo Franzone e le riconfigurazioni societarie.';
require __DIR__ . '/includes/header.php';
?>
<section class="page-hero">
  <div class="container">
    <span class="kicker" style="color:var(--gold-soft);border-color:rgba(201,162,75,.5)">Video</span>
    <h1>Video &amp; Formazione</h1>
    <p>Strategie fiscali spiegate in pochi minuti. Guarda, capisci, applica.</p>
  </div>
</section>
<section class="section">
  <div class="container">
    <?php if(!$videos): ?>
      <p class="muted" style="text-align:center;padding:60px 0">Nessun video pubblicato al momento.</p>
    <?php else: ?>
    <div class="video-grid">
      <?php foreach ($videos as $v): ?>
      <a class="video-card reveal" href="<?= url('video-single.php?slug='.urlencode($v['slug'])) ?>">
        <div class="thumb">
          <?php if($v['thumb']): ?><img src="<?= e(uploads_url('thumbs/'.$v['thumb'])) ?>" alt="<?= e($v['title']) ?>"><?php endif; ?>
          <div class="play"><svg width="24" height="24" viewBox="0 0 24 24" fill="currentColor"><path d="M8 5v14l11-7z"/></svg></div>
          <?php if($v['duration']): ?><span class="dur"><?= e($v['duration']) ?></span><?php endif; ?>
        </div>
        <div class="body">
          <h3><?= e($v['title']) ?></h3>
          <p><?= e(excerpt_from($v['description'], 120)) ?></p>
        </div>
      </a>
      <?php endforeach; ?>
    </div>
    <?php endif; ?>
  </div>
</section>
<?php require __DIR__ . '/includes/footer.php'; ?>
