@import url('https://fonts.googleapis.com/css2?family=DM+Sans:ital,opsz,wght@0,9..40,300;0,9..40,400;0,9..40,500;0,9..40,600;0,9..40,700;1,9..40,400&family=DM+Mono:wght@400;500&family=Playfair+Display:wght@700;800&display=swap');

:root {
    --bg:          #f7f9f5;
    --bg2:         #ffffff;
    --bg3:         #eef3ea;
    --bg4:         #e4edd9;
    --pistachio:   #8fb87a;
    --pist-dark:   #5e8c48;
    --pist-light:  #c8ddb8;
    --pist-xlight: #e8f2e0;
    --border:      #d4e2c8;
    --border2:     #c2d4b4;
    --text:        #1e2a18;
    --text2:       #5a7045;
    --text3:       #8aaa72;
    --danger:      #d95f4b;
    --danger-bg:   #fdf0ee;
    --success:     #3d9b6e;
    --success-bg:  #edf8f2;
    --warning:     #c88a2a;
    --warning-bg:  #fdf5e6;
    --info:        #3b7bbf;
    --info-bg:     #edf3fb;
    --sidebar-w:   256px;
    --radius:      10px;
    --radius-lg:   16px;
    --shadow-sm:   0 1px 3px rgba(94,140,72,.08), 0 1px 2px rgba(94,140,72,.04);
    --shadow:      0 4px 12px rgba(94,140,72,.10), 0 2px 4px rgba(94,140,72,.06);
    --shadow-lg:   0 12px 32px rgba(94,140,72,.14), 0 4px 12px rgba(94,140,72,.08);
    --sans:    'DM Sans', sans-serif;
    --mono:    'DM Mono', monospace;
    --display: 'Playfair Display', serif;
}

*,*::before,*::after{box-sizing:border-box;margin:0;padding:0}
html{scroll-behavior:smooth}
body{background:var(--bg);color:var(--text);font-family:var(--sans);font-size:14.5px;line-height:1.55;min-height:100vh;display:flex;-webkit-font-smoothing:antialiased}

::-webkit-scrollbar{width:6px;height:6px}
::-webkit-scrollbar-track{background:var(--bg3)}
::-webkit-scrollbar-thumb{background:var(--pist-light);border-radius:10px}
::-webkit-scrollbar-thumb:hover{background:var(--pistachio)}

/* ── SIDEBAR ── */
.sidebar{width:var(--sidebar-w);min-height:100vh;background:var(--bg2);border-right:1.5px solid var(--border);display:flex;flex-direction:column;position:fixed;top:0;left:0;bottom:0;z-index:100}

.sidebar-brand{display:flex;align-items:center;gap:10px;padding:22px 22px 18px;border-bottom:1.5px solid var(--border)}
.brand-icon{width:38px;height:38px;background:linear-gradient(135deg,var(--pistachio),var(--pist-dark));border-radius:10px;display:flex;align-items:center;justify-content:center;font-size:18px;color:white;box-shadow:0 2px 8px rgba(94,140,72,.3);flex-shrink:0}
.brand-text{line-height:1.15}
.brand-title{font-family:var(--display);font-size:18px;font-weight:700;color:var(--text);letter-spacing:-.3px}
.brand-sub{font-size:10px;color:var(--text3);letter-spacing:1.2px;text-transform:uppercase;font-family:var(--mono)}

.sidebar-logos{display:flex;align-items:center;justify-content:center;gap:14px;padding:12px 22px;border-bottom:1.5px solid var(--border);background:var(--pist-xlight)}
.sidebar-logos img{height:28px;width:auto;object-fit:contain}

.nav-links{list-style:none;padding:10px 10px;flex:1}
.nav-links li a{display:flex;align-items:center;gap:10px;padding:9px 12px;color:var(--text2);text-decoration:none;font-size:13.5px;font-weight:500;border-radius:8px;margin-bottom:2px;transition:all .18s ease}
.nav-links li a:hover{background:var(--pist-xlight);color:var(--pist-dark)}
.nav-links li a.active{background:linear-gradient(135deg,var(--pist-xlight),var(--bg3));color:var(--pist-dark);font-weight:600;box-shadow:var(--shadow-sm);border:1px solid var(--border)}
.nav-icon{width:28px;height:28px;background:var(--bg3);border-radius:7px;display:flex;align-items:center;justify-content:center;font-size:13px;flex-shrink:0;transition:background .18s}
.nav-links li a.active .nav-icon{background:var(--pistachio);color:white}
.nav-links li a:hover .nav-icon{background:var(--pist-light)}

