@import url('https://fonts.googleapis.com/css2?family=Lexend:wght@400;500;600&family=Roboto:wght@300;400;500;700&display=swap');

:root {
    --google-blue: #1a73e8;
    --google-red: #d93025;
    --google-yellow: #f9ab00;
    --google-green: #1e8e3e;
    --google-gray-50: #f8f9fa;
    --google-gray-100: #f1f3f4;
    --google-gray-200: #e8eaed;
    --google-gray-300: #dadce0;
    --google-gray-500: #9aa0a6;
    --google-gray-700: #5f6368;
    --google-gray-800: #3c4043;
    --google-gray-900: #202124;
    --font-family: 'Roboto', 'Inter', -apple-system, sans-serif;
    --brand-font: 'Lexend', sans-serif;
    --shadow-1: 0 1px 2px 0 rgba(60,64,67,0.3), 0 1px 3px 1px rgba(60,64,67,0.15);
    --shadow-2: 0 4px 6px -1px rgba(0,0,0,0.1), 0 2px 4px -1px rgba(0,0,0,0.06);
    --shadow-3: 0 10px 15px -3px rgba(0,0,0,0.1), 0 4px 6px -2px rgba(0,0,0,0.05);
    --border-radius-sm: 8px;
    --border-radius-md: 12px;
    --border-radius-lg: 20px;
    --border-radius-pill: 500px;
    --header-height: 64px;
    --sidebar-width: 280px;
    --sidebar-collapsed-width: 72px;
}
* {
    box-sizing: border-box;
}

/* Global Filter Overlay System */
.filter-panel {
    position: relative;
    border-radius: 8px;
    z-index: 1000;
}
.filter-content {
    position: absolute;
    top: 100%;
    left: 0;
    width: 100%;
    background: #fff;
    z-index: 1010;
    box-shadow: 0 10px 25px rgba(0,0,0,0.15), 0 5px 10px rgba(0,0,0,0.1);
    border: 1px solid var(--google-gray-300);
    border-top: none;
    border-radius: 0 0 8px 8px;
    display: grid;
    grid-template-columns: repeat(4, 1fr);
    row-gap: 10px; /* Reduced from 20px */
    column-gap: 20px;
    padding: 24px;
}
.filter-collapsed .filter-content {
    display: none;
}
.filter-header {
    cursor: pointer;
}

body {
    background-color: var(--google-gray-100);
    color: var(--google-gray-900);
    font-family: var(--font-family);
    margin: 0;
    padding-top: 64px;
}

/* Header / Profile Area */
.g-header {
    background-color: rgba(255, 255, 255, 0.85);
    backdrop-filter: blur(12px) saturate(180%);
    -webkit-backdrop-filter: blur(12px) saturate(180%);
    padding: 0 24px;
    display: flex;
    align-items: center;
    justify-content: space-between;
    border-bottom: 1px solid var(--google-gray-200);
    position: fixed;
    top: 0;
    left: 0;
    right: 0;
    height: var(--header-height);
    z-index: 1050;
    transition: all 0.3s ease;
}

.g-header-left {
    display: flex;
    align-items: center;
    gap: 8px;
}

.g-logo {
    font-family: var(--brand-font);
    font-size: 22px;
    font-weight: 500;
    color: var(--google-gray-800);
    display: flex;
    align-items: center;
    gap: 1.5px;
    margin-left: 12px;
    letter-spacing: -0.5px;
}

.g-logo span:first-child { color: var(--google-blue); }
.g-logo span:nth-child(2) { color: var(--google-red); }
.g-logo span:nth-child(3) { color: var(--google-yellow); }
.g-logo span:nth-child(4) { color: var(--google-blue); }
.g-logo span:nth-child(5) { color: var(--google-green); }
.g-logo span:nth-child(6) { color: var(--google-red); }

.g-brand-text {
    font-family: var(--brand-font);
    font-weight: 500;
    letter-spacing: -0.5px;
}

/* Sidebar */
.g-sidebar {
    width: var(--sidebar-width);
    background-color: #fff;
    height: calc(100vh - var(--header-height));
    position: fixed;
    top: var(--header-height);
    border-right: 1px solid var(--google-gray-200);
    padding: 12px 8px;
    transition: width 0.3s cubic-bezier(0.4, 0, 0.2, 1);
    overflow-x: hidden;
    z-index: 1040;
}
.collapsed .g-sidebar {
    width: var(--sidebar-collapsed-width);
}

.g-nav-item {
    display: flex;
    align-items: center;
    padding: 10px 16px;
    color: var(--google-gray-700);
    text-decoration: none;
    font-size: 14px;
    font-weight: 500;
    border-radius: var(--border-radius-pill);
    margin-bottom: 4px;
    transition: all 0.2s cubic-bezier(0.4, 0, 0.2, 1);
}

