@extends('adminlte::page')

@section('title', 'Estado de Cuentas')
@section('plugins.Select2', true)

@section('content_header')
    <h4>Estado de Cuentas</h4>
@stop

@section('content')
    <div class="card">
        <div class="card-body">

            <div class="row mb-4">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header bg-light">
                            <h3 class="card-title">Filtros de búsqueda</h3>
                        </div>
                        <div class="card-body">
                            <form action="{{ route('reportes.accounts.search') }}" method="GET" class="mb-0">
                                @csrf
                                <div class="row align-items-end">
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="fecha_inicio">Fecha Inicio</label>
                                            <input type="date"
                                                   name="fecha_inicio"
                                                   id="fecha_inicio"
                                                   class="form-control"
                                                   value="{{ request('fecha_inicio', now()->format('Y-m-d')) }}"
                                                   required>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="fecha_fin">Fecha Fin</label>
                                            <input type="date"
                                                   name="fecha_fin"
                                                   id="fecha_fin"
                                                   class="form-control"
                                                   value="{{ request('fecha_fin', now()->format('Y-m-d')) }}"
                                                   required>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="account_id">Cuenta</label>
                                            <select name="account_id" id="account_id" class="form-control select2"
                                                style="width: 100%">
                                                <option value="">Todas las cuentas</option>
                                                @foreach($accounts as $account)
                                                    <option value="{{ $account->id }}"
                                                            {{ request('account_id') == $account->id ? 'selected' : '' }}>
                                                        {{ $account->name }} - {{ $account->number }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-3">
                                        <div class="btn-group float-right">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="fas fa-search mr-1"></i>
                                                Buscar
                                            </button>

                                            <a href="{{ route('reportes.accounts.index') }}" class="btn btn-secondary">
                                                <i class="fas fa-broom mr-1"></i>
                                                Limpiar
                                            </a>

                                            <a href="{{ route('reportes.accounts.export', 'excel') }}?{{ http_build_query(request()->all()) }}"
                                                class="btn btn-success" target="_blank">
                                                 <i class="fas fa-file-excel mr-1"></i>
                                                 Excel
                                             </a>

                                             <a href="{{ route('reportes.accounts.export', 'pdf') }}?{{ http_build_query(request()->all()) }}"
                                                class="btn btn-danger" target="_blank">
                                                 <i class="fas fa-file-pdf mr-1"></i>
                                                 PDF
                                             </a>

                                        </div>
                                    </div>
                                </div>
                            </form>


                        </div>
                    </div>
                </div>
            </div>

            <hr>

            <!-- Tabla de resultados -->
            @if(isset($records))
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>Cuenta Bancaria</th>
                        <th>Número</th>
                        <th>Saldo Inicial</th>
                        <th>Ingresos</th>
                        <th>Egresos</th>
                        <th>Saldo Final</th>
                        <th>Variación</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($records as $account)
                    <tr>
                        <td>
                            <strong>{{ $account->name }}</strong>
                            @if($account->account_type)
                                <br><small class="text-muted">{{ $account->account_type->description }}</small>
                            @endif
                        </td>
                        <td>{{ $account->number }}</td>
                        <td class="text-right">
                            <span class="badge badge-secondary" style="font-size: 12px;">
                                S/. {{ number_format($account->saldo_inicial ?? 0, 2) }}
                            </span>
                        </td>
                        <td class="text-right">
                            <span class="badge badge-success" style="font-size: 12px;">
                                S/. {{ number_format($account->total_ingresos ?? 0, 2) }}
                            </span>
                        </td>
                        <td class="text-right">
                            <span class="badge badge-danger" style="font-size: 12px;">
                                S/. {{ number_format($account->total_egresos ?? 0, 2) }}
                            </span>
                        </td>
                        <td class="text-right">
                            <span class="badge badge-primary" style="font-size: 14px;">
                                S/. {{ number_format($account->saldo_final ?? 0, 2) }}
                            </span>
                        </td>
                        <td class="text-center">
                            @php
                                $variacion = $account->variacion_porcentaje ?? 0;
                                $badgeClass = $variacion > 0 ? 'badge-success' : ($variacion < 0 ? 'badge-danger' : 'badge-secondary');
                            @endphp
                            <span class="badge {{ $badgeClass }}" style="font-size: 12px;">
                                {{ $variacion > 0 ? '+' : '' }}{{ number_format($variacion, 1) }}%
                            </span>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="7" class="text-center">
                            <div class="alert alert-info">
                                <i class="fas fa-info-circle mr-2"></i>
                                No se encontraron cuentas para los filtros seleccionados
                            </div>
                        </td>
                    </tr>
                    @endforelse
                </tbody>
                @if($records->count() > 0)
                <tfoot class="bg-light">
                    <tr>
                        <th colspan="2" class="text-right">TOTALES:</th>
                        <th class="text-right">
                            <span class="badge badge-secondary" style="font-size: 14px;">
                                S/. {{ number_format($records->sum('saldo_inicial'), 2) }}
                            </span>
                        </th>
                        <th class="text-right">
                            <span class="badge badge-success" style="font-size: 14px;">
                                S/. {{ number_format($records->sum('total_ingresos'), 2) }}
                            </span>
                        </th>
                        <th class="text-right">
                            <span class="badge badge-danger" style="font-size: 14px;">
                                S/. {{ number_format($records->sum('total_egresos'), 2) }}
                            </span>
                        </th>
                        <th class="text-right">
                            <span class="badge badge-primary" style="font-size: 16px;">
                                S/. {{ number_format($records->sum('saldo_final'), 2) }}
                            </span>
                        </th>
                        <th></th>
                    </tr>
                </tfoot>
                @endif
            </table>
            @endif

            <!-- Sección de Transferencias -->
            @if(isset($transferencias) && $transferencias->count() > 0)
            <div class="mt-4">
                <h5 class="mb-3">
                    <i class="fas fa-exchange-alt mr-2"></i>
                    Transferencias entre Cuentas ({{ $transferencias->count() }})
                </h5>
                <table class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>N°</th>
                            <th>Fecha</th>
                            <th>Cuenta Origen</th>
                            <th>Cuenta Destino</th>
                            <th class="text-right">Monto</th>
                            <th>Tipo</th>
                            <th>N° Operación</th>
                            <th>Caja</th>
                            <th>Descripción</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($transferencias as $index => $transferencia)
                        <tr>
                            <td>{{ $index + 1 }}</td>
                            <td>{{ \Carbon\Carbon::parse($transferencia->date_of_issue)->format('d/m/Y') }}</td>
                            <td>
                                <strong>{{ $transferencia->account_origen->name ?? 'N/A' }}</strong>
                            </td>
                            <td>
                                <strong>{{ $transferencia->account_destino->name ?? 'N/A' }}</strong>
                            </td>
                            <td class="text-right">
                                <span class="badge badge-info" style="font-size: 12px;">
                                    S/. {{ number_format($transferencia->total, 2) }}
                                </span>
                            </td>
                            <td>{{ $transferencia->payment_method->description ?? 'N/A' }}</td>
                            <td>{{ $transferencia->numero_operacion ?? '-' }}</td>
                            <td>
                                @if($transferencia->caja)
                                    <span class="badge badge-secondary">Caja #{{ $transferencia->caja->id }}</span>
                                @else
                                    -
                                @endif
                            </td>
                            <td>{{ $transferencia->description ?? 'Sin descripción' }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot class="bg-light">
                        <tr>
                            <th colspan="4" class="text-right"><strong>TOTAL TRANSFERENCIAS:</strong></th>
                            <th class="text-right">
                                <span class="badge badge-info" style="font-size: 14px;">
                                    S/. {{ number_format($transferencias->sum('total'), 2) }}
                                </span>
                            </th>
                            <th colspan="4"></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
            @elseif(isset($transferencias) && $transferencias->count() == 0 && isset($records))
            <div class="mt-4">
                <div class="alert alert-info">
                    <i class="fas fa-info-circle mr-2"></i>
                    No se encontraron transferencias en el período seleccionado.
                </div>
            </div>
            @endif

        </div>
    </div>
@endsection

@section('css')
    <style>
        .select2-selection {
            height: 40px !important;
        }
    </style>
@endsection

@section('js')
    <script>
        // Iniciar Select2 para el filtro de cuenta
        $('.select2').select2();
    </script>
@stop