.sidebar-footer{padding:14px 14px 18px;border-top:1.5px solid var(--border);background:var(--bg)}
.user-badge{display:flex;align-items:center;gap:10px;padding:10px;background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius);margin-bottom:10px}
.user-avatar{width:32px;height:32px;background:linear-gradient(135deg,var(--pistachio),var(--pist-dark));border-radius:50%;display:flex;align-items:center;justify-content:center;font-size:13px;font-weight:700;color:white;flex-shrink:0}
.user-name{font-size:13px;font-weight:600;color:var(--text)}
.user-role{font-size:10.5px;color:var(--text3);font-family:var(--mono)}
.btn-logout{display:flex;align-items:center;justify-content:center;gap:6px;padding:8px;background:transparent;border:1.5px solid var(--border);border-radius:var(--radius);color:var(--text2);text-decoration:none;font-size:12.5px;font-weight:500;transition:all .18s;font-family:var(--sans)}
.btn-logout:hover{border-color:var(--danger);color:var(--danger);background:var(--danger-bg)}

/* ── MAIN ── */
.main-content{margin-left:var(--sidebar-w);flex:1;min-height:100vh;background:var(--bg)}
.page-wrapper{padding:24px 24px;max-width:1600px}

/* ── PAGE HEADER ── */
.page-header{display:flex;align-items:flex-end;justify-content:space-between;margin-bottom:28px;padding-bottom:20px;border-bottom:1.5px solid var(--border)}
.page-header h1{font-family:var(--display);font-size:30px;font-weight:700;color:var(--text);letter-spacing:-.5px;line-height:1.1}
.page-header h1 span{color:var(--pist-dark)}
.page-subtitle{color:var(--text3);font-size:12px;margin-top:5px;font-family:var(--mono);letter-spacing:.3px}

