@extends('layouts.app')

@push('datatable-styles')
    <script src="{{ asset('vendor/jquery/frappe-charts.min.iife.js') }}"></script>
    @include('sections.datatable_css')
@endpush

@push('styles')
    <style>
        .action-bar{
            float: right;
        }
        .overview-box{
            padding-left: 5px;
            padding-right: 5px;
            position: relative;
            width: 100%;
        }
        .card-body h4 {
            font-size:16px;
        }
    </style>
@endpush

@section('filter-section')

    <x-filters.filter-box>
        <!-- DATE START -->
        {{-- <div class="select-box d-flex pr-2 border-right-grey border-right-grey-sm-0">
            <p class="mb-0 pr-2 f-14 text-dark-grey d-flex align-items-center">@lang('app.duration')</p>
            <div class="select-status d-flex">
                <input type="text" class="position-relative text-dark form-control border-0 p-2 text-left f-14 f-w-500 border-additional-grey"
                    id="datatableRange2" placeholder="@lang('placeholders.dateRange')">
            </div>
        </div> --}}
        <!-- DATE END -->
        <div class="select-box d-flex  py-2 px-lg-2 px-md-2 px-0 border-right-grey border-right-grey-sm-0">
            <p class="mb-0 pr-2 f-14 text-dark-grey d-flex align-items-center">@lang('Year')</p>
            <div class="select-status">
                <select class="form-control select-picker" name="year" id="year" data-live-search="true"
                    data-size="8">
                    <option value="2023" @if($current_year == '2023') selected @endif>2023</option>
                    <option value="2024" @if($current_year == '2024') selected @endif>2024</option>

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

        <!-- RESET START -->
        {{-- <div class="select-box d-flex py-1 px-lg-2 px-md-2 px-0">
            <x-forms.button-secondary class="btn-xs d-none" id="reset-filters" icon="times-circle">
                @lang('app.clearFilters')
            </x-forms.button-secondary>
        </div> --}}
        <!-- RESET END -->

    </x-filters.filter-box>
