/* ========================================================
   QueryEdge — Core Design System
   ======================================================== */

/* ---------- Custom Properties ---------- */
:root {
  /* Palette – deep navy / electric teal accent */
  --bg-primary:    #0b0f19;
  --bg-surface:    #111827;
  --bg-elevated:   #1a2236;
  --border-subtle: rgba(255, 255, 255, 0.06);
  --border-accent: #38bdf8;
  --text-primary:  #e2e8f0;
  --text-muted:    #94a3b8;
  --text-dim:      #64748b;
  --accent:        #38bdf8;
  --accent-glow:   rgba(56, 189, 248, 0.15);
  --accent-hover:  #7dd3fc;
  --success:       #34d399;
  --success-glow:  rgba(52, 211, 153, 0.12);
  --error:         #f87171;
  --error-glow:    rgba(248, 113, 113, 0.12);
  --warning:       #fbbf24;

  /* Typography */
  --font-sans:  'Inter', system-ui, -apple-system, sans-serif;
  --font-mono:  'JetBrains Mono', 'Fira Code', 'Cascadia Code', monospace;

  /* Spacing & radii */
  --radius-sm:  6px;
  --radius-md:  12px;
  --radius-lg:  20px;
  --space-xs:   0.25rem;
  --space-sm:   0.5rem;
  --space-md:   1rem;
  --space-lg:   1.5rem;
  --space-xl:   2.5rem;
  --space-2xl:  4rem;

  /* Transitions */
  --ease-out:   cubic-bezier(0.16, 1, 0.3, 1);
  --transition: 0.25s var(--ease-out);
}

/* ---------- Reset ---------- */
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }
html { font-size: 16px; -webkit-font-smoothing: antialiased; -moz-osx-font-smoothing: grayscale; }

body {
  font-family: var(--font-sans);
  background: var(--bg-primary);
  color: var(--text-primary);
  line-height: 1.6;
  min-height: 100vh;
  overflow-x: hidden;
}

/* Subtle grid background */
body::before {
  content: '';
  position: fixed;
  inset: 0;
  background-image:
    linear-gradient(rgba(255, 255, 255, 0.015) 1px, transparent 1px),
    linear-gradient(90deg, rgba(255, 255, 255, 0.015) 1px, transparent 1px);
  background-size: 60px 60px;
  pointer-events: none;
  z-index: 0;
}

/* ---------- Layout Shell ---------- */
.app-wrapper {
  position: relative;
  z-index: 1;
  max-width: 960px;
  margin: 0 auto;
  padding: var(--space-lg) var(--space-md);
  display: flex;
  flex-direction: column;
  gap: var(--space-xl);
  min-height: 100vh;
}

/* ---------- Header ---------- */
.app-header {
  text-align: center;
  padding: var(--space-2xl) 0 var(--space-lg);
}

.app-header__logo {
  display: inline-flex;
  align-items: center;
  gap: var(--space-sm);
  font-size: 1.75rem;
  font-weight: 700;
  letter-spacing: -0.03em;
  color: var(--text-primary);
}

.app-header__logo .logo-icon {
  width: 36px;
  height: 36px;
  background: linear-gradient(135deg, var(--accent), #818cf8);
  border-radius: var(--radius-sm);
  display: grid;
  place-items: center;
  font-size: 1rem;
  color: var(--bg-primary);
  box-shadow: 0 0 24px var(--accent-glow);
}

.app-header__tagline {
  margin-top: var(--space-xs);
  font-size: 0.9rem;
  color: var(--text-dim);
  font-weight: 400;
}

/* ---------- Drop Zone ---------- */
#drop-zone {
  position: relative;
  border: 2px dashed var(--text-dim);
  border-radius: var(--radius-lg);
  padding: var(--space-2xl) var(--space-lg);
  text-align: center;
  cursor: pointer;
  transition:
    border-color var(--transition),
    background var(--transition),
    box-shadow var(--transition),
    transform var(--transition);
  background: var(--bg-surface);
  overflow: hidden;
}

#drop-zone::before {
  content: '';
  position: absolute;
  inset: 0;
  border-radius: inherit;
  background: radial-gradient(circle at 50% 40%, var(--accent-glow), transparent 70%);
  opacity: 0;
  transition: opacity var(--transition);
  pointer-events: none;
}

