@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 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>
      <th scope="col">Comment</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->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>  
      @foreach($user->loancomment as $loancomment)  
      {{ $loancomment->comment }} <hr><br>
      @endforeach 

<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#myModal">
Comment
  </button>

<!-- Modal -->
<!--div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"-->
<div class="modal fade" id="myModal">
<div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Loan Comment</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>

      
      <form action="{{ route('postloancomment') }}" method="POST">
          @csrf
      <div class="modal-body" >
      
      <input type="text" name="userid" value="{{ $user->id_user }}" >
      <input type="text" name="loanid" value="{{ $user->id}}" >

    <label for="exampleFormControlTextarea1">Enter Comment</label>
    <textarea name="comment" class="form-control" id="exampleFormControlTextarea1" rows="3"></textarea>

      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <button type="submit" class="btn btn-primary">Save changes</button>
      </div>
      </form>

      

    </div>
  </div>
</div>







      </td>

    </tr>
@else
<tr>
      <td>  {{ $user->id }}</td>
      <td>  {{ $user->id_user }} , {{ $user->names }} </td>
      <td>  {{ ($user->amount_requested) }}</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>  
      @foreach($user->loancomment as $loancomment)  
      {{ $loancomment->comment }} <hr>
      @endforeach 

      <a  href="{{ route('postcomment',['userid'=> $user->id_user , 'loanid'=>$user->id ]) }}" > 
      <button type="button" class="btn btn-primary" >Comment</button>
      </a>
 


      </td>

    </tr>
@endif

@endforeach
    
  </tbody>
</table>







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