@extends('layouts.app')

@section('title', 'Finanzas del Club - CAT')

@section('content')
<div class="container py-5">
    <div class="row">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center mb-4">
                <h1 class="h3 mb-0">
                    <i class="fas fa-chart-line me-2"></i>
                    Finanzas del Club Atlético Torino
                </h1>
                <div class="d-flex gap-2">
                    <!-- Filtros -->
                    <select class="form-select" id="yearFilter" style="width: auto;">
                        @foreach($availableYears as $availableYear)
                            <option value="{{ $availableYear }}" {{ $availableYear == $year ? 'selected' : '' }}>
                                {{ $availableYear }}
                            </option>
                        @endforeach
                    </select>
                    <select class="form-select" id="monthFilter" style="width: auto;">
                        <option value="">Todos los meses</option>
                        @for($i = 1; $i <= 12; $i++)
                            <option value="{{ $i }}" {{ $i == $month ? 'selected' : '' }}>
                                {{ date('F', mktime(0, 0, 0, $i, 1)) }}
                            </option>
                        @endfor
                    </select>
                </div>
            </div>
        </div>
    </div>

    <!-- Estadísticas principales -->
    <div class="row mb-4">
        <div class="col-lg-3 col-md-6 mb-4">
            <div class="card border-left-success shadow h-100 py-2" style="background: linear-gradient(135deg, #28a745 0%, #20c997 100%); color: white;">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-light text-uppercase mb-1">
                                Total Ingresos
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-white">S/ {{ number_format($stats['total_income'], 2) }}</div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-arrow-up fa-2x text-light"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6 mb-4">
            <div class="card border-left-danger shadow h-100 py-2" style="background: linear-gradient(135deg, #dc3545 0%, #fd7e14 100%); color: white;">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-light text-uppercase mb-1">
                                Total Egresos
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-white">S/ {{ number_format($stats['total_expense'], 2) }}</div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-arrow-down fa-2x text-light"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6 mb-4">
            <div class="card border-left-info shadow h-100 py-2" style="background: linear-gradient(135deg, #17a2b8 0%, #6f42c1 100%); color: white;">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-light text-uppercase mb-1">
                                Resultado Neto
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-white {{ $stats['net_income'] >= 0 ? 'text-success' : 'text-danger' }}">
                                S/ {{ number_format($stats['net_income'], 2) }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-balance-scale fa-2x text-light"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6 mb-4">
            <div class="card border-left-warning shadow h-100 py-2" style="background: linear-gradient(135deg, #ffc107 0%, #fd7e14 100%); color: white;">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-light text-uppercase mb-1">
                                Donaciones {{ $year }}
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-white">S/ {{ number_format($donationsThisYear, 2) }}</div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-heart fa-2x text-light"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Gráficos y análisis -->
    <div class="row mb-4">
        <!-- Ingresos por categoría -->
        <div class="col-lg-6 mb-4">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-chart-pie me-2"></i>
                        Ingresos por Categoría
                    </h6>
                </div>
                <div class="card-body">
                    @if($stats['income_by_category']->count() > 0)
                        @foreach($stats['income_by_category'] as $category)
                            <div class="mb-3">
                                <div class="d-flex justify-content-between align-items-center">
                                    <span>{{ $category->category_label ?? ucfirst($category->category) }}</span>
                                    <strong class="text-success">S/ {{ number_format($category->total, 2) }}</strong>
                                </div>
                                <div class="progress" style="height: 8px;">
                                    <div class="progress-bar bg-success" style="width: {{ $stats['total_income'] > 0 ? ($category->total / $stats['total_income']) * 100 : 0 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <p class="text-muted text-center">No hay ingresos registrados para este período.</p>
                    @endif
                </div>
            </div>
        </div>

        <!-- Egresos por categoría -->
        <div class="col-lg-6 mb-4">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-chart-pie me-2"></i>
                        Egresos por Categoría
                    </h6>
                </div>
                <div class="card-body">
                    @if($stats['expense_by_category']->count() > 0)
                        @foreach($stats['expense_by_category'] as $category)
                            <div class="mb-3">
                                <div class="d-flex justify-content-between align-items-center">
                                    <span>{{ $category->category_label ?? ucfirst($category->category) }}</span>
                                    <strong class="text-danger">S/ {{ number_format($category->total, 2) }}</strong>
                                </div>
                                <div class="progress" style="height: 8px;">
                                    <div class="progress-bar bg-danger" style="width: {{ $stats['total_expense'] > 0 ? ($category->total / $stats['total_expense']) * 100 : 0 }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <p class="text-muted text-center">No hay egresos registrados para este período.</p>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Lista de transacciones -->
    <div class="row">
        <div class="col-12">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-list me-2"></i>
                        Transacciones Financieras
                    </h6>
                </div>
                <div class="card-body">
                    @if($finances->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover" width="100%" cellspacing="0">
                                <thead class="table-dark">
                                    <tr>
                                        <th>Fecha</th>
                                        <th>Tipo</th>
                                        <th>Categoría</th>
                                        <th>Descripción</th>
                                        <th>Monto</th>
                                        <th>Referencia</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($finances as $finance)
                                        <tr>
                                            <td>
                                                <small>{{ $finance->date->format('d/m/Y') }}</small>
                                            </td>
                                            <td>
                                                @if($finance->type === 'income')
                                                    <span class="badge bg-success">
                                                        <i class="fas fa-arrow-up me-1"></i>Ingreso
                                                    </span>
                                                @else
                                                    <span class="badge bg-danger">
                                                        <i class="fas fa-arrow-down me-1"></i>Egreso
                                                    </span>
                                                @endif
                                            </td>
                                            <td>
                                                <span class="badge bg-light text-dark">
                                                    {{ $finance->category_label }}
                                                </span>
                                            </td>
                                            <td>{{ $finance->description }}</td>
                                            <td>
                                                <strong class="{{ $finance->type === 'income' ? 'text-success' : 'text-danger' }}">
                                                    {{ $finance->formatted_amount }}
                                                </strong>
                                            </td>
                                            <td>
                                                @if($finance->reference)
                                                    <small class="text-muted">{{ $finance->reference }}</small>
                                                @else
                                                    <span class="text-muted">-</span>
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>

                        <!-- Pagination -->
                        <div class="mt-4">
                            <x-pagination :paginator="$finances" />
                        </div>
                    @else
                        <div class="text-center py-5">
                            <i class="fas fa-chart-line text-muted mb-3" style="font-size: 4rem;"></i>
                            <h4 class="text-muted">No hay transacciones registradas</h4>
                            <p class="text-muted">Las transacciones financieras aparecerán aquí una vez que se registren.</p>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Información adicional -->
    <div class="row mt-4">
        <div class="col-12">
            @if(isset($tableMissing) && $tableMissing)
                <div class="alert alert-warning">
                    <h5><i class="fas fa-exclamation-triangle me-2"></i>Base de Datos no Configurada</h5>
                    <p class="mb-3">
                        La tabla de finanzas del club aún no ha sido creada en la base de datos. 
                        Para activar esta funcionalidad, un administrador debe ejecutar la migración correspondiente.
                    </p>
                    <p class="mb-0">
                        <strong>Instrucciones para el administrador:</strong><br>
                        1. Ejecutar: <code>php artisan migrate</code><br>
                        2. Ejecutar: <code>php artisan db:seed --class=ClubFinanceSeeder</code><br>
                        O ejecutar el archivo SQL: <code>create_club_finances_table.sql</code>
                    </p>
                </div>
            @elseif(isset($error))
                <div class="alert alert-danger">
                    <h5><i class="fas fa-exclamation-circle me-2"></i>Error en la Base de Datos</h5>
                    <p class="mb-0">
                        <strong>Error:</strong> {{ $error }}
                    </p>
                </div>
            @else
                <div class="alert alert-info">
                    <h5><i class="fas fa-info-circle me-2"></i>Información sobre las Finanzas del Club</h5>
                    <p class="mb-0">
                        Esta sección muestra la transparencia financiera del Club Atlético Torino. 
                        Aquí puedes ver todos los ingresos y egresos registrados, incluyendo donaciones, 
                        gastos de mantenimiento, equipamiento y otros conceptos relacionados con la 
                        operación del club.
                    </p>
                </div>
            @endif
        </div>
    </div>
</div>

<script>
document.addEventListener('DOMContentLoaded', function() {
    const yearFilter = document.getElementById('yearFilter');
    const monthFilter = document.getElementById('monthFilter');
    
    function updateFilters() {
        const year = yearFilter.value;
        const month = monthFilter.value;
        
        const url = new URL(window.location);
        url.searchParams.set('year', year);
        if (month) {
            url.searchParams.set('month', month);
        } else {
            url.searchParams.delete('month');
        }
        
        window.location.href = url.toString();
    }
    
    yearFilter.addEventListener('change', updateFilters);
    monthFilter.addEventListener('change', updateFilters);
});
</script>
@endsection