/* SQL-Kurs · SQL-Labor. Lizenz: CC BY-SA 4.0 · herrseibert.de · Erstellt von der KI Claude von Anthropic. */
:root {
  --sql-kw: #0b5cad; --sql-s: #a3410f; --sql-n: #6a1b9a;
  --zl-ja: #d7f0d8; --zl-nein: #f1f1f1; --zl-mark: #fff1a8;
}
:root[data-theme="dark"] { --sql-kw: #7cb8ff; --sql-s: #ffb07a; --sql-n: #d6a5f0; --zl-ja: #1f3d22; --zl-nein: #1b2129; --zl-mark: #5a4b0c; }
@media (prefers-color-scheme: dark) {
  :root:not([data-theme="light"]) { --sql-kw: #7cb8ff; --sql-s: #ffb07a; --sql-n: #d6a5f0; --zl-ja: #1f3d22; --zl-nein: #1b2129; --zl-mark: #5a4b0c; }
}

.labor { margin: 14px 0; }
.labor .muted, .training .muted { color: var(--muted); font-size: 14px; }

/* SQL-Code */
pre.sql, .labor-eingabe, .labor-zeile {
  font-family: ui-monospace, "Cascadia Mono", "DejaVu Sans Mono", Consolas, monospace; font-size: 16.5px; line-height: 1.6;
}
pre.sql {
  background: var(--code-bg); border-radius: 10px; padding: 12px 14px; margin: 10px 0; white-space: pre-wrap; overflow-wrap: anywhere;
  direction: ltr; text-align: left;
}
pre.sql .k, code.sql .k { color: var(--sql-kw); font-weight: 700; }
pre.sql .s, code.sql .s { color: var(--sql-s); }
pre.sql .n, code.sql .n { color: var(--sql-n); }

/* Eingabe */
.labor-code { direction: ltr; text-align: left; }
.labor-eingabe {
  display: block; width: 100%; resize: vertical; min-height: 4.2em; padding: 10px 12px; border-radius: 10px;
  border: 2px solid var(--line); background: var(--surface); color: var(--text);
}
.labor-eingabe:focus { outline: none; border-color: var(--accent); }
.labor-bausteine { display: flex; flex-wrap: wrap; gap: 6px; margin: 8px 0 0; }
.baustein {
  font-family: ui-monospace, "DejaVu Sans Mono", Consolas, monospace; font-size: 15px; font-weight: 700;
  min-width: 38px; min-height: 38px; padding: 4px 10px; border-radius: 8px; cursor: pointer;
  border: 1px solid var(--line); background: var(--surface-2); color: var(--text); touch-action: manipulation;
}
.baustein.kw { color: var(--sql-kw); }
.baustein.name { font-weight: 600; }
.baustein.op { color: var(--sql-n); }
.baustein:hover { border-color: var(--accent); }

/* Puzzle */
.labor-zeile {
  display: flex; flex-wrap: wrap; gap: 6px; align-items: center; min-height: 58px; padding: 8px 10px;
  border: 2px dashed var(--accent); border-radius: 10px; background: var(--surface);
}
.labor-zeile .platzhalter { font-family: system-ui, sans-serif; font-size: 15px; }
.labor-vorrat { min-height: 46px; }

/* Lücken */
.luecke {
  font: inherit; font-size: 16px; padding: 1px 6px; margin: 0 2px; border-radius: 6px;
  border: 2px solid var(--input-line); background: var(--input-bg); color: var(--text); vertical-align: baseline;
}
select.luecke { padding: 1px 4px; }

/* Knöpfe, Rückmeldung */
.labor-ctrl { display: flex; gap: 10px; align-items: center; flex-wrap: wrap; margin-top: 10px; }
.labor.geloest .labor-eingabe, .labor.geloest .labor-zeile { border-color: var(--basis); }

/* Tabellen */
.labor-tabellenbox { margin: 0 0 10px; }
details.labor-tabelle { border: 1px solid var(--line); border-radius: 10px; background: var(--surface); margin: 8px 0; direction: ltr; text-align: left; }
details.labor-tabelle > summary { cursor: pointer; padding: 8px 12px; font-weight: 700; }
details.labor-tabelle > summary .tabname { font-family: ui-monospace, "DejaVu Sans Mono", Consolas, monospace; }
details.labor-tabelle[open] > summary { border-bottom: 1px solid var(--line); }
details.labor-tabelle .labor-scroll { max-height: 320px; }
details.labor-tabelle .labor-anzahl { display: none; }
.labor-scroll { overflow: auto; max-height: 360px; direction: ltr; }
table.labor-tab { border-collapse: collapse; width: 100%; font-size: 14.5px; }
table.labor-tab th, table.labor-tab td { padding: 4px 10px; border-bottom: 1px solid var(--line); text-align: left; white-space: nowrap; }
table.labor-tab th {
  position: sticky; top: 0; background: var(--surface-2); z-index: 1;
  font-family: ui-monospace, "DejaVu Sans Mono", Consolas, monospace; font-size: 13.5px; color: var(--muted);
}
table.labor-tab td.num { text-align: right; font-variant-numeric: tabular-nums; }
table.labor-tab .null { color: var(--muted); font-style: italic; }
.labor-erg { margin-top: 12px; border: 1px solid var(--line); border-radius: 10px; padding: 8px 10px; background: var(--surface); }
.labor-erg-t { margin: 0 0 6px; font-weight: 800; color: var(--muted); font-size: 14px; text-transform: uppercase; letter-spacing: .04em; }
.labor-anzahl { margin: 6px 0 0; font-size: 14px; color: var(--muted); font-weight: 700; }
.labor-leer { color: var(--muted); margin: 4px 0; }

/* Zeitlupe */
.labor-zeitlupe .zl-status { min-height: 2.8em; margin: 10px 0; padding: 8px 12px; border-radius: 10px; background: var(--surface-2); }
.labor-zeitlupe .zl-status mark { background: var(--zl-mark); color: inherit; border-radius: 3px; padding: 0 2px; }
.labor-zeitlupe .zl-status .ja { color: var(--ok-fg); }
.labor-zeitlupe .zl-status .nein { color: var(--hint-fg); }
.labor-zeitlupe th.zl-bed { color: var(--text); background: var(--zl-mark); }
.labor-zeitlupe td.zl-bed { font-weight: 700; }
.labor-zeitlupe tr.zl-ja td { background: var(--zl-ja); }
.labor-zeitlupe tr.zl-nein td { background: var(--zl-nein); color: var(--muted); text-decoration: line-through; }
.labor-zeitlupe tr.zl-jetzt td { outline: 2px solid var(--accent); outline-offset: -2px; }

/* Training */
.training { border-top: 1px dashed var(--line); padding-top: 10px; margin-top: 10px; }
.tr-kopf { display: flex; gap: 12px; align-items: center; flex-wrap: wrap; margin-bottom: 6px; }
.tr-punkte { display: flex; gap: 6px; flex-wrap: wrap; list-style: none; margin: 0; padding: 0; }
.tr-p {
  width: 34px; height: 34px; border-radius: 50%; border: 2px solid var(--line); background: var(--surface);
  color: var(--muted); font-weight: 800; cursor: pointer; font-size: 14px;
}
.tr-p.akt { border-color: var(--accent); color: var(--accent); }
.tr-p.ok { border-color: var(--basis); background: var(--basis); color: #fff; }
.tr-nr { margin: 8px 0 0; font-size: 14px; color: var(--muted); font-weight: 700; }
.tr-text { margin: 2px 0 6px; font-size: 18px; }
.stufe { display: inline-block; letter-spacing: 2px; color: var(--plus); }

@media print {
  .labor-bausteine, .labor-ctrl, .tr-kopf .tr-punkte { display: none !important; }
}

/* Gruppen-Ansicht (GROUP BY) */
.labor-gruppen .zl-status { min-height: 2.8em; margin: 10px 0; padding: 8px 12px; border-radius: 10px; background: var(--surface-2); }
.labor-gruppen tr.gr-a td { background: var(--surface); }
.labor-gruppen tr.gr-b td { background: var(--surface-2); }
.labor-gruppen tr.gr-neu-gr td { border-top: 3px solid var(--accent); }
.labor-gruppen th.zl-bed { color: var(--text); background: var(--zl-mark); }
.labor-gruppen td.zl-bed { font-weight: 700; }

/* ID-Faden */
.faden-tabs { display: grid; gap: 12px; grid-template-columns: repeat(auto-fit, minmax(260px, 1fr)); align-items: start; }
.faden-tab .labor-scroll { max-height: 280px; border: 1px solid var(--line); border-radius: 10px; }
.faden-name { margin: 4px 0; font-weight: 700; }
.fk-pfeil { font-weight: 400; color: var(--accent); font-size: 12px; }
button.fk {
  font: inherit; font-weight: 800; min-width: 34px; padding: 1px 8px; border-radius: 6px; cursor: pointer;
  border: 2px solid var(--accent); background: var(--surface); color: var(--accent);
}
button.fk:hover { background: var(--accent); color: var(--surface); }
tr.faden-quelle td { background: var(--zl-mark); }
tr.faden-ziel td { background: var(--zl-ja); font-weight: 700; }
.labor-faden .zl-status { margin: 0 0 10px; padding: 8px 12px; border-radius: 10px; background: var(--surface-2); min-height: 2.6em; }

/* ER-Diagramm */
.er-diagramm { margin: 12px 0; overflow-x: auto; direction: ltr; }
.er-diagramm svg { max-width: 100%; height: auto; min-width: 520px; font-family: system-ui, sans-serif; }
.er-box { fill: var(--surface); stroke: var(--navy); stroke-width: 2; }
.er-kopf { fill: var(--navy); }
.er-name { fill: var(--surface); font-weight: 800; font-size: 15px; font-family: ui-monospace, "DejaVu Sans Mono", monospace; }
.er-spalte { fill: var(--text); font-size: 13.5px; font-family: ui-monospace, "DejaVu Sans Mono", monospace; }
.er-spalte.pk { font-weight: 800; text-decoration: underline; }
.er-spalte.fk { fill: var(--accent); }
.er-fkziel { fill: var(--muted); font-size: 11.5px; }
.er-linie { stroke: var(--muted); stroke-width: 2; }
.er-raute { fill: var(--surface-2); stroke: var(--muted); stroke-width: 1.5; }
.er-rtext { fill: var(--text); font-size: 12px; font-weight: 700; }
.er-kard { fill: var(--plus); font-size: 16px; font-weight: 800; }
.er-legende { font-size: 13.5px; color: var(--muted); margin: 4px 0 0; }

/* JOIN-Zeitlupe */
.jl-paar { display: grid; gap: 12px; grid-template-columns: repeat(auto-fit, minmax(260px, 1fr)); align-items: start; }
.jl-paar .labor-scroll { max-height: 260px; border: 1px solid var(--line); border-radius: 10px; }
.jl-erg .labor-scroll { max-height: 260px; }
.labor-joinlupe .zl-status mark { background: var(--zl-mark); color: inherit; border-radius: 3px; padding: 0 2px; }
.labor-zeit { margin: 6px 0 0; font-weight: 700; color: var(--ok-fg); }

/* Projekt-Labor, Planer, Formular-Baukasten */
.projekt-leiste { display: flex; flex-wrap: wrap; gap: 8px; align-items: center; margin: 0 0 12px; padding: 10px; border-radius: 12px; background: var(--surface-2); }
.projekt-leiste .btn { font-size: 15px; padding: 7px 12px; }
.pj-pruefliste { margin-top: 12px; border: 1px solid var(--line); border-radius: 10px; padding: 8px 12px; }
.pj-liste { list-style: none; margin: 0; padding: 0; }
.pj-liste li { display: flex; gap: 10px; padding: 5px 0; border-bottom: 1px dashed var(--line); }
.pj-liste li:last-child { border-bottom: 0; }
.pj-liste li.ok { color: var(--ok-fg); }
.pj-haken { font-weight: 800; flex: none; width: 18px; }
.planer-tabellen { display: grid; gap: 12px; grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); }
.planer-tab { border: 2px solid var(--navy); border-radius: 12px; padding: 10px; background: var(--surface); }
.planer-kopf { display: flex; gap: 8px; margin-bottom: 8px; }
.planer-kopf input { flex: 1; font: 700 16px ui-monospace, "DejaVu Sans Mono", monospace; padding: 6px 8px; border-radius: 8px; border: 2px solid var(--input-line); background: var(--input-bg); color: var(--text); }
.planer-spalten { width: 100%; border-collapse: collapse; font-size: 14px; }
.planer-spalten th { text-align: left; color: var(--muted); font-size: 13px; }
.planer-spalten td { padding: 2px 3px; }
.planer-spalten input[type=text], .planer-spalten input:not([type]), .planer-spalten select {
  width: 100%; font: 14px ui-monospace, "DejaVu Sans Mono", monospace; padding: 3px 5px; border-radius: 6px; border: 1px solid var(--line); background: var(--surface); color: var(--text); }
.pl-weg, .pl-spweg, .ff-weg { border: 0; background: transparent; color: var(--muted); cursor: pointer; font-size: 16px; }
.planer-check ul { margin: 6px 0 0; padding-left: 20px; }
.formular-baukasten .fb-zeile { margin: 8px 0; }
.formular-baukasten select, .formular-baukasten input:not([type=checkbox]) { font: inherit; padding: 4px 8px; border-radius: 8px; border: 1px solid var(--line); background: var(--surface); color: var(--text); max-width: 100%; }
.fb-felder td, .fb-felder th { padding: 4px 6px; }
.fb-cb { white-space: nowrap; margin-inline-end: 8px; font-family: ui-monospace, "DejaVu Sans Mono", monospace; font-size: 14px; }
.fb-form { display: grid; gap: 10px; max-width: 460px; padding: 16px; border-radius: 14px; border: 2px solid var(--accent); background: var(--surface); box-shadow: var(--shadow); }
.fb-feld { display: grid; gap: 4px; font-weight: 700; }
.fb-feld input, .fb-feld select { font-weight: 400; padding: 8px 10px !important; }
.planer-spalten td:nth-child(2), .planer-spalten td:nth-child(4) { min-width: 96px; }
.planer-spalten td:nth-child(1) { width: 40%; }
