/* Portfolio Color Variables */
:root {
    --bg-primary: #181a20;
    --bg-secondary: #23263a;
    --bg-accent: #353866;
    --accent-color: #ffb347;
    --text-primary: #f5f6fa;
    --text-secondary: #b2becd;
    --success: #4ecdc4;
    --warning: #f39c12;
    --danger: #e74c3c;
    --info: #60BADB;
}

/* Global Styles */
* {
    margin: 0;
    padding: 0;
    box-sizing: border-box;
    max-width: 100%;
}

/* Global overflow prevention for mobile */
* {
    word-wrap: break-word;
    overflow-wrap: break-word;
}

html, body {
    height: 100%;
    overflow-x: hidden;
    width: 100%;
}

body {
    font-family: 'Inter', sans-serif;
    background: linear-gradient(135deg, var(--bg-primary) 0%, var(--bg-secondary) 100%);
    color: var(--text-primary);
    min-height: 100vh;
    position: relative;
    max-width: 100vw;
}

.dashboard-container {
    max-width: 1400px;
    margin: 0 auto;
    padding: 20px;
    width: 100%;
    box-sizing: border-box;
    overflow-x: hidden;
}

/* Header */
.dashboard-header {
    background: linear-gradient(135deg, var(--bg-secondary), var(--bg-accent));
    border-radius: 20px;
    padding: 30px;
    margin-bottom: 30px;
    box-shadow: 0 10px 30px rgba(0, 0, 0, 0.3);
    border: 1px solid rgba(255, 179, 71, 0.1);
}

.header-content {
    display: flex;
    justify-content: space-between;
    align-items: center;
    flex-wrap: wrap;
    gap: 20px;
}

.header-left h1 {
    font-family: 'Montserrat', sans-serif;
    font-size: 2.5rem;
    font-weight: 700;
    color: var(--accent-color);
    margin-bottom: 8px;
}

.header-left p {
    color: var(--text-secondary);
    font-size: 1.1rem;
}

.header-right {
    display: flex;
    gap: 15px;
    flex-wrap: wrap;
}

.btn-refresh,
.btn-export {
    margin-top: 40px;
    padding: 12px 20px;
    border: none;
    border-radius: 8px;
    font-weight: 600;
    cursor: pointer;
    transition: all 0.3s ease;
    text-decoration: none;
    display: grid;
    align-items: center;
    gap: 8px;
}

.btn-refresh {
    background: var(--info);
    color: var(--bg-primary);
}

.btn-export {
    background: var(--success);
    color: var(--bg-primary);
}

.return-section {
    margin-top: 40px;
    text-align: center;
    animation: fadeInUp 0.8s ease 0.3s both;
}
.btn-return {
    background: var(--bg-primary);
    color: var(--text-secondary);
    border: 2px solid var(--bg-accent);
    padding: 12px 25px;
    border-radius: 10px;
    font-size: 13.5px;
    font-weight: 600;
    cursor: pointer;
    transition: all 0.3s ease;
    font-family: 'Montserrat', Arial, sans-serif;
}
    
.btn-return:hover {
    background: var(--bg-accent);
    color: var(--accent-color);
    border-color: var(--accent-color);
    transform: translateY(-2px);
    box-shadow: 0 6px 20px rgba(53, 56, 102, 0.4);
}

.btn-refresh:hover,
.btn-export:hover {
    transform: translateY(-2px);
    box-shadow: 0 5px 15px rgba(0, 0, 0, 0.2);
}

/* Stats Grid */
.stats-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
    gap: 20px;
    margin-bottom: 30px;
}

.stat-card {
    background: linear-gradient(135deg, var(--bg-secondary), var(--bg-accent));
    border-radius: 15px;
    padding: 25px;
    display: flex;
    align-items: center;
    gap: 20px;
    box-shadow: 0 8px 25px rgba(0, 0, 0, 0.2);
    border: 1px solid rgba(255, 179, 71, 0.1);
    transition: all 0.3s ease;
}

.stat-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 15px 35px rgba(0, 0, 0, 0.3);
}

.stat-icon {
    font-size: 3rem;
    opacity: 0.8;
}

.stat-content h3 {
    color: var(--text-secondary);
    font-size: 0.9rem;
    margin-bottom: 8px;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

.stat-value {
    font-size: 2.2rem;
    font-weight: 700;
    color: var(--text-primary);
    margin-bottom: 5px;
}

.stat-change {
    font-size: 0.85rem;
    font-weight: 600;
    padding: 2px 8px;
    border-radius: 12px;
}

.stat-change.positive {
    color: var(--success);
    background: rgba(78, 205, 196, 0.1);
}

.stat-change.negative {
    color: var(--danger);
    background: rgba(231, 76, 60, 0.1);
}

/* Dashboard Grid */
.dashboard-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(320px, 1fr));
    gap: 25px;
    width: 100%;
    box-sizing: border-box;
}