#drop-zone:hover,
#drop-zone:focus-visible {
  border-color: var(--accent);
  background: var(--bg-elevated);
}

#drop-zone:hover::before {
  opacity: 1;
}

/* Drag-active state */
#drop-zone.drag-active {
  border-color: var(--accent);
  background: var(--bg-elevated);
  box-shadow: 0 0 0 4px var(--accent-glow), 0 8px 40px var(--accent-glow);
  transform: scale(1.01);
}

#drop-zone.drag-active::before {
  opacity: 1;
}

.drop-zone__icon {
  font-size: 2.5rem;
  margin-bottom: var(--space-sm);
  display: block;
  transition: transform var(--transition);
}

#drop-zone.drag-active .drop-zone__icon {
  transform: translateY(-4px) scale(1.1);
}

.drop-zone__title {
  font-size: 1.1rem;
  font-weight: 600;
  color: var(--text-primary);
  margin-bottom: var(--space-xs);
}

.drop-zone__subtitle {
  font-size: 0.85rem;
  color: var(--text-dim);
}

.drop-zone__subtitle a,
.drop-zone__subtitle .browse-link {
  color: var(--accent);
  cursor: pointer;
  text-decoration: underline;
  text-underline-offset: 2px;
  transition: color var(--transition);
}

.drop-zone__subtitle .browse-link:hover {
  color: var(--accent-hover);
}

/* Hidden file input */
#file-input {
  display: none;
}

/* ---------- File Info Panel ---------- */
#file-info {
  border-radius: var(--radius-md);
  background: var(--bg-surface);
  border: 1px solid var(--border-subtle);
  overflow: hidden;
  transition: opacity var(--transition), transform var(--transition);
}

#file-info[hidden] {
  display: none;
}

#file-info .file-info__header {
  display: flex;
  align-items: center;
  gap: var(--space-sm);
  padding: var(--space-md) var(--space-lg);
  background: var(--bg-elevated);
  border-bottom: 1px solid var(--border-subtle);
  font-weight: 600;
  font-size: 0.85rem;
  text-transform: uppercase;
  letter-spacing: 0.06em;
  color: var(--text-muted);
}

.file-info__header .status-dot {
  width: 8px;
  height: 8px;
  border-radius: 50%;
  background: var(--success);
  box-shadow: 0 0 8px var(--success-glow);
  animation: pulse-dot 2s ease-in-out infinite;
}

@keyframes pulse-dot {
  0%, 100% { opacity: 1; }
  50% { opacity: 0.5; }
}

.file-info__body {
  padding: var(--space-md) var(--space-lg);
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(180px, 1fr));
  gap: var(--space-md);
}

.file-info__item {
  display: flex;
  flex-direction: column;
  gap: 2px;
}

.file-info__label {
  font-size: 0.7rem;
  text-transform: uppercase;
  letter-spacing: 0.08em;
  color: var(--text-dim);
  font-weight: 500;
}

.file-info__value {
  font-family: var(--font-mono);
  font-size: 0.9rem;
  color: var(--text-primary);
  word-break: break-all;
}

/* ---------- Query Output ---------- */
#output {
  border-radius: var(--radius-md);
  background: var(--bg-surface);
  border: 1px solid var(--border-subtle);
  overflow: hidden;
  transition: opacity var(--transition), transform var(--transition);
}

#output[hidden] {
  display: none;
}

#output .output__header {
  display: flex;
  align-items: center;
  justify-content: space-between;
  padding: var(--space-md) var(--space-lg);
  background: var(--bg-elevated);
  border-bottom: 1px solid var(--border-subtle);
  font-weight: 600;
  font-size: 0.85rem;
  text-transform: uppercase;
  letter-spacing: 0.06em;
  color: var(--text-muted);
}

.output__body {
  padding: var(--space-lg);
  font-family: var(--font-mono);
  font-size: 0.85rem;
  line-height: 1.7;
  color: var(--text-muted);
  white-space: pre-wrap;
  min-height: 100px;
  max-height: 400px;
  overflow-y: auto;
}

.output__body::-webkit-scrollbar {
  width: 6px;
}

.output__body::-webkit-scrollbar-track {
  background: transparent;
}

