@extends('layouts.app')

@section('title', 'Ventas por Vendedor')

@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-user-tie me-2"></i>Ventas por Vendedor
                </h2>
                <div>
                    <a href="{{ route('admin.reports.index') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left me-2"></i>Volver a Reportes
                    </a>
                    <a href="{{ route('admin.reports.sales-by-salesman', 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.reports.sales-by-salesman') }}" 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.reports.sales-by-salesman') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Resumen -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-primary text-white">
            <h5 class="mb-0">
                <i class="fas fa-chart-pie me-2"></i>Resumen General
            </h5>
        </div>
        <div class="card-body">
            <div class="row text-center">
                <div class="col-md-3">
                    <h3 class="text-primary mb-0">{{ count($report) }}</h3>
                    <p class="text-muted mb-0">Vendedores Activos</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-success mb-0">${{ number_format(array_sum(array_map(function($item) { return $item['total_amount'] ?? 0; }, $report)), 2) }}</h3>
                    <p class="text-muted mb-0">Total de Ventas</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-info mb-0">${{ number_format(array_sum(array_map(function($item) { return $item['total_paid'] ?? 0; }, $report)), 2) }}</h3>
                    <p class="text-muted mb-0">Total Pagado</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-warning mb-0">${{ number_format(array_sum(array_map(function($item) { return $item['total_due'] ?? 0; }, $report)), 2) }}</h3>
                    <p class="text-muted mb-0">Total Pendiente</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Gráficos de Ventas por Vendedor -->
    @if(count($report) > 0)
    <div class="row mb-4">
        <div class="col-md-8">
            <div class="card shadow-sm">
                <div class="card-header bg-primary text-white">
                    <h5 class="mb-0">
                        <i class="fas fa-chart-bar me-2"></i>Ventas por Vendedor
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="salesBySalesmanChart" height="80"></canvas>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card shadow-sm">
                <div class="card-header bg-info text-white">
                    <h5 class="mb-0">
                        <i class="fas fa-chart-pie me-2"></i>Distribución de Ventas
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="salesDistributionChart" height="80"></canvas>
                </div>
            </div>
        </div>
    </div>
    @endif

    <!-- Tabla de Vendedores -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Desempeño por Vendedor
            </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>#</th>
                            <th>Vendedor</th>
                            <th class="text-end">Facturas</th>
                            <th class="text-end">Total Ventas</th>
                            <th class="text-end">Total Pagado</th>
                            <th class="text-end">Total Pendiente</th>
                            <th class="text-end">Promedio por Factura</th>
                            <th class="text-end">% del Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $grandTotal = array_sum(array_map(function($item) { return $item['total_amount'] ?? 0; }, $report));
                        @endphp
                        @forelse($report as $index => $item)
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>
                                    <strong>{{ $item['salesman']->first_name }} {{ $item['salesman']->last_name }}</strong>
                                    @if($item['salesman']->email)
                                        <br><small class="text-muted">{{ $item['salesman']->email }}</small>
                                    @endif
                                </td>
                                <td class="text-end">{{ number_format($item['invoice_count'], 0) }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($item['total_amount'], 2) }}</strong>
                                </td>
                                <td class="text-end text-success">${{ number_format($item['total_paid'], 2) }}</td>
                                <td class="text-end text-warning">${{ number_format($item['total_due'], 2) }}</td>
                                <td class="text-end">${{ number_format($item['average_amount'], 2) }}</td>
                                <td class="text-end">
                                    <span class="badge bg-{{ $grandTotal > 0 && ($item['total_amount'] / $grandTotal * 100) > 20 ? 'success' : 'info' }}">
                                        {{ $grandTotal > 0 ? number_format(($item['total_amount'] / $grandTotal * 100), 2) : 0 }}%
                                    </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 ventas en el período seleccionado.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($report) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="2" class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format(array_sum(array_map(function($item) { return $item['invoice_count'] ?? 0; }, $report)), 0) }}</th>
                            <th class="text-end">${{ number_format($grandTotal, 2) }}</th>
                            <th class="text-end">${{ number_format(array_sum(array_map(function($item) { return $item['total_paid'] ?? 0; }, $report)), 2) }}</th>
                            <th class="text-end">${{ number_format(array_sum(array_map(function($item) { return $item['total_due'] ?? 0; }, $report)), 2) }}</th>
                            <th class="text-end">-</th>
                            <th class="text-end">100%</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>

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.0/dist/chart.umd.min.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    @if(count($report) > 0)
    @php
        $grandTotal = array_sum(array_map(function($item) { return $item['total_amount'] ?? 0; }, $report));
        $salesmanLabels = [];
        $salesmanAmounts = [];
        $salesmanPaid = [];
        $salesmanDue = [];
        foreach($report as $item) {
            $salesmanName = ($item['salesman']->first_name ?? '') . ' ' . ($item['salesman']->last_name ?? '');
            $salesmanLabels[] = trim($salesmanName) ?: 'Sin nombre';
            $salesmanAmounts[] = floatval($item['total_amount'] ?? 0);
            $salesmanPaid[] = floatval($item['total_paid'] ?? 0);
            $salesmanDue[] = floatval($item['total_due'] ?? 0);
        }
    @endphp
    const salesmanLabels = @json($salesmanLabels);
    const salesmanAmounts = @json($salesmanAmounts);
    const salesmanPaid = @json($salesmanPaid);
    const salesmanDue = @json($salesmanDue);
    const grandTotal = {{ $grandTotal }};
    
    // Gráfico de Barras
    const ctx1 = document.getElementById('salesBySalesmanChart');
    if (ctx1) {
        new Chart(ctx1, {
            type: 'bar',
            data: {
                labels: salesmanLabels,
                datasets: [{
                    label: 'Total Ventas',
                    data: salesmanAmounts,
                    backgroundColor: 'rgba(54, 162, 235, 0.6)',
                    borderColor: 'rgba(54, 162, 235, 1)',
                    borderWidth: 1
                }, {
                    label: 'Pagado',
                    data: salesmanPaid,
                    backgroundColor: 'rgba(75, 192, 192, 0.6)',
                    borderColor: 'rgba(75, 192, 192, 1)',
                    borderWidth: 1
                }, {
                    label: 'Pendiente',
                    data: salesmanDue,
                    backgroundColor: 'rgba(255, 99, 132, 0.6)',
                    borderColor: 'rgba(255, 99, 132, 1)',
                    borderWidth: 1
                }]
            },
            options: {
                responsive: true,
                maintainAspectRatio: true,
                scales: {
                    y: {
                        beginAtZero: true,
                        title: {
                            display: true,
                            text: 'Monto ($)'
                        }
                    }
                },
                plugins: {
                    legend: {
                        display: true,
                        position: 'top'
                    }
                }
            }
        });
    }
    
    // Gráfico de Pastel
    const ctx2 = document.getElementById('salesDistributionChart');
    if (ctx2 && grandTotal > 0) {
        const colors = [
            'rgba(255, 99, 132, 0.6)',
            'rgba(54, 162, 235, 0.6)',
            'rgba(255, 206, 86, 0.6)',
            'rgba(75, 192, 192, 0.6)',
            'rgba(153, 102, 255, 0.6)',
            'rgba(255, 159, 64, 0.6)',
            'rgba(199, 199, 199, 0.6)',
            'rgba(83, 102, 255, 0.6)',
            'rgba(255, 99, 255, 0.6)',
            'rgba(99, 255, 132, 0.6)'
        ];
        new Chart(ctx2, {
            type: 'pie',
            data: {
                labels: salesmanLabels,
                datasets: [{
                    data: salesmanAmounts,
                    backgroundColor: colors.slice(0, salesmanLabels.length),
                    borderColor: colors.slice(0, salesmanLabels.length).map(c => c.replace('0.6', '1')),
                    borderWidth: 1
                }]
            },
            options: {
                responsive: true,
                maintainAspectRatio: true,
                plugins: {
                    legend: {
                        display: true,
                        position: 'bottom'
                    },
                    tooltip: {
                        callbacks: {
                            label: function(context) {
                                const percentage = ((context.parsed / grandTotal) * 100).toFixed(2);
                                return context.label + ': $' + context.parsed.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) + ' (' + percentage + '%)';
                            }
                        }
                    }
                }
            }
        });
    }
    @endif
});
</script>
@endpush
@endsection