/* ── STATS ── */
.stats-grid{display:grid;grid-template-columns:repeat(auto-fit,minmax(200px,1fr));gap:14px;margin-bottom:28px}
.stat-card{background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);padding:20px 22px;position:relative;overflow:hidden;transition:transform .2s,box-shadow .2s;box-shadow:var(--shadow-sm)}
.stat-card:hover{transform:translateY(-3px);box-shadow:var(--shadow)}
.stat-card::after{content:'';position:absolute;bottom:0;left:0;right:0;height:3px;border-radius:0 0 var(--radius-lg) var(--radius-lg)}
.stat-card.c1::after{background:linear-gradient(90deg,var(--pistachio),var(--pist-dark))}
.stat-card.c2::after{background:linear-gradient(90deg,#6ab8a0,#3d9b6e)}
.stat-card.c3::after{background:linear-gradient(90deg,#b8a06a,#c88a2a)}
.stat-card.c4::after{background:linear-gradient(90deg,#e8917a,#d95f4b)}
.stat-icon{width:40px;height:40px;border-radius:10px;display:flex;align-items:center;justify-content:center;font-size:18px;margin-bottom:14px}
.c1 .stat-icon{background:var(--pist-xlight)}
.c2 .stat-icon{background:#edf8f2}
.c3 .stat-icon{background:#fdf5e6}
.c4 .stat-icon{background:#fdf0ee}
.stat-label{font-size:11px;color:var(--text3);letter-spacing:1px;text-transform:uppercase;font-family:var(--mono);margin-bottom:4px}
.stat-value{font-size:34px;font-weight:700;color:var(--text);font-family:var(--display);line-height:1;margin-bottom:4px}
.stat-sub{font-size:11.5px;color:var(--text3)}

/* ── CARDS ── */
.card{background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);margin-bottom:20px;box-shadow:var(--shadow-sm);overflow:hidden}
.card-header{display:flex;align-items:center;justify-content:space-between;padding:16px 22px;border-bottom:1.5px solid var(--border);background:var(--bg)}
.card-title{font-size:12px;font-weight:600;color:var(--text2);letter-spacing:1px;text-transform:uppercase;font-family:var(--mono)}
.card-body{padding:22px}

/* ── TABLE ── */
.table-wrap{overflow-x:visible}
table{width:100%;border-collapse:collapse;font-size:12.5px}
thead th{text-align:left;padding:9px 10px;background:var(--bg3);color:var(--text2);font-family:var(--mono);font-size:9.5px;letter-spacing:.8px;text-transform:uppercase;border-bottom:1.5px solid var(--border);white-space:nowrap;font-weight:500}
thead th a{color:var(--text2);text-decoration:none;transition:color .15s}
thead th a:hover{color:var(--pist-dark)}
tbody tr{border-bottom:1px solid var(--border);transition:background .12s}
tbody tr:last-child{border-bottom:none}
tbody tr:hover{background:var(--pist-xlight)}
tbody td{padding:8px 10px;vertical-align:middle}

/* ── BADGES ── */
.badge{display:inline-flex;align-items:center;padding:3px 10px;border-radius:20px;font-size:11px;font-family:var(--mono);font-weight:500;border:1px solid transparent}
.badge-green {background:var(--success-bg);color:var(--success);border-color:#b2dfc8}
.badge-red   {background:var(--danger-bg);color:var(--danger);border-color:#f0c4bc}
.badge-yellow{background:var(--warning-bg);color:var(--warning);border-color:#e8cfa0}
.badge-blue  {background:var(--info-bg);color:var(--info);border-color:#b8d0ee}
.badge-pist  {background:var(--pist-xlight);color:var(--pist-dark);border-color:var(--border)}
/* legacy aliases */
.badge-purple{background:var(--pist-xlight);color:var(--pist-dark);border-color:var(--border)}

/* ── FORMS ── */
.form-grid{display:grid;grid-template-columns:repeat(auto-fit,minmax(220px,1fr));gap:14px}
.form-group{display:flex;flex-direction:column;gap:5px}
.form-group label{font-size:11px;color:var(--text2);letter-spacing:.8px;text-transform:uppercase;font-family:var(--mono);font-weight:500}
.form-group input,.form-group select,.form-group textarea{background:var(--bg);border:1.5px solid var(--border);color:var(--text);padding:9px 12px;border-radius:8px;font-size:14px;font-family:var(--sans);outline:none;transition:border-color .18s,box-shadow .18s;width:100%;-webkit-appearance:none}
.form-group input:focus,.form-group select:focus,.form-group textarea:focus{border-color:var(--pistachio);box-shadow:0 0 0 3px rgba(143,184,122,.15);background:var(--bg2)}
.form-group input::placeholder{color:var(--text3)}

/* ── BUTTONS ── */
.btn{display:inline-flex;align-items:center;gap:7px;padding:9px 18px;border-radius:8px;font-family:var(--sans);font-size:13.5px;font-weight:600;cursor:pointer;border:none;transition:all .18s;text-decoration:none;letter-spacing:-.1px;line-height:1}
.btn-primary{background:linear-gradient(135deg,var(--pistachio),var(--pist-dark));color:white;box-shadow:0 2px 8px rgba(94,140,72,.3)}
.btn-primary:hover{transform:translateY(-1px);box-shadow:0 4px 14px rgba(94,140,72,.4)}
.btn-secondary{background:var(--bg2);color:var(--text2);border:1.5px solid var(--border)}
.btn-secondary:hover{border-color:var(--pistachio);color:var(--pist-dark);background:var(--pist-xlight)}
.btn-danger{background:var(--danger-bg);color:var(--danger);border:1.5px solid #f0c4bc}
.btn-danger:hover{background:#fce0db;border-color:var(--danger)}
.btn-sm{padding:5px 12px;font-size:12px;border-radius:6px}

/* ── SEARCH BAR ── */
.search-bar{display:flex;gap:10px;flex-wrap:wrap;margin-bottom:20px;align-items:flex-end;background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);padding:16px 20px;box-shadow:var(--shadow-sm)}
.search-bar .form-group{flex:1;min-width:160px;margin:0}

/* ── PAGINATION ── */
.pagination{display:flex;gap:5px;justify-content:flex-end;padding:14px 20px;border-top:1.5px solid var(--border);background:var(--bg)}
.pagination a,.pagination span{padding:5px 12px;border-radius:7px;font-size:13px;font-family:var(--mono);text-decoration:none;color:var(--text2);border:1.5px solid var(--border);background:var(--bg2);transition:all .15s}
.pagination a:hover{border-color:var(--pistachio);color:var(--pist-dark);background:var(--pist-xlight)}
.pagination .current{background:var(--pistachio);color:white;border-color:var(--pistachio);box-shadow:0 2px 6px rgba(94,140,72,.3)}

/* ── MODAL ── */
.modal-overlay{display:none;position:fixed;inset:0;background:rgba(30,42,24,.25);backdrop-filter:blur(6px);z-index:1000;align-items:center;justify-content:center}
.modal-overlay.open{display:flex}
.modal{background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);width:92%;max-width:640px;max-height:90vh;overflow-y:auto;box-shadow:var(--shadow-lg);animation:modalIn .22s cubic-bezier(.34,1.56,.64,1)}
@keyframes modalIn{from{transform:scale(.94) translateY(8px);opacity:0}to{transform:scale(1) translateY(0);opacity:1}}
.modal-header{display:flex;align-items:center;justify-content:space-between;padding:20px 24px;border-bottom:1.5px solid var(--border);background:var(--bg)}
.modal-header h3{font-size:17px;font-weight:700;font-family:var(--display);color:var(--text)}
.modal-close{background:var(--bg3);border:none;color:var(--text2);font-size:15px;cursor:pointer;width:30px;height:30px;border-radius:7px;display:flex;align-items:center;justify-content:center;transition:all .15s}
.modal-close:hover{background:var(--danger-bg);color:var(--danger)}
.modal-body{padding:24px}
.modal-footer{padding:16px 24px;border-top:1.5px solid var(--border);display:flex;gap:10px;justify-content:flex-end;background:var(--bg)}

/* ── AUTH ── */
body.auth-page{background:var(--bg)}
.auth-main{width:100%;min-height:100vh;display:flex;align-items:center;justify-content:center;background:radial-gradient(ellipse at 30% 40%,rgba(143,184,122,.2) 0%,transparent 55%),radial-gradient(ellipse at 75% 70%,rgba(94,140,72,.10) 0%,transparent 50%),var(--bg);padding:24px}
.auth-card{background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);padding:40px 44px;width:440px;max-width:100%;box-shadow:var(--shadow-lg)}
.auth-logo{display:flex;flex-direction:column;align-items:center;margin-bottom:28px;gap:6px}
.auth-logo-icon{width:58px;height:58px;background:linear-gradient(135deg,var(--pist-light),var(--pistachio));border-radius:16px;display:flex;align-items:center;justify-content:center;font-size:26px;margin-bottom:2px;box-shadow:0 4px 16px rgba(94,140,72,.25)}
.auth-logo h1{font-family:var(--display);font-size:28px;font-weight:700;color:var(--text);letter-spacing:-.5px}
.auth-logo p{color:var(--text3);font-size:11px;letter-spacing:1.5px;text-transform:uppercase;font-family:var(--mono)}
.auth-card h2{font-size:18px;margin-bottom:22px;font-weight:700;color:var(--text)}
.auth-links{margin-top:18px;text-align:center;font-size:13.5px;color:var(--text2)}
.auth-links a{color:var(--pist-dark);text-decoration:none;font-weight:600}
.auth-links a:hover{text-decoration:underline}
.auth-card .btn{width:100%;justify-content:center;padding:11px;margin-top:6px;font-size:14.5px}
.auth-card .form-group{margin-bottom:14px}
.auth-logos{display:flex;align-items:center;justify-content:center;gap:20px;margin-top:24px;padding-top:20px;border-top:1.5px solid var(--border)}
.auth-logos img{height:26px;width:auto;object-fit:contain}

/* ── ALERTS ── */
.alert{padding:12px 16px;border-radius:var(--radius);font-size:13.5px;margin-bottom:16px;border:1.5px solid}
.alert-success{background:var(--success-bg);border-color:#b2dfc8;color:#2a7a56}
.alert-error  {background:var(--danger-bg); border-color:#f0c4bc;color:#b84533}
.alert-info   {background:var(--pist-xlight);border-color:var(--border);color:var(--pist-dark)}

/* ── FLIGHT BOARD ── */
.flight-board{background:var(--bg2);border-radius:var(--radius);overflow:hidden}
.flight-board-header{display:grid;grid-template-columns:100px 1fr 120px 120px 110px 110px;padding:10px 16px;background:var(--bg3);border-bottom:1.5px solid var(--border);font-size:10.5px;color:var(--text3);letter-spacing:1px;text-transform:uppercase;font-family:var(--mono)}
.flight-row{display:grid;grid-template-columns:100px 1fr 120px 120px 110px 110px;padding:13px 16px;border-bottom:1px solid var(--border);font-size:13.5px;transition:background .12s;align-items:center}
.flight-row:last-child{border-bottom:none}
.flight-row:hover{background:var(--pist-xlight)}
.flight-num{color:var(--pist-dark);font-weight:700;font-family:var(--mono);font-size:13px}

/* ── TICKER ── */
.ticker-wrap{overflow:hidden;background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);margin-bottom:24px;position:relative;height:42px;display:flex;align-items:center;box-shadow:var(--shadow-sm)}
.ticker-label{position:absolute;left:0;top:0;bottom:0;background:linear-gradient(135deg,var(--pistachio),var(--pist-dark));color:white;font-weight:700;font-size:11px;letter-spacing:1.5px;display:flex;align-items:center;padding:0 16px;z-index:2;font-family:var(--mono);border-radius:var(--radius-lg) 0 0 var(--radius-lg);gap:6px}
.ticker-content{display:flex;gap:50px;padding-left:80px;animation:ticker 90s linear infinite;white-space:nowrap;font-family:var(--mono);font-size:12.5px;color:var(--text2)}
@keyframes ticker{from{transform:translateX(0)}to{transform:translateX(-50%)}}
.ticker-item{display:inline-flex;gap:10px;align-items:center}
.ticker-item .hi{color:var(--pist-dark);font-weight:600}

/* ── SQL QUERIES ── */
.query-card{background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius-lg);margin-bottom:16px;overflow:hidden;box-shadow:var(--shadow-sm);transition:box-shadow .2s}
.query-card:hover{box-shadow:var(--shadow)}
.query-header{display:flex;align-items:center;gap:14px;padding:18px 22px;background:var(--bg);cursor:pointer;border-bottom:1.5px solid var(--border);user-select:none}
.query-num{width:30px;height:30px;background:linear-gradient(135deg,var(--pistachio),var(--pist-dark));border-radius:8px;display:flex;align-items:center;justify-content:center;font-size:13px;font-weight:700;color:white;flex-shrink:0}
.query-title{font-size:14px;font-weight:600;flex:1;color:var(--text)}
.query-toggle{color:var(--text3);font-size:18px;transition:transform .2s;line-height:1}
.query-card.open .query-toggle{transform:rotate(180deg)}
.query-body{display:none}
.query-card.open .query-body{display:block}
.query-sql{background:#f0f4ec;padding:18px 22px;font-family:var(--mono);font-size:12.5px;color:#3a5030;border-bottom:1.5px solid var(--border);line-height:1.8;overflow-x:auto}
.sql-keyword{color:var(--pist-dark);font-weight:600}
.sql-fn     {color:#c88a2a;font-weight:500}
.sql-str    {color:var(--success)}
.sql-comment{color:var(--text3);font-style:italic}
.query-result{padding:20px 22px}

/* ── UTILS ── */
.text-accent {color:var(--pist-dark)}
.text-muted  {color:var(--text3)}
.text-danger {color:var(--danger)}
.text-success{color:var(--success)}
.mono{font-family:var(--mono)}
.mt-2{margin-top:16px}
.mt-3{margin-top:24px}
.flex{display:flex}
.gap-2{gap:8px}
.items-center{align-items:center}
.empty-state{text-align:center;padding:48px 24px;color:var(--text3);font-family:var(--mono);font-size:13px}
.empty-state .icon{font-size:36px;display:block;margin-bottom:12px;opacity:.5}

/* ── HAMBURGER ── */
.hamburger{display:none;position:fixed;top:16px;left:16px;z-index:200;background:var(--bg2);border:1.5px solid var(--border);border-radius:var(--radius);padding:8px 12px;cursor:pointer;flex-direction:column;gap:4px;box-shadow:var(--shadow)}
.hamburger span{display:block;width:18px;height:2px;background:var(--text2);border-radius:2px}

/* ── RESPONSIVE ── */
@media(max-width:960px){
    .sidebar{transform:translateX(-100%);transition:transform .3s ease}
    .sidebar.open{transform:translateX(0);box-shadow:var(--shadow-lg)}
    .main-content{margin-left:0}
    .page-wrapper{padding:20px 16px}
    .hamburger{display:flex}
    .flight-board-header,.flight-row{grid-template-columns:90px 1fr 100px 100px}
    .flight-board-header>*:nth-child(5),.flight-board-header>*:nth-child(6),
    .flight-row>*:nth-child(5),.flight-row>*:nth-child(6){display:none}
    .stats-grid{grid-template-columns:repeat(2,1fr)}
}
@media(max-width:480px){
    .stats-grid{grid-template-columns:1fr}
    .auth-card{padding:28px 24px}
    .page-header{flex-direction:column;align-items:flex-start;gap:14px}
}

/* ── PAGE LOAD ── */
.page-wrapper>*{animation:fadeUp .35s ease both}
.page-wrapper>*:nth-child(1){animation-delay:.05s}
.page-wrapper>*:nth-child(2){animation-delay:.10s}
.page-wrapper>*:nth-child(3){animation-delay:.15s}
.page-wrapper>*:nth-child(4){animation-delay:.20s}
.page-wrapper>*:nth-child(5){animation-delay:.25s}
@keyframes fadeUp{from{opacity:0;transform:translateY(12px)}to{opacity:1;transform:translateY(0)}}