@extends('adminlte::page')

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

@section('plugins.Datatables', true)

@section('content_header')

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

    <h1>Account Report</h1>


    <a href="{{ route('reports.accounts.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.accounts') }}"
                        class="btn btn-secondary">

                        Reset

                    </a>

                </div>

            </div>

        </div>

    </form>

</div>

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

    <div class="card-header">

        Account Report

    </div>

    <div class="card-body">

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

            <thead class="bg-primary">

                <tr>

                    <th>#</th>
                    <th>Account No</th>
                    <th>Name</th>
                    <th>Mobile</th>
                    <th>Opening Date</th>

                </tr>

            </thead>

            <tbody>

                @foreach($accounts as $account)

                <tr>

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

                    <td>{{ $account->account_no }}</td>

                    <td>{{ $account->customer_name }}</td>

                    <td>{{ $account->mobile }}</td>

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

                </tr>

                @endforeach

            </tbody>


        </table>

    </div>

</div>

@stop

@section('js')

<script>
    $('#reportTable').DataTable({
        scrollX: true,
        pageLength: 25,

        footerCallback: function(row, data, start, end, display) {

            var api = this.api();

            var total = api
                .column(4, {
                    search: 'applied'
                })
                .data()
                .reduce(function(a, b) {

                    a = parseFloat(String(a).replace(/[₹,\s]/g, '')) || 0;
                    b = parseFloat(String(b).replace(/[₹,\s]/g, '')) || 0;

                    return a + b;

                }, 0);

            $(api.column(4).footer()).html(
                '₹ ' + total.toLocaleString('en-IN', {
                    minimumFractionDigits: 2,
                    maximumFractionDigits: 2
                })
            );
        }
    });
</script>

@stop