.output__body::-webkit-scrollbar-thumb {
  background: var(--text-dim);
  border-radius: 3px;
}

.output__placeholder {
  display: flex;
  align-items: center;
  justify-content: center;
  min-height: 100px;
  color: var(--text-dim);
  font-size: 0.85rem;
  font-style: italic;
}

/* ---------- Toast / Status Messages ---------- */
.toast {
  position: fixed;
  bottom: var(--space-lg);
  right: var(--space-lg);
  padding: var(--space-sm) var(--space-lg);
  border-radius: var(--radius-sm);
  font-size: 0.85rem;
  font-weight: 500;
  color: var(--bg-primary);
  z-index: 1000;
  animation: toast-in 0.4s var(--ease-out) forwards;
  pointer-events: none;
}

.toast--success {
  background: var(--success);
  box-shadow: 0 4px 20px var(--success-glow);
}

.toast--error {
  background: var(--error);
  box-shadow: 0 4px 20px var(--error-glow);
}

@keyframes toast-in {
  from { opacity: 0; transform: translateY(12px) scale(0.96); }
  to   { opacity: 1; transform: translateY(0) scale(1); }
}

@keyframes toast-out {
  from { opacity: 1; transform: translateY(0) scale(1); }
  to   { opacity: 0; transform: translateY(-8px) scale(0.96); }
}

/* ---------- Error Banner ---------- */
.error-banner {
  padding: var(--space-md) var(--space-lg);
  border-radius: var(--radius-md);
  background: var(--error-glow);
  border: 1px solid var(--error);
  color: var(--error);
  font-size: 0.9rem;
  line-height: 1.5;
  text-align: center;
}

.error-banner strong {
  display: block;
  margin-bottom: var(--space-xs);
  font-size: 1rem;
}

/* ---------- Responsive ---------- */
@media (max-width: 640px) {
  .app-wrapper {
    padding: var(--space-md) var(--space-sm);
    gap: var(--space-lg);
  }

  .app-header {
    padding: var(--space-lg) 0 var(--space-md);
  }

  .app-header__logo {
    font-size: 1.35rem;
  }

  #drop-zone {
    padding: var(--space-xl) var(--space-md);
  }

  .file-info__body {
    grid-template-columns: 1fr;
  }
}

/* ---------- Accessibility ---------- */
@media (prefers-reduced-motion: reduce) {
  *, *::before, *::after {
    animation-duration: 0.01ms !important;
    transition-duration: 0.01ms !important;
  }
}

:focus-visible {
  outline: 2px solid var(--accent);
  outline-offset: 2px;
}

/* ---------- Loading spinner ---------- */
.spinner {
  display: inline-block;
  width: 18px;
  height: 18px;
  border: 2px solid var(--text-dim);
  border-top-color: var(--accent);
  border-radius: 50%;
  animation: spin 0.7s linear infinite;
  vertical-align: middle;
  margin-right: var(--space-xs);
}

@keyframes spin {
  to { transform: rotate(360deg); }
}

/* ---------- Output Badge ---------- */
.output__badge {
  font-size: 0.7rem;
  font-weight: 500;
  letter-spacing: 0.04em;
  color: var(--text-dim);
  background: var(--bg-primary);
  padding: 3px 10px;
  border-radius: 100px;
  border: 1px solid var(--border-subtle);
}

/* ---------- Preview Table ---------- */
.table-scroll {
  overflow-x: auto;
  overflow-y: auto;
  max-height: 480px;
  -webkit-overflow-scrolling: touch;
}

/* Scrollbar styling for the table wrapper */
.table-scroll::-webkit-scrollbar {
  width: 6px;
  height: 6px;
}

.table-scroll::-webkit-scrollbar-track {
  background: transparent;
}

.table-scroll::-webkit-scrollbar-thumb {
  background: var(--text-dim);
  border-radius: 3px;
}

.table-scroll::-webkit-scrollbar-corner {
  background: transparent;
}

.preview-table {
  width: 100%;
  border-collapse: collapse;
  font-family: var(--font-mono);
  font-size: 0.8rem;
  line-height: 1.5;
  white-space: nowrap;
}

