@extends('layouts.planti')
@section('contenido')
@if(Session::has('success'))
<div class="alert alert-info">
    {{Session::get('success')}}
</div>
@endif
@php $oculto = true @endphp
<div class="row">
    <div class="col-md-12 col-sm-12 ">
        <!-- INICIO ENCABEZADO ------------------------------------------------------ -->
        <div class="accordion btn-success" id="accordion" role="tablist" aria-multiselectable="true">
        <div class="panel">
            <a class="panel-heading negro" role="tab" id="headingOne" data-toggle="collapse" data-parent="#accordion" href="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
            <h6 class="panel-title lgris"><span class="fa fa-chevron-down"></span>&nbsp;&nbsp;&nbsp;<b> Definicion Plantilla Expo </b> Registros encontrados <b>{{ count($tblInfo) }}</b> 
                 [ {{ $reg->id }} ] </h6>
            </a>
            <div id ="collapseOne" class="panel-collapse collapse colla" role="tabpanel" aria-labelledby="headingOne">
                <form action = "{{ route('rexdefinicionplantilla.store') }}" method="post" accept-charset="utf-8" enctype="multipart/form-data">
                    @csrf
                
                    <center>
                     <input type = "text" hidden id="txtId" name="txtId" value="{{ $reg->id }}">
                        <div class="col-md-6 col-xs-8">
                            <div class="form-group" >                          
                                <label class="col-md-2 col-lg-4 control-label">Campo Relacion</label>
                                <div class="col-md-2  col-lg-6">
                                    <input type="text" class="form-control" name="txtCampoRelacion" id="txtCampoRelacion" value="{{$reg->campo_relacion}}" />
                                </div>
                            </div>
              
              
                            <div class="form-group">
                                <label class="col-md-4 col-lg-4 control-label">Origen</label>
                                <div class="col-md-4 col-lg-6">
                                  <select class="form-control" name="cboOrigen" id="cboOrigen" onchange="Filtrar(this)" >
                                    @foreach ($EnumOrigen as $item)
                                      <option value="{{$item}}" @if($item==$reg->origen) selected="selected" @endif>{{$item}}</option> 
                                    @endforeach
                                  </select>
                                </div>
                            </div>

                            
                            <div class="form-group" id="Fuente" style="display:none">
                                <label class="col-md-4 col-lg-4 control-label">Fuente</label>
                                <div class="col-md-4 col-lg-6">
                                    <select class="form-control" name="cboIdOrigen" id="cboIdOrigen" >  
                                    @foreach ($fuente as $item) 
                                        <option value="{{$item->id}}" @if($item->id==$reg->id_origen) selected="selected" @endif>{{$item->descripcion}}</option> 
                                    @endforeach                     
                                    </select>
                                </div>
                            </div>
                        

                            <div class="form-group" id="Po">                          
                                <label class="col-md-4 col-lg-4 control-label">Nombre Columna</label>
                                <div class="col-md-4 col-lg-6">
                                    <select class="form-control" name="cboCampo" id="cboCampo" >
                                        @foreach ($ColumnasPO as $item) 
                                        <option value="{{$item->COLUMN_NAME}}" @if($item->COLUMN_NAME==$reg->columna) selected="selected" @endif>{{$item->COLUMN_NAME}}</option> 
                                        @endforeach 
                                    </select>
                                </div>              
                            </div>
                            

                            <div class="form-group">
                                <label class="col-lg-4 control-label">Tipo</label>
                                <div class="col-lg-6">
                                <input type="text" class="form-control" name="txtTipo" id="txtTipo" onkeypress="return pulsar(event)" value="{{$reg->tipo}}" />
                                </div>
                            </div>
                            
                            <div class="form-group">
                                <label class="col-lg-4 control-label">Orden</label>
                                <div class="col-lg-6">
                                    <input type="number" class="form-control" name="txtOrden" id="txtOrden" value="{{$reg->orden}}"/>
                                </div>
                            </div>

                            <div class="form-group">
                                <label for="inactivo">                  
                                <input type="checkbox"  class="form-control" name="inactivo" value="1"  @if ($reg->inactivo == 1)) checked="checked" @endif  /> Inactivar Registro</label>
                            </div>

                            <div class="row">
                                    <button class="btn btn-success sinm"><span class="fa fa-save"></span>&nbsp;Guardar</button>
                                    <a href = " {{asset('/rexdefinicionplantilla')}}" class="btn btn-danger sinm"><spam class="fa fa-file-o sinm"></spam>&nbsp;Nuevo</a>
                            </div> 
                            <br><br> <br>
                        </div>
                    </center>
                    <br><br> <br>
                </form>
            </div>
        </div>
        </div>
        <!-- FIN ENCABEZADO ------------------------------------------------------ -->
        <br>
            <div id = "" class="col-md-12 col-sm-12" role="tabpanel" aria-labelledby="headingOne">
            <Form action = "{{ asset('rexdefinicionplantillasrh') }}" method="post" accept-charset="utf-8" enctype="multipart/form-data">
                @csrf
                <div class="panel-body negro">
                    <table style = "width: 100%">
                        <tr>
                            <td class="abajo">
                                <input type = "text" id="txtBuscar" name="txtBuscar" class="form-control" value="{{ $reg->bus }}" placeholder="Codigo o Nombre de ExDefinicionPlantilla" required>
                            </td> 
                            <td class="abajo">
                                <button class="btn btn-success sinm"><span class="fa fa-search"></span>&nbsp;Buscar</button>
                            </td>
                        </tr>
                        <tr> <td> <br></td></tr> 
                    </table>
                </div>
            </form>
        </div>  
        <div class="x_panel">
            <div class="x_title">
                <div class="clearfix"></div>
            </div>
            <div class="x_content">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-box table-responsive">
                            <table id = "datatable" class="tabla table table-hover" style="color:dimgray">
                                <thead>
                                     <th> <center>CAMPO_RELACION</center></th>
                                     <th> <center>TIPO</center></th>
                                     <th> <center>ORIGEN</center></th>
                                     <th> <center>ID_ORIGEN</center></th>
                                     <th> <center>COLUMNA</center></th>
                                     <th> <center>TABLA_ORIGEN</center></th>
                                     <th> <center>CAMPO_NOMBRE</center></th>
                                     <th> <center>ORDEN</center></th>
                                     <th> <center>INACTIVO</center></th>
                                    <th><center>EDITAR</center></th>
                                    <th><center>ELIMINAR</center></th>
                                </thead>
                                <tbody>
                                    @if(count($tblInfo)) 
                                        @foreach($tblInfo As $fil)  
                                            <tr style = "background-color: {{ ($fil->inactivo==1)?'#FEDFAF':'' }}">  
                                                <td align ="center">{{ $fil->campo_relacion }}</td>
                                                <td align ="center">{{ $fil->tipo }}</td>
                                                <td align ="center">{{ $fil->origen }}</td>
                                                <td align ="center">{{ $fil->id_origen }}</td>
                                                <td align ="center">{{ $fil->columna }}</td>
                                                <td align ="center">{{ $fil->tabla_origen }}</td>
                                                <td align ="center">{{ $fil->campo_nombre }}</td>
                                                <td align ="center">{{ $fil->orden }}</td>
                                                <td align ="center">@if($fil->inactivo==1) <span class='fa fa-remove'></span> @endif</td>
                                                <td align ="center">
                                                    <a href = " {{asset('rexdefinicionplantilla/editar')}}/{{base64_encode($fil->id)}}" class="btn btn-sm btn-success RVERDE" >
                                                    <span class="label label-primary"><i class="fa fa-edit"></i></span></a>
                                                </td>
                                                <td align="center">
                                                    <form action="{{action('ExDefinicionPlantillaController@destroy', base64_encode($fil->id) )}}" method="post" onclick="return confirm('¿Seguro que deseas eliminarlo?')">
                                                      @csrf
                                                      <input name = "_method" type="hidden" value="DELETE">
                                                      <button class="btn btn-danger btn-xs" type="submit"><span class="fa fa-trash"></span></button>
                                                    </form>
                                               </td>
                                            </tr>  
                                        @endforeach
                                    @else
                                          <tr>
                                              <td colspan = "8">No hay registro !!</td>
                                          </tr>
                                    @endif 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>  

<script>

    INIT(document.getElementById("cboOrigen"));
    
    function pulsar(e) {
      tecla=(document.all) ? e.keyCode : e.which;
      if(tecla==32) return false;
    }
  
  
  
    function INIT(sender){
  
        //alert(sender.value);
        if(sender.value=="po"){
          document.getElementById("Po").style.display="initial";
          document.getElementById("Fuente").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";
        
        }else{
          document.getElementById("Po").style.display="none";
          document.getElementById("Fuente").style.display="none";
        }
    }
  
    function Filtrar(sender){
  
      //alert("2: " + sender.value);
      
      if(sender.value=="po"){
         document.getElementById("Po").style.display="initial";
         document.getElementById("Fuente").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";
       
      }else{
  
        document.getElementById("Po").style.display="none";
        document.getElementById("Fuente").style.display="none";
  
      }
  
   
      $.ajax({
          url:'/rexllenarcombo/'+sender.value,
          //data:'/'+sender.value,
          beforeSend: function () {
           
              //jQuery('#loading_spinner').show();
          },
          success:function(data){
           
              //alert("RES: " + 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);
          }
      });
  
  
    }
  
  
  
  
   </script>
@endsection