{{-- Created by anchacon on 06/06/2019 --}}
{{-- Modificado por Victor Poeta, fecha 04/09/2017
--}}
@extends('layouts.mainFilters')
@section('header')
    {{--<meta http-equiv="Refresh" content="60; URL=filtros2">--}}
    <link href="{!! asset('css/jquery.tablesorter.pager.css') !!}" rel="stylesheet">
    <style type="text/css">
        .button {
            position: fixed;
            top: 143px;
            left: 5px;
            border-radius: 20px;

            border: none;
            color: #FFFFFF;
            text-align: left;
            font-size: 14px;
            padding: 5px;
            width: auto;
            transition: all 0.5s;
            cursor: pointer;
            margin: 5px;
        }

        .button span {
            cursor: pointer;
            display: inline-block;
            position: relative;
            transition: 0.5s;
        }

        .button span:after {
            font-family: 'Arial';

            content: 'Mensaje Masivo';
            position: absolute;
            opacity: 0;
            top: 0;
            right: -100px;
            transition: 0.5s;
            width:120px;
        }

        .button:hover span {
            padding-right: 140px;
        }

        .button:hover span:after {
            opacity: 1;
            right: 0;
        }

        .btn2-contenedor{
            width:90px;
            height:240px;
            position:absolute;
            right:0px;
            bottom:0px;
        }

        .botonF1{
            width:60px;
            height:60px;
            border-radius:100%;
            background:#0076be;
            right:0;
            bottom:0;
            position:absolute;
            margin-right:30px;
            margin-bottom:50px;
            border:none;
            outline:none;
            color:#FFF;
            font-size:32px;
            box-shadow: 0 3px 6px rgba(0,0,0,0.16), 0 3px 6px rgba(0,0,0,0.23);
            transition:.3s;
        }

        .botonF1:hover span{
            transform:rotate(360deg);
        }
        .botonF1:active{
            transform:scale(1.1);
        }

       .dataTables_filter {
           width: 50%;
           float: right;
           text-align: right;
       }



    </style>
@endsection
@section('script')
    <script type="text/javascript" src="{!! asset('js/jquery.tablesorter.min.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('js/jquery.tablesorter.widgets.min.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('js/jquery.tablesorter.pager.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('js/PagosElectronicos/tableSorterPagosElectronicos.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('js/TweenMax.min.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('/js/jquery-ui.min.js') !!}"></script>
    <script type="text/javascript" src="{!! asset('/js/datatables.min.js')  !!}"></script>
    <script>
        $(document).ready(function(){


            //capturamos la página guardada anteriormente
            var pagina = localStorage.getItem("pagina_actual");
            $('#suma').keyup(function () {

                var x=$('#suma').val();
                var y=$('#sumn1n2').val();
                if (x==y){$('#mensaje3').html('');
                    // console.log('confirm');
                    $('#mensaje3').append("<div class='alert '>¿Esta completamente seguro de realizar esta operacion?<br>Esta accion enviara un correo electronico a todos los usuarios <br> que tengan cargas de retenciones pendientes!</div>");
                    $('#aceptarform3').attr('class',' btn btn-success');
                    $('#aceptarform3').attr('autofocus','autofocus');
                    $('#suma').attr('disabled','disabled');
                }
                else {  $('#mensaje3').html('');
                    $('#mensaje3').append("<div class='alert '>Debe Realizar Correctamente la SUMA</div>");
                    $('#aceptarform3').attr('class',' hide');
                    // console.log('debe realizar la suma');
                }
            });
            var url=location.href;
            // console.log('url:'+url);
            $('#url1').val(url);

            var columna = 13, columnaBotton = [ 0, 1, 2, 3, 4, 5 , 6, 7, 8, 9];
            // Pregutnamos si existe el item

                var table = $('#myTable1').DataTable(
                    {
                        bStateSave: true,
                        columnDefs: [{
                            "searchable": true,
                            "orderable": true,
                            "targets": 0
                        }],
                        order: [[0, 'asc']],
                        dom: 'Bfrtip',
                        pageLength: 5,
                        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"
                            }
                        },
                        buttons: [
                            //'excel'//,'pdfHtml5'
                            {
                                extend: 'excelHtml5',
                                text: '<i class="fa fa-file-excel-o"></i>  Excel',
                                title: 'Reporte Pago Por transferencia',
                                titleAttr: 'Excel',
                                exportOptions: {
                                    columns: columnaBotton
                                },
                                className: 'btn btn-app btn-sm export excel'
                            },
                            {
                                extend:    'pdfHtml5',
                                text:      '<i class="fa fa-file-pdf-o"></i>  PDF',
                                title:'Reporte Pago Por transferencia',
                                titleAttr: 'PDF',
                                orientation: 'landscape',
                                pageSize: 'LETTER',
                                customize: function(doc) {
                                    doc.defaultStyle.fontSize = 8;
                                },
                                exportOptions: {
                                    columns: columnaBotton
                                },

                                className: 'btn btn-app-pdf btn-sm export pdf'

                            },
                            {
                                extend:    'print',
                                text:      '<i class="fa fa-print"></i>  Print',
                                title:'Reporte Pago Por transferencia',
                                titleAttr: 'Imprimir',
                                orientation: 'landscape',
                                pageSize: 'LETTER',
                                customize: function ( win ) {
                                    $(win.document.body)
                                        .css( 'font-size', '10pt' );


                                    $(win.document.body).find( 'table' )
                                        .addClass( 'compact' )
                                        .css( 'font-size', '10pt' );
                                },
                                exportOptions: {
                                    columns: columnaBotton
                                },
                                className: 'btn btn-app-print btn-sm export imprimir',
                            }

                        ]
                    }).draw();
            if (pagina != undefined && pagina != null) {
                if ( $(".paginate_button") ) {

                    table.page(pagina - 1 ).draw(false);
                    localStorage.removeItem("pagina_actual");
                }
            }
        });

        $('#myTable1').on('draw.dt', function() {
            var pagina_actual = $('.paginate_button.active > a').html();
            localStorage.setItem("pagina_actual", pagina_actual);
        });

        setTimeout('document.location.reload()',60000);
        function count(){
            var counter = { var: 60 };
            TweenMax.to(counter, 60, {
                var: 0,
                onUpdate: function () {
                    var number = Math.ceil(counter.var);
                    $('.counter').html(number);
                    if(number === counter.var){ count.kill; }
                },
                onComplete: function(){
                    count();
                }

            });
        }

        count();

    </script>
