@php
    $yearly_total_tax = 0;
    $Tax_waiver = 0;
    $bn_this_fiscal_year = NumToBn(substr("$fiscal_year", 0, 4)) .'-'. NumToBn(substr("$fiscal_year", 5))
@endphp
@foreach($holdingServer as $item)
    @php
        try {
            $yearly_total_tax += $item->assessment->yearly_total_tax;
            $Tax_waiver += $item->assessment->reviewed_fee;
       } catch (Exception $exception) {

       }
    @endphp
@endforeach
<div class="row">
    <div class="col-12">
        <div class="row">
            <div class="col-md-6">
                <div class="row">
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <div class="media">
                                    <div class="media-body">
                                        <p class="text-muted font-weight-medium">মোট করদাতা</p>
                                        <h4 class="mb-0">{{ NumToBn(count($holdingServer)) }} জন</h4>
                                    </div>
                                    <div class="mini-stat-icon avatar-sm rounded-circle bg-primary align-self-center">
                                        <span class="avatar-title">
                                            <i class="bx bx-user font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <div class="media">
                                    <div class="media-body">
                                        <p class="text-muted font-weight-medium">ইস্যুকৃত বিল সংখ্যা ({{ $bn_this_fiscal_year }})</p>
                                        <h4 class="mb-0">{{ NumToBn(count($issue_bills)) }} টি</h4>
                                    </div>
                                    <div class="avatar-sm rounded-circle bg-primary align-self-center mini-stat-icon">
                                        <span class="avatar-title rounded-circle bg-primary">
                                            <i class="bx bx-file-find font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <h4 class="card-title mb-4">বার্ষিক কর আদায় </h4>
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="mt-4 mt-sm-0">
                                            <div id="radialBar-chart" class="apex-charts"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <h4 class="card-title mb-4">বার্ষিক কর আদায় </h4>
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="mt-4 mt-sm-0">
                                            <div id="radialBar-chart1" class="apex-charts"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-3">{{ NumToBnMonth(\Carbon\Carbon::now()->format('m')) }} মাসের কর আদায়</h4>
                                <div>
                                    <div id="line-chart" class="apex-charts" dir="ltr"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-12">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <h4 class="card-title mb-4">ক্যাশ আদায় </h4>
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="mt-4 mt-sm-0">
                                            <div id="cash_collection" class="apex-charts"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <h4 class="card-title mb-4">অনলাইন পেমেন্টের মাধ্যমে আদায় </h4>
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="mt-4 mt-sm-0">
                                            <div id="onlinePayment_collection" class="apex-charts"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="card mini-stats-wid">
                            <div class="card-body">
                                <h4 class="card-title mb-4">নগদের মাধ্যমে আদায় </h4>
                                <div class="row">
                                    <div class="col-sm-12">
                                        <div class="mt-4 mt-sm-0">
                                            <div id="nagad_collection" class="apex-charts"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="card mini-stats-wid">
                    <div class="card-body">
                        <table class="table table-bordered">
                            <tbody>
                            <tr>
                                <td>
                                    <div class="input-group">
                                        <select class="form-control select2" id="fiscal_year">
                                            <option value="" selected disabled>&mdash;অর্থবছর চিহ্নিত করুণ&mdash;</option>
                                            @foreach($all_fiscal_year as $item)
                                                <option value="{{ $item->fiscal_year }}" {{ $item->fiscal_year == $fiscal_year ? 'selected' : '' }}>{{ $item->fiscal_year }}</option>
                                            @endforeach
                                        </select>
                                        <select class="form-control select2" id="word_no">
                                            <option value="" selected disabled>&mdash;ওয়ার্ড চিহ্নিত করুণ&mdash;</option>
                                            <option value="all" @if(isset($word_no)){{ $word_no == 'all' ? 'selected' : '' }}@endif>সকল ওয়ার্ড</option>
                                            @foreach(words() as $word)
                                                <option value="{{ $word->number }}"  @if(isset($word_no)) {{ $word_no == $word->number ? 'selected' : '' }} @endif>{{ NumToBn($word->number) }}</option>
                                            @endforeach
                                        </select>
                                        <div class="btn-group btn-group-example mb-3" role="group">
                                            <button type="button" class="btn btn-primary w-xs tax-dashboard-search"><i class="fa fa-search"></i></button>
                                            <button type="button" onclick="print('{{ route('tax.holding-tax-dashboard-print',['fiscal_year' => $fiscal_year, 'word_no' => $word_no]) }}')" class="btn btn-dark w-xs"><i class="fa fa-print"></i></button>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="card mini-stats-wid">
                    <div class="card-body">
                        <table class="table table-bordered">
                            <thead>
                            <tr>
                                <th colspan="2" class="text-center">মোট করদাতার ক্ষেত্রে</th>
                            </tr>
                            </thead>
                            <tbody>
                            <tr>
                                <th>বার্ষিক কর দাবি</th>
                                <td class="text-right">{{ NumToBn($yearly_total_tax) }}</td>
                            </tr>
                            <tr style="border-bottom: 2px solid black">
                                <th>মওকুফ</th>
                                <td class="text-right">-{{ NumToBn($Tax_waiver) }}</td>
                            </tr>
                            <tr>
                                <th>মোট বার্ষিক কর দাবি</th>
                                <td class="text-right">{{ NumToBn($yearly_total_tax-$Tax_waiver) }}</td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="card mini-stats-wid">
                    <div class="card-body">
                        <table class="table table-bordered">
                            <thead>
                            <tr>
                                <th colspan="2" class="text-center">ইস্যুকৃত বিলের ক্ষেত্রে <br/>অর্থবছর: {{ $bn_this_fiscal_year }}
                                </th>
                            </tr>
                            </thead>
                            <tbody>
                            <tr>
                                <th>বার্ষিক কর দাবি</th>
                                <td class="text-right">{{ NumToBn($issue_bills->sum('yearly_tax')) }}</td>
                            </tr>
                            <tr>
                                <th>পূর্বের বকেয়া</th>
                                <td class="text-right">+{{ NumToBn($issue_bills->sum('due_tax')) }}</td>
                            </tr>
                            <tr style="border-bottom: 2px solid black">
                                <th>বার্ষিক জরিমানা</th>
                                <td class="text-right">+{{ NumToBn($issue_bills->sum('yearly_fine')) }}</td>
                            </tr>
                            <tr style="border-bottom: 2px solid black">
                                <th>মোট বার্ষিক কর দাবি</th>
                                <td class="text-right">{{ NumToBn($issue_bills->sum('yearly_tax')+$issue_bills->sum('due_tax')+$issue_bills->sum('yearly_fine')) }}</td>
                            </tr>
                            {{--                                <tr>--}}
                            {{--                                    <th colspan="2" class="text-center">{{ '০১/০১/'.NumToBn(substr("$fiscal_year", 0, 4)).' হতে '.bn_today() }} পর্যন্ত</th>--}}
                            {{--                                </tr>--}}
                            <tr>
                                <th>মোট কর আদায়</th>
                                <td class="text-right">{{ NumToBn($paid_bills->sum('total_pay_bill')+$paid_bills->sum('waiver_annual_fine')+$paid_bills->sum('discount_amount')) }}</td>
                            </tr>
                            <tr>
                                <th>মোট কর মওকুফ</th>
                                <td class="text-right">-{{ NumToBn($paid_bills->sum('waiver_annual_fine')) }}</td>
                            </tr>
                            <tr  style="border-bottom: 2px solid black">
                                <th>মোট কর রিবেট</th>
                                <td class="text-right">-{{ NumToBn($paid_bills->sum('discount_amount')) }}</td>
                            </tr>
                            @php
                                if (($paid_bills->sum('total_pay_bill')+$paid_bills->sum('waiver_annual_fine')+$paid_bills->sum('discount_amount')) != 0 || ($issue_bills->sum('yearly_tax')+$issue_bills->sum('due_tax')+$issue_bills->sum('yearly_fine')) != 0) {
                                    $percentagePaid = (($paid_bills->sum('total_pay_bill')+$paid_bills->sum('waiver_annual_fine')+$paid_bills->sum('discount_amount')) / ($issue_bills->sum('yearly_tax')+$issue_bills->sum('due_tax')+$issue_bills->sum('yearly_fine'))) * 100;
                                } else {
                                    $percentagePaid = 0;
                                }
                                if (count($paid_bills) != 0 || count($issue_bills) != 0) {
                                    $percentagePaidHoldingServe = (count($paid_bills) / count($issue_bills)) * 100;
                                } else {
                                    $percentagePaidHoldingServe = 0;
                                }
                                if ($cash_collection != 0 || $paid_bills->sum('total_pay_bill') != 0) {
                                    $cash_collection_percentage = ($cash_collection / ($paid_bills->sum('total_pay_bill'))) * 100;
                                } else {
                                    $cash_collection_percentage = 0;
                                }
                                if ($nagad_collection != 0 || $paid_bills->sum('total_pay_bill') != 0) {
                                    $nagad_collection_percentage = ($nagad_collection / ($paid_bills->sum('total_pay_bill'))) * 100;
                                } else {
                                    $nagad_collection_percentage = 0;
                                }
                                if ($onlinePayment_collection != 0 || $paid_bills->sum('total_pay_bill') != 0) {
                                    $onlinePayment_collection_percentage = ($onlinePayment_collection / ($paid_bills->sum('total_pay_bill'))) * 100;
                                } else {
                                    $onlinePayment_collection_percentage = 0;
                                }
                            @endphp
                            <tr>
                                <th>সর্বমোট কর আদায়</th>
                                <td class="text-right">{{ NumToBn($paid_bills->sum('total_pay_bill')) }}</td>
                            </tr>
                            <tr>
                                <th>মোট পাওনা টাকা</th>
                                <td class="text-right">{{ NumToBn(($issue_bills->sum('yearly_tax')+$issue_bills->sum('due_tax')+$issue_bills->sum('yearly_fine'))-($paid_bills->sum('total_pay_bill')+$paid_bills->sum('waiver_annual_fine')+$paid_bills->sum('discount_amount'))) }}</td>
                            </tr>

                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
    $(".select2").select2();

    options = {
        chart: { height: 180, type: "radialBar", offsetY: -10 },
        plotOptions: {
            radialBar: {
                startAngle: -135,
                endAngle: 135,
                dataLabels: {
                    name: { fontSize: "13px", color: void 0, offsetY: 60 },
                    value: {
                        offsetY: 22,
                        fontSize: "16px",
                        color: void 0,
                        formatter: function (e) {
                            return e + "%";
                        },
                    },
                },
            },
        },
        colors: ["#556ee6"],
        fill: { type: "gradient", gradient: { shade: "dark", shadeIntensity: 0.15, inverseColors: !1, opacityFrom: 1, opacityTo: 1, stops: [0, 50, 65, 91] } },
        stroke: { dashArray: 4 },
        series: [{{ number_format($percentagePaid, 2) }}],
        labels: ["মোট টাকার উপর"],
    };
    (chart = new ApexCharts(document.querySelector("#radialBar-chart"), options)).render();

    options = {
        chart: { height: 180, type: "radialBar", offsetY: -10 },
        plotOptions: {
            radialBar: {
                startAngle: -135,
                endAngle: 135,
                dataLabels: {
                    name: { fontSize: "13px", color: void 0, offsetY: 60 },
                    value: {
                        offsetY: 22,
                        fontSize: "16px",
                        color: void 0,
                        formatter: function (e) {
                            return e + "%";
                        },
                    },
                },
            },
        },
        colors: ["#556ee6"],
        fill: { type: "gradient", gradient: { shade: "dark", shadeIntensity: 0.15, inverseColors: !1, opacityFrom: 1, opacityTo: 1, stops: [0, 50, 65, 91] } },
        stroke: { dashArray: 4 },
        series: [{{ number_format($percentagePaidHoldingServe, 2) }}],
        labels: ["মোট করদাতার উপর"],
    };
    (chart = new ApexCharts(document.querySelector("#radialBar-chart1"), options)).render();

    options = {
        chart: { height: 180, type: "radialBar", offsetY: -10 },
        plotOptions: {
            radialBar: {
                startAngle: -135,
                endAngle: 135,
                dataLabels: {
                    name: { fontSize: "13px", color: void 0, offsetY: 60 },
                    value: {
                        offsetY: 22,
                        fontSize: "16px",
                        color: void 0,
                        formatter: function (e) {
                            return e + "%";
                        },
                    },
                },
            },
        },
        colors: ["#556ee6"],
        fill: { type: "gradient", gradient: { shade: "dark", shadeIntensity: 0.15, inverseColors: !1, opacityFrom: 1, opacityTo: 1, stops: [0, 50, 65, 91] } },
        stroke: { dashArray: 4 },
        series: [{{ number_format($nagad_collection_percentage, 2) }}],
        labels: ["নগদ"],
    };
    (chart = new ApexCharts(document.querySelector("#nagad_collection"), options)).render();
    options = {
        chart: { height: 180, type: "radialBar", offsetY: -10 },
        plotOptions: {
            radialBar: {
                startAngle: -135,
                endAngle: 135,
                dataLabels: {
                    name: { fontSize: "13px", color: void 0, offsetY: 60 },
                    value: {
                        offsetY: 22,
                        fontSize: "16px",
                        color: void 0,
                        formatter: function (e) {
                            return e + "%";
                        },
                    },
                },
            },
        },
        colors: ["#556ee6"],
        fill: { type: "gradient", gradient: { shade: "dark", shadeIntensity: 0.15, inverseColors: !1, opacityFrom: 1, opacityTo: 1, stops: [0, 50, 65, 91] } },
        stroke: { dashArray: 4 },
        series: [{{ number_format($onlinePayment_collection_percentage, 2) }}],
        labels: ["অনলাইন পেমেন্ট"],
    };
    (chart = new ApexCharts(document.querySelector("#onlinePayment_collection"), options)).render();
    options = {
        chart: { height: 180, type: "radialBar", offsetY: -10 },
        plotOptions: {
            radialBar: {
                startAngle: -135,
                endAngle: 135,
                dataLabels: {
                    name: { fontSize: "13px", color: void 0, offsetY: 60 },
                    value: {
                        offsetY: 22,
                        fontSize: "16px",
                        color: void 0,
                        formatter: function (e) {
                            return e + "%";
                        },
                    },
                },
            },
        },
        colors: ["#556ee6"],
        fill: { type: "gradient", gradient: { shade: "dark", shadeIntensity: 0.15, inverseColors: !1, opacityFrom: 1, opacityTo: 1, stops: [0, 50, 65, 91] } },
        stroke: { dashArray: 4 },
        series: [{{ number_format($cash_collection_percentage, 2) }}],
        labels: ["ক্যাশ"],
    };
    (chart = new ApexCharts(document.querySelector("#cash_collection"), options)).render();

    $(".tax-dashboard-search").click(function (){
        let fiscal_year = $("#fiscal_year").val();
        let word_no = $("#word_no").val();
        $.ajax({
            method: "POST",
            url: "{{ route('tax.holding-tax-dashboard-search') }}",
            data:{fiscal_year:fiscal_year, word_no:word_no, _token:'{{ csrf_token() }}'},
            beforeSend: function(){
                var div = '';
                div += '<div class="col-md-12 text-center center">';
                div += '<div class="spinner-grow text-success m-1" role="status"> <span class="sr-only">Loading...</span></div><div class="spinner-grow text-info m-1" role="status"><span class="sr-only">Loading...</span></div><div class="spinner-grow text-warning m-1" role="status"><span class="sr-only">Loading...</span></div>';
                div += '</div>';
                $('.dashboard-body').empty().append(div);
            },
            success:function (res) {
                $('.dashboard-body').empty().html(res);
            }
        });
    });
    var options = {
            series: [{ name: "কর আদায়", data: [] }],
            chart: { height: 240, type: "area", toolbar: "false"},
            dataLabels: { enabled: !1 },
            colors: ["#556ee6"],
            stroke: { curve: "smooth", width: 2 },
            fill: { type: "gradient", gradient: { shadeIntensity: 1, opacityFrom: 0.6, opacityTo: 0.05, stops: [42, 100, 100, 100] } },
        },
        chart = new ApexCharts(document.querySelector("#line-chart"), options);
    chart.render();
    function print(url) {
        var h = $(window).height();
        var w = $(window).width();
        window.open(url, '_blank', 'height=' + h + ',width=' + w + ',scrollbars=yes,status=no');
    }
</script>