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

        
<div class="pc-container">
    <div class="pc-content">
 
        <div class="card"> 
              <div class="card-body">
                  <h2 class="mb-0">Reporte de Bancos</h2>
                <div class="text-end p-4 pb-0"> 
  


                </div>
         
        <div class="col-sm-12">

      <!-- [ breadcrumb ] start -->
     <form  role="form" method="POST" enctype="multipart/form-data"  action="{{ route('reporte_eficiencia_excel') }}">
      <div class="row"> 
            @csrf
          <div class="col-md-12"> 
 
        <div class="row">

            <div class="col-md-6">
                 <label for="fecha_inicio" class="form-label">Fecha Inicio</label>
                        <input type="date" name="fecha_inicio" class="form-control" required>
            </div>

          <div class="col-md-6">
                <label for="fecha_fin" class="form-label">Fecha Fin</label>
                        <input type="date" name="fecha_fin" class="form-control" required>
            </div>
         

          </div>
 
    <div class="table-responsive dt-responsive">
                  <table id="table-inventory-cat" class="table table-striped table-bordered">
                    <thead>
                      
                      <tr> 
                      <th >Cliente</th>         
                      <th>Monto</th>    
                      <th>Asociado</th>    
                      <th >Sucursal</th>
                      <th >Inst. Financiera</th>   
                      <th >Fecha Firma</th>
                      <th >Entidad</th>
                      <th >Municipio</th>
                      <th >Asesor</th>
                      <th >Oficina</th>
                      </tr>

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

                   
                      <tr> 
                                                      
                        <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>{{ $expediente->monto_solicitado}}</td>       
                        <td>{{ $expediente->user_name_v}}</td>     
                        <td>Toluca</td>     
                        <td style="color:darkred">{{ $expediente->banco_name}}</td>               
                        <td>{{ $expediente->fecha_firma}}</td>     

 
                        <td></td>     
                        <td></td>     
                        <td></td>     
                        <td></td>     
 
                      </tr>
                    @endforeach

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

            <div class="col-md-6">
              <div class="text-end btn-page mb-0 mt-4">
                <a href="#" class="btn btn-outline-secondary">Regresar</a> 
          

                <button type="submit" class="btn btn-primary">Descargar Excel </button>
         
              </div>
            </div>  

        </div> 

             
        </form>
      <!-- [ Main Content ] end -->
        </div>
      </div>
    </div>

  </div>
</div>

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

    <!-- datatable Js --> 
 
 
<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>

 <style type="text/css"> 
        .pc-container{
          padding-top: 50px;
        }
    </style>
   

@endsection