@import url('https://fonts.googleapis.com/css2?family=Source+Sans+3:wght@300;400;500;600;700&family=JetBrains+Mono:wght@400;500&display=swap');

:root {
  --bg:#f0f2f5;--surface:#ffffff;--surface2:#f7f8fa;
  --border:#dfe3e8;--border2:#e8ecf0;
  --text:#1a2b3c;--text2:#5a6a7e;--text3:#8896a6;
  --accent:#1b5fa8;--accent2:#2874c4;--accent-light:#e8f0fb;
  --header-bg:#ffffff;--header-border:#d0d7de;
}
*{margin:0;padding:0;box-sizing:border-box}
body{font-family:'Source Sans 3',-apple-system,BlinkMacSystemFont,sans-serif;background:var(--bg);color:var(--text);min-height:100vh;font-size:14px}

.header{background:var(--header-bg);border-bottom:1px solid var(--header-border);padding:0 24px;height:56px;display:flex;align-items:center;gap:14px;box-shadow:0 1px 3px rgba(0,0,0,0.04);position:sticky;top:0;z-index:100}
.header h1{font-size:17px;font-weight:700;color:var(--accent)}
.header .sep{width:1px;height:28px;background:var(--border);margin:0 6px}
.header .subtitle{color:var(--text2);font-size:13px}
.header .right-info{margin-left:auto;display:flex;align-items:center;gap:10px}
.fy-badge{background:var(--accent-light);color:var(--accent);padding:4px 12px;border-radius:20px;font-size:12px;font-weight:600}

