@extends('dlayout')

  

@section('content')

<div class="container">

    <div class="row justify-content-center">

        <div class="col-md-12">
        <br><br>
            <div class="card">





            <div>
        <div class="mx-auto pull-right">
            <div class="col-4 float-right">
                <form action="{{ route('usersearch') }}" method="POST" role="search">

                    <div class="input-group">
                        
                    @csrf
                        <input type="text" class="form-control mr-2" name="names" placeholder="Search user name or ID" id="term">
                       
                        <span class="input-group-btn mr-5 mt-1">
                            <button class="btn btn-info" type="submit" title="Search projects">
                                Search<span class="fas fa-search"></span>
                            </button>
                        </span>
                    </div>
                </form>
            </div>
        </div>
    </div>
















                <div class="card-header"> Users </div>
                <button style="width:150px;" type="button" class="btn btn-primary" id="btnExport" onclick="exportReportToExcel(this)">EXPORT REPORT</button>
<script>
function exportReportToExcel() {
  let table = document.getElementsByTagName("table"); // you can use document.getElementById('tableId') as well by providing id to the table tag
  TableToExcel.convert(table[0], { // html code may contain multiple tables so here we are refering to 1st table tag
    name: 'users.xlsx', // fileName you could use any name
    sheet: {
      name: 'Sheet 1' // sheetName
    }
  });
}
</script>

                <table class="table table-hover">
  <thead>
    <tr>
      <th scope="col">id </th>
      <th scope="col">Names</th>
      <th scope="col">Telephone</th>
      <th scope="col">Email </th>
      <th scope="col">Current Balance</th>
      <th scope="col">Loan Limit</th>
      <th scope="col">Enrolled</th>
      <th scope="col">Account status</th>
      <th scope="col"> User signup Date </th>

    </tr>
  </thead>
  <tbody>

  @foreach($users as $user)

  <tr>
      <th scope="row"> {{ $user->id }}</th> 
      <td>  {{ $user->names }}</td>
      <td>  {{ $user->telephone }}</td>
      <td>  {{ $user->email }}</td>
      <td>  {{ $user->balance }}</td>
      <td>  {{ $user->loanlimit }}</td>
      <td>  {{ $user->password }}</td>
      <td>  {{ $user->totalbalance }}</td>
      <td> {{ $user->created_at }} ,
      <a  href="{{ route('userdetails',['id'=> $user->id]) }}" > 
        <button type="button" class="btn btn-primary"> details</button>
  </a>
      </td>
    </tr>
@endforeach
    



  </tbody>
</table>



{{-- Pagination --}}

  <div class="pagination">
    {!! $users->links() !!}
</div>


<div>


</div>




  


                </div>

            </div>

        </div>

    </div>

</div>

@endsection