/* ── Reset & Base ─────────────────────────────────────── */
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }

:root {
  --bg:        #0f1117;
  --surface:   #1a1d27;
  --surface2:  #242838;
  --border:    #2e3347;
  --accent:    #5b7cf6;
  --accent2:   #7c5bf6;
  --danger:    #f65b5b;
  --success:   #5bf695;
  --text:      #e8eaf0;
  --text-muted:#8b93b0;
  --radius:    12px;
  --shadow:    0 4px 24px rgba(0,0,0,0.4);
}

body {
  font-family: 'Segoe UI', system-ui, -apple-system, sans-serif;
  background: var(--bg);
  color: var(--text);
  min-height: 100vh;
  display: flex;
  flex-direction: column;
}

/* ── Header ───────────────────────────────────────────── */
header {
  padding: 1.2rem 2rem;
  background: var(--surface);
  border-bottom: 1px solid var(--border);
  display: flex;
  align-items: center;
  gap: 1rem;
}
header h1 {
  font-size: 1.3rem;
  font-weight: 600;
  background: linear-gradient(135deg, var(--accent), var(--accent2));
  -webkit-background-clip: text;
  -webkit-text-fill-color: transparent;
}
.db-badge {
  font-size: 0.75rem;
  padding: 0.25rem 0.6rem;
  border-radius: 20px;
  background: var(--surface2);
  border: 1px solid var(--border);
  color: var(--text-muted);
}
.header-user {
  margin-left: auto;
  display: flex;
  align-items: center;
  gap: 0.75rem;
}
.user-badge {
  font-size: 0.8rem;
  color: var(--text-muted);
}
.logout-btn {
  display: flex;
  align-items: center;
  gap: 0.35rem;
  font-size: 0.8rem;
  padding: 0.35rem 0.75rem;
  border-radius: 8px;
  border: 1px solid var(--border);
  background: transparent;
  color: var(--text-muted);
  cursor: pointer;
  transition: border-color 0.2s, color 0.2s;
}
.logout-btn:hover { border-color: var(--danger); color: var(--danger); }
.logout-btn svg { width: 14px; height: 14px; }

/* ── Main layout ──────────────────────────────────────── */
main {
  flex: 1;
  display: grid;
  grid-template-rows: auto auto 1fr;
  gap: 1.5rem;
  padding: 1.5rem 2rem;
  max-width: 1400px;
  width: 100%;
  margin: 0 auto;
}

/* ── Mic section ──────────────────────────────────────── */
.mic-section {
  display: flex;
  flex-direction: column;
  align-items: center;
  gap: 1rem;
  padding: 2rem;
  background: var(--surface);
  border-radius: var(--radius);
  border: 1px solid var(--border);
}

#mic-btn {
  width: 96px;
  height: 96px;
  border-radius: 50%;
  border: 3px solid var(--accent);
  background: var(--surface2);
  color: var(--accent);
  cursor: pointer;
  display: flex;
  align-items: center;
  justify-content: center;
  transition: all 0.2s ease;
  box-shadow: 0 0 0 0 rgba(91,124,246,0.4);
}
#mic-btn:hover { background: rgba(91,124,246,0.1); transform: scale(1.05); }
#mic-btn.recording {
  border-color: var(--danger);
  color: var(--danger);
  background: rgba(246,91,91,0.1);
  animation: pulse 1.2s infinite;
}
#mic-btn svg { width: 40px; height: 40px; }

@keyframes pulse {
  0%   { box-shadow: 0 0 0 0 rgba(246,91,91,0.5); }
  70%  { box-shadow: 0 0 0 20px rgba(246,91,91,0); }
  100% { box-shadow: 0 0 0 0 rgba(246,91,91,0); }
}

.mic-top-row {
  display: flex;
  align-items: center;
  justify-content: space-between;
  width: 100%;
  max-width: 640px;
  gap: 1rem;
}

