@extends('adminlte::page')

@section('title','Loan Management')

@section('plugins.Datatables', true)

@section('content_header')

<div class="d-flex justify-content-between flex-wrap">

    <h1>Loan Management</h1>

    <a href="{{ route('loans.create') }}"
       class="btn btn-primary">

        <i class="fas fa-plus"></i>

        New Loan

    </a>

</div>

@stop

@section('css')

<style>

.table-responsive{
    overflow-x:auto;
}

.action-buttons{
    display:flex;
    gap:5px;
}

.card{
    border-radius:10px;
}

</style>

@stop

@section('content')

@if(session('success'))

<div class="alert alert-success">

    {{ session('success') }}

</div>

@endif

<div class="card card-info card-outline mb-3">

    <div class="card-header">

        Filter Loans

    </div>

    <form method="GET">

        <div class="card-body">

            <div class="row">

                <div class="col-md-3">

                    <input type="date"
                           name="from_date"
                           class="form-control"
                           value="{{ request('from_date') }}">

                </div>

                <div class="col-md-3">

                    <input type="date"
                           name="to_date"
                           class="form-control"
                           value="{{ request('to_date') }}">

                </div>

                <div class="col-md-3">

                    <select name="status"
                            class="form-control">

                        <option value="">
                            All Status
                        </option>

                        <option value="Active"
                            {{ request('status') == 'Active' ? 'selected' : '' }}>
                            Active
                        </option>

                        <option value="Closed"
                            {{ request('status') == 'Closed' ? 'selected' : '' }}>
                            Closed
                        </option>

                    </select>

                </div>

                <div class="col-md-3">

                    <button class="btn btn-primary">

                        Filter

                    </button>

                </div>

            </div>

        </div>

    </form>

</div>

<div class="card card-success card-outline shadow">

    <div class="card-header">

        Loan List

    </div>

    <div class="card-body">

        <div class="table-responsive">

            <table class="table table-bordered table-striped w-100 nowrap"
                   id="loanTable">

                <thead class="bg-success">

                <tr>

                    <th>#</th>
                    <th>Account No</th>
                    <th>Customer</th>
                    <th>Loan Amount</th>
                    <th>Interest %</th>
                    <th>Total Interest</th>
                    <th>Total Payable</th>
                    <th>Start Date</th>
                    <th>Principal EMI</th>
                    <th>Interest EMI</th>
                    <th>EMI Amount</th>
                    <th>Total EMI Count</th>
                    <th>Paid EMI Count</th>
                    <th>Remaining EMI Count</th>
                    <th>Status</th>
                    <th>Action</th>

                </tr>

                </thead>

                <tbody>

                @foreach($loans as $loan)

                <tr>

                    <td>
                        {{ $loop->iteration }}
                    </td>

                    <td>

                        <strong>

                            {{ $loan->account->account_no ?? '' }}

                        </strong>

                    </td>

                    <td>

                        {{ $loan->account->customer_name ?? '' }}

                    </td>

                    <td>

                        ₹ {{ number_format($loan->loan_amount,2) }}

                    </td>

                    <td>

                        {{ $loan->interest_rate }} %

                    </td>

                    <td>

                        ₹ {{ number_format($loan->total_interest,2) }}

                    </td>

                    <td>

                        ₹ {{ number_format($loan->total_payable,2) }}

                    </td>
                     <td>

                        {{ date('d-m-Y', strtotime($loan->loan_start_date)) }}

                    </td>

                    <td>₹ {{ number_format($loan->principal_emi, 2) }}</td>
                    <td>₹ {{ number_format($loan->interest_emi, 2) }}</td>

                    <td>
                        ₹ {{ number_format($loan->emi_amount,2) }}
                    </td>
                    <td>

                        ₹ {{ number_format($loan->total_emi_count) }}

                    </td>
                    <td>

                        ₹ {{ number_format($loan->paid_emi_count) }}

                    </td>
                    <td>

                        ₹ {{ number_format($loan->remaining_emi_count) }}

                    </td>

                   

                    <td>

                        @if($loan->status == 'Active')

                            <span class="badge badge-success">
                                Active
                            </span>

                        @else

                            <span class="badge badge-danger">
                                Closed
                            </span>

                        @endif

                    </td>

                    <td>

                        <div class="action-buttons">

                            <a href="{{ route('loans.show',$loan->id) }}"
                               class="btn btn-info btn-sm">

                                <i class="fas fa-eye"></i>

                            </a>

                            <a href="{{ route('loans.edit',$loan->id) }}"
                               class="btn btn-warning btn-sm">

                                <i class="fas fa-edit"></i>

                            </a>

                            <form action="{{ route('loans.destroy',$loan->id) }}"
                                  method="POST"
                                  style="display:inline;"
                                  onsubmit="return confirm('Are you sure you want to delete this loan?')">

                                @csrf
                                @method('DELETE')

                                <button type="submit"
                                        class="btn btn-danger btn-sm">

                                    <i class="fas fa-trash"></i>

                                </button>

                            </form>

                        </div>

                    </td>

                </tr>

                @endforeach

                </tbody>

            </table>

        </div>

    </div>

</div>

@stop

@section('js')

<script>

$('#loanTable').DataTable({

    scrollX: true,

    pageLength: 10

});

</script>

@stop