@extends('adminlte::page')

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

@section('content_header')
    <h4>Reporte 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">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Cuenta</th>
                        <th>Número</th>
                        <th>Tipo de Cuenta</th>
                        <th>Moneda</th>
                        <th>Saldo Inicial</th>
                        <th>Saldo Actual</th>
                        <th>Monto en Período</th>
                        <th>Fecha Creación</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($records as $account)
                    <tr>
                        <td>{{ $account->id }}</td>
                        <td>{{ $account->name }}</td>
                        <td>{{ $account->number }}</td>
                        <td>{{ $account->account_type->description ?? 'N/A' }}</td>
                        <td>{{ $account->currency_type->description ?? 'N/A' }}</td>
                        <td class="text-right">{{ number_format($account->beginning_balance, 2) }}</td>
                        <td class="text-right">{{ number_format($account->current_balance, 2) }}</td>
                        <td class="text-right">{{ number_format($account->monto_periodo ?? 0, 2) }}</td>
                        <td>{{ $account->date_of_issue ? \Carbon\Carbon::parse($account->date_of_issue)->format('d/m/Y') : 'N/A' }}</td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="9" class="text-center">No se encontraron cuentas</td>
                    </tr>
                    @endforelse
                </tbody>
                @if($records->count() > 0)
                <tfoot>
                    <tr style="background-color: #f8f9fa;">
                        <th colspan="5" class="text-right">TOTALES:</th>
                        <th class="text-right">{{ number_format($records->sum('beginning_balance'), 2) }}</th>
                        <th class="text-right">{{ number_format($records->sum('current_balance'), 2) }}</th>
                        <th class="text-right">{{ number_format($records->sum('monto_periodo'), 2) }}</th>
                        <th></th>
                    </tr>
                </tfoot>
                @endif
            </table>
            @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