{% extends "fatanalysis/base.html" %}
{% load i18n %}

{% block fatanalysis_content %}
<div class="d-flex flex-wrap justify-content-between align-items-center mb-3 pb-2 border-bottom">
    <div>
        <h2 class="h4 mb-0 fw-bold">{% trans "Fleet Activity Tracking" %}</h2>
        <small class="text-muted">{% trans "Corporation fleet participation analysis and longitudinal metrics" %}</small>
    </div>
    <div class="d-flex gap-2 mt-2 mt-md-0">
        <a href="{% url 'fatanalysis:period_list' %}" class="btn btn-outline-light btn-sm">
            <i class="fas fa-calendar-alt me-1"></i> {% trans "Recorded Periods" %}
        </a>
        {% if perms.fatanalysis.manage_fatanalysis %}
            <a href="{% url 'fatanalysis:sync_management' %}" class="btn btn-primary btn-sm">
                <i class="fas fa-sync-alt me-1"></i> {% trans "Sync & Ingestion" %}
            </a>
        {% endif %}
    </div>
</div>

<!-- Time Window Filter Navigation -->
<div class="card shadow-sm mb-4">
    <div class="card-body py-2">
        <div class="d-flex flex-wrap align-items-center justify-content-between gap-2">
            <span class="text-light small fw-bold text-uppercase opacity-75"><i class="fas fa-filter me-1"></i> {% trans "Time Window:" %}</span>
            <div class="btn-group btn-group-sm flex-wrap" role="group" aria-label="Time Window Selector">
                <a href="?window=30d" class="btn {% if window == '30d' %}btn-primary{% else %}btn-outline-light{% endif %}">
                    {% trans "30 Days (Latest)" %}
                </a>
                <a href="?window=90d" class="btn {% if window == '90d' %}btn-primary{% else %}btn-outline-light{% endif %}">
                    {% trans "90 Days" %}
                </a>
                <a href="?window=120d" class="btn {% if window == '120d' %}btn-primary{% else %}btn-outline-light{% endif %}">
                    {% trans "120 Days" %}
                </a>
                <a href="?window=ytd" class="btn {% if window == 'ytd' %}btn-primary{% else %}btn-outline-light{% endif %}">
                    {% trans "YTD" %}
                </a>
                {% for y in available_years %}
                    <a href="?window=year_{{ y }}" class="btn {% if window == 'year_'|add:y|stringformat:'s' %}btn-primary{% else %}btn-outline-light{% endif %}">
                        {{ y }}
                    </a>
                {% endfor %}
                <a href="?window=all" class="btn {% if window == 'all' %}btn-primary{% else %}btn-outline-light{% endif %}">
                    {% trans "All Time" %}
                </a>
            </div>
            <div class="text-muted small">
                {% if periods %}
                    <span class="badge bg-secondary">{{ periods|length }} {% trans "monthly periods selected" %}</span>
                {% else %}
                    <span class="badge bg-warning text-dark">{% trans "No periods recorded" %}</span>
                {% endif %}
            </div>
        </div>
    </div>
</div>

<!-- KPI Stat Cards -->
<div class="row g-3 mb-4">
    <div class="col-6 col-md-3">
        <div class="card fat-stat-card h-100 p-3">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <div class="text-muted small text-uppercase fw-semibold">{% trans "Total FATs" %}</div>
                    <div class="fat-stat-number text-primary mt-1">{{ total_fats|default:0 }}</div>
                </div>
                <div class="text-primary opacity-50"><i class="fas fa-rocket fa-2x"></i></div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="card fat-stat-card h-100 p-3">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <div class="text-muted small text-uppercase fw-semibold">{% trans "Active Pilots" %}</div>
                    <div class="fat-stat-number text-success mt-1">{{ agg.active_pilots_count|default:0 }}</div>
                    <div class="text-muted small">{% trans "Mains with at least one FAT" %}</div>
                </div>
                <div class="text-success opacity-50"><i class="fas fa-user-check fa-2x"></i></div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="card fat-stat-card h-100 p-3">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <div class="text-muted small text-uppercase fw-semibold">{% trans "Corp Members" %}</div>
                    <div class="fat-stat-number text-info mt-1">{{ agg.member_count|default:0 }}</div>
                    <div class="text-muted small">{% trans "Mains in Auth, alts not counted" %}</div>
                </div>
                <div class="text-info opacity-50"><i class="fas fa-users fa-2x"></i></div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-3">
        <div class="card fat-stat-card h-100 p-3">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <div class="text-muted small text-uppercase fw-semibold">{% trans "Active Participation" %}</div>
                    <div class="fat-stat-number text-warning mt-1">
                        {% if agg.participation_pct is not None %}{{ agg.participation_pct }}%{% else %}&ndash;{% endif %}
                    </div>
                    <div class="text-muted small">
                        {% blocktrans with active=agg.active_member_count members=agg.member_count %}{{ active }} of {{ members }} members{% endblocktrans %}
                    </div>
                </div>
                <div class="text-warning opacity-50"><i class="fas fa-percentage fa-2x"></i></div>
            </div>
        </div>
    </div>
