@extends('layouts.panel')

@section('title', 'Resumen Mensual')

@section('content')

    <div class="page-header d-flex align-items-center justify-content-between flex-wrap gap-3">
        <div class="page-header-title">
            <h1>Resumen Mensual</h1>
            <p class="page-header-subtitle">{{ $from->format('F Y') }}</p>
        </div>
        <a href="{{ route('monthly-summary.export', ['month' => $from->format('Y-m')]) }}" class="btn btn-success">
            <i class="bi bi-file-earmark-excel me-1"></i> Exportar a Excel
        </a>
    </div>

    <form method="GET" action="{{ route('monthly-summary.index') }}" class="row g-3 mb-4">
        <div class="col-md-3">
            <label class="form-label small">Mes</label>
            <input type="month" name="month" class="form-control" value="{{ $from->format('Y-m') }}">
        </div>
        <div class="col-md-3">
            <label class="form-label small">Cliente</label>
            <select name="client_id" class="form-select">
                <option value="">Todos los clientes</option>
                @foreach ($clients as $client)
                    <option value="{{ $client->id }}" {{ request('client_id') == $client->id ? 'selected' : '' }}>
                        {{ $client->business_name ?: $client->contact_name }}
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <label class="form-label small">Línea de servicio</label>
            <select name="service_line" class="form-select">
                <option value="">Todas las líneas</option>
                @foreach (\App\Models\Order::SERVICE_LINES as $value => $label)
                    <option value="{{ $value }}" {{ request('service_line') === $value ? 'selected' : '' }}>{{ $label }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3 d-flex align-items-end gap-2">
            <button type="submit" class="btn btn-outline-secondary w-100">Aplicar filtros</button>
            <a href="{{ route('monthly-summary.index') }}" class="btn btn-outline-secondary w-100">Limpiar</a>
        </div>
    </form>

    @if(request('client_id') || request('service_line'))
        <div class="alert alert-warning small">
            <i class="bi bi-info-circle me-1"></i>
            Los filtros de cliente/línea afectan solo lo que ves en pantalla. El botón "Exportar a Excel" descarga el mes completo, sin filtrar.
        </div>
    @endif

    <div class="row g-3 mb-4">
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <span class="text-muted small d-block">Total de pedidos</span>
                    <h3 class="mb-0">{{ $totalOrders }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <span class="text-muted small d-block">Total de kilos</span>
                    <h3 class="mb-0">{{ number_format($totalKilos, 2, ',', '.') }} kg</h3>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card">
                <div class="card-body">
                    <span class="text-muted small d-block">Total facturado</span>
                    <h3 class="mb-0">${{ number_format($totalRevenue, 0, ',', '.') }}</h3>
                </div>
            </div>
        </div>
    </div>

    <div class="row g-4">
        <div class="col-lg-6">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="card-title mb-0">Total por cliente</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead>
                                <tr>
                                    <th>Cliente</th>
                                    <th>Pedidos</th>
                                    <th>Kilos</th>
                                    <th>Total</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse ($byClient as $row)
                                    <tr>
                                        <td>{{ $row['name'] }}</td>
                                        <td>{{ $row['orders'] }}</td>
                                        <td>{{ number_format($row['kilos'], 2, ',', '.') }} kg</td>
                                        <td>${{ number_format($row['revenue'], 0, ',', '.') }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="4" class="text-center text-muted py-4">Sin datos para este periodo.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-6">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="card-title mb-0">Total por servicio</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead>
                                <tr>
                                    <th>Línea</th>
                                    <th>Pedidos</th>
                                    <th>Kilos</th>
                                    <th>Total</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse ($byService as $row)
                                    <tr>
                                        <td>{{ $row['name'] }}</td>
                                        <td>{{ $row['orders'] }}</td>
                                        <td>{{ number_format($row['kilos'], 2, ',', '.') }} kg</td>
                                        <td>${{ number_format($row['revenue'], 0, ',', '.') }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="4" class="text-center text-muted py-4">Sin datos para este periodo.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection