@extends('layouts.main')

@section('main-content')
    <section class="main-content-section thin-section-border">
        <div class="row">
            <div class="col-12">

                <div class="card">
                    <div class="card-content collapse show">
                        <div class="card-body card-dashboard">
                            @php
                                // $queryParams = session(\App\Helpers\ReportQueryBuilders::MONTHLY_RPT_FILTER_SESS_KEY);
                                $queryParams = (object) request()->all();
                                $filterUrl = Request::fullUrl();
                                $clearFilterUrl = explode("?", $filterUrl)[0];
                                $showFilter = collect($queryParams)->filter(function ($value, $key){ return !empty($value); })->isNotEmpty();
                                $accountingPeriods = getAccountingPeriods();
                            @endphp
                            <div class="row mb-2">
                                <div class="col-lg-12">
                                    <div class="card thin-section-border">
                                        <div class="card-title">
                                            <div class="row m-2 pt-2">
                                                <div class="col-sm-12 col-md-6 offset-md-6 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').toggle('show');">Show/Hide
                                                        Filter
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                        <div id="bills_filter_section" class="border-top p-2">
                                            <form id="bills_filter_form" action="{{ $filterUrl }}" method="get">
                                                <div class="form-body container">
                                                    <div class="row">
                                                        <div class="form-group col-md-4 col-sm-12">
                                                            <label class="form-label" for="service">Year</label>
                                                            @php $years = range($revenueOldestYear->year ?? 2020, date('Y'), 1); @endphp
                                                            <select class="form-control" name="revenue_year">
                                                                @foreach($years as $year)
                                                                    <option value="{{ $year }}" @if($year == old('revenue_year', $revenueYear)) selected @endif>{{ $year }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                        @if((isset($ministries) && !empty($ministries)))
                                                        <div class="form-group col-md-4 col-sm-12">
                                                            <label class="form-label" for="ministry">Ministry</label>
                                                            <select name="rpt_ministry" id="ministry" class="form-control">
                                                                <option value="">Select Ministry</option>
                                                                @foreach($ministries as $m)
                                                                    <option value="{{ $m->id }}" {{ (old('rpt_ministry', $queryParams->rpt_ministry ?? '') == $m->id)? 'selected': '' }}>{{ $m->display_name }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                        @endif
                                                        @if((isset($departments) && !empty($departments)))
                                                        <div class="form-group col-md-4 col-sm-12">
                                                            <label class="form-label" for="department">Department/Agency</label>
                                                            <select name="rpt_department" id="department" class="form-control">
                                                                <option value="">Select an option</option>
                                                                @foreach($departments as $d)
                                                                    <option value="{{ $d->id }}" data-ministry-id="{{ $d->ministry_id }}" {{ (old('rpt_department', $queryParams->rpt_department ?? '') == $d->id )? 'selected': '' }}>{{ $d->display_name }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                        @endif
                                                        <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', request()->accounting_period) == $period->id) ? 'selected': '' }}>{{ $period->name }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <div class="row pt-2">
                                                        <div class="form-group col-md-3 offset-md-9">
                                                            <button class="form-control btn btn-primary w-100" type="submit">Apply Filter</button>
                                                        </div>
                                                    </div>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="card mt-0">
                    <div class="card-content collapse show">
                        <div class="card-body card-dashboard">
                            <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>Revenue generated per month in {{ $revenueYear }}</caption>
                                <thead class="thead-dark">
                                <tr>
                                    <th scope="col" colspan="5" class="text-uppercase" style="font-size: 18px">Revenue Generated in {{ $revenueYear }}</th>
                                </tr>
                                <tr>
                                    <th scope="col">S/N</th>
                                    <th scope="col">Month</th>
                                    <th scope="col">Expected</th>
                                    <th scope="col">Received</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/monthly-report-data?${queryString}`, function(res){
                let data = res.data;
                let content;
                data.expectedVsGeneratedRevenueByMonths.forEach((item, indx) => {
                    let expected_revenue = item.expected ? parseFloat(item.expected).toLocaleString("en-US", { maximumFractionDigits: 2}) : 0;
                    let actual_revenue = item.generated ? parseFloat(item.generated).toLocaleString("en-US", { maximumFractionDigits: 2}) : 0;
                    content+=`<tr>
                            <td>${indx+1}</td>
                            <td class="nk-tb-col"><a href="/report/ministries-revenue-report?filter_start_date=${item.startDate}&filter_end_date=${item.endDate}" >${item.monthName}</a></td>
                            <td class="nk-tb-col naira-prefix">${expected_revenue}</td>
                            <td class="nk-tb-col naira-prefix">${actual_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>
@stop