</div>

<!-- Corp averages for the selected window -->
<div class="row g-3 mb-4">
    <div class="col-12 col-md-4">
        <div class="card fat-stat-card h-100 p-3">
            <div class="text-muted small text-uppercase fw-semibold">{% trans "Avg FATs / Month" %}</div>
            <div class="fat-stat-number text-primary mt-1">{{ agg.avg_fats_per_month|default_if_none:"–" }}</div>
            <div class="text-muted small">{% trans "Whole corp, per month in this window" %}</div>
        </div>
    </div>
    <div class="col-12 col-md-4">
        <div class="card fat-stat-card h-100 p-3">
            <div class="text-muted small text-uppercase fw-semibold">{% trans "Avg per Active Pilot" %}</div>
            <div class="fat-stat-number text-success mt-1">{{ agg.avg_fats_per_active_pilot|default_if_none:"–" }}</div>
            <div class="text-muted small">{% trans "FATs per month, pilots who flew" %}</div>
        </div>
    </div>
    <div class="col-12 col-md-4">
        <div class="card fat-stat-card h-100 p-3">
            <div class="text-muted small text-uppercase fw-semibold">{% trans "Avg per Member" %}</div>
            <div class="fat-stat-number text-info mt-1">{{ agg.avg_fats_per_member|default_if_none:"–" }}</div>
            <div class="text-muted small">{% trans "FATs per month, all members" %}</div>
        </div>
    </div>
</div>

<!-- Visualizations Row -->
<div class="row g-4 mb-4">
    <div class="col-lg-8">
        <div class="card shadow-sm h-100">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span class="fw-bold"><i class="fas fa-chart-bar me-1 text-primary"></i> {% trans "Fleet Activity Progression Over Time" %}</span>
                <span class="badge bg-secondary">{{ periods|length }} {% trans "Periods" %}</span>
            </div>
            <div class="card-body">
                {% if periods %}
                    <div style="position: relative; height: 260px;">
                        <canvas id="trendChart"></canvas>
                    </div>
                {% else %}
                    <div class="text-center py-5 text-muted">
                        <i class="fas fa-info-circle fa-2x mb-2"></i>
                        <p>{% trans "No period data available for this time window." %}</p>
                    </div>
                {% endif %}
            </div>
        </div>
    </div>
    <div class="col-lg-4">
        <div class="card shadow-sm h-100">
            <div class="card-header">
                <span class="fw-bold"><i class="fas fa-rocket me-1 text-info"></i> {% trans "Ship Types Breakdown" %}</span>
            </div>
            <div class="card-body">
                {% if ship_type_distribution or fat_type_distribution %}
                    <div style="position: relative; height: 260px;">
                        <canvas id="typeChart"></canvas>
                    </div>
                {% else %}
                    <div class="text-center py-5 text-muted">
                        <i class="fas fa-info-circle fa-2x mb-2"></i>
                        <p>{% trans "No ship type breakdown available." %}</p>
                    </div>
                {% endif %}
            </div>
        </div>
    </div>
</div>

