@extends('layouts.app')

@section('title', 'Análisis de Rentabilidad')

@section('content')
<div class="container-fluid">
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <h2 class="mb-0">
                    <i class="fas fa-chart-pie me-2"></i>Análisis de Rentabilidad
                </h2>
                <div>
                    <a href="{{ route('admin.accounting.dashboard') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left me-2"></i>Volver
                    </a>
                    <a href="{{ route('admin.accounting.reports.profitability', array_merge(request()->all(), ['export' => 'excel'])) }}" class="btn btn-success">
                        <i class="fas fa-file-excel me-2"></i>Exportar Excel
                    </a>
                    <button onclick="window.print()" class="btn btn-primary">
                        <i class="fas fa-print me-2"></i>Imprimir
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Filtros -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-filter me-2"></i>Filtros
            </h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('admin.accounting.reports.profitability') }}" class="row g-3">
                <div class="col-md-4">
                    <label for="date_from" class="form-label">Fecha Desde</label>
                    <input type="date" name="date_from" id="date_from" class="form-control" value="{{ $dateFrom ?? '' }}">
                </div>
                <div class="col-md-4">
                    <label for="date_to" class="form-label">Fecha Hasta</label>
                    <input type="date" name="date_to" id="date_to" class="form-control" value="{{ $dateTo ?? '' }}">
                </div>
                <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary me-2">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                    <a href="{{ route('admin.accounting.reports.profitability') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Resumen General -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card shadow-sm border-success">
                <div class="card-header bg-success text-white">
                    <h6 class="mb-0">Ingresos Totales</h6>
                </div>
                <div class="card-body text-center">
                    <h3 class="text-success mb-0">${{ number_format($totalRevenue, 2) }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card shadow-sm border-danger">
                <div class="card-header bg-danger text-white">
                    <h6 class="mb-0">Costos (Compras)</h6>
                </div>
                <div class="card-body text-center">
                    <h3 class="text-danger mb-0">${{ number_format($totalPurchases, 2) }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card shadow-sm border-warning">
                <div class="card-header bg-warning text-dark">
                    <h6 class="mb-0">Gastos</h6>
                </div>
                <div class="card-body text-center">
                    <h3 class="text-warning mb-0">${{ number_format($totalExpenses, 2) }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card shadow-sm border-primary">
                <div class="card-header bg-primary text-white">
                    <h6 class="mb-0">Utilidad Neta</h6>
                </div>
                <div class="card-body text-center">
                    <h3 class="text-primary mb-0">${{ number_format($netProfit, 2) }}</h3>
                    <small class="text-muted">Margen: {{ number_format($netMargin, 2) }}%</small>
                </div>
            </div>
        </div>
    </div>

    <!-- Análisis de Utilidades -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-info text-white">
            <h5 class="mb-0">
                <i class="fas fa-chart-line me-2"></i>Análisis de Utilidades
            </h5>
        </div>
        <div class="card-body">
            <div class="row text-center">
                <div class="col-md-6">
                    <h4 class="text-primary mb-0">Utilidad Bruta</h4>
                    <h3 class="text-success mb-0">${{ number_format($grossProfit, 2) }}</h3>
                    <p class="text-muted mb-0">Margen Bruto: {{ number_format($grossMargin, 2) }}%</p>
                </div>
                <div class="col-md-6">
                    <h4 class="text-primary mb-0">Utilidad Neta</h4>
                    <h3 class="text-{{ $netProfit > 0 ? 'success' : 'danger' }} mb-0">${{ number_format($netProfit, 2) }}</h3>
                    <p class="text-muted mb-0">Margen Neto: {{ number_format($netMargin, 2) }}%</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Análisis Mensual -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-calendar me-2"></i>Análisis Mensual
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover mb-0">
                    <thead class="table-dark">
                        <tr>
                            <th>Período</th>
                            <th class="text-end">Ingresos</th>
                            <th class="text-end">Compras</th>
                            <th class="text-end">Gastos</th>
                            <th class="text-end">Utilidad Bruta</th>
                            <th class="text-end">Utilidad Neta</th>
                            <th class="text-end">Margen Bruto %</th>
                            <th class="text-end">Margen Neto %</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($monthlyAnalysis as $month)
                            <tr>
                                <td><strong>{{ $month['period_label'] }}</strong></td>
                                <td class="text-end">${{ number_format($month['revenue'], 2) }}</td>
                                <td class="text-end text-danger">${{ number_format($month['purchases'], 2) }}</td>
                                <td class="text-end text-warning">${{ number_format($month['expenses'], 2) }}</td>
                                <td class="text-end text-success">
                                    <strong>${{ number_format($month['gross_profit'], 2) }}</strong>
                                </td>
                                <td class="text-end text-{{ $month['net_profit'] > 0 ? 'success' : 'danger' }}">
                                    <strong>${{ number_format($month['net_profit'], 2) }}</strong>
                                </td>
                                <td class="text-end">
                                    <span class="badge bg-{{ $month['gross_margin'] > 30 ? 'success' : ($month['gross_margin'] > 15 ? 'warning' : 'danger') }}">
                                        {{ number_format($month['gross_margin'], 2) }}%
                                    </span>
                                </td>
                                <td class="text-end">
                                    <span class="badge bg-{{ $month['net_margin'] > 20 ? 'success' : ($month['net_margin'] > 10 ? 'warning' : 'danger') }}">
                                        {{ number_format($month['net_margin'], 2) }}%
                                    </span>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center py-4">
                                    <i class="fas fa-info-circle me-2"></i>No se encontraron datos en el período seleccionado.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($monthlyAnalysis) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th class="text-end">Totales:</th>
                            <th class="text-end">${{ number_format($totalRevenue, 2) }}</th>
                            <th class="text-end">${{ number_format($totalPurchases, 2) }}</th>
                            <th class="text-end">${{ number_format($totalExpenses, 2) }}</th>
                            <th class="text-end">${{ number_format($grossProfit, 2) }}</th>
                            <th class="text-end">${{ number_format($netProfit, 2) }}</th>
                            <th class="text-end">{{ number_format($grossMargin, 2) }}%</th>
                            <th class="text-end">{{ number_format($netMargin, 2) }}%</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>

    <!-- Análisis por Categoría -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-box me-2"></i>Análisis de Rentabilidad por Categoría
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover mb-0">
                    <thead class="table-dark">
                        <tr>
                            <th>Categoría</th>
                            <th class="text-end">Cantidad Vendida</th>
                            <th class="text-end">Ingresos</th>
                            <th class="text-end">Costos</th>
                            <th class="text-end">Utilidad</th>
                            <th class="text-end">Margen %</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($productAnalysis as $item)
                            <tr>
                                <td><strong>{{ $item['category'] }}</strong></td>
                                <td class="text-end">{{ number_format($item['quantity'], 2) }}</td>
                                <td class="text-end">${{ number_format($item['revenue'], 2) }}</td>
                                <td class="text-end text-danger">${{ number_format($item['cost'], 2) }}</td>
                                <td class="text-end text-{{ $item['profit'] > 0 ? 'success' : 'danger' }}">
                                    <strong>${{ number_format($item['profit'], 2) }}</strong>
                                </td>
                                <td class="text-end">
                                    <span class="badge bg-{{ $item['margin'] > 30 ? 'success' : ($item['margin'] > 15 ? 'warning' : 'danger') }}">
                                        {{ number_format($item['margin'], 2) }}%
                                    </span>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="6" class="text-center py-4">
                                    <i class="fas fa-info-circle me-2"></i>No se encontraron ventas por categoría en el período seleccionado.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($productAnalysis) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format(array_sum(array_column($productAnalysis, 'quantity')), 2) }}</th>
                            <th class="text-end">${{ number_format(array_sum(array_column($productAnalysis, 'revenue')), 2) }}</th>
                            <th class="text-end">${{ number_format(array_sum(array_column($productAnalysis, 'cost')), 2) }}</th>
                            <th class="text-end">${{ number_format(array_sum(array_column($productAnalysis, 'profit')), 2) }}</th>
                            <th class="text-end">-</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
</div>

<style>
    @media print {
        .btn, .card-header, .navbar, .sidebar {
            display: none !important;
        }
        .card {
            border: none !important;
            box-shadow: none !important;
        }
    }
</style>
@endsection