/* ---- Header ---- */
.preview-table thead {
  position: sticky;
  top: 0;
  z-index: 2;
}

.preview-table th {
  background: var(--bg-elevated);
  color: var(--text-primary);
  font-weight: 600;
  text-align: left;
  padding: 10px 14px;
  border-bottom: 2px solid var(--accent);
  user-select: none;
}

.preview-table th .th__name {
  display: block;
  font-size: 0.8rem;
}

.preview-table th .th__type {
  display: block;
  font-size: 0.65rem;
  font-weight: 400;
  color: var(--accent);
  margin-top: 2px;
  text-transform: uppercase;
  letter-spacing: 0.05em;
  opacity: 0.8;
}

/* ---- Body cells ---- */
.preview-table td {
  padding: 8px 14px;
  color: var(--text-muted);
  border-bottom: 1px solid var(--border-subtle);
  max-width: 320px;
  overflow: hidden;
  text-overflow: ellipsis;
}

/* Zebra striping */
.preview-table tbody tr:nth-child(even) {
  background: rgba(255, 255, 255, 0.015);
}

/* Row hover */
.preview-table tbody tr:hover {
  background: rgba(56, 189, 248, 0.04);
}

.preview-table tbody tr:hover td {
  color: var(--text-primary);
}

/* NULL value badge */
.cell--null {
  color: var(--text-dim);
  font-style: italic;
  opacity: 0.6;
  font-size: 0.7rem;
  text-transform: uppercase;
  letter-spacing: 0.06em;
  background: rgba(255, 255, 255, 0.04);
  padding: 1px 6px;
  border-radius: 3px;
}

/* Truncated cell tooltip marker */
.preview-table td span[title] {
  cursor: help;
  border-bottom: 1px dotted var(--text-dim);
}

/* ---- When output body contains a table, remove default padding ---- */
.output__body:has(.table-scroll) {
  padding: 0;
  white-space: normal;
  max-height: none;
}

/* ========================================================
   SQL Console
   ======================================================== */

#sql-console {
  border-radius: var(--radius-md);
  background: var(--bg-surface);
  border: 1px solid var(--border-subtle);
  overflow: hidden;
  transition: opacity var(--transition), transform var(--transition);
}

#sql-console[hidden] {
  display: none;
}

/* ---------- Console Header ---------- */
.sql-console__header {
  display: flex;
  align-items: center;
  justify-content: space-between;
  flex-wrap: wrap;
  gap: var(--space-sm);
  padding: var(--space-md) var(--space-lg);
  background: var(--bg-elevated);
  border-bottom: 1px solid var(--border-subtle);
}

.sql-console__title {
  font-weight: 600;
  font-size: 0.85rem;
  text-transform: uppercase;
  letter-spacing: 0.06em;
  color: var(--text-muted);
}

/* ---------- Preset Pills ---------- */
.sql-console__presets {
  display: flex;
  flex-wrap: wrap;
  gap: 6px;
}

.preset-pill {
  background: var(--bg-primary);
  color: var(--text-muted);
  border: 1px solid var(--border-subtle);
  border-radius: 100px;
  padding: 4px 12px;
  font-family: var(--font-mono);
  font-size: 0.7rem;
  font-weight: 500;
  letter-spacing: 0.02em;
  cursor: pointer;
  transition:
    color var(--transition),
    border-color var(--transition),
    background var(--transition),
    box-shadow var(--transition);
  white-space: nowrap;
  user-select: none;
}

.preset-pill:hover {
  color: var(--accent);
  border-color: var(--accent);
  background: var(--accent-glow);
}

.preset-pill:active {
  transform: scale(0.96);
  box-shadow: 0 0 0 2px var(--accent-glow);
}

/* ---------- Editor Area ---------- */
.sql-console__editor {
  padding: var(--space-md) var(--space-lg);
}

/* ---------- SQL Textarea ---------- */
.sql-input {
  display: block;
  width: 100%;
  min-height: 110px;
  max-height: 300px;
  resize: vertical;
  background: var(--bg-primary);
  color: var(--text-primary);
  border: 1px solid var(--border-subtle);
  border-radius: var(--radius-sm);
  padding: var(--space-md);
  font-family: var(--font-mono);
  font-size: 0.85rem;
  line-height: 1.6;
  tab-size: 2;
  caret-color: var(--accent);
  outline: none;
  transition: border-color var(--transition), box-shadow var(--transition);
}

