@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col">

            <button class="btn btn-info" onclick="exportarExcel()">EXPORTAR TABLA EXCEL </button>
            <table class="table" id="table_id" data-page-length="15">
                <thead class="">
                    <tr>
                        <th>PACIENTE</th>
                        <th>TRATAMIENTO</th>
                        <th>DOCTOR</th>
                        <th>FECHA</th>
                        <th>ASISTENTE</th>

                    </tr>
                </thead>
                <tbody>

                    @foreach ($data as $item)
                    <tr>
                        <td>{{$item->paciente->nombre}} <br>

                            @if (searSalidaInsumo($item->paciente_id, $item->fecha) != null)
                            <span class="badge badge-info">SI REALIZADO</span>
                            @else
                            <span class="badge badge-danger">NO REALIZADO </span>


                            <a type="button" class="btn btn-success" href="{{route('tratamientos.desbloquear', $item->id)}}"><i class="fa fa-unlock" aria-hidden="true"></i></a>
                            @endif

                        </td>
                        <td>{{$item->tratamiento->nombre}} - {{$item->tratamiento->descripcion}}</td>
                        <td>{{$item->doctor->nombre}}</td>
                        <td>{{$item->fecha}}</td>
                        <td>{{$item->asistio}}</td>

                    </tr>
                    @endforeach

                </tbody>
            </table>




        </div>
    </div>
</div>
@endsection

@section('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.2/xlsx.full.min.js"></script>

<script>
    function exportarExcel() {
        var tabla = document.getElementById('table_id');
        var wb = XLSX.utils.table_to_book(tabla, {
            sheet: "Sheet1"
        });
        XLSX.writeFile(wb, "Total Tratamientos.xlsx");
    }
</script>

@endsection