/* Chart Containers */
.chart-container,
.data-table-container,
.analytics-panel,
.goals-panel,
.sql-showcase {
    background: linear-gradient(135deg, var(--bg-secondary), var(--bg-accent));
    border-radius: 15px;
    padding: 25px;
    box-shadow: 0 10px 30px rgba(0, 0, 0, 0.2);
    border: 1px solid rgba(255, 179, 71, 0.1);
    width: 100%;
    max-width: 100%;
    box-sizing: border-box;
    overflow-x: hidden;
}

.chart-header,
.table-header,
.panel-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 20px;
}

.chart-header h3,
.table-header h3,
.panel-header h3 {
    color: var(--accent-color);
    font-size: 1.3rem;
    font-weight: 600;
}

.chart-controls select,
.table-controls select {
    background: var(--bg-primary);
    color: var(--text-primary);
    border: 1px solid var(--bg-accent);
    border-radius: 8px;
    padding: 8px 12px;
    font-size: 0.9rem;
}

/* Revenue Chart Specific */
.revenue-chart {
    grid-column: span 2;
    min-height: 400px;
    max-height: 450px;
    overflow: hidden;
    transition: opacity 0.3s ease;
}

.revenue-chart canvas {
    max-height: 300px !important;
    height: 300px !important;
}

/* Regional Chart */
.regional-chart canvas {
    max-height: 300px !important;
    height: 300px !important;
}

/* General Chart Container */
.chart-container canvas {
    max-width: 100% !important;
    height: auto !important;
    max-height: 300px !important;
}

/* Table Styles */
.table-container {
    overflow-x: auto;
    width: 100%;
    max-width: 100%;
    box-sizing: border-box;
}

table {
    width: 100%;
    border-collapse: collapse;
    min-width: 600px;
}

th,
td {
    padding: 12px;
    text-align: left;
    border-bottom: 1px solid rgba(255, 179, 71, 0.1);
}

th {
    background: var(--bg-primary);
    color: var(--accent-color);
    font-weight: 600;
    text-transform: uppercase;
    font-size: 0.85rem;
    letter-spacing: 0.5px;
}

td {
    color: var(--text-primary);
}

tr:hover {
    background: rgba(255, 179, 71, 0.05);
}

/* Analytics Panel */
.analytics-content {
    display: flex;
    flex-direction: column;
    gap: 20px;
}

.metric-row {
    display: flex;
    justify-content: space-between;
    align-items: center;
    gap: 15px;
}

.metric-label {
    color: var(--text-secondary);
    font-size: 0.9rem;
    flex: 1;
}

.metric-bar {
    flex: 2;
    background: var(--bg-primary);
    border-radius: 10px;
    height: 8px;
    position: relative;
    margin-right: 15px;
}

.bar-fill {
    background: linear-gradient(90deg, var(--info), var(--success));
    height: 100%;
    border-radius: 10px;
    transition: width 1s ease;
}

.metric-value {
    color: var(--accent-color);
    font-weight: 600;
    min-width: 50px;
}

/* Goals Panel */
.goals-content {
    display: flex;
    flex-direction: column;
    gap: 20px;
}

.goal-item {
    display: flex;
    flex-direction: column;
    gap: 8px;
}

.goal-info {
    display: flex;
    justify-content: space-between;
    align-items: center;
}

.goal-label {
    color: var(--text-secondary);
    font-size: 0.9rem;
}

.goal-progress {
    color: var(--text-primary);
    font-size: 0.85rem;
    font-weight: 500;
}

.progress-bar {
    background: var(--bg-primary);
    border-radius: 10px;
    height: 12px;
    position: relative;
}

.progress-fill {
    background: linear-gradient(90deg, var(--accent-color), var(--warning));
    height: 100%;
    border-radius: 10px;
    transition: width 1.5s ease;
}

.goal-percentage {
    color: var(--success);
    font-weight: 600;
    font-size: 0.9rem;
    align-self: flex-end;
}

/* SQL Showcase */
.sql-showcase {
    grid-column: span 2;
}

.btn-toggle {
    background: var(--info);
    color: var(--bg-primary);
    border: none;
    padding: 8px 16px;
    border-radius: 6px;
    cursor: pointer;
    font-weight: 500;
    transition: all 0.3s ease;
}

.btn-toggle:hover {
    background: var(--accent-color);
}

.sql-content {
    display: none;
    margin-top: 20px;
}

.sql-content.visible {
    display: block;
}

.sql-query {
    margin-bottom: 25px;
}

.sql-query h4 {
    color: var(--accent-color);
    font-size: 1.1rem;
    margin-bottom: 10px;
}

.sql-query pre {
    background: var(--bg-primary);
    border-radius: 8px;
    padding: 20px;
    overflow-x: auto;
    border-left: 4px solid var(--accent-color);
}

.sql-query code {
    color: var(--text-primary);
    font-family: 'Courier New', monospace;
    font-size: 0.9rem;
    line-height: 1.5;
}

