@php
$sum_insurance = 0;
$bill_died = 0;
$sum_insurance_plus = 0;
$life_prima = 0;
$alone_medical = 0;
$medical_one_dependient = 0;
$medical_familiar_group = 0;
$alone_dental = 0;
$dental_familiar = 0;
$dental_dependients = 0;
$por_salud_dependient = 0;
$por_salud_alone_employee = 0;
$oftalmologic_help = 0;
$oftalmologic_help_dependient = 0;
$total = 0;
@endphp

<table>
    <thead>
        <tr>
            <th>Status</th>
            <th>Titular</th>
            <th>Certificado - Nombre</th>
            <th>Suma Asegurada</th>
            <th>Gastos Funebres</th>
            <th>Suma + Gastos</th>
            <th>Prima Vida</th>
            <th>Medico Empleado Solo</th>
            <th>Medico 1 Dependiente</th>
            <th>Medico Grupo Familiar</th>
            <th>Dental Empleado Solo</th>
            <th>Dental Familiar</th>
            <th>Dental Dependientes</th>
            <th>Porsalud Dependiente</th>
            <th>Porsalud Empleado Solo</th>
            <th>Ayuda Oftalmológica Titular</th>
            <th>Ayuda Oftalmológica Dependiente</th>
            <th>Total Gastos Médicos</th>
            <th>Total Médico + Vida</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($padres_e_hijos as $policies_insurer)
            <tr>
                <td>{{ rvfj(json_encode(statusInsurers()), $policies_insurer->status) }}</td>
                <td>{{ $policies_insurer->titular == 1 ? 'Titular' : '' }}</td>
                <td>{{ $policies_insurer->certificate_id }} - {{ $policies_insurer->name }}</td>

                <td>{{ $policies_insurer->sum_insurance }}</td>
                <td>{{ $policies_insurer->bill_died }}</td>
                <td>{{ $policies_insurer->sum_insurance_plus }}</td>
                <td>{{ $policies_insurer->life_prima }}</td>
                <td>{{ $policies_insurer->alone_medical }}</td>
                <td>{{ $policies_insurer->medical_one_dependient }}</td>
                <td>{{ $policies_insurer->medical_familiar_group }}</td>
                <td>{{ $policies_insurer->alone_dental }}</td>
                <td>{{ $policies_insurer->dental_familiar }}</td>
                <td>{{ $policies_insurer->dental_dependients }}</td>
                <td>{{ $policies_insurer->por_salud_dependient }}</td>
                <td>{{ $policies_insurer->por_salud_alone_employee }}</td>
                <td>{{ $policies_insurer->oftalmologic_help }}</td>
                <td>{{ $policies_insurer->oftalmologic_help_dependient }}</td>
                <td>{{ $policies_insurer->total }}</td>
                <td>{{ $policies_insurer->total + $policies_insurer->life_prima }}</td>

                @php
                    if($policies_insurer->titular == 1) {
                        $sum_insurance += $policies_insurer->sum_insurance;
                        $bill_died += $policies_insurer->bill_died;
                        $sum_insurance_plus += $policies_insurer->sum_insurance_plus;
                        $life_prima += $policies_insurer->life_prima;
                        $alone_medical += $policies_insurer->alone_medical;
                        $medical_one_dependient += $policies_insurer->medical_one_dependient;
                        $medical_familiar_group += $policies_insurer->medical_familiar_group;
                        $alone_dental += $policies_insurer->alone_dental;
                        $dental_familiar += $policies_insurer->dental_familiar;
                        $dental_dependients += $policies_insurer->dental_dependients;
                        $por_salud_dependient += $policies_insurer->por_salud_dependient;
                        $por_salud_alone_employee += $policies_insurer->por_salud_alone_employee;
                        $oftalmologic_help += $policies_insurer->oftalmologic_help;
                        $oftalmologic_help_dependient += $policies_insurer->oftalmologic_help_dependient;
                        $total += $policies_insurer->total;
                    }
                @endphp
            </tr>
        @endforeach

        {{-- Totales --}}
        <tr style="font-weight: bold;">
            <td colspan="3">Totales</td>
            <td>{{ $sum_insurance }}</td>
            <td>{{ $bill_died }}</td>
            <td>{{ $sum_insurance_plus }}</td>
            <td>{{ $life_prima }}</td>
            <td>{{ $alone_medical }}</td>
            <td>{{ $medical_one_dependient }}</td>
            <td>{{ $medical_familiar_group }}</td>
            <td>{{ $alone_dental }}</td>
            <td>{{ $dental_familiar }}</td>
            <td>{{ $dental_dependients }}</td>
            <td>{{ $por_salud_dependient }}</td>
            <td>{{ $por_salud_alone_employee }}</td>
            <td>{{ $oftalmologic_help }}</td>
            <td>{{ $oftalmologic_help_dependient }}</td>
            <td>{{ $total }}</td>
            <td>{{ $total + $life_prima }}</td>
        </tr>
    </tbody>
</table>