@extends('layouts.app')

@section('content')
<style>
    .select2-container--open {
    z-index: 9999999
}
</style>
    <!-- end sidebar menu -->
    <!-- start page content -->
    <div class="page-content-wrapper">
        <div class="page-content">
            <div class="page-bar">
                <div class="page-title-breadcrumb">
                    <div class="pull-left">
                        <div class="page-title text-primary">Registros no Identificados</div>
                    </div>
                    <ol class="breadcrumb page-breadcrumb pull-right">
                        <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item" href="{{ url('/dashboard') }}">Inicio</a>&nbsp;<i class="fa fa-angle-right"></i>
                        </li>
                        <li class="active">Registros no Identificados</li>
                    </ol>
                </div>
            </div>
            <!-- start widget -->
            <!-- start admited patient list -->
            <div class="row">
                <div class="col-md-12 col-sm-12">
                    <div class="card  card-box">
                        <div class="card-head">
                            <header>Listado</header>
                        </div>

                        <div class="card-body ">
                            <div class="row">
                                <div class="col-11">
                                    <a onclick="limpiar()" class="btn btn-warning mb-3">Limpiar Filtro</a>
                                </div>
                            </div>
                            <div class="table-wrap">
                                <div class="table-responsive">
                                    <table class="table display product-overview mb-30">
                                        <thead>
                                        <tr>
                                            <th><b>Listado</b></th>
                                            <th><b>Fecha de Pago</b></th>
                                            <th><b>Referencia</b></th>
                                            <th><b>Transacción</b></th>
                                            <th><b>Valor Pagado</b></th>
                                            <th><b>Concepto</b></th>
                                            <th><b>Observaciones</b></th>
                                            <th><b></b></th>
                                        </tr>
                                        {!! Form::open(['url' => 'pagos/debito_automatico/registros_no_identificados/lista','method'=>'get','id'=>'frmFiltros']) !!} 
                                        <tr>
                                            <th></th><!--Listado-->
                                            <th>
                                                {{-- group date_desde date_hasta --}}

                                                <div class="input-group">
                                                    <div class="input-group-prepend">
                                                        <span class="input-group-text" id="basic-addon1"><i class="fa fa-calendar"></i></span>
                                                    </div>
                                                    {!! Form::date('date_desde',$date_desde,['id'=>'date_desde','class'=>'form-control','placeholder'=>'Desde','onkeyup'=>"buscar(event,'date_desde')"]) !!}
                                                </div>
                                                <div class="input-group">
                                                    <div class="input-group-prepend">
                                                        <span class="input-group-text" id="basic-addon1"><i class="fa fa-calendar"></i></span>
                                                    </div>
                                                    {!! Form::date('date_hasta',$date_hasta,['id'=>'date_hasta','class'=>'form-control','placeholder'=>'Hasta','onkeyup'=>"buscar(event,'date_hasta')"]) !!}
                                                </div>

                                            </th><!--Fecha de Pago-->
                                            <th>
                                                {!! Form::text('referencia',$referencia,['id'=>'referencia','class'=>'form-control','onkeyup'=>"buscar(event,'referencia')"]) !!}
                                            </th><!--Referencia-->
                                            <th>
                                               {!! Form::text('transaccion',$transaccion,['id'=>'transaccion','class'=>'form-control','onkeyup'=>"buscar(event,'transaccion')"]) !!}
                                            </th><!--Transacción-->
                                            <th></th><!--Valor Pagado-->
                                            <th>
                                                {!! Form::text('concepto',$concepto,['id'=>'concepto','class'=>'form-control','onkeyup'=>"buscar(event,'concepto')"]) !!}
                                            </th><!--Concepto-->
                                            <th>
                                                {!! Form::text('observaciones',$observaciones,['id'=>'observaciones','class'=>'form-control','onkeyup'=>"buscar(event,'observaciones')"]) !!}
                                            </th><!--Observaciones-->
                                            <th></th>
                                         {!! Form::close() !!}
                                        </tr>
                                        </thead>
                                        <tbody>
                                            @if(count($data)>0)
                                                @foreach($data as $item)
                                                    <tr>
                                                        <td>{{$item->cobro_planilla_nombre}}</td>
                                                        <input type="hidden" name="con_pen_id"  id="con_pen_id" value="{{ $item->con_pen_id }}">
                                                        <td>
                                                            @php 
                                                                /* $date = gmdate('d-m-Y', $date_excel::ExcelToPHP($item->con_pen_fecha)) */
                                                                $date =  date('Y-m-d H:i:s', $item->con_pen_fecha);
                                                            @endphp
                                                            {{ $date }}
                                                        </td>{{-- con_pen_fecha --}}
                                                        <td>{{$item->con_pen_referencia}}</td>
                                                        <td>{{$item->con_pen_transaccion}}</td>
                                                        <td>
                                                            ₡ {{ number_format($item->con_pen_valor, 2, ',', '.') }}
                                                        </td>
                                                        <td>{{$item->con_pen_concepto}}</td>
                                                        <td>{{$item->con_pen_observaciones}}</td>
                                                        <input type="hidden" name="" id="cobro_id" value="{{ $item->contrato_cliente_id }}">
                                                         <td>
                                                            @if ($item->con_pen_estado == 1)
                                                                
                                                            <div class="btn-group">
                                                                  <a 
                                                                    onclick="data_conciliar('{{ $item->con_pen_id }}','{{$item->con_pen_transaccion}}','{{$item->con_pen_valor}}', '{{ $item->con_pen_fecha }}')" data-toggle="modal" data-target="#conciliar_registro"  class="btn btn-tbl-update btn-xs text-white" data-bs-toggle="tooltip" data-bs-placement="top" title="Conciliar">
                                                                    <i class="fa fa-handshake-o"></i>
                                                                  </a>
                                                                  <a onclick="anular('{{$item->con_pen_id}}')" class="btn btn-tbl-update btn-xs text-white" data-bs-toggle="tooltip" data-bs-placement="top" title="Anula la conciliación del registro.">
                                                                    <i class="fa fa-ban"></i>
                                                                  </a>
                                                            </div>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @else
                                            <tr>
                                                <td colspan="7" class="text-center">Sin registros.</td>
                                            </tr>
                                            @endif
                                        </tbody>
                                    </table>                                   
                                </div>
                            </div>
                            
                        </div>
                        <div class="card-footer">
                            <div class="float-right">
                                 {{ $data->appends([
                                    'referencia' => $referencia,
                                    'transaccion' => $transaccion,
                                    'concepto' => $concepto,
                                    'observaciones' => $observaciones
                                ])->links() }}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
