{% extends 'admin_panel/base.html' %}
{% load static %}

{% block page_title %}Laporan Wisata{% endblock %}

{% block extra_css %}
<style>

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

.content-wrapper {
    padding: 2rem;
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    min-height: 100vh;
    font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
}

.reports-header {
    background: rgba(255, 255, 255, 0.95);
    backdrop-filter: blur(10px);
    border-radius: 20px;
    padding: 2rem;
    margin-bottom: 2rem;
    box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);
}

.reports-title {
    font-size: 2.5rem;
    font-weight: 800;
    color: #1a202c;
    margin-bottom: 0.5rem;
    display: flex;
    align-items: center;
    gap: 1rem;
}

.reports-title i {
    color: #667eea;
}

.reports-subtitle {
    font-size: 1rem;
    color: #718096;
    font-weight: 500;
}

.reports-export-btn {
    background: linear-gradient(135deg, #10b981 0%, #059669 100%);
    color: white;
    border: none;
    padding: 0.875rem 1.75rem;
    border-radius: 12px;
    font-weight: 600;
    cursor: pointer;
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    box-shadow: 0 4px 16px rgba(16, 185, 129, 0.3);
    transition: all 0.3s ease;
    font-size: 1rem;
}

.reports-export-btn:hover {
    transform: translateY(-3px);
    box-shadow: 0 8px 24px rgba(16, 185, 129, 0.4);
}

.stats-grid {
    display: grid;
    grid-template-columns: repeat(4, 1fr);
    gap: 1.5rem;
    margin-bottom: 2rem;
}

.stat-card {
    background: rgba(255, 255, 255, 0.95);
    backdrop-filter: blur(10px);
    border-radius: 20px;
    padding: 2rem;
    position: relative;
    overflow: hidden;
    transition: all 0.4s cubic-bezier(0.4, 0, 0.2, 1);
    box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);
}

.stat-card::before {
    content: '';
    position: absolute;
    top: 0;
    left: 0;
    width: 100%;
    height: 5px;
    background: linear-gradient(90deg, var(--accent-color) 0%, var(--accent-light) 100%);
}

.stat-card:hover {
    transform: translateY(-10px) scale(1.03);
    box-shadow: 0 16px 48px rgba(0, 0, 0, 0.15);
}

