@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>
      
      <td>  
         

      </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>
      <td>  


      </td>

    </tr>
@endif

@endforeach
    
  </tbody>
</table>




{{-- Pagination --}}

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












                </div>

            </div>

        </div>

    </div>
  
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</div>

@endsection