@extends('layouts.app')

@section('content')
<div class="container">
    <h3 class="mb-4">Consulta de Balance</h3>
    <!-- <a href="{{ route('transactionspost.form') }}" class="btn btn-primary mb-3">Crear Transaccion</a> -->
    {{-- FORMULARIO DE BÚSQUEDA --}}
    <div class="card mb-4">
        <div class="card-body">
            <form action="{{ route('transactionsreport.index') }}" method="GET">
                <div class="row g-3">
                    <div class="col-md-3">
                        <label for="start_date" class="form-label">Fecha Inicio</label>
                        <input type="date" id="start_date" name="start_date"
                            value="{{ request('start_date') }}"
                            class="form-control" required>
                    </div>
                    <div class="col-md-3">
                        <label for="end_date" class="form-label">Fecha Fin</label>
                        <input type="date" id="end_date" name="end_date"
                            value="{{ request('end_date') }}"
                            class="form-control" required>
                    </div>

                    {{-- Filtros opcionales --}}
                    <div class="col-md-3">
                        <label for="chart_of_account_id">Cuenta contable</label>
                        <select name="chart_of_account_id" id="chart_of_account_id" class="form-select" required>
                            <option value="">Seleccione una cuenta contable</option>
                            @foreach($cuentas as $cuenta)
                            <option value="{{ $cuenta->id }}">{{ $cuenta->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label for="entity_id">Terceros </label>
                        <select name="entity_id" id="entity_id" class="form-select" required>
                            <option value="">Seleccione un Tercero</option>
                            @foreach($entidades as $entidad)
                            <option value="{{ $entidad->id }}">
                                @if($entidad->person_type === 'juridico')
                                {{ $entidad->business_name }}
                                @else
                                {{ $entidad->first_surname }} {{ $entidad->first_name }}
                                @endif
                            </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3">
                        <label for="company_id">Compañía</label>
                        <select name="company_id" id="company_id" class="form-select" required>
                            <option value="">Seleccione una compañía</option>
                            @foreach($companies as $company)
                            <option value="{{ $company->id }}">{{ $company->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label for="terceros" class="form-label">Incluir Terceros</label>
                        <select id="terceros" name="terceros" class="form-select">
                            <option value="">No</option>
                            <option value="true" {{ request('terceros') === 'true' ? 'selected' : '' }}>Sí</option>
                        </select>
                    </div>

                    <div class="col-md-12">
                        <button type="submit" class="btn btn-primary">Buscar</button>
                    </div>
                </div>
            </form>
        </div>
    </div>

    {{-- SOLO MOSTRAR RESULTADO SI balanceData NO ES NULL --}}
    @if(!is_null($balanceData))
    <div class="card">
        <div class="card-body">
            <h5>Balance del {{ $balanceData['start_date'] }} al {{ $balanceData['end_date'] }}</h5>

            {{-- Tabla de resultados --}}
            <table class="table table-bordered table-striped table-sm mt-3">
                <thead class="table-dark">
                    <tr>
                        <th>Código</th>
                        <th>Nombre</th>
                        <th>Saldo Anterior</th>
                        <th>Débitos</th>
                        <th>Créditos</th>
                        <th>Saldo Actual</th>
                        <th>Nivel</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($balanceData['balance'] as $row)
                    <tr>
                        <td>{{ $row['codigo'] }}</td>
                        <td>{{ $row['nombre'] }}</td>
                        <td class="text-end">$ {{ number_format($row['saldo_anterior'], 0) }}</td>
                        <td class="text-end">$ {{ number_format($row['debitos'], 0) }}</td>
                        <td class="text-end">$ {{ number_format($row['creditos'], 0) }}</td>
                        <td class="text-end">$ {{ number_format($row['saldo_actual'], 0) }}</td>
                        <td>{{ $row['nivel'] }}</td>
                    </tr>

                    {{-- Subtabla de terceros --}}
                    @if (!empty($row['terceros']))
                    <tr>
                        <td colspan="7">
                            <table class="table table-sm mb-0">
                                <thead>
                                    <tr class="table-secondary">
                                        <th>Tercero Identificación</th>
                                        <th>Tercero Nombre</th>
                                        <th>Saldo Anterior</th>
                                        <th>Débitos</th>
                                        <th>Créditos</th>
                                        <th>Saldo Actual</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($row['terceros'] as $tercero)
                                    <tr>
                                        <td>{{ $tercero['identificacion'] ?? '' }}</td>
                                        <td>{{ $tercero['nombre'] ?? '' }}</td>
                                        <td class="text-end">$ {{ number_format($tercero['saldo_anterior'] ?? 0, 0) }}</td>
                                        <td class="text-end">$ {{ number_format($tercero['debitos'] ?? 0, 0) }}</td>
                                        <td class="text-end">$ {{ number_format($tercero['creditos'] ?? 0, 0) }}</td>
                                        <td class="text-end">$ {{ number_format($tercero['saldo_actual'] ?? 0, 0) }}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </td>
                    </tr>
                    @endif
                    @empty
                    <tr>
                        <td colspan="7" class="text-center">No se encontraron resultados</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
    @endif
</div>
@endsection