{{--
Elaborado por Yoniquer Chacon

01-08-2018
--}}

@extends('layouts/master')
@section('header')
    <style> .dataTables_filter {
            width: 50%;
            float: right;
            text-align: right;
        }</style>

@endsection
@section('content')

<div class="row">
        <div class="col-sm-14 col-xs-14 col-md-14 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 EVENTUALES REALIZADAS POR OFICINAS</b></label>
                        <br>
                        <label for="codciudad" class="text-dark">
                                <b>{{$title}}</b>
                        </label>
                        <br>
                        <label for="codciudad" class="text-dark">
                            <b>FECHA DESDE: {{$desde}} HASTA: {{$hasta}}</b><br>
                        </label>
                 </div>


                    <ul class="nav nav-tabs" role="tablist">
                        <li role="presentation" class="active">
                            <a href="#ConGuia" aria-controls="detail" role="tab" data-toggle="tab">
                                <!-- Informaci&oacute;n del Cliente -->Con Guia Generada (activas)
                            </a>
                        </li>
                        <li role="presentation" {{--class="active"--}}>
                            <a href="#Pendientes" onclick="DataTable('#datos2')" aria-controls="Canceladas" role="tab" data-toggle="tab">
                                <!-- Gu&iacute;as y Facturas Canceladas -->Pendiente por generar
                            </a>
                        </li>
                        <li role="presentation" {{--class="active"--}}>
                            <a href="#IngresadasD" onclick="DataTable('#datos3')" aria-controls="Canceladas" role="tab" data-toggle="tab">
                                <!-- Gu&iacute;as y Facturas Canceladas -->Ingresadas Después de generar
                            </a>
                        </li>
                        <li role="presentation" {{--class="active"--}}>
                            <a href="#Anuladas" onclick="DataTable('#datos4')" aria-controls="Canceladas" role="tab" data-toggle="tab">
                                <!-- Gu&iacute;as y Facturas Canceladas -->Anuladas
                            </a>
                        </li>
                    </ul>
                    <div class="tab-content">
                        <div role="tabpanel" class="tab-pane fade active in" id="ConGuia">
                            <div class="panel-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-bordered table-hover table-condensed" id="datos"  style="font-size: 85%">
                                        <thead>
                                        <tr>
                                            <th class="text-center">°Nro</th>
                                            <th class="text-center"># Recolecta</th>
                                            <th class="text-center">Cod Cli</th>
                                            <th class="text-center">Nombre Cliente </th>
                                            <th class="text-center">Contacto</th>
                                            <th class="text-center">Tipo</th>
                                            <th class="text-center">Direcci&oacute;n</th>
                                            <th class="text-center">Ruta</th>
                                            <th class="text-center">Vehiculo</th>
                                            <th class="text-center">Guia Gen</th>
                                            <th class="text-center">Guia E</th>
                                            <th class="text-center">Estatus</th>
                                            <th class="text-center">Causal</th>
                                            <th class="text-center">Detalle</th>

                                        </tr>
                                        </thead>
                                        <tfoot></tfoot>
                                        <tbody class="text-center">

                                        @php

                                         $contar = 1;

                                        @endphp
                                        @foreach($consultaReporte['entidadRespuesta'] as $recolecta)
                                            @if($recolecta['inactivo'] == false AND $recolecta['codguia']!= NULL AND $recolecta['modificadocli'] == 0 AND $recolecta['modificadorec'] == 0 AND $recolecta['modificadocas'] == 0)
                                                <tr style=" background: #A9CCE3">
                                                    <td>@php echo $contar; @endphp</td>
                                                    <td>{{ strtoupper($recolecta['codrecolectadir']) }}</td>
                                                    <td>{{ strtoupper($recolecta['codcliente']) }}</td>
                                                    <td>{{ strtoupper($recolecta['nombrecli']) }}</td>
                                                    <td>{{ strtoupper($recolecta['contacto']) }}</td>
                                                    <td>{{ strtoupper($recolecta['tipo']) }}</td>
                                                    <td>{{ strtoupper($recolecta['direccion']) }}</td>
                                                    <td>{{ strtoupper($recolecta['numerorut']) }}</td>
                                                    <td>{{ strtoupper($recolecta['nombre']) }}</td>
                                                    <td>{{ strtoupper($recolecta['codguia']) }}</td>
                                                    <td>
                                                        @if(empty($recolecta['recolectage']))
                                                            {{ strtoupper('NO') }}
                                                        @else
                                                            {{ strtoupper('SI') }}
                                                        @endif
                                                    </td>
                                                    <td>{{ strtoupper($recolecta['siglas']) }}</td>
                                                    <td>{{ strtoupper($recolecta['causal']) }}</td>
                                                    <td>
                                                        <a href="{{ route('trackingRecolecta', ['codrecolecra' => $recolecta['codrecolectadir']])}}" class="btn btn-success" target="_blank" name="detalle" id="detalle" title="Detalle Recolecta">
                                                            <span class="glyphicon glyphicon-search"></span>
                                                        </a>
                                                    </td>
                                                </tr>
                                            @endif
                                            @php $contar++;@endphp
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                    </div>
                        <div role="tabpanel" class="tab-pane fade" id="Pendientes">
                            <div class="panel-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-bordered table-hover table-condensed" id="datos2"  style="font-size: 85%">
                                        <thead>
                                        <tr>
                                            <th class="text-center">°Nro</th>
                                            <th class="text-center"># Recolecta</th>
                                            <th class="text-center">Cod Cli</th>
                                            <th class="text-center">Nombre Cliente </th>
                                            <th class="text-center">Contacto</th>
                                            <th class="text-center">Tipo</th>
                                            <th class="text-center">Direcci&oacute;n</th>
                                            <th class="text-center">Ruta</th>
                                            <th class="text-center">Vehiculo</th>
                                            <th class="text-center">Guia Gen</th>
                                            <th class="text-center">Guia E</th>
                                            <th class="text-center">Estatus</th>
                                            <th class="text-center">Causal</th>
                                            <th class="text-center">Detalle</th>

                                        </tr>
                                        </thead>
                                        <tfoot></tfoot>
                                        <tbody class="text-center">

                                        @php

                                            $contar = 1;

                                        @endphp
                                        @foreach($consultaReporte['entidadRespuesta'] as $recolecta)
                                            @if($recolecta['inactivo'] == false AND $recolecta['codguia'] == NULL AND $recolecta['modificadocli'] == 0 AND $recolecta['modificadorec'] == 0 AND $recolecta['modificadocas'] == 0)
                                                <tr style=" background: #F9F9F9">
                                                    <td>@php echo $contar; @endphp</td>
                                                    <td>{{ strtoupper($recolecta['codrecolectadir']) }}</td>
                                                    <td>{{ strtoupper($recolecta['codcliente']) }}</td>
                                                    <td>{{ strtoupper($recolecta['nombrecli']) }}</td>
                                                    <td>{{ strtoupper($recolecta['contacto']) }}</td>
                                                    <td>{{ strtoupper($recolecta['tipo']) }}</td>
                                                    <td>{{ strtoupper($recolecta['direccion']) }}</td>
                                                    <td>{{ strtoupper($recolecta['numerorut']) }}</td>
                                                    <td>{{ strtoupper($recolecta['nombre']) }}</td>
                                                    <td>{{ strtoupper($recolecta['codguia']) }}</td>
                                                    <td>
                                                        @if(empty($recolecta['recolectage']))
                                                            {{ strtoupper('NO') }}
                                                        @else
                                                            {{ strtoupper('SI') }}
                                                        @endif
                                                    </td>
                                                    <td>{{ strtoupper($recolecta['siglas']) }}</td>
                                                    <td>{{ strtoupper($recolecta['causal']) }}</td>
                                                    <td>
                                                        <a href="{{ route('trackingRecolecta', ['codrecolecra' => $recolecta['codrecolectadir']])}}" class="btn btn-success" target="_blank" name="detalle" id="detalle" title="Detalle Recolecta">
                                                            <span class="glyphicon glyphicon-search"></span>
                                                        </a>
                                                    </td>
                                                </tr>
                                            @endif
                                            @php $contar++;@endphp
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                        <div role="tabpanel" class="tab-pane fade" id="IngresadasD">
                            <div class="panel-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-bordered table-hover table-condensed" id="datos3" style="font-size: 85%">
                                        <thead>
                                        <tr>
                                            <th class="text-center">°Nro</th>
                                            <th class="text-center"># Recolecta</th>
                                            <th class="text-center">Cod Cli</th>
                                            <th class="text-center">Nombre Cliente </th>
                                            <th class="text-center">Contacto</th>
                                            <th class="text-center">Tipo</th>
                                            <th class="text-center">Direcci&oacute;n</th>
                                            <th class="text-center">Ruta</th>
                                            <th class="text-center">Vehiculo</th>
                                            <th class="text-center">Guia Gen</th>
                                            <th class="text-center">Guia E</th>
                                            <th class="text-center">Estatus</th>
                                            <th class="text-center">Causal</th>
                                            <th class="text-center">Detalle</th>

                                        </tr>
                                        </thead>
                                        <tfoot></tfoot>
                                        <tbody class="text-center">
                                        @php
                                            $valor = 1;
                                        
                                        @endphp

                                        @foreach($consultaReporte['entidadRespuesta'] as $recolecta)
                                            @if($recolecta['modificadorec'] == 1 or $recolecta['modificadocli'] == 1 or $recolecta['modificadocas'] == 1)
                                                @if($recolecta["inactivo"] == false)
                                                    <tr style="@if($recolecta["inactivo"] == TRUE)
                                                    @if($recolecta['codguia'] != null or $recolecta['codguia'] == null) background: #E6B0AA;
                                                    @endif
                                                    @elseif($recolecta['codguia'] != Null and $recolecta['modificadorec'] == 0 and $recolecta['modificadocli'] == 0 and $recolecta['modificadocas'] == 0 ) background: #A9CCE3;
                                                    @elseif( $recolecta['modificadorec'] == 1 or $recolecta['modificadocli'] == 1 or $recolecta['modificadocas'] == 1)
                                                    @if($recolecta['inactivo'] == false) background: #00a4a4;
                                                    @endif
                                                    @else background: #F9F9F9;
                                                    @endif">
                                                        <td>@php echo $contar; @endphp</td>
                                                        <td>{{ strtoupper($recolecta['codrecolectadir']) }}</td>
                                                        <td>{{ strtoupper($recolecta['codcliente']) }}</td>
                                                        <td>{{ strtoupper($recolecta['nombrecli']) }}</td>
                                                        <td>{{ strtoupper($recolecta['contacto']) }}</td>
                                                        <td>{{ strtoupper($recolecta['tipo']) }}</td>
                                                        <td>{{ strtoupper($recolecta['direccion']) }}</td>
                                                        <td>{{ strtoupper($recolecta['numerorut']) }}</td>
                                                        <td>{{ strtoupper($recolecta['nombre']) }}</td>
                                                        <td>{{ strtoupper($recolecta['codguia']) }}</td>
                                                        <td>
                                                            @if(empty($recolecta['recolectage']))
                                                                {{ strtoupper('NO') }}
                                                            @else
                                                                {{ strtoupper('SI') }}
                                                            @endif
                                                        </td>
                                                        <td>{{ strtoupper($recolecta['siglas']) }}</td>
                                                        <td>{{ strtoupper($recolecta['causal']) }}</td>
                                                        <td>
                                                            <a href="{{ route('trackingRecolecta', ['codrecolecra' => $recolecta['codrecolectadir']])}}" class="btn btn-success" target="_blank" name="detalle" id="detalle" title="Detalle Recolecta">
                                                                <span class="glyphicon glyphicon-search"></span>
                                                            </a>
                                                        </td>
                                                        @php $valor++; @endphp
                                                    </tr>
                                                @endif

                                            @endif
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                        <div role="tabpanel" class="tab-pane fade" id="Anuladas">
                            <div class="panel-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-bordered table-hover table-condensed" id="datos4" style="font-size: 85%">
                                        <thead>
                                        <tr>
                                            <th class="text-center">°Nro</th>
                                            <th class="text-center"># Recolecta</th>
                                            <th class="text-center">Cod Cli</th>
                                            <th class="text-center">Nombre Cliente </th>
                                            <th class="text-center">Contacto</th>
                                            <th class="text-center">Tipo</th>
                                            <th class="text-center">Direcci&oacute;n</th>
                                            <th class="text-center">Ruta</th>
                                            <th class="text-center">Vehiculo</th>
                                            <th class="text-center">Guia Gen</th>
                                            <th class="text-center">Guia E</th>
                                            <th class="text-center">Estatus</th>
                                            <th class="text-center">Causal</th>
                                            <th class="text-center">Detalle</th>

                                        </tr>
                                        </thead>
                                        <tfoot></tfoot>
                                        <tbody class="text-center">
                                        @php
                                            $valor = 1;

                                        @endphp

                                        @foreach($consultaReporte['entidadRespuesta'] as $recolecta)
                                            @if($recolecta['inactivo'] == TRUE)
                                                    <tr style="@if($recolecta["inactivo"] == TRUE)
                                                    @if($recolecta['codguia'] != null or $recolecta['codguia'] == null) background: #E6B0AA;
                                                    @endif
                                                    @elseif($recolecta['codguia'] != Null and $recolecta['modificadorec'] == 0 and $recolecta['modificadocli'] == 0 and $recolecta['modificadocas'] == 0 ) background: #A9CCE3;
                                                    @elseif( $recolecta['modificadorec'] == 1 or $recolecta['modificadocli'] == 1 or $recolecta['modificadocas'] == 1)
                                                    @if($recolecta['inactivo'] == false) background: #00a4a4;
                                                    @endif
                                                    @else background: #F9F9F9;
                                                    @endif">
                                                        <td>@php echo $contar; @endphp</td>
                                                        <td>{{ strtoupper($recolecta['codrecolectadir']) }}</td>
                                                        <td>{{ strtoupper($recolecta['codcliente']) }}</td>
                                                        <td>{{ strtoupper($recolecta['nombrecli']) }}</td>
                                                        <td>{{ strtoupper($recolecta['contacto']) }}</td>
                                                        <td>{{ strtoupper($recolecta['tipo']) }}</td>
                                                        <td>{{ strtoupper($recolecta['direccion']) }}</td>
                                                        <td>{{ strtoupper($recolecta['numerorut']) }}</td>
                                                        <td>{{ strtoupper($recolecta['nombre']) }}</td>
                                                        <td>{{ strtoupper($recolecta['codguia']) }}</td>
                                                        <td>
                                                            @if(empty($recolecta['recolectage']))
                                                                {{ strtoupper('NO') }}
                                                            @else
                                                                {{ strtoupper('SI') }}
                                                            @endif
                                                        </td>
                                                        <td>{{ strtoupper($recolecta['siglas']) }}</td>
                                                        <td>{{ strtoupper($recolecta['causal']) }}</td>
                                                        <td>
                                                            <a href="{{ route('trackingRecolecta', ['codrecolecra' => $recolecta['codrecolectadir']])}}" class="btn btn-success" target="_blank" name="detalle" id="detalle" title="Detalle Recolecta">
                                                                <span class="glyphicon glyphicon-search"></span>
                                                            </a>
                                                        </td>
                                                        @php $valor++; @endphp
                                                    </tr>
                                            @endif
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                </div>
                    <div class="col-sm-7 col-xs-7 col-md-7 col-md-offset-3">
                    <div class="table-responsive">
                        <table class="table table-striped table-bordered table-hover">
                                <tr>
                                    <td bgcolor = "#A9CCE3">
                                        &nbsp
                                    </td>
                                    <td>
                                      Con Guia Generada (activas)
                                    </td>
                                    <td>
                                        @php
                                            $a=1;
                                            $generadas=0;
                                            foreach($consultaReporte['entidadRespuesta'] as $v){

                                                    if ($v['inactivo'] == false AND $v['codguia']!= NULL AND $v['modificadocli'] == 0 AND $v['modificadorec'] == 0 AND $v['modificadocas'] == 0){
                                                     $generadas = $a++;
                                                    }
                                             }

                                             echo $generadas;

                                        @endphp
                                    </td>
                                </tr>
                                <tr>
                                    <td bgcolor = "#FFFFFF">
                                        &nbsp
                                    </td>
                                    <td>
                                        &nbsp;Pendiente por Generar
                                    </td>
                                    <td>
                                        @php
                                            $b=1;
                                            $pendientes = 0;
                                            foreach($consultaReporte['entidadRespuesta'] as $v){

                                                    if ($v['inactivo'] == false AND $v['codguia'] == NULL AND $v['modificadocli'] == 0 AND $v['modificadorec'] == 0 AND $v['modificadocas'] == 0){
                                                        $pendientes = $b++;
                                                    }
                                             }

                                             echo $pendientes;

                                        @endphp

                                    </td>

                                </tr>
                                <tr>
                                    <td bgcolor = "#00a4a4">
                                        &nbsp
                                    </td>
                                    <td>
                                        Ingresadas despues de generar
                                    </td>
                                    <td>

                                        @php
                                            $z=1;
                                            $despues = 0;
                                            foreach($consultaReporte['entidadRespuesta'] as $v){

                                                    if ($v['modificadocli'] == 1 OR $v['modificadorec'] == 1 OR $v['modificadocas'] == 1){
                                                        if($v['inactivo'] == false AND $v['codguia'] == NULL){
                                                            $despues = $z++;
                                                        }
                                                    }
                                             }

                                             echo $despues;

                                        @endphp

                                    </td>

                                </tr>
                                <tr>
                                    <td bgcolor = "#E6B0AA">
                                        &nbsp
                                    </td>
                                    <td>
                                        Recolecta/Casillero/Cliente Anulado Con Guia Generada
                                    </td>
                                    <td>
                                        @php
                                            $c= 1;
                                            $inactivo = 0;
                                            foreach($consultaReporte['entidadRespuesta'] as $v){

                                                    if ($v["inactivo"] == TRUE){
                                                          $inactivo = $c++;
                                                    }
                                             }

                                             echo $inactivo;

                                        @endphp
                                    </td>

                                </tr>
                                <tr>
                                        <td colspan=2><b>
                                            Total</b>
                                            <td>
                                         @php

                                             $total = $generadas + $pendientes + $despues + $inactivo;
                                             echo $total;

                                         @endphp
                                            </td>
                                    </td>

                                </tr>
                        </table>


                    <div class="col-sm-5 col-xs-5 col-md-5 col-md-offset-5">
                        <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/datatables.js')  !!}"></script>--}}
     <script type="text/javascript" src="{!! URL::asset('/js/datatables2.min.js')  !!}"></script>
    <script>

        $(document).ready(function () {

            var t = $('#datos').DataTable({
                columnDefs: [{
                    "searchable": false,
                    "orderable": true,
                    "targets": 0
                }],
                order: [[0, 'asc']],
                dom: 'Bfrtip',
                buttons : [ {
                    extend : 'excel',
                    text: 'Exportar a Excel',
                    footer: true,
                    title: 'Listado de Recolectas'
                } ],
                pageLength: 10,
                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"
                    }
                }

            });

           /* var data = t.buttons.exportData( {
                columns: ':visible'
            } );

            t.on('order.dt search.dt', function () {
                t.column(0, {search: 'applied', order: 'applied'}).nodes().each( function (cell, i) {
                    cell.innerHTML = i+1;
                } );
            } ).draw();*/
        });

        function DataTable (tabla) {
            if ( ! $.fn.DataTable.isDataTable( tabla) ) {
                $(tabla).DataTable({
                    columnDefs: [{
                        "searchable": false,
                        "orderable": false,
                        "targets": 0
                    }],
                    order: [[0, 'asc']],
                    dom: 'Bfrtip',
                    buttons : [ {
                        extend : 'excel',
                        text: 'Exportar a Excel',
                        footer: true,
                        title: 'Listado de Recolectas'


                    } ],
                    pageLength: 10,
                    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"
                        }
                    }

                });
            }
        }


    </script>
@endsection