@endsection
@section('content')
    <form method="get">
        <h6 class="btn btn-primary" style="font-size: 10px;position: fixed; z-index: 10000000000000000000000; left: 45%; top: -5px; padding: 5px;">La p&aacute;gina se recargar&aacute; en: <div class="counter text-default" style="font-size: 15px;">0</div> </h6>
        <input id="consultar" type="hidden"  data-url="{{ route('getConsumirAjax') }}">
        <div class="row">
            <div align="center">
                <a href="filtros" class="btn btn-default btn-sm">
                    <span class="glyphicon glyphicon-backward" aria-hidden="true"></span> Regresar
                </a><br><br>
            </div>
            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 col-xs-offset-0 col-sm-offset-0 col-md-offset-0 col-lg-offset-0 ">
                @php($totalReg = count($requestListPagos['entidadRespuesta']))
                @php
                    $arrayPagos = [];
                    $ii = 1;
                    $i = 1;
                    $hoy = date('d-m-Y');
                    $dia1=date('d');
                    $mes1=date('m');
                    $ano1=date('Y');
                    $numPago = 0;
                @endphp
                @if(isset($detalleOficina) and isset($detalleOficina['codrespuesta']))
                    @if($detalleOficina['codrespuesta'] == 'COD_000')
                        <div class="row">
                            <div class="col-xs-4 col-sm-4 col-md-4 col-lg-4">
                                <div class="panel panel-info">
                                    <div class="panel-heading">
                                        <h6 class="panel-title">OFICINA:  {{$detalleOficina['entidadRespuesta'][0]['nombre']}} </h6></b>
                                    </div>
                                </div>
                            </div>
                        </div>
                    @endif
                @endif
                @if(isset($departamento))
                    @if($departamento == 22 || $departamento == 3)
                <!--Reporte para Cobranzas myTable1-->
                        <div>
                            <table id="myTable1" class="table table-hover tablesorter table-condensed">
                                @if ($totalReg > 0)
                                    <thead>
                                    <tr class="bg-primary">
                                        <th class="text-center" style="width: 10%;">N° Pago</th>
                                        <th class="text-center" style="width: 10%;">Fecha de Pago</th>
                                        <th class="text-center">Monto Transferencia</th>
                                        <th class="text-center">Nombre Pagador</th>
                                        <th class="text-center">N° Transferencia</th>
                                        <th class="text-center">Estatus</th>
                                        <th class="text-center">N° SAP</th>
                                        <th class="text-center">D&iacute;as estatus actual</th>
                                        <th class="text-center">Comprobantes de Retenci&oacute;n</th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                    </thead>
                                @endif
                                <tbody>
                                    @if(count($requestListPagos['entidadRespuesta']) > 0)
                                        @foreach($requestListPagos['entidadRespuesta'] as $value)

                                                @if(!empty($value))
                                                    @php
                                                        $arrayPagos[$numPago] = $value['idpago'];
                                                    @endphp
                                                @endif
                                            @if($value['idestatuspago'] == 8)
                                                <tr>
                                                        <input type="hidden" value="{{ @$value['idpago'] }}" name="listIdPago[{{$numPago}}]" id="listIdPago[{{$numPago}}]">
                                                        <td class="text-center">{{ @$value['idpago'] }}</td>
                                                        <td class="text-center">{{ @date('d/m/Y', strtotime($value['fechapago'])) }}</td>
                                                        <td class="text-right">{{ @money_format('%.2n',$value['montototal']) }}</td>
                                                        <td class="text-justify">{{ @$value['nombrepagador'] }}</td>
                                                        <td class="text-justify">{{ @$value['referencia'] }}</td>
                                                        <td class="text-center">{{ @$value['listestatuspago']['nombre'] }}</td>
                                                        <td class="text-center">{{ @$value['documento_sap'] }}</td>
                                                        <td class="text-center">
                                                            @php
                                                                if ($value['idestatuspago']==1){
                                                                $dia2= date('d', strtotime($value['fechapago']));
                                                                $mes2= date('m', strtotime($value['fechapago']));
                                                                $ano2= date('Y', strtotime($value['fechapago']));
                                                                } else {
                                                                    $dia2= date('d', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                    $mes2= date('m', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                    $ano2= date('Y', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                }
                                                                if (isset($value['listtrackingpago'][0]['fechahora'])) {
                                                                    $datetime1 =  date('d-m-Y', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                }
                                                                $timestamp1 = mktime(0,0,0,$mes1,$dia1,$ano1);
                                                                $timestamp2 = mktime(0,0,0,$mes2,$dia2,$ano2);
                                                                $segundos_diferencia = $timestamp1 - $timestamp2;
                                                                $hora_actual = localtime();
                                                                $hora=$hora_actual[2];
                                                                $minuto=$hora_actual[1];
                                                                $estatus_actual=$value['idestatuspago'];
                                                                $dias_diferencia = $segundos_diferencia / (60 * 60 * 24);
                                                                $dias_diferencia = abs($dias_diferencia);
                                                                $dias_diferencia = floor($dias_diferencia);
                                                                if($dias_diferencia < 2){
                                                                    $color = 'btn btn-info btn-sm';
                                                                }
                                                                if($dias_diferencia > 1 AND $dias_diferencia < 6){
                                                                    $color = 'btn btn-warning btn-sm';
                                                                }
                                                                if($dias_diferencia > 5){
                                                                    $color = 'btn btn-danger btn-sm';
                                                                }
                                                            @endphp
                                                            <div class="{{ $color }}"> {{ $dias_diferencia }} Días </div>
                                                            @if(isset($departamento))
                                                                @if(($departamento == 22) and $value['idestatuspago'] == 4)
                                                                    <label> Revisado en SAP: </label>
                                                                    @if(@$value['validar_sap'])
                                                                        <input type="checkbox" id="revisado_en_SAP" onclick="revisado_SAP({{$value['idpago']}})" class="input-sm inputs-inline" checked/>
                                                                    @else
                                                                        <input type="checkbox" id="revisado_en_SAP" onclick="revisado_SAP({{$value['idpago']}})"  class="input-sm inputs-inline"/>
                                                                    @endif
                                                                @endif
                                                            @endif
                                                        </td>
                                                        <td class="text-center">
                                                            @if (count(@$value['listpagoarchivo'])>0)
                                                                <select name="" id="">
                                                                    @foreach(@$value['listpagoarchivo'] as $value2)
                                                                        <option value="{{ @$value2['id']  }}">{{@$value2['nombre_archivo']}}</option>
                                                                    @endforeach
                                                                </select>
                                                            @elseif ($value['suma_montosret']>0 )
                                                                <h5 class="text-warning" >Pendiente por cargar Comprobante</h5>
                                                            @else
                                                                <h5 class="text-success">No Necesita Comprobante</h5>
                                                            @endif
                                                        </td>
                                                        <td class="text-center">
                                                            <a href="{{ route('canguroazul.reporte.detallePDF', ['id' => $value['idpago']])}}" class="btn btn-sm btn-primary" target="_blank" title="Detalle">
                                                                <span class="glyphicon glyphicon-search" >  </span>
                                                            </a>
                                                            @php
                                                                /*{{ link_to_route('canguroazul.reporte.detallePDF', $title = 'Detalle', $parameters = ['id' => $value['idpago']]), ['class' => 'btn btn-sm btn-primary', 'target' => '_blank']) }}*/
                                                            @endphp

                                                            @if($value['listestatuspago']['idestatuspago'] == 1 || $value['listestatuspago']['idestatuspago'] == 8)
                                                                <br>
                                                                <br>
                                                                <a  href="{{ route('pagoTransferencia.edit', ['pagoTransferencia' => $value['idpago']]) }}" class="btn btn-sm btn-info" target="_blank" title="Editar">
                                                                    <span class="glyphicon glyphicon-pencil" >  </span>
                                                                </a>
                                                            @endif
                                                        </td>
                                                        @if( $estatus_actual == 1 || $estatus_actual == 2  AND $value['suma_montosret'] > 0 AND count($value['listpagoarchivo']) < 1 )
                                                            <td class="text-center" title="Mensaje Recordatorio">
                                                                {{ link_to_route('pagoTransferencia.mail', $title = '', $parameters = ['id' => $value['idpago']], ['class' => 'btn btn-sm btn-primary glyphicon glyphicon-envelope']) }}
                                                            </td>
                                                        @else
                                                        <td class="text-center" title="Mensaje Recordatorio">
                                                            -
                                                        </td>
                                                        @endif
                                                </tr>
                                                @php
                                                    $i ++;
                                                    $ii ++;
                                                    $numPago++;
                                                @endphp
                                            @else
                                                <tr>
                                                    <input type="hidden" value="{{ @$value['idpago'] }}" name="listIdPago[{{$numPago}}]" id="listIdPago[{{$numPago}}]">
                                                    <td class="text-center"> <span  data-toggle="tooltip" data-placement="bottom" @if(!empty( @$value['fecha_contable'] )) title="  Fecha Contable : {{ date('d/m/Y', strtotime($value['fecha_contable'])) }}" @endif>{{ $value['idpago'] }}  </span></td>
                                                    <td class="text-center">{{ @date('d/m/Y', strtotime($value['fechapago'])) }}</td>
                                                    <td class="text-right">{{ @money_format('%.2n',$value['montototal']) }}</td>
                                                    <td class="text-justify">{{ @$value['nombrepagador'] }}</td>
                                                    <td class="text-justify">{{ @$value['referencia'] }}</td>
                                                    <td class="text-center">{{ @$value['listestatuspago']['nombre'] }}</td>
                                                    <td class="text-center">{{ @$value['documento_sap'] }}</td>
                                                    <td class="text-center">
                                                        @php
                                                            if ($value['idestatuspago']==1){
                                                            $dia2= date('d', strtotime($value['fechapago']));
                                                            $mes2= date('m', strtotime($value['fechapago']));
                                                            $ano2= date('Y', strtotime($value['fechapago']));
                                                            } else {
                                                                $dia2= date('d', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                $mes2= date('m', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                                $ano2= date('Y', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                            }
                                                            if (isset($value['listtrackingpago'][0]['fechahora'])) {
                                                                $datetime1 =  date('d-m-Y', strtotime($value['listtrackingpago'][0]['fechahora']));
                                                            }
                                                            $timestamp1 = mktime(0,0,0,$mes1,$dia1,$ano1);
                                                            $timestamp2 = mktime(0,0,0,$mes2,$dia2,$ano2);
                                                            $segundos_diferencia = $timestamp1 - $timestamp2;
                                                            $hora_actual = localtime();
                                                            $hora=$hora_actual[2];
                                                            $minuto=$hora_actual[1];
                                                            $estatus_actual=$value['idestatuspago'];
                                                            $dias_diferencia = $segundos_diferencia / (60 * 60 * 24);
                                                            $dias_diferencia = abs($dias_diferencia);
                                                            $dias_diferencia = floor($dias_diferencia);
                                                            if($dias_diferencia < 2){
                                                                $color = 'btn btn-info btn-sm';
                                                            }
                                                            if($dias_diferencia > 1 AND $dias_diferencia < 6){
                                                                $color = 'btn btn-warning btn-sm';
                                                            }
                                                            if($dias_diferencia > 5){
                                                                $color = 'btn btn-danger btn-sm';
                                                            }
                                                        @endphp
                                                        <div class="{{ $color }}"> {{ $dias_diferencia }} Días </div>
                                                        @if(isset($departamento))
                                                            @if(($departamento == 22) and $value['idestatuspago'] == 4)
                                                                <label> Revisado en SAP: </label>
                                                                @if(@$value['validar_sap'])
                                                                    <input type="checkbox" id="revisado_en_SAP" onclick="revisado_SAP({{$value['idpago']}})" class="input-sm inputs-inline" checked/>
                                                                @else
                                                                    <input type="checkbox" id="revisado_en_SAP" onclick="revisado_SAP({{$value['idpago']}})"  class="input-sm inputs-inline"/>
                                                                @endif
                                                            @endif
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        @if (count(@$value['listpagoarchivo'])>0)
                                                            <select name="" id="">
                                                                @foreach(@$value['listpagoarchivo'] as $value2)
                                                                    <option value=" {{ @$value2['id'] }}"> {{ @$value2['nombre_archivo']  }}></option>
                                                                @endforeach
                                                            </select>
                                                        @elseif (@$value['suma_montosret']>0 )
                                                            <h5 class="text-warning" >Pendiente por cargar Comprobante</h5>
                                                        @else
                                                            <h5 class="text-success">No Necesita Comprobante</h5>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <a href="{{ route('canguroazul.reporte.detallePDF', ['id' => $value['idpago']])}}" class="btn btn-sm btn-primary" target="_blank" title="Detalle">
                                                            <span class="glyphicon glyphicon-search" >  </span>
                                                        </a>
                                                        @php
                                                            /*{{ link_to_route('canguroazul.reporte.detallePDF', $title = 'Detalle', $parameters = ['id' => $value['idpago']], ['class' => 'btn btn-sm btn-primary']) }}*/
                                                        @endphp
                                                        @if($value['listestatuspago']['idestatuspago'] == 1 || $value['listestatuspago']['idestatuspago'] == 8)
                                                            <br>
                                                            <br>
                                                            <a  href="{{ route('pagoTransferencia.edit', ['pagoTransferencia' => $value['idpago']]) }}" class="btn btn-sm btn-info" target="_blank" title="Editar">
                                                                <span class="glyphicon glyphicon-pencil" >  </span>
                                                            </a>
                                                        @endif
                                                        @if(isset($departamento))
                                                            @if(($departamento == 19 or $departamento == 22) and $value['listestatuspago']['idestatuspago'] == 3)
                                                                <br>
                                                                <br>
                                                                <a  href="{{ route('pagoTransferencia.edit', ['pagoTransferencia' => $value['idpago']]) }}" class="btn btn-sm btn-info" target="_blank" title="Editar">
                                                                    <span class="glyphicon glyphicon-pencil" >  </span>
                                                                </a>
                                                            @endif
                                                        @endif
                                                    </td>
                                                    @if( $estatus_actual == 1 || $estatus_actual == 2  AND $value['suma_montosret'] > 0 AND count($value['listpagoarchivo']) < 1 )
                                                        <td class="text-center" title="Mensaje Recordatorio">
                                                            {{ link_to_route('pagoTransferencia.mail', $title = '', $parameters = ['id' => $value['idpago']], ['class' => 'btn btn-sm btn-primary glyphicon glyphicon-envelope']) }}
                                                        </td>
                                                    @else
                                                        <td class="text-center" title="Mensaje Recordatorio">
                                                            -
                                                        </td>
                                                    @endif
                                                </tr>
                                                @php
                                                    $i ++;
                                                    $ii ++;
                                                    $numPago++;
                                                @endphp
                                            @endif
                                        @endforeach
                                    @else
                                        <h5 class="alert alert-warning" align="center" style="padding:7px;" >No se encontro ning&uacute;n registro. Intente modificar los filtros de b&uacute;squeda. </h5>
                                    @endif
                                </tbody>
                            </table>
                        </div>
                @endif
                @if($departamento == 19)
                            @php
                                $arrayPagos = [];
                                $ii = 1;
                                $i = 1;
                                $hoy = date('d-m-Y');
                                $dia1=date('d');
                                $mes1=date('m');
                                $ano1=date('Y');
                                $numPago = 0;
                            @endphp
                        <!-- Reporte para Impuesto -->
                            <div>
                                <table id="myTable1" class="table table-hover tablesorter table-condensed">
                                    @if ($totalReg > 0)
                                        <thead>
                                        <tr class="bg-primary">
                                            <th class="text-center" style="width: 10%;">N° Pago</th>
                                            <th class="text-center">Sucursal</th>
                                            <th class="text-center" style="width: 10%;">Fecha contable</th>
                                            <th class="text-center">C&oacute;digo Cliente</th>
                                            <th class="text-center">Nombre Pagador</th>
                                            <th class="text-center">Estatus</th>
                                            <th class="text-center">N° SAP</th>
                                            <th class="text-center">IVA</th>
                                            <th class="text-center">ISLR</th>
                                            <th class="text-center">IAE</th>
                                            <th class="text-center">TIMBRE</th>
                                            <th class="text-center">Resp. Social</th>
                                            <th class="text-center">Comprobantes de Retenci&oacute;n</th>
                                            <th></th>
                                            <th></th>
                                        </tr>
                                        </thead>
                                    @endif
                                    <tbody>
                                    @if(count($requestListPagos['entidadRespuesta']) > 0)
                                        @foreach($requestListPagos['entidadRespuesta'] as $value)

                                            @if(!empty($value))
                                                @php
                                                    $arrayPagos[$numPago] = $value['idpago'];
                                                @endphp
                                            @endif
                                                <tr>
                                                    <input type="hidden" value="{{ $value['idpago'] }}" name="listIdPago[{{$numPago}}]" id="listIdPago[{{$numPago}}]">
                                                    <td class="text-center">{{ $value['idpago'] }}</td>
                                                    @php
                                                        $sucursal = '-';
                                                        if(isset($value['listpagodoc'][0]['listguia']) and ($value['listpagodoc'][0]['listguia']) != null ){
                                                            $sucursal = $value['listpagodoc'][0]['listguia']['oficinadestino']['nombre'];
                                                        }elseif (isset($value['listpagodoc'][0]['listfactura']) and $value['listpagodoc'][0]['listfactura'] != null){
                                                            $sucursal = $value['listpagodoc'][0]['listfactura']['listoficina']['nombre'];
                                                        }elseif(isset($value['listpagodoc'][0]['listnota']) and $value['listpagodoc'][0]['listnota'] != null){
                                                            $sucursal = $value['listpagodoc'][0]['listnota']['listoficina']['nombre'];
                                                        }

                                                        if($value['fecha_contable'] != null){
                                                            $fechaCont = date('d/m/Y', strtotime($value['fecha_contable']));
                                                        }else{
                                                            $fechaCont = 'NO POSEE';
                                                        }

                                                        $codCliente = 'NO POSEE';

                                                        if(isset($value['listpagodoc'][0]['listguia']) and $value['listpagodoc'][0]['listguia'] != null){
                                                            $codCliente = @$value['listpagodoc'][0]['listguia']['codcliente'];
                                                        }elseif(isset($value['listpagodoc'][0]['listfactura']) and $value['listpagodoc'][0]['listfactura'] != null){
                                                            $codCliente = @$value['listpagodoc'][0]['listfactura']['codcliente'];
                                                        }elseif(isset($value['listpagodoc'][0]['listnota']) and $value['listpagodoc'][0]['listnota'] != null){
                                                            $codCliente = @$value['listpagodoc'][0]['listnota']['codcliente'];
                                                        }

                                                        $estatus_actual=$value['idestatuspago'];
                                                       // $iva = money_format('%.2n',$value['monto_ret_iva']);
                                                        $iva = number_format($value['monto_ret_iva'],2,",", ".");
                                                        $islr = number_format($value['monto_ret_islr'],2,",", ".");
                                                        $iae = number_format($value['monto_ret_im'],2,",", ".");
                                                        $tf = number_format($value['monto_ret_tf'],2,",", ".");
                                                        $Rs = number_format($value['monto_ret_rs'],2,",", ".");
                                                    @endphp
                                                    <td class="text-right">{{ $sucursal }}</td>
                                                    <td class="text-center">{{ $fechaCont }}</td>
                                                    <td class="text-justify">{{ @$codCliente }}</td>
                                                    <td class="text-justify">{{ $value['nombrepagador'] }}</td>
                                                    <td class="text-center">{{ $value['listestatuspago']['nombre'] }}</td>
                                                    <td class="text-center">{{ $value['documento_sap'] }}</td>
                                                    <td class="text-center">{{ $iva }}</td>
                                                    <td class="text-center">{{ $islr }}</td>
                                                    <td class="text-center">{{ $iae }}</td>
                                                    <td class="text-center">{{ $tf }}</td>
                                                    <td class="text-center">{{ $Rs }}</td>
                                                    <td class="text-center">
                                                        @if (count($value['listpagoarchivo'])>0)
                                                            <select name="" id="">
                                                                @foreach($value['listpagoarchivo'] as $value2)
                                                                    <option value="{{ $value2['id']  }}">{{$value2['nombre_archivo']}}</option>
                                                                @endforeach
                                                            </select>
                                                        @elseif ($value['suma_montosret']>0 )
                                                            <h5 class="text-warning" >Pendiente por cargar Comprobante</h5>
                                                        @else
                                                            <h5 class="text-success">No Necesita Comprobante</h5>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <a href="{{ route('canguroazul.reporte.detallePDF', ['id' => $value['idpago']])}}" class="btn btn-sm btn-primary" target="_blank" title="Detalle">
                                                            <span class="glyphicon glyphicon-search" >  </span>
                                                        </a>
                                                        @if($value['listestatuspago']['idestatuspago'] == 1 || $value['listestatuspago']['idestatuspago'] == 8 || $value['listestatuspago']['idestatuspago'] == 16 || $value['listestatuspago']['idestatuspago'] == 15 || $value['listestatuspago']['idestatuspago'] == 3)
                                                            <br>
                                                            <br>
                                                            <a  href="{{ route('pagoTransferencia.edit', ['pagoTransferencia' => $value['idpago']]) }}" class="btn btn-sm btn-info" target="_blank" title="Editar">
                                                                <span class="glyphicon glyphicon-pencil" >  </span>
                                                            </a>
                                                        @endif
                                                    </td>
                                                    @if( $estatus_actual == 1 || $estatus_actual == 2  AND $value['suma_montosret'] > 0 AND count($value['listpagoarchivo']) < 1 )
                                                        <td class="text-center" title="Mensaje Recordatorio">
                                                            {{ link_to_route('pagoTransferencia.mail', $title = '', $parameters = ['id' => $value['idpago']], ['class' => 'btn btn-sm btn-primary glyphicon glyphicon-envelope']) }}
                                                        </td>
                                                    @else
                                                        <td class="text-center" title="Mensaje Recordatorio">
                                                            -
                                                        </td>
                                                    @endif
                                                </tr>
                                                @php
                                                    $i ++;
                                                    $ii ++;
                                                    $numPago++;
                                                @endphp
                                        @endforeach
                                    @else
                                        <h5 class="alert alert-warning" align="center" style="padding:7px;" >No se encontro ning&uacute;n registro. Intente modificar los filtros de b&uacute;squeda. </h5>
                                    @endif
                                    </tbody>
                                </table>
                            </div>
                @endif
                    @if($departamento != 22 and $departamento != 19 and $departamento != 3)
                            <h5 class="alert alert-warning" align="center" style="padding:7px;" >No pertenece al Departamento de Impuesto o de cobranzas para observar el reporte. Por favor comunicarse con sistemas</h5>
                    @endif
            @endif
            </div>
        </div>
    </form>
    <input type="hidden" name="parametro1" id="parametro1" value="{{ \Session::get('LoginUE.token') }}">
    <input type="hidden" name="user" id="user" value="{{ $usuario }}">
    <input type="hidden" id="url" data-url="{{ route('getConsumirAjax') }}">

    <div class="modal fade" id="messageModal3" name="messageModal3" tabindex="-1" role="dialog" aria-labelledby="Login"
         aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <header class="modal-header bg-danger">
                    <button  type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h5 class="modal-title text-center"><strong>Advertencia</strong></h5>
                </header>
                @php
                    $num1=(random_int(0, 9));
                    $num2=(random_int(0, 9));
                    $sumn1n2=$num1+$num2;
                @endphp

                <div class="center modal-body">
                    <input type="hidden" id="sumn1n2" name="sumn1n2" value=" {{ $sumn1n2  }}">
                    ¿Cuanto es <strong> {{ $num1 }}  + {{ $num2  }}</strong>  = <input class="" value="" size="2" type="text" id="suma" name="suma">?

                    <div class="text-center" id="mensaje3"></div>
                </div>
                <footer class="modal-footer">
                    <button type="button" class="hide" id="aceptarform3" name="aceptarform3" data-dismiss="modal" >Aceptar</button>
                    <button type="button" class="btn btn-default" id="close" name="close" data-dismiss="modal">Close</button>
                </footer>
            </div>
        </div>
    </div>

    <div class="row" style="margin-top: 14%;">
        <div class="btn2-contenedor">
            <a class="btn botonF1" data-toggle="tooltip" data-placement="left"  onclick="myModal()" title="Total de Estatus">
                <span class="glyphicon glyphicon-th-list"></span>
            </a>
        </div>
    </div>

    <div class="modal fade" id="myModal" role="dialog">
        <div class="modal-dialog">
            <!-- Modal content-->
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">×</button>
                    <h4 class="modal-title">Total Estatus</h4>
                </div>
                <div class="modal-body">
                    <table class="table-responsive table-condensed tablesorter">
                        <thead>
                        <tr class="bg-primary">
                            <th class="text-center" style="width: 10%;">Estatus</th>
                            <th class="text-center" style="width: 10%;">Total</th>
                        </tr>
                        </thead>
                        <tbody id="tableEstatus">
                        @if($totalReg > 0)
                            @if($pendiente != 0)
                                <tr>
                                    <td class="text-center" >Pendiente</td>
                                    <td class="text-center">{{ $pendiente }}</td>
                                </tr>
                            @endif
                            @if($conciliadoB != 0)
                                <tr>
                                    <td class="text-center" >Conciliado Banco</td>
                                    <td class="text-center">{{ $conciliadoB }}</td>
                                </tr>
                            @endif
                            @if($verifiCobra != 0)
                                <tr>
                                    <td class="text-center" >Verificado Cobranzas</td>
                                    <td class="text-center">{{ $verifiCobra }}</td>
                                </tr>
                            @endif
                            @if($regesSAP != 0)
                                <tr>
                                    <td class="text-center" >Registrado SAP</td>
                                    <td class="text-center">{{ $regesSAP }}</td>
                                </tr>
                            @endif
                            @if($verifIMP != 0)
                                <tr>
                                    <td class="text-center" >Verificado Impuesto</td>
                                    <td class="text-center">{{ $verifIMP }}</td>
                                </tr>
                            @endif
                            @if($finalizado != 0)
                                <tr>
                                    <td class="text-center" >Finalizado</td>
                                    <td class="text-center">{{ $finalizado }}</td>
                                </tr>
                            @endif
                            @if($rechazado != 0)
                                <tr>
                                    <td class="text-center" >Rechazado</td>
                                    <td class="text-center">{{ $rechazado }}</td>
                                </tr>
                            @endif
                            @if($conciliadoPagoP != 0)
                                <tr>
                                    <td class="text-center" >Conciliado Pago Parcial</td>
                                    <td class="text-center">{{ $conciliadoPagoP }}</td>
                                </tr>
                            @endif
                            @if($duplicado != 0)
                                <tr>
                                    <td class="text-center" >Duplicado</td>
                                    <td class="text-center">{{ $duplicado }}</td>
                                </tr>
                            @endif
                        @else
                            <tr>
                                <h5 class="text-success">No hay datos que mostrar</h5>
                            </tr>
                        @endif
                        </tbody>
                    </table>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="pleaseWaitDialog" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
        <div class="vertical-alignment-helper">
            <div class="modal-dialog vertical-align-center">
                <div class="modal-content">
                    <div class="modal-header">
                        <h4 class="modal-title">Por favor espere</h4>
                    </div>
                    <div class="modal-body">
                        <div class="progress">
                            <div class="progress-bar progress-bar-striped active" role="progressbar" aria-valuenow="40"
                                 aria-valuemin="0" aria-valuemax="100" style="width: 100%">
                                <span class="sr-only">40% Complete (success)</span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="messageModal" style="margin-top: 50%;" tabindex="-1" role="dialog" aria-labelledby="Login"
         aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <header class="modal-header modal-header-errors">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h5 class="modal-title modal-title-errors">Advertencia</h5>
                </header>
                <div class="modal-body modal-errors">
                    <div id="errors"></div>
                </div>
                <footer class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
                </footer>

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

    <div class="modal fade" id="messageModal2"  role="dialog" aria-labelledby="Login" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <header class="modal-header modal-header-errors">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h5 class="modal-title modal-title-errors">Advertencia</h5>
                </header>
                <div class="modal-body modal-errors">
                    <div id="errors2"></div>
                </div>
                <footer class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
                </footer>

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

    <input type="hidden" id="tk" value="{{$tk}}">
    @if($request['estatus']==1 or $request['estatus']==2)
        <button data-toggle="tooltip" data-placement="top" title="Recordatorio Retenciones Pendientes" type="button" onclick="enviaremail()" class="button bg-primary" ><span class="glyphicon glyphicon-envelope "></span></button>
    @endif

    <script>
        function enviaremail(){
            // Mostramos los valores del array
            $('#mensaje3').html('');
            $('#mensaje3').append("<div class='alert '>Para enviar correos masivos primero debe realizar la suma</div>");
            $('#messageModal3').modal('show');
            $('#aceptarform3').click(function () {
                // console.log('hola');
                location.href='{!! route('canguroazul.mail',['idpago' => $arrayPagos]) !!}';

            });
        }

        $('.btn2-contenedor').mouseleave(function(){
            $('.btn2').removeClass('animacionVer');
        });

        function myModal() {
            $('#myModal').modal('show');
        }

        function modal() {
            $('#pleaseWaitDialog').modal('show');
        }

        function revisado_SAP(idpago){
            var messageModal = $("#messageModal2");
            var errors = $("#errors2");
            $('#pleaseWaitDialog').modal('show');
            var token = $("#parametro1").val(), user = $('#user').val(),
                url = $("#url").data('url'),
                method = 'POST',
                pagina = 'canguroazul/',
                params = {
                    token: token,
                    webservice: 'getRevisadoSAPWs',
                    pagina: pagina,
                    method: method,
                    campos: ['idpago', 'user'],
                    valores: [idpago, user]
                };
            $.ajax({
                type: "GET",
                url: url,
                data: params,
                datatype: 'JSON',
                success: function (data) {
                    $('#pleaseWaitDialog').modal('hide');
                    errors.html('');
                    if(data.error_jwt != undefined){
                        errors.append("<div class='alert alert-success center'>Token Expirado, vuelva iniciar sesion nuevamente.</div>");
                        messageModal.modal('show');
                        return false;
                    }
                    errors.append("<div class='alert alert-success center'>El pago se a validado exitosamente.</div>");
                    messageModal.modal('show');
                }
                , error: function (mensaje) {
                    $('#pleaseWaitDialog').modal('hide');
                    errors.html('');
                    errors.append("<div class='alert alert-success center'>Problemas con actualizar la revision, por favor intente de nuevo.</div>");
                    messageModal.modal('show');
                }
            });
        }
        document.oncontextmenu = function(){return false;}
    </script>
@endsection