cd /home/tanahtin/museum.pondoktingal.com

# =============================================
# 1. BEAUTIFUL HEADER CSS - Modern Design
# =============================================

cat > admin/css/admin.css << 'CSS'
:root {
    --primary: #6366f1;
    --primary-dark: #4f46e5;
    --primary-light: #818cf8;
    --secondary: #ec4899;
    --success: #10b981;
    --danger: #ef4444;
    --warning: #f59e0b;
    --dark: #0f172a;
    --dark-light: #1e293b;
    --gray: #64748b;
    --gray-light: #94a3b8;
    --border: #e2e8f0;
    --bg: #f8fafc;
}

* {
    margin: 0;
    padding: 0;
    box-sizing: border-box;
}

body {
    font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif;
    background: var(--bg);
    color: var(--dark);
}

/* Modern Header */
.admin-header {
    background: linear-gradient(135deg, var(--dark) 0%, var(--dark-light) 100%);
    border-bottom: 1px solid rgba(255,255,255,0.1);
    position: sticky;
    top: 0;
    z-index: 100;
}

/* Top Bar */
.header-top {
    padding: 0 32px;
    height: 70px;
    display: flex;
    align-items: center;
    justify-content: space-between;
    border-bottom: 1px solid rgba(255,255,255,0.08);
}

.logo {
    display: flex;
    align-items: center;
    gap: 12px;
}

.logo-icon {
    font-size: 32px;
}

.logo-text {
    font-size: 22px;
    font-weight: 700;
    background: linear-gradient(135deg, #fff 0%, var(--primary-light) 100%);
    -webkit-background-clip: text;
    -webkit-text-fill-color: transparent;
    background-clip: text;
}

.logo-text span {
    color: var(--primary-light);
    -webkit-text-fill-color: var(--primary-light);
}

.user-info {
    display: flex;
    align-items: center;
    gap: 24px;
}

.user-badge {
    display: flex;
    align-items: center;
    gap: 12px;
    padding: 8px 16px;
    background: rgba(255,255,255,0.08);
    border-radius: 40px;
}

.user-avatar {
    width: 32px;
    height: 32px;
    background: linear-gradient(135deg, var(--primary), var(--secondary));
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 14px;
}

.user-name {
    font-weight: 500;
    color: white;
}

.user-role {
    font-size: 12px;
    color: var(--gray-light);
    margin-left: 4px;
}

.logout-btn {
    padding: 8px 20px;
    background: rgba(239, 68, 68, 0.15);
    border: 1px solid rgba(239, 68, 68, 0.3);
    border-radius: 40px;
    color: #fca5a5;
    text-decoration: none;
    font-size: 14px;
    font-weight: 500;
    transition: all 0.3s;
}

.logout-btn:hover {
    background: rgba(239, 68, 68, 0.25);
    border-color: rgba(239, 68, 68, 0.5);
    color: #fff;
}

/* Navigation Menu - Modern Pill Design */
.header-nav {
    padding: 12px 32px;
    display: flex;
    gap: 8px;
    flex-wrap: wrap;
    background: rgba(0,0,0,0.2);
}

.header-nav a {
    padding: 10px 20px;
    border-radius: 40px;
    text-decoration: none;
    font-size: 14px;
    font-weight: 500;
    transition: all 0.2s;
    display: inline-flex;
    align-items: center;
    gap: 8px;
    color: var(--gray-light);
    background: transparent;
}

.header-nav a:hover {
    background: rgba(255,255,255,0.1);
    color: white;
}

.header-nav a.active {
    background: linear-gradient(135deg, var(--primary), var(--primary-dark));
    color: white;
    box-shadow: 0 2px 8px rgba(99, 102, 241, 0.3);
}

/* Container */
.container {
    padding: 32px;
    max-width: 1400px;
    margin: 0 auto;
}

/* Dashboard Stats */
.stats-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
    gap: 24px;
    margin-bottom: 0;
}

