{{--Elaborado por Ivan Salazar
05-08-2018
--}}

@extends('layouts/master')
@section('header')

@endsection
@section('content')
    <div class="row">
        <div class="col-sm-13 col-xs-13 col-md-13 col-md-offset">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><span class="glyphicon glyphicon-th-list"></span> REPORTE DE LAS RECOLECTAS:</h3>
                </div>
                <div class="panel-body" >
                    <div class="center">
                        <label class="text-dark"><b> RECOLECTAS @if ($tiporecolect == "2") EVENTUALES @elseif($tiporecolect == "3") FIJAS @endif POR EFECTIVIDAD EN {{$title}}</b></label>
                        <br>
                        @if ($codcliente != "")
                            <label class="text-dark"><b> RECOLECTAS DEL CLIENTE: {{$codcliente}}</b></label>
                        @endif
                        <br>
                        <label for="codciudad" class="text-dark">
                            <b>DESDE: {{$desde}} HASTA: {{$hasta}}</b><br>
                        </label>

                    </div>
                    <div class="panel-body">
                        <div class="table-responsive">

                            <table style="margin-top: 1%; font-size: 96%;" class="table-striped table-bordered table-hover table-condensed table-condensed" id="datos">

                                <thead>
                                <tr>

                                    <td style="font-weight: bold;" class="text-center">Oficina</td>
                                    <td style="font-weight: bold;" class="text-center">Generadas</td>

                                    <td style="font-weight: bold;" class="text-center">Pendientes</td>
                                    <td class="text-center">%</td>
                                    <td style="font-weight: bold;" class="text-center @if ($status == 1 OR $status == 2) hidden @endif ">Estatus PK </td>
                                    <td class="text-center @if ($status == 1 OR $status == 2) hidden @endif ">%</td>
                                    <td style="font-weight: bold;" class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">Estatus NPK </td>
                                    <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">%</td>
                                    <td style="font-weight: bold;" class="text-center @if ($status == 1 OR $status == 3) hidden @endif ">Estatus NPKZ </td>
                                    <td class="text-center @if ($status == 1 OR $status == 3) hidden @endif ">%</td>
                                    <td style="font-weight: bold;" class="text-center @if ($status == 3 OR $status == 0) hidden @endif ">Reprogramadas</td>
                                    <td style="font-weight: bold;" class="text-center @if ($status == 3 OR $status == 0) hidden @endif ">%</td>
                                    <td style="font-weight: bold;" class="text-center">Efectividad <br>%</td>
                                    <td style="font-weight: bold;" class="text-center">Incumplimiento <br>%</td>
                                    <td style="font-weight: bold;" class="text-center">Realizada <br>%</td>
                                    <td style="font-weight: bold;" class="text-center">Pendiente <br>%</td>

                                </tr>


                                </thead>

                                <tbody class="text-center">


                                @php $totalgen = 0;
                            $totalpen = 0;
                            $cant =0;
                            $totalporcentod=0;
                            $totalrea=0;
                            $totalanu=0;
                            $totalanuz=0;
                            $totalrepro=0;
                                @endphp

                                @foreach($consultaReporte['entidadRespuesta'] as $recolecta)
                                    @php    $totalgen = $recolecta['total'] +$totalgen;
                            $totalpen = $recolecta['totalod'] +$totalpen;
                            $porcentod = number_format(((strtoupper($recolecta['totalod'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',');
                            $totalporcentod = $porcentod + $totalporcentod;
                            $cant = $cant + 1;
                            $totalrea = $recolecta['totalpkd'] +$totalrea;
                            $totalanu = $recolecta['totalnpk'] +$totalanu;
                            $totalanuz = $recolecta['totalnpkz'] +$totalanuz;
                            $totalrepo =  $recolecta['totalreprogramada'] + $totalrepro;

                                    @endphp



                                    <tr>

                                        <td style="width:10px;">{{ strtoupper($recolecta['oficina']) }}</td>
                                        <td >{{ strtoupper($recolecta['total']) }}</td>
                                        <td >{{ strtoupper($recolecta['totalod']) }}</td>
                                        <td>{{$porcentod}}</td>
                                        @if ($recolecta['totalpkd'] != 0)
                                            <td class="@if ($status == 1 OR $status == 2) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="codoficina" value="{{strtoupper($recolecta['codoficinaope'])}}">
                                                    <input type="hidden" name="status" value="0">
                                                    <input class="btn btn-link" style="font-weight: bold;" type="submit" name="submit" value={{strtoupper($recolecta['totalpkd']) }}>
                                                </form><p  style="display: none;">{{strtoupper($recolecta['totalpkd']) }}</p></td>
                                        @else
                                            <td class="@if ($status == 1 OR $status == 2) hidden @endif ">{{ strtoupper($recolecta['totalpkd']) }}</td>
                                        @endif
                                        <td class="@if ($status == 1 OR $status == 2) hidden @endif ">{{number_format(((strtoupper($recolecta['totalpkd'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>
                                        @if ($recolecta['totalnpk'] != 0)
                                            <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="codoficina" value="{{strtoupper($recolecta['codoficinaope'])}}">
                                                    <input type="hidden" name="status" value="1">
                                                    <input class="btn btn-link" style="font-weight: bold;" type="submit" name="submit" value={{strtoupper($recolecta['totalnpk']) }}>
                                                </form><p  style="display: none;">{{strtoupper($recolecta['totalnpk']) }}</p></td>
                                        @else
                                            <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">{{ strtoupper($recolecta['totalnpk']) }}</td>
                                        @endif
                                        <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">{{number_format(((strtoupper($recolecta['totalnpk'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>
                                        @if ($recolecta['totalnpkz'] != 0)
                                            <td class="text-center @if ($status == 1 OR $status == 3) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="codoficina" value="{{strtoupper($recolecta['codoficinaope'])}}">
                                                    <input type="hidden" name="status" value="2">
                                                    <input class="btn btn-link" style="font-weight: bold;" type="submit" name="submit" value={{strtoupper($recolecta['totalnpkz']) }}>
                                                </form><p  style="display: none;">{{strtoupper($recolecta['totalnpkz']) }}</p></td>
                                        @else
                                            <td class="text-center @if ($status == 1 OR $status == 3) hidden @endif ">{{ strtoupper($recolecta['totalnpkz']) }}</td>
                                        @endif
                                        <td class="@if ($status == 1 OR $status == 3) hidden @endif ">{{number_format(((strtoupper($recolecta['totalnpkz'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>

                                        @if ($status == 1 or $status == 2)
                                            <td>{{$recolecta['totalreprogramada']}}</td>
                                        @endif
                                        <td class="text-center @if ($status == 3 OR $status == 0) hidden @endif ">{{number_format(((strtoupper($recolecta['totalreprogramada'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>
                                        <td>{{number_format((100-(strtoupper($recolecta['totalnpkz'])* 100) / strtoupper($recolecta['total'])), 2, '.', ',') }}</td>
                                        <td>{{number_format(((strtoupper($recolecta['totalnpkz'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>
                                        <td>{{number_format(((strtoupper($recolecta['totalpkd'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>
                                        <td>{{number_format(((strtoupper($recolecta['totalod'])) * 100) / strtoupper($recolecta['total']), 2, '.', ',') }}</td>

                                    </tr>
                                @endforeach
                                @if ($title == 'TODAS LAS OFICINAS')
                                    <tfoot>
                                    <tr>

                                        <td class="text-right"><strong>TOTAL:</strong></td>
                                        <td id="total" class="text-center">{{$totalgen}}</td>
                                        <td  class="text-center">{{$totalpen}}</td>
                                        <td id ="pendientes" class="text-center">{{number_format(((($totalpen/$totalgen)* 100)), 2, '.', ',')  }}</td>
                                        @if ($totalrea != 0)
                                            <td class="text-center @if ($status == 1 OR $status == 2) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="codoficina" value="0">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="status" value="0">
                                                    <input class="btn btn-link " style="width: 100%;  font-weight: bold;" type="submit" name="submit" value={{$totalrea}}>
                                                </form><p style="display: none;">{{$totalrea }}</p></td>
                                        @else
                                            <td class="text-center @if ($status == 1 OR $status == 2) hidden @endif ">{{ $totalrea}}</td>
                                        @endif
                                        <td id="PK"  class="text-center @if ($status == 1 OR $status == 2) hidden @endif ">{{number_format(((($totalrea/$totalgen)* 100)), 2, '.', ',')  }}</td>
                                        @if ($totalanu != 0)
                                            <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="codoficina" value="0">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="status" value="1">
                                                    <input class="btn btn-link" style="width: 100%;  font-weight: bold;" type="submit" name="submit" value={{$totalanu}}>
                                                </form><p  style="display: none;">{{$totalanu }}</p></td>
                                        @else
                                            <td class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">{{ $totalanu}}</td>
                                        @endif
                                        <td id="NPK" class="text-center @if ($status == 2 OR $status == 3) hidden @endif ">{{number_format(((($totalanu/$totalgen) * 100)), 2, '.', ',')  }}</td>
                                        @if ($totalanuz != 0)
                                            <td class="text-center @if ($status == 1 OR $status == 3) hidden @endif "><form method="post" target="_blank" action="{{ route('listadoRecolectas') }}">
                                                    <input type="hidden" name="fechadesde" value="{{$fechadesde}}">
                                                    <input type="hidden" name="fechahasta" value="{{$fechahasta}}">
                                                    <input type="hidden" name="codcliente" value="{{$codcliente}}">
                                                    <input type="hidden" name="codoficina" value="0">
                                                    <input type="hidden" name="tiporecolect" value="{{$tiporecolect}}">
                                                    <input type="hidden" name="status" value="2">
                                                    <input class="btn btn-link" style="width: 100%; font-weight: bold;" type="submit" name="submit" value={{$totalanuz}}>
                                                </form><p style="display: none;">{{$totalanuz}}</p></td>
                                        @else
                                            <td  class="text-center @if ($status == 1 OR $status == 3) hidden @endif ">{{ $totalanuz}}</td>
                                        @endif
                                        <td id="NPKZ"  class="text-center @if ($status == 1 OR $status == 3) hidden @endif ">{{number_format(((($totalanuz/$totalgen) * 100)), 2, '.', ',')  }}</td>

                                        @if ($status == 1 or $status == 2)
                                            <td class="text-center">{{$totalrepro}}</td>

                                            <td class="text-center">{{number_format(((($totalrepro/$totalgen)* 100)), 2, '.', ',')  }}</td>

                                        @endif
                                        <td class="text-center">{{number_format(100-((($totalanuz/$totalgen)* 100)), 2, '.', ',')  }}</td>
                                        <td class="text-center">{{number_format(((($totalanuz/$totalgen)* 100)), 2, '.', ',')  }}</td>
                                        <td class="text-center">{{number_format(((($totalrea/$totalgen)* 100)), 2, '.', ',')  }}</td>
                                        <td class="text-center">{{number_format(((($totalpen/$totalgen)* 100)), 2, '.', ',')  }}</td>

                                    </tr>

                                    </tfoot>


                                    @endif
                                    </tbody>
                            </table>
                            <div class="col-sm-8 col-xs-8 col-md-8 col-md-offset-3">
                                <div class="col-md-8">
                                    <canvas id="pie-chart"></canvas>
                                </div>
                            </div>
                        </div>
                        <a href="{{ route('reportes') }}" class="btn btn-info">Volver
                            <span class="glyphicon glyphicon-circle-arrow-left"></span>
                        </a>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection

@section('script')
    <script type="text/javascript" src="{!! asset('/js/jquery-ui.min.js') !!}"></script>
    <script type="text/javascript" src="{!! URL::asset('/js/datatables2.min.js')  !!}"></script>
    <script type="text/javascript" src="{!! URL::asset('/js/jszip.min.js')  !!}"></script>
    <script type="text/javascript" src="{!! URL::asset('/js/Chart.js')  !!}"></script>
    <!-- <script type="text/javascript" src="{!! URL::asset('/js/dataTables.buttons.min.js')  !!}"></script>-->
   <!-- <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>-->


    <script>
        var pendientes = document.getElementById("pendientes").innerHTML;
        var PK = document.getElementById("PK").innerHTML;
        var NPK = document.getElementById("NPK").innerHTML;
        var NPKZ = document.getElementById("NPKZ").innerHTML;
        new Chart ( document . getElementById ( "pie-chart" ),
            { type : 'pie' , data :
                    { labels : [ "PENDIENTES: ".concat(pendientes).concat('%')  ,"ESTATUS PK: ".concat(PK).concat('%') , "ESTATUS NPK: ".concat(NPK).concat('%'), "ESTATUS NPKZ: ".concat(NPKZ).concat('%')],
                        datasets : [{
                            label : "Population (millions)" ,
                            backgroundColor : [ "#428bca" , "#5cb85c" , "#d9534f", "#FF8C00"],
                            data : [ pendientes, PK , NPK, NPKZ]
                        }] },
                options : {
                    title : { display : true , text : 'EFECTIVIDAD DE RECOLECTAS %'}
                }
            });
    </script>
    <script>

        $(document).ready(function () {

            var t = $('#datos').DataTable({
                "searching": false,
                columnDefs: [{
                    "searchable": false,
                    "orderable": false,
                    "targets": 0
                }],
                order: [[0, 'asc']],
                dom: 'Bfrtip',

                buttons : [
                    {
                        extend : 'print',
                        text: 'Imprimir',
                        footer: true,
                        title: 'Imprimir Tabla',

                    },

                    {
                        extend : 'excel',
                        text: 'Exportar a Excel',
                        footer: true,
                        title: 'Reporte por Efectividad',

                    },
                ],

                pageLength: 15,
                language: {
                    "processing": "Procesando...",
                    "lengthMenu": "Mostrar _MENU_ registros",
                    "zeroRecords": "No se encontraron resultados",
                    "emptyTable": "Ningún dato disponible en esta tabla",
                    "info": "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
                    "infoEmpty": "Mostrando registros del 0 al 0 de un total de 0 registros",
                    "infoFiltered": "(filtrado de un total de _MAX_ registros)",
                    "infoPostFix": "",
                    "search": "Búsqueda:",
                    "url": "",
                    "infoThousands": ",",
                    "loadingRecords": "Cargando...",
                    "paginate": {
                        "first": "Primero",
                        "last": "Último",
                        "next": "Siguiente",
                        "previous": "Anterior"
                    }
                }

            });

            t.on('order.dt', function () {
                t.column(0, {search: 'applied', order: 'applied'}).nodes();
            }).draw();
        });
    </script>
    <script>
        $('form').append('{!! csrf_field() !!}');
    </script>
@endsection