@extends('layouts.admin')
@section('styles')
<link rel="stylesheet" href="{{asset('plugins/datatable/css/dataTables.bootstrap4.min.css')}}">
<style>
   body {
      zoom: 70%;
   }
</style>
@endsection

@section('content')

@php
$t_abono = 0;
$t_caja = 0;
$t_gasto = 0;
@endphp

<div class="container-fluid">

   <div class="row">
      <div class="col">
         <p>
            <button class="btn btn-primary" type="button" data-toggle="collapse" data-target="#filtros" aria-expanded="false" aria-controls="filtros">
               FILTRAR POR FECHAS
            </button>
         </p>
         <div class="collapse" id="filtros">
            <form action="" method="get">
               <div class="form-group">
                  <label for=""> (Fecha de Inicio): </label>
                  <input type="date" class="form-control" name="inicio" placeholder="Fecha de Inicio" required>
               </div>

               <div class="form-group">
                  <label for=""> (Fecha de Final): </label>
                  <input type="date" class="form-control" name="fin" placeholder="Fecha de Fin" required>
               </div>

               <button type="submit" class="btn btn-success"><i class="fa fa-search" aria-hidden="true"></i> BUSCAR</button>
            </form>
         </div>
      </div>
   </div>

   <div class="row">
      <div class="col">
         <div class="card">
            <div class="card-body">
               <h4 class="card-title">ABONOS REALIZADOS</h4>
               <table class="table  table-sm" id="table_id">
                  <thead class="thead">
                     <tr>
                        <th>REC. / FECH.</th>
                        <th>ESTU.</th>
                        <th>VALOR</th>
                        <th></th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach ($data as $estudiante)
                                          <tr>
                        <td style="font-size: 12px;">#{{ $estudiante->id }} / <br>{{$estudiante->created_at->toFormattedDateString()}} <br> ({{$estudiante->user->name}}) </td>
                        <td style="font-size: 12px;">{{ $estudiante->estudiante->nombre }}</td>
                        <td style="font-size: 12px;">Q. {{ number_format($estudiante->valor, 2) }} <br> ({{$estudiante->tipo}}) </td>
                        <td>
                           <a href="{{route('abono.printRecibo', ['fecha' => $estudiante->created_at, 'factura' => $estudiante->factura_id, 'estudiante' => $estudiante->estudiante_id ])}}" class="btn btn-info btn-sm" target="_blank"><i class="fas fa-receipt    "></i> </a>
                        </td>
                     </tr>
                     @endforeach
                  </tbody>
               </table>


               <p class="text-center h5">USUARIOS QUE ABONARON</p>

               <table class="table">
                  <thead>
                     <tr>
                        @foreach ($user_Abonos as $us)
                        <th>{{$us->name}}</th>
                        @endforeach
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        @foreach ($user_Abonos as $us)
                        <td>Q. {{number_format($us->total, 2)}}</td>
                        @endforeach
                     </tr>
                  </tbody>
               </table>

            </div>
         </div>
      </div>
   </div>

   <div class="row">
      <div class="col">
         <div class="card">
            <div class="card-body">
               <h4 class="card-title">GASTOS</h4>
               <table class="table  table-sm" id="table_id">
                  <thead class="thead">
                     <tr>
                        <th> FECH.</th>
                        <th>DESCRIPCION.</th>
                        <th>VALOR</th>
                        <th>USUARIO</th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach ($gastos as $data)
                                          <tr>
                        <td>{{$data->created_at->toFormattedDateString()}}</td>
                        <td>{{$data->descripcion}}, {{$data->user->name}}</td>
                        <td>Q. {{number_format($data->valor, 2)}}</td>
                        <td>{{$data->user->name}}</td>
                     </tr>
                     @endforeach
                  </tbody>
               </table>
            </div>
         </div>
      </div>
   </div>

   <div class="row">
      <div class="col">
         <div class="card">
            <div class="card-body">
               <h4 class="card-title">CAJA CHICA</h4>
               <table class="table  table-sm" id="table_id">
                  <thead class="thead">
                     <tr>
                        <th> FECH.</th>
                        <th>DESCRIPCION.</th>
                        <th>VALOR</th>
                        <th>USUARIO</th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach ($entradas as $data)
                                          <tr>
                        <td>{{$data->created_at->toFormattedDateString()}}</td>
                        <td>{{$data->descripcion}}, {{$data->user->name}}</td>
                        <td>Q. {{number_format($data->valor, 2)}}</td>
                        <td>{{$data->user->name}}</td>

                     </tr>
                     @endforeach
                  </tbody>
               </table>
            </div>
         </div>
      </div>
   </div>

   <div class="row">
      <div class="col">
         <div class="card">
            <div class="card-body">
               <p>
                  <a class="btn btn-primary" data-toggle="collapse" href="#TOTALES" aria-expanded="false" aria-controls="TOTALES">
                     TOTALES
                  </a>
               </p>
               <div class="collapse" id="TOTALES">
                  <h4 class="card-title">TOTALES</h4>
                  <p class="card-text">ABONOS: Q. {{number_format($t_abono, 2)}}</p>
                  <p class="card-text">GASTOS: Q. {{number_format($t_gasto, 2)}}</p>
                  <p class="card-text">CAJA CHICA: Q. {{number_format($t_caja, 2)}}</p>
               </div>
            </div>
         </div>
      </div>
   </div>
</div>

@endsection

@section('scripts')
<script src="{{asset('plugins/datatable/js/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('plugins/datatable/js/dataTables.bootstrap4.min.js')}}"></script>

<script>
   // $(document).ready(function() {
   //    $('#table_id').DataTable({
   //       "language": {
   //          'info': '_TOTAL_ REGISTROS',
   //          'search': 'BUSCAR',
   //          'paginate': {
   //             'next': 'SIGUIENTE',
   //             'previous': 'ATRAS'
   //          },
   //          'loadingRecords': 'CARGANDO',
   //          'emptyTable': 'NO EXISTEN DATOS',
   //          'zeroRecords': 'NO EXISTEN DATOS IGUALES'
   //       },
   //       "order": [
   //          [1, "desc"]
   //       ]

   //    });
   // });
</script>
@endsection