<!----Modal conciliar registro------>
<div class="modal fade" id="conciliar_registro" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" style="display: none;" aria-hidden="true">
  <div class="modal-dialog modal-lg" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h4 class="modal-title" id="exampleModalLabel">Conciliar este registro</h4>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">×</span>
        </button>
      </div>
      {!! Form::open(['url' => '','method'=>'POST','role'=>'form','id'=>'frmContratos','enctype'=>'multipart/form-data']) !!}
      <div class="modal-body">
        <div class="row col-md-12">
          {!! Form::mtext('id',null,'ID',$errors,6,false,true,[['onkeyup'=>'javascript:this.value=this.value.toUpperCase()'],['disabled']]) !!}
          {!! Form::mtext('valor',null,'Valor',$errors,6,false,true,[['onkeyup'=>'javascript:this.value=this.value.toUpperCase()'],['disabled']]) !!}
        </div>
        <div class="row col-md-12">
          {!! Form::mtext('fecha','2020-05-16 13:57:10','Fecha',$errors,6,false,true,[['onkeyup'=>'javascript:this.value=this.value.toUpperCase()'],['disabled']]) !!}
          {!! Form::mtext('transaccion_modal',null,'Transacción',$errors,6,false,true,[['onkeyup'=>'javascript:this.value=this.value.toUpperCase()'],['disabled']]) !!}
        </div>
        <div class="row col-md-12 mb-3">
          

           {{--  <label for="foto" class="form-label">Cliente</label>
            {!! Form::select('cliente', [], null,['class'=>'form-control','id'=>'cliente','placeholder'=>'--Seleccionar--']) !!} --}}
            {!! Form::mselect('cliente',[],null,'Cliente',$errors,6,true) !!}
            
        </div>
        <div class="row col-md-12">
          <div class="card col-md-12">
              <div class="card-head">
                  Cobros
              </div>
              <div class="card-body">
                  <div class="table-responsive">
                      <table class="table table-inbox">
                          <thead>
                              <tr>
                                  <th>#</th>
                                  <th>Contrato</th>
                                  <th>Cuota</th>
                                  <th>Concepto</th>
                                  <th>Valor</th>
                                  <th></th>
                              </tr>
                          </thead>
                          <tbody id="row_conciliar">
                              
                          </tbody>
                          <tfoot>
                                
                                <tr>
                                    <th colspan="4" class="text-right">Total</th>
                                    <th colspan="2" class="text-left"><span id="span_total"></span></th>
                                    <input type="hidden" name="" id="total_pagado" >
                                </tr>
                          </tfoot>
                      </table>
                  </div>
              </div>
          </div>
        </div>
      </div>
      <div class="modal-footer text-center">
        <input type="hidden" name="id_registro" id="id_registro" value="0">
        <button type="button" onclick="conciliarPago()" class="btn bg-success text-white"><!--<i class="fa fa-times"></i>--> Conciliar</button>
        <button type="button" class="btn btn-default" data-dismiss="modal"><!--<i class="fa fa-times"></i>--> Cerrar</button>
      </div>
      {!! Form::close() !!}
    </div>
  </div>