@endsection
@section('content')
    <!-- CONTENT WRAPPER START -->
    <div class="content-wrapper">
        <div class="row mb-3">
            <div class="col-lg-3">
                <x-cards.widget :title="__('Balance')" value="{{user_setting()->country->currency_iso}} {{currency_format($serviceOrderSumary[0]->tot_amount_due - $serviceOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}" icon="coins"
                    widgetId="totalExpense" />
            </div>
            <div class="col-lg-3">
                <x-cards.widget :title="__('Amount')" value="{{user_setting()->country->currency_iso}} {{currency_format($serviceOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}" icon="coins"
                    widgetId="totalExpense" />
            </div>
            <div class="col-lg-3">
                <x-cards.widget :title="__('Amount Paid')" value="{{user_setting()->country->currency_iso}} {{currency_format($serviceOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}" icon="coins"
                    widgetId="totalExpense" />
            </div>
            <div class="col-lg-3">
                <x-cards.widget :title="__('Total Invoices')" value="{{$serviceOrderSumary[0]->tot_invoices}}" icon="coins"
                    widgetId="totalExpense" />
            </div>
            <div class="col-lg-3 mt-2">
                <a href="{{route('service-orders.index',['ps' => 'unpaid'])}}" target="_blank">
                <x-cards.widget :title="__('Unpaid Invoices')" value="{{$serviceOrderSumary[0]->tot_unpaid_invoices}}" icon="coins"
                    widgetId="totalExpense" />
                </a>
            </div>


            {{-- <div class="col-md-8">
                <div class="d-block d-lg-flex d-md-flex justify-content-between action-bar" id="reports">
                    <div class="btn-group mt-3 mt-lg-0 mt-md-0 ml-lg-3" role="group">
                        <a href="{{ route('general-stats-report.index') }}" class="btn btn-secondary f-14 btn-active" data-toggle="tooltip"
                            data-original-title="@lang('app.menu.expenseReport')"><i class="side-icon bi bi-list-ul"></i></a>



                    </div>
                </div>
            </div> --}}
        </div>
        <div class="row mb-4">

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">January</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($januaryOrderSumary[0]->tot_amount_due - $januaryOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($januaryOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($januaryOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$januaryOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4 justify-content-center">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$januaryOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '01','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$januaryOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span >Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$januaryOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($januaryOrderSumary[0]->tot_invoices - $januaryOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">February</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($februaryOrderSumary[0]->tot_amount_due - $februaryOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($februaryOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($februaryOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$februaryOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$februaryOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '02','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$februaryOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$februaryOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($februaryOrderSumary[0]->tot_invoices - $februaryOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">March</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($marchOrderSumary[0]->tot_amount_due - $marchOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($marchOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($marchOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$marchOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$marchOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '03','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$marchOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$marchOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($marchOrderSumary[0]->tot_invoices - $marchOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">April</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($aprilOrderSumary[0]->tot_amount_due - $aprilOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($aprilOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($aprilOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$aprilOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$aprilOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '04','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$aprilOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$aprilOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($aprilOrderSumary[0]->tot_invoices - $aprilOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">May</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($mayOrderSumary[0]->tot_amount_due - $mayOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($mayOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($mayOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$mayOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$mayOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '05','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$mayOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$mayOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($mayOrderSumary[0]->tot_invoices - $mayOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">June</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($juneOrderSumary[0]->tot_amount_due - $juneOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($juneOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($juneOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12"><span><strong>{{$juneOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$juneOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '06','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$juneOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$juneOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($juneOrderSumary[0]->tot_invoices - $juneOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">July</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($julyOrderSumary[0]->tot_amount_due - $julyOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($julyOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($julyOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$julyOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$julyOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '07','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$julyOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$julyOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($julyOrderSumary[0]->tot_invoices - $julyOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">August</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($augustOrderSumary[0]->tot_amount_due - $augustOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($augustOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($augustOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$augustOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$augustOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '08','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$augustOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$augustOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($augustOrderSumary[0]->tot_invoices - $augustOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">September</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($septemberOrderSumary[0]->tot_amount_due - $septemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($septemberOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($septemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12"><span><strong>{{$septemberOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$septemberOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '09','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$septemberOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$septemberOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($septemberOrderSumary[0]->tot_invoices - $septemberOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">October</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($octoberOrderSumary[0]->tot_amount_due - $octoberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($octoberOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($octoberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$octoberOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$octoberOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '10','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$octoberOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$octoberOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($octoberOrderSumary[0]->tot_invoices - $octoberOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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

            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">November</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($novemberOrderSumary[0]->tot_amount_due - $novemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($novemberOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($novemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$novemberOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$novemberOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>
                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '11','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$novemberOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>
                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$novemberOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($novemberOrderSumary[0]->tot_invoices - $novemberOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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



            <div class="col-md-3 overview-box">
                <div class="card border-0 b-shadow-4 mb-3 e-d-info">
                    <div class="card-header border-0 text-capitalize d-flex justify-content-center pt-2" style="background-color: #c4e1f6;">
                        <h4 class="f-18 f-w-500 mb-0">December</h4>
                    </div>
                    <div class="card-body p-0">

                        <div class="row m-4">
                            <div class="col-md-6 offset-md-3">
                                <span><h4><strong>{{user_setting()->country->currency_iso}} {{currency_format($decemberOrderSumary[0]->tot_amount_due - $decemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong></h4></span>
                            </div>
                            <div class="col-md-6  offset-md-4">
                                <span>Balance</span>
                            </div>
                        </div>
                        <div class="row m-3">
                            <div class="col-md-6 ">
                               <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($decemberOrderSumary[0]->tot_amount_due,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount</span>
                            </div>
                            <div class="col-md-6 ">
                                <span><strong>{{user_setting()->country->currency_iso}} {{currency_format($decemberOrderSumary[0]->tot_amount_paid,$currentCurrencyId,false)}}</strong><br /></span>
                                <span>Amount Paid</span>
                            </div>
                        </div>
                       <div class="row m-3">
                            <div class="col-md-4 ">
                                <div class="col-md-12 "><span><strong>{{$decemberOrderSumary[0]->tot_invoices}}</strong></span></div>
                                <span>Invoices</span>
                            </div>
                            <div class="col-md-4">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$decemberOrderSumary[0]->tot_paid_invoices}}</strong></span></div>
                                <span  >Paid</span>
                            </div>

                            <div class="col-md-4 ">
                                <a href="{{route('service-orders.index',['ps' => 'unpaid','m' => '12','year' => $current_year])}}" target="_blank">
                                <div class="col-md-12 offset-md-2"><span ><strong>{{$decemberOrderSumary[0]->tot_unpaid_invoices}}</strong></span></div>
                                </a>
                                <span>Unpaid</span>
                            </div>

                        </div>
                        <div class="progress mb-1">
                            @php $per_perc =$decemberOrderSumary[0]->tot_invoices/100;
                            $paid_inv = ($decemberOrderSumary[0]->tot_invoices - $decemberOrderSumary[0]->tot_unpaid_invoices);
                            $paid_perc = ($paid_inv> 0)?ceil(($paid_inv)/$per_perc):0;
                            @endphp
                            <div class="progress-bar bg-dark-green" role="progressbar" title="{{$paid_perc}}%" style="width: {{$paid_perc}}%" aria-valuenow="{{$paid_perc}}" aria-valuemin="0" aria-valuemax="100"></div>
                        </div>

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




        </div>


        <!-- Task Box Start -->
        {{-- <div class="d-flex flex-column w-tables rounded mt-4 bg-white table-responsive">
            {!! $dataTable->table(['class' => 'table table-hover border-0 w-100']) !!}
        </div> --}}
        <!-- Task Box End -->
    </div>
    <!-- CONTENT WRAPPER END -->

@endsection

@push('scripts')
@include('sections.datatable_js')
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
    function setDate() {
        var customStartDate = '2023-08-01 00:00:00';
        var start = moment(customStartDate);//moment().clone().startOf('month');
        var end = moment();

        $('#datatableRange2').daterangepicker({
            locale: daterangeLocale,
            linkedCalendars: false,
            startDate: start,
            endDate: end,
            ranges: daterangeConfig
        }, cb);
    }
</script>
<script>
    $(function() {
        setDate()
        $('#datatableRange2').on('apply.daterangepicker', function(ev, picker) {
            showTable();
        });

        // function barChart() {
        //     var startDate = $('#datatableRange2').val();

        //     if (startDate == '') {
        //         startDate = null;
        //         endDate = null;
        //     } else {
        //         var dateRangePicker = $('#datatableRange2').data('daterangepicker');
        //         startDate = dateRangePicker.startDate.format('{{ company()->moment_date_format }}');
        //         endDate = dateRangePicker.endDate.format('{{ company()->moment_date_format }}');
        //     }

        //     var data = new Array();
        //     var projectID = $('#project_id').val();
        //     var employeeID = $('#employee_id').val();
        //     var categoryID = $('#category_id').val();
        //     var searchText = $('#search-text-field').val();

        //     var url = "{{ route('general-stats-report.index') }}";

        //     $.easyAjax({
        //         url: url,
        //         container: '#e',
        //         blockUI: true,
        //         type: "POST",
        //         data: {
        //             startDate: startDate,
        //             endDate: endDate,
        //             categoryID: categoryID,
        //             projectID: projectID,
        //             employeeID: employeeID,
        //             _token: '{{ csrf_token() }}'
        //         },
        //         success: function(response) {
        //             $('#e .card-body').html(response.html);
        //             $('#expense-chart-card').html(response.html2);
        //             $('#totalExpense').html(response.totalExpenses);
        //         }
        //     });
        // }

        //barChart();

        // $('#expense-report-table').on('preXhr.dt', function(e, settings, data) {

        //     var dateRangePicker = $('#datatableRange2').data('daterangepicker');
        //     var startDate = $('#datatableRange2').val();

        //     if (startDate == '') {
        //         startDate = null;
        //         endDate = null;
        //     } else {
        //         startDate = dateRangePicker.startDate.format('{{ company()->moment_date_format }}');
        //         endDate = dateRangePicker.endDate.format('{{ company()->moment_date_format }}');
        //     }

        //     var projectID = $('#project_id').val();
        //     if (!projectID) {
        //         projectID = 0;
        //     }
        //     var employeeID = $('#employee_id').val();
        //     var categoryID = $('#category_id').val();
        //     var searchText = $('#search-text-field').val();

        //     data['categoryID'] = categoryID;
        //     data['employeeID'] = employeeID;
        //     data['projectID'] = projectID;
        //     data['startDate'] = startDate;
        //     data['endDate'] = endDate;
        //     data['searchText'] = searchText;
        // });

        // const showTable = () => {
        //     window.LaravelDataTables["expense-report-table"].draw(false);
        //     barChart();
        // }

        $('#category_id, #employee_id, #project_id')
            .on('change keyup',
                function() {
                    if ($('#project_id').val() != "all") {
                        $('#reset-filters').removeClass('d-none');
                        showTable();
                    } else if ($('#category_id').val() != "all") {
                        $('#reset-filters').removeClass('d-none');
                        showTable();
                    } else if ($('#project_id').val() != "all") {
                        $('#reset-filters').removeClass('d-none');
                        showTable();
                    } else if ($('#employee_id').val() != "all") {
                        $('#reset-filters').removeClass('d-none');
                        showTable();
                    } else {
                        $('#reset-filters').addClass('d-none');
                        showTable();
                    }
                });

        $('#filter-form')
            .on('change',
                function() {
                    $('#filter-form').submit();
                });

        $('#search-text-field').on('keyup', function() {
            if ($('#search-text-field').val() != "") {
                $('#reset-filters').removeClass('d-none');
                showTable();
            }
        });

        $('#reset-filters').click(function() {
            $('#filter-form')[0].reset();
            setDate()

            $('.filter-box .select-picker').selectpicker("refresh");
            $('#reset-filters').addClass('d-none');
            showTable();
        });

        $('#reset-filters-2').click(function() {
            $('#filter-form')[0].reset();

            $('.filter-box .select-picker').selectpicker("refresh");
            $('#reset-filters').addClass('d-none');
            showTable();
        });

    });
</script>
@endpush