/* ---------- Base (light theme) ---------- */
:root {
  --bg: #f6f7f9;
  --panel: #ffffff;
  --panel-2: #f1f5f9;
  --border: #e2e8f0;
  --border-strong: #cbd5e1;
  --text: #0f172a;
  --muted: #64748b;
  --muted-soft: #94a3b8;
  --primary: #2563eb;
  --primary-hover: #1d4ed8;
  --danger: #dc2626;
  --danger-soft: #fef2f2;
  --danger-border: #fecaca;
  --success: #059669;
  --warn: #d97706;
  --accent: #fef3c7;
}

* { box-sizing: border-box; }

html, body {
  margin: 0; padding: 0;
  background: var(--bg);
  color: var(--text);
  font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto,
               "Helvetica Neue", Arial, sans-serif;
  font-size: 14px;
}

a { color: var(--primary); text-decoration: none; }
a:hover { text-decoration: underline; }

.muted { color: var(--muted); }
.small { font-size: 12px; }
.spacer { flex: 1; }
.hidden { display: none !important; }
.inline { display: inline-flex; align-items: center; gap: 6px; }
.stack { display: flex; flex-direction: column; gap: 12px; }

/* ---------- Buttons ---------- */
.btn {
  display: inline-flex; align-items: center; gap: 6px;
  padding: 7px 13px;
  border: 1px solid var(--border);
  background: #ffffff;
  color: var(--text);
  border-radius: 6px;
  cursor: pointer;
  font-size: 13px;
  transition: all .15s ease;
}
.btn:hover { background: var(--panel-2); border-color: var(--border-strong); }
.btn-primary {
  background: var(--primary); border-color: var(--primary); color: #fff;
}
.btn-primary:hover {
  background: var(--primary-hover); border-color: var(--primary-hover);
}
.btn-danger {
  background: var(--danger-soft);
  border-color: var(--danger-border);
  color: var(--danger);
}
.btn-danger:hover { background: #fee2e2; }
.btn-ghost { background: transparent; border-color: transparent; }
.btn-ghost:hover { background: var(--panel-2); }
.btn.small { padding: 4px 10px; font-size: 12px; }

/* ---------- Login ---------- */
.login-body {
  min-height: 100vh;
  display: flex; align-items: center; justify-content: center;
  background: linear-gradient(135deg, #eff6ff 0%, #f0fdf4 100%);
}
.login-card {
  background: var(--panel);
  border: 1px solid var(--border);
  border-radius: 12px;
  padding: 32px;
  width: min(92vw, 380px);
  box-shadow: 0 10px 40px rgba(15, 23, 42, 0.08);
}
.login-card h1 { margin: 0 0 4px; font-size: 22px; color: var(--text); }
.login-card label { font-size: 13px; color: var(--muted); }
.login-card input[type=password] {
  width: 100%;
  padding: 10px 12px;
  background: #ffffff;
  border: 1px solid var(--border);
  color: var(--text);
  border-radius: 6px;
  font-size: 14px;
}
.login-card input[type=password]:focus {
  outline: none;
  border-color: var(--primary);
  box-shadow: 0 0 0 3px rgba(37, 99, 235, 0.15);
}
.login-card .btn { width: 100%; justify-content: center; padding: 10px; }
.btn-google {
  background: #fff; color: #1f2937;
  border: 1px solid var(--border);
}
.btn-google:hover { background: var(--panel-2); }
.g-icon {
  display: inline-flex; align-items: center; justify-content: center;
  width: 20px; height: 20px;
  background: linear-gradient(45deg, #4285f4, #34a853, #fbbc05, #ea4335);
  border-radius: 50%;
  color: #fff; font-weight: 700; font-size: 12px;
}

.alert {
  background: var(--danger-soft);
  border: 1px solid var(--danger-border);
  color: #991b1b;
  padding: 10px 12px;
  border-radius: 6px;
  margin-bottom: 12px;
  font-size: 13px;
}

/* ---------- Topbar ---------- */
.topbar {
  display: flex; align-items: center; gap: 20px;
  padding: 10px 16px;
  background: #ffffff;
  border-bottom: 1px solid var(--border);
}
.brand { display: flex; align-items: center; gap: 10px; font-size: 15px; color: var(--text); }
.brand .dot {
  width: 10px; height: 10px; border-radius: 50%;
  background: linear-gradient(135deg, #2563eb, #10b981);
}
.topbar-controls { display: flex; align-items: center; gap: 10px; }
.topbar-controls select {
  background: #ffffff;
  color: var(--text);
  border: 1px solid var(--border);
  padding: 6px 8px;
  border-radius: 6px;
}
.user { display: flex; align-items: center; gap: 10px; margin-left: auto; }
.avatar { width: 28px; height: 28px; border-radius: 50%; }

/* ---------- Tabs ---------- */
.tabs {
  display: flex;
  background: #ffffff;
  border-bottom: 1px solid var(--border);
  padding: 0 16px;
}
.tab {
  padding: 12px 20px;
  background: transparent;
  border: none;
  color: var(--muted);
  cursor: pointer;
  font-size: 13px;
  border-bottom: 2px solid transparent;
  transition: all .15s ease;
}
.tab:hover { color: var(--text); }
.tab.active {
  color: var(--primary);
  border-bottom-color: var(--primary);
  font-weight: 600;
}

/* ---------- Panels ---------- */
.panel {
  padding: 16px;
}
.toolbar {
  display: flex; align-items: center; gap: 8px;
  margin-bottom: 12px;
  flex-wrap: wrap;
}
.ytd {
  background: var(--panel-2);
  border: 1px solid var(--border);
  padding: 6px 12px;
  border-radius: 6px;
  font-weight: 600;
  color: var(--text);
}

#grid {
  background: var(--panel);
  border: 1px solid var(--border);
  border-radius: 6px;
  overflow: auto;
  height: calc(100vh - 360px);  /* leaves room for the summary table below */
  min-height: 280px;
}

/* Accent cells only — let Handsontable use its default light theme */
.handsontable { font-size: 12px; }
.handsontable td.negative-cell { color: var(--danger); }
.handsontable td.past-month {
  background: #f8fafc !important;
  color: var(--muted-soft);
}
.handsontable td.current-month {
  background: #eff6ff !important;
}
.handsontable td.highlight-row {
  background: var(--accent) !important;
}
.handsontable td.ht-total-col {
  background: var(--panel-2);
  font-weight: 600;
}

/* Summary table below the grid (rendered on "Update Data") ---------------- */
.summary-table {
  margin-top: 12px;
  border: 1px solid var(--border);
  border-radius: 6px;
  background: var(--panel);
  overflow-x: auto;
  font-size: 12px;
}
.summary-table:empty { display: none; }

.sum-row {
  display: grid;
  /* Matches Handsontable column widths: 220+130+110 = 460 label, 12×95, 120 */
  grid-template-columns: 460px repeat(12, 95px) 120px;
  min-width: 1720px;
}
.sum-row + .sum-row { border-top: 1px solid var(--border); }

.sum-cell {
  padding: 10px 8px;
  text-align: right;
  border-left: 1px solid var(--border);
  white-space: nowrap;
}
.sum-cell:first-child {
  border-left: none;
  text-align: left;
  font-weight: 700;
  letter-spacing: .04em;
}

.sum-header {
  background: var(--panel-2);
  color: var(--muted);
  font-weight: 600;
}
.sum-header .sum-cell { font-weight: 600; }

.sum-total {
  background: #dbeafe;
  color: var(--text);
  font-weight: 700;
  border-top: 2px solid var(--primary) !important;
}
.sum-total .sum-label { color: #1e40af; }

.sum-cumulative {
  background: #fef3c7;
  color: #78350f;
  font-weight: 700;
}
.sum-cumulative .sum-label { color: #78350f; }

.sum-year-total {
  background: rgba(0, 0, 0, 0.05);
  font-weight: 700;
}

/* ---------- Dashboard ---------- */
.kpis {
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
  gap: 12px;
  margin-bottom: 20px;
}
.kpi {
  background: var(--panel);
  border: 1px solid var(--border);
  border-radius: 8px;
  padding: 16px;
  box-shadow: 0 1px 2px rgba(15, 23, 42, 0.04);
}
.kpi-label {
  font-size: 12px;
  color: var(--muted);
  margin-bottom: 6px;
}
.kpi-value {
  font-size: 22px;
  font-weight: 700;
  color: var(--text);
}

.charts {
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(420px, 1fr));
  gap: 16px;
}
.chart-card {
  background: var(--panel);
  border: 1px solid var(--border);
  border-radius: 8px;
  padding: 16px;
  box-shadow: 0 1px 2px rgba(15, 23, 42, 0.04);
}
.chart-card h3 {
  margin: 0 0 12px;
  font-size: 14px;
  color: var(--muted);
  font-weight: 500;
}
.chart-card canvas {
  max-height: 280px;
}

/* ---------- Toast ---------- */
.toast {
  position: fixed;
  bottom: 20px;
  right: 20px;
  background: #ffffff;
  color: var(--text);
  border: 1px solid var(--border);
  border-left: 3px solid var(--primary);
  padding: 10px 16px;
  border-radius: 6px;
  box-shadow: 0 10px 30px rgba(15, 23, 42, 0.12);
  font-size: 13px;
  z-index: 1000;
  animation: slide-in .2s ease-out;
}
.toast.success { border-left-color: var(--success); }
.toast.error { border-left-color: var(--danger); }
@keyframes slide-in {
  from { transform: translateX(20px); opacity: 0; }
  to { transform: translateX(0); opacity: 1; }
}