@extends('layouts.app')

@section('title', 'Balance General')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header bg-primary text-white d-flex justify-content-between align-items-center">
                    <h4 class="mb-0">
                        <i class="fas fa-balance-scale"></i> Balance General
                    </h4>
                    <div>
                        <button onclick="window.print()" class="btn btn-light btn-sm">
                            <i class="fas fa-print"></i> Imprimir
                        </button>
                        <a href="{{ route('admin.accounting.dashboard') }}" class="btn btn-light btn-sm">
                            <i class="fas fa-arrow-left"></i> Volver
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    <!-- Filtros -->
                    <form method="GET" action="{{ route('admin.accounting.reports.balance-sheet') }}" class="mb-4">
                        <div class="row">
                            <div class="col-md-4">
                                <label for="period_id" class="form-label">Período Contable</label>
                                <select name="period_id" id="period_id" class="form-select">
                                    <option value="">Período Actual</option>
                                    @foreach($periods as $p)
                                        <option value="{{ $p->id }}" {{ $period && $period->id == $p->id ? 'selected' : '' }}>
                                            {{ $p->name }} ({{ $p->start_date->format('d/m/Y') }} - {{ $p->end_date->format('d/m/Y') }})
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label for="date" class="form-label">Fecha de Corte</label>
                                <input type="date" name="date" id="date" class="form-control" value="{{ $date }}">
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">&nbsp;</label>
                                <div>
                                    <button type="submit" class="btn btn-primary">
                                        <i class="fas fa-search"></i> Generar Reporte
                                    </button>
                                </div>
                            </div>
                        </div>
                    </form>

                    <!-- Balance General -->
                    <div class="row">
                        <div class="col-md-6">
                            <h5 class="text-center mb-3">ACTIVOS</h5>
                            <table class="table table-bordered">
                                <thead class="table-dark">
                                    <tr>
                                        <th>Cuenta</th>
                                        <th class="text-end">Saldo</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if($assets->count() > 0)
                                        @php
                                            $groupedAssets = $assets->groupBy(function($item) {
                                                return $item->account->category ?? 'other';
                                            });
                                        @endphp
                                        @foreach($groupedAssets as $category => $categoryAssets)
                                            @if($category && $category !== 'other')
                                                <tr class="table-info">
                                                    <td colspan="2"><strong>{{ ucfirst(str_replace('_', ' ', $category)) }}</strong></td>
                                                </tr>
                                            @endif
                                            @foreach($categoryAssets as $asset)
                                                <tr>
                                                    <td>{{ $asset->account->code }} - {{ $asset->account->name }}</td>
                                                    <td class="text-end">${{ number_format($asset->closing_balance, 2) }}</td>
                                                </tr>
                                            @endforeach
                                            @if($category && $category !== 'other')
                                                <tr class="table-secondary">
                                                    <td class="text-end"><strong>Subtotal {{ ucfirst(str_replace('_', ' ', $category)) }}</strong></td>
                                                    <td class="text-end"><strong>${{ number_format($categoryAssets->sum('closing_balance'), 2) }}</strong></td>
                                                </tr>
                                            @endif
                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="2" class="text-center text-muted">No hay activos registrados</td>
                                        </tr>
                                    @endif
                                    <tr class="table-dark">
                                        <td><strong>TOTAL ACTIVOS</strong></td>
                                        <td class="text-end"><strong>${{ number_format($totalAssets, 2) }}</strong></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <div class="col-md-6">
                            <h5 class="text-center mb-3">PASIVOS Y PATRIMONIO</h5>
                            <table class="table table-bordered">
                                <thead class="table-dark">
                                    <tr>
                                        <th>Cuenta</th>
                                        <th class="text-end">Saldo</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if($liabilities->count() > 0)
                                        @php
                                            $groupedLiabilities = $liabilities->groupBy(function($item) {
                                                return $item->account->category ?? 'other';
                                            });
                                        @endphp
                                        @foreach($groupedLiabilities as $category => $categoryLiabilities)
                                            @if($category && $category !== 'other')
                                                <tr class="table-warning">
                                                    <td colspan="2"><strong>{{ ucfirst(str_replace('_', ' ', $category)) }}</strong></td>
                                                </tr>
                                            @endif
                                            @foreach($categoryLiabilities as $liability)
                                                <tr>
                                                    <td>{{ $liability->account->code }} - {{ $liability->account->name }}</td>
                                                    <td class="text-end">${{ number_format($liability->closing_balance, 2) }}</td>
                                                </tr>
                                            @endforeach
                                            @if($category && $category !== 'other')
                                                <tr class="table-secondary">
                                                    <td class="text-end"><strong>Subtotal {{ ucfirst(str_replace('_', ' ', $category)) }}</strong></td>
                                                    <td class="text-end"><strong>${{ number_format($categoryLiabilities->sum('closing_balance'), 2) }}</strong></td>
                                                </tr>
                                            @endif
                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="2" class="text-center text-muted">No hay pasivos registrados</td>
                                        </tr>
                                    @endif
                                    <tr class="table-dark">
                                        <td><strong>TOTAL PASIVOS</strong></td>
                                        <td class="text-end"><strong>${{ number_format($totalLiabilities, 2) }}</strong></td>
                                    </tr>
                                    @if($equity->count() > 0)
                                        @foreach($equity as $eq)
                                            <tr>
                                                <td>{{ $eq->account->code }} - {{ $eq->account->name }}</td>
                                                <td class="text-end">${{ number_format($eq->closing_balance, 2) }}</td>
                                            </tr>
                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="2" class="text-center text-muted">No hay patrimonio registrado</td>
                                        </tr>
                                    @endif
                                    <tr class="table-dark">
                                        <td><strong>TOTAL PATRIMONIO</strong></td>
                                        <td class="text-end"><strong>${{ number_format($totalEquity, 2) }}</strong></td>
                                    </tr>
                                    <tr class="table-dark">
                                        <td><strong>TOTAL PASIVOS Y PATRIMONIO</strong></td>
                                        <td class="text-end"><strong>${{ number_format($totalLiabilitiesEquity, 2) }}</strong></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>

                    <!-- Verificación de Balance -->
                    <div class="alert {{ abs($totalAssets - $totalLiabilitiesEquity) < 0.01 ? 'alert-success' : 'alert-danger' }} mt-4">
                        <strong>
                            @if(abs($totalAssets - $totalLiabilitiesEquity) < 0.01)
                                <i class="fas fa-check-circle"></i> Balance Verificado: Los activos coinciden con pasivos y patrimonio.
                            @else
                                <i class="fas fa-exclamation-triangle"></i> Desbalance Detectado: Diferencia de ${{ number_format(abs($totalAssets - $totalLiabilitiesEquity), 2) }}
                            @endif
                        </strong>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection