/* ════════════════════════════════════════════════════════════════
   shared-extended.css
   CSS esteso per risorse con layout proprietario (guide tecniche,
   simulatori UI, contenuti ad alto grado di personalizzazione).

   Caricamento: SEMPRE dopo shared.css — i selettori qui presenti
   sovrascrivono intenzionalmente quelli di shared (es. body, h2,
   h3, .section-num) per garantire l'identità visiva della risorsa.

   Prima risorsa che lo usa: database/guida-libreoffice-base-query/
   ════════════════════════════════════════════════════════════════ */

:root {
  --bg: #f5f2eb;
  --paper: #fffef9;
  --ink: #1a1a18;
  --muted: #6b6b60;
  --accent: #d64f2a;
  --accent2: #2a6dd6;
  --accent3: #2aad5e;
  --border: #d0ccc0;
  --lo-blue: #1c71b8;
  --lo-toolbar: #e8e4dc;
  --lo-grid-header: #e2ddd4;
  --lo-selected: #b8d4f0;
  --lo-check: #2a6dd6;
  --lo-join: #555;
  --warning: #e8a020;
  --note-bg: #fff8e6;
  --tip-bg: #e8f4e8;
}

* { box-sizing: border-box; margin: 0; padding: 0; }

body {
  font-family: 'Sora', sans-serif;
  background: var(--bg);
  color: var(--ink);
  line-height: 1.7;
}

/* ── HEADER ── */
header {
  background: var(--ink);
  color: var(--paper);
  padding: 3rem 2rem 2rem;
  position: relative;
  overflow: hidden;
}
header::before {
  content: '';
  position: absolute;
  top: -60px; right: -60px;
  width: 300px; height: 300px;
  border-radius: 50%;
  background: var(--accent);
  opacity: 0.12;
}
.header-back-link {
  display: inline-flex; align-items: center; gap: 5px;
  font-size: 0.78rem; color: rgba(255,255,255,0.65);
  text-decoration: none; transition: color 0.2s;
  font-family: 'Sora', sans-serif;
  position: absolute; top: 1rem; left: 1.5rem;
}
.header-back-link:hover { color: white; }
header .badge {
  display: inline-block;
  font-family: 'Space Mono', monospace;
  font-size: 0.7rem;
  background: var(--accent);
  color: white;
  padding: 3px 10px;
  border-radius: 2px;
  letter-spacing: 0.1em;
  text-transform: uppercase;
  margin-bottom: 1rem;
}
header h1 {
  font-size: clamp(1.8rem, 4vw, 2.8rem);
  font-weight: 700;
  letter-spacing: -0.02em;
  line-height: 1.1;
}
header h1 span { color: var(--accent); }
header p {
  margin-top: 0.8rem;
  color: #aaa9a0;
  font-size: 0.95rem;
  max-width: 600px;
}
.db-pill {
  display: inline-flex;
  align-items: center;
  gap: 6px;
  margin-top: 1rem;
  background: rgba(255,255,255,0.08);
  border: 1px solid rgba(255,255,255,0.15);
  padding: 4px 12px;
  border-radius: 20px;
  font-family: 'Space Mono', monospace;
  font-size: 0.75rem;
  color: #ccc;
}
.db-pill::before { content: '🗄'; }

/* ── INDICE ── */
nav.toc {
  padding: 0.7rem 1.5rem;
  display: flex;
  flex-wrap: wrap;
  gap: 0.25rem;
  align-items: center;
  justify-content: center;
}

@media (max-width: 600px) {
  nav.toc {
    flex-wrap: nowrap;
    overflow-x: auto;
    scrollbar-width: none;
    justify-content: flex-start;
  }
  nav.toc::-webkit-scrollbar { display: none; }
  nav.toc .row-break { display: none; }
}

nav.toc a {
  font-size: 0.82rem;
  font-family: 'Sora', sans-serif;
  font-weight: 500;
  color: #aaa9a0;
  text-decoration: none;
  padding: 5px 13px;
  border-radius: 20px;
  border: 1px solid transparent;
  transition: all 0.18s;
  white-space: nowrap;
  letter-spacing: 0.01em;
}
nav.toc a:hover {
  background: rgba(255,255,255,0.1);
  color: white;
  border-color: rgba(255,255,255,0.2);
}
nav.toc a.active {
  background: var(--accent);
  color: white;
  border-color: var(--accent);
  font-weight: 700;
}
nav.toc span { display: none; }
nav.toc span.row-break {
  display: block;
  width: 100%;
  height: 0;
}