<!-- Activity Distribution Row: FATs by Time & FATs per Day -->
<div class="row g-4 mb-4">
    <div class="col-lg-6">
        <div class="card shadow-sm h-100">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span class="fw-bold"><i class="fas fa-clock me-1 text-warning"></i> {% trans "FATs by Time" %}</span>
                <span class="badge bg-secondary">{% trans "EVE Time (UTC)" %}</span>
            </div>
            <div class="card-body">
                {% if has_time_data %}
                    <div style="position: relative; height: 260px;">
                        <canvas id="timeChart"></canvas>
                    </div>
                {% else %}
                    <div class="text-center py-5 text-muted">
                        <i class="fas fa-clock fa-2x mb-2 opacity-50"></i>
                        <p class="mb-0">{% trans "No hourly time distribution data available for this time window." %}</p>
                    </div>
                {% endif %}
            </div>
        </div>
    </div>
    <div class="col-lg-6">
        <div class="card shadow-sm h-100">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span class="fw-bold"><i class="fas fa-calendar-day me-1 text-success"></i> {% trans "FATs per Day" %}</span>
                <span class="badge bg-secondary">{% trans "Weekday" %}</span>
            </div>
            <div class="card-body">
                {% if has_weekday_data %}
                    <div style="position: relative; height: 260px;">
                        <canvas id="weekdayChart"></canvas>
                    </div>
                {% else %}
                    <div class="text-center py-5 text-muted">
                        <i class="fas fa-calendar-day fa-2x mb-2 opacity-50"></i>
                        <p class="mb-0">{% trans "No weekday distribution data available for this time window." %}</p>
                    </div>
                {% endif %}
            </div>
        </div>
    </div>
</div>

<!-- Pilots Breakdown Table -->
<div class="card shadow-sm mb-4">
    <div class="card-header d-flex justify-content-between align-items-center">
        <span class="fw-bold"><i class="fas fa-table me-1 text-primary"></i> {% trans "Pilot Participation Matrix" %}</span>
        <span class="badge bg-primary">{{ pilots|length }} {% trans "Pilots" %}</span>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table id="table-pilots" class="table table-striped table-hover align-middle w-100">
                <thead>
                    <tr>
                        <th>{% trans "Pilot Name" %}</th>
                        <th>{% trans "Main Character" %}</th>
                        <th class="text-center">{% trans "Type" %}</th>
                        <th class="text-center">{% trans "Total FATs" %}</th>
                        <th class="text-center">{% trans "Avg / Month" %}</th>
                        {% for period in periods %}
                            <th class="text-center" title="{{ period.label }}">{{ period.year }}-{{ period.month|stringformat:"02d" }}</th>
                        {% endfor %}
                        {% for header in dynamic_headers %}
                            <th class="text-center">{{ header }}</th>
                        {% endfor %}
                    </tr>
                </thead>
                <tbody>
                    {% for pilot in pilots %}
                        <tr>
                            <td>
                                <a href="{% url 'fatanalysis:player_detail' character_name=pilot.character_name %}" class="fw-bold text-decoration-none">
                                    {{ pilot.character_name }}
                                </a>
                            </td>
                            <td>{{ pilot.main_character_name|default:"-" }}</td>
                            <td class="text-center">
                                {% if pilot.is_main %}
                                    <span class="badge bg-success">{% trans "Main" %}</span>
                                {% else %}
                                    <span class="badge bg-secondary">{% trans "Alt" %}</span>
                                {% endif %}
                            </td>
                            <td class="text-center">
                                {% if pilot.total_fats > 0 %}
                                    <span class="badge bg-primary fs-6">{{ pilot.total_fats }}</span>
                                {% else %}
                                    <span class="text-muted">0</span>
                                {% endif %}
                            </td>
                            <td class="text-center text-muted small">{{ pilot.avg_fats_per_month }}</td>
                            {% for val in pilot.period_values %}
                                <td class="text-center">
                                    {% if val > 0 %}
                                        <span class="badge bg-light text-dark border">{{ val }}</span>
                                    {% else %}
                                        <span class="text-muted opacity-50">-</span>
                                    {% endif %}
                                </td>
                            {% endfor %}
                            {% for val in pilot.dynamic_values %}
                                <td class="text-center">
                                    {% if val > 0 %}
                                        {{ val }}
                                    {% else %}
                                        <span class="text-muted opacity-50">-</span>
                                    {% endif %}
                                </td>
                            {% endfor %}
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
    </div>
</div>
{% endblock %}