.mic-hint {
  font-size: 0.85rem;
  color: var(--text-muted);
}

.tts-toggle {
  display: flex;
  align-items: center;
  gap: 0.4rem;
  font-size: 0.82rem;
  color: var(--text-muted);
  cursor: pointer;
  user-select: none;
  white-space: nowrap;
  flex-shrink: 0;
}
.tts-toggle input[type="checkbox"] { display: none; }
.tts-toggle svg {
  width: 16px; height: 16px;
  opacity: 0.5;
  transition: opacity 0.2s, color 0.2s;
}
.tts-toggle:has(input:checked) svg   { opacity: 1; color: var(--accent); }
.tts-toggle:has(input:checked) span  { color: var(--accent); }
.tts-toggle:has(input:checked)       { color: var(--accent); }

/* ── Text query row ───────────────────────────────────── */
.text-query-row {
  display: flex;
  width: 100%;
  max-width: 640px;
  gap: 0.5rem;
}

#text-input {
  flex: 1;
  padding: 0.65rem 1rem;
  border-radius: 8px;
  border: 1px solid var(--border);
  background: var(--surface2);
  color: var(--text);
  font-size: 0.9rem;
  outline: none;
  transition: border-color 0.2s;
}
#text-input:focus { border-color: var(--accent); }
#text-input::placeholder { color: var(--text-muted); }

#text-send-btn {
  display: flex;
  align-items: center;
  justify-content: center;
  width: 42px;
  height: 42px;
  border-radius: 8px;
  border: 1px solid var(--accent);
  background: rgba(91,124,246,0.1);
  color: var(--accent);
  cursor: pointer;
  flex-shrink: 0;
  transition: background 0.2s;
}
#text-send-btn:hover { background: rgba(91,124,246,0.2); }
#text-send-btn svg { width: 18px; height: 18px; }

/* ── Status bar ───────────────────────────────────────── */
#status-bar {
  display: flex;
  align-items: center;
  gap: 0.6rem;
  padding: 0.8rem 1.2rem;
  border-radius: 8px;
  font-size: 0.9rem;
  background: var(--surface2);
  border: 1px solid var(--border);
  min-height: 44px;
  transition: all 0.3s;
}
#status-bar.error   { border-color: var(--danger); color: var(--danger); }
#status-bar.success { border-color: var(--success); color: var(--success); }
#status-bar.loading { color: var(--accent); }
.spinner {
  width: 18px; height: 18px;
  border: 2px solid var(--border);
  border-top-color: var(--accent);
  border-radius: 50%;
  animation: spin 0.8s linear infinite;
  flex-shrink: 0;
}
@keyframes spin { to { transform: rotate(360deg); } }

/* ── Results section ──────────────────────────────────── */
.results-section { display: flex; flex-direction: column; gap: 1rem; }

.result-meta {
  display: none;
  flex-direction: column;
  gap: 0.5rem;
  padding: 1rem 1.2rem;
  background: var(--surface);
  border-radius: var(--radius);
  border: 1px solid var(--border);
}
.result-meta.visible { display: flex; }

.transcription-row {
  display: flex;
  align-items: flex-start;
  gap: 0.6rem;
  font-size: 0.9rem;
}
.label { color: var(--text-muted); font-size: 0.8rem; white-space: nowrap; }
.transcription-text { font-style: italic; color: var(--text); }
.description-text { color: var(--text); font-weight: 500; }

.sql-toggle {
  font-size: 0.78rem;
  color: var(--accent);
  cursor: pointer;
  background: none;
  border: none;
  padding: 0;
  text-decoration: underline;
  align-self: flex-start;
}
.sql-block {
  display: none;
  background: #0a0c14;
  border: 1px solid var(--border);
  border-radius: 8px;
  padding: 0.8rem 1rem;
  font-family: 'Cascadia Code', 'Fira Code', monospace;
  font-size: 0.82rem;
  color: #a8d8ea;
  overflow-x: auto;
  white-space: pre-wrap;
  word-break: break-word;
}
.sql-block.visible { display: block; }