/* Footer */
.dashboard-footer {
    margin-top: 40px;
    background: linear-gradient(135deg, var(--bg-secondary), var(--bg-accent));
    border-radius: 15px;
    padding: 25px;
    box-shadow: 0 8px 25px rgba(0, 0, 0, 0.2);
    border: 1px solid rgba(255, 179, 71, 0.1);
}

.footer-content {
    display: flex;
    justify-content: space-between;
    align-items: flex-start;
    gap: 30px;
    flex-wrap: wrap;
}

.tech-info h4 {
    color: var(--accent-color);
    margin-bottom: 15px;
    font-size: 1.1rem;
}

.tech-tags {
    display: flex;
    gap: 10px;
    flex-wrap: wrap;
}

.tech-tag {
    background: var(--bg-primary);
    color: var(--info);
    padding: 6px 12px;
    border-radius: 20px;
    font-size: 0.8rem;
    font-weight: 500;
    border: 1px solid var(--info);
}

.portfolio-info {
    text-align: right;
    color: var(--text-secondary);
    line-height: 1.6;
}

.portfolio-info strong {
    color: var(--accent-color);
}

/* Loading Overlay */
.loading-overlay {
    position: fixed;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: rgba(24, 26, 32, 0.9);
    display: flex;
    justify-content: center;
    align-items: center;
    z-index: 1000;
    opacity: 0;
    pointer-events: none;
    transition: opacity 0.3s ease;
}

.loading-overlay.visible {
    opacity: 1;
    pointer-events: all;
}

.loading-content {
    text-align: center;
    color: var(--text-primary);
}

.loading-spinner {
    width: 60px;
    height: 60px;
    border: 4px solid var(--bg-accent);
    border-top: 4px solid var(--accent-color);
    border-radius: 50%;
    animation: spin 1s linear infinite;
    margin: 0 auto 20px;
}

/* Ensure scrollbars work properly */
::-webkit-scrollbar {
    width: 10px;
}
    
::-webkit-scrollbar-track {
    background: var(--primary-bg);
}
    
::-webkit-scrollbar-thumb {
    background: var(--accent-color);
    border-radius: 4px;
}
    
::-webkit-scrollbar-thumb:hover {
    background: #ff8c42;
}

@keyframes spin {
    0% { transform: rotate(0deg); }
    100% { transform: rotate(360deg); }
}

.loading-content h3 {
    color: var(--accent-color);
    margin-bottom: 10px;
}

.loading-content p {
    color: var(--text-secondary);
}

/* Responsive Design */
@media (max-width: 1200px) {
    .dashboard-grid {
        grid-template-columns: 1fr;
    }
    
    .revenue-chart,
    .sql-showcase {
        grid-column: span 1;
    }
}

@media (max-width: 768px) {
    .dashboard-container {
        padding: 15px;
    }
    
    .header-content {
        flex-direction: column;
        text-align: center;
    }
    
    .header-left h1 {
        font-size: 2rem;
    }
    
    .stats-grid {
        grid-template-columns: 1fr;
    }
    
    .dashboard-grid {
        grid-template-columns: 1fr;
        gap: 20px;
    }
    
    .chart-container,
    .data-table-container,
    .analytics-panel,
    .goals-panel,
    .sql-showcase {
        padding: 15px;
        max-width: calc(100vw - 30px);
        margin: 0 auto;
    }
    
    .chart-header,
    .table-header,
    .panel-header {
        flex-direction: column;
        gap: 15px;
        text-align: center;
    }
    
    .footer-content {
        flex-direction: column;
        text-align: center;
    }
    
    .portfolio-info {
        text-align: center;
    }
}

@media (max-width: 480px) {
    .dashboard-container {
        padding: 10px;
    }
    
    .dashboard-grid {
        gap: 15px;
    }
    
    .chart-container,
    .data-table-container,
    .analytics-panel,
    .goals-panel,
    .sql-showcase {
        padding: 12px;
        max-width: calc(100vw - 20px);
        overflow: hidden;
    }
    
    .stat-card {
        flex-direction: column;
        text-align: center;
        gap: 15px;
    }
    
    .stat-icon {
        font-size: 2.5rem;
    }
    
    .metric-row {
        flex-direction: column;
        gap: 10px;
        text-align: center;
    }
    
    .metric-bar {
        width: 100%;
        margin-right: 0;
    }
    
    table {
        min-width: 500px;
        font-size: 14px;
    }
    
    th, td {
        padding: 8px 6px;
    }

    .header-right {
        flex-direction: column !important;
        gap: 8px !important;
        align-items: stretch !important;
    }
    .btn-return,
    .btn-refresh,
    .btn-export {
        width: 100%;
        margin-top: 0 !important;
        margin-bottom: 0 !important;
        padding-top: 10px;
        padding-bottom: 10px;
    }
    .return-section {
        margin-top: 0 !important;
        margin-bottom: 0 !important;
    }
}