@extends('adminlte::page')

@section('title', 'Reporte de Tickets - Insertbog')

@section('content_header')
<div></div>

@section('content')
@if(auth()->check() && auth()->user()->clase === 'Inspector')
<section class="content">
    <div class="container">
        <div class="row">
            <div class="card-body">
                <form action="{{ route('statisticsReport') }}" method="get">
                    @csrf
                    <div class="col-md-12">
                        <div class="card card-success card-outline">
                            <div class="card-header">
                                <h3 class="card-title col-md-6">
                                    Estadisticas de Servicios
                                </h3>
                            </div>
                            <div class="row col-md-12 overflow-auto">
                                <div class="col-md-2">
                                    <label class="form-label" for="mes">Selecciona un mes: </label>
                                    <select class="form-select" name="month">
                                        <option></option>
                                        <option value="1">Enero</option>
                                        <option value="2">Febrero</option>
                                        <option value="3">Marzo</option>
                                        <option value="4">Abril</option>
                                        <option value="5">Mayo</option>
                                        <option value="6">Junio</option>
                                        <option value="7">Julio</option>
                                        <option value="8">Agosto</option>
                                        <option value="9">Septiembre</option>
                                        <option value="10">Octubre</option>
                                        <option value="11">Noviembre</option>
                                        <option value="12">Diciembre</option>
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label" for="año">Selecciona un año: </label>
                                    <select class="form-select" name="year" id="year">
                                        @for($i = date('Y'); $i >= 2019; $i--)
                                        <option value="{{ $i }}">{{ $i }}</option>
                                        @endfor
                                    </select>
                                </div>
                            </div>
                            <br>
                            <div class="card-footer">
                                <div class="col-md-12">
                                    <div class="d-flex justify-content-end">
                                        <button type="submit" id="agregar" class="btn btn-primary btn-circle" data-bs-toggle="tooltip" data-bs-placement="top" tabindex="3" title="Generar Reporte" value="Generate Report">Generar Reporte</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </form>
            </div>

            <div class="card-body">
                <div class="col-md-12">
                    <div class="card card-success card-outline">
                        <div class="card-header">
                            <h3 class="card-title col-md-6">Estadisticas de servicio <b>Mes {{ $month }}</b>, <b>Año {{ $year }}</b></h3>
                        </div>
                        <div class="card-body">
                            <br>
                            <div class="col-md-12">
                                <div class="row">
                                    @if(auth()->user()->clase == 'Inspector')
                                    <div class="col-md-3 col-sm-3 col-12">
                                        <div class="info-box shadow-lg">
                                            <span class="info-box-icon bg-dark">{{$abierto}}</span>
                                            <div class="info-box-content">
                                                <span class="info-box-text">Abiertos</span>

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-3 col-12">
                                        <div class="info-box shadow-lg">
                                            <span class="info-box-icon bg-danger">{{$enProceso}}</span>
                                            <div class="info-box-content">
                                                <span class="info-box-text">En Proceso</span>

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-3 col-12">
                                        <div class="info-box shadow-lg">
                                            <span class="info-box-icon bg-secondary">{{$revision}}</span>
                                            <div class="info-box-content">
                                                <span class="info-box-text">En Revisión</span>

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-3 col-12">
                                        <div class="info-box shadow-lg">
                                            <span class="info-box-icon bg-success">{{$cerrado}}</span>
                                            <div class="info-box-content">
                                                <span class="info-box-text">Cerrados</span>

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

                                    @endif
                                </div>
                                @if(auth()->user()->clase == 'Inspector')
                                <div class="row">
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th scope="col">Especialidad</th>
                                                    <th scope="col">Cant. Ticket</th>
                                                    <th scope="col">%</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($tipoTarea as $especialidad)
                                                <tr>
                                                    <td>{{ $especialidad->tipoTarea }}</td>
                                                    <td>{{ $especialidad->cantidad }}</td>
                                                    @if($total > 0)
                                                    <td>{{ round(($especialidad->cantidad / $total) * 100, 1) }}</td>
                                                    @else
                                                    0
                                                    @endif
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th scope="col">Técnicos</th>
                                                    <th class="center">Cant. Ticket</th>
                                                    <th scope="col">%</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($responsable as $responsable)
                                                <tr>
                                                    <td>{{ $responsable->responsable }}</td>
                                                    <td>{{ $responsable->cantidad }}</td>
                                                    @if($total > 0)
                                                    <td>{{ round(($responsable->cantidad / $total) * 100, 1) }}</td>
                                                    @else
                                                    0
                                                    @endif
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Tipo de Tarea</th>
                                                    <th>Producción</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($produccion as $tipo_tarea => $p)
                                                <tr>
                                                    <td>{{ $tipo_tarea }}</td>
                                                    <td>${{ $p }}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th scope="col">Generador por</th>
                                                    <th scope="col">Cant. Ticket</th>
                                                    <th scope="col">%</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($solicitadoPor as $solicitadoPor)
                                                <tr>
                                                    <td>{{ $solicitadoPor->solicitadoPor }}</td>
                                                    <td>{{ $solicitadoPor->cantidad }}</td>
                                                    @if($total > 0)
                                                    <td>{{ round(($solicitadoPor->cantidad / $total) * 100, 1) }}</td>
                                                    @else
                                                    0
                                                    @endif
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Ciudad</th>
                                                    <th>Cantidad de Tickets/Ciudad</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($tickets_por_ciudad as $ciudad => $cantidad)
                                                <tr>
                                                    <td>{{ $ciudad }}</td>
                                                    <td>{{ $cantidad }}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="col-md-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Zona</th>
                                                    <th>Cantidad de Tickets/Sector</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($tickets_por_zona as $sector => $cantidad)
                                                <tr>
                                                    <td>{{ $sector }}</td>
                                                    <td>{{ $cantidad }}</td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- <div class="col-md-6">
                <canvas id="myChart" width="400" height="400"></canvas>
            </div> -->
    </div>
</section>
@endif


@stop

@section('css')
<link rel="stylesheet" href="/css/admin_custom.css">
<link rel="stylesheet" href="{{asset('vendor/jquery-ui/jquery-ui.min.css')}}">
<link rel="stylesheet" href="{{asset('vendor/select2-bootstrap4-theme/select2-bootstrap4.css')}}">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bs-stepper/dist/css/bs-stepper.min.css" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.4/css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" href="https:////cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.4/css/dataTables.bootstrap5.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.0.1/css/bootstrap.min.css">
@stop

@section('js')
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="{{asset('vendor/jquery/jquery.min.js')}}"></script>
<script src="{{asset('vendor/jquery-ui/jquery-ui.min.js')}}"></script>
<script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bs-stepper/dist/js/bs-stepper.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.11.4/js/jquery.dataTables.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.print.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
<script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script src="https://cdn.jsdelivr.net/npm/chart.js@2.9.3/dist/Chart.min.js"></script>


<script>
    $(document).ready(function() {
        $('table.display').DataTable({
            dom: 'Bfrtip',
            stateSave: true,
            "language": {
                "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Spanish.json"
            },
            "columnDefs": [{
                    "targets": [2],
                    "visible": true,
                    "searchable": true
                },
                {
                    "targets": [3],
                    "visible": true,
                    "searchable": true
                }
            ],
            buttons: [
                'copy', 'excel', 'pdf', 'print'
            ]
        });

        $('#selectAsset').select2({
            dropdownParent: $('#creatTicket'),
            placeholder: "Selecciona un Asset",
            allowClear: true,
            theme: "classic",
            width: '100%'
        });
    });
</script>
@stop