:root{
  --ink:#0f172a;--ink-2:#334155;--muted:#64748b;--line:#e5e9f0;--bg:#f4f6fa;--card:#fff;
  --navy:#0b1f3a;--brand:#0e9f7e;--brand-2:#0b7f65;--brand-soft:#e6f6f1;--accent:#ff9900;
  --green:#16a34a;--green-bg:#dcfce7;--amber:#d97706;--amber-bg:#fef3c7;--red:#dc2626;--red-bg:#fee2e2;--grey-bg:#eef2f7;
  --blue:#2563eb;--blue-bg:#e8efff;
  --font:Inter,ui-sans-serif,system-ui,-apple-system,"Segoe UI",Roboto,Arial,sans-serif;
  --shadow:0 1px 2px rgba(15,23,42,.05),0 4px 14px rgba(15,23,42,.05);
}
*{box-sizing:border-box}
body{margin:0;font-family:var(--font);color:var(--ink);background:var(--bg);font-size:14px;line-height:1.5;-webkit-font-smoothing:antialiased}
a{color:var(--brand-2)}
h1,h2,h3{margin:0;letter-spacing:-.01em}
.app{display:flex;min-height:100vh;background:linear-gradient(90deg,var(--navy) 230px,var(--bg) 230px)}

/* sidebar */
.side{width:230px;flex:none;background:var(--navy);color:#cbd5e1;display:flex;flex-direction:column;position:sticky;top:0;height:100vh}
.side-logo{display:flex;align-items:center;gap:10px;padding:20px 18px;color:#fff;text-decoration:none;font-weight:800;font-size:1.05rem}
.side-nav{display:flex;flex-direction:column;padding:6px 10px;gap:2px}
.side-nav a{display:flex;align-items:center;gap:12px;padding:10px 12px;border-radius:10px;color:#cbd5e1;text-decoration:none;font-weight:500}
.side-nav a i{font-style:normal;width:20px;text-align:center;opacity:.9}
.side-nav a:hover{background:rgba(255,255,255,.06);color:#fff}
.side-nav a.active{background:rgba(45,212,167,.14);color:#fff;box-shadow:inset 3px 0 0 #2dd4a7}
.nav-count{margin-left:auto;background:var(--red);color:#fff;font-size:.72rem;padding:1px 7px;border-radius:999px}
.nav-count:empty{display:none}
.side-foot{margin-top:auto;padding:16px 18px;font-size:.8rem;color:#94a3b8;border-top:1px solid rgba(255,255,255,.08)}
.side-foot p{margin:0 0 8px}
.side-foot a{color:#cbd5e1}

/* main */
.main{flex:1;min-width:0}
.topbar{display:flex;justify-content:space-between;align-items:center;gap:16px;padding:16px 28px;background:#fff;border-bottom:1px solid var(--line);position:sticky;top:0;z-index:20;flex-wrap:wrap}
.tb-left{display:flex;align-items:center;gap:12px}
.tb-left h1{font-size:1.25rem}
.badge-demo{background:#fff4d6;color:#8a5a00;font-weight:800;font-size:.7rem;letter-spacing:.08em;padding:4px 10px;border-radius:999px;border:1px solid #f5dfa6}
.badge-demo.live{background:var(--brand-soft);color:var(--brand-2);border-color:#bfe9dc}
.tb-right{display:flex;align-items:center;gap:12px}
.tb-range{color:var(--muted);font-size:.85rem}
.sel{display:flex;align-items:center;gap:8px;font-weight:600;font-size:.85rem;color:var(--ink-2)}
select,input[type=text],input[type=number],input[type=date],input[type=search]{font:inherit;padding:7px 10px;border:1px solid var(--line);border-radius:9px;background:#fff;color:var(--ink)}
select:focus,input:focus{outline:2px solid var(--brand);border-color:transparent}
.demo-note{margin:16px 28px 0;background:#fffbeb;border:1px solid #f5dfa6;color:#6b4a00;border-radius:12px;padding:10px 14px;font-size:.88rem}
.demo-note.hidden{display:none}
.view{padding:20px 28px 48px;outline:none}

/* generic */
.grid{display:grid;gap:16px}
.g-6{grid-template-columns:repeat(6,1fr)}.g-4{grid-template-columns:repeat(4,1fr)}.g-3{grid-template-columns:repeat(3,1fr)}.g-2{grid-template-columns:repeat(2,1fr)}
.card{background:var(--card);border:1px solid var(--line);border-radius:14px;box-shadow:var(--shadow);padding:18px}
.card h2{font-size:1rem;margin-bottom:12px;display:flex;align-items:center;gap:8px}
.card h2 small{color:var(--muted);font-weight:500;font-size:.8rem}
.section-title{display:flex;justify-content:space-between;align-items:center;margin:26px 0 12px;gap:12px;flex-wrap:wrap}
.section-title h2{font-size:1.05rem}
.muted{color:var(--muted)}
.btn{display:inline-flex;align-items:center;gap:6px;font:inherit;font-weight:600;padding:8px 14px;border-radius:9px;border:1px solid var(--line);background:#fff;color:var(--ink);cursor:pointer;text-decoration:none;white-space:nowrap}
.btn:hover{border-color:var(--brand);color:var(--brand-2)}
.btn.primary{background:var(--brand);border-color:var(--brand);color:#fff}
.btn.primary:hover{background:var(--brand-2);color:#fff}
.btn.danger{color:var(--red)}
.btn.sm{padding:5px 10px;font-size:.82rem}
.btn[disabled]{opacity:.5;cursor:not-allowed}

/* kpis */
.kpi{padding:14px 16px}
.kpi small{display:block;color:var(--muted);font-weight:600;font-size:.76rem;text-transform:uppercase;letter-spacing:.04em}
.kpi b{display:block;font-size:1.45rem;font-weight:800;margin:2px 0}
.kpi .delta{font-size:.8rem;font-weight:700}
.kpi .sub{font-size:.76rem;color:var(--muted);display:block}
.good{color:var(--green)}.bad{color:var(--red)}.neutral{color:var(--muted)}

/* account cards */
.acc-grid{display:grid;grid-template-columns:repeat(auto-fill,minmax(330px,1fr));gap:16px}
.acc{cursor:pointer;transition:.15s;border-top:4px solid var(--grey-bg);display:flex;flex-direction:column;gap:12px}
.acc:hover{transform:translateY(-2px);box-shadow:0 10px 26px rgba(15,23,42,.09)}
.acc.lv-green{border-top-color:var(--green)}.acc.lv-amber{border-top-color:#f59e0b}.acc.lv-red{border-top-color:var(--red)}
.acc-head{display:flex;justify-content:space-between;gap:10px;align-items:flex-start}
.acc-head h3{font-size:1.05rem}
.acc-head .meta{font-size:.78rem;color:var(--muted);margin-top:2px;display:flex;gap:6px;flex-wrap:wrap;align-items:center}
.acc-kpis{display:grid;grid-template-columns:repeat(3,1fr);gap:8px}
.acc-kpis div{background:var(--bg);border-radius:10px;padding:8px 10px}
.acc-kpis small{display:block;font-size:.7rem;color:var(--muted);font-weight:600;text-transform:uppercase;letter-spacing:.03em}
.acc-kpis b{font-size:1.02rem}
.acc-kpis em{display:block;font-style:normal;font-size:.72rem;font-weight:700}
.spark{width:100%;height:46px;display:block}
.pace{font-size:.78rem;color:var(--ink-2)}
.pace-bar{position:relative;height:8px;background:var(--grey-bg);border-radius:99px;margin-top:5px;overflow:visible}
.pace-bar span{position:absolute;left:0;top:0;bottom:0;border-radius:99px;background:var(--brand)}
.pace-bar span.over{background:var(--red)}
.pace-bar i{position:absolute;top:-3px;width:2px;height:14px;background:var(--ink)}

/* pills & badges */
.pill{display:inline-flex;align-items:center;gap:5px;font-size:.72rem;font-weight:700;padding:3px 9px;border-radius:999px;white-space:nowrap}
.pill::before{content:"";width:7px;height:7px;border-radius:50%;background:currentColor}
.pill.green{background:var(--green-bg);color:#166534}.pill.amber{background:var(--amber-bg);color:#92400e}.pill.red{background:var(--red-bg);color:#991b1b}.pill.none{background:var(--grey-bg);color:var(--muted)}
.tag{font-size:.7rem;font-weight:700;padding:2px 8px;border-radius:6px;background:var(--grey-bg);color:var(--ink-2)}
.tag.agency{background:#f3e8ff;color:#6b21a8}.tag.direct{background:var(--blue-bg);color:#1e40af}
.cbadge{font-size:.72rem;font-weight:700;padding:3px 9px;border-radius:999px;white-space:nowrap}
.cbadge.connected{background:var(--green-bg);color:#166534}.cbadge.reauth{background:var(--amber-bg);color:#92400e}.cbadge.files{background:var(--grey-bg);color:var(--ink-2)}.cbadge.pending{background:var(--blue-bg);color:#1e40af}

/* alerts */
.alert-list{display:flex;flex-direction:column;gap:10px}
.alert{display:grid;grid-template-columns:auto 1fr auto;gap:12px;align-items:start;background:#fff;border:1px solid var(--line);border-left:4px solid var(--muted);border-radius:12px;padding:12px 14px}
.alert.high{border-left-color:var(--red)}.alert.med{border-left-color:#f59e0b}.alert.low{border-left-color:var(--blue)}
.alert .sev{font-size:.68rem;font-weight:800;text-transform:uppercase;padding:2px 8px;border-radius:6px}
.alert.high .sev{background:var(--red-bg);color:#991b1b}.alert.med .sev{background:var(--amber-bg);color:#92400e}.alert.low .sev{background:var(--blue-bg);color:#1e40af}
.alert h4{margin:0;font-size:.92rem}
.alert p{margin:2px 0 0;color:var(--ink-2);font-size:.84rem}
.alert .who{font-size:.76rem;color:var(--muted);font-weight:600}
.filters{display:flex;gap:10px;flex-wrap:wrap;align-items:center}

/* tables */
.tbl-wrap{overflow:auto;border:1px solid var(--line);border-radius:12px;background:#fff}
table{border-collapse:collapse;width:100%;font-size:.86rem}
th,td{padding:9px 12px;text-align:right;border-bottom:1px solid var(--line);white-space:nowrap}
th{background:#f8fafc;color:var(--ink-2);font-weight:700;font-size:.76rem;text-transform:uppercase;letter-spacing:.03em;position:sticky;top:0;cursor:pointer;user-select:none}
th.l,td.l{text-align:left}
td.title{max-width:280px;overflow:hidden;text-overflow:ellipsis}
tr:hover td{background:#fafcff}
th.sorted::after{content:" ▾"}th.sorted.asc::after{content:" ▴"}
.flag{font-size:.7rem;font-weight:700;padding:2px 7px;border-radius:6px;background:var(--red-bg);color:#991b1b;margin-left:4px}
.flag.amber{background:var(--amber-bg);color:#92400e}

/* charts */
.chart-box{position:relative;height:260px}
.chart-box.sm{height:220px}
.seg{display:inline-flex;border:1px solid var(--line);border-radius:9px;overflow:hidden;background:#fff}
.seg button{font:inherit;font-weight:600;font-size:.82rem;padding:6px 12px;border:0;background:none;cursor:pointer;color:var(--ink-2)}
.seg button.on{background:var(--navy);color:#fff}
.seg button[disabled]{cursor:not-allowed;opacity:.45}

.donut-row{display:flex;gap:18px;align-items:center}
.donut-box{position:relative;width:190px;height:190px;flex:none}
.donut-tbl{flex:1;min-width:0}
/* connections */
.conn-intro{display:grid;grid-template-columns:1fr 1fr;gap:16px}
.method{border:1px solid var(--line);border-radius:12px;padding:14px;background:#fbfcfe}
.method h3{font-size:.95rem;margin-bottom:6px}
.method ul{margin:6px 0 0;padding-left:18px;color:var(--ink-2);font-size:.85rem}
.conn-row{display:grid;grid-template-columns:1.4fr 1.6fr 1fr 1.2fr auto;gap:14px;align-items:center;padding:14px 16px;border-bottom:1px solid var(--line)}
.conn-row:last-child{border-bottom:0}
.conn-row .nm b{display:block}
.conn-row .nm span{font-size:.78rem;color:var(--muted)}
.conn-row .when{font-size:.8rem;color:var(--ink-2)}
.conn-row .when small{display:block;color:var(--muted)}
.lock{font-size:.74rem;color:#6b21a8;margin-top:4px;display:block}
.arch{display:flex;align-items:stretch;gap:10px;flex-wrap:wrap}
.arch div{flex:1;min-width:150px;background:var(--bg);border-radius:12px;padding:12px;font-size:.82rem;color:var(--ink-2)}
.arch div b{display:block;color:var(--ink);font-size:.86rem;margin-bottom:2px}
.arch .arr{flex:none;min-width:0;background:none;align-self:center;font-size:1.3rem;color:var(--muted);padding:0}

/* import */
.drop{display:block;border:2px dashed #b8c4d6;border-radius:16px;padding:34px;text-align:center;background:#fbfcfe;transition:.15s;cursor:pointer}
.drop.over{border-color:var(--brand);background:var(--brand-soft)}
.drop b{font-size:1.05rem}
.form-grid{display:grid;grid-template-columns:repeat(4,1fr);gap:12px}
.form-grid label{display:flex;flex-direction:column;gap:5px;font-weight:600;font-size:.8rem;color:var(--ink-2)}
.log-ok{color:var(--green);font-weight:700}.log-skip{color:var(--amber);font-weight:700}.log-err{color:var(--red);font-weight:700}
.supported{columns:2;font-size:.85rem;color:var(--ink-2);padding-left:18px}

/* settings */
.set-tbl input{width:100px}
.set-tbl td,.set-tbl th{text-align:left}

/* modal */
.modal-wrap{position:fixed;inset:0;background:rgba(15,23,42,.45);display:flex;align-items:center;justify-content:center;z-index:100;padding:20px}
.modal-wrap.hidden{display:none}
.modal{background:#fff;border-radius:18px;max-width:640px;width:100%;max-height:90vh;overflow:auto;padding:24px;box-shadow:0 30px 80px rgba(0,0,0,.25)}
.modal h3{font-size:1.15rem;margin-bottom:4px}
.stepper{display:flex;gap:8px;margin:16px 0}
.stepper span{flex:1;height:5px;border-radius:9px;background:var(--grey-bg)}
.stepper span.on{background:var(--brand)}
.consent{border:1px solid var(--line);border-radius:14px;overflow:hidden;margin:12px 0}
.consent-head{background:#232f3e;color:#fff;padding:10px 14px;font-weight:700;display:flex;gap:8px;align-items:center}
.consent-head em{font-style:normal;color:var(--accent)}
.consent-body{padding:14px;font-size:.88rem}
.consent-body ul{padding-left:18px;margin:8px 0}
.mono{font-family:ui-monospace,SFMono-Regular,Menlo,monospace;font-size:.8rem;background:var(--bg);border:1px solid var(--line);border-radius:8px;padding:8px 10px;word-break:break-all}
.note{font-size:.8rem;color:var(--muted);background:var(--bg);border-radius:10px;padding:10px 12px}
.modal-actions{display:flex;justify-content:flex-end;gap:10px;margin-top:18px;flex-wrap:wrap}
.toast{position:fixed;bottom:22px;left:50%;transform:translateX(-50%) translateY(30px);background:var(--navy);color:#fff;padding:10px 16px;border-radius:10px;opacity:0;transition:.25s;z-index:200;font-weight:600;pointer-events:none}
.toast.show{opacity:1;transform:translateX(-50%)}
.empty{text-align:center;padding:40px;color:var(--muted)}

/* responsive */
@media (max-width:1180px){.g-6{grid-template-columns:repeat(3,1fr)}.g-4{grid-template-columns:repeat(2,1fr)}.conn-row{grid-template-columns:1fr 1fr;}}
@media (max-width:860px){
  .app{flex-direction:column;background:var(--bg)}
  .donut-row{flex-direction:column;align-items:stretch}.donut-box{margin:0 auto}
  .side{width:100%;height:auto;position:sticky;top:0;z-index:30;flex-direction:row;align-items:center}
  .side-logo{padding:10px 12px}.side-logo span{display:none}
  .side-nav{flex-direction:row;overflow-x:auto;padding:6px;gap:2px;scrollbar-width:none}
  .side-nav a{padding:8px 10px;white-space:nowrap;font-size:.82rem;gap:6px}
  .side-nav a.active{box-shadow:inset 0 -3px 0 #2dd4a7}
  .side-foot{display:none}
  .topbar{position:static;padding:12px 16px}
  .view{padding:14px 16px 40px}.demo-note{margin:12px 16px 0}
  .g-3,.g-2,.conn-intro{grid-template-columns:1fr}
  .form-grid{grid-template-columns:1fr 1fr}
  .acc-grid{grid-template-columns:1fr}
}
@media (max-width:520px){
  .g-6,.g-4{grid-template-columns:repeat(2,1fr)}
  .conn-row{grid-template-columns:1fr}
  .form-grid{grid-template-columns:1fr}
  .tb-range{display:none}
  .kpi b{font-size:1.2rem}
  .supported{columns:1}
}

/* ---------- database mode: badges, sign-in screen, import progress (Supabase wiring) ---------- */
[hidden]{display:none !important}
.badge-db{background:var(--grey-bg);color:var(--ink-2);font-weight:700;font-size:.7rem;padding:4px 10px;border-radius:999px;border:1px solid var(--line)}
body.auth-open .app{display:none}
.auth-wrap{min-height:100vh;display:flex;align-items:center;justify-content:center;padding:24px;background:linear-gradient(160deg,var(--navy) 0%,#123a5c 60%,#0e9f7e 140%)}
.auth-card{width:100%;max-width:400px;background:#fff;border-radius:18px;padding:28px 28px 20px;box-shadow:0 20px 60px rgba(2,12,27,.35)}
.auth-brand{display:flex;gap:12px;align-items:center;margin-bottom:18px}
.auth-brand b{display:block;font-size:1.1rem}.auth-brand span{font-size:.8rem;color:var(--muted)}
.auth-form h1{font-size:1.3rem;margin:0 0 12px}
.auth-form label{display:flex;flex-direction:column;gap:5px;font-weight:600;font-size:.82rem;color:var(--ink-2);margin-bottom:12px}
.auth-form input{width:100%;padding:10px 12px;font-size:.95rem}
.auth-form p{font-size:.85rem;margin:0 0 12px}
.auth-submit{width:100%;justify-content:center;padding:11px;font-size:.95rem}
.auth-link{display:inline-block;margin-top:12px;font-size:.85rem}
.auth-msg{font-size:.85rem;margin-top:10px;min-height:1px}
.auth-msg.err{color:var(--red)}.auth-msg.ok{color:var(--brand-2)}
.auth-or{display:flex;align-items:center;gap:10px;color:var(--muted);font-size:.78rem;margin:16px 0 12px}
.auth-or::before,.auth-or::after{content:"";flex:1;height:1px;background:var(--line)}
.auth-demo{width:100%;justify-content:center}
.auth-fine{font-size:.76rem;color:var(--muted);text-align:center;margin:8px 0 0}
.new-acc{margin-top:14px;padding:14px;border:1px dashed var(--line);border-radius:12px;background:#fbfcfe}
.new-acc h3{margin:0 0 10px;font-size:.95rem}
.drop.busy{opacity:.6;pointer-events:none}
.imp-progress{margin-top:12px;padding:12px 14px;border-radius:12px;background:var(--brand-soft)}
.imp-row{display:flex;justify-content:space-between;gap:12px;flex-wrap:wrap;font-size:.85rem}
.imp-bar{height:8px;border-radius:99px;background:#fff;margin-top:8px;overflow:hidden}
.imp-bar span{display:block;height:100%;background:var(--brand);transition:width .2s}
.imp-files{margin:0;padding-left:0;list-style:none;font-size:.85rem}
.imp-files li{padding:6px 0;border-top:1px solid var(--line)}
.imp-files li.error b{color:var(--red)}.imp-files li.skip b{color:var(--muted)}.imp-files li.ok b{color:var(--brand-2)}
.alert-acts{display:flex;gap:6px;flex-wrap:wrap;justify-content:flex-end}
.alert.quiet{opacity:.75}
.cbadge.error,.cbadge.revoked{background:var(--red-bg);color:#991b1b}.cbadge.none{background:var(--grey-bg);color:var(--muted)}
.bad{color:var(--red)}
.log-notes{white-space:normal;min-width:260px;max-width:380px}
.log-notes b{overflow-wrap:anywhere}