@extends('layouts.planti')

@section('contenido')
<!--<style>
  .uper {
    margin-top: 40px;
  }
</style>-->


<div class="container">
  <div class="row justify-content-center">
    <div class="col-md-11">
      <div class="card">
      <!--<div class="card uper">-->
      <center><h2>Agregar Registro de Tablero Exportaciones</h2></center>
       <div class="card-body">
            @if ($errors->any())
              <div class="alert alert-danger">
                <ul>
                    @foreach ($errors->all() as $error)
                      <li>{{ $error }}</li>
                    @endforeach
                </ul>
              </div><br />
            @endif
            <center> 
            <div class="row">
              <div class="col-md-10 col-xs-12">
            
                <br />
                    <form  class="form-horizontal" method="post" action="{{ route('rextablero.store') }}">
                    
                      @csrf

                      <div class="form-group">
                          <label class="col-lg-6 control-label">Origen</label>
                          <div class="col-lg-6">
                            <select class="form-control" name="cboOrigen" id="cboOrigen" onchange="Filtrar(this)" >
                              @foreach ($EnumOrigen as $item)
                                <option value="{{$item}}">{{$item}}</option> 
                              @endforeach
                            </select>
                          </div>
                      </div>

                      <div class="form-group" id="Fuente" style="display:none">
                          <label class="col-lg-6 control-label">Fuente</label>
                          <div class="col-lg-6">
                            <select class="form-control" name="cboIdOrigen" id="cboIdOrigen" >                     
                            </select>
                          </div>
                      </div>


                      <div class="form-group" id="Po">                          
                        <label class="col-lg-6 control-label">Nombre del Campo</label>
                        <div class="col-lg-6">
                            <select class="form-control" name="cboCampo" id="cboCampo" >
                                 @foreach ($ColumnasPO as $item) 
                                  <option value="{{$item->COLUMN_NAME}}">{{$item->COLUMN_NAME}}</option> 
                                 @endforeach 
                              </select>
                        </div>

                          <div class="form-group" >                          
                            <label class="col-lg-6 control-label">Nombre Campo Relacion</label>
                            <div class="col-lg-6">
                                <input type="text" class="form-control" name="txtCampoRelacion" id="txtCampoRelacion" />
                            </div>
                          </div>
                      </div>

                     


                      <div class="form-group" id="TablaWS" style="display:none">
                        <label class="col-lg-6 control-label">Nombre de Tabla</label>
                        <div class="col-lg-6">
                          <select class="form-control" name="cboTablaWS" id="cboTablaWS" onchange="CampoWS(this)">
                            <option value="0">Seleccione un Registro</option>
                            @foreach ($TablasWS as $item) 
                               <option value="{{$item->TABLE_NAME}}">{{$item->TABLE_NAME}}</option> 
                            @endforeach 
                          </select>
                        </div>
                      </div>
                  

                      <div class="form-group" id="CampoWS" style="display:none">
                        <label class="col-lg-6 control-label">Nombre del Campo WS</label>
                        <div class="col-lg-6">
                          <select class="form-control" name="cboCampoWS" id="cboCampoWS">
                            {{-- @foreach ($EnumOrigen as $item) 
                                 <option value="{{$item}}">{{$item}}</option> 
                                @endforeach --}}
                          </select>
                        </div>
                      </div> 
                      
                      <div class="form-group">
                        <label class="col-lg-6 control-label">Funcion SQL</label>
                        <div class="col-lg-6">
                          <input type="text" class="form-control" name="txtFuncion" id="txtFuncion" />
                        </div>
                      </div>

                      <div class="form-group">
                        <label class="col-lg-6 control-label">Titulo del Campo</label>
                        <div class="col-lg-6">
                          <input type="text" class="form-control" name="txtTitulo" id="txtTitulo" onkeypress="return pulsar(event)"/>
                        </div>
                      </div>

                      <div class="form-group">
                          <label class="col-lg-6 control-label">Orden</label>
                          <div class="col-lg-6">
                            <input type="number" class="form-control" name="txtOrden" id="txtOrden" />
                          </div>
                      </div>

                      <div class="form-group">
                        <label class="col-lg-5 control-label">Mostrar en:</label>
                        <div class="col-lg-7">
                          <input type="checkbox" name="chkMostrar[]" value="Tablero"  > Tablero &nbsp;&nbsp;
                          <input type="checkbox" name="chkMostrar[]" value="Reporte"  > Reporte &nbsp;&nbsp;
                          <input type="checkbox" name="chkMostrar[]" value="Historico"> Historico &nbsp;&nbsp;
                          <input type="checkbox" name="chkMostrar[]" value="Detalle"  > Detalle &nbsp;&nbsp;
                          <input type="checkbox" name="chkMostrar[]" value="Cliente"  > Cliente 

                          {{-- <select class="form-control" name="cboMostrar" id="cboMostrar">
                            <option value="0">Seleccione un Registro</option>
                            @foreach ($EnumMostrar as $item) 
                                <option value="{{$item}}">{{$item}}</option> 
                            @endforeach 
                          </select> --}}
                        </div>
                      </div>

                      <div class="form-group">
                        <div class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
                        <button class="btn btn-success" type="reset">Limpiar</button>
                        <button type="submit" class="btn btn-primary">Guardar</button>                     
                        <a href="{{ route('rextablero.index') }}" class="btn btn-warning shadow-sm" >Cancelar</a>
                      </div>
                        
                    </form>
              </div>
            </div>
           </center>
                          
         </div>
       </div>
     </div>
   </div>
 </div>

 <script>

  function pulsar(e) {
    tecla=(document.all) ? e.keyCode : e.which;
    if(tecla==32) return false;
  }

    
  function Filtrar(sender){

    //alert(sender.value);
    
    if(sender.value=="ex_po"){
       $('#Po').show();

       $('#Fuente').hide();
       $('#TablaWS').hide();
       $('#CampoWS').hide();
     // dd(sender.value);
    } else if(sender.value=="adicionales_po" || sender.value=="medicion" || sender.value=="etapa"){
      $('#Fuente').show();

      $('#Po').hide();
      $('#TablaWS').hide();
      $('#CampoWS').hide();
     
    } else if(sender.value=="websimex"){
      $('#TablaWS').show();
      $('#CampoWS').show();

      $('#Fuente').hide();
      $('#Po').hide();
      
    
    }else{

      $('#TablaWS').hide();
      $('#CampoWS').hide();      
      $('#Fuente').hide();
      $('#Po').hide();
    }

 
    $.ajax({
        url:'/rexllenarcombo/'+sender.value,
        //data:'/'+sender.value,
        beforeSend: function () {
         
            //jQuery('#loading_spinner').show();
        },
        success:function(data){
         
            //jQuery('#loading_spinner').hide()
            var option = '<option value="">Seleccione un(a) '+sender.value+'</option>'
            for (var i=0; i<data.length;i++){
                nombre="descripcion";
                option+='<option value="'+data[i].id+'">'+data[i][nombre]+'</option>';
            }
            $("#cboIdOrigen").html(option);
        }
    });


  }


  function CampoWS(sender){
     
     $.ajax({
          //url:'/rcamposws/'+sender.value,
          url:'/rexllenarcombows/'+sender.value,
          //data:'/'+sender.value,
          beforeSend: function () {            
              //jQuery('#loading_spinner').show();
          },
          success:function(data){
               
              //jQuery('#loading_spinner').hide()
              var option = '<option value="">Seleccione un Registro</option>'
              nombre="COLUMN_NAME";
          
              for (var i=0; i<data.length;i++){ 
                // alert(i+") " + data[i][nombre] + " --- "+  data[i].COLUMN_NAME);                                           
                option+='<option value="'+data[i][nombre]+'">' + data[i].COLUMN_NAME +'</option>';
              }
              $("#cboCampoWS").html(option);
          }
      });
   }

 </script>
@endsection