/* ── Table ────────────────────────────────────────────── */
.table-wrapper {
  overflow: auto;
  border-radius: var(--radius);
  border: 1px solid var(--border);
  background: var(--surface);
}
table {
  width: 100%;
  border-collapse: collapse;
  font-size: 0.875rem;
}
thead th {
  background: var(--surface2);
  padding: 0.7rem 1rem;
  text-align: left;
  font-weight: 600;
  color: var(--text-muted);
  border-bottom: 2px solid var(--border);
  cursor: pointer;
  user-select: none;
  white-space: nowrap;
}
thead th:hover { color: var(--accent); }
thead th.asc::after  { content: " ↑"; color: var(--accent); }
thead th.desc::after { content: " ↓"; color: var(--accent); }

tbody tr { border-bottom: 1px solid var(--border); transition: background 0.15s; }
tbody tr:last-child { border-bottom: none; }
tbody tr:hover { background: var(--surface2); }
tbody td { padding: 0.6rem 1rem; color: var(--text); }

.row-count {
  font-size: 0.8rem;
  color: var(--text-muted);
  padding: 0.5rem 1rem;
  background: var(--surface);
  border-top: 1px solid var(--border);
  border-radius: 0 0 var(--radius) var(--radius);
}

/* ── Responsive ───────────────────────────────────────── */
@media (max-width: 600px) {
  main { padding: 1rem; }
  header { padding: 1rem; }
  #mic-btn { width: 80px; height: 80px; }
}

/* ── Login page ───────────────────────────────────────── */
body.login-page {
  justify-content: center;
  align-items: center;
}

.login-card {
  width: 100%;
  max-width: 380px;
  background: var(--surface);
  border: 1px solid var(--border);
  border-radius: var(--radius);
  padding: 2.5rem 2rem;
  box-shadow: var(--shadow);
  display: flex;
  flex-direction: column;
  gap: 1.8rem;
}

.login-logo {
  display: flex;
  flex-direction: column;
  align-items: center;
  gap: 0.75rem;
}
.login-logo h1 {
  font-size: 1.4rem;
  font-weight: 600;
  background: linear-gradient(135deg, var(--accent), var(--accent2));
  -webkit-background-clip: text;
  -webkit-text-fill-color: transparent;
}

#login-form {
  display: flex;
  flex-direction: column;
  gap: 1rem;
}

.field-group {
  display: flex;
  flex-direction: column;
  gap: 0.4rem;
}
.field-group label {
  font-size: 0.82rem;
  color: var(--text-muted);
}
.field-group input {
  padding: 0.65rem 1rem;
  border-radius: 8px;
  border: 1px solid var(--border);
  background: var(--surface2);
  color: var(--text);
  font-size: 0.95rem;
  outline: none;
  transition: border-color 0.2s;
}
.field-group input:focus { border-color: var(--accent); }
.field-group input::placeholder { color: var(--text-muted); }

.login-error {
  font-size: 0.85rem;
  color: var(--danger);
  padding: 0.5rem 0.75rem;
  background: rgba(246,91,91,0.08);
  border: 1px solid rgba(246,91,91,0.3);
  border-radius: 6px;
}

#login-btn {
  display: flex;
  align-items: center;
  justify-content: center;
  padding: 0.75rem;
  border-radius: 8px;
  border: none;
  background: linear-gradient(135deg, var(--accent), var(--accent2));
  color: #fff;
  font-size: 0.95rem;
  font-weight: 600;
  cursor: pointer;
  transition: opacity 0.2s;
  min-height: 44px;
}
#login-btn:hover:not(:disabled) { opacity: 0.88; }
#login-btn:disabled { opacity: 0.5; cursor: not-allowed; }
#login-btn .spinner {
  border-top-color: #fff;
  border-color: rgba(255,255,255,0.3);
  border-top-color: #fff;
}