.stat-card {
    background: white;
    padding: 24px;
    border-radius: 20px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.05);
    border: 1px solid var(--border);
    transition: transform 0.2s, box-shadow 0.2s;
}

.stat-card:hover {
    transform: translateY(-2px);
    box-shadow: 0 10px 25px -5px rgba(0,0,0,0.1);
}

.stat-card .stat-number {
    font-size: 42px;
    font-weight: 800;
    background: linear-gradient(135deg, var(--primary), var(--primary-light));
    -webkit-background-clip: text;
    -webkit-text-fill-color: transparent;
    background-clip: text;
    margin-bottom: 8px;
}

.stat-card .stat-label {
    color: var(--gray);
    font-size: 14px;
    font-weight: 500;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

/* Page Title */
.page-title {
    font-size: 28px;
    font-weight: 700;
    margin-bottom: 24px;
    color: var(--dark);
    display: flex;
    align-items: center;
    gap: 12px;
}

.page-title::before {
    content: '';
    width: 4px;
    height: 28px;
    background: linear-gradient(135deg, var(--primary), var(--secondary));
    border-radius: 4px;
}

/* Buttons */
.btn {
    display: inline-flex;
    align-items: center;
    gap: 8px;
    padding: 10px 20px;
    border-radius: 40px;
    text-decoration: none;
    font-weight: 500;
    font-size: 14px;
    transition: all 0.2s;
    cursor: pointer;
    border: none;
}

.btn-primary {
    background: linear-gradient(135deg, var(--primary), var(--primary-dark));
    color: white;
    box-shadow: 0 2px 4px rgba(99, 102, 241, 0.2);
}

.btn-primary:hover {
    transform: translateY(-1px);
    box-shadow: 0 4px 12px rgba(99, 102, 241, 0.3);
}

.btn-danger {
    background: linear-gradient(135deg, var(--danger), #dc2626);
    color: white;
}

.btn-danger:hover {
    transform: translateY(-1px);
    filter: brightness(1.05);
}

.btn-warning {
    background: linear-gradient(135deg, var(--warning), #d97706);
    color: white;
}

.btn-sm {
    padding: 6px 14px;
    font-size: 12px;
}

/* Table */
.table-container {
    background: white;
    border-radius: 16px;
    overflow: auto;
    border: 1px solid var(--border);
    box-shadow: 0 1px 3px rgba(0,0,0,0.05);
}

table {
    width: 100%;
    border-collapse: collapse;
}

table thead {
    background: #f1f5f9;
}

table th {
    padding: 16px;
    text-align: left;
    font-weight: 600;
    color: var(--gray);
    font-size: 12px;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

table td {
    padding: 16px;
    border-bottom: 1px solid var(--border);
}

table tbody tr:hover {
    background: #f8fafc;
}

/* Form */
.form-card {
    background: white;
    border-radius: 20px;
    padding: 32px;
    max-width: 600px;
    margin: 0 auto;
    border: 1px solid var(--border);
    box-shadow: 0 1px 3px rgba(0,0,0,0.05);
}

.form-group {
    margin-bottom: 24px;
}

.form-group label {
    display: block;
    margin-bottom: 8px;
    font-weight: 600;
    color: var(--dark);
}

.form-group input,
.form-group select,
.form-group textarea {
    width: 100%;
    padding: 12px 16px;
    border: 2px solid var(--border);
    border-radius: 12px;
    font-size: 14px;
    transition: all 0.2s;
}

.form-group input:focus,
.form-group select:focus,
.form-group textarea:focus {
    outline: none;
    border-color: var(--primary);
    box-shadow: 0 0 0 3px rgba(99, 102, 241, 0.1);
}

/* Alerts */
.alert {
    padding: 14px 20px;
    border-radius: 12px;
    margin-bottom: 24px;
    font-size: 14px;
}

.alert-success {
    background: #ecfdf5;
    color: #065f46;
    border: 1px solid #a7f3d0;
}

.alert-danger {
    background: #fef2f2;
    color: #991b1b;
    border: 1px solid #fecaca;
}

/* Filter Bar */
.filter-bar {
    background: white;
    padding: 16px 20px;
    border-radius: 16px;
    margin-bottom: 24px;
    display: flex;
    gap: 16px;
    align-items: center;
    flex-wrap: wrap;
    border: 1px solid var(--border);
}

.filter-bar label {
    font-weight: 500;
    color: var(--gray);
}

.filter-bar select {
    padding: 8px 16px;
    border: 2px solid var(--border);
    border-radius: 40px;
    background: white;
}

/* Gallery */
.gallery {
    display: grid;
    grid-template-columns: repeat(auto-fill, minmax(240px, 1fr));
    gap: 24px;
}

.gallery-item {
    background: white;
    border-radius: 16px;
    overflow: hidden;
    border: 1px solid var(--border);
    transition: transform 0.2s;
}

.gallery-item:hover {
    transform: translateY(-4px);
}

.gallery-item img {
    width: 100%;
    height: 200px;
    object-fit: cover;
}

.gallery-item-info {
    padding: 12px 16px;
}

.gallery-item-actions {
    display: flex;
    gap: 8px;
    padding: 12px 16px;
    border-top: 1px solid var(--border);
    background: #f8fafc;
}

/* Login Page */
.login-container {
    max-width: 440px;
    margin: 100px auto;
    background: white;
    padding: 48px;
    border-radius: 32px;
    box-shadow: 0 20px 40px -12px rgba(0,0,0,0.15);
}

.login-container h1 {
    text-align: center;
    margin-bottom: 8px;
    font-size: 32px;
}

.login-container button {
    width: 100%;
    padding: 14px;
    background: linear-gradient(135deg, var(--primary), var(--primary-dark));
    color: white;
    border: none;
    border-radius: 40px;
    font-size: 16px;
    font-weight: 600;
    cursor: pointer;
}

/* Responsive */
@media (max-width: 768px) {
    .container {
        padding: 16px;
    }
    
    .header-nav {
        padding: 8px 16px;
        overflow-x: auto;
        flex-wrap: nowrap;
    }
    
    .header-nav a {
        white-space: nowrap;
        padding: 8px 16px;
    }
    
    .stats-grid {
        grid-template-columns: repeat(2, 1fr);
        gap: 12px;
    }
    
    .stat-card {
        padding: 16px;
    }
    
    .stat-card .stat-number {
        font-size: 28px;
    }
}
CSS

# =============================================
# 2. UPDATE HEADER.PHP with modern HTML structure
# =============================================

cat > admin/header.php << 'EOF'
<?php
// Get current page for active state
$current_page = basename(dirname($_SERVER['PHP_SELF']));
if ($current_page == 'admin' || $current_page == '') {
    $current_page = 'dashboard';
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Puppet Museum Admin</title>
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;500;600;700;800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="/admin/css/admin.css">
</head>
<body>
    <div class="admin-header">
        <div class="header-top">
            <div class="logo">
                <div class="logo-icon">🎭</div>
                <div class="logo-text">Puppet <span>Museum</span></div>
            </div>
            <div class="user-info">
                <div class="user-badge">
                    <div class="user-avatar">
                        <?php 
                        $initial = substr($user_fullname ?? $_SESSION['user_fullname'] ?? 'U', 0, 1);
                        echo htmlspecialchars($initial);
                        ?>
                    </div>
                    <div>
                        <div class="user-name"><?php echo htmlspecialchars($user_fullname ?? $_SESSION['user_fullname'] ?? 'User'); ?></div>
                        <div class="user-role"><?php echo htmlspecialchars($user_role ?? $_SESSION['user_role'] ?? 'role'); ?></div>
                    </div>
                </div>
                <a href="/admin/logout.php" class="logout-btn">🚪 Logout</a>
            </div>
        </div>
        <div class="header-nav">
            <a href="/admin/" class="<?php echo $current_page == 'dashboard' ? 'active' : ''; ?>">📊 Dashboard</a>
            <a href="/admin/countries/" class="<?php echo $current_page == 'countries' ? 'active' : ''; ?>">🌍 Countries</a>
            <a href="/admin/districts/" class="<?php echo $current_page == 'districts' ? 'active' : ''; ?>">🗺️ Districts</a>
            <a href="/admin/characters/" class="<?php echo $current_page == 'characters' ? 'active' : ''; ?>">🎭 Characters</a>
            <a href="/admin/collections/" class="<?php echo $current_page == 'collections' ? 'active' : ''; ?>">📦 Collections</a>
            <a href="/admin/images/" class="<?php echo $current_page == 'images' ? 'active' : ''; ?>">🖼️ Images</a>
            <?php if (isset($_SESSION['user_role']) && $_SESSION['user_role'] == 'admin'): ?>
            <a href="/admin/users/" class="<?php echo $current_page == 'users' ? 'active' : ''; ?>">👥 Users</a>
            <?php endif; ?>
        </div>
    </div>
    <div class="container">
EOF

# =============================================
# 3. SIMPLIFY DASHBOARD - Remove Quick Actions
# =============================================

cat > admin/index.php << 'EOF'
<?php
require_once 'session_check.php';
require_once '../includes/functions.php';

$db = getDB();

$countryCount = $db->query("SELECT COUNT(*) as c FROM countries")->fetch_assoc()['c'];
$districtCount = $db->query("SELECT COUNT(*) as c FROM districts")->fetch_assoc()['c'];
$characterCount = $db->query("SELECT COUNT(*) as c FROM characters")->fetch_assoc()['c'];
$collectionCount = $db->query("SELECT COUNT(*) as c FROM collections")->fetch_assoc()['c'];
$imageCount = $db->query("SELECT COUNT(*) as c FROM images")->fetch_assoc()['c'];

include 'header.php';
?>

<div>
    <h1 class="page-title">Dashboard</h1>
    <p style="margin-bottom: 32px; color: var(--gray);">Welcome back, <?php echo htmlspecialchars($user_fullname); ?>!</p>
    
    <div class="stats-grid">
        <div class="stat-card">
            <div class="stat-number"><?php echo $countryCount; ?></div>
            <div class="stat-label">Countries</div>
        </div>
        <div class="stat-card">
            <div class="stat-number"><?php echo $districtCount; ?></div>
            <div class="stat-label">Districts</div>
        </div>
        <div class="stat-card">
            <div class="stat-number"><?php echo $characterCount; ?></div>
            <div class="stat-label">Characters</div>
        </div>
        <div class="stat-card">
            <div class="stat-number"><?php echo $collectionCount; ?></div>
            <div class="stat-label">Collections</div>
        </div>
        <div class="stat-card">
            <div class="stat-number"><?php echo $imageCount; ?></div>
            <div class="stat-label">Images</div>
        </div>
    </div>
</div>

<?php include 'footer.php'; ?>
EOF

# =============================================
# 4. FIX SESSION CHECK to handle current_page
# =============================================

cat > admin/session_check.php << 'EOF'
<?php
require_once dirname(__DIR__) . '/includes/config.php';
require_once dirname(__DIR__) . '/includes/functions.php';

if (!isLoggedIn()) {
    header('Location: login.php');
    exit();
}

$user_id = $_SESSION['user_id'];
$user_role = $_SESSION['user_role'];
$user_fullname = $_SESSION['user_fullname'];
?>
EOF

echo -e "\n${GREEN}========================================${NC}"
echo -e "${GREEN}HEADER IMPROVED & DASHBOARD SIMPLIFIED!${NC}"
echo -e "${GREEN}========================================${NC}"
echo -e "\n${YELLOW}Refresh your browser (Ctrl+Shift+R) to see:${NC}"
echo -e "  • Modern gradient header"
echo -e "  • Pill-style navigation menu"
echo -e "  • User avatar badge"
echo -e "  • Clean dashboard with only stats (no quick actions)"