@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;
$total = 0;
@endphp


<table id="table-category-{{ $policy->category_policy }}" class="table table-hover align-middle table-bordered">
    <thead>
            <tr>
                <th></th>
                <th></th>
                <th>Certificado - Nombre</th>
                <th>Suma Asegurada </th>
                <th>Gastos Funebres </th>
                <th>Suma Asegurada + Gastos Funebres</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>Total Gastos Médicos</th>
                <th>Total Médico y Vida</th>
            </tr>
    </thead>
    <tbody>
        @foreach ($padres_e_hijos as $policies_insurer)
            <tr>
                <td>
                    {{rvfj( json_encode(statusInsurers()), $policies_insurer->status)}}
                </td>
                <td>
                    @if($policies_insurer->titular == 1)
                        Titular
                    @endif
                </td>
                <td width="200px">{{--Nombre Completo--}}
                    {{$policies_insurer->certificate_id}} - {{$policies_insurer->name}}
                </td>
                <td>{{-- Suma Asegurada --}}
                    {{$policy->currency}} {{number_format($policies_insurer->sum_insurance, 2, '.', ',')}}
                </td>
                <td>{{-- Gastos Funebres --}}
                    {{$policy->currency}} {{number_format($policies_insurer->bill_died, 2, '.', ',')}}
                </td>
                <td>{{--Suma Asegurada + Gastos Funebres--}}
                    {{$policy->currency}} {{number_format($policies_insurer->sum_insurance_plus, 2, '.', ',')}}
                </td>
                <td>{{--Prima Vida--}}
                    {{$policy->currency}} {{number_format($policies_insurer->life_prima, 2, '.', ',')}}
                </td>
                <td>{{--Medico Empleado Solo--}}
                    {{$policy->currency}} {{number_format($policies_insurer->alone_medical, 2, '.', ',')}}
                </td>
                <td>{{--Medico 1 Dependiente--}}
                    {{$policy->currency}} {{number_format($policies_insurer->medical_one_dependient, 2, '.', ',')}}
                </td>
                <td>{{--Medico Grupo Familiar--}}
                    {{$policy->currency}} {{number_format($policies_insurer->medical_familiar_group, 2, '.', ',')}}
                </td>
                <td>{{--Medico Grupo Familiar--}}
                    {{$policy->currency}} {{number_format($policies_insurer->alone_dental, 2, '.', ',')}}
                </td>
                <td>{{--Dental Familiar--}}
                    {{$policy->currency}} {{number_format($policies_insurer->dental_familiar, 2, '.', ',')}}
                </td>
                <td>{{--Dental Dependientes--}}
                    {{$policy->currency}} {{number_format($policies_insurer->dental_dependients, 2, '.', ',')}}
                </td>
                <td>{{--Total Medico y Vida--}}
                    {{$policy->currency}} {{number_format($policies_insurer->total, 2, '.', ',')}}
                </td>
                <td>{{--Total gastos medicos--}}
                    {{$policy->currency}} {{number_format($policies_insurer->total + $policies_insurer->life_prima, 2, '.', ',')}}
                </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;
                            $total += $policies_insurer->total;
                        }
                @endphp
            </tr>
            @endforeach
            <tr style="border-top: 3px solid #a7a7a7;">
                <th colspan="3" ></th>
                <th>{{-- Suma Asegurada --}}
                    {{$policy->currency}} {{number_format($sum_insurance, 2, '.', ',')}}
                </th>
                <th>{{-- Gastos Funebres --}}
                    {{$policy->currency}} {{number_format($bill_died, 2, '.', ',')}}
                </th>
                <th>{{--Suma Asegurada + Gastos Funebres--}}
                    {{$policy->currency}} {{number_format($sum_insurance_plus, 2, '.', ',')}}
                </th>
                <th>{{--Prima Vida--}}
                    {{$policy->currency}} {{number_format($life_prima, 2, '.', ',')}}
                </th>
                <th>{{--Medico Empleado Solo--}}
                    {{$policy->currency}} {{number_format($alone_medical, 2, '.', ',')}}
                </th>
                <th>{{--Medico 1 Dependiente--}}
                    {{$policy->currency}} {{number_format($medical_one_dependient, 2, '.', ',')}}
                </th>
                <th>{{--Medico Grupo Familiar--}}
                    {{$policy->currency}} {{number_format($medical_familiar_group, 2, '.', ',')}}
                </th>
                <th>{{--Medico Grupo Familiar--}}
                    {{$policy->currency}} {{number_format($alone_dental, 2, '.', ',')}}
                </th>
                <th>{{--Dental Familiar--}}
                    {{$policy->currency}} {{number_format($dental_familiar, 2, '.', ',')}}
                </th>
                <th>{{--Dental Dependientes--}}
                    {{$policy->currency}} {{number_format($dental_dependients, 2, '.', ',')}}
                </th>
                <th>{{--Total Medico y Vida--}}
                    <strong>{{$policy->currency}} {{number_format($total, 2, '.', ',')}}</strong>
                </th>
                <th>{{--Total Medico y Vida--}}
                    <strong>{{$policy->currency}} {{number_format($total + $life_prima, 2, '.', ',')}}</strong>
                </th>
            </tr>
            <tr>
                <th colspan="14" style="text-align: right;">TOTAL </th>
                <th> {{$policy->currency}} {{number_format($life_prima + $total, 2, '.', ',')}}</th>
            </tr>
    </tbody>
</table>