@extends('layouts.app')

@section('title', 'Reporte de Flujo de Caja')

@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-money-bill-wave me-2 text-primary"></i>Reporte de Flujo de Caja
            </h1>
            <p class="text-muted mb-0 small">Análisis detallado de ingresos y egresos bancarios</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('admin.bank.reports.index') }}" class="btn btn-secondary btn-sm">
                <i class="fas fa-arrow-left me-2"></i>Volver
            </a>
            <a href="{{ route('admin.bank.reports.cash-flow', array_merge(request()->all(), ['export' => 'excel'])) }}" 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>
        </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.bank.reports.cash-flow') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="period" class="form-label">Período</label>
                    <select name="period" id="period" class="form-select">
                        <option value="day" {{ $period == 'day' ? 'selected' : '' }}>Día</option>
                        <option value="week" {{ $period == 'week' ? 'selected' : '' }}>Semana</option>
                        <option value="month" {{ $period == 'month' ? 'selected' : '' }}>Mes</option>
                        <option value="year" {{ $period == 'year' ? 'selected' : '' }}>Año</option>
                        <option value="custom" {{ request('date_from') ? 'selected' : '' }}>Personalizado</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="date_from" class="form-label">Fecha Desde</label>
                    <input type="date" name="date_from" id="date_from" class="form-control" value="{{ $dates['start']->format('Y-m-d') }}">
                </div>
                <div class="col-md-3">
                    <label for="date_to" class="form-label">Fecha Hasta</label>
                    <input type="date" name="date_to" id="date_to" class="form-control" value="{{ $dates['end']->format('Y-m-d') }}">
                </div>
                <div class="col-md-3">
                    <label for="bank_account_id" class="form-label">Cuenta Bancaria</label>
                    <select name="bank_account_id" id="bank_account_id" class="form-select">
                        <option value="">Todas</option>
                        @foreach($bankAccounts ?? [] as $account)
                            <option value="{{ $account->id }}" {{ $bankAccountId == $account->id ? 'selected' : '' }}>
                                {{ $account->bank->name ?? 'N/A' }} - {{ $account->account_number }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-12 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.bank.reports.cash-flow') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Estadísticas -->
    <div class="row g-3 mb-4">
        <div class="col-md-3">
            <div class="stat-card stat-card-success">
                <div class="stat-card-icon">
                    <i class="fas fa-arrow-down"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Total Ingresos</div>
                    <div class="stat-card-value">${{ number_format($stats['total_inflows'] ?? 0, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="stat-card stat-card-danger">
                <div class="stat-card-icon">
                    <i class="fas fa-arrow-up"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Total Egresos</div>
                    <div class="stat-card-value">${{ number_format($stats['total_outflows'] ?? 0, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="stat-card stat-card-primary">
                <div class="stat-card-icon">
                    <i class="fas fa-balance-scale"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Flujo Neto</div>
                    <div class="stat-card-value">${{ number_format($stats['net_flow'] ?? 0, 2) }}</div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="stat-card stat-card-info">
                <div class="stat-card-icon">
                    <i class="fas fa-exchange-alt"></i>
                </div>
                <div class="stat-card-content">
                    <div class="stat-card-label">Transacciones</div>
                    <div class="stat-card-value">{{ number_format($stats['total_transactions'] ?? 0) }}</div>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Flujo de Caja -->
    <div class="card shadow-sm">
        <div class="card-header bg-white border-bottom py-3">
            <h5 class="mb-0 text-dark">
                <i class="fas fa-list me-2 text-primary"></i>Flujo de Caja Detallado
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0" loading="lazy">
                    <thead class="table-light">
                        <tr>
                            <th>Fecha</th>
                            <th>Ingresos</th>
                            <th>Egresos</th>
                            <th>Flujo Neto</th>
                            <th>Transacciones</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($cashFlow ?? [] as $flow)
                            <tr>
                                <td>{{ \Carbon\Carbon::parse($flow['date'])->format('d/m/Y') }}</td>
                                <td class="text-success">${{ number_format($flow['inflows'] ?? 0, 2) }}</td>
                                <td class="text-danger">${{ number_format($flow['outflows'] ?? 0, 2) }}</td>
                                <td class="{{ ($flow['net'] ?? 0) >= 0 ? 'text-success' : 'text-danger' }}">
                                    ${{ number_format($flow['net'] ?? 0, 2) }}
                                </td>
                                <td>{{ $flow['transactions'] ?? 0 }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="5" class="text-center py-4 text-muted">
                                    <i class="fas fa-inbox fa-2x mb-2 d-block"></i>
                                    No se encontraron registros
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Resumen por Tipo -->
    @if(isset($byType) && $byType->count() > 0)
    <div class="card shadow-sm mt-4">
        <div class="card-header bg-white border-bottom py-3">
            <h5 class="mb-0 text-dark">
                <i class="fas fa-chart-pie me-2 text-primary"></i>Resumen por Tipo de Transacción
            </h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead class="table-light">
                        <tr>
                            <th>Tipo</th>
                            <th>Cantidad</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($byType as $type => $data)
                            <tr>
                                <td>{{ ucfirst(str_replace('_', ' ', $type)) }}</td>
                                <td>{{ $data['count'] }}</td>
                                <td>${{ number_format($data['total'], 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif

    <!-- Resumen por Cuenta -->
    @if(isset($byAccount) && $byAccount->count() > 0)
    <div class="card shadow-sm mt-4">
        <div class="card-header bg-white border-bottom py-3">
            <h5 class="mb-0 text-dark">
                <i class="fas fa-wallet me-2 text-primary"></i>Resumen por Cuenta Bancaria
            </h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-sm">
                    <thead class="table-light">
                        <tr>
                            <th>Cuenta</th>
                            <th>Transacciones</th>
                            <th>Ingresos</th>
                            <th>Egresos</th>
                            <th>Neto</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($byAccount as $data)
                            <tr>
                                <td>{{ $data['account']->bank->name ?? 'N/A' }} - {{ $data['account']->account_number }}</td>
                                <td>{{ $data['count'] }}</td>
                                <td class="text-success">${{ number_format($data['inflows'], 2) }}</td>
                                <td class="text-danger">${{ number_format($data['outflows'], 2) }}</td>
                                <td class="{{ ($data['inflows'] - $data['outflows']) >= 0 ? 'text-success' : 'text-danger' }}">
                                    ${{ number_format($data['inflows'] - $data['outflows'], 2) }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
</div>
@endsection