.g-nav-item:hover {
    background-color: var(--google-gray-100);
    color: var(--google-gray-900);
}

.g-nav-item.active {
    background-color: #e8f0fe;
    color: #1967d2;
}

.g-nav-item i {
    width: 24px;
    margin-right: 16px;
    font-size: 18px;
    display: flex;
    align-items: center;
    justify-content: center;
}

.g-nav-header {
    font-size: 11px;
    font-weight: 700;
    text-transform: uppercase;
    color: var(--google-gray-500);
    padding: 15px 24px 8px;
    letter-spacing: 0.5px;
    cursor: pointer;
    display: flex;
    justify-content: space-between;
    align-items: center;
    transition: color 0.2s;
}

.g-nav-header:hover { color: var(--google-blue); }

.g-nav-header i.chevron {
    transition: transform 0.3s;
    font-size: 10px;
}

.g-nav-group.expanded .g-nav-header i.chevron {
    transform: rotate(180deg);
}

/* Accordion Transition */
.g-nav-submenu {
    display: grid;
    grid-template-rows: 0fr;
    transition: grid-template-rows 0.3s ease-out;
    overflow: hidden;
}

.g-nav-group.expanded .g-nav-submenu {
    grid-template-rows: 1fr;
}

.g-submenu-inner {
    min-height: 0;
}

.g-nav-sub-item {
    display: flex;
    align-items: center;
    padding: 8px 16px 8px 52px;
    text-decoration: none;
    color: var(--google-gray-700);
    font-size: 13px;
    border-radius: 0 20px 20px 0;
    transition: all 0.2s;
    margin-right: 8px;
}

.g-nav-item i {
    width: 24px;
    margin-right: 12px;
    font-size: 18px;
}

/* Content Area */
.g-content {
    margin-left: var(--sidebar-width);
    padding: 32px;
    transition: margin-left 0.3s cubic-bezier(0.4, 0, 0.2, 1);
}
.collapsed .g-content {
    margin-left: var(--sidebar-collapsed-width);
}

/* Collapsed State Item Adjustments */
.collapsed .g-nav-item span,
.collapsed .g-nav-header span,
.collapsed .g-nav-header i.chevron,
.collapsed .g-nav-submenu,
.collapsed .g-sidebar .version-text {
    display: none; /* Removed !important to allow hover state overrides */
}

/* Tooltip on Hover for Collapsed state */
.collapsed .g-nav-item:hover,
.collapsed .g-nav-header:hover {
    position: relative;
    overflow: visible;
}

.collapsed .g-nav-item span,
.collapsed .g-nav-header span {
    display: flex !important;
    position: fixed;
    left: calc(var(--sidebar-collapsed-width) - 10px);
    background-color: var(--google-gray-800);
    color: #fff;
    padding: 6px 16px;
    border-radius: 4px;
    font-size: 13px;
    font-weight: 500;
    white-space: nowrap;
    z-index: 2000;
    box-shadow: var(--shadow-2);
    pointer-events: auto;
    
    /* Persistence Delay */
    visibility: hidden;
    opacity: 0;
    transition: opacity 0.3s ease, visibility 0s linear 1s;
}

.collapsed .g-nav-item:hover span,
.collapsed .g-nav-group:hover span {
    visibility: visible;
    opacity: 1;
    transition: opacity 0.3s ease, visibility 0s linear 0s;
}

.collapsed .g-nav-group .g-nav-submenu {
    display: block !important;
    grid-template-rows: none !important;
    position: fixed;
    left: calc(var(--sidebar-collapsed-width) - 10px); /* Overlap by 10px to ensure no gap */
    width: 220px;
    background-color: #fff;
    border-radius: var(--border-radius-md);
    box-shadow: 10px 5px 25px rgba(0,0,0,0.15);
    border: 1px solid var(--google-gray-200);
    z-index: 2100;
    padding: 8px 0;
    margin-top: -10px;
    
    /* Smooth Transition with Delay on Exit */
    visibility: hidden;
    opacity: 0;
    transform: translateX(5px);
    transition: opacity 0.3s ease, transform 0.3s ease, visibility 0s linear 1s; /* Stays visible for 1s after mouse out */
}

/* Shown state on Hover */
.collapsed .g-nav-group:hover .g-nav-submenu {
    visibility: visible;
    opacity: 1;
    transform: translateX(0);
    transition: opacity 0.3s ease, transform 0.3s ease, visibility 0s linear 0s; /* Appears instantly */
}

/* Invisible bridge to maintain hover state while moving mouse */
.collapsed .g-nav-group:hover .g-nav-submenu::before {
    content: '';
    position: absolute;
    top: 0;
    left: -20px;
    width: 20px;
    height: 100%;
}

.collapsed .g-nav-group:hover .g-nav-submenu .g-submenu-inner {
    min-height: auto;
}

