/* ============================================================
   Frontek Data — SQL sui file dell'utente, DuckDB-WASM nel browser
   Palette brand frontek + tema chiaro/scuro (allineato a tools)
   ============================================================ */

:root{
  --teal:#2A9D8F; --coral:#E76F51; --dark:#264653; --gold:#E9C46A;
  --green:#8AB17D; --danger:#c0432c;

  --bg:#f4f2ea; --bg2:#ece8dc; --card:#ffffff; --line:#e4e0d4;
  --ink:#21333b; --muted:#5a6b73; --faint:#8a979c;
  --shadow:0 1px 2px rgba(38,70,83,.06), 0 6px 20px rgba(38,70,83,.06);
  --accent:var(--teal);
  --code:#0e1a1f; --code-ink:#d6efe9;

  /* grafici: una serie, validata (scripts/validate_palette.js) su entrambe le superfici */
  --series-1:#2A9D8F; --grid:#ebe8df; --axis:#d6d1c4; --hover:rgba(42,157,143,.10);
}

@media (prefers-color-scheme: dark){
  :root:not([data-theme="light"]){
    --bg:#0f1a1f; --bg2:#132229; --card:#17272e; --line:#24373f;
    --ink:#e8efee; --muted:#9db0b6; --faint:#6f8189;
    --shadow:0 1px 2px rgba(0,0,0,.3), 0 8px 26px rgba(0,0,0,.32);
    --code:#0a1418; --code-ink:#cfe9e3;
    --grid:#203239; --axis:#2c434c; --hover:rgba(42,157,143,.16);
  }
}
:root[data-theme="dark"]{
  --bg:#0f1a1f; --bg2:#132229; --card:#17272e; --line:#24373f;
  --ink:#e8efee; --muted:#9db0b6; --faint:#6f8189;
  --shadow:0 1px 2px rgba(0,0,0,.3), 0 8px 26px rgba(0,0,0,.32);
  --code:#0a1418; --code-ink:#cfe9e3;
  --grid:#203239; --axis:#2c434c; --hover:rgba(42,157,143,.16);
}

*{ box-sizing:border-box; }
html{ -webkit-text-size-adjust:100%; }
body{
  margin:0; min-height:100vh;
  font-family:system-ui,-apple-system,"Segoe UI",Roboto,Helvetica,Arial,sans-serif;
  color:var(--ink);
  background:
    radial-gradient(1200px 600px at 15% -10%, rgba(42,157,143,.10), transparent 60%),
    radial-gradient(1000px 500px at 100% 0%, rgba(231,111,81,.08), transparent 55%),
    var(--bg);
  display:flex; flex-direction:column;
}
a{ color:var(--accent); text-decoration:none; }
a:hover{ text-decoration:underline; }
h1,h2,h3{ line-height:1.2; }
[hidden]{ display:none !important; }
kbd{ font-family:ui-monospace,Menlo,Consolas,monospace; font-size:.72rem; opacity:.8;
  border:1px solid rgba(255,255,255,.45); border-radius:5px; padding:1px 5px; margin-left:4px; }

/* ---- TOP BAR ---- */
.top{ display:flex; align-items:center; gap:12px; padding:14px clamp(14px,4vw,34px); }
.brand{ font-size:1.02rem; letter-spacing:.16em; font-weight:800; text-transform:uppercase; color:var(--ink); }
.brand:hover{ text-decoration:none; }
.brand span{ color:var(--coral); }
.top__spacer{ flex:1 1 auto; }
.iconbtn{ border:1px solid var(--line); background:var(--card); color:var(--ink);
  width:40px; height:40px; border-radius:11px; font-size:1.15rem; cursor:pointer;
  display:inline-flex; align-items:center; justify-content:center;
  transition:transform .12s ease, border-color .12s ease; }
.iconbtn:hover{ transform:translateY(-1px); border-color:var(--accent); }

.engine{ display:inline-flex; align-items:center; gap:7px; font-size:.8rem; color:var(--muted); }
.engine__dot{ width:8px; height:8px; border-radius:50%; background:var(--gold); }
.engine[data-state="loading"] .engine__dot{ animation:pulse 1.2s ease-in-out infinite; }
.engine[data-state="ready"] .engine__dot{ background:var(--teal); }
.engine[data-state="error"] .engine__dot{ background:var(--danger); }
.engine[data-state="error"]{ color:var(--danger); }
@keyframes pulse{ 50%{ opacity:.3; } }