.sql-input::placeholder {
  color: var(--text-dim);
  opacity: 0.6;
}

.sql-input:focus {
  border-color: var(--accent);
  box-shadow: 0 0 0 3px var(--accent-glow);
}

/* Custom scrollbar */
.sql-input::-webkit-scrollbar {
  width: 6px;
}

.sql-input::-webkit-scrollbar-track {
  background: transparent;
}

.sql-input::-webkit-scrollbar-thumb {
  background: var(--text-dim);
  border-radius: 3px;
}

/* ---------- Actions Row ---------- */
.sql-console__actions {
  display: flex;
  align-items: center;
  gap: var(--space-md);
  margin-top: var(--space-sm);
  flex-wrap: wrap;
}

/* ---------- Execute Button ---------- */
.run-btn {
  display: inline-flex;
  align-items: center;
  gap: var(--space-xs);
  padding: 8px 20px;
  background: linear-gradient(135deg, var(--accent), #818cf8);
  color: var(--bg-primary);
  border: none;
  border-radius: var(--radius-sm);
  font-family: var(--font-sans);
  font-size: 0.85rem;
  font-weight: 600;
  cursor: pointer;
  transition:
    opacity var(--transition),
    transform var(--transition),
    box-shadow var(--transition);
  white-space: nowrap;
}

.run-btn:hover:not(:disabled) {
  opacity: 0.9;
  box-shadow: 0 4px 20px var(--accent-glow);
  transform: translateY(-1px);
}

.run-btn:active:not(:disabled) {
  transform: scale(0.97) translateY(0);
}

.run-btn:disabled {
  opacity: 0.6;
  cursor: not-allowed;
}

.run-btn .spinner {
  width: 14px;
  height: 14px;
  border-width: 2px;
  border-color: rgba(11, 15, 25, 0.3);
  border-top-color: var(--bg-primary);
  margin-right: 2px;
}

/* ---------- Keyboard Hint ---------- */
.sql-console__hint {
  font-size: 0.72rem;
  color: var(--text-dim);
  font-family: var(--font-mono);
  letter-spacing: 0.02em;
}

/* ---------- Query Stats Badge ---------- */
.query-stats {
  font-family: var(--font-mono);
  font-size: 0.78rem;
  color: var(--success);
  margin-left: auto;
  white-space: nowrap;
}

.query-stats[hidden] {
  display: none;
}

/* ---------- Query Error Banner ---------- */
#query-error {
  margin: 0;
}

#query-error[hidden] {
  display: none;
}

.query-error__inner {
  display: flex;
  align-items: flex-start;
  gap: var(--space-sm);
  padding: var(--space-md) var(--space-lg);
  background: var(--error-glow);
  border-top: 1px solid rgba(248, 113, 113, 0.2);
  color: var(--error);
  font-size: 0.82rem;
  line-height: 1.5;
}

.query-error__icon {
  flex-shrink: 0;
  display: inline-flex;
  align-items: center;
  justify-content: center;
  width: 20px;
  height: 20px;
  border-radius: 50%;
  background: var(--error);
  color: var(--bg-primary);
  font-size: 0.65rem;
  font-weight: 700;
  margin-top: 1px;
}

.query-error__text {
  display: flex;
  flex-direction: column;
  gap: 2px;
  min-width: 0;
}

.query-error__text strong {
  font-weight: 600;
  font-size: 0.82rem;
}

.query-error__text span {
  font-family: var(--font-mono);
  font-size: 0.78rem;
  word-break: break-word;
  white-space: pre-wrap;
  opacity: 0.9;
}

/* ---------- Responsive adjustments for SQL Console ---------- */
@media (max-width: 640px) {
  .sql-console__header {
    flex-direction: column;
    align-items: flex-start;
  }

  .sql-console__presets {
    width: 100%;
  }

  .sql-console__editor {
    padding: var(--space-sm) var(--space-md);
  }

  .sql-console__actions {
    flex-direction: column;
    align-items: stretch;
  }

  .query-stats {
    margin-left: 0;
  }

  .run-btn {
    justify-content: center;
  }
}