@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>ExDefinicionMediciones : </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('rexdefinicionmediciones.store') }}" method="post" accept-charset="utf-8" enctype="multipart/form-data">
                    @csrf
                    <div class="panel-body negro">
                    <center>
                      <input type = "text" hidden id="txtId" name="txtId" value="{{ $reg->id }}">
                     <table style="border-spacing: 10px !important; border-collapse: separate !important;">
                        <tr>
                            <td class="abajo">
                                MEDICION
                                <input type = "text" id="txtMedicion" name="txtMedicion" Class="form-control" value="{{ $reg->medicion }}" required>
                            </td>
                            <td class="abajo">
                                DESCRIPCION
                                <input type = "text" id="txtDescripcion" name="txtDescripcion" Class="form-control" value="{{ $reg->descripcion }}" required>
                            </td>
                            <td class="abajo">
                                SQL
                                <input type = "text" id="txtSql" name="txtSql" Class="form-control" value="{{ $reg->sql }}" required>
                            </td>
                            <td class="abajo">
                                SQLDETALLE
                                <input type = "text" id="txtSqldetalle" name="txtSqldetalle" Class="form-control" value="{{ $reg->sqldetalle }}" required>
                            </td>
                            <td class="abajo">
                                ID_ETAPA_INICIAL
                                <select name = "cboEtapainicial" id="cboEtapainicial" class="form-control"> 
                                     <option value = "" > SIN ASIGNAR</Option> 
                                     @if(count($datEtapainicial))  
                                         @foreach($datEtapainicial as $fil) 
                                             <Option @if($fil->id==$reg->id_etapa_inicial) selected="selected" @endif value="{{ $fil->id  }}">{{ $fil->descripcion }}</option> 
                                         @endforeach 
                                     @endif
                                </select> 
                            </td>
                            <td class="abajo">
                                TXT_INICIAL
                                <input type = "text" id="txtTxt_Inicial" name="txtTxt_Inicial" Class="form-control" value="{{ $reg->txt_inicial }}" required>
                            </td>
                            <td class="abajo">
                                ID_ETAPA_FINAL
                                <select name = "cboEtapafinal" id="cboEtapafinal" class="form-control"> 
                                     <option value = "" > SIN ASIGNAR</Option> 
                                     @if(count($datEtapafinal))  
                                         @foreach($datEtapafinal as $fil) 
                                             <Option @if($fil->id==$reg->id_etapa_final) selected="selected" @endif value="{{ $fil->id  }}">{{ $fil->descripcion }}</option> 
                                         @endforeach 
                                     @endif
                                </select> 
                            </td>
                            <td class="abajo">
                                TXT_FINAL
                                <input type = "text" id="txtTxt_Final" name="txtTxt_Final" Class="form-control" value="{{ $reg->txt_final }}" required>
                            </td>
                            <td class="abajo">
                                OPERADOR_LOGICO
                                <input type = "text" id="txtOperador_Logico" name="txtOperador_Logico" Class="form-control" value="{{ $reg->operador_logico }}" required>
                            </td>
                            <td class="abajo">
                                META
                                <input type = "text" id="txtMeta" name="txtMeta" Class="form-control" value="{{ $reg->meta }}" required>
                            </td>
                            <td class="abajo">
                                TIPO
                                <input type = "text" id="txtTipo" name="txtTipo" Class="form-control" value="{{ $reg->tipo }}" required>
                            </td>
                            <td class="abajo">
                                RANGO1
                                <input type = "text" id="txtRango1" name="txtRango1" Class="form-control" value="{{ $reg->rango1 }}" required>
                            </td>
                            <td class="abajo">
                                RANGO2
                                <input type = "text" id="txtRango2" name="txtRango2" Class="form-control" value="{{ $reg->rango2 }}" required>
                            </td>
                            <td class="abajo">
                                RANGO3
                                <input type = "text" id="txtRango3" name="txtRango3" Class="form-control" value="{{ $reg->rango3 }}" required>
                            </td>
                            <td class="abajo">
                                RANGONA
                                <input type = "text" id="txtRangona" name="txtRangona" Class="form-control" value="{{ $reg->rangona }}" required>
                            </td>
                            <td class="abajo">
                                FILTRO1
                                <input type = "text" id="txtFiltro1" name="txtFiltro1" Class="form-control" value="{{ $reg->filtro1 }}" required>
                            </td>
                            <td class="abajo">
                                FILTRO2
                                <input type = "text" id="txtFiltro2" name="txtFiltro2" Class="form-control" value="{{ $reg->filtro2 }}" required>
                            </td>
                            <td class="abajo">
                                INACTIVO
                                <input type = "checkbox" id="chkInactivo" name="chkInactivo" Class="form-control" value="1"  @if ($reg->inactivo == 1)) checked="checked" @endif >
                            </td>
                        </tr>
                        <tr> <td> <br></td></tr>   
                        <tr>
                            <td colspan = "4">
                                 <button class="btn btn-success sinm"><span class="fa fa-save"></span>&nbsp;Guardar</button>
                                 <a href = " {{asset('/rexdefinicionmediciones')}}" class="btn btn-danger sinm"><spam class="fa fa-file-o sinm"></spam>&nbsp;Nuevo</a>
                            </td>
                        </tr>
                        <tr> <td> <br></td></tr> 
                     </table>
                    </center>
                    </div>
                </form>
            </div>
        </div>
        </div>
        <!-- FIN ENCABEZADO ------------------------------------------------------ -->
        <br>
            <div id = "" class="col-md-12 col-sm-12" role="tabpanel" aria-labelledby="headingOne">
            <Form action = "{{ asset('rexdefinicionmedicionessrh') }}" 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 ExDefinicionMediciones" 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>MEDICION</center></th>
                                     <th> <center>DESCRIPCION</center></th>
                                     <th> <center>SQL</center></th>
                                     <th> <center>SQLDETALLE</center></th>
                                     <th> <center>ID_ETAPA_INICIAL</center></th>
                                     <th> <center>TXT_INICIAL</center></th>
                                     <th> <center>ID_ETAPA_FINAL</center></th>
                                     <th> <center>TXT_FINAL</center></th>
                                     <th> <center>OPERADOR_LOGICO</center></th>
                                     <th> <center>META</center></th>
                                     <th> <center>TIPO</center></th>
                                     <th> <center>RANGO1</center></th>
                                     <th> <center>RANGO2</center></th>
                                     <th> <center>RANGO3</center></th>
                                     <th> <center>RANGONA</center></th>
                                     <th> <center>FILTRO1</center></th>
                                     <th> <center>FILTRO2</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->medicion }}</td>
                                                <td align ="center">{{ $fil->descripcion }}</td>
                                                <td align ="center">{{ $fil->sql }}</td>
                                                <td align ="center">{{ $fil->sqldetalle }}</td>
                                                <td align ="center">{{ $fil->id_etapa_inicial }}</td>
                                                <td align ="center">{{ $fil->txt_inicial }}</td>
                                                <td align ="center">{{ $fil->id_etapa_final }}</td>
                                                <td align ="center">{{ $fil->txt_final }}</td>
                                                <td align ="center">{{ $fil->operador_logico }}</td>
                                                <td align ="center">{{ $fil->meta }}</td>
                                                <td align ="center">{{ $fil->tipo }}</td>
                                                <td align ="center">{{ $fil->rango1 }}</td>
                                                <td align ="center">{{ $fil->rango2 }}</td>
                                                <td align ="center">{{ $fil->rango3 }}</td>
                                                <td align ="center">{{ $fil->rangona }}</td>
                                                <td align ="center">{{ $fil->filtro1 }}</td>
                                                <td align ="center">{{ $fil->filtro2 }}</td>
                                                <td align ="center">@if($fil->inactivo==1) <span class='fa fa-remove'></span> @endif</td>
                                                <td align ="center">
                                                    <a href = " {{asset('rexdefinicionmediciones/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('ExDefinicionMedicionesController@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>   
@endsection