</div>
@endsection
@section('script')
    <script type="text/javascript">



        function conciliarPago(){

           
            $('#conciliar_registro').modal('hide');

            Swal.fire({
                title: 'Confirmación',
                text: '¿Esta seguro que desea conciliar este registro?',
                icon: 'question',
                showCancelButton: true,
                confirmButtonText:`<i class="fa fa-check"></i> Aceptar`,
                cancelButtonText:'<i class="fa fa-ban"></i> Cancelar',
                confirmButtonColor: '#3085d6'
                }).then((result) => {
                if (result.isConfirmed){
                    var url = "{{ URL::asset('pago/conciliar_pago') }}";
                    $.ajax({
                        url: url,
                        type: 'POST',
                        data: {
                            "_token": "{{ csrf_token() }}",
                            "id_registro": $('#id_registro').val(),
                            "id" : $("#con_pen_id").val(),
                            "cliente_id": $('#cliente').val(),
                            "con_pen_valor": $('#total_pagado').val(),
                            "con_pen_transaccion": $('#transaccion_modal').val(),
                            "con_pen_fecha": $('#fecha').val(),
                            "PagoDetalle": $("#row_conciliar").find("input[name^='PagoDetalle']").serializeArray(),
                            
                        },
                        success: function(res){
                            if(res){
                                Swal.fire({
                                title: 'Conciliado',
                                text: 'El registro ha sido conciliado.',
                                icon: 'success',
                                confirmButtonText: 'Aceptar',
                                showConfirmButton: true
                                }).then((result) => {
                                    location.reload();
                                });
                            }else{
                                Swal.fire({
                                title: 'Error',
                                text: 'El registro no ha sido conciliado.',
                                icon: 'error',
                                confirmButtonText: 'Aceptar',
                                showConfirmButton: true
                                }).then((result) => {
                                    location.reload();
                                });
                            }
                        }
                    });
                }
            })




        }



        function data_conciliar(con_pen_id,con_pen_transaccion,con_pen_valor,con_pen_fecha){
            let id_registro = $('#id').val(con_pen_id);
            
            $('#valor').val(con_pen_valor);
            $('#transaccion_modal').val(con_pen_transaccion);
            $('#modal_valor').val(con_pen_valor);
            $('#modal_fecha').val(fecha);
            $('#modal_transaccion').val(transaccion);

            
            
        }
        
        $("#cliente").change(function(){
           let cliente = $(this).val();
           console.log(cliente)
            var url = "{{ URL::asset('pagos/debito_automatico/registros_no_identificados/search/') }}"+"/"+cliente;
            var html = '';
             $.get(url, function(res) {
                var obj = $.parseJSON(res);
                var total = 0;
                var count = 0;
             
                for(var i = 0 ; i < obj[0].length; i++){
                    total += obj[0][i].valor;
                    html += `<tr id="fila_${i}">
                                <td>
                                    <input type="hidden" name="id_registros[]" value="${obj[0][i].cobro_id}"/>
                                    ${i+1}
                                </td>
                                <td>${obj[0][i].contrato}</td>
                                <td>${obj[0][i].cuota}</td>
                                <td>${obj[0][i].concepto}</td>
                                <td>
                                    <input type="hidden" value="${obj[0][i].valor}" id="valor_registro_${i}">
                                    ${obj[0][i].valor}
                                   
                                    <input  type="hidden" name="PagoDetalle['pago_detalle_cobro_id']" value="${obj[0][i].cobro_id}">
                                    <input  type="hidden" name="PagoDetalle[${i}][pago_detalle_saldo]" value="${obj[0][i].valor}">
                                    <input  type="hidden" name="PagoDetalle[${i}][pago_detalle_concepto]" value="${obj[0][i].concepto}">

                                </td>
                                <td><a onclick="remover(${i})" class="btn btn-xs btn-danger"><i class="fa fa-trash"></i>remover</a></td>
                            </tr>`;
                }
                $('#total').val(total);
                document.getElementById('span_total').innerHTML = total;
                $('#total_pagado').val(total);
                document.getElementById('row_conciliar').innerHTML = html;
               // document.getElementById('cliente').value = obj[1][1];
                $.ajax({
                    /* getClientByajax */
                    url: "{{ URL::asset('cliente/data/ajax/') }}"+"/"+obj[1].id,
                    type: 'GET',
                   
                    success: function(res){
                        document.getElementById('cliente').innerHTML = '';
                        console.log(res.cliente_documento);
                        document.getElementById("cliente").options[document.getElementById("cliente").options.length] = new Option((res.cliente_documento + ' ' + res.cliente_nombres + ' ' + res.cliente_apellido1 + ' ' + res.cliente_apellido2), res.cliente_id );
                       /*  $('#asociacion').val(res.cliente_entidad_id).change();
                        console.log(res);
                        $('#cliente').val(res); */
                    }
                })
             });
        })

        function remover(id){
            var total = $('#total').val();
            var total_eliminar = $('#valor_registro_'+id).val();
            var nuevo_total = total-total_eliminar;
             $('#total').val(nuevo_total);
             document.getElementById('span_total').innerHTML = nuevo_total;
            $('#fila_'+id).remove();
            console.log(id);
        }
        function anular(id){
            console.log('anular'+id);
             Swal.fire({
              title: 'Confirmación',
              text: '¿Esta seguro que desea anular el proceso de conciliación para este registro?',
              icon: 'question',
              showCancelButton: true,
              confirmButtonText:`<i class="fa fa-check"></i> Aceptar`,
              cancelButtonText:'<i class="fa fa-ban"></i> Cancelar',
              confirmButtonColor: '#3085d6'
            }).then((result) => {
              if (result.isConfirmed){
                var url = "{{ URL::asset('pagos/debito_automatico/registros_no_identificados/anular/') }}"+"/"+id;
                $.ajax({
                    url: url,
                    type: 'POST',
                    data: {
                        "_token": "{{ csrf_token() }}",
                    },
                    success: function(res){
                        if(res){
                            Swal.fire({
                              title: 'Anulado',
                              text: 'El registro ha sido anulado.',
                              icon: 'success',
                              confirmButtonText: 'Aceptar',
                              showConfirmButton: true
                            }).then((result) => {
                                location.reload();
                            });
                        }else{
                            Swal.fire({
                              title: 'Error',
                              text: 'El registro no ha sido anulado.',
                              icon: 'error',
                              confirmButtonText: 'Aceptar',
                              showConfirmButton: true
                            }).then((result) => {
                                location.reload();
                            });
                        }
                    }
                });
              }
            });
        }
        function generar(){
            $('#accion').val(2);
            document.getElementById("frmFiltros").submit();
        }

        function limpiar(){
            $('#referencia').val('');
            $('#transaccion').val('');
            $('#concepto').val('');
            $('#observaciones').val('');

            document.getElementById("frmFiltros").submit();
        }

        function buscar(e,tipo){
            $('#accion').val(1);
            var textoSelect = $('#'+tipo).val();
            if (e.keyCode === 13 && !e.shiftKey){
                document.getElementById("frmFiltros").submit();
            }
        }

        $(document).ready(function(){
            $('#cliente').select2({
                ajax: {
                    dataType: 'json',
                    url: "{{ asset('') . 'cliente/data/ajax' }}",
                    delay: 250,
                    minimumInputLength: 3,
                    data: function(params) {
                        var query = {
                            search: params.term.toLowerCase(),
                        }

                        return query;
                    },
                    processResults: function(data, page) {
                        return {
                            results: data
                        };
                    },
                    theme: "classic"
                }
            });
        })

    </script>
@endsection