/* ---- LAYOUT ---- */
.wrap{ flex:1 1 auto; width:100%; max-width:1320px; margin:0 auto;
  padding:clamp(8px,2.4vw,22px) clamp(14px,4vw,34px) 26px; }
.card{ background:var(--card); border:1px solid var(--line); border-radius:16px; box-shadow:var(--shadow); }

/* ---- LANDING ---- */
.landing{ max-width:760px; margin:0 auto; text-align:center; padding-top:clamp(10px,4vh,40px); }
.landing__title{ margin:0 0 10px; font-size:clamp(1.6rem,4.6vw,2.4rem); letter-spacing:-.01em; }
.landing__sub{ margin:0 auto 26px; color:var(--muted); font-size:1.05rem; max-width:600px; }
.drop{ display:flex; flex-direction:column; align-items:center; gap:8px; cursor:pointer;
  padding:clamp(28px,6vh,52px) 20px; border:2px dashed var(--axis); border-radius:20px;
  background:var(--card); box-shadow:var(--shadow);
  transition:border-color .12s ease, background .12s ease; }
.drop:hover, .drop.is-over{ border-color:var(--accent); background:var(--hover); }
.drop:focus-within{ outline:2px solid var(--accent); outline-offset:2px; }
.drop__ic{ width:54px; height:54px; border-radius:14px; display:flex; align-items:center; justify-content:center;
  font-size:1.6rem; font-weight:800; color:#fff; background:linear-gradient(135deg,var(--teal),var(--dark)); }
.drop__main{ font-weight:700; font-size:1.08rem; }
.drop__hint{ color:var(--muted); font-size:.86rem; }
.landing__actions{ margin:18px 0 0; }
.points{ list-style:none; padding:0; margin:34px 0 0; display:grid; gap:14px;
  grid-template-columns:repeat(3,1fr); text-align:left; }
.points li{ background:var(--card); border:1px solid var(--line); border-radius:14px; padding:14px 16px; }
.points b{ display:block; margin-bottom:4px; }
.points span{ color:var(--muted); font-size:.88rem; }

/* ---- WORKSPACE ---- */
.work{ display:grid; grid-template-columns:260px minmax(0,1fr); gap:16px; align-items:start; }
.mainpane{ display:flex; flex-direction:column; gap:16px; min-width:0; }

.side{ background:var(--card); border:1px solid var(--line); border-radius:16px; box-shadow:var(--shadow);
  padding:14px; position:sticky; top:12px; max-height:calc(100vh - 24px); overflow:auto; }
.side__head{ display:flex; align-items:center; justify-content:space-between; gap:8px; margin-bottom:10px; }
.side__title{ margin:0; font-size:1rem; }
.side__hint{ margin:12px 0 0; font-size:.78rem; color:var(--faint); }
.side__sample{ margin-top:8px; text-align:left; }
.tables{ list-style:none; margin:0; padding:0; display:flex; flex-direction:column; gap:10px; }
.tbl{ border:1px solid var(--line); border-radius:12px; padding:9px 10px; background:var(--bg2); }
.tbl__head{ display:flex; align-items:center; gap:6px; }
.tbl__name{ font-family:ui-monospace,Menlo,Consolas,monospace; font-weight:700; font-size:.9rem;
  background:none; border:0; padding:0; color:var(--ink); cursor:pointer; text-align:left;
  overflow:hidden; text-overflow:ellipsis; white-space:nowrap; flex:1 1 auto; }
.tbl__name:hover{ color:var(--accent); }
.tbl__x{ border:0; background:none; color:var(--faint); cursor:pointer; font-size:1rem; padding:0 2px; }
.tbl__x:hover{ color:var(--danger); }
.tbl__meta{ font-size:.75rem; color:var(--muted); margin:2px 0 6px; }
.tbl__acts{ display:flex; gap:6px; margin-bottom:6px; }
.tbl__cols{ list-style:none; margin:0; padding:0; max-height:220px; overflow:auto; }
.tbl__cols li{ display:flex; justify-content:space-between; gap:8px; font-size:.8rem; padding:2px 0; }
.col{ background:none; border:0; padding:0; color:var(--ink); cursor:pointer; text-align:left;
  font-family:ui-monospace,Menlo,Consolas,monospace; font-size:.8rem;
  overflow:hidden; text-overflow:ellipsis; white-space:nowrap; }
.col:hover{ color:var(--accent); }
.col__type{ color:var(--faint); font-size:.72rem; white-space:nowrap; }
.linkbtn{ border:0; background:none; padding:0; color:var(--accent); font-size:.78rem; cursor:pointer; }
.linkbtn:hover{ text-decoration:underline; }

/* ---- EDITOR ---- */
.editor{ padding:12px; }
.sql{ width:100%; min-height:150px; resize:vertical; display:block;
  font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace; font-size:.92rem; line-height:1.55;
  border:1px solid var(--line); border-radius:12px; background:var(--code); color:var(--code-ink);
  padding:12px 14px; outline:none; tab-size:2; }
.sql:focus{ border-color:var(--accent); }
.editor__bar{ display:flex; flex-wrap:wrap; align-items:center; gap:10px; margin-top:10px; }
.status{ font-size:.86rem; color:var(--muted); min-height:1.1em; }
.status--ok{ color:var(--ink); }
.status--err{ color:var(--danger); white-space:pre-wrap; font-family:ui-monospace,Menlo,Consolas,monospace; font-size:.82rem; }

/* ---- CONTROLLI ---- */
.btn{ border:0; background:var(--accent); color:#fff; padding:10px 16px; border-radius:10px;
  font-size:.92rem; font-weight:600; cursor:pointer; transition:filter .12s ease; display:inline-flex;
  align-items:center; gap:4px; }
.btn:hover{ filter:brightness(1.06); }
.btn:disabled{ opacity:.55; cursor:progress; }
.btn--light{ background:var(--bg2); color:var(--ink); border:1px solid var(--line); }
.btn--ghost{ background:transparent; color:var(--accent); border:1px solid var(--line); }
.btn--sm{ padding:6px 10px; font-size:.82rem; border-radius:8px; }
.sel{ border:1px solid var(--line); border-radius:10px; background:var(--card); color:var(--ink);
  padding:9px 10px; font-size:.88rem; cursor:pointer; outline:none; max-width:220px; }
.sel:focus{ border-color:var(--accent); }

/* ---- RISULTATI ---- */
.results{ padding:12px; min-width:0; }
.results.is-stale .grid, .results.is-stale .chart{ opacity:.45; transition:opacity .15s ease; }
.results__bar{ display:flex; flex-wrap:wrap; align-items:center; gap:8px; margin-bottom:10px; }
.results__spacer{ flex:1 1 auto; }
.results__label{ font-size:.8rem; color:var(--muted); }
.tabs{ display:inline-flex; background:var(--bg2); border:1px solid var(--line); border-radius:10px; padding:3px; }
.tab{ border:0; background:none; color:var(--muted); padding:6px 14px; border-radius:7px;
  font-size:.88rem; font-weight:600; cursor:pointer; }
.tab.is-on{ background:var(--card); color:var(--ink); box-shadow:var(--shadow); }

.grid{ overflow:auto; max-height:60vh; border:1px solid var(--line); border-radius:10px; }
.grid--small{ max-height:300px; margin-top:8px; }
.grid table{ border-collapse:collapse; width:max-content; min-width:100%; font-size:.84rem; }
.grid th, .grid td{ padding:6px 12px; border-bottom:1px solid var(--line); text-align:left;
  white-space:nowrap; max-width:420px; overflow:hidden; text-overflow:ellipsis; }
.grid th{ position:sticky; top:0; background:var(--bg2); font-weight:700; z-index:1; }
.grid th small{ display:block; font-weight:400; color:var(--faint); font-size:.7rem; }
.grid td.num, .grid th.num{ text-align:right; font-variant-numeric:tabular-nums; }
.grid td.null{ color:var(--faint); font-style:italic; }
.grid tbody tr:hover{ background:var(--hover); }
.grid .rn{ color:var(--faint); text-align:right; font-variant-numeric:tabular-nums; }
.pager{ display:flex; align-items:center; justify-content:flex-end; gap:10px; margin-top:10px;
  font-size:.84rem; color:var(--muted); font-variant-numeric:tabular-nums; }

/* ---- GRAFICO ---- */
.chartctl{ display:flex; flex-wrap:wrap; gap:10px 16px; align-items:center; margin-bottom:6px; }
.chartctl label{ display:inline-flex; align-items:center; gap:7px; font-size:.84rem; color:var(--muted); }
.chart__title{ margin:12px 0 2px; font-weight:700; font-size:.95rem; }
.chart{ position:relative; width:100%; }
.chart svg{ display:block; width:100%; height:auto; overflow:visible; }
.chart__note{ margin:4px 0 0; font-size:.8rem; color:var(--faint); min-height:1em; }
.chart__data{ margin-top:10px; font-size:.86rem; }
.chart__data summary{ cursor:pointer; color:var(--muted); }
.chart text{ fill:var(--muted); font-size:11px; font-variant-numeric:tabular-nums; }
.chart .ax-label{ fill:var(--ink); }
.chart .gridline{ stroke:var(--grid); stroke-width:1; shape-rendering:crispEdges; }
.chart .baseline{ stroke:var(--axis); stroke-width:1; shape-rendering:crispEdges; }
.chart .mark{ fill:var(--series-1); }
.chart .line{ fill:none; stroke:var(--series-1); stroke-width:2; stroke-linejoin:round; stroke-linecap:round; }
.chart .dot{ fill:var(--series-1); stroke:var(--card); stroke-width:2; }
.chart .dot--soft{ fill-opacity:.55; stroke-width:1; }
.chart .hit{ fill:transparent; cursor:crosshair; }
.chart .hit:hover + .mark, .chart .mark.is-hot{ filter:brightness(1.15); }
.chart .band{ fill:transparent; }
.chart .band:hover, .chart .band:focus{ fill:var(--hover); outline:none; }
.chart .cross{ stroke:var(--faint); stroke-width:1; shape-rendering:crispEdges; pointer-events:none; }
.chart .endlabel{ fill:var(--ink); font-weight:600; }

.tip{ position:fixed; z-index:70; pointer-events:none; background:var(--card); color:var(--ink);
  border:1px solid var(--line); border-radius:10px; box-shadow:var(--shadow); padding:8px 11px;
  font-size:.82rem; max-width:320px; }
.tip__v{ display:flex; align-items:center; gap:7px; font-weight:700; font-size:.95rem; font-variant-numeric:tabular-nums; }
.tip__v i{ display:inline-block; width:12px; height:2px; background:var(--series-1); border-radius:1px; }
.tip__l{ color:var(--muted); margin-top:2px; overflow-wrap:anywhere; }

/* ---- DRAG & DROP su tutta la pagina ---- */
.dropveil{ position:fixed; inset:0; z-index:80; display:flex; align-items:center; justify-content:center;
  background:rgba(15,26,31,.55); pointer-events:none; }
.dropveil span{ background:var(--card); color:var(--ink); border:2px dashed var(--accent); border-radius:16px;
  padding:22px 30px; font-weight:700; font-size:1.1rem; }

/* ---- FOOTER ---- */
.foot{ text-align:center; color:var(--muted); font-size:.82rem; padding:20px 16px 28px;
  display:flex; flex-wrap:wrap; gap:8px; justify-content:center; align-items:center; }
.foot__dot{ color:var(--faint); }

/* ---- MODALE ---- */
.modal{ position:fixed; inset:0; z-index:60; display:flex; align-items:center; justify-content:center; padding:16px; }
.modal__backdrop{ position:absolute; inset:0; background:rgba(15,26,31,.55); }
.modal__box{ position:relative; width:100%; max-width:440px; background:var(--card);
  border:1px solid var(--line); border-radius:18px; box-shadow:var(--shadow); overflow:hidden; }
.modal__head{ display:flex; align-items:center; justify-content:space-between;
  padding:16px 18px; border-bottom:1px solid var(--line); }
.modal__head h2{ margin:0; font-size:1.15rem; }
.modal__body{ padding:18px; display:flex; flex-direction:column; gap:16px; }
.field{ display:flex; flex-direction:column; gap:8px; }
.field__label{ font-size:.82rem; font-weight:600; color:var(--muted); }
.field__select{ border:1px solid var(--line); border-radius:10px; background:var(--bg2);
  color:var(--ink); padding:11px 12px; font-size:.95rem; outline:none; }
.field__select:focus{ border-color:var(--accent); }
.field__hint{ font-size:.82rem; color:var(--muted); margin:0; }

/* ---- RESPONSIVE ---- */
@media (max-width:860px){
  .work{ grid-template-columns:1fr; }
  .side{ position:static; max-height:none; }
  .points{ grid-template-columns:1fr; }
}
@media (max-width:560px){
  .engine span:last-child{ display:none; }
  .results__label{ display:none; }
}

@media (hover:none){ .btn kbd{ display:none; } }