@extends('adminlte::page')

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

@section('plugins.Datatables', true)

@section('content_header')

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

    <h1>Collection Report</h1>

    <a href="{{ route('reports.collections.export',[
        'from_date'=>request('from_date'),
        'to_date'=>request('to_date')
    ]) }}"
        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 d-flex align-items-end">

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

                        Filter

                    </button>

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

                        Reset

                    </a>

                </div>

            </div>

        </div>

    </form>

</div>

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

    <div class="card-header">

        Collection Report

    </div>

    <div class="card-body">

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

            <thead class="bg-success">

               <tr>
    <th>#</th>
    <th>Receipt No</th>
    <th>Date</th>
    <th>Account No</th>
    <th>Customer</th>
    <th>Loan Amount</th>
    <th>Total Interest</th>
    <th>Collection Amount</th>
    <th>Principal Amount</th>
    <th>Interest Amount</th>
    <th>Remaining Amount</th>
</tr>

            </thead>

            <tbody>

               @foreach($collections as $collection)

<tr>

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

    <td>{{ $collection->receipt_no }}</td>

    <td>{{ date('d-m-Y',strtotime($collection->collection_date)) }}</td>

    <td>{{ $collection->account->account_no ?? '-' }}</td>

    <td>{{ $collection->account->customer_name ?? '-' }}</td>

    <td class="text-right">
        ₹ {{ number_format($collection->loan->loan_amount ?? 0,2) }}
    </td>
     <td class="text-right">
        ₹ {{ number_format($collection->loan->total_interest ?? 0,2) }}
    </td>
    <td class="text-right">
        ₹ {{ number_format($collection->collection_amount,2) }}
    </td>

    <td class="text-right">
        ₹ {{ number_format($collection->principal_amount,2) }}
    </td>

    <td class="text-right">
        ₹ {{ number_format($collection->interest_amount,2) }}
    </td>

    <td class="text-right">
        ₹ {{ number_format($collection->balance_amount,2) }}
    </td>

</tr>

@endforeach

            </tbody>
<tfoot>

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

    <th colspan="5" class="text-right">
        Grand Total
    </th>

    <th>
        ₹ {{ number_format($totalLoanAmount,2) }}
    </th>

    <th>
        ₹ {{ number_format($totalInterest,2) }}
    </th>

    <th>
        ₹ {{ number_format($totalCollectionAmount,2) }}
    </th>

    <th>
        ₹ {{ number_format($totalPrincipalAmount,2) }}
    </th>

    <th>
        ₹ {{ number_format($totalInterestAmount,2) }}
    </th>

    <th>
        ₹ {{ number_format($totalPendingAmount,2) }}
    </th>

</tr>

</tfoot>
        </table>

    </div>

</div>

@stop

@section('js')

<script>
$(function(){

    $('#collectionTable').DataTable({

        scrollX: true,

        pageLength: 25,

        ordering: true,

        responsive: false,

        autoWidth: false

    });

});
</script>

@stop