@extends('adminlte::page')

@section('title', 'Validación Recaudo externo')

@section('content_header')
    <h1>Validación recaudo externo Autoridades de Tránsito</h1>
@stop

@section('content')

 
    <section class="section">
        <div class="container">
                                                                           
                <div class="card"> 
                    
                    @if (session('mensaje'))
                    <div class="alert alert-success">
                        <strong>{{session('mensaje')}}</strong>
                    </div>
                    @endif
                
                    <div class="card header">
                        <a href="{{route('admin.validacionexterno.index')}}" class="btn btn-primary btn-sm">Regresar a filtro validacion recaudo externo</a>
                    </div>

                    <hr class="mx-n3">

                    <div class="card">
                        <div class="card-body">
                            <table id="example" class="table table-striped">
                                <thead>
                                        <tr>
                                            <th>Divipo</th>
                                            <th>Municipio</th>
                                            <th>Valor recaudos Acta</th>
                                            <th>Cantidad recaudos Acta</th>
                                            <th>Valor detalle recaudos</th>
                                            <th>Cantidad detalle recaudos</th>
                                            <th>Diferencia valor recaudos</th>
                                            <th>Valor consolidado recaudos</th>
                                            <th>Valor detalle transferencias</th>
                                            <th>Diferencia valor transferencias</th>
                                            <th></th>
                                        </tr>
                                </thead>
                                    <tbody>
                                        @foreach($validacionDistVsAct as $validacionDistVsAct)
                                            
                                            @foreach ($validacionActVsDist as $validacionActVsDist)

                                                @foreach($validacionTransVsConso as $validacionTransVsConso)

                                                    @foreach($validacionConsoVsTrans as $validacionConsoVsTrans)
                                                    <tr>
                                                        <td width="50px" style = "text-aling: left">{{ $validacionDistVsAct->divipo }}</td>
                                                        <td>{{ $validacionDistVsAct->municipio }}</td>
                                                        <td>{{ $validacionActVsDist->ValRecaudosActa }}</td>
                                                        <td>{{ $validacionActVsDist->CantRecActa }}</td>
                                                        <td>{{ $validacionDistVsAct->total }}</td>
                                                        <td>{{ $validacionDistVsAct->cantidad }}</td>
                                                        <td>{{ $validacionDistVsAct->total - $validacionActVsDist->ValRecaudosActa }}</td>
                                                        <td>{{ $validacionConsoVsTrans->consolidado }}</td>
                                                        <td>{{ $validacionTransVsConso->total2 }}</td>
                                                        <td>{{ $validacionConsoVsTrans->consolidado - $validacionTransVsConso->total2}}</td>
                                                        <td style="visibility:collapse; display:none;">{{ $validacionDistVsAct->emailOficial }}</td>
                                                        <td style="visibility:collapse; display:none;">{{ $validacionDistVsAct->periodo }}</td>
                                                        <td style="visibility:collapse; display:none;">{{ $validacionDistVsAct->ano }}</td>
                                                        <td>
                                                            <form action="{{route('admin.validacionexterno.reportmail'),$validacionDistVsAct->periodo,$validacionDistVsAct->ano}}" method="POST">
                                                                @csrf
                                                                <input type="text" value="{{$validacionDistVsAct->periodo}}" name="periodo" hidden>
                                                                <input type="text" value="{{$validacionDistVsAct->ano}}" name="ano" hidden>
                                                                <input type="text" value="{{$validacionDistVsAct->divipo}}" name="divipo" hidden>
                                                                <input type="text" value="{{$validacionDistVsAct->emailOficial}}" name="email" hidden>
                                                                <input type="text" value="{{$validacionDistVsAct->total - $validacionActVsDist->ValRecaudosActa}}" name="recaudo" hidden>
                                                                <input type="text" value="{{$validacionConsoVsTrans->consolidado - $validacionTransVsConso->total2}}" name="transferencia" hidden>
                                                                <button class="btn btn-warning btn-sm"><i class="bi bi-envelope-at"></i></button>
                                                            </form>
                                                        </td>
                                                    </tr>     
                                                    @endforeach

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

@stop

@section('css')

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.1/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bulma/0.9.3/css/bulma.min.css">

<link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
<link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/datatables-buttons/css/buttons.bootstrap4.min.css">

@endsection

@section('js')
    
<script defer src="https://use.fontawesome.com/releases/v5.3.1/js/all.js"></script>

<script src="https://adminlte.io/themes/v3/plugins/jquery/jquery.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="https://adminlte.io/themes/v3/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/jszip/jszip.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/pdfmake/pdfmake.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/pdfmake/vfs_fonts.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="https://adminlte.io/themes/v3/plugins/datatables-buttons/js/buttons.colVis.min.js"></script>

<script src="https://adminlte.io/themes/v3/dist/js/adminlte.min.js?v=3.2.0"></script>

<script>
        
    $(document).ready(function() {
        $('#adicional').DataTable(      
        {
            "languaje": {"search": "Buscar", "lengthmenu": "Mostrar _MENU_ registros por pagina", "info": "Mostrando página _PAGE_ de _PAGES_", 
            "paginate": {"previous": "Anterior", "next": "Siguiente", "first": "Primero", "last": "Ultimo"}
            }
        })
    });    
           
   
</script>

<script>
    $(function () {
      $("#example1").DataTable({
        "responsive": true, "lengthChange": false, "autoWidth": false,
        "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
      }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
      $('#example2').DataTable({
        "paging": true,
        "lengthChange": false,
        "searching": false,
        "ordering": true,
        "info": true,
        "autoWidth": false,
        "responsive": true,
      });
    });
</script>

@stop