@extends('admin.admin_dashboard_pyme') 
@section('content')

 

     <section class="pc-container">
      <div class="pc-content">
        <!-- [ breadcrumb ] start -->
        <div class="page-header">
          <div class="page-block">
            <div class="row align-items-center"> 
              <div class="col-md-12">
                <div class="page-header-title">
                  <h2 class="mb-0">Expedientes</h2>
                </div>
              </div>
            </div>
          </div>
        </div>


          <div class="row ">

        
          <div class="col-sm-12">
            <div class="card"> 
              <div class="card-body">
                <div class="text-end p-4 pb-0"> 

                  <div id="exampleModalCenter" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                    <div class="modal-dialog modal-dialog-center" role="document">
                      <div class="modal-content">
                        <div class="modal-header">
                          <h5 class="modal-title" id="exampleModalCenterTitle">Crear expediente PYME</h5>
                          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                        </div>

                      <form class="smart-form" enctype="multipart/form-data"  method="POST"  action="{{ route('expedientes_pyme/add_expediente')}}">
                        @csrf

                        <div class="modal-body"> 
                        <div class="form-group row">
                          <label class="col-sm-3 col-form-label">Tipo de Expediente</label>
                          <div class="col-sm-9">
                            <div class="form-check mb-2" style="text-align: left;">
                              <input class="form-check-input" type="radio" name="flexCheckGarantia" value="0" id="flexCheckGarantia">
                              <label class="form-check-label" for="flexCheckDefault">Con Garantía  </label>
                            </div>
                            <div class="form-check mb-2" style="text-align: left;">
                              <input class="form-check-input" type="radio" name="flexCheckGarantia" value="1" id="flexCheckGarantia">
                              <label class="form-check-label" for="flexCheckChecked"> Sin Garantía </label>
                            </div>  
                          </div>
                        </div>

                        <div class="form-group row">
                          <label class="col-sm-3 col-form-label">Tipo de Persona</label>
                          <div class="col-sm-9">
                            <div class="form-check mb-2" style="text-align: left;">
                              <input class="form-check-input" type="radio" name="flexCheckPersona" value="0" id="flexCheckPersona">
                              <label class="form-check-label" for="flexCheckDefault"> Física</label>
                            </div>
                            <div class="form-check mb-2" style="text-align: left;">
                              <input class="form-check-input" type="radio" name="flexCheckPersona" value="1" id="flexCheckPersona">
                              <label class="form-check-label" for="flexCheckChecked"> Moral </label>
                            </div>  
                          </div>
                        </div>

                        </div>
                        <div class="modal-footer">
                          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button> 
                          <button type="button" class="btn btn-outline-primary" data-bs-dismiss="modal">Crear Expediente</button>  
                        </div>
                      </div>
                    </div>
                  </div>



 
 
              </div>
            <button type="submit" class="btn btn-primary pull-left" name="guardar_btn" value="inicia_expediente"  >Crear Expediente PYME</button> 

                <div class="table-responsive dt-responsive">
                  <table id="table-inventory-cat" class="table table-striped table-bordered">
                    <thead>
                      <tr>
                      <th><input type="text" class="form-control form-control-sm"  style="width: 50px" /></th>  
                      <th >
                        

                      </th> 
                      <th ></th> 
                      <th ></th> 
                      <th ></th> 
                      <th >
                        <select class="form-select form-select-sm" id="filter-column-6">
                    <option  value="0"></option> 
                    @foreach($bancos as $bancos) 
                      @if($bancos->pyme==1)                 
                        <option value="{{ $bancos->nombre}}">{{ $bancos->nombre}}</option>  
                        @endif 
                    @endforeach 
                  </select>

                      </th> 
                      <th ></th> 
                      <th ></th> 
                      <th ></th> 
                      </tr>



                      <tr>
                      <th>No.Exp</th> 
                      <th>Modificación</th>          
                      <th>Asociado</th>    
                      <th >Sucursal</th>
                      <th >Cliente</th>
                      <th >Inst. Financiera</th> 
                      <th >Coordinador</th> 
                      <th >Estado</th> 
                      <th >Garantía</th> 
                      </tr>



                    </thead>
                    <tbody>
                    @foreach($expedientes as $expediente)                   



                      <tr> 
                       <td style="color: blue">{{ $expediente->id_expediente }} </td>                                          
                        <td>{{ $expediente->updated_at}}</td>       
                        <td>{{ $expediente->user_name_v}}</td>    


                        <td>{{ $expediente->sucursales_name}}</td>    
                        

                        <td style="color:blue"> 
                          @if($expediente->tipo_cliente==1)
                         {{ $expediente->razon_social_moral}}  
                          @else
                           {{ $expediente->cliente}}  {{ $expediente->apellido_paterno}}  {{ $expediente->apellido_materno}}  
                          @endif
                          </td> 

                        <td style="color:darkred">{{ $expediente->banco_name}}</td>               
                        <td>{{ $expediente->user_name}}</td>

                        @if($expediente->id_cancelar>0)

                        <td style="color:red">{{ $expediente->estado}}</td> 
                        @else
                            @if($expediente->estado1==1)  
                                <td style="background-color: #31b2e4;">
                              <a href="../expediente_precalif_pyme/edit/{{ $expediente->id}}" style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td>
                            @elseif ($expediente->estado1==2)
                                <td style="background-color: #ff8c00; ">
                              <a href="../expediente_avaluo_pyme/edit/{{ $expediente->id}}" style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td> 
                            @elseif ($expediente->estado1==3)
                                <td style="background-color: #800080;">
                              <a href="../expediente_instruccion_pyme/edit/{{ $expediente->id}}" style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td> 
                            @elseif ($expediente->estado1==4)
                                <td style="background-color: #228b22;">
                              <a href="../expediente_firma_pyme/edit/{{ $expediente->id}}" style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td> 
                            @elseif ($expediente->estado1==5) 
                                <td style="background-color: darkblue;">
                              <a href="../expediente_formalizado_pyme/edit/{{ $expediente->id}}"  style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td>  
                            @elseif ($expediente->estado1==5)  
                                <td style="background-color: darkblue;">
                              <a href="../expediente_formalizado_pyme/edit/{{ $expediente->id}}"  style=" color: white">
                                  {{ $expediente->estado}}
                              </a>
                                </td>  
                            @endif

                          @endif         
                   
                        <td>
                          @if($expediente->garantia==0)
                          Con garantía
                          @else
                          Sin garantía
                          @endif
                        </td>
         
                      </tr>
                    @endforeach

                    </tbody> 
                  </table>
                </div>
              </div>
            </div>
          </div>
 
 </div>
