@extends('layouts.app')

@section('title', 'Reporte de Comisiones por Vendedor')

@section('content')
<div class="container-fluid py-4">
    <!-- Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h1 class="h3 mb-1 text-dark">
                <i class="fas fa-percent me-2 text-primary"></i>Reporte de Comisiones por Vendedor
            </h1>
            <p class="text-muted mb-0 small">Visualice y analice todas las comisiones generadas y adjudicadas</p>
        </div>
        <div>
            <a href="{{ route('admin.reports.commissions', array_merge(request()->all(), ['print' => '1'])) }}" 
               target="_blank"
               class="btn btn-primary me-2">
                <i class="fas fa-print me-2"></i>Imprimir Reporte
            </a>
            <a href="{{ route('admin.reports.commissions', array_merge(request()->all(), ['export' => 'excel'])) }}" 
               class="btn btn-success">
                <i class="fas fa-file-excel me-2"></i>Exportar Excel
            </a>
        </div>
    </div>

    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fas fa-check-circle me-2"></i>{{ session('success') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fas fa-exclamation-circle me-2"></i>{{ session('error') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    <!-- Estadísticas -->
    <div class="row mb-4">
        <div class="col-md-2">
            <div class="card text-center border-success">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Total Comisiones</h6>
                    <h4 class="text-primary">{{ number_format($stats['total_commissions'] ?? 0, 0) }}</h4>
                    <small class="text-muted">Registros</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card text-center border-success">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Total Ganadas</h6>
                    <h4 class="text-success">${{ number_format($stats['total_amount_earned'] ?? 0, 2) }}</h4>
                    <small class="text-muted">USD</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card text-center border-danger">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Total Perdidas</h6>
                    <h4 class="text-danger">${{ number_format($stats['total_amount_lost'] ?? 0, 2) }}</h4>
                    <small class="text-muted">USD</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card text-center border-warning">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Pendientes</h6>
                    <h4 class="text-warning">${{ number_format($stats['total_amount_pending'] ?? 0, 2) }}</h4>
                    <small class="text-muted">USD</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card text-center border-info">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Pagadas</h6>
                    <h4 class="text-info">${{ number_format($stats['total_amount_paid'] ?? 0, 2) }}</h4>
                    <small class="text-muted">USD</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card text-center border-secondary">
                <div class="card-body">
                    <h6 class="text-muted mb-2">Parciales</h6>
                    <h4 class="text-secondary">${{ number_format($stats['total_amount_partial'] ?? 0, 2) }}</h4>
                    <small class="text-muted">USD</small>
                </div>
            </div>
        </div>
    </div>

    <!-- Filtros -->
    <div class="card shadow 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.commissions') }}">
                <div class="row">
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label for="salesman_id" class="form-label">Vendedor</label>
                            <select class="form-select" id="salesman_id" name="salesman_id">
                                <option value="">Todos los vendedores</option>
                                @foreach($salesmen as $salesman)
                                    <option value="{{ $salesman->id }}" {{ request('salesman_id') == $salesman->id ? 'selected' : '' }}>
                                        {{ $salesman->first_name }} {{ $salesman->last_name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label for="status" class="form-label">Estado</label>
                            <select class="form-select" id="status" name="status">
                                <option value="">Todos los estados</option>
                                <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pendiente</option>
                                <option value="earned" {{ request('status') == 'earned' ? 'selected' : '' }}>Ganada</option>
                                <option value="lost" {{ request('status') == 'lost' ? 'selected' : '' }}>Perdida</option>
                                <option value="paid" {{ request('status') == 'paid' ? 'selected' : '' }}>Pagada</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label for="date_from" class="form-label">Fecha Desde</label>
                            <input type="date" class="form-control" id="date_from" name="date_from" value="{{ request('date_from') }}">
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="mb-3">
                            <label for="date_to" class="form-label">Fecha Hasta</label>
                            <input type="date" class="form-control" id="date_to" name="date_to" value="{{ request('date_to') }}">
                        </div>
                    </div>
                </div>
                <div class="d-flex gap-2">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search me-2"></i>Filtrar
                    </button>
                    <a href="{{ route('admin.reports.commissions') }}" class="btn btn-secondary">
                        <i class="fas fa-times me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Tabla de Comisiones -->
    <div class="card shadow">
        <div class="card-header bg-primary text-white">
            <h5 class="mb-0"><i class="fas fa-list me-2"></i>Comisiones</h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-striped table-sm table-hover mb-0">
                    <thead class="table-dark">
                        <tr>
                            <th>Factura</th>
                            <th>Tipo Doc.</th>
                            <th>Vendedor</th>
                            <th>Fec. Venta</th>
                            <th>Fec. Pago</th>
                            <th>Días P.</th>
                            <th>Mon. Vta.</th>
                            <th>Mon. Pago</th>
                            <th>Monto Base (USD)</th>
                            <th>%</th>
                            <th>Comisión (USD)</th>
                            <th>Estado</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($commissions as $comm)
                            <tr>
                                <td>
                                    @if($comm->salesInvoice)
                                        <a href="{{ route('admin.sales.invoices.show', $comm->sales_invoice_id) }}" target="_blank">
                                            {{ $comm->salesInvoice->invoice_number ?? 'N/A' }}
                                        </a>
                                    @else
                                        N/A
                                    @endif
                                </td>
                                <td>
                                    <span class="badge bg-info">
                                        {{ ($comm->document_type ?? 'invoice') == 'invoice' ? 'Factura' : 'Nota' }}
                                    </span>
                                </td>
                                <td>
                                    @if($comm->salesman)
                                        <strong>{{ $comm->salesman->first_name ?? '' }} {{ $comm->salesman->last_name ?? '' }}</strong>
                                    @else
                                        <span class="text-muted">N/A</span>
                                    @endif
                                </td>
                                <td>{{ $comm->invoice_date ? (is_string($comm->invoice_date) ? \Carbon\Carbon::parse($comm->invoice_date)->format('d/m/Y') : $comm->invoice_date->format('d/m/Y')) : 'N/A' }}</td>
                                <td>{{ $comm->payment_date ? (is_string($comm->payment_date) ? \Carbon\Carbon::parse($comm->payment_date)->format('d/m/Y') : $comm->payment_date->format('d/m/Y')) : '-' }}</td>
                                <td class="text-center">
                                    @php
                                        $invoice = $comm->salesInvoice;
                                        $isInvoicePaid = $invoice && ($invoice->amount_due ?? $invoice->total_amount_usd ?? 0) <= 0.01;
                                        $isOverdue = $comm->isOverdue();
                                        
                                        if ($comm->days_to_pay !== null && $comm->payment_days_limit !== null) {
                                            $daysToPay = $comm->days_to_pay;
                                            $isWithinLimit = $daysToPay <= $comm->payment_days_limit;
                                        } elseif ($comm->invoice_date) {
                                            $daysToPay = \Carbon\Carbon::parse($comm->invoice_date)->diffInDays(now());
                                            $isWithinLimit = $daysToPay <= $comm->payment_days_limit;
                                        } else {
                                            $daysToPay = null;
                                            $isWithinLimit = true;
                                        }
                                    @endphp
                                    @php
                                        $daysTooltipText = '';
                                        if ($isOverdue) {
                                            $daysTooltipText = 'Comisión fuera de tiempo - Excedió el límite de ' . ($comm->payment_days_limit ?? 30) . ' días';
                                        } elseif (!$isInvoicePaid) {
                                            $daysTooltipText = 'Factura pendiente de pago';
                                        }
                                    @endphp
                                    @if($daysToPay !== null)
                                        <span class="badge bg-{{ ($isWithinLimit && !$isOverdue) ? 'success' : 'danger' }}" 
                                              @if($daysTooltipText) title="{{ $daysTooltipText }}" @endif>
                                            {{ $daysToPay }}
                                            @if($isOverdue)
                                                <i class="fas fa-exclamation-triangle ms-1"></i>
                                            @endif
                                        </span>
                                    @else
                                        -
                                    @endif
                                </td>
                                <td>{{ $comm->sale_currency ?? '-' }}</td>
                                <td>{{ $comm->payment_currency ?? '-' }}</td>
                                <td>${{ number_format($comm->commissionable_amount_usd ?? 0, 2) }}</td>
                                <td>{{ number_format($comm->commission_rate_applied ?? 0, 2) }}%</td>
                                <td><strong>${{ number_format($comm->commission_amount_usd ?? 0, 2) }}</strong></td>
                                <td>
                                    @php
                                        $invoice = $comm->salesInvoice;
                                        $isInvoicePaid = $invoice && ($invoice->amount_due ?? $invoice->total_amount_usd ?? 0) <= 0.01;
                                        $isOverdue = $comm->isOverdue();
                                        $status = $comm->status ?? 'pending';
                                        
                                        $statusColors = [
                                            'pending' => 'warning',
                                            'earned' => 'success',
                                            'lost' => 'danger',
                                            'paid' => 'info',
                                            'partial' => 'secondary',
                                            'cancelled' => 'dark',
                                            'overdue' => 'danger'
                                        ];
                                        
                                        // Si está fuera de tiempo y es pending, mostrar como "Fuera de Tiempo"
                                        if ($isOverdue && $status === 'pending') {
                                            $displayStatus = 'overdue';
                                            $displayText = 'Fuera de Tiempo';
                                            $tooltipText = 'Comisión fuera de tiempo - La factura excedió el límite de ' . ($comm->payment_days_limit ?? 30) . ' días sin pagarse';
                                        } elseif (!$isInvoicePaid && $status === 'pending') {
                                            $displayStatus = 'pending';
                                            $displayText = 'En Espera';
                                            $tooltipText = 'En espera - La factura aún no está pagada';
                                        } else {
                                            $displayStatus = $status;
                                            $displayText = $comm->status_text ?? ucfirst($status);
                                            $tooltipText = '';
                                        }
                                    @endphp
                                    <span class="badge bg-{{ $statusColors[$displayStatus] ?? 'secondary' }}" 
                                          @if($tooltipText) title="{{ $tooltipText }}" @endif>
                                        {{ $displayText }}
                                    </span>
                                    @if($isOverdue && $status === 'pending')
                                        <br><small class="text-danger"><i class="fas fa-exclamation-triangle"></i> Fuera de tiempo</small>
                                    @elseif(!$isInvoicePaid && $status === 'pending')
                                        <br><small class="text-warning"><i class="fas fa-clock"></i> Factura pendiente</small>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="12" class="text-center py-4">
                                    <i class="fas fa-inbox fa-2x text-muted mb-2"></i>
                                    <p class="text-muted">No hay comisiones que coincidan con los filtros seleccionados.</p>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        <div class="card-footer bg-white">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    Mostrando {{ $commissions->firstItem() ?? 0 }} a {{ $commissions->lastItem() ?? 0 }} de {{ $commissions->total() }} comisiones
                </div>
                <div>
                    {{ $commissions->links() }}
                </div>
            </div>
        </div>
    </div>
</div>
@endsection