.toc-wrap {
  position: sticky;
  top: 0;
  z-index: 100;
  background: var(--ink);
  border-bottom: 3px solid var(--accent);
}

/* ── LAYOUT ── */
main { max-width: 960px; margin: 0 auto; padding: 2rem 1.5rem 4rem; }

/* ── SEZIONI ── */
section {
  margin-bottom: 4rem;
  scroll-margin-top: 70px;
}
.section-label {
  font-family: 'Space Mono', monospace;
  font-size: 0.82rem;
  font-weight: 700;
  color: var(--accent);
  letter-spacing: 0.12em;
  text-transform: uppercase;
  margin-bottom: 0.5rem;
  opacity: 1;
}
h2 {
  font-size: 1.7rem;
  font-weight: 700;
  letter-spacing: -0.02em;
  border-bottom: 2px solid var(--ink);
  padding-bottom: 0.5rem;
  margin-bottom: 1.5rem;
}
h3 {
  font-size: 1.1rem;
  font-weight: 600;
  margin: 1.8rem 0 0.8rem;
  color: var(--accent2);
}
p { margin-bottom: 0.9rem; }

/* ── MOCK UI ── */
.lo-window {
  border: 1px solid #999;
  border-radius: 4px;
  box-shadow: 0 4px 20px rgba(0,0,0,0.12);
  background: #f0ece4;
  margin: 1.5rem 0;
  overflow: hidden;
  font-size: 0.82rem;
}
.lo-titlebar {
  background: linear-gradient(to bottom, #5a5a5a, #3a3a3a);
  color: white;
  padding: 5px 10px;
  font-size: 0.78rem;
  display: flex;
  justify-content: space-between;
  align-items: center;
  font-family: 'Space Mono', monospace;
}
.lo-titlebar .win-btns { display: flex; gap: 5px; }
.lo-titlebar .win-btn {
  width: 12px; height: 12px; border-radius: 50%;
  display: inline-block;
}
.btn-close { background: #ff5f57; }
.btn-min { background: #ffbd2e; }
.btn-max { background: #28ca41; }

.lo-menubar {
  background: #e8e4dc;
  padding: 3px 8px;
  display: flex;
  gap: 1rem;
  font-size: 0.78rem;
  border-bottom: 1px solid #ccc;
}
.lo-menubar span { cursor: default; color: #333; }
.lo-menubar span:hover { background: var(--lo-blue); color: white; padding: 0 4px; border-radius: 2px; }

.lo-toolbar {
  background: #e8e4dc;
  padding: 4px 8px;
  border-bottom: 1px solid #ccc;
  display: flex;
  gap: 4px;
  align-items: center;
  flex-wrap: wrap;
}
.lo-btn {
  background: #f5f2eb;
  border: 1px solid #bbb;
  border-radius: 3px;
  padding: 2px 8px;
  font-size: 0.72rem;
  cursor: default;
  color: #333;
  white-space: nowrap;
}
.lo-btn:hover { background: #dde8f5; border-color: var(--lo-blue); }
.lo-sep { width: 1px; height: 18px; background: #bbb; margin: 0 2px; }

/* ── PANNELLO TABELLE ── */
.lo-tables-area {
  background: #f5f2eb;
  min-height: 160px;
  padding: 15px;
  display: flex;
  gap: 40px;
  align-items: flex-start;
  border-bottom: 3px solid #ccc;
  position: relative;
  flex-wrap: wrap;
}
.lo-table-box {
  background: white;
  border: 1px solid #888;
  border-radius: 2px;
  min-width: 120px;
  font-size: 0.75rem;
  box-shadow: 2px 2px 4px rgba(0,0,0,0.08);
}
.lo-table-header {
  background: #dce8f5;
  border-bottom: 1px solid #888;
  padding: 3px 8px;
  font-weight: bold;
  font-size: 0.72rem;
  display: flex;
  align-items: center;
  gap: 4px;
}
.lo-table-header::before { content: '▦'; font-size: 0.65rem; color: #555; }
.lo-table-fields { padding: 4px 0; }
.lo-field {
  padding: 2px 8px;
  cursor: default;
}
.lo-field.pk { font-weight: bold; }
.lo-field.pk::before { content: '🔑 '; font-size: 0.6rem; }
.lo-field:hover { background: var(--lo-selected); }

/* Join line SVG overlay */
.lo-join-svg {
  position: absolute;
  top: 0; left: 0;
  width: 100%; height: 100%;
  pointer-events: none;
}

/* ── GRIGLIA QUERY ── */
.lo-grid {
  background: white;
  overflow-x: auto;
}
.lo-grid table {
  border-collapse: collapse;
  width: 100%;
  min-width: 600px;
  font-size: 0.75rem;
}
.lo-grid th {
  background: var(--lo-grid-header);
  border: 1px solid #ccc;
  padding: 4px 8px;
  text-align: left;
  font-weight: 600;
  font-size: 0.72rem;
  white-space: nowrap;
  min-width: 110px;
}
.lo-grid th.row-label {
  background: var(--lo-grid-header);
  min-width: 70px;
  position: sticky;
  left: 0;
  z-index: 2;
}
.lo-grid td {
  border: 1px solid #ddd;
  padding: 3px 8px;
  min-width: 110px;
  height: 22px;
  vertical-align: middle;
}
.lo-grid td.row-label {
  background: var(--lo-grid-header);
  font-weight: 600;
  font-size: 0.7rem;
  position: sticky;
  left: 0;
  z-index: 1;
}
.lo-grid .selected-col { background: #e8f0fc; }
.lo-checkbox {
  width: 14px; height: 14px;
  border: 1px solid #888;
  border-radius: 2px;
  display: inline-flex;
  align-items: center;
  justify-content: center;
  background: white;
}
.lo-checkbox.checked {
  background: white;
  color: var(--lo-check);
  font-size: 11px;
}
.lo-checkbox.checked::after { content: '✓'; font-weight: bold; }
.lo-dropdown {
  font-size: 0.72rem;
  color: #333;
}
.lo-dropdown::after { content: ' ▾'; color: #888; }
.criteria-value { color: #c00; font-family: 'Space Mono', monospace; font-size: 0.72rem; }
.alias-value { color: #060; font-family: 'Space Mono', monospace; font-size: 0.72rem; }
.function-value { color: #606; font-family: 'Space Mono', monospace; font-size: 0.72rem; }

/* ── RISULTATI ── */
.lo-results {
  border-bottom: 3px solid #ccc;
  overflow-x: auto;
}
.lo-results table {
  border-collapse: collapse;
  width: 100%;
  font-size: 0.78rem;
}
.lo-results th {
  background: #dce8f5;
  border: 1px solid #bbb;
  padding: 4px 10px;
  text-align: left;
  font-weight: 600;
}
.lo-results td {
  border: 1px solid #ddd;
  padding: 3px 10px;
}
.lo-results tr:first-child td { border-top: 2px solid var(--lo-blue); }
.lo-results tr:hover td { background: #f0f5ff; }
.lo-statusbar {
  background: #e0dcd4;
  padding: 2px 10px;
  font-size: 0.7rem;
  color: #555;
  border-top: 1px solid #bbb;
  font-family: 'Space Mono', monospace;
}

/* ── DIALOG ── */
.lo-dialog {
  background: #f0ece4;
  border: 1px solid #888;
  border-radius: 4px;
  box-shadow: 4px 4px 16px rgba(0,0,0,0.2);
  width: 260px;
  margin: 1rem auto;
  overflow: hidden;
}
.lo-dialog-title {
  background: linear-gradient(to bottom, #5a5a5a, #3a3a3a);
  color: white;
  padding: 5px 10px;
  font-size: 0.78rem;
  display: flex;
  justify-content: space-between;
  align-items: center;
  font-family: 'Space Mono', monospace;
}
.lo-dialog-body { padding: 12px; }
.lo-dialog-body label {
  font-weight: 600;
  font-size: 0.8rem;
  display: block;
  margin-bottom: 6px;
}
.lo-list {
  border: 1px solid #aaa;
  background: white;
  border-radius: 2px;
  overflow: hidden;
  margin-bottom: 10px;
}
.lo-list-item {
  padding: 4px 10px;
  font-size: 0.78rem;
  cursor: default;
}
.lo-list-item.selected { background: var(--lo-blue); color: white; }
.lo-input-group { margin-bottom: 8px; }
.lo-input-group label { font-size: 0.75rem; display: block; margin-bottom: 3px; }
.lo-input {
  width: 100%;
  border: 1px solid #aaa;
  background: white;
  padding: 4px 6px;
  font-size: 0.78rem;
  border-radius: 2px;
  font-family: 'Space Mono', monospace;
}
.lo-dialog-btns {
  display: flex;
  gap: 6px;
  justify-content: flex-end;
  padding: 0 12px 12px;
}
.lo-dialog-btn {
  padding: 4px 16px;
  font-size: 0.78rem;
  border-radius: 3px;
  border: 1px solid #999;
  background: #e8e4dc;
  cursor: default;
}
.lo-dialog-btn.primary {
  background: var(--lo-blue);
  color: white;
  border-color: var(--lo-blue);
}

/* ── CALLOUT BOXES ── */
.callout {
  border-radius: 4px;
  padding: 1rem 1.2rem;
  margin: 1.2rem 0;
  display: flex;
  gap: 0.8rem;
  align-items: flex-start;
}
.callout-icon { font-size: 1.2rem; flex-shrink: 0; margin-top: 2px; }
.callout-body { flex: 1; font-size: 0.88rem; }
.callout-body strong { display: block; margin-bottom: 0.2rem; }
.callout.warning { background: var(--note-bg); border-left: 4px solid var(--warning); }
.callout.tip { background: var(--tip-bg); border-left: 4px solid var(--accent3); }
.callout.info { background: #e8f0ff; border-left: 4px solid var(--accent2); }
.callout.danger {
  background: var(--accent);
  border-left: none;
  border: 3px solid #8b1a06;
  box-shadow: 0 4px 20px rgba(214,79,42,0.35);
}
.callout.danger .callout-icon { font-size: 1.8rem; }
.callout.danger .callout-body { color: white; font-size: 0.95rem; }
.callout.danger .callout-body strong { color: white; font-size: 1.05rem; }

/* ── STEP LIST ── */
.steps { counter-reset: step; margin: 1rem 0; }
.step {
  counter-increment: step;
  display: flex;
  gap: 1rem;
  margin-bottom: 1rem;
  align-items: flex-start;
}
.step::before {
  content: counter(step);
  flex-shrink: 0;
  width: 28px; height: 28px;
  background: var(--ink);
  color: white;
  border-radius: 50%;
  display: flex;
  align-items: center;
  justify-content: center;
  font-family: 'Space Mono', monospace;
  font-size: 0.75rem;
  font-weight: 700;
  margin-top: 2px;
}
.step-body { flex: 1; font-size: 0.9rem; }
.step-body code {
  background: #e8e4dc;
  padding: 1px 5px;
  border-radius: 3px;
  font-family: 'Space Mono', monospace;
  font-size: 0.82rem;
  color: var(--accent);
}

/* ── SCHEMA DB ── */
.schema-wrap {
  overflow-x: auto;
  margin: 1.5rem 0;
}
.schema {
  display: flex;
  gap: 30px;
  padding: 20px;
  background: #f5f2eb;
  border: 1px solid var(--border);
  border-radius: 4px;
  min-width: 700px;
  align-items: flex-start;
  position: relative;
}

/* ── SCREENSHOT wrapper ── */
.screenshot {
  margin: 1.5rem 0;
  border: 2px solid var(--border);
  border-radius: 6px;
  overflow: hidden;
  box-shadow: 0 4px 16px rgba(0,0,0,0.1);
}
.screenshot img { max-width: 100%; display: block; margin: 0 auto; }
.screenshot figcaption {
  background: var(--lo-grid-header);
  padding: 6px 12px;
  font-size: 0.78rem;
  color: var(--muted);
  font-family: 'Space Mono', monospace;
  border-top: 1px solid var(--border);
}

/* ── HIGHLIGHT ── */
.highlight-box {
  background: var(--ink);
  color: var(--paper);
  border-radius: 4px;
  padding: 1rem 1.2rem;
  margin: 1.2rem 0;
  font-size: 0.88rem;
}
.highlight-box h4 { color: var(--accent); margin-bottom: 0.5rem; font-family: 'Space Mono', monospace; font-size: 0.8rem; }
.highlight-box ul { padding-left: 1.2rem; }
.highlight-box li { margin-bottom: 0.3rem; }

/* ── TABS ── */
.tabs { margin: 1.5rem 0; }
.tab-btns { display: flex; gap: 0; border-bottom: 2px solid var(--border); }
.tab-btn {
  padding: 8px 18px;
  font-size: 0.82rem;
  font-family: 'Sora', sans-serif;
  font-weight: 600;
  border: 1px solid var(--border);
  border-bottom: none;
  background: #e8e4dc;
  color: var(--muted);
  cursor: pointer;
  border-radius: 4px 4px 0 0;
  margin-bottom: -2px;
  transition: all 0.15s;
}
.tab-btn.active { background: var(--paper); color: var(--ink); border-bottom: 2px solid var(--paper); z-index: 1; }
.tab-content { display: none; padding: 1.2rem; background: var(--paper); border: 1px solid var(--border); border-top: none; }
.tab-content.active { display: block; }

/* ── CONFRONTO TABELLA ── */
.compare-table {
  width: 100%;
  border-collapse: collapse;
  font-size: 0.85rem;
  margin: 1rem 0;
}
.compare-table th {
  background: var(--ink);
  color: white;
  padding: 8px 12px;
  text-align: left;
}
.compare-table td {
  padding: 8px 12px;
  border-bottom: 1px solid var(--border);
  vertical-align: top;
}
.compare-table tr:nth-child(even) td { background: #f5f2eb; }
.compare-table code {
  background: #e8e4dc;
  padding: 1px 5px;
  border-radius: 3px;
  font-family: 'Space Mono', monospace;
  font-size: 0.8rem;
  color: var(--accent);
}

/* ── FOOTER ── */
footer {
  background: var(--ink);
  color: #888;
  text-align: center;
  padding: 2rem;
  font-size: 0.78rem;
  font-family: 'Space Mono', monospace;
}
footer span { color: var(--accent); }
footer a { color: #888; text-decoration: none; }
footer a:hover { color: var(--accent); }

/* ── ANIMAZIONI ── */
@keyframes fadeIn { from { opacity: 0; transform: translateY(12px); } to { opacity: 1; transform: none; } }
section { animation: fadeIn 0.4s ease both; }

/* ── RESPONSIVE ── */
@media (max-width: 600px) {
  .lo-tables-area { flex-direction: column; gap: 15px; }
}

/* ── CAMPO HIGHLIGHT ── */
.field-pill {
  display: inline-block;
  background: #dce8f5;
  border: 1px solid #aac;
  border-radius: 3px;
  padding: 1px 7px;
  font-family: 'Space Mono', monospace;
  font-size: 0.78rem;
  color: #234;
}
.table-pill {
  display: inline-block;
  background: #e8dce8;
  border: 1px solid #cac;
  border-radius: 3px;
  padding: 1px 7px;
  font-family: 'Space Mono', monospace;
  font-size: 0.78rem;
  color: #423;
}
.op-pill {
  display: inline-block;
  background: #ffeedd;
  border: 1px solid #dba;
  border-radius: 3px;
  padding: 1px 7px;
  font-family: 'Space Mono', monospace;
  font-size: 0.78rem;
  color: #640;
}

/* ── NUMERO SEZIONE LATERALE ── */
.section-num {
  font-family: 'Space Mono', monospace;
  font-size: 3rem;
  font-weight: 700;
  color: var(--border);
  line-height: 1;
  float: right;
  margin-left: 1rem;
  margin-top: -0.5rem;
}

/* ── BACK TO TOP ── */
.back-to-top {
  position: fixed; bottom: 1.5rem; right: 1.5rem; z-index: 200;
  width: 40px; height: 40px;
  background: var(--accent); color: #fff;
  border: none; border-radius: 50%;
  font-size: 1rem; cursor: pointer;
  display: flex; align-items: center; justify-content: center;
  box-shadow: 0 2px 12px rgba(214,79,42,.35);
  opacity: 0; pointer-events: none;
  transition: opacity .22s ease, transform .22s ease;
}
.back-to-top.visible { opacity: 1; pointer-events: all; }
.back-to-top:hover { transform: translateY(-2px); }