{% block extra_javascript %}
    {{ block.super }}
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script>
        $(document).ready(function() {
            // Initialize DataTables
            $('#table-pilots').DataTable({
                order: [[3, 'desc']],
                pageLength: 25,
                responsive: false,
                language: {
                    emptyTable: "{% trans 'No pilot FAT entries recorded for this time window.' %}",
                    zeroRecords: "{% trans 'No matching pilots found.' %}",
                    search: "_INPUT_",
                    searchPlaceholder: "{% trans 'Search pilots...' %}"
                }
            });

            // Trend Chart
            {% if periods %}
            const trendCtx = document.getElementById('trendChart');
            if (trendCtx) {
                new Chart(trendCtx.getContext('2d'), {
                    type: 'bar',
                    data: {
                        labels: {{ trend_labels|safe }},
                        datasets: [{
                            label: '{% trans "Total Fleet FATs" %}',
                            data: {{ trend_values|safe }},
                            backgroundColor: 'rgba(54, 162, 235, 0.45)',
                            borderColor: '#36A2EB',
                            borderWidth: 1.5,
                            borderRadius: 4
                        }]
                    },
                    options: {
                        responsive: true,
                        maintainAspectRatio: false,
                        scales: {
                            y: {
                                beginAtZero: true,
                                grid: { color: 'rgba(255, 255, 255, 0.08)' }
                            },
                            x: {
                                grid: { display: false }
                            }
                        },
                        plugins: {
                            legend: { display: false }
                        }
                    }
                });
            }
            {% endif %}

            // Doughnut Distribution Chart (Ship Types Breakdown)
            {% if ship_type_distribution or fat_type_distribution %}
            const typeCtx = document.getElementById('typeChart');
            if (typeCtx) {
                const typeData = {% if ship_type_distribution %}{{ ship_type_distribution|safe }}{% else %}{{ fat_type_distribution|safe }}{% endif %};
                const labels = Object.keys(typeData);
                const values = Object.values(typeData);
                const colors = [
                    '#36A2EB', '#4BC0C0', '#FF6384', '#FF9F40', '#9966FF',
                    '#FFCE56', '#20c997', '#8AC926', '#1982C4', '#6A4C93',
                    '#fd7e14', '#0dcaf0', '#6c757d'
                ];

                new Chart(typeCtx.getContext('2d'), {
                    type: 'doughnut',
                    data: {
                        labels: labels,
                        datasets: [{
                            data: values,
                            backgroundColor: colors.slice(0, labels.length),
                            borderWidth: 1
                        }]
                    },
                    options: {
                        responsive: true,
                        maintainAspectRatio: false,
                        plugins: {
                            legend: {
                                position: 'right',
                                labels: { boxWidth: 12, font: { size: 10 } }
                            }
                        }
                    }
                });
            }
            {% endif %}

            // FATs by Time (Hourly Line Chart)
            {% if has_time_data %}
            const timeCtx = document.getElementById('timeChart');
            if (timeCtx) {
                new Chart(timeCtx.getContext('2d'), {
                    type: 'line',
                    data: {
                        labels: {{ fats_by_time_labels|safe }},
                        datasets: [{
                            label: '{% trans "# of FATs" %}',
                            data: {{ fats_by_time_values|safe }},
                            backgroundColor: 'rgba(255, 193, 7, 0.25)',
                            borderColor: '#ffc107',
                            borderWidth: 2,
                            fill: true,
                            tension: 0.3,
                            pointRadius: 3,
                            pointBackgroundColor: '#ffc107'
                        }]
                    },
                    options: {
                        responsive: true,
                        maintainAspectRatio: false,
                        scales: {
                            y: {
                                beginAtZero: true,
                                grid: { color: 'rgba(255, 255, 255, 0.08)' }
                            },
                            x: {
                                grid: { color: 'rgba(255, 255, 255, 0.04)' },
                                ticks: { maxRotation: 45, minRotation: 0 }
                            }
                        },
                        plugins: {
                            legend: { display: false }
                        }
                    }
                });
            }
            {% endif %}

            // FATs per Day (Weekday Bar Chart)
            {% if has_weekday_data %}
            const weekdayCtx = document.getElementById('weekdayChart');
            if (weekdayCtx) {
                new Chart(weekdayCtx.getContext('2d'), {
                    type: 'bar',
                    data: {
                        labels: {{ fats_by_weekday_labels|safe }},
                        datasets: [{
                            label: '{% trans "# of FATs" %}',
                            data: {{ fats_by_weekday_values|safe }},
                            backgroundColor: 'rgba(25, 135, 84, 0.65)',
                            borderColor: '#198754',
                            borderWidth: 1.5,
                            borderRadius: 4
                        }]
                    },
                    options: {
                        responsive: true,
                        maintainAspectRatio: false,
                        scales: {
                            y: {
                                beginAtZero: true,
                                grid: { color: 'rgba(255, 255, 255, 0.08)' }
                            },
                            x: {
                                grid: { display: false }
                            }
                        },
                        plugins: {
                            legend: { display: false }
                        }
                    }
                });
            }
            {% endif %}
        });
    </script>
{% endblock %}