.collapsed .g-nav-group:hover .g-nav-sub-item {
    display: flex !important;
    padding: 10px 20px;
    border-radius: 0;
    margin-right: 0;
    font-size: 14px;
}

.collapsed .g-nav-group:hover .g-nav-sub-item:hover {
    background-color: var(--google-gray-100);
    color: var(--google-blue);
}

.collapsed .g-nav-item, 
.collapsed .g-nav-header {
    justify-content: center;
    padding: 12px 0;
    margin-right: 0;
    border-radius: 0;
}

.collapsed .g-nav-item i {
    margin-right: 0;
    font-size: 20px;
}

/* Cards */
.g-card {
    background-color: #fff;
    border-radius: var(--border-radius);
    border: 1px solid var(--google-gray-300);
    padding: 24px;
    margin-bottom: 24px;
    transition: box-shadow 0.2s;
}

.g-card:hover {
    box-shadow: var(--shadow-1);
}

/* Premium Dashboard Cards */
.dash-card {
    position: relative;
    padding: 24px;
    border-radius: 12px;
    color: #fff !important;
    overflow: hidden;
    box-shadow: 0 4px 6px -1px rgba(0,0,0,0.1), 0 2px 4px -1px rgba(0,0,0,0.06);
    transition: transform 0.2s, box-shadow 0.2s;
    border: none;
    display: flex;
    flex-direction: column;
    justify-content: center;
    min-height: 120px;
}
.dash-card:hover {
    transform: translateY(-4px);
    box-shadow: 0 10px 15px -3px rgba(0,0,0,0.1), 0 4px 6px -2px rgba(0,0,0,0.05);
}
.dash-card .dash-label {
    font-size: 11px;
    font-weight: 700;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    margin-bottom: 4px;
    opacity: 0.85;
}
.dash-card .dash-value {
    font-size: 36px;
    font-weight: 700;
    margin: 0;
}
.dash-card .dash-icon {
    position: absolute;
    right: 24px;
    top: 50%;
    transform: translateY(-50%);
    font-size: 56px;
    opacity: 0.25;
}
.dash-card-blue { background: linear-gradient(135deg, #1a73e8 0%, #1557b0 100%); }
.dash-card-red { background: linear-gradient(135deg, #d93025 0%, #a52714 100%); }
.dash-card-yellow { background: linear-gradient(135deg, #f9ab00 0%, #e39a00 100%); }
.dash-card-green { background: linear-gradient(135deg, #1e8e3e 0%, #137333 100%); }

/* Material Inputs */
.g-input-group {
    margin-bottom: 0; /* Changed from 20px as grid gap handles spacing */
}

.g-label {
    display: block;
    margin-bottom: 4px; /* Reduced from 8px for compactness */
    font-size: 14px;
    font-weight: 500;
    color: var(--google-gray-800);
}

.g-input {
    width: 100%;
    height: 38px;
    padding: 0 12px;
    border: 1px solid var(--google-gray-300);
    border-radius: 4px;
    font-size: 14px;
    outline: none;
    transition: border-color 0.2s, box-shadow 0.2s;
    box-sizing: border-box;
    display: flex;
    align-items: center;
    background-color: #fff;
}

.g-input:focus {
    border-color: var(--google-blue);
    box-shadow: 0 0 0 2px rgba(66, 133, 244, 0.2);
}

/* Buttons */
.g-btn {
    display: inline-flex;
    align-items: center;
    justify-content: center;
    padding: 0 24px;
    height: 38px;
    border-radius: 4px;
    font-size: 14px;
    font-weight: 500;
    cursor: pointer;
    border: none;
    transition: filter 0.2s, box-shadow 0.2s;
    box-sizing: border-box;
    text-decoration: none;
    line-height: normal;
}

.g-btn-primary {
    background-color: var(--google-blue);
    color: #fff;
}

.g-btn-primary:hover {
    filter: brightness(0.9);
    box-shadow: var(--shadow-1);
}

.g-btn-outline {
    background-color: #fff;
    border: 1px solid var(--google-gray-300);
    color: var(--google-blue);
}

.g-btn-outline:hover {
    background-color: var(--google-gray-100);
}

/* Table */
.g-table {
    width: 100%;
    border-collapse: collapse;
}

.g-table th {
    text-align: left;
    padding: 12px 16px;
    font-size: 12px;
    color: var(--google-gray-700);
    text-transform: uppercase;
    border-bottom: 1px solid var(--google-gray-300);
    background-color: #f8f9fa;
    position: sticky;
    top: 0;
    z-index: 5;
}

.g-table td {
    padding: 16px;
    border-bottom: 1px solid var(--google-gray-300);
    font-size: 14px;
}

.g-table tr:hover {
    background-color: var(--google-gray-100);
}

/* Badges */
.g-badge {
    padding: 4px 8px;
    border-radius: 12px;
    font-size: 12px;
    font-weight: 500;
}

.g-badge-success { background-color: #E6F4EA; color: var(--google-green); }
.g-badge-error { background-color: #FCE8E6; color: var(--google-red); }

/* Choices.js Google Material Overrides */
.choices {
    margin-bottom: 0px;
    font-family: var(--font-family);
}
.choices__inner {
    border: 1px solid var(--google-gray-300) !important;
    border-radius: 4px !important;
    background-color: #fff !important;
    padding: 0 12px !important;
    height: 38px !important;
    min-height: 38px !important;
    display: flex !important;
    align-items: center !important;
}
.choices__list--single {
    padding: 0 !important;
    font-size: 14px !important;
}
.choices[data-type*="select-one"]::after {
    display: none !important;
}
.choices.is-focused .choices__inner {
    border-color: var(--google-blue) !important;
    box-shadow: 0 0 0 2px rgba(66, 133, 244, 0.2) !important;
}
.choices__list--dropdown {
    border-radius: 4px !important;
    box-shadow: var(--shadow-2) !important;
    border: none !important;
    margin-top: 5px;
}
.choices__item--selectable {
    padding: 10px 15px !important;
    font-size: 14px !important;
}
.choices__item--selectable.is-highlighted {
    background-color: #E8F0FE !important;
    color: var(--google-blue) !important;
}
.choices__input {
    background-color: var(--google-gray-100) !important;
    font-size: 14px !important;
    padding: 8px !important;
}
.choices__placeholder {
    opacity: 0.6;
}

/* Segmented Control (Google Style Pills) */
.g-segmented {
    display: flex;
    background: #f1f3f4;
    border-radius: 20px;
    padding: 2px;
    width: 100%;
    height: 38px;
    margin-top: 4px;
}
.g-segmented-item {
    flex: 1;
    display: flex;
    align-items: center;
    justify-content: center;
    border-radius: 18px;
    cursor: pointer;
    font-size: 13px;
    font-weight: 500;
    color: #5f6368;
    transition: all 0.2s;
    user-select: none;
}
.g-segmented-item:hover { background: rgba(0,0,0,0.05); }
.g-segmented-item.active {
    background: #fff;
    color: #1a73e8;
    box-shadow: 0 1px 2px rgba(60,64,67,.3), 0 1px 3px 0.5px rgba(60,64,67,.15);
}
.g-segmented input { display: none; }

/* Hamburger Toggle - Refactored for Header */
.g-hamburger {
    width: 48px;
    height: 48px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    cursor: pointer;
    transition: background-color 0.3s cubic-bezier(0.4, 0, 0.2, 1);
    color: var(--google-gray-700);
    position: relative;
    margin-left: -12px; /* Pull into padding for better alignment */
}

.g-hamburger:hover {
    background-color: rgba(60, 64, 67, 0.08);
    color: var(--google-gray-900);
}

.g-hamburger:active {
    background-color: rgba(60, 64, 67, 0.12);
}

.g-hamburger i {
    font-size: 20px;
}

/* --- TAB SYSTEM --- */
.g-tabs {
    display: flex;
    border-bottom: 1px solid var(--google-gray-300);
    margin-bottom: 24px;
    gap: 8px;
}

.g-tab-item {
    padding: 12px 24px;
    cursor: pointer;
    font-size: 14px;
    font-weight: 500;
    color: var(--google-gray-700);
    border-bottom: 3px solid transparent;
    transition: all 0.2s;
    user-select: none;
    display: flex;
    align-items: center;
    gap: 8px;
}

.g-tab-item:hover {
    background-color: var(--google-gray-100);
    color: var(--google-gray-900);
}

.g-tab-item.active {
    color: var(--google-blue);
    border-bottom-color: var(--google-blue);
}

/* --- UTILITIES --- */
.g-hidden { display: none !important; }

.log-container {
    background-color: #1e1e1e;
    color: #d4d4d4;
    font-family: 'Consolas', 'Monaco', monospace;
    padding: 16px;
    border-radius: 8px;
    height: 500px;
    overflow-y: auto;
    font-size: 13px;
    line-height: 1.5;
    box-shadow: inset 0 2px 10px rgba(0,0,0,0.5);
}

.log-entry {
    border-bottom: 1px solid #333;
    padding: 4px 0;
}

.log-date { color: #569cd6; font-weight: bold; }

.sql-console {
    font-family: 'Consolas', monospace;
    width: 100%;
    min-height: 150px;
    background: #f8f9fa;
    border: 1px solid var(--google-gray-300);
    border-radius: 8px;
    padding: 12px;
    font-size: 14px;
    resize: vertical;
    outline: none;
}

.sql-console:focus {
    border-color: var(--google-blue);
    box-shadow: 0 0 0 2px rgba(66, 133, 244, 0.1);
}