@extends('adminlte::page')

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

@section('plugins.Datatables', true)

@section('content_header')

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

    <h1>Loan Report</h1>

    <a href="{{ route('reports.loans.export',[
        'from_date'=>request('from_date'),
        'to_date'=>request('to_date'),
        'account_id'=>request('account_id')
    ]) }}"
        class="btn btn-success">

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

        Export CSV

    </a>

</div>

@stop

@section('content')

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

    <form method="GET">

        <div class="card-body">

            <div class="row">

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

                    <label>From Date</label>

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

                </div>

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

                    <label>To Date</label>

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

                </div>

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

                    <label>Customer</label>

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

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

                        @foreach($accounts as $account)

                        <option value="{{ $account->id }}"
                            {{ request('account_id') == $account->id ? 'selected' : '' }}>

                            {{ $account->account_no }}
                            -
                            {{ $account->customer_name }}

                        </option>

                        @endforeach

                    </select>

                </div>

                <div class="col-md-3 d-flex align-items-end">

                    <button class="btn btn-primary mr-2">

                        Filter

                    </button>

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

                        Reset

                    </a>

                </div>

            </div>

        </div>

    </form>

</div>

<div class="card card-primary card-outline">

    <div class="card-header">

        Loan Report

    </div>

    <div class="card-body">

        <div class="table-responsive">

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

                <thead class="bg-primary">

                    <tr>

                        <th>#</th>
                        <th>Account</th>
                        <th>Start Date</th>
                        <th>Customer</th>
                        <th>Loan Amount</th>
                        <th>Interest %</th>
                        <th>Total Payable</th>
                        <th>Remaining Amount</th>

                        <th>Status</th>

                    </tr>

                </thead>

                <tbody>

                    @foreach($loans as $loan)

                    @php

                    $paid = App\Models\Collection::where(
                    'loan_id',
                    $loan->id
                    )->sum(
                    'principal_amount'
                    );

                    $remaining =
                    $loan->total_payable - $paid;

                    @endphp

                    <tr>

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

                        <td>
                            {{ $loan->account->account_no }}
                        </td>
                        <td>
                            {{ date('d-m-Y',strtotime($loan->loan_start_date)) }}
                        </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_payable,2) }}
                        </td>

                        <td>
                            ₹ {{ number_format($remaining,2) }}
                        </td>


                        <td>

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

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

                            @else

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

                            @endif

                        </td>

                    </tr>

                    @endforeach

                </tbody>
              <tfoot>

<tr class="bg-warning font-weight-bold">

    <th></th>

    <th colspan="3" class="text-right">

        Grand Total

    </th>

    <th class="text-right">

        ₹ {{ number_format($totalLoanAmount,2) }}

    </th>

    <!-- <th></th> -->

    <th class="text-right">

        ₹ {{ number_format($totalInterestAmount,2) }}

    </th>

    <th class="text-right">

        ₹ {{ number_format($totalPayableAmount,2) }}

    </th>

    <th class="text-right">

        ₹ {{ number_format($totalRemainingAmount,2) }}

    </th>

</tr>

</tfoot>
            </table>

        </div>

    </div>

</div>

@stop

@section('js')

<script>
    $('#loanTable').DataTable({

        scrollX: true,

        pageLength: 25,

        autoWidth: false

    });
</script>

@stop