<?php
require_once __DIR__ . '/admin/config.php';

function rv($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); }

try {
    $skills = db()->query('SELECT * FROM skills WHERE visible=1 ORDER BY category,sort_order,id')->fetchAll();
    $certs  = db()->query('SELECT * FROM certifications WHERE visible=1 ORDER BY sort_order,id')->fetchAll();
    $projs  = db()->query('SELECT * FROM projects WHERE visible=1 ORDER BY featured DESC,sort_order,id LIMIT 6')->fetchAll();
} catch (Exception $e) { $skills=$certs=$projs=[]; }

$name  = setting('hero_name', 'Sina Zarezadeh');
$stmt  = setting('hero_statement_en', 'Building intelligent infrastructures for the future.');
$email = setting('email', 'contact@sinazarezadeh.ir');
$tg    = setting('telegram',''); $li = setting('linkedin',''); $gh = setting('github','');

$catNames = ['infra'=>'Infrastructure','dev'=>'Development','sec'=>'Security','ai'=>'AI & Automation'];
$byCat = [];
foreach ($skills as $s) { $byCat[$s['category']][] = $s; }
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"><meta name="viewport" content="width=device-width,initial-scale=1.0">
<title>Résumé — <?= rv($name) ?></title>
<link href="https://fonts.googleapis.com/css2?family=Orbitron:wght@600;700;800&family=Rajdhani:wght@400;500;600;700&family=Inter:wght@300;400;500&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
<style>
:root{--gold:#bd8c06;--ink:#1a1a1e;--soft:#555;--line:#e2e0d8;--bg:#0a0a12}
*{box-sizing:border-box;margin:0;padding:0}
body{background:#15151c;font-family:'Rajdhani',sans-serif;color:#1a1a1e;padding:2rem;display:flex;flex-direction:column;align-items:center}
.bar{width:100%;max-width:820px;display:flex;justify-content:space-between;align-items:center;margin-bottom:1.25rem}
.bar a,.bar button{font-family:'Orbitron';font-size:.62rem;letter-spacing:.12em;text-transform:uppercase;padding:.6rem 1.2rem;border-radius:6px;border:1px solid #f5c518;color:#f5c518;background:transparent;cursor:pointer;text-decoration:none;display:inline-flex;align-items:center;gap:.5rem}
.bar button.dl{background:#f5c518;color:#000;border:none;font-weight:700}
.page{width:100%;max-width:820px;background:#fff;border-radius:8px;overflow:hidden;box-shadow:0 30px 80px rgba(0,0,0,.5)}
.head{background:linear-gradient(135deg,#0a0a12,#15151f);color:#fff;padding:2.5rem 2.5rem 2rem;position:relative}
.head::after{content:'';position:absolute;bottom:0;left:0;right:0;height:3px;background:linear-gradient(90deg,#bd8c06,#f5c518,#bd8c06)}
.head h1{font-family:'Orbitron';font-size:2rem;font-weight:800;letter-spacing:.02em}
.head .role{font-family:'Orbitron';font-size:.7rem;letter-spacing:.2em;text-transform:uppercase;color:#f5c518;margin-top:.5rem}
.head .stmt{color:rgba(255,255,255,.65);margin-top:1rem;font-size:1rem;max-width:560px;font-family:'Inter'}
.head .contact{display:flex;gap:1.5rem;flex-wrap:wrap;margin-top:1.25rem;font-size:.85rem;font-family:'Inter'}
.head .contact a{color:#f5c518;text-decoration:none;display:inline-flex;align-items:center;gap:.4rem}
.body{padding:2rem 2.5rem 2.5rem}
.sec{margin-bottom:1.75rem;break-inside:avoid}
.sec h2{font-family:'Orbitron';font-size:.78rem;letter-spacing:.12em;text-transform:uppercase;color:#bd8c06;border-bottom:2px solid var(--line);padding-bottom:.5rem;margin-bottom:1rem;display:flex;align-items:center;gap:.5rem}
.skill-cats{display:grid;grid-template-columns:1fr 1fr;gap:1rem 2rem}
.scat h3{font-family:'Orbitron';font-size:.6rem;letter-spacing:.1em;text-transform:uppercase;color:var(--ink);margin-bottom:.5rem}
.srow{display:flex;align-items:center;gap:.6rem;margin-bottom:.4rem;font-size:.9rem}
.srow .nm{flex:1;color:#333}
.sbar{width:70px;height:5px;background:var(--line);border-radius:3px;overflow:hidden}
.sbar div{height:100%;background:linear-gradient(90deg,#bd8c06,#f5c518)}
.srow .pc{font-family:'Orbitron';font-size:.62rem;color:#bd8c06;width:30px;text-align:right}
.cert-list,.proj-list{display:grid;gap:.6rem}
.cert{display:flex;align-items:flex-start;gap:.75rem}
.cert i{color:#bd8c06;margin-top:.2rem}
.cert .ct{font-weight:600;color:var(--ink);font-size:.92rem}
.cert .ci{color:var(--soft);font-size:.82rem}
.proj{padding:.6rem 0;border-bottom:1px solid var(--line)}
.proj:last-child{border:none}
.proj .pt{font-weight:600;color:var(--ink);font-size:.95rem}
.proj .pd{color:var(--soft);font-size:.84rem;margin-top:.15rem;font-family:'Inter'}
.proj .ps{font-size:.72rem;color:#bd8c06;margin-top:.25rem}
@media print{
  body{background:#fff;padding:0}
  .bar{display:none}
  .page{box-shadow:none;max-width:100%;border-radius:0}
  .head{background:#15151f!important;-webkit-print-color-adjust:exact;print-color-adjust:exact}
  @page{margin:1cm}
}
@media(max-width:640px){.skill-cats{grid-template-columns:1fr}.head,.body{padding:1.5rem}}
</style>
</head>
<body>
<div class="bar">
  <a href="index.html"><i class="fas fa-arrow-left"></i> Back to Site</a>
  <button class="dl" onclick="window.print()"><i class="fas fa-download"></i> Download PDF</button>
</div>

<div class="page">
  <div class="head">
    <h1><?= rv($name) ?></h1>
    <div class="role">Founder &amp; Chairman · Cybersecurity Specialist · AI Engineer</div>
    <div class="stmt"><?= rv($stmt) ?></div>
    <div class="contact">
      <a href="mailto:<?= rv($email) ?>"><i class="fas fa-envelope"></i> <?= rv($email) ?></a>
      <?php if($li): ?><a href="<?= rv($li) ?>"><i class="fab fa-linkedin"></i> LinkedIn</a><?php endif; ?>
      <?php if($gh): ?><a href="<?= rv($gh) ?>"><i class="fab fa-github"></i> GitHub</a><?php endif; ?>
      <?php if($tg): ?><a href="<?= rv($tg) ?>"><i class="fab fa-telegram"></i> Telegram</a><?php endif; ?>
      <span style="color:rgba(255,255,255,.5)"><i class="fas fa-location-dot"></i> Shiraz, Iran</span>
    </div>
  </div>

  <div class="body">
    <div class="sec">
      <h2><i class="fas fa-user"></i> Profile</h2>
      <p style="color:#444;font-family:'Inter';font-size:.92rem;line-height:1.7">
        Young technology entrepreneur and Founder &amp; Chairman of Zarvan Fanavaran Pars Ltd.
        Specialized in cybersecurity, AI systems, server infrastructure, and software engineering.
        Passionate about building futuristic, secure, and scalable digital infrastructures.
      </p>
    </div>

    <?php if($byCat): ?>
    <div class="sec">
      <h2><i class="fas fa-bars-progress"></i> Technical Skills</h2>
      <div class="skill-cats">
        <?php foreach($catNames as $ck=>$cn): if(empty($byCat[$ck]))continue; ?>
          <div class="scat">
            <h3><?= rv($cn) ?></h3>
            <?php foreach($byCat[$ck] as $s): ?>
              <div class="srow"><span class="nm"><?= rv($s['name_en']) ?></span><span class="sbar"><div style="width:<?= (int)$s['percent'] ?>%"></div></span><span class="pc"><?= (int)$s['percent'] ?>%</span></div>
            <?php endforeach; ?>
          </div>
        <?php endforeach; ?>
      </div>
    </div>
    <?php endif; ?>

    <?php if($projs): ?>
    <div class="sec">
      <h2><i class="fas fa-folder-open"></i> Selected Projects</h2>
      <div class="proj-list">
        <?php foreach($projs as $p): ?>
          <div class="proj">
            <div class="pt"><?= rv($p['title_en']) ?></div>
            <div class="pd"><?= rv($p['desc_en']) ?></div>
            <?php if($p['stack']): ?><div class="ps"><?= rv($p['stack']) ?></div><?php endif; ?>
          </div>
        <?php endforeach; ?>
      </div>
    </div>
    <?php endif; ?>

    <?php if($certs): ?>
    <div class="sec">
      <h2><i class="fas fa-certificate"></i> Certifications</h2>
      <div class="cert-list">
        <?php foreach($certs as $c): ?>
          <div class="cert"><i class="<?= rv($c['icon']) ?>"></i><div><div class="ct"><?= rv($c['title_en']) ?></div><div class="ci"><?= rv($c['issuer_en']) ?></div></div></div>
        <?php endforeach; ?>
      </div>
    </div>
    <?php endif; ?>
  </div>
</div>
</body>
</html>
