@extends('layouts.planti')

@section('contenido')

<div class="container">
  <div class="row justify-content-center">
      <div class="col-md-11">
          <div class="card">
          <center><h2>Actualizar Registro de Tablero Exportación</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.update',$tablero->id) }}" role="form">
                @csrf  
              @method('PUT')
              <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}}" @if($item==$tablero->origen) selected="selected" @endif>{{$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" >  
                     @foreach ($fuente as $item) 
                       <option value="{{$item->id}}" @if($item->id==$tablero->id_origen) selected="selected" @endif>{{$item->descripcion}}</option> 
                     @endforeach                     
                  </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}}" @if($item->COLUMN_NAME==$tablero->columna) selected="selected" @endif>{{$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" value="{{$tablero->campo_relacion}}"/>
                  </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}}" @if($item->TABLE_NAME==$tablero->tabla_ws) selected="selected" @endif>{{$item->TABLE_NAME}}</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" value="{{$tablero->funcion}}" />
              </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="txtNombre" value="{{$tablero->titulo}}" />
              </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" value="{{$tablero->orden}}"/>
                </div>
            </div>

            <div class="form-group">
              <label class="col-lg-5 control-label">Mostrar en:</label>
              <div class="col-lg-7">

                <div> {{-- class="toc" --}}
                  <h4>  
                    @php

                        $boolTablero   = false;
                        $boolReporte   = false;
                        $boolHistorico = false;
                        $boolDetalle   = false;
                        $boolCliente   = false;

                        $mostrar_en = explode(",",$tablero->mostrar_en);
                      
                        foreach($mostrar_en as $valor ) {
                          switch (trim($valor)) {
                            case 'Tablero': $boolTablero     = true; break;
                            case 'Reporte': $boolReporte     = true; break;
                            case 'Historico': $boolHistorico = true; break;
                            case 'Detalle': $boolDetalle     = true; break;
                            case 'Cliente': $boolCliente     = true; break;

                          }
                        }

                    @endphp
                    
                      <input type="checkbox" name="chkMostrar[]" value="Tablero"  @if($boolTablero) checked @endif> Tablero &nbsp;&nbsp;
                      <input type="checkbox" name="chkMostrar[]" value="Reporte"  @if($boolReporte) checked @endif> Reporte &nbsp;&nbsp;
                      <input type="checkbox" name="chkMostrar[]" value="Historico" @if($boolHistorico) checked @endif> Historico &nbsp;&nbsp;
                      <input type="checkbox" name="chkMostrar[]" value="Detalle"  @if($boolDetalle) checked @endif> Detalle &nbsp;&nbsp;
                      <input type="checkbox" name="chkMostrar[]" value="Cliente"  @if($boolCliente) checked @endif> Cliente
                
                  </h4>
                </div> 


              </div>
            </div>

                <div class="form-group">
                    <label for="inactivo">                  
                    <input type="checkbox"  class="form-control" name="inactivo" value="1"  @if ($tablero->inactivo == 1)) checked="checked" @endif  /> Inactivar Registro</label>
                </div>
            
                <div class="d-sm-flex align-items-center justify-content-between mb-4">
                  <button type="submit" class="btn btn-primary shadow-sm">Actualizar</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>

  Filtrar(document.getElementById("cboOrigen"));
  

  function Filtrar(sender){

    //alert(sender.value);
    
    if(sender.value=="po"){
       document.getElementById("Po").style.display="initial";

       document.getElementById("Fuente").style.display="none";
       document.getElementById("TablaWS").style.display="none";
       document.getElementById("CampoWS").style.display="none";

    } else if(sender.value=="adicionales_po" || sender.value=="medicion" || sender.value=="etapa"){
       document.getElementById("Fuente").style.display="initial";
       
       document.getElementById("Po").style.display="none";
       document.getElementById("TablaWS").style.display="none";
       document.getElementById("CampoWS").style.display="none";
     
    } else if(sender.value=="websimex"){  
       
       document.getElementById("TablaWS").style.display="initial";       
       document.getElementById("CampoWS").style.display="initial";

       document.getElementById("Fuente").style.display="none";
       document.getElementById("Po").style.display="none";
      
       //CampoWS(document.getElementById("cboTablaWS")); 
    
    }else{

      document.getElementById("Po").style.display="none";
      document.getElementById("Fuente").style.display="none";
      document.getElementById("TablaWS").style.display="none";
      document.getElementById("CampoWS").style.display="none";
    }

 
    $.ajax({
        url:'/rllenarcombo/'+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){
    //alert(sender.value);
     $.ajax({
          //url:'/rcamposws/'+sender.value,
          url:'/rllenarcombows/'+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