.stat-card.blue { --accent-color: #3b82f6; --accent-light: #60a5fa; }
.stat-card.green { --accent-color: #10b981; --accent-light: #34d399; }
.stat-card.orange { --accent-color: #f59e0b; --accent-light: #fbbf24; }
.stat-card.red { --accent-color: #ef4444; --accent-light: #f87171; }

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

.stat-info h3 {
    font-size: 0.875rem;
    text-transform: uppercase;
    letter-spacing: 1px;
    color: #64748b;
    font-weight: 700;
    margin-bottom: 0.75rem;
}

.stat-info .value {
    font-size: 2.75rem;
    font-weight: 900;
    color: #1a202c;
    line-height: 1;
}

.stat-icon {
    width: 80px;
    height: 80px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 2.5rem;
    background: linear-gradient(135deg, var(--accent-color) 0%, var(--accent-light) 100%);
    color: white;
    box-shadow: 0 8px 24px rgba(0, 0, 0, 0.15);
    transition: all 0.3s ease;
}

.stat-card:hover .stat-icon {
    transform: rotate(15deg) scale(1.1);
}

.cards-grid {
    display: grid;
    grid-template-columns: 2fr 1fr;
    gap: 1.5rem;
    margin-bottom: 2rem;
}

.main-card {
    background: rgba(255, 255, 255, 0.95);
    backdrop-filter: blur(10px);
    border-radius: 20px;
    overflow: hidden;
    box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);
    transition: all 0.3s ease;
}

.main-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 12px 40px rgba(0, 0, 0, 0.15);
}

.card-header {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    padding: 1.5rem 2rem;
    color: white;
}

.card-header h2 {
    font-size: 1.375rem;
    font-weight: 700;
    display: flex;
    align-items: center;
    gap: 0.75rem;
}

.card-body {
    padding: 2rem;
}

.table-responsive {
    overflow-x: auto;
}

table {
    width: 100%;
    border-collapse: separate;
    border-spacing: 0;
}

thead th {
    background: linear-gradient(135deg, #f8fafc 0%, #e2e8f0 100%);
    padding: 1rem;
    font-weight: 700;
    color: #1e293b;
    text-align: left;
    font-size: 0.875rem;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    position: sticky;
    top: 0;
}

tbody td {
    padding: 1rem;
    color: #475569;
    border-bottom: 1px solid #e2e8f0;
    font-size: 0.9375rem;
}

tbody tr {
    transition: all 0.2s ease;
}

tbody tr:hover {
    background: #f8fafc;
    transform: scale(1.01);
}

.badge {
    display: inline-block;
    padding: 0.375rem 0.875rem;
    border-radius: 8px;
    font-size: 0.8125rem;
    font-weight: 600;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

.badge-warning { background: linear-gradient(135deg, #fbbf24 0%, #f59e0b 100%); color: #78350f; }
.badge-secondary { background: linear-gradient(135deg, #94a3b8 0%, #64748b 100%); color: white; }
.badge-info { background: linear-gradient(135deg, #38bdf8 0%, #0284c7 100%); color: white; }
.badge-light { background: #e2e8f0; color: #475569; }
.badge-primary { background: linear-gradient(135deg, #3b82f6 0%, #2563eb 100%); color: white; }
.badge-success { background: linear-gradient(135deg, #10b981 0%, #059669 100%); color: white; }

.review-item {
    display: flex;
    gap: 1rem;
    padding: 1.25rem;
    border-radius: 12px;
    background: linear-gradient(135deg, #ffffff 0%, #f8fafc 100%);
    margin-bottom: 1rem;
    transition: all 0.3s ease;
    border: 1px solid #e2e8f0;
}

.review-item:hover {
    transform: translateX(8px);
    box-shadow: 0 4px 16px rgba(0, 0, 0, 0.08);
    border-color: #667eea;
}

.review-avatar {
    width: 56px;
    height: 56px;
    border-radius: 50%;
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    display: flex;
    align-items: center;
    justify-content: center;
    color: white;
    font-size: 1.5rem;
    flex-shrink: 0;
    box-shadow: 0 4px 12px rgba(102, 126, 234, 0.4);
}

.review-content {
    flex: 1;
}

.review-name {
    font-weight: 700;
    color: #1e293b;
    margin-bottom: 0.375rem;
    font-size: 1rem;
}

.review-text {
    color: #64748b;
    font-size: 0.875rem;
    margin-bottom: 0.625rem;
    line-height: 1.6;
}

.review-meta {
    display: flex;
    justify-content: space-between;
    align-items: center;
}

.review-stars {
    color: #fbbf24;
    display: flex;
    gap: 3px;
    font-size: 0.875rem;
}

.review-date {
    color: #94a3b8;
    font-size: 0.8125rem;
    font-weight: 500;
}

.empty-state {
    text-align: center;
    padding: 3rem 1rem;
    color: #94a3b8;
    font-size: 1rem;
}

.export-grid {
    display: grid;
    grid-template-columns: repeat(3, 1fr);
    gap: 1.5rem;
}

.export-card {
    background: rgba(255, 255, 255, 0.95);
    backdrop-filter: blur(10px);
    border-radius: 20px;
    padding: 2.5rem;
    text-align: center;
    transition: all 0.4s cubic-bezier(0.4, 0, 0.2, 1);
    position: relative;
    overflow: hidden;
    box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);
}

.export-card::before {
    content: '';
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    height: 6px;
    background: linear-gradient(90deg, var(--export-color) 0%, var(--export-light) 100%);
    transform: scaleX(0);
    transition: transform 0.4s ease;
}

.export-card:hover::before {
    transform: scaleX(1);
}

.export-card:hover {
    transform: translateY(-12px) scale(1.05);
    box-shadow: 0 20px 48px rgba(0, 0, 0, 0.15);
}

.export-card.excel { --export-color: #10b981; --export-light: #34d399; }
.export-card.pdf { --export-color: #ef4444; --export-light: #f87171; }
.export-card.csv { --export-color: #f59e0b; --export-light: #fbbf24; }

.export-icon {
    font-size: 4rem;
    margin-bottom: 1.25rem;
    transition: all 0.3s ease;
}

.export-card:hover .export-icon {
    transform: scale(1.2) rotate(10deg);
}

.export-card.excel .export-icon { color: #10b981; }
.export-card.pdf .export-icon { color: #ef4444; }
.export-card.csv .export-icon { color: #f59e0b; }

.export-title {
    font-size: 1.5rem;
    font-weight: 800;
    color: #1a202c;
    margin-bottom: 0.75rem;
}

.export-desc {
    color: #64748b;
    font-size: 0.9375rem;
    margin-bottom: 1.5rem;
    line-height: 1.6;
}

.export-btn {
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    padding: 0.875rem 1.75rem;
    border-radius: 12px;
    font-weight: 600;
    text-decoration: none;
    transition: all 0.3s ease;
    border: none;
    cursor: pointer;
    font-size: 0.9375rem;
}

.export-card.excel .export-btn {
    background: linear-gradient(135deg, #10b981 0%, #059669 100%);
    color: white;
    box-shadow: 0 4px 16px rgba(16, 185, 129, 0.3);
}

.export-card.pdf .export-btn {
    background: linear-gradient(135deg, #ef4444 0%, #dc2626 100%);
    color: white;
    box-shadow: 0 4px 16px rgba(239, 68, 68, 0.3);
}

.export-card.csv .export-btn {
    background: linear-gradient(135deg, #f59e0b 0%, #d97706 100%);
    color: #78350f;
    box-shadow: 0 4px 16px rgba(245, 158, 11, 0.3);
}

.export-btn:hover {
    transform: translateY(-3px);
    box-shadow: 0 8px 24px rgba(0, 0, 0, 0.2);
}

@media (max-width: 768px) {
    .content-wrapper { padding: 1rem; }
    .reports-title { font-size: 1.75rem; }
    .stats-grid { grid-template-columns: repeat(2, 1fr); gap: 1rem; }
    .stat-card { padding: 1.5rem; }
    .stat-info .value { font-size: 2rem; }
    .stat-icon { width: 60px; height: 60px; font-size: 1.75rem; }
    .cards-grid { grid-template-columns: 1fr; gap: 1rem; }
    .export-grid { grid-template-columns: 1fr; gap: 1rem; }
    .card-body { padding: 1.25rem; }
}
</style>
{% endblock %}

{% block content %}
<div class="content-wrapper">

    <a href="{% url 'admin_panel:tourism_dashboard' %}" style="display: inline-flex; align-items: center; gap: 0.5rem; padding: 0.75rem 1.5rem; background: rgba(255, 255, 255, 0.95); border-radius: 12px; color: #1a202c; text-decoration: none; font-weight: 600; margin-bottom: 1.5rem; box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1); transition: all 0.3s ease;" onmouseover="this.style.transform='translateX(-5px)'; this.style.boxShadow='0 6px 16px rgba(0, 0, 0, 0.15)';" onmouseout="this.style.transform=''; this.style.boxShadow='0 4px 12px rgba(0, 0, 0, 0.1)';">
        <i class="fas fa-arrow-left"></i>
        Kembali ke Dashboard
    </a>

    <div class="reports-header" style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; gap: 1.5rem;">
        <div>
            <h1 class="reports-title">
                <i class="fas fa-chart-bar"></i>
                Laporan Wisata
            </h1>
            <p class="reports-subtitle">Statistik dan analisis data wisata desa</p>
        </div>
        <button class="reports-export-btn" onclick="exportReport()">
            <i class="fas fa-download"></i> Export Laporan
        </button>
    </div>

    <div class="stats-grid">
        <div class="stat-card blue">
            <div class="stat-content">
                <div class="stat-info">
                    <h3>Total Lokasi</h3>
                    <div class="value">{{ total_locations }}</div>
                </div>
                <div class="stat-icon">
                    <i class="fas fa-map-marker-alt"></i>
                </div>
            </div>
        </div>

        <div class="stat-card green">
            <div class="stat-content">
                <div class="stat-info">
                    <h3>Lokasi Aktif</h3>
                    <div class="value">{{ active_locations }}</div>
                </div>
                <div class="stat-icon">
                    <i class="fas fa-check-circle"></i>
                </div>
            </div>
        </div>

        <div class="stat-card orange">
            <div class="stat-content">
                <div class="stat-info">
                    <h3>Total Review</h3>
                    <div class="value">{{ total_reviews }}</div>
                </div>
                <div class="stat-icon">
                    <i class="fas fa-star"></i>
                </div>
            </div>
        </div>

        <div class="stat-card red">
            <div class="stat-content">
                <div class="stat-info">
                    <h3>Rating Rata-rata</h3>
                    <div class="value">{{ average_rating|floatformat:1 }}</div>
                </div>
                <div class="stat-icon">
                    <i class="fas fa-thumbs-up"></i>
                </div>
            </div>
        </div>
    </div>

    <div class="cards-grid">
        <div class="main-card">
            <div class="card-header">
                <h2>
                    <i class="fas fa-trophy"></i>
                    Lokasi Terpopuler
                </h2>
            </div>
            <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>Rank</th>
                                    <th>Nama Lokasi</th>
                                    <th>Kategori</th>
                                    <th>Rating</th>
                                    <th>Review</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                {% for location in top_locations %}
                                    <tr>
                                        <td>
                                            <span class="badge badge-{% if forloop.counter == 1 %}warning{% elif forloop.counter == 2 %}secondary{% elif forloop.counter == 3 %}info{% else %}light{% endif %}">
                                                #{{ forloop.counter }}
                                            </span>
                                        </td>
                                        <td>{{ location.title }}</td>
                                        <td>
                                            {% if location.category %}
                                                <span class="badge badge-primary">{{ location.category.name }}</span>
                                            {% else %}
                                                <span class="badge badge-secondary">Tanpa Kategori</span>
                                            {% endif %}
                                        </td>
                                        <td>
                                            <div class="d-flex align-items-center">
                                                <span class="mr-1">{{ location.avg_rating|floatformat:1 }}</span>
                                                <div class="text-warning">
                                                    {% for i in "12345" %}
                                                        {% if forloop.counter <= location.avg_rating %}
                                                            <i class="fas fa-star"></i>
                                                        {% else %}
                                                            <i class="far fa-star"></i>
                                                        {% endif %}
                                                    {% endfor %}
                                                </div>
                                            </div>
                                        </td>
                                        <td>{{ location.review_count }}</td>
                                        <td>
                                            {% if location.is_active %}
                                                <span class="badge badge-success">Aktif</span>
                                            {% else %}
                                                <span class="badge badge-secondary">Tidak Aktif</span>
                                            {% endif %}
                                        </td>
                                    </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="main-card">
            <div class="card-header">
                <h2>
                    <i class="fas fa-comments"></i>
                    Review Terbaru
                </h2>
            </div>
            <div class="card-body">
                {% for review in recent_reviews %}
                    <div class="review-item">
                        <div class="review-avatar">
                            <i class="fas fa-user"></i>
                        </div>
                        <div class="review-content">
                            <div class="review-name">
                                {% if review.user %}
                                    {{ review.user.get_full_name|default:review.user.username }}
                                {% else %}
                                    Anonim
                                {% endif %}
                            </div>
                            <p class="review-text">{{ review.comment|truncatechars:50 }}</p>
                            <div class="review-meta">
                                <div class="review-stars">
                                    {% for i in "12345" %}
                                        {% if forloop.counter <= review.rating %}
                                            <i class="fas fa-star"></i>
                                        {% else %}
                                            <i class="far fa-star"></i>
                                        {% endif %}
                                    {% endfor %}
                                </div>
                                <span class="review-date">{{ review.created_at|date:"d M Y" }}</span>
                            </div>
                        </div>
                    </div>
                {% empty %}
                    <div class="empty-state">Belum ada review</div>
                {% endfor %}
            </div>
        </div>
    </div>

    <div class="main-card">
        <div class="card-header">
            <h2>
                <i class="fas fa-download"></i>
                Export Laporan
            </h2>
        </div>
        <div class="card-body">
            <div class="export-grid">
                <div class="export-card excel">
                    <i class="fas fa-file-excel export-icon"></i>
                    <h3 class="export-title">Excel</h3>
                    <p class="export-desc">Export data wisata ke format Excel untuk analisis lebih lanjut</p>
                    <a href="{% url 'admin_panel:tourism_export_data' %}?format=excel" class="export-btn">
                        <i class="fas fa-download"></i> Download Excel
                    </a>
                </div>

                <div class="export-card pdf">
                    <i class="fas fa-file-pdf export-icon"></i>
                    <h3 class="export-title">PDF</h3>
                    <p class="export-desc">Export laporan lengkap ke format PDF untuk dokumentasi</p>
                    <a href="{% url 'admin_panel:tourism_export_data' %}?format=pdf" class="export-btn">
                        <i class="fas fa-download"></i> Download PDF
                    </a>
                </div>

                <div class="export-card csv">
                    <i class="fas fa-file-csv export-icon"></i>
                    <h3 class="export-title">CSV</h3>
                    <p class="export-desc">Export data mentah ke format CSV untuk import ke sistem lain</p>
                    <a href="{% url 'admin_panel:tourism_export_data' %}?format=csv" class="export-btn">
                        <i class="fas fa-download"></i> Download CSV
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>
{% endblock %}

{% block extra_js %}
<script>function exportReport() {
    window.open('{% url "admin_panel:tourism_export_data" %}?format=excel', '_blank');
}
</script>
{% endblock %}