@isset($exportar)
    @php    
        echo pack("CCC",0xef,0xbb,0xbf); // BOM para UTF-8 en Excel
        header("Cache-Control: maxage=1");
        header("Pragma: public");
        header('Content-type: application/vnd.ms-excel');
        header("Content-Disposition: attachment; filename=Balance_Prueba.xls");
        header("Pragma: no-cache");
        header("Expires: 0");    
    @endphp
@endisset

@isset($Balance)
@php
    $fmt = function($val) {
        $rounded = round($val, 2);
        if (request()->has('exportar')) {
            return sprintf("%.2f", $rounded);
        }
        return number_format($rounded, 0, ',', '.');
    };
    $numStyle = request()->has('exportar') ? 'style="mso-number-format:\'\#\,\#\#0\.00\';"' : '';
    $decStyle = 'style="mso-number-format:\'0\.00\';"'; // Para la columna C
    
    $tipoBalance = $tipoBalance ?? 'prueba';
    $titulo = ($tipoBalance == 'general') ? 'ESTADO DE SITUACIÓN FINANCIERA (BALANCE GENERAL)' : 'BALANCE DE PRUEBA';
@endphp

<div class="row">
    <div class="col-12 text-center mb-4">
        <h2 class="fw-bold text-uppercase" style="color: #2c3e50;">{{ $titulo }}</h2>
        <p class="mb-0 text-muted">Periodo: {{ $fi }} al {{ $ff }}</p>
    </div>

    <table class="table table-striped table-bordered" style="margin-top: 3%" id="tablep">
        <thead class="table-dark">
            <tr>
                <th class="text-center">T</th>
                <th class="text-center">C</th>
                <th>CUENTA</th>
                <th>NOMBRE CUENTA</th>
                
                @if($tipoBalance == 'prueba')
                    <th class="text-end">Saldo Inicial</th>
                    <th class="text-end">Débitos</th>
                    <th class="text-end">Créditos</th>
                    <th class="text-end">Saldo Final</th>
                @else
                    <th class="text-end">VALOR</th>
                @endif
            </tr>
        </thead>
        <tbody>
            @foreach ($Balance as $b)
                @php
                    $rowClass = '';
                    $indent = '';
                    
                    if ($b->t == 'Clase') { 
                        $rowClass = 'table-primary fw-bold'; 
                        $indent = '';
                    } elseif ($b->t == 'Grupo') { 
                        $rowClass = 'table-info fw-bold'; 
                        $indent = '&nbsp;&nbsp;&nbsp;';
                    } elseif ($b->t == 'Cuenta') { 
                        $rowClass = 'table-light fw-bold text-primary'; 
                        $indent = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                    } elseif ($b->t == 'Subcuenta') { 
                        $rowClass = 'fw-semibold text-secondary';
                        $indent = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                    } else {
                        $indent = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                    }
                @endphp
                <tr class="{{ $rowClass }}">
                    <td class="text-center small">{{ $b->t }}</td>
                    <td class="text-center small" {!! $decStyle !!}>{{ $b->c }}</td>
                    <td style="mso-number-format:'@';">
                        @if($b->t == 'Auxiliar') &nbsp;&nbsp;&nbsp;&nbsp; @endif {{ $b->cuentaNum }}
                    </td>
                    <td>{!! $indent !!} {{ $b->NombreCuenta }}</td>
                    
                    @if($tipoBalance == 'prueba')
                        <td class="text-end @if($b->saldo_inicial < 0) text-danger @endif" {!! $numStyle !!}>
                            {{ $fmt($b->saldo_inicial) }}
                        </td>
                        <td class="text-end" {!! $numStyle !!}>{{ $fmt($b->debito) }}</td>
                        <td class="text-end" {!! $numStyle !!}>{{ $fmt(abs($b->credito)) }}</td>
                        <td class="text-end @if($b->saldo_final < 0) text-danger @endif" {!! $numStyle !!}>
                            {{ $fmt($b->saldo_final) }}
                        </td>
                    @else
                        @php
                            // Inversión de Naturaleza para Pasivo y Patrimonio
                            $clase = substr($b->cuentaNum, 0, 1);
                            $valorFinal = $b->saldo_final;
                            if (in_array($clase, ['2', '3'])) {
                                $valorFinal = -$b->saldo_final;
                            }
                        @endphp
                        <td class="text-end fw-bold @if($valorFinal < 0) text-danger @endif" {!! $numStyle !!}>
                            {{ $fmt($valorFinal) }}
                        </td>
                    @endif
                </tr>
            @endforeach
        </tbody>
        <tfoot>
            <tr class="table-dark fw-bold">
                <td colspan="4" class="text-end">
                    @if($tipoBalance == 'prueba') 
                        TOTAL SUMA CLASES 1-9 (NETO) 
                    @else 
                        DIFERENCIA (ACTIVO - PASIVO - PATRIMONIO) 
                    @endif
                </td>
                
                @if($tipoBalance == 'prueba')
                    @php $clases = $Balance->where('t', 'Clase'); @endphp
                    <td class="text-end" {!! $numStyle !!}>{{ $fmt($clases->sum('si_c') / 100) }}</td>
                    <td class="text-end" {!! $numStyle !!}>{{ $fmt($clases->sum('deb_c') / 100) }}</td>
                    <td class="text-end" {!! $numStyle !!}>{{ $fmt($clases->sum('cre_c') / 100) }}</td>
                    <td class="text-end" {!! $numStyle !!}>{{ $fmt($clases->sum('sf_c') / 100) }}</td>
                @else
                    @php $sf_total = $Balance->where('t', 'Clase')->sum('sf_c'); @endphp
                    <td class="text-end" {!! $numStyle !!}>
                        {{ $fmt($sf_total / 100) }}
                    </td>
                @endif
            </tr>
        </tfoot>
    </table>
</div>
@endisset