@extends('layouts.app')

@section('title', 'Reporte de Clientes')

@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-user-friends me-2 text-primary"></i>Reporte de Clientes
            </h1>
            <p class="text-muted mb-0 small">Análisis completo de clientes y cuentas por cobrar</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('admin.reports.clients.export', request()->all()) }}" class="btn btn-success btn-sm">
                <i class="fas fa-file-excel me-2"></i>Exportar Excel
            </a>
            <button onclick="window.print()" class="btn btn-primary btn-sm">
                <i class="fas fa-print me-2"></i>Imprimir
            </button>
            <a href="{{ route('admin.reports.index') }}" class="btn btn-secondary btn-sm">
                <i class="fas fa-arrow-left me-2"></i>Volver
            </a>
        </div>
    </div>

    <!-- Estadísticas -->
    <div class="row g-3 mb-4">
        <div class="col-xl-3 col-md-6">
            <div class="stat-card stat-card-info">
                <div class="stat-card-icon">
                    <i class="fas fa-users"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Total Clientes</div>
                    <div class="stat-card-value">{{ number_format($stats['total_clients'] ?? 0) }}</div>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-md-6">
            <div class="stat-card stat-card-success">
                <div class="stat-card-icon">
                    <i class="fas fa-check-circle"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Clientes Activos</div>
                    <div class="stat-card-value">{{ number_format($stats['active_clients'] ?? 0) }}</div>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-md-6">
            <div class="stat-card stat-card-warning">
                <div class="stat-card-icon">
                    <i class="fas fa-hand-holding-usd"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Total por Cobrar</div>
                    <div class="stat-card-value">${{ number_format($stats['total_receivable'] ?? 0, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-md-6">
            <div class="stat-card stat-card-danger">
                <div class="stat-card-icon">
                    <i class="fas fa-exclamation-triangle"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Vencidas</div>
                    <div class="stat-card-value">${{ number_format($stats['overdue_receivable'] ?? 0, 2) }}</div>
                </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.clients') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="search" class="form-label">Buscar</label>
                    <input type="text" name="search" id="search" class="form-control" value="{{ request('search') }}" placeholder="Nombre, RIF, Email...">
                </div>
                <div class="col-md-3">
                    <label for="status" class="form-label">Estado</label>
                    <select name="status" id="status" class="form-select">
                        <option value="">Todos</option>
                        <option value="active" {{ request('status') == 'active' ? 'selected' : '' }}>Activos</option>
                        <option value="inactive" {{ request('status') == 'inactive' ? 'selected' : '' }}>Inactivos</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="zone_id" class="form-label">Zona</label>
                    <select name="zone_id" id="zone_id" class="form-select">
                        <option value="">Todas</option>
                        @foreach($zones as $zone)
                            <option value="{{ $zone->id }}" {{ request('zone_id') == $zone->id ? 'selected' : '' }}>{{ $zone->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="salesman_id" class="form-label">Vendedor</label>
                    <select name="salesman_id" id="salesman_id" class="form-select">
                        <option value="">Todos</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 class="col-12">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                    <a href="{{ route('admin.reports.clients') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Tabla de Clientes -->
    <div class="card shadow-sm">
        <div class="card-header bg-white border-bottom py-3">
            <h5 class="mb-0">Lista de Clientes</h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>#</th>
                            <th>Nombre/Razón Social</th>
                            <th>RIF/NIT</th>
                            <th>Email</th>
                            <th>Teléfono</th>
                            <th>Zona</th>
                            <th>Vendedor</th>
                            <th>Por Cobrar</th>
                            <th>Vencidas</th>
                            <th>Estado</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($clients as $client)
                            @php
                                $receivables = \App\Models\AccountsReceivable::where('client_id', $client->id)
                                    ->where('current_balance', '>', 0)
                                    ->get();
                                $totalReceivable = $receivables->sum('current_balance');
                                $overdueReceivable = $receivables->where('due_date', '<', now()->toDateString())->sum('current_balance');
                            @endphp
                            <tr>
                                <td>{{ $clients->firstItem() + $loop->index }}</td>
                                <td>
                                    <strong>{{ $client->business_name }}</strong>
                                </td>
                                <td>{{ $client->tax_id ?? 'N/A' }}</td>
                                <td>{{ $client->email ?? 'N/A' }}</td>
                                <td>{{ $client->phone ?? 'N/A' }}</td>
                                <td>
                                    @if($client->zone)
                                        <span class="badge bg-info">{{ $client->zone->name }}</span>
                                    @else
                                        N/A
                                    @endif
                                </td>
                                <td>
                                    @if($client->salesman)
                                        {{ $client->salesman->first_name }} {{ $client->salesman->last_name }}
                                    @else
                                        N/A
                                    @endif
                                </td>
                                <td class="text-end">
                                    <strong>${{ number_format($totalReceivable, 2) }}</strong>
                                </td>
                                <td class="text-end">
                                    @if($overdueReceivable > 0)
                                        <span class="text-danger"><strong>${{ number_format($overdueReceivable, 2) }}</strong></span>
                                    @else
                                        $0.00
                                    @endif
                                </td>
                                <td>
                                    @if($client->status === 'active')
                                        <span class="badge bg-success">Activo</span>
                                    @else
                                        <span class="badge bg-secondary">Inactivo</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="10" class="text-center py-4">
                                    <i class="fas fa-inbox fa-2x text-muted mb-2"></i>
                                    <p class="text-muted">No se encontraron clientes</p>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        @if($clients->hasPages())
            <div class="card-footer bg-white">
                {{ $clients->links() }}
            </div>
        @endif
    </div>
</div>

@push('styles')
<style>
    @media print {
        .no-print {
            display: none !important;
        }
    }
</style>
@endpush
@endsection