@extends('dlayout')

  

@section('content')

<div class="container">

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

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

                <div class="card-header"> Loans </div>
                <button style="width:150px;" type="button" class="btn btn-success" 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: 'loans.xlsx', // fileName you could use any name
    sheet: {
      name: 'Sheet 1' // sheetName
    }
  });
}
</script>

                <table class="table table-hover">
  <thead>
    <tr>
    <th scope="col">Loan_Id</th>
      <th scope="col">User name</th>
      <th scope="col">Loan Amount</th>
      <th scope="col">Interest </th>
      <th scope="col">Interest Amount </th>
      <th scope="col">Amount to be Paid</th>
      <th scope="col">Amount Paid</th>
      <th scope="col">Amount Remaining</th>
      <th scope="col">Loan Status</th>
      <th scope="col">Date Taken</th>
      <th scope="col">Date for payment</th>
    </tr>
  </thead>
  <tbody>

  @foreach($loans as $user)


  @if ($user->interest== "15%")
  <tr>
      <td>  {{ $user->id }}</td>
      <td>  {{ $user->names }}</td>
      <td>  {{ ($user->amount_requested)/1.15 }}</td>
      <td>  {{ $user->interest }}</td>
      <td>  {{ ($user->amount_requested)-(($user->amount_requested)/1.15) }}</td>
      <td>  {{ $user->totaltobepaid }}</td>
      <td>  {{ $user->amount_paid }}</td>
      <td>  {{ $user->amount_remaining }}</td>
      <td>  {{ $user->loan_status }}</td>
      <td>  {{ $user->date_taken }}</td>
      <td>  {{ $user->dateforpayment }}</td>

    </tr>
@else
<tr>
      <td>  {{ $user->id }}</td>
      <td>  {{ $user->names }}</td>
      <td>  {{ ($user->amount_requested) }}</td>
      <td>  {{ $user->interest }}</td>
      <td>  {{ ($user->totaltobepaid)-($user->amount_requested) }}</td>
      <td>  {{ $user->totaltobepaid }}</td>
      <td>  {{ $user->amount_paid }}</td>
      <td>  {{ $user->amount_remaining }}</td>
      <td>  {{ $user->loan_status }}</td>
      <td>  {{ $user->date_taken }}</td>
      <td>  {{ $user->dateforpayment }}</td>

    </tr>
@endif

@endforeach
    
  </tbody>
</table>






{{-- Pagination --}}

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


  


                </div>

            </div>

        </div>

    </div>

</div>

@endsection