@extends('layouts.reportes')

@section('styles')
<style>
   tr.stick {
      background: #b3d9b4;
      position: sticky;
      bottom: 0;

      box-shadow: 0 2px 2px -1px rgba(0, 0, 0, 0.4);
   }
</style>
@endsection

@section('content')

<p class="text-center text-uppercase h3">{{$name}}</p>



<table class="table" id="table_id" data-page-length="15">
    <thead class="thead">
        <tr>
            <th>NOMBRE</th>
            <th>GRADO</th>
            <th>INSCRIPCION</th>
            <th>BOLSA</th>
            <th>UNIFORME</th>
            <th>BUS</th>
            <th>COLEGIATURA</th>
            <th>DEDUDAS EXTRAS</th>
            <th>ACTIVIDADES</th>
            <th>TOTAL</th>
        </tr>
    </thead>
    <tbody>
        @php
        $deuda_cole = 0;
        $deuda_bus = 0;
        $deuda_bolsa = 0;
        $deuda_uniforme = 0;
        $deuda_insc = 0;
        $deuda_acti = 0;
        $deuda_ext = 0;
        $deuda_total = 0;
        @endphp
        @foreach ($estu as $estudiante)
        @php
        $cole = getDeudaToAboo('COLEGIATURA', $estudiante->id);
        $bus = getDeudaToAboo('BUS', $estudiante->id);
        $bolsa = getDeudaToAboo('BOLSA DE UTILES', $estudiante->id);
        $uniforme = getDeudaToAboo('UNIFORME', $estudiante->id);
        $insc = getDeudaToAboo('INSCRIPCION', $estudiante->id);
        $acti = getDeudaToAboo('ACTIVIDADES', $estudiante->id);
        $ext = getDeudaToAboo('DEUDA EXTRA', $estudiante->id);
        $total = $cole + $bus +$bolsa +$uniforme + $insc +$acti +$ext;
        $deuda_cole += $cole;
        $deuda_bus += $bus;
        $deuda_bolsa += $bolsa;
        $deuda_uniforme += $uniforme;
        $deuda_insc += $insc;
        $deuda_acti += $acti;
        $deuda_ext += $ext;
        $deuda_total += $total;

        $t_deuda = 0;


        @endphp

        
        @if ($t_deuda >= $minimo && $t_deuda <= $maximo) <tr>

            <td> <a href="{{route('estudiante.show', ['id' => $estudiante->id])}}" target="_blanck" class="btn btn-link">{{ $estudiante->nombre }}</a> </td>
            <td class="text-uppercase">{{ $estudiante->grado->codigo }} </td>
            <td>
                @if ( $insc > 0)
                Q. {{ number_format($insc, 2) }} <br>
                @endif
            </td>
            <td>
                @if ( $bolsa > 0 )
                Q. {{ number_format($bolsa, 2) }} <br>
                @endif
            </td>
            <td>
                @if ( $uniforme > 0)
                Q. {{ number_format($uniforme, 2) }} <br>
                @endif
            </td>
            <td>
                @if ( $bus > 0)
                Q. {{ number_format($bus, 2) }} <br>
                @endif
            </td>
            <td>
                @if ( $cole > 0)
                Q. {{ number_format($cole, 2) }} <br>
                @endif
            </td>
            <td>

                @if ( $ext > 0)
                Q. {{ number_format($ext, 2) }} <br>
                @endif
            </td>
            <td>
                @if ( $acti > 0)
                Q. {{ number_format($acti, 2) }} <br>
                @endif
            </td>

            </tr>
            @endif
            @endforeach

            <tr class="stick">
                <td></td>
                <td></td>
                <td>Inscripcion <br> Q. {{number_format($deuda_insc, 2)}}</td>
                <td>Bolsa <br> Q. {{number_format($deuda_bolsa, 2)}}</td>
                <td>Uniforme <br> Q. {{number_format($deuda_uniforme, 2)}}</td>
                <td>Bus <br> Q. {{number_format($deuda_bus, 2)}}</td>
                <td>Colegiatura <br> Q. {{number_format($deuda_cole, 2)}}</td>
                <td>Deuda Extra <br> Q. {{number_format($deuda_ext, 2)}}</td>
                <td>Actividades <br> Q. {{number_format($deuda_acti, 2)}}</td>
                <td>Q. {{number_format($deuda_total, 2)}}</td>
            </tr>


    </tbody>
</table>




@endsection