.filters-bar{background:var(--surface);border-bottom:1px solid var(--border2);padding:10px 24px;display:flex;flex-wrap:wrap;gap:14px;align-items:flex-end}
.filter-group{display:flex;flex-direction:column;gap:3px}
.filter-group label{font-size:10px;text-transform:uppercase;letter-spacing:0.8px;color:var(--text3);font-weight:600}
.filter-group select{background:var(--surface);border:1px solid var(--border);color:var(--text);padding:6px 28px 6px 10px;border-radius:6px;font-size:13px;font-family:'Source Sans 3',sans-serif;min-width:130px;cursor:pointer;appearance:none;background-image:url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='12' height='12' viewBox='0 0 24 24' fill='none' stroke='%235a6a7e' stroke-width='2'%3E%3Cpolyline points='6 9 12 15 18 9'/%3E%3C/svg%3E");background-repeat:no-repeat;background-position:right 8px center;transition:border-color 0.15s}
.filter-group select:focus{outline:none;border-color:var(--accent2);box-shadow:0 0 0 2px rgba(27,95,168,0.12)}
.filter-check{display:flex;align-items:center;gap:7px;padding-bottom:2px}
.filter-check input[type=checkbox]{width:16px;height:16px;accent-color:var(--accent);cursor:pointer;border-radius:3px}
.filter-check span{font-size:13px;color:var(--text);font-weight:500;cursor:pointer;user-select:none}
.search-wrap{position:relative}
.search-wrap input{width:100%;background:var(--surface);border:1px solid var(--border);color:var(--text);padding:6px 10px 6px 30px;border-radius:6px;font-size:13px;font-family:'Source Sans 3',sans-serif;transition:border-color 0.15s}
.search-wrap input:focus{outline:none;border-color:var(--accent2);box-shadow:0 0 0 2px rgba(27,95,168,0.12)}
.search-wrap svg{position:absolute;left:8px;top:50%;transform:translateY(-50%);pointer-events:none}

.main{padding:18px 24px;max-width:1480px;margin:0 auto}
.kpi-row{display:grid;grid-template-columns:repeat(6,1fr);gap:12px;margin-bottom:18px}
.kpi{background:var(--surface);border:1px solid var(--border2);border-radius:8px;padding:14px 16px;transition:box-shadow 0.15s}
.kpi:hover{box-shadow:0 2px 8px rgba(0,0,0,0.06)}
.kpi-label{font-size:10px;color:var(--text3);text-transform:uppercase;letter-spacing:0.6px;font-weight:600;margin-bottom:2px}
.kpi-value{font-size:22px;font-weight:700;font-family:'JetBrains Mono',monospace;color:var(--text);line-height:1.1}
.card{background:var(--surface);border:1px solid var(--border2);border-radius:8px;padding:18px 20px;margin-bottom:16px}
.card:hover{box-shadow:0 2px 8px rgba(0,0,0,0.05)}
.card-title{font-size:14px;font-weight:700;color:var(--text);margin-bottom:12px;display:flex;align-items:center;gap:8px}
.card-title .ta{color:var(--accent)}
.chart-container{position:relative;width:100%;height:480px}
.horiz-chart-container{position:relative;width:100%;height:300px}
.legend{display:flex;flex-wrap:wrap;gap:14px;margin-bottom:14px;justify-content:center}
.legend-item{display:flex;align-items:center;gap:5px;font-size:12px;color:var(--text2);font-weight:500}
.legend-dot{width:12px;height:12px;border-radius:3px}
.table-wrap{overflow-x:auto;max-height:500px;overflow-y:auto}
table{width:100%;border-collapse:collapse;font-size:13px}
thead{position:sticky;top:0;z-index:2}
th{background:var(--surface2);color:var(--text2);padding:8px 10px;text-align:left;font-weight:600;font-size:11px;text-transform:uppercase;letter-spacing:0.4px;border-bottom:2px solid var(--border);white-space:nowrap}
th.sortable{cursor:pointer;user-select:none;position:relative;padding-right:20px}
th.sortable:hover{color:var(--accent);background:#edf2f7}
th.sortable::after{content:'⇅';position:absolute;right:4px;top:50%;transform:translateY(-50%);font-size:10px;opacity:0.4}
th.sortable.asc::after{content:'▲';opacity:0.8;color:var(--accent)}
th.sortable.desc::after{content:'▼';opacity:0.8;color:var(--accent)}
td{padding:7px 10px;border-bottom:1px solid var(--border2);white-space:nowrap;font-size:12px}
tr:hover td{background:#f4f7fb}
.td-name{max-width:300px;overflow:hidden;text-overflow:ellipsis}
.td-mono{font-family:'JetBrains Mono',monospace;font-size:11px}
.margin-badge{display:inline-block;padding:2px 8px;border-radius:4px;font-weight:700;font-size:11px;font-family:'JetBrains Mono',monospace}
.mb1{background:#1a1a1a;color:#fff}.mb2{background:#D64550;color:#fff}.mb3{background:#E66C37;color:#fff}
.mb4{background:#B5C334;color:#1a1a1a}.mb5{background:#02931C;color:#fff}.mb6{background:#02931C;color:#fff}
.mb7{background:#02931C;color:#fff}.mb8{background:#02931C;color:#fff}
.expand-row{cursor:pointer}.expand-row:hover td{background:var(--accent-light)!important}
.consultant-row td{background:var(--surface2)}.consultant-row table th{background:#edf1f5}
.bottom-grid{display:grid;grid-template-columns:320px 1fr;gap:16px}
@media(max-width:1200px){.bottom-grid{grid-template-columns:1fr}.kpi-row{grid-template-columns:repeat(3,1fr)}}
.tabs{display:flex;gap:0;margin-bottom:18px;border-bottom:2px solid var(--border)}
.tab{padding:9px 22px;font-size:13px;font-weight:600;color:var(--text2);cursor:pointer;border-bottom:2px solid transparent;margin-bottom:-2px;transition:all 0.15s;user-select:none}
.tab:hover{color:var(--text)}
.tab.active{color:var(--accent);border-bottom-color:var(--accent)}
.pivot-table{font-size:12px}
.pivot-table th{position:sticky;top:0;z-index:3;background:var(--surface2);padding:6px 8px;font-size:10px;white-space:nowrap}
.pivot-table td{padding:5px 8px;text-align:center;white-space:nowrap;border-bottom:1px solid var(--border2)}
.pivot-table tr:hover td{background:#f4f7fb}
.pivot-table .fixed-col{position:sticky;z-index:2;background:var(--surface);text-align:left}
.pivot-table th.fixed-col{background:var(--surface2);z-index:4}
.pivot-table .col0{left:0;min-width:60px}
.pivot-table .col1{left:60px;min-width:280px;max-width:280px;overflow:hidden;text-overflow:ellipsis}
.pivot-table .col2{left:340px;min-width:180px;max-width:180px;overflow:hidden;text-overflow:ellipsis}
.pivot-table .col3{left:520px;min-width:50px;border-right:2px solid var(--border)}
.pivot-table th.col3{border-right:2px solid var(--border)}
.mg-cell{border-radius:3px;padding:3px 6px;font-family:'JetBrains Mono',monospace;font-weight:600;font-size:11px;cursor:default;display:inline-block;min-width:52px;text-align:center}
.tip-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:8px;margin-bottom:8px}
.tip-grid.g4{grid-template-columns:repeat(4,1fr)}
.tip-grid.g5{grid-template-columns:repeat(5,1fr)}
.tip-kpi{text-align:center}
.tip-kpi .lbl{color:var(--text3);font-size:9px;text-transform:uppercase;letter-spacing:0.5px;font-weight:600}
.tip-kpi .val{font-family:'JetBrains Mono',monospace;font-weight:600;font-size:12px;margin-top:1px}

/* Loading overlay */
.loading-overlay{position:fixed;top:0;left:0;width:100%;height:100%;background:rgba(240,242,245,0.9);display:flex;flex-direction:column;align-items:center;justify-content:center;z-index:1000;gap:16px}
.loading-spinner{width:40px;height:40px;border:3px solid var(--border);border-top-color:var(--accent);border-radius:50%;animation:spin 0.8s linear infinite}
@keyframes spin{to{transform:rotate(360deg)}}
.loading-text{color:var(--text2);font-size:14px;font-weight:500}
.error-banner{background:#fce8ea;border:1px solid #f5c6cb;color:#721c24;padding:12px 24px;text-align:center;font-size:13px;font-weight:500}

/* Import tab */
.import-grid2{display:grid;grid-template-columns:1fr 1fr;gap:12px}
.import-field{display:flex;flex-direction:column;gap:4px}
.import-label{font-size:10px;text-transform:uppercase;letter-spacing:0.8px;color:var(--text3);font-weight:600}
.import-input{width:100%;padding:7px 10px;border:1px solid var(--border);border-radius:6px;font-size:13px;font-family:'JetBrains Mono',monospace;background:var(--surface);color:var(--text)}
.import-input:focus{outline:none;border-color:var(--accent2);box-shadow:0 0 0 2px rgba(27,95,168,0.12)}
.import-file-btn{display:inline-block;padding:9px 18px;background:var(--accent);color:#fff;border-radius:6px;font-size:13px;font-weight:600;cursor:pointer;transition:background 0.15s}
.import-file-btn:hover{background:var(--accent2)}
.import-checks{display:flex;flex-direction:column;gap:6px}
.import-check{display:flex;align-items:center;gap:8px;font-size:13px;cursor:pointer}
.import-check input{width:15px;height:15px;accent-color:var(--accent)}
.import-btn{padding:9px 20px;border:none;border-radius:6px;font-size:13px;font-weight:700;cursor:pointer;transition:all 0.15s}
.import-btn-go{background:#02931C;color:#fff}
.import-btn-go:hover{background:#027015}
.import-btn-go:disabled{background:#ccc;cursor:not-allowed}
.import-btn-clear{background:#D64550;color:#fff}
.import-btn-clear:hover{background:#b83540}
.import-progress-bar{height:6px;background:#e8e8e8;border-radius:4px;overflow:hidden;margin-top:8px}
.import-progress-fill{height:100%;background:var(--accent);border-radius:4px;transition:width 0.3s;width:0%}
.import-summary{display:grid;grid-template-columns:repeat(3,1fr);gap:10px;margin-top:12px}
.import-summary-item{text-align:center;padding:10px;background:var(--surface2);border-radius:6px}
.import-summary-item .num{font-size:20px;font-weight:800;color:var(--accent);font-family:'JetBrains Mono',monospace}
.import-summary-item .lbl{font-size:10px;color:var(--text3);text-transform:uppercase;letter-spacing:0.4px}
.import-log{margin-top:10px;max-height:260px;overflow-y:auto;font-family:'JetBrains Mono',monospace;font-size:11px;line-height:1.6;background:#1a1a2e;color:#e8e8e8;border-radius:6px;padding:10px}
.import-log .ok{color:#4ade80}
.import-log .err{color:#f87171}
.import-log .warn{color:#fbbf24}
.import-log .info{color:#60a5fa}
.import-preview{overflow-x:auto;max-height:180px;margin-top:10px}
.import-preview table{font-size:10px;border-collapse:collapse}
.import-preview th,.import-preview td{padding:3px 6px;border:1px solid var(--border2);white-space:nowrap}
.import-preview th{background:var(--surface2);font-weight:600;position:sticky;top:0}
.import-tag{display:inline-block;padding:2px 8px;border-radius:4px;font-size:10px;font-weight:600}
.import-tag-ok{background:#e2f5e5;color:#02931C}
@media(max-width:700px){.import-grid2{grid-template-columns:1fr}}

tr.month-band td{background:var(--surface2)}

.consultor-dropdown{display:none;position:absolute;left:0;top:100%;z-index:50;background:var(--surface);border:1px solid var(--border);border-radius:8px;box-shadow:0 4px 16px rgba(0,0,0,0.10);max-height:220px;overflow-y:auto;width:360px;margin-top:2px}
.consultor-dropdown.open{display:block}
.consultor-dropdown .cd-item{padding:8px 14px;font-size:13px;cursor:pointer;border-bottom:1px solid var(--border2)}
.consultor-dropdown .cd-item:last-child{border-bottom:none}
.consultor-dropdown .cd-item:hover,.consultor-dropdown .cd-item.active{background:var(--surface2);color:var(--accent)}
.consultor-dropdown .cd-empty{padding:12px 14px;font-size:12px;color:var(--text3);text-align:center}