</div>
</section>

          <!-- DOM/Jquery table end -->
<!--main--> 

    <!-- datatable Js --> 
 <style type="text/css">
   table {
    font-size: .8em !important;
   }

   th {
    font-size: .8em !important;
   }

 </style>
 
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
    <script src="{{ URL::asset('js/plugins/jquery.dataTables.min.js')}}"></script>
    <script src="{{ URL::asset('js/plugins/dataTables.bootstrap5.min.js')}}"></script>
    <script src="{{ URL::asset('js/plugins/dataTables.responsive.min.js')}}"></script>
    <script src="{{ URL::asset('js/plugins/responsive.bootstrap5.min.js')}}"></script>

    <script>
      // [ DOM/jquery ] 
 $(document).ready(function()
            {
 var table = $('#table-inventory-cat').DataTable({
    orderCellsTop: true,
    fixedHeader: true,
    "order": [[1, "desc"]]  // Columna 0 -> descendente
  });

  // Aplicar búsqueda por columna
  $('#table-inventory-cat thead tr:eq(0) th').each(function(i) {
    $('input', this).on('keyup change', function() {
      if (table.column(i).search() !== this.value) {
        table.column(i).search(this.value).draw(); 
      }
    });
  });


    $('#table-inventory-cat thead tr:eq(1) th input').on('keyup change', function() {
    var colIndex = $(this).parent().index();
    if (table.column(colIndex).search() !== this.value) {
      table.column(colIndex).search(this.value).draw();
    }
    });



    $('#filter-column-6').on('change', function() {
        var searchTerm = this.value ? '^' + this.value + '$' : ''; // Para hacer la búsqueda exacta

        // Filtro en la columna 6 (index 5, porque DataTables empieza a contar desde 0)
        table.column(5).search(searchTerm, true, false).draw();
    });

   

     
                
    }); // FIN DE TABLA
 
    </script>

@stop