@extends('layouts.main')

@section('main-content')
    @php
        $filterUrl = Request::fullUrl();
        $clearFilterUrl = explode("?", $filterUrl)[0];
        $queryParams = $filters;
        $showFilter = collect($queryParams)->filter(function ($value, $key){ return !empty($value); })->isNotEmpty();
        $accountingPeriods = getAccountingPeriods();
    @endphp
    <section class="main-content-section thin-section-border">
        <div class="row">
            <div class="col-12">

                <div class="card mt-0">
                    <div class="card-content collapse show">
                        <div class="card-body card-dashboard">
                            <div class="row m-2">
                                <div class="col-md-6 col-sm-12">
                                    <h5 id="filter_instruction" style="display: none;">Apply any or all of the filters below to streamline your search</h5>
                                </div>
                                <div class="col-md-6 col-sm-12 text-right">
                                    <a href="{{ $clearFilterUrl }}" class="btn underline">Clear Filter</a>
                                    <button class="btn btn-lg btn-primary float-right" id="toggle_filter_section" onclick="$('#bills_filter_section, #filter_instruction').toggle('show');">Show/Hide Filter
                                    </button>
                                </div>
                            </div>
                            <div class="row m-2">
                                <div class="col-sm-12 m-auto">
                                    <form id="bills_filter_section" action="{{ $filterUrl }}" class="row pt-2">
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="form-label" for="filter_ministry">Ministry</label>
                                                <select name="filter_ministry" id="filter_ministry" class="form-control" data-preselected="{{ old('filter_ministry', $queryParams->filter_ministry) }}">
                                                    <option value="">Filter By Ministry</option>
                                                    @foreach($ministries as $ministry)
                                                        <option @if($ministry->id == old('filter_ministry', $queryParams->filter_ministry)) selected
                                                                @endif value="{{ $ministry->id }}">{{ $ministry->display_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="form-label" for="filter_department">Department</label>
                                                <select name="filter_department" id="filter_department" class="form-control" data-preselected="{{ old('filter_department', $queryParams->filter_department) }}">
                                                    <option value="">Filter By Department</option>
                                                    @foreach($departments as $department)
                                                        <option @if($department->id == old('filter_department', $queryParams->filter_department ?? '')) selected
                                                                @endif value="{{ $department->id }}">{{ $department->display_name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="form-label" for="filter_service">Service</label>
                                                <select name="filter_service" id="filter_service" class="form-control" data-preselected="{{ old('filter_service', $queryParams->filter_service) }}">
                                                    <option value="">Filter By Service</option>
                                                    @foreach($services as $service)
                                                        <option @if($service->id == old('filter_service', $queryParams->filter_service ?? '')) selected
                                                                @endif value="{{ $service->id }}">{{ $service->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="form-label" for="filter_start_date">Payment Made From</label>
                                                <input type="text" value="{{ old('filter_start_date', $queryParams->filter_start_date) }}" id="filter_start_date" name="filter_start_date"
                                                       placeholder="From Date" readonly class="form-control pick-date from-date">
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="form-group">
                                                <label class="form-label" for="filter_end_date">Payment Made Till</label>
                                                <input type="text" value="{{ old('filter_end_date', $queryParams->filter_end_date) }}" id="filter_end_date" name="filter_end_date"
                                                       placeholder="To Date" readonly class="form-control pick-date to-date">
                                            </div>
                                        </div>
                                        <div class="form-group col-lg-3 col-md-4 col-sm-6">
                                            <label class="form-label" for="order_status">Accounting Period</label>
                                            <select name="accounting_period" id="accounting_period" class="form-select show-placeholder" data-preselected="{{ old('accounting_period') }}"
                                                data-placeholder="Filter By Accounting Period">
                                                <option value="">Filter by Accounting Period</option>
                                                @foreach($accountingPeriods as $period)
                                                    <option value="{{ $period->id }}" {{ (old('accounting_period', $queryParams->accounting_period) == $period->id) ? 'selected': '' }}>{{ $period->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-12">
                                            <div class="form-group">
                                                <label class="form-label"></label>
                                                <button class="btn btn-primary w-100 h-100">Filter</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                            <div class="row mb-2">
                                <div class="col-md-6 offset-md-6">
                                    <div class="dt-buttons btn-group float-right">
                                        <a class="btn btn-outline-success" href="{{ count(explode("?", $filterUrl)) > 1 ? $filterUrl . '&download_report=yes' : $filterUrl .'?download_report=yes'}}" tabindex="0" aria-controls="example"><span class="icon ni ni-download"> </span>Download Report</a>
                                    </div>
                                </div>
                            </div>
                            <table class="table table-bordered table-responsive report-table-res">
                                <caption>Payments Report Per Bank</caption>
                                <thead class="thead-dark">
                                <tr>
                                    <th scope="col" colspan="5" class="text-uppercase" style="font-size: 18px">Payments Report Per Bank</th>
                                </tr>
                                <tr>
                                    <th scope="col">S/N</th>
                                    <th scope="col">Account</th>
                                    <th scope="col">Bank</th>
                                    <th scope="col">Revenue</th>
                                </tr>
                                </thead>
                            </table>
                            <div class="row" id="card-initial-loader">
                                <div class="col-md-12">
                                    <div class="card">
                                        <div class="card-body container-to-center-items border" style="height: 300px !important;">
                                            <div class="dashb-loader"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>

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

            </div>
        </div>
    </section>
@endsection

@section('more-scripts')
    <script>
        const queryString = "{{ convertRequestToQueryString() }}";

        $(document).ready(function () {
            @if(!$showFilter)
            $('#bills_filter_section').hide();
            @endif

            fetchTableData()
        })

        function fetchTableData(){
            $.get(`/report/account-numbers-report-data?${queryString}`, function(res){
                let data = res.data;
                let content;
                data.accountNumbersTransactions.forEach((item, indx) => {
                    let revenue = item.revenue ? parseFloat(item.revenue).toLocaleString("en-US", { maximumFractionDigits: 2}) : 0;
                    content+=`<tr>
                            <td>${indx+1}</td>
                            <td class="nk-tb-col">${item.account_name ?? ''}</td>
                            <td class="nk-tb-col">${item.bank_name}</td>
                            <td class="nk-tb-col naira-prefix">${revenue}</td>
                        </tr>`;
                });

                let tableBody = `<tbody>${content}</tbody>`;

                $('.report-table-res').append(tableBody)
                $('#stat-card').removeClass('d-none');
                $('#card-initial-loader, .card-initial-loader').hide();
            });
        }
    </script>
    <script src="{{ asset('js/filter-datepicker-handler.js') }}"></script>
@stop